161: 1.0,
162: l_return_status,
163: p_req_line_id,
164: NULL);
165: IF(l_return_status = fnd_api.g_ret_sts_success) THEN
166: RETURN 'Y';
167: ELSE
168: RETURN 'N';
169: END IF;
552: l_progress := '020';
553:
554: -- Standard call to check for call compatibility
555:
556: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557:
558: RAISE fnd_api.g_exc_unexpected_error;
559: END IF;
560:
554: -- Standard call to check for call compatibility
555:
556: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557:
558: RAISE fnd_api.g_exc_unexpected_error;
559: END IF;
560:
561: l_progress := '030';
562:
562:
563:
564: -- Initialize API return status to success
565:
566: x_return_status := fnd_api.g_ret_sts_success;
567:
568: l_progress := '050';
569:
570: IF g_debug_stmt THEN
584: END IF;
585:
586: EXCEPTION
587:
588: WHEN fnd_api.g_exc_error THEN
589: ROLLBACK TO get_preparer_name_sp;
590: x_return_status := fnd_api.g_ret_sts_error;
591:
592: WHEN fnd_api.g_exc_unexpected_error THEN
586: EXCEPTION
587:
588: WHEN fnd_api.g_exc_error THEN
589: ROLLBACK TO get_preparer_name_sp;
590: x_return_status := fnd_api.g_ret_sts_error;
591:
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: ROLLBACK TO get_preparer_name_sp;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
588: WHEN fnd_api.g_exc_error THEN
589: ROLLBACK TO get_preparer_name_sp;
590: x_return_status := fnd_api.g_ret_sts_error;
591:
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: ROLLBACK TO get_preparer_name_sp;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: WHEN OTHERS THEN
596: ROLLBACK TO get_preparer_name_sp;
590: x_return_status := fnd_api.g_ret_sts_error;
591:
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: ROLLBACK TO get_preparer_name_sp;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: WHEN OTHERS THEN
596: ROLLBACK TO get_preparer_name_sp;
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598: IF g_debug_stmt THEN
593: ROLLBACK TO get_preparer_name_sp;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: WHEN OTHERS THEN
596: ROLLBACK TO get_preparer_name_sp;
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598: IF g_debug_stmt THEN
599: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
600: END IF;
601: END get_preparer_name;
629: l_progress := '010';
630:
631: -- Standard call to check for call compatibility
632:
633: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
634: RAISE fnd_api.g_exc_unexpected_error;
635: END IF;
636:
637: END update_reqcancel_from_so;
630:
631: -- Standard call to check for call compatibility
632:
633: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
634: RAISE fnd_api.g_exc_unexpected_error;
635: END IF;
636:
637: END update_reqcancel_from_so;
638:
669: l_progress := '020';
670:
671: -- Standard call to check for call compatibility
672:
673: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
674: RAISE fnd_api.g_exc_unexpected_error;
675: END IF;
676:
677: l_progress := '030';
670:
671: -- Standard call to check for call compatibility
672:
673: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
674: RAISE fnd_api.g_exc_unexpected_error;
675: END IF;
676:
677: l_progress := '030';
678:
683: END IF;
684:
685: EXCEPTION
686:
687: WHEN fnd_api.g_exc_error THEN
688: ROLLBACK TO update_reqcancel_from_so_sp;
689: x_return_status := fnd_api.g_ret_sts_error;
690:
691: WHEN fnd_api.g_exc_unexpected_error THEN
685: EXCEPTION
686:
687: WHEN fnd_api.g_exc_error THEN
688: ROLLBACK TO update_reqcancel_from_so_sp;
689: x_return_status := fnd_api.g_ret_sts_error;
690:
691: WHEN fnd_api.g_exc_unexpected_error THEN
692: ROLLBACK TO update_reqcancel_from_so_sp;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
687: WHEN fnd_api.g_exc_error THEN
688: ROLLBACK TO update_reqcancel_from_so_sp;
689: x_return_status := fnd_api.g_ret_sts_error;
690:
691: WHEN fnd_api.g_exc_unexpected_error THEN
692: ROLLBACK TO update_reqcancel_from_so_sp;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: WHEN OTHERS THEN
695: ROLLBACK TO update_reqcancel_from_so_sp;
689: x_return_status := fnd_api.g_ret_sts_error;
690:
691: WHEN fnd_api.g_exc_unexpected_error THEN
692: ROLLBACK TO update_reqcancel_from_so_sp;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: WHEN OTHERS THEN
695: ROLLBACK TO update_reqcancel_from_so_sp;
696: x_return_status := fnd_api.g_ret_sts_unexp_error;
697: IF g_debug_stmt THEN
692: ROLLBACK TO update_reqcancel_from_so_sp;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: WHEN OTHERS THEN
695: ROLLBACK TO update_reqcancel_from_so_sp;
696: x_return_status := fnd_api.g_ret_sts_unexp_error;
697: IF g_debug_stmt THEN
698: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
699: END IF;
700: END update_reqcancel_from_so;
735: l_progress := '010';
736:
737: -- Standard call to check for call compatibility
738:
739: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
740:
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
737: -- Standard call to check for call compatibility
738:
739: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
740:
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: END update_reqchange_from_so;
745:
792: l_progress := '020';
793:
794: -- Standard call to check for call compatibility
795:
796: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
797: RAISE fnd_api.g_exc_unexpected_error;
798: END IF;
799:
800: l_progress := '030';
793:
794: -- Standard call to check for call compatibility
795:
796: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
797: RAISE fnd_api.g_exc_unexpected_error;
798: END IF;
799:
800: l_progress := '030';
801:
802: IF (p_req_line_id_tbl IS NULL OR p_req_line_id_tbl.Count=0 ) THEN
803: IF g_debug_stmt THEN
804: po_debug.debug_stmt(l_log_head, l_progress,'Procedure update_ReqCancel_from_SO called with no req line id from OM');
805: END IF;
806: RAISE fnd_api.g_exc_unexpected_error;
807: END IF;
808:
809: -- Initialize API return status to success
810: x_return_status := fnd_api.g_ret_sts_success;
806: RAISE fnd_api.g_exc_unexpected_error;
807: END IF;
808:
809: -- Initialize API return status to success
810: x_return_status := fnd_api.g_ret_sts_success;
811:
812: l_progress := '050';
813:
814: IF g_debug_stmt THEN
856: END IF;
857:
858: EXCEPTION
859:
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO update_reqcancel_from_so_sp;
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: WHEN fnd_api.g_exc_unexpected_error THEN
858: EXCEPTION
859:
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO update_reqcancel_from_so_sp;
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: WHEN fnd_api.g_exc_unexpected_error THEN
865: ROLLBACK TO update_reqcancel_from_so_sp;
866: x_return_status := fnd_api.g_ret_sts_unexp_error;
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO update_reqcancel_from_so_sp;
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: WHEN fnd_api.g_exc_unexpected_error THEN
865: ROLLBACK TO update_reqcancel_from_so_sp;
866: x_return_status := fnd_api.g_ret_sts_unexp_error;
867: WHEN OTHERS THEN
868: ROLLBACK TO update_reqcancel_from_so_sp;
862: x_return_status := fnd_api.g_ret_sts_error;
863:
864: WHEN fnd_api.g_exc_unexpected_error THEN
865: ROLLBACK TO update_reqcancel_from_so_sp;
866: x_return_status := fnd_api.g_ret_sts_unexp_error;
867: WHEN OTHERS THEN
868: ROLLBACK TO update_reqcancel_from_so_sp;
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870: IF g_debug_stmt THEN
865: ROLLBACK TO update_reqcancel_from_so_sp;
866: x_return_status := fnd_api.g_ret_sts_unexp_error;
867: WHEN OTHERS THEN
868: ROLLBACK TO update_reqcancel_from_so_sp;
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870: IF g_debug_stmt THEN
871: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
872: END IF;
873: END update_reqcancel_from_so;
924: l_progress := '020';
925:
926: -- Standard call to check for call compatibility
927:
928: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
929:
930: RAISE fnd_api.g_exc_unexpected_error;
931: END IF;
932:
926: -- Standard call to check for call compatibility
927:
928: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
929:
930: RAISE fnd_api.g_exc_unexpected_error;
931: END IF;
932:
933: l_progress := '040';
934:
933: l_progress := '040';
934:
935: -- Initialize API return status to success
936:
937: x_return_status := fnd_api.g_ret_sts_success;
938:
939: l_progress := '050';
940:
941: IF g_debug_stmt THEN
955: , p_new_need_by_date => p_new_need_by_date
956: , x_return_status => x_return_status);
957:
958: ELSE
959: RAISE fnd_api.g_exc_unexpected_error;
960: END IF;
961:
962:
963: IF g_debug_stmt THEN
965: END IF;
966:
967: EXCEPTION
968:
969: WHEN fnd_api.g_exc_error THEN
970: ROLLBACK TO update_reqchange_from_so_sp;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: WHEN fnd_api.g_exc_unexpected_error THEN
967: EXCEPTION
968:
969: WHEN fnd_api.g_exc_error THEN
970: ROLLBACK TO update_reqchange_from_so_sp;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: WHEN fnd_api.g_exc_unexpected_error THEN
974: ROLLBACK TO update_reqchange_from_so_sp;
975: x_return_status := fnd_api.g_ret_sts_unexp_error;
969: WHEN fnd_api.g_exc_error THEN
970: ROLLBACK TO update_reqchange_from_so_sp;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: WHEN fnd_api.g_exc_unexpected_error THEN
974: ROLLBACK TO update_reqchange_from_so_sp;
975: x_return_status := fnd_api.g_ret_sts_unexp_error;
976: WHEN OTHERS THEN
977: ROLLBACK TO update_reqchange_from_so_sp;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: WHEN fnd_api.g_exc_unexpected_error THEN
974: ROLLBACK TO update_reqchange_from_so_sp;
975: x_return_status := fnd_api.g_ret_sts_unexp_error;
976: WHEN OTHERS THEN
977: ROLLBACK TO update_reqchange_from_so_sp;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: IF g_debug_stmt THEN
974: ROLLBACK TO update_reqchange_from_so_sp;
975: x_return_status := fnd_api.g_ret_sts_unexp_error;
976: WHEN OTHERS THEN
977: ROLLBACK TO update_reqchange_from_so_sp;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: IF g_debug_stmt THEN
980: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
981: END IF;
982: