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 3449: --* : ap_invoice_lines_interface and ap_interface_rejections after a *--

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

Line 3467: --* : ap_interface_rejections DELETE *--

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

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

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

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

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

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

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

Line 3518: DELETE ap_interface_rejections

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

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

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

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

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

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

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

Line 3545: DELETE ap_interface_rejections

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

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

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

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

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