DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_GRP dependencies on FND_API

Line 165: IF(l_return_status = fnd_api.g_ret_sts_success) THEN

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;

Line 556: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:

Line 558: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 566: x_return_status := fnd_api.g_ret_sts_success;

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

Line 588: WHEN fnd_api.g_exc_error 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

Line 590: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 592: WHEN fnd_api.g_exc_unexpected_error THEN

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;

Line 594: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 597: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 633: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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;

Line 634: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 673: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

Line 674: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 687: WHEN fnd_api.g_exc_error THEN

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

Line 689: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 691: WHEN fnd_api.g_exc_unexpected_error THEN

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;

Line 693: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 696: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 739: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:

Line 741: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 796: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

Line 797: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 806: RAISE fnd_api.g_exc_unexpected_error;

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;

Line 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

Line 860: WHEN fnd_api.g_exc_error 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

Line 862: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 864: WHEN fnd_api.g_exc_unexpected_error THEN

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;

Line 866: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 869: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 928: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:

Line 930: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 937: x_return_status := fnd_api.g_ret_sts_success;

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

Line 959: RAISE fnd_api.g_exc_unexpected_error;

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

Line 969: WHEN fnd_api.g_exc_error 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

Line 971: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 973: WHEN fnd_api.g_exc_unexpected_error THEN

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;

Line 975: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 978: x_return_status := fnd_api.g_ret_sts_unexp_error;

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: