eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RSV_RESERVATIONS_PVT dependencies on FND_API

Line 37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

33: -- Function : Reserves the serial numbers in the p_serial_number_tbl
34: -- Pre-reqs :
35: -- Standard IN Parameters :
36: -- p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
40: -- p_module_type IN VARCHAR2 Default NULL
41: -- Standard OUT Parameters :

Line 38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

34: -- Pre-reqs :
35: -- Standard IN Parameters :
36: -- p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
40: -- p_module_type IN VARCHAR2 Default NULL
41: -- Standard OUT Parameters :
42: -- x_return_status OUT VARCHAR2 Required

Line 39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

35: -- Standard IN Parameters :
36: -- p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
40: -- p_module_type IN VARCHAR2 Default NULL
41: -- Standard OUT Parameters :
42: -- x_return_status OUT VARCHAR2 Required
43: -- x_msg_count OUT NUMBER Required

Line 148: x_return_status:= FND_API.G_RET_STS_SUCCESS;

144: BEGIN
145: -- Standard start of API savepoint
146: SAVEPOINT CREATE_RESERVATION_PVT;
147: -- Initialize return status to success before any code logic/validation
148: x_return_status:= FND_API.G_RET_STS_SUCCESS;
149:
150:
151: -- Standard call to check for call compatibility
152: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

Line 152: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

148: x_return_status:= FND_API.G_RET_STS_SUCCESS;
149:
150:
151: -- Standard call to check for call compatibility
152: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150:
151: -- Standard call to check for call compatibility
152: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157:
158: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

Line 158: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157:
158: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
159: IF FND_API.TO_BOOLEAN(p_init_msg_list)
160: THEN
161: FND_MSG_PUB.INITIALIZE;
162: END IF;

Line 159: IF FND_API.TO_BOOLEAN(p_init_msg_list)

155: END IF;
156:
157:
158: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
159: IF FND_API.TO_BOOLEAN(p_init_msg_list)
160: THEN
161: FND_MSG_PUB.INITIALIZE;
162: END IF;
163:

Line 189: RAISE FND_API.G_EXC_ERROR;

185: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
186: 'Number of Serial Numbers to be reserved equal to ZERO'
187: );
188: END IF;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF; -- l_sn_number = 0
191:
192: -- Get the Material Requirements details
193: OPEN get_mtl_req_dtls_csr(p_scheduled_material_id);

Line 208: RAISE FND_API.G_EXC_ERROR;

204: 'get_mtl_req_dtls_csr, did not fetch any records'
205: );
206: END IF;
207: CLOSE get_mtl_req_dtls_csr;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF; -- Material Requirement details not found
210: CLOSE get_mtl_req_dtls_csr;
211:
212:

Line 228: RAISE FND_API.G_EXC_ERROR;

224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
225: 'Number of serial numbers + Completed Qty + Reserved Qty is more than Requested Qty '
226: );
227: END IF;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF; -- sum of number of serial nos to be reserved ,completed qty and reserved qty is more than requested qty
230:
231: -- For all the serial numbers that need to be reserved
232: FOR i IN p_serial_number_tbl.FIRST..p_serial_number_tbl.LAST

Line 258: RAISE FND_API.G_EXC_ERROR;

254: 'get_instance_dtls_csr, did not fetch any records'
255: );
256: END IF;
257: CLOSE get_instance_dtls_csr;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF; -- get_instance_dtls_csr%NOTFOUND
260: CLOSE get_instance_dtls_csr;
261:
262: l_reservation_id := null;

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

352: );
353: END IF; -- IF l_reservation_id IS NULL
354:
355: -- Check the error status
356: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
357: -- log the error
358: IF (l_log_error >= l_log_current_level) THEN
359: fnd_log.string
360: (

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
363: 'Call to WMS returned Unexpected Error'
364: );
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
368: -- log the error
369: IF (l_log_error >= l_log_current_level) THEN
370: fnd_log.string

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

363: 'Call to WMS returned Unexpected Error'
364: );
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
368: -- log the error
369: IF (l_log_error >= l_log_current_level) THEN
370: fnd_log.string
371: (

Line 377: RAISE FND_API.G_EXC_ERROR;

373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
374: 'Call to WMS returned Expected Error'
375: );
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: END LOOP; -- FOR i IN p_serial_number_tbl.FIRST..p_serial_number_tbl.LAST
380:
381: -- Check Error Message stack.

Line 394: RAISE FND_API.G_EXC_ERROR;

390: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
391: 'Call to WMS returned Errors in x_msg_count'
392: );
393: END IF;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: -- Commit if p_commit = FND_API.G_TRUE
398: IF FND_API.TO_BOOLEAN(p_commit)

Line 397: -- Commit if p_commit = FND_API.G_TRUE

393: END IF;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: -- Commit if p_commit = FND_API.G_TRUE
398: IF FND_API.TO_BOOLEAN(p_commit)
399: THEN
400: COMMIT WORK;
401: IF (l_log_statement >= l_log_current_level) THEN

Line 398: IF FND_API.TO_BOOLEAN(p_commit)

394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: -- Commit if p_commit = FND_API.G_TRUE
398: IF FND_API.TO_BOOLEAN(p_commit)
399: THEN
400: COMMIT WORK;
401: IF (l_log_statement >= l_log_current_level) THEN
402: fnd_log.string

Line 416: p_encoded => FND_API.G_FALSE

412: FND_MSG_PUB.count_and_get
413: (
414: p_count => x_msg_count,
415: p_data => x_msg_data,
416: p_encoded => FND_API.G_FALSE
417: );
418:
419: -- Log API exit point
420: IF (l_log_procedure >= l_log_current_level)THEN

Line 430: WHEN FND_API.G_EXC_ERROR THEN

426: );
427: END IF;
428:
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_RESERVATION_PVT;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get
434: (

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428:
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_RESERVATION_PVT;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get
434: (
435: p_count => x_msg_count,
436: p_data => x_msg_data,

Line 437: p_encoded => FND_API.G_FALSE

433: FND_MSG_PUB.count_and_get
434: (
435: p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => FND_API.G_FALSE
438: );
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_RESERVATION_PVT;

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

436: p_data => x_msg_data,
437: p_encoded => FND_API.G_FALSE
438: );
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_RESERVATION_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.count_and_get
444: (

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: );
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_RESERVATION_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.count_and_get
444: (
445: p_count => x_msg_count,
446: p_data => x_msg_data,

Line 447: p_encoded => FND_API.G_FALSE

443: FND_MSG_PUB.count_and_get
444: (
445: p_count => x_msg_count,
446: p_data => x_msg_data,
447: p_encoded => FND_API.G_FALSE
448: );
449:
450: WHEN OTHERS THEN
451: ROLLBACK TO CREATE_RESERVATION_PVT;

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

448: );
449:
450: WHEN OTHERS THEN
451: ROLLBACK TO CREATE_RESERVATION_PVT;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.add_exc_msg
456: (

Line 466: p_encoded => FND_API.G_FALSE

462: FND_MSG_PUB.count_and_get
463: (
464: p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => FND_API.G_FALSE
467: );
468: END CREATE_RESERVATION;
469:
470: ------------------------------------------------------------------------------------------------------------------

Line 480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

476: -- Function : Updates reservation for serial numbers in the p_serial_number_tbl
477: -- Pre-reqs :
478: -- Standard IN Parameters :
479: -- p_api_version IN NUMBER Required
480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
483: -- p_module_type IN VARCHAR2 Default NULL
484: -- Standard OUT Parameters :

Line 481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

477: -- Pre-reqs :
478: -- Standard IN Parameters :
479: -- p_api_version IN NUMBER Required
480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
483: -- p_module_type IN VARCHAR2 Default NULL
484: -- Standard OUT Parameters :
485: -- x_return_status OUT VARCHAR2 Required

Line 482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

478: -- Standard IN Parameters :
479: -- p_api_version IN NUMBER Required
480: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
481: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
482: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
483: -- p_module_type IN VARCHAR2 Default NULL
484: -- Standard OUT Parameters :
485: -- x_return_status OUT VARCHAR2 Required
486: -- x_msg_count OUT NUMBER Required

Line 555: x_return_status:= FND_API.G_RET_STS_SUCCESS;

551: -- Standard start of API savepoint
552: SAVEPOINT UPDATE_RESERVATION_PVT;
553:
554: -- Initialize return status to success before any code logic/validation
555: x_return_status:= FND_API.G_RET_STS_SUCCESS;
556:
557: -- Standard call to check for call compatibility
558: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
559: THEN

Line 558: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

554: -- Initialize return status to success before any code logic/validation
555: x_return_status:= FND_API.G_RET_STS_SUCCESS;
556:
557: -- Standard call to check for call compatibility
558: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
559: THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

556:
557: -- Standard call to check for call compatibility
558: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
559: THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
564: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 563: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

559: THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
564: IF FND_API.TO_BOOLEAN(p_init_msg_list)
565: THEN
566: FND_MSG_PUB.INITIALIZE;
567: END IF;

Line 564: IF FND_API.TO_BOOLEAN(p_init_msg_list)

560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
564: IF FND_API.TO_BOOLEAN(p_init_msg_list)
565: THEN
566: FND_MSG_PUB.INITIALIZE;
567: END IF;
568:

Line 593: RAISE FND_API.G_EXC_ERROR;

589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
590: 'schedule material id is null'
591: );
592: END IF;
593: RAISE FND_API.G_EXC_ERROR;
594: END IF; -- IF p_scheduled_material_id IS NULL
595:
596: -- Validate the schedule material id
597: OPEN get_mtl_req_dtls_csr(p_scheduled_material_id);

Line 612: RAISE FND_API.G_EXC_ERROR;

608: 'Invalid Material Requirement ID'
609: );
610: END IF;
611: CLOSE get_mtl_req_dtls_csr;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF; -- IF get_mtl_req_dtls_csr%NOTFOUND
614: CLOSE get_mtl_req_dtls_csr;
615:
616: -- if the requested date is null, throw error

Line 629: RAISE FND_API.G_EXC_ERROR;

625: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
626: 'Requested Date is null'
627: );
628: END IF;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF; --IF p_requested_date IS NULL
631:
632: -- if the dates are the same, no need to do anything
633: IF p_requested_date = l_requested_date THEN

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

677: p_original_serial_number => l_from_serial_number_tbl,
678: p_to_serial_number => l_to_serial_number_tbl
679: );
680:
681: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
682: -- log the error
683: IF (l_log_error >= l_log_current_level) THEN
684: fnd_log.string
685: (

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: 'Call to WMS returned Unexpected Error'
689: );
690: END IF;
691: CLOSE get_reservation_csr;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
694: -- log the error
695: IF (l_log_error >= l_log_current_level) THEN
696: fnd_log.string

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

689: );
690: END IF;
691: CLOSE get_reservation_csr;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
694: -- log the error
695: IF (l_log_error >= l_log_current_level) THEN
696: fnd_log.string
697: (

Line 704: RAISE FND_API.G_EXC_ERROR;

700: 'Call to WMS returned Expected Error'
701: );
702: END IF;
703: CLOSE get_reservation_csr;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: END LOOP; -- All the reservations for this material requiement id
707:
708: -- Check Error Message stack.

Line 721: RAISE FND_API.G_EXC_ERROR;

717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
718: 'Call to WMS returned Errors in x_msg_count'
719: );
720: END IF;
721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723:
724: -- Commit if p_commit = FND_API.G_TRUE
725: IF FND_API.TO_BOOLEAN(p_commit)

Line 724: -- Commit if p_commit = FND_API.G_TRUE

720: END IF;
721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723:
724: -- Commit if p_commit = FND_API.G_TRUE
725: IF FND_API.TO_BOOLEAN(p_commit)
726: THEN
727: COMMIT WORK;
728: IF (l_log_statement >= l_log_current_level) THEN

Line 725: IF FND_API.TO_BOOLEAN(p_commit)

721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723:
724: -- Commit if p_commit = FND_API.G_TRUE
725: IF FND_API.TO_BOOLEAN(p_commit)
726: THEN
727: COMMIT WORK;
728: IF (l_log_statement >= l_log_current_level) THEN
729: fnd_log.string

Line 743: p_encoded => FND_API.G_FALSE

739: FND_MSG_PUB.count_and_get
740: (
741: p_count => x_msg_count,
742: p_data => x_msg_data,
743: p_encoded => FND_API.G_FALSE
744: );
745:
746: -- Log API exit point
747: IF (l_log_procedure >= l_log_current_level)THEN

Line 756: WHEN FND_API.G_EXC_ERROR THEN

