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

Line 70: x_return_status := fnd_api.g_ret_sts_success;

66:
67: BEGIN
68:
69: fnd_msg_pub.delete_msg();
70: x_return_status := fnd_api.g_ret_sts_success;
71: FND_MSG_PUB.initialize;
72:
73: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
74: l_act_usr_lbl_count := 0;

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: if (l_temp_act_label <> rec_obj.action_user_label) then
190: if (l_set_id_count <> 0) then
191: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: end if;
195: end if;
196: else
197: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: else
197: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
198: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
199: FND_MSG_PUB.Add;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: end if;
202: end if;
203:
204:

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216:
217: if (l_set_id_count >= 1) then
218: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
219: FND_MSG_PUB.Add;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: end if;
222: end if;
223:
224: temp_act_key := LTRIM(RTRIM(rec_obj.maction_def_key));

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232:
233: if (l_act_def_key_count <> 0) then
234: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_NAME_UNIQUE');
235: FND_MSG_PUB.Add;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: end if;
238:
239: end if;
240:

Line 256: -- x_return_status := FND_API.G_RET_STS_ERROR;

252:
253: -- if (l_temp_count <= 0) then
254: -- FND_MESSAGE.set_name('IEU', 'IEU_PROV_PKG_INVALID');
255: -- FND_MSG_PUB.Add;
256: -- x_return_status := FND_API.G_RET_STS_ERROR;
257: -- end if;
258:
259:
260:

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

262:
263: FOR i in 1..x_msg_count LOOP
264: l_msg_data := '';
265: l_msg_count := 0;
266: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
267: x_msg_data := x_msg_data || ',' || l_msg_data;
268:
269: END LOOP;
270:

Line 273: WHEN FND_API.G_EXC_ERROR THEN

269: END LOOP;
270:
271: EXCEPTION
272:
273: WHEN FND_API.G_EXC_ERROR THEN
274:
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: x_msg_count := fnd_msg_pub.COUNT_MSG();
277: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: EXCEPTION
272:
273: WHEN FND_API.G_EXC_ERROR THEN
274:
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: x_msg_count := fnd_msg_pub.COUNT_MSG();
277: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
278:
279: FOR i in 1..x_msg_count LOOP

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

278:
279: FOR i in 1..x_msg_count LOOP
280: l_msg_data := '';
281: l_msg_count := 0;
282: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
283: x_msg_data := x_msg_data || ',' || l_msg_data;
284: END LOOP;
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
283: x_msg_data := x_msg_data || ',' || l_msg_data;
284: END LOOP;
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: x_msg_count := fnd_msg_pub.COUNT_MSG();
290:

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

284: END LOOP;
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: x_msg_count := fnd_msg_pub.COUNT_MSG();
290:
291: FOR i in 1..x_msg_count LOOP
292: l_msg_data := '';

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

290:
291: FOR i in 1..x_msg_count LOOP
292: l_msg_data := '';
293: l_msg_count := 0;
294: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
295: x_msg_data := x_msg_data || ',' || l_msg_data;
296: END LOOP;
297: WHEN OTHERS THEN
298: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295: x_msg_data := x_msg_data || ',' || l_msg_data;
296: END LOOP;
297: WHEN OTHERS THEN
298: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: --DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
301:
302:
303: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

304:
305: FOR i in 1..x_msg_count LOOP
306: l_msg_data := '';
307: l_msg_count := 0;
308: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
309: x_msg_data := x_msg_data || ',' || l_msg_data;
310: END LOOP;
311: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
312:

Line 356: x_return_status := fnd_api.g_ret_sts_success;

352: BEGIN
353:
354:
355: fnd_msg_pub.delete_msg();
356: x_return_status := fnd_api.g_ret_sts_success;
357: FND_MSG_PUB.initialize;
358:
359: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
360: l_set_id_count :=0;

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458:
459: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
460: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
461: FND_MSG_PUB.Add;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: end if;
464:
465: -- x_return_status := fnd_api.g_ret_sts_success;
466:

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

461: FND_MSG_PUB.Add;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: end if;
464:
465: -- x_return_status := fnd_api.g_ret_sts_success;
466:
467: x_msg_count := fnd_msg_pub.COUNT_MSG();
468:
469: FOR i in 1..x_msg_count LOOP

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

468:
469: FOR i in 1..x_msg_count LOOP
470: l_msg_data := '';
471: l_msg_count := 0;
472: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
473: x_msg_data := x_msg_data || ',' || l_msg_data;
474: END LOOP;
475:
476: EXCEPTION

Line 478: WHEN FND_API.G_EXC_ERROR THEN

474: END LOOP;
475:
476: EXCEPTION
477:
478: WHEN FND_API.G_EXC_ERROR THEN
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: x_msg_count := fnd_msg_pub.COUNT_MSG();
482: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476: EXCEPTION
477:
478: WHEN FND_API.G_EXC_ERROR THEN
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: x_msg_count := fnd_msg_pub.COUNT_MSG();
482: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
483:
484: FOR i in 1..x_msg_count LOOP

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

483:
484: FOR i in 1..x_msg_count LOOP
485: l_msg_data := '';
486: l_msg_count := 0;
487: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
488: x_msg_data := x_msg_data || ',' || l_msg_data;
489: END LOOP;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

487: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
488: x_msg_data := x_msg_data || ',' || l_msg_data;
489: END LOOP;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
493:
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
493:
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: x_msg_count := fnd_msg_pub.COUNT_MSG();
497:
498: FOR i in 1..x_msg_count LOOP
499: l_msg_data := '';

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

497:
498: FOR i in 1..x_msg_count LOOP
499: l_msg_data := '';
500: l_msg_count := 0;
501: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
502: x_msg_data := x_msg_data || ',' || l_msg_data;
503: END LOOP;
504: WHEN OTHERS THEN
505: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: x_msg_data := x_msg_data || ',' || l_msg_data;
503: END LOOP;
504: WHEN OTHERS THEN
505: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
508:
509:
510: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

511:
512: FOR i in 1..x_msg_count LOOP
513: l_msg_data := '';
514: l_msg_count := 0;
515: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
516: x_msg_data := x_msg_data || ',' || l_msg_data;
517: END LOOP;
518: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
519:

Line 556: x_return_status := fnd_api.g_ret_sts_success;

552: BEGIN
553:
554:
555: fnd_msg_pub.delete_msg();
556: x_return_status := fnd_api.g_ret_sts_success;
557: FND_MSG_PUB.initialize;
558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
560: x_msg_data := '';

Line 574: WHEN fnd_api.g_exc_error THEN

570:
571: COMMIT;
572:
573: EXCEPTION
574: WHEN fnd_api.g_exc_error THEN
575: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
576: ROLLBACK;
577: x_return_status := fnd_api.g_ret_sts_error;
578:

Line 577: x_return_status := fnd_api.g_ret_sts_error;

573: EXCEPTION
574: WHEN fnd_api.g_exc_error THEN
575: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
576: ROLLBACK;
577: x_return_status := fnd_api.g_ret_sts_error;
578:
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
581: ROLLBACK;

Line 579: WHEN fnd_api.g_exc_unexpected_error THEN

575: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
576: ROLLBACK;
577: x_return_status := fnd_api.g_ret_sts_error;
578:
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
581: ROLLBACK;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583:

Line 582: x_return_status := fnd_api.g_ret_sts_unexp_error;

578:
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
581: ROLLBACK;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583:
584: WHEN OTHERS THEN
585: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
586:

Line 588: x_return_status := fnd_api.g_ret_sts_unexp_error;

584: WHEN OTHERS THEN
585: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
586:
587: ROLLBACK;
588: x_return_status := fnd_api.g_ret_sts_unexp_error;
589:
590: END Create_MAction;
591:
592: --===================================================================

