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.4.12010000.2 2008/08/06 07:50:16 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 250: 'ap.pls.AP_WEB_CC_VALIDATION_WF_PKG.raise_new_cc_event',

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:
254:

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

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

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

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',
312: itemtype, itemkey, to_char(actid), funcmode);
313: raise;
314: end card_employee_match;
315:

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

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

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

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',
362: itemtype, itemkey, to_char(actid), funcmode);
363: raise;
364: end assign_emp_if_unique;
365:

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

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

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

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',
403: itemtype, itemkey, to_char(actid), funcmode);
404: raise;
405: end new_cards_exist;
406:

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

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

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

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',
445: itemtype, itemkey, to_char(actid), funcmode);
446: raise;
447: end inactive_cards_exist;
448:

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

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

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

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',
504: itemtype, itemkey, to_char(actid), funcmode);
505: raise;
506: end invalid_cctrx_exist;
507:

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

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

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

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',
544: itemtype, itemkey, to_char(actid), funcmode);
545: raise;
546: end count_new_cards;
547:

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

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

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

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',
593: itemtype, itemkey, to_char(actid), funcmode);
594: raise;
595: end get_new_card_page_url;
596:

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

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

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

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',
645: itemtype, itemkey, to_char(actid), funcmode);
646: raise;
647: end whoami;
648:

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

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

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

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);
713: raise;
714: end get_card_sysadmin;
715:

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

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

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

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);
758: raise;
759: end get_card_program_name;
760:

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

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

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

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);
791: raise;
792: end get_attribute_value;
793:

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

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

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

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);
823: raise;
824: end get_act_attribute_value;
825:

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

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

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

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);
858: raise;
859: end get_instructions;
860:

Line 864: end ap_web_cc_validation_wf_pkg;

860:
861:
862:
863:
864: end ap_web_cc_validation_wf_pkg;