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

Line 157: --* Tables Used : ap_invoices SELECT *--

153: --* : fv_utility.log_mesg *--
154: --* : mo_global.get_current_org_id *--
155: --* : mo_utils.get_ledger_info *--
156: --* : fnd_date.canonical_to_date *--
157: --* Tables Used : ap_invoices SELECT *--
158: --* : po_vendors SELECT *--
159: --* : fv_operating_units SELECT *--
160: --* : fv_interagency_funds SELECT *--
161: --* Logic : *--

Line 184: FROM ap_invoices ai , po_vendors pv

180: ai.invoice_num,
181: ai.vendor_id ,
182: pv.vendor_name,
183: ai.creation_date
184: FROM ap_invoices ai , po_vendors pv
185: WHERE ai.vendor_id = pv.vendor_id
186: AND ai.invoice_num LIKE 'IPAC%'
187: AND ai.payment_method_lookup_code = 'CLEARING'
188: AND EXISTS (SELECT 'X'

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 1233: --* Name : kick_off_ap_invoices_import *--

1229: END IF;
1230: END;
1231:
1232: --****************************************************************************************--
1233: --* Name : kick_off_ap_invoices_import *--
1234: --* Type : Procedure *--
1235: --* Purpose : Procedure to kick of the concurrent process *--
1236: --* : Payables Open Interface Import (APXIIMPT) *--
1237: --* Parameters : p_batch_name IN The batch name to be passed to conc pgm *--

Line 1261: PROCEDURE kick_off_ap_invoices_import

1257: --* Tables Used : None *--
1258: --* Logic : Submit a request for APXIIMPT using the parameters passed and wait *--
1259: --* : for the request to finish *--
1260: --****************************************************************************************--
1261: PROCEDURE kick_off_ap_invoices_import
1262: (
1263: p_batch_name IN VARCHAR2,
1264: p_group_id IN NUMBER,
1265: p_error_code OUT NOCOPY NUMBER,

Line 1279: l_module_name := g_module_name || 'kick_off_ap_invoices_import';

1275: l_dev_phase VARCHAR2(100);
1276: l_dev_status VARCHAR2(100);
1277: l_message VARCHAR2(100);
1278: BEGIN
1279: l_module_name := g_module_name || 'kick_off_ap_invoices_import';
1280: p_error_code := g_SUCCESS;
1281:
1282: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1283: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,g_enter);

Line 1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--

1782: --* : g_user_id READ *--
1783: --* Called from : validate_po *--
1784: --* Calls : fv_utility.debug_mesg *--
1785: --* : fv_utility.log_mesg *--
1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--
1787: --* : ap_recurring_payments_v VIEW, SELECT *--
1788: --* : ap_invoices VIEW, SELECT *--
1789: --* : fv_ipac_recurring_inv SELECT, INSERT *--
1790: --* Logic : Already existing code *--

Line 1788: --* : ap_invoices VIEW, SELECT *--

1784: --* Calls : fv_utility.debug_mesg *--
1785: --* : fv_utility.log_mesg *--
1786: --* Tables Used : ap_invoices_v VIEW, SELECT *--
1787: --* : ap_recurring_payments_v VIEW, SELECT *--
1788: --* : ap_invoices VIEW, SELECT *--
1789: --* : fv_ipac_recurring_inv SELECT, INSERT *--
1790: --* Logic : Already existing code *--
1791: --****************************************************************************************--
1792: PROCEDURE process_recurr_invoice

Line 1810: l_invoice_id ap_invoices.invoice_id%TYPE;

1806: IS
1807: l_module_name VARCHAR2(200);
1808: l_location VARCHAR2(200);
1809:
1810: l_invoice_id ap_invoices.invoice_id%TYPE;
1811: l_approval_code ap_invoices_v.approval_status_lookup_code%TYPE;
1812: l_code VARCHAR2(1);
1813:
1814: CURSOR invoice_cur

Line 1811: l_approval_code ap_invoices_v.approval_status_lookup_code%TYPE;

1807: l_module_name VARCHAR2(200);
1808: l_location VARCHAR2(200);
1809:
1810: l_invoice_id ap_invoices.invoice_id%TYPE;
1811: l_approval_code ap_invoices_v.approval_status_lookup_code%TYPE;
1812: l_code VARCHAR2(1);
1813:
1814: CURSOR invoice_cur
1815: (

Line 1823: FROM ap_invoices_v ai,

1819: )
1820: IS
1821: SELECT ai.invoice_id,
1822: ai.approval_status_lookup_code
1823: FROM ap_invoices_v ai,
1824: ap_recurring_payments_v arp
1825: WHERE arp.recurring_payment_id = ai.recurring_payment_id
1826: AND arp.set_of_books_id = ai.set_of_books_id
1827: AND arp.po_number = c_po_num

Line 1834: FROM ap_invoices aib,

1830: AND ai.invoice_amount = c_amount
1831: AND ai.payment_status_flag = 'N'
1832: AND ai.set_of_books_id = g_set_of_books_id
1833: AND ai.invoice_date = (SELECT MIN(invoice_date)
1834: FROM ap_invoices aib,
1835: ap_recurring_payments_v arpb
1836: WHERE aib.source = 'RECURRING INVOICE'
1837: AND aib.set_of_books_id = g_set_of_books_id
1838: AND aib.payment_status_flag = 'N'

Line 1847: FROM ap_invoices_v ai,

1843: AND arp.line_num = NVL(c_po_line_num,1))
1844: UNION
1845: SELECT DISTINCT ai.invoice_id,
1846: ai.approval_status_lookup_code
1847: FROM ap_invoices_v ai,
1848: ap_invoice_distributions_v ali
1849: WHERE ali.po_number = c_po_num
1850: AND ai.invoice_id = ali.invoice_id
1851: AND ali.po_line_number = NVL(c_po_line_num,1)

Line 1858: FROM ap_invoices_v ai1,

1854: AND ai.set_of_books_id = g_set_of_books_id
1855: AND ai.source <> 'RECURRING INVOICE'
1856: AND ai.invoice_type_lookup_code = 'STANDARD'
1857: AND ai.invoice_date = (SELECT MIN(invoice_date)
1858: FROM ap_invoices_v ai1,
1859: ap_invoice_distributions_v ali1
1860: WHERE ali1.po_number = c_po_num
1861: AND ai1.invoice_id = ali1.invoice_id
1862: AND ali1.po_line_number = NVL(c_po_line_num,1)

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;

Line 4289: --* : kick_off_ap_invoices_import *--

4285: --* : fv_utility.log_mesg *--
4286: --* : fnd_profile.value *--
4287: --* : load_data_file *--
4288: --* : process_data *--
4289: --* : kick_off_ap_invoices_import *--
4290: --* : check_for_ap_import_errors *--
4291: --* : kick_off_exception_report *--
4292: --* : kick_off_ipac_auto_pmt_process *--
4293: --* : cleanup_current_failed_run *--

Line 4435: * Import AP Invoices *

4431: END IF;
4432:
4433: /*
4434: *****************************************************************************
4435: * Import AP Invoices *
4436: *****************************************************************************
4437: */
4438: IF (p_retcode = g_SUCCESS) THEN
4439: IF (l_ok_to_import = 'Y') THEN

Line 4441: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling kick_off_ap_invoices_import');

4437: */
4438: IF (p_retcode = g_SUCCESS) THEN
4439: IF (l_ok_to_import = 'Y') THEN
4440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4441: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling kick_off_ap_invoices_import');
4442: END IF;
4443: kick_off_ap_invoices_import
4444: (
4445: p_batch_name => l_batch_name,

Line 4443: kick_off_ap_invoices_import

4439: IF (l_ok_to_import = 'Y') THEN
4440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4441: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Calling kick_off_ap_invoices_import');
4442: END IF;
4443: kick_off_ap_invoices_import
4444: (
4445: p_batch_name => l_batch_name,
4446: p_group_id => l_group_id,
4447: p_error_code => p_retcode,

Line 4451: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'kick_off_ap_invoices_import returned');

4447: p_error_code => p_retcode,
4448: p_error_desc => p_errbuf
4449: );
4450: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4451: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'kick_off_ap_invoices_import returned');
4452: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_error_code = '||p_retcode);
4453: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_error_desc = '||p_errbuf);
4454: END IF;
4455: END IF;