Line 660: x_return_status := fnd_api.g_ret_sts_success;

656:
657:
658: BEGIN
659: fnd_msg_pub.delete_msg();
660: x_return_status := fnd_api.g_ret_sts_success;
661: FND_MSG_PUB.initialize;
662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
664: x_msg_data := '';

Line 951: x_return_status := fnd_api.g_ret_sts_success;

947: end if;
948: end if;
949:
950:
951: x_return_status := fnd_api.g_ret_sts_success;
952: else
953: x_return_status := l_return_status;
954: x_msg_count := l_msg_count;
955: x_msg_data := l_msg_data;

Line 962: WHEN fnd_api.g_exc_error THEN

958:
959: COMMIT;
960:
961: EXCEPTION
962: WHEN fnd_api.g_exc_error THEN
963: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
964: ROLLBACK;
965: x_return_status := fnd_api.g_ret_sts_error;
966:

Line 965: x_return_status := fnd_api.g_ret_sts_error;

961: EXCEPTION
962: WHEN fnd_api.g_exc_error THEN
963: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
964: ROLLBACK;
965: x_return_status := fnd_api.g_ret_sts_error;
966:
967: WHEN fnd_api.g_exc_unexpected_error THEN
968: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
969: ROLLBACK;

Line 967: WHEN fnd_api.g_exc_unexpected_error THEN

963: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
964: ROLLBACK;
965: x_return_status := fnd_api.g_ret_sts_error;
966:
967: WHEN fnd_api.g_exc_unexpected_error THEN
968: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
969: ROLLBACK;
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971:

Line 970: x_return_status := fnd_api.g_ret_sts_unexp_error;

966:
967: WHEN fnd_api.g_exc_unexpected_error THEN
968: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
969: ROLLBACK;
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971:
972: WHEN OTHERS THEN
973: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
974:

Line 976: x_return_status := fnd_api.g_ret_sts_unexp_error;

972: WHEN OTHERS THEN
973: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
974:
975: ROLLBACK;
976: x_return_status := fnd_api.g_ret_sts_unexp_error;
977:
978: END Create_MAction2;
979:
980: --===================================================================

Line 1020: x_return_status := fnd_api.g_ret_sts_success;

1016: BEGIN
1017:
1018:
1019: fnd_msg_pub.delete_msg();
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: FND_MSG_PUB.initialize;
1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1024: x_msg_data := '';

Line 1196: x_return_status := fnd_api.g_ret_sts_success;

1192: l_mact_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
1193: l_section_id number;
1194:
1195: BEGIN
1196: x_return_status := fnd_api.g_ret_sts_success;
1197: x_msg_count := 0;
1198: x_msg_data := '';
1199:
1200: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 1371: WHEN fnd_api.g_exc_unexpected_error THEN

1367: end if;
1368:
1369: COMMIT;
1370: EXCEPTION
1371: WHEN fnd_api.g_exc_unexpected_error THEN
1372: ROLLBACK;
1373: x_return_status := fnd_api.g_ret_sts_unexp_error;
1374:
1375: WHEN OTHERS THEN

Line 1373: x_return_status := fnd_api.g_ret_sts_unexp_error;

1369: COMMIT;
1370: EXCEPTION
1371: WHEN fnd_api.g_exc_unexpected_error THEN
1372: ROLLBACK;
1373: x_return_status := fnd_api.g_ret_sts_unexp_error;
1374:
1375: WHEN OTHERS THEN
1376: ROLLBACK;
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1377: x_return_status := fnd_api.g_ret_sts_unexp_error;

1373: x_return_status := fnd_api.g_ret_sts_unexp_error;
1374:
1375: WHEN OTHERS THEN
1376: ROLLBACK;
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1378: END Delete_Action_From_Node;
1379:
1380:
1381: --===================================================================

Line 1429: x_return_status := fnd_api.g_ret_sts_success;

1425:
1426: BEGIN
1427:
1428: fnd_msg_pub.delete_msg();
1429: x_return_status := fnd_api.g_ret_sts_success;
1430: FND_MSG_PUB.initialize;
1431:
1432: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1433: l_param_usr_lbl_count := 0;

Line 1464: x_return_status := FND_API.G_RET_STS_ERROR;

1460:
1461: if (l_param_name_count <> 0) then
1462: FND_MESSAGE.set_name('IEU', 'Parameter name must be unique');
1463: FND_MSG_PUB.Add;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: end if;
1466:
1467: if (l_param_usr_lbl_count <> 0) then
1468: FND_MESSAGE.set_name('IEU', 'Parameter label must be unique');

Line 1470: x_return_status := FND_API.G_RET_STS_ERROR;

1466:
1467: if (l_param_usr_lbl_count <> 0) then
1468: FND_MESSAGE.set_name('IEU', 'Parameter label must be unique');
1469: FND_MSG_PUB.Add;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: end if;
1472:
1473: end if;
1474:

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

1477:
1478: FOR i in 1..x_msg_count LOOP
1479: l_msg_data := '';
1480: l_msg_count := 0;
1481: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1482: x_msg_data := x_msg_data || ',' || l_msg_data;
1483: END LOOP;
1484:
1485: EXCEPTION

Line 1487: WHEN FND_API.G_EXC_ERROR THEN

1483: END LOOP;
1484:
1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_msg_count := fnd_msg_pub.COUNT_MSG();
1491: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_msg_count := fnd_msg_pub.COUNT_MSG();
1491: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
1492:
1493: FOR i in 1..x_msg_count LOOP

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

1492:
1493: FOR i in 1..x_msg_count LOOP
1494: l_msg_data := '';
1495: l_msg_count := 0;
1496: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1497: x_msg_data := x_msg_data || ',' || l_msg_data;
1498: END LOOP;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1496: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1497: x_msg_data := x_msg_data || ',' || l_msg_data;
1498: END LOOP;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: x_msg_count := fnd_msg_pub.COUNT_MSG();
1504:

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1498: END LOOP;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: x_msg_count := fnd_msg_pub.COUNT_MSG();
1504:
1505: FOR i in 1..x_msg_count LOOP
1506: l_msg_data := '';

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

1504:
1505: FOR i in 1..x_msg_count LOOP
1506: l_msg_data := '';
1507: l_msg_count := 0;
1508: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1509: x_msg_data := x_msg_data || ',' || l_msg_data;
1510: END LOOP;
1511: WHEN OTHERS THEN
1512: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1509: x_msg_data := x_msg_data || ',' || l_msg_data;
1510: END LOOP;
1511: WHEN OTHERS THEN
1512: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1515:
1516:
1517: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

1518:
1519: FOR i in 1..x_msg_count LOOP
1520: l_msg_data := '';
1521: l_msg_count := 0;
1522: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1523: x_msg_data := x_msg_data || ',' || l_msg_data;
1524: END LOOP;
1525: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
1526:

Line 1579: x_return_status := fnd_api.g_ret_sts_success;

1575: BEGIN
1576:
1577:
1578: fnd_msg_pub.delete_msg();
1579: x_return_status := fnd_api.g_ret_sts_success;
1580: FND_MSG_PUB.initialize;
1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1583: x_msg_data := '';

Line 1691: WHEN fnd_api.g_exc_error THEN

1687:
1688: COMMIT;
1689:
1690: EXCEPTION
1691: WHEN fnd_api.g_exc_error THEN
1692: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1693: ROLLBACK;
1694: x_return_status := fnd_api.g_ret_sts_error;
1695:

Line 1694: x_return_status := fnd_api.g_ret_sts_error;

1690: EXCEPTION
1691: WHEN fnd_api.g_exc_error THEN
1692: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1693: ROLLBACK;
1694: x_return_status := fnd_api.g_ret_sts_error;
1695:
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);

Line 1697: WHEN fnd_api.g_exc_unexpected_error THEN

1693: ROLLBACK;
1694: x_return_status := fnd_api.g_ret_sts_error;
1695:
1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1699: ROLLBACK;
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701:

Line 1700: x_return_status := fnd_api.g_ret_sts_unexp_error;

1696:
1697: WHEN fnd_api.g_exc_unexpected_error THEN
1698: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1699: ROLLBACK;
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701:
1702: WHEN OTHERS THEN
1703: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1704: ROLLBACK;

Line 1705: x_return_status := fnd_api.g_ret_sts_unexp_error;

1701:
1702: WHEN OTHERS THEN
1703: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1704: ROLLBACK;
1705: x_return_status := fnd_api.g_ret_sts_unexp_error;
1706:
1707:
1708: END Create_Param_Defs;
1709:

Line 1753: x_return_status := fnd_api.g_ret_sts_success;

1749: BEGIN
1750:
1751:
1752: fnd_msg_pub.delete_msg();
1753: x_return_status := fnd_api.g_ret_sts_success;
1754: FND_MSG_PUB.initialize;
1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1757: x_msg_data := '';

Line 1790: x_return_status := fnd_api.g_ret_sts_success;

1786: end if;
1787:
1788:
1789: COMMIT;
1790: x_return_status := fnd_api.g_ret_sts_success;
1791:
1792:
1793:
1794: END Update_Param_Defs;

Line 1844: x_return_status := fnd_api.g_ret_sts_success;

1840:
1841:
1842:
1843: fnd_msg_pub.delete_msg();
1844: x_return_status := fnd_api.g_ret_sts_success;
1845: FND_MSG_PUB.initialize;
1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1848: x_msg_data := '';

Line 1924: WHEN fnd_api.g_exc_error THEN

1920:
1921:
1922:
1923: EXCEPTION
1924: WHEN fnd_api.g_exc_error THEN
1925: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1926:
1927: ROLLBACK;
1928: x_return_status := fnd_api.g_ret_sts_error;

Line 1928: x_return_status := fnd_api.g_ret_sts_error;

1924: WHEN fnd_api.g_exc_error THEN
1925: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1926:
1927: ROLLBACK;
1928: x_return_status := fnd_api.g_ret_sts_error;
1929:
1930: WHEN fnd_api.g_exc_unexpected_error THEN
1931: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1932:

Line 1930: WHEN fnd_api.g_exc_unexpected_error THEN

1926:
1927: ROLLBACK;
1928: x_return_status := fnd_api.g_ret_sts_error;
1929:
1930: WHEN fnd_api.g_exc_unexpected_error THEN
1931: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1932:
1933: ROLLBACK;
1934: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1934: x_return_status := fnd_api.g_ret_sts_unexp_error;

1930: WHEN fnd_api.g_exc_unexpected_error THEN
1931: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1932:
1933: ROLLBACK;
1934: x_return_status := fnd_api.g_ret_sts_unexp_error;
1935:
1936: WHEN OTHERS THEN
1937: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
1938:

Line 1940: x_return_status := fnd_api.g_ret_sts_unexp_error;

1936: WHEN OTHERS THEN
1937: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
1938:
1939: ROLLBACK;
1940: x_return_status := fnd_api.g_ret_sts_unexp_error;
1941:
1942: END Create_Param_Props;
1943:
1944:

Line 1989: x_return_status := fnd_api.g_ret_sts_success;

1985:
1986: BEGIN
1987:
1988: fnd_msg_pub.delete_msg();
1989: x_return_status := fnd_api.g_ret_sts_success;
1990: FND_MSG_PUB.initialize;
1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1993: x_msg_data := '';

Line 2181: x_return_status := fnd_api.g_ret_sts_success;

2177:
2178:
2179: end if;
2180:
2181: x_return_status := fnd_api.g_ret_sts_success;
2182:
2183: COMMIT;
2184:
2185:

Line 2217: x_return_status := fnd_api.g_ret_sts_success;

2213:
2214: BEGIN
2215:
2216: fnd_msg_pub.delete_msg();
2217: x_return_status := fnd_api.g_ret_sts_success;
2218: FND_MSG_PUB.initialize;
2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2221: x_msg_data := '';

Line 2391: x_return_status := fnd_api.g_ret_sts_success;

2387:
2388:
2389: end if;
2390:
2391: x_return_status := fnd_api.g_ret_sts_success;
2392:
2393: COMMIT;
2394:
2395:

Line 2580: x_return_status := fnd_api.g_ret_sts_success;

2576:
2577: BEGIN
2578:
2579: fnd_msg_pub.delete_msg();
2580: x_return_status := fnd_api.g_ret_sts_success;
2581: FND_MSG_PUB.initialize;
2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2584: x_msg_data := '';

Line 2645: x_return_status := fnd_api.g_ret_sts_success;

2641:
2642: BEGIN
2643:
2644: fnd_msg_pub.delete_msg();
2645: x_return_status := fnd_api.g_ret_sts_success;
2646: FND_MSG_PUB.initialize;
2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2649: x_msg_data := '';

Line 2736: x_return_status := fnd_api.g_ret_sts_success;

2732:
2733: BEGIN
2734:
2735: fnd_msg_pub.delete_msg();
2736: x_return_status := fnd_api.g_ret_sts_success;
2737: FND_MSG_PUB.initialize;
2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2740: x_msg_data := '';

Line 2874: x_return_status := fnd_api.g_ret_sts_success;

2870: end if;
2871: end if;
2872: end if;
2873:
2874: x_return_status := fnd_api.g_ret_sts_success;
2875: COMMIT;
2876:
2877:
2878: EXCEPTION

Line 2879: WHEN fnd_api.g_exc_error THEN

2875: COMMIT;
2876:
2877:
2878: EXCEPTION
2879: WHEN fnd_api.g_exc_error THEN
2880: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
2881:
2882: ROLLBACK;
2883: x_return_status := fnd_api.g_ret_sts_error;

Line 2883: x_return_status := fnd_api.g_ret_sts_error;

2879: WHEN fnd_api.g_exc_error THEN
2880: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
2881:
2882: ROLLBACK;
2883: x_return_status := fnd_api.g_ret_sts_error;
2884:
2885: WHEN fnd_api.g_exc_unexpected_error THEN
2886: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
2887:

Line 2885: WHEN fnd_api.g_exc_unexpected_error THEN

2881:
2882: ROLLBACK;
2883: x_return_status := fnd_api.g_ret_sts_error;
2884:
2885: WHEN fnd_api.g_exc_unexpected_error THEN
2886: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
2887:
2888: ROLLBACK;
2889: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2889: x_return_status := fnd_api.g_ret_sts_unexp_error;

2885: WHEN fnd_api.g_exc_unexpected_error THEN
2886: --dbms_outPUT.PUT_LINE('unexpected Error : '||sqlerrm);
2887:
2888: ROLLBACK;
2889: x_return_status := fnd_api.g_ret_sts_unexp_error;
2890:
2891: WHEN OTHERS THEN
2892: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
2893:

Line 2895: x_return_status := fnd_api.g_ret_sts_unexp_error;

2891: WHEN OTHERS THEN
2892: --dbms_outPUT.PUT_LINE('other Error : '||sqlerrm);
2893:
2894: ROLLBACK;
2895: x_return_status := fnd_api.g_ret_sts_unexp_error;
2896:
2897:
2898: END Map_Action;
2899:

Line 2938: x_return_status := fnd_api.g_ret_sts_success;

2934: BEGIN
2935:
2936:
2937: fnd_msg_pub.delete_msg();
2938: x_return_status := fnd_api.g_ret_sts_success;
2939: FND_MSG_PUB.initialize;
2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2942: x_msg_data := '';

Line 2961: x_return_status := fnd_api.g_ret_sts_success;

2957: if (sql%notfound) then
2958: null;
2959: end if;
2960:
2961: x_return_status := fnd_api.g_ret_sts_success;
2962: COMMIT;
2963: EXCEPTION
2964: WHEN fnd_api.g_exc_unexpected_error THEN
2965: ROLLBACK;

Line 2964: WHEN fnd_api.g_exc_unexpected_error THEN

2960:
2961: x_return_status := fnd_api.g_ret_sts_success;
2962: COMMIT;
2963: EXCEPTION
2964: WHEN fnd_api.g_exc_unexpected_error THEN
2965: ROLLBACK;
2966: x_return_status := fnd_api.g_ret_sts_unexp_error;
2967:
2968: WHEN OTHERS THEN

Line 2966: x_return_status := fnd_api.g_ret_sts_unexp_error;

2962: COMMIT;
2963: EXCEPTION
2964: WHEN fnd_api.g_exc_unexpected_error THEN
2965: ROLLBACK;
2966: x_return_status := fnd_api.g_ret_sts_unexp_error;
2967:
2968: WHEN OTHERS THEN
2969: ROLLBACK;
2970: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2970: x_return_status := fnd_api.g_ret_sts_unexp_error;

2966: x_return_status := fnd_api.g_ret_sts_unexp_error;
2967:
2968: WHEN OTHERS THEN
2969: ROLLBACK;
2970: x_return_status := fnd_api.g_ret_sts_unexp_error;
2971:
2972:
2973: END Update_Data_Type;
2974:

Line 3001: x_return_status := fnd_api.g_ret_sts_success;

2997:
2998:
2999: BEGIN
3000: fnd_msg_pub.delete_msg();
3001: x_return_status := fnd_api.g_ret_sts_success;
3002: FND_MSG_PUB.initialize;
3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
3005: x_msg_data := '';

Line 3022: x_return_status := fnd_api.g_ret_sts_success;

3018: if (sql%notfound) then
3019: null;
3020: end if;
3021:
3022: x_return_status := fnd_api.g_ret_sts_success;
3023: COMMIT;
3024: EXCEPTION
3025: WHEN fnd_api.g_exc_unexpected_error THEN
3026: ROLLBACK;

Line 3025: WHEN fnd_api.g_exc_unexpected_error THEN

3021:
3022: x_return_status := fnd_api.g_ret_sts_success;
3023: COMMIT;
3024: EXCEPTION
3025: WHEN fnd_api.g_exc_unexpected_error THEN
3026: ROLLBACK;
3027: x_return_status := fnd_api.g_ret_sts_unexp_error;
3028:
3029: WHEN OTHERS THEN

Line 3027: x_return_status := fnd_api.g_ret_sts_unexp_error;

3023: COMMIT;
3024: EXCEPTION
3025: WHEN fnd_api.g_exc_unexpected_error THEN
3026: ROLLBACK;
3027: x_return_status := fnd_api.g_ret_sts_unexp_error;
3028:
3029: WHEN OTHERS THEN
3030: ROLLBACK;
3031: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3031: x_return_status := fnd_api.g_ret_sts_unexp_error;

3027: x_return_status := fnd_api.g_ret_sts_unexp_error;
3028:
3029: WHEN OTHERS THEN
3030: ROLLBACK;
3031: x_return_status := fnd_api.g_ret_sts_unexp_error;
3032:
3033:
3034:
3035: END Update_Multi_Select_Flag;

Line 3063: x_return_status := fnd_api.g_ret_sts_success;

3059:
3060:
3061: BEGIN
3062: fnd_msg_pub.delete_msg();
3063: x_return_status := fnd_api.g_ret_sts_success;
3064: FND_MSG_PUB.initialize;
3065:
3066: x_msg_data := '';
3067: for c_rec in c_cur LOOP