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.FV_FACTS_TRX_REGISTER dependencies on FND_FILE

Line 1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);

1195: AND gjh.je_from_sla_flag = ''Y''
1196: '|| l_src || l_cat ||
1197: ' ORDER BY fund_value , ' || g_acct_segment_name ;
1198:
1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);
1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);

Line 1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);

1196: '|| l_src || l_cat ||
1197: ' ORDER BY fund_value , ' || g_acct_segment_name ;
1198:
1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);
1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);

Line 1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);

1197: ' ORDER BY fund_value , ' || g_acct_segment_name ;
1198:
1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);
1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');

Line 1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');

1198:
1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);
1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);

Line 1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);

1199: fnd_file.put_line (fnd_file.log, ':sob_id='|| l_sob);
1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);

Line 1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);

1200: fnd_file.put_line (fnd_file.log, ':coa_id='|| l_coa);
1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);

Line 1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');

1201: fnd_file.put_line (fnd_file.log, ':currency_code='|| g_currency_code);
1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);
1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);

Line 1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);

1202: fnd_file.put_line (fnd_file.log, ':actual_flag='|| 'A');
1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);
1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);
1210:

Line 1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);

1203: fnd_file.put_line (fnd_file.log, ':from_posted_date='|| g_from_gl_posted_date);
1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);
1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);
1210:
1211: BEGIN

Line 1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);

1204: fnd_file.put_line (fnd_file.log, ':to_posted_date='|| g_to_gl_posted_date);
1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);
1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);
1210:
1211: BEGIN
1212: l_jrnl_select := l_jrnl_select_gl||' UNION ALL '||l_jrnl_select_xla;

Line 1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);

1205: fnd_file.put_line (fnd_file.log, ':status='|| 'P');
1206: fnd_file.put_line (fnd_file.log, ':period_num_low='|| g_period_num_low);
1207: fnd_file.put_line (fnd_file.log, ':period_num_high='|| g_period_num_high);
1208: fnd_file.put_line (fnd_file.log, ':period_year='|| l_period_year);
1209: fnd_file.put_line (fnd_file.log, ':treasury_symbol_id='|| g_treasury_symbol_id);
1210:
1211: BEGIN
1212: l_jrnl_select := l_jrnl_select_gl||' UNION ALL '||l_jrnl_select_xla;
1213: DBMS_SQL.PARSE(l_jrnl_cursor, l_jrnl_select, DBMS_SQL.V7);

Line 1768: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);

1764: FROM ap_invoice_distributions_all aid
1765: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
1766: EXCEPTION
1767: WHEN NO_DATA_FOUND THEN
1768: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);
1769: END;
1770: ELSIF (l_source_distribution_type IN ('AP_PMT_DIST')) THEN
1771: BEGIN
1772: SELECT aid.invoice_id,

Line 1780: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1a) '||l_applied_to_dist_id_num_1);

1776: FROM ap_invoice_distributions_all aid
1777: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
1778: EXCEPTION
1779: WHEN NO_DATA_FOUND THEN
1780: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1a) '||l_applied_to_dist_id_num_1);
1781: END;
1782:
1783: BEGIN
1784: SELECT aip.check_id,

Line 1798: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1b) '||l_source_distribution_id_num_1);

1794: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1795: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1796: EXCEPTION
1797: WHEN NO_DATA_FOUND THEN
1798: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1b) '||l_source_distribution_id_num_1);
1799: END;
1800:
1801: END IF;
1802: ELSIF (l_source = 'Purchasing' AND l_category = 'Purchases') THEN

Line 1817: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(2) '||l_source_distribution_id_num_1);

1813: WHERE pod.po_distribution_id = l_source_distribution_id_num_1
1814: AND pod.po_header_id = poh.po_header_id;
1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(2) '||l_source_distribution_id_num_1);
1818: END;
1819: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN
1820: l_reference_1 := 'REQ';
1821: l_reference_3 := l_source_distribution_id_num_1;

Line 1835: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(3) '||l_source_distribution_id_num_1);

1831: AND pol.requisition_header_id = poh.requisition_header_id
1832: AND pod.requisition_line_id = pol.requisition_line_id;
1833: EXCEPTION
1834: WHEN NO_DATA_FOUND THEN
1835: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(3) '||l_source_distribution_id_num_1);
1836: END;
1837: END IF;
1838: ELSIF (l_source = 'Purchasing' AND l_category = 'Requisitions') THEN
1839: l_reference_1 := 'REQ';

