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_HOLDS_WF dependencies on AP_WEB_UTILITIES_PKG

Line 30: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start ParseItemKey');

26: l_item_key wf_items.item_key%TYPE;
27:
28: BEGIN
29:
30: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start ParseItemKey');
31:
32: ----------------------------------------------------------
33: l_debug_info := 'Parse the item key for the Expense Report Id';
34: ----------------------------------------------------------

Line 37: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end ParseItemKey');

33: l_debug_info := 'Parse the item key for the Expense Report Id';
34: ----------------------------------------------------------
35: return substrb(p_item_key, 1, instrb(p_item_key, C_ITEM_KEY_DELIM)-1);
36:
37: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end ParseItemKey');
38:
39: EXCEPTION
40: WHEN OTHERS THEN
41: Wf_Core.Context('AP_WEB_HOLDS_WF', 'ParseItemKey',

Line 58: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start IsHoldsRuleSetup');

54: l_is_holds_rule_setup VARCHAR2(1);
55:
56: BEGIN
57:
58: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start IsHoldsRuleSetup');
59:
60: ------------------------------------------------------------
61: l_debug_info := 'Check if Holds Rule Setup';
62: ------------------------------------------------------------

Line 77: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end IsHoldsRuleSetup');

73: and rownum = 1;
74:
75: return l_is_holds_rule_setup;
76:
77: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end IsHoldsRuleSetup');
78:
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
81: return 'N';

Line 107: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start IsHoldsRuleSetup');

103: l_is_notif_rule_setup VARCHAR2(1);
104:
105: BEGIN
106:
107: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start IsHoldsRuleSetup');
108:
109: IF (p_funmode = 'RUN') THEN
110:
111: ----------------------------------------------------------

Line 148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end IsHoldsRuleSetup');

144: p_result := 'COMPLETE';
145:
146: END IF; -- p_funmode = 'RUN'
147:
148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end IsHoldsRuleSetup');
149:
150: EXCEPTION
151: WHEN OTHERS THEN
152: Wf_Core.Context('AP_WEB_HOLDS_WF', 'IsHoldsRuleSetup',

Line 212: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseHeldEvent');

208: l_event_key wf_items.item_key%type;
209:
210: BEGIN
211:
212: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseHeldEvent');
213:
214: ----------------------------------------------------------
215: l_debug_info := 'Generate Event Key';
216: ----------------------------------------------------------

Line 233: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseHeldEvent');

229: --p_parameters => l_parameter_list);
230:
231: end if;
232:
233: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseHeldEvent');
234:
235: EXCEPTION
236: WHEN OTHERS THEN
237: Wf_Core.Context('AP_WEB_HOLDS_WF', 'RaiseHeldEvent',

Line 253: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseReleasedEvent');

249: l_event_key wf_items.item_key%type;
250:
251: BEGIN
252:
253: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseReleasedEvent');
254:
255: ----------------------------------------------------------
256: l_debug_info := 'Generate Event Key';
257: ----------------------------------------------------------

Line 274: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseReleasedEvent');

270: --p_parameters => l_parameter_list);
271:
272: end if;
273:
274: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseReleasedEvent');
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: Wf_Core.Context('AP_WEB_HOLDS_WF', 'RaiseReleasedEvent',

Line 296: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseReleasedEvent');

292: l_debug_info VARCHAR2(200);
293:
294: BEGIN
295:
296: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseReleasedEvent');
297:
298: IF (p_funmode = 'RUN') THEN
299:
300: ----------------------------------------------------------

Line 311: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseReleasedEvent');

307: p_result := 'COMPLETE';
308:
309: END IF; -- p_funmode = 'RUN'
310:
311: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end RaiseReleasedEvent');
312:
313: EXCEPTION
314: WHEN OTHERS THEN
315: Wf_Core.Context('AP_WEB_HOLDS_WF', 'RaiseReleasedEvent',

Line 354: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start Init');

350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
351:
352: BEGIN
353:
354: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start Init');
355:
356: ----------------------------------------------------------
357: l_debug_info := 'Parse the item key for the Expense Report Id';
358: ----------------------------------------------------------

Line 551: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end Init');

547: -----------------------------------------------------
548: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);
549:
550:
551: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end Init');
552:
553: EXCEPTION
554: WHEN OTHERS THEN
555: Wf_Core.Context('AP_WEB_HOLDS_WF', 'Init',

Line 573: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start InitHeld');

569: l_debug_info VARCHAR2(200);
570:
571: BEGIN
572:
573: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start InitHeld');
574:
575: IF (p_funmode = 'RUN') THEN
576:
577: ----------------------------------------------------------

Line 586: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end InitHeld');

582: p_result := 'COMPLETE';
583:
584: END IF; -- p_funmode = 'RUN'
585:
586: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end InitHeld');
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: Wf_Core.Context('AP_WEB_HOLDS_WF', 'InitHeld',

Line 608: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start InitReleased');

604: l_debug_info VARCHAR2(200);
605:
606: BEGIN
607:
608: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start InitReleased');
609:
610: IF (p_funmode = 'RUN') THEN
611:
612: ----------------------------------------------------------

Line 621: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end InitReleased');

617: p_result := 'COMPLETE';
618:
619: END IF; -- p_funmode = 'RUN'
620:
621: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end InitReleased');
622:
623: EXCEPTION
624: WHEN OTHERS THEN
625: Wf_Core.Context('AP_WEB_HOLDS_WF', 'InitReleased',

Line 646: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start AnyHoldsPending');

642: l_any_holds_pending varchar2(1) := 'N';
643:
644: BEGIN
645:
646: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start AnyHoldsPending');
647:
648: IF (p_funmode = 'RUN') THEN
649:
650: ------------------------------------------------------------

Line 671: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end AnyHoldsPending');

667: p_result := 'COMPLETE:'||l_any_holds_pending;
668:
669: END IF; -- p_funmode = 'RUN'
670:
671: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end AnyHoldsPending');
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: Wf_Core.Context('AP_WEB_HOLDS_WF', 'AnyHoldsPending',

Line 693: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');

689: l_hold_code AP_AUD_RULE_SETS.hold_code%type;
690:
691: BEGIN
692:
693: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');
694:
695: ------------------------------------------------------------
696: l_debug_info := 'Check if Holds Rule Setup';
697: ------------------------------------------------------------

Line 718: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end GetHoldsScenario');

714: end if;
715:
716: return null;
717:
718: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end GetHoldsScenario');
719:
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN
722: return null;

Line 747: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');

743: l_holds_scenario AP_AUD_RULE_SETS.hold_code%type;
744:
745: BEGIN
746:
747: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');
748:
749: IF (p_funmode = 'RUN') THEN
750:
751: ------------------------------------------------------------

Line 774: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end GetHoldsScenario');

770: p_result := 'COMPLETE:'||l_holds_scenario;
771:
772: END IF; -- p_funmode = 'RUN'
773:
774: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end GetHoldsScenario');
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: Wf_Core.Context('AP_WEB_HOLDS_WF', 'GetHoldsScenario',

Line 796: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start ReleaseHold');

792: l_debug_info VARCHAR2(200);
793:
794: BEGIN
795:
796: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start ReleaseHold');
797:
798: IF (p_funmode = 'RUN') THEN
799:
800: ----------------------------------------------------------

Line 808: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end ReleaseHold');

804: p_result := 'COMPLETE';
805:
806: END IF; -- p_funmode = 'RUN'
807:
808: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end ReleaseHold');
809:
810: EXCEPTION
811: WHEN OTHERS THEN
812: Wf_Core.Context('AP_WEB_HOLDS_WF', 'ReleaseHold',

Line 842: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start StoreNote');

838: l_org_id ap_expense_params_all.org_id%type;
839:
840: BEGIN
841:
842: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start StoreNote');
843:
844: IF (p_funmode = 'RUN') THEN
845:
846: -------------------------------------------------------------------

Line 947: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end StoreNote');

943: p_result := 'COMPLETE';
944:
945: END IF; -- p_funmode = 'RUN'
946:
947: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end StoreNote');
948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: Wf_Core.Context('AP_WEB_HOLDS_WF', 'StoreNote',

Line 971: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start CallbackFunction');

967: l_expense_report_id number;
968:
969: BEGIN
970:
971: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start CallbackFunction');
972:
973: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
974: p_item_key,
975: 'ORG_ID');

Line 1037: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end CallbackFunction');

1033: return;
1034: end if;
1035: */
1036:
1037: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end CallbackFunction');
1038:
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: Wf_Core.Context('AP_WEB_HOLDS_WF', 'CallbackFunction',