149:
150:
151: -- Call VWP API.
152: /* AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: p_unit_effectivity_id => p_unit_effectivity_id,
157: x_return_status => l_return_status,
150:
151: -- Call VWP API.
152: /* AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: p_unit_effectivity_id => p_unit_effectivity_id,
157: x_return_status => l_return_status,
158: x_msg_count => l_msg_count,
151: -- Call VWP API.
152: /* AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: p_unit_effectivity_id => p_unit_effectivity_id,
157: x_return_status => l_return_status,
158: x_msg_count => l_msg_count,
159: x_msg_data => l_msg_data,
159: x_msg_data => l_msg_data,
160: x_ump_visit_rec => l_ump_visit_rec);
161:
162:
163: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF; */
160: x_ump_visit_rec => l_ump_visit_rec);
161:
162:
163: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF; */
168:
161:
162:
163: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF; */
168:
169: open ahl_visit_csr (p_unit_effectivity_id);
162:
163: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF; */
168:
169: open ahl_visit_csr (p_unit_effectivity_id);
170: FETCH ahl_visit_csr INTO x_visit_start_date, l_visit_id, l_tsk_status_code;
188: CLOSE get_wo_dt;
189: ELSE
190: CLOSE get_wo_dt;
191: x_visit_End_date := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id => l_visit_id,
192: p_use_actuals => FND_API.G_FALSE);
193: END IF; -- get_wo_dt
194: END IF; -- l_tsk_status_code
195: END IF;
196:
247: begin
248: /*
249: -- Call VWP API.
250: AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_FALSE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: p_unit_effectivity_id => p_unit_effectivity_id,
255: x_return_status => l_return_status,
248: /*
249: -- Call VWP API.
250: AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_FALSE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: p_unit_effectivity_id => p_unit_effectivity_id,
255: x_return_status => l_return_status,
256: x_msg_count => l_msg_count,
249: -- Call VWP API.
250: AHL_VWP_VISITS_PVT.UMP_Visit_Info( p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_FALSE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: p_unit_effectivity_id => p_unit_effectivity_id,
255: x_return_status => l_return_status,
256: x_msg_count => l_msg_count,
257: x_msg_data => l_msg_data,
256: x_msg_count => l_msg_count,
257: x_msg_data => l_msg_data,
258: x_ump_visit_rec => l_ump_visit_rec);
259:
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
257: x_msg_data => l_msg_data,
258: x_ump_visit_rec => l_ump_visit_rec);
259:
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
258: x_ump_visit_rec => l_ump_visit_rec);
259:
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: */
259:
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: */
267:
571:
572: -- call api to fetch all applicable mrs for ASO installation.
573: AHL_FMP_PVT.get_applicable_mrs(
574: p_api_version => l_api_version,
575: p_init_msg_list => FND_API.G_FALSE,
576: p_commit => FND_API.G_FALSE,
577: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
572: -- call api to fetch all applicable mrs for ASO installation.
573: AHL_FMP_PVT.get_applicable_mrs(
574: p_api_version => l_api_version,
575: p_init_msg_list => FND_API.G_FALSE,
576: p_commit => FND_API.G_FALSE,
577: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data,
573: AHL_FMP_PVT.get_applicable_mrs(
574: p_api_version => l_api_version,
575: p_init_msg_list => FND_API.G_FALSE,
576: p_commit => FND_API.G_FALSE,
577: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data,
581: p_item_instance_id => p_csi_ii_id,
586: x_applicable_mr_tbl => l_appl_mrs_tbl);
587:
588:
589: -- Raise errors if exceptions occur
590: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
591: RAISE FND_API.G_EXC_ERROR;
592: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
587:
588:
589: -- Raise errors if exceptions occur
590: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
591: RAISE FND_API.G_EXC_ERROR;
592: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
588:
589: -- Raise errors if exceptions occur
590: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
591: RAISE FND_API.G_EXC_ERROR;
592: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: -- fix perf bug# 13629335
589: -- Raise errors if exceptions occur
590: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
591: RAISE FND_API.G_EXC_ERROR;
592: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: -- fix perf bug# 13629335
597: -- commented following code as this is done by ahl_fmp_pvt.get_applicable_mrs API.