DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_USER

Line 7944: -- check 15: Check if vendor contact has a valid fnd user.

7940:
7941: --Increment the p_sequence with number of errors reported in last query
7942: p_sequence := p_sequence + 1;
7943: else
7944: -- check 15: Check if vendor contact has a valid fnd user.
7945: fnd_message.set_name('PO', 'PO_CONTACT_WITHOUT_VALID_USER');
7946: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
7947: l_textline := substr(fnd_message.get, 1, 240);
7948:

Line 7977: fnd_user fu

7973: FROM dual
7974: WHERE NOT EXISTS (SELECT 'Y'
7975: FROM po_supplier_contacts_val_v pscv,
7976: po_headers_gt poh,
7977: fnd_user fu
7978: WHERE pscv.vendor_contact_id = poh.vendor_contact_id
7979: AND pscv.vendor_site_id = poh.vendor_site_id -- bug 9865162, included the check for vendor_site_id
7980: AND poh.po_header_id = p_document_id
7981: AND fu.user_name = pscv.user_name