Subversion Repositories DevTools

Rev

Rev 13 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                                BOM_AcceptReject                               |
'|                                                   |
'=====================================================
%>
<%
Option explicit
Response.Expires = 0
%>
<!--#include file="common/globals.asp"-->
<!--#include file="common/config.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/_form_window_common.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_general.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
Dim parIs_rejected
Dim parBom_id_list
'------------ CONSTANTS DECLARATION -----------
'------------ VARIABLE INIT -------------------
parIs_rejected = Request("is_rejected")
parBom_id_list = Request("bom_id_list")
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'--------------------------------------------------------------------------------------------------------------------------
Sub AcceptRejectBOM ()
        On Error Resume Next
        
        OraDatabase.Parameters.Add "BOM_ID",            Request("bom_id_list"),                 ORAPARM_INPUT, ORATYPE_NUMBER
        OraDatabase.Parameters.Add "IS_REJECTED",       Request("is_rejected"),                 ORAPARM_INPUT, ORATYPE_CHAR
        OraDatabase.Parameters.Add "USER_ID",           objAccessControl.UserId,                ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "STATE_ID",          Request("state_id"),                    ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "COMMENTS",          Request("reject_note"),                 ORAPARM_INPUT, ORATYPE_VARCHAR2
        
        
        objEH.TryORA ( OraSession )
        
        OraDatabase.ExecuteSQL _
        "BEGIN   pk_Bom.Accept_Reject ( :BOM_ID, :IS_REJECTED, :COMMENTS, :STATE_ID, :USER_ID );   END;"
        
        objEH.CatchORA ( OraSession )
        
        
        OraDatabase.Parameters.Remove "BOM_ID"
        OraDatabase.Parameters.Remove "USER_ID"
        OraDatabase.Parameters.Remove "STATE_ID"
        OraDatabase.Parameters.Remove "COMMENTS"
        OraDatabase.Parameters.Remove "IS_REJECTED"
        
End Sub
'--------------------------------------------------------------------------------------------------------------------------
%>
<%
'------------ RUN BEFORE PAGE RENDER ----------
' --- Get Form details from DB ---

' --- Load Validation Rules ---
Call objForm.LoadValidationRules ( Array("reject_note"), OraDatabase )          ' Load Validation Rules

' --- Enter Form Validation Rule Changes here... ----
'----------------------------------------------------

' --- RUN onPostBack ---
If Request("action") <> "" Then
        If objForm.IsValidOnPostBack Then
                ' --- Form is Valid ---
                Call AcceptRejectBOM()
                
                If objEH.Finally Then
                        Call OpenInWindow ( Request("rfile") &"?DONE=OK"& objPMod.ComposeURLWithout("rfile") )
                End If
                
        End If
End If

'----------------------------------------------
%>
<html>
<head>
<title>Deployment Manager</title>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="scripts/common.js"></script>

</head>
<body background="images/bg_lite_blue.gif" leftmargin="0" topmargin="0" onLoad="FormName.reject_note.focus();">
<!-- HEADER ++++++++++++++++ -->
<!--#include file="_header.asp"-->
<!-- +++++++++++++++++++++++ -->
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
<form name="FormName" method="post" action="<%=SCRIPT_NAME%>" onSubmit="ShowProgress();">
  <tr>
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bgcolor="#FFFFFF">
        <!-- LOGIN FROM ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
    <table width="570" border="0" cellspacing="0" cellpadding="1">
        <tr>
          <td background="images/bg_bage_2.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="10">
                <tr>
                  <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1">
                                  <%If parIs_rejected = enumDB_NO Then%>
                                  <img src="icons/mi_accept.gif" width="13" height="13" align="absmiddle" border="0">&nbsp;Accept BOM
                                  <%Else%>
                                  <img src="icons/mi_reject.gif" width="13" height="13" align="absmiddle" border="0">&nbsp;Reject BOM
                                  <%End If%></span> <br>
                        Enter optional comments and click Submit.</td>
                </tr>
                <tr>
                  <td background="images/bg_bage_0.gif"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
                      <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                      <%If NOT objEH.Finally Then%>
                      <tr>
                        <td class="form_iname">&nbsp;</td>
                        <td>
                          <%objEH.DisplayMessage()%>
                        </td>
                        <td class="val_err"></td>
                      </tr>
                      <%End If%>
                      <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                      <tr>
                        <td valign="top" nowrap class="form_iname">Comments</td>
                        <td valign="top"><textarea name="reject_note" cols="60" rows="14" class="form_ivalue"><%=Request("reject_note")%></textarea></td>
                        <td valign="top"><%=objForm.Validate ("reject_note")%> </td>
                      </tr>
                      <tr>
                        <td width="10%" class="form_iname">&nbsp;</td>
                        <td width="1%">&nbsp;</td>
                        <td width="90%" class="val_err"></td>
                      </tr>
                  </table></td>
                </tr>
                                <tr>
                  <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td></td>
                        <td align="right"><input name="btn" type="submit" class="form_btn" value="Submit">
                            <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="window.location='<%=Request("rfile") &"?CANCEL=OK"& objPMod.ComposeURLWithout("rfile")%>';"></td>
                      </tr>
                  </table></td>
                </tr>
                <%=objPMod.ComposeHiddenTags()%>
                                <input type="hidden" name="is_rejected" value="<%=parIs_rejected%>">
                <input type="hidden" name="bom_id_list" value="<%=parBom_id_list%>">
                <input type="hidden" name="action" value="true">
              </table>                </td>
            </tr>
          </table></td>
        </tr>
      </table>
          <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->   </td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
  </tr>
</form>  
</table>
<!-- FOOTER ++++++++++++++++++++++ -->
<!--#include file="_footer.asp"-->
<!-- +++++++++++++++++++++++++++++ -->
</body>
</html>
<%
'------------ RUN AFTER PAGE RENDER -----------
Set objPMod = Nothing
'----------------------------------------------
%>
<!--#include file="common/globals_destructor.asp"-->