eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CONSTANTS

Line 787: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then

783: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO :'
784: ||' Register code ='|| v_register_code
785: );
786: end if;
787: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then
788:
789: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
790: /*
791: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here

Line 789: /jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740/

785: );
786: end if;
787: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then
788:
789: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
790: /*
791: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
792: because of the return statement above.
793: */

Line 921: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime

917: close JA_SO_LINES_INFO;
918:
919:
920: ln_tcs_exists := null;
921: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
922: , cp_cust_trx_line_id => v_customer_trx_line_id
923: );
924: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
925: close c_chk_rgm_tax_exists ;

Line 929: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);

925: close c_chk_rgm_tax_exists ;
926:
927: if ln_tcs_exists > 0 then
928: /* TCS type of tax is present */
929: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
930: fetch c_get_regime_id into ln_tcs_regime_id;
931: close c_get_regime_id;
932: /* Find out what is the current slab */
933: jai_rgm_thhold_proc_pkg.get_threshold_slab_id

Line 937: , p_party_type => jai_constants.party_type_customer

933: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
934: (
935: p_regime_id => ln_tcs_regime_id
936: , p_organization_id => ln_inv_orgn_id
937: , p_party_type => jai_constants.party_type_customer
938: , p_party_id => lr_trx_rec.customer_id
939: , p_org_id => v_org_id
940: , p_source_trx_date => lr_trx_rec.trx_date
941: , p_threshold_slab_id => ln_threshold_slab_id

Line 946: if lv_process_flag <> jai_constants.successful then

942: , p_process_flag => lv_process_flag
943: , p_process_message => lv_process_message
944: );
945:
946: if lv_process_flag <> jai_constants.successful then
947: app_exception.raise_exception
948: (exception_type => 'APP'
949: ,exception_code => -20275
950: ,exception_text => lv_process_message

Line 963: if lv_process_flag <> jai_constants.successful then

959: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
960: , p_process_flag => lv_process_flag
961: , p_process_message => lv_process_message
962: );
963: if lv_process_flag <> jai_constants.successful then
964: app_exception.raise_exception
965: (exception_type => 'APP'
966: ,exception_code => -20275
967: ,exception_text => lv_process_message

Line 982: and jtc.tax_type = jai_constants.tax_type_tcs;

978: from JAI_AR_TRX_TAX_LINES jrctt
979: , JAI_CMN_TAXES_ALL jtc
980: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
981: and jrctt.tax_id = jtc.tax_id
982: and jtc.tax_type = jai_constants.tax_type_tcs;
983: /*
984: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
985: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
986: || into the ja_in_so_picking_tax_lines table

Line 992: , p_source_event => jai_constants.bill_only_invoice

988: jai_rgm_thhold_proc_pkg.default_thhold_taxes
989: (
990: p_source_trx_id => ''
991: , p_source_trx_line_id => v_customer_trx_line_id
992: , p_source_event => jai_constants.bill_only_invoice
993: , p_action => jai_constants.default_taxes
994: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
995: , p_tax_base_line_number => ln_base_line_no
996: , p_last_line_number => ln_last_line_no

Line 993: , p_action => jai_constants.default_taxes

989: (
990: p_source_trx_id => ''
991: , p_source_trx_line_id => v_customer_trx_line_id
992: , p_source_event => jai_constants.bill_only_invoice
993: , p_action => jai_constants.default_taxes
994: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
995: , p_tax_base_line_number => ln_base_line_no
996: , p_last_line_number => ln_last_line_no
997: , p_currency_code => lr_trx_rec.invoice_currency_code

Line 1009: if lv_process_flag <> jai_constants.successful then

1005: , p_process_flag => lv_process_flag
1006: , p_process_message => lv_process_message
1007: );
1008:
1009: if lv_process_flag <> jai_constants.successful then
1010: app_exception.raise_exception
1011: (exception_type => 'APP'
1012: ,exception_code => -20275
1013: ,exception_text => lv_process_message

Line 1106: lv_action := jai_constants.INSERTING;

1102: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
1103: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1104: CLOSE c_jai_ar_trx_lines;
1105:
1106: lv_action := jai_constants.INSERTING;
1107:
1108: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
1109: pr_old => NULL ,
1110: pr_new => t_jai_line_rec_new ,

Line 1115: IF lv_return_code <> jai_constants.successful then

1111: pv_action => lv_action ,
1112: pv_return_code => lv_return_code ,
1113: pv_return_message => lv_return_message
1114: );
1115: IF lv_return_code <> jai_constants.successful then
1116: RAISE le_error;
1117: END IF;
1118: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1119: open c_get_amounts;

Line 1169: lv_action := jai_constants.updating ;

1165: close c_get_rec;
1166:
1167: if(t_rec_new.once_completed_flag = 'Y')then
1168:
1169: lv_action := jai_constants.updating ;
1170:
1171: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
1172: pr_old => t_rec_old ,
1173: pr_new => t_rec_new ,

Line 1179: IF lv_return_code <> jai_constants.successful then

1175: pv_return_code => lv_return_code ,
1176: pv_return_message => lv_return_message
1177: );
1178:
1179: IF lv_return_code <> jai_constants.successful then
1180: RAISE le_error;
1181: END IF;
1182:
1183: end if;

Line 1194: if lv_process_flag <> jai_constants.successful then

1190: ( p_ractl => pr_new
1191: , p_process_flag => lv_process_flag
1192: , p_process_message => lv_process_message
1193: );
1194: if lv_process_flag <> jai_constants.successful then
1195: app_exception.raise_exception
1196: (exception_type => 'APP'
1197: ,exception_code => -20275
1198: ,exception_text => lv_process_message

Line 1262: pv_return_code := jai_constants.successful ;

1258: v_item_type oe_order_lines_all.item_type_code%type;
1259: l_api_name CONSTANT VARCHAR2(30) := 'Process_Taxes_for_ATO_Order()';
1260: BEGIN
1261:
1262: pv_return_code := jai_constants.successful ;
1263:
1264: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1265: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1266: G_MODULE_NAME || l_api_name || '.BEGIN',

Line 1342: IF v_tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN

1338: G_MODULE_NAME || l_api_name || '.IN',
1339: G_PKG_NAME || ': ' || l_api_name || '().'||' Inside BOND Register '
1340: );
1341: end if;
1342: IF v_tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
1343:
1344: INSERT INTO JAI_AR_TRX_TAX_LINES
1345: (
1346: tax_line_no ,

Line 1583: lv_action := jai_constants.updating ;

1579: close c_get_rec;
1580:
1581: if(t_rec_new.once_completed_flag = 'Y')then
1582:
1583: lv_action := jai_constants.updating ;
1584:
1585: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
1586: pr_old => t_rec_old ,
1587: pr_new => t_rec_new ,

Line 1593: IF lv_return_code <> jai_constants.successful then

1589: pv_return_code => lv_return_code ,
1590: pv_return_message => lv_return_message
1591: );
1592:
1593: IF lv_return_code <> jai_constants.successful then
1594: RAISE le_error;
1595: END IF;
1596:
1597: end if;

Line 1824: lv_action := jai_constants.INSERTING;

1820: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
1821: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1822: CLOSE c_jai_ar_trx_lines;
1823:
1824: lv_action := jai_constants.INSERTING;
1825:
1826: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
1827: pr_old => NULL ,
1828: pr_new => t_jai_line_rec_new ,

Line 1833: IF lv_return_code <> jai_constants.successful then

1829: pv_action => lv_action ,
1830: pv_return_code => lv_return_code ,
1831: pv_return_message => lv_return_message
1832: );
1833: IF lv_return_code <> jai_constants.successful then
1834: RAISE le_error;
1835: END IF;
1836: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1837:

Line 2110: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN

2106: CLOSE duplicate_tax_lines_cur;
2107:
2108: IF NVL(v_tax_line_count,0) <> 1 THEN
2109: IF v_register_code ='BOND_REG' THEN
2110: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
2111: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
2112: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
2113: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
2114: )

Line 2111: /jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740/

2107:
2108: IF NVL(v_tax_line_count,0) <> 1 THEN
2109: IF v_register_code ='BOND_REG' THEN
2110: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
2111: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
2112: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
2113: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
2114: )
2115: or

Line 2329: jai_constants.tax_type_sh_cvd_edu_cess,

2325: IF NVL(v_tax_line_count,0) <> 1 THEN
2326: IF v_register_code ='BOND_REG' THEN
2327: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS',
2328: 'EXCISE_EDUCATION_CESS',
2329: jai_constants.tax_type_sh_cvd_edu_cess,
2330: jai_constants.tax_type_sh_exc_edu_cess)
2331: THEN
2332: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
2333: AND nvl(v_ont_source_code,'ORDER ENTRY') =

Line 2330: jai_constants.tax_type_sh_exc_edu_cess)

2326: IF v_register_code ='BOND_REG' THEN
2327: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS',
2328: 'EXCISE_EDUCATION_CESS',
2329: jai_constants.tax_type_sh_cvd_edu_cess,
2330: jai_constants.tax_type_sh_exc_edu_cess)
2331: THEN
2332: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
2333: AND nvl(v_ont_source_code,'ORDER ENTRY') =
2334: ltrim(rtrim(pr_new.interface_line_context))

Line 2623: pv_return_code := jai_constants.successful ;

2619: FROM JAI_OM_OE_SO_LINES
2620: WHERE line_id = pr_new.interface_line_attribute6;
2621: lv_exists VARCHAR2(1);
2622: BEGIN
2623: pv_return_code := jai_constants.successful ;
2624: OPEN c_so_lines_exists ;
2625: FETCH c_so_lines_exists INTO lv_exists;
2626: IF c_so_lines_exists%NOTFOUND THEN
2627: CLOSE c_so_lines_exists;

Line 2773: lv_action := jai_constants.INSERTING;

2769: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2770: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
2771: CLOSE c_jai_ar_trx_lines;
2772:
2773: lv_action := jai_constants.INSERTING;
2774:
2775: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
2776: pr_old => NULL ,
2777: pr_new => t_jai_line_rec_new ,

Line 2782: IF lv_return_code <> jai_constants.successful then

2778: pv_action => lv_action ,
2779: pv_return_code => lv_return_code ,
2780: pv_return_message => lv_return_message
2781: );
2782: IF lv_return_code <> jai_constants.successful then
2783: RAISE le_error;
2784: END IF;
2785: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
2786: ELSE /* ELSE OF IF NVL(v_line_count,0) <> 1*/

Line 2811: lv_action := jai_constants.UPDATING;

2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2808: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
2809: CLOSE c_jai_ar_trx_lines;
2810:
2811: lv_action := jai_constants.UPDATING;
2812:
2813: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
2814: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'
2815: ) AND

