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_INVOICES_INTERFACE

Line 332: --* Purpose : Inserts the Invoice Header record into ap_invoices_interface *--

328:
329: --****************************************************************************************--
330: --* Name : insert_invoice_hdr *--
331: --* Type : Procedure *--
332: --* Purpose : Inserts the Invoice Header record into ap_invoices_interface *--
333: --* Parameters : p_invoice_hdr_rec The Header record that has to be inserted *--
334: --* : p_errbuf Error returned to the concurrent process *--
335: --* : p_retcode Return Code to concurrent process *--
336: --* Global Vars : g_module_name READ *--

Line 348: --* Tables Used : ap_invoices_interface INSERT *--

344: --* : g_exit READ *--
345: --* Called from : save_or_erase_invoice *--
346: --* Calls : fv_utility.debug_mesg *--
347: --* : fv_utility.log_mesg *--
348: --* Tables Used : ap_invoices_interface INSERT *--
349: --* Logic : Insert the record p_invoice_hdr_rec into table ap_invoices_interface *--
350: --****************************************************************************************--
351: PROCEDURE insert_invoice_hdr
352: (

Line 349: --* Logic : Insert the record p_invoice_hdr_rec into table ap_invoices_interface *--

345: --* Called from : save_or_erase_invoice *--
346: --* Calls : fv_utility.debug_mesg *--
347: --* : fv_utility.log_mesg *--
348: --* Tables Used : ap_invoices_interface INSERT *--
349: --* Logic : Insert the record p_invoice_hdr_rec into table ap_invoices_interface *--
350: --****************************************************************************************--
351: PROCEDURE insert_invoice_hdr
352: (
353: p_invoice_hdr_rec IN ap_invoices_interface%ROWTYPE,

Line 353: p_invoice_hdr_rec IN ap_invoices_interface%ROWTYPE,

349: --* Logic : Insert the record p_invoice_hdr_rec into table ap_invoices_interface *--
350: --****************************************************************************************--
351: PROCEDURE insert_invoice_hdr
352: (
353: p_invoice_hdr_rec IN ap_invoices_interface%ROWTYPE,
354: p_error_code OUT NOCOPY NUMBER,
355: p_error_desc OUT NOCOPY VARCHAR2
356: )
357: IS

Line 368: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoices_interface');

364: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);
365: END IF;
366:
367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
368: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoices_interface');
369: END IF;
370: INSERT INTO ap_invoices_interface
371: (
372: invoice_id,

Line 370: INSERT INTO ap_invoices_interface

366:
367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
368: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into ap_invoices_interface');
369: END IF;
370: INSERT INTO ap_invoices_interface
371: (
372: invoice_id,
373: invoice_num,
374: invoice_type_lookup_code,

Line 897: --* Tables Used : ap_invoices_interface SELECT *--

893: --* Called from : main *--
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 *--

Line 913: p_group_id ap_invoices_interface.group_id%TYPE,

909: --* : error status. *--
910: --****************************************************************************************--
911: PROCEDURE check_for_ap_import_errors
912: (
913: p_group_id ap_invoices_interface.group_id%TYPE,
914: p_error_code OUT NOCOPY NUMBER,
915: p_error_desc OUT NOCOPY VARCHAR2
916: )
917: IS

Line 938: FROM ap_invoices_interface aii,

934: FOR invoices_rec IN (SELECT aii.invoice_id,
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

Line 945: AND air.parent_table = 'AP_INVOICES_INTERFACE'

941: ap_lookup_codes alc
942: WHERE aii.group_id = p_group_id
943: AND aii.status = 'REJECTED'
944: AND aii.invoice_id = air.parent_id
945: AND air.parent_table = 'AP_INVOICES_INTERFACE'
946: AND fii.group_id = p_group_id
947: AND fii.int_invoice_id = aii.invoice_id
948: AND alc.lookup_type = 'REJECT CODE'
949: AND alc.lookup_code = air.reject_lookup_code) LOOP

Line 1010: FROM ap_invoices_interface aii,

1006: FOR invoice_lines_rec IN (SELECT aii.invoice_id,
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

Line 2778: p_ap_inv_hdr_rec IN ap_invoices_interface%ROWTYPE,

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,
2779: p_previous_inv_number IN ap_invoices_interface.invoice_num%TYPE,
2780: p_okay_to_insert_inv IN VARCHAR2,
2781: p_total_invoice_lines IN NUMBER,
2782: p_total_invoices IN OUT NOCOPY NUMBER,

Line 2779: p_previous_inv_number IN ap_invoices_interface.invoice_num%TYPE,

2775: --****************************************************************************************--
2776: PROCEDURE save_or_erase_invoice
2777: (
2778: p_ap_inv_hdr_rec IN ap_invoices_interface%ROWTYPE,
2779: p_previous_inv_number IN ap_invoices_interface.invoice_num%TYPE,
2780: p_okay_to_insert_inv IN VARCHAR2,
2781: p_total_invoice_lines IN NUMBER,
2782: p_total_invoices IN OUT NOCOPY NUMBER,
2783: p_error_code OUT NOCOPY NUMBER,

Line 2903: --* Sequence Used : ap_invoices_interface_s *--

2899: --* : resolve_uom *--
2900: --* : insert_invoice_line *--
2901: --* : fv_utility.debug_mesg *--
2902: --* : fv_utility.log_mesg *--
2903: --* Sequence Used : ap_invoices_interface_s *--
2904: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
2905: --* Logic : 1. Pre process the data to get the group_id handle *--
2906: --* : 2. Process every record from fv_ipac_import table *--
2907: --* : 3. Validate the PO. *--

Line 2926: l_inv_hdrs_interface_rec ap_invoices_interface%ROWTYPE;

2922: IS
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;

Line 2928: l_inv_hdrs_interface_rec_null ap_invoices_interface%ROWTYPE;

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);
2932: l_current_inv_lines NUMBER;

Line 3084: SELECT ap_invoices_interface_s.NEXTVAL

3080: BEGIN
3081: --****************************************************************************************--
3082: --* get the invoice header sequence number *--
3083: --****************************************************************************************--
3084: SELECT ap_invoices_interface_s.NEXTVAL
3085: INTO l_inv_hdrs_interface_rec.invoice_id
3086: FROM DUAL;
3087: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3088: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_id ='||l_inv_hdrs_interface_rec.invoice_id);

Line 3094: l_location := l_module_name||'select_ap_invoices_interface_s';

3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: p_error_code := g_FAILURE;
3093: p_error_desc := SQLERRM;
3094: l_location := l_module_name||'select_ap_invoices_interface_s';
3095: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3096: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3097: END;
3098: END IF;

Line 3448: --* Purpose : This procedure removes data from ap_invoices_interface, *--

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

Line 3469: --* : ap_invoices_interface DELETE *--

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 *--
3472: --* : 1. Delete all data from ap_interface_rejections for lines *--
3473: --* : 2. Delete all data from ap_interface_rejections for header *--

Line 3475: --* : 4. Delete all data from ap_invoices_interface *--

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 *--
3478: --****************************************************************************************--
3479: PROCEDURE cleanup_current_failed_run

Line 3522: ap_invoices_interface aii

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
3523: WHERE aii.invoice_num = import_rec.invoice_number
3524: AND aii.group_id = p_group_id
3525: AND aii.invoice_id = aili.invoice_id);
3526: l_rowcount := SQL%ROWCOUNT;

Line 3546: WHERE parent_table = 'AP_INVOICES_INTERFACE'

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
3550: AND aii.group_id = p_group_id);

Line 3548: FROM ap_invoices_interface aii

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
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

Line 3572: FROM ap_invoices_interface

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

Line 3593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoices_interface');

3589:
3590: IF (p_error_code = g_SUCCESS) THEN
3591: BEGIN
3592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoices_interface');
3594: END IF;
3595: DELETE ap_invoices_interface
3596: WHERE invoice_num = import_rec.invoice_number
3597: AND group_id = p_group_id;

Line 3595: DELETE ap_invoices_interface

3591: BEGIN
3592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting ap_invoices_interface');
3594: END IF;
3595: DELETE ap_invoices_interface
3596: WHERE invoice_num = import_rec.invoice_number
3597: AND group_id = p_group_id;
3598: l_rowcount := SQL%ROWCOUNT;
3599: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

3596: WHERE invoice_num = import_rec.invoice_number
3597: AND group_id = p_group_id;
3598: l_rowcount := SQL%ROWCOUNT;
3599: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3600: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from ap_invoices_interface.');
3601: END IF;
3602: EXCEPTION
3603: WHEN OTHERS THEN
3604: p_error_code := g_FAILURE;

Line 3606: l_location := l_module_name||'.delete_ap_invoices_interface';

3602: EXCEPTION
3603: WHEN OTHERS THEN
3604: p_error_code := g_FAILURE;
3605: p_error_desc := SQLERRM;
3606: l_location := l_module_name||'.delete_ap_invoices_interface';
3607: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3608: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3609: END;
3610: END IF;