APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 67: pv_return_code := jai_constants.successful ;

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

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

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

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

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

Line 177: jai_constants.yes,

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