APPS.JAI_FA_MA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 66: ( jai_constants.tax_type_cvd, /*--'CVD', 'CUSTOMS', Ramananda for removal of SQL LITERALs */

62: and nvl(tax_amount, 0) <> 0
63: and
64: (
65: (upper(tax_type) in
66: ( jai_constants.tax_type_cvd, /*--'CVD', 'CUSTOMS', Ramananda for removal of SQL LITERALs */
67: jai_constants.tax_type_customs,
68: jai_constants.tax_type_customs_edu_cess,
69: jai_constants.tax_type_cvd_Edu_cess))
70: /* BOE Tax */

Line 67: jai_constants.tax_type_customs,

63: and
64: (
65: (upper(tax_type) in
66: ( jai_constants.tax_type_cvd, /*--'CVD', 'CUSTOMS', Ramananda for removal of SQL LITERALs */
67: jai_constants.tax_type_customs,
68: jai_constants.tax_type_customs_edu_cess,
69: jai_constants.tax_type_cvd_Edu_cess))
70: /* BOE Tax */
71: or

Line 68: jai_constants.tax_type_customs_edu_cess,

64: (
65: (upper(tax_type) in
66: ( jai_constants.tax_type_cvd, /*--'CVD', 'CUSTOMS', Ramananda for removal of SQL LITERALs */
67: jai_constants.tax_type_customs,
68: jai_constants.tax_type_customs_edu_cess,
69: jai_constants.tax_type_cvd_Edu_cess))
70: /* BOE Tax */
71: or
72: (upper(tax_type) not in --('TDS', 'MODVAT RECOVERY') /* Third party tax */

Line 69: jai_constants.tax_type_cvd_Edu_cess))

65: (upper(tax_type) in
66: ( jai_constants.tax_type_cvd, /*--'CVD', 'CUSTOMS', Ramananda for removal of SQL LITERALs */
67: jai_constants.tax_type_customs,
68: jai_constants.tax_type_customs_edu_cess,
69: jai_constants.tax_type_cvd_Edu_cess))
70: /* BOE Tax */
71: or
72: (upper(tax_type) not in --('TDS', 'MODVAT RECOVERY') /* Third party tax */
73: (

Line 74: jai_constants.tax_type_tds,

70: /* BOE Tax */
71: or
72: (upper(tax_type) not in --('TDS', 'MODVAT RECOVERY') /* Third party tax */
73: (
74: jai_constants.tax_type_tds,
75: jai_constants.tax_type_modvat_recovery
76: )
77: and vendor_id > 0
78: and vendor_id <> p_po_vendor_id

Line 75: jai_constants.tax_type_modvat_recovery

71: or
72: (upper(tax_type) not in --('TDS', 'MODVAT RECOVERY') /* Third party tax */
73: (
74: jai_constants.tax_type_tds,
75: jai_constants.tax_type_modvat_recovery
76: )
77: and vendor_id > 0
78: and vendor_id <> p_po_vendor_id
79: )

Line 100: pv_return_code := jai_constants.successful ;

96: ln_first_record number := 0;
97:
98:
99: BEGIN
100: pv_return_code := jai_constants.successful ;
101: /*------------------------------------------------------------------------------
102: Filename: ja_in_fa_mass_additions_boe3p_trg.sql
103:
104: CHANGE HISTORY:

Line 289: Pv_return_code := jai_constants.unexpected_error;

285: );
286: /* Added an exception block by Ramananda for bug#4570303 */
287: EXCEPTION
288: WHEN OTHERS THEN
289: Pv_return_code := jai_constants.unexpected_error;
290: Pv_return_message := 'Encountered an error in JAI_FA_MA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
291: END ARI_T1 ;
292:
293: /*

Line 418: pv_return_code := jai_constants.successful ;

414: --
415:
416:
417: BEGIN
418: pv_return_code := jai_constants.successful ;
419: /*------------------------------------------------------------------------------------------
420: FILENAME: ja_in_fa_mass_add_trg1.sql
421:
422: CHANGE HISTORY:

Line 565: Pv_return_code := jai_constants.unexpected_error;

561: END IF;
562: /* Added an exception block by Ramananda for bug#4570303 */
563: EXCEPTION
564: WHEN OTHERS THEN
565: Pv_return_code := jai_constants.unexpected_error;
566: Pv_return_message := 'Encountered an error in JAI_FA_MA_TRIGGER_PKG.BRI_T1 ' || substr(sqlerrm,1,1900);
567: END BRI_T1 ;
568:
569: END JAI_FA_MA_TRIGGER_PKG ;