APPS.JAI_JMCR_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 80: jai_constants.tax_type_tds ,

76: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
77: WHERE a.tax_id = b.tax_id
78: AND a.link_to_cust_trx_line_id = v_ref_line
79: AND b.tax_type NOT IN (
80: jai_constants.tax_type_tds ,
81: jai_constants.tax_type_modvat_recovery);
82: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
83: BEGIN
84: pv_return_code := jai_constants.successful ;

Line 81: jai_constants.tax_type_modvat_recovery);

77: WHERE a.tax_id = b.tax_id
78: AND a.link_to_cust_trx_line_id = v_ref_line
79: AND b.tax_type NOT IN (
80: jai_constants.tax_type_tds ,
81: jai_constants.tax_type_modvat_recovery);
82: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
83: BEGIN
84: pv_return_code := jai_constants.successful ;
85: /*-------------------------------------------------------------------------------------------

Line 84: pv_return_code := jai_constants.successful ;

80: jai_constants.tax_type_tds ,
81: jai_constants.tax_type_modvat_recovery);
82: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
83: BEGIN
84: pv_return_code := jai_constants.successful ;
85: /*-------------------------------------------------------------------------------------------
86: Change History for FileName: ja_in_receipts_match_ar_trg.sql
87: S.No. dd/mm/yyyy Author and Details
88: ---------------------------------------------------------------------------------------------

Line 164: Pv_return_code := jai_constants.unexpected_error;

160:
161: /* Added an exception block by Ramananda for bug#4570303 */
162: EXCEPTION
163: WHEN OTHERS THEN
164: Pv_return_code := jai_constants.unexpected_error;
165: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
166:
167: END ARIU_T1 ;
168:

Line 239: pv_return_code := jai_constants.successful ;

235: where delivery_detail_id =pr_new.ref_line_id );
236:
237:
238: BEGIN
239: pv_return_code := jai_constants.successful ;
240:
241: /*-------------------------------------------------------------------------------------------
242: Change History for FileName: ja_in_receipts_match_trigger.sql
243: S.No. dd/mm/yyyy Author and Details

Line 306: Pv_return_code := jai_constants.unexpected_error;

302: -- end if;
303: /* Added an exception block by Ramananda for bug#4570303 */
304: EXCEPTION
305: WHEN OTHERS THEN
306: Pv_return_code := jai_constants.unexpected_error;
307: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
308:
309: END ARIU_T2 ;
310: