DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_TIMES_PVT

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

3098: AND c_visit_rec.DEPARTMENT_ID <> Fnd_Api.g_miss_num)
3099: AND l_count > 0 AND l_chk_flag = 'N' AND l_dept_flag = 'N' THEN
3100:
3101: --The visit end date
3102: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
3103:
3104: -- Start by shbhanda on Feb03,2004 for 11.5.10 release--
3105: -- If visit actual end date exceeds planned end date,
3106: -- then an error message will be displayed and the visit cannot be released.

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

4159:
4160: IF (l_log_statement >= l_log_current_level) THEN
4161: fnd_log.string(l_log_statement,
4162: L_DEBUG_KEY,
4163: 'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
4164: END IF;
4165:
4166: -- Calculate Task Start/End time
4167: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(

Line 4167: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(

4163: 'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
4164: END IF;
4165:
4166: -- Calculate Task Start/End time
4167: AHL_VWP_TIMES_PVT.CALCULATE_TASK_TIMES(
4168: p_api_version => 1.0,
4169: p_init_msg_list => Fnd_Api.G_FALSE,
4170: p_commit => Fnd_Api.G_FALSE,
4171: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

4176:
4177: IF (l_log_statement >= l_log_current_level) THEN
4178: fnd_log.string(l_log_statement,
4179: L_DEBUG_KEY,
4180: 'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times. Return Status = ' || l_return_status);
4181: END IF;
4182:
4183: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4184: IF (l_log_statement >= l_log_current_level) THEN

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

4183: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4184: IF (l_log_statement >= l_log_current_level) THEN
4185: fnd_log.string(l_log_statement,
4186: L_DEBUG_KEY,
4187: 'Errors from AHL_VWP_TIMES_PVT.Calculate_Task_Times. Message count: ' ||
4188: l_msg_count || ', message data: ' || l_msg_data);
4189: END IF;
4190: END IF;
4191:

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

4201: IF get_vst_status_and_date_rec.STATUS_CODE = 'PARTIALLY RELEASED' THEN
4202: IF (l_log_statement >= l_log_current_level) THEN
4203: fnd_log.string(l_log_statement,
4204: L_DEBUG_KEY,
4205: 'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
4206: END IF;
4207: FOR l_get_independent_tasks IN get_independent_tasks(p_visit_id) LOOP
4208: AHL_VWP_TIMES_PVT.adjust_task_times(
4209: p_api_version => 1.0,

Line 4208: AHL_VWP_TIMES_PVT.adjust_task_times(

4204: L_DEBUG_KEY,
4205: 'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
4206: END IF;
4207: FOR l_get_independent_tasks IN get_independent_tasks(p_visit_id) LOOP
4208: AHL_VWP_TIMES_PVT.adjust_task_times(
4209: p_api_version => 1.0,
4210: p_init_msg_list => Fnd_Api.G_FALSE,
4211: p_commit => Fnd_Api.G_FALSE,
4212: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

4219:
4220: IF (l_log_statement >= l_log_current_level) THEN
4221: fnd_log.string(l_log_statement,
4222: L_DEBUG_KEY,
4223: 'After calling AHL_VWP_TIMES_PVT.adjust_task_times. Return Status = ' || l_return_status);
4224: END IF;
4225:
4226: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4227: IF (l_log_statement >= l_log_current_level) THEN

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

4226: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
4227: IF (l_log_statement >= l_log_current_level) THEN
4228: fnd_log.string(l_log_statement,
4229: L_DEBUG_KEY,
4230: 'Errors from AHL_VWP_TIMES_PVT.adjust_task_times. Message count: ' ||
4231: l_msg_count || ', message data: ' || l_msg_data);
4232: END IF;
4233: END IF;
4234:

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

4231: l_msg_count || ', message data: ' || l_msg_data);
4232: END IF;
4233: END IF;
4234:
4235: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
4236: IF l_visit_end_time > get_vst_status_and_date_rec.close_date_time THEN
4237: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
4238: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
4239: Fnd_Msg_Pub.ADD;

Line 5586: AHL_VWP_TIMES_PVT.adjust_task_times

5582: END IF;
5583:
5584: FOR i IN l_tasks_tbl.FIRST..l_tasks_tbl.LAST
5585: LOOP
5586: AHL_VWP_TIMES_PVT.adjust_task_times
5587: (p_api_version => l_api_version,
5588: p_init_msg_list => p_init_msg_list,
5589: p_commit => 'F',
5590: p_validation_level => p_validation_level,

Line 7249: AHL_VWP_TIMES_PVT.adjust_task_times(

7245:
7246: IF c_visit_rec.STATUS_CODE = 'PARTIALLY RELEASED' AND c_visit_rec.start_date_time < SYSDATE THEN
7247: FOR l_get_independent_tasks IN get_independent_tasks(c_visit_rec.visit_id,p_unit_effectivity_id)
7248: LOOP
7249: AHL_VWP_TIMES_PVT.adjust_task_times(
7250: p_api_version => 1.0,
7251: p_init_msg_list => Fnd_Api.G_FALSE,
7252: p_commit => Fnd_Api.G_FALSE,
7253: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

7256: x_msg_data => l_msg_data,
7257: p_task_id => l_get_independent_tasks.visit_task_id,
7258: p_reset_sysdate_flag => FND_API.G_TRUE);
7259: END LOOP;
7260: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
7261: IF l_visit_end_time > c_visit_rec.close_date_time THEN
7262: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
7263: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
7264: Fnd_Msg_Pub.ADD;

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

7273: OPEN get_summary_task_times_csr(p_visit_id, p_unit_effectivity_id);
7274: FETCH get_summary_task_times_csr into l_MR_end_time;
7275: CLOSE get_summary_task_times_csr;
7276: */
7277: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
7278:
7279: OPEN c_get_wo_details(c_visit_rec.visit_id);
7280: FETCH c_get_wo_details into c_get_wo_details_rec;
7281: -- Validate to check if derived visit end time now exceeds scheduled master work order completion time

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

9222: FETCH c_visit INTO c_visit_rec;
9223: CLOSE c_visit;
9224:
9225: IF (l_log_statement >= l_log_current_level) THEN
9226: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_VWP_TIMES_PVT.adjust_task_times');
9227: END IF;
9228:
9229: IF c_visit_rec.start_date_time < SYSDATE THEN
9230: WHILE i IS NOT NULL

Line 9232: AHL_VWP_TIMES_PVT.adjust_task_times(

9228:
9229: IF c_visit_rec.start_date_time < SYSDATE THEN
9230: WHILE i IS NOT NULL
9231: LOOP
9232: AHL_VWP_TIMES_PVT.adjust_task_times(
9233: p_api_version => 1.0,
9234: p_init_msg_list => Fnd_Api.G_FALSE,
9235: p_commit => Fnd_Api.G_FALSE,
9236: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

9243: i:= p_x_task_Tbl.NEXT(i);
9244: END LOOP;
9245: END IF;
9246: --The visit end date
9247: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
9248:
9249: IF (l_log_statement >= l_log_current_level) THEN
9250: 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);
9251: END IF;

Line 9250: 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);

9246: --The visit end date
9247: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
9248:
9249: IF (l_log_statement >= l_log_current_level) THEN
9250: 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);
9251: END IF;
9252: -- yazhou 15Aug2005 ends
9253: END IF;
9254: