eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_IPAC_IMPORT_ERRORS

Line 251: --* : fv_ipac_import_errors table *--

247: --****************************************************************************************--
248: --* Name : insert_error *--
249: --* Type : Procedure *--
250: --* Purpose : This procedure inserts the import errors into the table *--
251: --* : fv_ipac_import_errors table *--
252: --* Parameters : p_ipac_import_id IN The import id *--
253: --* : p_validation_code IN The validation Code *--
254: --* : p_validation_err IN The Validation Error *--
255: --* : p_errbuf OUT Error returned to the calling process *--

Line 272: --* Tables Used : fv_ipac_import_errors INSERT *--

268: --* : validate_duns *--
269: --* : validate_po *--
270: --* Calls : fv_utility.debug_mesg *--
271: --* : fv_utility.log_mesg *--
272: --* Tables Used : fv_ipac_import_errors INSERT *--
273: --* Logic : Inserts the record into table fv_ipac_import_errors *--
274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error

Line 273: --* Logic : Inserts the record into table fv_ipac_import_errors *--

269: --* : validate_po *--
270: --* Calls : fv_utility.debug_mesg *--
271: --* : fv_utility.log_mesg *--
272: --* Tables Used : fv_ipac_import_errors INSERT *--
273: --* Logic : Inserts the record into table fv_ipac_import_errors *--
274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (

Line 278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,

274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2

Line 279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,

275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2
283: )

Line 280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,

276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2
283: )
284: IS

Line 300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');

296: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_validation_err = '||p_validation_err);
297: END IF;
298:
299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');
301: END IF;
302: INSERT INTO fv_ipac_import_errors
303: (
304: ipac_import_id,

Line 302: INSERT INTO fv_ipac_import_errors

298:
299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');
301: END IF;
302: INSERT INTO fv_ipac_import_errors
303: (
304: ipac_import_id,
305: error_code,
306: error_desc

Line 904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

900: --* : fv_ipac_import SELECT, UPDATE *--
901: --* : ap_lookup_codes SELECT *--
902: --* Logic : Go through ap_interface_rejections for the group id and see *--
903: --* : if there are any header errors. If so insert the errors into *--
904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
905: --* : error status. *--
906: --* : Go through ap_interface_rejections for the group id and see *--
907: --* : if there are any line errors. If so insert the errors into *--
908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

Line 908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
905: --* : error status. *--
906: --* : Go through ap_interface_rejections for the group id and see *--
907: --* : if there are any line errors. If so insert the errors into *--
908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
909: --* : error status. *--
910: --****************************************************************************************--
911: PROCEDURE check_for_ap_import_errors
912: (

Line 2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;

2176: IS
2177: l_module_name VARCHAR2(200);
2178: l_location VARCHAR2(200);
2179: l_dummy VARCHAR2(1);
2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2182: l_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
2183: BEGIN
2184: l_module_name := g_module_name || 'validate_duns';

Line 2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;

2177: l_module_name VARCHAR2(200);
2178: l_location VARCHAR2(200);
2179: l_dummy VARCHAR2(1);
2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2182: l_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
2183: BEGIN
2184: l_module_name := g_module_name || 'validate_duns';
2185: p_error_code := g_SUCCESS;

Line 2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;

2341: l_line_closed_code po_lines.closed_code%TYPE;
2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;
2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2347: l_invoice_found VARCHAR2(1);
2348: l_amount NUMBER;
2349: l_recurr_invoice_id NUMBER;

Line 2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;

2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;
2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2347: l_invoice_found VARCHAR2(1);
2348: l_amount NUMBER;
2349: l_recurr_invoice_id NUMBER;
2350: BEGIN