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.33.12020000.3 2012/10/17 09:45:56 dsadipir ship $ */
3:
4: ------------------------
5: -- Day to minutes conversion 24*60

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

43:
44: BEGIN
45:
46:
47: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start ParseItemKey');
48:
49: ----------------------------------------------------------
50: l_debug_info := 'Parse the item key for the Expense Report Id';
51: ----------------------------------------------------------

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

50: l_debug_info := 'Parse the item key for the Expense Report Id';
51: ----------------------------------------------------------
52: return substrb(p_item_key, 1, instrb(p_item_key, C_ITEM_KEY_DELIM)-1);
53:
54: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end ParseItemKey');
55:
56: EXCEPTION
57: WHEN OTHERS THEN
58: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'ParseItemKey',

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

54: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end ParseItemKey');
55:
56: EXCEPTION
57: WHEN OTHERS THEN
58: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'ParseItemKey',
59: p_item_type, p_item_key, l_debug_info);
60: raise;
61: END ParseItemKey;
62:

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

92: EXCEPTION
93: WHEN NO_DATA_FOUND THEN
94: return 'N';
95: WHEN OTHERS THEN
96: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',
97: to_char(p_org_id), to_char(p_report_submitted_date), l_debug_info);
98: raise;
99: END IsNotifRuleSetup;
100:

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

116: l_is_notif_rule_setup VARCHAR2(1);
117:
118: BEGIN
119:
120: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsNotifRuleSetup');
121:
122: IF (p_funmode = 'RUN') THEN
123:
124: ----------------------------------------------------------

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

157: p_result := 'COMPLETE';
158:
159: END IF; -- p_funmode = 'RUN'
160:
161: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsNotifRuleSetup');
162:
163: EXCEPTION
164: WHEN OTHERS THEN
165: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',

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

161: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsNotifRuleSetup');
162:
163: EXCEPTION
164: WHEN OTHERS THEN
165: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsNotifRuleSetup',
166: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
167: raise;
168: END IsNotifRuleSetup;
169:

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

221: l_event_key wf_items.item_key%type;
222:
223: BEGIN
224:
225: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');
226:
227: ----------------------------------------------------------
228: l_debug_info := 'Generate Event Key';
229: ----------------------------------------------------------

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

242: --p_parameters => l_parameter_list);
243:
244: end if;
245:
246: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',

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

246: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',
251: p_expense_report_id, l_debug_info);
252: raise;
253: END RaiseOverdueEvent;
254:

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

262: l_event_key wf_items.item_key%type;
263:
264: BEGIN
265:
266: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');
267:
268: ----------------------------------------------------------
269: l_debug_info := 'Generate Event Key';
270: ----------------------------------------------------------

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

283: --p_parameters => l_parameter_list);
284:
285: end if;
286:
287: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',

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

287: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',
292: p_expense_report_id, l_debug_info);
293: raise;
294: END RaiseMissingEvent;
295:

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

303: l_event_key wf_items.item_key%type;
304:
305: BEGIN
306:
307: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');
308:
309: ----------------------------------------------------------
310: l_debug_info := 'Generate Event Key';
311: ----------------------------------------------------------

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

324: --p_parameters => l_parameter_list);
325:
326: end if;
327:
328: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',

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

328: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',
333: p_expense_report_id, l_debug_info);
334: raise;
335: END RaiseReceivedEvent;
336:

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

344: l_event_key wf_items.item_key%type;
345:
346: BEGIN
347:
348: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');
349:
350: ----------------------------------------------------------
351: l_debug_info := 'Generate Event Key';
352: ----------------------------------------------------------

Line 367: 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, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)

363: begin
364: update ap_expense_report_headers_all
365: set receipts_status = ''
366: where report_header_id = p_expense_report_id
367: 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, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
368: and receipts_received_date is null;
369:
370: update ap_expense_report_headers_all
371: set image_receipts_status = ''

Line 373: and nvl(image_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, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)

369:
370: update ap_expense_report_headers_all
371: set image_receipts_status = ''
372: where report_header_id = p_expense_report_id
373: and nvl(image_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, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
374: and image_receipts_received_date is null;
375: exception
376: when others then null;
377: end;

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

399: --p_parameters => l_parameter_list);
400:
401: end if;
402:
403: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

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

403: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',
408: p_expense_report_id, l_debug_info);
409: raise;
410: END RaiseAbortedEvent;
411:

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

424: l_report_header_id NUMBER;
425:
426: BEGIN
427:
428: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');
429:
430: IF (p_funmode = 'RUN') THEN
431:
432: ----------------------------------------------------------

Line 453: 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)

449: IF (l_receipt_type = 'ORIGINAL') THEN
450: update ap_expense_report_headers_all
451: set receipts_status = ''
452: where report_header_id = l_report_header_id
453: 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)
454: and receipts_received_date is null;
455: ELSE
456: update ap_expense_report_headers_all
457: set image_receipts_status = ''

Line 459: and nvl(image_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)

455: ELSE
456: update ap_expense_report_headers_all
457: set image_receipts_status = ''
458: where report_header_id = l_report_header_id
459: and nvl(image_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)
460: and image_receipts_received_date is null;
461: END IF;
462:
463: begin

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

480: p_result := 'COMPLETE';
481:
482: END IF; -- p_funmode = 'RUN'
483:
484: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',

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

484: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseAbortedEvent');
485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseAbortedEvent',
489: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
490: raise;
491: END RaiseAbortedEvent;
492:

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

525: l_is_notif_rule_setup varchar2(1) := 'N';
526:
527: BEGIN
528:
529: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start Init');
530:
531: ----------------------------------------------------------
532: l_debug_info := 'Parse the item key for the Expense Report Id';
533: ----------------------------------------------------------

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

793:
794: end if; -- (l_is_notif_rule_setup = 'Y')
795:
796:
797: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end Init');
798:
799: EXCEPTION
800: WHEN OTHERS THEN
801: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'Init',

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

797: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end Init');
798:
799: EXCEPTION
800: WHEN OTHERS THEN
801: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'Init',
802: p_item_type, p_item_key, l_expense_report_id, l_preparer_name, l_debug_info);
803: raise;
804: END Init;
805:

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

816: l_item_key VARCHAR2(200) := lower(p_item_key);
817:
818: BEGIN
819:
820: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitOverdue');
821:
822: IF (p_funmode = 'RUN') THEN
823:
824: ----------------------------------------------------------

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

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

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

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

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

875: l_item_key VARCHAR2(200) := lower(p_item_key);
876:
877: BEGIN
878:
879: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitMissing');
880:
881: IF (p_funmode = 'RUN') THEN
882:
883: ----------------------------------------------------------

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

910: p_result := 'COMPLETE';
911:
912: END IF; -- p_funmode = 'RUN'
913:
914: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitMissing');
915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitMissing',

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

914: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitMissing');
915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitMissing',
919: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
920: raise;
921: END InitMissing;
922:

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

938: l_found_item_key wf_items.item_key%TYPE;
939:
940: BEGIN
941:
942: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckOverdueExists');
943:
944: IF (p_funmode = 'RUN') THEN
945:
946: begin

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

979: ELSIF (p_funmode = 'CANCEL') THEN
980: p_result := 'COMPLETE';
981: END IF; -- p_funmode = 'RUN'
982:
983: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckOverdueExists');
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckOverdueExists',

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

983: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckOverdueExists');
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckOverdueExists',
988: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
989: raise;
990: END CheckOverdueExists;
991:

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

1007: l_found_item_key wf_items.item_key%TYPE;
1008:
1009: BEGIN
1010:
1011: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingExists');
1012:
1013: IF (p_funmode = 'RUN') THEN
1014:
1015: begin

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

1048: ELSIF (p_funmode = 'CANCEL') THEN
1049: p_result := 'COMPLETE';
1050: END IF; -- p_funmode = 'RUN'
1051:
1052: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingExists');
1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingExists',

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

1052: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingExists');
1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingExists',
1057: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1058: raise;
1059: END CheckMissingExists;
1060:

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

