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 548: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

544: l_progress := '020';
545:
546: -- Standard call to check for call compatibility
547: dbms_output.put_line('p_api_version=' || p_api_version);
548: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
549: dbms_output.put_line('inside if ');
550: RAISE fnd_api.g_exc_unexpected_error;
551: END IF;
552:

Line 550: RAISE fnd_api.g_exc_unexpected_error;

546: -- Standard call to check for call compatibility
547: dbms_output.put_line('p_api_version=' || p_api_version);
548: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
549: dbms_output.put_line('inside if ');
550: RAISE fnd_api.g_exc_unexpected_error;
551: END IF;
552:
553: l_progress := '030';
554:

Line 558: x_return_status := fnd_api.g_ret_sts_success;

554:
555:
556: -- Initialize API return status to success
557:
558: x_return_status := fnd_api.g_ret_sts_success;
559:
560: l_progress := '050';
561:
562: IF g_debug_stmt THEN

Line 580: WHEN fnd_api.g_exc_error THEN

576: END IF;
577:
578: EXCEPTION
579:
580: WHEN fnd_api.g_exc_error THEN
581: ROLLBACK TO get_preparer_name_sp;
582: x_return_status := fnd_api.g_ret_sts_error;
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN

Line 582: x_return_status := fnd_api.g_ret_sts_error;

578: EXCEPTION
579:
580: WHEN fnd_api.g_exc_error THEN
581: ROLLBACK TO get_preparer_name_sp;
582: x_return_status := fnd_api.g_ret_sts_error;
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: ROLLBACK TO get_preparer_name_sp;
586: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 584: WHEN fnd_api.g_exc_unexpected_error THEN

580: WHEN fnd_api.g_exc_error THEN
581: ROLLBACK TO get_preparer_name_sp;
582: x_return_status := fnd_api.g_ret_sts_error;
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: ROLLBACK TO get_preparer_name_sp;
586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587: WHEN OTHERS THEN
588: ROLLBACK TO get_preparer_name_sp;

Line 586: x_return_status := fnd_api.g_ret_sts_unexp_error;

582: x_return_status := fnd_api.g_ret_sts_error;
583:
584: WHEN fnd_api.g_exc_unexpected_error THEN
585: ROLLBACK TO get_preparer_name_sp;
586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587: WHEN OTHERS THEN
588: ROLLBACK TO get_preparer_name_sp;
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: IF g_debug_stmt THEN

Line 589: x_return_status := fnd_api.g_ret_sts_unexp_error;

585: ROLLBACK TO get_preparer_name_sp;
586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587: WHEN OTHERS THEN
588: ROLLBACK TO get_preparer_name_sp;
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: IF g_debug_stmt THEN
591: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
592: END IF;
593: END get_preparer_name;

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

627: l_progress := '020';
628:
629: -- Standard call to check for call compatibility
630: dbms_output.put_line('p_api_version=' || p_api_version);
631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
632: dbms_output.put_line('inside if ');
633: RAISE fnd_api.g_exc_unexpected_error;
634: END IF;
635:

Line 633: RAISE fnd_api.g_exc_unexpected_error;

629: -- Standard call to check for call compatibility
630: dbms_output.put_line('p_api_version=' || p_api_version);
631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
632: dbms_output.put_line('inside if ');
633: RAISE fnd_api.g_exc_unexpected_error;
634: END IF;
635:
636: l_progress := '030';
637:

Line 640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

636: l_progress := '030';
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: /*
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: */
644: l_progress := '040';

Line 648: x_return_status := fnd_api.g_ret_sts_success;

644: l_progress := '040';
645:
646: -- Initialize API return status to success
647:
648: x_return_status := fnd_api.g_ret_sts_success;
649:
650: l_progress := '050';
651:
652: IF g_debug_stmt THEN

Line 663: RAISE fnd_api.g_exc_unexpected_error;

659: po_rco_validation_pvt.update_reqcancel_from_so(p_req_hdr_id => p_req_hdr_id
660: , p_req_line_id => p_req_line_id
661: , x_return_status => x_return_status);
662: ELSE
663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:
666:
667: IF g_debug_stmt THEN

Line 673: WHEN fnd_api.g_exc_error THEN

669: END IF;
670:
671: EXCEPTION
672:
673: WHEN fnd_api.g_exc_error THEN
674: ROLLBACK TO update_reqcancel_from_so_sp;
675: x_return_status := fnd_api.g_ret_sts_error;
676:
677: WHEN fnd_api.g_exc_unexpected_error THEN

Line 675: x_return_status := fnd_api.g_ret_sts_error;

671: EXCEPTION
672:
673: WHEN fnd_api.g_exc_error THEN
674: ROLLBACK TO update_reqcancel_from_so_sp;
675: x_return_status := fnd_api.g_ret_sts_error;
676:
677: WHEN fnd_api.g_exc_unexpected_error THEN
678: ROLLBACK TO update_reqcancel_from_so_sp;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 677: WHEN fnd_api.g_exc_unexpected_error THEN

673: WHEN fnd_api.g_exc_error THEN
674: ROLLBACK TO update_reqcancel_from_so_sp;
675: x_return_status := fnd_api.g_ret_sts_error;
676:
677: WHEN fnd_api.g_exc_unexpected_error THEN
678: ROLLBACK TO update_reqcancel_from_so_sp;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: WHEN OTHERS THEN
681: ROLLBACK TO update_reqcancel_from_so_sp;

Line 679: x_return_status := fnd_api.g_ret_sts_unexp_error;

675: x_return_status := fnd_api.g_ret_sts_error;
676:
677: WHEN fnd_api.g_exc_unexpected_error THEN
678: ROLLBACK TO update_reqcancel_from_so_sp;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: WHEN OTHERS THEN
681: ROLLBACK TO update_reqcancel_from_so_sp;
682: x_return_status := fnd_api.g_ret_sts_unexp_error;
683: IF g_debug_stmt THEN

Line 682: x_return_status := fnd_api.g_ret_sts_unexp_error;

678: ROLLBACK TO update_reqcancel_from_so_sp;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: WHEN OTHERS THEN
681: ROLLBACK TO update_reqcancel_from_so_sp;
682: x_return_status := fnd_api.g_ret_sts_unexp_error;
683: IF g_debug_stmt THEN
684: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
685: END IF;
686: END update_reqcancel_from_so;

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

723: l_progress := '020';
724:
725: -- Standard call to check for call compatibility
726: dbms_output.put_line('p_api_version=' || p_api_version);
727: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
728: dbms_output.put_line('inside if ');
729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:

Line 729: RAISE fnd_api.g_exc_unexpected_error;

725: -- Standard call to check for call compatibility
726: dbms_output.put_line('p_api_version=' || p_api_version);
727: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
728: dbms_output.put_line('inside if ');
729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:
732: l_progress := '030';
733:

Line 736: IF FND_API.to_Boolean( p_init_msg_list ) THEN

732: l_progress := '030';
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: /*
736: IF FND_API.to_Boolean( p_init_msg_list ) THEN
737: FND_MSG_PUB.initialize;
738: END IF;
739: */
740: l_progress := '040';

Line 744: x_return_status := fnd_api.g_ret_sts_success;

740: l_progress := '040';
741:
742: -- Initialize API return status to success
743:
744: x_return_status := fnd_api.g_ret_sts_success;
745:
746: l_progress := '050';
747:
748: IF g_debug_stmt THEN

Line 765: RAISE fnd_api.g_exc_unexpected_error;

761: , p_new_need_by_date => p_new_need_by_date
762: , x_return_status => x_return_status);
763:
764: ELSE
765: RAISE fnd_api.g_exc_unexpected_error;
766: END IF;
767:
768:
769: IF g_debug_stmt THEN

Line 775: WHEN fnd_api.g_exc_error THEN

771: END IF;
772:
773: EXCEPTION
774:
775: WHEN fnd_api.g_exc_error THEN
776: ROLLBACK TO update_reqcancel_from_so_sp;
777: x_return_status := fnd_api.g_ret_sts_error;
778:
779: WHEN fnd_api.g_exc_unexpected_error THEN

Line 777: x_return_status := fnd_api.g_ret_sts_error;

773: EXCEPTION
774:
775: WHEN fnd_api.g_exc_error THEN
776: ROLLBACK TO update_reqcancel_from_so_sp;
777: x_return_status := fnd_api.g_ret_sts_error;
778:
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO update_reqcancel_from_so_sp;
781: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 779: WHEN fnd_api.g_exc_unexpected_error THEN

775: WHEN fnd_api.g_exc_error THEN
776: ROLLBACK TO update_reqcancel_from_so_sp;
777: x_return_status := fnd_api.g_ret_sts_error;
778:
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO update_reqcancel_from_so_sp;
781: x_return_status := fnd_api.g_ret_sts_unexp_error;
782: WHEN OTHERS THEN
783: ROLLBACK TO update_reqcancel_from_so_sp;

Line 781: x_return_status := fnd_api.g_ret_sts_unexp_error;

777: x_return_status := fnd_api.g_ret_sts_error;
778:
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO update_reqcancel_from_so_sp;
781: x_return_status := fnd_api.g_ret_sts_unexp_error;
782: WHEN OTHERS THEN
783: ROLLBACK TO update_reqcancel_from_so_sp;
784: x_return_status := fnd_api.g_ret_sts_unexp_error;
785: IF g_debug_stmt THEN

Line 784: x_return_status := fnd_api.g_ret_sts_unexp_error;

780: ROLLBACK TO update_reqcancel_from_so_sp;
781: x_return_status := fnd_api.g_ret_sts_unexp_error;
782: WHEN OTHERS THEN
783: ROLLBACK TO update_reqcancel_from_so_sp;
784: x_return_status := fnd_api.g_ret_sts_unexp_error;
785: IF g_debug_stmt THEN
786: po_debug.debug_var(l_log_head, l_progress,'EXCEPTION: Location and SQL CODE is ', SQLCODE);
787: END IF;
788: END update_reqchange_from_so;