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

Line 59: x_return_status := fnd_api.g_ret_sts_success;

55:
56: BEGIN
57:
58: fnd_msg_pub.delete_msg();
59: x_return_status := fnd_api.g_ret_sts_success;
60: FND_MSG_PUB.initialize;
61: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
62: x_msg_data := '';
63:

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64:
65: if (p_user_name is null) then
66: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_USER');
67: FND_MSG_PUB.Add;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69:
70: else
71:
72: begin

Line 86: x_return_status := FND_API.G_RET_STS_ERROR;

82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_USER_INVALID');
85: FND_MSG_PUB.Add;
86: x_return_status := FND_API.G_RET_STS_ERROR;
87:
88: end;
89:
90: end if;

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105: WHEN NO_DATA_FOUND THEN
106: --DBMS_OUTPUT.PUT_LINE('resource id does not exists ');
107: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESOURCEID');
108: FND_MSG_PUB.Add;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: --DBMS_OUTPUT.PUT_LINE('No data found for resource id : ');
111:
112: end;
113: end if;

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

123:
124: FOR i in 1..x_msg_count LOOP
125: l_msg_data := '';
126: l_msg_count := 0;
127: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
128: x_msg_data := x_msg_data || ',' || l_msg_data;
129: END LOOP;
130:
131:

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130:
131:
132: EXCEPTION
133:
134: WHEN FND_API.G_EXC_ERROR THEN
135:
136: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
137:
138: x_return_status := FND_API.G_RET_STS_ERROR;

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: WHEN FND_API.G_EXC_ERROR THEN
135:
136: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
137:
138: x_return_status := FND_API.G_RET_STS_ERROR;
139:
140: x_msg_count := fnd_msg_pub.COUNT_MSG();
141:
142: FOR i in 1..x_msg_count LOOP

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

141:
142: FOR i in 1..x_msg_count LOOP
143: l_msg_data := '';
144: l_msg_count := 0;
145: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
146: x_msg_data := x_msg_data || ',' || l_msg_data;
147: END LOOP;
148:
149:

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: x_msg_data := x_msg_data || ',' || l_msg_data;
147: END LOOP;
148:
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
153:
154:

Line 155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

151:
152: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
153:
154:
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: x_msg_count := fnd_msg_pub.COUNT_MSG();
157:
158: FOR i in 1..x_msg_count LOOP
159: l_msg_data := '';

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

157:
158: FOR i in 1..x_msg_count LOOP
159: l_msg_data := '';
160: l_msg_count := 0;
161: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
162: x_msg_data := x_msg_data || ',' || l_msg_data;
163: END LOOP;
164:
165: WHEN OTHERS THEN

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164:
165: WHEN OTHERS THEN
166: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
167:
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := fnd_msg_pub.COUNT_MSG();
170:
171: FOR i in 1..x_msg_count LOOP
172: l_msg_data := '';

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

170:
171: FOR i in 1..x_msg_count LOOP
172: l_msg_data := '';
173: l_msg_count := 0;
174: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
175: x_msg_data := x_msg_data || ',' || l_msg_data;
176: END LOOP;
177:
178:

Line 238: x_return_status := fnd_api.g_ret_sts_success;

234:
235: BEGIN
236:
237: fnd_msg_pub.delete_msg();
238: x_return_status := fnd_api.g_ret_sts_success;
239: FND_MSG_PUB.initialize;
240: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
241: x_msg_data := '';
242:

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: if (p_user_name is null) then
245:
246: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_USER');
247: FND_MSG_PUB.Add;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249:
250:
251: else
252: begin

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266:
267:
268: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_USER_INVALID');
269: FND_MSG_PUB.Add;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271:
272:
273: end;
274:

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: if (p_responsibility is null) then
279:
280: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESP');
281: FND_MSG_PUB.Add;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283:
284: else
285: begin
286:

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

333: WHEN NO_DATA_FOUND THEN
334:
335: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESP_USER');
336: FND_MSG_PUB.Add;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: WHEN others then
339: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_RESP_INVALID');
340: FND_MSG_PUB.Add;
341: x_return_status := FND_API.G_RET_STS_ERROR;

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: x_return_status := FND_API.G_RET_STS_ERROR;
338: WHEN others then
339: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_RESP_INVALID');
340: FND_MSG_PUB.Add;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342:
343: end;
344:
345: end;

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

365:
366: FOR i in 1..x_msg_count LOOP
367: l_msg_data := '';
368: l_msg_count := 0;
369: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
370: x_msg_data := x_msg_data || ',' || l_msg_data;
371: END LOOP;
372:
373:

Line 377: WHEN FND_API.G_EXC_ERROR THEN

373:
374:
375: EXCEPTION
376:
377: WHEN FND_API.G_EXC_ERROR THEN
378:
379:
380: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
381:

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379:
380: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
381:
382:
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: x_msg_count := fnd_msg_pub.COUNT_MSG();
385:
386: FOR i in 1..x_msg_count LOOP
387: l_msg_data := '';

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

385:
386: FOR i in 1..x_msg_count LOOP
387: l_msg_data := '';
388: l_msg_count := 0;
389: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
390: x_msg_data := x_msg_data || ',' || l_msg_data;
391: END LOOP;
392:
393:

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: END LOOP;
392:
393:
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396:
397: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
398:
399:

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

396:
397: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
398:
399:
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: x_msg_count := fnd_msg_pub.COUNT_MSG();
402:
403: FOR i in 1..x_msg_count LOOP
404: l_msg_data := '';

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

402:
403: FOR i in 1..x_msg_count LOOP
404: l_msg_data := '';
405: l_msg_count := 0;
406: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
407: x_msg_data := x_msg_data || ',' || l_msg_data;
408: END LOOP;
409:
410:

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: WHEN OTHERS THEN
412: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
413: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
414:
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: x_msg_count := fnd_msg_pub.COUNT_MSG();
417:
418: FOR i in 1..x_msg_count LOOP
419: l_msg_data := '';

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

417:
418: FOR i in 1..x_msg_count LOOP
419: l_msg_data := '';
420: l_msg_count := 0;
421: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
422: x_msg_data := x_msg_data || ',' || l_msg_data;
423: END LOOP;
424:
425:

Line 480: x_return_status := fnd_api.g_ret_sts_success;

