APPS.EDR_PSIG_RULE dependencies on FND_MESSAGE

Line 204: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PROC_EVT');

200: l_temp_clob:=P_eventP.getEventData( );
201:
202: --Diagnostics Start
203: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
204: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PROC_EVT');
205: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
206: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
207: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
208: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 205: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

201:
202: --Diagnostics Start
203: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
204: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PROC_EVT');
205: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
206: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
207: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
208: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
209: FALSE

Line 206: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

202: --Diagnostics Start
203: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
204: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PROC_EVT');
205: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
206: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
207: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
208: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
209: FALSE
210: );

Line 257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');

253: --
254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);
255: --Diagnostics Start
256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
259: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
260: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);
255: --Diagnostics Start
256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
259: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
260: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
262: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 259: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

255: --Diagnostics Start
256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
259: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
260: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
262: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
263: FALSE

Line 260: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
259: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
260: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
262: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
263: FALSE
264: );

Line 310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');

306: --Bug 4160412: End
307:
308: --Diagnostics Start
309: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');
311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);

Line 311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

307:
308: --Diagnostics Start
309: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');
311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);
315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);

Line 312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

308: --Diagnostics Start
309: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');
311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);
315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);
316: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

309: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');
311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);
315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);
316: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
317: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);

310: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_APPR_EVT');
311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);
315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);
316: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
317: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
318: FALSE

Line 315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);

311: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
312: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
313: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
314: FND_MESSAGE.SET_TOKEN('APPROVER_NO',i);
315: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',p_approverlist.count);
316: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
317: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
318: FALSE
319: );

Line 350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');

346: --Bug 2674799 : end
347:
348: --Diagnostics Start
349: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');
351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);

Line 351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

347:
348: --Diagnostics Start
349: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');
351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

348: --Diagnostics Start
349: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');
351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
356: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

349: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');
351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
356: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
357: FALSE

Line 354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);

350: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_ESIG_EVT');
351: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
352: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
353: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
354: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
356: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
357: FALSE
358: );

Line 392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');

388: --Bug 4160412: End
389:
390: --Diagnostics Start
391: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');
393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);

Line 393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

389:
390: --Diagnostics Start
391: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');
393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
397: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

390: --Diagnostics Start
391: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');
393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
397: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
398: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

391: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');
393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
397: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
398: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
399: FALSE

Line 396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);

392: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_PSIG_EVT');
393: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
394: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
395: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
396: FND_MESSAGE.SET_TOKEN('APPROVER',l_overriding_approver);
397: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
398: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
399: FALSE
400: );

Line 436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');

432: wf_log_pkg.string(3, 'EDR_PSIG_RULE.create_pageflow','COMMIT Completed in Create pageflow');
433:
434: --Diagnostics Start
435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');
437: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
438: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
439: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
440: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 437: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

433:
434: --Diagnostics Start
435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');
437: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
438: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
439: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
440: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
441: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 438: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

434: --Diagnostics Start
435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');
437: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
438: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
439: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
440: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
441: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
442: FALSE

Line 439: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
436: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_SUCCESS_EVT');
437: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
438: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
439: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
440: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
441: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
442: FALSE
443: );

Line 465: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

461: p_err_code:=l_error;
462: p_err_msg:=l_error_msg;
463:
464: --Diagnostics Start
465: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
466: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
467: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
468: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 466: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

462: p_err_msg:=l_error_msg;
463:
464: --Diagnostics Start
465: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
466: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
467: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
468: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 467: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

463:
464: --Diagnostics Start
465: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
466: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
467: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
468: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
471: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 468: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');

464: --Diagnostics Start
465: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
466: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
467: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
468: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
471: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
472: FALSE

Line 489: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

485: p_err_code:=l_error;
486: p_err_msg:= l_error_msg;
487:
488: --Diagnostics Start
489: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
491: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
492: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

486: p_err_msg:= l_error_msg;
487:
488: --Diagnostics Start
489: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
491: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
492: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 491: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

487:
488: --Diagnostics Start
489: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
491: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
492: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
495: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 492: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');

488: --Diagnostics Start
489: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
490: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
491: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
492: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
495: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
496: FALSE

Line 514: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

510: ROLLBACK;
511: p_err_code:=l_error;
512: p_err_msg:=l_error_msg;
513: --Diagnostics Start
514: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
515: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
516: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
517: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
518: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 515: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

511: p_err_code:=l_error;
512: p_err_msg:=l_error_msg;
513: --Diagnostics Start
514: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
515: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
516: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
517: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
518: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 516: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

512: p_err_msg:=l_error_msg;
513: --Diagnostics Start
514: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
515: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
516: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
517: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
518: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
520: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',

Line 517: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');

513: --Diagnostics Start
514: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
515: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
516: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
517: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CREATE_PAGEFLOW');
518: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
520: 'edr.plsql.EDR_PSIG_RULE.CREATE_PAGEFLOW',
521: FALSE

Line 636: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PROC_EVT');

632: l_event_key:=x_event.getEventKey( );
633:
634: --Diagnostics Start
635: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
636: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PROC_EVT');
637: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
638: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
639: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
640: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 637: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

633:
634: --Diagnostics Start
635: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
636: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PROC_EVT');
637: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
638: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
639: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
640: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
641: FALSE

Line 638: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

634: --Diagnostics Start
635: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
636: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PROC_EVT');
637: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
638: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
639: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
640: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
641: FALSE
642: );

Line 676: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_EREC_EVT');

672: commit;
673:
674: --Diagnostics Start
675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
676: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_EREC_EVT');
677: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
678: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
679: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
680: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 677: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

673:
674: --Diagnostics Start
675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
676: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_EREC_EVT');
677: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
678: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
679: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
680: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
681: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 678: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

674: --Diagnostics Start
675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
676: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_EREC_EVT');
677: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
678: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
679: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
680: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
681: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
682: FALSE

Line 679: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
676: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_EREC_EVT');
677: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
678: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
679: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
680: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
681: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
682: FALSE
683: );

Line 707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');

703: --Bug 2637353: End
704:
705: --Diagnostics Start
706: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');
708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);

Line 708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

704:
705: --Diagnostics Start
706: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');
708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);

Line 709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

705: --Diagnostics Start
706: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');
708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

706: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');
708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
714: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);

707: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_RTF_EVT');
708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
714: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
715: FALSE

Line 712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);

708: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
709: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
710: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
711: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
712: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
714: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
715: FALSE
716: );

Line 802: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');

798: RAISE ERECORD_GEN_JSPRQFAIL_ERR;
799: END IF;
800:
801: /* Set the E-Record Notification Details to Message for PDF E-Records */
802: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
803: fnd_message.set_token('ERECORD_ID',l_document_id);
804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);

Line 803: fnd_message.set_token('ERECORD_ID',l_document_id);

799: END IF;
800:
801: /* Set the E-Record Notification Details to Message for PDF E-Records */
802: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
803: fnd_message.set_token('ERECORD_ID',l_document_id);
804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);

Line 805: l_erec_output_ch := fnd_message.get;

801: /* Set the E-Record Notification Details to Message for PDF E-Records */
802: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
803: fnd_message.set_token('ERECORD_ID',l_document_id);
804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);
808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);
809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));

Line 813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');

809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));
810:
811: --Diagnostics Start
812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');
814: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
815: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
816: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 814: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

810:
811: --Diagnostics Start
812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');
814: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
815: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
816: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
818: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 815: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

811: --Diagnostics Start
812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');
814: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
815: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
816: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
818: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
819: FALSE

Line 816: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');
814: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
815: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
816: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
818: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
819: FALSE
820: );

Line 832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');

828: IF(UPPER(l_style_sheet_type) = 'XSL') THEN
829:
830: --Diagnostics Start
831: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');
833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);

Line 833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

829:
830: --Diagnostics Start
831: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');
833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);

Line 834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

830: --Diagnostics Start
831: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');
833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
838: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

831: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');
833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
838: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
839: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);

832: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_EVT');
833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
838: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
839: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
840: FALSE

Line 837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);

833: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
834: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
835: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
836: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME',p_style_sheet);
837: FND_MESSAGE.SET_TOKEN('TEMPLATE_VER',p_style_sheet_ver);
838: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
839: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
840: FALSE
841: );

Line 968: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_SUC_EVT');

964: END IF;
965:
966: --Diagnostics Start
967: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_SUC_EVT');
969: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
970: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
971: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
972: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 969: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

965:
966: --Diagnostics Start
967: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_SUC_EVT');
969: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
970: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
971: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
972: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
973: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 970: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

966: --Diagnostics Start
967: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_SUC_EVT');
969: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
970: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
971: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
972: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
973: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
974: FALSE

Line 971: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

967: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_XSL_SUC_EVT');
969: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
970: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
971: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
972: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
973: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
974: FALSE
975: );

Line 1018: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_REC_UPD_EVT');

1014: END IF;
1015:
1016: --Diagnostics Start
1017: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1018: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_REC_UPD_EVT');
1019: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1020: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1021: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1019: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

1015:
1016: --Diagnostics Start
1017: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1018: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_REC_UPD_EVT');
1019: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1020: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1021: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1023: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1020: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

1016: --Diagnostics Start
1017: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1018: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_REC_UPD_EVT');
1019: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1020: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1021: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1023: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1024: FALSE

Line 1021: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

1017: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1018: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_REC_UPD_EVT');
1019: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1020: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1021: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1023: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1024: FALSE
1025: );

Line 1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');

1098:
1099:
1100: --Diagnostics Start
1101: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');
1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);

Line 1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

1099:
1100: --Diagnostics Start
1101: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');
1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);
1107: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

1100: --Diagnostics Start
1101: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');
1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);
1107: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1108: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

1101: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');
1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);
1107: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1108: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1109: FALSE

Line 1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);

1102: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_ATCH_EVT');
1103: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1104: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1105: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1106: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_edr_event_id);
1107: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1108: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1109: FALSE
1110: );

Line 1178: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_POST_EVT');

