APPS.AHL_RM_ROUTE_PVT dependencies on FND_LOG

Line 2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2035: x_return_status => x_return_status
2036: );
2037:
2038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2040: fnd_log.string
2041: (
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2040: fnd_log.string

2036: );
2037:
2038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2040: fnd_log.string
2041: (
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2044: 'Error in converting Route Number, Route Revision to ID'

Line 2042: fnd_log.level_statement,

2038: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2040: fnd_log.string
2041: (
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2044: 'Error in converting Route Number, Route Revision to ID'
2045: );
2046: END IF;

Line 2301: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2297: IF ( SQLCODE = -1 ) THEN
2298: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2299: FND_MSG_PUB.add;
2300: ELSE
2301: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2302: fnd_log.string
2303: (
2304: fnd_log.level_unexpected,
2305: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 2302: fnd_log.string

2298: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2299: FND_MSG_PUB.add;
2300: ELSE
2301: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2302: fnd_log.string
2303: (
2304: fnd_log.level_unexpected,
2305: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2306: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

Line 2304: fnd_log.level_unexpected,

2300: ELSE
2301: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2302: fnd_log.string
2303: (
2304: fnd_log.level_unexpected,
2305: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2306: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
2307: );
2308: END IF;

Line 2396: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2392: IF ( SQLCODE = -1 ) THEN
2393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2394: FND_MSG_PUB.add;
2395: ELSE
2396: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2397: fnd_log.string
2398: (
2399: fnd_log.level_unexpected,
2400: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 2397: fnd_log.string

2393: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2394: FND_MSG_PUB.add;
2395: ELSE
2396: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2397: fnd_log.string
2398: (
2399: fnd_log.level_unexpected,
2400: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2401: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'

Line 2399: fnd_log.level_unexpected,

2395: ELSE
2396: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2397: fnd_log.string
2398: (
2399: fnd_log.level_unexpected,
2400: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2401: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'
2402: );
2403: END IF;

Line 3200: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

3196: IF ( SQLCODE = -1 ) THEN
3197: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3198: FND_MSG_PUB.add;
3199: ELSE
3200: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3201: fnd_log.string
3202: (
3203: fnd_log.level_unexpected,
3204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 3201: fnd_log.string

3197: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3198: FND_MSG_PUB.add;
3199: ELSE
3200: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3201: fnd_log.string
3202: (
3203: fnd_log.level_unexpected,
3204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3205: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

Line 3203: fnd_log.level_unexpected,

3199: ELSE
3200: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3201: fnd_log.string
3202: (
3203: fnd_log.level_unexpected,
3204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3205: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
3206: );
3207: END IF;