eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_HOLDS_WF dependencies on FND_FILE

Line 1057: fnd_file.put_line(fnd_file.log, l_debug_info);

1053: BEGIN
1054:
1055: ------------------------------------------------------------
1056: l_debug_info := 'Process Hold Each Scenario';
1057: fnd_file.put_line(fnd_file.log, l_debug_info);
1058: ------------------------------------------------------------
1059: HoldEach;
1060:
1061: ------------------------------------------------------------

Line 1063: fnd_file.put_line(fnd_file.log, l_debug_info);

1059: HoldEach;
1060:
1061: ------------------------------------------------------------
1062: l_debug_info := 'Process Hold All Scenario';
1063: fnd_file.put_line(fnd_file.log, l_debug_info);
1064: ------------------------------------------------------------
1065: HoldAll;
1066:
1067: ------------------------------------------------------------

Line 1069: fnd_file.put_line(fnd_file.log, l_debug_info);

1065: HoldAll;
1066:
1067: ------------------------------------------------------------
1068: l_debug_info := 'Process Hold BothPay Scenario';
1069: fnd_file.put_line(fnd_file.log, l_debug_info);
1070: ------------------------------------------------------------
1071: HoldBothPay;
1072:
1073: ------------------------------------------------------------

Line 1075: fnd_file.put_line(fnd_file.log, l_debug_info);

1071: HoldBothPay;
1072:
1073: ------------------------------------------------------------
1074: l_debug_info := 'Process Obsolete Holds';
1075: fnd_file.put_line(fnd_file.log, l_debug_info);
1076: ------------------------------------------------------------
1077: ObsoleteHold;
1078:
1079: EXCEPTION

Line 1113: fnd_file.put_line(fnd_file.log, l_debug_info);

1109: BEGIN
1110:
1111: ------------------------------------------------------------
1112: l_debug_info := 'Lock current Expense Status for: '||p_report_header_id;
1113: fnd_file.put_line(fnd_file.log, l_debug_info);
1114: ------------------------------------------------------------
1115: select expense_status_code
1116: into l_expense_status_code
1117: from ap_expense_report_headers

Line 1123: fnd_file.put_line(fnd_file.log, l_debug_info);

1119: for update of expense_status_code nowait;
1120:
1121: ------------------------------------------------------------
1122: l_debug_info := 'Update current Expense Status to: '||p_expense_status_code||' for: '||p_report_header_id;
1123: fnd_file.put_line(fnd_file.log, l_debug_info);
1124: ------------------------------------------------------------
1125: update ap_expense_report_headers
1126: set expense_status_code = p_expense_status_code,
1127: holding_report_header_id = p_holding_report_header_id,

Line 1162: fnd_file.put_line(fnd_file.log, l_debug_info);

1158: BEGIN
1159:
1160: ------------------------------------------------------------
1161: l_debug_info := 'Release Hold for: '||p_report_header_id;
1162: fnd_file.put_line(fnd_file.log, l_debug_info);
1163: ------------------------------------------------------------
1164: UpdateExpenseStatus(p_report_header_id, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS, null);
1165:
1166: EXCEPTION

Line 1197: fnd_file.put_line(fnd_file.log, l_debug_info);

1193: BEGIN
1194:
1195: ------------------------------------------------------------
1196: l_debug_info := 'Place Hold on: '||p_report_header_id||' because of: '||p_holding_report_header_id;
1197: fnd_file.put_line(fnd_file.log, l_debug_info);
1198: ------------------------------------------------------------
1199: UpdateExpenseStatus(p_report_header_id, AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, p_holding_report_header_id);
1200:
1201: EXCEPTION

Line 1231: fnd_file.put_line(fnd_file.log, l_debug_info);

1227: BEGIN
1228:
1229: ------------------------------------------------------------
1230: l_debug_info := 'Ready for Payment for: '||p_report_header_id;
1231: fnd_file.put_line(fnd_file.log, l_debug_info);
1232: ------------------------------------------------------------
1233: UpdateExpenseStatus(p_report_header_id, AP_WEB_RECEIPTS_WF.C_INVOICED, null);
1234:
1235: EXCEPTION

Line 1338: fnd_file.put_line(fnd_file.log, l_debug_info);

1334: BEGIN
1335:
1336: ------------------------------------------------------------
1337: l_debug_info := 'Determine whether to place Holds';
1338: fnd_file.put_line(fnd_file.log, l_debug_info);
1339: ------------------------------------------------------------
1340: open c_hold_each;
1341: loop
1342:

Line 1362: fnd_file.put_line(fnd_file.log, l_debug_info);

1358: nvl(l_image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)))) then
1359:
1360: ------------------------------------------------------------
1361: l_debug_info := 'Receipts not required or have been received/waived';
1362: fnd_file.put_line(fnd_file.log, l_debug_info);
1363: ------------------------------------------------------------
1364: ------------------------------------------------------------
1365: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
1366: fnd_file.put_line(fnd_file.log, l_debug_info);

Line 1366: fnd_file.put_line(fnd_file.log, l_debug_info);

1362: fnd_file.put_line(fnd_file.log, l_debug_info);
1363: ------------------------------------------------------------
1364: ------------------------------------------------------------
1365: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
1366: fnd_file.put_line(fnd_file.log, l_debug_info);
1367: ------------------------------------------------------------
1368: ReadyForPayment(l_report_header_id);
1369:
1370: ------------------------------------------------------------

Line 1386: fnd_file.put_line(fnd_file.log, l_debug_info);

1382: /*elsif (nvl(l_image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)) then
1383:
1384: ------------------------------------------------------------
1385: l_debug_info := 'Image Receipts not required or have been received/waived';
1386: fnd_file.put_line(fnd_file.log, l_debug_info);
1387: ------------------------------------------------------------
1388: ------------------------------------------------------------
1389: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
1390: fnd_file.put_line(fnd_file.log, l_debug_info);

Line 1390: fnd_file.put_line(fnd_file.log, l_debug_info);

1386: fnd_file.put_line(fnd_file.log, l_debug_info);
1387: ------------------------------------------------------------
1388: ------------------------------------------------------------
1389: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
1390: fnd_file.put_line(fnd_file.log, l_debug_info);
1391: ------------------------------------------------------------
1392: ReadyForPayment(l_report_header_id);*/
1393:
1394: elsif (l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS or

Line 1399: fnd_file.put_line(fnd_file.log, l_debug_info);

1395: (l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD and l_holding_report_header_id <> l_report_header_id)) then
1396:
1397: ------------------------------------------------------------
1398: l_debug_info := 'Set status Payment Held and set holding_report_header_id to current report_header_id for: '||l_report_header_id;
1399: fnd_file.put_line(fnd_file.log, l_debug_info);
1400: ------------------------------------------------------------
1401: PlaceHold(l_report_header_id, l_report_header_id);
1402:
1403: ------------------------------------------------------------

Line 1405: fnd_file.put_line(fnd_file.log, l_debug_info);

1401: PlaceHold(l_report_header_id, l_report_header_id);
1402:
1403: ------------------------------------------------------------
1404: l_debug_info := 'Raise hold placed event for: '||l_report_header_id;
1405: fnd_file.put_line(fnd_file.log, l_debug_info);
1406: ------------------------------------------------------------
1407: RaiseHeldEvent(l_report_header_id);
1408:
1409: elsif (l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD and

Line 1414: fnd_file.put_line(fnd_file.log, l_debug_info);

1410: nvl(l_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)) then
1411:
1412: ------------------------------------------------------------
1413: l_debug_info := 'Payment Held status untouched for: '||l_report_header_id;
1414: fnd_file.put_line(fnd_file.log, l_debug_info);
1415: ------------------------------------------------------------
1416:
1417: else
1418:

Line 1421: fnd_file.put_line(fnd_file.log, l_debug_info);

1417: else
1418:
1419: ------------------------------------------------------------
1420: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
1421: fnd_file.put_line(fnd_file.log, l_debug_info);
1422: ------------------------------------------------------------
1423: ReadyForPayment(l_report_header_id);
1424:
1425: end if;

Line 1485: fnd_file.put_line(fnd_file.log, l_debug_info);

1481: BEGIN
1482:
1483: ------------------------------------------------------------
1484: l_debug_info := 'Get Oldest Overdue Receipts';
1485: fnd_file.put_line(fnd_file.log, l_debug_info);
1486: ------------------------------------------------------------
1487: open c_oldest_overdue_receipts;
1488: fetch c_oldest_overdue_receipts into l_overdue_report_header_id;
1489: close c_oldest_overdue_receipts;

Line 1552: fnd_file.put_line(fnd_file.log, l_debug_info);

1548: BEGIN
1549:
1550: ------------------------------------------------------------
1551: l_debug_info := 'Get Oldest Overdue Receipts';
1552: fnd_file.put_line(fnd_file.log, l_debug_info);
1553: ------------------------------------------------------------
1554: open c_oldest_overdue_receipts;
1555: fetch c_oldest_overdue_receipts into l_overdue_report_header_id;
1556: close c_oldest_overdue_receipts;

Line 1665: fnd_file.put_line(fnd_file.log, l_debug_info);

1661: BEGIN
1662:
1663: ------------------------------------------------------------
1664: l_debug_info := 'Determine whether to place Holds';
1665: fnd_file.put_line(fnd_file.log, l_debug_info);
1666: ------------------------------------------------------------
1667: open c_hold_all;
1668: loop
1669:

Line 1681: fnd_file.put_line(fnd_file.log, l_debug_info);

1677: exit when c_hold_all%NOTFOUND;
1678:
1679: ------------------------------------------------------------
1680: l_debug_info := 'Get oldest overdue receipts for employee: '||to_char(l_employee_id);
1681: fnd_file.put_line(fnd_file.log, l_debug_info);
1682: ------------------------------------------------------------
1683: l_overdue_report_header_id := GetOldestOverdueReceipts(l_employee_id, l_hold_rct_overdue_days);
1684:
1685: l_overdue_img_report_hdr_id := GetOldestImgOverdueReceipts(l_employee_id, l_hold_rct_overdue_days);

Line 1689: fnd_file.put_line(fnd_file.log, l_debug_info);

1685: l_overdue_img_report_hdr_id := GetOldestImgOverdueReceipts(l_employee_id, l_hold_rct_overdue_days);
1686:
1687: ------------------------------------------------------------
1688: l_debug_info := 'Oldest overdue receipts is: '||to_char(l_overdue_report_header_id);
1689: fnd_file.put_line(fnd_file.log, l_debug_info);
1690: ------------------------------------------------------------
1691:
1692: ------------------------------------------------------------
1693: l_debug_info := 'Oldest overdue image receipts is: '||to_char(l_overdue_img_report_hdr_id);

Line 1694: fnd_file.put_line(fnd_file.log, l_debug_info);

1690: ------------------------------------------------------------
1691:
1692: ------------------------------------------------------------
1693: l_debug_info := 'Oldest overdue image receipts is: '||to_char(l_overdue_img_report_hdr_id);
1694: fnd_file.put_line(fnd_file.log, l_debug_info);
1695: ------------------------------------------------------------
1696:
1697: if (l_overdue_report_header_id is not null) then
1698:

Line 1701: fnd_file.put_line(fnd_file.log, l_debug_info);

1697: if (l_overdue_report_header_id is not null) then
1698:
1699: ------------------------------------------------------------
1700: l_debug_info := 'Current holding report is: '||to_char(l_holding_report_header_id);
1701: fnd_file.put_line(fnd_file.log, l_debug_info);
1702: ------------------------------------------------------------
1703:
1704: if (l_overdue_report_header_id <> nvl(l_holding_report_header_id, 0)) then
1705:

Line 1708: fnd_file.put_line(fnd_file.log, l_debug_info);

1704: if (l_overdue_report_header_id <> nvl(l_holding_report_header_id, 0)) then
1705:
1706: ------------------------------------------------------------
1707: l_debug_info := 'Place Hold';
1708: fnd_file.put_line(fnd_file.log, l_debug_info);
1709: ------------------------------------------------------------
1710:
1711: ------------------------------------------------------------
1712: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to overdue report_header_id: '||l_overdue_report_header_id;

Line 1713: fnd_file.put_line(fnd_file.log, l_debug_info);

1709: ------------------------------------------------------------
1710:
1711: ------------------------------------------------------------
1712: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to overdue report_header_id: '||l_overdue_report_header_id;
1713: fnd_file.put_line(fnd_file.log, l_debug_info);
1714: ------------------------------------------------------------
1715: PlaceHold(l_report_header_id, l_overdue_report_header_id);
1716:
1717: ------------------------------------------------------------

Line 1719: fnd_file.put_line(fnd_file.log, l_debug_info);

1715: PlaceHold(l_report_header_id, l_overdue_report_header_id);
1716:
1717: ------------------------------------------------------------
1718: l_debug_info := 'Raise hold placed event for: '||l_report_header_id;
1719: fnd_file.put_line(fnd_file.log, l_debug_info);
1720: ------------------------------------------------------------
1721: RaiseHeldEvent(l_report_header_id);
1722:
1723: end if;

Line 1728: fnd_file.put_line(fnd_file.log, l_debug_info);

1724: elsif (l_overdue_img_report_hdr_id is not null) then
1725:
1726: ------------------------------------------------------------
1727: l_debug_info := 'Current holding report is: '||to_char(l_holding_report_header_id);
1728: fnd_file.put_line(fnd_file.log, l_debug_info);
1729: ------------------------------------------------------------
1730:
1731: if (l_overdue_img_report_hdr_id <> nvl(l_holding_report_header_id, 0)) then
1732:

Line 1735: fnd_file.put_line(fnd_file.log, l_debug_info);

1731: if (l_overdue_img_report_hdr_id <> nvl(l_holding_report_header_id, 0)) then
1732:
1733: ------------------------------------------------------------
1734: l_debug_info := 'Place Hold';
1735: fnd_file.put_line(fnd_file.log, l_debug_info);
1736: ------------------------------------------------------------
1737:
1738: ------------------------------------------------------------
1739: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to overdue report_header_id: '|| l_overdue_img_report_hdr_id;

Line 1740: fnd_file.put_line(fnd_file.log, l_debug_info);

1736: ------------------------------------------------------------
1737:
1738: ------------------------------------------------------------
1739: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to overdue report_header_id: '|| l_overdue_img_report_hdr_id;
1740: fnd_file.put_line(fnd_file.log, l_debug_info);
1741: ------------------------------------------------------------
1742: PlaceHold(l_report_header_id, l_overdue_img_report_hdr_id);
1743:
1744: ------------------------------------------------------------

Line 1746: fnd_file.put_line(fnd_file.log, l_debug_info);

1742: PlaceHold(l_report_header_id, l_overdue_img_report_hdr_id);
1743:
1744: ------------------------------------------------------------
1745: l_debug_info := 'Raise hold placed event for: '||l_report_header_id;
1746: fnd_file.put_line(fnd_file.log, l_debug_info);
1747: ------------------------------------------------------------
1748: RaiseHeldEvent(l_report_header_id);
1749:
1750: end if;

Line 1756: fnd_file.put_line(fnd_file.log, l_debug_info);

1752: else
1753:
1754: ------------------------------------------------------------
1755: l_debug_info := 'Mark Ready for Payment';
1756: fnd_file.put_line(fnd_file.log, l_debug_info);
1757: ------------------------------------------------------------
1758:
1759: ------------------------------------------------------------
1760: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;

Line 1761: fnd_file.put_line(fnd_file.log, l_debug_info);

1757: ------------------------------------------------------------
1758:
1759: ------------------------------------------------------------
1760: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;
1761: fnd_file.put_line(fnd_file.log, l_debug_info);
1762: ------------------------------------------------------------
1763: ReadyForPayment(l_report_header_id);
1764:
1765: ------------------------------------------------------------

