DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on FND_FILE

Line 1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER'));

1446: END IF;
1447:
1448:
1449: -- Create report header
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER'));
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER_LINE'));
1452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
1454: ||' '||RPAD(l_sob_name, 65)

Line 1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER_LINE'));

1447:
1448:
1449: -- Create report header
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER'));
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER_LINE'));
1452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
1454: ||' '||RPAD(l_sob_name, 65)
1455: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')

Line 1452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1448:
1449: -- Create report header
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER'));
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER_LINE'));
1452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
1454: ||' '||RPAD(l_sob_name, 65)
1455: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
1456: ||' '||l_org_name);

Line 1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')

1449: -- Create report header
1450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER'));
1451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_HEADER_LINE'));
1452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
1454: ||' '||RPAD(l_sob_name, 65)
1455: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
1456: ||' '||l_org_name);
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')

Line 1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')

1453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
1454: ||' '||RPAD(l_sob_name, 65)
1455: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
1456: ||' '||l_org_name);
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
1458: ||' '||RPAD(l_sysdate, 61)||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROV_DATE_TITLE')
1459: ||' '||l_entry_date);
1460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
1461: ||' '||RPAD(l_func_currency_code,65));

Line 1460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')

1456: ||' '||l_org_name);
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
1458: ||' '||RPAD(l_sysdate, 61)||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROV_DATE_TITLE')
1459: ||' '||l_entry_date);
1460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
1461: ||' '||RPAD(l_func_currency_code,65));
1462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1463:
1464: -- Create Report Content

Line 1462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1458: ||' '||RPAD(l_sysdate, 61)||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROV_DATE_TITLE')
1459: ||' '||l_entry_date);
1460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
1461: ||' '||RPAD(l_func_currency_code,65));
1462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1463:
1464: -- Create Report Content
1465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROD_TITLE')||' '||l_product_name);
1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);

Line 1465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROD_TITLE')||' '||l_product_name);

1461: ||' '||RPAD(l_func_currency_code,65));
1462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1463:
1464: -- Create Report Content
1465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROD_TITLE')||' '||l_product_name);
1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1468:
1469: IF l_product_subclass = 'LEASE' THEN

Line 1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);

1462: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1463:
1464: -- Create Report Content
1465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROD_TITLE')||' '||l_product_name);
1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1468:
1469: IF l_product_subclass = 'LEASE' THEN
1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)

Line 1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1463:
1464: -- Create Report Content
1465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROD_TITLE')||' '||l_product_name);
1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1468:
1469: IF l_product_subclass = 'LEASE' THEN
1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
1471: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)

Line 1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)

1466: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_STY_TITLE')||' '||l_sty_name);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1468:
1469: IF l_product_subclass = 'LEASE' THEN
1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
1471: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)
1472: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXLOCAL_TITLE'),23)
1473: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXCORP_TITLE'),26)
1474: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)

Line 1477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_NUM_TITLE'),28)

1473: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXCORP_TITLE'),26)
1474: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)
1475: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),17));
1476: ELSE
1477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_NUM_TITLE'),28)
1478: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)
1479: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXLOCAL_TITLE'),23)
1480: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXCORP_TITLE'),26)
1481: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)

Line 1485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_LINE'),28)

1481: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)
1482: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),17));
1483: END IF;
1484:
1485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_LINE'),28)
1486: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_LINE'),22)
1487: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXLOCAL_LINE'),23)
1488: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TAXCORP_LINE'),26)
1489: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURR_UNDERLINE'),9)

Line 2106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_cntrct_number,28)||

2102: p_token1_value => l_cntrct_number);
2103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2104: END IF;
2105:
2106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_cntrct_number,28)||
2107: RPAD(x_tcnv_rec.trx_number,22)||
2108: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_local,0,0),23)||
2109: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',x_tcnv_rec.tax_deductible_corporate,0,0),26)||
2110: RPAD(x_tcnv_rec.currency_code,9)||

Line 2121: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);

2117:
2118: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2119: l_return_status := Okl_Api.G_RET_STS_ERROR;
2120: -- Select the contract for error reporting
2121: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2122: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2123: l_error_cnt := l_error_cnt + 1; Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2124: IF (l_error_msg_tbl.COUNT > 0) THEN
2125: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST

Line 2128: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

2124: IF (l_error_msg_tbl.COUNT > 0) THEN
2125: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2126: LOOP
2127: IF l_error_msg_tbl(i) IS NOT NULL THEN
2128: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2129: END IF;
2130: END LOOP;
2131: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2132: END IF;

Line 2131: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

2127: IF l_error_msg_tbl(i) IS NOT NULL THEN
2128: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2129: END IF;
2130: END LOOP;
2131: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2132: END IF;
2133:
2134: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2135: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);

2133:
2134: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2135: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2136: -- Select the contract for error reporting
2137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2138: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2139: l_error_cnt := l_error_cnt + 1;
2140: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2141: IF (l_error_msg_tbl.COUNT > 0) THEN

Line 2145: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

2141: IF (l_error_msg_tbl.COUNT > 0) THEN
2142: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2143: LOOP
2144: IF l_error_msg_tbl(i) IS NOT NULL THEN
2145: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2146: END IF;
2147: END LOOP;
2148: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2149: END IF;

Line 2148: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

2144: IF l_error_msg_tbl(i) IS NOT NULL THEN
2145: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2146: END IF;
2147: END LOOP;
2148: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2149: END IF;
2150:
2151: WHEN OTHERS THEN
2152: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2170: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);

2166: CLOSE gen_loss_trx_csr;
2167: END IF;
2168:
2169: -- Select the contract for error reporting
2170: FND_FILE.PUT_LINE(FND_FILE.LOG,l_cntrct_number||', '||'Error Status: '||l_return_status);
2171: l_contract_error_tbl(l_error_cnt) := l_cntrct_number;
2172: l_error_cnt := l_error_cnt + 1;
2173: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
2174: IF (l_error_msg_tbl.COUNT > 0) THEN

Line 2178: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

2174: IF (l_error_msg_tbl.COUNT > 0) THEN
2175: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
2176: LOOP
2177: IF l_error_msg_tbl(i) IS NOT NULL THEN
2178: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2179: END IF;
2180: END LOOP;
2181: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2182: END IF;

Line 2181: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

2177: IF l_error_msg_tbl(i) IS NOT NULL THEN
2178: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
2179: END IF;
2180: END LOOP;
2181: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2182: END IF;
2183: END;
2184:
2185: END LOOP; -- for contracts within a product

Line 2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2184:
2185: END LOOP; -- for contracts within a product
2186: END IF; -- IF l_pdt_contracts_tbl.COUNT > 0 THEN
2187:
2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2190: IF l_product_subclass = 'LEASE' THEN
2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
2192: ELSE

Line 2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2185: END LOOP; -- for contracts within a product
2186: END IF; -- IF l_pdt_contracts_tbl.COUNT > 0 THEN
2187:
2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2190: IF l_product_subclass = 'LEASE' THEN
2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
2192: ELSE
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_ERROR_TITLE'));

Line 2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

2187:
2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2190: IF l_product_subclass = 'LEASE' THEN
2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
2192: ELSE
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_ERROR_TITLE'));
2194: END IF;
2195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

Line 2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_ERROR_TITLE'));

2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2190: IF l_product_subclass = 'LEASE' THEN
2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
2192: ELSE
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_ERROR_TITLE'));
2194: END IF;
2195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
2196: IF l_contract_error_tbl.COUNT > 0 THEN
2197: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

Line 2195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

2191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
2192: ELSE
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AGR_ERROR_TITLE'));
2194: END IF;
2195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
2196: IF l_contract_error_tbl.COUNT > 0 THEN
2197: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
2198: LOOP
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

Line 2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

2195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
2196: IF l_contract_error_tbl.COUNT > 0 THEN
2197: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
2198: LOOP
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
2200: END LOOP;
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
2203: END IF;

Line 2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

2197: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
2198: LOOP
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
2200: END LOOP;
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
2203: END IF;
2204: retcode := 0;
2205:

Line 2202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));

2198: LOOP
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
2200: END LOOP;
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
2203: END IF;
2204: retcode := 0;
2205:
2206: EXCEPTION

Line 2212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);

2208: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2209: l_return_status := Okl_Api.G_RET_STS_ERROR;
2210:
2211: -- print the overall status in the log file
2212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2213: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2214: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2215: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2216: LOOP

Line 2218: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));

2214: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2215: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2216: LOOP
2217: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN
2218: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));
2219: END IF;
2220: END LOOP;
2221: END IF;
2222: retcode := 2;

Line 2228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);

2224: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2225: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2226:
2227: -- print the overall status in the log file
2228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2229: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2230: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2231: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2232: LOOP

Line 2234: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));

2230: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2231: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2232: LOOP
2233: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN
2234: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));
2235: END IF;
2236: END LOOP;
2237: END IF;
2238: retcode := 2;

Line 2265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);

2261: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2262: errbuf := SQLERRM;
2263: retcode := 2;
2264: -- print the overall status in the log file
2265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overall Program Status = '||l_return_status);
2266: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
2267: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2268: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2269: LOOP

Line 2271: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));

2267: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
2268: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
2269: LOOP
2270: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN
2271: FND_FILE.PUT_LINE(FND_FILE.LOG,l_outer_error_msg_tbl(i));
2272: END IF;
2273: END LOOP;
2274: END IF;
2275: