[Home] [Help]
25:
26: 3 26/04/2007 CSahoo for bug#5989740 File Version 120.12
27: Forward porting of 11i BUG#5907436
28: ENH: Handling Secondary and Higher Education Cess
29: Added the new cess types jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess
30:
31: 4. 27/04/2007 CSahoo for bug#5879769, File Version 120.12
32: Forward porting of 11i bug#5694855
33: Added a function get_service_type to get the service_type_code
227:
228: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
229:
230: BEGIN
231: pv_return_code := jai_constants.successful ;
232: v_customer_trx_line_id := pr_old.CUSTOMER_TRX_LINE_ID; --Ramananda for File.Sql.35
233: v_customer_trx_id := pr_old.CUSTOMER_TRX_ID; --Ramananda for File.Sql.35
234:
235: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_AR_LINES_DELETE_TRG', P_ORG_ID => pr_old.ORG_ID) = false then
288: CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
289: /* Added an exception block by Ramananda for bug#4570303 */
290: EXCEPTION
291: WHEN OTHERS THEN
292: Pv_return_code := jai_constants.unexpected_error;
293: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);
294: END ARD_T1 ;
295:
296: /*
395:
396: Removed the cursor sob_cur also.
397: */
398: BEGIN
399: pv_return_code := jai_constants.successful ;
400: /*------------------------------------------------------------------------------------------
401: FILENAME: JA_IN_AR_CM_LINES_INSERT_TRG.sql
402:
403: CHANGE HISTORY:
632: END IF;
633: /* Added an exception block by Ramananda for bug#4570303 */
634: EXCEPTION
635: WHEN OTHERS THEN
636: Pv_return_code := jai_constants.unexpected_error;
637: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
638: END ARI_T1 ;
639:
640: /*
1418:
1419:
1420:
1421: BEGIN
1422: pv_return_code := jai_constants.successful ;
1423:
1424: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');
1425:
1426: OPEN cur_legal_entity_id ;
1480: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1481: /* Added by JMEENA for bug#6391684 (FP 6061010 )*/
1482: ln_hdr_exist_chk number;
1483: BEGIN
1484: pv_return_code := jai_constants.successful ;
1485:
1486: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1488: v_tax_amount :=0;
1522:
1523: IF V_REGISTER_CODE ='BOND_REG' THEN
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1526: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1527: 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
1528: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1529: -- Date 23/02/2006 by sacsethi for bug 5228046
1530: -- precedence 6 to 10
1523: IF V_REGISTER_CODE ='BOND_REG' THEN
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1526: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1527: 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
1528: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1529: -- Date 23/02/2006 by sacsethi for bug 5228046
1530: -- precedence 6 to 10
1531: INSERT INTO JAI_AR_TRX_TAX_LINES
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2274:
2275: if v_register_code = 'BOND_REG' then
2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2277: 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
2278: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2279: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2280: /*
2281: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
2275: if v_register_code = 'BOND_REG' then
2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2277: 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
2278: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2279: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2280: /*
2281: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
2282: because of the return statement above.
2283: */
2409: close JA_SO_LINES_INFO;
2410:
2411: --end 5631784
2412: ln_tcs_exists := null;
2413: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
2414: , cp_cust_trx_line_id => v_customer_trx_line_id
2415: );
2416: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
2417: close c_chk_rgm_tax_exists ;
2417: close c_chk_rgm_tax_exists ;
2418: -- if ln_tcs_exists is not null then/*Bug 5684363 bduvarag*/
2419: if ln_tcs_exists > 0 then
2420: /* TCS type of tax is present */
2421: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2422: fetch c_get_regime_id into ln_tcs_regime_id;
2423: close c_get_regime_id;
2424: /* Find out what is the current slab */
2425: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2425: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2426: (
2427: p_regime_id => ln_tcs_regime_id
2428: , p_organization_id => ln_inv_orgn_id
2429: , p_party_type => jai_constants.party_type_customer
2430: , p_party_id => lr_trx_rec.customer_id
2431: , p_org_id => v_org_id
2432: , p_source_trx_date => lr_trx_rec.trx_date
2433: , p_threshold_slab_id => ln_threshold_slab_id
2434: , p_process_flag => lv_process_flag
2435: , p_process_message => lv_process_message
2436: );
2437:
2438: if lv_process_flag <> jai_constants.successful then
2439: app_exception.raise_exception
2440: (exception_type => 'APP'
2441: ,exception_code => -20275
2442: ,exception_text => lv_process_message
2451: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2452: , p_process_flag => lv_process_flag
2453: , p_process_message => lv_process_message
2454: );
2455: if lv_process_flag <> jai_constants.successful then
2456: app_exception.raise_exception
2457: (exception_type => 'APP'
2458: ,exception_code => -20275
2459: ,exception_text => lv_process_message
2470: from JAI_AR_TRX_TAX_LINES jrctt
2471: , JAI_CMN_TAXES_ALL jtc
2472: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
2473: and jrctt.tax_id = jtc.tax_id
2474: and jtc.tax_type = jai_constants.tax_type_tcs;
2475: /*
2476: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2477: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2478: || into the ja_in_so_picking_tax_lines table
2480: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2481: (
2482: p_source_trx_id => ''
2483: , p_source_trx_line_id => v_customer_trx_line_id
2484: , p_source_event => jai_constants.bill_only_invoice
2485: , p_action => jai_constants.default_taxes
2486: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2487: , p_tax_base_line_number => ln_base_line_no
2488: , p_last_line_number => ln_last_line_no
2481: (
2482: p_source_trx_id => ''
2483: , p_source_trx_line_id => v_customer_trx_line_id
2484: , p_source_event => jai_constants.bill_only_invoice
2485: , p_action => jai_constants.default_taxes
2486: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2487: , p_tax_base_line_number => ln_base_line_no
2488: , p_last_line_number => ln_last_line_no
2489: , p_currency_code => lr_trx_rec.invoice_currency_code
2497: , p_process_flag => lv_process_flag
2498: , p_process_message => lv_process_message
2499: );
2500:
2501: if lv_process_flag <> jai_constants.successful then
2502: app_exception.raise_exception
2503: (exception_type => 'APP'
2504: ,exception_code => -20275
2505: ,exception_text => lv_process_message
2612: ( p_ractl => pr_new
2613: , p_process_flag => lv_process_flag
2614: , p_process_message => lv_process_message
2615: );
2616: if lv_process_flag <> jai_constants.successful then
2617: app_exception.raise_exception
2618: (exception_type => 'APP'
2619: ,exception_code => -20275
2620: ,exception_text => lv_process_message
2621: );
2622: end if;
2623: end ;
2624: BEGIN
2625: pv_return_code := jai_constants.successful ;
2626: /*---------------------------------------------------------------------------------------------
2627: FILENAME: JA_IN_OE_AR_LINES_INSERT_TRG.sql CHANGE HISTORY:
2628: S.No Date Author and Details
2629: ---------------------------------------------------------------------------------------------
2844: Dependency due to this bug :-
2845: Functional dependency with jai_ar_rctla_ari_t8 trigger of jai_fin_t.sql (120.2)
2846:
2847: 34. 28-Jun-2007 CSahoo for bug#6155839, File Version 120.16
2848: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
2849: 35. 16-oCT-2007 CSahoo for bug#6498072, File Version 120.21
2850: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2851:
2852: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2952: v_add_excise_duty_amount := 0;
2953: v_oth_excise_duty_amount := 0;
2954: v_exist_flag := 0;
2955: v_source_name := 'Receivables India';
2956: v_category_name := jai_constants.je_category_rg_entry ; -- 'RG Register Data Entry' modified by csahoo for bug#6155839
2957: /* --Ramananda for File.Sql.35, end */
2958:
2959: ln_bill_only := 0;
2960: ln_bill_return := 0; --added by abezgam for bug#10176878
3571: END IF; --5
3572:
3573: IF NVL(v_raise_error_flag,'N') = 'Y' THEN
3574: /* RAISE_APPLICATION_ERROR(-20120, 'NONE OF the Register Have Balances Greater OR Equal TO the Excisable Amount ->' || TO_CHAR(v_excise_diff));
3575: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'NONE OF the Register Have Balances Greater OR Equal TO the Excisable Amount ->' || TO_CHAR(v_excise_diff) ; return ;
3576: END IF;
3577:
3578: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs */
3579: FETCH register_code_meaning_cur INTO v_meaning;
3605:
3606: IF v_start_number IS NOT NULL THEN --2
3607: IF NVL(v_start_number,0) >= NVL(v_end_number,0) AND v_end_number IS NOT NULL THEN
3608: /* RAISE_APPLICATION_ERROR(-20120, 'Excise Invoice NUMBER has been exhausted. ' ||
3609: ' Increase END NUMBER OR enter fresh START NUMBER AND END NUMBER.'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Excise Invoice NUMBER has been exhausted. ' ||
3610: ' Increase END NUMBER OR enter fresh START NUMBER AND END NUMBER.' ; return ;
3611: END IF;
3612: v_exc_invoice_no := NVL(v_start_number,0);
3613: v_start_number := NVL(v_start_number,0) + NVL(v_jump_by,0);
3926: CLOSE duplicate_tax_lines_cur;
3927:
3928: IF NVL(v_tax_line_count,0) <> 1 THEN
3929: IF v_register_code ='BOND_REG' THEN
3930: 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
3931: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
3932: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
3933: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
3934: )/* following OR added by sriram - bug#3607101 */
3927:
3928: IF NVL(v_tax_line_count,0) <> 1 THEN
3929: IF v_register_code ='BOND_REG' THEN
3930: 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
3931: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
3932: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
3933: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
3934: )/* following OR added by sriram - bug#3607101 */
3935: or
4232: FROM JAI_OM_OE_SO_LINES
4233: WHERE line_id = pr_new.interface_line_attribute6;
4234: lv_exists VARCHAR2(1);
4235: BEGIN
4236: pv_return_code := jai_constants.successful ;
4237: OPEN c_so_lines_exists ;
4238: FETCH c_so_lines_exists INTO lv_exists;
4239: IF c_so_lines_exists%NOTFOUND THEN
4240: CLOSE c_so_lines_exists;
4449: WHEN OTHERS THEN
4450: vsqlerrm := SQLERRM;
4451:
4452: /* Added an exception block by Ramananda for bug#4570303 */
4453: Pv_return_code := jai_constants.unexpected_error;
4454: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 ' || substr(sqlerrm,1,1900);
4455:
4456: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4457: lv_err_msg := 'EXCEPTION Occured' ;
4997: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
4998:
4999: if lv_register_code = 'BOND_REG' then
5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);
5001: 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
5002: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
5003: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
5004: /*
5005: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
4999: if lv_register_code = 'BOND_REG' then
5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);
5001: 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
5002: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
5003: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
5004: /*
5005: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
5006: because of the return statement above.
5007: */
5137: close SO_RMA_TAX_LINES_INFO;
5138:
5139: --end 5631784
5140: ln_tcs_exists := null;
5141: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
5142: , cp_cust_trx_line_id => v_customer_trx_line_id
5143: );
5144: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
5145: close c_chk_rgm_tax_exists ;
5145: close c_chk_rgm_tax_exists ;
5146: -- if ln_tcs_exists is not null then/*Bug 5684363 bduvarag*/
5147: if ln_tcs_exists > 0 then
5148: /* TCS type of tax is present */
5149: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
5150: fetch c_get_regime_id into ln_tcs_regime_id;
5151: close c_get_regime_id;
5152: /* Find out what is the current slab */
5153: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5153: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5154: (
5155: p_regime_id => ln_tcs_regime_id
5156: , p_organization_id => ln_inv_orgn_id
5157: , p_party_type => jai_constants.party_type_customer
5158: , p_party_id => lr_trx_rec.customer_id
5159: , p_org_id => pr_new.org_id
5160: , p_source_trx_date => lr_trx_rec.trx_date
5161: , p_threshold_slab_id => ln_threshold_slab_id
5162: , p_process_flag => lv_process_flag
5163: , p_process_message => lv_process_message
5164: );
5165:
5166: if lv_process_flag <> jai_constants.successful then
5167: app_exception.raise_exception
5168: (exception_type => 'APP'
5169: ,exception_code => -20275
5170: ,exception_text => lv_process_message
5179: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5180: , p_process_flag => lv_process_flag
5181: , p_process_message => lv_process_message
5182: );
5183: if lv_process_flag <> jai_constants.successful then
5184: app_exception.raise_exception
5185: (exception_type => 'APP'
5186: ,exception_code => -20275
5187: ,exception_text => lv_process_message
5198: from JAI_AR_TRX_TAX_LINES jrctt
5199: , JAI_CMN_TAXES_ALL jtc
5200: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
5201: and jrctt.tax_id = jtc.tax_id
5202: and jtc.tax_type = jai_constants.tax_type_tcs;
5203: /*
5204: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
5205: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
5206: || into the ja_in_so_picking_tax_lines table
5208: jai_rgm_thhold_proc_pkg.default_thhold_taxes
5209: (
5210: p_source_trx_id => ''
5211: , p_source_trx_line_id => v_customer_trx_line_id
5212: , p_source_event => jai_constants.bill_only_invoice
5213: , p_action => jai_constants.default_taxes
5214: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5215: , p_tax_base_line_number => ln_base_line_no
5216: , p_last_line_number => ln_last_line_no
5209: (
5210: p_source_trx_id => ''
5211: , p_source_trx_line_id => v_customer_trx_line_id
5212: , p_source_event => jai_constants.bill_only_invoice
5213: , p_action => jai_constants.default_taxes
5214: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5215: , p_tax_base_line_number => ln_base_line_no
5216: , p_last_line_number => ln_last_line_no
5217: , p_currency_code => lr_trx_rec.invoice_currency_code
5225: , p_process_flag => lv_process_flag
5226: , p_process_message => lv_process_message
5227: );
5228:
5229: if lv_process_flag <> jai_constants.successful then
5230: app_exception.raise_exception
5231: (exception_type => 'APP'
5232: ,exception_code => -20275
5233: ,exception_text => lv_process_message
5311: ( p_ractl => pr_new
5312: , p_process_flag => lv_process_flag
5313: , p_process_message => lv_process_message
5314: );
5315: if lv_process_flag <> jai_constants.successful then
5316: app_exception.raise_exception
5317: (exception_type => 'APP'
5318: ,exception_code => -20275
5319: ,exception_text => lv_process_message
5324: /* End of the changes by abezgam for the bug 10176878*/
5325:
5326:
5327: BEGIN
5328: pv_return_code := jai_constants.successful ;
5329: /*------------------------------------------------------------------------------------------
5330: FILENAME: JA_IN_RMA_AR_LINES_INSERT_TRG.sql
5331:
5332: CHANGE HISTORY:
5635:
5636: /*Start additions by mmurtuza for bug 14475132*/
5637: IF lv_register_code ='BOND_REG' THEN
5638: -- Added 'Addl. Excise' in below NOT IN clause for the bug 16014871
5639: IF tax_rec.tax_type NOT IN ('Excise','Other Excise','Addl. Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
5640: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
5641: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
5642: )
5643: or
5929: WHERE customer_trx_id = v_header_id;
5930: /* Added an exception block by Ramananda for bug#4570303 */
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: Pv_return_code := jai_constants.unexpected_error;
5934: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 ' || substr(sqlerrm,1,1900);
5935: END ARI_T3 ;
5936:
5937:
6028: WHERE hl.location_id = jcio.location_id
6029: AND jcio.organization_id = pr_new.warehouse_id;
6030:
6031: BEGIN
6032: pv_return_code := jai_constants.successful ;
6033: /*------------------------------------------------------------------------------------------
6034: FILENAME: JA_IN_RMA_AR_LINES_INSERT_TRG.sql
6035:
6036: CHANGE HISTORY:
6126: v_last_update_login,
6127: ln_legal_entity_id /* rallamse bug#4448789 */
6128: );
6129: ELSE
6130: Pv_return_code := jai_constants.expected_error;
6131: Pv_return_message := 'WAREHOUSE_ID Should not be null in the interface table' ;
6132: RETURN;
6133: END IF;
6134: END IF;
6189: WHERE customer_trx_id = v_header_id;
6190:
6191: EXCEPTION
6192: WHEN OTHERS THEN
6193: Pv_return_code := jai_constants.unexpected_error;
6194: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T4 ' || substr(sqlerrm,1,1900);
6195: END ;
6196:
6197: ------------------------------------------------------------------------------------------
6269: is
6270: select gl_date
6271: from ra_cust_trx_line_gl_dist_all
6272: where customer_trx_id = cp_customer_trx_id
6273: and account_class = jai_constants.account_class_rec
6274: and latest_rec_flag = jai_constants.yes;
6275:
6276: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
6277: IS
6270: select gl_date
6271: from ra_cust_trx_line_gl_dist_all
6272: where customer_trx_id = cp_customer_trx_id
6273: and account_class = jai_constants.account_class_rec
6274: and latest_rec_flag = jai_constants.yes;
6275:
6276: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
6277: IS
6278: SELECT REGIME_ID
6421: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
6422: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
6423: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
6424: BEGIN
6425: pv_return_code := jai_constants.successful ;
6426: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
6427:
6428: /*------------------------------------------------------------------------------------------
6429: FILENAME: JA_IN_AR_LINES_INSERT_TRG.sql
6674: */
6675: --Added by Xiao Lv for bug 10091373, ends
6676:
6677: open gc_chk_rgm_tax_exists
6678: ( cp_regime_code => jai_constants.tcs_regime
6679: , cp_rgm_tax_type => jai_constants.tax_type_tcs
6680: , cp_tax_category_id => v_tax_category_id
6681: );
6682: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
6675: --Added by Xiao Lv for bug 10091373, ends
6676:
6677: open gc_chk_rgm_tax_exists
6678: ( cp_regime_code => jai_constants.tcs_regime
6679: , cp_rgm_tax_type => jai_constants.tax_type_tcs
6680: , cp_tax_category_id => v_tax_category_id
6681: );
6682: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
6683: close gc_chk_rgm_tax_exists;
6776: );
6777: v_line_tax_amount := nvl(v_line_amount,0);
6778: -- Date 26-feb-2006 added by sacsethi for bug 5631784
6779: /* open gc_chk_rgm_tax_exists
6780: ( cp_regime_code => jai_constants.tcs_regime
6781: , cp_rgm_tax_type => jai_constants.tax_type_tcs
6782: , cp_tax_category_id => v_tax_category_id
6783: );
6784: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
6777: v_line_tax_amount := nvl(v_line_amount,0);
6778: -- Date 26-feb-2006 added by sacsethi for bug 5631784
6779: /* open gc_chk_rgm_tax_exists
6780: ( cp_regime_code => jai_constants.tcs_regime
6781: , cp_rgm_tax_type => jai_constants.tax_type_tcs
6782: , cp_tax_category_id => v_tax_category_id
6783: );
6784: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
6785: close gc_chk_rgm_tax_exists;
6785: close gc_chk_rgm_tax_exists;
6786: if ln_tcs_exists > 0 then Commented by nprashar for TCS issue # 9489145 */
6787: /** TCS type of tax(s) are present */
6788: If v_num_check = 1 then /*Added by nprashar for TCS for bug # 9489145*/
6789: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);
6790: fetch gc_get_regime_id into ln_tcs_regime_id;
6791: close gc_get_regime_id;
6792:
6793: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
6792:
6793: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
6794: ( p_regime_id => ln_tcs_regime_id
6795: , p_organization_id => v_organization_id
6796: , p_party_type => jai_constants.party_type_customer
6797: , p_party_id => v_customer_id
6798: , p_org_id => v_org_id
6799: , p_source_trx_date => ld_trx_date /* ssumaith - bug# 6109941*/
6800: , p_threshold_slab_id => ln_threshold_slab_id
6801: , p_process_flag => lv_process_flag
6802: , p_process_message => lv_process_message
6803: );
6804:
6805: if lv_process_flag <> jai_constants.successful then
6806: app_exception.raise_exception
6807: (exception_type => 'APP'
6808: ,exception_code => -20275
6809: ,exception_text => lv_process_message
6820: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
6821: , p_process_flag => lv_process_flag
6822: , p_process_message => lv_process_message
6823: );
6824: if lv_process_flag <> jai_constants.successful then
6825: app_exception.raise_exception
6826: (exception_type => 'APP'
6827: ,exception_code => -20275
6828: ,exception_text => lv_process_message
6849: v_last_updated_by ,
6850: v_last_update_login,
6851: NULL,
6852: ln_vat_assessable_value, /* added by ssumaith - bug# 4245053*/
6853: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs , -- Date 26-feb-2006 added by sacsethi for bug 5631784
6854: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6855: p_source_trx_type => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6856: p_source_table_name => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6857: p_action => jai_constants.default_taxes-- Date 26-feb-2006 added by sacsethi for bug 5631784
6853: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs , -- Date 26-feb-2006 added by sacsethi for bug 5631784
6854: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6855: p_source_trx_type => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6856: p_source_table_name => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
6857: p_action => jai_constants.default_taxes-- Date 26-feb-2006 added by sacsethi for bug 5631784
6858: -- , pn_gst_assessable_value => ln_gst_assessable_value -- Added by Jia for GST Bug#10091373 on 2010/09/10
6859: );
6860: END IF;
6861: v_excise := 0;
6953: VAR_SQLERRM := 'EXCEPTION OCCURED - ' || SQLERRM;
6954: VAR_SQLERRM := SUBSTR(VAR_SQLERRM,1,235);
6955:
6956: /* Added an exception block by Ramananda for bug#4570303 */
6957: Pv_return_code := jai_constants.unexpected_error;
6958: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
6959:
6960: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
6961: lv_add_err := 'CUSTOMER_TRX_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_ID) || ' CUSTOMER_TRX_LINE_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_LINE_ID) ;
7101: Removed the reference to cursor set_of_books_cur
7102: as the SOB will never be null in base table.
7103: */
7104: BEGIN
7105: pv_return_code := jai_constants.successful ;
7106: /*------------------------------------------------------------------------------------------
7107: FILENAME: JA_IN_AR_CM_LINES_UPDATE_TRG.sql
7108:
7109: CHANGE HISTORY:
7445: --ln_gst_assessable_value JAI_AR_TRX_LINES.GST_ASSESSABLE_VALUE%TYPE;--Added by Xiao Lv for bug 10091373
7446: ld_trx_date DATE;
7447:
7448: BEGIN
7449: pv_return_code := jai_constants.successful ;
7450: /*------------------------------------------------------------------------------------------
7451: FILENAME: JA_IN_AR_LINES_UPDATE_TRG.sql
7452:
7453: CHANGE HISTORY:
7817: AND customer_trx_id = v_header_id;
7818: /* Added an exception block by Ramananda for bug#4570303 */
7819: EXCEPTION
7820: WHEN OTHERS THEN
7821: Pv_return_code := jai_constants.unexpected_error;
7822: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
7823: END ARU_T2 ;
7824:
7825: /* following procedure added by cbabu for bug#6012570 (5876390) */
8240: ||passed as parameters.
8241: */
8242:
8243: BEGIN
8244: IF pv_party_type = jai_constants.party_type_customer THEN
8245:
8246: OPEN c_get_address;
8247: FETCH c_get_address INTO ln_address_id;
8248: CLOSE c_get_address;
8258: CLOSE cur_get_ser_type_customer;
8259:
8260: END IF;
8261:
8262: ELSIF pv_party_type = jai_constants.party_type_vendor THEN
8263:
8264: OPEN cur_get_ser_type_vendor(pn_party_id, pn_party_site_id);
8265: FETCH cur_get_ser_type_vendor INTO v_service_type;
8266: CLOSE cur_get_ser_type_vendor;