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_RECEIPTS_WF dependencies on AP_WEB_RECEIPTS_WF

Line 1: PACKAGE BODY AP_WEB_RECEIPTS_WF AS

1: PACKAGE BODY AP_WEB_RECEIPTS_WF AS
2: /* $Header: apwrecptb.pls 120.6.12010000.3 2008/11/21 09:01:23 sodash ship $ */
3:
4: ------------------------
5: -- Day to minutes conversion 24*60

Line 40: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start ParseItemKey');

36:
37: BEGIN
38:
39:
40: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start ParseItemKey');
41:
42: ----------------------------------------------------------
43: l_debug_info := 'Parse the item key for the Expense Report Id';
44: ----------------------------------------------------------

Line 47: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end ParseItemKey');

43: l_debug_info := 'Parse the item key for the Expense Report Id';
44: ----------------------------------------------------------
45: return substrb(p_item_key, 1, instrb(p_item_key, C_ITEM_KEY_DELIM)-1);
46:
47: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end ParseItemKey');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'ParseItemKey',

Line 51: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'ParseItemKey',

47: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end ParseItemKey');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'ParseItemKey',
52: p_item_type, p_item_key, l_debug_info);
53: raise;
54: END ParseItemKey;
55:

Line 89: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',

85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN
87: return 'N';
88: WHEN OTHERS THEN
89: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',
90: to_char(p_org_id), to_char(p_report_submitted_date), l_debug_info);
91: raise;
92: END IsNotifRuleSetup;
93:

Line 113: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsNotifRuleSetup');

109: l_is_notif_rule_setup VARCHAR2(1);
110:
111: BEGIN
112:
113: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsNotifRuleSetup');
114:
115: IF (p_funmode = 'RUN') THEN
116:
117: ----------------------------------------------------------

Line 154: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsNotifRuleSetup');

150: p_result := 'COMPLETE';
151:
152: END IF; -- p_funmode = 'RUN'
153:
154: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsNotifRuleSetup');
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',

Line 158: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',

154: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsNotifRuleSetup');
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',
159: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
160: raise;
161: END IsNotifRuleSetup;
162:

Line 218: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');

214: l_event_key wf_items.item_key%type;
215:
216: BEGIN
217:
218: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');
219:
220: ----------------------------------------------------------
221: l_debug_info := 'Generate Event Key';
222: ----------------------------------------------------------

Line 239: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');

235: --p_parameters => l_parameter_list);
236:
237: end if;
238:
239: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',

Line 243: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',

239: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',
244: p_expense_report_id, l_debug_info);
245: raise;
246: END RaiseOverdueEvent;
247:

Line 259: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');

255: l_event_key wf_items.item_key%type;
256:
257: BEGIN
258:
259: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');
260:
261: ----------------------------------------------------------
262: l_debug_info := 'Generate Event Key';
263: ----------------------------------------------------------

Line 280: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');

276: --p_parameters => l_parameter_list);
277:
278: end if;
279:
280: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',

Line 284: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',

280: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',
285: p_expense_report_id, l_debug_info);
286: raise;
287: END RaiseMissingEvent;
288:

Line 300: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');

296: l_event_key wf_items.item_key%type;
297:
298: BEGIN
299:
300: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');
301:
302: ----------------------------------------------------------
303: l_debug_info := 'Generate Event Key';
304: ----------------------------------------------------------

Line 321: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');

317: --p_parameters => l_parameter_list);
318:
319: end if;
320:
321: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',

Line 325: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',

321: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',
326: p_expense_report_id, l_debug_info);
327: raise;
328: END RaiseReceivedEvent;
329:

Line 341: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');

337: l_event_key wf_items.item_key%type;
338:
339: BEGIN
340:
341: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');
342:
343: ----------------------------------------------------------
344: l_debug_info := 'Generate Event Key';
345: ----------------------------------------------------------

Line 360: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)

356: begin
357: update ap_expense_report_headers_all
358: set receipts_status = ''
359: where report_header_id = p_expense_report_id
360: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
361: and receipts_received_date is null;
362: exception
363: when others then null;
364: end;

Line 390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');

386: --p_parameters => l_parameter_list);
387:
388: end if;
389:
390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

Line 394: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',
395: p_expense_report_id, l_debug_info);
396: raise;
397: END RaiseAbortedEvent;
398:

Line 412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');

408: l_debug_info VARCHAR2(200);
409:
410: BEGIN
411:
412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');
413:
414: IF (p_funmode = 'RUN') THEN
415:
416: ----------------------------------------------------------

Line 427: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');

423: p_result := 'COMPLETE';
424:
425: END IF; -- p_funmode = 'RUN'
426:
427: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

Line 431: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

427: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',
432: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
433: raise;
434: END RaiseAbortedEvent;
435:

Line 471: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start Init');

467: l_is_notif_rule_setup varchar2(1) := 'N';
468:
469: BEGIN
470:
471: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start Init');
472:
473: ----------------------------------------------------------
474: l_debug_info := 'Parse the item key for the Expense Report Id';
475: ----------------------------------------------------------

Line 718: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end Init');

714:
715: end if; -- (l_is_notif_rule_setup = 'Y')
716:
717:
718: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end Init');
719:
720: EXCEPTION
721: WHEN OTHERS THEN
722: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'Init',

Line 722: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'Init',

718: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end Init');
719:
720: EXCEPTION
721: WHEN OTHERS THEN
722: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'Init',
723: p_item_type, p_item_key, l_expense_report_id, l_preparer_name, l_debug_info);
724: raise;
725: END Init;
726:

Line 740: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitOverdue');

736: l_debug_info VARCHAR2(200);
737:
738: BEGIN
739:
740: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitOverdue');
741:
742: IF (p_funmode = 'RUN') THEN
743:
744: ----------------------------------------------------------

Line 753: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitOverdue');

749: p_result := 'COMPLETE';
750:
751: END IF; -- p_funmode = 'RUN'
752:
753: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitOverdue');
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitOverdue',

Line 757: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitOverdue',

753: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitOverdue');
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitOverdue',
758: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
759: raise;
760: END InitOverdue;
761:

Line 775: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitMissing');

771: l_debug_info VARCHAR2(200);
772:
773: BEGIN
774:
775: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitMissing');
776:
777: IF (p_funmode = 'RUN') THEN
778:
779: ----------------------------------------------------------

Line 788: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitMissing');

784: p_result := 'COMPLETE';
785:
786: END IF; -- p_funmode = 'RUN'
787:
788: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitMissing');
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitMissing',

Line 792: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitMissing',

788: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitMissing');
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitMissing',
793: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
794: raise;
795: END InitMissing;
796:

Line 816: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckOverdueExists');

812: l_found_item_key wf_items.item_key%TYPE;
813:
814: BEGIN
815:
816: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckOverdueExists');
817:
818: IF (p_funmode = 'RUN') THEN
819:
820: begin

Line 857: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckOverdueExists');

853: ELSIF (p_funmode = 'CANCEL') THEN
854: p_result := 'COMPLETE';
855: END IF; -- p_funmode = 'RUN'
856:
857: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckOverdueExists');
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckOverdueExists',

Line 861: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckOverdueExists',

857: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckOverdueExists');
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckOverdueExists',
862: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
863: raise;
864: END CheckOverdueExists;
865:

Line 885: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingExists');

881: l_found_item_key wf_items.item_key%TYPE;
882:
883: BEGIN
884:
885: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingExists');
886:
887: IF (p_funmode = 'RUN') THEN
888:
889: begin

Line 926: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingExists');

922: ELSIF (p_funmode = 'CANCEL') THEN
923: p_result := 'COMPLETE';
924: END IF; -- p_funmode = 'RUN'
925:
926: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingExists');
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingExists',

Line 930: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingExists',

926: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingExists');
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingExists',
931: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
932: raise;
933: END CheckMissingExists;
934:

Line 948: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortOverdue');

944: l_debug_info VARCHAR2(200);
945:
946: BEGIN
947:
948: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortOverdue');
949:
950: IF (p_funmode = 'RUN') THEN
951:
952: AbortProcess(p_item_type, p_item_key, C_OVERDUE_EVENT_KEY);

Line 958: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortOverdue');

954: p_result := 'COMPLETE';
955:
956: END IF; -- p_funmode = 'RUN'
957:
958: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortOverdue');
959:
960: EXCEPTION
961: WHEN OTHERS THEN
962: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortOverdue',

Line 962: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortOverdue',

958: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortOverdue');
959:
960: EXCEPTION
961: WHEN OTHERS THEN
962: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortOverdue',
963: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
964: raise;
965: END AbortOverdue;
966:

Line 982: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortMissing');

978: l_item_key wf_items.item_key%type;
979:
980: BEGIN
981:
982: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortMissing');
983:
984: IF (p_funmode = 'RUN') THEN
985:
986: AbortProcess(p_item_type, p_item_key, C_MISSING_EVENT_KEY);

Line 992: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortMissing');

988: p_result := 'COMPLETE';
989:
990: END IF; -- p_funmode = 'RUN'
991:
992: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortMissing');
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortMissing',

Line 996: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortMissing',

992: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortMissing');
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortMissing',
997: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
998: raise;
999: END AbortMissing;
1000:

Line 1026: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortProcess');

1022: and end_date is null;
1023:
1024: BEGIN
1025:
1026: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortProcess');
1027:
1028: ----------------------------------------------------------
1029: l_debug_info := 'Getting item key of current process';
1030: ----------------------------------------------------------

Line 1061: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortProcess');

1057:
1058: end loop;
1059: close c_receipt_events;
1060:
1061: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortProcess');
1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortProcess',

Line 1065: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortProcess',

1061: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortProcess');
1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortProcess',
1066: p_item_type, p_item_key, p_event_key, l_debug_info);
1067: raise;
1068: END AbortProcess;
1069:

Line 1083: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitReceived');

1079: l_debug_info VARCHAR2(200);
1080:
1081: BEGIN
1082:
1083: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitReceived');
1084:
1085: IF (p_funmode = 'RUN') THEN
1086:
1087: ----------------------------------------------------------

Line 1096: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitReceived');

1092: p_result := 'COMPLETE';
1093:
1094: END IF; -- p_funmode = 'RUN'
1095:
1096: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitReceived');
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitReceived',

Line 1100: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitReceived',

1096: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitReceived');
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitReceived',
1101: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1102: raise;
1103: END InitReceived;
1104:

Line 1118: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitAborted');

1114: l_debug_info VARCHAR2(200);
1115:
1116: BEGIN
1117:
1118: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitAborted');
1119:
1120: IF (p_funmode = 'RUN') THEN
1121:
1122: ----------------------------------------------------------

Line 1131: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitAborted');

1127: p_result := 'COMPLETE';
1128:
1129: END IF; -- p_funmode = 'RUN'
1130:
1131: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitAborted');
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitAborted',

Line 1135: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitAborted',

1131: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitAborted');
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitAborted',
1136: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1137: raise;
1138: END InitAborted;
1139:

Line 1164: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',

1160: EXCEPTION
1161: WHEN NO_DATA_FOUND THEN
1162: return null;
1163: WHEN OTHERS THEN
1164: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',
1165: to_char(p_report_header_id), l_debug_info);
1166: raise;
1167: END GetReceiptsStatus;
1168:

Line 1185: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start GetReceiptsStatus');

1181: l_report_header_id number;
1182:
1183: BEGIN
1184:
1185: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start GetReceiptsStatus');
1186:
1187: IF (p_funmode = 'RUN') THEN
1188:
1189: ------------------------------------------------------------

Line 1205: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetReceiptsStatus');

1201: p_result := 'COMPLETE:'||l_receipts_status;
1202:
1203: END IF; -- p_funmode = 'RUN'
1204:
1205: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetReceiptsStatus');
1206:
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',

Line 1209: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',

1205: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetReceiptsStatus');
1206:
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',
1210: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1211: raise;
1212: END GetReceiptsStatus;
1213:

Line 1226: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');

1222: l_orig_receipts_status varchar2(30);
1223:
1224: BEGIN
1225:
1226: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');
1227:
1228: ------------------------------------------------------------
1229: l_debug_info := 'Lock current Receipt Status';
1230: ------------------------------------------------------------

Line 1244: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');

1240: update ap_expense_report_headers_all
1241: set receipts_status = p_receipts_status
1242: where report_header_id = p_report_header_id;
1243:
1244: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1245:
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

Line 1248: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

1244: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1245:
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',
1249: to_char(p_report_header_id), p_receipts_status, l_debug_info);
1250: raise;
1251: END SetReceiptsStatus;
1252:

Line 1270: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');

1266: l_report_header_id number;
1267:
1268: BEGIN
1269:
1270: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');
1271:
1272: IF (p_funmode = 'RUN') THEN
1273:
1274: -------------------------------------------------------------------

Line 1298: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');

1294: p_result := 'COMPLETE';
1295:
1296: END IF; -- p_funmode = 'RUN'
1297:
1298: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

Line 1302: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

1298: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',
1303: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1304: raise;
1305: END SetReceiptsStatus;
1306:

Line 1323: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');

1319: l_report_header_id number;
1320:
1321: BEGIN
1322:
1323: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
1324:
1325: /*
1326: DAYS_OVERDUE is the diff between notif sent date and date the
1327: the expense report receipts package became overdue

Line 1364: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');

1360: ------------------------------------------------------------
1361: SetReceiptsStatus(l_report_header_id, C_OVERDUE);
1362: end if;
1363:
1364: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

Line 1368: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

1364: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
1369: p_item_type, p_item_key, l_debug_info);
1370: raise;
1371: END SetDaysOverdue;
1372:

Line 1390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');

1386: l_notif_rule_days_overdue number;
1387:
1388: BEGIN
1389:
1390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
1391:
1392: IF (p_funmode = 'RUN') THEN
1393:
1394: SetDaysOverdue(p_item_type, p_item_key);

Line 1400: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');

1396: p_result := 'COMPLETE';
1397:
1398: END IF; -- p_funmode = 'RUN'
1399:
1400: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

Line 1404: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

1400: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
1405: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1406: raise;
1407: END SetDaysOverdue;
1408:

Line 1424: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingDeclRequired');

1420: l_missing_decl_reqd fnd_lookups.lookup_code%TYPE;
1421:
1422: BEGIN
1423:
1424: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingDeclRequired');
1425:
1426: IF (p_funmode = 'RUN') THEN
1427:
1428: ----------------------------------------------------------

Line 1443: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingDeclRequired');

1439: end if;
1440:
1441: END IF; -- p_funmode = 'RUN'
1442:
1443: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingDeclRequired');
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingDeclRequired',

Line 1447: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingDeclRequired',

1443: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingDeclRequired');
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingDeclRequired',
1448: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1449: raise;
1450: END CheckMissingDeclRequired;
1451:

Line 1469: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyReceived');

1465: l_days_overdue number := 0;
1466:
1467: BEGIN
1468:
1469: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyReceived');
1470:
1471: IF (p_funmode = 'RUN') THEN
1472:
1473: ----------------------------------------------------------

Line 1497: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyReceived');

1493: end if;
1494:
1495: END IF; -- p_funmode = 'RUN'
1496:
1497: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyReceived');
1498:
1499: EXCEPTION
1500: WHEN OTHERS THEN
1501: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyReceived',

Line 1501: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyReceived',

1497: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyReceived');
1498:
1499: EXCEPTION
1500: WHEN OTHERS THEN
1501: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyReceived',
1502: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1503: raise;
1504: END CheckNotifyReceived;
1505:

Line 1522: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsReceivedWaived');

1518: l_report_header_id number;
1519:
1520: BEGIN
1521:
1522: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsReceivedWaived');
1523:
1524: IF (p_funmode = 'RUN') THEN
1525:
1526: ------------------------------------------------------------

Line 1546: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsReceivedWaived');

1542: end if;
1543:
1544: END IF; -- p_funmode = 'RUN'
1545:
1546: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsReceivedWaived');
1547:
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsReceivedWaived',

Line 1550: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsReceivedWaived',

1546: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsReceivedWaived');
1547:
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsReceivedWaived',
1551: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1552: raise;
1553: END IsReceivedWaived;
1554:

Line 1569: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsShortpay');

1565: l_is_shortpay varchar2(1) := 'N';
1566:
1567: BEGIN
1568:
1569: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsShortpay');
1570:
1571: ------------------------------------------------------------
1572: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1573: ------------------------------------------------------------

Line 1595: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsShortpay');

1591: and rownum = 1;
1592:
1593: return l_is_shortpay;
1594:
1595: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsShortpay');
1596:
1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN
1599: return 'N';

Line 1601: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsShortpay',

1597: EXCEPTION
1598: WHEN NO_DATA_FOUND THEN
1599: return 'N';
1600: WHEN OTHERS THEN
1601: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsShortpay',
1602: p_item_type, p_item_key, l_debug_info);
1603: raise;
1604: END IsShortpay;
1605:

Line 1621: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsMissingShortpay');

1617: l_is_shortpay VARCHAR2(1) := 'N';
1618:
1619: BEGIN
1620:
1621: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsMissingShortpay');
1622:
1623: IF (p_funmode = 'RUN') THEN
1624:
1625: ------------------------------------------------------------

Line 1636: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsMissingShortpay');

1632: p_result := 'COMPLETE:'||l_is_shortpay;
1633:
1634: END IF; -- p_funmode = 'RUN'
1635:
1636: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsMissingShortpay');
1637:
1638: EXCEPTION
1639: WHEN NO_DATA_FOUND THEN
1640: p_result := 'COMPLETE:N';

Line 1642: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsMissingShortpay',

1638: EXCEPTION
1639: WHEN NO_DATA_FOUND THEN
1640: p_result := 'COMPLETE:N';
1641: WHEN OTHERS THEN
1642: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsMissingShortpay',
1643: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1644: raise;
1645: END IsMissingShortpay;
1646:

Line 1662: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsPolicyShortpay');

1658: l_is_shortpay VARCHAR2(1) := 'N';
1659:
1660: BEGIN
1661:
1662: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsPolicyShortpay');
1663:
1664: IF (p_funmode = 'RUN') THEN
1665:
1666: ------------------------------------------------------------

Line 1677: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsPolicyShortpay');

1673: p_result := 'COMPLETE:'||l_is_shortpay;
1674:
1675: END IF; -- p_funmode = 'RUN'
1676:
1677: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsPolicyShortpay');
1678:
1679: EXCEPTION
1680: WHEN NO_DATA_FOUND THEN
1681: p_result := 'COMPLETE:N';

Line 1683: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsPolicyShortpay',

1679: EXCEPTION
1680: WHEN NO_DATA_FOUND THEN
1681: p_result := 'COMPLETE:N';
1682: WHEN OTHERS THEN
1683: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsPolicyShortpay',
1684: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1685: raise;
1686: END IsPolicyShortpay;
1687:

Line 1702: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteShortpay');

1698: l_report_header_id number;
1699:
1700: BEGIN
1701:
1702: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteShortpay');
1703:
1704: ------------------------------------------------------------
1705: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1706: ------------------------------------------------------------

Line 1725: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteShortpay');

1721: exception
1722: when others then null;
1723: end;
1724:
1725: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteShortpay');
1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteShortpay',

Line 1729: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteShortpay',

1725: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteShortpay');
1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteShortpay',
1730: p_item_type, p_item_key, p_activity, p_result, l_debug_info);
1731: raise;
1732: END CompleteShortpay;
1733:

Line 1747: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteMissingShortpay');

1743: l_debug_info VARCHAR2(200);
1744:
1745: BEGIN
1746:
1747: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteMissingShortpay');
1748:
1749: IF (p_funmode = 'RUN') THEN
1750:
1751: ----------------------------------------------------------

Line 1767: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteMissingShortpay');

1763: end;
1764:
1765: end if;
1766:
1767: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteMissingShortpay');
1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteMissingShortpay',

Line 1771: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteMissingShortpay',

1767: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteMissingShortpay');
1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteMissingShortpay',
1772: p_item_type, p_item_key, to_char(p_actid), p_result, l_debug_info);
1773: raise;
1774: END CompleteMissingShortpay;
1775:

Line 1789: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompletePolicyShortpay');

1785: l_debug_info VARCHAR2(200);
1786:
1787: BEGIN
1788:
1789: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompletePolicyShortpay');
1790:
1791: IF (p_funmode = 'RUN') THEN
1792:
1793: ----------------------------------------------------------

Line 1809: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompletePolicyShortpay');

1805: end;
1806:
1807: end if;
1808:
1809: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompletePolicyShortpay');
1810:
1811: EXCEPTION
1812: WHEN OTHERS THEN
1813: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompletePolicyShortpay',

Line 1813: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompletePolicyShortpay',

1809: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompletePolicyShortpay');
1810:
1811: EXCEPTION
1812: WHEN OTHERS THEN
1813: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompletePolicyShortpay',
1814: p_item_type, p_item_key, to_char(p_actid), p_result, l_debug_info);
1815: raise;
1816: END CompletePolicyShortpay;
1817:

Line 1869: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');

1865:
1866: l_org_id ap_expense_params_all.org_id%type;
1867: BEGIN
1868:
1869: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');
1870:
1871: IF (p_funmode = 'RUN') THEN
1872:
1873: -------------------------------------------------------------------

Line 2066: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end StoreNote');

2062: p_result := 'COMPLETE:Y';
2063:
2064: END IF;
2065:
2066: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end StoreNote');
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'StoreNote',

Line 2070: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'StoreNote',

2066: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end StoreNote');
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'StoreNote',
2071: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
2072: raise;
2073: END StoreNote;
2074:

Line 2090: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CallbackFunction');

2086: l_expense_report_id number;
2087:
2088: BEGIN
2089:
2090: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CallbackFunction');
2091:
2092: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2093: p_item_key,
2094: 'ORG_ID');

Line 2156: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CallbackFunction');

2152: return;
2153: end if;
2154: */
2155:
2156: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CallbackFunction');
2157:
2158: EXCEPTION
2159: WHEN OTHERS THEN
2160: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CallbackFunction',

Line 2160: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CallbackFunction',

2156: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CallbackFunction');
2157:
2158: EXCEPTION
2159: WHEN OTHERS THEN
2160: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CallbackFunction',
2161: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
2162: raise;
2163: END CallbackFunction;
2164:

Line 2376: END AP_WEB_RECEIPTS_WF;

2372:
2373: END TrackOverdue;
2374:
2375:
2376: END AP_WEB_RECEIPTS_WF;