39: where b.sel_enum_id = r_enumId
40: and a.action_map_code = b.enum_type_uuid;
41: begin
42: fnd_msg_pub.delete_msg();
43: x_return_status := fnd_api.g_ret_sts_success;
44: FND_MSG_PUB.initialize;
45: x_msg_data := '';
46: --DBMS_OUTPUT.Put_Line('before cursor loop');
47: -- find enumId, applicationId, and panel for
110: ' where sel_enum_id = :1 '
111: USING r_enumId;
112:
113: EXCEPTION
114: WHEN fnd_api.g_exc_error THEN
115: ROLLBACK;
116: x_return_status := fnd_api.g_ret_sts_error;
117:
118: WHEN fnd_api.g_exc_unexpected_error THEN
112:
113: EXCEPTION
114: WHEN fnd_api.g_exc_error THEN
115: ROLLBACK;
116: x_return_status := fnd_api.g_ret_sts_error;
117:
118: WHEN fnd_api.g_exc_unexpected_error THEN
119: ROLLBACK;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: WHEN fnd_api.g_exc_error THEN
115: ROLLBACK;
116: x_return_status := fnd_api.g_ret_sts_error;
117:
118: WHEN fnd_api.g_exc_unexpected_error THEN
119: ROLLBACK;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121:
122: WHEN OTHERS THEN
116: x_return_status := fnd_api.g_ret_sts_error;
117:
118: WHEN fnd_api.g_exc_unexpected_error THEN
119: ROLLBACK;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121:
122: WHEN OTHERS THEN
123: ROLLBACK;
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121:
122: WHEN OTHERS THEN
123: ROLLBACK;
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125:
126: commit;
127: end DeleteNode;
128: END IEU_WORK_PROVIDER_PUB;