752: 'At the end of PLSQL procedure'
753: );
754: END IF;
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO UPDATE_RESERVATION_PVT;
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get
760: (

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754: END IF;
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO UPDATE_RESERVATION_PVT;
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get
760: (
761: p_count => x_msg_count,
762: p_data => x_msg_data,

Line 763: p_encoded => FND_API.G_FALSE

759: FND_MSG_PUB.count_and_get
760: (
761: p_count => x_msg_count,
762: p_data => x_msg_data,
763: p_encoded => FND_API.G_FALSE
764: );
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO UPDATE_RESERVATION_PVT;

Line 766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

762: p_data => x_msg_data,
763: p_encoded => FND_API.G_FALSE
764: );
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO UPDATE_RESERVATION_PVT;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.count_and_get
770: (

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

764: );
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO UPDATE_RESERVATION_PVT;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.count_and_get
770: (
771: p_count => x_msg_count,
772: p_data => x_msg_data,

Line 773: p_encoded => FND_API.G_FALSE

769: FND_MSG_PUB.count_and_get
770: (
771: p_count => x_msg_count,
772: p_data => x_msg_data,
773: p_encoded => FND_API.G_FALSE
774: );
775:
776: WHEN OTHERS THEN
777: ROLLBACK TO UPDATE_RESERVATION_PVT;

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: );
775:
776: WHEN OTHERS THEN
777: ROLLBACK TO UPDATE_RESERVATION_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: FND_MSG_PUB.add_exc_msg
782: (

Line 792: p_encoded => FND_API.G_FALSE

788: FND_MSG_PUB.count_and_get
789: (
790: p_count => x_msg_count,
791: p_data => x_msg_data,
792: p_encoded => FND_API.G_FALSE
793: );
794: END UPDATE_RESERVATION;
795:
796: ---------------------------------------------------------------------------------------------------------------------

Line 806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

802: -- Function : API to delete all the reservation made for a requirement
803: -- Pre-reqs :
804: -- Standard IN Parameters :
805: -- p_api_version IN NUMBER Required
806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
809: -- p_module_type IN VARCHAR2 Default NULL
810: -- Standard OUT Parameters :

Line 807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

803: -- Pre-reqs :
804: -- Standard IN Parameters :
805: -- p_api_version IN NUMBER Required
806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
809: -- p_module_type IN VARCHAR2 Default NULL
810: -- Standard OUT Parameters :
811: -- x_return_status OUT VARCHAR2 Required

Line 808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

804: -- Standard IN Parameters :
805: -- p_api_version IN NUMBER Required
806: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
807: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
808: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
809: -- p_module_type IN VARCHAR2 Default NULL
810: -- Standard OUT Parameters :
811: -- x_return_status OUT VARCHAR2 Required
812: -- x_msg_count OUT NUMBER Required

Line 823: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

819: -- End of Comments.
820: ---------------------------------------------------------------------------------------------------------------------
821: PROCEDURE DELETE_RESERVATION(
822: p_api_version IN NUMBER := 1.0,
823: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
824: p_commit IN VARCHAR2 := FND_API.G_FALSE,
825: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
826: p_module_type IN VARCHAR2,
827: x_return_status OUT NOCOPY VARCHAR2,

Line 824: p_commit IN VARCHAR2 := FND_API.G_FALSE,

820: ---------------------------------------------------------------------------------------------------------------------
821: PROCEDURE DELETE_RESERVATION(
822: p_api_version IN NUMBER := 1.0,
823: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
824: p_commit IN VARCHAR2 := FND_API.G_FALSE,
825: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
826: p_module_type IN VARCHAR2,
827: x_return_status OUT NOCOPY VARCHAR2,
828: x_msg_count OUT NOCOPY NUMBER,

Line 825: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

821: PROCEDURE DELETE_RESERVATION(
822: p_api_version IN NUMBER := 1.0,
823: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
824: p_commit IN VARCHAR2 := FND_API.G_FALSE,
825: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
826: p_module_type IN VARCHAR2,
827: x_return_status OUT NOCOPY VARCHAR2,
828: x_msg_count OUT NOCOPY NUMBER,
829: x_msg_data OUT NOCOPY VARCHAR2,

Line 887: x_return_status:= FND_API.G_RET_STS_SUCCESS;

883: -- Standard start of API savepoint
884: SAVEPOINT DELETE_RESERVATION_PVT;
885:
886: -- Initialize return status to success before any code logic/validation
887: x_return_status:= FND_API.G_RET_STS_SUCCESS;
888:
889: -- Standard call to check for call compatibility
890: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
891: THEN

Line 890: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

886: -- Initialize return status to success before any code logic/validation
887: x_return_status:= FND_API.G_RET_STS_SUCCESS;
888:
889: -- Standard call to check for call compatibility
890: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
891: THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:

Line 892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

888:
889: -- Standard call to check for call compatibility
890: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
891: THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
896: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 895: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

891: THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
896: IF FND_API.TO_BOOLEAN(p_init_msg_list)
897: THEN
898: FND_MSG_PUB.INITIALIZE;
899: END IF;

Line 896: IF FND_API.TO_BOOLEAN(p_init_msg_list)

892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
896: IF FND_API.TO_BOOLEAN(p_init_msg_list)
897: THEN
898: FND_MSG_PUB.INITIALIZE;
899: END IF;
900:

Line 915: RAISE FND_API.G_EXC_ERROR;

911: -- Validate the schedule material id and p_sub_inventory_code
912: IF p_scheduled_material_id IS NULL THEN
913: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
914: FND_MSG_PUB.add;
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917:
918: -- log the p_scheduled_material_id and the p_sub_inventory_code
919: IF (l_log_statement >= l_log_current_level) THEN

Line 953: RAISE FND_API.G_EXC_ERROR;

949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
950: 'Invalid Material Requirement ID'
951: );
952: END IF;
953: RAISE FND_API.G_EXC_ERROR;
954: END;
955:
956: -- Begin Changes by skpathak on 12-NOV-2008 for bug 7241925
957: IF (p_serial_number IS NOT NULL) THEN

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

990: fnd_log.string(fnd_log.level_statement, l_debug_module,
991: 'Returned from inv_reservation_pub.delete_reservation, l_return_status: ' || l_return_status);
992: END IF;
993: -- Check whether the return status is success, if not raise exception
994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
995: -- log the error
996: IF (l_log_error >= l_log_current_level) THEN
997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');

Line 998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');

994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
995: -- log the error
996: IF (l_log_error >= l_log_current_level) THEN
997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

996: IF (l_log_error >= l_log_current_level) THEN
997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error
1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,

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

997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error
1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,
1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');

Line 1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');

1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error
1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,
1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');
1006: END IF;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF; -- l_reservation_id IS NOT NULL

Line 1007: RAISE FND_API.G_EXC_ERROR;

1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,
1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');
1006: END IF;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF; -- l_reservation_id IS NOT NULL
1010: ELSE
1011: -- Delete Based on p_scheduled_material_id and p_sub_inventory_code

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

1045: 'After call inv_reservation_pub.delete_reservation,l_return_status :' || l_return_status
1046: );
1047: END IF;
1048: -- Check whether the return status is success, if not raise exception
1049: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1050: -- log the error
1051: IF (l_log_error >= l_log_current_level) THEN
1052: fnd_log.string
1053: (

Line 1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'

1052: fnd_log.string
1053: (
1054: fnd_log.level_error,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'
1057: );
1058: END IF;
1059: CLOSE get_reservation_csr;
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'
1057: );
1058: END IF;
1059: CLOSE get_reservation_csr;
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: -- log the error
1063: IF (l_log_error >= l_log_current_level) THEN
1064: fnd_log.string

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

1057: );
1058: END IF;
1059: CLOSE get_reservation_csr;
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: -- log the error
1063: IF (l_log_error >= l_log_current_level) THEN
1064: fnd_log.string
1065: (

Line 1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'

1064: fnd_log.string
1065: (
1066: fnd_log.level_error,
1067: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'
1069: );
1070: END IF;
1071: CLOSE get_reservation_csr;
1072: RAISE FND_API.G_EXC_ERROR;

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'
1069: );
1070: END IF;
1071: CLOSE get_reservation_csr;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074: END LOOP; -- All the reservations for this material req id, sub inventory pair
1075: END IF;
1076:

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087: -- Check Error Message stack.
1088: x_msg_count := FND_MSG_PUB.count_msg;
1089: IF x_msg_count > 0
1090: THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094: -- Commit if p_commit = FND_API.G_TRUE
1095: IF FND_API.TO_BOOLEAN(p_commit)

Line 1094: -- Commit if p_commit = FND_API.G_TRUE

1090: THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094: -- Commit if p_commit = FND_API.G_TRUE
1095: IF FND_API.TO_BOOLEAN(p_commit)
1096: THEN
1097: COMMIT WORK;
1098: IF (l_log_statement >= l_log_current_level) THEN

Line 1095: IF FND_API.TO_BOOLEAN(p_commit)

1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094: -- Commit if p_commit = FND_API.G_TRUE
1095: IF FND_API.TO_BOOLEAN(p_commit)
1096: THEN
1097: COMMIT WORK;
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string

Line 1113: p_encoded => FND_API.G_FALSE

1109: FND_MSG_PUB.count_and_get
1110: (
1111: p_count => x_msg_count,
1112: p_data => x_msg_data,
1113: p_encoded => FND_API.G_FALSE
1114: );
1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN

Line 1117: WHEN FND_API.G_EXC_ERROR THEN

1113: p_encoded => FND_API.G_FALSE
1114: );
1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN
1118: ROLLBACK TO DELETE_RESERVATION_PVT;
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.count_and_get
1121: (

Line 1119: x_return_status := FND_API.G_RET_STS_ERROR;

1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN
1118: ROLLBACK TO DELETE_RESERVATION_PVT;
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.count_and_get
1121: (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,

Line 1124: p_encoded => FND_API.G_FALSE

1120: FND_MSG_PUB.count_and_get
1121: (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1125: );
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO DELETE_RESERVATION_PVT;

Line 1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1125: );
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO DELETE_RESERVATION_PVT;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.count_and_get
1131: (

Line 1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1125: );
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO DELETE_RESERVATION_PVT;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.count_and_get
1131: (
1132: p_count => x_msg_count,
1133: p_data => x_msg_data,

Line 1134: p_encoded => FND_API.G_FALSE

1130: FND_MSG_PUB.count_and_get
1131: (
1132: p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE
1135: );
1136:
1137: WHEN OTHERS THEN
1138: ROLLBACK TO DELETE_RESERVATION_PVT;

Line 1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1135: );
1136:
1137: WHEN OTHERS THEN
1138: ROLLBACK TO DELETE_RESERVATION_PVT;
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: FND_MSG_PUB.add_exc_msg
1143: (

Line 1153: p_encoded => FND_API.G_FALSE

1149: FND_MSG_PUB.count_and_get
1150: (
1151: p_count => x_msg_count,
1152: p_data => x_msg_data,
1153: p_encoded => FND_API.G_FALSE
1154: );
1155: END DELETE_RESERVATION;
1156:
1157: ---------------------------------------------------------------------------------------------------------------------

Line 1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1163: -- Function : API to delete the reservation made for a particular serial number
1164: -- Pre-reqs :
1165: -- Standard IN Parameters :
1166: -- p_api_version IN NUMBER Required
1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1170: -- p_module_type IN VARCHAR2 Default NULL
1171: -- Standard OUT Parameters :

Line 1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1164: -- Pre-reqs :
1165: -- Standard IN Parameters :
1166: -- p_api_version IN NUMBER Required
1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1170: -- p_module_type IN VARCHAR2 Default NULL
1171: -- Standard OUT Parameters :
1172: -- x_return_status OUT VARCHAR2 Required

Line 1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1165: -- Standard IN Parameters :
1166: -- p_api_version IN NUMBER Required
1167: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1168: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1169: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1170: -- p_module_type IN VARCHAR2 Default NULL
1171: -- Standard OUT Parameters :
1172: -- x_return_status OUT VARCHAR2 Required
1173: -- x_msg_count OUT NUMBER Required

Line 1184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1180: -- End of Comments.
1181: ---------------------------------------------------------------------------------------------------------------------
1182: PROCEDURE RELIEVE_RESERVATION(
1183: p_api_version IN NUMBER := 1.0,
1184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1187: p_module_type IN VARCHAR2,
1188: x_return_status OUT NOCOPY VARCHAR2,

Line 1185: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1181: ---------------------------------------------------------------------------------------------------------------------
1182: PROCEDURE RELIEVE_RESERVATION(
1183: p_api_version IN NUMBER := 1.0,
1184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1187: p_module_type IN VARCHAR2,
1188: x_return_status OUT NOCOPY VARCHAR2,
1189: x_msg_count OUT NOCOPY NUMBER,

Line 1186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1182: PROCEDURE RELIEVE_RESERVATION(
1183: p_api_version IN NUMBER := 1.0,
1184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1187: p_module_type IN VARCHAR2,
1188: x_return_status OUT NOCOPY VARCHAR2,
1189: x_msg_count OUT NOCOPY NUMBER,
1190: x_msg_data OUT NOCOPY VARCHAR2,

Line 1275: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1271: -- Standard start of API savepoint
1272: SAVEPOINT RELIEVE_RESERVATION_PVT;
1273:
1274: -- Initialize return status to success before any code logic/validation
1275: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1276:
1277: -- Standard call to check for call compatibility
1278: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1279: THEN

Line 1278: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1274: -- Initialize return status to success before any code logic/validation
1275: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1276:
1277: -- Standard call to check for call compatibility
1278: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1279: THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1276:
1277: -- Standard call to check for call compatibility
1278: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1279: THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:
1283: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1284: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1283: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

1279: THEN
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:
1283: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1284: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1285: THEN
1286: FND_MSG_PUB.INITIALIZE;
1287: END IF;

Line 1284: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:
1283: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1284: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1285: THEN
1286: FND_MSG_PUB.INITIALIZE;
1287: END IF;
1288:

Line 1309: 'AHL_RSV_INVLD_MAT_REQ: FND_API.G_EXC_ERROR'

1305: fnd_log.string
1306: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1309: 'AHL_RSV_INVLD_MAT_REQ: FND_API.G_EXC_ERROR'
1310: );
1311: END IF;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF; -- IF p_scheduled_material_id IS NULL

Line 1312: RAISE FND_API.G_EXC_ERROR;

1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1309: 'AHL_RSV_INVLD_MAT_REQ: FND_API.G_EXC_ERROR'
1310: );
1311: END IF;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF; -- IF p_scheduled_material_id IS NULL
1314:
1315: -- Get the Material Requirements details
1316: OPEN get_mtl_req_dtls_csr(p_scheduled_material_id);

Line 1323: RAISE FND_API.G_EXC_ERROR;

1319: IF get_mtl_req_dtls_csr%NOTFOUND THEN
1320: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1321: FND_MSG_PUB.add;
1322: CLOSE get_mtl_req_dtls_csr;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF; -- IF get_mtl_req_dtls_csr%NOTFOUND
1325: CLOSE get_mtl_req_dtls_csr;
1326:
1327: -- Validate the Serial Number

Line 1339: RAISE FND_API.G_EXC_ERROR;

1335: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1336: 'p_serial_number is null'
1337: );
1338: END IF;
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF; -- IF p_serial_number IS NULL
1341:
1342: -- Get the details of the item instance
1343: OPEN get_instance_dtls_csr(l_get_mtl_req_dtls_rec.inventory_item_id,p_serial_number,l_get_mtl_req_dtls_rec.organization_id);

Line 1349: RAISE FND_API.G_EXC_ERROR;

1345: IF get_instance_dtls_csr%NOTFOUND THEN
1346: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
1347: FND_MSG_PUB.add;
1348: CLOSE get_instance_dtls_csr;
1349: RAISE FND_API.G_EXC_ERROR;
1350: END IF; -- IF get_instance_dtls_csr%NOTFOUND
1351: CLOSE get_instance_dtls_csr;
1352:
1353: IF (l_log_statement >= l_log_current_level) THEN

Line 1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

1393: delete_reservation(
1394: p_api_version => l_api_version,
1395: p_init_msg_list => l_init_msg_list,
1396: p_commit => l_commit,
1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level
1398: p_module_type => p_module_type,
1399: x_return_status => l_return_status,
1400: x_msg_count => l_msg_count,
1401: x_msg_data => l_msg_data,

Line 1432: p_relieve_all => fnd_api.g_false,

1428: x_msg_count => l_msg_count,
1429: x_msg_data => l_msg_data,
1430: p_rsv_rec => l_rsv_rec,
1431: p_primary_relieved_quantity => 1,
1432: p_relieve_all => fnd_api.g_false,
1433: p_original_serial_number => l_serial_number_tbl,
1434: x_primary_relieved_quantity => l_x_primary_relieved_quantity,
1435: x_primary_remain_quantity => l_x_primary_remain_quantity
1436: );

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

1436: );
1437: END IF; -- IF l_reserved_quantity = 1
1438:
1439: -- Check for the returned status from these APIs
1440: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1441: IF (l_log_error >= l_log_current_level) THEN
1442: fnd_log.string
1443: (
1444: fnd_log.level_error,

Line 1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'

1442: fnd_log.string
1443: (
1444: fnd_log.level_error,
1445: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'
1447: );
1448: END IF;
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1445: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'
1447: );
1448: END IF;
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1451: IF (l_log_error >= l_log_current_level) THEN
1452: fnd_log.string
1453: (

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

1446: 'After Relieve/Delete FND_API.G_EXC_UNEXPECTED_ERROR'
1447: );
1448: END IF;
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1451: IF (l_log_error >= l_log_current_level) THEN
1452: fnd_log.string
1453: (
1454: fnd_log.level_error,

Line 1456: 'After Relieve/Delete FND_API.G_EXC_ERROR'

1452: fnd_log.string
1453: (
1454: fnd_log.level_error,
1455: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1456: 'After Relieve/Delete FND_API.G_EXC_ERROR'
1457: );
1458: END IF;
1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;

Line 1459: RAISE FND_API.G_EXC_ERROR;

1455: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1456: 'After Relieve/Delete FND_API.G_EXC_ERROR'
1457: );
1458: END IF;
1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;
1461:
1462: -- Log API exit point
1463: IF (l_log_procedure >= l_log_current_level)THEN

Line 1476: RAISE FND_API.G_EXC_ERROR;

1472: -- Check Error Message stack.
1473: x_msg_count := FND_MSG_PUB.count_msg;
1474: IF x_msg_count > 0
1475: THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479: -- Commit if p_commit = FND_API.G_TRUE
1480: IF FND_API.TO_BOOLEAN(p_commit)

Line 1479: -- Commit if p_commit = FND_API.G_TRUE

1475: THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479: -- Commit if p_commit = FND_API.G_TRUE
1480: IF FND_API.TO_BOOLEAN(p_commit)
1481: THEN
1482: COMMIT WORK;
1483: END IF;

Line 1480: IF FND_API.TO_BOOLEAN(p_commit)

1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479: -- Commit if p_commit = FND_API.G_TRUE
1480: IF FND_API.TO_BOOLEAN(p_commit)
1481: THEN
1482: COMMIT WORK;
1483: END IF;
1484:

Line 1490: p_encoded => FND_API.G_FALSE

1486: FND_MSG_PUB.count_and_get
1487: (
1488: p_count => x_msg_count,
1489: p_data => x_msg_data,
1490: p_encoded => FND_API.G_FALSE
1491: );
1492:
1493: EXCEPTION
1494: WHEN FND_API.G_EXC_ERROR THEN

Line 1494: WHEN FND_API.G_EXC_ERROR THEN

1490: p_encoded => FND_API.G_FALSE
1491: );
1492:
1493: EXCEPTION
1494: WHEN FND_API.G_EXC_ERROR THEN
1495: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.count_and_get
1498: (

Line 1496: x_return_status := FND_API.G_RET_STS_ERROR;

1492:
1493: EXCEPTION
1494: WHEN FND_API.G_EXC_ERROR THEN
1495: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.count_and_get
1498: (
1499: p_count => x_msg_count,
1500: p_data => x_msg_data,

Line 1501: p_encoded => FND_API.G_FALSE

1497: FND_MSG_PUB.count_and_get
1498: (
1499: p_count => x_msg_count,
1500: p_data => x_msg_data,
1501: p_encoded => FND_API.G_FALSE
1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK TO RELIEVE_RESERVATION_PVT;

Line 1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1500: p_data => x_msg_data,
1501: p_encoded => FND_API.G_FALSE
1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.count_and_get
1508: (

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.count_and_get
1508: (
1509: p_count => x_msg_count,
1510: p_data => x_msg_data,

Line 1511: p_encoded => FND_API.G_FALSE

1507: FND_MSG_PUB.count_and_get
1508: (
1509: p_count => x_msg_count,
1510: p_data => x_msg_data,
1511: p_encoded => FND_API.G_FALSE
1512: );
1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK TO RELIEVE_RESERVATION_PVT;

Line 1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1512: );
1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1518: THEN
1519: FND_MSG_PUB.add_exc_msg
1520: (

Line 1530: p_encoded => FND_API.G_FALSE

1526: FND_MSG_PUB.count_and_get
1527: (
1528: p_count => x_msg_count,
1529: p_data => x_msg_data,
1530: p_encoded => FND_API.G_FALSE
1531: );
1532: END RELIEVE_RESERVATION;
1533:
1534: ---------------------------------------------------------------------------------------------------------------------

Line 1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1540: -- Function : API to change the demand source type, called when pushed to production
1541: -- Pre-reqs :
1542: -- Standard IN Parameters :
1543: -- p_api_version IN NUMBER Required
1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1547: -- p_module_type IN VARCHAR2 Default NULL
1548: -- Standard OUT Parameters :

Line 1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1541: -- Pre-reqs :
1542: -- Standard IN Parameters :
1543: -- p_api_version IN NUMBER Required
1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1547: -- p_module_type IN VARCHAR2 Default NULL
1548: -- Standard OUT Parameters :
1549: -- x_return_status OUT VARCHAR2 Required

Line 1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1542: -- Standard IN Parameters :
1543: -- p_api_version IN NUMBER Required
1544: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1545: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1546: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1547: -- p_module_type IN VARCHAR2 Default NULL
1548: -- Standard OUT Parameters :
1549: -- x_return_status OUT VARCHAR2 Required
1550: -- x_msg_count OUT NUMBER Required

Line 1560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1556: -- End of Comments.
1557: ---------------------------------------------------------------------------------------------------------------------
1558: PROCEDURE TRANSFER_RESERVATION(
1559: p_api_version IN NUMBER := 1.0,
1560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1563: p_module_type IN VARCHAR2,
1564: x_return_status OUT NOCOPY VARCHAR2,

Line 1561: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1557: ---------------------------------------------------------------------------------------------------------------------
1558: PROCEDURE TRANSFER_RESERVATION(
1559: p_api_version IN NUMBER := 1.0,
1560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1563: p_module_type IN VARCHAR2,
1564: x_return_status OUT NOCOPY VARCHAR2,
1565: x_msg_count OUT NOCOPY NUMBER,

Line 1562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1558: PROCEDURE TRANSFER_RESERVATION(
1559: p_api_version IN NUMBER := 1.0,
1560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1563: p_module_type IN VARCHAR2,
1564: x_return_status OUT NOCOPY VARCHAR2,
1565: x_msg_count OUT NOCOPY NUMBER,
1566: x_msg_data OUT NOCOPY VARCHAR2,

Line 1629: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1625: -- Standard start of API savepoint
1626: SAVEPOINT TRANSFER_RESERVATION_PVT;
1627:
1628: -- Initialize return status to success before any code logic/validation
1629: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1630:
1631: -- Standard call to check for call compatibility
1632: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1633: THEN

Line 1632: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1628: -- Initialize return status to success before any code logic/validation
1629: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1630:
1631: -- Standard call to check for call compatibility
1632: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1633: THEN
1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END IF;
1636:

Line 1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1630:
1631: -- Standard call to check for call compatibility
1632: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1633: THEN
1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1638: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 1637: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

1633: THEN
1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1638: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1639: THEN
1640: FND_MSG_PUB.INITIALIZE;
1641: END IF;

Line 1638: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1638: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1639: THEN
1640: FND_MSG_PUB.INITIALIZE;
1641: END IF;
1642:

Line 1721: p_is_transfer_supply => fnd_api.g_false,

1717: p_init_msg_lst => l_init_msg_list,
1718: x_return_status => l_return_status,
1719: x_msg_count => l_msg_count,
1720: x_msg_data => l_msg_data,
1721: p_is_transfer_supply => fnd_api.g_false,
1722: p_original_rsv_rec => l_from_rsv_rec,
1723: p_to_rsv_rec => l_to_rsv_rec,
1724: p_original_serial_number=> l_from_serial_number_tbl,
1725: p_to_serial_number => l_to_serial_number_tbl,

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

1726: x_to_reservation_id => l_x_to_reservation_id
1727: );
1728:
1729: -- Check for the returned status from these APIs
1730: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1731: CLOSE get_reservation_csr;
1732: CLOSE get_mtl_req_dtls_csr;
1733: IF (l_log_error >= l_log_current_level) THEN
1734: fnd_log.string

Line 1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

1734: fnd_log.string
1735: (
1736: fnd_log.level_error,
1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
1739: );
1740: END IF;
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
1739: );
1740: END IF;
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: CLOSE get_reservation_csr;
1744: CLOSE get_mtl_req_dtls_csr;
1745: IF (l_log_error >= l_log_current_level) THEN

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

1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
1739: );
1740: END IF;
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: CLOSE get_reservation_csr;
1744: CLOSE get_mtl_req_dtls_csr;
1745: IF (l_log_error >= l_log_current_level) THEN
1746: fnd_log.string

Line 1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

1746: fnd_log.string
1747: (
1748: fnd_log.level_error,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
1751: );
1752: END IF;
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;

Line 1753: RAISE FND_API.G_EXC_ERROR;

1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
1751: );
1752: END IF;
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;
1755: END LOOP ; -- get_reservation_csr,for all the reservations for this material req
1756: CLOSE get_reservation_csr;
1757: END LOOP; --get_mtl_req_dtls_csr, for all the mat reqs of this visit

Line 1774: RAISE FND_API.G_EXC_ERROR;

1770: -- Check Error Message stack.
1771: x_msg_count := FND_MSG_PUB.count_msg;
1772: IF x_msg_count > 0
1773: THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:
1777: -- Commit if p_commit = FND_API.G_TRUE
1778: IF FND_API.TO_BOOLEAN(p_commit)

Line 1777: -- Commit if p_commit = FND_API.G_TRUE

1773: THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:
1777: -- Commit if p_commit = FND_API.G_TRUE
1778: IF FND_API.TO_BOOLEAN(p_commit)
1779: THEN
1780: COMMIT WORK;
1781: END IF;

Line 1778: IF FND_API.TO_BOOLEAN(p_commit)

1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;
1776:
1777: -- Commit if p_commit = FND_API.G_TRUE
1778: IF FND_API.TO_BOOLEAN(p_commit)
1779: THEN
1780: COMMIT WORK;
1781: END IF;
1782:

Line 1788: p_encoded => FND_API.G_FALSE

1784: FND_MSG_PUB.count_and_get
1785: (
1786: p_count => x_msg_count,
1787: p_data => x_msg_data,
1788: p_encoded => FND_API.G_FALSE
1789: );
1790:
1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN

Line 1792: WHEN FND_API.G_EXC_ERROR THEN

1788: p_encoded => FND_API.G_FALSE
1789: );
1790:
1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN
1793: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: FND_MSG_PUB.count_and_get
1796: (

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790:
1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN
1793: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: FND_MSG_PUB.count_and_get
1796: (
1797: p_count => x_msg_count,
1798: p_data => x_msg_data,

Line 1799: p_encoded => FND_API.G_FALSE

1795: FND_MSG_PUB.count_and_get
1796: (
1797: p_count => x_msg_count,
1798: p_data => x_msg_data,
1799: p_encoded => FND_API.G_FALSE
1800: );
1801:
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO TRANSFER_RESERVATION_PVT;

Line 1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1798: p_data => x_msg_data,
1799: p_encoded => FND_API.G_FALSE
1800: );
1801:
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1805: FND_MSG_PUB.count_and_get
1806: (

Line 1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1800: );
1801:
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1805: FND_MSG_PUB.count_and_get
1806: (
1807: p_count => x_msg_count,
1808: p_data => x_msg_data,

Line 1809: p_encoded => FND_API.G_FALSE

1805: FND_MSG_PUB.count_and_get
1806: (
1807: p_count => x_msg_count,
1808: p_data => x_msg_data,
1809: p_encoded => FND_API.G_FALSE
1810: );
1811:
1812: WHEN OTHERS THEN
1813: ROLLBACK TO TRANSFER_RESERVATION_PVT;

Line 1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1810: );
1811:
1812: WHEN OTHERS THEN
1813: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1816: THEN
1817: FND_MSG_PUB.add_exc_msg
1818: (

Line 1828: p_encoded => FND_API.G_FALSE

1824: FND_MSG_PUB.count_and_get
1825: (
1826: p_count => x_msg_count,
1827: p_data => x_msg_data,
1828: p_encoded => FND_API.G_FALSE
1829: );
1830: END TRANSFER_RESERVATION;
1831:
1832:

Line 1914: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1910: -- Standard start of API savepoint
1911: SAVEPOINT UPDATE_VISIT_RESERVATIONS_PVT;
1912:
1913: -- Initialize return status to success before any code logic/validation
1914: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Log API entry point
1917: IF (l_log_procedure >= l_log_current_level)THEN
1918: fnd_log.string

Line 1987: RAISE FND_API.G_EXC_ERROR;

1983: );
1984: END IF;
1985: CLOSE get_upd_rsv_csr;
1986: CLOSE get_mtl_req_id_csr;
1987: RAISE FND_API.G_EXC_ERROR;
1988: END IF; -- IF get_mtl_req_id_csr%NOTFOUND
1989: CLOSE get_mtl_req_id_csr;
1990:
1991: IF (l_log_statement >= l_log_current_level) THEN

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

2071: p_to_serial_number => l_to_serial_number_tbl--,
2072: );
2073:
2074: -- Check for the returned status from these APIs
2075: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2076: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: -- log the error
2079: IF (l_log_statement >= l_log_current_level) THEN

Line 2076: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2072: );
2073:
2074: -- Check for the returned status from these APIs
2075: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2076: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: -- log the error
2079: IF (l_log_statement >= l_log_current_level) THEN
2080: fnd_log.string

Line 2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2073:
2074: -- Check for the returned status from these APIs
2075: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2076: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: -- log the error
2079: IF (l_log_statement >= l_log_current_level) THEN
2080: fnd_log.string
2081: (

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

2083: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'
2085: );
2086: END IF;
2087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: --RAISE FND_API.G_EXC_ERROR;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: -- log the error
2091: IF (l_log_statement >= l_log_current_level) THEN

Line 2088: --RAISE FND_API.G_EXC_ERROR;

2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'
2085: );
2086: END IF;
2087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: --RAISE FND_API.G_EXC_ERROR;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: -- log the error
2091: IF (l_log_statement >= l_log_current_level) THEN
2092: fnd_log.string

Line 2089: x_return_status := FND_API.G_RET_STS_ERROR;

2085: );
2086: END IF;
2087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: --RAISE FND_API.G_EXC_ERROR;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: -- log the error
2091: IF (l_log_statement >= l_log_current_level) THEN
2092: fnd_log.string
2093: (

Line 2183: x_return_status:= FND_API.G_RET_STS_SUCCESS;

2179: -- Standard start of API savepoint
2180: SAVEPOINT DELETE_VISIT_RESERVATIONS_PVT;
2181:
2182: -- Initialize return status to success before any code logic/validation
2183: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2184:
2185: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2186: /* IF FND_API.TO_BOOLEAN(p_init_msg_list)
2187: THEN

Line 2185: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

2181:
2182: -- Initialize return status to success before any code logic/validation
2183: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2184:
2185: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2186: /* IF FND_API.TO_BOOLEAN(p_init_msg_list)
2187: THEN
2188: FND_MSG_PUB.INITIALIZE;
2189: END IF;

Line 2186: /* IF FND_API.TO_BOOLEAN(p_init_msg_list)

2182: -- Initialize return status to success before any code logic/validation
2183: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2184:
2185: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2186: /* IF FND_API.TO_BOOLEAN(p_init_msg_list)
2187: THEN
2188: FND_MSG_PUB.INITIALIZE;
2189: END IF;
2190: */

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

2216: p_rsv_rec => l_rsv_rec,
2217: p_serial_number => l_serial_number_tbl
2218: );
2219: -- Check for the returned status from these APIs
2220: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;

Line 2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2217: p_serial_number => l_serial_number_tbl
2218: );
2219: -- Check for the returned status from these APIs
2220: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;
2225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2218: );
2219: -- Check for the returned status from these APIs
2220: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: END IF;

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

2219: -- Check for the returned status from these APIs
2220: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: END IF;
2227: END LOOP;

Line 2224: --RAISE FND_API.G_EXC_ERROR;

2220: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: END IF;
2227: END LOOP;
2228: CLOSE get_del_rsv_csr;

Line 2225: x_return_status := FND_API.G_RET_STS_ERROR;

2221: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2224: --RAISE FND_API.G_EXC_ERROR;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: END IF;
2227: END LOOP;
2228: CLOSE get_del_rsv_csr;
2229:

Line 2443: --RAISE FND_API.G_EXC_ERROR;

2439: x_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.rt_oper_material_id;
2440: ELSE
2441: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ONLY_PLN_SPF_TSK' );
2442: FND_MSG_PUB.ADD;
2443: --RAISE FND_API.G_EXC_ERROR;
2444: x_return_status := FND_API.G_RET_STS_ERROR;
2445: END IF; -- l_get_mtl_req_dtls_rec.task_status_code = 'RELEASED'
2446:
2447: -- Log API exit point

Line 2444: x_return_status := FND_API.G_RET_STS_ERROR;

2440: ELSE
2441: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ONLY_PLN_SPF_TSK' );
2442: FND_MSG_PUB.ADD;
2443: --RAISE FND_API.G_EXC_ERROR;
2444: x_return_status := FND_API.G_RET_STS_ERROR;
2445: END IF; -- l_get_mtl_req_dtls_rec.task_status_code = 'RELEASED'
2446:
2447: -- Log API exit point
2448: IF (l_log_procedure >= l_log_current_level)THEN

