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

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

Line 249: fnd_log.string(fnd_log.level_event,

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

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

302: return;
303: end if;
304: exception
305: when others then
306: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
307: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
308: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.CARD_EMPLOYEE_MATCH',
309: sqlerrm);
310: end if;

Line 307: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,

303: end if;
304: exception
305: when others then
306: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
307: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
308: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.CARD_EMPLOYEE_MATCH',
309: sqlerrm);
310: end if;
311: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'CARD_EMPLOYEE_MATCH',

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

352: return;
353: end if;
354: exception
355: when others then
356: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
357: fnd_log.string(fnd_log.level_unexpected,
358: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.ASSIGN_EMP_IF_UNIQUE',
359: sqlerrm);
360: end if;

Line 357: fnd_log.string(fnd_log.level_unexpected,

353: end if;
354: exception
355: when others then
356: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
357: fnd_log.string(fnd_log.level_unexpected,
358: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.ASSIGN_EMP_IF_UNIQUE',
359: sqlerrm);
360: end if;
361: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'ASSIGN_EMP_IF_UNIQUE',

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

393: return;
394: end if;
395: exception
396: when others then
397: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
398: fnd_log.string(fnd_log.level_unexpected,
399: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.NEW_CARDS_EXIST',
400: sqlerrm);
401: end if;

Line 398: fnd_log.string(fnd_log.level_unexpected,

394: end if;
395: exception
396: when others then
397: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
398: fnd_log.string(fnd_log.level_unexpected,
399: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.NEW_CARDS_EXIST',
400: sqlerrm);
401: end if;
402: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'NEW_CARDS_EXIST',

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

435: return;
436: end if;
437: exception
438: when others then
439: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
440: fnd_log.string(fnd_log.level_unexpected,
441: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INACTIVE_CARDS_EXIST',
442: sqlerrm);
443: end if;

Line 440: fnd_log.string(fnd_log.level_unexpected,

436: end if;
437: exception
438: when others then
439: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
440: fnd_log.string(fnd_log.level_unexpected,
441: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INACTIVE_CARDS_EXIST',
442: sqlerrm);
443: end if;
444: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INACTIVE_CARDS_EXIST',

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

494: return;
495: end if;
496: exception
497: when others then
498: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
499: fnd_log.string(fnd_log.level_unexpected,
500: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INVALID_CCTRX_EXIST',
501: sqlerrm);
502: end if;

Line 499: fnd_log.string(fnd_log.level_unexpected,

495: end if;
496: exception
497: when others then
498: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
499: fnd_log.string(fnd_log.level_unexpected,
500: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INVALID_CCTRX_EXIST',
501: sqlerrm);
502: end if;
503: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INVALID_CCTRX_EXIST',

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

534: return;
535: end if;
536: exception
537: when others then
538: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: fnd_log.string(fnd_log.level_unexpected,
540: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.COUNT_NEW_CARDS',
541: sqlerrm);
542: end if;

Line 539: fnd_log.string(fnd_log.level_unexpected,

535: end if;
536: exception
537: when others then
538: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: fnd_log.string(fnd_log.level_unexpected,
540: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.COUNT_NEW_CARDS',
541: sqlerrm);
542: end if;
543: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'COUNT_NEW_CARDS',

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

583: return;
584: end if;
585: exception
586: when others then
587: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
588: fnd_log.string(fnd_log.level_unexpected,
589: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_new_card_page_url',
590: sqlerrm);
591: end if;

Line 588: fnd_log.string(fnd_log.level_unexpected,

584: end if;
585: exception
586: when others then
587: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
588: fnd_log.string(fnd_log.level_unexpected,
589: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_new_card_page_url',
590: sqlerrm);
591: end if;
592: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_NEW_CARD_PAGE_URL',

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

635: return;
636: end if;
637: exception
638: when others then
639: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
640: fnd_log.string(fnd_log.level_unexpected,
641: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.whoami',
642: sqlerrm);
643: end if;

Line 640: fnd_log.string(fnd_log.level_unexpected,

636: end if;
637: exception
638: when others then
639: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
640: fnd_log.string(fnd_log.level_unexpected,
641: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.whoami',
642: sqlerrm);
643: end if;
644: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'WHOAMI',

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

703: return;
704: end if;
705: exception
706: when others then
707: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
708: fnd_log.string(fnd_log.level_unexpected,
709: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_SYSADMIN', sqlerrm);
710: end if;
711: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_SYSADMIN',

Line 708: fnd_log.string(fnd_log.level_unexpected,

704: end if;
705: exception
706: when others then
707: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
708: fnd_log.string(fnd_log.level_unexpected,
709: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_SYSADMIN', sqlerrm);
710: end if;
711: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_SYSADMIN',
712: itemtype, itemkey, to_char(actid), funcmode);

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

748: return;
749: end if;
750: exception
751: when others then
752: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
753: fnd_log.string(fnd_log.level_unexpected,
754: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_PROGRAM_NAME', sqlerrm);
755: end if;
756: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_PROGRAM_NAME',

Line 753: fnd_log.string(fnd_log.level_unexpected,

749: end if;
750: exception
751: when others then
752: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
753: fnd_log.string(fnd_log.level_unexpected,
754: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_PROGRAM_NAME', sqlerrm);
755: end if;
756: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_PROGRAM_NAME',
757: itemtype, itemkey, to_char(actid), funcmode);

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

781: return;
782: end if;
783: exception
784: when others then
785: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
786: fnd_log.string(fnd_log.level_unexpected,
787: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
788: end if;
789: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

Line 786: fnd_log.string(fnd_log.level_unexpected,

782: end if;
783: exception
784: when others then
785: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
786: fnd_log.string(fnd_log.level_unexpected,
787: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
788: end if;
789: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',
790: itemtype, itemkey, to_char(actid), funcmode);

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

813: return;
814: end if;
815: exception
816: when others then
817: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
818: fnd_log.string(fnd_log.level_unexpected,
819: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
820: end if;
821: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

Line 818: fnd_log.string(fnd_log.level_unexpected,

814: end if;
815: exception
816: when others then
817: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
818: fnd_log.string(fnd_log.level_unexpected,
819: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);
820: end if;
821: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',
822: itemtype, itemkey, to_char(actid), funcmode);

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

848: return;
849: end if;
850: exception
851: when others then
852: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
853: fnd_log.string(fnd_log.level_unexpected,
854: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_INSTRUCTIONS', sqlerrm);
855: end if;
856: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_INSTRUCTIONS',

Line 853: fnd_log.string(fnd_log.level_unexpected,

849: end if;
850: exception
851: when others then
852: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
853: fnd_log.string(fnd_log.level_unexpected,
854: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_INSTRUCTIONS', sqlerrm);
855: end if;
856: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_INSTRUCTIONS',
857: itemtype, itemkey, to_char(actid), funcmode);