APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VWP_PROJ_PROD_PVT

Line 1035: 'Before calling ahl vwp proj prod pvt.release visit'

1031: fnd_log.string
1032: (
1033: fnd_log.level_procedure,
1034: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1035: 'Before calling ahl vwp proj prod pvt.release visit'
1036: );
1037: END IF;
1038:
1039: --salogan::Added release flag parameter based on the module type BG/Standard CP ER 9299910::01-JUN-2009::BEGIN

Line 1044: ahl_vwp_proj_prod_pvt.release_visit (

1040: IF (p_module_type = l_bg_module_type) THEN
1041: l_bg_release_flag := 'U';
1042: END IF;
1043:
1044: ahl_vwp_proj_prod_pvt.release_visit (
1045: p_api_version => l_api_version,
1046: p_init_msg_list => p_init_msg_list,
1047: p_commit => l_commit,
1048: p_validation_level => p_validation_level,

Line 1063: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

1059: fnd_log.string
1060: (
1061: fnd_log.level_procedure,
1062: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1063: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
1064: );
1065: END IF;
1066:
1067: -- Check Error Message stack.

Line 2965: 'Before calling ahl vwp proj prod pvt.release visit'

2961: fnd_log.string
2962: (
2963: fnd_log.level_statement,
2964: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2965: 'Before calling ahl vwp proj prod pvt.release visit'
2966: );
2967: END IF;
2968:
2969: AHL_VWP_PROJ_PROD_PVT.release_visit

Line 2969: AHL_VWP_PROJ_PROD_PVT.release_visit

2965: 'Before calling ahl vwp proj prod pvt.release visit'
2966: );
2967: END IF;
2968:
2969: AHL_VWP_PROJ_PROD_PVT.release_visit
2970: (
2971: p_api_version =>l_api_version,
2972: p_init_msg_list =>Fnd_Api.g_false,
2973: p_commit =>Fnd_Api.g_false,

Line 2987: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

2983: fnd_log.string
2984: (
2985: fnd_log.level_statement,
2986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2987: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
2988: );
2989: END IF;
2990:
2991: -- Check Error Message stack.

Line 3483: -- Master workorder not found then call ahl_vwp_proj_prod_pvt.release_visit

3479: 'Visit Master Workorder Id : ' || l_master_wo_rec.workorder_id
3480: );
3481: END IF;
3482:
3483: -- Master workorder not found then call ahl_vwp_proj_prod_pvt.release_visit
3484: IF l_master_wo_rec.workorder_id IS NULL THEN
3485:
3486: l_release_visit_required := 'Y';
3487:

Line 3597: l_Error_Tbl_Type AHL_VWP_PROJ_PROD_PVT.Error_Tbl_Type;

3593: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3594: l_msg_data VARCHAR2(2000);
3595: l_return_status VARCHAR2(1);
3596: l_msg_count NUMBER;
3597: l_Error_Tbl_Type AHL_VWP_PROJ_PROD_PVT.Error_Tbl_Type;
3598: l_req_id NUMBER;
3599: l_curr_org_id NUMBER;
3600: l_visit_num NUMBER;
3601: l_visit_status VARCHAR2(20);

Line 3682: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production');

3678: -- Validate visit if required
3679: IF l_visit_status IS NOT NULL AND l_visit_status <> 'RELEASED' THEN
3680:
3681: IF (l_log_statement >= l_log_current_level)THEN
3682: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production');
3683: END IF;
3684:
3685: --Valdate before Cost Estimation happens
3686: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

Line 3686: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production

3682: fnd_log.string (l_log_statement,L_DEBUG_KEY, 'Before Calling AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production');
3683: END IF;
3684:
3685: --Valdate before Cost Estimation happens
3686: AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production
3687: (p_api_version => p_api_version,
3688: p_init_msg_list => p_init_msg_list,
3689: p_commit => FND_API.G_FALSE,
3690: p_validation_level => p_validation_level,

Line 3703: fnd_log.string ( l_log_statement, L_DEBUG_KEY,'Errors from AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - '||x_msg_count);

3699: -- Check Error Message stack.
3700: x_msg_count := FND_MSG_PUB.count_msg;
3701:
3702: IF (l_log_statement >= l_log_current_level)THEN
3703: fnd_log.string ( l_log_statement, L_DEBUG_KEY,'Errors from AHL_VWP_PROJ_PROD_PVT.Validate_Before_Production - '||x_msg_count);
3704: END IF;
3705: RAISE Fnd_Api.g_exc_error;
3706: END IF;
3707: END IF;