APPS.EDR_PSIG_RULE dependencies on FND_LOG

Line 203: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

199: l_event_key:=P_eventP.getEventKey( );
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,

Line 207: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
211: end if;

Line 256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

252: -- and eSignature Required scenarios
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);

Line 261: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
265: end if;

Line 309: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

305:
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);

Line 316: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
320: end if;

Line 349: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

345: L_OVERRIDING_COMMENTS);
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);

Line 355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
359: end if;

Line 391: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

387: --Bug 3416357: end
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);

Line 397: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
401: end if;

Line 435: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

431: COMMIT;
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);

Line 440: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
444: end if;

Line 469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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
473: );

Line 470: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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
473: );
474: end if;

Line 493: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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
497: );

Line 494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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
497: );
498: end if;

Line 518: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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
522: );

Line 519: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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
522: );
523: end if;

Line 635: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

631: l_event_name:=x_event.getEventName( );
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,

Line 639: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
643: end if;

Line 675: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

671: wf_log_pkg.string(3, 'EDR_PSIG_RULE.store_erecord','committing the transaction in store erecord');
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);

Line 680: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
684: end if;

Line 706: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

702: END IF;
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);

Line 713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
717: end if;

Line 812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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));
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);

Line 817: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
821: end if;

Line 831: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

827: -- For normal XSL stylsheet generate HTML eRecord using ECX Transformations
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);

Line 838: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
842: end if;

Line 967: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

963: RAISE ERECORD_GEN_XSLT_ERR;
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);

Line 972: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
976: end if;

Line 1017: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1013: RAISE ERECORD_CREATION_ERROR;
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);

Line 1022: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1026: end if;

Line 1101: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1097: ||'from '||p_edr_event_id);
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);

Line 1107: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1111: end if;

Line 1177: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1173: RAISE ERECORD_PARAM_ERROR;
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);

Line 1182: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1186: end if;

Line 1214: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1210: -- If everything went fine, commiting the ERECORD Contents by commiting this autonomous transaction
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);

Line 1219: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1223: end if;

Line 1239: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1241: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1242: FALSE
1243: );

Line 1240: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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,
1241: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1242: FALSE
1243: );
1244: end if;

Line 1258: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1260: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1261: FALSE
1262: );

Line 1259: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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,
1260: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1261: FALSE
1262: );
1263: end if;

Line 1276: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
1279: FALSE
1280: );

Line 1277: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
1279: FALSE
1280: );
1281: end if;

Line 1295: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
1298: FALSE
1299: );

Line 1296: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
1298: FALSE
1299: );
1300: end if;

Line 1317: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1319: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1320: FALSE
1321: );

Line 1318: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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,
1319: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1320: FALSE
1321: );
1322: end if;

Line 1336: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1338: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1339: FALSE
1340: );

Line 1337: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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,
1338: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1339: FALSE
1340: );
1341: end if;

Line 1354: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1356: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1357: FALSE
1358: );

Line 1355: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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,
1356: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1357: FALSE
1358: );
1359: end if;

Line 1372: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1374: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1375: FALSE
1376: );

Line 1373: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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,
1374: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1375: FALSE
1376: );
1377: end if;

Line 1389: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1391: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1392: FALSE
1393: );

Line 1390: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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,
1391: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1392: FALSE
1393: );
1394: end if;

Line 1405: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
1407: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1408: FALSE
1409: );

Line 1406: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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,
1407: 'edr.plsql.EDR_PSIG_RULE.STORE_ERECORD',
1408: FALSE
1409: );
1410: end if;

Line 1425: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
1428: FALSE
1429: );

Line 1426: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
1428: FALSE
1429: );
1430: end if;

Line 1440: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
1443: FALSE
1444: );

Line 1441: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
1443: FALSE
1444: );
1445: end if;

Line 1460: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
1463: FALSE
1464: );

Line 1461: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
1463: FALSE
1464: );
1465: end if;

Line 1761: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1757:
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);

Line 1766: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1770: end if;

Line 1813: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1809: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Inter Event Mode: '||l_inter_event_mode);
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'));

Line 1820: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1824: end if;

Line 1893: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1889:
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);

Line 1898: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1902: end if;

Line 1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1971: from EDR_FINAL_XML_GT;
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');

Line 1980: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
1984: end if;

Line 2045: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2041: if l_transform_xml = 'Y' then
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);

Line 2051: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2055: end if;

Line 2059: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2055: end if;
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,

Line 2063: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2067: end if;

Line 2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2079:
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');

Line 2088: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2092: end if;

Line 2144: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2140: and (nvl(l_relationship,'EDR') <> EDR_CONSTANTS_GRP.g_erecord_only) and l_ruleids.count >0 )then
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,

Line 2148: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2152: end if;

Line 2395: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2391: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','StyleSheet Version :'||l_style_sheet_ver);
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);

Line 2405: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2409: end if;

Line 2557: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2553: p_event_key => P_EVENT.getEventKey(),
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);

Line 2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2567: end if;

Line 2640: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2636: transactionTypeIn=>NVL(l_ame_transaction_type,P_EVENT.getEventName( )),
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);

Line 2645: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2649: end if;

Line 2705: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2701: if l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE then
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,

Line 2709: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2713: end if;

Line 2730: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2726: --If approving users are set, then fetch the approver list from the comma separated string.
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);

Line 2735: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2739: end if;

Line 2772: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2768:
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);

Line 2777: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2781: end if;

Line 2825: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2821: end if;
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);

Line 2830: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2834: end if;

Line 2865: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2861: /* CAll Page Flow Creation API */
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);

Line 2872: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

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: );
2876: end if;

Line 2968: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
2971: FALSE
2972: );

Line 2969: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
2971: FALSE
2972: );
2973: end if;

Line 2983: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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,
2985: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2986: FALSE
2987: );

Line 2984: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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,
2985: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2986: FALSE
2987: );
2988: end if;

Line 2998: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3001: FALSE
3002: );

Line 2999: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3001: FALSE
3002: );
3003: end if;

Line 3017: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3020: FALSE
3021: );

Line 3018: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
3020: FALSE
3021: );
3022: end if;

Line 3034: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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',
3037: FALSE
3038: );

Line 3035: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
3037: FALSE
3038: );
3039: end if;

Line 3051: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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',
3054: FALSE
3055: );

Line 3052: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
3054: FALSE
3055: );
3056: end if;

Line 3068: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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',
3071: FALSE
3072: );

Line 3069: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3071: FALSE
3072: );
3073: end if;

Line 3084: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3087: FALSE
3088: );

Line 3085: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3087: FALSE
3088: );
3089: end if;

Line 3100: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3103: FALSE
3104: );

Line 3101: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3103: FALSE
3104: );
3105: end if;

Line 3117: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
3119: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3120: FALSE
3121: );

Line 3118: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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,
3119: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3120: FALSE
3121: );
3122: end if;

Line 3133: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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,
3135: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3136: FALSE
3137: );

Line 3134: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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,
3135: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3136: FALSE
3137: );
3138: end if;

Line 3151: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3154: FALSE
3155: );

Line 3152: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3154: FALSE
3155: );
3156: end if;

Line 3169: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3172: FALSE
3173: );

Line 3170: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3172: FALSE
3173: );
3174: end if;

Line 3188: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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',
3191: FALSE
3192: );

Line 3189: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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',
3191: FALSE
3192: );
3193: end if;

Line 3207: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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',
3210: FALSE
3211: );

Line 3208: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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',
3210: FALSE
3211: );
3212: end if;