DBA Data[Home] [Help]

APPS.GL_PERIOD_TYPES_PKG dependencies on APP_EXCEPTION

Line 71: app_exception.raise_exception;

67:
68: IF check_dups%FOUND THEN
69: CLOSE check_dups;
70: fnd_message.set_name('SQLGL', 'GL_DUP_USER_PERIOD_TYPE');
71: app_exception.raise_exception;
72: END IF;
73:
74: CLOSE check_dups;
75: EXCEPTION

Line 76: WHEN app_exception.application_exception THEN RAISE;

72: END IF;
73:
74: CLOSE check_dups;
75: EXCEPTION
76: WHEN app_exception.application_exception THEN RAISE;
77: WHEN OTHERS THEN
78: fnd_message.set_name('SQLGL','Unhandled Exception');
79: fnd_message.set_token('PROCEDURE', 'Check_Unique_User_Type');
80: RAISE;

Line 103: app_exception.raise_exception;

99: IF chk_dups%FOUND THEN
100: CLOSE chk_dups;
101: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
103: app_exception.raise_exception;
104: END IF;
105:
106: CLOSE chk_dups;
107: EXCEPTION

Line 108: WHEN app_exception.application_exception THEN RAISE;

104: END IF;
105:
106: CLOSE chk_dups;
107: EXCEPTION
108: WHEN app_exception.application_exception THEN RAISE;
109: WHEN OTHERS THEN
110: fnd_message.set_name('SQLGL','Unhandled Exception');
111: fnd_message.set_token('PROCEDURE', 'Check_Unique_Type');
112: RAISE;

Line 125: app_exception.raise_exception;

121:
122: IF (x_period_type is NULL) THEN
123: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
125: app_exception.raise_exception;
126: END IF;
127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;
129: WHEN OTHERS THEN

Line 128: WHEN app_exception.application_exception THEN RAISE;

124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
125: app_exception.raise_exception;
126: END IF;
127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;
129: WHEN OTHERS THEN
130: fnd_message.set_name('SQLGL','Unhandled Exception');
131: fnd_message.set_token('PROCEDURE', 'Get_New_Id');
132: RAISE;

Line 199: app_exception.raise_exception;

195: -- validate input parameters
196: if ( x_period_type is null) then
197:
198: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
199: app_exception.raise_exception;
200: end if;
201:
202: if (X_OWNER = 'SEED') then
203: user_id := 1;