APPS.GL_CARRYFORWARD_RANGES_PKG dependencies on GL_CARRYFORWARD_RANGES

Line 1: PACKAGE BODY GL_CARRYFORWARD_RANGES_PKG as

1: PACKAGE BODY GL_CARRYFORWARD_RANGES_PKG as
2: /* $Header: glicfrab.pls 120.2 2005/05/05 01:03:39 kvora ship $ */
3:
4: FUNCTION get_unique_id RETURN NUMBER IS
5: CURSOR get_new_id IS

Line 6: SELECT gl_carryforward_ranges_s.NEXTVAL

2: /* $Header: glicfrab.pls 120.2 2005/05/05 01:03:39 kvora ship $ */
3:
4: FUNCTION get_unique_id RETURN NUMBER IS
5: CURSOR get_new_id IS
6: SELECT gl_carryforward_ranges_s.NEXTVAL
7: FROM sys.dual;
8: new_id number;
9: BEGIN
10: OPEN get_new_id;

Line 19: fnd_message.set_token('SEQUENCE', 'GL_CARRYFORWARD_RANGES_S');

15: return(new_id);
16: ELSE
17: CLOSE get_new_id;
18: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
19: fnd_message.set_token('SEQUENCE', 'GL_CARRYFORWARD_RANGES_S');
20: app_exception.raise_exception;
21: END IF;
22:
23: EXCEPTION

Line 28: fnd_message.set_token('PROCEDURE', 'gl_carryforward_ranges.get_unique_id');

24: WHEN app_exceptions.application_exception THEN
25: RAISE;
26: WHEN OTHERS THEN
27: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
28: fnd_message.set_token('PROCEDURE', 'gl_carryforward_ranges.get_unique_id');
29: RAISE;
30: END get_unique_id;
31:
32:

Line 98: FROM GL_CARRYFORWARD_RANGES

94: x_segment30_high IN VARCHAR2,
95: row_id VARCHAR2 ) IS
96: CURSOR chk_overlapping IS
97: SELECT 'Overlapping'
98: FROM GL_CARRYFORWARD_RANGES
99: WHERE carryforward_range_id = x_carryforward_range_id AND
100: (NVL(SEGMENT30_LOW,'X') <= NVL(X_SEGMENT30_HIGH,'X') AND
101: NVL(SEGMENT30_HIGH,'X') >= NVL(X_SEGMENT30_LOW,'X')) AND
102: NVL(SEGMENT29_LOW,'X') <= NVL(X_SEGMENT29_HIGH,'X') AND

Line 179: fnd_message.set_token('PROCEDURE', 'GL_CARRYFORWARD_RANGES_PKG.check_overlapping');

175: WHEN app_exceptions.application_exception THEN
176: RAISE;
177: WHEN OTHERS THEN
178: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
179: fnd_message.set_token('PROCEDURE', 'GL_CARRYFORWARD_RANGES_PKG.check_overlapping');
180: RAISE;
181: END check_overlapping;
182:
183: END GL_CARRYFORWARD_RANGES_PKG;

Line 183: END GL_CARRYFORWARD_RANGES_PKG;

179: fnd_message.set_token('PROCEDURE', 'GL_CARRYFORWARD_RANGES_PKG.check_overlapping');
180: RAISE;
181: END check_overlapping;
182:
183: END GL_CARRYFORWARD_RANGES_PKG;