1075: l_workflow_flag VARCHAR2(1);
1076:
1077: BEGIN
1078:
1079: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortOverdue');
1080:
1081: IF (p_funmode = 'RUN') THEN
1082:
1083: l_expense_report_id := ParseItemKey(p_item_type, p_item_key);

Line 1089: IF (l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR l_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR

1085: SELECT receipts_status, image_receipts_status, expense_status_code, workflow_approved_flag
1086: INTO l_receipts_status, l_image_receipts_status, l_expense_status_code, l_workflow_flag
1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
1088:
1089: IF (l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR l_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR
1090: l_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR
1091: l_expense_status_code = 'WITHDRAWN') THEN
1092:
1093: AbortProcess(p_item_type, p_item_key, C_OVERDUE_ORIG_EVENT_KEY);

Line 1090: l_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR

1086: INTO l_receipts_status, l_image_receipts_status, l_expense_status_code, l_workflow_flag
1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
1088:
1089: IF (l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR l_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR
1090: l_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR
1091: l_expense_status_code = 'WITHDRAWN') THEN
1092:
1093: AbortProcess(p_item_type, p_item_key, C_OVERDUE_ORIG_EVENT_KEY);
1094:

Line 1097: IF ((l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED AND l_workflow_flag IN ('P', 'Y')) OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR

1093: AbortProcess(p_item_type, p_item_key, C_OVERDUE_ORIG_EVENT_KEY);
1094:
1095: END IF;
1096:
1097: IF ((l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED AND l_workflow_flag IN ('P', 'Y')) OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR
1098: l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR
1099: l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR l_expense_status_code = 'WITHDRAWN') THEN
1100:
1101: AbortProcess(p_item_type, p_item_key, C_OVERDUE_IMG_EVENT_KEY);

Line 1098: l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR

1094:
1095: END IF;
1096:
1097: IF ((l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED AND l_workflow_flag IN ('P', 'Y')) OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR
1098: l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR l_image_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR
1099: l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR l_expense_status_code = 'WITHDRAWN') THEN
1100:
1101: AbortProcess(p_item_type, p_item_key, C_OVERDUE_IMG_EVENT_KEY);
1102:

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

1105: p_result := 'COMPLETE';
1106:
1107: END IF; -- p_funmode = 'RUN'
1108:
1109: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortOverdue');
1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortOverdue',

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

1109: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortOverdue');
1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortOverdue',
1114: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1115: raise;
1116: END AbortOverdue;
1117:

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

1129: l_item_key wf_items.item_key%type;
1130:
1131: BEGIN
1132:
1133: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortMissing');
1134:
1135: IF (p_funmode = 'RUN') THEN
1136:
1137: AbortProcess(p_item_type, p_item_key, C_MISSING_EVENT_KEY);

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

1139: p_result := 'COMPLETE';
1140:
1141: END IF; -- p_funmode = 'RUN'
1142:
1143: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortMissing');
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortMissing',

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

1143: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortMissing');
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortMissing',
1148: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1149: raise;
1150: END AbortMissing;
1151:

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

1173: and end_date is null;
1174:
1175: BEGIN
1176:
1177: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortProcess');
1178:
1179: ----------------------------------------------------------
1180: l_debug_info := 'Getting item key of current process';
1181: ----------------------------------------------------------

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

1208:
1209: end loop;
1210: close c_receipt_events;
1211:
1212: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortProcess');
1213:
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortProcess',

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

1212: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end AbortProcess');
1213:
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'AbortProcess',
1217: p_item_type, p_item_key, p_event_key, l_debug_info);
1218: raise;
1219: END AbortProcess;
1220:

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

1231: l_item_key VARCHAR2(200) := lower(p_item_key);
1232:
1233: BEGIN
1234:
1235: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitReceived');
1236:
1237: IF (p_funmode = 'RUN') THEN
1238:
1239: ----------------------------------------------------------

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

1262: p_result := 'COMPLETE';
1263:
1264: END IF; -- p_funmode = 'RUN'
1265:
1266: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitReceived');
1267:
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitReceived',

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

1266: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitReceived');
1267:
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitReceived',
1271: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1272: raise;
1273: END InitReceived;
1274:

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

1284: l_debug_info VARCHAR2(200);
1285:
1286: BEGIN
1287:
1288: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start InitAborted');
1289:
1290: IF (p_funmode = 'RUN') THEN
1291:
1292: ----------------------------------------------------------

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

1297: p_result := 'COMPLETE';
1298:
1299: END IF; -- p_funmode = 'RUN'
1300:
1301: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitAborted');
1302:
1303: EXCEPTION
1304: WHEN OTHERS THEN
1305: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitAborted',

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

1301: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end InitAborted');
1302:
1303: EXCEPTION
1304: WHEN OTHERS THEN
1305: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'InitAborted',
1306: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1307: raise;
1308: END InitAborted;
1309:

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

1330: EXCEPTION
1331: WHEN NO_DATA_FOUND THEN
1332: return null;
1333: WHEN OTHERS THEN
1334: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',
1335: to_char(p_report_header_id), l_debug_info);
1336: raise;
1337: END GetReceiptsStatus;
1338:

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

