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_UTILITIES_PKG

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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',