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 1666: ----------------------- FND Logging -----------------------------------

1662:
1663: -- Initialize API return status to success
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: ----------------------- FND Logging -----------------------------------
1667: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1668: THEN
1669: FND_LOG.String
1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

1663: -- Initialize API return status to success
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: ----------------------- FND Logging -----------------------------------
1667: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1668: THEN
1669: FND_LOG.String
1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1671: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 1669: FND_LOG.String

1665:
1666: ----------------------- FND Logging -----------------------------------
1667: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1668: THEN
1669: FND_LOG.String
1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1671: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1672: );
1673: FND_LOG.String

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

1666: ----------------------- FND Logging -----------------------------------
1667: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1668: THEN
1669: FND_LOG.String
1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1671: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1672: );
1673: FND_LOG.String
1674: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1673: FND_LOG.String

1669: FND_LOG.String
1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1671: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1672: );
1673: FND_LOG.String
1674: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1675: , 'p_api_version:' || p_api_version
1676: );
1677: FND_LOG.String

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

1670: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1671: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1672: );
1673: FND_LOG.String
1674: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1675: , 'p_api_version:' || p_api_version
1676: );
1677: FND_LOG.String
1678: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1677: FND_LOG.String

1673: FND_LOG.String
1674: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1675: , 'p_api_version:' || p_api_version
1676: );
1677: FND_LOG.String
1678: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1679: , 'p_init_msg_list:' || p_init_msg_list
1680: );
1681: FND_LOG.String

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

1674: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1675: , 'p_api_version:' || p_api_version
1676: );
1677: FND_LOG.String
1678: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1679: , 'p_init_msg_list:' || p_init_msg_list
1680: );
1681: FND_LOG.String
1682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1681: FND_LOG.String

1677: FND_LOG.String
1678: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1679: , 'p_init_msg_list:' || p_init_msg_list
1680: );
1681: FND_LOG.String
1682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1683: , 'p_commit:' || p_commit
1684: );
1685: FND_LOG.String

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

1678: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1679: , 'p_init_msg_list:' || p_init_msg_list
1680: );
1681: FND_LOG.String
1682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1683: , 'p_commit:' || p_commit
1684: );
1685: FND_LOG.String
1686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1685: FND_LOG.String

1681: FND_LOG.String
1682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1683: , 'p_commit:' || p_commit
1684: );
1685: FND_LOG.String
1686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1687: , 'p_validation_level:' || p_validation_level
1688: );
1689: FND_LOG.String

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

1682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1683: , 'p_commit:' || p_commit
1684: );
1685: FND_LOG.String
1686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1687: , 'p_validation_level:' || p_validation_level
1688: );
1689: FND_LOG.String
1690: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1689: FND_LOG.String

1685: FND_LOG.String
1686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1687: , 'p_validation_level:' || p_validation_level
1688: );
1689: FND_LOG.String
1690: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1691: , 'p_resp_appl_id:' || p_resp_appl_id
1692: );
1693: FND_LOG.String

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

1686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1687: , 'p_validation_level:' || p_validation_level
1688: );
1689: FND_LOG.String
1690: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1691: , 'p_resp_appl_id:' || p_resp_appl_id
1692: );
1693: FND_LOG.String
1694: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1693: FND_LOG.String

1689: FND_LOG.String
1690: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1691: , 'p_resp_appl_id:' || p_resp_appl_id
1692: );
1693: FND_LOG.String
1694: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1695: , 'p_resp_id:' || p_resp_id
1696: );
1697: FND_LOG.String

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

1690: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1691: , 'p_resp_appl_id:' || p_resp_appl_id
1692: );
1693: FND_LOG.String
1694: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1695: , 'p_resp_id:' || p_resp_id
1696: );
1697: FND_LOG.String
1698: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1697: FND_LOG.String

1693: FND_LOG.String
1694: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1695: , 'p_resp_id:' || p_resp_id
1696: );
1697: FND_LOG.String
1698: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1699: , 'p_user_id:' || p_user_id
1700: );
1701: FND_LOG.String

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

1694: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1695: , 'p_resp_id:' || p_resp_id
1696: );
1697: FND_LOG.String
1698: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1699: , 'p_user_id:' || p_user_id
1700: );
1701: FND_LOG.String
1702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1701: FND_LOG.String

1697: FND_LOG.String
1698: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1699: , 'p_user_id:' || p_user_id
1700: );
1701: FND_LOG.String
1702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1703: , 'p_login_id:' || p_login_id
1704: );
1705: FND_LOG.String

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

1698: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1699: , 'p_user_id:' || p_user_id
1700: );
1701: FND_LOG.String
1702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1703: , 'p_login_id:' || p_login_id
1704: );
1705: FND_LOG.String
1706: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1705: FND_LOG.String

1701: FND_LOG.String
1702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1703: , 'p_login_id:' || p_login_id
1704: );
1705: FND_LOG.String
1706: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1707: , 'p_transaction_control:' || p_transaction_control
1708: );
1709:

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

1702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1703: , 'p_login_id:' || p_login_id
1704: );
1705: FND_LOG.String
1706: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1707: , 'p_transaction_control:' || p_transaction_control
1708: );
1709:
1710: -- --------------------------------------------------------------------------

Line 2323: ----------------------- FND Logging -----------------------------------

2319:
2320: -- Initialize API return status to success
2321: x_return_status := FND_API.G_RET_STS_SUCCESS;
2322:
2323: ----------------------- FND Logging -----------------------------------
2324: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2325: THEN
2326: FND_LOG.String
2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

2320: -- Initialize API return status to success
2321: x_return_status := FND_API.G_RET_STS_SUCCESS;
2322:
2323: ----------------------- FND Logging -----------------------------------
2324: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2325: THEN
2326: FND_LOG.String
2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2328: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 2326: FND_LOG.String

2322:
2323: ----------------------- FND Logging -----------------------------------
2324: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2325: THEN
2326: FND_LOG.String
2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2328: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2329: );
2330: FND_LOG.String

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

2323: ----------------------- FND Logging -----------------------------------
2324: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2325: THEN
2326: FND_LOG.String
2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2328: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2329: );
2330: FND_LOG.String
2331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2330: FND_LOG.String

2326: FND_LOG.String
2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2328: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2329: );
2330: FND_LOG.String
2331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2332: , 'p_api_version:' || p_api_version
2333: );
2334: FND_LOG.String

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

2327: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2328: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2329: );
2330: FND_LOG.String
2331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2332: , 'p_api_version:' || p_api_version
2333: );
2334: FND_LOG.String
2335: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2334: FND_LOG.String

2330: FND_LOG.String
2331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2332: , 'p_api_version:' || p_api_version
2333: );
2334: FND_LOG.String
2335: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2336: , 'p_init_msg_list:' || p_init_msg_list
2337: );
2338: FND_LOG.String

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

2331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2332: , 'p_api_version:' || p_api_version
2333: );
2334: FND_LOG.String
2335: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2336: , 'p_init_msg_list:' || p_init_msg_list
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2338: FND_LOG.String

2334: FND_LOG.String
2335: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2336: , 'p_init_msg_list:' || p_init_msg_list
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2340: , 'p_commit:' || p_commit
2341: );
2342: FND_LOG.String

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

2335: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2336: , 'p_init_msg_list:' || p_init_msg_list
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2340: , 'p_commit:' || p_commit
2341: );
2342: FND_LOG.String
2343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2342: FND_LOG.String

2338: FND_LOG.String
2339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2340: , 'p_commit:' || p_commit
2341: );
2342: FND_LOG.String
2343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2344: , 'p_validation_level:' || p_validation_level
2345: );
2346: FND_LOG.String

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

2339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2340: , 'p_commit:' || p_commit
2341: );
2342: FND_LOG.String
2343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2344: , 'p_validation_level:' || p_validation_level
2345: );
2346: FND_LOG.String
2347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2346: FND_LOG.String

2342: FND_LOG.String
2343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2344: , 'p_validation_level:' || p_validation_level
2345: );
2346: FND_LOG.String
2347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2348: , 'p_resp_appl_id:' || p_resp_appl_id
2349: );
2350: FND_LOG.String

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

2343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2344: , 'p_validation_level:' || p_validation_level
2345: );
2346: FND_LOG.String
2347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2348: , 'p_resp_appl_id:' || p_resp_appl_id
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2350: FND_LOG.String

2346: FND_LOG.String
2347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2348: , 'p_resp_appl_id:' || p_resp_appl_id
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2352: , 'p_resp_id:' || p_resp_id
2353: );
2354: FND_LOG.String

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

2347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2348: , 'p_resp_appl_id:' || p_resp_appl_id
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2352: , 'p_resp_id:' || p_resp_id
2353: );
2354: FND_LOG.String
2355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2354: FND_LOG.String

2350: FND_LOG.String
2351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2352: , 'p_resp_id:' || p_resp_id
2353: );
2354: FND_LOG.String
2355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2356: , 'p_user_id:' || p_user_id
2357: );
2358: FND_LOG.String

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

2351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2352: , 'p_resp_id:' || p_resp_id
2353: );
2354: FND_LOG.String
2355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2356: , 'p_user_id:' || p_user_id
2357: );
2358: FND_LOG.String
2359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2358: FND_LOG.String

2354: FND_LOG.String
2355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2356: , 'p_user_id:' || p_user_id
2357: );
2358: FND_LOG.String
2359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2360: , 'p_login_id:' || p_login_id
2361: );
2362: FND_LOG.String

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

2355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2356: , 'p_user_id:' || p_user_id
2357: );
2358: FND_LOG.String
2359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2360: , 'p_login_id:' || p_login_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2362: FND_LOG.String

2358: FND_LOG.String
2359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2360: , 'p_login_id:' || p_login_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2364: , 'p_transaction_control:' || p_transaction_control
2365: );
2366:

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

2359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2360: , 'p_login_id:' || p_login_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2364: , 'p_transaction_control:' || p_transaction_control
2365: );
2366:
2367: -- --------------------------------------------------------------------------

Line 2941: ----------------------- FND Logging -----------------------------------

2937:
2938: --Initialize the API Return Success to True
2939: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2940:
2941: ----------------------- FND Logging -----------------------------------
2942: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2943: THEN
2944: FND_LOG.String
2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

2938: --Initialize the API Return Success to True
2939: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2940:
2941: ----------------------- FND Logging -----------------------------------
2942: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2943: THEN
2944: FND_LOG.String
2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2946: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 2944: FND_LOG.String

2940:
2941: ----------------------- FND Logging -----------------------------------
2942: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2943: THEN
2944: FND_LOG.String
2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2946: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2947: );
2948: FND_LOG.String

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

2941: ----------------------- FND Logging -----------------------------------
2942: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2943: THEN
2944: FND_LOG.String
2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2946: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2947: );
2948: FND_LOG.String
2949: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2948: FND_LOG.String

2944: FND_LOG.String
2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2946: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2947: );
2948: FND_LOG.String
2949: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2950: , 'p_api_version:' || p_api_version
2951: );
2952: FND_LOG.String

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

2945: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
2946: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2947: );
2948: FND_LOG.String
2949: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2950: , 'p_api_version:' || p_api_version
2951: );
2952: FND_LOG.String
2953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2952: FND_LOG.String

2948: FND_LOG.String
2949: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2950: , 'p_api_version:' || p_api_version
2951: );
2952: FND_LOG.String
2953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2954: , 'p_init_msg_list:' || p_init_msg_list
2955: );
2956: FND_LOG.String

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

2949: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2950: , 'p_api_version:' || p_api_version
2951: );
2952: FND_LOG.String
2953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2954: , 'p_init_msg_list:' || p_init_msg_list
2955: );
2956: FND_LOG.String
2957: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2956: FND_LOG.String

2952: FND_LOG.String
2953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2954: , 'p_init_msg_list:' || p_init_msg_list
2955: );
2956: FND_LOG.String
2957: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2958: , 'p_commit:' || p_commit
2959: );
2960: FND_LOG.String

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

2953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2954: , 'p_init_msg_list:' || p_init_msg_list
2955: );
2956: FND_LOG.String
2957: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2958: , 'p_commit:' || p_commit
2959: );
2960: FND_LOG.String
2961: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2960: FND_LOG.String

2956: FND_LOG.String
2957: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2958: , 'p_commit:' || p_commit
2959: );
2960: FND_LOG.String
2961: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2962: , 'p_validation_level:' || p_validation_level
2963: );
2964: FND_LOG.String

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

2957: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2958: , 'p_commit:' || p_commit
2959: );
2960: FND_LOG.String
2961: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2962: , 'p_validation_level:' || p_validation_level
2963: );
2964: FND_LOG.String
2965: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2964: FND_LOG.String

2960: FND_LOG.String
2961: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2962: , 'p_validation_level:' || p_validation_level
2963: );
2964: FND_LOG.String
2965: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2966: , 'p_transaction_control:' || p_transaction_control
2967: );
2968: FND_LOG.String

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

2961: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2962: , 'p_validation_level:' || p_validation_level
2963: );
2964: FND_LOG.String
2965: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2966: , 'p_transaction_control:' || p_transaction_control
2967: );
2968: FND_LOG.String
2969: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 2968: FND_LOG.String

2964: FND_LOG.String
2965: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2966: , 'p_transaction_control:' || p_transaction_control
2967: );
2968: FND_LOG.String
2969: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2970: , 'p_estimate_detail_id:' || p_estimate_detail_id
2971: );
2972:

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

2965: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2966: , 'p_transaction_control:' || p_transaction_control
2967: );
2968: FND_LOG.String
2969: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
2970: , 'p_estimate_detail_id:' || p_estimate_detail_id
2971: );
2972:
2973: END IF;

Line 3133: ----------------------- FND Logging -----------------------------------

3129:
3130: -- Initialize API return status to success
3131: x_return_status := FND_API.G_RET_STS_SUCCESS;
3132:
3133: ----------------------- FND Logging -----------------------------------
3134: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3135: THEN
3136: FND_LOG.String
3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

3130: -- Initialize API return status to success
3131: x_return_status := FND_API.G_RET_STS_SUCCESS;
3132:
3133: ----------------------- FND Logging -----------------------------------
3134: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3135: THEN
3136: FND_LOG.String
3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3138: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 3136: FND_LOG.String

3132:
3133: ----------------------- FND Logging -----------------------------------
3134: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3135: THEN
3136: FND_LOG.String
3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3138: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3139: );
3140: FND_LOG.String

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

3133: ----------------------- FND Logging -----------------------------------
3134: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3135: THEN
3136: FND_LOG.String
3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3138: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3139: );
3140: FND_LOG.String
3141: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3140: FND_LOG.String

3136: FND_LOG.String
3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3138: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3139: );
3140: FND_LOG.String
3141: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3142: , 'p_api_version:' || p_api_version
3143: );
3144: FND_LOG.String

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

3137: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3138: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3139: );
3140: FND_LOG.String
3141: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3142: , 'p_api_version:' || p_api_version
3143: );
3144: FND_LOG.String
3145: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3144: FND_LOG.String

3140: FND_LOG.String
3141: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3142: , 'p_api_version:' || p_api_version
3143: );
3144: FND_LOG.String
3145: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3146: , 'p_init_msg_list:' || p_init_msg_list
3147: );
3148: FND_LOG.String

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

3141: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3142: , 'p_api_version:' || p_api_version
3143: );
3144: FND_LOG.String
3145: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3146: , 'p_init_msg_list:' || p_init_msg_list
3147: );
3148: FND_LOG.String
3149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3148: FND_LOG.String

3144: FND_LOG.String
3145: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3146: , 'p_init_msg_list:' || p_init_msg_list
3147: );
3148: FND_LOG.String
3149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3150: , 'p_commit:' || p_commit
3151: );
3152: FND_LOG.String

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

