[Home] [Help]
1: PACKAGE BODY jai_cmn_rg_master_org_pkg AS
2: /* $Header: jai_cmn_rg_mst.plb 120.2.12010000.2 2008/11/06 13:44:40 srjayara ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
128: IF rg_others_cur%ISOPEN then
129: close rg_others_cur;
130: end if;
131: RETCODE := '2' ;
132: ERRBUF := ' Error Encountered in - jai_cmn_rg_master_org_pkg.insert_rg23_others ' || substr(SQLERRM,1,1000);
133: END insert_rg23_others;
134:
135:
136: PROCEDURE insert_pla_others
152:
153: BEGIN
154:
155: /*------------------------------------------------------------------------------------------
156: FILENAME: jai_cmn_rg_master_org_pkg.sql
157: Harshita J: /**********************************************************************
158: CREATED BY : hjujjuru
159: CREATED DATE : 11-JAN-2005
160: ENHANCEMENT BUG : 4106667
218: EXCEPTION
219: WHEN OTHERS THEN
220:
221: RETCODE := '2' ;
222: ERRBUF := ' Error Encountered in - jai_cmn_rg_master_org_pkg ' || substr(SQLERRM,1,1000);
223: --RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
224: END insert_pla_others;
225:
226:
289:
290:
291: Begin
292: /*------------------------------------------------------------------------------------------
293: FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_i.sql
294: CHANGE HISTORY:
295:
296: 1. 2002/12/14 Nagaraj.s - For BUG#2708516 Version - 615.1
297: Ideally In Master Organization, no transactions should happen
588: lv_retcode varchar2(100);
589:
590: Begin
591: /*------------------------------------------------------------------------------------------
592: FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_ii.sql
593: CHANGE HISTORY:
594:
595: 1. 2002/12/09 Nagaraj.s - For BUG#2636714 Version - 615.1
596: Ideally In Master Organization, no transactions should happen
609:
610: 2. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
611: Master Org Consolidation has been implemented for CESS taxes and any other new
612: tax types that may be added in future.
613: Procedure jai_cmn_rg_master_org_pkg.insert_rg23_others is called for each record that has been consolidated
614: with the master to consolidate the taxes for CESS.
615: Base Bug #4106633
616:
617: 3. 2005/01/28 Harshita.J - For Bug #410667 Version - 115.1
776: LOOP
777: if v_debug_flag = 'Y' THEN
778: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . Before calling other taxes ');
779: end if;
780: jai_cmn_rg_master_org_pkg.insert_rg23_others
781: (errbuf => lv_buffer,
782: retcode => lv_retcode,
783: p_previous_serial_no => v_previous_serial_no,
784: p_tax_type => tax_types_rec.tax_type,
975:
976: 3. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
977: Master Org Consolidation has been implemented for CESS taxes and any other new
978: tax types that may be added in future.
979: Procedure jai_cmn_rg_master_org_pkg.insert_rg23_others is called for each record that has been consolidated
980: with the master to consolidate the taxes for CESS.
981: Base Bug #4106633
982:
983: 3. 2005/01/28 Harshita.J - For Bug #410667 Version - 115.1
1142:
1143: LOOP
1144:
1145:
1146: jai_cmn_rg_master_org_pkg.insert_pla_others
1147: ( errbuf => lv_buffer,
1148: retcode => lv_retcode,
1149: p_previous_serial_no => v_previous_serial_no,
1150: p_tax_type => tax_types_rec.tax_type,
1288:
1289:
1290: BEGIN
1291: /*------------------------------------------------------------------------------------------
1292: CHANGE HISTORY for FILENAME: jai_cmn_rg_master_org_pkg.consolidate_rg23_part_i.sql
1293:
1294: SlNo yyyy/mm/dd Details of Changes
1295: ------------------------------------------------------------------------------------------
1296: 1. 2002/12/14 Nagaraj.s - For BUG#2708518 Version - 615.1
1561: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
1562:
1563: END consolidate_rg_i;
1564:
1565: END jai_cmn_rg_master_org_pkg ;