DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on FND_API

Line 153: p_init_msg_list => FND_API.G_FALSE,

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,

Line 154: p_commit => FND_API.G_FALSE,

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,

Line 155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,

Line 163: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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; */

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 165: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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);

Line 166: RAISE FND_API.G_EXC_ERROR;

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;

Line 192: p_use_actuals => FND_API.G_FALSE);

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:

Line 251: p_init_msg_list => FND_API.G_FALSE,

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,

Line 252: p_commit => FND_API.G_FALSE,

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,

Line 253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,

Line 260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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: */

Line 263: RAISE FND_API.G_EXC_ERROR;

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:

Line 575: p_init_msg_list => FND_API.G_FALSE,

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,

Line 576: p_commit => FND_API.G_FALSE,

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,

Line 577: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,

Line 590: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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;

Line 591: RAISE FND_API.G_EXC_ERROR;

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:

Line 592: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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.