APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_EXP_INTERFACE_ERRORS

Line 33: --DESCRIPTION: This procedure insert a row in the OE_EXP_INTERFACE_ERRORS

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

Line 50: -- Insert row into OE_EXP_INTERFACE_ERRORS table

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

Line 52: INSERT INTO OE_EXP_INTERFACE_ERRORS (

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

Line 660: l_message_text oe_exp_interface_errors.error_message%TYPE;

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 ');

Line 1253: DELETE FROM oe_exp_interface_errors

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: --