DBA Data[Home] [Help]

APPS.IEU_WORK_PANEL_PUB dependencies on FND_API

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: where MACTION_DEF_KEY = r_action_key;
64:
65: begin
66: fnd_msg_pub.delete_msg();
67: x_return_status := fnd_api.g_ret_sts_success;
68: FND_MSG_PUB.initialize;
69: x_msg_data := '';
70: --DBMS_OUTPUT.Put_Line('before cursor loop');
71: -- find enumId, applicationId, and panel for

Line 129: WHEN fnd_api.g_exc_error THEN

125: IEU_WP_ACTION_PVT.ReOrdering(x_return_status ,x_msg_count , x_msg_data
126: , cur_rec.sel_enum_id, cur_rec.application_id, cur_rec.maction_def_type_flag);
127: end loop;
128: EXCEPTION
129: WHEN fnd_api.g_exc_error THEN
130: ROLLBACK;
131: x_return_status := fnd_api.g_ret_sts_error;
132:
133: WHEN fnd_api.g_exc_unexpected_error THEN

Line 131: x_return_status := fnd_api.g_ret_sts_error;

127: end loop;
128: EXCEPTION
129: WHEN fnd_api.g_exc_error THEN
130: ROLLBACK;
131: x_return_status := fnd_api.g_ret_sts_error;
132:
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK;
135: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 133: WHEN fnd_api.g_exc_unexpected_error THEN

129: WHEN fnd_api.g_exc_error THEN
130: ROLLBACK;
131: x_return_status := fnd_api.g_ret_sts_error;
132:
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK;
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136:
137: WHEN OTHERS THEN

Line 135: x_return_status := fnd_api.g_ret_sts_unexp_error;

131: x_return_status := fnd_api.g_ret_sts_error;
132:
133: WHEN fnd_api.g_exc_unexpected_error THEN
134: ROLLBACK;
135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136:
137: WHEN OTHERS THEN
138: ROLLBACK;
139: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 139: x_return_status := fnd_api.g_ret_sts_unexp_error;

135: x_return_status := fnd_api.g_ret_sts_unexp_error;
136:
137: WHEN OTHERS THEN
138: ROLLBACK;
139: x_return_status := fnd_api.g_ret_sts_unexp_error;
140:
141: commit;
142: end DeleteAction;
143: -- Start of Comments

Line 218: x_return_status := fnd_api.g_ret_sts_success;

214: );
215:
216: begin
217: fnd_msg_pub.delete_msg();
218: x_return_status := fnd_api.g_ret_sts_success;
219: FND_MSG_PUB.initialize;
220: x_msg_data := '';
221: --DBMS_OUTPUT.Put_Line('before cursor loop');
222:

Line 313: WHEN fnd_api.g_exc_error THEN

309: IEU_WP_ACTION_PVT.ReOrdering(x_return_status ,x_msg_count , x_msg_data
310: , r_node_id, cur_rec.application_id, cur_rec.maction_def_type_flag);
311: end loop;
312: EXCEPTION
313: WHEN fnd_api.g_exc_error THEN
314: ROLLBACK;
315: x_return_status := fnd_api.g_ret_sts_error;
316:
317: WHEN fnd_api.g_exc_unexpected_error THEN

Line 315: x_return_status := fnd_api.g_ret_sts_error;

311: end loop;
312: EXCEPTION
313: WHEN fnd_api.g_exc_error THEN
314: ROLLBACK;
315: x_return_status := fnd_api.g_ret_sts_error;
316:
317: WHEN fnd_api.g_exc_unexpected_error THEN
318: ROLLBACK;
319: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 317: WHEN fnd_api.g_exc_unexpected_error THEN

313: WHEN fnd_api.g_exc_error THEN
314: ROLLBACK;
315: x_return_status := fnd_api.g_ret_sts_error;
316:
317: WHEN fnd_api.g_exc_unexpected_error THEN
318: ROLLBACK;
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320:
321: WHEN OTHERS THEN

Line 319: x_return_status := fnd_api.g_ret_sts_unexp_error;

315: x_return_status := fnd_api.g_ret_sts_error;
316:
317: WHEN fnd_api.g_exc_unexpected_error THEN
318: ROLLBACK;
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320:
321: WHEN OTHERS THEN
322: ROLLBACK;
323: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 323: x_return_status := fnd_api.g_ret_sts_unexp_error;

319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320:
321: WHEN OTHERS THEN
322: ROLLBACK;
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324:
325:
326: commit;
327: end DeleteCloneAction;

Line 416: x_return_status := fnd_api.g_ret_sts_success;

412: )
413: );
414: begin
415: fnd_msg_pub.delete_msg();
416: x_return_status := fnd_api.g_ret_sts_success;
417: FND_MSG_PUB.initialize;
418: x_msg_data := '';
419: FOR cur_rec IN c_cursor1
420: LOOP

Line 484: WHEN fnd_api.g_exc_error THEN

480: --DBMS_SQL.CLOSE_CURSOR(v_cursor1);
481: CLOSE c_ref;
482: END loop;
483: EXCEPTION
484: WHEN fnd_api.g_exc_error THEN
485: ROLLBACK;
486: x_return_status := fnd_api.g_ret_sts_error;
487:
488: WHEN fnd_api.g_exc_unexpected_error THEN

Line 486: x_return_status := fnd_api.g_ret_sts_error;

482: END loop;
483: EXCEPTION
484: WHEN fnd_api.g_exc_error THEN
485: ROLLBACK;
486: x_return_status := fnd_api.g_ret_sts_error;
487:
488: WHEN fnd_api.g_exc_unexpected_error THEN
489: ROLLBACK;
490: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 488: WHEN fnd_api.g_exc_unexpected_error THEN

484: WHEN fnd_api.g_exc_error THEN
485: ROLLBACK;
486: x_return_status := fnd_api.g_ret_sts_error;
487:
488: WHEN fnd_api.g_exc_unexpected_error THEN
489: ROLLBACK;
490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491:
492: WHEN OTHERS THEN

Line 490: x_return_status := fnd_api.g_ret_sts_unexp_error;

486: x_return_status := fnd_api.g_ret_sts_error;
487:
488: WHEN fnd_api.g_exc_unexpected_error THEN
489: ROLLBACK;
490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491:
492: WHEN OTHERS THEN
493: ROLLBACK;
494: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 494: x_return_status := fnd_api.g_ret_sts_unexp_error;

490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491:
492: WHEN OTHERS THEN
493: ROLLBACK;
494: x_return_status := fnd_api.g_ret_sts_unexp_error;
495:
496:
497:
498: commit;