16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,
22: p_error_table_name IN MTL_CC_INTERFACE_ERRORS.ERROR_TABLE_NAME%TYPE,
23: p_flags IN VARCHAR2,
24: x_return_status OUT NOCOPY VARCHAR2,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,
22: p_error_table_name IN MTL_CC_INTERFACE_ERRORS.ERROR_TABLE_NAME%TYPE,
23: p_flags IN VARCHAR2,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER ,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,
22: p_error_table_name IN MTL_CC_INTERFACE_ERRORS.ERROR_TABLE_NAME%TYPE,
23: p_flags IN VARCHAR2,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER ,
26: x_msg_data OUT NOCOPY VARCHAR2 )
768: L_err_count := 0;
769: BEGIN
770: select count(*)
771: into L_err_count
772: from mtl_cc_interface_errors
773: where cc_entry_interface_id =
774: p_interface_rec.cc_entry_interface_id;
775:
776: EXCEPTION