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_INVOICE_LINES_INTERFACE

Line 584: --* Purpose : Inserts the Invoice Line record into ap_invoice_lines_interface *--

580:
581: --****************************************************************************************--
582: --* Name : insert_invoice_line *--
583: --* Type : Procedure *--
584: --* Purpose : Inserts the Invoice Line record into ap_invoice_lines_interface *--
585: --* Parameters : p_invoice_lines_rec The Line record that has to be inserted *--
586: --* : p_errbuf Error returned to the concurrent process *--
587: --* : p_retcode Return Code to concurrent process *--
588: --* Global Vars : g_module_name READ *--

Line 600: --* Sequence Used : ap_invoice_lines_interface_s *--

596: --* : g_exit READ *--
597: --* Called from : process_data *--
598: --* Calls : fv_utility.debug_mesg *--
599: --* : fv_utility.log_mesg *--
600: --* Sequence Used : ap_invoice_lines_interface_s *--
601: --* Tables Used : ap_invoice_lines_interface INSERT *--
602: --* Logic : Insert the record p_invoice_lines_rec into table *--
603: --* : ap_invoice_lines_interface *--
604: --* : The invoice line id is returned in *--

Line 601: --* Tables Used : ap_invoice_lines_interface INSERT *--

597: --* Called from : process_data *--
598: --* Calls : fv_utility.debug_mesg *--
599: --* : fv_utility.log_mesg *--
600: --* Sequence Used : ap_invoice_lines_interface_s *--
601: --* Tables Used : ap_invoice_lines_interface INSERT *--
602: --* Logic : Insert the record p_invoice_lines_rec into table *--
603: --* : ap_invoice_lines_interface *--
604: --* : The invoice line id is returned in *--
605: --* : p_invoice_lines_rec.invoice_line_id *--

Line 603: --* : ap_invoice_lines_interface *--

599: --* : fv_utility.log_mesg *--
600: --* Sequence Used : ap_invoice_lines_interface_s *--
601: --* Tables Used : ap_invoice_lines_interface INSERT *--
602: --* Logic : Insert the record p_invoice_lines_rec into table *--
603: --* : ap_invoice_lines_interface *--
604: --* : The invoice line id is returned in *--
605: --* : p_invoice_lines_rec.invoice_line_id *--
606: --****************************************************************************************--
607: PROCEDURE insert_invoice_line

Line 609: p_invoice_lines_rec IN OUT NOCOPY ap_invoice_lines_interface%ROWTYPE,

605: --* : p_invoice_lines_rec.invoice_line_id *--
606: --****************************************************************************************--
607: PROCEDURE insert_invoice_line
608: (
609: p_invoice_lines_rec IN OUT NOCOPY ap_invoice_lines_interface%ROWTYPE,
610: p_error_code OUT NOCOPY NUMBER,
611: p_error_desc OUT NOCOPY VARCHAR2
612: )
613: IS

Line 624: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoice_lines_interface');

620: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
621: END IF;
622:
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
624: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoice_lines_interface');
625: END IF;
626: INSERT INTO ap_invoice_lines_interface
627: (
628: invoice_id,

Line 626: INSERT INTO ap_invoice_lines_interface

622:
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
624: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoice_lines_interface');
625: END IF;
626: INSERT INTO ap_invoice_lines_interface
627: (
628: invoice_id,
629: invoice_line_id,
630: line_number,

Line 747: ap_invoice_lines_interface_s.NEXTVAL,

743: )
744: VALUES
745: (
746: p_invoice_lines_rec.invoice_id,
747: ap_invoice_lines_interface_s.NEXTVAL,
748: p_invoice_lines_rec.line_number,
749: p_invoice_lines_rec.line_type_lookup_code,
750: p_invoice_lines_rec.line_group_number,
751: p_invoice_lines_rec.amount,

Line 898: --* : ap_invoice_lines_interface SELECT *--

894: --* Calls : insert_error *--
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 *--

Line 1011: ap_invoice_lines_interface aili,

1007: air.reject_lookup_code,
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

Line 1019: AND air.parent_table = 'AP_INVOICE_LINES_INTERFACE'

1015: WHERE aii.group_id = p_group_id
1016: AND aii.status = 'REJECTED'
1017: AND aili.invoice_line_id = air.parent_id
1018: AND aii.invoice_id = aili.invoice_id
1019: AND air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
1020: AND fii.group_id = p_group_id
1021: AND fii.int_invoice_id = aii.invoice_id
1022: AND fii.int_invoice_line_id = aili.invoice_line_id
1023: AND alc.lookup_type = 'REJECT CODE'

Line 2333: p_ap_inv_lines_rec IN OUT NOCOPY ap_invoice_lines_interface%ROWTYPE,

2329: --****************************************************************************************--
2330: PROCEDURE validate_po
2331: (
2332: p_ipac_import_rec IN OUT NOCOPY fv_ipac_import%ROWTYPE,
2333: p_ap_inv_lines_rec IN OUT NOCOPY ap_invoice_lines_interface%ROWTYPE,
2334: p_error_code OUT NOCOPY NUMBER,
2335: p_error_desc OUT NOCOPY VARCHAR2
2336: )
2337: IS

Line 2769: --* Tables Used : ap_invoice_lines_interface DELETE *--

2765: --* Called from : process_data *--
2766: --* Calls : insert_invoice_hdr *--
2767: --* : fv_utility.debug_mesg *--
2768: --* : fv_utility.log_mesg *--
2769: --* Tables Used : ap_invoice_lines_interface DELETE *--
2770: --* Logic : 1. If the previous invoice number is not null and if it is okay to *--
2771: --* : insert the invoice, then insert the invoice header *--
2772: --* : 2. If the previous invoice number is not null and if it is not okay *--
2773: --* : to insert the invoice and if there are more than 0 lines already *--

Line 2774: --* : inserted, delete them from ap_invoice_lines_interface *--

2770: --* Logic : 1. If the previous invoice number is not null and if it is okay to *--
2771: --* : insert the invoice, then insert the invoice header *--
2772: --* : 2. If the previous invoice number is not null and if it is not okay *--
2773: --* : to insert the invoice and if there are more than 0 lines already *--
2774: --* : inserted, delete them from ap_invoice_lines_interface *--
2775: --****************************************************************************************--
2776: PROCEDURE save_or_erase_invoice
2777: (
2778: p_ap_inv_hdr_rec IN ap_invoices_interface%ROWTYPE,

Line 2833: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');

2829: IF ((p_previous_inv_number IS NOT NULL) AND (p_okay_to_insert_inv = 'N')) THEN
2830: IF (p_total_invoice_lines > 0) THEN
2831: BEGIN
2832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2833: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');
2834: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_id='||p_ap_inv_hdr_rec.invoice_id);
2835: END IF;
2836:
2837: DELETE ap_invoice_lines_interface

Line 2837: DELETE ap_invoice_lines_interface

2833: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');
2834: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_id='||p_ap_inv_hdr_rec.invoice_id);
2835: END IF;
2836:
2837: DELETE ap_invoice_lines_interface
2838: WHERE invoice_id = p_ap_inv_hdr_rec.invoice_id;
2839: l_rowcount := SQL%ROWCOUNT;
2840: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2841: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_invoice_lines_interface.');

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

2837: DELETE ap_invoice_lines_interface
2838: WHERE invoice_id = p_ap_inv_hdr_rec.invoice_id;
2839: l_rowcount := SQL%ROWCOUNT;
2840: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2841: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_invoice_lines_interface.');
2842: END IF;
2843: EXCEPTION
2844: WHEN OTHERS THEN
2845: p_error_code := g_FAILURE;

Line 2847: l_location := l_module_name||'delete_ap_invoice_lines_interface';

2843: EXCEPTION
2844: WHEN OTHERS THEN
2845: p_error_code := g_FAILURE;
2846: p_error_desc := SQLERRM;
2847: l_location := l_module_name||'delete_ap_invoice_lines_interface';
2848: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2849: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2850: END;
2851: END IF;

Line 2927: l_inv_lines_interface_rec ap_invoice_lines_interface%ROWTYPE;

2923: l_module_name VARCHAR2(200);
2924: l_location VARCHAR2(200);
2925: l_ipac_import_record fv_ipac_import%ROWTYPE;
2926: l_inv_hdrs_interface_rec ap_invoices_interface%ROWTYPE;
2927: l_inv_lines_interface_rec ap_invoice_lines_interface%ROWTYPE;
2928: l_inv_hdrs_interface_rec_null ap_invoices_interface%ROWTYPE;
2929: l_inv_lines_interface_rec_null ap_invoice_lines_interface%ROWTYPE;
2930: l_save_invoice_number fv_ipac_import.invoice_number%TYPE;
2931: l_ok_to_insert_inv VARCHAR2(1);

Line 2929: l_inv_lines_interface_rec_null ap_invoice_lines_interface%ROWTYPE;

2925: l_ipac_import_record fv_ipac_import%ROWTYPE;
2926: l_inv_hdrs_interface_rec ap_invoices_interface%ROWTYPE;
2927: l_inv_lines_interface_rec ap_invoice_lines_interface%ROWTYPE;
2928: l_inv_hdrs_interface_rec_null ap_invoices_interface%ROWTYPE;
2929: l_inv_lines_interface_rec_null ap_invoice_lines_interface%ROWTYPE;
2930: l_save_invoice_number fv_ipac_import.invoice_number%TYPE;
2931: l_ok_to_insert_inv VARCHAR2(1);
2932: l_current_inv_lines NUMBER;
2933: l_no_of_invoices_inserted NUMBER;

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 3470: --* : ap_invoice_lines_interface DELETE *--

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 *--
3474: --* : 1. Delete all data from ap_interface_rejections for lines *--

Line 3476: --* : 3. Delete all data from ap_invoice_lines_interface *--

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 *--
3480: --****************************************************************************************--

Line 3521: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'

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
3525: WHERE aii.invoice_num = import_rec.invoice_number

Line 3523: FROM ap_invoice_lines_interface aili,

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
3525: WHERE aii.invoice_num = import_rec.invoice_number
3526: AND aii.group_id = p_group_id
3527: AND aii.invoice_id = aili.invoice_id);

Line 3570: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');

3566:
3567: IF (p_error_code = g_SUCCESS) THEN
3568: BEGIN
3569: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3570: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');
3571: END IF;
3572: DELETE ap_invoice_lines_interface
3573: WHERE invoice_id IN (SELECT invoice_id
3574: FROM ap_invoices_interface

Line 3572: DELETE ap_invoice_lines_interface

3568: BEGIN
3569: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3570: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoice_lines_interface');
3571: END IF;
3572: DELETE ap_invoice_lines_interface
3573: WHERE invoice_id IN (SELECT invoice_id
3574: FROM ap_invoices_interface
3575: WHERE invoice_num = import_rec.invoice_number
3576: AND group_id = p_group_id);

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

3575: WHERE invoice_num = import_rec.invoice_number
3576: AND group_id = p_group_id);
3577: l_rowcount := SQL%ROWCOUNT;
3578: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3579: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_invoice_lines_interface.');
3580: END IF;
3581: EXCEPTION
3582: WHEN OTHERS THEN
3583: p_error_code := g_FAILURE;

Line 3585: l_location := l_module_name||'.delete_ap_invoice_lines_interface';

3581: EXCEPTION
3582: WHEN OTHERS THEN
3583: p_error_code := g_FAILURE;
3584: p_error_desc := SQLERRM;
3585: l_location := l_module_name||'.delete_ap_invoice_lines_interface';
3586: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3587: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3588: END;
3589: END IF;