DBA Data[Home] [Help]

APPS.OKL_BOOK_CONTROLLER_PVT dependencies on FND_MESSAGE

Line 45: fnd_message.set_name(application => G_APP_NAME,

41: l_message VARCHAR2(2000);
42: BEGIN
43: IF p_msg_name IS NOT NULL THEN
44: --create mesg to print in o/p files of requests
45: fnd_message.set_name(application => G_APP_NAME,
46: name => p_msg_name);
47:
48: fnd_message.set_token(token => p_token_name,
49: value => p_token_value);

Line 48: fnd_message.set_token(token => p_token_name,

44: --create mesg to print in o/p files of requests
45: fnd_message.set_name(application => G_APP_NAME,
46: name => p_msg_name);
47:
48: fnd_message.set_token(token => p_token_name,
49: value => p_token_value);
50:
51: l_message := fnd_message.get();
52: END IF;

Line 51: l_message := fnd_message.get();

47:
48: fnd_message.set_token(token => p_token_name,
49: value => p_token_value);
50:
51: l_message := fnd_message.get();
52: END IF;
53: RETURN l_message;
54:
55: EXCEPTION

Line 83: fnd_message.set_name(application => G_APP_NAME,

79: l_message VARCHAR2(2000);
80: BEGIN
81: IF p_msg_name IS NOT NULL THEN
82: --create mesg for to print in o/p filse of requests
83: fnd_message.set_name(application => G_APP_NAME,
84: name => p_msg_name);
85:
86: FOR i IN p_msg_tokens_tbl.FIRST..p_msg_tokens_tbl.LAST
87: LOOP

Line 88: fnd_message.set_token(token => p_msg_tokens_tbl(i).token_name,

84: name => p_msg_name);
85:
86: FOR i IN p_msg_tokens_tbl.FIRST..p_msg_tokens_tbl.LAST
87: LOOP
88: fnd_message.set_token(token => p_msg_tokens_tbl(i).token_name,
89: value => p_msg_tokens_tbl(i).token_value);
90:
91: END LOOP;
92: l_message := fnd_message.get();

Line 92: l_message := fnd_message.get();

88: fnd_message.set_token(token => p_msg_tokens_tbl(i).token_name,
89: value => p_msg_tokens_tbl(i).token_value);
90:
91: END LOOP;
92: l_message := fnd_message.get();
93: END IF;
94: RETURN l_message;
95:
96: EXCEPTION

Line 1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

1703: l_msg_token_tbl(2).token_value := 'QA Validation';
1704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1705: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
1706: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1708: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
1709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1710:
1711: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 1761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QA_CHECKLIST'));

1757: END IF;
1758:
1759: --print QA validation checklist into the output file
1760: IF (l_msg_tbl.COUNT > 0) THEN
1761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QA_CHECKLIST'));
1762: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------');
1763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1764: --column headings for the QA Validation checklist
1765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 1832: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

1828: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
1829: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
1830:
1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1832: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
1835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 1834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

1830:
1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1832: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
1835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1838:

Line 1836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

1832: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
1835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1838:
1839: EXCEPTION
1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

1856: x_msg_data => l_msg_data,
1857: p_api_type => g_api_type);
1858:
1859: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1862:
1863: --print the error message in the output file
1864: IF (fnd_msg_pub.count_msg > 0) THEN

Line 1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

1873: END LOOP;
1874: END IF;
1875:
1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1879:
1880: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1881: p_retcode := 2;

Line 1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

1896: x_msg_data => l_msg_data,
1897: p_api_type => g_api_type);
1898:
1899: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1902:
1903: -- print the error message in the output file
1904: IF (fnd_msg_pub.count_msg > 0) THEN

Line 1917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

1913: END LOOP;
1914: END IF;
1915:
1916: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1918: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1919:
1920: WHEN OTHERS THEN
1921: p_retcode := 2;

Line 1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

1937: x_msg_data => l_msg_data,
1938: p_api_type => g_api_type);
1939:
1940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1943:
1944: -- print the error message in the output file
1945: IF (fnd_msg_pub.count_msg > 0) THEN

Line 1958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

1954: END LOOP;
1955: END IF;
1956:
1957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_QACHECK_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
1959: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
1961:
1962: END execute_qa_check_list;

Line 2035: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2031: l_msg_token_tbl(2).token_value := 'Stream Generation';
2032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2033: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
2034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2035: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2036: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2037: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2038:
2039: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2147: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2149:
2150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 2153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

2149:
2150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2157:

Line 2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2151: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2157:
2158: EXCEPTION
2159: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2178: x_msg_data => l_msg_data,
2179: p_api_type => g_api_type);
2180:
2181: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2184:
2185: -- print the error message in the output file
2186: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2195: END LOOP;
2196: END IF;
2197:
2198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2201:
2202: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2203: p_retcode := 2;

Line 2225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2221: x_msg_data => l_msg_data,
2222: p_api_type => g_api_type);
2223:
2224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2227:
2228: -- print the error message in the output file
2229: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2238: END LOOP;
2239: END IF;
2240:
2241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2244:
2245: WHEN OTHERS THEN
2246: p_retcode := 2;

Line 2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2265: x_msg_data => l_msg_data,
2266: p_api_type => g_api_type);
2267:
2268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2271:
2272: -- print the error message in the output file
2273: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2282: END LOOP;
2283: END IF;
2284:
2285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_STREAM_GENERATION_SUCCESS')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2288: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
2289:
2290: END generate_streams;

Line 2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2337: l_msg_token_tbl(2).token_value := 'Draft Journal Entry';
2338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
2340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2344:
2345: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2421: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2423:
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 2427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

2423:
2424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2431:

Line 2429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2431:
2432: EXCEPTION
2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2446: x_msg_data => l_msg_data,
2447: p_api_type => g_api_type);
2448:
2449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2452:
2453: -- print the error message in the output file
2454: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2463: END LOOP;
2464: END IF;
2465:
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2469:
2470: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2471: p_retcode := 2;

Line 2487: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2483: x_msg_data => l_msg_data,
2484: p_api_type => g_api_type);
2485:
2486: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2487: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2489:
2490: -- print the error message in the output file
2491: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2500: END LOOP;
2501: END IF;
2502:
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2505: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2506:
2507: WHEN OTHERS THEN
2508: p_retcode := 2;

Line 2525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2521: x_msg_data => l_msg_data,
2522: p_api_type => g_api_type);
2523:
2524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2526: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2527:
2528: -- print the error message in the output file
2529: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_data);
2538: END LOOP;
2539: END IF;
2540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_JOURNAL_ENTRY_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2543: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
2544:
2545: END generate_journal_entries;

Line 2587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2583: l_msg_token_tbl(2).token_value := 'Approval';
2584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2585: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
2586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2590:
2591: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 2633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2629: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
2630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
2631:
2632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2634: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2636: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

2631:
2632: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2634: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2636: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2639:

Line 2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2633: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2634: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2635: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2636: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2639:
2640: EXCEPTION
2641: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2648: x_msg_data => l_msg_data,
2649: p_api_type => g_api_type);
2650:
2651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2654:
2655: -- print the error message in the output file
2656: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2665: END LOOP;
2666: END IF;
2667:
2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2671:
2672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2673: p_retcode := 2;

Line 2683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2679: x_msg_data => l_msg_data,
2680: p_api_type => g_api_type);
2681:
2682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2684: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2685:
2686: -- print the error message in the output file
2687: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2696: END LOOP;
2697: END IF;
2698:
2699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2701: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2702:
2703: WHEN OTHERS THEN
2704: p_retcode := 2;

Line 2715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2711: x_msg_data => l_msg_data,
2712: p_api_type => g_api_type);
2713:
2714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2717:
2718: -- print the error message in the output file
2719: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2728: END LOOP;
2729: END IF;
2730:
2731: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_APPROVAL_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2734: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
2735:
2736: END submit_for_approval;

Line 2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2777: l_msg_token_tbl(2).token_value := 'Activation';
2778: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
2780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
2783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2784:
2785: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2819: END IF;
2820:
2821: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
2822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2825: -- print the error message in the output file
2826: IF (fnd_msg_pub.count_msg > 0) THEN
2827: FOR l_counter IN 1 .. fnd_msg_pub.count_msg

Line 2838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_data);
2835: END LOOP;
2836: END IF;
2837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2839: END IF;
2840:
2841: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
2842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Activated successfully....');

Line 2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2840:
2841: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
2842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Activated successfully....');
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

Line 2846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

2842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract Activated successfully....');
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2849: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2850: END IF;

Line 2848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
2847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2849: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2850: END IF;
2851:
2852: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2872: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2868: x_msg_data => l_msg_data,
2869: p_api_type => g_api_type);
2870:
2871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2872: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2873: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2874:
2875: -- print the error message in the output file
2876: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2885: END LOOP;
2886: END IF;
2887:
2888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2890: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2891:
2892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2893: p_retcode := 2;

Line 2903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2899: x_msg_data => l_msg_data,
2900: p_api_type => g_api_type);
2901:
2902: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2905:
2906: -- print the error message in the output file
2907: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2916: END LOOP;
2917: END IF;
2918:
2919: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2921: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2922:
2923: WHEN OTHERS THEN
2924: p_retcode := 2;

Line 2935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

2931: x_msg_data => l_msg_data,
2932: p_api_type => g_api_type);
2933:
2934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2937:
2938: -- print the error message in the output file
2939: IF (fnd_msg_pub.count_msg > 0) THEN

Line 2952: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

2948: END LOOP;
2949: END IF;
2950:
2951: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2952: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CONTRACT_ACTIVATION_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
2953: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
2955:
2956: END activate_contract;

Line 3804: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

3800: l_msg_token_tbl(2).token_value := 'Calculate Upfront Tax';
3801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_COPYRIGHT_HEADER',l_msg_token_tbl));
3803: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3804: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_START')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,get_message('OKL_CONC_REQ_ID','REQUEST_ID',fnd_global.conc_request_id));
3806: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3807:
3808: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 3845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

3841: RAISE OKL_API.G_EXCEPTION_ERROR;
3842: END IF;
3843:
3844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3848:
3849: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN

Line 3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));

3863:
3864: IF (l_process_status <> OKL_API.G_RET_STS_ERROR) THEN
3865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Upfront Tax was calculated successfully....');
3866: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_REQ_SUCCESS'));
3868: END IF;
3869:
3870: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
3871: p_retcode := 2;

Line 3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

3870: IF (l_process_status = OKL_API.G_RET_STS_ERROR) THEN
3871: p_retcode := 2;
3872: END IF;
3873:
3874: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3876:
3877: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
3878: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');

Line 3893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

3889: x_msg_data => l_msg_data,
3890: p_api_type => g_api_type);
3891:
3892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3895:
3896: -- print the error message in the output file
3897: IF (fnd_msg_pub.count_msg > 0) THEN

Line 3910: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

3906: END LOOP;
3907: END IF;
3908:
3909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3910: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3911: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3912:
3913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3914: p_retcode := 2;

Line 3925: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

3921: x_msg_data => l_msg_data,
3922: p_api_type => g_api_type);
3923:
3924: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3925: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3926: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3927:
3928: -- print the error message in the output file
3929: IF (fnd_msg_pub.count_msg > 0) THEN

Line 3942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

3938: END LOOP;
3939: END IF;
3940:
3941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3944:
3945: WHEN OTHERS THEN
3946: p_retcode := 2;

Line 3958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));

3954: x_msg_data => l_msg_data,
3955: p_api_type => g_api_type);
3956:
3957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3959: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3960:
3961: -- print the error message in the output file
3962: IF (fnd_msg_pub.count_msg > 0) THEN

Line 3974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));

3970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_data);
3971: END LOOP;
3972: END IF;
3973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CALC_UPFRNTTX_END')||' '||TO_CHAR(sysdate,'DD-MON-YYYY HH:MM:SS'));
3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'+--------------------------------------------------------+');
3976: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
3977:
3978: END calculate_upfront_tax;