[Home] [Help]
1: PACKAGE BODY jai_cmn_mtax_pkg AS
2: /* $Header: jai_cmn_mtax.plb 120.34.12020000.3 2013/03/27 08:07:02 vkaranam ship $ */
3:
4: /*START, Added the following procedures by Bgowrava for the forward porting bug#5724855*/
5:
63: begin
64:
65: if p_called_from is null then
66: /* Called from concurrent JAINMTCH */
67: jai_cmn_mtax_pkg.do_tax_redefaultation
68: (
69: p_err_buf => p_err_buf
70: ,p_ret_code => p_ret_code
71: ,p_org_id => p_org_id
91: );
92:
93: elsif p_called_from = 'JAINUCTG' then
94: /* Called from Update Tax Categories form */
95: jai_cmn_mtax_pkg.process_tax_cat_update
96: (
97: p_err_buf => p_err_buf
98: ,p_ret_code => p_ret_code
99: ,p_org_id => p_org_id
329: v_enable_trace FND_CONCURRENT_PROGRAMS.enable_trace%TYPE;
330:
331:
332: -- used for log file Generation
333: v_log_file_name VARCHAR2(50); -- := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log'; --Ramananda for File.Sql.35
334: v_utl_location VARCHAR2(512);
335: v_myfilehandle UTL_FILE.FILE_TYPE;
336:
337: --//~~~~~~~~ Declaration Section for Preprocessing of the variables ~~~~~~~~~~//
1240: 115.2 LGOPALSA IN60106 + Added Cess tax code
1241: 4146708
1242:
1243: 115.3 hjujjuru 4245089 VAT Implelentationfnd_file.put_line(fnd_file.log,
1244: 120.3 Aiyer R12 JAI A Changed for bug 4565665. Spec and body change in jai_cmn_mtax_pkg
1245: --------------------------------------------------------------------------------------------------------------------------*/
1246:
1247: -- Add code by Xiao to get release version on 24-Jul-2009
1248: lb_result := fnd_release.get_release(lv_release_name, lv_other_release_info);
1263: v_document_find_failed := 'N';
1264: v_failed := 'N';
1265: p_from_date := fnd_date.canonical_to_date(pv_from_date);
1266: p_to_date := fnd_date.canonical_to_date(pv_to_date);
1267: v_log_file_name := 'jai_cmn_mtax_pkg.do_tax_redefaultation.log';
1268: /* Added below code for bug#7351304 by JMEENA*/
1269: IF p_from_date IS NULL THEN
1270: p_from_date := to_date('01/01/1940','DD-MM-YYYY');
1271: END IF;
1953: WHERE line_focus_id = shipment_rec.line_focus_id;
1954:
1955: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
1956: ELSE
1957: jai_cmn_mtax_pkg.del_taxes_after_validate
1958: ( 'PO', shipment_rec.line_focus_id, v_line_location_id, shipment_rec.po_line_id,
1959: v_success, v_message
1960: );
1961: END IF;
2541: WHERE line_focus_id = releases_rec.line_focus_id;
2542:
2543: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
2544: ELSE
2545: jai_cmn_mtax_pkg.del_taxes_after_validate
2546: ( 'PO', releases_rec.line_focus_id, releases_rec.line_location_id, releases_rec.po_line_id,
2547: v_success, v_message
2548: );
2549: END IF;
3136: WHERE requisition_line_id = reqn_rec.requisition_line_id;
3137:
3138: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
3139: ELSE
3140: jai_cmn_mtax_pkg.del_taxes_after_validate( 'REQUISITION', null, null, reqn_rec.requisition_line_id,
3141: v_success, v_message );
3142: END IF;
3143:
3144: IF v_debug THEN
3686: WHERE line_id = so_rec.line_id;
3687:
3688: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
3689: ELSE
3690: jai_cmn_mtax_pkg.del_taxes_after_validate( 'SO', null, null, so_rec.line_id, v_success, v_message );
3691: END IF;
3692:
3693: IF v_debug THEN
3694: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
4310:
4311: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
4312: ELSE
4313:
4314: jai_cmn_mtax_pkg.del_taxes_after_validate( 'BOE', null, null, boe_rec.boe_detail_id, v_success, v_message );
4315: END IF;
4316:
4317: IF v_debug THEN
4318: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
4845:
4846: v_dflt_temp NUMBER;
4847: v_debug VARCHAR2(1); -- := 'N'; --Ramananda for File.Sql.35
4848:
4849: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_mtax_pkg.del_taxes_after_validate'; /* Added by Ramananda for bug#4407165 */
4850:
4851: BEGIN
4852:
4853: /*--------------------------------------------------------------------------------------------------------------------------
4850:
4851: BEGIN
4852:
4853: /*--------------------------------------------------------------------------------------------------------------------------
4854: CHANGE HISTORY for FILENAME - jai_cmn_mtax_pkg.del_taxes_after_validate_p.sql
4855: S.No Date Author and Details
4856: -------------------------------------------------
4857: 1. 30/12/2002 cbabu for EnhancementBug# 2427465, FileVersion# 615.1
4858: Procedure created to check whether the line passed to this procedure has no dependency problems related to
5191: app_exception.raise_exception;
5192:
5193: END del_taxes_after_validate;
5194:
5195: END jai_cmn_mtax_pkg;