DBA Data[Home] [Help]

APPS.IEU_WORK_PROVIDER_PUB dependencies on FND_API

Line 43: x_return_status := fnd_api.g_ret_sts_success;

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

Line 114: WHEN fnd_api.g_exc_error THEN

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

Line 116: x_return_status := fnd_api.g_ret_sts_error;

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;

Line 118: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 120: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

Line 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;