828: x_operation_id => p_x_route_operation_tbl(i).operation_id,
829: x_return_status => x_return_status
830: );
831: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
833: fnd_log.string
834: (
835: fnd_log.level_statement,
836: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
829: x_return_status => x_return_status
830: );
831: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
833: fnd_log.string
834: (
835: fnd_log.level_statement,
836: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
837: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
831: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
833: fnd_log.string
834: (
835: fnd_log.level_statement,
836: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
837: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
838: );
839: END IF;
1049: IF ( SQLCODE = -1 ) THEN
1050: FND_MESSAGE.set_token( 'FIELD', 'INSERT : ' || to_char(p_x_route_operation_tbl(i).step) );
1051: ELSE
1052: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );
1053: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1054: THEN
1055: fnd_log.string
1056: (
1057: fnd_log.level_unexpected,
1051: ELSE
1052: FND_MESSAGE.set_token( 'FIELD', 'OTHER : ' || to_char(p_x_route_operation_tbl(i).step) );
1053: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1054: THEN
1055: fnd_log.string
1056: (
1057: fnd_log.level_unexpected,
1058: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1059: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1053: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1054: THEN
1055: fnd_log.string
1056: (
1057: fnd_log.level_unexpected,
1058: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
1059: 'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
1060: );
1061: END IF;