[Home] [Help]
160: CURSOR all_invoices_csr(p_instruction_id NUMBER)
161: IS
162: SELECT calling_app_doc_unique_ref2
163: FROM IBY_DOCS_PAYABLE_ALL -- added all
164: WHERE upper(document_type)='STANDARD'
165: AND calling_app_id=200
166: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
167: AND payment_id in (select payment_id
168: from iby_payments_all
398: WHERE ibydocpay.payment_id = p_payment_id
399: AND ibydocpay.calling_app_doc_unique_ref2 = p_invoice_id
400: AND ibydocpay.payment_id=ibypmt.payment_id
401: AND ibydocpay.calling_app_id=200
402: AND UPPER(ibydocpay.document_type)='STANDARD'
403: AND UPPER(ibydocpay.payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
404: */
405:
406:
946: AND asup.vendor_id = aia.vendor_id;
947:
948: /* Validation rule: Bug 5457879: The validation set must look at the type of supplier. If the supplier is
949: a type of Employee then the only type of reason codes that the invoice can have is 'US_FV_B','US_FV_C',
950: 'US_FV_D','US_FV_O','US_FV_R', 'US_FV_X'. For the Supplier type of Organization (Standard Supplier),
951: the reason code can only be 'US_FV_V'.
952: */
953:
954: IF (l_vendor_type_lookup_code = 'EMPLOYEE') THEN
963: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
964: END IF;
965: ELSE -- vendor is of type organization
966: IF (l_payment_reason_code <> 'US_FV_V') THEN
967: x_error_mesg := 'Payments to a Standard Supplier can only have a payment reason code of ''Vendor Payment Sub-Type'' ';
968: p_docErrorRec.transaction_error_id := null;
969: p_docErrorRec.error_code := 'INVALID_PAY_TAX_BENEFIT';
970: p_docErrorRec.error_message := x_error_mesg;
971: x_error_code := g_ERROR;