[Home] [Help]
662: This Procedure is called from various procedure whenever an error is detected in
663: the data elements.
664:
665: This Procedure accepts upto 6 different tokens and Values Concatenates and stores
666: the resulting message text in WSH_INTERFACE_ERRORS table.
667: ==============================================================================*/
668:
669: PROCEDURE log_interface_errors (
670: p_interface_errors_rec IN interface_errors_rec_type,
803:
804: IF l_debug_on THEN
805: wsh_debug_sv.log (l_module_name, 'Text: ', l_text);
806: END IF;
807: -- Insert error record in WSH_Interface_errors table.
808: -- We need the check for l_text because the column error_message
809: -- is a Not_Null column.
810:
811: IF (l_text IS NOT NULL) THEN
810:
811: IF (l_text IS NOT NULL) THEN
812: IF l_debug_on THEN
813: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
814: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
815: END IF;
816:
817: INSERT INTO wsh_interface_errors
818: (interface_error_id,
813: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
814: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
815: END IF;
816:
817: INSERT INTO wsh_interface_errors
818: (interface_error_id,
819: interface_table_name,
820: interface_id, error_message, creation_date,
821: created_by, last_update_date, last_updated_by,
819: interface_table_name,
820: interface_id, error_message, creation_date,
821: created_by, last_update_date, last_updated_by,
822: last_update_login,INTERFACE_ACTION_CODE)
823: VALUES (wsh_interface_errors_s.NEXTVAL,
824: p_interface_errors_rec.p_interface_table_name,
825: p_interface_errors_rec.p_interface_id, l_text, SYSDATE,
826: fnd_global.user_id, SYSDATE, fnd_global.user_id,
827: fnd_global.user_id,'94X_INBOUND');