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 2399: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

Line 2409: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2405: FND_MESSAGE.SET_TOKEN('STYLE_SHEET',l_style_sheet);
2406: FND_MESSAGE.SET_TOKEN('STYLE_VER',l_style_sheet_ver);
2407: FND_MESSAGE.SET_TOKEN('STYLE_REP',l_style_sheet_repository);
2408: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2409: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2410: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2411: FALSE
2412: );
2413: end if;

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

2557: p_event_key => P_EVENT.getEventKey(),
2558: p_parameter_list => p_event.Parameter_List);
2559:
2560: --Diagnostics Start
2561: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2562: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_ECX_GEN_EVT');
2563: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2564: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2565: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);

Line 2567: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2563: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2564: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2565: FND_MESSAGE.SET_TOKEN('XML_MAP_CODE',l_xml_map_code);
2566: FND_MESSAGE.SET_TOKEN('TRANS','DB TO XML');
2567: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2568: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2569: FALSE
2570: );
2571: end if;

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

2640: transactionTypeIn=>NVL(l_ame_transaction_type,P_EVENT.getEventName( )),
2641: approversOut=>approverList); */
2642:
2643: --Diagnostics Start
2644: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2645: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2646: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2647: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2648: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);

Line 2649: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2645: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_APPROVER_COUNT_EVT');
2646: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2647: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2648: FND_MESSAGE.SET_TOKEN('COUNT',approverList.count);
2649: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2650: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2651: FALSE
2652: );
2653: end if;

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

2705: if l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE then
2706: --Bug 4543216: Start
2707:
2708: --Diagnostics Start
2709: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');
2711: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2712: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

Line 2713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2709: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2710: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_SIGN_MODE_EVT');
2711: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2712: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2713: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2714: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2715: FALSE
2716: );
2717: end if;

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

2730: --If approving users are set, then fetch the approver list from the comma separated string.
2731: if l_approver_list is not null then
2732:
2733: --Diagnostics Start
2734: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2735: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2736: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2737: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2738: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);

Line 2739: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2735: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_LIST_EVT');
2736: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2737: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2738: FND_MESSAGE.SET_TOKEN('APPROVER_LIST',l_approver_list);
2739: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2740: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2741: FALSE
2742: );
2743: end if;

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

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

Line 2781: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2777: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_COUNT_EVT');
2778: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2779: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2780: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
2781: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2782: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2783: FALSE
2784: );
2785: end if;

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

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

Line 2834: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2830: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_DEFER_MODE_EVT');
2831: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2832: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2833: FND_MESSAGE.SET_TOKEN('DEFER_MODE',l_einitials_defer_mode);
2834: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2835: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2836: FALSE
2837: );
2838: end if;

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

2865: /* CAll Page Flow Creation API */
2866: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','Calling Page Flow Creation Procedure');
2867:
2868: --Diagnostics Start
2869: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2870: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_WF_PARAMS_EVT');
2871: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
2872: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2873: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);

Line 2876: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,

2872: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
2873: FND_MESSAGE.SET_TOKEN('ITEM_TYPE',l_wftype);
2874: FND_MESSAGE.SET_TOKEN('ITEM_KEY',l_edr_event_id);
2875: FND_MESSAGE.SET_TOKEN('PROCESS',l_wfprocess);
2876: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,
2877: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2878: FALSE
2879: );
2880: end if;

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

2968: when NO_ENABLED_ERES_SUBSCRIPTION THEN
2969: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');
2970: fnd_message.set_token( 'EVENT', l_error_event);
2971: --Diagnostics Start
2972: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2973: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2974: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2975: FALSE
2976: );

Line 2973: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

2969: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');
2970: fnd_message.set_token( 'EVENT', l_error_event);
2971: --Diagnostics Start
2972: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2973: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2974: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2975: FALSE
2976: );
2977: end if;

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

2983: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');
2984: fnd_message.set_token( 'EVENT', l_error_event);
2985:
2986: --Diagnostics Start
2987: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2988: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2989: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2990: FALSE
2991: );

Line 2988: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

2984: fnd_message.set_token( 'EVENT', l_error_event);
2985:
2986: --Diagnostics Start
2987: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2988: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
2989: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
2990: FALSE
2991: );
2992: end if;

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

2998: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2999: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
3000: fnd_message.set_token( 'EVENT',l_error_event);
3001: --Diagnostics Start
3002: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3003: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3004: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3005: FALSE
3006: );

Line 3003: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

2999: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
3000: fnd_message.set_token( 'EVENT',l_error_event);
3001: --Diagnostics Start
3002: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3003: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3004: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3005: FALSE
3006: );
3007: end if;

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

3017: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3018: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3019: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3020: --Diagnostics Start
3021: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3022: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3023: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3024: FALSE
3025: );

Line 3022: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

3018: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3019: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3020: --Diagnostics Start
3021: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3022: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3023: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3024: FALSE
3025: );
3026: end if;

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

3034: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_XML_TO_XML_ERR');
3035: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);
3036: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);
3037: --Diagnostics Start
3038: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3039: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3040: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3041: FALSE
3042: );

Line 3039: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

3035: FND_MESSAGE.SET_TOKEN('EXCEPTION_MESSAGE',l_errbuf);
3036: FND_MESSAGE.SET_TOKEN('LOG',l_log_file);
3037: --Diagnostics Start
3038: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3039: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3040: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3041: FALSE
3042: );
3043: end if;

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

3051: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_TRANSFORM_XML_VAR_ERR');
3052: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3053: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3054: --Diagnostics Start
3055: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3057: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3058: FALSE
3059: );

Line 3056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

3052: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3053: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3054: --Diagnostics Start
3055: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3057: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3058: FALSE
3059: );
3060: end if;

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

3068: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_USERS_PARAMS_ERR');
3069: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3070: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3071: --Diagnostics Start
3072: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3073: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3074: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3075: FALSE
3076: );

Line 3073: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3069: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3070: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3071: --Diagnostics Start
3072: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3073: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3074: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3075: FALSE
3076: );
3077: end if;

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

3084: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3085: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3086: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3087: --Diagnostics Start
3088: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3089: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3090: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3091: FALSE
3092: );

Line 3089: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3085: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3086: FND_MESSAGE.SET_TOKEN('APPROVER_NAMES',l_invalid_approvers);
3087: --Diagnostics Start
3088: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3089: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3090: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3091: FALSE
3092: );
3093: end if;

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

3100: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3101: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3102: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3103: --Diagnostics Start
3104: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3105: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3106: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3107: FALSE
3108: );

Line 3105: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3101: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3102: FND_MESSAGE.SET_TOKEN('STRING',l_approver_list);
3103: --Diagnostics Start
3104: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3105: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3106: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3107: FALSE
3108: );
3109: end if;

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

3117: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3118: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3119:
3120: --Diagnostics Start
3121: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3122: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3123: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3124: FALSE
3125: );

Line 3122: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3118: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3119:
3120: --Diagnostics Start
3121: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3122: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3123: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3124: FALSE
3125: );
3126: end if;

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

3133: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3134: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3135:
3136: --Diagnostics Start
3137: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3138: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3139: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3140: FALSE
3141: );

Line 3138: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3134: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3135:
3136: --Diagnostics Start
3137: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3138: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3139: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3140: FALSE
3141: );
3142: end if;

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

3151: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3152: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3153: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3154: --Diagnostics Start
3155: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3156: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3157: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3158: FALSE
3159: );

Line 3156: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3152: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3153: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM||': '||l_xml_generation_api);
3154: --Diagnostics Start
3155: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3156: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3157: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3158: FALSE
3159: );
3160: end if;

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

3169: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3170: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3171: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3172: --Diagnostics Start
3173: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3174: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3175: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3176: FALSE
3177: );

Line 3174: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3170: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3171: FND_MESSAGE.SET_TOKEN('APINAME',SQLERRM);
3172: --Diagnostics Start
3173: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3174: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3175: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3176: FALSE
3177: );
3178: end if;

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

3188: FND_MESSAGE.SET_NAME('EDR','EDR_NO_SIGNER_DEF_ERR');
3189: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3190: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3191: --Diagnostics Start
3192: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3193: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3194: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3195: FALSE
3196: );

Line 3193: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

3189: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3190: FND_MESSAGE.SET_TOKEN('EVENT_KEY',p_event.getEventKey());
3191: --Diagnostics Start
3192: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3193: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
3194: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3195: FALSE
3196: );
3197: end if;

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

3207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
3208: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3209: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3210: --Diagnostics Start
3211: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3212: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3213: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3214: FALSE
3215: );

Line 3212: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

3208: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_RULE');
3209: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_RULE');
3210: --Diagnostics Start
3211: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3212: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
3213: 'edr.plsql.EDR_PSIG_RULE.PSIG_RULE',
3214: FALSE
3215: );
3216: end if;