476:
477: BEGIN
478:
479: fnd_msg_pub.delete_msg();
480: x_return_status := fnd_api.g_ret_sts_success;
481: FND_MSG_PUB.initialize;
482: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
483: x_msg_data := '';
484:

Line 495: x_return_status := FND_API.G_RET_STS_ERROR;

491:
492: IF l_count = 0 THEN
493: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_NO_OBJ_INVALID');
494: FND_MSG_PUB.Add;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496:
497: END if;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_NO_OBJ_INVALID');
501: FND_MSG_PUB.Add;
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504:
505: end;
506:

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: if (p_responsibility is null) then
510:
511: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESP');
512: FND_MSG_PUB.Add;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514:
515: else
516: if (p_responsibility = '-1') then
517: x_resp_id := p_responsibility;

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: WHEN NO_DATA_FOUND THEN
562:
563: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESP_USER');
564: FND_MSG_PUB.Add;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: WHEN others then
567: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_RESP_INVALID');
568: FND_MSG_PUB.Add;
569: x_return_status := FND_API.G_RET_STS_ERROR;

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: x_return_status := FND_API.G_RET_STS_ERROR;
566: WHEN others then
567: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_RESP_INVALID');
568: FND_MSG_PUB.Add;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570:
571: end;
572:
573: end;

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

593:
594: FOR i in 1..x_msg_count LOOP
595: l_msg_data := '';
596: l_msg_count := 0;
597: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
598: x_msg_data := x_msg_data || ',' || l_msg_data;
599: END LOOP;
600:
601:

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601:
602:
603: EXCEPTION
604:
605: WHEN FND_API.G_EXC_ERROR THEN
606:
607:
608: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
609:

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607:
608: --DBMS_OUTPUT.PUT_LINE('TError : '||sqlerrm);
609:
610:
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_msg_count := fnd_msg_pub.COUNT_MSG();
613:
614: FOR i in 1..x_msg_count LOOP
615: l_msg_data := '';

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

613:
614: FOR i in 1..x_msg_count LOOP
615: l_msg_data := '';
616: l_msg_count := 0;
617: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
618: x_msg_data := x_msg_data || ',' || l_msg_data;
619: END LOOP;
620:
621:

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

619: END LOOP;
620:
621:
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624:
625: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
626:
627:

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624:
625: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
626:
627:
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: x_msg_count := fnd_msg_pub.COUNT_MSG();
630:
631: FOR i in 1..x_msg_count LOOP
632: l_msg_data := '';

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

630:
631: FOR i in 1..x_msg_count LOOP
632: l_msg_data := '';
633: l_msg_count := 0;
634: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
635: x_msg_data := x_msg_data || ',' || l_msg_data;
636: END LOOP;
637:
638:

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: WHEN OTHERS THEN
640: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
641: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
642:
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: x_msg_count := fnd_msg_pub.COUNT_MSG();
645:
646: FOR i in 1..x_msg_count LOOP
647: l_msg_data := '';

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

645:
646: FOR i in 1..x_msg_count LOOP
647: l_msg_data := '';
648: l_msg_count := 0;
649: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
650: x_msg_data := x_msg_data || ',' || l_msg_data;
651: END LOOP;
652:
653:

Line 731: x_return_status := fnd_api.g_ret_sts_success;

727:
728: BEGIN
729:
730: fnd_msg_pub.delete_msg();
731: x_return_status := fnd_api.g_ret_sts_success;
732: FND_MSG_PUB.initialize;
733: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
734: l_media_type_name := null;
735: x_media_types := IEU_DIAG_STRING_NST();

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: -- user does not have any media queues enabled
790: if x_media_types.COUNT = 0 then
791: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_MEDIAS_ENABLED');
792: FND_MSG_PUB.Add;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: end if;
795:
796:
797: v_count := 1;

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817: null;
818: elsif (l_media_count = 0) then
819: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_MEDIA');
820: FND_MSG_PUB.Add;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: else
823: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_MORE_ENTRIES');
824: FND_MSG_PUB.Add;
825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: else
823: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_MORE_ENTRIES');
824: FND_MSG_PUB.Add;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: end if;
827:
828:
829: EXCEPTION

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

853:
854: FOR i in 1..x_msg_count LOOP
855: l_msg_data := '';
856: l_msg_count := 0;
857: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
858: x_msg_data := x_msg_data || ',' || l_msg_data;
859: END LOOP;
860:
861:

Line 864: WHEN FND_API.G_EXC_ERROR THEN

860:
861:
862: EXCEPTION
863:
864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
867:
868:

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

865:
866: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
867:
868:
869: x_return_status := FND_API.G_RET_STS_ERROR;
870:
871: x_msg_count := fnd_msg_pub.COUNT_MSG();
872:
873: FOR i in 1..x_msg_count LOOP

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

872:
873: FOR i in 1..x_msg_count LOOP
874: l_msg_data := '';
875: l_msg_count := 0;
876: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
877: x_msg_data := x_msg_data || ',' || l_msg_data;
878: END LOOP;
879:
880:

Line 881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

877: x_msg_data := x_msg_data || ',' || l_msg_data;
878: END LOOP;
879:
880:
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882:
883: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
884:
885:

Line 886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

882:
883: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
884:
885:
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887:
888: x_msg_count := fnd_msg_pub.COUNT_MSG();
889:
890: FOR i in 1..x_msg_count LOOP

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

889:
890: FOR i in 1..x_msg_count LOOP
891: l_msg_data := '';
892: l_msg_count := 0;
893: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
894: x_msg_data := x_msg_data || ',' || l_msg_data;
895: END LOOP;
896:
897:

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: WHEN OTHERS THEN
900: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
901: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
902:
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904:
905: x_msg_count := fnd_msg_pub.COUNT_MSG();
906:
907: FOR i in 1..x_msg_count LOOP

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

906:
907: FOR i in 1..x_msg_count LOOP
908: l_msg_data := '';
909: l_msg_count := 0;
910: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
911: x_msg_data := x_msg_data || ',' || l_msg_data;
912: END LOOP;
913:
914:

Line 987: x_return_status := fnd_api.g_ret_sts_success;

983:
984: BEGIN
985:
986: fnd_msg_pub.delete_msg();
987: x_return_status := fnd_api.g_ret_sts_success;
988: FND_MSG_PUB.initialize;
989: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
990: j := 0;
991: x_medias := IEU_DIAG_STRING_NST();

Line 1048: x_return_status := FND_API.G_RET_STS_ERROR;

1044: x_medias.EXTEND;
1045: x_medias(j) := l_media_types(i);
1046: --DBMS_OUTPUT.put_line('failed medias '||x_medias(j)||':)');
1047:
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: -- exit;
1050:
1051: end;
1052: end LOOP;

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: EXCEPTION
1066: WHEN NO_DATA_FOUND THEN
1067: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_SVR_GROUP');--Server group does not exist
1068: FND_MSG_PUB.Add;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: end;
1071:
1072:
1073:

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

1090:
1091: FOR i in 1..x_msg_count LOOP
1092: l_msg_data := '';
1093: l_msg_count := 0;
1094: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1095: x_msg_data := x_msg_data || ',' || l_msg_data;
1096: END LOOP;
1097:
1098:

Line 1103: WHEN FND_API.G_EXC_ERROR THEN

1099:
1100:
1101: EXCEPTION
1102:
1103: WHEN FND_API.G_EXC_ERROR THEN
1104:
1105:
1106:
1107: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR;

1103: WHEN FND_API.G_EXC_ERROR THEN
1104:
1105:
1106:
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108:
1109: x_msg_data := '';
1110:
1111: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

1112:
1113: FOR i in 1..x_msg_count LOOP
1114: l_msg_data := '';
1115: l_msg_count := 0;
1116: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1117: x_msg_data := x_msg_data || ',' || l_msg_data;
1118: END LOOP;
1119:
1120:

Line 1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1118: END LOOP;
1119:
1120:
1121:
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123:
1124:
1125:
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123:
1124:
1125:
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: x_msg_data := '';
1128:
1129: x_msg_count := fnd_msg_pub.COUNT_MSG();
1130:

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

1130:
1131: FOR i in 1..x_msg_count LOOP
1132: l_msg_data := '';
1133: l_msg_count := 0;
1134: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1135: x_msg_data := x_msg_data || ',' || l_msg_data;
1136: END LOOP;
1137:
1138:

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1140:
1141: WHEN OTHERS THEN
1142: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1143:
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145:
1146: x_msg_data := '';
1147:
1148: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

1149:
1150: FOR i in 1..x_msg_count LOOP
1151: l_msg_data := '';
1152: l_msg_count := 0;
1153: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1154: x_msg_data := x_msg_data || ',' || l_msg_data;
1155: END LOOP;
1156:
1157:

Line 1231: x_return_status := fnd_api.g_ret_sts_success;

1227:
1228: BEGIN
1229:
1230: fnd_msg_pub.delete_msg();
1231: x_return_status := fnd_api.g_ret_sts_success;
1232: FND_MSG_PUB.initialize;
1233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1234: x_valid_nodes := IEU_DIAG_VNODE_NST();
1235: i := 0;

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

1269:
1270: FOR i in 1..x_msg_count LOOP
1271: l_msg_data := '';
1272: l_msg_count := 0;
1273: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1274: x_msg_data := x_msg_data || ',' || l_msg_data;
1275: END LOOP;
1276:
1277:

Line 1282: WHEN FND_API.G_EXC_ERROR THEN

1278:
1279:
1280: EXCEPTION
1281:
1282: WHEN FND_API.G_EXC_ERROR THEN
1283:
1284: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1285:
1286:

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

1283:
1284: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1285:
1286:
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: x_msg_data := '';
1289:
1290: x_msg_count := fnd_msg_pub.COUNT_MSG();
1291:

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

1291:
1292: FOR i in 1..x_msg_count LOOP
1293: l_msg_data := '';
1294: l_msg_count := 0;
1295: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1296: x_msg_data := x_msg_data || ',' || l_msg_data;
1297: END LOOP;
1298:
1299:

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

1297: END LOOP;
1298:
1299:
1300: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1301: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1302: x_msg_data := x_msg_data || ',' || l_msg_data;
1303: END LOOP;*/
1304:
1305:

Line 1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1302: x_msg_data := x_msg_data || ',' || l_msg_data;
1303: END LOOP;*/
1304:
1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307:
1308: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1309:
1310:

Line 1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1307:
1308: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1309:
1310:
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: x_msg_data := '';
1313:
1314: x_msg_count := fnd_msg_pub.COUNT_MSG();
1315:

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

1315:
1316: FOR i in 1..x_msg_count LOOP
1317: l_msg_data := '';
1318: l_msg_count := 0;
1319: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1320: x_msg_data := x_msg_data || ',' || l_msg_data;
1321: END LOOP;
1322:
1323: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

1320: x_msg_data := x_msg_data || ',' || l_msg_data;
1321: END LOOP;
1322:
1323: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1324: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1325: x_msg_data := x_msg_data || ',' || l_msg_data;
1326: END LOOP;*/
1327:
1328: WHEN OTHERS THEN

Line 1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1328: WHEN OTHERS THEN
1329: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1330: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1331:
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333:
1334: x_msg_data := '';
1335:
1336: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

1337:
1338: FOR i in 1..x_msg_count LOOP
1339: l_msg_data := '';
1340: l_msg_count := 0;
1341: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1342: x_msg_data := x_msg_data || ',' || l_msg_data;
1343: END LOOP;
1344:
1345:

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

1343: END LOOP;
1344:
1345:
1346: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1347: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1348: x_msg_data := x_msg_data || ',' || l_msg_data;
1349: END LOOP;*/
1350:
1351: END Get_Valid_Nodes;

Line 1411: x_return_status := fnd_api.g_ret_sts_success;

1407:
1408: BEGIN
1409:
1410: fnd_msg_pub.delete_msg();
1411: x_return_status := fnd_api.g_ret_sts_success;
1412: FND_MSG_PUB.initialize;
1413: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1414: --x_valid_nodes := IEU_DIAG_VNODE_NST();
1415: x_invalid_profile_options := IEU_DIAG_VNODE_NST();

Line 1450: x_return_status := FND_API.G_RET_STS_ERROR;

1446:
1447:
1448:
1449: if not(l_profle_name is null) then
1450: x_return_status := FND_API.G_RET_STS_ERROR;
1451: i:= i+1;
1452: x_invalid_profile_options.EXTEND(1);
1453: --dbms_output.put_line('invalid profile extended');
1454: x_invalid_profile_options(x_invalid_profile_options.LAST) :=

Line 1480: x_return_status := FND_API.G_RET_STS_ERROR;

1476:
1477: if (x_invalid_profile_options.COUNT > 0) then
1478: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_PROFILE_INVALID');
1479: FND_MSG_PUB.Add;
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481:
1482: end if;
1483:
1484:

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

1491: p_data => l_msg_data
1492: );
1493:
1494: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1495: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1496: x_msg_data := x_msg_data || ',' || l_msg_data;
1497: END LOOP;*/
1498: x_msg_data := '';
1499:

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

1501:
1502: FOR i in 1..x_msg_count LOOP
1503: l_msg_data := '';
1504: l_msg_count := 0;
1505: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1506: x_msg_data := x_msg_data || ',' || l_msg_data;
1507: END LOOP;
1508:
1509:

Line 1513: WHEN FND_API.G_EXC_ERROR THEN

1509:
1510:
1511: EXCEPTION
1512:
1513: WHEN FND_API.G_EXC_ERROR THEN
1514:
1515: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1516:
1517:

Line 1518: x_return_status := FND_API.G_RET_STS_ERROR;

1514:
1515: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1516:
1517:
1518: x_return_status := FND_API.G_RET_STS_ERROR;
1519: x_msg_data := '';
1520:
1521: x_msg_count := fnd_msg_pub.COUNT_MSG();
1522:

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

1522:
1523: FOR i in 1..x_msg_count LOOP
1524: l_msg_data := '';
1525: l_msg_count := 0;
1526: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1527: x_msg_data := x_msg_data || ',' || l_msg_data;
1528: END LOOP;
1529:
1530: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

1527: x_msg_data := x_msg_data || ',' || l_msg_data;
1528: END LOOP;
1529:
1530: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1531: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1532: x_msg_data := x_msg_data || ',' || l_msg_data;
1533: END LOOP;*/
1534:
1535:

Line 1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1532: x_msg_data := x_msg_data || ',' || l_msg_data;
1533: END LOOP;*/
1534:
1535:
1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1537:
1538: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1539:
1540:

Line 1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1537:
1538: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1539:
1540:
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542: x_msg_data := '';
1543:
1544: x_msg_count := fnd_msg_pub.COUNT_MSG();
1545:

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

1545:
1546: FOR i in 1..x_msg_count LOOP
1547: l_msg_data := '';
1548: l_msg_count := 0;
1549: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1550: x_msg_data := x_msg_data || ',' || l_msg_data;
1551: END LOOP;
1552:
1553: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

1550: x_msg_data := x_msg_data || ',' || l_msg_data;
1551: END LOOP;
1552:
1553: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1554: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1555: x_msg_data := x_msg_data || ',' || l_msg_data;
1556: END LOOP;*/
1557:
1558: WHEN OTHERS THEN

Line 1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1558: WHEN OTHERS THEN
1559: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1560: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1561:
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563:
1564: x_msg_data := '';
1565:
1566: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

1567:
1568: FOR i in 1..x_msg_count LOOP
1569: l_msg_data := '';
1570: l_msg_count := 0;
1571: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1572: x_msg_data := x_msg_data || ',' || l_msg_data;
1573: END LOOP;
1574:
1575:

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

1573: END LOOP;
1574:
1575:
1576: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1577: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1578: x_msg_data := x_msg_data || ',' || l_msg_data;
1579: END LOOP;*/
1580:
1581:

Line 1734: x_return_status := fnd_api.g_ret_sts_success;

1730:
1731: BEGIN
1732:
1733: fnd_msg_pub.delete_msg();
1734: x_return_status := fnd_api.g_ret_sts_success;
1735: FND_MSG_PUB.initialize;
1736: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1737: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1738: x_dupli_proc := IEU_DIAG_ENUM_NST();

Line 1839: x_return_status := FND_API.G_RET_STS_ERROR;

1835:
1836: --DBMS_OUTPUT.put_line('count of duplicate enum_proc-->'||l_count);
1837:
1838: if not(l_count is null) and (l_count > 1) then
1839: x_return_status := FND_API.G_RET_STS_ERROR;
1840: --dbms_output.put_line('there are duplicate records with the same enum_proc');
1841:
1842: FOR c_temp in c_dproc(c_rec.sel_enum_id, c_rec.application_id, c_rec.work_q_label_lu_type, c_rec.work_q_label_lu_code) LOOP
1843: --dbms_output.put_line('in the for loop of duplicate row cursor');

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

1872:
1873:
1874:
1875: if not(l_temp_count is null) and (l_temp_count <= 0) then
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877:
1878: FOR c_temp2 in c_dproc(c_rec.sel_enum_id, c_rec.application_id, c_rec.work_q_label_lu_type, c_rec.work_q_label_lu_code)
1879: LOOP
1880: --dbms_output.put_line('in the for loop');

Line 1970: x_return_status := FND_API.G_RET_STS_ERROR;

1966: l_savepoint_valid := 1;
1967:
1968: EXCEPTION
1969: WHEN others then
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971:
1972: --dbms_output.put_line('sqlerr : ' ||sqlerrm || ' end err msg');
1973: FOR c_temp3 in c_dproc(c_rec.sel_enum_id, c_rec.application_id, c_rec.work_q_label_lu_type, c_rec.work_q_label_lu_code)
1974: LOOP

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

2097: p_data => l_msg_data
2098: );
2099:
2100: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2101: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2102: x_msg_data := x_msg_data || ',' || l_msg_data;
2103: END LOOP;*/
2104: -- x_msg_data := '';
2105:

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

2107:
2108: FOR i in 1..x_msg_count LOOP
2109: l_msg_data := '';
2110: l_msg_count := 0;
2111: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2112: x_msg_data := x_msg_data || ',' || l_msg_data;
2113: END LOOP;
2114:
2115: temp2 := DBMS_UTILITY.GET_TIME;

Line 2125: WHEN FND_API.G_EXC_ERROR THEN

2121:
2122:
2123: EXCEPTION
2124:
2125: WHEN FND_API.G_EXC_ERROR THEN
2126:
2127: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2128:
2129:

Line 2130: x_return_status := FND_API.G_RET_STS_ERROR;

