APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_CCR_VENDORS

Line 2157: --* Tables Used : fv_ccr_vendors SELECT *--

2153: --* Called from : process_data *--
2154: --* Calls : insert_error *--
2155: --* : fv_utility.debug_mesg *--
2156: --* : fv_utility.log_mesg *--
2157: --* Tables Used : fv_ccr_vendors SELECT *--
2158: --* : po_vendor_sites SELECT *--
2159: --* Logic : 1. Check against fv_ccr_vendors to see if a record exists with the *--
2160: --* : specific vendor id duns and duns+4 combination *--
2161: --* : 2. If no record exists then provide an error DUNS_NOT_SETUP and *--

Line 2159: --* Logic : 1. Check against fv_ccr_vendors to see if a record exists with the *--

2155: --* : fv_utility.debug_mesg *--
2156: --* : fv_utility.log_mesg *--
2157: --* Tables Used : fv_ccr_vendors SELECT *--
2158: --* : po_vendor_sites SELECT *--
2159: --* Logic : 1. Check against fv_ccr_vendors to see if a record exists with the *--
2160: --* : specific vendor id duns and duns+4 combination *--
2161: --* : 2. If no record exists then provide an error DUNS_NOT_SETUP and *--
2162: --* : insert the error and return. *--
2163: --* : 3. Get the vendor site id using the duns and duns+4 combinatiion *--

Line 2202: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Select fv_ccr_vendors');

2198:
2199: IF (p_error_code = g_SUCCESS) THEN
2200: BEGIN
2201: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2202: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Select fv_ccr_vendors');
2203: END IF;
2204: SELECT 'X'
2205: INTO l_dummy
2206: FROM fv_ccr_vendors fcv

Line 2206: FROM fv_ccr_vendors fcv

2202: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Select fv_ccr_vendors');
2203: END IF;
2204: SELECT 'X'
2205: INTO l_dummy
2206: FROM fv_ccr_vendors fcv
2207: WHERE fcv.vendor_id = p_ipac_import_rec.vendor_id
2208: AND fcv.duns = p_ipac_import_rec.receiver_duns
2209: AND NVL(fcv.plus_four, '-1') = NVL(p_ipac_import_rec.receiver_duns_4, '-1');
2210: EXCEPTION