Line 1854: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(4) '||l_source_distribution_id_num_1);

1850: AND pol.requisition_header_id = poh.requisition_header_id
1851: AND pod.requisition_line_id = pol.requisition_line_id;
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(4) '||l_source_distribution_id_num_1);
1855: END;
1856: ELSIF (l_source = 'Budgetary Transaction') THEN
1857: IF (l_source_distribution_type ='FV_TREASURY_CONFIRMATIONS_ALL') THEN
1858: l_source := 'Payables';

Line 1880: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(5) '||l_source_distribution_id_num_1);

1876: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1877: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1878: EXCEPTION
1879: WHEN NO_DATA_FOUND THEN
1880: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(5) '||l_source_distribution_id_num_1);
1881: END;
1882: ELSE
1883: l_reference_1 := l_source_distribution_id_num_1;
1884: END IF;

Line 1900: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6a) '||l_applied_to_dist_id_num_1);

1896: WHERE pod.po_distribution_id = l_applied_to_dist_id_num_1
1897: AND pod.po_header_id = poh.po_header_id;
1898: EXCEPTION
1899: WHEN NO_DATA_FOUND THEN
1900: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6a) '||l_applied_to_dist_id_num_1);
1901: END;
1902: BEGIN
1903: SELECT rcv_transaction_id
1904: INTO l_reference_5

Line 1909: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6b) '||l_source_distribution_id_num_1);

1905: FROM rcv_receiving_sub_ledger
1906: WHERE rcv_sub_ledger_id = l_source_distribution_id_num_1;
1907: EXCEPTION
1908: WHEN NO_DATA_FOUND THEN
1909: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6b) '||l_source_distribution_id_num_1);
1910: END;
1911: ELSIF (l_source = 'Receivables' AND l_category = 'Receipts') THEN
1912: BEGIN
1913: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

Line 1913: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

1909: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6b) '||l_source_distribution_id_num_1);
1910: END;
1911: ELSIF (l_source = 'Receivables' AND l_category = 'Receipts') THEN
1912: BEGIN
1913: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);
1914: SELECT source_id,
1915: source_table,
1916: source_type
1917: INTO l_ar_source_id,

Line 1922: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);

1918: l_ar_source_table,
1919: l_ar_source_type
1920: FROM ar_distributions_all
1921: WHERE line_id = l_source_distribution_id_num_1;
1922: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
1923: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
1924: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
1925: EXCEPTION
1926: WHEN NO_DATA_FOUND THEN

Line 1923: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);

1919: l_ar_source_type
1920: FROM ar_distributions_all
1921: WHERE line_id = l_source_distribution_id_num_1;
1922: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
1923: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
1924: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
1925: EXCEPTION
1926: WHEN NO_DATA_FOUND THEN
1927: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

Line 1924: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);

1920: FROM ar_distributions_all
1921: WHERE line_id = l_source_distribution_id_num_1;
1922: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
1923: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
1924: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
1925: EXCEPTION
1926: WHEN NO_DATA_FOUND THEN
1927: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
1928: END;

Line 1927: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

1923: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
1924: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
1925: EXCEPTION
1926: WHEN NO_DATA_FOUND THEN
1927: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
1928: END;
1929: IF (l_ar_source_table = 'RA') THEN
1930: BEGIN
1931: l_reference_2 := l_ar_source_id;

Line 1948: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

1944: AND hcsu.site_use_id = acr.customer_site_use_id
1945: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1946: AND hca.cust_account_id = hcas.cust_account_id;
1947:
1948: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1949: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1950: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1951:
1952: l_reference_5 := l_reference_4;

Line 1949: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

1945: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1946: AND hca.cust_account_id = hcas.cust_account_id;
1947:
1948: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1949: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1950: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1951:
1952: l_reference_5 := l_reference_4;
1953: l_category := 'Trade Receipts';

Line 1950: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

1946: AND hca.cust_account_id = hcas.cust_account_id;
1947:
1948: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1949: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1950: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1951:
1952: l_reference_5 := l_reference_4;
1953: l_category := 'Trade Receipts';
1954: EXCEPTION

Line 1956: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7b) '||l_applied_to_dist_id_num_1);

1952: l_reference_5 := l_reference_4;
1953: l_category := 'Trade Receipts';
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7b) '||l_applied_to_dist_id_num_1);
1957: END;
1958: ELSIF (l_ar_source_table = 'CRH') THEN
1959: l_reference_2 := l_ar_source_id;
1960: BEGIN

Line 1977: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

1973: AND hcsu.site_use_id = acr.customer_site_use_id
1974: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1975: AND hca.cust_account_id = hcas.cust_account_id;
1976:
1977: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1978: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1979: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1980:
1981: l_reference_5 := l_reference_4;

Line 1978: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

1974: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1975: AND hca.cust_account_id = hcas.cust_account_id;
1976:
1977: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1978: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1979: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1980:
1981: l_reference_5 := l_reference_4;
1982: l_category := 'Trade Receipts';

Line 1979: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

1975: AND hca.cust_account_id = hcas.cust_account_id;
1976:
1977: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
1978: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
1979: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
1980:
1981: l_reference_5 := l_reference_4;
1982: l_category := 'Trade Receipts';
1983: EXCEPTION

Line 1985: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7c) '||l_applied_to_dist_id_num_1);

1981: l_reference_5 := l_reference_4;
1982: l_category := 'Trade Receipts';
1983: EXCEPTION
1984: WHEN NO_DATA_FOUND THEN
1985: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7c) '||l_applied_to_dist_id_num_1);
1986: END;
1987: ELSIF (l_ar_source_table = 'ADJ') THEN
1988: l_reference_2 := l_ar_source_id;
1989: BEGIN

Line 2006: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

2002: AND hcsu.site_use_id = acr.customer_site_use_id
2003: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2004: AND hca.cust_account_id = hcas.cust_account_id;
2005:
2006: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2007: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2008: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2009:
2010: l_reference_5 := l_reference_4;

Line 2007: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

2003: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2004: AND hca.cust_account_id = hcas.cust_account_id;
2005:
2006: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2007: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2008: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2009:
2010: l_reference_5 := l_reference_4;
2011: l_category := 'Trade Receipts';

Line 2008: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

2004: AND hca.cust_account_id = hcas.cust_account_id;
2005:
2006: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2007: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2008: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2009:
2010: l_reference_5 := l_reference_4;
2011: l_category := 'Trade Receipts';
2012: EXCEPTION

Line 2014: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7d) '||l_applied_to_dist_id_num_1);

2010: l_reference_5 := l_reference_4;
2011: l_category := 'Trade Receipts';
2012: EXCEPTION
2013: WHEN NO_DATA_FOUND THEN
2014: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7d) '||l_applied_to_dist_id_num_1);
2015: END;
2016: ELSIF (l_ar_source_table = 'MCD') THEN
2017: l_reference_2 := l_ar_source_id;
2018: BEGIN

Line 2035: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

2031: AND hcsu.site_use_id = acr.customer_site_use_id
2032: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2033: AND hca.cust_account_id = hcas.cust_account_id;
2034:
2035: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2036: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2037: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2038:
2039: l_reference_5 := l_reference_4;

Line 2036: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

2032: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2033: AND hca.cust_account_id = hcas.cust_account_id;
2034:
2035: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2036: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2037: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2038:
2039: l_reference_5 := l_reference_4;
2040: l_category := 'Trade Receipts';

Line 2037: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

2033: AND hca.cust_account_id = hcas.cust_account_id;
2034:
2035: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2036: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2037: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2038:
2039: l_reference_5 := l_reference_4;
2040: l_category := 'Trade Receipts';
2041: EXCEPTION

Line 2043: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);

2039: l_reference_5 := l_reference_4;
2040: l_category := 'Trade Receipts';
2041: EXCEPTION
2042: WHEN NO_DATA_FOUND THEN
2043: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);
2044: END;
2045: ELSIF (l_ar_source_table = 'TH') THEN
2046: l_reference_2 := l_ar_source_id;
2047: BEGIN

Line 2057: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

2053: ra_customer_trx_all rcth
2054: WHERE ara.transaction_history_id = l_ar_source_id
2055: AND ara.customer_trx_id = rcth.customer_trx_id;
2056:
2057: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2058: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2059: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2060:
2061: l_reference_5 := l_reference_4;

Line 2058: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

2054: WHERE ara.transaction_history_id = l_ar_source_id
2055: AND ara.customer_trx_id = rcth.customer_trx_id;
2056:
2057: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2058: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2059: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2060:
2061: l_reference_5 := l_reference_4;
2062: l_category := 'Trade Receipts';

Line 2059: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

2055: AND ara.customer_trx_id = rcth.customer_trx_id;
2056:
2057: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2058: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2059: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2060:
2061: l_reference_5 := l_reference_4;
2062: l_category := 'Trade Receipts';
2063: EXCEPTION

Line 2065: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7f) '||l_applied_to_dist_id_num_1);

2061: l_reference_5 := l_reference_4;
2062: l_category := 'Trade Receipts';
2063: EXCEPTION
2064: WHEN NO_DATA_FOUND THEN
2065: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7f) '||l_applied_to_dist_id_num_1);
2066: END;
2067: END IF;
2068: ELSIF (l_source = 'Receivables' AND
2069: (l_category = 'Sales Invoices' OR

Line 2113: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

2109: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2110: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2111: END IF;
2112:
2113: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2114: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2115: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2116:
2117: l_reference_5 := l_reference_4;

Line 2114: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);

2110: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2111: END IF;
2112:
2113: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2114: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2115: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2116:
2117: l_reference_5 := l_reference_4;
2118: EXCEPTION

Line 2115: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

2111: END IF;
2112:
2113: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2114: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2115: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2116:
2117: l_reference_5 := l_reference_4;
2118: EXCEPTION
2119: WHEN NO_DATA_FOUND THEN

Line 2120: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(8a) '||l_source_distribution_id_num_1);

2116:
2117: l_reference_5 := l_reference_4;
2118: EXCEPTION
2119: WHEN NO_DATA_FOUND THEN
2120: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(8a) '||l_source_distribution_id_num_1);
2121: END;
2122: ELSIF (l_source = 'Receivables' AND l_category = 'Misc Receipts') THEN
2123: BEGIN
2124: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

Line 2124: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

2120: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(8a) '||l_source_distribution_id_num_1);
2121: END;
2122: ELSIF (l_source = 'Receivables' AND l_category = 'Misc Receipts') THEN
2123: BEGIN
2124: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);
2125: SELECT source_id,
2126: source_table,
2127: source_type
2128: INTO l_ar_source_id,

Line 2133: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);

2129: l_ar_source_table,
2130: l_ar_source_type
2131: FROM ar_distributions_all
2132: WHERE line_id = l_source_distribution_id_num_1;
2133: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2134: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2135: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN

Line 2134: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);

2130: l_ar_source_type
2131: FROM ar_distributions_all
2132: WHERE line_id = l_source_distribution_id_num_1;
2133: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2134: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2135: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN
2138: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

Line 2135: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);

2131: FROM ar_distributions_all
2132: WHERE line_id = l_source_distribution_id_num_1;
2133: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2134: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2135: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN
2138: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2139: END;

Line 2138: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

2134: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2135: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN
2138: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2139: END;
2140:
2141: IF (l_ar_source_table = 'MCD' ) THEN
2142: BEGIN

Line 2156: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);

2152: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2153: AND ara.cash_receipt_id = acr.cash_receipt_id
2154: AND ara.cash_receipt_id = acrh.cash_receipt_id;
2155:
2156: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2157: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2158: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2159:
2160: EXCEPTION

Line 2157: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);

2153: AND ara.cash_receipt_id = acr.cash_receipt_id
2154: AND ara.cash_receipt_id = acrh.cash_receipt_id;
2155:
2156: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2157: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2158: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2159:
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN

Line 2158: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

2154: AND ara.cash_receipt_id = acrh.cash_receipt_id;
2155:
2156: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2157: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2158: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2159:
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);

Line 2162: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);

2158: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2159:
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);
2163: END;
2164: END IF;
2165: END IF;
2166: END IF;

Line 3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');

3140: SELECT trx_date, creation_date, created_by
3141: FROM ra_customer_trx_all
3142: WHERE customer_trx_id = l_refer2;
3143: BEGIN
3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);

Line 3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);

3141: FROM ra_customer_trx_all
3142: WHERE customer_trx_id = l_refer2;
3143: BEGIN
3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);

Line 3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);

3142: WHERE customer_trx_id = l_refer2;
3143: BEGIN
3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);

Line 3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);

3143: BEGIN
3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);

Line 3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);

3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);

Line 3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);

3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);
3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);

Line 3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);

3146: fnd_file.put_line (fnd_file.log, 'p_je_source_name='||p_je_source_name);
3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);

Line 3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);

3147: fnd_file.put_line (fnd_file.log, 'p_je_category_name='||p_je_category_name);
3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);

Line 3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);

3148: fnd_file.put_line (fnd_file.log, 'p_name='||p_name);
3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);

Line 3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);

3149: fnd_file.put_line (fnd_file.log, 'p_date='||p_date);
3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);

Line 3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);

3150: fnd_file.put_line (fnd_file.log, 'p_creation_date='||p_creation_date);
3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);

Line 3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);

3151: fnd_file.put_line (fnd_file.log, 'p_created_by='||p_created_by);
3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);

Line 3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);

3152: fnd_file.put_line (fnd_file.log, 'p_reference1='||p_reference1);
3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);

Line 3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);

3153: fnd_file.put_line (fnd_file.log, 'p_reference2='||p_reference2);
3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);
3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);

Line 3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);

3154: fnd_file.put_line (fnd_file.log, 'p_reference3='||p_reference3);
3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);
3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);
3162:

Line 3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);

3155: fnd_file.put_line (fnd_file.log, 'p_reference4='||p_reference4);
3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);
3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);
3162:
3163:

Line 3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);

3156: fnd_file.put_line (fnd_file.log, 'p_reference5='||p_reference5);
3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);
3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);
3162:
3163:
3164: l_module_name := g_module_name || 'GET_DOC_INFO';

Line 3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);

3157: fnd_file.put_line (fnd_file.log, 'p_reference9='||p_reference9);
3158: fnd_file.put_line (fnd_file.log, 'p_ref2='||p_ref2);
3159: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3160: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code_col='||p_rec_public_law_code_col);
3161: fnd_file.put_line (fnd_file.log, 'p_gl_sl_link_id='||p_gl_sl_link_id);
3162:
3163:
3164: l_module_name := g_module_name || 'GET_DOC_INFO';
3165: l_rev_exists := 'N';

Line 3837: fnd_file.put_line (fnd_file.log, 'Budget p_reference_1 = '||p_reference1);

3833: THEN
3834: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3835: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' BUDGETARY TRANSACTION ...');
3836: END IF;
3837: fnd_file.put_line (fnd_file.log, 'Budget p_reference_1 = '||p_reference1);
3838: OPEN Budget_Transac;
3839: FETCH Budget_Transac INTO l_document_num,
3840: l_doc_date,
3841: l_doc_creation_date,

Line 3844: fnd_file.put_line (fnd_file.log, 'Budget l_document_num = '||l_document_num);

3840: l_doc_date,
3841: l_doc_creation_date,
3842: l_doc_created_by;
3843: CLOSE Budget_Transac;
3844: fnd_file.put_line (fnd_file.log, 'Budget l_document_num = '||l_document_num);
3845: p_gl_date := l_doc_date;
3846: -- Code for Manual
3847: ELSIF p_je_source_name = 'Manual'
3848: THEN

Line 3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');

3908: l_doc_creation_date);
3909: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' DOCUMENT CREATED BY - '||L_DOC_CREATED_BY);
3910: END IF;
3911:
3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');
3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);

Line 3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);

3909: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' DOCUMENT CREATED BY - '||L_DOC_CREATED_BY);
3910: END IF;
3911:
3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');
3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);

Line 3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);

3910: END IF;
3911:
3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');
3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);

Line 3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);

3911:
3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');
3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);

Line 3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);

3912: fnd_file.put_line (fnd_file.log, '<<<<<>>>>>');
3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);
3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');

Line 3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);

3913: fnd_file.put_line (fnd_file.log, 'p_doc_num='||p_doc_num);
3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);
3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');
3921:

Line 3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);

3914: fnd_file.put_line (fnd_file.log, 'p_doc_date='||p_doc_date);
3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);
3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');
3921:
3922:

Line 3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);

3915: fnd_file.put_line (fnd_file.log, 'p_doc_creation_date='||p_doc_creation_date);
3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);
3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');
3921:
3922:
3923: EXCEPTION

Line 3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');

3916: fnd_file.put_line (fnd_file.log, 'p_doc_created_by='||p_doc_created_by);
3917: fnd_file.put_line (fnd_file.log, 'p_gl_date='||p_gl_date);
3918: fnd_file.put_line (fnd_file.log, 'p_rec_public_law_code='||p_rec_public_law_code);
3919: fnd_file.put_line (fnd_file.log, 'p_reversed='||p_reversed);
3920: fnd_file.put_line (fnd_file.log, 'END GET_DOC_INFO');
3921:
3922:
3923: EXCEPTION
3924: WHEN OTHERS THEN