1351: l_report_header_id number;
1352:
1353: BEGIN
1354:
1355: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start GetReceiptsStatus');
1356:
1357: IF (p_funmode = 'RUN') THEN
1358:
1359: ------------------------------------------------------------

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

1371: p_result := 'COMPLETE:'||l_receipts_status;
1372:
1373: END IF; -- p_funmode = 'RUN'
1374:
1375: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetReceiptsStatus');
1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',

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

1375: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetReceiptsStatus');
1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',
1380: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1381: raise;
1382: END GetReceiptsStatus;
1383:

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

1392: l_orig_receipts_status varchar2(30);
1393:
1394: BEGIN
1395:
1396: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');
1397:
1398: ------------------------------------------------------------
1399: l_debug_info := 'Lock current Receipt Status';
1400: ------------------------------------------------------------

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

1410: update ap_expense_report_headers_all
1411: set receipts_status = p_receipts_status
1412: where report_header_id = p_report_header_id;
1413:
1414: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

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

1414: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',
1419: to_char(p_report_header_id), p_receipts_status, l_debug_info);
1420: raise;
1421: END SetReceiptsStatus;
1422:

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

1436: l_report_header_id number;
1437:
1438: BEGIN
1439:
1440: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetReceiptsStatus');
1441:
1442: IF (p_funmode = 'RUN') THEN
1443:
1444: -------------------------------------------------------------------

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

1464: p_result := 'COMPLETE';
1465:
1466: END IF; -- p_funmode = 'RUN'
1467:
1468: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',

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

1468: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetReceiptsStatus',
1473: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1474: raise;
1475: END SetReceiptsStatus;
1476:

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

1489: l_report_header_id number;
1490:
1491: BEGIN
1492:
1493: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
1494:
1495: /*
1496: DAYS_OVERDUE is the diff between notif sent date and date the
1497: the expense report receipts package became overdue

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

1530: ------------------------------------------------------------
1531: SetReceiptsStatus(l_report_header_id, C_OVERDUE);
1532: end if;
1533:
1534: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1535:
1536: EXCEPTION
1537: WHEN OTHERS THEN
1538: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

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

1534: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1535:
1536: EXCEPTION
1537: WHEN OTHERS THEN
1538: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
1539: p_item_type, p_item_key, l_debug_info);
1540: raise;
1541: END SetDaysOverdue;
1542:

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

1557: l_notif_rule_days_overdue number;
1558:
1559: BEGIN
1560:
1561: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
1562:
1563: IF (p_funmode = 'RUN') THEN
1564:
1565: SetDaysOverdue(p_item_type, p_item_key);

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

1567: p_result := 'COMPLETE';
1568:
1569: END IF; -- p_funmode = 'RUN'
1570:
1571: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

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

1571: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
1576: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1577: raise;
1578: END SetDaysOverdue;
1579:

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

1591: l_missing_decl_reqd fnd_lookups.lookup_code%TYPE;
1592:
1593: BEGIN
1594:
1595: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingDeclRequired');
1596:
1597: IF (p_funmode = 'RUN') THEN
1598:
1599: ----------------------------------------------------------

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

1610: end if;
1611:
1612: END IF; -- p_funmode = 'RUN'
1613:
1614: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingDeclRequired');
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingDeclRequired',

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

1614: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckMissingDeclRequired');
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckMissingDeclRequired',
1619: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1620: raise;
1621: END CheckMissingDeclRequired;
1622:

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

1638: l_receipts_status varchar2(30);
1639:
1640: BEGIN
1641:
1642: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyReceived');
1643:
1644: IF (p_funmode = 'RUN') THEN
1645:
1646: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

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

1675: end if;
1676:
1677: END IF; -- p_funmode = 'RUN'
1678:
1679: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyReceived');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyReceived',

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

1679: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyReceived');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyReceived',
1684: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1685: raise;
1686: END CheckNotifyReceived;
1687:

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

1701: l_report_header_id number;
1702:
1703: BEGIN
1704:
1705: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsReceivedWaived');
1706:
1707: IF (p_funmode = 'RUN') THEN
1708:
1709: ------------------------------------------------------------

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

1727: end if;
1728:
1729: END IF; -- p_funmode = 'RUN'
1730:
1731: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsReceivedWaived');
1732:
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsReceivedWaived',

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

1731: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsReceivedWaived');
1732:
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsReceivedWaived',
1736: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1737: raise;
1738: END IsReceivedWaived;
1739:

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

1750: l_is_shortpay varchar2(1) := 'N';
1751:
1752: BEGIN
1753:
1754: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsShortpay');
1755:
1756: ------------------------------------------------------------
1757: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1758: ------------------------------------------------------------

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

1776: and rownum = 1;
1777:
1778: return l_is_shortpay;
1779:
1780: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsShortpay');
1781:
1782: EXCEPTION
1783: WHEN NO_DATA_FOUND THEN
1784: return 'N';

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

1782: EXCEPTION
1783: WHEN NO_DATA_FOUND THEN
1784: return 'N';
1785: WHEN OTHERS THEN
1786: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsShortpay',
1787: p_item_type, p_item_key, l_debug_info);
1788: raise;
1789: END IsShortpay;
1790:

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

1802: l_is_shortpay VARCHAR2(1) := 'N';
1803:
1804: BEGIN
1805:
1806: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsMissingShortpay');
1807:
1808: IF (p_funmode = 'RUN') THEN
1809:
1810: ------------------------------------------------------------

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

1817: p_result := 'COMPLETE:'||l_is_shortpay;
1818:
1819: END IF; -- p_funmode = 'RUN'
1820:
1821: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsMissingShortpay');
1822:
1823: EXCEPTION
1824: WHEN NO_DATA_FOUND THEN
1825: p_result := 'COMPLETE:N';

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

1823: EXCEPTION
1824: WHEN NO_DATA_FOUND THEN
1825: p_result := 'COMPLETE:N';
1826: WHEN OTHERS THEN
1827: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsMissingShortpay',
1828: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1829: raise;
1830: END IsMissingShortpay;
1831:

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

1843: l_is_shortpay VARCHAR2(1) := 'N';
1844:
1845: BEGIN
1846:
1847: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start IsPolicyShortpay');
1848:
1849: IF (p_funmode = 'RUN') THEN
1850:
1851: ------------------------------------------------------------

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

1858: p_result := 'COMPLETE:'||l_is_shortpay;
1859:
1860: END IF; -- p_funmode = 'RUN'
1861:
1862: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end IsPolicyShortpay');
1863:
1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: p_result := 'COMPLETE:N';

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

1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: p_result := 'COMPLETE:N';
1867: WHEN OTHERS THEN
1868: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'IsPolicyShortpay',
1869: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
1870: raise;
1871: END IsPolicyShortpay;
1872:

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

1883: l_report_header_id number;
1884:
1885: BEGIN
1886:
1887: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteShortpay');
1888:
1889: ------------------------------------------------------------
1890: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1891: ------------------------------------------------------------

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

1905: exception
1906: when others then null;
1907: end;
1908:
1909: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteShortpay');
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteShortpay',

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

1909: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteShortpay');
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteShortpay',
1914: p_item_type, p_item_key, p_activity, p_result, l_debug_info);
1915: raise;
1916: END CompleteShortpay;
1917:

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

1927: l_debug_info VARCHAR2(200);
1928:
1929: BEGIN
1930:
1931: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompleteMissingShortpay');
1932:
1933: IF (p_funmode = 'RUN') THEN
1934:
1935: ----------------------------------------------------------

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

1955: end;
1956:
1957: end if;
1958:
1959: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteMissingShortpay');
1960:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteMissingShortpay',

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

1959: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompleteMissingShortpay');
1960:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompleteMissingShortpay',
1964: p_item_type, p_item_key, to_char(p_actid), p_result, l_debug_info);
1965: raise;
1966: END CompleteMissingShortpay;
1967:

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

1977: l_debug_info VARCHAR2(200);
1978:
1979: BEGIN
1980:
1981: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CompletePolicyShortpay');
1982:
1983: IF (p_funmode = 'RUN') THEN
1984:
1985: ----------------------------------------------------------

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

1997: end;
1998:
1999: end if;
2000:
2001: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompletePolicyShortpay');
2002:
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompletePolicyShortpay',

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

2001: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CompletePolicyShortpay');
2002:
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CompletePolicyShortpay',
2006: p_item_type, p_item_key, to_char(p_actid), p_result, l_debug_info);
2007: raise;
2008: END CompletePolicyShortpay;
2009:

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

2058: l_org_id ap_expense_params_all.org_id%type;
2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;
2060: BEGIN
2061:
2062: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');
2063:
2064: IF (p_funmode = 'RUN') THEN
2065:
2066: -------------------------------------------------------------------

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

2314: p_result := 'COMPLETE:Y';
2315:
2316: END IF;
2317:
2318: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end StoreNote');
2319:
2320: EXCEPTION
2321: WHEN OTHERS THEN
2322: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'StoreNote',

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

2318: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end StoreNote');
2319:
2320: EXCEPTION
2321: WHEN OTHERS THEN
2322: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'StoreNote',
2323: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
2324: raise;
2325: END StoreNote;
2326:

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

2338: l_expense_report_id number;
2339:
2340: BEGIN
2341:
2342: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CallbackFunction');
2343:
2344: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2345: p_item_key,
2346: 'ORG_ID');

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

2404: return;
2405: end if;
2406: */
2407:
2408: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CallbackFunction');
2409:
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CallbackFunction',

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

2408: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CallbackFunction');
2409:
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CallbackFunction',
2413: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
2414: raise;
2415: END CallbackFunction;
2416:

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

2425: l_event_key wf_items.item_key%type;
2426:
2427: BEGIN
2428:
2429: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');
2430:
2431: ----------------------------------------------------------
2432: l_debug_info := 'Generate Event Key';
2433: ----------------------------------------------------------

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

2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
2452: SET OVERDUE_REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2453: WHERE REPORT_HEADER_ID = p_expense_report_id;
2454:
2455: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
2456:
2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',

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

2455: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
2456:
2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseOverdueEvent',
2460: p_expense_report_id, l_debug_info);
2461: raise;
2462: END RaiseOverdueEvent;
2463:

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

2471: l_event_key wf_items.item_key%type;
2472:
2473: BEGIN
2474:
2475: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');
2476:
2477: ----------------------------------------------------------
2478: l_debug_info := 'Generate Event Key';
2479: ----------------------------------------------------------

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

2492: --p_parameters => l_parameter_list);
2493:
2494: end if;
2495:
2496: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
2497:
2498: EXCEPTION
2499: WHEN OTHERS THEN
2500: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',

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

2496: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseMissingEvent');
2497:
2498: EXCEPTION
2499: WHEN OTHERS THEN
2500: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseMissingEvent',
2501: p_expense_report_id, l_debug_info);
2502: raise;
2503: END RaiseMissingEvent;
2504:

Line 2635: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))

2631: )
2632: or
2633: ((decode(aerh.IMAGE_RECEIPTS_STATUS, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.IMAGE_RECEIPTS_STATUS) = C_REQUIRED
2634: and sysdate - (aerh.report_submitted_date + rs.NOTIFY_IMG_RCT_OVERDUE_DAYS) > 0)
2635: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))
2636: and not exists
2637: (select 1
2638: from wf_items
2639: where decode(aerh.IMAGE_RECEIPTS_STATUS, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.IMAGE_RECEIPTS_STATUS) = C_REQUIRED

Line 2649: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))

2645: )
2646: or
2647: ((aerh.IMAGE_RECEIPTS_STATUS = C_MISSING and nvl(aerh.RECEIPTS_STATUS, C_NOT_REQUIRED) in (C_NOT_REQUIRED, C_MISSING, C_WAIVED, C_RECEIVED)
2648: and sysdate - (aerh.report_submitted_date + rs.NOTIFY_IMG_RCT_OVERDUE_DAYS) > 0)
2649: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))
2650: and not exists
2651: (select 1
2652: from wf_items
2653: where aerh.IMAGE_RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT'

Line 3115: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetImageReceiptsStatus',

3111: EXCEPTION
3112: WHEN NO_DATA_FOUND THEN
3113: return null;
3114: WHEN OTHERS THEN
3115: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetImageReceiptsStatus',
3116: to_char(p_report_header_id), l_debug_info);
3117: raise;
3118: END GetImageReceiptsStatus;
3119:

Line 3132: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetImageReceiptsStatus');

3128: l_image_receipts_status varchar2(30);
3129:
3130: BEGIN
3131:
3132: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetImageReceiptsStatus');
3133:
3134: ------------------------------------------------------------
3135: l_debug_info := 'Lock current Receipt Status';
3136: ------------------------------------------------------------

Line 3150: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');

3146: update ap_expense_report_headers_all
3147: set image_receipts_status = p_receipts_status
3148: where report_header_id = p_report_header_id;
3149:
3150: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');
3151:
3152: EXCEPTION
3153: WHEN OTHERS THEN
3154: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',

Line 3154: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',

3150: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');
3151:
3152: EXCEPTION
3153: WHEN OTHERS THEN
3154: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',
3155: to_char(p_report_header_id), p_receipts_status, l_debug_info);
3156: raise;
3157: END SetImageReceiptsStatus;
3158:

Line 3178: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyImageReceived');

3174: l_image_receipts_status varchar2(30);
3175:
3176: BEGIN
3177:
3178: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyImageReceived');
3179:
3180: IF (p_funmode = 'RUN') THEN
3181:
3182: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 3215: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyImageReceived');

3211: end if;
3212:
3213: END IF; -- p_funmode = 'RUN'
3214:
3215: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyImageReceived');
3216:
3217: EXCEPTION
3218: WHEN OTHERS THEN
3219: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyImageReceived',

Line 3219: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyImageReceived',

3215: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end CheckNotifyImageReceived');
3216:
3217: EXCEPTION
3218: WHEN OTHERS THEN
3219: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'CheckNotifyImageReceived',
3220: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
3221: raise;
3222: END CheckNotifyImageReceived;
3223:

Line 3240: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetImageReceiptsStatus');

3236: l_report_header_id number;
3237:
3238: BEGIN
3239:
3240: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetImageReceiptsStatus');
3241:
3242: IF (p_funmode = 'RUN') THEN
3243:
3244: -------------------------------------------------------------------

Line 3268: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');

3264: p_result := 'COMPLETE';
3265:
3266: END IF; -- p_funmode = 'RUN'
3267:
3268: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');
3269:
3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',

Line 3272: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',

3268: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');
3269:
3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetImageReceiptsStatus',
3273: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
3274: raise;
3275: END SetImageReceiptsStatus;
3276:

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

3289: l_notif_rule_days_overdue number;
3290:
3291: BEGIN
3292:
3293: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
3294:
3295: IF (p_funmode = 'RUN') THEN
3296:
3297: SetImageOverdueDays(p_item_type, p_item_key);

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

