eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on FND_LOG

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

34: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.transaction.error',
35: p_event_key => to_char(l_event_key),
36: p_parameters => l_parameter_list);
37:
38: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
39: fnd_log.string(fnd_log.level_event,
40: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',
41: 'Raised validation event with key = '||to_char(l_event_key));
42: end if;

Line 39: fnd_log.string(fnd_log.level_event,

35: p_event_key => to_char(l_event_key),
36: p_parameters => l_parameter_list);
37:
38: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
39: fnd_log.string(fnd_log.level_event,
40: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',
41: 'Raised validation event with key = '||to_char(l_event_key));
42: end if;
43:

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

55: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.transaction.error',
56: p_event_key => to_char(l_event_key),
57: p_parameters => l_parameter_list);
58:
59: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
60: fnd_log.string(fnd_log.level_event,
61: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',
62: 'Raised validation event with key = '||to_char(l_event_key));
63: end if;

Line 60: fnd_log.string(fnd_log.level_event,

56: p_event_key => to_char(l_event_key),
57: p_parameters => l_parameter_list);
58:
59: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
60: fnd_log.string(fnd_log.level_event,
61: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',
62: 'Raised validation event with key = '||to_char(l_event_key));
63: end if;
64: end loop;

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

153: return;
154: end if;
155: exception
156: when others then
157: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
158: fnd_log.string(fnd_log.level_unexpected,
159: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.count_invalid',
160: sqlerrm);
161: end if;

Line 158: fnd_log.string(fnd_log.level_unexpected,

154: end if;
155: exception
156: when others then
157: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
158: fnd_log.string(fnd_log.level_unexpected,
159: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.count_invalid',
160: sqlerrm);
161: end if;
162: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'COUNT_INVALID',

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

209: return;
210: end if;
211: exception
212: when others then
213: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
214: fnd_log.string(fnd_log.level_unexpected,
215: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_search_page_url',
216: sqlerrm);
217: end if;

Line 214: fnd_log.string(fnd_log.level_unexpected,

210: end if;
211: exception
212: when others then
213: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
214: fnd_log.string(fnd_log.level_unexpected,
215: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_search_page_url',
216: sqlerrm);
217: end if;
218: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_SEARCH_PAGE_URL',

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

248:
249: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
250: p_event_key => to_char(l_event_key),
251: p_parameters => l_parameter_list);
252: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
253: fnd_log.string(fnd_log.level_event,
254: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',
255: 'Raised new card event with key = '||to_char(l_event_key));
256: end if;

Line 253: fnd_log.string(fnd_log.level_event,

249: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
250: p_event_key => to_char(l_event_key),
251: p_parameters => l_parameter_list);
252: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
253: fnd_log.string(fnd_log.level_event,
254: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',
255: 'Raised new card event with key = '||to_char(l_event_key));
256: end if;
257: else

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

267:
268: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
269: p_event_key => to_char(l_event_key),
270: p_parameters => l_parameter_list);
271: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
272: fnd_log.string(fnd_log.level_event,
273: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',
274: 'Raised new card event with key = '||to_char(l_event_key));
275: end if;

Line 272: fnd_log.string(fnd_log.level_event,

268: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
269: p_event_key => to_char(l_event_key),
270: p_parameters => l_parameter_list);
271: if ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
272: fnd_log.string(fnd_log.level_event,
273: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',
274: 'Raised new card event with key = '||to_char(l_event_key));
275: end if;
276: end loop;

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

326: return;
327: end if;
328: exception
329: when others then
330: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
331: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
332: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.CARD_EMPLOYEE_MATCH',
333: sqlerrm);
334: end if;

Line 331: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

327: end if;
328: exception
329: when others then
330: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
331: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
332: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.CARD_EMPLOYEE_MATCH',
333: sqlerrm);
334: end if;
335: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'CARD_EMPLOYEE_MATCH',

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

376: return;
377: end if;
378: exception
379: when others then
380: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
381: fnd_log.string(fnd_log.level_unexpected,
382: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.ASSIGN_EMP_IF_UNIQUE',
383: sqlerrm);
384: end if;

Line 381: fnd_log.string(fnd_log.level_unexpected,

377: end if;
378: exception
379: when others then
380: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
381: fnd_log.string(fnd_log.level_unexpected,
382: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.ASSIGN_EMP_IF_UNIQUE',
383: sqlerrm);
384: end if;
385: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'ASSIGN_EMP_IF_UNIQUE',

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

417: return;
418: end if;
419: exception
420: when others then
421: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
422: fnd_log.string(fnd_log.level_unexpected,
423: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.NEW_CARDS_EXIST',
424: sqlerrm);
425: end if;

Line 422: fnd_log.string(fnd_log.level_unexpected,

418: end if;
419: exception
420: when others then
421: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
422: fnd_log.string(fnd_log.level_unexpected,
423: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.NEW_CARDS_EXIST',
424: sqlerrm);
425: end if;
426: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'NEW_CARDS_EXIST',

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

459: return;
460: end if;
461: exception
462: when others then
463: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
464: fnd_log.string(fnd_log.level_unexpected,
465: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INACTIVE_CARDS_EXIST',
466: sqlerrm);
467: end if;

Line 464: fnd_log.string(fnd_log.level_unexpected,

460: end if;
461: exception
462: when others then
463: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
464: fnd_log.string(fnd_log.level_unexpected,
465: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INACTIVE_CARDS_EXIST',
466: sqlerrm);
467: end if;
468: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INACTIVE_CARDS_EXIST',

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

518: return;
519: end if;
520: exception
521: when others then
522: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
523: fnd_log.string(fnd_log.level_unexpected,
524: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INVALID_CCTRX_EXIST',
525: sqlerrm);
526: end if;

Line 523: fnd_log.string(fnd_log.level_unexpected,

519: end if;
520: exception
521: when others then
522: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
523: fnd_log.string(fnd_log.level_unexpected,
524: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INVALID_CCTRX_EXIST',
525: sqlerrm);
526: end if;
527: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INVALID_CCTRX_EXIST',

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

558: return;
559: end if;
560: exception
561: when others then
562: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: fnd_log.string(fnd_log.level_unexpected,
564: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.COUNT_NEW_CARDS',
565: sqlerrm);
566: end if;

Line 563: fnd_log.string(fnd_log.level_unexpected,

559: end if;
560: exception
561: when others then
562: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: fnd_log.string(fnd_log.level_unexpected,
564: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.COUNT_NEW_CARDS',
565: sqlerrm);
566: end if;
567: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'COUNT_NEW_CARDS',

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

607: return;
608: end if;
609: exception
610: when others then
611: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
612: fnd_log.string(fnd_log.level_unexpected,
613: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_new_card_page_url',
614: sqlerrm);
615: end if;

Line 612: fnd_log.string(fnd_log.level_unexpected,

608: end if;
609: exception
610: when others then
611: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
612: fnd_log.string(fnd_log.level_unexpected,
613: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_new_card_page_url',
614: sqlerrm);
615: end if;
616: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_NEW_CARD_PAGE_URL',

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

659: return;
660: end if;
661: exception
662: when others then
663: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
664: fnd_log.string(fnd_log.level_unexpected,
665: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.whoami',
666: sqlerrm);
667: end if;

Line 664: fnd_log.string(fnd_log.level_unexpected,

660: end if;
661: exception
662: when others then
663: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
664: fnd_log.string(fnd_log.level_unexpected,
665: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.whoami',
666: sqlerrm);
667: end if;
668: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'WHOAMI',

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

727: return;
728: end if;
729: exception
730: when others then
731: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
732: fnd_log.string(fnd_log.level_unexpected,
733: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_SYSADMIN', sqlerrm);
734: end if;
735: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_SYSADMIN',

Line 732: fnd_log.string(fnd_log.level_unexpected,

728: end if;
729: exception
730: when others then
731: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
732: fnd_log.string(fnd_log.level_unexpected,
733: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_SYSADMIN', sqlerrm);
734: end if;
735: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_SYSADMIN',
736: itemtype, itemkey, to_char(actid), funcmode);

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

772: return;
773: end if;
774: exception
775: when others then
776: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
777: fnd_log.string(fnd_log.level_unexpected,
778: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_PROGRAM_NAME', sqlerrm);
779: end if;
780: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_PROGRAM_NAME',

Line 777: fnd_log.string(fnd_log.level_unexpected,

773: end if;
774: exception
775: when others then
776: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
777: fnd_log.string(fnd_log.level_unexpected,
778: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_PROGRAM_NAME', sqlerrm);
779: end if;
780: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_PROGRAM_NAME',
781: itemtype, itemkey, to_char(actid), funcmode);

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

805: return;
806: end if;
807: exception
808: when others then
809: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: fnd_log.string(fnd_log.level_unexpected,
811: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
812: end if;
813: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

Line 810: fnd_log.string(fnd_log.level_unexpected,

806: end if;
807: exception
808: when others then
809: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: fnd_log.string(fnd_log.level_unexpected,
811: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
812: end if;
813: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',
814: itemtype, itemkey, to_char(actid), funcmode);

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

837: return;
838: end if;
839: exception
840: when others then
841: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
842: fnd_log.string(fnd_log.level_unexpected,
843: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
844: end if;
845: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

Line 842: fnd_log.string(fnd_log.level_unexpected,

838: end if;
839: exception
840: when others then
841: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
842: fnd_log.string(fnd_log.level_unexpected,
843: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
844: end if;
845: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',
846: itemtype, itemkey, to_char(actid), funcmode);

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

872: return;
873: end if;
874: exception
875: when others then
876: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
877: fnd_log.string(fnd_log.level_unexpected,
878: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_INSTRUCTIONS', sqlerrm);
879: end if;
880: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_INSTRUCTIONS',

Line 877: fnd_log.string(fnd_log.level_unexpected,

873: end if;
874: exception
875: when others then
876: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
877: fnd_log.string(fnd_log.level_unexpected,
878: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_INSTRUCTIONS', sqlerrm);
879: end if;
880: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_INSTRUCTIONS',
881: itemtype, itemkey, to_char(actid), funcmode);