DBA Data[Home] [Help]

APPS.GMS_NOTIFICATION_PKG dependencies on APP_EXCEPTION

Line 47: APP_EXCEPTION.Raise_Exception;

43: fetch c into Recinfo;
44: if (c%NOTFOUND) then
45: CLOSE c;
46: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
47: APP_EXCEPTION.Raise_Exception;
48: END if;
49: CLOSE c;
50: if ( recinfo.award_id = X_award_id
51: and recinfo.event_type = X_event_type

Line 56: APP_EXCEPTION.Raise_Exception;

52: and recinfo.user_id = X_user_id ) then
53: return;
54: else
55: FND_MESSAGE.set_name('FND','FORM_RECORD_CHANGED');
56: APP_EXCEPTION.Raise_Exception;
57: END if;
58:
59: -- Added Exception for Bug:2662848
60: EXCEPTION

Line 181: -- APP_EXCEPTION.raise_exception;

177: x_err_stage := 'GMS_FND_USER_NOT_CREATED';
178:
179: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');
180: -- fnd_message.set_token('PERSON_ID',to_char(p_person_id));
181: -- APP_EXCEPTION.raise_exception;
182:
183: when others then
184: if report_event_cursor%isopen then
185: close report_Event_cursor;

Line 199: APP_EXCEPTION.RAISE_EXCEPTION;

195: x_token_val2 => sqlerrm,
196: x_err_code => x_err_code,
197: x_err_buff => x_err_stage);
198:
199: APP_EXCEPTION.RAISE_EXCEPTION;
200:
201: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
202: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_PERSON_EVENTS');
203: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

Line 205: -- APP_EXCEPTION.raise_exception;

201: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
202: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_PERSON_EVENTS');
203: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;
206: END crt_default_person_events;
207:
208:
209: PROCEDURE crt_default_report_events(x_err_code in out NOCOPY NUMBER,

Line 271: -- APP_EXCEPTION.raise_exception;

267: x_err_stage := 'GMS_FND_USER_NOT_CREATED';
268:
269: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');
270: -- fnd_message.set_token('PERSON_ID',to_char(l_person_id));
271: -- APP_EXCEPTION.raise_exception;
272: when others then
273: if award_persons%isopen then
274: close award_persons;
275: end if;

Line 288: APP_EXCEPTION.RAISE_EXCEPTION;

284: x_token_val2 => sqlerrm,
285: x_err_code => x_err_code,
286: x_err_buff => x_err_stage);
287:
288: APP_EXCEPTION.RAISE_EXCEPTION;
289:
290: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
291: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_REPORT_EVENTS');
292: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

Line 294: -- app_exception.raise_exception;

290: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
291: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_REPORT_EVENTS');
292: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;
295: END crt_default_report_events;
296:
297:
298: PROCEDURE Del_default_person_events(x_err_code in out NOCOPY NUMBER,

Line 345: -- APP_EXCEPTION.raise_exception;

341: x_err_stage := 'GMS_FND_USER_NOT_CREATED';
342:
343: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');
344: -- fnd_message.set_token('PERSON_ID',to_char(l_user_id));
345: -- APP_EXCEPTION.raise_exception;
346: when others then
347: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',
348: x_token_name1 => 'SQLCODE',
349: x_token_val1 => sqlcode,

Line 355: APP_EXCEPTION.RAISE_EXCEPTION;

351: x_token_val2 => sqlerrm,
352: x_err_code => x_err_code,
353: x_err_buff => x_err_stage);
354:
355: APP_EXCEPTION.RAISE_EXCEPTION;
356:
357: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
358: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_PERSON_EVENTS');
359: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

Line 361: -- app_exception.raise_exception;

357: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
358: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_PERSON_EVENTS');
359: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;
362: END;
363:
364:
365: PROCEDURE Del_default_report_events(x_err_code in out NOCOPY NUMBER,

Line 387: APP_EXCEPTION.RAISE_EXCEPTION;

383: x_token_val2 => sqlerrm,
384: x_err_code => x_err_code,
385: x_err_buff => x_err_stage);
386:
387: APP_EXCEPTION.RAISE_EXCEPTION;
388:
389: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
390: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_REPORT_EVENTS');
391: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

Line 393: -- app_exception.raise_exception;

389: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
390: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_REPORT_EVENTS');
391: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;
394: END;
395:
396:
397: END GMS_NOTIFICATION_PKG;