[Home] [Help]
1: PACKAGE BODY jai_cmn_tax_defaultation_pkg AS
2: /* $Header: jai_cmn_tax_dflt.plb 120.13.12010000.2 2008/11/21 12:11:01 jmeena ship $ */
3:
4:
5: PROCEDURE ja_in_cust_default_taxes (
16: v_tax_category_list VARCHAR2(30);
17: v_tax_category_id NUMBER;
18:
19: /* Added by Ramananda for bug#4407165 */
20: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes';
21:
22: -- to get address_id
23: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
24: SELECT cust_acct_site_id address_id
114: v_tax_category_list VARCHAR2(30);
115: v_tax_category_id NUMBER;
116:
117: /* Added by Ramananda for bug#4407165 */
118: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes';
119:
120: -- to get tax_category_list
121: CURSOR tax_catg_list_cur(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER DEFAULT 0) IS
122: SELECT tax_category_list
211: The trigger ja_in_oe_order_lines_aiu_trg raises an error of warehouse not found when the value of warehouse_id goes as
212: null from the form.
213:
214: Solution:-
215: Removed this part from the trigger ja_in_oe_order_lines_aiu_trg. The procedure jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes has been modified
216: for the same.
217: During tax defaultation, if the tax category list is not found in the customer/customer site level then it is being picked up from the
218: item class level. Now in cases where the warehouseid is left blank in the base apps sales order form, the tax category id from the
219: master organization set for the default operating unit is picked up for further processing
235: 5. 01-08-2007 rchandan for bug#6030615 , Version 120.10
236: Issue : Inter org Forward porting
237: ----------------------------------------------------------------------------------------------------------------------------------------------------*/
238: /* Added by Ramananda for bug#4407165 */
239: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes';
240:
241:
242: --Code Added on 18-SEP-2000, Srihari and Gsrinivas
243: v_operating_unit NUMBER;
374: ln_vat_assessable_value NUMBER;
375: -----------------------------------------------
376:
377: /* Added by Ramananda for bug#4407165 */
378: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes';
379:
380: p1 NUM_TAB;
381: p2 NUM_TAB;
382: p3 NUM_TAB;
661:
662: ----------------------------------------------------------------------------------------------------------------------------------------------------
663: Current Version Current Bug Dependent Files Version Author Date Remarks
664: Of File On Bug/Patchset Dependent On
665: jai_cmn_tax_defaultation_pkg.sql
666: ----------------------------------------------------------------------------------------------------------------------------------------------------
667: 115.1 2977185 IN60105D2 None -- Aiyer 13/07/2004 Row introduces to start dependency tracking
668:
669: 115.3 4245053 IN60106 + ssumaith Service Tax and VAT Infrastructure are created
1507: base_tax_amt_tab(I) := vamt;
1508: tax_target_tab(I) := vamt;
1509:
1510: --------------------------------------------------------------------------------------
1511: /*Change History: jai_cmn_tax_defaultation_pkg
1512: Last Modified By Jagdish Bhosle. 2001/04/05
1513: The follow check will ensure that for Bond reg. Txns
1514: excise duty will not be added to original Line amount. */
1515: --------------------------------------------------------------------------------------
2358: base_tax_amt_tab(I) := vamt;
2359: tax_target_tab(I) := vamt;
2360:
2361: --------------------------------------------------------------------------------------
2362: /*Change History: jai_cmn_tax_defaultation_pkg
2363: Last Modified By Jagdish Bhosle. 2001/04/05
2364: The follow check will ensure that for Bond reg. Txns
2365: excise duty will not be added to original Line amount. */
2366: --------------------------------------------------------------------------------------
2851:
2852: IF lv_process_flag IN ('EE', 'UE')
2853: THEN
2854: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2855: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_CMN_TAX_DEFAULTATION_PKG.JA_IN_CALC_PREC_TAXES.Err:'||lv_process_message);
2856: app_exception.raise_exception;
2857: END IF;
2858: END IF;
2859: --=====================================================
3315: SET tax_category_id = p_tax_category_id
3316: WHERE line_focus_id = v_line_focus_id_holder;
3317: EXCEPTION
3318: WHEN OTHERS THEN
3319: RAISE_APPLICATION_ERROR( -20101, '1 Exception raised in jai_cmn_tax_defaultation_pkg:JIPLL '||SQLERRM, TRUE);
3320: END;
3321:
3322: ELSIF transaction_name = 'PO_REQN' THEN
3323:
3326: SET tax_category_id = p_tax_category_id
3327: WHERE requisition_line_id = p_line_id;
3328: EXCEPTION
3329: WHEN OTHERS THEN
3330: RAISE_APPLICATION_ERROR( -20101, '2 Exception raised in jai_cmn_tax_defaultation_pkg:JIRL '||SQLERRM, TRUE);
3331: END;
3332:
3333:
3334: /* End, cbabu for EnhancementBug# 2427465 */
3534: p_refc_tax_cat_taxes_cur := ref_tax_cur;
3535: end get_tax_cat_taxes_cur;
3536: /* end of bug#5631784 */
3537:
3538: END jai_cmn_tax_defaultation_pkg;