DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_TIMES_PVT

Line 6370: 'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');

6366:
6367: IF (l_log_statement >= l_log_current_level) THEN
6368: fnd_log.string(l_log_statement,
6369: L_DEBUG_KEY,
6370: 'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
6371: END IF;
6372:
6373: -- Calculate Task Start/End time
6374: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(

Line 6374: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(

6370: 'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
6371: END IF;
6372:
6373: -- Calculate Task Start/End time
6374: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(
6375: p_api_version => 1.0,
6376: p_init_msg_list => Fnd_Api.G_FALSE,
6377: p_commit => Fnd_Api.G_FALSE,
6378: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 6387: 'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times. Return Status = ' || l_return_status);

6383:
6384: IF (l_log_statement >= l_log_current_level) THEN
6385: fnd_log.string(l_log_statement,
6386: L_DEBUG_KEY,
6387: 'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times. Return Status = ' || l_return_status);
6388: END IF;
6389:
6390: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6391: IF (l_log_statement >= l_log_current_level) THEN

Line 6394: 'Errors from AHL_VWP_TIMES_PVT.Calculate_Task_Times. Message count: ' ||

6390: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6391: IF (l_log_statement >= l_log_current_level) THEN
6392: fnd_log.string(l_log_statement,
6393: L_DEBUG_KEY,
6394: 'Errors from AHL_VWP_TIMES_PVT.Calculate_Task_Times. Message count: ' ||
6395: l_msg_count || ', message data: ' || l_msg_data);
6396: END IF;
6397: END IF;
6398:

Line 6414: 'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');

6410: IF get_vst_status_and_date_rec.STATUS_CODE = 'PLANNING' OR get_vst_status_and_date_rec.STATUS_CODE = 'PARTIALLY RELEASED' THEN
6411: IF (l_log_statement >= l_log_current_level) THEN
6412: fnd_log.string(l_log_statement,
6413: L_DEBUG_KEY,
6414: 'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
6415: END IF;
6416: FOR l_get_independent_tasks IN get_independent_tasks(p_visit_id) LOOP
6417: AHL_VWP_TIMES_PVT.adjust_task_times(
6418: p_api_version => 1.0,

Line 6417: AHL_VWP_TIMES_PVT.adjust_task_times(

6413: L_DEBUG_KEY,
6414: 'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
6415: END IF;
6416: FOR l_get_independent_tasks IN get_independent_tasks(p_visit_id) LOOP
6417: AHL_VWP_TIMES_PVT.adjust_task_times(
6418: p_api_version => 1.0,
6419: p_init_msg_list => Fnd_Api.G_FALSE,
6420: p_commit => Fnd_Api.G_FALSE,
6421: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 6432: 'After calling AHL_VWP_TIMES_PVT.adjust_task_times. Return Status = ' || l_return_status);

6428:
6429: IF (l_log_statement >= l_log_current_level) THEN
6430: fnd_log.string(l_log_statement,
6431: L_DEBUG_KEY,
6432: 'After calling AHL_VWP_TIMES_PVT.adjust_task_times. Return Status = ' || l_return_status);
6433: END IF;
6434:
6435: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6436: IF (l_log_statement >= l_log_current_level) THEN

Line 6439: 'Errors from AHL_VWP_TIMES_PVT.adjust_task_times. Message count: ' ||

6435: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6436: IF (l_log_statement >= l_log_current_level) THEN
6437: fnd_log.string(l_log_statement,
6438: L_DEBUG_KEY,
6439: 'Errors from AHL_VWP_TIMES_PVT.adjust_task_times. Message count: ' ||
6440: l_msg_count || ', message data: ' || l_msg_data);
6441: END IF;
6442: END IF;
6443:

Line 6444: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);

6440: l_msg_count || ', message data: ' || l_msg_data);
6441: END IF;
6442: END IF;
6443:
6444: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
6445: IF (l_log_statement >= l_log_current_level) THEN
6446: fnd_log.string(l_log_statement,
6447: L_DEBUG_KEY,
6448: 'l_visit_end_time --@>'||l_visit_end_time);

Line 8472: AHL_VWP_TIMES_PVT.adjust_task_times

8468: LOOP
8469: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Call adjust_task_times only if past task dates are null
8470: SELECT past_task_start_date INTO l_tasks_tbl(i).past_task_start_date FROM ahl_visit_tasks_b WHERE visit_task_id = l_tasks_tbl(i).visit_task_id;
8471: IF l_tasks_tbl(i).past_task_start_date IS NULL THEN
8472: AHL_VWP_TIMES_PVT.adjust_task_times
8473: (p_api_version => l_api_version,
8474: p_init_msg_list => p_init_msg_list,
8475: p_commit => 'F',
8476: p_validation_level => p_validation_level,

Line 10627: AHL_VWP_TIMES_PVT.adjust_task_times(

10623: -- for the p_recalculate_dates parameter so that the original dates can be retained
10624: IF (NVL(p_recalculate_dates, 'Y') <> 'N') THEN
10625: FOR l_get_independent_tasks IN get_independent_tasks(c_visit_rec.visit_id,p_unit_effectivity_id)
10626: LOOP
10627: AHL_VWP_TIMES_PVT.adjust_task_times(
10628: p_api_version => 1.0,
10629: p_init_msg_list => Fnd_Api.G_FALSE,
10630: p_commit => Fnd_Api.G_FALSE,
10631: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 10640: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);

10636: p_reset_sysdate_flag => FND_API.G_TRUE);
10637: END LOOP;
10638: END IF;
10639: -- SKPATHAK :: Bug 8343599 :: 14-APR-2009 :: End
10640: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
10641: IF l_visit_end_time > c_visit_rec.close_date_time THEN
10642: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
10643: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
10644: Fnd_Msg_Pub.ADD;

Line 10657: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);

10653: OPEN get_summary_task_times_csr(p_visit_id, p_unit_effectivity_id);
10654: FETCH get_summary_task_times_csr into l_MR_end_time;
10655: CLOSE get_summary_task_times_csr;
10656: */
10657: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
10658:
10659: OPEN c_get_wo_details(c_visit_rec.visit_id);
10660: FETCH c_get_wo_details into c_get_wo_details_rec;
10661: -- Validate to check if derived visit end time now exceeds scheduled master work order completion time

Line 13197: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');

13193: FETCH c_visit INTO c_visit_rec;
13194: CLOSE c_visit;
13195:
13196: IF (l_log_statement >= l_log_current_level) THEN
13197: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
13198: END IF;
13199:
13200: IF c_visit_rec.start_date_time < SYSDATE THEN
13201: WHILE i IS NOT NULL

Line 13203: AHL_VWP_TIMES_PVT.adjust_task_times(

13199:
13200: IF c_visit_rec.start_date_time < SYSDATE THEN
13201: WHILE i IS NOT NULL
13202: LOOP
13203: AHL_VWP_TIMES_PVT.adjust_task_times(
13204: p_api_version => 1.0,
13205: p_init_msg_list => Fnd_Api.G_FALSE,
13206: p_commit => Fnd_Api.G_FALSE,
13207: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 13218: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);

13214: i:= p_x_task_Tbl.NEXT(i);
13215: END LOOP;
13216: END IF;
13217: --The visit end date
13218: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
13219:
13220: IF (l_log_statement >= l_log_current_level) THEN
13221: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_VWP_TIMES_PVT.adjust_task_times - l_visit_end_time = '||l_visit_end_time);
13222: END IF;

Line 13221: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_VWP_TIMES_PVT.adjust_task_times - l_visit_end_time = '||l_visit_end_time);

13217: --The visit end date
13218: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
13219:
13220: IF (l_log_statement >= l_log_current_level) THEN
13221: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_VWP_TIMES_PVT.adjust_task_times - l_visit_end_time = '||l_visit_end_time);
13222: END IF;
13223: -- yazhou 15Aug2005 ends
13224: END IF;
13225: