The following lines contain the word 'select', 'insert', 'update' or 'delete':
| Insert_Errors |
| |
| This routine is called at the end of the program to insert all |
| errors from the plsql array into the error table and reset the array |
| |
+======================================================================*/
PROCEDURE insert_errors IS
BEGIN
g_trace_label :='Insert_errors';
INSERT INTO xla_amb_setup_errors
(amb_error_id
,message_name
,message_type_flag
,category_sequence_num
,message_category_code
,application_id
,amb_context_code
,product_rule_type_code
,product_rule_code
,entity_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,description_type_code
,description_code
,analytical_criterion_type_code
,analytical_criterion_code
,segment_rule_type_code
,segment_rule_code
,mapping_set_code
,source_application_id
,source_type_code
,source_code
,extract_object_name
,extract_object_type_code
,accounting_source_code
,mapping_group_code
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
,program_update_date
,program_application_id
,program_id
,request_id
,extract_column_name
,language
,mpa_accounting_line_type_code
,mpa_accounting_line_code)
VALUES (xla_amb_setup_errors_s.nextval
,g_amb_errors(i).message_name
,g_amb_errors(i).message_type_flag
,g_amb_errors(i).category_sequence_num
,g_amb_errors(i).message_category_code
,g_amb_errors(i).application_id
,g_amb_errors(i).amb_context_code
,g_amb_errors(i).product_rule_type_code
,g_amb_errors(i).product_rule_code
,g_amb_errors(i).entity_code
,g_amb_errors(i).event_class_code
,g_amb_errors(i).event_type_code
,g_amb_errors(i).line_definition_owner_code
,g_amb_errors(i).line_definition_code
,g_amb_errors(i).accounting_line_type_code
,g_amb_errors(i).accounting_line_code
,g_amb_errors(i).description_type_code
,g_amb_errors(i).description_code
,g_amb_errors(i).analytical_criterion_type_code
,g_amb_errors(i).analytical_criterion_code
,g_amb_errors(i).segment_rule_type_code
,g_amb_errors(i).segment_rule_code
,g_amb_errors(i).mapping_set_code
,g_amb_errors(i).source_application_id
,g_amb_errors(i).source_type_code
,g_amb_errors(i).source_code
,g_amb_errors(i).extract_object_name
,g_amb_errors(i).extract_object_type_code
,g_amb_errors(i).accounting_source_code
,g_amb_errors(i).mapping_group_code
,xla_environment_pkg.g_usr_id
,sysdate
,sysdate
,xla_environment_pkg.g_usr_id
,xla_environment_pkg.g_login_id
,NULL
,xla_environment_pkg.g_prog_appl_id
,xla_environment_pkg.g_prog_id
,g_amb_errors(i).request_id
,g_amb_errors(i).extract_column_name
,g_amb_errors(i).language
,g_amb_errors(i).mpa_accounting_line_type_code
,g_amb_errors(i).mpa_accounting_line_code);
(p_location => 'xla_amb_setup_err_pkg.insert_errors');
END insert_errors;
g_amb_errors.DELETE;