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 1837: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);

1833: FROM ap_invoice_distributions_all aid
1834: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
1835: EXCEPTION
1836: WHEN NO_DATA_FOUND THEN
1837: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1) '||l_source_distribution_id_num_1);
1838: END;
1839: ELSIF (l_source_distribution_type IN ('AP_PMT_DIST')) THEN
1840: BEGIN
1841: SELECT aid.invoice_id,

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

1845: FROM ap_invoice_distributions_all aid
1846: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
1847: EXCEPTION
1848: WHEN NO_DATA_FOUND THEN
1849: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1a) '||l_applied_to_dist_id_num_1);
1850: END;
1851:
1852: BEGIN
1853: SELECT aip.check_id,

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

1863: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1864: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1865: EXCEPTION
1866: WHEN NO_DATA_FOUND THEN
1867: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(1b) '||l_source_distribution_id_num_1);
1868: END;
1869:
1870: END IF;
1871: ELSIF (l_source = 'Purchasing' AND l_category = 'Purchases') THEN

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

1882: WHERE pod.po_distribution_id = l_source_distribution_id_num_1
1883: AND pod.po_header_id = poh.po_header_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(2) '||l_source_distribution_id_num_1);
1887: END;
1888: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN
1889: l_reference_1 := 'REQ';
1890: l_reference_3 := l_source_distribution_id_num_1;

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

1911: fv_utility.log_mesg('l_reference_4: '||l_reference_4);
1912:
1913: EXCEPTION
1914: WHEN NO_DATA_FOUND THEN
1915: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(3) '||l_source_distribution_id_num_1);
1916: END;
1917: END IF;
1918: ELSIF (l_source = 'Purchasing' AND l_category = 'Requisitions') THEN
1919: l_reference_1 := 'REQ';

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

1930: AND pol.requisition_header_id = poh.requisition_header_id
1931: AND pod.requisition_line_id = pol.requisition_line_id;
1932: EXCEPTION
1933: WHEN NO_DATA_FOUND THEN
1934: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(4) '||l_source_distribution_id_num_1);
1935: END;
1936: ELSIF (l_source = 'Budgetary Transaction') THEN
1937: IF (l_source_distribution_type ='FV_TREASURY_CONFIRMATIONS_ALL') THEN
1938: l_source := 'Payables';

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

1956: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1957: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1958: EXCEPTION
1959: WHEN NO_DATA_FOUND THEN
1960: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(5) '||l_source_distribution_id_num_1);
1961: END;
1962: ELSE
1963: l_reference_1 := l_source_distribution_id_num_1;
1964: END IF;

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

1976: WHERE pod.po_distribution_id = l_applied_to_dist_id_num_1
1977: AND pod.po_header_id = poh.po_header_id;
1978: EXCEPTION
1979: WHEN NO_DATA_FOUND THEN
1980: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6a) '||l_applied_to_dist_id_num_1);
1981: END;
1982: BEGIN
1983: SELECT rcv_transaction_id
1984: INTO l_reference_5

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

1985: FROM rcv_receiving_sub_ledger
1986: WHERE rcv_sub_ledger_id = l_source_distribution_id_num_1;
1987: EXCEPTION
1988: WHEN NO_DATA_FOUND THEN
1989: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6b) '||l_source_distribution_id_num_1);
1990: END;
1991: ELSIF (l_source = 'Receivables' AND l_category = 'Receipts') THEN
1992: BEGIN
1993: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

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

1989: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(6b) '||l_source_distribution_id_num_1);
1990: END;
1991: ELSIF (l_source = 'Receivables' AND l_category = 'Receipts') THEN
1992: BEGIN
1993: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);
1994: SELECT source_id,
1995: source_table,
1996: source_type
1997: INTO l_ar_source_id,

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

1998: l_ar_source_table,
1999: l_ar_source_type
2000: FROM ar_distributions_all
2001: WHERE line_id = l_source_distribution_id_num_1;
2002: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2003: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2004: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN

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

1999: l_ar_source_type
2000: FROM ar_distributions_all
2001: WHERE line_id = l_source_distribution_id_num_1;
2002: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2003: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2004: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

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

2000: FROM ar_distributions_all
2001: WHERE line_id = l_source_distribution_id_num_1;
2002: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2003: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2004: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2008: END;

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

2003: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2004: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2008: END;
2009: IF (l_ar_source_table = 'RA') THEN
2010: BEGIN
2011: l_reference_2 := l_ar_source_id;

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

2024: AND hcsu.site_use_id = acr.customer_site_use_id
2025: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2026: AND hca.cust_account_id = hcas.cust_account_id;
2027:
2028: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2029: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2030: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2031:
2032: l_reference_5 := l_reference_4;

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

