DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on GL_BUDGET_ASSIGNMENT_RANGES_S

Line 1418: -- of the GL sequence gl_budget_assignment_ranges_s

1414: l_final_budget_ranges BUDGET_RANGE_TYPE;
1415:
1416: -- This is a local variable used to emulate the behavior of a sequence
1417: -- A local sequence emulation is used to avoid unnecessary increment
1418: -- of the GL sequence gl_budget_assignment_ranges_s
1419: l_range_id_seq NUMBER(38);
1420:
1421: -- Local variable to store the sequence number of the budget ranges
1422: -- This is used in Step 3

Line 1441: SELECT gl_budget_assignment_ranges_s.NEXTVAL

1437:
1438: l_data_type := p_data_type;
1439: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');
1440: BEGIN
1441: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1442: INTO l_range_id_seq
1443: FROM dual;
1444: l_range_id_seq := l_range_id_seq + 1;
1445: EXCEPTION

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

1443: FROM dual;
1444: l_range_id_seq := l_range_id_seq + 1;
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1449: from gl_budget_assignment_ranges_s');
1450: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1451: retcode := -1;

Line 1449: from gl_budget_assignment_ranges_s');

1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1449: from gl_budget_assignment_ranges_s');
1450: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1451: retcode := -1;
1452: RETURN;
1453: END;

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

1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1449: from gl_budget_assignment_ranges_s');
1450: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1451: retcode := -1;
1452: RETURN;
1453: END;
1454:

Line 1474: SELECT gl_budget_assignment_ranges_s.NEXTVAL

1470:
1471: FOR i IN 1..lc_non_overlapping_ranges.COUNT LOOP
1472: IF p_mode = 1 THEN
1473: BEGIN
1474: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1475: INTO l_actual_range_id
1476: FROM dual;
1477: EXCEPTION
1478: WHEN OTHERS THEN

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

1475: INTO l_actual_range_id
1476: FROM dual;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1481: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1482: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1483: retcode := -1;

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

1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1481: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1482: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1483: retcode := -1;
1484: RETURN;
1485: END;

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

1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1481: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1482: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1483: retcode := -1;
1484: RETURN;
1485: END;
1486: