[Home] [Help]
2796: and the invoice amount is greated than zero then the invoice will be
2797: rejected for 'Invalid Category'.
2798:
2799: The document category specified should be valid in
2800: FND_DOC_SEQUENCE_CATEGORIES for AP_INVOICES or AP_INVOICES_ALL
2801: table. If not then the invoice will be rejected for 'Invalid Category'.
2802:
2803: If the document category is valid then Check the status of the
2804: sequence assigned to this category.The sequence should be automatic
2970: SELECT name, application_id
2971: INTO l_name, l_application_id
2972: FROM fnd_doc_sequence_categories
2973: WHERE code = p_invoice_rec.doc_category_code
2974: AND table_name IN ('AP_INVOICES','AP_INVOICES_ALL');
2975: EXCEPTION
2976: WHEN NO_DATA_FOUND THEN
2977: debug_info := debug_info || 'Reject->Doc cat does not exist';
2978: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3621: END IF;
3622:
3623: -- Payment Requests: Added party_id, party_site_id,
3624: -- pay_proc_trxn_type_code, payment_function to the insert stmt
3625: INSERT INTO ap_invoices_all(
3626: invoice_id,
3627: org_id,
3628: last_update_date,
3629: last_updated_by,
4352: -- bug# 6989166 ends
4353:
4354: Cursor c_ship_to (c_invoice_id NUMBER) Is
4355: Select aps.ship_to_location_id
4356: From ap_invoices_all ai,
4357: ap_supplier_sites_all aps
4358: Where ai.invoice_id = c_invoice_id
4359: And ai.vendor_site_id = aps.vendor_site_id;
4360: