117: -- dbms_output.put_line('l_msg_data fo rule is: ' || l_msg_data);
118: -- dbms_output.put_line ('rule deleted');
119:
120:
121: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
122: RAISE L_DEL_EXT;
123: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
124: RAISE L_DEL_EXT;
125: END IF;
119:
120:
121: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
122: RAISE L_DEL_EXT;
123: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
124: RAISE L_DEL_EXT;
125: END IF;
126:
127: EXCEPTION
126:
127: EXCEPTION
128:
129: WHEN L_DEL_EXT THEN
130: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
131: x_msg_count := l_msg_count ;
132: l_msg_data := 'Problems with External Delete';
133: x_msg_data := l_msg_data ;
134: