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 AP_WEB_CC_VALIDATION_WF_PKG

Line 1: PACKAGE BODY AP_WEB_CC_VALIDATION_WF_PKG as

1: PACKAGE BODY AP_WEB_CC_VALIDATION_WF_PKG as
2: /* $Header: apwfvalb.pls 120.9.12020000.2 2012/07/05 14:17:08 rveliche ship $ */
3:
4: --
5: -- Raises the Workflow business event

Line 40: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',

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:
44: else

Line 61: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_validation_event',

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;
65:

Line 159: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.count_invalid',

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',
163: itemtype, itemkey, to_char(actid), funcmode);

Line 162: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'COUNT_INVALID',

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',
163: itemtype, itemkey, to_char(actid), funcmode);
164: raise;
165: end count_invalid;
166: */

Line 215: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_search_page_url',

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',
219: itemtype, itemkey, to_char(actid), funcmode);

Line 218: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_SEARCH_PAGE_URL',

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',
219: itemtype, itemkey, to_char(actid), funcmode);
220: raise;
221: end get_search_page_url;
222:

Line 254: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',

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
258: for l_fetch_card_program_id in fetch_card_program_id loop

Line 273: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',

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

Line 332: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.CARD_EMPLOYEE_MATCH',

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',
336: itemtype, itemkey, to_char(actid), funcmode);

Line 335: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'CARD_EMPLOYEE_MATCH',

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',
336: itemtype, itemkey, to_char(actid), funcmode);
337: raise;
338: end card_employee_match;
339:

Line 382: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.ASSIGN_EMP_IF_UNIQUE',

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',
386: itemtype, itemkey, to_char(actid), funcmode);

Line 385: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'ASSIGN_EMP_IF_UNIQUE',

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',
386: itemtype, itemkey, to_char(actid), funcmode);
387: raise;
388: end assign_emp_if_unique;
389:

Line 423: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.NEW_CARDS_EXIST',

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',
427: itemtype, itemkey, to_char(actid), funcmode);

Line 426: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'NEW_CARDS_EXIST',

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',
427: itemtype, itemkey, to_char(actid), funcmode);
428: raise;
429: end new_cards_exist;
430:

Line 465: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INACTIVE_CARDS_EXIST',

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',
469: itemtype, itemkey, to_char(actid), funcmode);

Line 468: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INACTIVE_CARDS_EXIST',

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',
469: itemtype, itemkey, to_char(actid), funcmode);
470: raise;
471: end inactive_cards_exist;
472:

Line 524: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.INVALID_CCTRX_EXIST',

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',
528: itemtype, itemkey, to_char(actid), funcmode);

Line 527: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'INVALID_CCTRX_EXIST',

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',
528: itemtype, itemkey, to_char(actid), funcmode);
529: raise;
530: end invalid_cctrx_exist;
531:

Line 564: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.COUNT_NEW_CARDS',

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',
568: itemtype, itemkey, to_char(actid), funcmode);

Line 567: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'COUNT_NEW_CARDS',

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',
568: itemtype, itemkey, to_char(actid), funcmode);
569: raise;
570: end count_new_cards;
571:

Line 613: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.get_new_card_page_url',

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',
617: itemtype, itemkey, to_char(actid), funcmode);

Line 616: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_NEW_CARD_PAGE_URL',

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',
617: itemtype, itemkey, to_char(actid), funcmode);
618: raise;
619: end get_new_card_page_url;
620:

Line 665: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.whoami',

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',
669: itemtype, itemkey, to_char(actid), funcmode);

Line 668: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'WHOAMI',

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',
669: itemtype, itemkey, to_char(actid), funcmode);
670: raise;
671: end whoami;
672:

Line 733: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_SYSADMIN', sqlerrm);

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);
737: raise;

Line 735: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_SYSADMIN',

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);
737: raise;
738: end get_card_sysadmin;
739:

Line 778: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_CARD_PROGRAM_NAME', sqlerrm);

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);
782: raise;

Line 780: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_CARD_PROGRAM_NAME',

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);
782: raise;
783: end get_card_program_name;
784:

Line 811: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);

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);
815: raise;

Line 813: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

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);
815: raise;
816: end get_attribute_value;
817:

Line 843: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_ATTRIBUUTE_VALUE', sqlerrm);

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);
847: raise;

Line 845: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_ATTRIBUTE_VALUE',

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);
847: raise;
848: end get_act_attribute_value;
849:

Line 878: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.GET_INSTRUCTIONS', sqlerrm);

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);
882: raise;

Line 880: WF_CORE.CONTEXT ('AP_WEB_CC_VALIDATION_WF_PKG', 'GET_INSTRUCTIONS',

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);
882: raise;
883: end get_instructions;
884:

Line 888: end ap_web_cc_validation_wf_pkg;

884:
885:
886:
887:
888: end ap_web_cc_validation_wf_pkg;