Line 2830: IF lv_return_code <> jai_constants.successful then

2826: pv_action => lv_action,
2827: pv_return_code => lv_return_code,
2828: pv_return_message => lv_return_message
2829: );
2830: IF lv_return_code <> jai_constants.successful then
2831: RAISE le_error;
2832: END IF;
2833: END IF;
2834: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end

Line 2935: lv_action := jai_constants.updating ;

2931: close c_get_rec;
2932:
2933: if(t_rec_new.once_completed_flag = 'Y')then
2934:
2935: lv_action := jai_constants.updating ;
2936:
2937: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
2938: pr_old => t_rec_old ,
2939: pr_new => t_rec_new ,

Line 2945: IF lv_return_code <> jai_constants.successful then

2941: pv_return_code => lv_return_code ,
2942: pv_return_message => lv_return_message
2943: );
2944:
2945: IF lv_return_code <> jai_constants.successful then
2946: RAISE le_error;
2947: END IF;
2948:
2949: end if;

Line 2960: pv_return_code := jai_constants.unexpected_error;

2956: G_PKG_NAME || ': ' || l_api_name || '()-');
2957: end if;
2958: EXCEPTION
2959: when le_error then
2960: pv_return_code := jai_constants.unexpected_error;
2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;

Line 2964: pv_return_code := jai_constants.unexpected_error;

2960: pv_return_code := jai_constants.unexpected_error;
2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));
2967:
2968: end process_order;

Line 3343: v_category_name := jai_constants.je_category_rg_entry ;

3339: v_assessable_value := 0;
3340: v_line_amount := nvl(pr_new.quantity_invoiced * pr_new.unit_selling_price, nvl(pr_new.extended_amount,0));
3341: v_once_completed_flag := pv_once_complete_flag;
3342: v_source_name := 'Receivables India';
3343: v_category_name := jai_constants.je_category_rg_entry ;
3344:
3345:
3346:
3347: OPEN get_exchange_rate;

Line 3805: lv_action := jai_constants.INSERTING;

3801: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
3802: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
3803: CLOSE c_jai_ar_trx_lines;
3804:
3805: lv_action := jai_constants.INSERTING;
3806:
3807: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
3808: pr_old => NULL ,
3809: pr_new => t_jai_line_rec_new ,

Line 3814: IF lv_return_code <> jai_constants.successful then

3810: pv_action => lv_action ,
3811: pv_return_code => lv_return_code ,
3812: pv_return_message => lv_return_message
3813: );
3814: IF lv_return_code <> jai_constants.successful then
3815: RAISE le_error;
3816: END IF;
3817: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
3818:

Line 3843: lv_action := jai_constants.updating ;

3839: close c_get_rec;
3840:
3841: if(t_rec_new.once_completed_flag = 'Y')then
3842:
3843: lv_action := jai_constants.updating ;
3844:
3845: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
3846: pr_old => t_rec_old ,
3847: pr_new => t_rec_new ,

Line 3853: IF lv_return_code <> jai_constants.successful then

3849: pv_return_code => lv_return_code ,
3850: pv_return_message => lv_return_message
3851: );
3852:
3853: IF lv_return_code <> jai_constants.successful then
3854: RAISE le_error;
3855: END IF;
3856:
3857: end if;

Line 4003: pv_return_code := jai_constants.expected_error ;

3999:
4000: IF NVL(v_raise_error_flag,'N') = 'Y' THEN
4001: /* RAISE_APPLICATION_ERROR(-20120, 'NONE OF the Register Have Balances Greater OR Equal TO the Excisable Amount ->' || TO_CHAR(v_excise_diff));
4002: */
4003: pv_return_code := jai_constants.expected_error ;
4004: pv_return_message := 'NONE OF the Register Have Balances Greater OR Equal TO the Excisable Amount ->' || TO_CHAR(v_excise_diff) ; return ;
4005: END IF;
4006:
4007: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE');

Line 4071: pv_return_code := jai_constants.expected_error ;

4067: IF v_start_number IS NOT NULL THEN --2
4068: IF NVL(v_start_number,0) >= NVL(v_end_number,0) AND v_end_number IS NOT NULL THEN
4069: /* RAISE_APPLICATION_ERROR(-20120, 'Excise Invoice NUMBER has been exhausted. ' ||
4070: ' Increase END NUMBER OR enter fresh START NUMBER AND END NUMBER.'); */
4071: pv_return_code := jai_constants.expected_error ;
4072: pv_return_message := 'Excise Invoice NUMBER has been exhausted. ' ||' Increase END NUMBER OR enter fresh START NUMBER AND END NUMBER.' ;
4073: return ;
4074: END IF;
4075: v_exc_invoice_no := NVL(v_start_number,0);

Line 4121: lv_action := jai_constants.UPDATING;

4117: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4118: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
4119: CLOSE c_jai_ar_trx_lines;
4120:
4121: lv_action := jai_constants.UPDATING;
4122:
4123: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
4124: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'
4125: ) AND

Line 4140: IF lv_return_code <> jai_constants.successful then

4136: pv_action => lv_action,
4137: pv_return_code => lv_return_code,
4138: pv_return_message => lv_return_message
4139: );
4140: IF lv_return_code <> jai_constants.successful then
4141: RAISE le_error;
4142: END IF;
4143: END IF;
4144: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end

Line 4264: pv_return_code := jai_constants.unexpected_error;

4260: END IF;
4261: END IF;
4262: EXCEPTION
4263: when le_error then
4264: pv_return_code := jai_constants.unexpected_error;
4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;

Line 4268: pv_return_code := jai_constants.unexpected_error;

4264: pv_return_code := jai_constants.unexpected_error;
4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));
4271:
4272: end process_supplement;

Line 4504: pv_return_code := jai_constants.successful ;

4500: l_api_name CONSTANT VARCHAR2(30) := 'POP_JAI_INV_AND_SUPPL()';
4501:
4502: BEGIN
4503:
4504: pv_return_code := jai_constants.successful ;
4505:
4506: v_org_id := pr_new.org_id;
4507: v_last_update_date := pr_new.last_update_date;
4508: v_last_updated_by := pr_new.last_updated_by;

Line 4526: v_category_name := jai_constants.je_category_rg_entry ; -- 'RG Register Data Entry' modified by csahoo for bug#6155839

4522: v_add_excise_duty_amount := 0;
4523: v_oth_excise_duty_amount := 0;
4524: v_exist_flag := 0;
4525: v_source_name := 'Receivables India';
4526: v_category_name := jai_constants.je_category_rg_entry ; -- 'RG Register Data Entry' modified by csahoo for bug#6155839
4527:
4528:
4529: ln_bill_only := 0;
4530: ln_bill_return := 0;

Line 4705: IF lv_return_code <> jai_constants.successful then

4701: pv_once_complete_flag => v_once_completed_flag,
4702: pv_return_code => lv_return_code,
4703: pv_return_message =>lv_return_message
4704: );
4705: IF lv_return_code <> jai_constants.successful then
4706: RAISE le_error;
4707: END IF;
4708:
4709: ELSE /* ELSIF OF pr_new.interface_line_context IN ('SUPPLEMENT CM','SUPPLEMENT DM','SUPPLEMENT INVOICE') */

Line 4722: IF lv_return_code <> jai_constants.successful then

4718: pv_once_complete_flag => v_once_completed_flag,
4719: pv_return_code => lv_return_code,
4720: pv_return_message =>lv_return_message
4721: );
4722: IF lv_return_code <> jai_constants.successful then
4723: RAISE le_error;
4724: END IF;
4725:
4726: END IF;

Line 4734: Pv_return_code := jai_constants.unexpected_error;

4730: G_PKG_NAME || ': ' || l_api_name || '()-');
4731: end if;
4732: EXCEPTION
4733: WHEN le_error then
4734: Pv_return_code := jai_constants.unexpected_error;
4735: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message;
4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);
4737: WHEN OTHERS THEN
4738: vsqlerrm := SQLERRM;

Line 4741: Pv_return_code := jai_constants.unexpected_error;

4737: WHEN OTHERS THEN
4738: vsqlerrm := SQLERRM;
4739:
4740:
4741: Pv_return_code := jai_constants.unexpected_error;
4742: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900);
4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));
4744:
4745: /*lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;

Line 5360: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then

5356: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
5357: ||' Register code ='||lv_register_code
5358: );
5359: end if;
5360: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then
5361:
5362: INSERT INTO JAI_AR_TRX_TAX_LINES
5363: (
5364: tax_line_no ,

Line 5492: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime

5488: close SO_RMA_TAX_LINES_INFO;
5489:
5490:
5491: ln_tcs_exists := null;
5492: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
5493: , cp_cust_trx_line_id => v_customer_trx_line_id
5494: );
5495: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
5496: close c_chk_rgm_tax_exists ;

Line 5500: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);

5496: close c_chk_rgm_tax_exists ;
5497:
5498: if ln_tcs_exists > 0 then
5499: /* TCS type of tax is present */
5500: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
5501: fetch c_get_regime_id into ln_tcs_regime_id;
5502: close c_get_regime_id;
5503: /* Find out what is the current slab */
5504: jai_rgm_thhold_proc_pkg.get_threshold_slab_id

Line 5508: , p_party_type => jai_constants.party_type_customer

5504: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5505: (
5506: p_regime_id => ln_tcs_regime_id
5507: , p_organization_id => ln_inv_orgn_id
5508: , p_party_type => jai_constants.party_type_customer
5509: , p_party_id => lr_trx_rec.customer_id
5510: , p_org_id => pr_new.org_id
5511: , p_source_trx_date => lr_trx_rec.trx_date
5512: , p_threshold_slab_id => ln_threshold_slab_id

Line 5517: if lv_process_flag <> jai_constants.successful then

5513: , p_process_flag => lv_process_flag
5514: , p_process_message => lv_process_message
5515: );
5516:
5517: if lv_process_flag <> jai_constants.successful then
5518: app_exception.raise_exception
5519: (exception_type => 'APP'
5520: ,exception_code => -20275
5521: ,exception_text => lv_process_message

Line 5534: if lv_process_flag <> jai_constants.successful then

5530: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5531: , p_process_flag => lv_process_flag
5532: , p_process_message => lv_process_message
5533: );
5534: if lv_process_flag <> jai_constants.successful then
5535: app_exception.raise_exception
5536: (exception_type => 'APP'
5537: ,exception_code => -20275
5538: ,exception_text => lv_process_message

Line 5553: and jtc.tax_type = jai_constants.tax_type_tcs;

5549: from JAI_AR_TRX_TAX_LINES jrctt
5550: , JAI_CMN_TAXES_ALL jtc
5551: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
5552: and jrctt.tax_id = jtc.tax_id
5553: and jtc.tax_type = jai_constants.tax_type_tcs;
5554: /*
5555: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
5556: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
5557: || into the ja_in_so_picking_tax_lines table

Line 5563: , p_source_event => jai_constants.bill_only_invoice

5559: jai_rgm_thhold_proc_pkg.default_thhold_taxes
5560: (
5561: p_source_trx_id => ''
5562: , p_source_trx_line_id => v_customer_trx_line_id
5563: , p_source_event => jai_constants.bill_only_invoice
5564: , p_action => jai_constants.default_taxes
5565: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5566: , p_tax_base_line_number => ln_base_line_no
5567: , p_last_line_number => ln_last_line_no

Line 5564: , p_action => jai_constants.default_taxes

5560: (
5561: p_source_trx_id => ''
5562: , p_source_trx_line_id => v_customer_trx_line_id
5563: , p_source_event => jai_constants.bill_only_invoice
5564: , p_action => jai_constants.default_taxes
5565: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5566: , p_tax_base_line_number => ln_base_line_no
5567: , p_last_line_number => ln_last_line_no
5568: , p_currency_code => lr_trx_rec.invoice_currency_code

Line 5580: if lv_process_flag <> jai_constants.successful then

5576: , p_process_flag => lv_process_flag
5577: , p_process_message => lv_process_message
5578: );
5579:
5580: if lv_process_flag <> jai_constants.successful then
5581: app_exception.raise_exception
5582: (exception_type => 'APP'
5583: ,exception_code => -20275
5584: ,exception_text => lv_process_message

Line 5648: lv_action := jai_constants.INSERTING;

5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
5645: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
5646: CLOSE c_jai_ar_trx_lines;
5647:
5648: lv_action := jai_constants.INSERTING;
5649:
5650: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
5651: pr_old => NULL ,
5652: pr_new => t_jai_line_rec_new ,

Line 5657: IF lv_return_code <> jai_constants.successful then

5653: pv_action => lv_action ,
5654: pv_return_code => lv_return_code ,
5655: pv_return_message => lv_return_message
5656: );
5657: IF lv_return_code <> jai_constants.successful then
5658: RAISE le_error;
5659: END IF;
5660: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
5661:

Line 5700: lv_action := jai_constants.updating ;

5696: close c_get_rec;
5697:
5698: if(t_rec_new.once_completed_flag = 'Y')then
5699:
5700: lv_action := jai_constants.updating ;
5701:
5702: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
5703: pr_old => t_rec_old ,
5704: pr_new => t_rec_new ,

Line 5710: IF lv_return_code <> jai_constants.successful then

5706: pv_return_code => lv_return_code ,
5707: pv_return_message => lv_return_message
5708: );
5709:
5710: IF lv_return_code <> jai_constants.successful then
5711: RAISE le_error;
5712: END IF;
5713:
5714: end if;

Line 5725: if lv_process_flag <> jai_constants.successful then

5721: ( p_ractl => pr_new
5722: , p_process_flag => lv_process_flag
5723: , p_process_message => lv_process_message
5724: );
5725: if lv_process_flag <> jai_constants.successful then
5726: app_exception.raise_exception
5727: (exception_type => 'APP'
5728: ,exception_code => -20275
5729: ,exception_text => lv_process_message

Line 5754: pv_return_code := jai_constants.successful ;

5750: G_PKG_NAME || ': ' || l_api_name || '()+');
5751: end if;
5752:
5753:
5754: pv_return_code := jai_constants.successful ;
5755:
5756: IF pr_new.interface_line_context IN ('PROJECTS INVOICES','OKS CONTRACTS','LEGACY') THEN
5757: RETURN;
5758: END IF;

Line 6101: lv_action := jai_constants.INSERTING;

6097: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6098: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6099: CLOSE c_jai_ar_trx_lines;
6100:
6101: lv_action := jai_constants.INSERTING;
6102:
6103: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
6104: pr_old => NULL ,
6105: pr_new => t_jai_line_rec_new ,

Line 6110: IF lv_return_code <> jai_constants.successful then

6106: pv_action => lv_action ,
6107: pv_return_code => lv_return_code ,
6108: pv_return_message => lv_return_message
6109: );
6110: IF lv_return_code <> jai_constants.successful then
6111: RAISE le_error;
6112: END IF;
6113: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
6114:

Line 6137: lv_action := jai_constants.UPDATING;

6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6134: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
6135: CLOSE c_jai_ar_trx_lines;
6136:
6137: lv_action := jai_constants.UPDATING;
6138:
6139: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
6140: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'
6141: ) AND

Line 6156: IF lv_return_code <> jai_constants.successful then

6152: pv_action => lv_action,
6153: pv_return_code => lv_return_code,
6154: pv_return_message => lv_return_message
6155: );
6156: IF lv_return_code <> jai_constants.successful then
6157: RAISE le_error;
6158: END IF;
6159: END IF;
6160: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end

Line 6191: lv_action := jai_constants.updating ;

6187: close c_get_rec;
6188:
6189: if(t_rec_new.once_completed_flag = 'Y')then
6190:
6191: lv_action := jai_constants.updating ;
6192:
6193: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
6194: pr_old => t_rec_old ,
6195: pr_new => t_rec_new ,

Line 6201: IF lv_return_code <> jai_constants.successful then

6197: pv_return_code => lv_return_code ,
6198: pv_return_message => lv_return_message
6199: );
6200:
6201: IF lv_return_code <> jai_constants.successful then
6202: RAISE le_error;
6203: END IF;
6204:
6205: end if;

Line 6216: Pv_return_code := jai_constants.unexpected_error;

6212: end if;
6213:
6214: EXCEPTION
6215: WHEN le_error then
6216: Pv_return_code := jai_constants.unexpected_error;
6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;
6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN

Line 6221: Pv_return_code := jai_constants.unexpected_error;

6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;
6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);
6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));
6224: END pop_jai_rmacm ;
6225:

Line 6627: lv_action := jai_constants.INSERTING;

6623: OPEN c_jai_ar_trx_lines(r_new.customer_trx_id,ln_line_customer_trx_line_id);
6624: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6625: CLOSE c_jai_ar_trx_lines;
6626:
6627: lv_action := jai_constants.INSERTING;
6628:
6629: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (
6630: pr_old => NULL ,
6631: pr_new => t_jai_line_rec_new ,

Line 6636: IF lv_return_code <> jai_constants.successful then

6632: pv_action => lv_action ,
6633: pv_return_code => lv_return_code ,
6634: pv_return_message => lv_return_message
6635: );
6636: IF lv_return_code <> jai_constants.successful then
6637: RAISE le_error;
6638: END IF;
6639: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
6640: --Added by Zhiwei for JAI Trigger elimination begin

Line 6666: lv_action := jai_constants.updating ;

6662: close c_get_rec;
6663:
6664: if(t_rec_new.once_completed_flag = 'Y')then
6665:
6666: lv_action := jai_constants.updating ;
6667:
6668: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
6669: pr_old => t_rec_old ,
6670: pr_new => t_rec_new ,

Line 6676: IF lv_return_code <> jai_constants.successful then

6672: pv_return_code => lv_return_code ,
6673: pv_return_message => lv_return_message
6674: );
6675:
6676: IF lv_return_code <> jai_constants.successful then
6677: RAISE le_error;
6678: END IF;
6679:
6680: end if;

Line 6696: pv_err_flg := jai_constants.unexpected_error;

6692:
6693: --Added by Zhiwei for ZX prototype begin
6694: EXCEPTION
6695: WHEN le_error then
6696: pv_err_flg := jai_constants.unexpected_error;
6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;
6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN

Line 6701: pv_err_flg := jai_constants.unexpected_error;

6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;
6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);
6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));
6704:
6705: --Added by Zhiwei for ZX prototype end

Line 6771: --pv_return_code := jai_constants.successful ;

6767: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
6768: l_api_name CONSTANT VARCHAR2(30) := 'GET_LEGAL_ENTITY_ID()';
6769: BEGIN
6770:
6771: --pv_return_code := jai_constants.successful ;
6772: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6773: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6774: G_MODULE_NAME || l_api_name || '.BEGIN',
6775: G_PKG_NAME || ': ' || l_api_name || '()+');

Line 6840: IF pv_party_type = jai_constants.party_type_customer THEN

6836: ||passed as parameters.
6837: */
6838:
6839: BEGIN
6840: IF pv_party_type = jai_constants.party_type_customer THEN
6841:
6842: OPEN c_get_address;
6843: FETCH c_get_address INTO ln_address_id;
6844: CLOSE c_get_address;

Line 6858: ELSIF pv_party_type = jai_constants.party_type_vendor THEN

6854: CLOSE cur_get_ser_type_customer;
6855:
6856: END IF;
6857:
6858: ELSIF pv_party_type = jai_constants.party_type_vendor THEN
6859:
6860: OPEN cur_get_ser_type_vendor(pn_party_id, pn_party_site_id);
6861: FETCH cur_get_ser_type_vendor INTO v_service_type;
6862: CLOSE cur_get_ser_type_vendor;