3145: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3146: , 'p_init_msg_list:' || p_init_msg_list
3147: );
3148: FND_LOG.String
3149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3150: , 'p_commit:' || p_commit
3151: );
3152: FND_LOG.String
3153: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3152: FND_LOG.String

3148: FND_LOG.String
3149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3150: , 'p_commit:' || p_commit
3151: );
3152: FND_LOG.String
3153: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3154: , 'p_transaction_control:' || p_transaction_control
3155: );
3156: FND_LOG.String

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

3149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3150: , 'p_commit:' || p_commit
3151: );
3152: FND_LOG.String
3153: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3154: , 'p_transaction_control:' || p_transaction_control
3155: );
3156: FND_LOG.String
3157: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 3156: FND_LOG.String

3152: FND_LOG.String
3153: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3154: , 'p_transaction_control:' || p_transaction_control
3155: );
3156: FND_LOG.String
3157: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3158: , 'p_estimate_detail_id:' || p_estimate_detail_id
3159: );
3160:

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

3153: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3154: , 'p_transaction_control:' || p_transaction_control
3155: );
3156: FND_LOG.String
3157: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3158: , 'p_estimate_detail_id:' || p_estimate_detail_id
3159: );
3160:
3161: END IF;

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

5007: -- Get the Business Process Id from Service Request
5008: -- Check if the profile to get Business Process From SR = 'Y'
5009: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5010:
5011: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5012: THEN
5013: FND_LOG.String
5014: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5015: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr

Line 5013: FND_LOG.String

5009: l_def_bp_from_sr := fnd_profile.value('CS_CHG_DEFAULT_BP_FROM_SR');
5010:
5011: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5012: THEN
5013: FND_LOG.String
5014: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5015: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr
5016: );
5017: END IF;

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

5010:
5011: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5012: THEN
5013: FND_LOG.String
5014: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
5015: , 'The Value of profile CS_CHG_DEFAULT_BP_FROM_SR :' || l_def_bp_from_sr
5016: );
5017: END IF;
5018:

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

9171:
9172: --use the default from the price list
9173: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9174:
9175: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9176: THEN
9177: FND_LOG.String
9178: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9179: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id

Line 9177: FND_LOG.String

9173: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9174:
9175: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9176: THEN
9177: FND_LOG.String
9178: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9179: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9180: );
9181: END IF;

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

9174:
9175: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9176: THEN
9177: FND_LOG.String
9178: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9179: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9180: );
9181: END IF;
9182:

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

9327:
9328: --use the default from the price list
9329: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9330:
9331: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9332: THEN
9333: FND_LOG.String
9334: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9335: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id

Line 9333: FND_LOG.String

9329: x_charges_detail_rec.price_list_id := to_number(fnd_profile.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
9330:
9331: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9332: THEN
9333: FND_LOG.String
9334: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9335: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9336: );
9337: END IF;

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

9330:
9331: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
9332: THEN
9333: FND_LOG.String
9334: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
9335: , 'The Value of profile CS_CHARGE_DEFAULT_PRICE_LIST :' || x_charges_detail_rec.price_list_id
9336: );
9337: END IF;
9338:

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

14424:
14425: --DBMS_OUTPUT.PUT_LINE('Conversion Type is '||l_conversion_type);
14426: --DBMS_OUTPUT.PUT_LINE('l_max_roll_days '||l_max_roll_days);
14427:
14428: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
14429: THEN
14430: FND_LOG.String
14431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14432: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type

Line 14430: FND_LOG.String

14426: --DBMS_OUTPUT.PUT_LINE('l_max_roll_days '||l_max_roll_days);
14427:
14428: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
14429: THEN
14430: FND_LOG.String
14431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14432: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
14433: );
14434: FND_LOG.String

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

14427:
14428: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
14429: THEN
14430: FND_LOG.String
14431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14432: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
14433: );
14434: FND_LOG.String
14435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 14434: FND_LOG.String

14430: FND_LOG.String
14431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14432: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
14433: );
14434: FND_LOG.String
14435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14436: , 'The Value of profile CS_CHG_MAX_ROLL_DAYS :' || l_max_roll_days
14437: );
14438: END IF;

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

14431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14432: , 'The Value of profile CS_CHG_DEFAULT_CONVERSION_TYPE :' || l_conversion_type
14433: );
14434: FND_LOG.String
14435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
14436: , 'The Value of profile CS_CHG_MAX_ROLL_DAYS :' || l_max_roll_days
14437: );
14438: END IF;
14439:

Line 14908: FROM fnd_logins

14904: AND NVL(end_date, SYSDATE) >= SYSDATE;
14905:
14906: CURSOR c_login IS
14907: SELECT 1
14908: FROM fnd_logins
14909: WHERE login_id = p_login_id
14910: AND user_id = p_user_id;
14911:
14912: l_dummy VARCHAR2(1);

Line 14943: FROM fnd_logins

14939:
14940: IF p_login_id is not null then
14941: BEGIN
14942: SELECT 'x' into l_dummy
14943: FROM fnd_logins
14944: WHERE login_id = p_login_id
14945: AND user_id = p_user_id;
14946:
14947: EXCEPTION

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

15219:
15220: BEGIN
15221: x_return_status := FND_API.G_RET_STS_SUCCESS;
15222:
15223: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15224: THEN
15225: FND_LOG.String
15226: (
15227: FND_LOG.level_procedure

Line 15225: FND_LOG.String

15221: x_return_status := FND_API.G_RET_STS_SUCCESS;
15222:
15223: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15224: THEN
15225: FND_LOG.String
15226: (
15227: FND_LOG.level_procedure
15228: , L_LOG_MODULE || 'start'
15229: , 'Inside ' || L_API_NAME_FULL

Line 15227: FND_LOG.level_procedure

15223: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15224: THEN
15225: FND_LOG.String
15226: (
15227: FND_LOG.level_procedure
15228: , L_LOG_MODULE || 'start'
15229: , 'Inside ' || L_API_NAME_FULL
15230: || ', called with parameters below:'
15231: );

Line 15232: FND_LOG.String

15228: , L_LOG_MODULE || 'start'
15229: , 'Inside ' || L_API_NAME_FULL
15230: || ', called with parameters below:'
15231: );
15232: FND_LOG.String
15233: (
15234: FND_LOG.level_procedure
15235: , L_LOG_MODULE || 'param 1'
15236: , 'p_api_version_number:' || p_api_version_number

Line 15234: FND_LOG.level_procedure

15230: || ', called with parameters below:'
15231: );
15232: FND_LOG.String
15233: (
15234: FND_LOG.level_procedure
15235: , L_LOG_MODULE || 'param 1'
15236: , 'p_api_version_number:' || p_api_version_number
15237: );
15238: FND_LOG.String

Line 15238: FND_LOG.String

15234: FND_LOG.level_procedure
15235: , L_LOG_MODULE || 'param 1'
15236: , 'p_api_version_number:' || p_api_version_number
15237: );
15238: FND_LOG.String
15239: (
15240: FND_LOG.level_procedure
15241: , L_LOG_MODULE || 'param 2'
15242: , 'p_init_msg_list:' || p_init_msg_list

Line 15240: FND_LOG.level_procedure

15236: , 'p_api_version_number:' || p_api_version_number
15237: );
15238: FND_LOG.String
15239: (
15240: FND_LOG.level_procedure
15241: , L_LOG_MODULE || 'param 2'
15242: , 'p_init_msg_list:' || p_init_msg_list
15243: );
15244: FND_LOG.String

Line 15244: FND_LOG.String

15240: FND_LOG.level_procedure
15241: , L_LOG_MODULE || 'param 2'
15242: , 'p_init_msg_list:' || p_init_msg_list
15243: );
15244: FND_LOG.String
15245: (
15246: FND_LOG.level_procedure
15247: , L_LOG_MODULE || 'param 3'
15248: , 'p_commit:' || p_commit

Line 15246: FND_LOG.level_procedure

15242: , 'p_init_msg_list:' || p_init_msg_list
15243: );
15244: FND_LOG.String
15245: (
15246: FND_LOG.level_procedure
15247: , L_LOG_MODULE || 'param 3'
15248: , 'p_commit:' || p_commit
15249: );
15250: FND_LOG.String

Line 15250: FND_LOG.String

15246: FND_LOG.level_procedure
15247: , L_LOG_MODULE || 'param 3'
15248: , 'p_commit:' || p_commit
15249: );
15250: FND_LOG.String
15251: (
15252: FND_LOG.level_procedure
15253: , L_LOG_MODULE || 'param 4'
15254: , 'p_object_type:' || p_object_type

Line 15252: FND_LOG.level_procedure

15248: , 'p_commit:' || p_commit
15249: );
15250: FND_LOG.String
15251: (
15252: FND_LOG.level_procedure
15253: , L_LOG_MODULE || 'param 4'
15254: , 'p_object_type:' || p_object_type
15255: );
15256: FND_LOG.String

Line 15256: FND_LOG.String

15252: FND_LOG.level_procedure
15253: , L_LOG_MODULE || 'param 4'
15254: , 'p_object_type:' || p_object_type
15255: );
15256: FND_LOG.String
15257: (
15258: FND_LOG.level_procedure
15259: , L_LOG_MODULE || 'param 5'
15260: , 'p_processing_set_id:' || p_processing_set_id

Line 15258: FND_LOG.level_procedure

15254: , 'p_object_type:' || p_object_type
15255: );
15256: FND_LOG.String
15257: (
15258: FND_LOG.level_procedure
15259: , L_LOG_MODULE || 'param 5'
15260: , 'p_processing_set_id:' || p_processing_set_id
15261: );
15262: END IF ;

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

15287: ------------------------------------------------------------------------------
15288:
15289: IF NVL(p_object_type, 'X') <> 'SR'
15290: THEN
15291: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15292: THEN
15293: FND_LOG.String
15294: (
15295: FND_LOG.level_unexpected

Line 15293: FND_LOG.String

15289: IF NVL(p_object_type, 'X') <> 'SR'
15290: THEN
15291: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15292: THEN
15293: FND_LOG.String
15294: (
15295: FND_LOG.level_unexpected
15296: , L_LOG_MODULE || 'object_type_invalid'
15297: , 'p_object_type has to be SR.'

Line 15295: FND_LOG.level_unexpected

15291: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15292: THEN
15293: FND_LOG.String
15294: (
15295: FND_LOG.level_unexpected
15296: , L_LOG_MODULE || 'object_type_invalid'
15297: , 'p_object_type has to be SR.'
15298: );
15299: END IF ;

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

15310: ---
15311:
15312: IF p_processing_set_id IS NULL
15313: THEN
15314: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15315: THEN
15316: FND_LOG.String
15317: (
15318: FND_LOG.level_unexpected

Line 15316: FND_LOG.String

15312: IF p_processing_set_id IS NULL
15313: THEN
15314: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15315: THEN
15316: FND_LOG.String
15317: (
15318: FND_LOG.level_unexpected
15319: , L_LOG_MODULE || 'proc_set_id_invalid'
15320: , 'p_processing_set_id should not be NULL.'

Line 15318: FND_LOG.level_unexpected

15314: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15315: THEN
15316: FND_LOG.String
15317: (
15318: FND_LOG.level_unexpected
15319: , L_LOG_MODULE || 'proc_set_id_invalid'
15320: , 'p_processing_set_id should not be NULL.'
15321: );
15322: END IF ;

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

15333: ------------------------------------------------------------------------------
15334: -- Actual Logic starts below:
15335: ------------------------------------------------------------------------------
15336:
15337: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15338: THEN
15339: FND_LOG.String
15340: (
15341: FND_LOG.level_statement

Line 15339: FND_LOG.String

15335: ------------------------------------------------------------------------------
15336:
15337: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15338: THEN
15339: FND_LOG.String
15340: (
15341: FND_LOG.level_statement
15342: , L_LOG_MODULE || 'valid_chg_line_start'
15343: , 'validating charge lines against SRs in the global temp table'

Line 15341: FND_LOG.level_statement

15337: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15338: THEN
15339: FND_LOG.String
15340: (
15341: FND_LOG.level_statement
15342: , L_LOG_MODULE || 'valid_chg_line_start'
15343: , 'validating charge lines against SRs in the global temp table'
15344: );
15345: END IF ;

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

15375: AND processing_set_id = p_processing_set_id;
15376:
15377: l_row_count := SQL%ROWCOUNT;
15378:
15379: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15380: THEN
15381: FND_LOG.String
15382: (
15383: FND_LOG.level_statement

Line 15381: FND_LOG.String

15377: l_row_count := SQL%ROWCOUNT;
15378:
15379: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15380: THEN
15381: FND_LOG.String
15382: (
15383: FND_LOG.level_statement
15384: , L_LOG_MODULE || 'valid_chg_line_end'
15385: , 'after validating charge lines against SRs in the global temp table '

Line 15383: FND_LOG.level_statement

15379: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15380: THEN
15381: FND_LOG.String
15382: (
15383: FND_LOG.level_statement
15384: , L_LOG_MODULE || 'valid_chg_line_end'
15385: , 'after validating charge lines against SRs in the global temp table '
15386: || l_row_count || ' rows failed validation'
15387: );

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

15388: END IF ;
15389:
15390: ---
15391:
15392: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15393: THEN
15394: FND_LOG.String
15395: (
15396: FND_LOG.level_procedure

Line 15394: FND_LOG.String

15390: ---
15391:
15392: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15393: THEN
15394: FND_LOG.String
15395: (
15396: FND_LOG.level_procedure
15397: , L_LOG_MODULE || 'end'
15398: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'

Line 15396: FND_LOG.level_procedure

15392: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15393: THEN
15394: FND_LOG.String
15395: (
15396: FND_LOG.level_procedure
15397: , L_LOG_MODULE || 'end'
15398: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'
15399: );
15400: END IF ;

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

15402: EXCEPTION
15403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15405:
15406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15407: THEN
15408: FND_LOG.String
15409: (
15410: FND_LOG.level_unexpected

Line 15408: FND_LOG.String

15404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15405:
15406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15407: THEN
15408: FND_LOG.String
15409: (
15410: FND_LOG.level_unexpected
15411: , L_LOG_MODULE || 'unexpected_error'
15412: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 15410: FND_LOG.level_unexpected

15406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15407: THEN
15408: FND_LOG.String
15409: (
15410: FND_LOG.level_unexpected
15411: , L_LOG_MODULE || 'unexpected_error'
15412: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
15413: );
15414: END IF ;

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

15419: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
15420: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
15421: FND_MSG_PUB.ADD;
15422:
15423: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15424: THEN
15425: FND_LOG.String
15426: (
15427: FND_LOG.level_unexpected

Line 15425: FND_LOG.String

15421: FND_MSG_PUB.ADD;
15422:
15423: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15424: THEN
15425: FND_LOG.String
15426: (
15427: FND_LOG.level_unexpected
15428: , L_LOG_MODULE || 'when_others'
15429: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'

Line 15427: FND_LOG.level_unexpected

15423: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15424: THEN
15425: FND_LOG.String
15426: (
15427: FND_LOG.level_unexpected
15428: , L_LOG_MODULE || 'when_others'
15429: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15430: );
15431: FND_LOG.String

Line 15431: FND_LOG.String

15427: FND_LOG.level_unexpected
15428: , L_LOG_MODULE || 'when_others'
15429: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15430: );
15431: FND_LOG.String
15432: (
15433: FND_LOG.level_unexpected
15434: , L_LOG_MODULE || 'when_others'
15435: , SQLERRM

Line 15433: FND_LOG.level_unexpected

15429: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15430: );
15431: FND_LOG.String
15432: (
15433: FND_LOG.level_unexpected
15434: , L_LOG_MODULE || 'when_others'
15435: , SQLERRM
15436: );
15437: END IF ;

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

15486:
15487: BEGIN
15488: x_return_status := FND_API.G_RET_STS_SUCCESS;
15489:
15490: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15491: THEN
15492: FND_LOG.String
15493: (
15494: FND_LOG.level_procedure

Line 15492: FND_LOG.String

15488: x_return_status := FND_API.G_RET_STS_SUCCESS;
15489:
15490: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15491: THEN
15492: FND_LOG.String
15493: (
15494: FND_LOG.level_procedure
15495: , L_LOG_MODULE || 'start'
15496: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 15494: FND_LOG.level_procedure

15490: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15491: THEN
15492: FND_LOG.String
15493: (
15494: FND_LOG.level_procedure
15495: , L_LOG_MODULE || 'start'
15496: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
15497: );
15498: FND_LOG.String

Line 15498: FND_LOG.String

15494: FND_LOG.level_procedure
15495: , L_LOG_MODULE || 'start'
15496: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
15497: );
15498: FND_LOG.String
15499: (
15500: FND_LOG.level_procedure
15501: , L_LOG_MODULE || 'param 1'
15502: , 'p_api_version_number:' || p_api_version_number

Line 15500: FND_LOG.level_procedure

15496: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
15497: );
15498: FND_LOG.String
15499: (
15500: FND_LOG.level_procedure
15501: , L_LOG_MODULE || 'param 1'
15502: , 'p_api_version_number:' || p_api_version_number
15503: );
15504: FND_LOG.String

Line 15504: FND_LOG.String

15500: FND_LOG.level_procedure
15501: , L_LOG_MODULE || 'param 1'
15502: , 'p_api_version_number:' || p_api_version_number
15503: );
15504: FND_LOG.String
15505: (
15506: FND_LOG.level_procedure
15507: , L_LOG_MODULE || 'param 2'
15508: , 'p_init_msg_list:' || p_init_msg_list

Line 15506: FND_LOG.level_procedure

15502: , 'p_api_version_number:' || p_api_version_number
15503: );
15504: FND_LOG.String
15505: (
15506: FND_LOG.level_procedure
15507: , L_LOG_MODULE || 'param 2'
15508: , 'p_init_msg_list:' || p_init_msg_list
15509: );
15510: FND_LOG.String

Line 15510: FND_LOG.String

15506: FND_LOG.level_procedure
15507: , L_LOG_MODULE || 'param 2'
15508: , 'p_init_msg_list:' || p_init_msg_list
15509: );
15510: FND_LOG.String
15511: (
15512: FND_LOG.level_procedure
15513: , L_LOG_MODULE || 'param 3'
15514: , 'p_commit:' || p_commit

Line 15512: FND_LOG.level_procedure

15508: , 'p_init_msg_list:' || p_init_msg_list
15509: );
15510: FND_LOG.String
15511: (
15512: FND_LOG.level_procedure
15513: , L_LOG_MODULE || 'param 3'
15514: , 'p_commit:' || p_commit
15515: );
15516: FND_LOG.String

Line 15516: FND_LOG.String

15512: FND_LOG.level_procedure
15513: , L_LOG_MODULE || 'param 3'
15514: , 'p_commit:' || p_commit
15515: );
15516: FND_LOG.String
15517: (
15518: FND_LOG.level_procedure
15519: , L_LOG_MODULE || 'param 4'
15520: , 'p_object_type:' || p_object_type

Line 15518: FND_LOG.level_procedure

15514: , 'p_commit:' || p_commit
15515: );
15516: FND_LOG.String
15517: (
15518: FND_LOG.level_procedure
15519: , L_LOG_MODULE || 'param 4'
15520: , 'p_object_type:' || p_object_type
15521: );
15522: FND_LOG.String

Line 15522: FND_LOG.String

15518: FND_LOG.level_procedure
15519: , L_LOG_MODULE || 'param 4'
15520: , 'p_object_type:' || p_object_type
15521: );
15522: FND_LOG.String
15523: (
15524: FND_LOG.level_procedure
15525: , L_LOG_MODULE || 'param 5'
15526: , 'p_processing_set_id:' || p_processing_set_id

Line 15524: FND_LOG.level_procedure

15520: , 'p_object_type:' || p_object_type
15521: );
15522: FND_LOG.String
15523: (
15524: FND_LOG.level_procedure
15525: , L_LOG_MODULE || 'param 5'
15526: , 'p_processing_set_id:' || p_processing_set_id
15527: );
15528: END IF ;

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

15553: ------------------------------------------------------------------------------
15554:
15555: IF NVL(p_object_type, 'X') <> 'SR'
15556: THEN
15557: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15558: THEN
15559: FND_LOG.String
15560: (
15561: FND_LOG.level_unexpected

Line 15559: FND_LOG.String

15555: IF NVL(p_object_type, 'X') <> 'SR'
15556: THEN
15557: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15558: THEN
15559: FND_LOG.String
15560: (
15561: FND_LOG.level_unexpected
15562: , L_LOG_MODULE || 'object_type_invalid'
15563: , 'p_object_type has to be SR.'

Line 15561: FND_LOG.level_unexpected

15557: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15558: THEN
15559: FND_LOG.String
15560: (
15561: FND_LOG.level_unexpected
15562: , L_LOG_MODULE || 'object_type_invalid'
15563: , 'p_object_type has to be SR.'
15564: );
15565: END IF ;

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

15576: ---
15577:
15578: IF p_processing_set_id IS NULL
15579: THEN
15580: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15581: THEN
15582: FND_LOG.String
15583: (
15584: FND_LOG.level_unexpected

Line 15582: FND_LOG.String

15578: IF p_processing_set_id IS NULL
15579: THEN
15580: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15581: THEN
15582: FND_LOG.String
15583: (
15584: FND_LOG.level_unexpected
15585: , L_LOG_MODULE || 'proc_set_id_invalid'
15586: , 'p_processing_set_id should not be NULL.'

Line 15584: FND_LOG.level_unexpected

15580: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15581: THEN
15582: FND_LOG.String
15583: (
15584: FND_LOG.level_unexpected
15585: , L_LOG_MODULE || 'proc_set_id_invalid'
15586: , 'p_processing_set_id should not be NULL.'
15587: );
15588: END IF ;

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

15599: ------------------------------------------------------------------------------
15600: -- Actual Logic starts below:
15601: ------------------------------------------------------------------------------
15602:
15603: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15604: THEN
15605: FND_LOG.String
15606: (
15607: FND_LOG.level_statement

Line 15605: FND_LOG.String

15601: ------------------------------------------------------------------------------
15602:
15603: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15604: THEN
15605: FND_LOG.String
15606: (
15607: FND_LOG.level_statement
15608: , L_LOG_MODULE || 'del_chg_line_start'
15609: , 'deleting charge lines against SRs in the global temp table'

Line 15607: FND_LOG.level_statement

15603: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15604: THEN
15605: FND_LOG.String
15606: (
15607: FND_LOG.level_statement
15608: , L_LOG_MODULE || 'del_chg_line_start'
15609: , 'deleting charge lines against SRs in the global temp table'
15610: );
15611: END IF ;

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

15628: );
15629:
15630: l_row_count := SQL%ROWCOUNT;
15631:
15632: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15633: THEN
15634: FND_LOG.String
15635: (
15636: FND_LOG.level_statement

Line 15634: FND_LOG.String

15630: l_row_count := SQL%ROWCOUNT;
15631:
15632: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15633: THEN
15634: FND_LOG.String
15635: (
15636: FND_LOG.level_statement
15637: , L_LOG_MODULE || 'del_chg_line_end'
15638: , 'after deleting charge lines against SRs in the global temp table'

Line 15636: FND_LOG.level_statement

15632: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
15633: THEN
15634: FND_LOG.String
15635: (
15636: FND_LOG.level_statement
15637: , L_LOG_MODULE || 'del_chg_line_end'
15638: , 'after deleting charge lines against SRs in the global temp table'
15639: || l_row_count || ' rows deleted.'
15640: );

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

15641: END IF ;
15642:
15643: ---
15644:
15645: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15646: THEN
15647: FND_LOG.String
15648: (
15649: FND_LOG.level_procedure

Line 15647: FND_LOG.String

15643: ---
15644:
15645: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15646: THEN
15647: FND_LOG.String
15648: (
15649: FND_LOG.level_procedure
15650: , L_LOG_MODULE || 'end'
15651: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'

Line 15649: FND_LOG.level_procedure

15645: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
15646: THEN
15647: FND_LOG.String
15648: (
15649: FND_LOG.level_procedure
15650: , L_LOG_MODULE || 'end'
15651: , 'Completed work in ' || L_API_NAME_FULL || ' successfully'
15652: );
15653: END IF ;

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

15655: EXCEPTION
15656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15658:
15659: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15660: THEN
15661: FND_LOG.String
15662: (
15663: FND_LOG.level_unexpected

Line 15661: FND_LOG.String

15657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15658:
15659: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15660: THEN
15661: FND_LOG.String
15662: (
15663: FND_LOG.level_unexpected
15664: , L_LOG_MODULE || 'unexpected_error'
15665: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 15663: FND_LOG.level_unexpected

15659: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15660: THEN
15661: FND_LOG.String
15662: (
15663: FND_LOG.level_unexpected
15664: , L_LOG_MODULE || 'unexpected_error'
15665: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
15666: );
15667: END IF ;

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

15672: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
15673: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
15674: FND_MSG_PUB.ADD;
15675:
15676: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15677: THEN
15678: FND_LOG.String
15679: (
15680: FND_LOG.level_unexpected

Line 15678: FND_LOG.String

15674: FND_MSG_PUB.ADD;
15675:
15676: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15677: THEN
15678: FND_LOG.String
15679: (
15680: FND_LOG.level_unexpected
15681: , L_LOG_MODULE || 'when_others'
15682: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'

Line 15680: FND_LOG.level_unexpected

15676: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
15677: THEN
15678: FND_LOG.String
15679: (
15680: FND_LOG.level_unexpected
15681: , L_LOG_MODULE || 'when_others'
15682: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15683: );
15684: FND_LOG.String

Line 15684: FND_LOG.String

15680: FND_LOG.level_unexpected
15681: , L_LOG_MODULE || 'when_others'
15682: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15683: );
15684: FND_LOG.String
15685: (
15686: FND_LOG.level_unexpected
15687: , L_LOG_MODULE || 'when_others'
15688: , SQLERRM

Line 15686: FND_LOG.level_unexpected

15682: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
15683: );
15684: FND_LOG.String
15685: (
15686: FND_LOG.level_unexpected
15687: , L_LOG_MODULE || 'when_others'
15688: , SQLERRM
15689: );
15690: END IF ;