Line 1772: fnd_file.put_line(fnd_file.log, l_debug_info);

1768: if (l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
1769:
1770: ------------------------------------------------------------
1771: l_debug_info := 'Raise hold released event for: '||l_report_header_id;
1772: fnd_file.put_line(fnd_file.log, l_debug_info);
1773: ------------------------------------------------------------
1774: RaiseReleasedEvent(l_report_header_id);
1775:
1776: end if;

Line 1816: fnd_file.put_line(fnd_file.log, l_debug_info);

1812: BEGIN
1813:
1814: ------------------------------------------------------------
1815: l_debug_info := 'Check if Credit Card Receipts are required for: '||p_report_header_id;
1816: fnd_file.put_line(fnd_file.log, l_debug_info);
1817: ------------------------------------------------------------
1818: select 'Y'
1819: into l_is_cc_receipts_required
1820: from AP_EXPENSE_REPORT_HEADERS aerh

Line 1869: fnd_file.put_line(fnd_file.log, l_debug_info);

1865: BEGIN
1866:
1867: ------------------------------------------------------------
1868: l_debug_info := 'Check if Credit Card Receipts are required for: '||p_report_header_id;
1869: fnd_file.put_line(fnd_file.log, l_debug_info);
1870: ------------------------------------------------------------
1871: select 'Y'
1872: into l_is_cc_receipts_required
1873: from AP_EXPENSE_REPORT_HEADERS aerh

Line 2008: fnd_file.put_line(fnd_file.log, l_debug_info);

2004: BEGIN
2005:
2006: ------------------------------------------------------------
2007: l_debug_info := 'Determine whether to place Holds';
2008: fnd_file.put_line(fnd_file.log, l_debug_info);
2009: ------------------------------------------------------------
2010: open c_hold_bothpay;
2011: loop
2012:

Line 2029: fnd_file.put_line(fnd_file.log, l_debug_info);

2025: nvl(l_image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED) and
2026: l_hold_rct_overdue_bp_cc_code <> C_HOLD_BP_ALWAYS) then
2027: ------------------------------------------------------------
2028: l_debug_info := 'Receipts not required or have been received/waived and not Hold Always';
2029: fnd_file.put_line(fnd_file.log, l_debug_info);
2030: ------------------------------------------------------------
2031:
2032: ------------------------------------------------------------
2033: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;

Line 2034: fnd_file.put_line(fnd_file.log, l_debug_info);

2030: ------------------------------------------------------------
2031:
2032: ------------------------------------------------------------
2033: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
2034: fnd_file.put_line(fnd_file.log, l_debug_info);
2035: ------------------------------------------------------------
2036: ReadyForPayment(l_report_header_id);
2037:
2038: /*elsif (nvl(l_image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED) and

Line 2042: fnd_file.put_line(fnd_file.log, l_debug_info);

2038: /*elsif (nvl(l_image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED) and
2039: l_hold_rct_overdue_bp_cc_code <> C_HOLD_BP_ALWAYS) then
2040: ------------------------------------------------------------
2041: l_debug_info := 'Receipts not required or have been received/waived and not Hold Always';
2042: fnd_file.put_line(fnd_file.log, l_debug_info);
2043: ------------------------------------------------------------
2044:
2045: ------------------------------------------------------------
2046: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;

Line 2047: fnd_file.put_line(fnd_file.log, l_debug_info);

2043: ------------------------------------------------------------
2044:
2045: ------------------------------------------------------------
2046: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
2047: fnd_file.put_line(fnd_file.log, l_debug_info);
2048: ------------------------------------------------------------
2049: ReadyForPayment(l_report_header_id);*/
2050:
2051: elsif (l_hold_rct_overdue_bp_cc_code = C_HOLD_BP_NEVER) then

Line 2054: fnd_file.put_line(fnd_file.log, l_debug_info);

2050:
2051: elsif (l_hold_rct_overdue_bp_cc_code = C_HOLD_BP_NEVER) then
2052: ------------------------------------------------------------
2053: l_debug_info := 'Never Hold BothPay';
2054: fnd_file.put_line(fnd_file.log, l_debug_info);
2055: ------------------------------------------------------------
2056:
2057: ------------------------------------------------------------
2058: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;

Line 2059: fnd_file.put_line(fnd_file.log, l_debug_info);

2055: ------------------------------------------------------------
2056:
2057: ------------------------------------------------------------
2058: l_debug_info := 'Set status Ready for Payment for: '||l_report_header_id;
2059: fnd_file.put_line(fnd_file.log, l_debug_info);
2060: ------------------------------------------------------------
2061: ReadyForPayment(l_report_header_id);
2062:
2063: elsif (l_hold_rct_overdue_bp_cc_code = C_HOLD_BP_REQUIRED) then

Line 2066: fnd_file.put_line(fnd_file.log, l_debug_info);

2062:
2063: elsif (l_hold_rct_overdue_bp_cc_code = C_HOLD_BP_REQUIRED) then
2064: ------------------------------------------------------------
2065: l_debug_info := 'Hold BothPay If Required';
2066: fnd_file.put_line(fnd_file.log, l_debug_info);
2067: ------------------------------------------------------------
2068:
2069: if (IsCCReceiptsRequired(l_bothpay_parent_id) = 'Y' and
2070: nvl(l_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED, AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)) then

Line 2076: fnd_file.put_line(fnd_file.log, l_debug_info);

2072: if (l_expense_status_code <> AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2073:
2074: ------------------------------------------------------------
2075: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to parent report_header_id: '||l_bothpay_parent_id;
2076: fnd_file.put_line(fnd_file.log, l_debug_info);
2077: ------------------------------------------------------------
2078: PlaceHold(l_report_header_id, l_bothpay_parent_id);
2079:
2080: end if;

Line 2089: fnd_file.put_line(fnd_file.log, l_debug_info);

2085: if (l_expense_status_code <> AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2086:
2087: ------------------------------------------------------------
2088: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to parent report_header_id: '||l_bothpay_parent_id;
2089: fnd_file.put_line(fnd_file.log, l_debug_info);
2090: ------------------------------------------------------------
2091: PlaceHold(l_report_header_id, l_bothpay_parent_id);
2092:
2093: end if;

Line 2099: fnd_file.put_line(fnd_file.log, l_debug_info);

2095: else
2096:
2097: ------------------------------------------------------------
2098: l_debug_info := 'Set status Ready for Payment Held for: '||l_report_header_id;
2099: fnd_file.put_line(fnd_file.log, l_debug_info);
2100: ------------------------------------------------------------
2101: ReadyForPayment(l_report_header_id);
2102:
2103: end if; -- Hold BothPay If Required

Line 2108: fnd_file.put_line(fnd_file.log, l_debug_info);

2104:
2105: elsif (l_hold_rct_overdue_bp_cc_code = C_HOLD_BP_ALWAYS) then
2106: ------------------------------------------------------------
2107: l_debug_info := 'Hold BothPay Always';
2108: fnd_file.put_line(fnd_file.log, l_debug_info);
2109: ------------------------------------------------------------
2110:
2111: if (l_parent_status = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2112:

Line 2115: fnd_file.put_line(fnd_file.log, l_debug_info);

2111: if (l_parent_status = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2112:
2113: ------------------------------------------------------------
2114: l_debug_info := 'Set status Payment Held for: '||l_report_header_id||' and set holding_report_header_id to parent report_header_id: '||l_bothpay_parent_id;
2115: fnd_file.put_line(fnd_file.log, l_debug_info);
2116: ------------------------------------------------------------
2117: PlaceHold(l_report_header_id, l_bothpay_parent_id);
2118:
2119: else

Line 2123: fnd_file.put_line(fnd_file.log, l_debug_info);

2119: else
2120:
2121: ------------------------------------------------------------
2122: l_debug_info := 'Set status Ready for Payment Held for: '||l_report_header_id;
2123: fnd_file.put_line(fnd_file.log, l_debug_info);
2124: ------------------------------------------------------------
2125: ReadyForPayment(l_report_header_id);
2126:
2127: end if; -- Hold BothPay Always

Line 2133: fnd_file.put_line(fnd_file.log, l_debug_info);

2129: else
2130:
2131: ------------------------------------------------------------
2132: l_debug_info := 'I do not understand hold scenario: '||l_hold_rct_overdue_bp_cc_code;
2133: fnd_file.put_line(fnd_file.log, l_debug_info);
2134: ------------------------------------------------------------
2135:
2136: end if;
2137:

Line 2267: fnd_file.put_line(fnd_file.log, l_debug_info);

2263: BEGIN
2264:
2265: ------------------------------------------------------------
2266: l_debug_info := 'Obsolete Holds';
2267: fnd_file.put_line(fnd_file.log, l_debug_info);
2268: ------------------------------------------------------------
2269: open c_obsolete_holds;
2270: loop
2271:

Line 2279: fnd_file.put_line(fnd_file.log, l_debug_info);

2275: exit when c_obsolete_holds%NOTFOUND;
2276:
2277: ------------------------------------------------------------
2278: l_debug_info := 'Mark Ready for Payment';
2279: fnd_file.put_line(fnd_file.log, l_debug_info);
2280: ------------------------------------------------------------
2281:
2282: ------------------------------------------------------------
2283: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;

Line 2284: fnd_file.put_line(fnd_file.log, l_debug_info);

2280: ------------------------------------------------------------
2281:
2282: ------------------------------------------------------------
2283: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;
2284: fnd_file.put_line(fnd_file.log, l_debug_info);
2285: ------------------------------------------------------------
2286: ReadyForPayment(l_report_header_id);
2287:
2288: ------------------------------------------------------------

Line 2296: fnd_file.put_line(fnd_file.log, l_debug_info);

2292: l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2293:
2294: ------------------------------------------------------------
2295: l_debug_info := 'Raise hold released event for: '||l_report_header_id;
2296: fnd_file.put_line(fnd_file.log, l_debug_info);
2297: ------------------------------------------------------------
2298: RaiseReleasedEvent(l_report_header_id);
2299:
2300: end if;

Line 2308: fnd_file.put_line(fnd_file.log, l_debug_info);

2304:
2305:
2306: ------------------------------------------------------------
2307: l_debug_info := 'Obsolete Both Pay Holds';
2308: fnd_file.put_line(fnd_file.log, l_debug_info);
2309: ------------------------------------------------------------
2310: open c_obsolete_bothpay_holds;
2311: loop
2312:

Line 2319: fnd_file.put_line(fnd_file.log, l_debug_info);

2315: exit when c_obsolete_bothpay_holds%NOTFOUND;
2316:
2317: ------------------------------------------------------------
2318: l_debug_info := 'Mark Ready for Payment';
2319: fnd_file.put_line(fnd_file.log, l_debug_info);
2320: ------------------------------------------------------------
2321:
2322: ------------------------------------------------------------
2323: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;

Line 2324: fnd_file.put_line(fnd_file.log, l_debug_info);

2320: ------------------------------------------------------------
2321:
2322: ------------------------------------------------------------
2323: l_debug_info := 'Set status Ready for Payment and clear holding_report_header_id for: '||l_report_header_id;
2324: fnd_file.put_line(fnd_file.log, l_debug_info);
2325: ------------------------------------------------------------
2326: ReadyForPayment(l_report_header_id);
2327:
2328: ------------------------------------------------------------

Line 2335: fnd_file.put_line(fnd_file.log, l_debug_info);

2331: if (l_expense_status_code = AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD) then
2332:
2333: ------------------------------------------------------------
2334: l_debug_info := 'Raise hold released event for: '||l_report_header_id;
2335: fnd_file.put_line(fnd_file.log, l_debug_info);
2336: ------------------------------------------------------------
2337: RaiseReleasedEvent(l_report_header_id);
2338:
2339: end if;