Line 2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

2465: -- Function : API to transfer the reservations from one material requirement to another
2466: -- Pre-reqs :
2467: -- Standard IN Parameters :
2468: -- p_api_version IN NUMBER Required
2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2472: -- p_module_type IN VARCHAR2 Default NULL
2473: -- Standard OUT Parameters :

Line 2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2466: -- Pre-reqs :
2467: -- Standard IN Parameters :
2468: -- p_api_version IN NUMBER Required
2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2472: -- p_module_type IN VARCHAR2 Default NULL
2473: -- Standard OUT Parameters :
2474: -- x_return_status OUT VARCHAR2 Required

Line 2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2467: -- Standard IN Parameters :
2468: -- p_api_version IN NUMBER Required
2469: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2470: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2471: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2472: -- p_module_type IN VARCHAR2 Default NULL
2473: -- Standard OUT Parameters :
2474: -- x_return_status OUT VARCHAR2 Required
2475: -- x_msg_count OUT NUMBER Required

Line 2489: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2485: -- End of Comments.
2486: ---------------------------------------------------------------------------------------------------------------------
2487: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
2488: p_api_version IN NUMBER := 1.0,
2489: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2490: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2492: p_module_type IN VARCHAR2,
2493: x_return_status OUT NOCOPY VARCHAR2,

Line 2490: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2486: ---------------------------------------------------------------------------------------------------------------------
2487: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
2488: p_api_version IN NUMBER := 1.0,
2489: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2490: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2492: p_module_type IN VARCHAR2,
2493: x_return_status OUT NOCOPY VARCHAR2,
2494: x_msg_count OUT NOCOPY NUMBER,

Line 2491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2487: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
2488: p_api_version IN NUMBER := 1.0,
2489: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2490: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2492: p_module_type IN VARCHAR2,
2493: x_return_status OUT NOCOPY VARCHAR2,
2494: x_msg_count OUT NOCOPY NUMBER,
2495: x_msg_data OUT NOCOPY VARCHAR2,

Line 2529: x_return_status:= FND_API.G_RET_STS_SUCCESS;

2525: -- Standard start of API savepoint
2526: SAVEPOINT TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2527:
2528: -- Initialize return status to success before any code logic/validation
2529: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2530:
2531: -- Standard call to check for call compatibility
2532: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2533: THEN

Line 2532: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

2528: -- Initialize return status to success before any code logic/validation
2529: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2530:
2531: -- Standard call to check for call compatibility
2532: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2533: THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536:

Line 2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2530:
2531: -- Standard call to check for call compatibility
2532: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2533: THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536:
2537: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2538: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 2537: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

2533: THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536:
2537: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2538: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2539: THEN
2540: FND_MSG_PUB.INITIALIZE;
2541: END IF;

Line 2538: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536:
2537: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2538: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2539: THEN
2540: FND_MSG_PUB.INITIALIZE;
2541: END IF;
2542:

Line 2570: p_is_transfer_supply => fnd_api.g_false,

2566: p_init_msg_lst => l_init_msg_list,
2567: x_return_status => l_return_status,
2568: x_msg_count => l_msg_count,
2569: x_msg_data => l_msg_data,
2570: p_is_transfer_supply => fnd_api.g_false,
2571: p_original_rsv_rec => l_from_rsv_rec,
2572: p_to_rsv_rec => l_to_rsv_rec,
2573: p_original_serial_number=> l_from_serial_number_tbl,
2574: p_to_serial_number => l_to_serial_number_tbl,

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

2575: x_to_reservation_id => l_x_to_reservation_id
2576: );
2577:
2578: -- Check for the returned status from these APIs
2579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2580: IF (l_log_error >= l_log_current_level) THEN
2581: fnd_log.string
2582: (
2583: fnd_log.level_error,

Line 2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

2581: fnd_log.string
2582: (
2583: fnd_log.level_error,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
2586: );
2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
2586: );
2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2590: IF (l_log_error >= l_log_current_level) THEN
2591: fnd_log.string
2592: (

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

2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
2586: );
2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2590: IF (l_log_error >= l_log_current_level) THEN
2591: fnd_log.string
2592: (
2593: fnd_log.level_error,

Line 2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

2591: fnd_log.string
2592: (
2593: fnd_log.level_error,
2594: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
2596: );
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;

Line 2598: RAISE FND_API.G_EXC_ERROR;

2594: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
2596: );
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;
2600:
2601: -- Log API exit point
2602: IF (l_log_procedure >= l_log_current_level)THEN

Line 2615: RAISE FND_API.G_EXC_ERROR;

2611: -- Check Error Message stack.
2612: x_msg_count := FND_MSG_PUB.count_msg;
2613: IF x_msg_count > 0
2614: THEN
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617:
2618: -- Commit if p_commit = FND_API.G_TRUE
2619: IF FND_API.TO_BOOLEAN(p_commit)

Line 2618: -- Commit if p_commit = FND_API.G_TRUE

2614: THEN
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617:
2618: -- Commit if p_commit = FND_API.G_TRUE
2619: IF FND_API.TO_BOOLEAN(p_commit)
2620: THEN
2621: COMMIT WORK;
2622: END IF;

Line 2619: IF FND_API.TO_BOOLEAN(p_commit)

2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617:
2618: -- Commit if p_commit = FND_API.G_TRUE
2619: IF FND_API.TO_BOOLEAN(p_commit)
2620: THEN
2621: COMMIT WORK;
2622: END IF;
2623:

Line 2629: p_encoded => FND_API.G_FALSE

2625: FND_MSG_PUB.count_and_get
2626: (
2627: p_count => x_msg_count,
2628: p_data => x_msg_data,
2629: p_encoded => FND_API.G_FALSE
2630: );
2631:
2632: EXCEPTION
2633: WHEN FND_API.G_EXC_ERROR THEN

Line 2633: WHEN FND_API.G_EXC_ERROR THEN

2629: p_encoded => FND_API.G_FALSE
2630: );
2631:
2632: EXCEPTION
2633: WHEN FND_API.G_EXC_ERROR THEN
2634: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: FND_MSG_PUB.count_and_get
2637: (

Line 2635: x_return_status := FND_API.G_RET_STS_ERROR;

2631:
2632: EXCEPTION
2633: WHEN FND_API.G_EXC_ERROR THEN
2634: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: FND_MSG_PUB.count_and_get
2637: (
2638: p_count => x_msg_count,
2639: p_data => x_msg_data,

Line 2640: p_encoded => FND_API.G_FALSE

2636: FND_MSG_PUB.count_and_get
2637: (
2638: p_count => x_msg_count,
2639: p_data => x_msg_data,
2640: p_encoded => FND_API.G_FALSE
2641: );
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;

Line 2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2639: p_data => x_msg_data,
2640: p_encoded => FND_API.G_FALSE
2641: );
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.count_and_get
2647: (

Line 2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2641: );
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.count_and_get
2647: (
2648: p_count => x_msg_count,
2649: p_data => x_msg_data,

Line 2650: p_encoded => FND_API.G_FALSE

2646: FND_MSG_PUB.count_and_get
2647: (
2648: p_count => x_msg_count,
2649: p_data => x_msg_data,
2650: p_encoded => FND_API.G_FALSE
2651: );
2652:
2653: WHEN OTHERS THEN
2654: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;

Line 2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2651: );
2652:
2653: WHEN OTHERS THEN
2654: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2657: THEN
2658: FND_MSG_PUB.add_exc_msg
2659: (

Line 2669: p_encoded => FND_API.G_FALSE

2665: FND_MSG_PUB.count_and_get
2666: (
2667: p_count => x_msg_count,
2668: p_data => x_msg_data,
2669: p_encoded => FND_API.G_FALSE
2670: );
2671: END TRNSFR_RSRV_FOR_MATRL_REQR;
2672:
2673: -- Helper procedure added by skpathak on 12-NOV-2008 for bug 7241925