[Home] [Help]
2112: and the invoice amount is greated than zero then the invoice will be
2113: rejected for 'Invalid Category'.
2114:
2115: The document category specified should be valid in
2116: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL
2117: table. If not then the invoice will be rejected for 'Invalid Category'.
2118:
2119: If the document category is valid then Check the status of the
2120: sequence assigned to this category.The sequence should be automatic
2286: SELECT name, application_id
2287: INTO l_name, l_application_id
2288: FROM fnd_doc_sequence_categories
2289: WHERE code = p_invoice_rec.doc_category_code
2290: AND table_name IN ('AP_INVOICES','AP_INVOICES_ALL');
2291: EXCEPTION
2292: WHEN NO_DATA_FOUND THEN
2293: debug_info := debug_info || 'Reject->Doc cat does not exist';
2294: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2933: END IF;
2934:
2935: -- Payment Requests: Added party_id, party_site_id,
2936: -- pay_proc_trxn_type_code, payment_function to the insert stmt
2937: INSERT INTO ap_invoices_all(
2938: invoice_id,
2939: org_id,
2940: last_update_date,
2941: last_updated_by,
3651: -- bug# 6989166 ends
3652:
3653: Cursor c_ship_to (c_invoice_id NUMBER) Is
3654: Select aps.ship_to_location_id
3655: From ap_invoices_all ai,
3656: ap_supplier_sites_all aps
3657: Where ai.invoice_id = c_invoice_id
3658: And ai.vendor_site_id = aps.vendor_site_id;
3659:
3687:
3688: -- BUG 6785691. START
3689: select INVOICE_TYPE_LOOKUP_CODE
3690: into l_inv_code
3691: from ap_invoices_all
3692: where invoice_id = p_base_invoice_id;
3693:
3694: IF l_inv_code = 'EXPENSE REPORT' THEN
3695: l_wfapproval_status := 'NOT REQUIRED';