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 AP_INTERFACE_REJECTIONS

Line 899: --* : ap_interface_rejections SELECT *--

895: --* : fv_utility.debug_mesg *--
896: --* : fv_utility.log_mesg *--
897: --* Tables Used : ap_invoices_interface SELECT *--
898: --* : ap_invoice_lines_interface SELECT *--
899: --* : ap_interface_rejections SELECT *--
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 *--

Line 902: --* Logic : Go through ap_interface_rejections for the group id and see *--

898: --* : ap_invoice_lines_interface SELECT *--
899: --* : ap_interface_rejections SELECT *--
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 *--

Line 906: --* : Go through ap_interface_rejections for the group id and see *--

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 *--
909: --* : error status. *--
910: --****************************************************************************************--

Line 939: ap_interface_rejections air,

935: air.reject_lookup_code,
936: fii.ipac_import_id,
937: alc.description
938: FROM ap_invoices_interface aii,
939: ap_interface_rejections air,
940: fv_ipac_import fii,
941: ap_lookup_codes alc
942: WHERE aii.group_id = p_group_id
943: AND aii.status = 'REJECTED'

Line 1012: ap_interface_rejections air,

1008: fii.ipac_import_id,
1009: alc.description
1010: FROM ap_invoices_interface aii,
1011: ap_invoice_lines_interface aili,
1012: ap_interface_rejections air,
1013: fv_ipac_import fii,
1014: ap_lookup_codes alc
1015: WHERE aii.group_id = p_group_id
1016: AND aii.status = 'REJECTED'

Line 3451: --* : ap_invoice_lines_interface and ap_interface_rejections after a *--

3447: --****************************************************************************************--
3448: --* Name : cleanup_current_failed_run *--
3449: --* Type : Procedure *--
3450: --* Purpose : This procedure removes data from ap_invoices_interface, *--
3451: --* : ap_invoice_lines_interface and ap_interface_rejections after a *--
3452: --* : failed run *--
3453: --* Parameters : p_group_id IN The group id for which the data is processed *--
3454: --* : p_errbuf OUT Error returned to the concurrent process *--
3455: --* : p_retcode OUT Return Code to concurrent process *--

Line 3469: --* : ap_interface_rejections DELETE *--

3465: --* Called from : main *--
3466: --* Calls : fv_utility.debug_mesg *--
3467: --* : fv_utility.log_mesg *--
3468: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
3469: --* : ap_interface_rejections DELETE *--
3470: --* : ap_invoice_lines_interface DELETE *--
3471: --* : ap_invoices_interface DELETE *--
3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--
3473: --* : do the following *--

Line 3474: --* : 1. Delete all data from ap_interface_rejections for lines *--

3470: --* : ap_invoice_lines_interface DELETE *--
3471: --* : ap_invoices_interface DELETE *--
3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--
3473: --* : do the following *--
3474: --* : 1. Delete all data from ap_interface_rejections for lines *--
3475: --* : 2. Delete all data from ap_interface_rejections for header *--
3476: --* : 3. Delete all data from ap_invoice_lines_interface *--
3477: --* : 4. Delete all data from ap_invoices_interface *--
3478: --* : 5. Update all other records of fv_ipac_import table with same *--

Line 3475: --* : 2. Delete all data from ap_interface_rejections for header *--

3471: --* : ap_invoices_interface DELETE *--
3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--
3473: --* : do the following *--
3474: --* : 1. Delete all data from ap_interface_rejections for lines *--
3475: --* : 2. Delete all data from ap_interface_rejections for header *--
3476: --* : 3. Delete all data from ap_invoice_lines_interface *--
3477: --* : 4. Delete all data from ap_invoices_interface *--
3478: --* : 5. Update all other records of fv_ipac_import table with same *--
3479: --* : invoice and status of not ERROR to ERROR IN OTHER LINES *--

Line 3518: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections1');

3514:
3515: IF (p_error_code = g_SUCCESS) THEN
3516: BEGIN
3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3518: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections1');
3519: END IF;
3520: DELETE ap_interface_rejections
3521: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
3522: AND parent_id IN (SELECT invoice_line_id

Line 3520: DELETE ap_interface_rejections

3516: BEGIN
3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3518: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections1');
3519: END IF;
3520: DELETE ap_interface_rejections
3521: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
3522: AND parent_id IN (SELECT invoice_line_id
3523: FROM ap_invoice_lines_interface aili,
3524: ap_invoices_interface aii

Line 3530: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_interface_rejections1.');

3526: AND aii.group_id = p_group_id
3527: AND aii.invoice_id = aili.invoice_id);
3528: l_rowcount := SQL%ROWCOUNT;
3529: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3530: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_interface_rejections1.');
3531: END IF;
3532: EXCEPTION
3533: WHEN OTHERS THEN
3534: p_error_code := g_FAILURE;

Line 3536: l_location := l_module_name||'.delete_ap_interface_rejections1';

3532: EXCEPTION
3533: WHEN OTHERS THEN
3534: p_error_code := g_FAILURE;
3535: p_error_desc := SQLERRM;
3536: l_location := l_module_name||'.delete_ap_interface_rejections1';
3537: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3538: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3539: END;
3540: END IF;

Line 3545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections2');

3541:
3542: IF (p_error_code = g_SUCCESS) THEN
3543: BEGIN
3544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections2');
3546: END IF;
3547: DELETE ap_interface_rejections
3548: WHERE parent_table = 'AP_INVOICES_INTERFACE'
3549: AND parent_id IN (SELECT invoice_id

Line 3547: DELETE ap_interface_rejections

3543: BEGIN
3544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3545: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_interface_rejections2');
3546: END IF;
3547: DELETE ap_interface_rejections
3548: WHERE parent_table = 'AP_INVOICES_INTERFACE'
3549: AND parent_id IN (SELECT invoice_id
3550: FROM ap_invoices_interface aii
3551: WHERE aii.invoice_num = import_rec.invoice_number

Line 3555: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_interface_rejections2.');

3551: WHERE aii.invoice_num = import_rec.invoice_number
3552: AND aii.group_id = p_group_id);
3553: l_rowcount := SQL%ROWCOUNT;
3554: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3555: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_interface_rejections2.');
3556: END IF;
3557: EXCEPTION
3558: WHEN OTHERS THEN
3559: p_error_code := g_FAILURE;

Line 3561: l_location := l_module_name||'.delete_ap_interface_rejections2';

3557: EXCEPTION
3558: WHEN OTHERS THEN
3559: p_error_code := g_FAILURE;
3560: p_error_desc := SQLERRM;
3561: l_location := l_module_name||'.delete_ap_interface_rejections2';
3562: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3563: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3564: END;
3565: END IF;