DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on GL_BUDGET_ASSIGNMENT_RANGES_S

Line 1192: SELECT gl_budget_assignment_ranges_s.NEXTVAL

1188:
1189: l_data_type := p_data_type;
1190: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');
1191: BEGIN
1192: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1193: INTO l_range_id_seq
1194: FROM dual;
1195: l_range_id_seq := l_range_id_seq + 1;
1196: EXCEPTION

Line 1198: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

1194: FROM dual;
1195: l_range_id_seq := l_range_id_seq + 1;
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1199: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1200: from gl_budget_assignment_ranges_s');
1201: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1202: retcode := -1;

Line 1200: from gl_budget_assignment_ranges_s');

1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1199: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1200: from gl_budget_assignment_ranges_s');
1201: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1202: retcode := -1;
1203: RETURN;
1204: END;

Line 1201: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';

1197: WHEN OTHERS THEN
1198: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1199: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1200: from gl_budget_assignment_ranges_s');
1201: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1202: retcode := -1;
1203: RETURN;
1204: END;
1205:

Line 1221: SELECT gl_budget_assignment_ranges_s.NEXTVAL

1217:
1218: FOR i IN 1..lc_non_overlapping_ranges.COUNT LOOP
1219: IF p_mode = 1 THEN
1220: BEGIN
1221: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1222: INTO l_actual_range_id
1223: FROM dual;
1224: EXCEPTION
1225: WHEN OTHERS THEN

Line 1226: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

1222: INTO l_actual_range_id
1223: FROM dual;
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1227: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1228: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1229: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1230: retcode := -1;

Line 1228: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');

1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1227: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1228: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1229: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1230: retcode := -1;
1231: RETURN;
1232: END;

Line 1229: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';

1225: WHEN OTHERS THEN
1226: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1227: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1228: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1229: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1230: retcode := -1;
1231: RETURN;
1232: END;
1233: