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

Line 1662: fnd_file.put_line(FND_FILE.LOG,' AMOUNT_DUE_ORG_OCM l_amount_due_org'|| l_num_val);

1658:
1659:
1660:
1661: l_num_val := ROUND(nvl(l_amount_due_org,0), 0);
1662: fnd_file.put_line(FND_FILE.LOG,' AMOUNT_DUE_ORG_OCM l_amount_due_org'|| l_num_val);
1663: RETURN l_num_val;
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: RETURN(0);

Line 1715: fnd_file.put_line(FND_FILE.LOG,' GET_ADJ_TOTAL_OCM l_adj_total'|| l_num_val);

1711: END IF;
1712: END IF;
1713:
1714: l_num_val := ROUND(nvl(l_adj_total,0), 2);
1715: fnd_file.put_line(FND_FILE.LOG,' GET_ADJ_TOTAL_OCM l_adj_total'|| l_num_val);
1716: RETURN l_num_val;
1717: EXCEPTION
1718: WHEN OTHERS THEN
1719: RETURN(0);

Line 1805: fnd_file.put_line(FND_FILE.LOG,' COMP_REM_REC_OCM l_amount_due_rem '|| l_num_val);

1801: END IF;
1802: END IF;
1803:
1804: l_num_val := ROUND(nvl(l_amount_due_rem,0), 2);
1805: fnd_file.put_line(FND_FILE.LOG,' COMP_REM_REC_OCM l_amount_due_rem '|| l_num_val);
1806: RETURN l_num_val;
1807:
1808: EXCEPTION
1809: WHEN OTHERS THEN

Line 1962: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_beg_ar '|| p_beg_ar);

1958: p_beg_ar := l_num_val;
1959:
1960: l_num_val := ROUND(l_tot_rec,2);
1961: p_end_ar := l_num_val;
1962: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_beg_ar '|| p_beg_ar);
1963: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_end_ar '|| p_end_ar);
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: p_beg_ar := 0;

Line 1963: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_end_ar '|| p_end_ar);

1959:
1960: l_num_val := ROUND(l_tot_rec,2);
1961: p_end_ar := l_num_val;
1962: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_beg_ar '|| p_beg_ar);
1963: fnd_file.put_line(FND_FILE.LOG,' comp_rem_ar p_end_ar '|| p_end_ar);
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: p_beg_ar := 0;
1967: p_end_ar := 0;

Line 1983: fnd_file.put_line(FND_FILE.LOG,' COMP_TOT_REC_OCM l_tot_sales '|| l_num_val);

1979: into l_tot_sales
1980: from dual;
1981:
1982: l_num_val := ROUND(nvl(l_tot_sales,0), 2);
1983: fnd_file.put_line(FND_FILE.LOG,' COMP_TOT_REC_OCM l_tot_sales '|| l_num_val);
1984: RETURN l_num_val;
1985: EXCEPTION
1986: WHEN OTHERS THEN
1987: RETURN(0);

Line 2094: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Start');

2090: l_invoice_dso number;
2091: l_num_val number;
2092: l_char_val VARCHAR2(100);
2093: begin
2094: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Start');
2095:
2096: -- collect month wise total sales in last year
2097: IF p_party_id IS NOT NULL THEN
2098:

Line 2139: fnd_file.put_line(FND_FILE.LOG,' GET_TRUE_DSO_OCM: Total sales in month '|| j|| ' is ' || l_month_amounts(j).l_amount);

2135: end loop;
2136:
2137: j:= 1;
2138: for j in 1..12 loop
2139: fnd_file.put_line(FND_FILE.LOG,' GET_TRUE_DSO_OCM: Total sales in month '|| j|| ' is ' || l_month_amounts(j).l_amount);
2140: end loop;
2141:
2142: l_dso := 0;
2143: -- Loop throgh all open invoices in last year

Line 2147: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);

2143: -- Loop throgh all open invoices in last year
2144: IF p_party_id IS NOT NULL THEN
2145: for i in c_invoices_party(p_party_id) loop
2146: begin
2147: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2148: k := i.month;
2149: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2150: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2151: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

Line 2149: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);

2145: for i in c_invoices_party(p_party_id) loop
2146: begin
2147: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2148: k := i.month;
2149: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2150: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2151: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2152: -- sum all invoices dso
2153: l_dso := l_dso + l_invoice_dso;

Line 2151: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

2147: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2148: k := i.month;
2149: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2150: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2151: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2152: -- sum all invoices dso
2153: l_dso := l_dso + l_invoice_dso;
2154:
2155: exception

Line 2157: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);

2153: l_dso := l_dso + l_invoice_dso;
2154:
2155: exception
2156: when others then
2157: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);
2158: end;
2159: end loop;
2160: ELSE IF p_cust_account_id IS NOT NULL THEN
2161: for i in c_invoices_acct(p_cust_account_id) loop

Line 2163: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);

2159: end loop;
2160: ELSE IF p_cust_account_id IS NOT NULL THEN
2161: for i in c_invoices_acct(p_cust_account_id) loop
2162: begin
2163: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2164: k := i.month;
2165: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2166: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2167: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

Line 2165: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);

2161: for i in c_invoices_acct(p_cust_account_id) loop
2162: begin
2163: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2164: k := i.month;
2165: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2166: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2167: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2168: -- sum all invoices dso
2169: l_dso := l_dso + l_invoice_dso;

Line 2167: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

2163: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2164: k := i.month;
2165: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2166: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2167: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2168: -- sum all invoices dso
2169: l_dso := l_dso + l_invoice_dso;
2170:
2171: exception

Line 2173: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);

2169: l_dso := l_dso + l_invoice_dso;
2170:
2171: exception
2172: when others then
2173: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);
2174: end;
2175: end loop;
2176: ELSE IF p_customer_site_use_id IS NOT NULL THEN
2177: for i in c_invoices_site(p_customer_site_use_id) loop

Line 2179: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);

2175: end loop;
2176: ELSE IF p_customer_site_use_id IS NOT NULL THEN
2177: for i in c_invoices_site(p_customer_site_use_id) loop
2178: begin
2179: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2180: k := i.month;
2181: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2182: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2183: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

Line 2181: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);

2177: for i in c_invoices_site(p_customer_site_use_id) loop
2178: begin
2179: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2180: k := i.month;
2181: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2182: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2183: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2184: -- sum all invoices dso
2185: l_dso := l_dso + l_invoice_dso;

Line 2183: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);

2179: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Month of the Invoice ' || i.month);
2180: k := i.month;
2181: fnd_file.put_line(FND_FILE.LOG,k|| 'GET_TRUE_DSO_OCM month sales'||l_month_amounts(k).l_amount);
2182: l_invoice_dso := i.amount/l_month_amounts(i.month).l_amount;
2183: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: DSO of the invoice '||i.payment_schedule_id || ' is '|| l_invoice_dso);
2184: -- sum all invoices dso
2185: l_dso := l_dso + l_invoice_dso;
2186:
2187: exception

Line 2189: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);

2185: l_dso := l_dso + l_invoice_dso;
2186:
2187: exception
2188: when others then
2189: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in calculating True DSO of invoice '|| i.payment_schedule_id || sqlerrm);
2190: end;
2191: end loop;
2192: END IF;
2193: END IF;

Line 2198: fnd_file.put_line(fnd_file.LOG,'GET_TRUE_DSO_OCM: True DSO '|| l_char_val);

2194:
2195: END IF;
2196: l_num_val := ROUND(NVL(l_dso,0),2);
2197: l_char_val := RTRIM(TO_CHAR(l_num_val));
2198: fnd_file.put_line(fnd_file.LOG,'GET_TRUE_DSO_OCM: True DSO '|| l_char_val);
2199: RETURN l_char_val;
2200: exception
2201: when others then
2202: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in True DSO '|| sqlerrm);

Line 2202: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in True DSO '|| sqlerrm);

2198: fnd_file.put_line(fnd_file.LOG,'GET_TRUE_DSO_OCM: True DSO '|| l_char_val);
2199: RETURN l_char_val;
2200: exception
2201: when others then
2202: fnd_file.put_line(FND_FILE.LOG,'GET_TRUE_DSO_OCM: Exception in True DSO '|| sqlerrm);
2203: end;
2204:
2205:
2206: FUNCTION get_conv_dso_ocm(p_party_id number,p_cust_account_id number,p_customer_site_use_id number) RETURN VARCHAR2 IS

Line 2214: --fnd_file.put_line(FND_FILE.LOG,'get_conv_dso_ocm: Start');

2210: l_num_val number;
2211: l_char_val VARCHAR2(1000);
2212: l_dso_days number;
2213: BEGIN
2214: --fnd_file.put_line(FND_FILE.LOG,'get_conv_dso_ocm: Start');
2215:
2216: IF p_party_id IS NOT NULL THEN
2217: select (sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2218: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_invoices_value),0)+

Line 2275: fnd_file.put_line(FND_FILE.LOG, 'GET_CONV_DSO_OCM :l_op_bal '|| l_op_bal);

2271: END IF;
2272: END IF;
2273: END IF;
2274:
2275: fnd_file.put_line(FND_FILE.LOG, 'GET_CONV_DSO_OCM :l_op_bal '|| l_op_bal);
2276:
2277: IF p_party_id IS NOT NULL THEN
2278: SELECT SUM(NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2279: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_invoices_value),0) +

Line 2342: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_tot_bal '||l_tot_bal);

2338:
2339:
2340: SELECT cer_dso_days INTO l_dso_days FROM ar_system_parameters;
2341:
2342: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_tot_bal '||l_tot_bal);
2343: l_conv_dso := l_op_bal/l_tot_bal*l_dso_days;
2344: --fnd_file.put_line(FND_FILE.LOG,'l_conv_dso '||l_conv_dso);
2345: l_num_val := ROUND(nvl(l_conv_dso,0), 2);
2346: l_char_val := RTRIM(TO_CHAR(l_num_val));

Line 2344: --fnd_file.put_line(FND_FILE.LOG,'l_conv_dso '||l_conv_dso);

2340: SELECT cer_dso_days INTO l_dso_days FROM ar_system_parameters;
2341:
2342: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_tot_bal '||l_tot_bal);
2343: l_conv_dso := l_op_bal/l_tot_bal*l_dso_days;
2344: --fnd_file.put_line(FND_FILE.LOG,'l_conv_dso '||l_conv_dso);
2345: l_num_val := ROUND(nvl(l_conv_dso,0), 2);
2346: l_char_val := RTRIM(TO_CHAR(l_num_val));
2347:
2348: -- fnd_file.put_line(FND_FILE.LOG, 'CUST_ACCOUNT_ID ' || p_cust_account_id);

Line 2348: -- fnd_file.put_line(FND_FILE.LOG, 'CUST_ACCOUNT_ID ' || p_cust_account_id);

2344: --fnd_file.put_line(FND_FILE.LOG,'l_conv_dso '||l_conv_dso);
2345: l_num_val := ROUND(nvl(l_conv_dso,0), 2);
2346: l_char_val := RTRIM(TO_CHAR(l_num_val));
2347:
2348: -- fnd_file.put_line(FND_FILE.LOG, 'CUST_ACCOUNT_ID ' || p_cust_account_id);
2349: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_conv_dso '|| l_char_val);
2350: RETURN l_char_val;
2351: EXCEPTION
2352: WHEN OTHERS THEN

Line 2349: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_conv_dso '|| l_char_val);

2345: l_num_val := ROUND(nvl(l_conv_dso,0), 2);
2346: l_char_val := RTRIM(TO_CHAR(l_num_val));
2347:
2348: -- fnd_file.put_line(FND_FILE.LOG, 'CUST_ACCOUNT_ID ' || p_cust_account_id);
2349: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_conv_dso '|| l_char_val);
2350: RETURN l_char_val;
2351: EXCEPTION
2352: WHEN OTHERS THEN
2353: RETURN(0);

Line 2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);

2380: -- l_end_ar := COMP_REM_REC_ocm(p_party_id, p_cust_account_id, p_customer_site_use_id,to_date('01/01/1952','MM/DD/YYYY'), TRUNC(sysdate));
2381: comp_rem_ar(p_party_id, p_cust_account_id, p_customer_site_use_id,l_beg_ar,l_end_ar);
2382: l_curr_ar := comp_curr_rec(to_date('01/01/1952','MM/DD/YYYY'), TRUNC(sysdate),p_party_id, p_cust_account_id, p_customer_site_use_id);
2383:
2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);
2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);
2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);
2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);
2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);

Line 2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);

2381: comp_rem_ar(p_party_id, p_cust_account_id, p_customer_site_use_id,l_beg_ar,l_end_ar);
2382: l_curr_ar := comp_curr_rec(to_date('01/01/1952','MM/DD/YYYY'), TRUNC(sysdate),p_party_id, p_cust_account_id, p_customer_site_use_id);
2383:
2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);
2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);
2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);
2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);
2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);
2389:

Line 2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);

2382: l_curr_ar := comp_curr_rec(to_date('01/01/1952','MM/DD/YYYY'), TRUNC(sysdate),p_party_id, p_cust_account_id, p_customer_site_use_id);
2383:
2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);
2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);
2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);
2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);
2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);
2389:
2390: l_cei := (l_beg_ar + (l_sales / 12) - l_end_ar) * 100 / (l_beg_ar + (l_sales / 12) - l_curr_ar);

Line 2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);

2383:
2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);
2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);
2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);
2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);
2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);
2389:
2390: l_cei := (l_beg_ar + (l_sales / 12) - l_end_ar) * 100 / (l_beg_ar + (l_sales / 12) - l_curr_ar);
2391:

Line 2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);

2384: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_sales ' || l_sales);
2385: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_beg_ar ' || l_beg_ar);
2386: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_end_ar ' || l_end_ar);
2387: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_curr_ar ' || l_curr_ar);
2388: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_cei);
2389:
2390: l_cei := (l_beg_ar + (l_sales / 12) - l_end_ar) * 100 / (l_beg_ar + (l_sales / 12) - l_curr_ar);
2391:
2392: l_num_val := ROUND(TRUNC(NVL(l_cei, 0)));

Line 2394: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_char_val);

2390: l_cei := (l_beg_ar + (l_sales / 12) - l_end_ar) * 100 / (l_beg_ar + (l_sales / 12) - l_curr_ar);
2391:
2392: l_num_val := ROUND(TRUNC(NVL(l_cei, 0)));
2393: l_char_val := RTRIM(TO_CHAR(l_num_val));
2394: fnd_file.put_line(FND_FILE.LOG, 'GET_CEI_OCM l_cei ' || l_char_val);
2395: RETURN l_char_val;
2396:
2397: EXCEPTION
2398: WHEN NO_DATA_FOUND THEN

Line 2413: fnd_file.put_line(FND_FILE.LOG, 'get_sales_ocm l_sales ' || l_char_val);

2409: l_sales := COMP_TOT_REC_ocm(p_party_id, p_cust_account_id, p_customer_site_use_id,TRUNC(add_months(sysdate, -12)), TRUNC(sysdate));
2410:
2411: l_num_val := ROUND(NVL(l_sales, 0),2);
2412: l_char_val := RTRIM(TO_CHAR(l_num_val));
2413: fnd_file.put_line(FND_FILE.LOG, 'get_sales_ocm l_sales ' || l_char_val);
2414: RETURN l_char_val;
2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: RETURN(TO_CHAR(0));

Line 2430: fnd_file.put_line(FND_FILE.LOG, 'get_deduction_ocm l_adj ' || l_char_val);

2426: BEGIN
2427: l_adj := get_adj_total_ocm(p_party_id,p_cust_account_id,p_customer_site_use_id,TRUNC(add_months(sysdate, -12)),TRUNC(sysdate));
2428: l_num_val := ROUND(NVL(l_adj,0),2);
2429: l_char_val := rtrim(TO_CHAR(l_num_val));
2430: fnd_file.put_line(FND_FILE.LOG, 'get_deduction_ocm l_adj ' || l_char_val);
2431: RETURN l_char_val;
2432: EXCEPTION
2433: WHEN OTHERS THEN
2434: RETURN(TO_CHAR(0));

Line 2484: fnd_file.put_line(FND_FILE.LOG,' GET_NSF_STOP_PMT_COUNT l_nsf_count'|| l_num_val);

2480: END IF;
2481: END IF;
2482:
2483: l_num_val := ROUND(nvl(l_nsf_count,0), 2);
2484: fnd_file.put_line(FND_FILE.LOG,' GET_NSF_STOP_PMT_COUNT l_nsf_count'|| l_num_val);
2485: RETURN l_num_val;
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: RETURN(0);

Line 2538: fnd_file.put_line(FND_FILE.LOG,' GET_NSF_STOP_PMT_AMOUNT l_nsf_amount'|| l_num_val);

2534: END IF;
2535: END IF;
2536:
2537: l_num_val := ROUND(nvl(l_nsf_amount,0), 2);
2538: fnd_file.put_line(FND_FILE.LOG,' GET_NSF_STOP_PMT_AMOUNT l_nsf_amount'|| l_num_val);
2539: RETURN l_num_val;
2540: EXCEPTION
2541: WHEN OTHERS THEN
2542: RETURN(0);

Line 2599: fnd_file.put_line(FND_FILE.LOG,' get_wt_avg_days_paid_late l_wt_days_paid_late '|| l_num_val);

2595: END IF;
2596: END IF;
2597:
2598: l_num_val := ROUND(nvl(l_wt_days_paid_late,0), 2);
2599: fnd_file.put_line(FND_FILE.LOG,' get_wt_avg_days_paid_late l_wt_days_paid_late '|| l_num_val);
2600: RETURN l_num_val;
2601: EXCEPTION
2602: WHEN OTHERS THEN
2603: RETURN(0);