572: p_message => l_progress || ': violated rule 1'
573: );
574: END IF;
575:
576: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_PGOA_SITE_DIFF');
577: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
578: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
579:
580: APP_EXCEPTION.raise_exception;
573: );
574: END IF;
575:
576: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_PGOA_SITE_DIFF');
577: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
578: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
579:
580: APP_EXCEPTION.raise_exception;
581:
574: END IF;
575:
576: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_PGOA_SITE_DIFF');
577: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
578: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
579:
580: APP_EXCEPTION.raise_exception;
581:
582: WHEN GA_FOR_SITE_W_POREF_FRM_OTR_OU THEN
590: p_message => l_progress || ': violated rule 2'
591: );
592: END IF;
593:
594: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_FRM_OTR_OU');
595: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
596: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
597:
598: APP_EXCEPTION.raise_exception;
591: );
592: END IF;
593:
594: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_FRM_OTR_OU');
595: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
596: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
597:
598: APP_EXCEPTION.raise_exception;
599:
592: END IF;
593:
594: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_FRM_OTR_OU');
595: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
596: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
597:
598: APP_EXCEPTION.raise_exception;
599:
600: WHEN GA_FOR_SITE_W_POREF_DIFF_SITE THEN
608: p_message => l_progress || ': violated rule 3'
609: );
610: END IF;
611:
612: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_DIFF_SITE');
613: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
614: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
615:
616: APP_EXCEPTION.raise_exception;
609: );
610: END IF;
611:
612: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_DIFF_SITE');
613: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
614: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
615:
616: APP_EXCEPTION.raise_exception;
617:
610: END IF;
611:
612: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_POREF_DIFF_SITE');
613: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
614: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
615:
616: APP_EXCEPTION.raise_exception;
617:
618: WHEN PGOA_FOR_SITE_AND_GA_SITE_DIFF THEN
626: p_message => l_progress || ': violated rule 4'
627: );
628: END IF;
629:
630: FND_MESSAGE.set_name('PO', 'PO_MERGE_PGOA_GA_SITE_DIFF');
631: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
632:
633: APP_EXCEPTION.raise_exception;
634:
627: );
628: END IF;
629:
630: FND_MESSAGE.set_name('PO', 'PO_MERGE_PGOA_GA_SITE_DIFF');
631: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
632:
633: APP_EXCEPTION.raise_exception;
634:
635: WHEN SPO_FOR_SITE_AND_GA_SITE_DIFF THEN
643: p_message => l_progress || ': violated rule 5'
644: );
645: END IF;
646:
647: FND_MESSAGE.set_name('PO', 'PO_MERGE_SPO_GA_SITE_DIFF');
648: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
649: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
650:
651: APP_EXCEPTION.raise_exception;
644: );
645: END IF;
646:
647: FND_MESSAGE.set_name('PO', 'PO_MERGE_SPO_GA_SITE_DIFF');
648: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
649: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
650:
651: APP_EXCEPTION.raise_exception;
652:
645: END IF;
646:
647: FND_MESSAGE.set_name('PO', 'PO_MERGE_SPO_GA_SITE_DIFF');
648: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
649: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
650:
651: APP_EXCEPTION.raise_exception;
652:
653: WHEN REQ_FOR_VDR_REF_GA_IN_OTHER_OU THEN
661: p_message => l_progress || ': violated rule 6'
662: );
663: END IF;
664:
665: FND_MESSAGE.set_name('PO', 'PO_MERGE_REQ_REF_GA_IN_OTR_OU');
666: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
667:
668: APP_EXCEPTION.raise_exception;
669:
662: );
663: END IF;
664:
665: FND_MESSAGE.set_name('PO', 'PO_MERGE_REQ_REF_GA_IN_OTR_OU');
666: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
667:
668: APP_EXCEPTION.raise_exception;
669:
670: WHEN REQ_FOR_SITE_REF_GA_DIFF_SITE THEN
678: p_message => l_progress || ': violated rule 7'
679: );
680: END IF;
681:
682: FND_MESSAGE.set_name('PO', 'PO_MERGE_REQ_REF_GA_DIFF_SITE');
683: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
684: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
685:
686: APP_EXCEPTION.raise_exception;
679: );
680: END IF;
681:
682: FND_MESSAGE.set_name('PO', 'PO_MERGE_REQ_REF_GA_DIFF_SITE');
683: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
684: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
685:
686: APP_EXCEPTION.raise_exception;
687:
680: END IF;
681:
682: FND_MESSAGE.set_name('PO', 'PO_MERGE_REQ_REF_GA_DIFF_SITE');
683: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
684: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
685:
686: APP_EXCEPTION.raise_exception;
687:
688: WHEN GA_FOR_SITE_W_REQREF_DIFF_SITE THEN
696: p_message => l_progress || ': violated rule 8'
697: );
698: END IF;
699:
700: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_REQREF_DIFF_SITE');
701: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
702: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
703:
704: APP_EXCEPTION.raise_exception;
697: );
698: END IF;
699:
700: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_REQREF_DIFF_SITE');
701: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
702: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
703:
704: APP_EXCEPTION.raise_exception;
705:
698: END IF;
699:
700: FND_MESSAGE.set_name('PO', 'PO_MERGE_GA_W_REQREF_DIFF_SITE');
701: FND_MESSAGE.set_token('FROM_VENDOR', l_from_vendor_name);
702: FND_MESSAGE.set_token('FROM_VENDOR_SITE', l_from_site_code);
703:
704: APP_EXCEPTION.raise_exception;
705:
706: WHEN PO_CONSIGNMENT_EXIST THEN
704: APP_EXCEPTION.raise_exception;
705:
706: WHEN PO_CONSIGNMENT_EXIST THEN
707: x_result := FND_API.G_FALSE;
708: FND_MESSAGE.set_name('PO', x_validation_error);
709:
710: APP_EXCEPTION.raise_exception;
711:
712: WHEN PO_INVALID_VENDOR_SITE_ID THEN
944: AND PV.vendor_id = PVS.vendor_id;
945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: FND_MESSAGE.set_name('PO','PO_INVALID_VENDOR_SITE_ID');
949: FND_MESSAGE.set_token('VENDOR_SITE_ID',p_vendor_site_id);
950: APP_EXCEPTION.raise_exception;
951: END get_vdr_and_site_name;
952:
945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: FND_MESSAGE.set_name('PO','PO_INVALID_VENDOR_SITE_ID');
949: FND_MESSAGE.set_token('VENDOR_SITE_ID',p_vendor_site_id);
950: APP_EXCEPTION.raise_exception;
951: END get_vdr_and_site_name;
952:
953: