[Home] [Help]
1: PACKAGE BODY jai_cmn_tax_defaultation_pkg AS
2: /* $Header: jai_cmn_tax_dflt.plb 120.38.12020000.6 2013/03/19 03:04:10 qimeng ship $ */
3:
4: /*Bug 8371741 - Start*/
5:
48: v_tax_category_list VARCHAR2(30);
49: v_tax_category_id NUMBER;
50:
51: /* Added by Ramananda for bug#4407165 */
52: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes';
53:
54: -- to get address_id
55: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
56: SELECT cust_acct_site_id address_id
146: v_tax_category_list VARCHAR2(30);
147: v_tax_category_id NUMBER;
148:
149: /* Added by Ramananda for bug#4407165 */
150: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes';
151:
152: -- to get tax_category_list
153: CURSOR tax_catg_list_cur(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER DEFAULT 0) IS
154: SELECT tax_category_list
243: The trigger ja_in_oe_order_lines_aiu_trg raises an error of warehouse not found when the value of warehouse_id goes as
244: null from the form.
245:
246: Solution:-
247: 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
248: for the same.
249: 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
250: 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
251: master organization set for the default operating unit is picked up for further processing
267: 5. 01-08-2007 rchandan for bug#6030615 , Version 120.10
268: Issue : Inter org Forward porting
269: ----------------------------------------------------------------------------------------------------------------------------------------------------*/
270: /* Added by Ramananda for bug#4407165 */
271: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes';
272:
273:
274: --Code Added on 18-SEP-2000, Srihari and Gsrinivas
275: v_operating_unit NUMBER;
416: ln_amount NUMBER; --Added shujuan for bug
417:
418: ln_customs_assessable_value NUMBER; --Added by Bo Li for Bug#11684111 BOE Ehancement
419: /* Added by Ramananda for bug#4407165 */
420: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes';
421:
422: p1 NUM_TAB;
423: p2 NUM_TAB;
424: p3 NUM_TAB;
769:
770: ----------------------------------------------------------------------------------------------------------------------------------------------------
771: Current Version Current Bug Dependent Files Version Author Date Remarks
772: Of File On Bug/Patchset Dependent On
773: jai_cmn_tax_defaultation_pkg.sql
774: ----------------------------------------------------------------------------------------------------------------------------------------------------
775: 115.1 2977185 IN60105D2 None -- Aiyer 13/07/2004 Row introduces to start dependency tracking
776:
777: 115.3 4245053 IN60106 + ssumaith Service Tax and VAT Infrastructure are created
2311: base_tax_amount_nr_tab(I):=ln_vamt_nr;/*9692478*/
2312:
2313:
2314: --------------------------------------------------------------------------------------
2315: /*Change History: jai_cmn_tax_defaultation_pkg
2316: Last Modified By Jagdish Bhosle. 2001/04/05
2317: The follow check will ensure that for Bond reg. Txns
2318: excise duty will not be added to original Line amount. */
2319: --------------------------------------------------------------------------------------
3404: base_tax_amt_tab(I) := vamt;
3405: tax_target_tab(I) := vamt;
3406:
3407: --------------------------------------------------------------------------------------
3408: /*Change History: jai_cmn_tax_defaultation_pkg
3409: Last Modified By Jagdish Bhosle. 2001/04/05
3410: The follow check will ensure that for Bond reg. Txns
3411: excise duty will not be added to original Line amount. */
3412: --------------------------------------------------------------------------------------
4051:
4052: IF lv_process_flag IN ('EE', 'UE')
4053: THEN
4054: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
4055: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_CMN_TAX_DEFAULTATION_PKG.JA_IN_CALC_PREC_TAXES.Err:'||lv_process_message);
4056: app_exception.raise_exception;
4057: END IF;
4058: END IF;
4059: --=====================================================
4548: SET tax_category_id = p_tax_category_id
4549: WHERE line_focus_id = v_line_focus_id_holder;
4550: EXCEPTION
4551: WHEN OTHERS THEN
4552: RAISE_APPLICATION_ERROR( -20101, '1 Exception raised in jai_cmn_tax_defaultation_pkg:JIPLL '||SQLERRM, TRUE);
4553: END;
4554:
4555: ELSIF transaction_name = 'PO_REQN' THEN
4556:
4559: SET tax_category_id = p_tax_category_id
4560: WHERE requisition_line_id = p_line_id;
4561: EXCEPTION
4562: WHEN OTHERS THEN
4563: RAISE_APPLICATION_ERROR( -20101, '2 Exception raised in jai_cmn_tax_defaultation_pkg:JIRL '||SQLERRM, TRUE);
4564: END;
4565:
4566:
4567: /* End, cbabu for EnhancementBug# 2427465 */
4774: p_refc_tax_cat_taxes_cur := ref_tax_cur;
4775: end get_tax_cat_taxes_cur;
4776: /* end of bug#5631784 */
4777:
4778: END jai_cmn_tax_defaultation_pkg;