详解EBS接口开发之供应商导入（补充）--错误信息处理

check reject details on records of AP_SUPPLIER_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUPPLIER_INT' AND f.language_code='ZHS'; 

check reject details on records of AP_SUPPLIER_SITES_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUPPLIER_SITES_INT' AND f.language_code='ZHS';

 

check reject details on records of AP_SUP_SITE_CONTACT_INT

SELECT s.parent_table,s.reject_lookup_code,S.LAST_UPDATE_DATE,F.MESSAGE_TEXT,F.DESCRIPTION 
FROM ap_supplier_int_rejections s, fnd_new_messages f 
WHERE s.reject_lookup_code = f.message_name 
AND s.parent_table = 'AP_SUP_SITE_CONTACT_INT' AND f.language_code='ZHS';