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_OPEN_API_PKG dependencies on JAI_CONSTANTS

Line 478: AND CURRENCY_CODE = JAI_CONSTANTS.func_curr;

474: IS
475: SELECT CHART_OF_ACCOUNTS_ID
476: FROM gl_sets_of_books
477: WHERE SET_OF_BOOKS_ID = cn_set_books_id
478: AND CURRENCY_CODE = JAI_CONSTANTS.func_curr;
479:
480: --Added by zhiwei for bug#12560646 on 20110523 begin
481: --------------------------------------------------------------------
482: CURSOR chk_ccid_cur

Line 867: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN --Added by zhiwei for bug#12585126 on 20110523

863: lv_error_mess VARCHAR2(1000);
864: --Main block
865: BEGIN
866:
867: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN --Added by zhiwei for bug#12585126 on 20110523
868: IF (NVL(pr_interface_lines.taxable_event,'#') = GV_TAXABLE_EVENT_STANDALONE )THEN
869: IF( NVL(pr_interface_lines.taxable_basis,'#') NOT IN ( GV_TAXABLE_BASIS_LINEAMT , GV_TAXABLE_BASIS_AV)) THEN
870:
871: xn_err_flag := 1;

Line 1017: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN

1013:
1014: --Main block
1015: BEGIN
1016: --For AR
1017: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN
1018: OPEN get_tax_ar_count_cur;
1019: FETCH get_tax_ar_count_cur INTO ln_tax_count;
1020: CLOSE get_tax_ar_count_cur;
1021:

Line 1041: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AP)THEN

1037:
1038: END IF;--AR
1039:
1040: --For AP
1041: IF(GV_IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AP)THEN
1042:
1043: OPEN get_tax_ap_count_cur;
1044: FETCH get_tax_ap_count_cur INTO ln_tax_count;
1045: CLOSE get_tax_ap_count_cur;

Line 1126: IF pv_import_module = JAI_CONSTANTS.SOURCE_AP THEN

1122:
1123: BEGIN
1124:
1125:
1126: IF pv_import_module = JAI_CONSTANTS.SOURCE_AP THEN
1127: OPEN chk_ap_accted;
1128: FETCH chk_ap_accted INTO ln_ap_accted;
1129: CLOSE chk_ap_accted;
1130:

Line 1147: IF pv_import_module = JAI_CONSTANTS.SOURCE_AR THEN

1143: pv_fnd_log => lv_return_mess
1144: );
1145: END IF;
1146: END IF;
1147: IF pv_import_module = JAI_CONSTANTS.SOURCE_AR THEN
1148: OPEN chk_ar_accted;
1149: FETCH chk_ar_accted INTO ln_ar_accted;
1150: CLOSE chk_ar_accted;
1151:

Line 1265: IF( pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN

1261: BEGIN
1262: lv_transaction_num := get_trx_number(pn_interface_line_id);
1263: --For AR
1264: --NEED ADD THE STATUS CHECK FOR APPLIED OR PARTIALLY APPLIED .
1265: IF( pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN
1266: OPEN get_ar_status_cur;
1267: FETCH get_ar_status_cur INTO lv_ar_status;
1268: CLOSE get_ar_status_cur;
1269:

Line 1309: IF ( pv_import_module = JAI_CONSTANTS.SOURCE_AP) THEN

1305: END IF;
1306:
1307: ELSE
1308: --For AP
1309: IF ( pv_import_module = JAI_CONSTANTS.SOURCE_AP) THEN
1310: ln_exist_flag := 0;
1311: FOR rec_ap_info IN get_ap_info_cur
1312: LOOP
1313: --ln_exist_flag := 1;--Commented by zhiwei for Bug#12639971 on 20110615

Line 1469: IF( pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN

1465: --Main block
1466: BEGIN
1467:
1468: --For AR
1469: IF( pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN
1470:
1471: OPEN get_ar_info_cur;
1472: FETCH get_ar_info_cur INTO rec_get_info;
1473: CLOSE get_ar_info_cur;

Line 1539: IF ( pv_import_module = JAI_CONSTANTS.SOURCE_AP) THEN

1535: END IF;
1536:
1537: ELSE
1538: --For AP
1539: IF ( pv_import_module = JAI_CONSTANTS.SOURCE_AP) THEN
1540:
1541: OPEN get_ap_info_cur;
1542: FETCH get_ap_info_cur INTO rec_get_info;
1543: CLOSE get_ap_info_cur;

Line 2110: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

2106: 'TURNOVER TAX','OTHER EXCISE','VAT', 'VAT_REVERSAL')
2107: OR upper(tax_type) IN
2108: (SELECT jrr.attribute_code
2109: FROM jai_rgm_registrations jrr
2110: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2111: AND jrr.regime_id IN
2112: (SELECT jrd.regime_id
2113: FROM jai_rgm_definitions jrd
2114: WHERE jrd.regime_code = jai_constants.customs_regime)));

Line 2114: WHERE jrd.regime_code = jai_constants.customs_regime)));

2110: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2111: AND jrr.regime_id IN
2112: (SELECT jrd.regime_id
2113: FROM jai_rgm_definitions jrd
2114: WHERE jrd.regime_code = jai_constants.customs_regime)));
2115:
2116: CURSOR chk_ar_tax_type_cur
2117: IS
2118: SELECT

Line 2134: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

2130: (--Added by zhiwei for Bug#12561573
2131: upper(tax_type) IN
2132: (SELECT jrr.attribute_code
2133: FROM jai_rgm_registrations jrr
2134: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2135: AND jrr.regime_id IN
2136: (SELECT jrd.regime_id
2137: FROM jai_rgm_definitions jrd
2138: WHERE jrd.regime_code = jai_constants.customs_regime))

Line 2138: WHERE jrd.regime_code = jai_constants.customs_regime))

2134: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2135: AND jrr.regime_id IN
2136: (SELECT jrd.regime_id
2137: FROM jai_rgm_definitions jrd
2138: WHERE jrd.regime_code = jai_constants.customs_regime))
2139: --Added by zhiwei for Bug#12561573 begin
2140: -------------------------------------------------
2141: or
2142: upper(tax_type) in

Line 2162: IF(pr_interface_lines.import_module = JAI_CONSTANTS.SOURCE_AP)THEN

2158:
2159:
2160: BEGIN
2161:
2162: IF(pr_interface_lines.import_module = JAI_CONSTANTS.SOURCE_AP)THEN
2163:
2164: OPEN chk_ap_tax_type_cur;
2165: FETCH chk_ap_tax_type_cur INTO ln_count;
2166: CLOSE chk_ap_tax_type_cur;

Line 2183: ELSIF (pr_interface_lines.import_module = JAI_CONSTANTS.SOURCE_AR) THEN

2179: record_fnd_log(
2180: pv_fnd_log => lv_return_mess
2181: );
2182: END IF;
2183: ELSIF (pr_interface_lines.import_module = JAI_CONSTANTS.SOURCE_AR) THEN
2184:
2185: OPEN chk_ar_tax_type_cur;
2186: FETCH chk_ar_tax_type_cur INTO ln_count;
2187: CLOSE chk_ar_tax_type_cur;

Line 2718: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

2714: AND jila.internal_trx_id = cn_trx_id
2715: AND upper(jcta.tax_type) IN
2716: (SELECT jrr.attribute_code
2717: FROM jai_rgm_registrations jrr
2718: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2719: AND jrr.regime_id = (SELECT jrd.regime_id
2720: FROM jai_rgm_definitions jrd
2721: WHERE jrd.regime_code = jai_constants.vat_regime)));
2722:

Line 2721: WHERE jrd.regime_code = jai_constants.vat_regime)));

2717: FROM jai_rgm_registrations jrr
2718: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2719: AND jrr.regime_id = (SELECT jrd.regime_id
2720: FROM jai_rgm_definitions jrd
2721: WHERE jrd.regime_code = jai_constants.vat_regime)));
2722:
2723: CURSOR get_excise_tax_exists_cur(cn_trx_id IN NUMBER) IS
2724: SELECT 'Y'
2725: FROM dual

Line 2835: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

2831: AND jila.internal_trx_id = cn_trx_id
2832: AND upper(jcta.tax_type) IN
2833: (SELECT upper(jrr.attribute_code)
2834: FROM jai_rgm_registrations jrr
2835: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2836: AND jrr.regime_id = (SELECT jrd.regime_id
2837: FROM jai_rgm_definitions jrd
2838: WHERE jrd.regime_code = jai_constants.service_regime)));
2839: ln_st_num_count NUMBER;

Line 2838: WHERE jrd.regime_code = jai_constants.service_regime)));

2834: FROM jai_rgm_registrations jrr
2835: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2836: AND jrr.regime_id = (SELECT jrd.regime_id
2837: FROM jai_rgm_definitions jrd
2838: WHERE jrd.regime_code = jai_constants.service_regime)));
2839: ln_st_num_count NUMBER;
2840: lv_service_tax_exist VARCHAR2(1);
2841: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
2842: BEGIN

Line 3171: IF(rec_trx_line_count.IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN

3167: ------------------------------------------------------------------------
3168: --Added by zhiwei for Bug#12630077 on 20110608 end
3169:
3170: --AR
3171: IF(rec_trx_line_count.IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AR)THEN
3172:
3173:
3174: OPEN get_ar_lines_count_cur(rec_trx_line_count.trx_id);
3175: FETCH get_ar_lines_count_cur INTO ln_line_count;

Line 3264: IF(rec_trx_line_count.IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AP)THEN

3260: END IF;
3261: END IF;--AR
3262:
3263: --AP
3264: IF(rec_trx_line_count.IMPORT_MODULE = JAI_CONSTANTS.SOURCE_AP)THEN
3265: OPEN get_ap_lines_count_cur(rec_trx_line_count.trx_id);
3266: FETCH get_ap_lines_count_cur INTO ln_line_count;
3267: CLOSE get_ap_lines_count_cur;
3268:

Line 3867: IF(pn_import_module = JAI_CONSTANTS.SOURCE_AR)THEN

3863:
3864: --Main block
3865: BEGIN
3866:
3867: IF(pn_import_module = JAI_CONSTANTS.SOURCE_AR)THEN
3868:
3869: lv_enable_gst_flag := 'N';--JAI_GST_GENERAL_PKG.IS_GST_ENABLED;
3870:
3871: OPEN bind_cur(pn_internal_trx_id);

Line 3933: IF (pn_import_module = JAI_CONSTANTS.SOURCE_AP) THEN

3929: END IF;
3930: END IF;
3931: --FOR AP
3932: ELSE
3933: IF (pn_import_module = JAI_CONSTANTS.SOURCE_AP) THEN
3934:
3935: Get_Invoice_Header_Infor (
3936: pn_internal_trx_id--ln_invoice_id
3937: , ln_vendor_id

Line 3978: v_debug := jai_constants.NO;

3974:
3975: --Main block
3976: BEGIN
3977:
3978: v_debug := jai_constants.NO;
3979:
3980: OPEN c_get_tax_type_code(pn_tax_id);
3981: FETCH c_get_tax_type_code INTO ln_tax_type_code;
3982: CLOSE c_get_tax_type_code;

Line 4071: IF(pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN

4067: --Main block
4068: BEGIN
4069:
4070: --AR
4071: IF(pv_import_module = JAI_CONSTANTS.SOURCE_AR)THEN
4072:
4073: OPEN get_trx_info_ar_cur;
4074: FETCH get_trx_info_ar_cur INTO rec_ar_trx_info;
4075: CLOSE get_trx_info_ar_cur;

Line 4082: IF(pv_import_module = JAI_CONSTANTS.SOURCE_AP)THEN

4078: ln_trx_line_id := rec_ar_trx_info.customer_trx_line_id;
4079: END IF;--AR
4080:
4081: --AP
4082: IF(pv_import_module = JAI_CONSTANTS.SOURCE_AP)THEN
4083: OPEN get_trx_info_ap_cur;
4084: FETCH get_trx_info_ap_cur INTO rec_ap_trx_info;
4085: CLOSE get_trx_info_ap_cur;
4086:

Line 4208: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AR)THEN

4204: lv_error_mess VARCHAR2(1000);
4205: --Main block
4206: BEGIN
4207:
4208: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AR)THEN
4209:
4210: IF(NVL(pn_party_id,-1) = -1)THEN
4211: xn_err_flag := 1;
4212: lv_return_mess := 'INITIAL in get_party_info : the customer id given by user should not be null With interface_line_id:'||pn_interface_line_id;

Line 4287: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AP)THEN

4283:
4284: END IF;
4285:
4286: END IF;
4287: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AP)THEN
4288:
4289:
4290:
4291: IF(NVL(pn_party_id,-1) = -1)THEN

Line 4369: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AR)THEN

4365:
4366: END IF;
4367:
4368: --Check the combination of party id and party site id is available.
4369: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AR)THEN
4370: OPEN chk_ar_party_combination_cur(
4371: cn_party_id => pn_party_id,
4372: cn_party_site_id => pn_party_site_id
4373: );

Line 4377: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AP)THEN

4373: );
4374: FETCH chk_ar_party_combination_cur INTO ln_party_count;
4375: CLOSE chk_ar_party_combination_cur;
4376: END IF;
4377: IF(NVL(pv_import_module,'#') = JAI_CONSTANTS.SOURCE_AP)THEN
4378: OPEN chk_ap_party_combination_cur(
4379: cn_party_id => pn_party_id,
4380: cn_party_site_id => pn_party_site_id
4381: );

Line 4476: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

4472: upper(tax_type) in
4473: (
4474: SELECT jrr.attribute_code
4475: FROM jai_rgm_registrations jrr
4476: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4477: AND jrr.regime_id IN
4478: (
4479: SELECT jrd.regime_id
4480: FROM jai_rgm_definitions jrd

Line 4481: WHERE jrd.regime_code = jai_constants.service_regime

4477: AND jrr.regime_id IN
4478: (
4479: SELECT jrd.regime_id
4480: FROM jai_rgm_definitions jrd
4481: WHERE jrd.regime_code = jai_constants.service_regime
4482: )
4483: )
4484: or
4485: upper(tax_type) in

Line 4514: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

4510: upper(tax_type) in
4511: (
4512: SELECT jrr.attribute_code
4513: FROM jai_rgm_registrations jrr
4514: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4515: AND jrr.regime_id IN
4516: (
4517: SELECT jrd.regime_id
4518: FROM jai_rgm_definitions jrd

Line 4519: WHERE jrd.regime_code = jai_constants.service_regime

4515: AND jrr.regime_id IN
4516: (
4517: SELECT jrd.regime_id
4518: FROM jai_rgm_definitions jrd
4519: WHERE jrd.regime_code = jai_constants.service_regime
4520: )
4521: )
4522: or
4523: upper(tax_type) in

Line 4888: IF(NVL(pr_interface_lines.import_module,'#') NOT IN (JAI_CONSTANTS.SOURCE_AR,JAI_CONSTANTS.SOURCE_AP))THEN

4884: --Main block
4885: BEGIN
4886:
4887: --Import module should be AR or AP
4888: IF(NVL(pr_interface_lines.import_module,'#') NOT IN (JAI_CONSTANTS.SOURCE_AR,JAI_CONSTANTS.SOURCE_AP))THEN
4889:
4890: lv_return_mess := 'VALIDATION in validate_import_module : Import module is incorrect With interface_line_id:'||pr_interface_lines.interface_line_id;
4891: lv_error_mess := 'JAI_IMPORT_MODULE_ERR';--'Import module value is invalid';
4892: xn_err_flag := 1;

Line 5100: IF(rec_interface_line.import_module = JAI_CONSTANTS.SOURCE_AP)THEN

5096: ln_phase := 13.01;
5097:
5098:
5099: --Check the Service Type for AP.
5100: IF(rec_interface_line.import_module = JAI_CONSTANTS.SOURCE_AP)THEN
5101:
5102: validate_service_type(
5103: pn_interface_line_id => rec_interface_line.interface_line_id,
5104: pn_trx_id => ln_internal_trx_id,

Line 5273: or( NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AR

5269:
5270: ln_phase := 10.5;
5271:
5272: IF(NVL(lv_import_module,'#') = '#'
5273: or( NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AR
5274: and NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AP))THEN
5275: ln_err_flag_init := 1;
5276: lv_return_mess := 'INITIAL in initial_process : Import module should be '|| jai_constants.source_ar ||' or '||jai_constants.source_ap ||' With interface_line_id:'||pn_interface_line_id;
5277: lv_error_mess := 'JAI_IMPORT_MODULE_ERR';--'Import module value is invalid';

Line 5274: and NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AP))THEN

5270: ln_phase := 10.5;
5271:
5272: IF(NVL(lv_import_module,'#') = '#'
5273: or( NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AR
5274: and NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AP))THEN
5275: ln_err_flag_init := 1;
5276: lv_return_mess := 'INITIAL in initial_process : Import module should be '|| jai_constants.source_ar ||' or '||jai_constants.source_ap ||' With interface_line_id:'||pn_interface_line_id;
5277: lv_error_mess := 'JAI_IMPORT_MODULE_ERR';--'Import module value is invalid';
5278: log_error(

Line 5276: lv_return_mess := 'INITIAL in initial_process : Import module should be '|| jai_constants.source_ar ||' or '||jai_constants.source_ap ||' With interface_line_id:'||pn_interface_line_id;

5272: IF(NVL(lv_import_module,'#') = '#'
5273: or( NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AR
5274: and NVL(lv_import_module,'#') <> JAI_CONSTANTS.SOURCE_AP))THEN
5275: ln_err_flag_init := 1;
5276: lv_return_mess := 'INITIAL in initial_process : Import module should be '|| jai_constants.source_ar ||' or '||jai_constants.source_ap ||' With interface_line_id:'||pn_interface_line_id;
5277: lv_error_mess := 'JAI_IMPORT_MODULE_ERR';--'Import module value is invalid';
5278: log_error(
5279: pv_err_level => GV_ERROR_TYPE_LINE,
5280: pn_line_id => pn_interface_line_id,

Line 5421: AND jrd.regime_code = jai_constants.service_regime

5417: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
5418: select to_date(attribute_value, 'DD/MM/YYYY')
5419: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5420: where jrr.regime_id = jrd.regime_id
5421: AND jrd.regime_code = jai_constants.service_regime
5422: and jrr.organization_id = p_organization_id
5423: and jrr.location_id = p_location_id
5424: AND jrr.attribute_code = 'EFF_DATE_ST_PT'
5425: AND jrr.attribute_type_code = 'OTHERS'

Line 5431: AND jrd.regime_code = jai_constants.service_regime

5427: AND (NOT EXISTS
5428: (select '1'
5429: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5430: where jrr.regime_id = jrd.regime_id
5431: AND jrd.regime_code = jai_constants.service_regime
5432: and jrr.attribute_code IN 'INV_ORG_CLASSIFICATION'
5433: and jrr.attribute_value <> 'ORGANIZATION'
5434: and jrr.organization_id = p_organization_id
5435: and jrr.location_id = p_location_id)

Line 5441: AND jrd.regime_code = jai_constants.service_regime

5437: NOT EXISTS
5438: (select '1'
5439: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
5440: where jrr.regime_id = jrd.regime_id
5441: AND jrd.regime_code = jai_constants.service_regime
5442: and jrr.attribute_code IN 'SERVICE TYPE'
5443: and jrr.attribute_value <> 'OTHER'
5444: and jrr.organization_id = p_organization_id
5445: and jrr.location_id = p_location_id)

Line 5730: pv_return_code := jai_constants.successful;

5726:
5727: BEGIN
5728:
5729:
5730: pv_return_code := jai_constants.successful;
5731: --added by zhiwei for Open Interface ER 20101116 begin,
5732: -------------------------------------------------------
5733: --use get_jai_trx_line to replace pr_new
5734: open cur_get_jai_line_rec(pn_customer_trx_line_id);

Line 5831: jai_constants.tax_type_sh_exc_edu_cess,

5827: 'ADDL. EXCISE',
5828: 'OTHER EXCISE',
5829: 'EXCISE_EDUCATION_CESS',
5830: 'CVD_EDUCATION_CESS',
5831: jai_constants.tax_type_sh_exc_edu_cess,
5832: jai_constants.tax_type_sh_cvd_edu_cess) THEN
5833: TAX_TYPE_REC.tax_amt := 0;
5834: END IF;
5835: END IF;

Line 5832: jai_constants.tax_type_sh_cvd_edu_cess) THEN

5828: 'OTHER EXCISE',
5829: 'EXCISE_EDUCATION_CESS',
5830: 'CVD_EDUCATION_CESS',
5831: jai_constants.tax_type_sh_exc_edu_cess,
5832: jai_constants.tax_type_sh_cvd_edu_cess) THEN
5833: TAX_TYPE_REC.tax_amt := 0;
5834: END IF;
5835: END IF;
5836:

Line 5885: upper(jai_constants.tax_type_service) OR

5881: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
5882: || IF no setup is found then raise an error and stop the transaction.
5883: */
5884: IF upper(tax_type_rec.t_type) =
5885: upper(jai_constants.tax_type_service) OR
5886: upper(tax_type_rec.t_type) =
5887: upper(jai_constants.tax_type_service_edu_cess) OR
5888: upper(tax_type_rec.t_type) =
5889: upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806

Line 5887: upper(jai_constants.tax_type_service_edu_cess) OR

5883: */
5884: IF upper(tax_type_rec.t_type) =
5885: upper(jai_constants.tax_type_service) OR
5886: upper(tax_type_rec.t_type) =
5887: upper(jai_constants.tax_type_service_edu_cess) OR
5888: upper(tax_type_rec.t_type) =
5889: upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
5890: THEN
5891: -- Start of A1

Line 5889: upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806

5885: upper(jai_constants.tax_type_service) OR
5886: upper(tax_type_rec.t_type) =
5887: upper(jai_constants.tax_type_service_edu_cess) OR
5888: upper(tax_type_rec.t_type) =
5889: upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
5890: THEN
5891: -- Start of A1
5892:
5893: /*################################################################################################################

Line 5897: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,

5893: /*################################################################################################################
5894: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information
5895: ################################################################################################################*/
5896:
5897: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,
5898: p_tax_type_code => tax_type_rec.t_type,
5899: p_regime_id => ln_regime_id,
5900: p_error_flag => lv_error_flag,
5901: p_error_message => lv_error_message);

Line 5903: IF lv_error_flag <> jai_constants.successful THEN

5899: p_regime_id => ln_regime_id,
5900: p_error_flag => lv_error_flag,
5901: p_error_message => lv_error_message);
5902:
5903: IF lv_error_flag <> jai_constants.successful THEN
5904: /*
5905: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
5906: || Stop processing and thorw an error
5907: */

Line 5909: pv_return_code := jai_constants.expected_error;

5905: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
5906: || Stop processing and thorw an error
5907: */
5908: /* raise_application_error (-20130,lv_error_message); */
5909: pv_return_code := jai_constants.expected_error;
5910: pv_return_message := lv_error_message;
5911: return;
5912: /*
5913: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 5933: p_organization_type => jai_constants.service_tax_orgn_type,

5929: --Added by zhiwei for POT change Bug#13023443 begin
5930: -----------------------------------------------------------------
5931: if( is_accrual_basis(tax_type_rec.line_id))then
5932: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
5933: p_organization_type => jai_constants.service_tax_orgn_type,
5934: p_organization_id => v_organization_id,
5935: p_location_id => v_location_id,
5936: p_tax_type => tax_type_rec.t_type,
5937: p_account_name => jai_constants.liability);

Line 5937: p_account_name => jai_constants.liability);

5933: p_organization_type => jai_constants.service_tax_orgn_type,
5934: p_organization_id => v_organization_id,
5935: p_location_id => v_location_id,
5936: p_tax_type => tax_type_rec.t_type,
5937: p_account_name => jai_constants.liability);
5938:
5939: else
5940: -----------------------------------------------------------------
5941: --Added by zhiwei for POT change Bug#13023443 end

Line 5943: p_organization_type => jai_constants.service_tax_orgn_type,

5939: else
5940: -----------------------------------------------------------------
5941: --Added by zhiwei for POT change Bug#13023443 end
5942: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
5943: p_organization_type => jai_constants.service_tax_orgn_type,
5944: p_organization_id => v_organization_id,
5945: p_location_id => v_location_id,
5946: p_tax_type => tax_type_rec.t_type,
5947: p_account_name => jai_constants.liability_interim);

Line 5947: p_account_name => jai_constants.liability_interim);

5943: p_organization_type => jai_constants.service_tax_orgn_type,
5944: p_organization_id => v_organization_id,
5945: p_location_id => v_location_id,
5946: p_tax_type => tax_type_rec.t_type,
5947: p_account_name => jai_constants.liability_interim);
5948: end if;--Added by zhiwei for POT change Bug#13023443
5949:
5950: IF v_ccid IS NULL THEN
5951: /*

Line 5956: pv_return_code := jai_constants.expected_error;

5952: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
5953: || This is an error condition and the current processing has to be stopped
5954: */
5955: /* raise_application_error (-20130,'Invalid Code combination, please check the Service Tax - Tax Accounting Setup'); */
5956: pv_return_code := jai_constants.expected_error;
5957: pv_return_message := 'Invalid Code combination,please check the Service Tax - Tax Accounting Setup';
5958: return;
5959: /*
5960: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 5974: jai_constants.vat_regime THEN

5970: || Code modified by aiyer for the VAT Enhancement
5971: || Get the Tax accounting information from the vat regime setup when the taxes are as mentioned below taxes
5972: */
5973: ELSIF UPPER(nvl(ln_regime_code, '####')) =
5974: jai_constants.vat_regime THEN
5975:
5976: /*********************************************************************************************************
5977: || Validate whether the item attached is vatable or not
5978: *********************************************************************************************************/

Line 5984: p_attribute_code => jai_constants.rgm_attr_item_applicable,

5980: /*Bug 5671400 bduvarag*/
5981: jai_inv_items_pkg.jai_get_attrib(p_regime_code => ln_regime_code,
5982: p_organization_id => v_organization_id,
5983: p_inventory_item_id => get_jai_trx_line.inventory_item_id,
5984: p_attribute_code => jai_constants.rgm_attr_item_applicable,
5985: p_attribute_value => lv_attr_value,
5986: p_process_flag => lv_error_flag,
5987: p_process_msg => lv_error_message);
5988:

Line 5989: IF lv_error_flag <> jai_constants.successful THEN

5985: p_attribute_value => lv_attr_value,
5986: p_process_flag => lv_error_flag,
5987: p_process_msg => lv_error_message);
5988:
5989: IF lv_error_flag <> jai_constants.successful THEN
5990: /*
5991: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
5992: || Stop processing and thorw an error
5993: */

Line 5995: pv_return_code := jai_constants.expected_error;

5991: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
5992: || Stop processing and thorw an error
5993: */
5994: /* raise_application_error (-20130,lv_error_message); */
5995: pv_return_code := jai_constants.expected_error;
5996: pv_return_message := lv_error_message;
5997: return;
5998: /*
5999: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 6018: pv_return_code := jai_constants.expected_error;

6014: /*
6015: || Item is not vatable . Stop processing and throw an error
6016: */
6017: /* raise_application_error (-20130,'ITEM not vatable'); */
6018: pv_return_code := jai_constants.expected_error;
6019: pv_return_message := 'ITEM not vatable';
6020: return;
6021: /* DO not delete this code, enable this code while doing the messageing project
6022: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 6040: p_organization_type => jai_constants.orgn_type_io,

6036: || by calling the function jai_cmn_rgm_recording_pkg.get_account
6037: */
6038:
6039: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
6040: p_organization_type => jai_constants.orgn_type_io,
6041: p_organization_id => v_organization_id,
6042: p_location_id => v_location_id,
6043: p_tax_type => tax_type_rec.t_type,
6044: p_account_name => jai_constants.liability_interim);

Line 6044: p_account_name => jai_constants.liability_interim);

6040: p_organization_type => jai_constants.orgn_type_io,
6041: p_organization_id => v_organization_id,
6042: p_location_id => v_location_id,
6043: p_tax_type => tax_type_rec.t_type,
6044: p_account_name => jai_constants.liability_interim);
6045: IF v_ccid IS NULL THEN
6046: /*
6047: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
6048: || This is an error condition and the current processing has to be stopped

Line 6051: pv_return_code := jai_constants.expected_error;

6047: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
6048: || This is an error condition and the current processing has to be stopped
6049: */
6050: /* raise_application_error (-20130,'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup'); */
6051: pv_return_code := jai_constants.expected_error;
6052: pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup';
6053: return;
6054: /*
6055: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 6068: jai_constants.tcs_regime THEN

6064: */
6065:
6066: /* Added by CSahoo for the TCS enhancements Bug# 5631784 */
6067: ELSIF UPPER(nvl(ln_regime_code, '####')) =
6068: jai_constants.tcs_regime THEN
6069: -- Start of A1
6070:
6071: /*********************************************************************************************************
6072: || Get the code combination id from the Organization/Regime Registration setup

Line 6077: p_organization_type => jai_constants.orgn_type_io,

6073: || by calling the function jai_rgm_trx_recording_pkg.get_account
6074: *********************************************************************************************************/
6075:
6076: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
6077: p_organization_type => jai_constants.orgn_type_io,
6078: p_organization_id => v_organization_id,
6079: p_location_id => v_location_id,
6080: p_tax_type => tax_type_rec.t_type,
6081: p_account_name => jai_constants.liability_interim);

Line 6081: p_account_name => jai_constants.liability_interim);

6077: p_organization_type => jai_constants.orgn_type_io,
6078: p_organization_id => v_organization_id,
6079: p_location_id => v_location_id,
6080: p_tax_type => tax_type_rec.t_type,
6081: p_account_name => jai_constants.liability_interim);
6082: IF v_ccid IS NULL THEN
6083: /**********************************************************************************************************
6084: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account
6085: || This is an error condition and the current processing has to be stopped

Line 6087: pv_return_code := jai_constants.expected_error;

6083: /**********************************************************************************************************
6084: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account
6085: || This is an error condition and the current processing has to be stopped
6086: **********************************************************************************************************/
6087: pv_return_code := jai_constants.expected_error;
6088: pv_return_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup'|| tax_type_rec.t_type;
6089: return;
6090: /*raise_application_error(-20130,
6091: 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup');*/--Commented by zhiwei for open interface ER 20101116

Line 6184: pv_return_code := jai_constants.unexpected_error;

6180:
6181: -- END IF; Commented BY ZHIWEI
6182: EXCEPTION
6183: WHEN OTHERS THEN
6184: pv_return_code := jai_constants.unexpected_error;
6185: pv_return_message := 'Encountered an error in JAI_JAR_TL_TRIGGER_PKG.ARU_T1 ' ||
6186: substr(sqlerrm, 1, 1900);
6187:
6188: END populate_temp_table;

Line 6232: p_process_status := jai_constants.successful;

6228: WHERE object_name = cp_object_name
6229: AND procedure_name = cp_procedure_name;
6230:
6231: BEGIN
6232: p_process_status := jai_constants.successful;
6233: p_process_message := NULL;
6234:
6235: /* Ramananda for bug#5219225. START */
6236: lv_object_name := 'AR_MRC_ENGINE';

Line 6292: p_process_status := jai_constants.unexpected_error;

6288: AND line_type IN ('TAX', 'FREIGHT');
6289:
6290: EXCEPTION
6291: WHEN OTHERS THEN
6292: p_process_status := jai_constants.unexpected_error;
6293: p_process_message := SUBSTR(SQLERRM, 1, 300);
6294: END delete_trx_data;
6295:
6296:

Line 6317: lv_action VARCHAR2(20) := jai_constants.updating;

6313: SELECT *
6314: FROM RA_CUSTOMER_TRX_ALL
6315: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6316: --Variable define here
6317: lv_action VARCHAR2(20) := jai_constants.updating;
6318: lv_return_message VARCHAR2(2000);
6319: lv_return_code VARCHAR2(100) ;
6320: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6321: --Main block

Line 6357: lv_action VARCHAR2(20) := jai_constants.updating;

6353: SELECT *
6354: FROM RA_CUSTOMER_TRX_ALL
6355: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6356:
6357: lv_action VARCHAR2(20) := jai_constants.updating;
6358: lv_return_message VARCHAR2(2000);
6359: lv_return_code VARCHAR2(100) ;
6360: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6361: BEGIN

Line 6374: --IF lv_return_code <> jai_constants.successful then

6370: pv_return_message => lv_return_message
6371: );
6372: ov_return_code := lv_return_code;
6373: ov_return_message := lv_return_message;
6374: --IF lv_return_code <> jai_constants.successful then
6375: -- RAISE le_error;
6376: --END IF;
6377: END LOOP;
6378:

Line 6397: lv_action VARCHAR2(20) := jai_constants.updating;

6393: SELECT *
6394: FROM RA_CUSTOMER_TRX_ALL
6395: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6396:
6397: lv_action VARCHAR2(20) := jai_constants.updating;
6398: lv_return_message VARCHAR2(2000);
6399: lv_return_code VARCHAR2(100) ;
6400: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6401: BEGIN

Line 6414: --IF lv_return_code <> jai_constants.successful then

6410: pv_return_message => lv_return_message
6411: );
6412: ov_return_code := lv_return_code;
6413: ov_return_message := lv_return_message;
6414: --IF lv_return_code <> jai_constants.successful then
6415: -- RAISE le_error;
6416:
6417: --END IF;
6418: END LOOP;

Line 6438: lv_action VARCHAR2(20) := jai_constants.updating;

6434: SELECT *
6435: FROM RA_CUSTOMER_TRX_ALL
6436: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6437:
6438: lv_action VARCHAR2(20) := jai_constants.updating;
6439: lv_return_message VARCHAR2(2000);
6440: lv_return_code VARCHAR2(100) ;
6441: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6442: BEGIN

Line 6455: --IF lv_return_code <> jai_constants.successful then

6451: pv_return_message => lv_return_message
6452: );
6453: ov_return_code := lv_return_code;
6454: ov_return_message := lv_return_message;
6455: --IF lv_return_code <> jai_constants.successful then
6456: -- RAISE le_error;
6457:
6458: --END IF;
6459: END LOOP;

Line 6491: lv_action VARCHAR2(20) := jai_constants.updating;

6487: from jai_inv_itm_setups
6488: where inventory_item_id = p_inventory_item_id
6489: AND organization_id = p_org_id;
6490:
6491: lv_action VARCHAR2(20) := jai_constants.updating;
6492: lv_return_message VARCHAR2(2000);
6493: lv_return_code VARCHAR2(100) ;
6494: rec_jai_ar_detail jai_ar_trxs%ROWTYPE;
6495: ln_item_id NUMBER;

Line 6535: --IF lv_return_code <> jai_constants.successful then

6531: pv_return_message => lv_return_message
6532: );
6533: ov_return_code := lv_return_code;
6534: ov_return_message := lv_return_message;
6535: --IF lv_return_code <> jai_constants.successful then
6536: -- RAISE le_error;
6537: --END IF;
6538: END LOOP;
6539:

Line 6581: lv_return_code := JAI_CONSTANTS.SUCCESSFUL;

6577: lv_inclu_tax_flag VARCHAR2(3) ;
6578: ln_cust_trx_type_id NUMBER;
6579:
6580: BEGIN
6581: lv_return_code := JAI_CONSTANTS.SUCCESSFUL;
6582:
6583: OPEN organization_id_check(pn_customer_trx_id);
6584: FETCH organization_id_check INTO ln_organization_id;
6585: CLOSE organization_id_check;

Line 6607: --IF lv_return_code <> jai_constants.successful then

6603: , xv_process_message => lv_return_message);
6604:
6605: ov_return_code := lv_return_code;
6606: ov_return_message := lv_return_message;
6607: --IF lv_return_code <> jai_constants.successful then
6608: -- RAISE le_error;
6609:
6610: --END IF;
6611:

Line 6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),

6665: JAI_AR_TRX_TAX_LINES taxes ,
6666: JAI_CMN_TAXES_ALL define
6667: where taxes.tax_id = define.tax_id
6668: and taxes.customer_trx_line_id = pn_customer_trx_line_id
6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),
6670: jai_constants.tax_type_service_edu_cess ,
6671: jai_constants.tax_type_sh_service_edu_cess);
6672: ln_flag number;
6673: BEGIN

Line 6670: jai_constants.tax_type_service_edu_cess ,

6666: JAI_CMN_TAXES_ALL define
6667: where taxes.tax_id = define.tax_id
6668: and taxes.customer_trx_line_id = pn_customer_trx_line_id
6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),
6670: jai_constants.tax_type_service_edu_cess ,
6671: jai_constants.tax_type_sh_service_edu_cess);
6672: ln_flag number;
6673: BEGIN
6674: open chk_service_tax;

Line 6671: jai_constants.tax_type_sh_service_edu_cess);

6667: where taxes.tax_id = define.tax_id
6668: and taxes.customer_trx_line_id = pn_customer_trx_line_id
6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),
6670: jai_constants.tax_type_service_edu_cess ,
6671: jai_constants.tax_type_sh_service_edu_cess);
6672: ln_flag number;
6673: BEGIN
6674: open chk_service_tax;
6675: fetch chk_service_tax into ln_flag;

Line 6918: AND b.tax_type = jai_constants.tax_type_freight);

6914: AND Rma_line_id in
6915: (Select RMA_LINE_ID
6916: from JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
6917: Where a.tax_id = b.tax_id
6918: AND b.tax_type = jai_constants.tax_type_freight);
6919:
6920:
6921: --added 12-Mar-2002
6922: CURSOR tax_type IS

Line 8065: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

8061: --Added by zhiwei for bug#12564566 end
8062: AND upper(jcta.tax_type) IN
8063: (SELECT jrr.attribute_code
8064: FROM jai_rgm_registrations jrr
8065: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8066: AND jrr.regime_id = (SELECT jrd.regime_id
8067: FROM jai_rgm_definitions jrd
8068: WHERE jrd.regime_code = jai_constants.vat_regime)));
8069:

Line 8068: WHERE jrd.regime_code = jai_constants.vat_regime)));

8064: FROM jai_rgm_registrations jrr
8065: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8066: AND jrr.regime_id = (SELECT jrd.regime_id
8067: FROM jai_rgm_definitions jrd
8068: WHERE jrd.regime_code = jai_constants.vat_regime)));
8069:
8070: CURSOR get_excise_tax_exists_cur IS
8071: SELECT 'Y'
8072: FROM dual

Line 8149: WHERE jrr.registration_type = jai_constants.regn_type_tax_types

8145: )
8146: AND upper(jcta.tax_type) IN
8147: (SELECT upper(jrr.attribute_code)
8148: FROM jai_rgm_registrations jrr
8149: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8150: AND jrr.regime_id = (SELECT jrd.regime_id
8151: FROM jai_rgm_definitions jrd
8152: WHERE jrd.regime_code = jai_constants.service_regime)));
8153: CURSOR get_trx_st_no_cur

Line 8152: WHERE jrd.regime_code = jai_constants.service_regime)));

8148: FROM jai_rgm_registrations jrr
8149: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8150: AND jrr.regime_id = (SELECT jrd.regime_id
8151: FROM jai_rgm_definitions jrd
8152: WHERE jrd.regime_code = jai_constants.service_regime)));
8153: CURSOR get_trx_st_no_cur
8154: IS
8155: SELECT
8156: DISTINCT(st_inv_number)

Line 8321: IF(lv_return_code <> jai_constants.successful)THEN

8317: pn_customer_trx_line_id => ln_customer_trx_line_id,
8318: pv_return_code => lv_return_code,
8319: pv_return_message => lv_return_mess
8320: );
8321: IF(lv_return_code <> jai_constants.successful)THEN
8322: ov_return_code := lv_return_code;
8323: ov_return_message := lv_return_mess ;
8324:
8325: --pv_process_flag := lv_return_code;

Line 8342: IF(lv_return_code = jai_constants.expected_error)THEN

8338: pn_customer_trx_line_id => ln_customer_trx_line_id,
8339: pn_interface_line_id => ln_interface_line_id,
8340: p_process_flag => lv_return_code,
8341: p_process_message => lv_return_mess);
8342: IF(lv_return_code = jai_constants.expected_error)THEN
8343: ov_return_code := lv_return_code;
8344: ov_return_message := lv_return_mess ;
8345:
8346: --pv_process_flag := lv_return_code;

Line 8377: ov_return_code := jai_constants.unexpected_error;

8373:
8374: EXCEPTION
8375: WHEN OTHERS THEN
8376: lv_return_mess := 'PROCESSING Exception with SQLERR '||SUBSTR(SQLERRM,1,230) ||' in PROCESS_AR_UPDATING_LINES With interface_line_id:'||pn_interface_line_id||', at POS:'||ln_phase;
8377: ov_return_code := jai_constants.unexpected_error;
8378: ov_return_message := lv_return_mess ;
8379:
8380: RETURN;
8381:

Line 8427: IF(lv_return_code <> jai_constants.successful)THEN

8423: pn_customer_trx_id => pn_trx_id,
8424: ov_return_code => lv_return_code,
8425: ov_return_message => lv_return_message
8426: );
8427: IF(lv_return_code <> jai_constants.successful)THEN
8428: ov_return_code := lv_return_code ;
8429: ov_return_message := lv_return_message;
8430: RETURN;
8431: END IF;

Line 8442: IF(lv_return_code <> jai_constants.successful)THEN

8438: pn_customer_trx_id => pn_trx_id,
8439: ov_return_code => lv_return_code,
8440: ov_return_message => lv_return_message
8441: );
8442: IF(lv_return_code <> jai_constants.successful)THEN
8443: ov_return_code := lv_return_code ;
8444: ov_return_message := lv_return_message;
8445: RETURN;
8446: END IF;

Line 8457: IF(lv_return_code <> jai_constants.successful)THEN

8453: ov_return_code => lv_return_code,
8454: ov_return_message => lv_return_message
8455: );
8456:
8457: IF(lv_return_code <> jai_constants.successful)THEN
8458: ov_return_code := lv_return_code ;
8459: ov_return_message := lv_return_message;
8460: RETURN;
8461: END IF;

Line 8471: IF(lv_return_code <> jai_constants.successful)THEN

8467: pn_customer_trx_id => pn_trx_id,
8468: ov_return_code => lv_return_code,
8469: ov_return_message => lv_return_message
8470: );
8471: IF(lv_return_code <> jai_constants.successful)THEN
8472: ov_return_code := lv_return_code ;
8473: ov_return_message := lv_return_message;
8474: RETURN;
8475: END IF;

Line 8494: IF(lv_return_code <> jai_constants.successful)THEN

8490: pn_customer_trx_id => pn_trx_id,
8491: ov_return_code => lv_return_code,
8492: ov_return_message => lv_return_message
8493: );
8494: IF(lv_return_code <> jai_constants.successful)THEN
8495: ov_return_code := lv_return_code ;
8496: ov_return_message := lv_return_message;
8497: RETURN;
8498: END IF;

Line 8508: IF(lv_return_code <> jai_constants.successful)THEN

8504: ov_retcode => lv_return_code,
8505: ov_errbuf => lv_return_message,
8506: pn_customer_trx_id => pn_trx_id);
8507:
8508: IF(lv_return_code <> jai_constants.successful)THEN
8509: ov_return_code := lv_return_code ;
8510: ov_return_message := lv_return_message;
8511: RETURN;
8512: END IF;

Line 8526: ov_return_code := jai_constants.unexpected_error;

8522:
8523: EXCEPTION
8524: WHEN OTHERS THEN
8525: lv_return_message := 'PROCESSING Exception with SQLERR: '||SUBSTR(SQLERRM,1,230) ||' in PROCESS_AR_ACCOUNTING_LINES With internal_trx_id :'||pn_trx_id||', at POS:'||ln_phase;
8526: ov_return_code := jai_constants.unexpected_error;
8527: ov_return_message := lv_return_message ;
8528:
8529: RETURN;
8530:

Line 8800: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/

8796: , a.tax_rate
8797: , a.tax_amount
8798: , b.uom_code
8799: , b.end_date valid_date
8800: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
8801: '''||jai_constants.cgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8802: '''||jai_constants.sgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8803: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
8804: , ''ADDL. EXCISE'', 1

Line 8801: '''||jai_constants.cgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */

8797: , a.tax_amount
8798: , b.uom_code
8799: , b.end_date valid_date
8800: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
8801: '''||jai_constants.cgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8802: '''||jai_constants.sgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8803: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
8804: , ''ADDL. EXCISE'', 1
8805: , ''OTHER EXCISE'', 1

Line 8802: '''||jai_constants.sgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */

8798: , b.uom_code
8799: , b.end_date valid_date
8800: , DECODE(rttv.regime_code, '''||jai_constants.vat_regime||''', 4, /* added by ssumaith - bug# 4245053*/
8801: '''||jai_constants.cgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8802: '''||jai_constants.sgst_regime||''', 7, /* Added by Jia for GST Bug#10043656 on 2010/09/10 */
8803: DECODE(UPPER(b.tax_type), ''EXCISE'' , 1
8804: , ''ADDL. EXCISE'', 1
8805: , ''OTHER EXCISE'', 1
8806: , ''TDS'' , 2

Line 8808: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /bduvarag for the bug#5989740/ --modified by walton for inclusive tax

8804: , ''ADDL. EXCISE'', 1
8805: , ''OTHER EXCISE'', 1
8806: , ''TDS'' , 2
8807: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
8808: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
8809: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
8810: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
8811: , 0
8812: )

Line 8810: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /bduvarag for the bug#5989740/ --modified by walton for inclusive tax

8806: , ''TDS'' , 2
8807: , ''EXCISE_EDUCATION_CESS'',6 --modified by walton for inclusive tax
8808: , '''||JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
8809: , ''CVD_EDUCATION_CESS'' ,6 --modified by walton for inclusive tax
8810: , '''||JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS||''' , 6 /*bduvarag for the bug#5989740*/ --modified by walton for inclusive tax
8811: , 0
8812: )
8813: ) tax_type_val
8814: , b.mod_cr_percentage

Line 8873: ELSIF upper(p_source_trx_type) = jai_constants.G_AP_STANDALONE_INVOICE THEN

8869: );
8870:
8871: --For AP standalone, replace it with AP tax tables
8872: -----------------------------------------------------------
8873: ELSIF upper(p_source_trx_type) = jai_constants.G_AP_STANDALONE_INVOICE THEN
8874:
8875: lv_recalculation_sql :=
8876: REPLACE( lv_recalculation_sql
8877: , 'a.tax_amount'

Line 8893: jai_constants.G_AP_STANDALONE_INVOICE || ''''

8889: , '$$SOURCE_TABLE_FILTER$$'
8890: , 'a.SOURCE_DOC_LINE_ID = ' || p_line_id ||
8891: ' and SOURCE_DOC_ID = '|| p_header_id ||
8892: ' and SOURCE_DOC_TYPE ='''||
8893: jai_constants.G_AP_STANDALONE_INVOICE || ''''
8894: );
8895: END IF;
8896:
8897: /**

Line 9036: AND p_source_trx_type = jai_constants.ar_cash

9032: IF NVL(v_conversion_rate, 0) <= 0 THEN
9033:
9034: /* for cash receipt there will be no lines. sacsethi for 6012570 (5876390) */
9035: IF (p_uom_code IS NULL AND p_inventory_item_id IS NULL )
9036: AND p_source_trx_type = jai_constants.ar_cash
9037: THEN
9038: v_conversion_rate := 1;
9039: /*
9040: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)

Line 9044: AND p_source_trx_type IN (jai_constants.pa_draft_invoice

9040: Date 22-feb-2007 Added by SACSETHI for bug 6012570 (5876390)
9041: in This , Recalculation will be happen in Draft invoice
9042: */
9043: ELSIF (p_uom_code IS NULL AND p_inventory_item_id IS NULL )
9044: AND p_source_trx_type IN (jai_constants.pa_draft_invoice
9045: ,jai_constants.G_AP_STANDALONE_INVOICE)
9046: THEN
9047: v_conversion_rate := 0;
9048: ELSE

Line 9045: ,jai_constants.G_AP_STANDALONE_INVOICE)

9041: in This , Recalculation will be happen in Draft invoice
9042: */
9043: ELSIF (p_uom_code IS NULL AND p_inventory_item_id IS NULL )
9044: AND p_source_trx_type IN (jai_constants.pa_draft_invoice
9045: ,jai_constants.G_AP_STANDALONE_INVOICE)
9046: THEN
9047: v_conversion_rate := 0;
9048: ELSE
9049: v_conversion_rate := 0;

Line 9071: IF p_action = jai_constants.default_taxes

9067: END IF;
9068: row_count := row_count + 1;
9069:
9070: --added for bug#9214366, start
9071: IF p_action = jai_constants.default_taxes
9072: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs
9073: THEN
9074: tax_amt_tab(rec.lno) := 0;
9075: END IF;

Line 9072: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs

9068: row_count := row_count + 1;
9069:
9070: --added for bug#9214366, start
9071: IF p_action = jai_constants.default_taxes
9072: and p_thhold_cat_base_tax_typ = jai_constants.tax_type_tcs
9073: THEN
9074: tax_amt_tab(rec.lno) := 0;
9075: END IF;
9076: --bug#9214366, end

Line 11083: , p_source_trx_type => jai_constants.G_AP_STANDALONE_INVOICE

11079: , p_last_updated_by => FND_GLOBAL.user_id
11080: , p_last_update_login => FND_GLOBAL.login_id
11081: , p_operation_flag => NULL
11082: , p_vat_assessable_value => ln_line_amount--ln_vat_assessable_value
11083: , p_source_trx_type => jai_constants.G_AP_STANDALONE_INVOICE
11084: );
11085: ELSIF lv_module = 'AR' THEN
11086:
11087: OPEN ar_lines_cur(ln_header_id, ln_line_num);

Line 11247: , jai_constants.default_taxes--pv_action

11243: , 'INR'--pv_currency
11244: , ln_location_id
11245: , ln_invoice_id
11246: , ln_line_num
11247: , jai_constants.default_taxes--pv_action
11248: , ln_tax_category_id--, 0--pn_tax_category_id --Changed by zhiwei for Bug#12537533 on 20110510
11249: , 'N'--pv_tax_modified
11250: );
11251:

Line 11820: IF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AP) THEN

11816: IF lv_import_status = GV_IMPORT_SUCCESS THEN
11817:
11818: ln_phase := 90;
11819:
11820: IF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AP) THEN
11821:
11822: lv_import_process := GV_PROCESS_ACCOUNTING;
11823: process_ap_accounting_lines(ln_interface_line_id);
11824:

Line 11836: ELSIF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AR) THEN

11832: WHERE source_doc_id = ln_invoice_id
11833: AND source_doc_parent_line_no = ln_invoice_line_num);
11834: */
11835:
11836: ELSIF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AR) THEN
11837:
11838: lv_import_process := GV_PROCESS_UPDATING;
11839: process_ar_updating_lines(
11840: pn_interface_line_id => ln_interface_line_id,

Line 11846: IF(lv_return_code <> jai_constants.successful)THEN

11842: ov_return_message => lv_return_message
11843: );
11844:
11845:
11846: IF(lv_return_code <> jai_constants.successful)THEN
11847:
11848: ROLLBACK TO PROC_MAIN_SVP;
11849:
11850: lv_import_status := GV_IMPORT_FAILURE;

Line 11921: IF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AR) THEN

11917: -------------------------------------------------------------------------------
11918: BEGIN
11919: IF (lv_import_status = GV_IMPORT_SUCCESS) THEN
11920:
11921: IF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AR) THEN
11922:
11923: lv_import_process := GV_PROCESS_ACCOUNTING;
11924:
11925: ln_phase := 110;

Line 11933: IF(lv_return_code <> jai_constants.successful)THEN

11929: ov_return_code => lv_return_code,
11930: ov_return_message => lv_return_message
11931: );
11932:
11933: IF(lv_return_code <> jai_constants.successful)THEN
11934:
11935: ROLLBACK TO PROC_MAIN_SVP;
11936:
11937: lv_import_status := GV_IMPORT_FAILURE;

Line 11966: ELSIF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AP) THEN

11962:
11963: ln_phase := 120;
11964:
11965: update_trx_lines_status(rec_trx_id.trx_id, lv_import_status, lv_import_process );
11966: ELSIF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AP) THEN
11967:
11968: SELECT SUM(amount)
11969: INTO ln_total_amount
11970: FROM ap_invoice_lines_all