eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_WP_ACTION_PVT dependencies on FND_API

Line 37: x_return_status := fnd_api.g_ret_sts_success;

33: BEGIN
34: l_responsibility_id := rec_obj.responsibility_id;
35: l_application_id := rec_obj.application_id;
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: x_msg_data := '';
40:
41: if (rec_obj.responsibility_id is null) then

Line 108: WHEN fnd_api.g_exc_error THEN

104:
105: COMMIT;
106:
107: EXCEPTION
108: WHEN fnd_api.g_exc_error THEN
109: ROLLBACK;
110: x_return_status := fnd_api.g_ret_sts_error;
111:
112: WHEN fnd_api.g_exc_unexpected_error THEN

Line 110: x_return_status := fnd_api.g_ret_sts_error;

106:
107: EXCEPTION
108: WHEN fnd_api.g_exc_error THEN
109: ROLLBACK;
110: x_return_status := fnd_api.g_ret_sts_error;
111:
112: WHEN fnd_api.g_exc_unexpected_error THEN
113: ROLLBACK;
114: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 112: WHEN fnd_api.g_exc_unexpected_error THEN

108: WHEN fnd_api.g_exc_error THEN
109: ROLLBACK;
110: x_return_status := fnd_api.g_ret_sts_error;
111:
112: WHEN fnd_api.g_exc_unexpected_error THEN
113: ROLLBACK;
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115:
116: WHEN OTHERS THEN

Line 114: x_return_status := fnd_api.g_ret_sts_unexp_error;

110: x_return_status := fnd_api.g_ret_sts_error;
111:
112: WHEN fnd_api.g_exc_unexpected_error THEN
113: ROLLBACK;
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115:
116: WHEN OTHERS THEN
117: ROLLBACK;
118: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 118: x_return_status := fnd_api.g_ret_sts_unexp_error;

114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115:
116: WHEN OTHERS THEN
117: ROLLBACK;
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119:
120: END CREATE_action_map;
121: PROCEDURE DELETE_Actions (x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

Line 143: x_return_status := fnd_api.g_ret_sts_success;

139: WHERE action_param_set_id = v_param_set_id;
140: cur_rec c_cursor%ROWTYPE;
141: begin
142: fnd_msg_pub.delete_msg();
143: x_return_status := fnd_api.g_ret_sts_success;
144: FND_MSG_PUB.initialize;
145: x_msg_data := '';
146:
147: v_param_set_id := r_param_set_id;

Line 180: WHEN fnd_api.g_exc_error THEN

176: COMMIT;
177:
178: EXCEPTION
179:
180: WHEN fnd_api.g_exc_error THEN
181: ROLLBACK;
182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: WHEN fnd_api.g_exc_unexpected_error THEN

Line 182: x_return_status := fnd_api.g_ret_sts_error;

178: EXCEPTION
179:
180: WHEN fnd_api.g_exc_error THEN
181: ROLLBACK;
182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: WHEN fnd_api.g_exc_unexpected_error THEN
185: ROLLBACK;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 184: WHEN fnd_api.g_exc_unexpected_error THEN

180: WHEN fnd_api.g_exc_error THEN
181: ROLLBACK;
182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: WHEN fnd_api.g_exc_unexpected_error THEN
185: ROLLBACK;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
188: WHEN NO_DATA_FOUND THEN

Line 186: x_return_status := fnd_api.g_ret_sts_unexp_error;

182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: WHEN fnd_api.g_exc_unexpected_error THEN
185: ROLLBACK;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
188: WHEN NO_DATA_FOUND THEN
189: null;
190:

Line 194: x_return_status := fnd_api.g_ret_sts_unexp_error;

190:
191: WHEN OTHERS THEN
192: ROLLBACK;
193: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195:
196:
197: commit;
198: END DELETE_Actions;

Line 231: x_return_status := fnd_api.g_ret_sts_success;

227: v_Dummy INTEGER;
228:
229: BEGIN
230: fnd_msg_pub.delete_msg();
231: x_return_status := fnd_api.g_ret_sts_success;
232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';

Line 249: WHEN fnd_api.g_exc_error THEN

245: using r_action_user_label, r_action_description,r_param_set_id, l_language,l_source_lang ;
246:
247:
248: EXCEPTION
249: WHEN fnd_api.g_exc_error THEN
250: ROLLBACK;
251: x_return_status := fnd_api.g_ret_sts_error;
252:
253: WHEN fnd_api.g_exc_unexpected_error THEN

Line 251: x_return_status := fnd_api.g_ret_sts_error;

247:
248: EXCEPTION
249: WHEN fnd_api.g_exc_error THEN
250: ROLLBACK;
251: x_return_status := fnd_api.g_ret_sts_error;
252:
253: WHEN fnd_api.g_exc_unexpected_error THEN
254: ROLLBACK;
255: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 253: WHEN fnd_api.g_exc_unexpected_error THEN

249: WHEN fnd_api.g_exc_error THEN
250: ROLLBACK;
251: x_return_status := fnd_api.g_ret_sts_error;
252:
253: WHEN fnd_api.g_exc_unexpected_error THEN
254: ROLLBACK;
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256:
257: WHEN OTHERS THEN

Line 255: x_return_status := fnd_api.g_ret_sts_unexp_error;

251: x_return_status := fnd_api.g_ret_sts_error;
252:
253: WHEN fnd_api.g_exc_unexpected_error THEN
254: ROLLBACK;
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256:
257: WHEN OTHERS THEN
258: ROLLBACK;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256:
257: WHEN OTHERS THEN
258: ROLLBACK;
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260:
261: commit;
262: END Update_MAction;
263:

Line 293: x_return_status := fnd_api.g_ret_sts_success;

289:
290: BEGIN
291:
292: fnd_msg_pub.delete_msg();
293: x_return_status := fnd_api.g_ret_sts_success;
294: FND_MSG_PUB.initialize;
295: x_msg_data := '';
296:
297: execute immediate 'select unique(object_version_number) from ieu_wp_action_maps where wp_action_map_ID = :1'

Line 320: WHEN fnd_api.g_exc_error THEN

316:
317: commit;
318:
319: EXCEPTION
320: WHEN fnd_api.g_exc_error THEN
321: ROLLBACK;
322: x_return_status := fnd_api.g_ret_sts_error;
323:
324: WHEN fnd_api.g_exc_unexpected_error THEN

Line 322: x_return_status := fnd_api.g_ret_sts_error;

318:
319: EXCEPTION
320: WHEN fnd_api.g_exc_error THEN
321: ROLLBACK;
322: x_return_status := fnd_api.g_ret_sts_error;
323:
324: WHEN fnd_api.g_exc_unexpected_error THEN
325: ROLLBACK;
326: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 324: WHEN fnd_api.g_exc_unexpected_error THEN

320: WHEN fnd_api.g_exc_error THEN
321: ROLLBACK;
322: x_return_status := fnd_api.g_ret_sts_error;
323:
324: WHEN fnd_api.g_exc_unexpected_error THEN
325: ROLLBACK;
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327:
328: WHEN NO_DATA_FOUND THEN

Line 326: x_return_status := fnd_api.g_ret_sts_unexp_error;

322: x_return_status := fnd_api.g_ret_sts_error;
323:
324: WHEN fnd_api.g_exc_unexpected_error THEN
325: ROLLBACK;
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327:
328: WHEN NO_DATA_FOUND THEN
329: null;
330:

Line 333: x_return_status := fnd_api.g_ret_sts_unexp_error;

329: null;
330:
331: WHEN OTHERS THEN
332: ROLLBACK;
333: x_return_status := fnd_api.g_ret_sts_unexp_error;
334: commit;
335:
336: END UPDATE_action_map;
337:

Line 408: x_return_status := fnd_api.g_ret_sts_success;

404: where sel_enum_id = v_sel_enum_id);
405: c_rec2 c_cursor2%ROWTYPE;
406: BEGIN
407: fnd_msg_pub.delete_msg();
408: x_return_status := fnd_api.g_ret_sts_success;
409: FND_MSG_PUB.initialize;
410: x_msg_data := '';
411:
412: if(r_MACTION_DEF_TYPE_FLAG <> 'F') then

Line 495: WHEN fnd_api.g_exc_error THEN

491: end if;
492: commit;
493:
494: EXCEPTION
495: WHEN fnd_api.g_exc_error THEN
496: ROLLBACK;
497: x_return_status := fnd_api.g_ret_sts_error;
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN

Line 497: x_return_status := fnd_api.g_ret_sts_error;

493:
494: EXCEPTION
495: WHEN fnd_api.g_exc_error THEN
496: ROLLBACK;
497: x_return_status := fnd_api.g_ret_sts_error;
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN
500: ROLLBACK;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 499: WHEN fnd_api.g_exc_unexpected_error THEN

495: WHEN fnd_api.g_exc_error THEN
496: ROLLBACK;
497: x_return_status := fnd_api.g_ret_sts_error;
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN
500: ROLLBACK;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: WHEN NO_DATA_FOUND THEN

Line 501: x_return_status := fnd_api.g_ret_sts_unexp_error;

497: x_return_status := fnd_api.g_ret_sts_error;
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN
500: ROLLBACK;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: WHEN NO_DATA_FOUND THEN
504: null;
505:

Line 508: x_return_status := fnd_api.g_ret_sts_unexp_error;

504: null;
505:
506: WHEN OTHERS THEN
507: ROLLBACK;
508: x_return_status := fnd_api.g_ret_sts_unexp_error;
509: commit;
510:
511: END UPDATE_action_map_sequence;
512:

Line 541: x_return_status := fnd_api.g_ret_sts_success;

537: temp_svr_type_id NUMBER(15);
538: l_count NUMBER(15) :=0;
539: BEGIN
540: fnd_msg_pub.delete_msg();
541: x_return_status := fnd_api.g_ret_sts_success;
542: FND_MSG_PUB.initialize;
543: x_msg_data := '';
544: execute immediate ' select count(*) '||
545: ' from ieu_wp_action_maps where wp_action_map_id = :1 '||

Line 570: WHEN fnd_api.g_exc_error THEN

566: COMMIT;
567:
568: EXCEPTION
569:
570: WHEN fnd_api.g_exc_error THEN
571: ROLLBACK;
572: x_return_status := fnd_api.g_ret_sts_error;
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN

Line 572: x_return_status := fnd_api.g_ret_sts_error;

568: EXCEPTION
569:
570: WHEN fnd_api.g_exc_error THEN
571: ROLLBACK;
572: x_return_status := fnd_api.g_ret_sts_error;
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN
575: ROLLBACK;
576: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 574: WHEN fnd_api.g_exc_unexpected_error THEN

570: WHEN fnd_api.g_exc_error THEN
571: ROLLBACK;
572: x_return_status := fnd_api.g_ret_sts_error;
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN
575: ROLLBACK;
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
578: WHEN NO_DATA_FOUND THEN

Line 576: x_return_status := fnd_api.g_ret_sts_unexp_error;

572: x_return_status := fnd_api.g_ret_sts_error;
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN
575: ROLLBACK;
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
578: WHEN NO_DATA_FOUND THEN
579: null;
580:

Line 583: x_return_status := fnd_api.g_ret_sts_unexp_error;

579: null;
580:
581: WHEN OTHERS THEN
582: ROLLBACK;
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584:
585: commit;
586:
587: END DELETE_action_map;

Line 654: x_return_status := fnd_api.g_ret_sts_success;

650:
651: BEGIN
652:
653: fnd_msg_pub.delete_msg();
654: x_return_status := fnd_api.g_ret_sts_success;
655: FND_MSG_PUB.initialize;
656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
658: x_msg_data := '';

Line 791: x_return_status := fnd_api.g_ret_sts_success;

787: null_string varchar2(200) := null;
788: BEGIN
789:
790: fnd_msg_pub.delete_msg();
791: x_return_status := fnd_api.g_ret_sts_success;
792: FND_MSG_PUB.initialize;
793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
795: x_msg_data := '';

Line 993: WHEN fnd_api.g_exc_error THEN

989: l_temp_map_sequence, r_dev_data_flag;
990: end loop;
991: CLOSE c_cur2;
992: EXCEPTION
993: WHEN fnd_api.g_exc_error THEN
994: ROLLBACK;
995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: WHEN fnd_api.g_exc_unexpected_error THEN

Line 995: x_return_status := fnd_api.g_ret_sts_error;

991: CLOSE c_cur2;
992: EXCEPTION
993: WHEN fnd_api.g_exc_error THEN
994: ROLLBACK;
995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: WHEN fnd_api.g_exc_unexpected_error THEN
998: ROLLBACK;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 997: WHEN fnd_api.g_exc_unexpected_error THEN

993: WHEN fnd_api.g_exc_error THEN
994: ROLLBACK;
995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: WHEN fnd_api.g_exc_unexpected_error THEN
998: ROLLBACK;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000:
1001: WHEN OTHERS THEN

Line 999: x_return_status := fnd_api.g_ret_sts_unexp_error;

