APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on PO_HEADERS

Line 2220: l_location := l_module_name||'.select_po_headers';

2216: l_validation_code := 'DUNS_NOT_SETUP';
2217: WHEN OTHERS THEN
2218: p_error_code := g_FAILURE;
2219: p_error_desc := SQLERRM;
2220: l_location := l_module_name||'.select_po_headers';
2221: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2222: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2223: END;
2224: END IF;

Line 2249: l_location := l_module_name||'.select_po_headers';

2245: l_validation_code := 'INAVALID_SITE_CODE';
2246: WHEN OTHERS THEN
2247: p_error_code := g_FAILURE;
2248: p_error_desc := SQLERRM;
2249: l_location := l_module_name||'.select_po_headers';
2250: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2251: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2252: END;
2253: END IF;

Line 2323: --* Tables Used : po_headers SELECT *--

2319: --* Calls : process_recurr_invoice *--
2320: --* : insert_error *--
2321: --* : fv_utility.debug_mesg *--
2322: --* : fv_utility.log_mesg *--
2323: --* Tables Used : po_headers SELECT *--
2324: --* : po_distributions SELECT *--
2325: --* : po_lines SELECT *--
2326: --* : ap_invoice_distributions SELECT *--
2327: --* : ap_recurring_payments_v SELECT *--

Line 2340: l_hdr_closed_code po_headers.closed_code%TYPE;

2336: )
2337: IS
2338: l_module_name VARCHAR2(200);
2339: l_location VARCHAR2(200);
2340: l_hdr_closed_code po_headers.closed_code%TYPE;
2341: l_line_closed_code po_lines.closed_code%TYPE;
2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;

Line 2378: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_headers');

2374: END IF;
2375:
2376: IF (p_error_code = g_SUCCESS) THEN
2377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2378: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from po_headers');
2379: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'segment1='||p_ap_inv_lines_rec.po_number);
2380: END IF;
2381: BEGIN
2382: SELECT po_header_id,

Line 2390: FROM po_headers

2386: INTO p_ap_inv_lines_rec.po_header_id,
2387: l_hdr_closed_code,
2388: p_ipac_import_rec.vendor_id,
2389: p_ipac_import_rec.vendor_site_id
2390: FROM po_headers
2391: WHERE segment1 = p_ap_inv_lines_rec.po_number;
2392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2393: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'po_header_id = '||p_ap_inv_lines_rec.po_header_id);
2394: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'closed_code = '||l_hdr_closed_code);

Line 2415: l_location := l_module_name||'.select_po_headers';

2411: END IF;
2412: WHEN OTHERS THEN
2413: p_error_code := g_FAILURE;
2414: p_error_desc := SQLERRM;
2415: l_location := l_module_name||'.select_po_headers';
2416: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2417: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2418: END;
2419: END IF;