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_WORK_ACTION_PVT dependencies on FND_API

Line 37: x_return_status := fnd_api.g_ret_sts_success;

33:
34: BEGIN
35:
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
41: x_msg_data := '';

Line 186: x_return_status := fnd_api.g_ret_sts_success;

182: end if;
183: end if;
184:
185:
186: x_return_status := fnd_api.g_ret_sts_success;
187: COMMIT;
188: END if;
189:
190: EXCEPTION

Line 192: x_return_status := fnd_api.g_ret_sts_unexp_error;

188: END if;
189:
190: EXCEPTION
191: WHEN name_fail_exception THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193:
194: fnd_message.set_name ('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
195: fnd_msg_pub.add;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 196: x_return_status := fnd_api.g_ret_sts_unexp_error;

192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193:
194: fnd_message.set_name ('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
195: fnd_msg_pub.add;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get (
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );

Line 202: WHEN fnd_api.g_exc_error THEN

198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:
202: WHEN fnd_api.g_exc_error THEN
203: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
204:
205: ROLLBACK;
206: x_return_status := fnd_api.g_ret_sts_error;

Line 206: x_return_status := fnd_api.g_ret_sts_error;

202: WHEN fnd_api.g_exc_error THEN
203: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
204:
205: ROLLBACK;
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: WHEN fnd_api.g_exc_unexpected_error THEN
209: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
210:

Line 208: WHEN fnd_api.g_exc_unexpected_error THEN

204:
205: ROLLBACK;
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: WHEN fnd_api.g_exc_unexpected_error THEN
209: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
210:
211: ROLLBACK;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: WHEN fnd_api.g_exc_unexpected_error THEN
209: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
210:
211: ROLLBACK;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:
214: WHEN OTHERS THEN
215: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
216:

Line 218: x_return_status := fnd_api.g_ret_sts_unexp_error;

214: WHEN OTHERS THEN
215: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
216:
217: ROLLBACK;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220:
221: END Node_Mapping;
222:

Line 244: x_return_status := fnd_api.g_ret_sts_success;

240: BEGIN
241:
242:
243: fnd_msg_pub.delete_msg();
244: x_return_status := fnd_api.g_ret_sts_success;
245: FND_MSG_PUB.initialize;
246:
247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
248: l_set_id_count :=0;

Line 286: x_return_status := FND_API.G_RET_STS_ERROR;

282:
283: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
284: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
285: FND_MSG_PUB.Add;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287: end if;
288:
289: -- x_return_status := fnd_api.g_ret_sts_success;
290:

Line 289: -- x_return_status := fnd_api.g_ret_sts_success;

285: FND_MSG_PUB.Add;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287: end if;
288:
289: -- x_return_status := fnd_api.g_ret_sts_success;
290:
291: x_msg_count := fnd_msg_pub.COUNT_MSG();
292:
293: FOR i in 1..x_msg_count LOOP

Line 296: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

292:
293: FOR i in 1..x_msg_count LOOP
294: l_msg_data := '';
295: l_msg_count := 0;
296: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
297: x_msg_data := x_msg_data || ',' || l_msg_data;
298: END LOOP;
299:
300: EXCEPTION

Line 302: WHEN FND_API.G_EXC_ERROR THEN

298: END LOOP;
299:
300: EXCEPTION
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: x_msg_count := fnd_msg_pub.COUNT_MSG();
306:

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: EXCEPTION
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: x_msg_count := fnd_msg_pub.COUNT_MSG();
306:
307: FOR i in 1..x_msg_count LOOP
308: l_msg_data := '';

Line 310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

306:
307: FOR i in 1..x_msg_count LOOP
308: l_msg_data := '';
309: l_msg_count := 0;
310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
311: x_msg_data := x_msg_data || ',' || l_msg_data;
312: END LOOP;
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
311: x_msg_data := x_msg_data || ',' || l_msg_data;
312: END LOOP;
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_msg_count := fnd_msg_pub.COUNT_MSG();
317:
318: FOR i in 1..x_msg_count LOOP

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

311: x_msg_data := x_msg_data || ',' || l_msg_data;
312: END LOOP;
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_msg_count := fnd_msg_pub.COUNT_MSG();
317:
318: FOR i in 1..x_msg_count LOOP
319: l_msg_data := '';

Line 321: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

317:
318: FOR i in 1..x_msg_count LOOP
319: l_msg_data := '';
320: l_msg_count := 0;
321: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
322: x_msg_data := x_msg_data || ',' || l_msg_data;
323: END LOOP;
324: WHEN OTHERS THEN
325: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: x_msg_data := x_msg_data || ',' || l_msg_data;
323: END LOOP;
324: WHEN OTHERS THEN
325: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: x_msg_count := fnd_msg_pub.COUNT_MSG();
328:
329: FOR i in 1..x_msg_count LOOP
330: l_msg_data := '';

Line 332: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

328:
329: FOR i in 1..x_msg_count LOOP
330: l_msg_data := '';
331: l_msg_count := 0;
332: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
333: x_msg_data := x_msg_data || ',' || l_msg_data;
334: END LOOP;
335:
336: END Validate_Action_Label;

Line 406: WHEN fnd_api.g_exc_error THEN

402:
403: COMMIT;
404:
405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
407: ROLLBACK;
408: x_return_status := fnd_api.g_ret_sts_error;
409:
410: WHEN fnd_api.g_exc_unexpected_error THEN

Line 408: x_return_status := fnd_api.g_ret_sts_error;

404:
405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
407: ROLLBACK;
408: x_return_status := fnd_api.g_ret_sts_error;
409:
410: WHEN fnd_api.g_exc_unexpected_error THEN
411: ROLLBACK;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 410: WHEN fnd_api.g_exc_unexpected_error THEN

406: WHEN fnd_api.g_exc_error THEN
407: ROLLBACK;
408: x_return_status := fnd_api.g_ret_sts_error;
409:
410: WHEN fnd_api.g_exc_unexpected_error THEN
411: ROLLBACK;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413:
414: WHEN OTHERS THEN

Line 412: x_return_status := fnd_api.g_ret_sts_unexp_error;

408: x_return_status := fnd_api.g_ret_sts_error;
409:
410: WHEN fnd_api.g_exc_unexpected_error THEN
411: ROLLBACK;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413:
414: WHEN OTHERS THEN
415: ROLLBACK;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 416: x_return_status := fnd_api.g_ret_sts_unexp_error;

412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413:
414: WHEN OTHERS THEN
415: ROLLBACK;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417:
418: END CREATE_action_map;
419:
420: PROCEDURE Create_Work_Action (x_return_status OUT NOCOPY VARCHAR2,

Line 447: x_return_status := fnd_api.g_ret_sts_success;

443: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
445: BEGIN
446: fnd_msg_pub.delete_msg();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;
449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
451: x_msg_data := '';

Line 647: x_return_status := fnd_api.g_ret_sts_success;

643:
644: end if;
645:
646:
647: x_return_status := fnd_api.g_ret_sts_success;
648: else
649: x_return_status := l_return_status;
650: x_msg_count := l_msg_count;
651: x_msg_data := l_msg_data;

Line 658: WHEN fnd_api.g_exc_error THEN

654:
655: COMMIT;
656:
657: EXCEPTION
658: WHEN fnd_api.g_exc_error THEN
659: ROLLBACK;
660: x_return_status := fnd_api.g_ret_sts_error;
661:
662: WHEN fnd_api.g_exc_unexpected_error THEN

Line 660: x_return_status := fnd_api.g_ret_sts_error;

656:
657: EXCEPTION
658: WHEN fnd_api.g_exc_error THEN
659: ROLLBACK;
660: x_return_status := fnd_api.g_ret_sts_error;
661:
662: WHEN fnd_api.g_exc_unexpected_error THEN
663: ROLLBACK;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 662: WHEN fnd_api.g_exc_unexpected_error THEN

658: WHEN fnd_api.g_exc_error THEN
659: ROLLBACK;
660: x_return_status := fnd_api.g_ret_sts_error;
661:
662: WHEN fnd_api.g_exc_unexpected_error THEN
663: ROLLBACK;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: WHEN OTHERS THEN

Line 664: x_return_status := fnd_api.g_ret_sts_unexp_error;

660: x_return_status := fnd_api.g_ret_sts_error;
661:
662: WHEN fnd_api.g_exc_unexpected_error THEN
663: ROLLBACK;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: WHEN OTHERS THEN
667: ROLLBACK;
668: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 668: x_return_status := fnd_api.g_ret_sts_unexp_error;

664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: WHEN OTHERS THEN
667: ROLLBACK;
668: x_return_status := fnd_api.g_ret_sts_unexp_error;
669:
670: END Create_Work_Action;
671: -- ===============================================================
672: -- Start of Comments

Line 741: x_return_status := fnd_api.g_ret_sts_success;

737: );
738: BEGIN
739:
740: fnd_msg_pub.delete_msg();
741: x_return_status := fnd_api.g_ret_sts_success;
742: FND_MSG_PUB.initialize;
743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
745: x_msg_data := '';

Line 861: WHEN fnd_api.g_exc_error THEN

857:
858:
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK;
863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN fnd_api.g_exc_unexpected_error THEN

Line 863: x_return_status := fnd_api.g_ret_sts_error;

859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK;
863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN fnd_api.g_exc_unexpected_error THEN
866: ROLLBACK;
867: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 865: WHEN fnd_api.g_exc_unexpected_error THEN

861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK;
863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN fnd_api.g_exc_unexpected_error THEN
866: ROLLBACK;
867: x_return_status := fnd_api.g_ret_sts_unexp_error;
868:
869: WHEN OTHERS THEN

Line 867: x_return_status := fnd_api.g_ret_sts_unexp_error;

863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN fnd_api.g_exc_unexpected_error THEN
866: ROLLBACK;
867: x_return_status := fnd_api.g_ret_sts_unexp_error;
868:
869: WHEN OTHERS THEN
870: ROLLBACK;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 871: x_return_status := fnd_api.g_ret_sts_unexp_error;

867: x_return_status := fnd_api.g_ret_sts_unexp_error;
868:
869: WHEN OTHERS THEN
870: ROLLBACK;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: end;
873:
874: end loop;
875: end if ;

Line 901: x_return_status := fnd_api.g_ret_sts_success;

897: l_mact_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
898: l_section_id number;
899:
900: BEGIN
901: x_return_status := fnd_api.g_ret_sts_success;
902: x_msg_count := 0;
903: x_msg_data := '';
904:
905: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 1079: WHEN fnd_api.g_exc_unexpected_error THEN

1075: end if;
1076: end if;
1077: COMMIT;
1078: EXCEPTION
1079: WHEN fnd_api.g_exc_unexpected_error THEN
1080: ROLLBACK;
1081: x_return_status := fnd_api.g_ret_sts_unexp_error;
1082:
1083: WHEN OTHERS THEN

Line 1081: x_return_status := fnd_api.g_ret_sts_unexp_error;

1077: COMMIT;
1078: EXCEPTION
1079: WHEN fnd_api.g_exc_unexpected_error THEN
1080: ROLLBACK;
1081: x_return_status := fnd_api.g_ret_sts_unexp_error;
1082:
1083: WHEN OTHERS THEN
1084: ROLLBACK;
1085: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1085: x_return_status := fnd_api.g_ret_sts_unexp_error;

1081: x_return_status := fnd_api.g_ret_sts_unexp_error;
1082:
1083: WHEN OTHERS THEN
1084: ROLLBACK;
1085: x_return_status := fnd_api.g_ret_sts_unexp_error;
1086: END Delete_Action_From_Node;
1087:
1088:
1089: END ieu_work_action_pvt;