2025: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2026: AND hca.cust_account_id = hcas.cust_account_id;
2027:
2028: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2029: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2030: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2031:
2032: l_reference_5 := l_reference_4;
2033: l_category := 'Trade Receipts';

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

2026: AND hca.cust_account_id = hcas.cust_account_id;
2027:
2028: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2029: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2030: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2031:
2032: l_reference_5 := l_reference_4;
2033: l_category := 'Trade Receipts';
2034: EXCEPTION

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

2032: l_reference_5 := l_reference_4;
2033: l_category := 'Trade Receipts';
2034: EXCEPTION
2035: WHEN NO_DATA_FOUND THEN
2036: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7b) '||l_applied_to_dist_id_num_1);
2037: END;
2038: ELSIF (l_ar_source_table = 'CRH') THEN
2039: l_reference_2 := l_ar_source_id;
2040: BEGIN

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

2053: AND hcsu.site_use_id = acr.customer_site_use_id
2054: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2055: AND hca.cust_account_id = hcas.cust_account_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: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2055: AND hca.cust_account_id = hcas.cust_account_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 hca.cust_account_id = hcas.cust_account_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(7c) '||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(7c) '||l_applied_to_dist_id_num_1);
2066: END;
2067: ELSIF (l_ar_source_table = 'ADJ') THEN
2068: l_reference_2 := l_ar_source_id;
2069: BEGIN

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

2082: AND hcsu.site_use_id = acr.customer_site_use_id
2083: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2084: AND hca.cust_account_id = hcas.cust_account_id;
2085:
2086: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2087: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2088: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2089:
2090: l_reference_5 := l_reference_4;

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

2083: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2084: AND hca.cust_account_id = hcas.cust_account_id;
2085:
2086: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2087: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2088: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2089:
2090: l_reference_5 := l_reference_4;
2091: l_category := 'Trade Receipts';

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

2084: AND hca.cust_account_id = hcas.cust_account_id;
2085:
2086: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2087: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2088: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2089:
2090: l_reference_5 := l_reference_4;
2091: l_category := 'Trade Receipts';
2092: EXCEPTION

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

2090: l_reference_5 := l_reference_4;
2091: l_category := 'Trade Receipts';
2092: EXCEPTION
2093: WHEN NO_DATA_FOUND THEN
2094: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7d) '||l_applied_to_dist_id_num_1);
2095: END;
2096: ELSIF (l_ar_source_table = 'MCD') THEN
2097: l_reference_2 := l_ar_source_id;
2098: BEGIN

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

2111: AND hcsu.site_use_id = acr.customer_site_use_id
2112: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2113: AND hca.cust_account_id = hcas.cust_account_id;
2114:
2115: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2116: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2117: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2118:
2119: l_reference_5 := l_reference_4;

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

2112: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2113: AND hca.cust_account_id = hcas.cust_account_id;
2114:
2115: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2116: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2117: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2118:
2119: l_reference_5 := l_reference_4;
2120: l_category := 'Trade Receipts';

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

2113: AND hca.cust_account_id = hcas.cust_account_id;
2114:
2115: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2116: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2117: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2118:
2119: l_reference_5 := l_reference_4;
2120: l_category := 'Trade Receipts';
2121: EXCEPTION

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

2119: l_reference_5 := l_reference_4;
2120: l_category := 'Trade Receipts';
2121: EXCEPTION
2122: WHEN NO_DATA_FOUND THEN
2123: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);
2124: END;
2125: ELSIF (l_ar_source_table = 'TH') THEN
2126: l_reference_2 := l_ar_source_id;
2127: BEGIN

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

2133: ra_customer_trx_all rcth
2134: WHERE ara.transaction_history_id = l_ar_source_id
2135: AND ara.customer_trx_id = rcth.customer_trx_id;
2136:
2137: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2138: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2139: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2140:
2141: l_reference_5 := l_reference_4;

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

2134: WHERE ara.transaction_history_id = l_ar_source_id
2135: AND ara.customer_trx_id = rcth.customer_trx_id;
2136:
2137: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2138: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2139: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2140:
2141: l_reference_5 := l_reference_4;
2142: l_category := 'Trade Receipts';

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

2135: AND ara.customer_trx_id = rcth.customer_trx_id;
2136:
2137: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2138: --fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2139: --fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2140:
2141: l_reference_5 := l_reference_4;
2142: l_category := 'Trade Receipts';
2143: EXCEPTION

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

2141: l_reference_5 := l_reference_4;
2142: l_category := 'Trade Receipts';
2143: EXCEPTION
2144: WHEN NO_DATA_FOUND THEN
2145: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7f) '||l_applied_to_dist_id_num_1);
2146: END;
2147: END IF;
2148: ELSIF (l_source = 'Receivables' AND
2149: (l_category = 'Sales Invoices' OR

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

2189: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2190: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2191: END IF;
2192:
2193: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2194: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2195: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2196:
2197: l_reference_5 := l_reference_4;

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

2190: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2191: END IF;
2192:
2193: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2194: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2195: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2196:
2197: l_reference_5 := l_reference_4;
2198: EXCEPTION

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

2191: END IF;
2192:
2193: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2194: fnd_file.put_line (fnd_file.log, 'l_reference_7='||l_reference_7);
2195: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2196:
2197: l_reference_5 := l_reference_4;
2198: EXCEPTION
2199: WHEN NO_DATA_FOUND THEN

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

2196:
2197: l_reference_5 := l_reference_4;
2198: EXCEPTION
2199: WHEN NO_DATA_FOUND THEN
2200: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(8a) '||l_source_distribution_id_num_1);
2201: END;
2202: ELSIF (l_source = 'Receivables' AND l_category = 'Misc Receipts') THEN
2203: BEGIN
2204: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);

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

2200: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(8a) '||l_source_distribution_id_num_1);
2201: END;
2202: ELSIF (l_source = 'Receivables' AND l_category = 'Misc Receipts') THEN
2203: BEGIN
2204: fnd_file.put_line (fnd_file.log, 'l_source_distribution_id_num_1='||l_source_distribution_id_num_1);
2205: SELECT source_id,
2206: source_table,
2207: source_type
2208: INTO l_ar_source_id,

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

2209: l_ar_source_table,
2210: l_ar_source_type
2211: FROM ar_distributions_all
2212: WHERE line_id = l_source_distribution_id_num_1;
2213: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2214: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2215: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN

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

2210: l_ar_source_type
2211: FROM ar_distributions_all
2212: WHERE line_id = l_source_distribution_id_num_1;
2213: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2214: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2215: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN
2218: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);

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

2211: FROM ar_distributions_all
2212: WHERE line_id = l_source_distribution_id_num_1;
2213: fnd_file.put_line (fnd_file.log, 'l_ar_source_id='||l_ar_source_id);
2214: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2215: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN
2218: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2219: END;

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

2214: fnd_file.put_line (fnd_file.log, 'l_ar_source_table='||l_ar_source_table);
2215: fnd_file.put_line (fnd_file.log, 'l_ar_source_type='||l_ar_source_type);
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN
2218: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7a) '||l_source_distribution_id_num_1);
2219: END;
2220:
2221: IF (l_ar_source_table = 'MCD' ) THEN
2222: BEGIN

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

2237: AND ara.cash_receipt_id = acr.cash_receipt_id
2238: AND ara.cash_receipt_id = acrh.cash_receipt_id
2239: group by acr.cash_receipt_id, acr.receipt_number;
2240:
2241: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2242: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2243: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2244:
2245: EXCEPTION

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

2238: AND ara.cash_receipt_id = acrh.cash_receipt_id
2239: group by acr.cash_receipt_id, acr.receipt_number;
2240:
2241: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2242: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2243: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2244:
2245: EXCEPTION
2246: WHEN NO_DATA_FOUND THEN

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

2239: group by acr.cash_receipt_id, acr.receipt_number;
2240:
2241: fnd_file.put_line (fnd_file.log, 'l_reference_5='||l_reference_5);
2242: fnd_file.put_line (fnd_file.log, 'l_reference_2='||l_reference_2);
2243: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2244:
2245: EXCEPTION
2246: WHEN NO_DATA_FOUND THEN
2247: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);

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

2243: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);
2244:
2245: EXCEPTION
2246: WHEN NO_DATA_FOUND THEN
2247: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(7e) '||l_applied_to_dist_id_num_1);
2248: END;
2249: END IF;
2250: END IF;
2251: END IF;

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

4050: THEN
4051: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' BUDGETARY TRANSACTION ...');
4053: END IF;
4054: fnd_file.put_line (fnd_file.log, 'Budget p_reference_1 = '||p_reference1);
4055: OPEN Budget_Transac;
4056: FETCH Budget_Transac INTO l_document_num,
4057: l_doc_date,
4058: l_doc_creation_date,

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

4057: l_doc_date,
4058: l_doc_creation_date,
4059: l_doc_created_by;
4060: CLOSE Budget_Transac;
4061: fnd_file.put_line (fnd_file.log, 'Budget l_document_num = '||l_document_num);
4062: p_gl_date := l_doc_date;
4063: -- Code for Manual
4064: ELSIF p_je_source_name = 'Manual'
4065: THEN