445: THEN
446: SELECT program_type_code INTO l_mr_prog_type FROM ahl_mr_headers_app_v WHERE mr_header_id = p_x_mr_route_rec.mr_header_id;
447: SELECT route_type_code INTO l_route_type FROM ahl_routes_app_v WHERE route_id = p_x_mr_route_rec.route_id;
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
450: THEN
451: fnd_log.string
452: (
453: fnd_log.level_statement,
447: SELECT route_type_code INTO l_route_type FROM ahl_routes_app_v WHERE route_id = p_x_mr_route_rec.route_id;
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
450: THEN
451: fnd_log.string
452: (
453: fnd_log.level_statement,
454: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
455: 'l_mr_prog_type='||l_mr_prog_type||' - l_route_type='||l_route_type
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
450: THEN
451: fnd_log.string
452: (
453: fnd_log.level_statement,
454: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
455: 'l_mr_prog_type='||l_mr_prog_type||' - l_route_type='||l_route_type
456: );
457: END IF;
606: x_mr_header_id => p_x_mr_route_tbl(i).mr_header_id,
607: x_return_status => x_return_status
608: );
609: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
607: x_return_status => x_return_status
608: );
609: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'Invalid MR Title, Version Number provided'
609: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
611: fnd_log.string
612: (
613: fnd_log.level_statement,
614: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
615: 'Invalid MR Title, Version Number provided'
616: );
617: END IF;