[Home] [Help]
307:
308: /* Procedure that bulk updates the term_ids on imported transactions
309: using the predefined algorithm for BFB/ECBI. Takes a request
310: ID in and processes all invoices in that request batch. Also
311: inserts errors into ra_interface_errors for those situations
312: where the term is in conflict with the setups */
313:
314: PROCEDURE validate_and_default_term( p_request_id IN NUMBER,
315: p_error_count IN OUT NOCOPY NUMBER)
423: l_rows_processed := SQL%ROWCOUNT;
424:
425: /* Now, for those that we didn't process because they
426: were in error, we need to insert the correct error
427: message into RA_INTERFACE_ERRORS */
428: IF NVL(l_rows_processed,0) < l_rows_selected
429: THEN
430: /* Get error messages for bulk insert */
431: fnd_message.set_name('AR', 'AR_BFB_TERM_BILL_LEVEL_NULL');
440: l_msg_95 := fnd_message.get;
441:
442: /* process the errors */
443: FORALL err IN t_trx_id.FIRST..t_trx_id.LAST
444: INSERT into RA_INTERFACE_ERRORS
445: (interface_line_id,
446: message_text,
447: org_id)
448: SELECT line.customer_trx_line_id,