DBA Data[Home] [Help]

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_INVOICES_INTERFACE_S

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