29: --
30: --=====================================================================
31: --NAME: Insert_In_Errors_Table
32: --TYPE: PRIVATE
33: --DESCRIPTION: This procedure insert a row in the OE_EXP_INTERFACE_ERRORS
34: -- table.
35: --Parameters:
36: --IN
37: --OUT
46: IS
47: BEGIN
48: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_To_Errors_Table');
49: --
50: -- Insert row into OE_EXP_INTERFACE_ERRORS table
51: --
52: INSERT INTO OE_EXP_INTERFACE_ERRORS (
53: EXPOSURE_SOURCE_CODE
54: , EXPOSURE_INTERFACE_ID
48: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_To_Errors_Table');
49: --
50: -- Insert row into OE_EXP_INTERFACE_ERRORS table
51: --
52: INSERT INTO OE_EXP_INTERFACE_ERRORS (
53: EXPOSURE_SOURCE_CODE
54: , EXPOSURE_INTERFACE_ID
55: , BATCH_ID
56: , ERROR_MESSAGE_NAME
656:
657: l_exposure_soure_code oe_exposure_interface.exposure_source_code%TYPE;
658: l_op_code_count NUMBER := 0;
659: l_operation_code oe_exposure_interface.operation_code%TYPE;
660: l_message_text oe_exp_interface_errors.error_message%TYPE;
661: l_source_valid NUMBER;
662: l_any_op_code_errors BOOLEAN := FALSE;
663: BEGIN
664: OE_DEBUG_PUB.Add('OEXVECEB: In Validate_Exposure_Source ');
1249:
1250: --
1251: -- Delete any existing error messages for the selected exposure source and batch
1252: --
1253: DELETE FROM oe_exp_interface_errors
1254: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1255: AND NVL(batch_id, -99) = NVL(p_batch_id, NVL(batch_id,-99));
1256:
1257: --