eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_EFC_UPGRADE dependencies on IGI_UPG_GL_BUDGET_ASSIGNMENT

Line 124: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,

120: -- This cursor fetches the account range information
121: CURSOR C_UPG_GL_BUDGET_ASSIGNMENT (pp_range_id NUMBER)
122: IS
123: SELECT IGIGL.*,ent.NAME BUDGET_NAME,led.NAME LEDGER_NAME
124: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,
125: gl_budget_entities ent,
126: GL_LEDGERS led
127: WHERE IGIGL.RANGE_ID = pp_range_id
128: AND IGIGL.budget_entity_id = ent.budget_entity_id

Line 1116: -- Step 1A: Table IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for occurences of

1112:
1113: -- PROCEDURE LOOP_AND_PROCESS does the main processing logic
1114: -- This proceedure works as follows:
1115: --
1116: -- Step 1A: Table IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for occurences of
1117: -- non merging ranges. If Non Merging ranges are found, then they are
1118: -- migrated to the GL if the mode is "final". Otherwise they are
1119: -- added to the report output.
1120: --

Line 1121: -- Step 1B: If No records exist in table IGI_UPG_GL_BUDGET_ASSIGNMENT

1117: -- non merging ranges. If Non Merging ranges are found, then they are
1118: -- migrated to the GL if the mode is "final". Otherwise they are
1119: -- added to the report output.
1120: --
1121: -- Step 1B: If No records exist in table IGI_UPG_GL_BUDGET_ASSIGNMENT
1122: -- then execute stops and control is returned to the calling procedure
1123: --
1124: -- Step 2: Table IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for occurences of any
1125: -- range which exactly merges with other ranges. If such a range is found

Line 1124: -- Step 2: Table IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for occurences of any

1120: --
1121: -- Step 1B: If No records exist in table IGI_UPG_GL_BUDGET_ASSIGNMENT
1122: -- then execute stops and control is returned to the calling procedure
1123: --
1124: -- Step 2: Table IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for occurences of any
1125: -- range which exactly merges with other ranges. If such a range is found
1126: -- then the duplicate range is deleted and the proceed continues to Step 1A.
1127: --
1128: -- Step 3: In this step, the remaning ranges are analyzed. The table

Line 1129: -- IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for two ranges which merge with

1125: -- range which exactly merges with other ranges. If such a range is found
1126: -- then the duplicate range is deleted and the proceed continues to Step 1A.
1127: --
1128: -- Step 3: In this step, the remaning ranges are analyzed. The table
1129: -- IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for two ranges which merge with
1130: -- each other. Then the two ranges are split by calling the function SPLIT_RANGES
1131: -- followed by RECURSIVE_MERGE. After the ranges are split they are inserted
1132: -- back into IGI_UPG_GL_BUDGET_ASSIGNMENT. The original ranges are deleted
1133: -- and the proceed continues to Step 1A.

Line 1132: -- back into IGI_UPG_GL_BUDGET_ASSIGNMENT. The original ranges are deleted

1128: -- Step 3: In this step, the remaning ranges are analyzed. The table
1129: -- IGI_UPG_GL_BUDGET_ASSIGNMENT is scanned for two ranges which merge with
1130: -- each other. Then the two ranges are split by calling the function SPLIT_RANGES
1131: -- followed by RECURSIVE_MERGE. After the ranges are split they are inserted
1132: -- back into IGI_UPG_GL_BUDGET_ASSIGNMENT. The original ranges are deleted
1133: -- and the proceed continues to Step 1A.
1134: --
1135: --
1136: PROCEDURE LOOP_AND_PROCESS (p_data_type NUMBER,

Line 1143: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1139: retcode OUT NOCOPY NUMBER
1140: )
1141: IS
1142:
1143: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1144:
1145: -- This cursor fetches all the ranges that overlap in merge manner
1146: CURSOR C_NON_OVERLAPPING_RANGES IS
1147: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

Line 1147: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

1143: TYPE BUD_ASSIGN_TAB IS TABLE OF IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1144:
1145: -- This cursor fetches all the ranges that overlap in merge manner
1146: CURSOR C_NON_OVERLAPPING_RANGES IS
1147: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1148: WHERE NOT EXISTS
1149: (SELECT 1 FROM
1150: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1151: WHERE BA1.RANGE_ID <> BA2.RANGE_ID

Line 1150: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

1146: CURSOR C_NON_OVERLAPPING_RANGES IS
1147: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1148: WHERE NOT EXISTS
1149: (SELECT 1 FROM
1150: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1151: WHERE BA1.RANGE_ID <> BA2.RANGE_ID
1152: AND BA2.ledger_id = BA1.ledger_id
1153: AND BA2.currency_code = BA1.currency_code
1154: AND NVL(BA1.SEGMENT1_LOW,'X') <= NVL(BA2.SEGMENT1_HIGH,'X')

Line 1220: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

1216:
1217: -- This cursor fetches all the ranges that overlap with p_range_id
1218: -- exactly
1219: CURSOR C_EXACT_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1220: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1221: WHERE EXISTS
1222: (SELECT 1 FROM
1223: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1224: WHERE

Line 1223: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

1219: CURSOR C_EXACT_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1220: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1221: WHERE EXISTS
1222: (SELECT 1 FROM
1223: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1224: WHERE
1225: BA2.range_id = p_range_id
1226: AND BA2.ledger_id = BA1.ledger_id
1227: AND BA2.currency_code = BA1.currency_code

Line 1294: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1

1290:
1291: -- This cursor fetches all the ranges that overlap with p_range_id
1292: -- in a merge fashion
1293: CURSOR C_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1294: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1295: WHERE EXISTS
1296: (SELECT 1 FROM
1297: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1298: WHERE

Line 1297: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2

1293: CURSOR C_OVERLAPPING_RANGE(p_range_id NUMBER) IS
1294: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1
1295: WHERE EXISTS
1296: (SELECT 1 FROM
1297: IGI_UPG_GL_BUDGET_ASSIGNMENT BA2
1298: WHERE
1299: BA2.range_id = p_range_id
1300: AND BA2.ledger_id = BA1.ledger_id
1301: AND BA2.currency_code = BA1.currency_code

Line 1367: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1;

1363: );
1364:
1365: -- This cursor fetches all the ranges
1366: CURSOR C_ALL_RANGES IS
1367: SELECT * FROM IGI_UPG_GL_BUDGET_ASSIGNMENT BA1;
1368:
1369: -- This cursor fetches all the budgets associated to p_range_id
1370: CURSOR C_BC_OPTIONS (p_range_id NUMBER)
1371: IS

Line 1379: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1375: TYPE non_overlapping_ranges_tab IS TABLE OF C_NON_OVERLAPPING_RANGES%ROWTYPE;
1376:
1377: lc_non_overlapping_ranges non_overlapping_ranges_tab;
1378:
1379: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1380: lc_exact_merge_range1_bc BC_OPTIONS_TAB;
1381:
1382: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1383: lc_exact_merge_range2_bc BC_OPTIONS_TAB;

Line 1382: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1378:
1379: lc_exact_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1380: lc_exact_merge_range1_bc BC_OPTIONS_TAB;
1381:
1382: lc_exact_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1383: lc_exact_merge_range2_bc BC_OPTIONS_TAB;
1384:
1385:
1386:

Line 1387: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1383: lc_exact_merge_range2_bc BC_OPTIONS_TAB;
1384:
1385:
1386:
1387: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1388: lc_merge_range1_bc BC_OPTIONS_TAB;
1389:
1390: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1391: lc_merge_range2_bc BC_OPTIONS_TAB;

Line 1390: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;

1386:
1387: lc_merge_range1 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1388: lc_merge_range1_bc BC_OPTIONS_TAB;
1389:
1390: lc_merge_range2 IGI_UPG_GL_BUDGET_ASSIGNMENT%ROWTYPE;
1391: lc_merge_range2_bc BC_OPTIONS_TAB;
1392:
1393: p_segment1 segment_range_rec;
1394: p_segment2 segment_range_rec;

Line 1743: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

1739: END IF;
1740:
1741: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1742:
1743: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1744:
1745:
1746:
1747: EXCEPTION

Line 1770: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;

1766:
1767:
1768: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1769:
1770: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1771: EXCEPTION
1772: WHEN OTHERS THEN
1773: fnd_file.put_line(fnd_file.output, 'Error processing demerged data - prelim mode');
1774: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

Line 1820: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;

1816: UPDATE IGI_UPG_GL_BUDORG_BC_OPTIONS
1817: SET RANGE_ID = lc_exact_merge_range1.range_id
1818: WHERE RANGE_ID = lc_exact_merge_range2.range_id;
1819:
1820: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_file.put_line(fnd_file.output, 'Error merging data which overlaps exactly');

Line 2251: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT

2247: l_seq_number2 NUMBER;
2248: BEGIN
2249: SELECT max(sequence_number)+1
2250: INTO l_seq_number1
2251: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
2252: WHERE
2253: budget_entity_id = lc_merge_range2.budget_entity_id;
2254:
2255: SELECT max(sequence_number)+1

Line 2286: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

2282: -- For range l_final_budget_ranges(i) insert data corresponding
2283: -- to lc_merge_range2
2284: BEGIN
2285:
2286: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
2287: (
2288: BUDGET_ENTITY_ID,
2289: LEDGER_ID,
2290: CURRENCY_CODE,

Line 2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');

2484: lc_merge_range2.attribute15
2485: );
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2492: retcode := -1;

Line 2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);

2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2492: retcode := -1;
2493: RETURN;
2494: END;

Line 2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;

2487: WHEN OTHERS THEN
2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2492: retcode := -1;
2493: RETURN;
2494: END;
2495:

Line 2565: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT

2561: l_seq_number2 NUMBER;
2562: BEGIN
2563: SELECT max(sequence_number)+1
2564: INTO l_seq_number1
2565: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT
2566: WHERE
2567: budget_entity_id = lc_merge_range1.budget_entity_id;
2568:
2569: SELECT max(sequence_number)+1

Line 2601: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

2597: -- For range l_final_budget_ranges(i) insert data corresponding
2598: -- to lc_merge_range1
2599: BEGIN
2600:
2601: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
2602: (
2603: BUDGET_ENTITY_ID,
2604: LEDGER_ID,
2605: CURRENCY_CODE,

Line 2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');

2800: );
2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2807: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;

Line 2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);

2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2807: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
2809: retcode := -1;
2810: RETURN;

Line 2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;

2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2807: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
2809: retcode := -1;
2810: RETURN;
2811: END;
2812:

Line 2933: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE

2929:
2930: BEGIN
2931: --Since the splits ranges have been inserted
2932: --the original ranges have to be deleted from the backend
2933: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE
2934: range_id = lc_merge_range2.range_id OR
2935: range_id = lc_merge_range1.range_id;
2936:
2937: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS WHERE

Line 3221: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;

3217: -- Typically data should not exist in these tables at this point. Deletion
3218: -- has been added to ensure that no data exists
3219: BEGIN
3220:
3221: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT;
3222: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;
3223:
3224: EXCEPTION
3225: WHEN OTHERS THEN

Line 3604: -- the processing table IGI_UPG_GL_BUDGET_ASSIGNMENT

3600: END IF; -- If mode is Final mode
3601:
3602:
3603: -- Copy all ranges belonging to EFC enabled ledgers into
3604: -- the processing table IGI_UPG_GL_BUDGET_ASSIGNMENT
3605: -- LOOP_AND_PROCESS picks up data from IGI_UPG_GL_BUDGET_ASSIGNMENT for
3606: -- processing. Data is pushed into IGI_UPG_GL_BUDGET_ASSIGNMENT
3607: -- instead of directly accessing it as recursive processing is needed to
3608: -- ensure non overlap of all ranges. Once all processing is completed

Line 3605: -- LOOP_AND_PROCESS picks up data from IGI_UPG_GL_BUDGET_ASSIGNMENT for

3601:
3602:
3603: -- Copy all ranges belonging to EFC enabled ledgers into
3604: -- the processing table IGI_UPG_GL_BUDGET_ASSIGNMENT
3605: -- LOOP_AND_PROCESS picks up data from IGI_UPG_GL_BUDGET_ASSIGNMENT for
3606: -- processing. Data is pushed into IGI_UPG_GL_BUDGET_ASSIGNMENT
3607: -- instead of directly accessing it as recursive processing is needed to
3608: -- ensure non overlap of all ranges. Once all processing is completed
3609: -- data is inserted into the GL table

Line 3606: -- processing. Data is pushed into IGI_UPG_GL_BUDGET_ASSIGNMENT

3602:
3603: -- Copy all ranges belonging to EFC enabled ledgers into
3604: -- the processing table IGI_UPG_GL_BUDGET_ASSIGNMENT
3605: -- LOOP_AND_PROCESS picks up data from IGI_UPG_GL_BUDGET_ASSIGNMENT for
3606: -- processing. Data is pushed into IGI_UPG_GL_BUDGET_ASSIGNMENT
3607: -- instead of directly accessing it as recursive processing is needed to
3608: -- ensure non overlap of all ranges. Once all processing is completed
3609: -- data is inserted into the GL table
3610: BEGIN

Line 3612: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT

3608: -- ensure non overlap of all ranges. Once all processing is completed
3609: -- data is inserted into the GL table
3610: BEGIN
3611:
3612: INSERT INTO IGI_UPG_GL_BUDGET_ASSIGNMENT
3613: (
3614: BUDGET_ENTITY_ID,
3615: LEDGER_ID,
3616: CURRENCY_CODE,

Line 3826: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);

3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3825: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3826: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3827: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3828: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
3829: retcode := -1;
3830: RETURN;

Line 3828: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;

3824: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3825: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3826: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3827: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3828: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
3829: retcode := -1;
3830: RETURN;
3831: END;
3832:

Line 3864: IGI_UPG_GL_BUDGET_ASSIGNMENT);

3860: FROM GL_BUDORG_BC_OPTIONS
3861: WHERE range_id IN
3862: (SELECT range_id
3863: FROM
3864: IGI_UPG_GL_BUDGET_ASSIGNMENT);
3865:
3866: EXCEPTION
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');