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.CS_CHARGE_DETAILS_PVT dependencies on FND_LOG

Line 1766: ----------------------- FND Logging -----------------------------------

1762:
1763: -- Initialize API return status to success
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: ----------------------- FND Logging -----------------------------------
1767: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1768: THEN
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 1767: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1763: -- Initialize API return status to success
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: ----------------------- FND Logging -----------------------------------
1767: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1768: THEN
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1771: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 1769: FND_LOG.String

1765:
1766: ----------------------- FND Logging -----------------------------------
1767: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1768: THEN
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1771: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1772: );
1773: FND_LOG.String

Line 1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

1766: ----------------------- FND Logging -----------------------------------
1767: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1768: THEN
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1771: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1773: FND_LOG.String

1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1771: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_api_version:' || p_api_version
1776: );
1777: FND_LOG.String

Line 1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1770: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1771: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_api_version:' || p_api_version
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1777: FND_LOG.String

1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_api_version:' || p_api_version
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_init_msg_list:' || p_init_msg_list
1780: );
1781: FND_LOG.String

Line 1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_api_version:' || p_api_version
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_init_msg_list:' || p_init_msg_list
1780: );
1781: FND_LOG.String
1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1781: FND_LOG.String

1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_init_msg_list:' || p_init_msg_list
1780: );
1781: FND_LOG.String
1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1783: , 'p_commit:' || p_commit
1784: );
1785: FND_LOG.String

Line 1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_init_msg_list:' || p_init_msg_list
1780: );
1781: FND_LOG.String
1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1783: , 'p_commit:' || p_commit
1784: );
1785: FND_LOG.String
1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1785: FND_LOG.String

1781: FND_LOG.String
1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1783: , 'p_commit:' || p_commit
1784: );
1785: FND_LOG.String
1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1787: , 'p_validation_level:' || p_validation_level
1788: );
1789: FND_LOG.String

Line 1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1782: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1783: , 'p_commit:' || p_commit
1784: );
1785: FND_LOG.String
1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1787: , 'p_validation_level:' || p_validation_level
1788: );
1789: FND_LOG.String
1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1789: FND_LOG.String

1785: FND_LOG.String
1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1787: , 'p_validation_level:' || p_validation_level
1788: );
1789: FND_LOG.String
1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1791: , 'p_resp_appl_id:' || p_resp_appl_id
1792: );
1793: FND_LOG.String

Line 1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1786: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1787: , 'p_validation_level:' || p_validation_level
1788: );
1789: FND_LOG.String
1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1791: , 'p_resp_appl_id:' || p_resp_appl_id
1792: );
1793: FND_LOG.String
1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1793: FND_LOG.String

1789: FND_LOG.String
1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1791: , 'p_resp_appl_id:' || p_resp_appl_id
1792: );
1793: FND_LOG.String
1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1795: , 'p_resp_id:' || p_resp_id
1796: );
1797: FND_LOG.String

Line 1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1790: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1791: , 'p_resp_appl_id:' || p_resp_appl_id
1792: );
1793: FND_LOG.String
1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1795: , 'p_resp_id:' || p_resp_id
1796: );
1797: FND_LOG.String
1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1797: FND_LOG.String

1793: FND_LOG.String
1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1795: , 'p_resp_id:' || p_resp_id
1796: );
1797: FND_LOG.String
1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1799: , 'p_user_id:' || p_user_id
1800: );
1801: FND_LOG.String

Line 1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1794: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1795: , 'p_resp_id:' || p_resp_id
1796: );
1797: FND_LOG.String
1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1799: , 'p_user_id:' || p_user_id
1800: );
1801: FND_LOG.String
1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1801: FND_LOG.String

1797: FND_LOG.String
1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1799: , 'p_user_id:' || p_user_id
1800: );
1801: FND_LOG.String
1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1803: , 'p_login_id:' || p_login_id
1804: );
1805: FND_LOG.String

Line 1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1798: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1799: , 'p_user_id:' || p_user_id
1800: );
1801: FND_LOG.String
1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1803: , 'p_login_id:' || p_login_id
1804: );
1805: FND_LOG.String
1806: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1805: FND_LOG.String

1801: FND_LOG.String
1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1803: , 'p_login_id:' || p_login_id
1804: );
1805: FND_LOG.String
1806: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1807: , 'p_transaction_control:' || p_transaction_control
1808: );
1809:

Line 1806: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1802: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1803: , 'p_login_id:' || p_login_id
1804: );
1805: FND_LOG.String
1806: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1807: , 'p_transaction_control:' || p_transaction_control
1808: );
1809:
1810: -- --------------------------------------------------------------------------

Line 1924: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1920: x_charges_detail_rec => l_est_detail_rec,
1921: x_msg_data => x_msg_data,
1922: x_msg_count => x_msg_count,
1923: x_return_status => l_return_status);
1924: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1925: THEN
1926: FND_LOG.String
1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1928: , 'After calling VALIDATE_CHARGE_DETAILS l_return_status :' || l_return_status

Line 1926: FND_LOG.String

1922: x_msg_count => x_msg_count,
1923: x_return_status => l_return_status);
1924: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1925: THEN
1926: FND_LOG.String
1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1928: , 'After calling VALIDATE_CHARGE_DETAILS l_return_status :' || l_return_status
1929: );
1930: FND_LOG.String

Line 1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1923: x_return_status => l_return_status);
1924: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1925: THEN
1926: FND_LOG.String
1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1928: , 'After calling VALIDATE_CHARGE_DETAILS l_return_status :' || l_return_status
1929: );
1930: FND_LOG.String
1931: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1930: FND_LOG.String

1926: FND_LOG.String
1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1928: , 'After calling VALIDATE_CHARGE_DETAILS l_return_status :' || l_return_status
1929: );
1930: FND_LOG.String
1931: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1932: , 'x_msg_data :' || x_msg_data
1933: );
1934: END IF;

Line 1931: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1927: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1928: , 'After calling VALIDATE_CHARGE_DETAILS l_return_status :' || l_return_status
1929: );
1930: FND_LOG.String
1931: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1932: , 'x_msg_data :' || x_msg_data
1933: );
1934: END IF;
1935:

Line 2042: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

2038: --DBMS_OUTPUT.PUT_LINE('p_login_id = '||p_login_id);
2039: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
2040: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
2041: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
2042: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2043: THEN
2044: FND_LOG.String
2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2046: , 'The Value of l_est_detail_rec.shipping_method :' || l_est_detail_rec.shipping_method

Line 2044: FND_LOG.String

2040: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
2041: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
2042: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2043: THEN
2044: FND_LOG.String
2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2046: , 'The Value of l_est_detail_rec.shipping_method :' || l_est_detail_rec.shipping_method
2047: );
2048: FND_LOG.String

Line 2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2041: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
2042: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2043: THEN
2044: FND_LOG.String
2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2046: , 'The Value of l_est_detail_rec.shipping_method :' || l_est_detail_rec.shipping_method
2047: );
2048: FND_LOG.String
2049: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2048: FND_LOG.String

2044: FND_LOG.String
2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2046: , 'The Value of l_est_detail_rec.shipping_method :' || l_est_detail_rec.shipping_method
2047: );
2048: FND_LOG.String
2049: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2050: , 'The Value of l_est_detail_rec.arrival_date_time :' || l_est_detail_rec.arrival_date_time
2051: );
2052: END IF;

Line 2049: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2045: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2046: , 'The Value of l_est_detail_rec.shipping_method :' || l_est_detail_rec.shipping_method
2047: );
2048: FND_LOG.String
2049: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2050: , 'The Value of l_est_detail_rec.arrival_date_time :' || l_est_detail_rec.arrival_date_time
2051: );
2052: END IF;
2053:

Line 2458: ----------------------- FND Logging -----------------------------------

2454:
2455: -- Initialize API return status to success
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: ----------------------- FND Logging -----------------------------------
2459: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2460: THEN
2461: FND_LOG.String
2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 2459: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

2455: -- Initialize API return status to success
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: ----------------------- FND Logging -----------------------------------
2459: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2460: THEN
2461: FND_LOG.String
2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2463: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 2461: FND_LOG.String

2457:
2458: ----------------------- FND Logging -----------------------------------
2459: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2460: THEN
2461: FND_LOG.String
2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2463: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2464: );
2465: FND_LOG.String

Line 2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

2458: ----------------------- FND Logging -----------------------------------
2459: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2460: THEN
2461: FND_LOG.String
2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2463: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2464: );
2465: FND_LOG.String
2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2465: FND_LOG.String

2461: FND_LOG.String
2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2463: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2464: );
2465: FND_LOG.String
2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2467: , 'p_api_version:' || p_api_version
2468: );
2469: FND_LOG.String

Line 2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2462: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2463: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2464: );
2465: FND_LOG.String
2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2467: , 'p_api_version:' || p_api_version
2468: );
2469: FND_LOG.String
2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2469: FND_LOG.String

2465: FND_LOG.String
2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2467: , 'p_api_version:' || p_api_version
2468: );
2469: FND_LOG.String
2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2471: , 'p_init_msg_list:' || p_init_msg_list
2472: );
2473: FND_LOG.String

Line 2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2466: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2467: , 'p_api_version:' || p_api_version
2468: );
2469: FND_LOG.String
2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2471: , 'p_init_msg_list:' || p_init_msg_list
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2473: FND_LOG.String

2469: FND_LOG.String
2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2471: , 'p_init_msg_list:' || p_init_msg_list
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2475: , 'p_commit:' || p_commit
2476: );
2477: FND_LOG.String

Line 2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2470: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2471: , 'p_init_msg_list:' || p_init_msg_list
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2475: , 'p_commit:' || p_commit
2476: );
2477: FND_LOG.String
2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2477: FND_LOG.String

2473: FND_LOG.String
2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2475: , 'p_commit:' || p_commit
2476: );
2477: FND_LOG.String
2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2479: , 'p_validation_level:' || p_validation_level
2480: );
2481: FND_LOG.String

Line 2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2474: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2475: , 'p_commit:' || p_commit
2476: );
2477: FND_LOG.String
2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2479: , 'p_validation_level:' || p_validation_level
2480: );
2481: FND_LOG.String
2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2481: FND_LOG.String

2477: FND_LOG.String
2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2479: , 'p_validation_level:' || p_validation_level
2480: );
2481: FND_LOG.String
2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2483: , 'p_resp_appl_id:' || p_resp_appl_id
2484: );
2485: FND_LOG.String

Line 2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2478: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2479: , 'p_validation_level:' || p_validation_level
2480: );
2481: FND_LOG.String
2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2483: , 'p_resp_appl_id:' || p_resp_appl_id
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2485: FND_LOG.String

2481: FND_LOG.String
2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2483: , 'p_resp_appl_id:' || p_resp_appl_id
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2487: , 'p_resp_id:' || p_resp_id
2488: );
2489: FND_LOG.String

Line 2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2482: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2483: , 'p_resp_appl_id:' || p_resp_appl_id
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2487: , 'p_resp_id:' || p_resp_id
2488: );
2489: FND_LOG.String
2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2489: FND_LOG.String

2485: FND_LOG.String
2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2487: , 'p_resp_id:' || p_resp_id
2488: );
2489: FND_LOG.String
2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2491: , 'p_user_id:' || p_user_id
2492: );
2493: FND_LOG.String

Line 2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2487: , 'p_resp_id:' || p_resp_id
2488: );
2489: FND_LOG.String
2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2491: , 'p_user_id:' || p_user_id
2492: );
2493: FND_LOG.String
2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2493: FND_LOG.String

2489: FND_LOG.String
2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2491: , 'p_user_id:' || p_user_id
2492: );
2493: FND_LOG.String
2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2495: , 'p_login_id:' || p_login_id
2496: );
2497: FND_LOG.String

Line 2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2491: , 'p_user_id:' || p_user_id
2492: );
2493: FND_LOG.String
2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2495: , 'p_login_id:' || p_login_id
2496: );
2497: FND_LOG.String
2498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2497: FND_LOG.String

2493: FND_LOG.String
2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2495: , 'p_login_id:' || p_login_id
2496: );
2497: FND_LOG.String
2498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2499: , 'p_transaction_control:' || p_transaction_control
2500: );
2501:

Line 2498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

2494: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2495: , 'p_login_id:' || p_login_id
2496: );
2497: FND_LOG.String
2498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2499: , 'p_transaction_control:' || p_transaction_control
2500: );
2501:
2502: -- --------------------------------------------------------------------------

Line 3089: ----------------------- FND Logging -----------------------------------

3085:
3086: --Initialize the API Return Success to True
3087: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3088:
3089: ----------------------- FND Logging -----------------------------------
3090: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3091: THEN
3092: FND_LOG.String
3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 3090: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

3086: --Initialize the API Return Success to True
3087: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3088:
3089: ----------------------- FND Logging -----------------------------------
3090: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3091: THEN
3092: FND_LOG.String
3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3094: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 3092: FND_LOG.String

3088:
3089: ----------------------- FND Logging -----------------------------------
3090: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3091: THEN
3092: FND_LOG.String
3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3094: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3095: );
3096: FND_LOG.String

Line 3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

3089: ----------------------- FND Logging -----------------------------------
3090: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3091: THEN
3092: FND_LOG.String
3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3094: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3095: );
3096: FND_LOG.String
3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3096: FND_LOG.String

3092: FND_LOG.String
3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3094: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3095: );
3096: FND_LOG.String
3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3098: , 'p_api_version:' || p_api_version
3099: );
3100: FND_LOG.String

Line 3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3093: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3094: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3095: );
3096: FND_LOG.String
3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3098: , 'p_api_version:' || p_api_version
3099: );
3100: FND_LOG.String
3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3100: FND_LOG.String

3096: FND_LOG.String
3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3098: , 'p_api_version:' || p_api_version
3099: );
3100: FND_LOG.String
3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3102: , 'p_init_msg_list:' || p_init_msg_list
3103: );
3104: FND_LOG.String

Line 3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3097: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3098: , 'p_api_version:' || p_api_version
3099: );
3100: FND_LOG.String
3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3102: , 'p_init_msg_list:' || p_init_msg_list
3103: );
3104: FND_LOG.String
3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3104: FND_LOG.String

3100: FND_LOG.String
3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3102: , 'p_init_msg_list:' || p_init_msg_list
3103: );
3104: FND_LOG.String
3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3106: , 'p_commit:' || p_commit
3107: );
3108: FND_LOG.String

Line 3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3101: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3102: , 'p_init_msg_list:' || p_init_msg_list
3103: );
3104: FND_LOG.String
3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3106: , 'p_commit:' || p_commit
3107: );
3108: FND_LOG.String
3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3108: FND_LOG.String

3104: FND_LOG.String
3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3106: , 'p_commit:' || p_commit
3107: );
3108: FND_LOG.String
3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3110: , 'p_validation_level:' || p_validation_level
3111: );
3112: FND_LOG.String

Line 3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3105: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3106: , 'p_commit:' || p_commit
3107: );
3108: FND_LOG.String
3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3110: , 'p_validation_level:' || p_validation_level
3111: );
3112: FND_LOG.String
3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3112: FND_LOG.String

3108: FND_LOG.String
3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3110: , 'p_validation_level:' || p_validation_level
3111: );
3112: FND_LOG.String
3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3114: , 'p_transaction_control:' || p_transaction_control
3115: );
3116: FND_LOG.String

Line 3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3109: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3110: , 'p_validation_level:' || p_validation_level
3111: );
3112: FND_LOG.String
3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3114: , 'p_transaction_control:' || p_transaction_control
3115: );
3116: FND_LOG.String
3117: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3116: FND_LOG.String

3112: FND_LOG.String
3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3114: , 'p_transaction_control:' || p_transaction_control
3115: );
3116: FND_LOG.String
3117: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3118: , 'p_estimate_detail_id:' || p_estimate_detail_id
3119: );
3120:

Line 3117: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3113: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3114: , 'p_transaction_control:' || p_transaction_control
3115: );
3116: FND_LOG.String
3117: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3118: , 'p_estimate_detail_id:' || p_estimate_detail_id
3119: );
3120:
3121: END IF;

Line 3281: ----------------------- FND Logging -----------------------------------

3277:
3278: -- Initialize API return status to success
3279: x_return_status := FND_API.G_RET_STS_SUCCESS;
3280:
3281: ----------------------- FND Logging -----------------------------------
3282: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3283: THEN
3284: FND_LOG.String
3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 3282: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

3278: -- Initialize API return status to success
3279: x_return_status := FND_API.G_RET_STS_SUCCESS;
3280:
3281: ----------------------- FND Logging -----------------------------------
3282: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3283: THEN
3284: FND_LOG.String
3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3286: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 3284: FND_LOG.String

3280:
3281: ----------------------- FND Logging -----------------------------------
3282: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3283: THEN
3284: FND_LOG.String
3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3286: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3287: );
3288: FND_LOG.String

Line 3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

3281: ----------------------- FND Logging -----------------------------------
3282: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3283: THEN
3284: FND_LOG.String
3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3286: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3287: );
3288: FND_LOG.String
3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3288: FND_LOG.String

3284: FND_LOG.String
3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3286: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3287: );
3288: FND_LOG.String
3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3290: , 'p_api_version:' || p_api_version
3291: );
3292: FND_LOG.String

Line 3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3285: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3286: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3287: );
3288: FND_LOG.String
3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3290: , 'p_api_version:' || p_api_version
3291: );
3292: FND_LOG.String
3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3292: FND_LOG.String

3288: FND_LOG.String
3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3290: , 'p_api_version:' || p_api_version
3291: );
3292: FND_LOG.String
3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3294: , 'p_init_msg_list:' || p_init_msg_list
3295: );
3296: FND_LOG.String

Line 3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3290: , 'p_api_version:' || p_api_version
3291: );
3292: FND_LOG.String
3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3294: , 'p_init_msg_list:' || p_init_msg_list
3295: );
3296: FND_LOG.String
3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3296: FND_LOG.String

3292: FND_LOG.String
3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3294: , 'p_init_msg_list:' || p_init_msg_list
3295: );
3296: FND_LOG.String
3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3298: , 'p_commit:' || p_commit
3299: );
3300: FND_LOG.String

Line 3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3293: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3294: , 'p_init_msg_list:' || p_init_msg_list
3295: );
3296: FND_LOG.String
3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3298: , 'p_commit:' || p_commit
3299: );
3300: FND_LOG.String
3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3300: FND_LOG.String

3296: FND_LOG.String
3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3298: , 'p_commit:' || p_commit
3299: );
3300: FND_LOG.String
3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3302: , 'p_transaction_control:' || p_transaction_control
3303: );
3304: FND_LOG.String

Line 3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3297: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3298: , 'p_commit:' || p_commit
3299: );
3300: FND_LOG.String
3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3302: , 'p_transaction_control:' || p_transaction_control
3303: );
3304: FND_LOG.String
3305: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3304: FND_LOG.String

3300: FND_LOG.String
3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3302: , 'p_transaction_control:' || p_transaction_control
3303: );
3304: FND_LOG.String
3305: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3306: , 'p_estimate_detail_id:' || p_estimate_detail_id
3307: );
3308:

Line 3305: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

3301: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3302: , 'p_transaction_control:' || p_transaction_control
3303: );
3304: FND_LOG.String
3305: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3306: , 'p_estimate_detail_id:' || p_estimate_detail_id
3307: );
3308:
3309: END IF;

Line 5304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

5300: -- Get the Business Process Id from Service Request
5301: -- Check if the profile to get Business Process From SR = 'Y'
5302: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5303:
5304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5305: THEN
5306: FND_LOG.String
5307: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5308: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr

Line 5306: FND_LOG.String

5302: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5303:
5304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5305: THEN
5306: FND_LOG.String
5307: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5308: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr
5309: );
5310: END IF;

Line 5307: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

5303:
5304: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5305: THEN
5306: FND_LOG.String
5307: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5308: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr
5309: );
5310: END IF;
5311:

Line 9680: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

9676:
9677: --use the default from the price list
9678: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9679:
9680: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9681: THEN
9682: FND_LOG.String
9683: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9684: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id

Line 9682: FND_LOG.String

9678: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9679:
9680: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9681: THEN
9682: FND_LOG.String
9683: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9684: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9685: );
9686: END IF;

Line 9683: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

9679:
9680: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9681: THEN
9682: FND_LOG.String
9683: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9684: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9685: );
9686: END IF;
9687:

Line 9866: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

9862:
9863: --use the default from the price list
9864: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9865:
9866: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9867: THEN
9868: FND_LOG.String
9869: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9870: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id

Line 9868: FND_LOG.String

9864: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9865:
9866: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9867: THEN
9868: FND_LOG.String
9869: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9870: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9871: );
9872: END IF;

Line 9869: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

9865:
9866: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9867: THEN
9868: FND_LOG.String
9869: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9870: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9871: );
9872: END IF;
9873:

Line 15965: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

15961:
15962: --DBMS_OUTPUT.PUT_LINE('Conversion Type is '||l_conversion_type);
15963: --DBMS_OUTPUT.PUT_LINE('l_max_roll_days '||l_max_roll_days);
15964:
15965: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15966: THEN
15967: FND_LOG.String
15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15969: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type

Line 15967: FND_LOG.String

15963: --DBMS_OUTPUT.PUT_LINE('l_max_roll_days '||l_max_roll_days);
15964:
15965: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15966: THEN
15967: FND_LOG.String
15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15969: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
15970: );
15971: FND_LOG.String

Line 15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

15964:
15965: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15966: THEN
15967: FND_LOG.String
15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15969: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
15970: );
15971: FND_LOG.String
15972: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 15971: FND_LOG.String

15967: FND_LOG.String
15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15969: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
15970: );
15971: FND_LOG.String
15972: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15973: , 'The Value of profile CS_CHG_MAX_ROLL_DAYS :' || l_max_roll_days
15974: );
15975: END IF;

Line 15972: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

15968: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15969: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
15970: );
15971: FND_LOG.String
15972: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
15973: , 'The Value of profile CS_CHG_MAX_ROLL_DAYS :' || l_max_roll_days
15974: );
15975: END IF;
15976:

Line 16479: FROM fnd_logins

16475: AND NVL(end_date, SYSDATE) >= SYSDATE;
16476:
16477: CURSOR c_login IS
16478: SELECT 1
16479: FROM fnd_logins
16480: WHERE login_id = p_login_id
16481: AND user_id = p_user_id;
16482:
16483: l_dummy VARCHAR2(1);

Line 16514: FROM fnd_logins

16510:
16511: IF p_login_id is not null then
16512: BEGIN
16513: SELECT 'x' into l_dummy
16514: FROM fnd_logins
16515: WHERE login_id = p_login_id
16516: AND user_id = p_user_id;
16517:
16518: EXCEPTION

Line 16794: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

16790:
16791: BEGIN
16792: x_return_status := FND_API.G_RET_STS_SUCCESS;
16793:
16794: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16795: THEN
16796: FND_LOG.String
16797: (
16798: FND_LOG.level_procedure

Line 16796: FND_LOG.String

16792: x_return_status := FND_API.G_RET_STS_SUCCESS;
16793:
16794: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16795: THEN
16796: FND_LOG.String
16797: (
16798: FND_LOG.level_procedure
16799: , L_LOG_MODULE || 'start'
16800: , 'Inside ' || L_API_NAME_FULL

Line 16798: FND_LOG.level_procedure

16794: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16795: THEN
16796: FND_LOG.String
16797: (
16798: FND_LOG.level_procedure
16799: , L_LOG_MODULE || 'start'
16800: , 'Inside ' || L_API_NAME_FULL
16801: || ', called with parameters below:'
16802: );

Line 16803: FND_LOG.String

16799: , L_LOG_MODULE || 'start'
16800: , 'Inside ' || L_API_NAME_FULL
16801: || ', called with parameters below:'
16802: );
16803: FND_LOG.String
16804: (
16805: FND_LOG.level_procedure
16806: , L_LOG_MODULE || 'param 1'
16807: , 'p_api_version_number:' || p_api_version_number

Line 16805: FND_LOG.level_procedure

16801: || ', called with parameters below:'
16802: );
16803: FND_LOG.String
16804: (
16805: FND_LOG.level_procedure
16806: , L_LOG_MODULE || 'param 1'
16807: , 'p_api_version_number:' || p_api_version_number
16808: );
16809: FND_LOG.String

Line 16809: FND_LOG.String

16805: FND_LOG.level_procedure
16806: , L_LOG_MODULE || 'param 1'
16807: , 'p_api_version_number:' || p_api_version_number
16808: );
16809: FND_LOG.String
16810: (
16811: FND_LOG.level_procedure
16812: , L_LOG_MODULE || 'param 2'
16813: , 'p_init_msg_list:' || p_init_msg_list

Line 16811: FND_LOG.level_procedure

16807: , 'p_api_version_number:' || p_api_version_number
16808: );
16809: FND_LOG.String
16810: (
16811: FND_LOG.level_procedure
16812: , L_LOG_MODULE || 'param 2'
16813: , 'p_init_msg_list:' || p_init_msg_list
16814: );
16815: FND_LOG.String

Line 16815: FND_LOG.String

16811: FND_LOG.level_procedure
16812: , L_LOG_MODULE || 'param 2'
16813: , 'p_init_msg_list:' || p_init_msg_list
16814: );
16815: FND_LOG.String
16816: (
16817: FND_LOG.level_procedure
16818: , L_LOG_MODULE || 'param 3'
16819: , 'p_commit:' || p_commit

Line 16817: FND_LOG.level_procedure

16813: , 'p_init_msg_list:' || p_init_msg_list
16814: );
16815: FND_LOG.String
16816: (
16817: FND_LOG.level_procedure
16818: , L_LOG_MODULE || 'param 3'
16819: , 'p_commit:' || p_commit
16820: );
16821: FND_LOG.String

Line 16821: FND_LOG.String

16817: FND_LOG.level_procedure
16818: , L_LOG_MODULE || 'param 3'
16819: , 'p_commit:' || p_commit
16820: );
16821: FND_LOG.String
16822: (
16823: FND_LOG.level_procedure
16824: , L_LOG_MODULE || 'param 4'
16825: , 'p_object_type:' || p_object_type

Line 16823: FND_LOG.level_procedure

16819: , 'p_commit:' || p_commit
16820: );
16821: FND_LOG.String
16822: (
16823: FND_LOG.level_procedure
16824: , L_LOG_MODULE || 'param 4'
16825: , 'p_object_type:' || p_object_type
16826: );
16827: FND_LOG.String

Line 16827: FND_LOG.String

16823: FND_LOG.level_procedure
16824: , L_LOG_MODULE || 'param 4'
16825: , 'p_object_type:' || p_object_type
16826: );
16827: FND_LOG.String
16828: (
16829: FND_LOG.level_procedure
16830: , L_LOG_MODULE || 'param 5'
16831: , 'p_processing_set_id:' || p_processing_set_id

Line 16829: FND_LOG.level_procedure

16825: , 'p_object_type:' || p_object_type
16826: );
16827: FND_LOG.String
16828: (
16829: FND_LOG.level_procedure
16830: , L_LOG_MODULE || 'param 5'
16831: , 'p_processing_set_id:' || p_processing_set_id
16832: );
16833: END IF ;

Line 16862: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

16858: ------------------------------------------------------------------------------
16859:
16860: IF NVL(p_object_type, 'X') <> 'SR'
16861: THEN
16862: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16863: THEN
16864: FND_LOG.String
16865: (
16866: FND_LOG.level_unexpected

Line 16864: FND_LOG.String

16860: IF NVL(p_object_type, 'X') <> 'SR'
16861: THEN
16862: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16863: THEN
16864: FND_LOG.String
16865: (
16866: FND_LOG.level_unexpected
16867: , L_LOG_MODULE || 'object_type_invalid'
16868: , 'p_object_type has to be SR.'

Line 16866: FND_LOG.level_unexpected

16862: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16863: THEN
16864: FND_LOG.String
16865: (
16866: FND_LOG.level_unexpected
16867: , L_LOG_MODULE || 'object_type_invalid'
16868: , 'p_object_type has to be SR.'
16869: );
16870: END IF ;

Line 16885: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

16881: ---
16882:
16883: IF p_processing_set_id IS NULL
16884: THEN
16885: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16886: THEN
16887: FND_LOG.String
16888: (
16889: FND_LOG.level_unexpected

Line 16887: FND_LOG.String

16883: IF p_processing_set_id IS NULL
16884: THEN
16885: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16886: THEN
16887: FND_LOG.String
16888: (
16889: FND_LOG.level_unexpected
16890: , L_LOG_MODULE || 'proc_set_id_invalid'
16891: , 'p_processing_set_id should not be NULL.'

Line 16889: FND_LOG.level_unexpected

16885: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16886: THEN
16887: FND_LOG.String
16888: (
16889: FND_LOG.level_unexpected
16890: , L_LOG_MODULE || 'proc_set_id_invalid'
16891: , 'p_processing_set_id should not be NULL.'
16892: );
16893: END IF ;

Line 16908: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

16904: ------------------------------------------------------------------------------
16905: -- Actual Logic starts below:
16906: ------------------------------------------------------------------------------
16907:
16908: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16909: THEN
16910: FND_LOG.String
16911: (
16912: FND_LOG.level_statement

Line 16910: FND_LOG.String

16906: ------------------------------------------------------------------------------
16907:
16908: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16909: THEN
16910: FND_LOG.String
16911: (
16912: FND_LOG.level_statement
16913: , L_LOG_MODULE || 'valid_chg_line_start'
16914: , 'validating charge lines against SRs in the global temp table'

Line 16912: FND_LOG.level_statement

16908: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16909: THEN
16910: FND_LOG.String
16911: (
16912: FND_LOG.level_statement
16913: , L_LOG_MODULE || 'valid_chg_line_start'
16914: , 'validating charge lines against SRs in the global temp table'
16915: );
16916: END IF ;

Line 16950: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

16946: AND processing_set_id = p_processing_set_id;
16947:
16948: l_row_count := SQL%ROWCOUNT;
16949:
16950: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16951: THEN
16952: FND_LOG.String
16953: (
16954: FND_LOG.level_statement

Line 16952: FND_LOG.String

16948: l_row_count := SQL%ROWCOUNT;
16949:
16950: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16951: THEN
16952: FND_LOG.String
16953: (
16954: FND_LOG.level_statement
16955: , L_LOG_MODULE || 'valid_chg_line_end'
16956: , 'after validating charge lines against SRs in the global temp table '

Line 16954: FND_LOG.level_statement

16950: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
16951: THEN
16952: FND_LOG.String
16953: (
16954: FND_LOG.level_statement
16955: , L_LOG_MODULE || 'valid_chg_line_end'
16956: , 'after validating charge lines against SRs in the global temp table '
16957: || l_row_count || ' rows failed validation'
16958: );

Line 16963: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

16959: END IF ;
16960:
16961: ---
16962:
16963: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16964: THEN
16965: FND_LOG.String
16966: (
16967: FND_LOG.level_procedure

Line 16965: FND_LOG.String

16961: ---
16962:
16963: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16964: THEN
16965: FND_LOG.String
16966: (
16967: FND_LOG.level_procedure
16968: , L_LOG_MODULE || 'end'
16969: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'

Line 16967: FND_LOG.level_procedure

16963: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
16964: THEN
16965: FND_LOG.String
16966: (
16967: FND_LOG.level_procedure
16968: , L_LOG_MODULE || 'end'
16969: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'
16970: );
16971: END IF ;

Line 16977: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

16973: EXCEPTION
16974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16976:
16977: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16978: THEN
16979: FND_LOG.String
16980: (
16981: FND_LOG.level_unexpected

Line 16979: FND_LOG.String

16975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16976:
16977: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16978: THEN
16979: FND_LOG.String
16980: (
16981: FND_LOG.level_unexpected
16982: , L_LOG_MODULE || 'unexpected_error'
16983: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 16981: FND_LOG.level_unexpected

16977: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16978: THEN
16979: FND_LOG.String
16980: (
16981: FND_LOG.level_unexpected
16982: , L_LOG_MODULE || 'unexpected_error'
16983: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
16984: );
16985: END IF ;

Line 16994: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

16990: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
16991: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
16992: FND_MSG_PUB.ADD;
16993:
16994: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16995: THEN
16996: FND_LOG.String
16997: (
16998: FND_LOG.level_unexpected

Line 16996: FND_LOG.String

16992: FND_MSG_PUB.ADD;
16993:
16994: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16995: THEN
16996: FND_LOG.String
16997: (
16998: FND_LOG.level_unexpected
16999: , L_LOG_MODULE || 'when_others'
17000: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'

Line 16998: FND_LOG.level_unexpected

16994: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
16995: THEN
16996: FND_LOG.String
16997: (
16998: FND_LOG.level_unexpected
16999: , L_LOG_MODULE || 'when_others'
17000: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17001: );
17002: FND_LOG.String

Line 17002: FND_LOG.String

16998: FND_LOG.level_unexpected
16999: , L_LOG_MODULE || 'when_others'
17000: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17001: );
17002: FND_LOG.String
17003: (
17004: FND_LOG.level_unexpected
17005: , L_LOG_MODULE || 'when_others'
17006: , SQLERRM

Line 17004: FND_LOG.level_unexpected

17000: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17001: );
17002: FND_LOG.String
17003: (
17004: FND_LOG.level_unexpected
17005: , L_LOG_MODULE || 'when_others'
17006: , SQLERRM
17007: );
17008: END IF ;

Line 17061: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

17057:
17058: BEGIN
17059: x_return_status := FND_API.G_RET_STS_SUCCESS;
17060:
17061: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17062: THEN
17063: FND_LOG.String
17064: (
17065: FND_LOG.level_procedure

Line 17063: FND_LOG.String

17059: x_return_status := FND_API.G_RET_STS_SUCCESS;
17060:
17061: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17062: THEN
17063: FND_LOG.String
17064: (
17065: FND_LOG.level_procedure
17066: , L_LOG_MODULE || 'start'
17067: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 17065: FND_LOG.level_procedure

17061: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17062: THEN
17063: FND_LOG.String
17064: (
17065: FND_LOG.level_procedure
17066: , L_LOG_MODULE || 'start'
17067: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
17068: );
17069: FND_LOG.String

Line 17069: FND_LOG.String

17065: FND_LOG.level_procedure
17066: , L_LOG_MODULE || 'start'
17067: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
17068: );
17069: FND_LOG.String
17070: (
17071: FND_LOG.level_procedure
17072: , L_LOG_MODULE || 'param 1'
17073: , 'p_api_version_number:' || p_api_version_number

Line 17071: FND_LOG.level_procedure

17067: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
17068: );
17069: FND_LOG.String
17070: (
17071: FND_LOG.level_procedure
17072: , L_LOG_MODULE || 'param 1'
17073: , 'p_api_version_number:' || p_api_version_number
17074: );
17075: FND_LOG.String

Line 17075: FND_LOG.String

17071: FND_LOG.level_procedure
17072: , L_LOG_MODULE || 'param 1'
17073: , 'p_api_version_number:' || p_api_version_number
17074: );
17075: FND_LOG.String
17076: (
17077: FND_LOG.level_procedure
17078: , L_LOG_MODULE || 'param 2'
17079: , 'p_init_msg_list:' || p_init_msg_list

Line 17077: FND_LOG.level_procedure

17073: , 'p_api_version_number:' || p_api_version_number
17074: );
17075: FND_LOG.String
17076: (
17077: FND_LOG.level_procedure
17078: , L_LOG_MODULE || 'param 2'
17079: , 'p_init_msg_list:' || p_init_msg_list
17080: );
17081: FND_LOG.String

Line 17081: FND_LOG.String

17077: FND_LOG.level_procedure
17078: , L_LOG_MODULE || 'param 2'
17079: , 'p_init_msg_list:' || p_init_msg_list
17080: );
17081: FND_LOG.String
17082: (
17083: FND_LOG.level_procedure
17084: , L_LOG_MODULE || 'param 3'
17085: , 'p_commit:' || p_commit

Line 17083: FND_LOG.level_procedure

17079: , 'p_init_msg_list:' || p_init_msg_list
17080: );
17081: FND_LOG.String
17082: (
17083: FND_LOG.level_procedure
17084: , L_LOG_MODULE || 'param 3'
17085: , 'p_commit:' || p_commit
17086: );
17087: FND_LOG.String

Line 17087: FND_LOG.String

17083: FND_LOG.level_procedure
17084: , L_LOG_MODULE || 'param 3'
17085: , 'p_commit:' || p_commit
17086: );
17087: FND_LOG.String
17088: (
17089: FND_LOG.level_procedure
17090: , L_LOG_MODULE || 'param 4'
17091: , 'p_object_type:' || p_object_type

Line 17089: FND_LOG.level_procedure

17085: , 'p_commit:' || p_commit
17086: );
17087: FND_LOG.String
17088: (
17089: FND_LOG.level_procedure
17090: , L_LOG_MODULE || 'param 4'
17091: , 'p_object_type:' || p_object_type
17092: );
17093: FND_LOG.String

Line 17093: FND_LOG.String

17089: FND_LOG.level_procedure
17090: , L_LOG_MODULE || 'param 4'
17091: , 'p_object_type:' || p_object_type
17092: );
17093: FND_LOG.String
17094: (
17095: FND_LOG.level_procedure
17096: , L_LOG_MODULE || 'param 5'
17097: , 'p_processing_set_id:' || p_processing_set_id

Line 17095: FND_LOG.level_procedure

17091: , 'p_object_type:' || p_object_type
17092: );
17093: FND_LOG.String
17094: (
17095: FND_LOG.level_procedure
17096: , L_LOG_MODULE || 'param 5'
17097: , 'p_processing_set_id:' || p_processing_set_id
17098: );
17099: END IF ;

Line 17128: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

17124: ------------------------------------------------------------------------------
17125:
17126: IF NVL(p_object_type, 'X') <> 'SR'
17127: THEN
17128: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17129: THEN
17130: FND_LOG.String
17131: (
17132: FND_LOG.level_unexpected

Line 17130: FND_LOG.String

17126: IF NVL(p_object_type, 'X') <> 'SR'
17127: THEN
17128: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17129: THEN
17130: FND_LOG.String
17131: (
17132: FND_LOG.level_unexpected
17133: , L_LOG_MODULE || 'object_type_invalid'
17134: , 'p_object_type has to be SR.'

Line 17132: FND_LOG.level_unexpected

17128: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17129: THEN
17130: FND_LOG.String
17131: (
17132: FND_LOG.level_unexpected
17133: , L_LOG_MODULE || 'object_type_invalid'
17134: , 'p_object_type has to be SR.'
17135: );
17136: END IF ;

Line 17151: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

17147: ---
17148:
17149: IF p_processing_set_id IS NULL
17150: THEN
17151: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17152: THEN
17153: FND_LOG.String
17154: (
17155: FND_LOG.level_unexpected

Line 17153: FND_LOG.String

17149: IF p_processing_set_id IS NULL
17150: THEN
17151: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17152: THEN
17153: FND_LOG.String
17154: (
17155: FND_LOG.level_unexpected
17156: , L_LOG_MODULE || 'proc_set_id_invalid'
17157: , 'p_processing_set_id should not be NULL.'

Line 17155: FND_LOG.level_unexpected

17151: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17152: THEN
17153: FND_LOG.String
17154: (
17155: FND_LOG.level_unexpected
17156: , L_LOG_MODULE || 'proc_set_id_invalid'
17157: , 'p_processing_set_id should not be NULL.'
17158: );
17159: END IF ;

Line 17174: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

17170: ------------------------------------------------------------------------------
17171: -- Actual Logic starts below:
17172: ------------------------------------------------------------------------------
17173:
17174: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17175: THEN
17176: FND_LOG.String
17177: (
17178: FND_LOG.level_statement

Line 17176: FND_LOG.String

17172: ------------------------------------------------------------------------------
17173:
17174: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17175: THEN
17176: FND_LOG.String
17177: (
17178: FND_LOG.level_statement
17179: , L_LOG_MODULE || 'del_chg_line_start'
17180: , 'deleting charge lines against SRs in the global temp table'

Line 17178: FND_LOG.level_statement

17174: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17175: THEN
17176: FND_LOG.String
17177: (
17178: FND_LOG.level_statement
17179: , L_LOG_MODULE || 'del_chg_line_start'
17180: , 'deleting charge lines against SRs in the global temp table'
17181: );
17182: END IF ;

Line 17204: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

17200: );
17201:
17202: l_row_count := SQL%ROWCOUNT;
17203:
17204: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17205: THEN
17206: FND_LOG.String
17207: (
17208: FND_LOG.level_statement

Line 17206: FND_LOG.String

17202: l_row_count := SQL%ROWCOUNT;
17203:
17204: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17205: THEN
17206: FND_LOG.String
17207: (
17208: FND_LOG.level_statement
17209: , L_LOG_MODULE || 'del_chg_line_end'
17210: , 'after deleting charge lines against SRs in the global temp table'

Line 17208: FND_LOG.level_statement

17204: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
17205: THEN
17206: FND_LOG.String
17207: (
17208: FND_LOG.level_statement
17209: , L_LOG_MODULE || 'del_chg_line_end'
17210: , 'after deleting charge lines against SRs in the global temp table'
17211: || l_row_count || ' rows deleted.'
17212: );

Line 17217: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

17213: END IF ;
17214:
17215: ---
17216:
17217: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17218: THEN
17219: FND_LOG.String
17220: (
17221: FND_LOG.level_procedure

Line 17219: FND_LOG.String

17215: ---
17216:
17217: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17218: THEN
17219: FND_LOG.String
17220: (
17221: FND_LOG.level_procedure
17222: , L_LOG_MODULE || 'end'
17223: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'

Line 17221: FND_LOG.level_procedure

17217: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
17218: THEN
17219: FND_LOG.String
17220: (
17221: FND_LOG.level_procedure
17222: , L_LOG_MODULE || 'end'
17223: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'
17224: );
17225: END IF ;

Line 17231: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

17227: EXCEPTION
17228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
17229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17230:
17231: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17232: THEN
17233: FND_LOG.String
17234: (
17235: FND_LOG.level_unexpected

Line 17233: FND_LOG.String

17229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17230:
17231: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17232: THEN
17233: FND_LOG.String
17234: (
17235: FND_LOG.level_unexpected
17236: , L_LOG_MODULE || 'unexpected_error'
17237: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 17235: FND_LOG.level_unexpected

17231: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17232: THEN
17233: FND_LOG.String
17234: (
17235: FND_LOG.level_unexpected
17236: , L_LOG_MODULE || 'unexpected_error'
17237: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
17238: );
17239: END IF ;

Line 17248: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

17244: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
17245: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
17246: FND_MSG_PUB.ADD;
17247:
17248: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17249: THEN
17250: FND_LOG.String
17251: (
17252: FND_LOG.level_unexpected

Line 17250: FND_LOG.String

17246: FND_MSG_PUB.ADD;
17247:
17248: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17249: THEN
17250: FND_LOG.String
17251: (
17252: FND_LOG.level_unexpected
17253: , L_LOG_MODULE || 'when_others'
17254: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'

Line 17252: FND_LOG.level_unexpected

17248: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
17249: THEN
17250: FND_LOG.String
17251: (
17252: FND_LOG.level_unexpected
17253: , L_LOG_MODULE || 'when_others'
17254: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17255: );
17256: FND_LOG.String

Line 17256: FND_LOG.String

17252: FND_LOG.level_unexpected
17253: , L_LOG_MODULE || 'when_others'
17254: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17255: );
17256: FND_LOG.String
17257: (
17258: FND_LOG.level_unexpected
17259: , L_LOG_MODULE || 'when_others'
17260: , SQLERRM

Line 17258: FND_LOG.level_unexpected

17254: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
17255: );
17256: FND_LOG.String
17257: (
17258: FND_LOG.level_unexpected
17259: , L_LOG_MODULE || 'when_others'
17260: , SQLERRM
17261: );
17262: END IF ;