[Home] [Help]
1: PACKAGE BODY jai_cmn_rg_master_org_pkg AS
2: /* $Header: jai_cmn_rg_mst.plb 120.5.12020000.2 2012/07/16 12:06:09 nkodakan ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
136: IF rg_others_cur%ISOPEN then
137: close rg_others_cur;
138: end if;
139: RETCODE := '2' ;
140: ERRBUF := ' Error Encountered in - jai_cmn_rg_master_org_pkg.insert_rg23_others ' || substr(SQLERRM,1,1000);
141: END insert_rg23_others;
142:
143:
144: PROCEDURE insert_pla_others
160:
161: BEGIN
162:
163: /*------------------------------------------------------------------------------------------
164: FILENAME: jai_cmn_rg_master_org_pkg.sql
165: Harshita J: /**********************************************************************
166: CREATED BY : hjujjuru
167: CREATED DATE : 11-JAN-2005
168: ENHANCEMENT BUG : 4106667
226: EXCEPTION
227: WHEN OTHERS THEN
228:
229: RETCODE := '2' ;
230: ERRBUF := ' Error Encountered in - jai_cmn_rg_master_org_pkg ' || substr(SQLERRM,1,1000);
231: --RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
232: END insert_pla_others;
233:
234:
297:
298:
299: Begin
300: /*------------------------------------------------------------------------------------------
301: FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_i.sql
302: CHANGE HISTORY:
303:
304: 1. 2002/12/14 Nagaraj.s - For BUG#2708516 Version - 615.1
305: Ideally In Master Organization, no transactions should happen
611: lv_retcode varchar2(100);
612:
613: Begin
614: /*------------------------------------------------------------------------------------------
615: FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_ii.sql
616: CHANGE HISTORY:
617:
618: 1. 2002/12/09 Nagaraj.s - For BUG#2636714 Version - 615.1
619: Ideally In Master Organization, no transactions should happen
632:
633: 2. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
634: Master Org Consolidation has been implemented for CESS taxes and any other new
635: tax types that may be added in future.
636: Procedure jai_cmn_rg_master_org_pkg.insert_rg23_others is called for each record that has been consolidated
637: with the master to consolidate the taxes for CESS.
638: Base Bug #4106633
639:
640: 3. 2005/01/28 Harshita.J - For Bug #410667 Version - 115.1
807: LOOP
808: if v_debug_flag = 'Y' THEN
809: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . Before calling other taxes ');
810: end if;
811: jai_cmn_rg_master_org_pkg.insert_rg23_others
812: (errbuf => lv_buffer,
813: retcode => lv_retcode,
814: p_previous_serial_no => v_previous_serial_no,
815: p_tax_type => tax_types_rec.tax_type,
1006:
1007: 3. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
1008: Master Org Consolidation has been implemented for CESS taxes and any other new
1009: tax types that may be added in future.
1010: Procedure jai_cmn_rg_master_org_pkg.insert_rg23_others is called for each record that has been consolidated
1011: with the master to consolidate the taxes for CESS.
1012: Base Bug #4106633
1013:
1014: 3. 2005/01/28 Harshita.J - For Bug #410667 Version - 115.1
1173:
1174: LOOP
1175:
1176:
1177: jai_cmn_rg_master_org_pkg.insert_pla_others
1178: ( errbuf => lv_buffer,
1179: retcode => lv_retcode,
1180: p_previous_serial_no => v_previous_serial_no,
1181: p_tax_type => tax_types_rec.tax_type,
1319:
1320:
1321: BEGIN
1322: /*------------------------------------------------------------------------------------------
1323: CHANGE HISTORY for FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_i.sql
1324:
1325: SlNo yyyy/mm/dd Details of Changes
1326: ------------------------------------------------------------------------------------------
1327: 1. 2002/12/14 Nagaraj.s - For BUG#2708518 Version - 615.1
1608: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
1609:
1610: END consolidate_rg_i;
1611:
1612: END jai_cmn_rg_master_org_pkg ;