995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: WHEN fnd_api.g_exc_unexpected_error THEN
998: ROLLBACK;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000:
1001: WHEN OTHERS THEN
1002: ROLLBACK;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000:
1001: WHEN OTHERS THEN
1002: ROLLBACK;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004:
1005:
1006: commit;
1007: end CreateFromAction2;

Line 1101: x_return_status := fnd_api.g_ret_sts_success;

1097:
1098: Begin
1099:
1100: fnd_msg_pub.delete_msg();
1101: x_return_status := fnd_api.g_ret_sts_success;
1102: FND_MSG_PUB.initialize;
1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1105: x_msg_data := '';

Line 1271: WHEN fnd_api.g_exc_error THEN

1267: end LOOP; -- for c_cur2
1268: CLOSE c_cur2;
1269: commit;
1270: EXCEPTION
1271: WHEN fnd_api.g_exc_error THEN
1272: ROLLBACK;
1273: x_return_status := fnd_api.g_ret_sts_error;
1274:
1275: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1273: x_return_status := fnd_api.g_ret_sts_error;

1269: commit;
1270: EXCEPTION
1271: WHEN fnd_api.g_exc_error THEN
1272: ROLLBACK;
1273: x_return_status := fnd_api.g_ret_sts_error;
1274:
1275: WHEN fnd_api.g_exc_unexpected_error THEN
1276: ROLLBACK;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1275: WHEN fnd_api.g_exc_unexpected_error THEN

1271: WHEN fnd_api.g_exc_error THEN
1272: ROLLBACK;
1273: x_return_status := fnd_api.g_ret_sts_error;
1274:
1275: WHEN fnd_api.g_exc_unexpected_error THEN
1276: ROLLBACK;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: WHEN OTHERS THEN

Line 1277: x_return_status := fnd_api.g_ret_sts_unexp_error;

1273: x_return_status := fnd_api.g_ret_sts_error;
1274:
1275: WHEN fnd_api.g_exc_unexpected_error THEN
1276: ROLLBACK;
1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: WHEN OTHERS THEN
1280: ROLLBACK;
1281: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1281: x_return_status := fnd_api.g_ret_sts_unexp_error;

1277: x_return_status := fnd_api.g_ret_sts_unexp_error;
1278:
1279: WHEN OTHERS THEN
1280: ROLLBACK;
1281: x_return_status := fnd_api.g_ret_sts_unexp_error;
1282:
1283: end UpdateParamProps;
1284:
1285:

Line 1348: x_return_status := fnd_api.g_ret_sts_success;

1344:
1345: l_count NUMBER:=1;
1346: begin
1347: fnd_msg_pub.delete_msg();
1348: x_return_status := fnd_api.g_ret_sts_success;
1349: FND_MSG_PUB.initialize;
1350:
1351: x_msg_data := '';
1352: if (r_panel = 'F') then

Line 1552: x_return_status := fnd_api.g_ret_sts_success;

1548:
1549: BEGIN
1550:
1551: fnd_msg_pub.delete_msg();
1552: x_return_status := fnd_api.g_ret_sts_success;
1553: FND_MSG_PUB.initialize;
1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1556: x_msg_data := '';

Line 1693: WHEN fnd_api.g_exc_error THEN

1689: end loop;
1690: CLOSE c_cur2;
1691: commit;
1692: EXCEPTION
1693: WHEN fnd_api.g_exc_error THEN
1694: ROLLBACK;
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1695: x_return_status := fnd_api.g_ret_sts_error;

1691: commit;
1692: EXCEPTION
1693: WHEN fnd_api.g_exc_error THEN
1694: ROLLBACK;
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: ROLLBACK;
1699: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1697: WHEN fnd_api.g_exc_unexpected_error THEN

1693: WHEN fnd_api.g_exc_error THEN
1694: ROLLBACK;
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: ROLLBACK;
1699: x_return_status := fnd_api.g_ret_sts_unexp_error;
1700:
1701: WHEN OTHERS THEN

Line 1699: x_return_status := fnd_api.g_ret_sts_unexp_error;

1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: ROLLBACK;
1699: x_return_status := fnd_api.g_ret_sts_unexp_error;
1700:
1701: WHEN OTHERS THEN
1702: ROLLBACK;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1703: x_return_status := fnd_api.g_ret_sts_unexp_error;

1699: x_return_status := fnd_api.g_ret_sts_unexp_error;
1700:
1701: WHEN OTHERS THEN
1702: ROLLBACK;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:
1705:
1706: end CreateFromQFilter;
1707: