APPS.JAI_JMCR_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 86: jai_constants.tax_type_tds ,

82: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
83: WHERE a.tax_id = b.tax_id
84: AND a.link_to_cust_trx_line_id = v_ref_line
85: AND b.tax_type NOT IN (
86: jai_constants.tax_type_tds ,
87: jai_constants.tax_type_modvat_recovery);
88: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
89: BEGIN
90: pv_return_code := jai_constants.successful ;

Line 87: jai_constants.tax_type_modvat_recovery);

83: WHERE a.tax_id = b.tax_id
84: AND a.link_to_cust_trx_line_id = v_ref_line
85: AND b.tax_type NOT IN (
86: jai_constants.tax_type_tds ,
87: jai_constants.tax_type_modvat_recovery);
88: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
89: BEGIN
90: pv_return_code := jai_constants.successful ;
91: /*-------------------------------------------------------------------------------------------

Line 90: pv_return_code := jai_constants.successful ;

86: jai_constants.tax_type_tds ,
87: jai_constants.tax_type_modvat_recovery);
88: --AND b.tax_type NOT IN ('TDS','Modvat Recovery');
89: BEGIN
90: pv_return_code := jai_constants.successful ;
91: /*-------------------------------------------------------------------------------------------
92: Change History for FileName: ja_in_receipts_match_ar_trg.sql
93: S.No. dd/mm/yyyy Author and Details
94: ---------------------------------------------------------------------------------------------

Line 172: Pv_return_code := jai_constants.unexpected_error;

168:
169: /* Added an exception block by Ramananda for bug#4570303 */
170: EXCEPTION
171: WHEN OTHERS THEN
172: Pv_return_code := jai_constants.unexpected_error;
173: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
174:
175: END ARIU_T1 ;
176:

Line 253: pv_return_code := jai_constants.successful ;

249: AND organization_id = p_warehouse_id;
250:
251:
252: BEGIN
253: pv_return_code := jai_constants.successful ;
254:
255: /*-------------------------------------------------------------------------------------------
256: Change History for FileName: ja_in_receipts_match_trigger.sql
257: S.No. dd/mm/yyyy Author and Details

Line 330: Pv_return_code := jai_constants.unexpected_error;

326: -- end if;
327: /* Added an exception block by Ramananda for bug#4570303 */
328: EXCEPTION
329: WHEN OTHERS THEN
330: Pv_return_code := jai_constants.unexpected_error;
331: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
332:
333: END ARIU_T2 ;
334: