[Home] [Help]
388:
389: /* Procedure that bulk updates the term_ids on imported transactions
390: using the predefined algorithm for BFB/ECBI. Takes a request
391: ID in and processes all invoices in that request batch. Also
392: inserts errors into ra_interface_errors for those situations
393: where the term is in conflict with the setups */
394:
395: PROCEDURE validate_and_default_term( p_request_id IN NUMBER,
396: p_error_count IN OUT NOCOPY NUMBER)
517: l_rows_processed := SQL%ROWCOUNT;
518:
519: /* Now, for those that we didn't process because they
520: were in error, we need to insert the correct error
521: message into RA_INTERFACE_ERRORS */
522: IF NVL(l_rows_processed,0) < l_rows_selected
523: THEN
524: /* Get error messages for bulk insert */
525: fnd_message.set_name('AR', 'AR_BFB_TERM_BILL_LEVEL_NULL');
534: l_msg_95 := fnd_message.get;
535:
536: /* process the errors */
537: FORALL err IN t_trx_id.FIRST..t_trx_id.LAST
538: INSERT into RA_INTERFACE_ERRORS
539: (interface_line_id,
540: message_text,
541: org_id)
542: SELECT line.customer_trx_line_id,