DBA Data[Home] [Help]

APPS.GL_JE_SOURCES_PKG dependencies on GL_JE_SOURCES_PKG

Line 1: PACKAGE BODY gl_je_sources_pkg AS

1: PACKAGE BODY gl_je_sources_pkg AS
2: /* $Header: glijesrb.pls 120.11 2011/11/03 06:15:05 skotakar ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 18: -- gl_je_sources_pkg.select_row(recinfo)

14: -- 11-02-93 D. J. Ogg Created
15: -- Arguments
16: -- recinfo Various information about the row
17: -- Example
18: -- gl_je_sources_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_je_sources%ROWTYPE) IS
22: BEGIN

Line 68: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.check_unique_name');

64: WHEN app_exceptions.application_exception THEN
65: RAISE;
66: WHEN OTHERS THEN
67: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
68: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.check_unique_name');
69: RAISE;
70: END check_unique_name;
71:
72: PROCEDURE check_unique_user_name(x_user_je_source_name VARCHAR2,

Line 97: 'gl_je_sources_pkg.check_unique_user_name');

93: RAISE;
94: WHEN OTHERS THEN
95: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
96: fnd_message.set_token('PROCEDURE',
97: 'gl_je_sources_pkg.check_unique_user_name');
98: RAISE;
99: END check_unique_user_name;
100:
101: PROCEDURE check_unique_key(x_je_source_key VARCHAR2,

Line 126: 'gl_je_sources_pkg.check_unique_key');

122: RAISE;
123: WHEN OTHERS THEN
124: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
125: fnd_message.set_token('PROCEDURE',
126: 'gl_je_sources_pkg.check_unique_key');
127: RAISE;
128: END check_unique_key;
129:
130: FUNCTION get_unique_id RETURN NUMBER IS

Line 154: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.get_unique_id');

150: WHEN app_exceptions.application_exception THEN
151: RAISE;
152: WHEN OTHERS THEN
153: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
154: fnd_message.set_token('PROCEDURE', 'gl_je_sources_pkg.get_unique_id');
155: RAISE;
156: END get_unique_id;
157:
158: FUNCTION is_sla_source( X_je_source VARCHAR2) RETURN BOOLEAN IS

Line 527: GL_JE_SOURCES_PKG.Update_Row(

523:
524: /* Update only if force_edits is 'Y' or if user_id = 1 */
525: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
526: -- update row if present
527: GL_JE_SOURCES_PKG.Update_Row(
528: X_Rowid => v_rowid,
529: X_je_source_name => X_Je_Source_Name,
530: X_last_update_date => sysdate,
531: X_last_updated_by => user_id,

Line 552: GL_JE_SOURCES_PKG.Insert_Row(

548: X_context => V_Context);
549: end if;
550: exception
551: when NO_DATA_FOUND then
552: GL_JE_SOURCES_PKG.Insert_Row(
553: X_Rowid => v_rowid,
554: X_je_source_name => X_Je_Source_Name,
555: X_language => v_language,
556: X_source_lang => v_source_lang,

Line 697: END gl_je_sources_pkg;

693: and T.LANGUAGE = L.LANGUAGE_CODE);
694:
695: end ADD_LANGUAGE;
696:
697: END gl_je_sources_pkg;