APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 361: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,

357:
358: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011
359: -- To validate whether the passed stages have any predessor stage in planning status
360: PROCEDURE Validate_Stage_Predecessors ( p_visit_id IN NUMBER,
361: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
362: x_has_pre_in_planning OUT NOCOPY VARCHAR2);
363:
364: -- SATRAJEN :: Bug 12990261 :: FUnction to sum up all the error messages :: Jun 2012.
365: -- Same functionality as the procedure Validate_MR_Route_Date except for raising the error messages in the same place.

Line 14391: fnd_log.string(l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API','Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');

14387: END IF;
14388:
14389: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: START
14390: IF (l_log_statement >= l_log_current_level) THEN
14391: fnd_log.string(l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API','Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
14392: END IF;
14393:
14394: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,
14395: x_return_status => l_return_status,

Line 14394: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,

14390: IF (l_log_statement >= l_log_current_level) THEN
14391: fnd_log.string(l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API','Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
14392: END IF;
14393:
14394: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => p_visit_id,
14395: x_return_status => l_return_status,
14396: x_msg_count => l_msg_count,
14397: x_msg_data => l_msg_data);
14398:

Line 14400: fnd_log.string(l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API','After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);

14396: x_msg_count => l_msg_count,
14397: x_msg_data => l_msg_data);
14398:
14399: IF (l_log_statement >= l_log_current_level) THEN
14400: fnd_log.string(l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API','After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);
14401: END IF;
14402:
14403: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
14404: x_msg_count := l_msg_count;

Line 14497: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,

14493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14494: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
14495: p_module_type IN VARCHAR2 := Null,
14496: p_visit_id IN NUMBER,
14497: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
14498: p_release_flag IN VARCHAR2 ,
14499: x_return_status OUT NOCOPY VARCHAR2,
14500: x_msg_count OUT NOCOPY NUMBER,
14501: x_msg_data OUT NOCOPY VARCHAR2

Line 15410: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,

15406: -- This API is not fool-proof as it does not consider parallel rules when
15407: -- in the hierarchy, the object_id of the parallel rule is treated as parent and subject_id as child
15408: -- Ideally, for parallel rules, object_id can be treated as child and subject_id as parent OR vice-versa
15409: PROCEDURE Validate_Stage_Predecessors ( p_visit_id IN NUMBER,
15410: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
15411: x_has_pre_in_planning OUT NOCOPY VARCHAR2)
15412: IS
15413:
15414: L_API_NAME CONSTANT VARCHAR2(30) := 'BG_Release_Visit';