DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 2529: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES');

2525: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_rec.visit_id);
2526: IF (l_is_comp_visit = 'N') THEN
2527:
2528: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2529: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES');
2530: END IF;
2531:
2532: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
2533: -- The below call is no more needed since going forward default stages need not be created during visit creation

Line 2535: /*AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES

2531:
2532: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
2533: -- The below call is no more needed since going forward default stages need not be created during visit creation
2534: -----CREATE STAGES IF VISIT HAS BEEN CREATED SUCESSFULLY--------
2535: /*AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES
2536: ( p_api_version => p_api_version,
2537: p_init_msg_list => p_init_msg_list,
2538: p_commit => Fnd_Api.g_false,
2539: p_validation_level => p_validation_level,

Line 2548: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES - x_return_status : '||x_return_status);

2544: x_msg_data => x_msg_data
2545: );
2546:
2547: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2548: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.CREATE_STAGES - x_return_status : '||x_return_status);
2549: END IF;
2550: */
2551:
2552: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: START

Line 2602: -- Swapped the below two calls AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit and AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS

2598: IF l_Visit_rec.visit_type_code IS NOT NULL
2599: AND l_Visit_rec.visit_type_code <> FND_API.G_MISS_CHAR THEN
2600:
2601: -- TCHIMIRA :: BUG 13991270 :: 26-Apr-2012
2602: -- Swapped the below two calls AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit and AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS
2603: -- First we need to create stages and then associate default MRs to the visit during visit creation.
2604:
2605: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
2606: * There is no need for handling anything related to Stages for Component Visits

Line 2615: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit');

2611: --VWPE ER-12424063:: tchimira :: 15-FEB -2011 :: start
2612: -- since the visit type code is not null during creation of a visit, call the associate visit type to visit procedure
2613: -- This procedure creates stages, stage tasks, stage rules and stage-stage type association in a visit
2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit');
2616: END IF;
2617:
2618: AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit (
2619: p_api_version => 1.0,

Line 2618: AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit (

2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit');
2616: END IF;
2617:
2618: AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit (
2619: p_api_version => 1.0,
2620: p_init_msg_list => fnd_api.g_false,
2621: p_commit => fnd_api.g_false,
2622: p_validation_level => p_validation_level,

Line 2630: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit - l_return_status : '||l_return_status);

2626: x_msg_count => x_msg_count,
2627: x_msg_data => x_msg_data
2628: );
2629: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2630: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit - l_return_status : '||l_return_status);
2631: END IF;
2632:
2633:
2634: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

Line 4634: AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit (

4630: -- This procedure creates stages, stage tasks, stage rules and stage-stage type association in a visit
4631: IF c_visit_rec.status_code = 'DRAFT' THEN
4632: IF l_Visit_rec.VISIT_TYPE_CODE IS NOT NULL AND c_Visit_rec.visit_type_code IS NULL THEN
4633: IF l_is_old_visit_dets.IS_OLD_VISIT <> 'Y' THEN -- PRAKKUM :: 28-JUN-2011 :: VWPE :: ER 12730539 :: IF not an old visit
4634: AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit (
4635: p_api_version => 1.0,
4636: p_init_msg_list => fnd_api.g_false,
4637: p_commit => fnd_api.g_false,
4638: p_validation_level => p_validation_level,

Line 4646: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - After calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit - l_return_status : '||l_return_status);

4642: x_msg_count => x_msg_count,
4643: x_msg_data => x_msg_data
4644: );
4645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4646: fnd_log.string(fnd_log.level_statement,L_DEBUG,'TASK - After calling AHL_VWP_VISITS_STAGES_PVT.Assoc_VisitType_to_Visit - l_return_status : '||l_return_status);
4647: END IF;
4648:
4649: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4650: RAISE Fnd_Api.g_exc_unexpected_error;

Line 4717: AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_HIERARICHY (

4713: IF l_is_start_date_changed OR l_is_dept_changed THEN -- If start date or department changed, then need to update all stage dates
4714:
4715: l_stages_ovn_updated_count := l_stages_ovn_updated_count+1;--prakkum :: 06-JUL-2011 :: VWPE 12730539 :: All stages are updated to new dates
4716:
4717: AHL_VWP_VISITS_STAGES_PVT.UPDATE_STAGES_HIERARICHY (
4718: p_api_version => p_api_version,
4719: p_init_msg_list => Fnd_Api.g_false,
4720: p_commit => Fnd_Api.g_false,
4721: p_validation_level => p_validation_level,

Line 4733: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');

4729: ELSIF l_is_close_date_changed THEN -- On visit end change, validate stage dates against visit end date
4730:
4731: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: START
4732: IF (l_log_statement >= l_log_current_level) THEN
4733: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
4734: END IF;
4735:
4736: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => l_Visit_rec.visit_id,
4737: x_return_status => l_return_status,

Line 4736: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => l_Visit_rec.visit_id,

4732: IF (l_log_statement >= l_log_current_level) THEN
4733: fnd_log.string(l_log_statement,L_DEBUG,'Before calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES ');
4734: END IF;
4735:
4736: AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES( p_visit_id => l_Visit_rec.visit_id,
4737: x_return_status => l_return_status,
4738: x_msg_count => l_msg_count,
4739: x_msg_data => l_msg_data);
4740:

Line 4742: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);

4738: x_msg_count => l_msg_count,
4739: x_msg_data => l_msg_data);
4740:
4741: IF (l_log_statement >= l_log_current_level) THEN
4742: fnd_log.string(l_log_statement,L_DEBUG,'After calling AHL_VWP_VISITS_STAGES_PVT.VALIDATE_STAGE_DATES - l_return_status : '||l_return_status);
4743: END IF;
4744:
4745: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4746: x_msg_count := l_msg_count;

Line 5578: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES ');

5574: IF (l_is_comp_visit = 'N') THEN
5575:
5576: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: changed the API name from DELETE_STAGES to DELETE_ALL_STAGES
5577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5578: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES ');
5579: END IF;
5580:
5581: AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES
5582: ( p_api_version => p_api_version,

Line 5581: AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES

5577: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5578: fnd_log.string (fnd_log.level_statement,L_DEBUG,'before calling AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES ');
5579: END IF;
5580:
5581: AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES
5582: ( p_api_version => p_api_version,
5583: p_init_msg_list => l_init_msg_list,
5584: p_commit => l_commit,
5585: p_validation_level => p_validation_level,

Line 5594: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES - l_return_status : '||l_return_status );

5590: x_msg_data => x_msg_data
5591: );
5592:
5593: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5594: fnd_log.string (fnd_log.level_statement,L_DEBUG,'after calling AHL_VWP_VISITS_STAGES_PVT.DELETE_ALL_STAGES - l_return_status : '||l_return_status );
5595: END IF;
5596:
5597: IF NVL(l_return_status, 'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
5598: RAISE Fnd_Api.G_EXC_ERROR;