2126:
2127: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2128:
2129:
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: -- x_msg_data := '';
2132:
2133: x_msg_count := fnd_msg_pub.COUNT_MSG();
2134:

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

2134:
2135: FOR i in 1..x_msg_count LOOP
2136: l_msg_data := '';
2137: l_msg_count := 0;
2138: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2139: x_msg_data := x_msg_data || ',' || l_msg_data;
2140: END LOOP;
2141:
2142:

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

2140: END LOOP;
2141:
2142:
2143: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2144: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2145: x_msg_data := x_msg_data || ',' || l_msg_data;
2146: END LOOP;*/
2147:
2148:

Line 2149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2145: x_msg_data := x_msg_data || ',' || l_msg_data;
2146: END LOOP;*/
2147:
2148:
2149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2150:
2151: -- dbms_output.PUT_LINE('Error : '||sqlerrm);
2152:
2153:

Line 2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2150:
2151: -- dbms_output.PUT_LINE('Error : '||sqlerrm);
2152:
2153:
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: -- x_msg_data := '';
2156:
2157: x_msg_count := fnd_msg_pub.COUNT_MSG();
2158:

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

2158:
2159: FOR i in 1..x_msg_count LOOP
2160: l_msg_data := '';
2161: l_msg_count := 0;
2162: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2163: x_msg_data := x_msg_data || ',' || l_msg_data;
2164: END LOOP;
2165:
2166:

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

2164: END LOOP;
2165:
2166:
2167: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2168: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2169: x_msg_data := x_msg_data || ',' || l_msg_data;
2170: END LOOP;*/
2171:
2172: WHEN OTHERS THEN

Line 2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2172: WHEN OTHERS THEN
2173: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
2174: -- dbms_output.PUT_LINE('Error : '||sqlerrm);
2175:
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177:
2178: -- x_msg_data := '';
2179:
2180: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

2181:
2182: FOR i in 1..x_msg_count LOOP
2183: l_msg_data := '';
2184: l_msg_count := 0;
2185: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2186: x_msg_data := x_msg_data || ',' || l_msg_data;
2187: END LOOP;
2188:
2189:

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

2187: END LOOP;
2188:
2189:
2190: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2191: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2192: x_msg_data := x_msg_data || ',' || l_msg_data;
2193: END LOOP;*/
2194:
2195:

Line 2262: x_return_status := fnd_api.g_ret_sts_success;

2258:
2259:
2260: BEGIN
2261: fnd_msg_pub.delete_msg();
2262: x_return_status := fnd_api.g_ret_sts_success;
2263: FND_MSG_PUB.initialize;
2264: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2265: x_valid_nodes := IEU_DIAG_NODE_NST();
2266:

Line 2302: x_return_status := FND_API.G_RET_STS_ERROR;

2298: WHEN NO_DATA_FOUND THEN
2299: --dbms_output.PUT_LINE('resource id does not exists ');
2300: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESOURCEID');-- Resource ID does not exist
2301: FND_MSG_PUB.Add;
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: --dbms_output.PUT_LINE('No data found for resource id : ');
2304: END;
2305:
2306: end if;

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

2315: p_data => l_msg_data
2316: );
2317:
2318: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2319: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2320: x_msg_data := x_msg_data || ',' || l_msg_data;
2321: END LOOP;*/
2322: x_msg_data := '';
2323:

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

2325:
2326: FOR i in 1..x_msg_count LOOP
2327: l_msg_data := '';
2328: l_msg_count := 0;
2329: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2330: x_msg_data := x_msg_data || ',' || l_msg_data;
2331: END LOOP;
2332:
2333:

Line 2336: WHEN FND_API.G_EXC_ERROR THEN

2332:
2333:
2334: EXCEPTION
2335:
2336: WHEN FND_API.G_EXC_ERROR THEN
2337:
2338: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2339:
2340:

Line 2341: x_return_status := FND_API.G_RET_STS_ERROR;

2337:
2338: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2339:
2340:
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342: x_msg_data := '';
2343:
2344: x_msg_count := fnd_msg_pub.COUNT_MSG();
2345:

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

2345:
2346: FOR i in 1..x_msg_count LOOP
2347: l_msg_data := '';
2348: l_msg_count := 0;
2349: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2350: x_msg_data := x_msg_data || ',' || l_msg_data;
2351: END LOOP;
2352:
2353:

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

2351: END LOOP;
2352:
2353:
2354: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2355: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2356: x_msg_data := x_msg_data || ',' || l_msg_data;
2357: END LOOP;*/
2358:
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2355: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2356: x_msg_data := x_msg_data || ',' || l_msg_data;
2357: END LOOP;*/
2358:
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360:
2361: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2362:
2363:

Line 2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2360:
2361: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2362:
2363:
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: x_msg_data := '';
2366:
2367: x_msg_count := fnd_msg_pub.COUNT_MSG();
2368:

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

2368:
2369: FOR i in 1..x_msg_count LOOP
2370: l_msg_data := '';
2371: l_msg_count := 0;
2372: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2373: x_msg_data := x_msg_data || ',' || l_msg_data;
2374: END LOOP;
2375:
2376: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

2373: x_msg_data := x_msg_data || ',' || l_msg_data;
2374: END LOOP;
2375:
2376: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2377: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2378: x_msg_data := x_msg_data || ',' || l_msg_data;
2379: END LOOP;*/
2380:
2381:

Line 2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2382: WHEN OTHERS THEN
2383: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
2384: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2385:
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387:
2388: x_msg_data := '';
2389:
2390: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

2391:
2392: FOR i in 1..x_msg_count LOOP
2393: l_msg_data := '';
2394: l_msg_count := 0;
2395: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2396: x_msg_data := x_msg_data || ',' || l_msg_data;
2397: END LOOP;
2398:
2399:

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

2397: END LOOP;
2398:
2399:
2400: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2401: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2402: x_msg_data := x_msg_data || ',' || l_msg_data;
2403: END LOOP;*/
2404:
2405: END Get_Valid_RT_Nodes;

Line 2601: x_return_status := fnd_api.g_ret_sts_success;

2597: l_enum_time IEU_DIAG_ENUM_TIME_NST;
2598:
2599: BEGIN
2600: fnd_msg_pub.delete_msg();
2601: x_return_status := fnd_api.g_ret_sts_success;
2602: FND_MSG_PUB.initialize;
2603: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2604: x_invalid_pkg := IEU_DIAG_REFRESH_NST();
2605: x_invalid_rproc := IEU_DIAG_REFRESH_ERR_NST();

Line 2715: x_return_status := FND_API.G_RET_STS_ERROR;

2711: end;
2712: END LOOP;
2713:
2714: if (x_invalid_pkg IS NOT NULL and x_invalid_pkg.count > 0 ) then
2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: refresh_status := 'F';--Failed
2717: end if;
2718:
2719:

Line 2744: x_return_status := FND_API.G_RET_STS_ERROR;

2740: and tl.language = l_language;
2741:
2742:
2743: if (l_temp_view_count <> 1) then
2744: x_return_status := FND_API.G_RET_STS_ERROR;
2745:
2746: i:= i+1;
2747: x_invalid_pkg.EXTEND();
2748: --DBMS_OUTPUT.put_line('invalid pkg extended for view');

Line 2801: x_return_status := FND_API.G_RET_STS_ERROR;

2797: /* insert into g_temp (G) values (l_time_spent);
2798: commit;*/
2799:
2800: IF l_invalid_rproc.count > 0 THEN
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: FOR i IN l_invalid_rproc.first..l_invalid_rproc.last LOOP
2803: IF l_invalid_rproc.exists(i) THEN
2804: x_invalid_rproc.EXTEND();
2805: x_invalid_rproc(x_invalid_rproc.last) := l_invalid_rproc(i);

Line 2812: x_return_status := FND_API.G_RET_STS_ERROR;

2808: END LOOP;
2809: END IF;
2810:
2811: /* if (x_invalid_rproc IS NOT NULL) then
2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: loop
2814:
2815: if x_invalid_rproc.EXISTS(i) then
2816: --dbms_output.put_line('count: -->'|| i);

Line 2861: x_return_status := FND_API.G_RET_STS_ERROR;

2857: and tl.application_id = s.application_id
2858: and tl.language = l_language;
2859:
2860: if (l_temp_view_count <> 1) then
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: i:= i+1;
2863: x_invalid_pkg.EXTEND();
2864: --DBMS_OUTPUT.put_line('invalid pkg extended');
2865: refresh_status := 'F';--Failed

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

2888: l_rtotal_time := l_rtotal_time + l_time_spent;
2889: --DBMS_OUTPUT.put_line('total***-- '||l_rtotal_time);
2890:
2891: IF l_invalid_rproc.count > 0 THEN
2892: x_return_status := FND_API.G_RET_STS_ERROR;--
2893: refresh_status := 'F';--Failed
2894: --DBMS_OUTPUT.put_line('failed');
2895: END IF;
2896: --DBMS_OUTPUT.put_line('put refresh time in nst');

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

2911: /* insert into g_temp (G) values (l_time_spent);
2912: commit;*/
2913:
2914: IF l_invalid_rproc.count > 0 THEN
2915: x_return_status := FND_API.G_RET_STS_ERROR;--
2916: FOR i IN l_invalid_rproc.first..l_invalid_rproc.last LOOP
2917: IF l_invalid_rproc.exists(i) THEN
2918: x_invalid_rproc.EXTEND();
2919: refresh_status := 'F';--Failed

Line 2931: x_return_status := FND_API.G_RET_STS_ERROR;

2927: /* --x_invalid_rproc.EXTEND();
2928: x_invalid_rproc := l_invalid_rproc;
2929: --x_return_status := l_return_status;*/
2930: if (x_invalid_rproc IS NOT NULL and x_invalid_rproc.count > 0) then
2931: x_return_status := FND_API.G_RET_STS_ERROR;
2932: refresh_status := 'F';--Failed
2933: end if;
2934:
2935: end if;

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

2950: p_data => l_msg_data
2951: );
2952:
2953: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2954: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2955: x_msg_data := x_msg_data || ',' || l_msg_data;
2956: END LOOP;*/
2957: -- x_msg_data := '';
2958:

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

2960:
2961: FOR i in 1..x_msg_count LOOP
2962: l_msg_data := '';
2963: l_msg_count := 0;
2964: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2965: x_msg_data := x_msg_data || ',' || l_msg_data;
2966: END LOOP;
2967:
2968: x_rtime_total := l_rtotal_time;

Line 2972: WHEN FND_API.G_EXC_ERROR THEN

2968: x_rtime_total := l_rtotal_time;
2969: --DBMS_OUTPUT.put_line('refresh time'||x_rtime_total);
2970: EXCEPTION
2971:
2972: WHEN FND_API.G_EXC_ERROR THEN
2973:
2974: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2975: x_return_status := FND_API.G_RET_STS_ERROR;
2976: -- x_msg_data := '';

Line 2975: x_return_status := FND_API.G_RET_STS_ERROR;

2971:
2972: WHEN FND_API.G_EXC_ERROR THEN
2973:
2974: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2975: x_return_status := FND_API.G_RET_STS_ERROR;
2976: -- x_msg_data := '';
2977: x_msg_count := fnd_msg_pub.COUNT_MSG();
2978:
2979: FOR i in 1..x_msg_count LOOP

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

2978:
2979: FOR i in 1..x_msg_count LOOP
2980: l_msg_data := '';
2981: l_msg_count := 0;
2982: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2983: x_msg_data := x_msg_data || ',' || l_msg_data;
2984: END LOOP;
2985:
2986:

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

2984: END LOOP;
2985:
2986:
2987: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
2988: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
2989: x_msg_data := x_msg_data || ',' || l_msg_data;
2990: END LOOP;*/
2991:
2992:

Line 2993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2989: x_msg_data := x_msg_data || ',' || l_msg_data;
2990: END LOOP;*/
2991:
2992:
2993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2994:
2995: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2996:
2997:

Line 2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2994:
2995: --dbms_output.PUT_LINE('Error : '||sqlerrm);
2996:
2997:
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999: -- x_msg_data := '';
3000:
3001: x_msg_count := fnd_msg_pub.COUNT_MSG();
3002:

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

3002:
3003: FOR i in 1..x_msg_count LOOP
3004: l_msg_data := '';
3005: l_msg_count := 0;
3006: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3007: x_msg_data := x_msg_data || ',' || l_msg_data;
3008: END LOOP;
3009:
3010: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

3007: x_msg_data := x_msg_data || ',' || l_msg_data;
3008: END LOOP;
3009:
3010: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3011: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3012: x_msg_data := x_msg_data || ',' || l_msg_data;
3013: END LOOP;*/
3014:
3015:

Line 3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3016: WHEN OTHERS THEN
3017: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
3018: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3019:
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021:
3022: -- x_msg_data := '';
3023:
3024: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

3025:
3026: FOR i in 1..x_msg_count LOOP
3027: l_msg_data := '';
3028: l_msg_count := 0;
3029: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3030: x_msg_data := x_msg_data || ',' || l_msg_data;
3031: END LOOP;
3032:
3033: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

3030: x_msg_data := x_msg_data || ',' || l_msg_data;
3031: END LOOP;
3032:
3033: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3034: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3035: x_msg_data := x_msg_data || ',' || l_msg_data;
3036: END LOOP;*/
3037:
3038: END Check_Refresh_Node_Counts;

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

3224: null;
3225: when others then
3226: --valid_rproc := false;
3227:
3228: --x_return_status := FND_API.G_RET_STS_ERROR;
3229: --dbms_output.put_line('exception raised while calling refresh');
3230: x_invalid_rproc.EXTEND();
3231: --dbms_output.put_line('invalid rproc extended');
3232:

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

3423: (nodes.sel_rt_node_id = p_sel_rt_node_id) AND
3424: (nodes.resource_id = p_resource_id);
3425:
3426: -- if NOT(valid_rproc)then
3427: -- x_return_status := FND_API.G_RET_STS_ERROR;
3428: -- end if;
3429:
3430: --dbms_output.put_line('return status in refresh_node' || x_return_status);
3431:

Line 3508: x_return_status := fnd_api.g_ret_sts_success;

3504: l_temp_view VARCHAR2(512) ;
3505:
3506: BEGIN
3507: fnd_msg_pub.delete_msg();
3508: x_return_status := fnd_api.g_ret_sts_success;
3509: FND_MSG_PUB.initialize;
3510: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3511: x_invalid_views := IEU_DIAG_STRING_NST();
3512:

Line 3540: x_return_status := FND_API.G_RET_STS_ERROR;

3536: and status = 'VALID' and owner = 'APPS';
3537:
3538: if l_count <> 1 then
3539:
3540: x_return_status := FND_API.G_RET_STS_ERROR;
3541: i := i+1;
3542: x_invalid_views.EXTEND;
3543: x_invalid_views(i) := cur_rec.view_name;
3544: end if;

Line 3560: x_return_status := FND_API.G_RET_STS_ERROR;

3556: WHEN NO_DATA_FOUND THEN
3557: --dbms_output.PUT_LINE('resource id does not exists ');
3558: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_RESOURCEID');-- Resource ID does not exist
3559: FND_MSG_PUB.Add;
3560: x_return_status := FND_API.G_RET_STS_ERROR;
3561: --dbms_output.PUT_LINE('No data found for resource id : ');
3562: END;
3563:
3564: end if;

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

3570: p_data => l_msg_data
3571: );
3572:
3573: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3574: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3575: x_msg_data := x_msg_data || ',' || l_msg_data;
3576: END LOOP;*/
3577:
3578: x_msg_data := '';

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

3581:
3582: FOR i in 1..x_msg_count LOOP
3583: l_msg_data := '';
3584: l_msg_count := 0;
3585: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3586: x_msg_data := x_msg_data || ',' || l_msg_data;
3587: END LOOP;
3588:
3589:

Line 3592: WHEN FND_API.G_EXC_ERROR THEN

3588:
3589:
3590: EXCEPTION
3591:
3592: WHEN FND_API.G_EXC_ERROR THEN
3593:
3594: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3595:
3596:

Line 3597: x_return_status := FND_API.G_RET_STS_ERROR;

3593:
3594: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3595:
3596:
3597: x_return_status := FND_API.G_RET_STS_ERROR;
3598: FND_MSG_PUB.Count_And_Get(
3599: p_count => x_msg_count,
3600: p_data => l_msg_data
3601: );

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

3601: );
3602:
3603:
3604: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3605: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3606: x_msg_data := x_msg_data || ',' || l_msg_data;
3607: END LOOP;*/
3608:
3609:

Line 3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3606: x_msg_data := x_msg_data || ',' || l_msg_data;
3607: END LOOP;*/
3608:
3609:
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611:
3612: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3613:
3614:

Line 3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3611:
3612: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3613:
3614:
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: x_msg_data := '';
3617:
3618: x_msg_count := fnd_msg_pub.COUNT_MSG();
3619:

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

3619:
3620: FOR i in 1..x_msg_count LOOP
3621: l_msg_data := '';
3622: l_msg_count := 0;
3623: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3624: x_msg_data := x_msg_data || ',' || l_msg_data;
3625: END LOOP;
3626:
3627:

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

3625: END LOOP;
3626:
3627:
3628: /*FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3629: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3630: x_msg_data := x_msg_data || ',' || l_msg_data;
3631: END LOOP;*/
3632:
3633: WHEN OTHERS THEN

Line 3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3633: WHEN OTHERS THEN
3634: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
3635: --dbms_output.PUT_LINE('Error : '||sqlerrm);
3636:
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638:
3639: x_msg_data := '';
3640:
3641: x_msg_count := fnd_msg_pub.COUNT_MSG();

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

3642:
3643: FOR i in 1..x_msg_count LOOP
3644: l_msg_data := '';
3645: l_msg_count := 0;
3646: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3647: x_msg_data := x_msg_data || ',' || l_msg_data;
3648: END LOOP;
3649:
3650:

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

3648: END LOOP;
3649:
3650:
3651: /* FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3652: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3653: x_msg_data := x_msg_data || ',' || l_msg_data;
3654: END LOOP;*/
3655:
3656:

Line 3691: x_return_status := fnd_api.g_ret_sts_success;

3687: l_count NUMBER;
3688: l_application_name VARCHAR2(2000);
3689:
3690: begin
3691: x_return_status := fnd_api.g_ret_sts_success;
3692: -- 1. get object_function from jtf_objects_vl and call FND_FUNCTION.TEST
3693: -- 2. if FND_FUNCTION.TEST run successfully, show successful message with function name, application name
3694: -- 3. if FND_FUNCITON.TEST run failed,
3695: -- 3.1 if object_code is 'TASK', test 'Launch TASK Manager',

Line 3732: x_return_status := FND_API.G_RET_STS_ERROR;

3728: x_log.extend;
3729: x_log(x_log.last) := FND_MESSAGE.GET();
3730: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_NULL_OBJ_FUNC');
3731: FND_MSG_PUB.Add;
3732: x_return_status := FND_API.G_RET_STS_ERROR;
3733:
3734:
3735: ELSe
3736: -- call FND_FUNCTION.TEST with this l_object_function

Line 3765: x_return_status := FND_API.G_RET_STS_ERROR;

3761: x_log.extend;
3762: x_log(x_log.last) := FND_MESSAGE.GET();
3763: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_OBJ_FUN_Y_FAIL');
3764: FND_MSG_PUB.Add;
3765: x_return_status := FND_API.G_RET_STS_ERROR;
3766:
3767: END if; -- test for launch Task Manager
3768: ELSE -- not a TASK object code
3769: -- show error message, IEU_UWQ_ALL_NO_SOURCE_DOC

Line 3772: x_return_status := FND_API.G_RET_STS_ERROR;

3768: ELSE -- not a TASK object code
3769: -- show error message, IEU_UWQ_ALL_NO_SOURCE_DOC
3770: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_OBJ_FUN_N_FAIL');
3771: FND_MSG_PUB.Add;
3772: x_return_status := FND_API.G_RET_STS_ERROR;
3773:
3774: END if; -- object_code = 'TASK'
3775: END IF; -- if FND_FUNCTION.TEST
3776: END if; -- if object function is null

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

3785: p_data => l_msg_data
3786: );
3787:
3788: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3789: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3790: x_msg_data := x_msg_data || ',' || l_msg_data;
3791: END LOOP;
3792:
3793: EXCEPTION

Line 3795: WHEN FND_API.G_EXC_ERROR THEN

3791: END LOOP;
3792:
3793: EXCEPTION
3794:
3795: WHEN FND_API.G_EXC_ERROR THEN
3796:
3797: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
3798:
3799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3799: x_return_status := FND_API.G_RET_STS_ERROR;

3795: WHEN FND_API.G_EXC_ERROR THEN
3796:
3797: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
3798:
3799: x_return_status := FND_API.G_RET_STS_ERROR;
3800: FND_MSG_PUB.Count_And_Get(
3801: p_count => x_msg_count,
3802: p_data => l_msg_data
3803: );

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

3803: );
3804:
3805:
3806: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3807: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3808: x_msg_data := x_msg_data || ',' || l_msg_data;
3809: END LOOP;
3810:
3811:

Line 3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3808: x_msg_data := x_msg_data || ',' || l_msg_data;
3809: END LOOP;
3810:
3811:
3812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3813:
3814: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
3815:
3816:

Line 3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3813:
3814: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
3815:
3816:
3817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3818: FND_MSG_PUB.Count_And_Get
3819: (
3820: p_count => x_msg_count,
3821: p_data => l_msg_data

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

3821: p_data => l_msg_data
3822: );
3823:
3824: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3825: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3826: x_msg_data := x_msg_data || ',' || l_msg_data;
3827: END LOOP;
3828:
3829:

Line 3834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3830: WHEN OTHERS THEN
3831: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
3832: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
3833:
3834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3835:
3836: FND_MSG_PUB.Count_And_Get (
3837: p_count => x_msg_count,
3838: p_data => l_msg_data

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

3838: p_data => l_msg_data
3839: );
3840:
3841: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
3842: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
3843: x_msg_data := x_msg_data || ',' || l_msg_data;
3844: END LOOP;
3845:
3846: end CHECK_OBJECT_FUNCTION;

Line 3931: x_return_status := fnd_api.g_ret_sts_success;

3927: l_string1 := 'RS_INDIVIDUAL';
3928: l_string2 := 'RS_EMPLOYEE';
3929: l_string3 := 'RS_GROUP';
3930: fnd_msg_pub.delete_msg();
3931: x_return_status := fnd_api.g_ret_sts_success;
3932: FND_MSG_PUB.initialize;
3933: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3934: x_problem_tasks := IEU_DIAG_STRING_NST();
3935: x_log := IEU_DIAG_STRING_NST();

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

4014: p_data => l_msg_data
4015: );
4016:
4017: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
4018: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
4019: x_msg_data := x_msg_data || ',' || l_msg_data;
4020: END LOOP;
4021:
4022: EXCEPTION

Line 4024: WHEN FND_API.G_EXC_ERROR THEN

4020: END LOOP;
4021:
4022: EXCEPTION
4023:
4024: WHEN FND_API.G_EXC_ERROR THEN
4025:
4026: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
4027:
4028: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4028: x_return_status := FND_API.G_RET_STS_ERROR;

4024: WHEN FND_API.G_EXC_ERROR THEN
4025:
4026: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
4027:
4028: x_return_status := FND_API.G_RET_STS_ERROR;
4029: FND_MSG_PUB.Count_And_Get(
4030: p_count => x_msg_count,
4031: p_data => l_msg_data
4032: );

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

4032: );
4033:
4034:
4035: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
4036: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
4037: x_msg_data := x_msg_data || ',' || l_msg_data;
4038: END LOOP;
4039:
4040:

Line 4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4037: x_msg_data := x_msg_data || ',' || l_msg_data;
4038: END LOOP;
4039:
4040:
4041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4042:
4043: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
4044:
4045:

Line 4046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4042:
4043: --DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
4044:
4045:
4046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4047: FND_MSG_PUB.Count_And_Get
4048: (
4049: p_count => x_msg_count,
4050: p_data => l_msg_data

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

4050: p_data => l_msg_data
4051: );
4052:
4053: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
4054: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
4055: x_msg_data := x_msg_data || ',' || l_msg_data;
4056: END LOOP;
4057:
4058:

Line 4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4059: WHEN OTHERS THEN
4060: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
4061: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
4062:
4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4064:
4065: FND_MSG_PUB.Count_And_Get (
4066: p_count => x_msg_count,
4067: p_data => l_msg_data

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

4067: p_data => l_msg_data
4068: );
4069:
4070: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
4071: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
4072: x_msg_data := x_msg_data || ',' || l_msg_data;
4073: END LOOP;
4074:
4075: end CHECK_TASK_LAUNCHING;