1174: END IF;
1175:
1176: --Diagnostics Start
1177: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1178: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_POST_EVT');
1179: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1180: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1181: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1182: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1179: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

1175:
1176: --Diagnostics Start
1177: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1178: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_POST_EVT');
1179: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1180: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1181: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1182: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1183: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1180: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

1176: --Diagnostics Start
1177: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1178: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_POST_EVT');
1179: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1180: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1181: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1182: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1183: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1184: FALSE

Line 1181: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

1177: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1178: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_POST_EVT');
1179: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1180: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1181: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1182: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1183: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1184: FALSE
1185: );

Line 1215: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_STATUS_EVT');

1211: COMMIT;
1212:
1213: --Diagnostics Start
1214: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1215: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_STATUS_EVT');
1216: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1217: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1218: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1219: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1216: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

1212:
1213: --Diagnostics Start
1214: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1215: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_STATUS_EVT');
1216: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1217: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1218: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1219: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1220: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1217: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);

1213: --Diagnostics Start
1214: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1215: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_STATUS_EVT');
1216: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1217: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1218: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1219: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1220: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1221: FALSE

Line 1218: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);

1214: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1215: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_STATUS_EVT');
1216: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);
1217: FND_MESSAGE.SET_TOKEN('EVENT_KEY',l_event_key);
1218: FND_MESSAGE.SET_TOKEN('ERECORD_ID',l_document_id);
1219: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1220: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1221: FALSE
1222: );

Line 1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1229: when ERECORD_GENERATION_ERROR then
1230: ROLLBACK;
1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
1237:

Line 1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1230: ROLLBACK;
1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
1237:
1238: --Diagnostics Start

Line 1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1231: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
1237:
1238: --Diagnostics Start
1239: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');

1232: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
1237:
1238: --Diagnostics Start
1239: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1240: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1248: when ERECORD_CREATION_ERROR then
1249: ROLLBACK;
1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1256:

Line 1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1249: ROLLBACK;
1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1256:
1257: --Diagnostics Start

Line 1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1250: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1256:
1257: --Diagnostics Start
1258: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

1251: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1252: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1253: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1254: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1255: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1256:
1257: --Diagnostics Start
1258: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1259: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1267: when ERECORD_PARAM_ERROR then
1268: ROLLBACK;
1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1275: --Diagnostics Start

Line 1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1268: ROLLBACK;
1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1275: --Diagnostics Start
1276: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1269: Wf_Core.Context('EDR_PSIG_RULE', 'STORE_ERECORD', x_event.getEventName(), p_subscription_guid);
1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1275: --Diagnostics Start
1276: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1277: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

1270: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1275: --Diagnostics Start
1276: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1277: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1278: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');

1287: when ERECORD_GEN_XSLFOMISS_ERR then
1288: ROLLBACK;
1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');
1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');
1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1294: --Diagnostics Start
1295: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);

1288: ROLLBACK;
1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');
1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');
1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1294: --Diagnostics Start
1295: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1296: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

1289: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1290: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR XSLFO MISSING');
1291: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLFO_MISSING_ERR');
1292: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1293: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1294: --Diagnostics Start
1295: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1296: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1297: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1307: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1308:
1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');
1310:
1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1314: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1315:

Line 1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1308:
1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');
1310:
1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1314: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1315:
1316: --Diagnostics Start

Line 1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1309: wf_log_pkg.string(5, 'EDR_PSIG_RULE.store_erecord','There is a fatal error during e-record creation using XDO API');
1310:
1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1314: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1315:
1316: --Diagnostics Start
1317: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1314: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

1310:
1311: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1313: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1314: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1315:
1316: --Diagnostics Start
1317: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1318: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1326: when ERECORD_GEN_UNKNWN_ERR then
1327: ROLLBACK;
1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1334:

Line 1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1327: ROLLBACK;
1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1334:
1335: --Diagnostics Start

Line 1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1328: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1334:
1335: --Diagnostics Start
1336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

1329: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1330: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1331: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1332: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1333: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1334:
1335: --Diagnostics Start
1336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1337: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');

1345: when ERECORD_GEN_XDOERR then
1346: ROLLBACK;
1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');
1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');
1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1352:
1353: --Diagnostics Start

Line 1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);

1346: ROLLBACK;
1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');
1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');
1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1352:
1353: --Diagnostics Start
1354: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

1347: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1348: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR IN XDO');
1349: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XDO_ERR');
1350: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1351: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1352:
1353: --Diagnostics Start
1354: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');

1363: when ERECORD_UNKWN_TMPL_TYPE then
1364: ROLLBACK;
1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);
1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');
1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1370:
1371: --Diagnostics Start

Line 1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);

1364: ROLLBACK;
1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);
1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');
1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1370:
1371: --Diagnostics Start
1372: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

1365: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1366: wf_event.setErrorInfo(x_event,SQLERRM || 'Unknown Template Type'|| l_style_sheet_type);
1367: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_TMPL_TYPE_ERR');
1368: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1369: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1370:
1371: --Diagnostics Start
1372: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1373: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 1386: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSP_MISSING_ERR');

1382: when ERECORD_GEN_JSPMSNG_ERR then
1383: ROLLBACK;
1384: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1385: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP MISSING');
1386: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSP_MISSING_ERR');
1387:
1388: --Diagnostics Start
1389: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1390: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1402: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSPREQFAIL_ERR');

1398: when ERECORD_GEN_JSPRQFAIL_ERR then
1399: ROLLBACK;
1400: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1401: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR JSP UTL_HTTP REQUEST FAILED');
1402: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_JSPREQFAIL_ERR');
1403:
1404: --Diagnostics Start
1405: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1406: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');

1417: when ERECORD_GEN_XSLT_ERR then
1418: ROLLBACK;
1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');
1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');
1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1424: --Diagnostics Start
1425: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);

1418: ROLLBACK;
1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');
1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');
1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1424: --Diagnostics Start
1425: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1426: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);

1419: wf_core.context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1420: Wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR : XSLT Transformation error');
1421: FND_MESSAGE.SET_NAME('EDR','EDR_EREC_XSLTTRANS_ERR');
1422: fnd_message.set_token( 'TEMPLATE_NAME',p_style_sheet);
1423: fnd_message.set_token( 'TEMPLATE_VER',p_style_sheet_ver);
1424: --Diagnostics Start
1425: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1426: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1427: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1438: FND_MESSAGE.SET_NAME('EDR','EDR_MSCA_TMPL_ERR');

1434: --Bug 3390571: End
1435:
1436: --Bug 2637353: Start
1437: WHEN MSCA_TMPL_ERROR THEN
1438: FND_MESSAGE.SET_NAME('EDR','EDR_MSCA_TMPL_ERR');
1439: --Diagnostics Start
1440: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1441: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1442: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1451: when OTHERS then
1452: ROLLBACK;
1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1459: --Diagnostics Start

Line 1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1452: ROLLBACK;
1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1459: --Diagnostics Start
1460: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

1453: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', x_event.getEventName(), p_subscription_guid);
1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1459: --Diagnostics Start
1460: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1461: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');

1454: wf_event.setErrorInfo(x_event,SQLERRM || 'ERROR');
1455: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1456: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1457: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
1458: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','STORE_ERECORD');
1459: --Diagnostics Start
1460: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1461: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1462: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',

Line 1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');

1758: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','AME transaction Type :'||l_ame_transaction_type );
1759:
1760: --Diagnostics Start
1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');
1763: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1764: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1765: FND_MESSAGE.SET_TOKEN('AME_TYPE',l_ame_transaction_type);
1766: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1763: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

1759:
1760: --Diagnostics Start
1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');
1763: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1764: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1765: FND_MESSAGE.SET_TOKEN('AME_TYPE',l_ame_transaction_type);
1766: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1767: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 1764: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

1760: --Diagnostics Start
1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');
1763: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1764: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1765: FND_MESSAGE.SET_TOKEN('AME_TYPE',l_ame_transaction_type);
1766: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1767: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1768: FALSE

Line 1765: FND_MESSAGE.SET_TOKEN('AME_TYPE',l_ame_transaction_type);

1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1762: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_START_EVT');
1763: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1764: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1765: FND_MESSAGE.SET_TOKEN('AME_TYPE',l_ame_transaction_type);
1766: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1767: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1768: FALSE
1769: );

Line 1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');

1810:
1811: if (l_inter_event_mode = 'Y') then
1812: --Diagnostics Start
1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');
1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));

Line 1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

1811: if (l_inter_event_mode = 'Y') then
1812: --Diagnostics Start
1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');
1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));
1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);

Line 1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

1812: --Diagnostics Start
1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');
1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));
1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);
1820: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));

1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');
1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));
1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);
1820: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1821: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));

1814: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTER_EVENT_EVT');
1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));
1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);
1820: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1821: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1822: FALSE

Line 1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);

1815: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1816: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1817: FND_MESSAGE.SET_TOKEN('PARENT_NAME',nvl(l_parent_event,'NULL'));
1818: FND_MESSAGE.SET_TOKEN('PARENT_KEY',nvl(l_parent_key,'NULL'));
1819: FND_MESSAGE.SET_TOKEN('PARENT_EREC_ID',l_parent_erecord_id);
1820: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1821: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1822: FALSE
1823: );

Line 1894: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTEREVENT_REL_EVT');

1890: l_relationship := upper(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(p_event.event_name,l_parent_sub_guid));
1891:
1892: --Diagnostics Start
1893: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1894: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTEREVENT_REL_EVT');
1895: FND_MESSAGE.SET_TOKEN('CHILD_NAME',p_event.getEventName());
1896: FND_MESSAGE.SET_TOKEN('PARENT_EVENT',l_parent_event);
1897: FND_MESSAGE.SET_TOKEN('RELATION',l_relationship);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1895: FND_MESSAGE.SET_TOKEN('CHILD_NAME',p_event.getEventName());

1891:
1892: --Diagnostics Start
1893: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1894: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTEREVENT_REL_EVT');
1895: FND_MESSAGE.SET_TOKEN('CHILD_NAME',p_event.getEventName());
1896: FND_MESSAGE.SET_TOKEN('PARENT_EVENT',l_parent_event);
1897: FND_MESSAGE.SET_TOKEN('RELATION',l_relationship);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1899: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 1896: FND_MESSAGE.SET_TOKEN('PARENT_EVENT',l_parent_event);

1892: --Diagnostics Start
1893: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1894: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTEREVENT_REL_EVT');
1895: FND_MESSAGE.SET_TOKEN('CHILD_NAME',p_event.getEventName());
1896: FND_MESSAGE.SET_TOKEN('PARENT_EVENT',l_parent_event);
1897: FND_MESSAGE.SET_TOKEN('RELATION',l_relationship);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1899: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1900: FALSE

Line 1897: FND_MESSAGE.SET_TOKEN('RELATION',l_relationship);

1893: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1894: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_INTEREVENT_REL_EVT');
1895: FND_MESSAGE.SET_TOKEN('CHILD_NAME',p_event.getEventName());
1896: FND_MESSAGE.SET_TOKEN('PARENT_EVENT',l_parent_event);
1897: FND_MESSAGE.SET_TOKEN('RELATION',l_relationship);
1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1899: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1900: FALSE
1901: );

Line 1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');

1972:
1973: if dbms_lob.getlength(l_event_data)>0 then
1974: --Diagnostics Start
1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1978: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1979: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','VIEW OBJECT');
1980: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

1973: if dbms_lob.getlength(l_event_data)>0 then
1974: --Diagnostics Start
1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1978: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1979: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','VIEW OBJECT');
1980: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1981: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 1978: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

1974: --Diagnostics Start
1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1978: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1979: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','VIEW OBJECT');
1980: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1981: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1982: FALSE

Line 1979: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','VIEW OBJECT');

1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
1978: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
1979: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','VIEW OBJECT');
1980: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
1981: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
1982: FALSE
1983: );

Line 2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');

2042:
2043: --Ensure that the ECX error handling is put here.
2044: --Diagnostics Start
2045: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');

Line 2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2043: --Ensure that the ECX error handling is put here.
2044: --Diagnostics Start
2045: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');
2051: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2044: --Diagnostics Start
2045: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');
2051: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2052: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);

2045: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');
2051: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2052: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2053: FALSE

Line 2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');

2046: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2047: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2048: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2049: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2050: FND_MESSAGE.SET_TOKEN('TRANS','XML TO XML');
2051: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2052: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2053: FALSE
2054: );

Line 2060: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_XML_TRANS_EVT');

2056: --Diagnostics End
2057: else
2058: --Diagnostics Start
2059: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2060: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_XML_TRANS_EVT');
2061: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2062: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2063: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2064: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2061: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2057: else
2058: --Diagnostics Start
2059: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2060: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_XML_TRANS_EVT');
2061: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2062: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2063: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2064: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2065: FALSE

Line 2062: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2058: --Diagnostics Start
2059: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2060: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_XML_TRANS_EVT');
2061: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2062: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2063: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2064: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2065: FALSE
2066: );

Line 2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');

2080: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','updated edr_final_xml_gt with the final xml');
2081: else
2082: --Diagnostics Start
2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
2085: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2086: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2087: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','DATABASE');
2088: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2085: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2081: else
2082: --Diagnostics Start
2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
2085: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2086: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2087: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','DATABASE');
2088: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2089: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2086: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2082: --Diagnostics Start
2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
2085: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2086: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2087: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','DATABASE');
2088: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2089: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2090: FALSE

Line 2087: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','DATABASE');

2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
2085: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2086: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2087: FND_MESSAGE.SET_TOKEN('DATA_SOURCE','DATABASE');
2088: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2089: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2090: FALSE
2091: );

Line 2145: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_APPROVERS_EVT');

2141:
2142: --Bug 5724159 :End
2143: --Diagnostics Start
2144: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2145: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_APPROVERS_EVT');
2146: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2147: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2149: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2146: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2142: --Bug 5724159 :End
2143: --Diagnostics Start
2144: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2145: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_APPROVERS_EVT');
2146: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2147: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2149: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2150: FALSE

Line 2147: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2143: --Diagnostics Start
2144: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2145: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_NO_APPROVERS_EVT');
2146: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2147: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2149: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2150: FALSE
2151: );

Line 2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');

2392: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet repository :'||l_style_sheet_repository);
2393:
2394: --Diagnostics Start
2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');
2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);

Line 2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2393:
2394: --Diagnostics Start
2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');
2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);

Line 2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2394: --Diagnostics Start
2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');
2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);

Line 2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);

2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');
2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);

Line 2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);

2396: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_PARAM_LIST_EVT');
2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);

Line 2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);

2397: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2405: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);

2398: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2405: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2406: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);

2399: FND_MESSAGE.SET_TOKEN('ESIG_VALUE',l_esign_required);
2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2405: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2406: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2407: FALSE

Line 2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);

2400: FND_MESSAGE.SET_TOKEN('EREC_VALUE',l_erecord_required);
2401: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2402: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2403: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2404: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2405: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2406: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2407: FALSE
2408: );

Line 2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');

2554: p_parameter_list => p_event.Parameter_List);
2555:
2556: --Diagnostics Start
2557: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');

Line 2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2555:
2556: --Diagnostics Start
2557: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2556: --Diagnostics Start
2557: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2564: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);

2557: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2564: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2565: FALSE

Line 2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');

2558: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2559: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2560: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2561: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2562: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2564: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2565: FALSE
2566: );

Line 2641: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');

2637: approversOut=>approverList); */
2638:
2639: --Diagnostics Start
2640: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2641: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2642: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2643: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2644: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);
2645: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2642: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2638:
2639: --Diagnostics Start
2640: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2641: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2642: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2643: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2644: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);
2645: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2646: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2643: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2639: --Diagnostics Start
2640: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2641: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2642: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2643: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2644: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);
2645: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2646: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2647: FALSE

Line 2644: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);

2640: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2641: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2642: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2643: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2644: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);
2645: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2646: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2647: FALSE
2648: );

Line 2706: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');

2702: --Bug 4543216: Start
2703:
2704: --Diagnostics Start
2705: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2706: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');
2707: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2708: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2710: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2707: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2703:
2704: --Diagnostics Start
2705: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2706: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');
2707: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2708: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2710: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2711: FALSE

Line 2708: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2704: --Diagnostics Start
2705: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2706: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');
2707: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2708: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2710: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2711: FALSE
2712: );

Line 2731: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');

2727: if l_approver_list is not null then
2728:
2729: --Diagnostics Start
2730: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2731: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2732: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2733: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2734: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);
2735: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2732: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2728:
2729: --Diagnostics Start
2730: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2731: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2732: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2733: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2734: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);
2735: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2736: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2733: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2729: --Diagnostics Start
2730: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2731: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2732: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2733: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2734: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);
2735: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2736: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2737: FALSE

Line 2734: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);

2730: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2731: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2732: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2733: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2734: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);
2735: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2736: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2737: FALSE
2738: );

Line 2773: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');

2769: if l_approver_count is not null then
2770:
2771: --Diagnostics Start
2772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2773: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');
2774: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2775: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2776: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
2777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2774: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2770:
2771: --Diagnostics Start
2772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2773: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');
2774: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2775: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2776: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
2777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2778: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2775: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2771: --Diagnostics Start
2772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2773: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');
2774: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2775: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2776: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
2777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2778: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2779: FALSE

Line 2776: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);

2772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2773: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');
2774: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2775: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2776: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
2777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2778: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2779: FALSE
2780: );

Line 2826: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');

2822: END IF;
2823:
2824: --Diagnostics Start
2825: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2826: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');
2827: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2828: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2829: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);
2830: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2827: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2823:
2824: --Diagnostics Start
2825: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2826: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');
2827: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2828: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2829: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);
2830: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2831: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2828: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2824: --Diagnostics Start
2825: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2826: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');
2827: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2828: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2829: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);
2830: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2831: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2832: FALSE

Line 2829: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);

2825: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2826: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');
2827: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2828: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2829: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);
2830: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2831: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2832: FALSE
2833: );

Line 2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');

2862: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');
2863:
2864: --Diagnostics Start
2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);

Line 2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

2863:
2864: --Diagnostics Start
2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);

Line 2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

2864: --Diagnostics Start
2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);
2872: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);

2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);
2872: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2873: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);

2866: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);
2872: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2873: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2874: FALSE

Line 2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);

2867: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2868: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2869: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2870: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2871: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);
2872: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2873: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2874: FALSE
2875: );

Line 2958: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');

2954:
2955: exception
2956: --Bug 4577122: Start
2957: when INVALID_FIRST_VOTER_WINS_SETUP then
2958: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');
2959: fnd_message.set_token( 'EVENT', l_error_event);
2960: APP_EXCEPTION.RAISE_EXCEPTION;
2961: return EDR_CONSTANTS_GRP.g_error_status;
2962: --Bug 4577122: End

Line 2959: fnd_message.set_token( 'EVENT', l_error_event);

2955: exception
2956: --Bug 4577122: Start
2957: when INVALID_FIRST_VOTER_WINS_SETUP then
2958: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');
2959: fnd_message.set_token( 'EVENT', l_error_event);
2960: APP_EXCEPTION.RAISE_EXCEPTION;
2961: return EDR_CONSTANTS_GRP.g_error_status;
2962: --Bug 4577122: End
2963:

Line 2965: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');

2961: return EDR_CONSTANTS_GRP.g_error_status;
2962: --Bug 4577122: End
2963:
2964: when NO_ENABLED_ERES_SUBSCRIPTION THEN
2965: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');
2966: fnd_message.set_token( 'EVENT', l_error_event);
2967: --Diagnostics Start
2968: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 2966: fnd_message.set_token( 'EVENT', l_error_event);

2962: --Bug 4577122: End
2963:
2964: when NO_ENABLED_ERES_SUBSCRIPTION THEN
2965: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');
2966: fnd_message.set_token( 'EVENT', l_error_event);
2967: --Diagnostics Start
2968: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2970: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 2979: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');

2975: APP_EXCEPTION.RAISE_EXCEPTION;
2976: return EDR_CONSTANTS_GRP.g_error_status;
2977:
2978: when NO_ERES_SUBSCRIPTION THEN
2979: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');
2980: fnd_message.set_token( 'EVENT', l_error_event);
2981:
2982: --Diagnostics Start
2983: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2980: fnd_message.set_token( 'EVENT', l_error_event);

2976: return EDR_CONSTANTS_GRP.g_error_status;
2977:
2978: when NO_ERES_SUBSCRIPTION THEN
2979: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');
2980: fnd_message.set_token( 'EVENT', l_error_event);
2981:
2982: --Diagnostics Start
2983: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2984: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 2995: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');

2991: APP_EXCEPTION.RAISE_EXCEPTION;
2992: return EDR_CONSTANTS_GRP.g_error_status;
2993:
2994: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2995: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
2996: fnd_message.set_token( 'EVENT',l_error_event);
2997: --Diagnostics Start
2998: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2999: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 2996: fnd_message.set_token( 'EVENT',l_error_event);

2992: return EDR_CONSTANTS_GRP.g_error_status;
2993:
2994: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2995: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
2996: fnd_message.set_token( 'EVENT',l_error_event);
2997: --Diagnostics Start
2998: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2999: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3000: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

3008:
3009: when PAGE_FLOW_FAILED then
3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3016: --Diagnostics Start

Line 3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

3009: when PAGE_FLOW_FAILED then
3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3016: --Diagnostics Start
3017: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3016: --Diagnostics Start
3017: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3018: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 3015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');

3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3012: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3014: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3016: --Diagnostics Start
3017: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3018: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3019: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3030: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_XML_TO_XML_ERR');

3026:
3027: --Bug 3667036: Start
3028: --Catch the XML to XML transformation error.
3029: when ECX_XML_TO_XML_ERROR then
3030: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_XML_TO_XML_ERR');
3031: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);
3032: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);
3033: --Diagnostics Start
3034: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3031: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);

3027: --Bug 3667036: Start
3028: --Catch the XML to XML transformation error.
3029: when ECX_XML_TO_XML_ERROR then
3030: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_XML_TO_XML_ERR');
3031: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);
3032: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);
3033: --Diagnostics Start
3034: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3035: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 3032: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);

3028: --Catch the XML to XML transformation error.
3029: when ECX_XML_TO_XML_ERROR then
3030: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_XML_TO_XML_ERR');
3031: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);
3032: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);
3033: --Diagnostics Start
3034: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3035: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3036: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3047: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_TRANSFORM_XML_VAR_ERR');

3043: --Bug 3667036: End
3044:
3045: --Bug 3893101: Start
3046: WHEN TRANSFORM_XML_VAR_ERROR then
3047: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_TRANSFORM_XML_VAR_ERR');
3048: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3049: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3050: --Diagnostics Start
3051: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3048: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3044:
3045: --Bug 3893101: Start
3046: WHEN TRANSFORM_XML_VAR_ERROR then
3047: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_TRANSFORM_XML_VAR_ERR');
3048: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3049: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3050: --Diagnostics Start
3051: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3052: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 3049: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3045: --Bug 3893101: Start
3046: WHEN TRANSFORM_XML_VAR_ERROR then
3047: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_TRANSFORM_XML_VAR_ERR');
3048: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3049: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3050: --Diagnostics Start
3051: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3052: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3053: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3064: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_USERS_PARAMS_ERR');

3060: --Bug 3893101: End
3061:
3062: --Bug 4160412: Start
3063: WHEN APPROVING_USERS_PARAMS_ERR THEN
3064: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_USERS_PARAMS_ERR');
3065: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3066: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3067: --Diagnostics Start
3068: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3065: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3061:
3062: --Bug 4160412: Start
3063: WHEN APPROVING_USERS_PARAMS_ERR THEN
3064: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_USERS_PARAMS_ERR');
3065: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3066: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3067: --Diagnostics Start
3068: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3069: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3066: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3062: --Bug 4160412: Start
3063: WHEN APPROVING_USERS_PARAMS_ERR THEN
3064: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_USERS_PARAMS_ERR');
3065: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3066: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3067: --Diagnostics Start
3068: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3069: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3070: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');

3075: APP_EXCEPTION.RAISE_EXCEPTION;
3076: return EDR_CONSTANTS_GRP.g_error_status;
3077:
3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3081: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3082: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3083: --Diagnostics Start

Line 3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3076: return EDR_CONSTANTS_GRP.g_error_status;
3077:
3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3081: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3082: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3083: --Diagnostics Start
3084: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3081: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3077:
3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3081: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3082: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3083: --Diagnostics Start
3084: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3085: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3082: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);

3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3081: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3082: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3083: --Diagnostics Start
3084: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3085: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3086: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');

3091: APP_EXCEPTION.RAISE_EXCEPTION;
3092: return EDR_CONSTANTS_GRP.g_error_status;
3093:
3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3097: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3098: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3099: --Diagnostics Start

Line 3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3092: return EDR_CONSTANTS_GRP.g_error_status;
3093:
3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3097: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3098: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3099: --Diagnostics Start
3100: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3097: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3093:
3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3097: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3098: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3099: --Diagnostics Start
3100: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3101: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3098: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);

3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3097: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3098: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3099: --Diagnostics Start
3100: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3101: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3102: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');

3107: APP_EXCEPTION.RAISE_EXCEPTION;
3108: return EDR_CONSTANTS_GRP.g_error_status;
3109:
3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
3113: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3114: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3115:

Line 3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);

3108: return EDR_CONSTANTS_GRP.g_error_status;
3109:
3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
3113: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3114: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3115:
3116: --Diagnostics Start

Line 3113: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3109:
3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
3113: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3114: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3115:
3116: --Diagnostics Start
3117: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3114: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
3113: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3114: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3115:
3116: --Diagnostics Start
3117: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3118: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');

3124: APP_EXCEPTION.RAISE_EXCEPTION;
3125: return EDR_CONSTANTS_GRP.g_error_status;
3126:
3127: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');
3129: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3130: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3131:
3132: --Diagnostics Start

Line 3129: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3125: return EDR_CONSTANTS_GRP.g_error_status;
3126:
3127: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');
3129: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3130: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3131:
3132: --Diagnostics Start
3133: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3130: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3126:
3127: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');
3129: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3130: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3131:
3132: --Diagnostics Start
3133: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3134: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3146: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_API_ERR');

3142: --Bug 4160412: End
3143:
3144: --Bug 3960236: Start
3145: WHEN API_EXECUTION_ERROR THEN
3146: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_API_ERR');
3147: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3148: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3149: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3150: --Diagnostics Start

Line 3147: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3143:
3144: --Bug 3960236: Start
3145: WHEN API_EXECUTION_ERROR THEN
3146: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_API_ERR');
3147: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3148: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3149: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3150: --Diagnostics Start
3151: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3148: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3144: --Bug 3960236: Start
3145: WHEN API_EXECUTION_ERROR THEN
3146: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_API_ERR');
3147: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3148: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3149: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3150: --Diagnostics Start
3151: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3152: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3149: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);

3145: WHEN API_EXECUTION_ERROR THEN
3146: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_API_ERR');
3147: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3148: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3149: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3150: --Diagnostics Start
3151: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3152: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3153: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3164: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_EMPTY_ERR');

3160: -- Bug 3960236 : end
3161:
3162:
3163: WHEN EMPTY_XML_DOCUMENT THEN
3164: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_EMPTY_ERR');
3165: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3166: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3167: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3168: --Diagnostics Start

Line 3165: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3161:
3162:
3163: WHEN EMPTY_XML_DOCUMENT THEN
3164: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_EMPTY_ERR');
3165: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3166: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3167: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3168: --Diagnostics Start
3169: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3166: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3162:
3163: WHEN EMPTY_XML_DOCUMENT THEN
3164: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_EMPTY_ERR');
3165: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3166: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3167: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3168: --Diagnostics Start
3169: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3170: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3167: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);

3163: WHEN EMPTY_XML_DOCUMENT THEN
3164: FND_MESSAGE.SET_NAME('EDR','EDR_XMLCALLBACK_EMPTY_ERR');
3165: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3166: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3167: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3168: --Diagnostics Start
3169: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3170: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3171: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3184: FND_MESSAGE.SET_NAME('EDR','EDR_NO_SIGNER_DEF_ERR');

3180: --Bug 5724159 :start
3181: --define a new exception to throw error message when there are no approvers, Signature mode is SHORT
3182: --and the Adhoc Signer capability is ALL or ADHOC.
3183: WHEN NO_SIGNERS_DEF_FOR_LITE_MODE THEN
3184: FND_MESSAGE.SET_NAME('EDR','EDR_NO_SIGNER_DEF_ERR');
3185: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3186: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3187: --Diagnostics Start
3188: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3185: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

3181: --define a new exception to throw error message when there are no approvers, Signature mode is SHORT
3182: --and the Adhoc Signer capability is ALL or ADHOC.
3183: WHEN NO_SIGNERS_DEF_FOR_LITE_MODE THEN
3184: FND_MESSAGE.SET_NAME('EDR','EDR_NO_SIGNER_DEF_ERR');
3185: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3186: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3187: --Diagnostics Start
3188: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 3186: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());

3182: --and the Adhoc Signer capability is ALL or ADHOC.
3183: WHEN NO_SIGNERS_DEF_FOR_LITE_MODE THEN
3184: FND_MESSAGE.SET_NAME('EDR','EDR_NO_SIGNER_DEF_ERR');
3185: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3186: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3187: --Diagnostics Start
3188: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3190: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',

Line 3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

3198:
3199: when others then
3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3201: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3205: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3206: --Diagnostics Start

Line 3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

3199: when others then
3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3201: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3205: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3206: --Diagnostics Start
3207: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');

3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3201: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3205: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3206: --Diagnostics Start
3207: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3208: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 3205: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');

3201: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3202: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
3203: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3204: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3205: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3206: --Diagnostics Start
3207: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3208: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3209: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',