3299: p_result := 'COMPLETE';
3300:
3301: END IF; -- p_funmode = 'RUN'
3302:
3303: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

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

3303: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
3308: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
3309: raise;
3310: END SetImageOverdueDays;
3311:

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

3324: l_report_header_id number;
3325:
3326: BEGIN
3327:
3328: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start SetDaysOverdue');
3329:
3330: /*
3331: DAYS_OVERDUE is the diff between notif sent date and date the
3332: the expense report receipts package became overdue

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

3364: ------------------------------------------------------------
3365: SetImageReceiptsStatus(l_report_header_id, C_OVERDUE);
3366: end if;
3367:
3368: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
3369:
3370: EXCEPTION
3371: WHEN OTHERS THEN
3372: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',

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

3368: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetDaysOverdue');
3369:
3370: EXCEPTION
3371: WHEN OTHERS THEN
3372: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'SetDaysOverdue',
3373: p_item_type, p_item_key, l_debug_info);
3374: raise;
3375: END SetImageOverdueDays;
3376:

Line 3392: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start GetImageReceiptsStatus');

3388: l_report_header_id number;
3389:
3390: BEGIN
3391:
3392: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start GetImageReceiptsStatus');
3393:
3394: IF (p_funmode = 'RUN') THEN
3395:
3396: ------------------------------------------------------------

Line 3412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetImageReceiptsStatus');

3408: p_result := 'COMPLETE:'||l_receipts_status;
3409:
3410: END IF; -- p_funmode = 'RUN'
3411:
3412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetImageReceiptsStatus');
3413:
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',

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

3412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end GetImageReceiptsStatus');
3413:
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'GetReceiptsStatus',
3417: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
3418: raise;
3419: END GetImageReceiptsStatus;
3420:

Line 3445: IF (nvl(l_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) <> AP_WEB_RECEIPTS_WF.C_RECEIVED) THEN

3441: end if;
3442:
3443: l_receipts_status := GetReceiptsStatus(l_expense_report_id);
3444:
3445: IF (nvl(l_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) <> AP_WEB_RECEIPTS_WF.C_RECEIVED) THEN
3446: SetReceiptsStatus(l_expense_report_id, C_IN_TRANSIT);
3447: END IF;
3448: p_result := 'COMPLETE';
3449: END IF;

Line 3561: --AP_WEB_RECEIPTS_WF.RaiseAbortedEvent(l_expense_report_id);

3557:
3558: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_expense_report_id);
3559: AP_WEB_AUDIT_UTILS.clear_audit_reason_codes(l_expense_report_id);
3560: AP_WEB_DB_EXPLINE_PKG.resetAPflags(l_expense_report_id);
3561: --AP_WEB_RECEIPTS_WF.RaiseAbortedEvent(l_expense_report_id);
3562:
3563: BEGIN
3564: wf_engine.AbortProcess (itemtype => C_APEXP,
3565: itemkey => l_item_key,

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

3740: l_debug_info VARCHAR2(200);
3741:
3742: l_event_key wf_items.item_key%type;
3743: BEGIN
3744: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');
3745:
3746: ----------------------------------------------------------
3747: l_debug_info := 'Generate Event Key';
3748: ----------------------------------------------------------

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

3765: --p_parameters => l_parameter_list);
3766:
3767: end if;
3768:
3769: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
3770:
3771: EXCEPTION
3772: WHEN OTHERS THEN
3773: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',

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

3769: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseReceivedEvent');
3770:
3771: EXCEPTION
3772: WHEN OTHERS THEN
3773: Wf_Core.Context('AP_WEB_RECEIPTS_WF', 'RaiseReceivedEvent',
3774: p_expense_report_id, l_debug_info);
3775: raise;
3776: END RaiseReceivedEvent;
3777: PROCEDURE AbortOriginalOverdue(

Line 3848: END AP_WEB_RECEIPTS_WF;

3844: END;
3845:
3846:
3847:
3848: END AP_WEB_RECEIPTS_WF;