APPS.AHL_RM_ROUTE_PVT dependencies on FND_LOG

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

2334: x_return_status => x_return_status
2335: );
2336:
2337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_statement,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2339: fnd_log.string

2335: );
2336:
2337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_statement,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2343: 'Error in converting Route Number, Route Revision to ID'

Line 2341: fnd_log.level_statement,

2337: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_statement,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2343: 'Error in converting Route Number, Route Revision to ID'
2344: );
2345: END IF;

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

2606: IF ( SQLCODE = -1 ) THEN
2607: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2608: FND_MSG_PUB.add;
2609: ELSE
2610: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_unexpected,
2614: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 2611: fnd_log.string

2607: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2608: FND_MSG_PUB.add;
2609: ELSE
2610: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_unexpected,
2614: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2615: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

Line 2613: fnd_log.level_unexpected,

2609: ELSE
2610: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_unexpected,
2614: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2615: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
2616: );
2617: END IF;

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

2711: IF ( SQLCODE = -1 ) THEN
2712: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2713: FND_MSG_PUB.add;
2714: ELSE
2715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2716: fnd_log.string
2717: (
2718: fnd_log.level_unexpected,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 2716: fnd_log.string

2712: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
2713: FND_MSG_PUB.add;
2714: ELSE
2715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2716: fnd_log.string
2717: (
2718: fnd_log.level_unexpected,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2720: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'

Line 2718: fnd_log.level_unexpected,

2714: ELSE
2715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2716: fnd_log.string
2717: (
2718: fnd_log.level_unexpected,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2720: 'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'
2721: );
2722: END IF;

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

3613: IF ( SQLCODE = -1 ) THEN
3614: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3615: FND_MSG_PUB.add;
3616: ELSE
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 3618: fnd_log.string

3614: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_NO_DUP' );
3615: FND_MSG_PUB.add;
3616: ELSE
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3622: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'

Line 3620: fnd_log.level_unexpected,

3616: ELSE
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3622: 'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
3623: );
3624: END IF;