[Home] [Help]
604: WHEN eligibility_status = l_eligible AND Trunc((SYSDATE - received_Date)*24) <= l_epls_timeframe THEN 'ELIGIBLE'
605: WHEN approved_without_check = 'Y' THEN 'APPROVED'
606: WHEN eligibility_status = l_ineligible AND Trunc((SYSDATE - received_Date)*24) <= l_epls_timeframe THEN 'INELIGIBLE'
607: ELSE 'NOTRUN' END)
608: FROM po_vendor_eligibility
609: WHERE doc_id = l_document_id
610: AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1)
611: AND doc_type = l_doc_type;
612:
655: CLOSE c_vendor_eligibility;
656:
657: IF l_enable_epls = 'Y' AND l_eligibility = 'NOTRUN' THEN
658:
659: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_VENDOR_ELIGIBILITY_NOTRUN');
660:
661: INSERT INTO po_online_report_text_gt
662: (online_report_id
663: ,last_updated_by
680: ,sysdate
681: ,0 ,0 ,0
682: ,p_sequence+1
683: ,l_textline
684: ,'PO_VENDOR_ELIGIBILITY_NOTRUN'
685: ,'E'
686: );
687: --increment the sequence by the error count
688: p_sequence := p_sequence + 1;
690: END IF;
691:
692: IF l_enable_epls = 'Y' AND l_eligibility = 'INELIGIBILE' THEN
693:
694: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_VENDOR_ELIGIBILITY_INVALID');
695:
696: INSERT INTO po_online_report_text_gt
697: (online_report_id
698: ,last_updated_by
715: ,sysdate
716: ,0 ,0 ,0
717: ,p_sequence+1
718: ,l_textline
719: ,'PO_VENDOR_ELIGIBILITY_INVALID'
720: ,'W'
721: );
722: --increment the sequence by the error count
723: p_sequence := p_sequence + 1;