DBA Data[Home] [Help]

APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 68: pv_return_code := jai_constants.successful ;

64: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;
65: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;
66:
67: BEGIN
68: pv_return_code := jai_constants.successful ;
69: /*--------------------------------------------------------------------------------------------
70: Change History
71: --------------------------------------------------------------------------------------------
72: 1. Ssumaith - Bug # 2695779 - File Version 712.1

Line 108: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Cannot Certify the Batch Without Releasing it' ; return ;

104: --------------------------------------------------------------------------------------------*/
105:
106: IF pr_new.BATCH_STATUS = 3 AND pr_old.BATCH_STATUS=1 THEN
107: /* Raise_application_error(-20010,'Cannot Certify the Batch Without Releasing it');
108: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Cannot Certify the Batch Without Releasing it' ; return ;
109: end if ;
110: IF pr_old.batch_status <> pr_new.batch_status THEN
111:
112: OPEN c_reg_sel;

Line 137: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Purchase Order Not Associated' ; return ;

133: CLOSE C_Vend_Id;
134:
135: If l_vend_id is null then
136: /* RAISE_APPLICATION_ERROR('-20009','Purchase Order Not Associated');
137: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Purchase Order Not Associated' ; return ;
138: end if ;
139: lv_tran_name := 'OSP_ISSUE' ;
140: INSERT INTO JAI_OPM_TXN_EXTN_HDRS
141: ( TRANSACTION_NAME,

Line 178: jai_constants.yes,

174: sysdate,
175: l_reg_sel,
176: --Fle.Sql.35 Cbabu
177: 0,
178: jai_constants.yes,
179: pr_new.organization_id
180: );
181:
182: FOR rec IN C_Osp_Rcpt_Dtl LOOP