DBA Data[Home] [Help]

APPS.ZX_TEST_API dependencies on PO_VENDOR_SITES_ALL

Line 1460: from po_vendor_sites_all

1456: ---------------------------------------------------
1457: write_message('~ Retrieves the user_key_id using PO_VENDOR_SITES');
1458: select vendor_site_id
1459: into x_user_key_id
1460: from po_vendor_sites_all
1461: where vendor_site_code = l_varchar2_id;
1462: --Bug 4306914. The Composite Key was simpified to single key.
1463: /*where vendor_id = to_number(l_varchar2_id)
1464: and vendor_site_code = l_varchar2_id1

Line 1479: 'is not unique in table PO_VENDOR_SITES_ALL. '||sqlerrm);

1475: WHEN TOO_MANY_ROWS THEN
1476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||
1478: p_user_key_type|| ' the vendor_site_code'|| l_varchar2_id1 ||
1479: 'is not unique in table PO_VENDOR_SITES_ALL. '||sqlerrm);
1480: write_message(substr(sqlerrm,1,200));
1481: FND_MSG_PUB.Add;
1482: x_user_key_id := -9999;
1483: WHEN OTHERS THEN