APPS.AP_WEB_EXPORT_ER dependencies on FND_FILE

Line 6: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, p_msg);

2: /* $Header: apwexptb.pls 120.74.12020000.5 2013/03/12 10:50:01 dsadipir ship $ */
3:
4: PROCEDURE WriteOutput(p_msg VARCHAR2) IS
5: BEGIN
6: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, p_msg);
7: END WriteOutput;
8:
9: PROCEDURE PrintExportOutput IS
10:

Line 785: fnd_file.put_line(fnd_file.log, 'Exception writing output ' || SQLERRM);

781:
782: WriteOutput('');
783: EXCEPTION
784: WHEN OTHERS THEN
785: fnd_file.put_line(fnd_file.log, 'Exception writing output ' || SQLERRM);
786: END PrintExportOutput;
787:
788: ---------------------------------------------------------------------------------------------------------
789: -- Bug: 11071821, Validate Line and Dist amounts for nulls

Line 805: fnd_file.put_line(fnd_file.log, 'Start ValidateAmounts ');

801:
802: BEGIN
803:
804: IF g_debug_switch = 'Y' THEN
805: fnd_file.put_line(fnd_file.log, 'Start ValidateAmounts ');
806: END IF;
807:
808:
809: SELECT count(*)

Line 816: fnd_file.put_line(fnd_file.log, 'Lines with null amount ' || l_line_count);

812: WHERE report_header_id = p_report_header_id
813: AND amount IS NULL;
814:
815: IF g_debug_switch = 'Y' THEN
816: fnd_file.put_line(fnd_file.log, 'Lines with null amount ' || l_line_count);
817: END IF;
818:
819: SELECT count(*)
820: INTO l_dist_count

Line 826: fnd_file.put_line(fnd_file.log, 'Dists with null amount ' || l_dist_count);

822: WHERE report_header_id = p_report_header_id
823: AND amount IS NULL;
824:
825: IF g_debug_switch = 'Y' THEN
826: fnd_file.put_line(fnd_file.log, 'Dists with null amount ' || l_dist_count);
827: END IF;
828:
829: IF (l_line_count > 0 OR l_dist_count > 0) THEN
830: p_reject_code := 'LINE AMOUNT IS NULL';

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

848: and (web_parameter_id is null or web_parameter_id <> l_parameter_id);
849:
850: l_debug_info := 'Header Total: ' || l_header_total || ', Line Total: ' || l_line_total || ', Dist Total: ' || l_dist_total;
851: IF g_debug_switch = 'Y' THEN
852: fnd_file.put_line(fnd_file.log, l_debug_info);
853: END IF;
854:
855: IF (l_header_total <> l_line_total) THEN
856: p_reject_code := 'EXPENSE HEADER LINE MISMATCH';

Line 865: fnd_file.put_line(fnd_file.log, 'END ValidateAmounts ');

861: END IF;
862:
863:
864: IF g_debug_switch = 'Y' THEN
865: fnd_file.put_line(fnd_file.log, 'END ValidateAmounts ');
866: END IF;
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF g_debug_switch = 'Y' THEN

Line 870: fnd_file.put_line(fnd_file.log, 'Error for the Report#'||to_char(p_report_header_id)||

866: END IF;
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF g_debug_switch = 'Y' THEN
870: fnd_file.put_line(fnd_file.log, 'Error for the Report#'||to_char(p_report_header_id)||
871: ':"'||SQLERRM||'" raised and ignored while validating amounts.');
872:
873: END IF;
874:

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

930: ------------------------------------------------------------
931: l_debug_info := 'Fetching Attachments for Expense Reports...';
932: ------------------------------------------------------------
933: IF g_debug_switch = 'Y' THEN
934: fnd_file.put_line(fnd_file.log, l_debug_info);
935: END IF;
936:
937: FETCH expense_attachments_cur
938: INTO AttachedDocTabRec;

Line 1057: fnd_file.put_line(fnd_file.log, 'Error for the Report#'||to_char(p_report_header_id)||

1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: IF g_debug_switch = 'Y' THEN
1056: --Error raised and ignored while Transferring the attachments.
1057: fnd_file.put_line(fnd_file.log, 'Error for the Report#'||to_char(p_report_header_id)||
1058: ':"'||SQLERRM||'" raised and ignored while Transferring the attachments.');
1059: END IF;
1060: END;
1061:

Line 1114: fnd_file.put_line(fnd_file.log, SQLERRM);

1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: p_reject_code := substr(SQLCODE,1,25);
1113: IF g_debug_switch = 'Y' THEN
1114: fnd_file.put_line(fnd_file.log, SQLERRM);
1115: END IF;
1116: END ValidateAttachCategory;
1117: -----------------------------------------------------------------------------------------------
1118:

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

1137: ------------------------------------------------------------
1138: l_debug_info := 'Validate GL Date with params p_source_date ' || p_source_date || ' , p_valid_inv_gl_date ' || p_valid_inv_gl_date || ' ,p_source_item ' || p_source_item;
1139: ------------------------------------------------------------
1140: IF g_debug_switch = 'Y' THEN
1141: fnd_file.put_line(fnd_file.log, l_debug_info);
1142: END IF;
1143:
1144: BEGIN
1145:

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

1162: ----------------------------------
1163: l_debug_info := p_source_item || ' GL Period status: ' || l_gl_period_status;
1164: ----------------------------------
1165: IF g_debug_switch = 'Y' THEN
1166: fnd_file.put_line(fnd_file.log, l_debug_info);
1167: END IF;
1168:
1169:
1170: IF l_gl_period_status IS NOT NULL AND (l_gl_period_status = 'O' OR l_gl_period_status = 'F') THEN

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

1172: ----------------------------------
1173: l_debug_info := p_source_item || ' GL Date is in Valid Period';
1174: ----------------------------------
1175: IF g_debug_switch = 'Y' THEN
1176: fnd_file.put_line(fnd_file.log, l_debug_info);
1177: END IF;
1178: p_open_gl_date := p_source_date;
1179:
1180: ELSIF l_gl_period_status IS NOT NULL AND l_gl_period_status = 'N' THEN

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

1182: ----------------------------------
1183: l_debug_info := p_source_item || ' GL Date is in Never Opened Period, Rejecting the expense report';
1184: ----------------------------------
1185: IF g_debug_switch = 'Y' THEN
1186: fnd_file.put_line(fnd_file.log, l_debug_info);
1187: END IF;
1188:
1189: p_reject_code := 'GL Date in Closed Period';
1190:

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

1193: ----------------------------------
1194: l_debug_info := p_source_item || ' GL Date is in the closed period or GL period status is null. Getting new GL Date';
1195: ----------------------------------
1196: IF g_debug_switch = 'Y' THEN
1197: fnd_file.put_line(fnd_file.log, l_debug_info);
1198: END IF;
1199:
1200: IF p_valid_inv_gl_date IS NOT NULL THEN
1201: p_open_gl_date := p_valid_inv_gl_date;

Line 1234: fnd_file.put_line(fnd_file.log, SQLERRM);

1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: p_reject_code := substr(SQLCODE,1,25);
1233: IF g_debug_switch = 'Y' THEN
1234: fnd_file.put_line(fnd_file.log, SQLERRM);
1235: END IF;
1236: END ValidateGLDate;
1237:
1238: --------------------------

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

1333: ------------------------------------------------------------
1334: l_debug_info := 'End UpdateDistsWithReceiptInfo';
1335: ------------------------------------------------------------
1336: IF g_debug_switch = 'Y' THEN
1337: fnd_file.put_line(fnd_file.log, l_debug_info);
1338: END IF;
1339:
1340: EXCEPTION
1341: WHEN OTHERS THEN

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

1342: ------------------------------------------------------------
1343: l_debug_info := 'Exception in UpdateDistsWithReceiptInfo' || SQLERRM;
1344: ------------------------------------------------------------
1345: IF g_debug_switch = 'Y' THEN
1346: fnd_file.put_line(fnd_file.log, l_debug_info);
1347: END IF;
1348: END UpdateDistsWithReceiptInfo;
1349:
1350: ------------------------------------------------------------------------

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

1746: ------------------------------------------------------------
1747: l_debug_info := 'Batch Name = ' || l_batch_name;
1748: ------------------------------------------------------------
1749: IF g_debug_switch = 'Y' THEN
1750: fnd_file.put_line(fnd_file.log, l_debug_info);
1751: END IF;
1752:
1753: ------------------------------------------------------------
1754: l_debug_info := 'Begin Receipts Management - Holds';

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

1752:
1753: ------------------------------------------------------------
1754: l_debug_info := 'Begin Receipts Management - Holds';
1755: ------------------------------------------------------------
1756: fnd_file.put_line(fnd_file.log, l_debug_info);
1757:
1758: AP_WEB_HOLDS_WF.ExpenseHolds;
1759:
1760: ------------------------------------------------------------

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

1760: ------------------------------------------------------------
1761: l_debug_info := 'End Receipts Management - Holds';
1762: ------------------------------------------------------------
1763: IF g_debug_switch = 'Y' THEN
1764: fnd_file.put_line(fnd_file.log, l_debug_info);
1765: END IF;
1766:
1767: ------------------------------------------------------------
1768: l_debug_info := 'Begin Processing Individual expense reports';

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

1766:
1767: ------------------------------------------------------------
1768: l_debug_info := 'Begin Processing Individual expense reports';
1769: ------------------------------------------------------------
1770: fnd_file.put_line(fnd_file.log, l_debug_info);
1771:
1772: OPEN c_expenses_to_import(p_source);
1773:
1774: LOOP

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

1775:
1776: ------------------------------------------------------------
1777: l_debug_info := 'Fetching expense report...';
1778: ------------------------------------------------------------
1779: fnd_file.put_line(fnd_file.log, l_debug_info);
1780:
1781: FETCH c_expenses_to_import
1782: INTO l_invoice_rec;
1783:

Line 1798: fnd_file.put_line(fnd_file.log,

1794:
1795: l_expenses_fetched := l_expenses_fetched + 1;
1796: l_reject_code := NULL;
1797:
1798: fnd_file.put_line(fnd_file.log,
1799: 'Expense Report Number : **'||l_invoice_rec.invoice_num||'**');
1800:
1801: --Bug#2823530
1802: l_debug_info := 'Transfer Attachments option(Y/N):'||p_transfer_attachments;

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

1799: 'Expense Report Number : **'||l_invoice_rec.invoice_num||'**');
1800:
1801: --Bug#2823530
1802: l_debug_info := 'Transfer Attachments option(Y/N):'||p_transfer_attachments;
1803: fnd_file.put_line(fnd_file.log, l_debug_info);
1804:
1805: IF p_transfer_attachments = 'Y' THEN
1806: l_debug_info := 'Validating the Attachment Categories';
1807: IF g_debug_switch = 'Y' THEN

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

1804:
1805: IF p_transfer_attachments = 'Y' THEN
1806: l_debug_info := 'Validating the Attachment Categories';
1807: IF g_debug_switch = 'Y' THEN
1808: fnd_file.put_line(fnd_file.log, l_debug_info);
1809: END IF;
1810:
1811: ValidateAttachCategory(l_invoice_rec.report_header_id,l_reject_code);
1812: IF (l_reject_code IS NOT NULL) THEN

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

1815:
1816: END IF;
1817:
1818: l_debug_info := 'Validate Amounts';
1819: fnd_file.put_line(fnd_file.log, l_debug_info);
1820: ValidateAmounts(l_invoice_rec.report_header_id,l_reject_code);
1821: IF (l_reject_code IS NOT NULL) THEN
1822: raise validation_failed;
1823: END IF;

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

1831: ------------------------------------------------------------
1832: l_debug_info := 'Get the system parameters';
1833: ------------------------------------------------------------
1834: IF g_debug_switch = 'Y' THEN
1835: fnd_file.put_line(fnd_file.log, l_debug_info);
1836: END IF;
1837:
1838: OPEN c_system_params(l_org_id);
1839: FETCH c_system_params

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

1856: IF l_employee_terms_id < 0 THEN
1857: ---------------------------------------------------------------------------
1858: l_debug_info := 'employee terms id is < 0 in system parameters. Aborting.';
1859: ---------------------------------------------------------------------------
1860: fnd_file.put_line(fnd_file.log, l_debug_info);
1861:
1862: raise batch_failure;
1863: END IF;
1864:

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

1866: ----------------------------------
1867: l_debug_info := 'Validate Vendor';
1868: ----------------------------------
1869: IF g_debug_switch = 'Y' THEN
1870: fnd_file.put_line(fnd_file.log, l_debug_info);
1871: END IF;
1872:
1873: vendor_valid_flag := AP_WEB_DB_PO_INT_PKG.IsVendorValid(l_invoice_rec.header_vendor_id);
1874:

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

1876: ---------------------------------------------------------------
1877: l_debug_info := 'Inactive vendor *' ||
1878: to_char(l_invoice_rec.header_vendor_id) || '*';
1879: ---------------------------------------------------------------
1880: fnd_file.put_line(fnd_file.log, l_debug_info);
1881:
1882: l_reject_code := 'Inactive vendor';
1883: raise validation_failed;
1884: END IF;

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

1894: -------------------------------------------------------------------
1895: l_debug_info := 'Validate Site if employee is a contingent worker';
1896: -------------------------------------------------------------------
1897: IF g_debug_switch = 'Y' THEN
1898: fnd_file.put_line(fnd_file.log, l_debug_info);
1899: END IF;
1900:
1901: IF l_invoice_rec.header_vendor_site_id is NULL THEN
1902: -------------------------------------

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

1901: IF l_invoice_rec.header_vendor_site_id is NULL THEN
1902: -------------------------------------
1903: l_debug_info := 'NULL vendor site *';
1904: -------------------------------------
1905: fnd_file.put_line(fnd_file.log, l_debug_info);
1906:
1907: l_reject_code := 'Inactive site';
1908: raise validation_failed;
1909: END IF;

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

1917: --------------------------------------------------------------------
1918: l_debug_info := 'Inactive site *' ||
1919: to_char(l_invoice_rec.header_vendor_site_id) || '*';
1920: --------------------------------------------------------------------
1921: fnd_file.put_line(fnd_file.log, l_debug_info);
1922:
1923: l_reject_code := 'Inactive site';
1924: raise validation_failed;
1925: END IF;

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

1927: --------------------------------------------------------------------
1928: l_debug_info := 'Set the description field for a contingent worker';
1929: --------------------------------------------------------------------
1930: IF g_debug_switch = 'Y' THEN
1931: fnd_file.put_line(fnd_file.log, l_debug_info);
1932: END IF;
1933:
1934: FND_MESSAGE.SET_NAME('SQLAP', 'OIE_REMITTANCE_DESC');
1935: FND_MESSAGE.Set_Token('PAID_ON_BEHALF_OF', l_invoice_rec.name);

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

1946: ---------------------------------------------------
1947: l_debug_info := 'Validation for Project Expenses ';
1948: ---------------------------------------------------
1949: IF g_debug_switch = 'Y' THEN
1950: fnd_file.put_line(fnd_file.log, l_debug_info);
1951: END IF;
1952:
1953: IF l_invoice_rec.employee_id = -1 THEN
1954: l_reject_code := 'Invalid employee';

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

1959: --------------------------------------------------------------
1960: l_debug_info := 'Invalid SOB *' ||
1961: to_char(l_invoice_rec.set_of_books_id) || '*';
1962: --------------------------------------------------------------
1963: fnd_file.put_line(fnd_file.log, l_debug_info);
1964:
1965: l_reject_code := 'Invalid set of books';
1966: raise validation_failed;
1967: END IF;

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

1971: -------------------------------------------------
1972: l_debug_info := 'Validate/Set the doc sequence';
1973: -------------------------------------------------
1974: IF g_debug_switch = 'Y' THEN
1975: fnd_file.put_line(fnd_file.log, l_debug_info);
1976: END IF;
1977:
1978: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', l_seq_profile);
1979: -------------------------------------------------

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

1999: ----------------------------------
2000: l_debug_info := 'Set the GL Date';
2001: ----------------------------------
2002: IF g_debug_switch = 'Y' THEN
2003: fnd_file.put_line(fnd_file.log, l_debug_info);
2004: END IF;
2005:
2006: IF l_gl_date_flag IN ('I', 'N') THEN
2007: l_invoice_rec.gl_date := l_invoice_rec.week_end_date;

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

2023: ----------------------------------
2024: l_debug_info := 'Checking GL Period status for the set Invoice GL Date: ' || l_invoice_rec.gl_date;
2025: ----------------------------------
2026: IF g_debug_switch = 'Y' THEN
2027: fnd_file.put_line(fnd_file.log, l_debug_info);
2028: END IF;
2029:
2030: ValidateGLDate(l_invoice_rec.gl_date,
2031: null,

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

2042: -------------------------------------------------------------------
2043: l_debug_info := 'Final Invoice GL Date: ' || l_invoice_rec.gl_date;
2044: -------------------------------------------------------------------
2045: IF g_debug_switch = 'Y' THEN
2046: fnd_file.put_line(fnd_file.log, l_debug_info);
2047: END IF;
2048:
2049: IF (l_invoice_rec.source = 'XpenseXpress') THEN
2050: ----------------------------------

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

2050: ----------------------------------
2051: l_debug_info := 'Checking GL Period status for the set Prepayment GL Date: ' || l_invoice_rec.prepay_gl_date;
2052: ----------------------------------
2053: IF g_debug_switch = 'Y' THEN
2054: fnd_file.put_line(fnd_file.log, l_debug_info);
2055: END IF;
2056:
2057: ValidateGLDate(l_invoice_rec.prepay_gl_date,
2058: l_invoice_rec.gl_date,

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

2069: -----------------------------------------------------------------------------
2070: l_debug_info := 'Final Prepayment GL Date: ' || l_invoice_rec.prepay_gl_date;
2071: -----------------------------------------------------------------------------
2072: IF g_debug_switch = 'Y' THEN
2073: fnd_file.put_line(fnd_file.log, l_debug_info);
2074: END IF;
2075: ELSE -- Bug#7278445 - Prepayment GL Date defaulting is done by AP
2076: -----------------------------------------------------------------------------
2077: l_debug_info := 'As source is not XpenseXpress Resetting Prepay GL date to Null since Prepay GL date defaulting is done by Payables';

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

2076: -----------------------------------------------------------------------------
2077: l_debug_info := 'As source is not XpenseXpress Resetting Prepay GL date to Null since Prepay GL date defaulting is done by Payables';
2078: -----------------------------------------------------------------------------
2079: IF g_debug_switch = 'Y' THEN
2080: fnd_file.put_line(fnd_file.log, l_debug_info);
2081: END IF;
2082: l_invoice_rec.prepay_gl_date := NULL;
2083: END IF;
2084:

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

2085: ----------------------------------------
2086: l_debug_info := 'Set the Exchange Rate';
2087: ----------------------------------------
2088: IF g_debug_switch = 'Y' THEN
2089: fnd_file.put_line(fnd_file.log, l_debug_info);
2090: END IF;
2091:
2092: IF l_base_currency = l_invoice_rec.default_currency_code THEN
2093: l_invoice_rec.default_exchange_rate := -1;

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

2106: ----------------------------------------
2107: l_debug_info := 'Set the Base Amount';
2108: ----------------------------------------
2109: IF g_debug_switch = 'Y' THEN
2110: fnd_file.put_line(fnd_file.log, l_debug_info);
2111: END IF;
2112:
2113: IF l_base_currency = l_invoice_rec.default_currency_code THEN
2114: l_invoice_rec.base_amount := '';

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

2129: ----------------------------------------
2130: l_debug_info := 'Set the Address flag';
2131: ----------------------------------------
2132: IF g_debug_switch = 'Y' THEN
2133: fnd_file.put_line(fnd_file.log, l_debug_info);
2134: END IF;
2135:
2136: --Bug#7207375 - Allow payment of Expense Report to Temporary Address
2137: l_invoice_rec.home_or_office := nvl(l_invoice_rec.home_or_office,l_address_flag);

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

2149: ---------------------------------------
2150: l_debug_info := 'Set the Invoice Type';
2151: ---------------------------------------
2152: IF g_debug_switch = 'Y' THEN
2153: fnd_file.put_line(fnd_file.log, l_debug_info);
2154: END IF;
2155:
2156: IF l_invoice_rec.source not IN
2157: ('XpenseXpress', 'SelfService', 'Both Pay', 'CREDIT CARD',

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

2178: ---------------------------------------------------------------------
2179: l_debug_info := 'Call procedure to query and validate expense lines';
2180: ---------------------------------------------------------------------
2181: IF g_debug_switch = 'Y' THEN
2182: fnd_file.put_line(fnd_file.log, l_debug_info);
2183: END IF;
2184:
2185: SELECT AP_INVOICES_INTERFACE_S.nextval
2186: INTO l_invoice_rec.invoice_id

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

2194: ----------------------------------------------------------------
2195: l_debug_info := 'Get/validate the vendor_id and vendor_site_id';
2196: ----------------------------------------------------------------
2197: IF g_debug_switch = 'Y' THEN
2198: fnd_file.put_line(fnd_file.log, l_debug_info);
2199: END IF;
2200:
2201: l_vendor_rec.vendor_id := l_invoice_rec.vendor_id;
2202: l_vendor_rec.vendor_site_id := l_invoice_rec.header_vendor_site_id;

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

2233: ----------------------------------
2234: l_debug_info := 'Get Vendor Info';
2235: ----------------------------------
2236: IF g_debug_switch = 'Y' THEN
2237: fnd_file.put_line(fnd_file.log, l_debug_info);
2238: END IF;
2239:
2240: IF NOT GetVendorInfo(l_vendor_rec,
2241: l_reject_code) THEN

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

2253: -------------------------------------------
2254: l_debug_info := 'Get the Payment Scenario';
2255: -------------------------------------------
2256: IF g_debug_switch = 'Y' THEN
2257: fnd_file.put_line(fnd_file.log, l_debug_info);
2258: END IF;
2259:
2260: l_payment_due_from := '';
2261:

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

2273: l_debug_info := 'Calling Reversal Logic for payment scenario ' ||
2274: l_payment_due_from;
2275: -----------------------------------------------------------------
2276: IF g_debug_switch = 'Y' THEN
2277: fnd_file.put_line(fnd_file.log, l_debug_info);
2278: END IF;
2279: l_total := AP_CREDIT_CARD_INVOICE_PKG.createCreditCardReversals(l_invoice_rec.invoice_id,
2280: l_invoice_rec.report_header_id,
2281: l_invoice_rec.gl_date,

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

2289: ---------------------------------------------------------
2290: l_debug_info := 'Create the Payee if one does not exist';
2291: ---------------------------------------------------------
2292: IF g_debug_switch = 'Y' THEN
2293: fnd_file.put_line(fnd_file.log, l_debug_info);
2294: END IF;
2295:
2296: IF NOT CreatePayee(l_vendor_rec.party_id,
2297: l_vendor_rec.org_id,

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

2313: ----------------------------------------------------------
2314: l_debug_info := 'Check if the employee is contingent worker';
2315: ----------------------------------------------------------
2316: IF g_debug_switch = 'Y' THEN
2317: fnd_file.put_line(fnd_file.log, l_debug_info);
2318: END IF;
2319:
2320: IF l_invoice_rec.is_contingent = 'N' THEN
2321:

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

2323: l_debug_info := 'Employee is not contingent worker, checking if it is active or not';
2324: ----------------------------------------------------------
2325:
2326: IF g_debug_switch = 'Y' THEN
2327: fnd_file.put_line(fnd_file.log, l_debug_info);
2328: END IF;
2329:
2330: l_is_active_employee := 'N';
2331:

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

2348: l_debug_info := 'Active Employee = ' || l_is_active_employee;
2349: ----------------------------------------------------------
2350:
2351: IF g_debug_switch = 'Y' THEN
2352: fnd_file.put_line(fnd_file.log, l_debug_info);
2353: END IF;
2354:
2355: IF l_is_active_employee = 'N' THEN
2356:

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

2366: l_debug_info := 'Employee is contingent worker';
2367: ----------------------------------------------------------
2368:
2369: IF g_debug_switch = 'Y' THEN
2370: fnd_file.put_line(fnd_file.log, l_debug_info);
2371: END IF;
2372:
2373: END IF;
2374:

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

2376: ----------------------------------------------------------
2377: l_debug_info := 'Check the Default Payment Method';
2378: ----------------------------------------------------------
2379: IF g_debug_switch = 'Y' THEN
2380: fnd_file.put_line(fnd_file.log, l_debug_info);
2381: END IF;
2382:
2383: if (l_invoice_rec.payment_method_code is null) then
2384:

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

2385: ----------------------------------------------------------
2386: l_debug_info := 'Get the Default Payment Method';
2387: ----------------------------------------------------------
2388: IF g_debug_switch = 'Y' THEN
2389: fnd_file.put_line(fnd_file.log, l_debug_info);
2390: END IF;
2391:
2392: l_trx_attributes.application_id := 200;
2393:

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

2394: ----------------------------------------------------------
2395: l_debug_info := 'Getting the legal entity id';
2396: ----------------------------------------------------------
2397: IF g_debug_switch = 'Y' THEN
2398: fnd_file.put_line(fnd_file.log, l_debug_info);
2399: END IF;
2400:
2401:
2402: AP_UTILITIES_PKG.Get_Invoice_LE(

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

2420: ----------------------------------------------------------
2421: l_debug_info := 'Calling iby_disbursement_comp_pub.get_default_payment_attributes';
2422: ----------------------------------------------------------
2423: IF g_debug_switch = 'Y' THEN
2424: fnd_file.put_line(fnd_file.log, l_debug_info);
2425: END IF;
2426:
2427:
2428: iby_disbursement_comp_pub.get_default_payment_attributes(

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

2444: l_debug_info := 'Calling get_default_payment_attributes is failed with result ' || l_return_status;
2445: ----------------------------------------------------------
2446:
2447: IF g_debug_switch = 'Y' THEN
2448: fnd_file.put_line(fnd_file.log, l_debug_info);
2449: END IF;
2450:
2451: END IF;
2452:

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

2455: ----------------------------------------------------------
2456: l_debug_info := 'l_invoice_rec.payment_method_code := '|| l_invoice_rec.payment_method_code;
2457: ----------------------------------------------------------
2458: IF g_debug_switch = 'Y' THEN
2459: fnd_file.put_line(fnd_file.log, l_debug_info);
2460: END IF;
2461:
2462:
2463: ----------------------------------------------------------

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

2464: l_debug_info := 'Check for apply advance default flag := ' || l_invoice_rec.apply_advances_flag;
2465: ----------------------------------------------------------
2466:
2467: IF g_debug_switch = 'Y' THEN
2468: fnd_file.put_line(fnd_file.log, l_debug_info);
2469: END IF;
2470:
2471: -- Bug: 7329159, Donot reset the advances flag for XpenseXpress
2472: IF nvl(l_invoice_rec.advance_invoice_to_apply, -1) = -1 AND

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

2476: l_debug_info := 'Rechecking if apply_advance_flag needs to be reset';
2477: ----------------------------------------------------------
2478:
2479: IF g_debug_switch = 'Y' THEN
2480: fnd_file.put_line(fnd_file.log, l_debug_info);
2481: END IF;
2482:
2483: ----------------------------------------------------------
2484: l_debug_info := 'Apply Advance in Payable options := ' || l_sys_apply_advances_flag;

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

2484: l_debug_info := 'Apply Advance in Payable options := ' || l_sys_apply_advances_flag;
2485: ----------------------------------------------------------
2486:
2487: IF g_debug_switch = 'Y' THEN
2488: fnd_file.put_line(fnd_file.log, l_debug_info);
2489: END IF;
2490:
2491: --------------------------------------------------------------------
2492: l_debug_info := 'Calculate available prepayments for this employee';

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

2492: l_debug_info := 'Calculate available prepayments for this employee';
2493: --------------------------------------------------------------------
2494:
2495: IF g_debug_switch = 'Y' THEN
2496: fnd_file.put_line(fnd_file.log, l_debug_info);
2497: END IF;
2498:
2499: l_available_prepays := 0;
2500: -- Bug#7440653 - Should not apply advances when invoice total is zero.

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

2562: l_debug_info := 'Available Prepayment Sign := ' || l_available_prepays;
2563: ----------------------------------------------------------
2564:
2565: IF g_debug_switch = 'Y' THEN
2566: fnd_file.put_line(fnd_file.log, l_debug_info);
2567: END IF;
2568:
2569:
2570: IF l_invoice_rec.apply_advances_flag = 'Y' AND

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

2575: l_debug_info := 'Resetting the apply advance default to N ';
2576: ----------------------------------------------------------
2577:
2578: IF g_debug_switch = 'Y' THEN
2579: fnd_file.put_line(fnd_file.log, l_debug_info);
2580: END IF;
2581:
2582:
2583: UPDATE ap_expense_report_headers_all

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

2594: l_debug_info := 'Resetting the apply advance default to Y ';
2595: ----------------------------------------------------------
2596:
2597: IF g_debug_switch = 'Y' THEN
2598: fnd_file.put_line(fnd_file.log, l_debug_info);
2599: END IF;
2600:
2601:
2602: UPDATE ap_expense_report_headers_all

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

2614: ----------------------------------------------------------
2615: l_debug_info := 'Insert into AP Invoices Interface table';
2616: ----------------------------------------------------------
2617: IF g_debug_switch = 'Y' THEN
2618: fnd_file.put_line(fnd_file.log, l_debug_info);
2619: END IF;
2620:
2621:
2622: InsertInvoiceInterface(l_invoice_rec, l_vendor_rec);

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

2630: ------------------------------------------------------------
2631: l_debug_info := 'Processing '||l_invoice_rec.source;
2632: ------------------------------------------------------------
2633: IF g_debug_switch = 'Y' THEN
2634: fnd_file.put_line(fnd_file.log, l_debug_info);
2635: END IF;
2636:
2637: ------------------------------------------------------------
2638: l_debug_info := 'Submitting Payment Request';

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

2637: ------------------------------------------------------------
2638: l_debug_info := 'Submitting Payment Request';
2639: ------------------------------------------------------------
2640: IF g_debug_switch = 'Y' THEN
2641: fnd_file.put_line(fnd_file.log, l_debug_info);
2642: END IF;
2643:
2644: l_cc_invoices_fetched := l_cc_invoices_fetched + 1;
2645: l_rows_to_import := l_rows_to_import - 1;

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

2662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2663:
2664: FOR i in l_rejection_list.FIRST .. l_rejection_list.LAST LOOP
2665: l_debug_info := i||' Errors found interfacing data to AP ...';
2666: fnd_file.put_line(fnd_file.log, l_debug_info);
2667: l_debug_info := l_rejection_list(i).reject_lookup_code;
2668: fnd_file.put_line(fnd_file.log, l_debug_info);
2669: l_reject_code := l_rejection_list(i).reject_lookup_code;
2670: END LOOP;

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

2664: FOR i in l_rejection_list.FIRST .. l_rejection_list.LAST LOOP
2665: l_debug_info := i||' Errors found interfacing data to AP ...';
2666: fnd_file.put_line(fnd_file.log, l_debug_info);
2667: l_debug_info := l_rejection_list(i).reject_lookup_code;
2668: fnd_file.put_line(fnd_file.log, l_debug_info);
2669: l_reject_code := l_rejection_list(i).reject_lookup_code;
2670: END LOOP;
2671:
2672: raise validation_failed;

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

2682: ------------------------------------------------------------
2683: l_debug_info := 'Update request_id';
2684: ------------------------------------------------------------
2685: IF g_debug_switch = 'Y' THEN
2686: fnd_file.put_line(fnd_file.log, l_debug_info);
2687: END IF;
2688:
2689: UPDATE ap_expense_report_headers_all
2690: SET request_id = l_request_id,

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

2699: ------------------------------------------------------------
2700: l_debug_info := 'Validation failed';
2701: ------------------------------------------------------------
2702: IF g_debug_switch = 'Y' THEN
2703: fnd_file.put_line(fnd_file.log, l_debug_info);
2704: END IF;
2705:
2706: UPDATE ap_expense_report_headers_all
2707: SET reject_code = l_reject_code,

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

2719:
2720: -------------------------------------------------------------------
2721: l_debug_info := 'Credit Card Expenses Fetched = '|| to_char(l_cc_invoices_fetched);
2722: -------------------------------------------------------------------
2723: fnd_file.put_line(fnd_file.log, l_debug_info);
2724:
2725: -------------------------------------------------------------------
2726: l_debug_info := 'Credit Card Invoices Created = '|| to_char(l_cc_invoices_created);
2727: -------------------------------------------------------------------

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

2724:
2725: -------------------------------------------------------------------
2726: l_debug_info := 'Credit Card Invoices Created = '|| to_char(l_cc_invoices_created);
2727: -------------------------------------------------------------------
2728: fnd_file.put_line(fnd_file.log, l_debug_info);
2729:
2730: CLOSE c_expenses_to_import;
2731:
2732: IF l_rows_to_import = 0 THEN

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

2732: IF l_rows_to_import = 0 THEN
2733: ------------------------------------------
2734: l_debug_info := 'No Rows found to import';
2735: ------------------------------------------
2736: fnd_file.put_line(fnd_file.log, l_debug_info);
2737:
2738: ELSE
2739: -----------------------------------------------
2740: l_debug_info := 'Call Payables Open Interface';

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

2738: ELSE
2739: -----------------------------------------------
2740: l_debug_info := 'Call Payables Open Interface';
2741: -----------------------------------------------
2742: fnd_file.put_line(fnd_file.log, l_debug_info);
2743:
2744: IF (NOT AP_IMPORT_INVOICES_PKG.IMPORT_INVOICES(l_batch_name,
2745: l_invoice_rec.gl_date,
2746: to_char(''),

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

2759: l_calling_sequence)) THEN
2760: -----------------------------------------------------------------------------------
2761: l_debug_info := 'Call to AP_IMPORT_INVOICES_PKG.IMPORT_INVOICES failed. Aborting.';
2762: -----------------------------------------------------------------------------------
2763: fnd_file.put_line(fnd_file.log, l_debug_info);
2764:
2765: RAISE batch_failure;
2766: END IF;
2767:

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

2810:
2811: -----------------------------------------------------------------------
2812: l_debug_info := 'Updated ap_expense_report_headers_all for report_header_id = '||to_char(l_report_header_id_list(i))||' with maximum_amount_to_apply = '||to_char(l_actual_adv_applied);
2813: -----------------------------------------------------------------------
2814: fnd_file.put_line(fnd_file.log, l_debug_info);
2815:
2816: END IF;
2817: END IF;
2818:

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

2852: --Bug#2823530
2853: IF p_transfer_attachments = 'Y' THEN
2854: l_debug_info := 'Transferring the Attachments if any';
2855: IF g_debug_switch = 'Y' THEN
2856: fnd_file.put_line(fnd_file.log, l_debug_info);
2857: END IF;
2858:
2859: TransferAttachments(l_report_header_id_list(i),l_invoice_id_list(i));
2860:

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

2875: l_debug_info := 'Invoices that failed Open Interface *' ||
2876: to_char(l_failed_open_interface) || '*';
2877: -----------------------------------------------------------
2878: IF g_debug_switch = 'Y' THEN
2879: fnd_file.put_line(fnd_file.log, l_debug_info);
2880: END IF;
2881:
2882: OPEN c_rejected_invoices(l_request_id);
2883:

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

2890: l_debug_info := 'Opening cursor for deleting from AP interface tables';
2891: -----------------------------------------------------------------------
2892:
2893: IF g_debug_switch = 'Y' THEN
2894: fnd_file.put_line(fnd_file.log, l_debug_info);
2895: END IF;
2896:
2897: FORALL i IN l_report_header_id_list.FIRST .. l_report_header_id_list.LAST
2898: UPDATE ap_expense_report_headers_all

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

2912: ----------------------------------------------------------
2913: l_debug_info := 'Purge data from the ap interface tables';
2914: ----------------------------------------------------------
2915: IF g_debug_switch = 'Y' THEN
2916: fnd_file.put_line(fnd_file.log, l_debug_info);
2917: END IF;
2918:
2919: IF (NOT AP_IMPORT_INVOICES_PKG.IMPORT_PURGE(p_source,
2920: p_group_id,

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

2924:
2925: ----------------------------------------------------------------------
2926: l_debug_info := 'Purge from the ap interface tables failed. Aborting';
2927: ----------------------------------------------------------------------
2928: fnd_file.put_line(fnd_file.log, l_debug_info);
2929: raise batch_failure;
2930: END IF;
2931:
2932: --Bug#8464009 - Deleting records from Interface tables that are left out by IMPORT_PURGE

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

2959:
2960: -------------------------------------------------------------------
2961: l_debug_info := 'Expenses Fetched = '|| to_char(l_expenses_fetched);
2962: -------------------------------------------------------------------
2963: fnd_file.put_line(fnd_file.log, l_debug_info);
2964:
2965: -------------------------------------------------------------------
2966: l_debug_info := 'Invoices Created = '|| to_char(l_invoices_created);
2967: -------------------------------------------------------------------

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

2964:
2965: -------------------------------------------------------------------
2966: l_debug_info := 'Invoices Created = '|| to_char(l_invoices_created);
2967: -------------------------------------------------------------------
2968: fnd_file.put_line(fnd_file.log, l_debug_info);
2969:
2970: IF (l_expenses_fetched <> l_invoices_created AND
2971: p_role_name IS NOT NULL )THEN
2972:

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

2973: ---------------------------------------------------
2974: l_debug_info := 'Call Expenses Rejection Workflow';
2975: ---------------------------------------------------
2976: IF g_debug_switch = 'Y' THEN
2977: fnd_file.put_line(fnd_file.log, l_debug_info);
2978: END IF;
2979:
2980: AP_WEB_EXPORT_WF.RaiseRejectionEvent(l_request_id,
2981: p_role_name );

Line 2989: fnd_file.put_line(fnd_file.log, sqlerrm);

2985:
2986: PrintExportOutput;
2987: EXCEPTION
2988: WHEN batch_failure THEN
2989: fnd_file.put_line(fnd_file.log, sqlerrm);
2990: rollback;
2991: raise;
2992: WHEN OTHERS THEN
2993: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 2993: fnd_file.put_line(fnd_file.log, sqlerrm);

2989: fnd_file.put_line(fnd_file.log, sqlerrm);
2990: rollback;
2991: raise;
2992: WHEN OTHERS THEN
2993: fnd_file.put_line(fnd_file.log, sqlerrm);
2994: rollback;
2995: raise;
2996:
2997: END ExportERtoAP;

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

3148: ------------------------------------------------
3149: l_debug_info := 'Start Exporting Expense Lines';
3150: ------------------------------------------------
3151: IF g_debug_switch = 'Y' THEN
3152: fnd_file.put_line(fnd_file.log, l_debug_info);
3153: END IF;
3154:
3155: OPEN c_expense_lines(p_report_header_id, p_base_currency);
3156:

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

3165: ---------------------------------------------------------------------------
3166: l_debug_info := 'report_header_id = **'||to_char(p_report_header_id)||'**';
3167: ---------------------------------------------------------------------------
3168: IF g_debug_switch = 'Y' THEN
3169: fnd_file.put_line(fnd_file.log, l_debug_info);
3170: END IF;
3171:
3172: p_invoice_lines_rec_tab(i).invoice_id := p_invoice_id;
3173:

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

3176: ---------------------------------------------
3177: l_debug_info := 'Validate Line Set Of Books';
3178: ---------------------------------------------
3179: IF g_debug_switch = 'Y' THEN
3180: fnd_file.put_line(fnd_file.log, l_debug_info);
3181: END IF;
3182:
3183: IF p_invoice_lines_rec_tab(i).line_set_of_books_id <> p_set_of_books_id THEN
3184: ---------------------------------------------------------------------------------

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

3184: ---------------------------------------------------------------------------------
3185: l_debug_info := 'Invalid set of books-line *' ||
3186: to_char(p_invoice_lines_rec_tab(i) .line_set_of_books_id) || '*';
3187: ---------------------------------------------------------------------------------
3188: fnd_file.put_line(fnd_file.log, l_debug_info);
3189:
3190: p_reject_code := 'Invalid set of books-line';
3191: raise line_validation_failed;
3192: END IF;

Line 3222: fnd_file.put_line(fnd_file.log, SQLERRM);

3218: RETURN(FALSE);
3219: WHEN OTHERS THEN
3220: CLOSE c_expense_lines;
3221: p_reject_code := SQLCODE;
3222: fnd_file.put_line(fnd_file.log, SQLERRM);
3223: RETURN(FALSE);
3224:
3225: END ValidateERLines;
3226:

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

3470: BEGIN
3471:
3472: IF g_debug_switch = 'Y' THEN
3473: l_debug_info := 'Insert into Invoice Lines Interface, p_invoice_id ' || p_invoice_id || ', p_report_header_id ' || p_report_header_id || ', p_transfer_flag ' || p_transfer_flag || ', p_enable_recoverable_flag ' || p_enable_recoverable_flag;
3474: fnd_file.put_line(fnd_file.log, l_debug_info);
3475: END IF;
3476: INSERT INTO AP_INVOICE_LINES_INTERFACE
3477: (INVOICE_ID,
3478: APPLICATION_ID,

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

3693:
3694:
3695: IF g_debug_switch = 'Y' THEN
3696: l_debug_info := 'Done Insert into Invoice Lines Interface';
3697: fnd_file.put_line(fnd_file.log, l_debug_info);
3698: END IF;
3699: END InsertInvoiceLinesInterface;
3700:
3701: PROCEDURE PrintVendorInfo(p_vendor_rec IN VendorInfoRecType) IS

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

3702: l_debug_info VARCHAR2(2000);
3703: BEGIN
3704: IF g_debug_switch = 'Y' THEN
3705: l_debug_info := '>p_vendor_rec.vendor_id := '||p_vendor_rec.vendor_id;
3706: fnd_file.put_line(fnd_file.log, l_debug_info);
3707: l_debug_info := '>p_vendor_rec.vendor_site_id := '||p_vendor_rec.vendor_site_id;
3708: fnd_file.put_line(fnd_file.log, l_debug_info);
3709: l_debug_info := '>p_vendor_rec.home_or_office := '||p_vendor_rec.home_or_office;
3710: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3704: IF g_debug_switch = 'Y' THEN
3705: l_debug_info := '>p_vendor_rec.vendor_id := '||p_vendor_rec.vendor_id;
3706: fnd_file.put_line(fnd_file.log, l_debug_info);
3707: l_debug_info := '>p_vendor_rec.vendor_site_id := '||p_vendor_rec.vendor_site_id;
3708: fnd_file.put_line(fnd_file.log, l_debug_info);
3709: l_debug_info := '>p_vendor_rec.home_or_office := '||p_vendor_rec.home_or_office;
3710: fnd_file.put_line(fnd_file.log, l_debug_info);
3711: l_debug_info := '>p_vendor_rec.employee_id := '||p_vendor_rec.employee_id;
3712: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3706: fnd_file.put_line(fnd_file.log, l_debug_info);
3707: l_debug_info := '>p_vendor_rec.vendor_site_id := '||p_vendor_rec.vendor_site_id;
3708: fnd_file.put_line(fnd_file.log, l_debug_info);
3709: l_debug_info := '>p_vendor_rec.home_or_office := '||p_vendor_rec.home_or_office;
3710: fnd_file.put_line(fnd_file.log, l_debug_info);
3711: l_debug_info := '>p_vendor_rec.employee_id := '||p_vendor_rec.employee_id;
3712: fnd_file.put_line(fnd_file.log, l_debug_info);
3713: l_debug_info := '>p_vendor_rec.vendor_name := '||p_vendor_rec.vendor_name;
3714: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3708: fnd_file.put_line(fnd_file.log, l_debug_info);
3709: l_debug_info := '>p_vendor_rec.home_or_office := '||p_vendor_rec.home_or_office;
3710: fnd_file.put_line(fnd_file.log, l_debug_info);
3711: l_debug_info := '>p_vendor_rec.employee_id := '||p_vendor_rec.employee_id;
3712: fnd_file.put_line(fnd_file.log, l_debug_info);
3713: l_debug_info := '>p_vendor_rec.vendor_name := '||p_vendor_rec.vendor_name;
3714: fnd_file.put_line(fnd_file.log, l_debug_info);
3715: l_debug_info := '>p_vendor_rec.org_id := '||p_vendor_rec.org_id;
3716: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3710: fnd_file.put_line(fnd_file.log, l_debug_info);
3711: l_debug_info := '>p_vendor_rec.employee_id := '||p_vendor_rec.employee_id;
3712: fnd_file.put_line(fnd_file.log, l_debug_info);
3713: l_debug_info := '>p_vendor_rec.vendor_name := '||p_vendor_rec.vendor_name;
3714: fnd_file.put_line(fnd_file.log, l_debug_info);
3715: l_debug_info := '>p_vendor_rec.org_id := '||p_vendor_rec.org_id;
3716: fnd_file.put_line(fnd_file.log, l_debug_info);
3717: l_debug_info := '>p_vendor_rec.address_line_1 := '||p_vendor_rec.address_line_1;
3718: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3712: fnd_file.put_line(fnd_file.log, l_debug_info);
3713: l_debug_info := '>p_vendor_rec.vendor_name := '||p_vendor_rec.vendor_name;
3714: fnd_file.put_line(fnd_file.log, l_debug_info);
3715: l_debug_info := '>p_vendor_rec.org_id := '||p_vendor_rec.org_id;
3716: fnd_file.put_line(fnd_file.log, l_debug_info);
3717: l_debug_info := '>p_vendor_rec.address_line_1 := '||p_vendor_rec.address_line_1;
3718: fnd_file.put_line(fnd_file.log, l_debug_info);
3719: l_debug_info := '>p_vendor_rec.address_line_2 := '||p_vendor_rec.address_line_2;
3720: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3714: fnd_file.put_line(fnd_file.log, l_debug_info);
3715: l_debug_info := '>p_vendor_rec.org_id := '||p_vendor_rec.org_id;
3716: fnd_file.put_line(fnd_file.log, l_debug_info);
3717: l_debug_info := '>p_vendor_rec.address_line_1 := '||p_vendor_rec.address_line_1;
3718: fnd_file.put_line(fnd_file.log, l_debug_info);
3719: l_debug_info := '>p_vendor_rec.address_line_2 := '||p_vendor_rec.address_line_2;
3720: fnd_file.put_line(fnd_file.log, l_debug_info);
3721: l_debug_info := '>p_vendor_rec.address_line_3 := '||p_vendor_rec.address_line_3;
3722: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3716: fnd_file.put_line(fnd_file.log, l_debug_info);
3717: l_debug_info := '>p_vendor_rec.address_line_1 := '||p_vendor_rec.address_line_1;
3718: fnd_file.put_line(fnd_file.log, l_debug_info);
3719: l_debug_info := '>p_vendor_rec.address_line_2 := '||p_vendor_rec.address_line_2;
3720: fnd_file.put_line(fnd_file.log, l_debug_info);
3721: l_debug_info := '>p_vendor_rec.address_line_3 := '||p_vendor_rec.address_line_3;
3722: fnd_file.put_line(fnd_file.log, l_debug_info);
3723: l_debug_info := '>p_vendor_rec.city := '||p_vendor_rec.city;
3724: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3718: fnd_file.put_line(fnd_file.log, l_debug_info);
3719: l_debug_info := '>p_vendor_rec.address_line_2 := '||p_vendor_rec.address_line_2;
3720: fnd_file.put_line(fnd_file.log, l_debug_info);
3721: l_debug_info := '>p_vendor_rec.address_line_3 := '||p_vendor_rec.address_line_3;
3722: fnd_file.put_line(fnd_file.log, l_debug_info);
3723: l_debug_info := '>p_vendor_rec.city := '||p_vendor_rec.city;
3724: fnd_file.put_line(fnd_file.log, l_debug_info);
3725: l_debug_info := '>p_vendor_rec.state := '||p_vendor_rec.state;
3726: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3720: fnd_file.put_line(fnd_file.log, l_debug_info);
3721: l_debug_info := '>p_vendor_rec.address_line_3 := '||p_vendor_rec.address_line_3;
3722: fnd_file.put_line(fnd_file.log, l_debug_info);
3723: l_debug_info := '>p_vendor_rec.city := '||p_vendor_rec.city;
3724: fnd_file.put_line(fnd_file.log, l_debug_info);
3725: l_debug_info := '>p_vendor_rec.state := '||p_vendor_rec.state;
3726: fnd_file.put_line(fnd_file.log, l_debug_info);
3727: l_debug_info := '>p_vendor_rec.postal_code := '||p_vendor_rec.postal_code;
3728: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3722: fnd_file.put_line(fnd_file.log, l_debug_info);
3723: l_debug_info := '>p_vendor_rec.city := '||p_vendor_rec.city;
3724: fnd_file.put_line(fnd_file.log, l_debug_info);
3725: l_debug_info := '>p_vendor_rec.state := '||p_vendor_rec.state;
3726: fnd_file.put_line(fnd_file.log, l_debug_info);
3727: l_debug_info := '>p_vendor_rec.postal_code := '||p_vendor_rec.postal_code;
3728: fnd_file.put_line(fnd_file.log, l_debug_info);
3729: l_debug_info := '>p_vendor_rec.province := '||p_vendor_rec.province;
3730: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3724: fnd_file.put_line(fnd_file.log, l_debug_info);
3725: l_debug_info := '>p_vendor_rec.state := '||p_vendor_rec.state;
3726: fnd_file.put_line(fnd_file.log, l_debug_info);
3727: l_debug_info := '>p_vendor_rec.postal_code := '||p_vendor_rec.postal_code;
3728: fnd_file.put_line(fnd_file.log, l_debug_info);
3729: l_debug_info := '>p_vendor_rec.province := '||p_vendor_rec.province;
3730: fnd_file.put_line(fnd_file.log, l_debug_info);
3731: l_debug_info := '>p_vendor_rec.county := '||p_vendor_rec.county;
3732: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3726: fnd_file.put_line(fnd_file.log, l_debug_info);
3727: l_debug_info := '>p_vendor_rec.postal_code := '||p_vendor_rec.postal_code;
3728: fnd_file.put_line(fnd_file.log, l_debug_info);
3729: l_debug_info := '>p_vendor_rec.province := '||p_vendor_rec.province;
3730: fnd_file.put_line(fnd_file.log, l_debug_info);
3731: l_debug_info := '>p_vendor_rec.county := '||p_vendor_rec.county;
3732: fnd_file.put_line(fnd_file.log, l_debug_info);
3733: l_debug_info := '>p_vendor_rec.country := '||p_vendor_rec.country;
3734: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3728: fnd_file.put_line(fnd_file.log, l_debug_info);
3729: l_debug_info := '>p_vendor_rec.province := '||p_vendor_rec.province;
3730: fnd_file.put_line(fnd_file.log, l_debug_info);
3731: l_debug_info := '>p_vendor_rec.county := '||p_vendor_rec.county;
3732: fnd_file.put_line(fnd_file.log, l_debug_info);
3733: l_debug_info := '>p_vendor_rec.country := '||p_vendor_rec.country;
3734: fnd_file.put_line(fnd_file.log, l_debug_info);
3735: l_debug_info := '>p_vendor_rec.style := '||p_vendor_rec.style;
3736: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3730: fnd_file.put_line(fnd_file.log, l_debug_info);
3731: l_debug_info := '>p_vendor_rec.county := '||p_vendor_rec.county;
3732: fnd_file.put_line(fnd_file.log, l_debug_info);
3733: l_debug_info := '>p_vendor_rec.country := '||p_vendor_rec.country;
3734: fnd_file.put_line(fnd_file.log, l_debug_info);
3735: l_debug_info := '>p_vendor_rec.style := '||p_vendor_rec.style;
3736: fnd_file.put_line(fnd_file.log, l_debug_info);
3737:
3738: l_debug_info := '>p_vendor_rec.pay_group := '||p_vendor_rec.pay_group;

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

3732: fnd_file.put_line(fnd_file.log, l_debug_info);
3733: l_debug_info := '>p_vendor_rec.country := '||p_vendor_rec.country;
3734: fnd_file.put_line(fnd_file.log, l_debug_info);
3735: l_debug_info := '>p_vendor_rec.style := '||p_vendor_rec.style;
3736: fnd_file.put_line(fnd_file.log, l_debug_info);
3737:
3738: l_debug_info := '>p_vendor_rec.pay_group := '||p_vendor_rec.pay_group;
3739: fnd_file.put_line(fnd_file.log, l_debug_info);
3740: l_debug_info := '>p_vendor_rec.terms_date_basis := '||p_vendor_rec.terms_date_basis;

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

3735: l_debug_info := '>p_vendor_rec.style := '||p_vendor_rec.style;
3736: fnd_file.put_line(fnd_file.log, l_debug_info);
3737:
3738: l_debug_info := '>p_vendor_rec.pay_group := '||p_vendor_rec.pay_group;
3739: fnd_file.put_line(fnd_file.log, l_debug_info);
3740: l_debug_info := '>p_vendor_rec.terms_date_basis := '||p_vendor_rec.terms_date_basis;
3741: fnd_file.put_line(fnd_file.log, l_debug_info);
3742: l_debug_info := '>p_vendor_rec.liab_acc := '||p_vendor_rec.liab_acc;
3743: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3737:
3738: l_debug_info := '>p_vendor_rec.pay_group := '||p_vendor_rec.pay_group;
3739: fnd_file.put_line(fnd_file.log, l_debug_info);
3740: l_debug_info := '>p_vendor_rec.terms_date_basis := '||p_vendor_rec.terms_date_basis;
3741: fnd_file.put_line(fnd_file.log, l_debug_info);
3742: l_debug_info := '>p_vendor_rec.liab_acc := '||p_vendor_rec.liab_acc;
3743: fnd_file.put_line(fnd_file.log, l_debug_info);
3744: l_debug_info := '>p_vendor_rec.terms_id := '||p_vendor_rec.terms_id;
3745: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3739: fnd_file.put_line(fnd_file.log, l_debug_info);
3740: l_debug_info := '>p_vendor_rec.terms_date_basis := '||p_vendor_rec.terms_date_basis;
3741: fnd_file.put_line(fnd_file.log, l_debug_info);
3742: l_debug_info := '>p_vendor_rec.liab_acc := '||p_vendor_rec.liab_acc;
3743: fnd_file.put_line(fnd_file.log, l_debug_info);
3744: l_debug_info := '>p_vendor_rec.terms_id := '||p_vendor_rec.terms_id;
3745: fnd_file.put_line(fnd_file.log, l_debug_info);
3746: l_debug_info := '>p_vendor_rec.payment_priority := '||p_vendor_rec.payment_priority;
3747: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3741: fnd_file.put_line(fnd_file.log, l_debug_info);
3742: l_debug_info := '>p_vendor_rec.liab_acc := '||p_vendor_rec.liab_acc;
3743: fnd_file.put_line(fnd_file.log, l_debug_info);
3744: l_debug_info := '>p_vendor_rec.terms_id := '||p_vendor_rec.terms_id;
3745: fnd_file.put_line(fnd_file.log, l_debug_info);
3746: l_debug_info := '>p_vendor_rec.payment_priority := '||p_vendor_rec.payment_priority;
3747: fnd_file.put_line(fnd_file.log, l_debug_info);
3748: l_debug_info := '>p_vendor_rec.prepay_ccid := '||p_vendor_rec.prepay_ccid;
3749: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3743: fnd_file.put_line(fnd_file.log, l_debug_info);
3744: l_debug_info := '>p_vendor_rec.terms_id := '||p_vendor_rec.terms_id;
3745: fnd_file.put_line(fnd_file.log, l_debug_info);
3746: l_debug_info := '>p_vendor_rec.payment_priority := '||p_vendor_rec.payment_priority;
3747: fnd_file.put_line(fnd_file.log, l_debug_info);
3748: l_debug_info := '>p_vendor_rec.prepay_ccid := '||p_vendor_rec.prepay_ccid;
3749: fnd_file.put_line(fnd_file.log, l_debug_info);
3750: l_debug_info := '>p_vendor_rec.always_take_disc_flag := '||p_vendor_rec.always_take_disc_flag;
3751: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3745: fnd_file.put_line(fnd_file.log, l_debug_info);
3746: l_debug_info := '>p_vendor_rec.payment_priority := '||p_vendor_rec.payment_priority;
3747: fnd_file.put_line(fnd_file.log, l_debug_info);
3748: l_debug_info := '>p_vendor_rec.prepay_ccid := '||p_vendor_rec.prepay_ccid;
3749: fnd_file.put_line(fnd_file.log, l_debug_info);
3750: l_debug_info := '>p_vendor_rec.always_take_disc_flag := '||p_vendor_rec.always_take_disc_flag;
3751: fnd_file.put_line(fnd_file.log, l_debug_info);
3752: l_debug_info := '>p_vendor_rec.pay_date_basis := '||p_vendor_rec.pay_date_basis;
3753: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3747: fnd_file.put_line(fnd_file.log, l_debug_info);
3748: l_debug_info := '>p_vendor_rec.prepay_ccid := '||p_vendor_rec.prepay_ccid;
3749: fnd_file.put_line(fnd_file.log, l_debug_info);
3750: l_debug_info := '>p_vendor_rec.always_take_disc_flag := '||p_vendor_rec.always_take_disc_flag;
3751: fnd_file.put_line(fnd_file.log, l_debug_info);
3752: l_debug_info := '>p_vendor_rec.pay_date_basis := '||p_vendor_rec.pay_date_basis;
3753: fnd_file.put_line(fnd_file.log, l_debug_info);
3754: l_debug_info := '>p_vendor_rec.vendor_num := '||p_vendor_rec.vendor_num;
3755: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3749: fnd_file.put_line(fnd_file.log, l_debug_info);
3750: l_debug_info := '>p_vendor_rec.always_take_disc_flag := '||p_vendor_rec.always_take_disc_flag;
3751: fnd_file.put_line(fnd_file.log, l_debug_info);
3752: l_debug_info := '>p_vendor_rec.pay_date_basis := '||p_vendor_rec.pay_date_basis;
3753: fnd_file.put_line(fnd_file.log, l_debug_info);
3754: l_debug_info := '>p_vendor_rec.vendor_num := '||p_vendor_rec.vendor_num;
3755: fnd_file.put_line(fnd_file.log, l_debug_info);
3756: l_debug_info := '>p_vendor_rec.allow_awt_flag := '||p_vendor_rec.allow_awt_flag;
3757: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3751: fnd_file.put_line(fnd_file.log, l_debug_info);
3752: l_debug_info := '>p_vendor_rec.pay_date_basis := '||p_vendor_rec.pay_date_basis;
3753: fnd_file.put_line(fnd_file.log, l_debug_info);
3754: l_debug_info := '>p_vendor_rec.vendor_num := '||p_vendor_rec.vendor_num;
3755: fnd_file.put_line(fnd_file.log, l_debug_info);
3756: l_debug_info := '>p_vendor_rec.allow_awt_flag := '||p_vendor_rec.allow_awt_flag;
3757: fnd_file.put_line(fnd_file.log, l_debug_info);
3758: l_debug_info := '>p_vendor_rec.party_id := '||p_vendor_rec.party_id;
3759: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3753: fnd_file.put_line(fnd_file.log, l_debug_info);
3754: l_debug_info := '>p_vendor_rec.vendor_num := '||p_vendor_rec.vendor_num;
3755: fnd_file.put_line(fnd_file.log, l_debug_info);
3756: l_debug_info := '>p_vendor_rec.allow_awt_flag := '||p_vendor_rec.allow_awt_flag;
3757: fnd_file.put_line(fnd_file.log, l_debug_info);
3758: l_debug_info := '>p_vendor_rec.party_id := '||p_vendor_rec.party_id;
3759: fnd_file.put_line(fnd_file.log, l_debug_info);
3760: END IF;
3761: END PrintVendorInfo;

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

3755: fnd_file.put_line(fnd_file.log, l_debug_info);
3756: l_debug_info := '>p_vendor_rec.allow_awt_flag := '||p_vendor_rec.allow_awt_flag;
3757: fnd_file.put_line(fnd_file.log, l_debug_info);
3758: l_debug_info := '>p_vendor_rec.party_id := '||p_vendor_rec.party_id;
3759: fnd_file.put_line(fnd_file.log, l_debug_info);
3760: END IF;
3761: END PrintVendorInfo;
3762:
3763: PROCEDURE PrintVendorSiteInfo(p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type) IS

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

3764: l_debug_info VARCHAR2(2000);
3765: BEGIN
3766: IF g_debug_switch = 'Y' THEN
3767: l_debug_info := '>p_vendor_site_rec.vendor_id := '||p_vendor_site_rec.vendor_id;
3768: fnd_file.put_line(fnd_file.log, l_debug_info);
3769: l_debug_info := '>p_vendor_site_rec.org_id := '||p_vendor_site_rec.org_id;
3770: fnd_file.put_line(fnd_file.log, l_debug_info);
3771: l_debug_info := '>p_vendor_site_rec.org_name := '||p_vendor_site_rec.org_name;
3772: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3766: IF g_debug_switch = 'Y' THEN
3767: l_debug_info := '>p_vendor_site_rec.vendor_id := '||p_vendor_site_rec.vendor_id;
3768: fnd_file.put_line(fnd_file.log, l_debug_info);
3769: l_debug_info := '>p_vendor_site_rec.org_id := '||p_vendor_site_rec.org_id;
3770: fnd_file.put_line(fnd_file.log, l_debug_info);
3771: l_debug_info := '>p_vendor_site_rec.org_name := '||p_vendor_site_rec.org_name;
3772: fnd_file.put_line(fnd_file.log, l_debug_info);
3773: l_debug_info := '>p_vendor_site_rec.vendor_site_code := '||p_vendor_site_rec.vendor_site_code;
3774: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3768: fnd_file.put_line(fnd_file.log, l_debug_info);
3769: l_debug_info := '>p_vendor_site_rec.org_id := '||p_vendor_site_rec.org_id;
3770: fnd_file.put_line(fnd_file.log, l_debug_info);
3771: l_debug_info := '>p_vendor_site_rec.org_name := '||p_vendor_site_rec.org_name;
3772: fnd_file.put_line(fnd_file.log, l_debug_info);
3773: l_debug_info := '>p_vendor_site_rec.vendor_site_code := '||p_vendor_site_rec.vendor_site_code;
3774: fnd_file.put_line(fnd_file.log, l_debug_info);
3775: l_debug_info := '>p_vendor_site_rec.pay_site_flag := '||p_vendor_site_rec.pay_site_flag;
3776: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3770: fnd_file.put_line(fnd_file.log, l_debug_info);
3771: l_debug_info := '>p_vendor_site_rec.org_name := '||p_vendor_site_rec.org_name;
3772: fnd_file.put_line(fnd_file.log, l_debug_info);
3773: l_debug_info := '>p_vendor_site_rec.vendor_site_code := '||p_vendor_site_rec.vendor_site_code;
3774: fnd_file.put_line(fnd_file.log, l_debug_info);
3775: l_debug_info := '>p_vendor_site_rec.pay_site_flag := '||p_vendor_site_rec.pay_site_flag;
3776: fnd_file.put_line(fnd_file.log, l_debug_info);
3777: l_debug_info := '>p_vendor_site_rec.address_line1 := '||p_vendor_site_rec.address_line1;
3778: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3772: fnd_file.put_line(fnd_file.log, l_debug_info);
3773: l_debug_info := '>p_vendor_site_rec.vendor_site_code := '||p_vendor_site_rec.vendor_site_code;
3774: fnd_file.put_line(fnd_file.log, l_debug_info);
3775: l_debug_info := '>p_vendor_site_rec.pay_site_flag := '||p_vendor_site_rec.pay_site_flag;
3776: fnd_file.put_line(fnd_file.log, l_debug_info);
3777: l_debug_info := '>p_vendor_site_rec.address_line1 := '||p_vendor_site_rec.address_line1;
3778: fnd_file.put_line(fnd_file.log, l_debug_info);
3779: l_debug_info := '>p_vendor_site_rec.address_line2 := '||p_vendor_site_rec.address_line2;
3780: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3774: fnd_file.put_line(fnd_file.log, l_debug_info);
3775: l_debug_info := '>p_vendor_site_rec.pay_site_flag := '||p_vendor_site_rec.pay_site_flag;
3776: fnd_file.put_line(fnd_file.log, l_debug_info);
3777: l_debug_info := '>p_vendor_site_rec.address_line1 := '||p_vendor_site_rec.address_line1;
3778: fnd_file.put_line(fnd_file.log, l_debug_info);
3779: l_debug_info := '>p_vendor_site_rec.address_line2 := '||p_vendor_site_rec.address_line2;
3780: fnd_file.put_line(fnd_file.log, l_debug_info);
3781: l_debug_info := '>p_vendor_site_rec.address_line3 := '||p_vendor_site_rec.address_line3;
3782: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3776: fnd_file.put_line(fnd_file.log, l_debug_info);
3777: l_debug_info := '>p_vendor_site_rec.address_line1 := '||p_vendor_site_rec.address_line1;
3778: fnd_file.put_line(fnd_file.log, l_debug_info);
3779: l_debug_info := '>p_vendor_site_rec.address_line2 := '||p_vendor_site_rec.address_line2;
3780: fnd_file.put_line(fnd_file.log, l_debug_info);
3781: l_debug_info := '>p_vendor_site_rec.address_line3 := '||p_vendor_site_rec.address_line3;
3782: fnd_file.put_line(fnd_file.log, l_debug_info);
3783: l_debug_info := '>p_vendor_site_rec.city := '||p_vendor_site_rec.city;
3784: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3778: fnd_file.put_line(fnd_file.log, l_debug_info);
3779: l_debug_info := '>p_vendor_site_rec.address_line2 := '||p_vendor_site_rec.address_line2;
3780: fnd_file.put_line(fnd_file.log, l_debug_info);
3781: l_debug_info := '>p_vendor_site_rec.address_line3 := '||p_vendor_site_rec.address_line3;
3782: fnd_file.put_line(fnd_file.log, l_debug_info);
3783: l_debug_info := '>p_vendor_site_rec.city := '||p_vendor_site_rec.city;
3784: fnd_file.put_line(fnd_file.log, l_debug_info);
3785: l_debug_info := '>p_vendor_site_rec.state := '||p_vendor_site_rec.state;
3786: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3780: fnd_file.put_line(fnd_file.log, l_debug_info);
3781: l_debug_info := '>p_vendor_site_rec.address_line3 := '||p_vendor_site_rec.address_line3;
3782: fnd_file.put_line(fnd_file.log, l_debug_info);
3783: l_debug_info := '>p_vendor_site_rec.city := '||p_vendor_site_rec.city;
3784: fnd_file.put_line(fnd_file.log, l_debug_info);
3785: l_debug_info := '>p_vendor_site_rec.state := '||p_vendor_site_rec.state;
3786: fnd_file.put_line(fnd_file.log, l_debug_info);
3787: l_debug_info := '>p_vendor_site_rec.zip := '||p_vendor_site_rec.zip;
3788: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3782: fnd_file.put_line(fnd_file.log, l_debug_info);
3783: l_debug_info := '>p_vendor_site_rec.city := '||p_vendor_site_rec.city;
3784: fnd_file.put_line(fnd_file.log, l_debug_info);
3785: l_debug_info := '>p_vendor_site_rec.state := '||p_vendor_site_rec.state;
3786: fnd_file.put_line(fnd_file.log, l_debug_info);
3787: l_debug_info := '>p_vendor_site_rec.zip := '||p_vendor_site_rec.zip;
3788: fnd_file.put_line(fnd_file.log, l_debug_info);
3789: l_debug_info := '>p_vendor_site_rec.province := '||p_vendor_site_rec.province;
3790: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3784: fnd_file.put_line(fnd_file.log, l_debug_info);
3785: l_debug_info := '>p_vendor_site_rec.state := '||p_vendor_site_rec.state;
3786: fnd_file.put_line(fnd_file.log, l_debug_info);
3787: l_debug_info := '>p_vendor_site_rec.zip := '||p_vendor_site_rec.zip;
3788: fnd_file.put_line(fnd_file.log, l_debug_info);
3789: l_debug_info := '>p_vendor_site_rec.province := '||p_vendor_site_rec.province;
3790: fnd_file.put_line(fnd_file.log, l_debug_info);
3791: l_debug_info := '>p_vendor_site_rec.county := '||p_vendor_site_rec.county;
3792: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3786: fnd_file.put_line(fnd_file.log, l_debug_info);
3787: l_debug_info := '>p_vendor_site_rec.zip := '||p_vendor_site_rec.zip;
3788: fnd_file.put_line(fnd_file.log, l_debug_info);
3789: l_debug_info := '>p_vendor_site_rec.province := '||p_vendor_site_rec.province;
3790: fnd_file.put_line(fnd_file.log, l_debug_info);
3791: l_debug_info := '>p_vendor_site_rec.county := '||p_vendor_site_rec.county;
3792: fnd_file.put_line(fnd_file.log, l_debug_info);
3793: l_debug_info := '>p_vendor_site_rec.country := '||p_vendor_site_rec.country;
3794: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3788: fnd_file.put_line(fnd_file.log, l_debug_info);
3789: l_debug_info := '>p_vendor_site_rec.province := '||p_vendor_site_rec.province;
3790: fnd_file.put_line(fnd_file.log, l_debug_info);
3791: l_debug_info := '>p_vendor_site_rec.county := '||p_vendor_site_rec.county;
3792: fnd_file.put_line(fnd_file.log, l_debug_info);
3793: l_debug_info := '>p_vendor_site_rec.country := '||p_vendor_site_rec.country;
3794: fnd_file.put_line(fnd_file.log, l_debug_info);
3795: l_debug_info := '>p_vendor_site_rec.address_style := '||p_vendor_site_rec.address_style;
3796: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3790: fnd_file.put_line(fnd_file.log, l_debug_info);
3791: l_debug_info := '>p_vendor_site_rec.county := '||p_vendor_site_rec.county;
3792: fnd_file.put_line(fnd_file.log, l_debug_info);
3793: l_debug_info := '>p_vendor_site_rec.country := '||p_vendor_site_rec.country;
3794: fnd_file.put_line(fnd_file.log, l_debug_info);
3795: l_debug_info := '>p_vendor_site_rec.address_style := '||p_vendor_site_rec.address_style;
3796: fnd_file.put_line(fnd_file.log, l_debug_info);
3797: END IF;
3798: END PrintVendorSiteInfo;

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

3792: fnd_file.put_line(fnd_file.log, l_debug_info);
3793: l_debug_info := '>p_vendor_site_rec.country := '||p_vendor_site_rec.country;
3794: fnd_file.put_line(fnd_file.log, l_debug_info);
3795: l_debug_info := '>p_vendor_site_rec.address_style := '||p_vendor_site_rec.address_style;
3796: fnd_file.put_line(fnd_file.log, l_debug_info);
3797: END IF;
3798: END PrintVendorSiteInfo;
3799:
3800: ------------------------------------------------------------------------

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

3904: --------------------------------------------------------------
3905: l_debug_info := 'Get Vendor Info when vendor id is not known';
3906: --------------------------------------------------------------
3907: IF g_debug_switch = 'Y' THEN
3908: fnd_file.put_line(fnd_file.log, l_debug_info);
3909: END IF;
3910:
3911: BEGIN
3912: SELECT vendor_id,

Line 3930: fnd_file.put_line(fnd_file.log, 'Employee Id '||p_vendor_rec.employee_id||' is not found');

3926: FROM ap_suppliers
3927: WHERE employee_id = p_vendor_rec.employee_id;
3928: EXCEPTION
3929: WHEN NO_DATA_FOUND THEN
3930: fnd_file.put_line(fnd_file.log, 'Employee Id '||p_vendor_rec.employee_id||' is not found');
3931: l_vendor_id := -1;
3932: WHEN TOO_MANY_ROWS THEN
3933: p_reject_code := 'Create duplicate vendor';
3934: RETURN (FALSE);

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

3935: END;
3936:
3937: IF g_debug_switch = 'Y' THEN
3938: l_debug_info := 'l_vendor_id := '||l_vendor_id;
3939: fnd_file.put_line(fnd_file.log, l_debug_info);
3940: l_debug_info := 'l_duplicate_vendor := '||l_duplicate_vendor;
3941: fnd_file.put_line(fnd_file.log, l_debug_info);
3942: l_debug_info := 'l_party_id := '||l_party_id;
3943: fnd_file.put_line(fnd_file.log, l_debug_info);

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

3937: IF g_debug_switch = 'Y' THEN
3938: l_debug_info := 'l_vendor_id := '||l_vendor_id;
3939: fnd_file.put_line(fnd_file.log, l_debug_info);
3940: l_debug_info := 'l_duplicate_vendor := '||l_duplicate_vendor;
3941: fnd_file.put_line(fnd_file.log, l_debug_info);
3942: l_debug_info := 'l_party_id := '||l_party_id;
3943: fnd_file.put_line(fnd_file.log, l_debug_info);
3944: END IF;
3945:

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

3939: fnd_file.put_line(fnd_file.log, l_debug_info);
3940: l_debug_info := 'l_duplicate_vendor := '||l_duplicate_vendor;
3941: fnd_file.put_line(fnd_file.log, l_debug_info);
3942: l_debug_info := 'l_party_id := '||l_party_id;
3943: fnd_file.put_line(fnd_file.log, l_debug_info);
3944: END IF;
3945:
3946: IF l_duplicate_vendor = 'Y' THEN
3947: p_reject_code := 'Create duplicate vendor';

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

3968: ----------------------------------------------------------
3969: l_debug_info := 'Get Vendor Info when vendor id is known';
3970: ----------------------------------------------------------
3971: IF g_debug_switch = 'Y' THEN
3972: fnd_file.put_line(fnd_file.log, l_debug_info);
3973: END IF;
3974:
3975: l_payment_priority := NULL;
3976:

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

3996: ------------------------------------
3997: l_debug_info := 'Get party_id';
3998: ------------------------------------
3999: IF g_debug_switch = 'Y' THEN
4000: fnd_file.put_line(fnd_file.log, l_debug_info);
4001: END IF;
4002:
4003: OPEN c_party_id(p_vendor_rec.employee_id);
4004: FETCH c_party_id INTO l_vendor_rec.party_id;

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

4007: ------------------------------------
4008: l_debug_info := 'l_vendor_rec.party_id = '||l_vendor_rec.party_id;
4009: ------------------------------------
4010: IF g_debug_switch = 'Y' THEN
4011: fnd_file.put_line(fnd_file.log, l_debug_info);
4012: END IF;
4013: if nvl(l_vendor_rec.party_id, -1) = -1 then
4014: p_reject_code := 'INVALID PARTY';
4015: RETURN (FALSE);

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

4018: ------------------------------------
4019: l_debug_info := 'Checking Automatic Create Employee as Supplier option';
4020: ------------------------------------
4021: IF g_debug_switch = 'Y' THEN
4022: fnd_file.put_line(fnd_file.log, l_debug_info);
4023: END IF;
4024:
4025:
4026: if(nvl(l_create_vendor_flag, 'N') <> 'Y') then

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

4028: ------------------------------------
4029: l_debug_info := 'Automatic Create Employee as Supplier is not checked in Payable Options';
4030: ------------------------------------
4031: IF g_debug_switch = 'Y' THEN
4032: fnd_file.put_line(fnd_file.log, l_debug_info);
4033: END IF;
4034:
4035: p_reject_code := 'Not a vendor';
4036: RETURN (FALSE);

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

4040: ------------------------------------
4041: l_debug_info := 'Checking ap_product_setup.supplier_numbering_method';
4042: ------------------------------------
4043: IF g_debug_switch = 'Y' THEN
4044: fnd_file.put_line(fnd_file.log, l_debug_info);
4045: END IF;
4046:
4047: OPEN c_supplier_numbering_method;
4048: FETCH c_supplier_numbering_method into l_supplier_numbering_method;

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

4053: ------------------------------------
4054: l_debug_info := 'ap_product_setup.supplier_numbering_method is not AUTOMATIC';
4055: ------------------------------------
4056: IF g_debug_switch = 'Y' THEN
4057: fnd_file.put_line(fnd_file.log, l_debug_info);
4058: END IF;
4059:
4060: p_reject_code := 'Create as vendor';
4061: RETURN (FALSE);

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

4064: ------------------------------------
4065: l_debug_info := 'Creating a vendor (AP_VENDOR_PUB_PKG.create_vendor())';
4066: ------------------------------------
4067: IF g_debug_switch = 'Y' THEN
4068: fnd_file.put_line(fnd_file.log, l_debug_info);
4069: END IF;
4070:
4071: l_create_vendor := TRUE;
4072: l_pay_group := p_vendor_rec.pay_group;

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

4098:
4099: IF g_debug_switch = 'Y' THEN
4100:
4101: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4102: fnd_file.put_line(fnd_file.log, l_debug_info);
4103:
4104: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4105: fnd_file.put_line(fnd_file.log, l_debug_info);
4106:

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

4101: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4102: fnd_file.put_line(fnd_file.log, l_debug_info);
4103:
4104: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4105: fnd_file.put_line(fnd_file.log, l_debug_info);
4106:
4107: if (nvl(l_val_msg_count, 0) > 1) then
4108: for i in 1..l_val_msg_count
4109: loop

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

4107: if (nvl(l_val_msg_count, 0) > 1) then
4108: for i in 1..l_val_msg_count
4109: loop
4110: l_debug_info := 'l_val_msg_data('||i||') := '||substrb(substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 255), 1, 30);
4111: fnd_file.put_line(fnd_file.log, l_debug_info);
4112: end loop;
4113: else
4114: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4115: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4111: fnd_file.put_line(fnd_file.log, l_debug_info);
4112: end loop;
4113: else
4114: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4115: fnd_file.put_line(fnd_file.log, l_debug_info);
4116: end if;
4117:
4118: l_debug_info := 'l_vendor_id := '||l_vendor_id;
4119: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4115: fnd_file.put_line(fnd_file.log, l_debug_info);
4116: end if;
4117:
4118: l_debug_info := 'l_vendor_id := '||l_vendor_id;
4119: fnd_file.put_line(fnd_file.log, l_debug_info);
4120: l_debug_info := 'l_party_id := '||l_party_id;
4121: fnd_file.put_line(fnd_file.log, l_debug_info);
4122:
4123: END IF;

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

4117:
4118: l_debug_info := 'l_vendor_id := '||l_vendor_id;
4119: fnd_file.put_line(fnd_file.log, l_debug_info);
4120: l_debug_info := 'l_party_id := '||l_party_id;
4121: fnd_file.put_line(fnd_file.log, l_debug_info);
4122:
4123: END IF;
4124:
4125: IF l_val_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

4148: --------------------------------------------------------------------
4149: l_debug_info := 'Get Vendor Site Info when vendor site id is known';
4150: --------------------------------------------------------------------
4151: IF g_debug_switch = 'Y' THEN
4152: fnd_file.put_line(fnd_file.log, l_debug_info);
4153: END IF;
4154:
4155:
4156: OPEN c_vendor_site_known(p_vendor_rec.vendor_site_id);

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

4169: -------------------------------------------------------------
4170: l_debug_info := 'Get Vendor Site Info for Employee when vendor site id is not known';
4171: -------------------------------------------------------------
4172: IF g_debug_switch = 'Y' THEN
4173: fnd_file.put_line(fnd_file.log, l_debug_info);
4174: END IF;
4175:
4176: OPEN c_vendor_site(p_vendor_rec.vendor_id, p_vendor_rec.home_or_office, p_vendor_rec.org_id);
4177:

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

4193: -----------------------------------------
4194: l_debug_info := 'Creating a vendor site (AP_VENDOR_PUB_PKG.create_vendor_site())';
4195: -----------------------------------------
4196: IF g_debug_switch = 'Y' THEN
4197: fnd_file.put_line(fnd_file.log, l_debug_info);
4198: END IF;
4199:
4200: -- Bug: 13493260, Do not create a site when the the payables option is not set.
4201: if(nvl(l_create_vendor_flag, 'N') <> 'Y') then

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

4203: ------------------------------------
4204: l_debug_info := 'Automatic Create Employee as Supplier is not checked in Payable Options, cannot create site';
4205: ------------------------------------
4206: IF g_debug_switch = 'Y' THEN
4207: fnd_file.put_line(fnd_file.log, l_debug_info);
4208: END IF;
4209:
4210: p_reject_code := 'Invalid vendor site';
4211: RETURN (FALSE);

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

4265:
4266: IF g_debug_switch = 'Y' THEN
4267:
4268: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4269: fnd_file.put_line(fnd_file.log, l_debug_info);
4270:
4271: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4272: fnd_file.put_line(fnd_file.log, l_debug_info);
4273:

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

4268: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4269: fnd_file.put_line(fnd_file.log, l_debug_info);
4270:
4271: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4272: fnd_file.put_line(fnd_file.log, l_debug_info);
4273:
4274: if (nvl(l_val_msg_count, 0) > 1) then
4275: for i in 1..l_val_msg_count
4276: loop

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

4274: if (nvl(l_val_msg_count, 0) > 1) then
4275: for i in 1..l_val_msg_count
4276: loop
4277: l_debug_info := 'l_val_msg_data('||i||') := '||substrb(substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 255), 1, 30);
4278: fnd_file.put_line(fnd_file.log, l_debug_info);
4279: end loop;
4280: else
4281: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4282: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4278: fnd_file.put_line(fnd_file.log, l_debug_info);
4279: end loop;
4280: else
4281: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4282: fnd_file.put_line(fnd_file.log, l_debug_info);
4283: end if;
4284:
4285: l_debug_info := 'l_vendor_site_id := '||l_vendor_site_id;
4286: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4282: fnd_file.put_line(fnd_file.log, l_debug_info);
4283: end if;
4284:
4285: l_debug_info := 'l_vendor_site_id := '||l_vendor_site_id;
4286: fnd_file.put_line(fnd_file.log, l_debug_info);
4287: l_debug_info := 'l_party_site_id := '||l_party_site_id;
4288: fnd_file.put_line(fnd_file.log, l_debug_info);
4289: l_debug_info := 'l_location_id := '||l_location_id;
4290: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4284:
4285: l_debug_info := 'l_vendor_site_id := '||l_vendor_site_id;
4286: fnd_file.put_line(fnd_file.log, l_debug_info);
4287: l_debug_info := 'l_party_site_id := '||l_party_site_id;
4288: fnd_file.put_line(fnd_file.log, l_debug_info);
4289: l_debug_info := 'l_location_id := '||l_location_id;
4290: fnd_file.put_line(fnd_file.log, l_debug_info);
4291: END IF;
4292:

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

4286: fnd_file.put_line(fnd_file.log, l_debug_info);
4287: l_debug_info := 'l_party_site_id := '||l_party_site_id;
4288: fnd_file.put_line(fnd_file.log, l_debug_info);
4289: l_debug_info := 'l_location_id := '||l_location_id;
4290: fnd_file.put_line(fnd_file.log, l_debug_info);
4291: END IF;
4292:
4293:
4294: IF l_val_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

4329: --------------------------------------------------------------------------------
4330: l_debug_info := 'Vendor Site ID got is '|| to_char(p_vendor_rec.vendor_site_id);
4331: --------------------------------------------------------------------------------
4332: IF g_debug_switch = 'Y' THEN
4333: fnd_file.put_line(fnd_file.log, l_debug_info);
4334: END IF;
4335:
4336: if (not l_create_vendor) then
4337: l_vendor_site_rec.vendor_id := p_vendor_rec.vendor_id;

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

4359: -------------------------------------
4360: l_debug_info := 'Update Vendor Site';
4361: -------------------------------------
4362: IF g_debug_switch = 'Y' THEN
4363: fnd_file.put_line(fnd_file.log, l_debug_info);
4364: END IF;
4365:
4366: PrintVendorSiteInfo(l_vendor_site_rec);
4367:

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

4379:
4380: IF g_debug_switch = 'Y' THEN
4381:
4382: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4383: fnd_file.put_line(fnd_file.log, l_debug_info);
4384:
4385: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4386: fnd_file.put_line(fnd_file.log, l_debug_info);
4387:

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

4382: l_debug_info := 'l_val_return_status := '||l_val_return_status;
4383: fnd_file.put_line(fnd_file.log, l_debug_info);
4384:
4385: l_debug_info := 'l_val_msg_count := '||l_val_msg_count;
4386: fnd_file.put_line(fnd_file.log, l_debug_info);
4387:
4388: if (nvl(l_val_msg_count, 0) > 1) then
4389: for i in 1..l_val_msg_count
4390: loop

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

4388: if (nvl(l_val_msg_count, 0) > 1) then
4389: for i in 1..l_val_msg_count
4390: loop
4391: l_debug_info := 'l_val_msg_data('||i||') := '||substrb(substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ), 1, 255), 1, 30);
4392: fnd_file.put_line(fnd_file.log, l_debug_info);
4393: end loop;
4394: else
4395: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4396: fnd_file.put_line(fnd_file.log, l_debug_info);

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

4392: fnd_file.put_line(fnd_file.log, l_debug_info);
4393: end loop;
4394: else
4395: l_debug_info := 'l_val_msg_data := '||l_val_msg_data;
4396: fnd_file.put_line(fnd_file.log, l_debug_info);
4397: end if;
4398:
4399: PrintVendorSiteInfo(l_vendor_site_rec);
4400:

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

4398:
4399: PrintVendorSiteInfo(l_vendor_site_rec);
4400:
4401: l_debug_info := 'l_vendor_site_id := '||l_vendor_site_id;
4402: fnd_file.put_line(fnd_file.log, l_debug_info);
4403: END IF;
4404:
4405: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4406:

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

4472: ------------------------------------------------------------------
4473: l_debug_info := 'Creating a Payee by calling Oracle Payments API';
4474: ------------------------------------------------------------------
4475: IF g_debug_switch = 'Y' THEN
4476: fnd_file.put_line(fnd_file.log, l_debug_info);
4477: END IF;
4478:
4479: l_External_Payee_Tab(0).Payee_Party_Id := p_party_id;
4480: l_External_Payee_Tab(0).Payer_Org_Id := p_org_id;

Line 4495: fnd_file.put_line(fnd_file.log, 'l_return_status: ' || l_return_status);

4491: x_ext_payee_id_tab => l_Ext_Payee_ID_Tab,
4492: x_ext_payee_status_tab => l_Ext_Payee_Create_Tab);
4493:
4494: IF g_debug_switch = 'Y' THEN
4495: fnd_file.put_line(fnd_file.log, 'l_return_status: ' || l_return_status);
4496:
4497: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Status: ' ||
4498: l_Ext_Payee_Create_Tab(0).Payee_Creation_Status);
4499: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Msg: ' ||

Line 4497: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Status: ' ||

4493:
4494: IF g_debug_switch = 'Y' THEN
4495: fnd_file.put_line(fnd_file.log, 'l_return_status: ' || l_return_status);
4496:
4497: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Status: ' ||
4498: l_Ext_Payee_Create_Tab(0).Payee_Creation_Status);
4499: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Msg: ' ||
4500: l_Ext_Payee_Create_Tab(0).Payee_Creation_Msg);
4501: END IF;

Line 4499: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Msg: ' ||

4495: fnd_file.put_line(fnd_file.log, 'l_return_status: ' || l_return_status);
4496:
4497: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Status: ' ||
4498: l_Ext_Payee_Create_Tab(0).Payee_Creation_Status);
4499: fnd_file.put_line(fnd_file.log, 'Payee_Creation_Msg: ' ||
4500: l_Ext_Payee_Create_Tab(0).Payee_Creation_Msg);
4501: END IF;
4502:
4503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN