DBA Data[Home] [Help]

APPS.GMS_NOTIFICATION_PKG dependencies on FND_MESSAGE

Line 46: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

42: open c;
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

Line 55: FND_MESSAGE.set_name('FND','FORM_RECORD_CHANGED');

51: and recinfo.event_type = X_event_type
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

Line 179: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');

175: when user_not_yet_created then
176: x_err_code := 2;
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

Line 180: -- fnd_message.set_token('PERSON_ID',to_char(p_person_id));

176: x_err_code := 2;
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

Line 201: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');

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));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;

Line 202: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_PERSON_EVENTS');

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));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;
206: END crt_default_person_events;

Line 203: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

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));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;
206: END crt_default_person_events;
207:

Line 204: -- fnd_message.set_token('OERRM',sqlerrm);

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));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;
206: END crt_default_person_events;
207:
208:

Line 269: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');

265: when user_not_yet_created then
266: x_err_code := 2;
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

Line 270: -- fnd_message.set_token('PERSON_ID',to_char(l_person_id));

266: x_err_code := 2;
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;

Line 290: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');

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));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;

Line 291: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_REPORT_EVENTS');

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));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;
295: END crt_default_report_events;

Line 292: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

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));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;
295: END crt_default_report_events;
296:

Line 293: -- fnd_message.set_token('OERRM',sqlerrm);

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));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;
295: END crt_default_report_events;
296:
297:

Line 343: -- fnd_message.set_name('GMS','GMS_FND_USER_NOT_CREATED');

339: when user_not_yet_created then
340: x_err_code := 2;
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',

Line 344: -- fnd_message.set_token('PERSON_ID',to_char(l_user_id));

340: x_err_code := 2;
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',

Line 357: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');

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));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;

Line 358: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_PERSON_EVENTS');

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));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;
362: END;

Line 359: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

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));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;
362: END;
363:

Line 360: -- fnd_message.set_token('OERRM',sqlerrm);

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));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;
362: END;
363:
364:

Line 389: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');

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));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;

Line 390: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_REPORT_EVENTS');

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));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;
394: END;

Line 391: -- fnd_message.set_token('OERRNO',to_char(sqlcode));

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));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;
394: END;
395:

Line 392: -- fnd_message.set_token('OERRM',sqlerrm);

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));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;
394: END;
395:
396: