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.OZF_SD_REQUEST_PUB dependencies on FND_MSG_PUB

Line 6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfpsdrb.pls 120.14.12010000.10 2009/02/04 09:22:57 bkunjan ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(14) := 'ozfpsdrb.pls';
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: G_ITEM_ORG_ID NUMBER;
8: G_REQUEST_HEADER_ID NUMBER;
9:
10: -----------------------------------------------------------------------

Line 523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

519: FETCH c_user INTO l_user_id;
520: CLOSE c_user;
521:
522: IF l_user_id IS NULL THEN
523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
524: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_ID');
525: --//User Id is invalid, Please re-enter
526: FND_MSG_PUB.add;
527: END IF;

Line 526: FND_MSG_PUB.add;

522: IF l_user_id IS NULL THEN
523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
524: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_ID');
525: --//User Id is invalid, Please re-enter
526: FND_MSG_PUB.add;
527: END IF;
528: x_return_status := fnd_api.g_ret_sts_error;
529: RETURN;
530: ELSE --// Check if User is a valid resource or not

Line 536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

532: FETCH c_resource_id INTO l_resource_id;
533: CLOSE c_resource_id;
534:
535: IF l_resource_id IS NULL THEN
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
538: FND_MSG_PUB.add;
539: END IF;
540: x_return_status := fnd_api.g_ret_sts_error;

Line 538: FND_MSG_PUB.add;

534:
535: IF l_resource_id IS NULL THEN
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
538: FND_MSG_PUB.add;
539: END IF;
540: x_return_status := fnd_api.g_ret_sts_error;
541: RETURN;
542: END IF;

Line 549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

545: END IF;
546: END IF;
547:
548: ELSE
549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
550: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_ID');
551: --//User Id is Mandatory
552: FND_MSG_PUB.add;
553: END IF;

Line 552: FND_MSG_PUB.add;

548: ELSE
549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
550: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_ID');
551: --//User Id is Mandatory
552: FND_MSG_PUB.add;
553: END IF;
554: x_return_status := fnd_api.g_ret_sts_error;
555: RETURN;
556: END IF;

Line 565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

561: FETCH c_org_id INTO l_org_id;
562: CLOSE c_org_id;
563:
564: IF l_org_id IS NULL THEN
565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
566: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ORG_ID');
567: --//Organization id entered is invalid
568: FND_MSG_PUB.add;
569: END IF;

Line 568: FND_MSG_PUB.add;

564: IF l_org_id IS NULL THEN
565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
566: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ORG_ID');
567: --//Organization id entered is invalid
568: FND_MSG_PUB.add;
569: END IF;
570: x_return_status := fnd_api.g_ret_sts_error;
571: RETURN;
572: END IF;

Line 576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

572: END IF;
573: --//Set Org ID to Global Variable
574: -- G_ORG_ID := p_SDR_hdr_rec.org_id;
575: ELSE
576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
577: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ORG_ID');
578: --//Organization id is Mandatory
579: FND_MSG_PUB.add;
580: END IF;

Line 579: FND_MSG_PUB.add;

575: ELSE
576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
577: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ORG_ID');
578: --//Organization id is Mandatory
579: FND_MSG_PUB.add;
580: END IF;
581: x_return_status := fnd_api.g_ret_sts_error;
582: RETURN;
583: END IF;

Line 595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

591: FETCH c_requestor_id INTO l_requestor_id;
592: CLOSE c_requestor_id;
593:
594: IF l_requestor_id IS NULL THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUESTOR_ID');
597: --//Requestor id entered is invalid
598: IF G_DEBUG THEN
599: OZF_UTILITY_PVT.debug_message('Requestor id entered is invalid');

Line 601: FND_MSG_PUB.add;

597: --//Requestor id entered is invalid
598: IF G_DEBUG THEN
599: OZF_UTILITY_PVT.debug_message('Requestor id entered is invalid');
600: END IF;
601: FND_MSG_PUB.add;
602: END IF;
603: x_return_status := fnd_api.g_ret_sts_error;
604: RETURN;
605: END IF;

Line 624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

620: FETCH c_supp_id INTO l_supplier_id;
621: CLOSE c_supp_id;
622:
623: IF l_supplier_id IS NULL THEN
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPPLIER_ID');
626: --//Supplier id entered is invalid
627: FND_MSG_PUB.add;
628: END IF;

Line 627: FND_MSG_PUB.add;

623: IF l_supplier_id IS NULL THEN
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPPLIER_ID');
626: --//Supplier id entered is invalid
627: FND_MSG_PUB.add;
628: END IF;
629: x_return_status := fnd_api.g_ret_sts_error;
630: RETURN;
631: END IF;

Line 634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

630: RETURN;
631: END IF;
632:
633: ELSE
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SUPPLIER_ID');
636: --//Supplier id is Mandatory
637: FND_MSG_PUB.add;
638: END IF;

Line 637: FND_MSG_PUB.add;

633: ELSE
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SUPPLIER_ID');
636: --//Supplier id is Mandatory
637: FND_MSG_PUB.add;
638: END IF;
639: x_return_status := fnd_api.g_ret_sts_error;
640: RETURN;
641: END IF;

Line 653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

649: FETCH c_supplier_site_id INTO l_supplier_site_id;
650: CLOSE c_supplier_site_id;
651:
652: IF l_supplier_site_id IS NULL THEN
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
654: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPPLIER_SITE_ID');
655: --//Supplier site id entered is invalid
656: FND_MSG_PUB.add;
657: END IF;

Line 656: FND_MSG_PUB.add;

652: IF l_supplier_site_id IS NULL THEN
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
654: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPPLIER_SITE_ID');
655: --//Supplier site id entered is invalid
656: FND_MSG_PUB.add;
657: END IF;
658: x_return_status := fnd_api.g_ret_sts_error;
659: RETURN;
660: END IF;

Line 663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

659: RETURN;
660: END IF;
661:
662: ELSE
663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
664: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SUPPLIER_SITE_ID');
665: --//Supplier site id is Mandatory
666: FND_MSG_PUB.add;
667: END IF;

Line 666: FND_MSG_PUB.add;

662: ELSE
663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
664: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SUPPLIER_SITE_ID');
665: --//Supplier site id is Mandatory
666: FND_MSG_PUB.add;
667: END IF;
668: x_return_status := fnd_api.g_ret_sts_error;
669: RETURN;
670: END IF;

Line 686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

682: IF l_supplier_contact_id IS NOT NULL THEN
683: p_SDR_hdr_rec.supplier_contact_name := l_sup_contact_full_name;
684: ELSE
685: IF p_SDR_hdr_rec.supplier_contact_name = FND_API.g_miss_char OR p_SDR_hdr_rec.supplier_contact_name IS NULL THEN
686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
687: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPP_CONTACT_ID');
688: --//Supplier contact id entered is invalid
689: FND_MSG_PUB.add;
690: END IF;

Line 689: FND_MSG_PUB.add;

685: IF p_SDR_hdr_rec.supplier_contact_name = FND_API.g_miss_char OR p_SDR_hdr_rec.supplier_contact_name IS NULL THEN
686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
687: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPP_CONTACT_ID');
688: --//Supplier contact id entered is invalid
689: FND_MSG_PUB.add;
690: END IF;
691: x_return_status := fnd_api.g_ret_sts_error;
692: RETURN;
693: ELSE

Line 714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

710:
711: IF p_SDR_hdr_rec.supplier_response_by_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
712: p_SDR_hdr_rec.request_end_date THEN
713:
714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
715: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPRESPB_DATE');
716: FND_MSG_PUB.add;
717: END IF;
718: x_return_status := fnd_api.g_ret_sts_error;

Line 716: FND_MSG_PUB.add;

712: p_SDR_hdr_rec.request_end_date THEN
713:
714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
715: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPRESPB_DATE');
716: FND_MSG_PUB.add;
717: END IF;
718: x_return_status := fnd_api.g_ret_sts_error;
719: RETURN;
720: END IF;

Line 730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

726:
727: IF p_SDR_hdr_rec.supplier_response_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
728: p_SDR_hdr_rec.request_end_date THEN
729:
730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
731: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPRESP_DATE');
732: FND_MSG_PUB.add;
733: END IF;
734: x_return_status := fnd_api.g_ret_sts_error;

Line 732: FND_MSG_PUB.add;

728: p_SDR_hdr_rec.request_end_date THEN
729:
730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
731: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPRESP_DATE');
732: FND_MSG_PUB.add;
733: END IF;
734: x_return_status := fnd_api.g_ret_sts_error;
735: RETURN;
736: END IF;

Line 746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

742:
743: IF p_SDR_hdr_rec.supplier_submission_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
744: p_SDR_hdr_rec.request_end_date THEN
745:
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
747: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPSUB_DATE');
748: FND_MSG_PUB.add;
749: END IF;
750: x_return_status := fnd_api.g_ret_sts_error;

Line 748: FND_MSG_PUB.add;

744: p_SDR_hdr_rec.request_end_date THEN
745:
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
747: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPSUB_DATE');
748: FND_MSG_PUB.add;
749: END IF;
750: x_return_status := fnd_api.g_ret_sts_error;
751: RETURN;
752: END IF;

Line 775: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

771: FETCH c_requestor_id INTO l_assignee_resource_id;
772: CLOSE c_requestor_id;
773:
774: IF l_assignee_resource_id IS NULL THEN
775: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
776: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASSIGNEE_ID');
777: --//Assignee id entered is invalid (Approver)
778: FND_MSG_PUB.add;
779: END IF;

Line 778: FND_MSG_PUB.add;

774: IF l_assignee_resource_id IS NULL THEN
775: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
776: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASSIGNEE_ID');
777: --//Assignee id entered is invalid (Approver)
778: FND_MSG_PUB.add;
779: END IF;
780: x_return_status := fnd_api.g_ret_sts_error;
781: RETURN;
782: END IF;

Line 784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

780: x_return_status := fnd_api.g_ret_sts_error;
781: RETURN;
782: END IF;
783: ELSE
784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
785: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ASSIGNEE_ID');
786: --//Assignee resource id is Mandatory (Approver is mandatory)
787: FND_MSG_PUB.add;
788: END IF;

Line 787: FND_MSG_PUB.add;

783: ELSE
784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
785: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ASSIGNEE_ID');
786: --//Assignee resource id is Mandatory (Approver is mandatory)
787: FND_MSG_PUB.add;
788: END IF;
789: x_return_status := fnd_api.g_ret_sts_error;
790: RETURN;
791: END IF;

Line 800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

796:
797: IF p_SDR_hdr_rec.assignee_response_by_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
798: p_SDR_hdr_rec.request_end_date THEN
799:
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
801: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASRESPB_DATE');
802: FND_MSG_PUB.add;
803: END IF;
804: x_return_status := fnd_api.g_ret_sts_error;

Line 802: FND_MSG_PUB.add;

798: p_SDR_hdr_rec.request_end_date THEN
799:
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
801: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASRESPB_DATE');
802: FND_MSG_PUB.add;
803: END IF;
804: x_return_status := fnd_api.g_ret_sts_error;
805: RETURN;
806: END IF;

Line 816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

812:
813: IF p_SDR_hdr_rec.assignee_response_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
814: p_SDR_hdr_rec.request_end_date THEN
815:
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASRESP_DATE');
818: FND_MSG_PUB.add;
819: END IF;
820: x_return_status := fnd_api.g_ret_sts_error;

Line 818: FND_MSG_PUB.add;

814: p_SDR_hdr_rec.request_end_date THEN
815:
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ASRESP_DATE');
818: FND_MSG_PUB.add;
819: END IF;
820: x_return_status := fnd_api.g_ret_sts_error;
821: RETURN;
822: END IF;

Line 854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

850: FETCH c_cust_account_id INTO l_cust_account_id;
851: CLOSE c_cust_account_id;
852:
853: IF l_cust_account_id IS NULL THEN
854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
855: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
856: --//Cust Account ID entered is invalid
857: FND_MSG_PUB.add;
858: END IF;

Line 857: FND_MSG_PUB.add;

853: IF l_cust_account_id IS NULL THEN
854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
855: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
856: --//Cust Account ID entered is invalid
857: FND_MSG_PUB.add;
858: END IF;
859: x_return_status := fnd_api.g_ret_sts_error;
860: RETURN;
861: END IF;

Line 864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

860: RETURN;
861: END IF;
862:
863: ELSE
864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
865: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
866: --//Cust Account id is Mandatory
867: FND_MSG_PUB.add;
868: END IF;

Line 867: FND_MSG_PUB.add;

863: ELSE
864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
865: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
866: --//Cust Account id is Mandatory
867: FND_MSG_PUB.add;
868: END IF;
869: x_return_status := fnd_api.g_ret_sts_error;
870: RETURN;
871: END IF;

Line 891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

887: p_SDR_hdr_rec.request_end_date := p_SDR_hdr_rec.request_start_date + l_authorization_period;
888: END IF;
889:
890: ELSIF p_SDR_hdr_rec.request_end_date < p_SDR_hdr_rec.request_start_date THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_DATE');
893: --//End date should be greater than start date
894: FND_MSG_PUB.add;
895: END IF;

Line 894: FND_MSG_PUB.add;

890: ELSIF p_SDR_hdr_rec.request_end_date < p_SDR_hdr_rec.request_start_date THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_DATE');
893: --//End date should be greater than start date
894: FND_MSG_PUB.add;
895: END IF;
896: x_return_status := fnd_api.g_ret_sts_error;
897: RETURN;
898: END IF;

Line 912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

908: FETCH c_currency INTO l_currency_code;
909: CLOSE c_currency;
910:
911: IF l_currency_code IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CURRENCY_CODE');
914: FND_MSG_PUB.add;
915: END IF;
916: x_return_status := fnd_api.g_ret_sts_error;

Line 914: FND_MSG_PUB.add;

910:
911: IF l_currency_code IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CURRENCY_CODE');
914: FND_MSG_PUB.add;
915: END IF;
916: x_return_status := fnd_api.g_ret_sts_error;
917: RETURN;
918: END IF;

Line 925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

921: p_SDR_hdr_rec.request_currency_code :=FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY');
922:
923: IF p_SDR_hdr_rec.request_currency_code IS NULL THEN
924:
925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
926: FND_MESSAGE.set_name('OZF', 'OZF_SD_ADD_PROFILE_CURRENCY');
927: --//Please set default Currency in profile JTF_PROFILE_DEFAULT_CURRENCY
928: FND_MSG_PUB.add;
929: END IF;

Line 928: FND_MSG_PUB.add;

924:
925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
926: FND_MESSAGE.set_name('OZF', 'OZF_SD_ADD_PROFILE_CURRENCY');
927: --//Please set default Currency in profile JTF_PROFILE_DEFAULT_CURRENCY
928: FND_MSG_PUB.add;
929: END IF;
930: x_return_status := fnd_api.g_ret_sts_error;
931: RETURN;
932: END IF;

Line 943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

939: ,p_lookup_type =>'OZF_SD_REQUEST_OUTCOME'
940: ,p_lookup_code => p_SDR_hdr_rec.request_outcome);
941:
942: IF l_lookup_stat = FND_API.g_false THEN
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
944: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQ_OUTCOME');
945: FND_MSG_PUB.add;
946: END IF;
947: x_return_status := fnd_api.g_ret_sts_error;

Line 945: FND_MSG_PUB.add;

941:
942: IF l_lookup_stat = FND_API.g_false THEN
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
944: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQ_OUTCOME');
945: FND_MSG_PUB.add;
946: END IF;
947: x_return_status := fnd_api.g_ret_sts_error;
948: RETURN;
949: END IF;

Line 959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

955: FETCH c_order_no INTO l_internal_order_number;
956: CLOSE c_order_no;
957:
958: IF l_internal_order_number IS NULL THEN
959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
960: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ORDER_NUMBER'); --//Seed
961: FND_MSG_PUB.add;
962: END IF;
963: x_return_status := fnd_api.g_ret_sts_error;

Line 961: FND_MSG_PUB.add;

957:
958: IF l_internal_order_number IS NULL THEN
959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
960: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ORDER_NUMBER'); --//Seed
961: FND_MSG_PUB.add;
962: END IF;
963: x_return_status := fnd_api.g_ret_sts_error;
964: RETURN;
965: END IF;

Line 975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

971: FETCH c_currency INTO l_sales_order_currency;
972: CLOSE c_currency;
973:
974: IF l_sales_order_currency IS NULL THEN
975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
976: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SO_CURRENCY');
977: --//Invalid Sales order Currency.
978: FND_MSG_PUB.add;
979: END IF;

Line 978: FND_MSG_PUB.add;

974: IF l_sales_order_currency IS NULL THEN
975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
976: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SO_CURRENCY');
977: --//Invalid Sales order Currency.
978: FND_MSG_PUB.add;
979: END IF;
980: x_return_status := fnd_api.g_ret_sts_error;
981: RETURN;
982: END IF;

Line 992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

988:
989: IF p_SDR_hdr_rec.internal_submission_date NOT BETWEEN p_SDR_hdr_rec.request_start_date AND
990: p_SDR_hdr_rec.request_end_date THEN
991:
992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
993: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_INTSUB_DATE');
994: FND_MSG_PUB.add;
995: END IF;
996: x_return_status := fnd_api.g_ret_sts_error;

Line 994: FND_MSG_PUB.add;

990: p_SDR_hdr_rec.request_end_date THEN
991:
992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
993: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_INTSUB_DATE');
994: FND_MSG_PUB.add;
995: END IF;
996: x_return_status := fnd_api.g_ret_sts_error;
997: RETURN;
998: END IF;

Line 1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1208: FETCH c_request_line_id INTO l_request_line_id;
1209: CLOSE c_request_line_id;
1210:
1211: IF l_request_line_id IS NULL THEN
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1213: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_LINE_ID');
1214: --//Request Line id is Invalid , Please Re-enter
1215: FND_MSG_PUB.add;
1216: END IF;

Line 1215: FND_MSG_PUB.add;

1211: IF l_request_line_id IS NULL THEN
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1213: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_LINE_ID');
1214: --//Request Line id is Invalid , Please Re-enter
1215: FND_MSG_PUB.add;
1216: END IF;
1217: x_return_status := fnd_api.g_ret_sts_error;
1218: RETURN;
1219: ELSE

Line 1345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1341: ,p_lookup_type =>'OZF_SD_PRODUCT_CONTEXT'
1342: ,p_lookup_code => p_SDR_lines_tbl(i).product_context);
1343:
1344: IF l_lookup_stat = FND_API.g_false THEN
1345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1346: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_TYPE');
1347: FND_MSG_PUB.add;
1348: END IF;
1349: x_return_status := fnd_api.g_ret_sts_error;

Line 1347: FND_MSG_PUB.add;

1343:
1344: IF l_lookup_stat = FND_API.g_false THEN
1345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1346: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_TYPE');
1347: FND_MSG_PUB.add;
1348: END IF;
1349: x_return_status := fnd_api.g_ret_sts_error;
1350: RETURN;
1351: END IF;

Line 1353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1349: x_return_status := fnd_api.g_ret_sts_error;
1350: RETURN;
1351: END IF;
1352: ELSE
1353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1354: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_CONTEXT');
1355: --//Product context is Mandatory
1356: FND_MSG_PUB.add;
1357: END IF;

Line 1356: FND_MSG_PUB.add;

1352: ELSE
1353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1354: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_CONTEXT');
1355: --//Product context is Mandatory
1356: FND_MSG_PUB.add;
1357: END IF;
1358: x_return_status := fnd_api.g_ret_sts_error;
1359: RETURN;
1360: END IF;

Line 1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1372: FETCH c_inventory_item_id INTO l_inventory_item_id;
1373: CLOSE c_inventory_item_id;
1374:
1375: IF l_inventory_item_id IS NULL THEN
1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1377: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_INVENTORY_ITEM_ID');
1378: --//Inventory item id is Invalid
1379: FND_MSG_PUB.add;
1380: END IF;

Line 1379: FND_MSG_PUB.add;

1375: IF l_inventory_item_id IS NULL THEN
1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1377: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_INVENTORY_ITEM_ID');
1378: --//Inventory item id is Invalid
1379: FND_MSG_PUB.add;
1380: END IF;
1381: x_return_status := fnd_api.g_ret_sts_error;
1382: RETURN;
1383: END IF;

Line 1402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1398: FETCH c_ext_int_code INTO l_external_code,l_internal_code;
1399: CLOSE c_ext_int_code;
1400:
1401: IF l_external_code IS NULL THEN
1402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1403: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_VENDOR_ITEM_CODE');
1404: FND_MSG_PUB.add;
1405: END IF;
1406: x_return_status := fnd_api.g_ret_sts_error;

Line 1404: FND_MSG_PUB.add;

1400:
1401: IF l_external_code IS NULL THEN
1402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1403: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_VENDOR_ITEM_CODE');
1404: FND_MSG_PUB.add;
1405: END IF;
1406: x_return_status := fnd_api.g_ret_sts_error;
1407: RETURN;
1408: END IF;

Line 1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1408: END IF;
1409: p_SDR_lines_tbl(i).inventory_item_id := l_internal_code;
1410:
1411: ELSE
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1413: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_INVENTORY_ITEM_ID');
1414: --//Inventory item id is mandatory
1415: FND_MSG_PUB.add;
1416: END IF;

Line 1415: FND_MSG_PUB.add;

1411: ELSE
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1413: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_INVENTORY_ITEM_ID');
1414: --//Inventory item id is mandatory
1415: FND_MSG_PUB.add;
1416: END IF;
1417: x_return_status := fnd_api.g_ret_sts_error;
1418: RETURN;
1419: END IF;

Line 1430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1426: FETCH c_item_uom INTO l_item_uom;
1427: CLOSE c_item_uom;
1428:
1429: IF l_item_uom IS NULL THEN
1430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1431: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ITEM_UOM');
1432: --//Unit of Measurement is Invalid
1433: FND_MSG_PUB.add;
1434: END IF;

Line 1433: FND_MSG_PUB.add;

1429: IF l_item_uom IS NULL THEN
1430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1431: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ITEM_UOM');
1432: --//Unit of Measurement is Invalid
1433: FND_MSG_PUB.add;
1434: END IF;
1435: x_return_status := fnd_api.g_ret_sts_error;
1436: RETURN;
1437: END IF;

Line 1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1435: x_return_status := fnd_api.g_ret_sts_error;
1436: RETURN;
1437: END IF;
1438: ELSE
1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1440: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ITEM_UOM');
1441: --//Unit of Measurement is mandatory
1442: FND_MSG_PUB.add;
1443: END IF;

Line 1442: FND_MSG_PUB.add;

1438: ELSE
1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1440: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ITEM_UOM');
1441: --//Unit of Measurement is mandatory
1442: FND_MSG_PUB.add;
1443: END IF;
1444: x_return_status := fnd_api.g_ret_sts_error;
1445: RETURN;
1446: END IF;

Line 1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1451: FETCH c_product_cost INTO p_SDR_lines_tbl(i).product_cost;
1452: CLOSE c_product_cost;
1453:
1454: IF p_SDR_lines_tbl(i).product_cost IS NULL THEN
1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1456: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_COST');
1457: --//A value must be entered for Product Cost
1458: FND_MSG_PUB.add;
1459: END IF;

Line 1458: FND_MSG_PUB.add;

1454: IF p_SDR_lines_tbl(i).product_cost IS NULL THEN
1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1456: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_COST');
1457: --//A value must be entered for Product Cost
1458: FND_MSG_PUB.add;
1459: END IF;
1460: x_return_status := fnd_api.g_ret_sts_error;
1461: RETURN;
1462: END IF;

Line 1481: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1477: FETCH c_category_id INTO l_category_id;
1478: CLOSE c_category_id;
1479:
1480: IF l_category_id IS NULL THEN
1481: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1482: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_CATEGORY');
1483: --//Product category is Invalid
1484: FND_MSG_PUB.add;
1485: END IF;

Line 1484: FND_MSG_PUB.add;

1480: IF l_category_id IS NULL THEN
1481: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1482: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_CATEGORY');
1483: --//Product category is Invalid
1484: FND_MSG_PUB.add;
1485: END IF;
1486: x_return_status := fnd_api.g_ret_sts_error;
1487: RETURN;
1488: END IF;

Line 1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1486: x_return_status := fnd_api.g_ret_sts_error;
1487: RETURN;
1488: END IF;
1489: ELSE
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1491: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_CATEGORY');
1492: --//Product category is mandatory
1493: FND_MSG_PUB.add;
1494: END IF;

Line 1493: FND_MSG_PUB.add;

1489: ELSE
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1491: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_CATEGORY');
1492: --//Product category is mandatory
1493: FND_MSG_PUB.add;
1494: END IF;
1495: x_return_status := fnd_api.g_ret_sts_error;
1496: RETURN;
1497: END IF;

Line 1508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1504: FETCH c_category_set_id INTO l_category_set_id;
1505: CLOSE c_category_set_id;
1506:
1507: IF l_category_set_id IS NULL THEN
1508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1509: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_CATEGORY_SET');
1510: --//Product category set is Invalid
1511: FND_MSG_PUB.add;
1512: END IF;

Line 1511: FND_MSG_PUB.add;

1507: IF l_category_set_id IS NULL THEN
1508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1509: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRODUCT_CATEGORY_SET');
1510: --//Product category set is Invalid
1511: FND_MSG_PUB.add;
1512: END IF;
1513: x_return_status := fnd_api.g_ret_sts_error;
1514: RETURN;
1515: END IF;

Line 1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1524: ,p_lookup_type =>'OZF_SD_REQUEST_DISTYPE'
1525: ,p_lookup_code => p_SDR_lines_tbl(i).requested_discount_type);
1526:
1527: IF l_lookup_stat = FND_API.g_false THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1529: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_DISCOUNT_TYPE');
1530: FND_MSG_PUB.add;
1531: END IF;
1532: x_return_status := fnd_api.g_ret_sts_error;

Line 1530: FND_MSG_PUB.add;

1526:
1527: IF l_lookup_stat = FND_API.g_false THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1529: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_DISCOUNT_TYPE');
1530: FND_MSG_PUB.add;
1531: END IF;
1532: x_return_status := fnd_api.g_ret_sts_error;
1533: RETURN;
1534: END IF;

Line 1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1532: x_return_status := fnd_api.g_ret_sts_error;
1533: RETURN;
1534: END IF;
1535: ELSE
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1537: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_DISCOUNT_TYPE');
1538: FND_MSG_PUB.add;
1539: END IF;
1540: x_return_status := fnd_api.g_ret_sts_error;

Line 1538: FND_MSG_PUB.add;

1534: END IF;
1535: ELSE
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1537: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_DISCOUNT_TYPE');
1538: FND_MSG_PUB.add;
1539: END IF;
1540: x_return_status := fnd_api.g_ret_sts_error;
1541: RETURN;
1542: END IF;

Line 1547: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1543:
1544: --//Requested discount Value
1545:
1546: IF p_SDR_lines_tbl(i).requested_discount_value = FND_API.g_miss_num OR p_SDR_lines_tbl(i).requested_discount_value IS NULL THEN
1547: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1548: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_DISC_VALUE');
1549: FND_MSG_PUB.add;
1550: END IF;
1551: x_return_status := fnd_api.g_ret_sts_error;

Line 1549: FND_MSG_PUB.add;

1545:
1546: IF p_SDR_lines_tbl(i).requested_discount_value = FND_API.g_miss_num OR p_SDR_lines_tbl(i).requested_discount_value IS NULL THEN
1547: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1548: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_DISC_VALUE');
1549: FND_MSG_PUB.add;
1550: END IF;
1551: x_return_status := fnd_api.g_ret_sts_error;
1552: RETURN;
1553: ELSE

Line 1556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1552: RETURN;
1553: ELSE
1554: l_status := check_zero(p_SDR_lines_tbl(i).requested_discount_value);
1555: IF l_status = FND_API.g_false THEN
1556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1557: FND_MESSAGE.set_name('OZF', 'OZF_SD_DISCOUNT_VALUE_IS_ZERO'); --//Check the message!
1558: --//Discount value should not be zero
1559: FND_MSG_PUB.add;
1560: END IF;

Line 1559: FND_MSG_PUB.add;

1555: IF l_status = FND_API.g_false THEN
1556: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1557: FND_MESSAGE.set_name('OZF', 'OZF_SD_DISCOUNT_VALUE_IS_ZERO'); --//Check the message!
1558: --//Discount value should not be zero
1559: FND_MSG_PUB.add;
1560: END IF;
1561: x_return_status := fnd_api.g_ret_sts_error;
1562: RETURN;
1563: END IF;

Line 1578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1574: --//Max Qty
1575: IF p_SDR_lines_tbl(i).max_qty <> FND_API.g_miss_num AND p_SDR_lines_tbl(i).max_qty IS NOT NULL THEN
1576: l_status := check_zero(p_SDR_lines_tbl(i).max_qty);
1577: IF l_status = FND_API.g_false THEN
1578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1579: FND_MESSAGE.set_name('OZF', 'OZF_SD_MAX_QTY_ZERO_CHECK'); --//Check the message!
1580: --//Discount value should not be zero
1581: FND_MSG_PUB.add;
1582: END IF;

Line 1581: FND_MSG_PUB.add;

1577: IF l_status = FND_API.g_false THEN
1578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1579: FND_MESSAGE.set_name('OZF', 'OZF_SD_MAX_QTY_ZERO_CHECK'); --//Check the message!
1580: --//Discount value should not be zero
1581: FND_MSG_PUB.add;
1582: END IF;
1583: x_return_status := fnd_api.g_ret_sts_error;
1584: RETURN;
1585: END IF;

Line 1602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1598: --//End Customer price
1599: IF p_SDR_lines_tbl(i).end_customer_price <> FND_API.g_miss_num AND p_SDR_lines_tbl(i).end_customer_price IS NOT NULL THEN
1600: l_status := check_zero(p_SDR_lines_tbl(i).end_customer_price);
1601: IF l_status = FND_API.g_false THEN
1602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1603: FND_MESSAGE.set_name('OZF', 'OZF_SD_END_CUST_PRICE_VALUE_IS_ZERO');
1604: --//Discount value should not be zero
1605: FND_MSG_PUB.add;
1606: END IF;

Line 1605: FND_MSG_PUB.add;

1601: IF l_status = FND_API.g_false THEN
1602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1603: FND_MESSAGE.set_name('OZF', 'OZF_SD_END_CUST_PRICE_VALUE_IS_ZERO');
1604: --//Discount value should not be zero
1605: FND_MSG_PUB.add;
1606: END IF;
1607: x_return_status := fnd_api.g_ret_sts_error;
1608: RETURN;
1609: END IF;

Line 1617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1613: IF p_SDR_lines_tbl(i).vendor_approved_flag <> FND_API.g_miss_char OR p_SDR_lines_tbl(i).vendor_approved_flag IS NULL THEN
1614: p_SDR_lines_tbl(i).vendor_approved_flag := 'Y';
1615: ELSE
1616: IF p_SDR_lines_tbl(i).vendor_approved_flag NOT IN ('Y','N')THEN
1617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1618: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_VENDOR_APPR_FLAG');
1619: FND_MSG_PUB.add;
1620: END IF;
1621: x_return_status := fnd_api.g_ret_sts_error;

Line 1619: FND_MSG_PUB.add;

1615: ELSE
1616: IF p_SDR_lines_tbl(i).vendor_approved_flag NOT IN ('Y','N')THEN
1617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1618: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_VENDOR_APPR_FLAG');
1619: FND_MSG_PUB.add;
1620: END IF;
1621: x_return_status := fnd_api.g_ret_sts_error;
1622: RETURN;
1623: END IF;

Line 1633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1629:
1630: ELSIF TRUNC(p_SDR_lines_tbl(i).start_date) NOT BETWEEN
1631: TRUNC(p_SDR_hdr_rec.request_start_date) AND TRUNC(p_SDR_hdr_rec.request_end_date) THEN
1632:
1633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1634: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_START_DATE_CHECK');
1635: --//Start Date should fall in between Header Start date and End Date
1636: FND_MSG_PUB.add;
1637: END IF;

Line 1636: FND_MSG_PUB.add;

1632:
1633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1634: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_START_DATE_CHECK');
1635: --//Start Date should fall in between Header Start date and End Date
1636: FND_MSG_PUB.add;
1637: END IF;
1638: x_return_status := fnd_api.g_ret_sts_error;
1639: RETURN;
1640: END IF;

Line 1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1645:
1646: ELSIF TRUNC(p_SDR_lines_tbl(i).end_date) NOT BETWEEN
1647: TRUNC(p_SDR_hdr_rec.request_start_date) AND TRUNC(p_SDR_hdr_rec.request_end_date) THEN
1648:
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1650: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_END_DATE_CHECK');
1651: --//End Date should fall in between Header Start date and End Date
1652: FND_MSG_PUB.add;
1653: END IF;

Line 1652: FND_MSG_PUB.add;

1648:
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1650: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_END_DATE_CHECK');
1651: --//End Date should fall in between Header Start date and End Date
1652: FND_MSG_PUB.add;
1653: END IF;
1654: x_return_status := fnd_api.g_ret_sts_error;
1655: RETURN;
1656: END IF;

Line 1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1656: END IF;
1657: END IF;
1658:
1659: IF p_SDR_lines_tbl(i).end_date < p_SDR_lines_tbl(i).start_date THEN
1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1661: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_END_DATE_GT_CHECK');
1662: --//End Date should be greater than start date
1663: FND_MSG_PUB.add;
1664: END IF;

Line 1663: FND_MSG_PUB.add;

1659: IF p_SDR_lines_tbl(i).end_date < p_SDR_lines_tbl(i).start_date THEN
1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1661: FND_MESSAGE.set_name('OZF', 'OZF_SD_LINE_END_DATE_GT_CHECK');
1662: --//End Date should be greater than start date
1663: FND_MSG_PUB.add;
1664: END IF;
1665: x_return_status := fnd_api.g_ret_sts_error;
1666: RETURN;
1667: END IF;

Line 1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1676: ,p_lookup_type =>'OZF_SD_PRICE_TYPE'
1677: ,p_lookup_code => p_SDR_lines_tbl(i).end_customer_price_type);
1678:
1679: IF l_lookup_stat = FND_API.g_false THEN
1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1681: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRICE_TYPE');
1682: FND_MSG_PUB.add;
1683: END IF;
1684: x_return_status := fnd_api.g_ret_sts_error;

Line 1682: FND_MSG_PUB.add;

1678:
1679: IF l_lookup_stat = FND_API.g_false THEN
1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1681: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PRICE_TYPE');
1682: FND_MSG_PUB.add;
1683: END IF;
1684: x_return_status := fnd_api.g_ret_sts_error;
1685: RETURN;
1686: END IF;

Line 1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1693: ,p_lookup_type =>'OZF_SD_TOLERANCE_TYPE'
1694: ,p_lookup_code => p_SDR_lines_tbl(i).end_customer_tolerance_type);
1695:
1696: IF l_lookup_stat = FND_API.g_false THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1698: FND_MESSAGE.set_name('OZF', 'OZF_SD_BAD_TOLERANCE_TYPE');
1699: FND_MSG_PUB.add;
1700: END IF;
1701: x_return_status := fnd_api.g_ret_sts_error;

Line 1699: FND_MSG_PUB.add;

1695:
1696: IF l_lookup_stat = FND_API.g_false THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1698: FND_MESSAGE.set_name('OZF', 'OZF_SD_BAD_TOLERANCE_TYPE');
1699: FND_MSG_PUB.add;
1700: END IF;
1701: x_return_status := fnd_api.g_ret_sts_error;
1702: RETURN;
1703: END IF;

Line 1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1710: ,p_lookup_type =>'OZF_SD_REQ_LINE_REJECT_CODE'
1711: ,p_lookup_code => p_SDR_lines_tbl(i).rejection_code);
1712:
1713: IF l_lookup_stat = FND_API.g_false THEN
1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1715: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REJECTION_CODE');
1716: FND_MSG_PUB.add;
1717: END IF;
1718: x_return_status := fnd_api.g_ret_sts_error;

Line 1716: FND_MSG_PUB.add;

1712:
1713: IF l_lookup_stat = FND_API.g_false THEN
1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1715: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REJECTION_CODE');
1716: FND_MSG_PUB.add;
1717: END IF;
1718: x_return_status := fnd_api.g_ret_sts_error;
1719: RETURN;
1720: END IF;

Line 1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1736: ,p_lookup_type =>'OZF_SP_REQUEST_DISTYPE'
1737: ,p_lookup_code => p_SDR_lines_tbl(i).approved_discount_type);
1738:
1739: IF l_lookup_stat =FND_API.g_false THEN
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1741: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_APPROVED_DISC_TYPE');
1742: FND_MSG_PUB.add;
1743: END IF;
1744: x_return_status := fnd_api.g_ret_sts_error;

Line 1742: FND_MSG_PUB.add;

1738:
1739: IF l_lookup_stat =FND_API.g_false THEN
1740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1741: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_APPROVED_DISC_TYPE');
1742: FND_MSG_PUB.add;
1743: END IF;
1744: x_return_status := fnd_api.g_ret_sts_error;
1745: RETURN;
1746: END IF;

Line 1748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1744: x_return_status := fnd_api.g_ret_sts_error;
1745: RETURN;
1746: END IF;
1747: ELSE
1748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1749: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_DISC_TYPE');
1750: FND_MSG_PUB.add;
1751: END IF;
1752: x_return_status := fnd_api.g_ret_sts_error;

Line 1750: FND_MSG_PUB.add;

1746: END IF;
1747: ELSE
1748: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1749: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_DISC_TYPE');
1750: FND_MSG_PUB.add;
1751: END IF;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: RETURN;
1754: END IF;

Line 1760: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1756: --//Approved discount Value
1757: IF p_SDR_lines_tbl(i).approved_discount_value <> FND_API.g_miss_num AND p_SDR_lines_tbl(i).approved_discount_value IS NOT NULL THEN
1758: l_status := check_zero(p_SDR_lines_tbl(i).approved_discount_value);
1759: IF l_status = FND_API.g_false THEN
1760: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1761: FND_MESSAGE.set_name('OZF', 'OZF_SD_APPR_DISC_VALUE_IS_ZERO');
1762: FND_MSG_PUB.add;
1763: END IF;
1764: x_return_status := fnd_api.g_ret_sts_error;

Line 1762: FND_MSG_PUB.add;

1758: l_status := check_zero(p_SDR_lines_tbl(i).approved_discount_value);
1759: IF l_status = FND_API.g_false THEN
1760: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1761: FND_MESSAGE.set_name('OZF', 'OZF_SD_APPR_DISC_VALUE_IS_ZERO');
1762: FND_MSG_PUB.add;
1763: END IF;
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: RETURN;
1766: END IF;

Line 1768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1764: x_return_status := fnd_api.g_ret_sts_error;
1765: RETURN;
1766: END IF;
1767: ELSE
1768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1769: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_DISC_VALUE');
1770: FND_MSG_PUB.add;
1771: END IF;
1772: x_return_status := fnd_api.g_ret_sts_error;

Line 1770: FND_MSG_PUB.add;

1766: END IF;
1767: ELSE
1768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1769: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_DISC_VALUE');
1770: FND_MSG_PUB.add;
1771: END IF;
1772: x_return_status := fnd_api.g_ret_sts_error;
1773: RETURN;
1774: END IF;

Line 1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1776: --//Approved Max Qty
1777: IF p_SDR_lines_tbl(i).approved_max_qty <> FND_API.g_miss_num AND p_SDR_lines_tbl(i).approved_max_qty IS NOT NULL THEN
1778: l_status := check_zero(p_SDR_lines_tbl(i).approved_max_qty);
1779: IF l_status = FND_API.g_false THEN
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1781: FND_MESSAGE.set_name('OZF', 'OZF_SD_APPR_MAX_QTY_VALUE_IS_ZERO');
1782: FND_MSG_PUB.add;
1783: END IF;
1784: x_return_status := fnd_api.g_ret_sts_error;

Line 1782: FND_MSG_PUB.add;

1778: l_status := check_zero(p_SDR_lines_tbl(i).approved_max_qty);
1779: IF l_status = FND_API.g_false THEN
1780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1781: FND_MESSAGE.set_name('OZF', 'OZF_SD_APPR_MAX_QTY_VALUE_IS_ZERO');
1782: FND_MSG_PUB.add;
1783: END IF;
1784: x_return_status := fnd_api.g_ret_sts_error;
1785: RETURN;
1786: END IF;

Line 1789: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1785: RETURN;
1786: END IF;
1787: /* BugFix : 7501013
1788: ELSE
1789: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1790: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_MAX_QTY');
1791: FND_MSG_PUB.add;
1792: END IF;
1793: x_return_status := fnd_api.g_ret_sts_error;

Line 1791: FND_MSG_PUB.add;

1787: /* BugFix : 7501013
1788: ELSE
1789: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1790: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_APPROVED_MAX_QTY');
1791: FND_MSG_PUB.add;
1792: END IF;
1793: x_return_status := fnd_api.g_ret_sts_error;
1794: RETURN; */
1795: END IF;

Line 1907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1903: FETCH c_request_customer_id INTO l_request_customer_id;
1904: CLOSE c_request_customer_id;
1905:
1906: IF l_request_customer_id IS NULL THEN
1907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1908: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_CUSTOMER_ID');
1909: FND_MSG_PUB.add;
1910: END IF;
1911: x_return_status := fnd_api.g_ret_sts_error;

Line 1909: FND_MSG_PUB.add;

1905:
1906: IF l_request_customer_id IS NULL THEN
1907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1908: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_CUSTOMER_ID');
1909: FND_MSG_PUB.add;
1910: END IF;
1911: x_return_status := fnd_api.g_ret_sts_error;
1912: RETURN;
1913: ELSE

Line 1972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1968: IF p_SDR_cust_tbl(j).end_customer_flag <> FND_API.g_miss_char AND p_SDR_cust_tbl(j).end_customer_flag IS NOT NULL THEN
1969:
1970: IF p_SDR_cust_tbl(j).end_customer_flag NOT IN ('N','Y') THEN
1971:
1972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1973: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_CUST_FLAG');
1974: --//Invalid End Customer flag
1975: FND_MSG_PUB.add;
1976: END IF;

Line 1975: FND_MSG_PUB.add;

1971:
1972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1973: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_CUST_FLAG');
1974: --//Invalid End Customer flag
1975: FND_MSG_PUB.add;
1976: END IF;
1977: x_return_status := fnd_api.g_ret_sts_error;
1978: RETURN;
1979: END IF;

Line 1981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1977: x_return_status := fnd_api.g_ret_sts_error;
1978: RETURN;
1979: END IF;
1980: ELSE
1981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1982: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_END_CUST_FLAG');
1983: --//End Customer Flag is Mandatory
1984: FND_MSG_PUB.add;
1985: END IF;

Line 1984: FND_MSG_PUB.add;

1980: ELSE
1981: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1982: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_END_CUST_FLAG');
1983: --//End Customer Flag is Mandatory
1984: FND_MSG_PUB.add;
1985: END IF;
1986: x_return_status := fnd_api.g_ret_sts_error;
1987: RETURN;
1988: END IF;

Line 1999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1995: ,p_lookup_type =>'OZF_SD_CUSTOMER_TYPE'
1996: ,p_lookup_code => p_SDR_cust_tbl(j).cust_usage_code);
1997:
1998: IF l_lookup_stat = FND_API.g_false THEN
1999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2000: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ADDR_TYPE');
2001: FND_MSG_PUB.add;
2002: END IF;
2003: x_return_status := fnd_api.g_ret_sts_error;

Line 2001: FND_MSG_PUB.add;

1997:
1998: IF l_lookup_stat = FND_API.g_false THEN
1999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2000: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ADDR_TYPE');
2001: FND_MSG_PUB.add;
2002: END IF;
2003: x_return_status := fnd_api.g_ret_sts_error;
2004: RETURN;
2005: END IF;

Line 2010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2006:
2007: --//if end_customer_flag = 'Y' then cust_usage_code should be CUSTOMER only
2008: IF ((p_SDR_cust_tbl(j).end_customer_flag ='Y')
2009: AND (p_SDR_cust_tbl(j).cust_usage_code <> 'CUSTOMER')) THEN
2010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2011: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_COMB');
2012: FND_MSG_PUB.add;
2013: END IF;
2014: x_return_status := fnd_api.g_ret_sts_error;

Line 2012: FND_MSG_PUB.add;

2008: IF ((p_SDR_cust_tbl(j).end_customer_flag ='Y')
2009: AND (p_SDR_cust_tbl(j).cust_usage_code <> 'CUSTOMER')) THEN
2010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2011: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_COMB');
2012: FND_MSG_PUB.add;
2013: END IF;
2014: x_return_status := fnd_api.g_ret_sts_error;
2015: RETURN;
2016: END IF;

Line 2025: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2021: FETCH c_party_id INTO l_party_id;
2022: CLOSE c_party_id;
2023:
2024: IF l_party_id IS NULL THEN
2025: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2026: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PARTY_ID'); --//To set in design
2027: FND_MSG_PUB.add;
2028: END IF;
2029: x_return_status := fnd_api.g_ret_sts_error;

Line 2027: FND_MSG_PUB.add;

2023:
2024: IF l_party_id IS NULL THEN
2025: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2026: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_PARTY_ID'); --//To set in design
2027: FND_MSG_PUB.add;
2028: END IF;
2029: x_return_status := fnd_api.g_ret_sts_error;
2030: RETURN;
2031: END IF;

Line 2033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2029: x_return_status := fnd_api.g_ret_sts_error;
2030: RETURN;
2031: END IF;
2032: ELSE
2033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2034: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PARTY_ID');
2035: --//Party Id is mandatory
2036: FND_MSG_PUB.add;
2037: END IF;

Line 2036: FND_MSG_PUB.add;

2032: ELSE
2033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2034: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PARTY_ID');
2035: --//Party Id is mandatory
2036: FND_MSG_PUB.add;
2037: END IF;
2038: x_return_status := fnd_api.g_ret_sts_error;
2039: RETURN;
2040: END IF;

Line 2051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2047: FETCH c_cust_account_id INTO l_cust_account_id;
2048: CLOSE c_cust_account_id;
2049:
2050: IF l_cust_account_id IS NULL THEN
2051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2052: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
2053: FND_MSG_PUB.add;
2054: END IF;
2055: x_return_status := fnd_api.g_ret_sts_error;

Line 2053: FND_MSG_PUB.add;

2049:
2050: IF l_cust_account_id IS NULL THEN
2051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2052: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
2053: FND_MSG_PUB.add;
2054: END IF;
2055: x_return_status := fnd_api.g_ret_sts_error;
2056: RETURN;
2057: END IF;

Line 2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2055: x_return_status := fnd_api.g_ret_sts_error;
2056: RETURN;
2057: END IF;
2058: ELSE
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2060: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
2061: FND_MSG_PUB.add;
2062: END IF;
2063: x_return_status := fnd_api.g_ret_sts_error;

Line 2061: FND_MSG_PUB.add;

2057: END IF;
2058: ELSE
2059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2060: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
2061: FND_MSG_PUB.add;
2062: END IF;
2063: x_return_status := fnd_api.g_ret_sts_error;
2064: RETURN;
2065: END IF;

Line 2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2073: FETCH c_cust_account_id INTO l_cust_account_id;
2074: CLOSE c_cust_account_id;
2075:
2076: IF l_cust_account_id IS NULL THEN
2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2078: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
2079: FND_MSG_PUB.add;
2080: END IF;
2081: x_return_status := fnd_api.g_ret_sts_error;

Line 2079: FND_MSG_PUB.add;

2075:
2076: IF l_cust_account_id IS NULL THEN
2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2078: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
2079: FND_MSG_PUB.add;
2080: END IF;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: RETURN;
2083: END IF;

Line 2096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2092: FETCH c_site_use_id INTO l_site_use_id;
2093: CLOSE c_site_use_id;
2094:
2095: IF l_site_use_id IS NULL THEN
2096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2097: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SITE_USE_ID');
2098: FND_MSG_PUB.add;
2099: END IF;
2100: x_return_status := fnd_api.g_ret_sts_error;

Line 2098: FND_MSG_PUB.add;

2094:
2095: IF l_site_use_id IS NULL THEN
2096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2097: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SITE_USE_ID');
2098: FND_MSG_PUB.add;
2099: END IF;
2100: x_return_status := fnd_api.g_ret_sts_error;
2101: RETURN;
2102: END IF;

Line 2104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2100: x_return_status := fnd_api.g_ret_sts_error;
2101: RETURN;
2102: END IF;
2103: ELSE
2104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2105: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SITE_USE_ID');
2106: FND_MSG_PUB.add;
2107: END IF;
2108: x_return_status := fnd_api.g_ret_sts_error;

Line 2106: FND_MSG_PUB.add;

2102: END IF;
2103: ELSE
2104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2105: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SITE_USE_ID');
2106: FND_MSG_PUB.add;
2107: END IF;
2108: x_return_status := fnd_api.g_ret_sts_error;
2109: RETURN;
2110: END IF;

Line 2113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2109: RETURN;
2110: END IF;
2111: END IF;
2112: ELSE
2113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2114: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ADDR_TYPE');
2115: --//Invalid Customer Usage Code
2116: FND_MSG_PUB.add;
2117: END IF;

Line 2116: FND_MSG_PUB.add;

2112: ELSE
2113: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2114: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ADDR_TYPE');
2115: --//Invalid Customer Usage Code
2116: FND_MSG_PUB.add;
2117: END IF;
2118: x_return_status := fnd_api.g_ret_sts_error;
2119: RETURN;
2120: END IF;

Line 2271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2267: WHEN FND_API.G_EXC_ERROR THEN
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error;
2271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2272: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2273: FND_MSG_PUB.add;
2274: END IF;
2275: End insert_header_record;

Line 2273: FND_MSG_PUB.add;

2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error;
2271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2272: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2273: FND_MSG_PUB.add;
2274: END IF;
2275: End insert_header_record;
2276: ---------------------------------------------------------------------
2277: -- PROCEDURE

Line 2351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2347: WHEN FND_API.G_EXC_ERROR THEN
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: WHEN OTHERS THEN
2350: x_return_status := FND_API.g_ret_sts_unexp_error;
2351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2352: FND_MESSAGE.set_name('OZF', 'OZF_SD_TL_POPULATION_ERROR');
2353: FND_MSG_PUB.add;
2354: END IF;
2355:

Line 2353: FND_MSG_PUB.add;

2349: WHEN OTHERS THEN
2350: x_return_status := FND_API.g_ret_sts_unexp_error;
2351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2352: FND_MESSAGE.set_name('OZF', 'OZF_SD_TL_POPULATION_ERROR');
2353: FND_MSG_PUB.add;
2354: END IF;
2355:
2356: END populate_translation_record;
2357: ---------------------------------------------------------------------

Line 2534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2530: WHEN FND_API.G_EXC_ERROR THEN
2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2535: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2536: FND_MSG_PUB.add;
2537: END IF;
2538:

Line 2536: FND_MSG_PUB.add;

2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2535: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2536: FND_MSG_PUB.add;
2537: END IF;
2538:
2539: END populate_product_lines;
2540:

Line 2605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2601: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
2602: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
2603: END IF;
2604:
2605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2606: IF p_SDR_cust_tbl(c).end_customer_flag = 'Y' THEN
2607: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQ_DUP_END_CUST');
2608: ELSE
2609: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQ_DUP_CUSTOMER');

Line 2611: FND_MSG_PUB.add;

2607: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQ_DUP_END_CUST');
2608: ELSE
2609: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQ_DUP_CUSTOMER');
2610: END IF;
2611: FND_MSG_PUB.add;
2612: END IF;
2613: x_return_status := fnd_api.g_ret_sts_error;
2614: RETURN;
2615: END IF;

Line 2692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2688: WHEN FND_API.G_EXC_ERROR THEN
2689: x_return_status := FND_API.G_RET_STS_ERROR;
2690: WHEN OTHERS THEN
2691: x_return_status := FND_API.g_ret_sts_unexp_error;
2692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2693: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2694: FND_MSG_PUB.add;
2695: END IF;
2696: END populate_customer_details;

Line 2694: FND_MSG_PUB.add;

2690: WHEN OTHERS THEN
2691: x_return_status := FND_API.g_ret_sts_unexp_error;
2692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2693: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2694: FND_MSG_PUB.add;
2695: END IF;
2696: END populate_customer_details;
2697: ---------------------------------------------------------------------
2698: -- PROCEDURE

Line 2827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2823: IF G_DEBUG THEN
2824: OZF_UTILITY_PVT.debug_message(SQLERRM);
2825: END IF;
2826: x_return_status := FND_API.g_ret_sts_unexp_error;
2827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2828: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2829: FND_MSG_PUB.add;
2830: END IF;
2831:

Line 2829: FND_MSG_PUB.add;

2825: END IF;
2826: x_return_status := FND_API.g_ret_sts_unexp_error;
2827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2828: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
2829: FND_MSG_PUB.add;
2830: END IF;
2831:
2832: END update_header_record;
2833: ---------------------------------------------------------------------

Line 2899: FND_MSG_PUB.initialize;

2895:
2896: -- Initialize message list if p_init_msg_list is set to TRUE.
2897: IF FND_API.to_Boolean( p_init_msg_list )
2898: THEN
2899: FND_MSG_PUB.initialize;
2900: END IF;
2901: -- Debug Message
2902: IF G_DEBUG THEN
2903: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');

Line 2921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2917: ,p_lookup_type =>'OZF_SDR_ACCRUAL_TYPE'
2918: ,p_lookup_code => l_SDR_rec.accrual_type);
2919:
2920: IF l_lookup_check = FND_API.g_false THEN
2921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2922: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ACCRUAL_TYPE');
2923: FND_MSG_PUB.add;
2924: END IF;
2925: x_return_status := fnd_api.g_ret_sts_error;

Line 2923: FND_MSG_PUB.add;

2919:
2920: IF l_lookup_check = FND_API.g_false THEN
2921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2922: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ACCRUAL_TYPE');
2923: FND_MSG_PUB.add;
2924: END IF;
2925: x_return_status := fnd_api.g_ret_sts_error;
2926: RETURN;
2927: END IF;

Line 2929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2925: x_return_status := fnd_api.g_ret_sts_error;
2926: RETURN;
2927: END IF;
2928: ELSE
2929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2930: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ACCRUAL_TYPE');
2931: --//Accrual type is Mandatory
2932: FND_MSG_PUB.add;
2933: END IF;

Line 2932: FND_MSG_PUB.add;

2928: ELSE
2929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2930: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ACCRUAL_TYPE');
2931: --//Accrual type is Mandatory
2932: FND_MSG_PUB.add;
2933: END IF;
2934: x_return_status := fnd_api.g_ret_sts_error;
2935: RETURN;
2936: END IF;

Line 2945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2941: END IF;
2942: l_system_status_code := get_system_status_code(l_SDR_rec.user_status_id);
2943:
2944: IF l_system_status_code IS NULL THEN
2945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2946: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_STATUS_ID');
2947: --//User status id entered is invalid
2948: FND_MSG_PUB.add;
2949: END IF;

Line 2948: FND_MSG_PUB.add;

2944: IF l_system_status_code IS NULL THEN
2945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2946: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_STATUS_ID');
2947: --//User status id entered is invalid
2948: FND_MSG_PUB.add;
2949: END IF;
2950: x_return_status := fnd_api.g_ret_sts_error;
2951: RETURN;
2952: END IF;

Line 2957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2953:
2954: --//Accrual type wise status check
2955: IF l_SDR_rec.accrual_type ='SUPPLIER' THEN
2956: IF l_system_status_code NOT IN ('DRAFT','ASSIGNED','SUPPLIER_APPROVED') THEN
2957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2958: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CREATE_STATUS');
2959: --//User status id entered is invalid for Create
2960: FND_MSG_PUB.add;
2961: END IF;

Line 2960: FND_MSG_PUB.add;

2956: IF l_system_status_code NOT IN ('DRAFT','ASSIGNED','SUPPLIER_APPROVED') THEN
2957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2958: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CREATE_STATUS');
2959: --//User status id entered is invalid for Create
2960: FND_MSG_PUB.add;
2961: END IF;
2962: x_return_status := fnd_api.g_ret_sts_error;
2963: RETURN;
2964: END IF;

Line 2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2964: END IF;
2965:
2966: ELSIF l_SDR_rec.accrual_type ='INTERNAL' THEN
2967: IF l_system_status_code <> 'DRAFT' THEN
2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2969: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CREATE_STATUS_I');
2970: --//User status id entered is invalid for Create
2971: FND_MSG_PUB.add;
2972: END IF;

Line 2971: FND_MSG_PUB.add;

2967: IF l_system_status_code <> 'DRAFT' THEN
2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2969: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CREATE_STATUS_I');
2970: --//User status id entered is invalid for Create
2971: FND_MSG_PUB.add;
2972: END IF;
2973: x_return_status := fnd_api.g_ret_sts_error;
2974: RETURN;
2975: END IF;

Line 2984: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2980: OZF_UTILITY_PVT.debug_message('l_system_status_code :'||l_system_status_code);
2981: END IF;
2982:
2983: IF (l_system_status_code <> 'DRAFT') AND (p_SDR_lines_tbl.count = 0) THEN
2984: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2985: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_RECORDS');
2986: --//Product Line records are mandatory
2987: FND_MSG_PUB.add;
2988: END IF;

Line 2987: FND_MSG_PUB.add;

2983: IF (l_system_status_code <> 'DRAFT') AND (p_SDR_lines_tbl.count = 0) THEN
2984: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2985: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_PRODUCT_RECORDS');
2986: --//Product Line records are mandatory
2987: FND_MSG_PUB.add;
2988: END IF;
2989: x_return_status := fnd_api.g_ret_sts_error;
2990: RETURN;
2991: END IF;

Line 2999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2995: FETCH c_request_number INTO l_request_number;
2996: CLOSE c_request_number;
2997:
2998: IF l_request_number IS NOT NULL THEN
2999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3000: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
3001: FND_MSG_PUB.add;
3002: END IF;
3003: x_return_status := fnd_api.g_ret_sts_error;

Line 3001: FND_MSG_PUB.add;

2997:
2998: IF l_request_number IS NOT NULL THEN
2999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3000: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
3001: FND_MSG_PUB.add;
3002: END IF;
3003: x_return_status := fnd_api.g_ret_sts_error;
3004: RETURN;
3005: END IF;

Line 3015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3011: FETCH c_request_type_setup INTO l_request_type_setup_id,l_request_type;
3012: CLOSE c_request_type_setup;
3013:
3014: IF l_request_type_setup_id IS NULL THEN
3015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3016: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_TYPE_SETUP');
3017: --//Request type setup id is Mandatory
3018: FND_MSG_PUB.add;
3019: END IF;

Line 3018: FND_MSG_PUB.add;

3014: IF l_request_type_setup_id IS NULL THEN
3015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3016: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_TYPE_SETUP');
3017: --//Request type setup id is Mandatory
3018: FND_MSG_PUB.add;
3019: END IF;
3020: x_return_status := fnd_api.g_ret_sts_error;
3021: RETURN;
3022: ELSE

Line 3027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3023: IF ((l_request_type = 'BID')
3024: AND (l_system_status_code <> 'DRAFT')
3025: AND (l_SDR_cust_tbl.count = 0)) THEN
3026:
3027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3028: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUSTOMER_DETAILS');
3029: FND_MSG_PUB.add;
3030: END IF;
3031: x_return_status := fnd_api.g_ret_sts_error;

Line 3029: FND_MSG_PUB.add;

3025: AND (l_SDR_cust_tbl.count = 0)) THEN
3026:
3027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3028: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUSTOMER_DETAILS');
3029: FND_MSG_PUB.add;
3030: END IF;
3031: x_return_status := fnd_api.g_ret_sts_error;
3032: RETURN;
3033: END IF;

Line 3036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3032: RETURN;
3033: END IF;
3034: END IF;
3035: ELSE
3036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3037: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_REQUEST_TYPE_SETUP');
3038: --//Request type setup id is Mandatory
3039: FND_MSG_PUB.add;
3040: END IF;

Line 3039: FND_MSG_PUB.add;

3035: ELSE
3036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3037: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_REQUEST_TYPE_SETUP');
3038: --//Request type setup id is Mandatory
3039: FND_MSG_PUB.add;
3040: END IF;
3041: x_return_status := fnd_api.g_ret_sts_error;
3042: RETURN;
3043: END IF;

Line 3232: FND_MSG_PUB.Count_And_Get (

3228: THEN
3229: COMMIT WORK;
3230: END IF;
3231:
3232: FND_MSG_PUB.Count_And_Get (
3233: p_encoded => FND_API.G_FALSE,
3234: p_count => x_msg_count,
3235: p_data => x_msg_data
3236: );

Line 3243: FND_MSG_PUB.Count_And_Get (

3239: WHEN FND_API.G_EXC_ERROR THEN
3240: ROLLBACK TO CREATE_SDR_PUB;
3241: x_return_status := FND_API.G_RET_STS_ERROR;
3242: -- Standard call to get message count and if count=1, get the message
3243: FND_MSG_PUB.Count_And_Get (
3244: p_encoded => FND_API.G_FALSE,
3245: p_count => x_msg_count,
3246: p_data => x_msg_data
3247: );

Line 3252: FND_MSG_PUB.Count_And_Get (

3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3249: ROLLBACK TO CREATE_SDR_PUB;
3250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3251: -- Standard call to get message count and if count=1, get the message
3252: FND_MSG_PUB.Count_And_Get (
3253: p_encoded => FND_API.G_FALSE,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data
3256: );

Line 3260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3256: );
3257: WHEN OTHERS THEN
3258: ROLLBACK TO CREATE_SDR_PUB;
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3262: END IF;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (

Line 3261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3257: WHEN OTHERS THEN
3258: ROLLBACK TO CREATE_SDR_PUB;
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3262: END IF;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,

Line 3264: FND_MSG_PUB.Count_And_Get (

3260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3262: END IF;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );

Line 3454: FND_MSG_PUB.initialize;

3450:
3451: -- Initialize message list if p_init_msg_list is set to TRUE.
3452: IF FND_API.to_Boolean( p_init_msg_list )
3453: THEN
3454: FND_MSG_PUB.initialize;
3455: END IF;
3456: -- Debug Message
3457: IF G_DEBUG THEN
3458: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');

Line 3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3461: x_return_status := FND_API.G_RET_STS_SUCCESS;
3462: --==============================================================================
3463: IF l_new_sdr_hdr_rec.request_header_id = FND_API.g_miss_num OR l_new_sdr_hdr_rec.request_header_id IS NULL THEN
3464:
3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3466: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQUEST_HEADER_ID_NULL');
3467: FND_MSG_PUB.add;
3468: END IF;
3469: x_return_status := fnd_api.g_ret_sts_error;

Line 3467: FND_MSG_PUB.add;

3463: IF l_new_sdr_hdr_rec.request_header_id = FND_API.g_miss_num OR l_new_sdr_hdr_rec.request_header_id IS NULL THEN
3464:
3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3466: FND_MESSAGE.set_name('OZF', 'OZF_SD_REQUEST_HEADER_ID_NULL');
3467: FND_MSG_PUB.add;
3468: END IF;
3469: x_return_status := fnd_api.g_ret_sts_error;
3470: RETURN;
3471: ELSE

Line 3477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3473: FETCH c_request_header_id INTO l_request_header_id;
3474: CLOSE c_request_header_id;
3475:
3476: IF l_request_header_id IS NULL THEN
3477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3478: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQ_HEADER_ID');
3479: --//Request id is invalid. Please re-enter
3480: FND_MSG_PUB.add;
3481: END IF;

Line 3480: FND_MSG_PUB.add;

3476: IF l_request_header_id IS NULL THEN
3477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3478: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQ_HEADER_ID');
3479: --//Request id is invalid. Please re-enter
3480: FND_MSG_PUB.add;
3481: END IF;
3482: x_return_status := fnd_api.g_ret_sts_error;
3483: RETURN;
3484: END IF;

Line 3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3495: FETCH c_request_number INTO l_request_number;
3496: CLOSE c_request_number;
3497:
3498: IF l_request_number IS NOT NULL THEN
3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3500: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
3501: FND_MSG_PUB.add;
3502: END IF;
3503: x_return_status := fnd_api.g_ret_sts_error;

Line 3501: FND_MSG_PUB.add;

3497:
3498: IF l_request_number IS NOT NULL THEN
3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3500: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
3501: FND_MSG_PUB.add;
3502: END IF;
3503: x_return_status := fnd_api.g_ret_sts_error;
3504: RETURN;
3505: END IF;

Line 3562: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3558: CLOSE c_old_sdr_hdr;
3559:
3560: --// Object Version number check
3561: IF l_old_sdr_hdr_rec.object_version_number <> l_new_sdr_hdr_rec.object_version_number THEN
3562: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3563: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
3564: FND_MSG_PUB.ADD;
3565: END IF;
3566: RAISE FND_API.G_EXC_ERROR;

Line 3564: FND_MSG_PUB.ADD;

3560: --// Object Version number check
3561: IF l_old_sdr_hdr_rec.object_version_number <> l_new_sdr_hdr_rec.object_version_number THEN
3562: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3563: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
3564: FND_MSG_PUB.ADD;
3565: END IF;
3566: RAISE FND_API.G_EXC_ERROR;
3567: END IF;
3568:

Line 3583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3579: FETCH c_user INTO l_user_id;
3580: CLOSE c_user;
3581:
3582: IF l_user_id IS NULL THEN
3583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3584: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_ID');
3585: --//User Id is invalid, Please re-enter
3586: FND_MSG_PUB.add;
3587: END IF;

Line 3586: FND_MSG_PUB.add;

3582: IF l_user_id IS NULL THEN
3583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3584: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER_ID');
3585: --//User Id is invalid, Please re-enter
3586: FND_MSG_PUB.add;
3587: END IF;
3588: x_return_status := fnd_api.g_ret_sts_error;
3589: RETURN;
3590: ELSE --// Check if User is a valid resource or not

Line 3596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3592: FETCH c_resource_id INTO l_resource_id;
3593: CLOSE c_resource_id;
3594:
3595: IF l_resource_id IS NULL THEN
3596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3597: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
3598: FND_MSG_PUB.add;
3599: END IF;
3600: x_return_status := fnd_api.g_ret_sts_error;

Line 3598: FND_MSG_PUB.add;

3594:
3595: IF l_resource_id IS NULL THEN
3596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3597: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
3598: FND_MSG_PUB.add;
3599: END IF;
3600: x_return_status := fnd_api.g_ret_sts_error;
3601: RETURN;
3602: END IF;

Line 3606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3602: END IF;
3603: END IF;
3604:
3605: ELSE
3606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3607: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_ID');
3608: --//User Id is Mandatory
3609: FND_MSG_PUB.add;
3610: END IF;

Line 3609: FND_MSG_PUB.add;

3605: ELSE
3606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3607: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_ID');
3608: --//User Id is Mandatory
3609: FND_MSG_PUB.add;
3610: END IF;
3611: x_return_status := fnd_api.g_ret_sts_error;
3612: RETURN;
3613: END IF;

Line 3650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3646: IF ((l_owner_flag IS NULL)
3647: AND (l_approver_flag IS NULL)
3648: AND(l_admin_flag IS NULL)) THEN
3649:
3650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3651: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_PERMISSIONS');
3652: --//User has no previlage to update the record.
3653: FND_MSG_PUB.add;
3654: END IF;

Line 3653: FND_MSG_PUB.add;

3649:
3650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3651: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_USER_PERMISSIONS');
3652: --//User has no previlage to update the record.
3653: FND_MSG_PUB.add;
3654: END IF;
3655: x_return_status := fnd_api.g_ret_sts_error;
3656: RETURN;
3657: END IF;

Line 3704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3700: ,p_internal_flag =>l_internal_flag
3701: ,p_external_flag =>l_external_flag);
3702:
3703: IF l_is_stat_trns_allowed = FND_API.g_false THEN
3704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3705: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_STATUS_TRANS');
3706: --//Status transition is invalid
3707: FND_MSG_PUB.add;
3708: END IF;

Line 3707: FND_MSG_PUB.add;

3703: IF l_is_stat_trns_allowed = FND_API.g_false THEN
3704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3705: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_STATUS_TRANS');
3706: --//Status transition is invalid
3707: FND_MSG_PUB.add;
3708: END IF;
3709: x_return_status := fnd_api.g_ret_sts_error;
3710: RETURN;
3711: END IF;

Line 4335: FND_MSG_PUB.Count_And_Get (

4331: ,p_supplier_site_id => l_old_sdr_hdr_rec.supplier_site_id);
4332:
4333: END IF;
4334:
4335: FND_MSG_PUB.Count_And_Get (
4336: p_encoded => FND_API.G_FALSE,
4337: p_count => x_msg_count,
4338: p_data => x_msg_data
4339: );

Line 4346: FND_MSG_PUB.Count_And_Get (

4342: WHEN FND_API.G_EXC_ERROR THEN
4343: ROLLBACK TO UPDATE_SDR_PUB;
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: -- Standard call to get message count and if count=1, get the message
4346: FND_MSG_PUB.Count_And_Get (
4347: p_encoded => FND_API.G_FALSE,
4348: p_count => x_msg_count,
4349: p_data => x_msg_data
4350: );

Line 4355: FND_MSG_PUB.Count_And_Get (

4351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4352: ROLLBACK TO UPDATE_SDR_PUB;
4353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4354: -- Standard call to get message count and if count=1, get the message
4355: FND_MSG_PUB.Count_And_Get (
4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data
4359: );

Line 4363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4359: );
4360: WHEN OTHERS THEN
4361: ROLLBACK TO UPDATE_SDR_PUB;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4365: END IF;
4366: -- Standard call to get message count and if count=1, get the message
4367: FND_MSG_PUB.Count_And_Get (

Line 4364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4360: WHEN OTHERS THEN
4361: ROLLBACK TO UPDATE_SDR_PUB;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4365: END IF;
4366: -- Standard call to get message count and if count=1, get the message
4367: FND_MSG_PUB.Count_And_Get (
4368: p_encoded => FND_API.G_FALSE,

Line 4367: FND_MSG_PUB.Count_And_Get (

4363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4365: END IF;
4366: -- Standard call to get message count and if count=1, get the message
4367: FND_MSG_PUB.Count_And_Get (
4368: p_encoded => FND_API.G_FALSE,
4369: p_count => x_msg_count,
4370: p_data => x_msg_data
4371: );

Line 4603: FND_MSG_PUB.initialize;

4599:
4600: -- Initialize message list if p_init_msg_list is set to TRUE.
4601: IF FND_API.to_Boolean( p_init_msg_list )
4602: THEN
4603: FND_MSG_PUB.initialize;
4604: END IF;
4605: -- Debug Message
4606: IF G_DEBUG THEN
4607: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

Line 4625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4621: FETCH c_resource_id INTO l_resource_id;
4622: CLOSE c_resource_id;
4623:
4624: IF l_resource_id IS NULL THEN
4625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4626: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
4627: FND_MSG_PUB.add;
4628: END IF;
4629: x_return_status := fnd_api.g_ret_sts_error;

Line 4627: FND_MSG_PUB.add;

4623:
4624: IF l_resource_id IS NULL THEN
4625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4626: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
4627: FND_MSG_PUB.add;
4628: END IF;
4629: x_return_status := fnd_api.g_ret_sts_error;
4630: RETURN;
4631: END IF;

Line 4645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4641: FETCH c_source_request_header_id INTO l_source_rid;
4642: CLOSE c_source_request_header_id;
4643:
4644: IF l_source_rid IS NULL THEN
4645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4646: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SOURCE_REQ_ID');
4647: --//Invalid source request id. Please re-enter
4648: FND_MSG_PUB.add;
4649: END IF;

Line 4648: FND_MSG_PUB.add;

4644: IF l_source_rid IS NULL THEN
4645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4646: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SOURCE_REQ_ID');
4647: --//Invalid source request id. Please re-enter
4648: FND_MSG_PUB.add;
4649: END IF;
4650: x_return_status := fnd_api.g_ret_sts_error;
4651: RETURN;
4652: END IF;

Line 4654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4650: x_return_status := fnd_api.g_ret_sts_error;
4651: RETURN;
4652: END IF;
4653: ELSE
4654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4655: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SOURCE_REQ_ID');
4656: --//Invalid source request id. Please re-enter
4657: FND_MSG_PUB.add;
4658: END IF;

Line 4657: FND_MSG_PUB.add;

4653: ELSE
4654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4655: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_SOURCE_REQ_ID');
4656: --//Invalid source request id. Please re-enter
4657: FND_MSG_PUB.add;
4658: END IF;
4659: x_return_status := fnd_api.g_ret_sts_error;
4660: RETURN;
4661: END IF;

Line 4670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4666: FETCH c_new_request_no INTO l_new_req_no;
4667: CLOSE c_new_request_no;
4668:
4669: IF l_new_req_no IS NOT NULL THEN
4670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4671: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
4672: --//New request number entered is already exists.
4673: FND_MSG_PUB.add;
4674: END IF;

Line 4673: FND_MSG_PUB.add;

4669: IF l_new_req_no IS NOT NULL THEN
4670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4671: FND_MESSAGE.set_name('OZF', 'OZF_SD_DUP_SOURCE_REQ_NO');
4672: --//New request number entered is already exists.
4673: FND_MSG_PUB.add;
4674: END IF;
4675: x_return_status := fnd_api.g_ret_sts_error;
4676: RETURN;
4677: END IF;

Line 4687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4683: ,p_lookup_type =>'OZF_SDR_ACCRUAL_TYPE'
4684: ,p_lookup_code => p_accrual_type);
4685:
4686: IF l_lookup_stat = FND_API.g_false THEN
4687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4688: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ACCRUAL_TYPE');
4689: FND_MSG_PUB.add;
4690: END IF;
4691: x_return_status := fnd_api.g_ret_sts_error;

Line 4689: FND_MSG_PUB.add;

4685:
4686: IF l_lookup_stat = FND_API.g_false THEN
4687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4688: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_ACCRUAL_TYPE');
4689: FND_MSG_PUB.add;
4690: END IF;
4691: x_return_status := fnd_api.g_ret_sts_error;
4692: RETURN;
4693: END IF;

Line 4695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4691: x_return_status := fnd_api.g_ret_sts_error;
4692: RETURN;
4693: END IF;
4694: ELSE
4695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4696: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ACCRUAL_TYPE');
4697: --//Accrual type is Mandatory
4698: FND_MSG_PUB.add;
4699: END IF;

Line 4698: FND_MSG_PUB.add;

4694: ELSE
4695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4696: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_ACCRUAL_TYPE');
4697: --//Accrual type is Mandatory
4698: FND_MSG_PUB.add;
4699: END IF;
4700: x_return_status := fnd_api.g_ret_sts_error;
4701: RETURN;
4702: END IF;

Line 4708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4704: --//Cust Account ID Validation
4705: IF p_accrual_type ='INTERNAL' THEN
4706:
4707: IF p_cust_account_id IS NULL THEN
4708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4709: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
4710: FND_MSG_PUB.add;
4711: END IF;
4712: x_return_status := fnd_api.g_ret_sts_error;

Line 4710: FND_MSG_PUB.add;

4706:
4707: IF p_cust_account_id IS NULL THEN
4708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4709: FND_MESSAGE.set_name('OZF', 'OZF_SD_NO_CUST_ACCOUNT_ID');
4710: FND_MSG_PUB.add;
4711: END IF;
4712: x_return_status := fnd_api.g_ret_sts_error;
4713: RETURN;
4714: ELSE

Line 4720: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4716: FETCH c_cust_account_id INTO l_cust_account_id;
4717: CLOSE c_cust_account_id;
4718:
4719: IF l_cust_account_id IS NULL THEN
4720: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4721: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
4722: FND_MSG_PUB.add;
4723: END IF;
4724: x_return_status := fnd_api.g_ret_sts_error;

Line 4722: FND_MSG_PUB.add;

4718:
4719: IF l_cust_account_id IS NULL THEN
4720: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4721: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_CUST_ACCOUNT_ID');
4722: FND_MSG_PUB.add;
4723: END IF;
4724: x_return_status := fnd_api.g_ret_sts_error;
4725: RETURN;
4726: END IF;

Line 4770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4766: END IF;
4767: END IF;
4768:
4769: IF p_request_source NOT IN ('API','Manual') THEN
4770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4771: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_SOURCE');
4772: FND_MSG_PUB.add;
4773: END IF;
4774: x_return_status := fnd_api.g_ret_sts_error;

Line 4772: FND_MSG_PUB.add;

4768:
4769: IF p_request_source NOT IN ('API','Manual') THEN
4770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4771: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUEST_SOURCE');
4772: FND_MSG_PUB.add;
4773: END IF;
4774: x_return_status := fnd_api.g_ret_sts_error;
4775: RETURN;
4776: END IF;

Line 4836: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4832: l_request_end_date := p_request_end_date;
4833: END IF;
4834:
4835: IF p_request_end_date < p_request_start_date THEN
4836: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4837: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_DATE');
4838: --//End date should be greater than start date
4839: FND_MSG_PUB.add;
4840: END IF;

Line 4839: FND_MSG_PUB.add;

4835: IF p_request_end_date < p_request_start_date THEN
4836: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4837: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_END_DATE');
4838: --//End date should be greater than start date
4839: FND_MSG_PUB.add;
4840: END IF;
4841: x_return_status := fnd_api.g_ret_sts_error;
4842: RETURN;
4843: END IF;

Line 4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4849: END IF;
4850:
4851: IF (l_sdr_source_rec.accrual_type ='INTERNAL') AND (p_accrual_type ='SUPPLIER') THEN
4852: --Invalid Copy Option
4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4854: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_COPY_OPTION');
4855: --//Internal to Supplier Copy option is invalid!
4856: FND_MSG_PUB.add;
4857: END IF;

Line 4856: FND_MSG_PUB.add;

4852: --Invalid Copy Option
4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4854: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_COPY_OPTION');
4855: --//Internal to Supplier Copy option is invalid!
4856: FND_MSG_PUB.add;
4857: END IF;
4858: x_return_status := fnd_api.g_ret_sts_error;
4859: RETURN;
4860:

Line 5138: FND_MSG_PUB.Count_And_Get (

5134: THEN
5135: COMMIT WORK;
5136: END IF;
5137:
5138: FND_MSG_PUB.Count_And_Get (
5139: p_encoded => FND_API.G_FALSE,
5140: p_count => x_msg_count,
5141: p_data => x_msg_data
5142: );

Line 5150: FND_MSG_PUB.Count_And_Get (

5146: WHEN FND_API.G_EXC_ERROR THEN
5147: ROLLBACK TO COPY_SDR_PUB;
5148: x_return_status := FND_API.G_RET_STS_ERROR;
5149: -- Standard call to get message count and if count=1, get the message
5150: FND_MSG_PUB.Count_And_Get (
5151: p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,
5153: p_data => x_msg_data
5154: );

Line 5159: FND_MSG_PUB.Count_And_Get (

5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK TO COPY_SDR_PUB;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: -- Standard call to get message count and if count=1, get the message
5159: FND_MSG_PUB.Count_And_Get (
5160: p_encoded => FND_API.G_FALSE,
5161: p_count => x_msg_count,
5162: p_data => x_msg_data
5163: );

Line 5167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5163: );
5164: WHEN OTHERS THEN
5165: ROLLBACK TO COPY_SDR_PUB;
5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5169: END IF;
5170: -- Standard call to get message count and if count=1, get the message
5171: FND_MSG_PUB.Count_And_Get (

Line 5168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5164: WHEN OTHERS THEN
5165: ROLLBACK TO COPY_SDR_PUB;
5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5169: END IF;
5170: -- Standard call to get message count and if count=1, get the message
5171: FND_MSG_PUB.Count_And_Get (
5172: p_encoded => FND_API.G_FALSE,

Line 5171: FND_MSG_PUB.Count_And_Get (

5167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5169: END IF;
5170: -- Standard call to get message count and if count=1, get the message
5171: FND_MSG_PUB.Count_And_Get (
5172: p_encoded => FND_API.G_FALSE,
5173: p_count => x_msg_count,
5174: p_data => x_msg_data
5175: );