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.10 2005/05/05 01:09:58 kvora 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 502: GL_JE_SOURCES_PKG.Update_Row(

498:
499: /* Update only if force_edits is 'Y' or if user_id = 1 */
500: if ( user_id = 1 or X_Force_Edits = 'Y' ) then
501: -- update row if present
502: GL_JE_SOURCES_PKG.Update_Row(
503: X_Rowid => v_rowid,
504: X_je_source_name => X_Je_Source_Name,
505: X_last_update_date => sysdate,
506: X_last_updated_by => user_id,

Line 526: GL_JE_SOURCES_PKG.Insert_Row(

522: X_context => X_Context);
523: end if;
524: exception
525: when NO_DATA_FOUND then
526: GL_JE_SOURCES_PKG.Insert_Row(
527: X_Rowid => v_rowid,
528: X_je_source_name => X_Je_Source_Name,
529: X_language => v_language,
530: X_source_lang => v_source_lang,

Line 671: END gl_je_sources_pkg;

667: and T.LANGUAGE = L.LANGUAGE_CODE);
668:
669: end ADD_LANGUAGE;
670:
671: END gl_je_sources_pkg;