[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
201:
202: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
203:
204: BEGIN
205: pv_return_code := jai_constants.successful ;
206: v_customer_trx_line_id := pr_old.CUSTOMER_TRX_LINE_ID; --Ramananda for File.Sql.35
207: v_customer_trx_id := pr_old.CUSTOMER_TRX_ID; --Ramananda for File.Sql.35
208:
209: --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
262: CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
263: /* Added an exception block by Ramananda for bug#4570303 */
264: EXCEPTION
265: WHEN OTHERS THEN
266: Pv_return_code := jai_constants.unexpected_error;
267: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);
268: END ARD_T1 ;
269:
270: /*
369:
370: Removed the cursor sob_cur also.
371: */
372: BEGIN
373: pv_return_code := jai_constants.successful ;
374: /*------------------------------------------------------------------------------------------
375: FILENAME: JA_IN_AR_CM_LINES_INSERT_TRG.sql
376:
377: CHANGE HISTORY:
606: END IF;
607: /* Added an exception block by Ramananda for bug#4570303 */
608: EXCEPTION
609: WHEN OTHERS THEN
610: Pv_return_code := jai_constants.unexpected_error;
611: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
612: END ARI_T1 ;
613:
614: /*
1333:
1334: ln_legal_entity_id NUMBER ;
1335:
1336: BEGIN
1337: pv_return_code := jai_constants.successful ;
1338:
1339: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');
1340:
1341: OPEN cur_legal_entity_id ;
1394:
1395: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1396:
1397: BEGIN
1398: pv_return_code := jai_constants.successful ;
1399:
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1401: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1402: v_tax_amount :=0;
1436:
1437: IF V_REGISTER_CODE ='BOND_REG' THEN
1438:
1439: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1440: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1441: 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
1442: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1443: -- Date 23/02/2006 by sacsethi for bug 5228046
1444: -- precedence 6 to 10
1437: IF V_REGISTER_CODE ='BOND_REG' THEN
1438:
1439: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1440: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1441: 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
1442: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1443: -- Date 23/02/2006 by sacsethi for bug 5228046
1444: -- precedence 6 to 10
1445: INSERT INTO JAI_AR_TRX_TAX_LINES
2063: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2064:
2065: if v_register_code = 'BOND_REG' then
2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2067: 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
2068: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2069: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2070: /*
2071: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
2065: if v_register_code = 'BOND_REG' then
2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2067: 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
2068: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2069: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2070: /*
2071: This is not a discount line , so taxes can flow. In case it was discount , control would have never come here
2072: because of the return statement above.
2073: */
2199: close JA_SO_LINES_INFO;
2200:
2201: --end 5631784
2202: ln_tcs_exists := null;
2203: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
2204: , cp_cust_trx_line_id => v_customer_trx_line_id
2205: );
2206: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
2207: close c_chk_rgm_tax_exists ;
2207: close c_chk_rgm_tax_exists ;
2208: -- if ln_tcs_exists is not null then/*Bug 5684363 bduvarag*/
2209: if ln_tcs_exists > 0 then
2210: /* TCS type of tax is present */
2211: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2212: fetch c_get_regime_id into ln_tcs_regime_id;
2213: close c_get_regime_id;
2214: /* Find out what is the current slab */
2215: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2215: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2216: (
2217: p_regime_id => ln_tcs_regime_id
2218: , p_organization_id => ln_inv_orgn_id
2219: , p_party_type => jai_constants.party_type_customer
2220: , p_party_id => lr_trx_rec.customer_id
2221: , p_org_id => v_org_id
2222: , p_source_trx_date => lr_trx_rec.trx_date
2223: , p_threshold_slab_id => ln_threshold_slab_id
2224: , p_process_flag => lv_process_flag
2225: , p_process_message => lv_process_message
2226: );
2227:
2228: if lv_process_flag <> jai_constants.successful then
2229: app_exception.raise_exception
2230: (exception_type => 'APP'
2231: ,exception_code => -20275
2232: ,exception_text => lv_process_message
2241: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2242: , p_process_flag => lv_process_flag
2243: , p_process_message => lv_process_message
2244: );
2245: if lv_process_flag <> jai_constants.successful then
2246: app_exception.raise_exception
2247: (exception_type => 'APP'
2248: ,exception_code => -20275
2249: ,exception_text => lv_process_message
2260: from JAI_AR_TRX_TAX_LINES jrctt
2261: , JAI_CMN_TAXES_ALL jtc
2262: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
2263: and jrctt.tax_id = jtc.tax_id
2264: and jtc.tax_type = jai_constants.tax_type_tcs;
2265: /*
2266: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2267: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2268: || into the ja_in_so_picking_tax_lines table
2270: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2271: (
2272: p_source_trx_id => ''
2273: , p_source_trx_line_id => v_customer_trx_line_id
2274: , p_source_event => jai_constants.bill_only_invoice
2275: , p_action => jai_constants.default_taxes
2276: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2277: , p_tax_base_line_number => ln_base_line_no
2278: , p_last_line_number => ln_last_line_no
2271: (
2272: p_source_trx_id => ''
2273: , p_source_trx_line_id => v_customer_trx_line_id
2274: , p_source_event => jai_constants.bill_only_invoice
2275: , p_action => jai_constants.default_taxes
2276: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2277: , p_tax_base_line_number => ln_base_line_no
2278: , p_last_line_number => ln_last_line_no
2279: , p_currency_code => lr_trx_rec.invoice_currency_code
2287: , p_process_flag => lv_process_flag
2288: , p_process_message => lv_process_message
2289: );
2290:
2291: if lv_process_flag <> jai_constants.successful then
2292: app_exception.raise_exception
2293: (exception_type => 'APP'
2294: ,exception_code => -20275
2295: ,exception_text => lv_process_message
2402: ( p_ractl => pr_new
2403: , p_process_flag => lv_process_flag
2404: , p_process_message => lv_process_message
2405: );
2406: if lv_process_flag <> jai_constants.successful then
2407: app_exception.raise_exception
2408: (exception_type => 'APP'
2409: ,exception_code => -20275
2410: ,exception_text => lv_process_message
2411: );
2412: end if;
2413: end ;
2414: BEGIN
2415: pv_return_code := jai_constants.successful ;
2416: /*---------------------------------------------------------------------------------------------
2417: FILENAME: JA_IN_OE_AR_LINES_INSERT_TRG.sql CHANGE HISTORY:
2418: S.No Date Author and Details
2419: ---------------------------------------------------------------------------------------------
2634: Dependency due to this bug :-
2635: Functional dependency with jai_ar_rctla_ari_t8 trigger of jai_fin_t.sql (120.2)
2636:
2637: 34. 28-Jun-2007 CSahoo for bug#6155839, File Version 120.16
2638: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
2639: 35. 16-oCT-2007 CSahoo for bug#6498072, File Version 120.21
2640: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2641:
2642: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2694: v_add_excise_duty_amount := 0;
2695: v_oth_excise_duty_amount := 0;
2696: v_exist_flag := 0;
2697: v_source_name := 'Receivables India';
2698: v_category_name := jai_constants.je_category_rg_entry ; -- 'RG Register Data Entry' modified by csahoo for bug#6155839
2699: /* --Ramananda for File.Sql.35, end */
2700:
2701: ln_bill_only := 0;
2702: ln_legal_entity_id := get_legal_entity_id ;
3310: END IF; --5
3311:
3312: IF NVL(v_raise_error_flag,'N') = 'Y' THEN
3313: /* RAISE_APPLICATION_ERROR(-20120, 'NONE OF the Register Have Balances Greater OR Equal TO the Excisable Amount ->' || TO_CHAR(v_excise_diff));
3314: */ 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 ;
3315: END IF;
3316:
3317: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs */
3318: FETCH register_code_meaning_cur INTO v_meaning;
3344:
3345: IF v_start_number IS NOT NULL THEN --2
3346: IF NVL(v_start_number,0) >= NVL(v_end_number,0) AND v_end_number IS NOT NULL THEN
3347: /* RAISE_APPLICATION_ERROR(-20120, 'Excise Invoice NUMBER has been exhausted. ' ||
3348: ' 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. ' ||
3349: ' Increase END NUMBER OR enter fresh START NUMBER AND END NUMBER.' ; return ;
3350: END IF;
3351: v_exc_invoice_no := NVL(v_start_number,0);
3352: v_start_number := NVL(v_start_number,0) + NVL(v_jump_by,0);
3641: CLOSE duplicate_tax_lines_cur;
3642:
3643: IF NVL(v_tax_line_count,0) <> 1 THEN
3644: IF v_register_code ='BOND_REG' THEN
3645: 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
3646: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
3647: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
3648: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
3649: )/* following OR added by sriram - bug#3607101 */
3642:
3643: IF NVL(v_tax_line_count,0) <> 1 THEN
3644: IF v_register_code ='BOND_REG' THEN
3645: 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
3646: /*jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess added by CSahoo BUG#5989740*/
3647: IF (NVL(pr_new.Interface_line_attribute11,'0') = '0'
3648: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context))
3649: )/* following OR added by sriram - bug#3607101 */
3650: or
3926: FROM JAI_OM_OE_SO_LINES
3927: WHERE line_id = pr_new.interface_line_attribute6;
3928: lv_exists VARCHAR2(1);
3929: BEGIN
3930: pv_return_code := jai_constants.successful ;
3931: OPEN c_so_lines_exists ;
3932: FETCH c_so_lines_exists INTO lv_exists;
3933: IF c_so_lines_exists%NOTFOUND THEN
3934: CLOSE c_so_lines_exists;
4118: WHEN OTHERS THEN
4119: vsqlerrm := SQLERRM;
4120:
4121: /* Added an exception block by Ramananda for bug#4570303 */
4122: Pv_return_code := jai_constants.unexpected_error;
4123: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 ' || substr(sqlerrm,1,1900);
4124:
4125: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4126: lv_err_msg := 'EXCEPTION Occured' ;
4370: /*
4371: || End of bug4567935 (115 bug4404898)
4372: */
4373: BEGIN
4374: pv_return_code := jai_constants.successful ;
4375: /*------------------------------------------------------------------------------------------
4376: FILENAME: JA_IN_RMA_AR_LINES_INSERT_TRG.sql
4377:
4378: CHANGE HISTORY:
4828: WHERE customer_trx_id = v_header_id;
4829: /* Added an exception block by Ramananda for bug#4570303 */
4830: EXCEPTION
4831: WHEN OTHERS THEN
4832: Pv_return_code := jai_constants.unexpected_error;
4833: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 ' || substr(sqlerrm,1,1900);
4834: END ARI_T3 ;
4835:
4836: /*
4897: is
4898: select gl_date
4899: from ra_cust_trx_line_gl_dist_all
4900: where customer_trx_id = cp_customer_trx_id
4901: and account_class = jai_constants.account_class_rec
4902: and latest_rec_flag = jai_constants.yes;
4903:
4904: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
4905: IS
4898: select gl_date
4899: from ra_cust_trx_line_gl_dist_all
4900: where customer_trx_id = cp_customer_trx_id
4901: and account_class = jai_constants.account_class_rec
4902: and latest_rec_flag = jai_constants.yes;
4903:
4904: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
4905: IS
4906: SELECT REGIME_ID
5040: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
5043: BEGIN
5044: pv_return_code := jai_constants.successful ;
5045: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
5046:
5047: /*------------------------------------------------------------------------------------------
5048: FILENAME: JA_IN_AR_LINES_INSERT_TRG.sql
5324: );
5325: v_line_tax_amount := nvl(v_line_amount,0);
5326: -- Date 26-feb-2006 added by sacsethi for bug 5631784
5327: open gc_chk_rgm_tax_exists
5328: ( cp_regime_code => jai_constants.tcs_regime
5329: , cp_rgm_tax_type => jai_constants.tax_type_tcs
5330: , cp_tax_category_id => v_tax_category_id
5331: );
5332: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
5325: v_line_tax_amount := nvl(v_line_amount,0);
5326: -- Date 26-feb-2006 added by sacsethi for bug 5631784
5327: open gc_chk_rgm_tax_exists
5328: ( cp_regime_code => jai_constants.tcs_regime
5329: , cp_rgm_tax_type => jai_constants.tax_type_tcs
5330: , cp_tax_category_id => v_tax_category_id
5331: );
5332: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
5333: close gc_chk_rgm_tax_exists;
5332: fetch gc_chk_rgm_tax_exists into ln_tcs_exists;
5333: close gc_chk_rgm_tax_exists;
5334: if ln_tcs_exists > 0 then
5335: /** TCS type of tax(s) are present */
5336: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);
5337: fetch gc_get_regime_id into ln_tcs_regime_id;
5338: close gc_get_regime_id;
5339:
5340: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5339:
5340: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5341: ( p_regime_id => ln_tcs_regime_id
5342: , p_organization_id => v_organization_id
5343: , p_party_type => jai_constants.party_type_customer
5344: , p_party_id => v_customer_id
5345: , p_org_id => v_org_id
5346: , p_source_trx_date => ld_trx_date /* ssumaith - bug# 6109941*/
5347: , p_threshold_slab_id => ln_threshold_slab_id
5348: , p_process_flag => lv_process_flag
5349: , p_process_message => lv_process_message
5350: );
5351:
5352: if lv_process_flag <> jai_constants.successful then
5353: app_exception.raise_exception
5354: (exception_type => 'APP'
5355: ,exception_code => -20275
5356: ,exception_text => lv_process_message
5367: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5368: , p_process_flag => lv_process_flag
5369: , p_process_message => lv_process_message
5370: );
5371: if lv_process_flag <> jai_constants.successful then
5372: app_exception.raise_exception
5373: (exception_type => 'APP'
5374: ,exception_code => -20275
5375: ,exception_text => lv_process_message
5396: v_last_updated_by ,
5397: v_last_update_login,
5398: NULL,
5399: ln_vat_assessable_value, /* added by ssumaith - bug# 4245053*/
5400: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs , -- Date 26-feb-2006 added by sacsethi for bug 5631784
5401: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5402: p_source_trx_type => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5403: p_source_table_name => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5404: p_action => jai_constants.default_taxes-- Date 26-feb-2006 added by sacsethi for bug 5631784
5400: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs , -- Date 26-feb-2006 added by sacsethi for bug 5631784
5401: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5402: p_source_trx_type => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5403: p_source_table_name => null,-- Date 26-feb-2006 added by sacsethi for bug 5631784
5404: p_action => jai_constants.default_taxes-- Date 26-feb-2006 added by sacsethi for bug 5631784
5405: );
5406: END IF;
5407: v_excise := 0;
5408: v_additional := 0;
5497: VAR_SQLERRM := 'EXCEPTION OCCURED - ' || SQLERRM;
5498: VAR_SQLERRM := SUBSTR(VAR_SQLERRM,1,235);
5499:
5500: /* Added an exception block by Ramananda for bug#4570303 */
5501: Pv_return_code := jai_constants.unexpected_error;
5502: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
5503:
5504: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
5505: 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) ;
5645: Removed the reference to cursor set_of_books_cur
5646: as the SOB will never be null in base table.
5647: */
5648: BEGIN
5649: pv_return_code := jai_constants.successful ;
5650: /*------------------------------------------------------------------------------------------
5651: FILENAME: JA_IN_AR_CM_LINES_UPDATE_TRG.sql
5652:
5653: CHANGE HISTORY:
5986: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
5987: ld_trx_date DATE;
5988:
5989: BEGIN
5990: pv_return_code := jai_constants.successful ;
5991: /*------------------------------------------------------------------------------------------
5992: FILENAME: JA_IN_AR_LINES_UPDATE_TRG.sql
5993:
5994: CHANGE HISTORY:
6320: AND customer_trx_id = v_header_id;
6321: /* Added an exception block by Ramananda for bug#4570303 */
6322: EXCEPTION
6323: WHEN OTHERS THEN
6324: Pv_return_code := jai_constants.unexpected_error;
6325: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
6326: END ARU_T2 ;
6327:
6328: /* following procedure added by cbabu for bug#6012570 (5876390) */
6743: ||passed as parameters.
6744: */
6745:
6746: BEGIN
6747: IF pv_party_type = jai_constants.party_type_customer THEN
6748:
6749: OPEN c_get_address;
6750: FETCH c_get_address INTO ln_address_id;
6751: CLOSE c_get_address;
6761: CLOSE cur_get_ser_type_customer;
6762:
6763: END IF;
6764:
6765: ELSIF pv_party_type = jai_constants.party_type_vendor THEN
6766:
6767: OPEN cur_get_ser_type_vendor(pn_party_id, pn_party_site_id);
6768: FETCH cur_get_ser_type_vendor INTO v_service_type;
6769: CLOSE cur_get_ser_type_vendor;