54:
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 := '';
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:
64:
63:
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:
81:
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:
104: EXCEPTION
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;
112: end;
113: end if;
114:
115: -- Standard call to get message count and if count is 1, get message info.
116: /*FND_MSG_PUB.Count_And_Get(
117: p_count => x_msg_count,
118: p_data => l_msg_data
119: );*/
120:
118: p_data => l_msg_data
119: );*/
120:
121:
122: x_msg_count := fnd_msg_pub.COUNT_MSG();
123:
124: FOR i in 1..x_msg_count LOOP
125: l_msg_data := '';
126: l_msg_count := 0;
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:
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
143: l_msg_data := '';
144: l_msg_count := 0;
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:
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 := '';
160: l_msg_count := 0;
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
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 := '';
173: l_msg_count := 0;
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:
233:
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 := '';
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:
243:
243:
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
265:
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;
277:
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
332: EXCEPTION
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;
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;
342:
343: end;
344:
354: x_appl_id := FND_GLOBAL.RESP_APPL_ID;
355:
356:
357: -- Standard call to get message count and if count is 1, get message info.
358: /* FND_MSG_PUB.Count_And_Get(
359: p_count => x_msg_count,
360: p_data => l_msg_data
361: );*/
362:
360: p_data => l_msg_data
361: );*/
362:
363:
364: x_msg_count := fnd_msg_pub.COUNT_MSG();
365:
366: FOR i in 1..x_msg_count LOOP
367: l_msg_data := '';
368: l_msg_count := 0;
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:
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 := '';
388: l_msg_count := 0;
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:
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 := '';
405: l_msg_count := 0;
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:
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 := '';
420: l_msg_count := 0;
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:
475:
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 := '';
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:
485: begin
490: USING in p_object_code;
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
497: END if;
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;
508:
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
560: EXCEPTION
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;
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;
570:
571: end;
572:
582:
583:
584:
585: -- Standard call to get message count and if count is 1, get message info.
586: /* FND_MSG_PUB.Count_And_Get(
587: p_count => x_msg_count,
588: p_data => l_msg_data
589: );*/
590:
588: p_data => l_msg_data
589: );*/
590:
591:
592: x_msg_count := fnd_msg_pub.COUNT_MSG();
593:
594: FOR i in 1..x_msg_count LOOP
595: l_msg_data := '';
596: l_msg_count := 0;
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:
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 := '';
616: l_msg_count := 0;
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:
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 := '';
633: l_msg_count := 0;
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:
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 := '';
648: l_msg_count := 0;
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:
726:
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;
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();
736: l_media_count := 0;
788:
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:
816: if (l_media_count = 1) then
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;
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;
826: end if;
827:
828:
842:
843: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
844:
845: -- Standard call to get message count and if count is 1, get message info.
846: /*FND_MSG_PUB.Count_And_Get(
847: p_count => x_msg_count,
848: p_data => x_msg_data --x_msg_data --l_msg_data
849: );*/
850: x_msg_data := '';
848: p_data => x_msg_data --x_msg_data --l_msg_data
849: );*/
850: x_msg_data := '';
851:
852: x_msg_count := fnd_msg_pub.COUNT_MSG();
853:
854: FOR i in 1..x_msg_count LOOP
855: l_msg_data := '';
856: l_msg_count := 0;
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:
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
874: l_msg_data := '';
875: l_msg_count := 0;
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:
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
891: l_msg_data := '';
892: l_msg_count := 0;
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:
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
908: l_msg_data := '';
909: l_msg_count := 0;
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:
982:
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;
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();
992:
1038:
1039: EXCEPTION
1040: WHEN NO_DATA_FOUND then
1041: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_NO_SVRS');
1042: FND_MSG_PUB.Add;
1043: j:=j+1;
1044: x_medias.EXTEND;
1045: x_medias(j) := l_media_types(i);
1046: --DBMS_OUTPUT.put_line('failed medias '||x_medias(j)||':)');
1064:
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:
1078:
1079:
1080:
1081: -- Standard call to get message count and if count is 1, get message info.
1082: /*FND_MSG_PUB.Count_And_Get(
1083: p_count => x_msg_count,
1084: p_data => l_msg_data
1085: );*/
1086:
1085: );*/
1086:
1087: x_msg_data := '';
1088:
1089: x_msg_count := fnd_msg_pub.COUNT_MSG();
1090:
1091: FOR i in 1..x_msg_count LOOP
1092: l_msg_data := '';
1093: l_msg_count := 0;
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:
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();
1112:
1113: FOR i in 1..x_msg_count LOOP
1114: l_msg_data := '';
1115: l_msg_count := 0;
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:
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:
1131: FOR i in 1..x_msg_count LOOP
1132: l_msg_data := '';
1133: l_msg_count := 0;
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:
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();
1149:
1150: FOR i in 1..x_msg_count LOOP
1151: l_msg_data := '';
1152: l_msg_count := 0;
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:
1226: i integer ;
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();
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;
1236: Check_User_Resp (x_return_status, x_msg_count, x_msg_data,
1257: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
1258:
1259:
1260: -- Standard call to get message count and if count is 1, get message info.
1261: /* FND_MSG_PUB.Count_And_Get(
1262: p_count => x_msg_count,
1263: p_data => l_msg_data
1264: );*/
1265:
1264: );*/
1265:
1266: x_msg_data := '';
1267:
1268: x_msg_count := fnd_msg_pub.COUNT_MSG();
1269:
1270: FOR i in 1..x_msg_count LOOP
1271: l_msg_data := '';
1272: l_msg_count := 0;
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:
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:
1292: FOR i in 1..x_msg_count LOOP
1293: l_msg_data := '';
1294: l_msg_count := 0;
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:
1296: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
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:
1316: FOR i in 1..x_msg_count LOOP
1317: l_msg_data := '';
1318: l_msg_count := 0;
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
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
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:
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
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();
1337:
1338: FOR i in 1..x_msg_count LOOP
1339: l_msg_data := '';
1340: l_msg_count := 0;
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:
1342: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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;
1406:
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();
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();
1416: l_profle_name := null;
1475: end if;
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:
1485: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
1486:
1487:
1488: -- Standard call to get message count and if count is 1, get message info.
1489: /*FND_MSG_PUB.Count_And_Get(
1490: p_count => x_msg_count,
1491: p_data => l_msg_data
1492: );
1493:
1490: p_count => x_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 := '';
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:
1496: x_msg_data := x_msg_data || ',' || l_msg_data;
1497: END LOOP;*/
1498: x_msg_data := '';
1499:
1500: x_msg_count := fnd_msg_pub.COUNT_MSG();
1501:
1502: FOR i in 1..x_msg_count LOOP
1503: l_msg_data := '';
1504: l_msg_count := 0;
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:
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:
1523: FOR i in 1..x_msg_count LOOP
1524: l_msg_data := '';
1525: l_msg_count := 0;
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
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
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:
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:
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:
1546: FOR i in 1..x_msg_count LOOP
1547: l_msg_data := '';
1548: l_msg_count := 0;
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
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
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:
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
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();
1567:
1568: FOR i in 1..x_msg_count LOOP
1569: l_msg_data := '';
1570: l_msg_count := 0;
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:
1572: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
1729:
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;
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();
1739: x_invalid_pkg := IEU_DIAG_ENUM_NST();
2091: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
2092:
2093:
2094: -- Standard call to get message count and if count is 1, get message info.
2095: /*FND_MSG_PUB.Count_And_Get(
2096: p_count => x_msg_count,
2097: p_data => l_msg_data
2098: );
2099:
2096: p_count => x_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 := '';
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:
2102: x_msg_data := x_msg_data || ',' || l_msg_data;
2103: END LOOP;*/
2104: -- x_msg_data := '';
2105:
2106: x_msg_count := fnd_msg_pub.COUNT_MSG();
2107:
2108: FOR i in 1..x_msg_count LOOP
2109: l_msg_data := '';
2110: l_msg_count := 0;
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;
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:
2135: FOR i in 1..x_msg_count LOOP
2136: l_msg_data := '';
2137: l_msg_count := 0;
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:
2139: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
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:
2159: FOR i in 1..x_msg_count LOOP
2160: l_msg_data := '';
2161: l_msg_count := 0;
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:
2163: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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
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();
2181:
2182: FOR i in 1..x_msg_count LOOP
2183: l_msg_data := '';
2184: l_msg_count := 0;
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:
2186: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
2257:
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();
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:
2267: Check_User_Resp (x_return_status, x_msg_count, x_msg_data,
2297: EXCEPTION
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:
2309: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
2310:
2311:
2312: -- Standard call to get message count and if count is 1, get message info.
2313: /*FND_MSG_PUB.Count_And_Get(
2314: p_count => x_msg_count,
2315: p_data => l_msg_data
2316: );
2317:
2314: p_count => x_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 := '';
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:
2320: x_msg_data := x_msg_data || ',' || l_msg_data;
2321: END LOOP;*/
2322: x_msg_data := '';
2323:
2324: x_msg_count := fnd_msg_pub.COUNT_MSG();
2325:
2326: FOR i in 1..x_msg_count LOOP
2327: l_msg_data := '';
2328: l_msg_count := 0;
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:
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:
2346: FOR i in 1..x_msg_count LOOP
2347: l_msg_data := '';
2348: l_msg_count := 0;
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:
2350: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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
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:
2369: FOR i in 1..x_msg_count LOOP
2370: l_msg_data := '';
2371: l_msg_count := 0;
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
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
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:
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:
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();
2391:
2392: FOR i in 1..x_msg_count LOOP
2393: l_msg_data := '';
2394: l_msg_count := 0;
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:
2396: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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;
2596: l_invalid_proc IEU_DIAG_ENUM_ERR_NST;
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();
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();
2606: l_invalid_rproc := IEU_DIAG_REFRESH_ERR_NST();
2936: END;
2937: else
2938: -- DBMS_OUTPUT.put_line('Check_Node_Enumeration...failed');
2939: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_ENUM_FAIL_FIXIT');
2940: FND_MSG_PUB.Add;
2941:
2942: end if;
2943:
2944: commit;
2944: commit;
2945:
2946: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
2947: -- Standard call to get message count and if count is 1, get message info.
2948: /*FND_MSG_PUB.Count_And_Get(
2949: p_count => x_msg_count,
2950: p_data => l_msg_data
2951: );
2952:
2949: p_count => x_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 := '';
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:
2955: x_msg_data := x_msg_data || ',' || l_msg_data;
2956: END LOOP;*/
2957: -- x_msg_data := '';
2958:
2959: x_msg_count := fnd_msg_pub.COUNT_MSG();
2960:
2961: FOR i in 1..x_msg_count LOOP
2962: l_msg_data := '';
2963: l_msg_count := 0;
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;
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
2980: l_msg_data := '';
2981: l_msg_count := 0;
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:
2983: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
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:
3003: FOR i in 1..x_msg_count LOOP
3004: l_msg_data := '';
3005: l_msg_count := 0;
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
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
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:
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:
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();
3025:
3026: FOR i in 1..x_msg_count LOOP
3027: l_msg_data := '';
3028: l_msg_count := 0;
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
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
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:
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;
3503:
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();
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:
3513: Check_User_Resp (x_return_status, x_msg_count, x_msg_data,
3555: EXCEPTION
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;
3565:
3566: fnd_global.APPS_INITIALIZE(l_user_id, l_responsibility_id, l_application_id, null);
3567: -- Standard call to get message count and if count is 1, get message info.
3568: /*FND_MSG_PUB.Count_And_Get(
3569: p_count => x_msg_count,
3570: p_data => l_msg_data
3571: );
3572:
3569: p_count => x_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:
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 := '';
3576: END LOOP;*/
3577:
3578: x_msg_data := '';
3579:
3580: x_msg_count := fnd_msg_pub.COUNT_MSG();
3581:
3582: FOR i in 1..x_msg_count LOOP
3583: l_msg_data := '';
3584: l_msg_count := 0;
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:
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: );
3602:
3600: p_data => l_msg_data
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:
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:
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:
3620: FOR i in 1..x_msg_count LOOP
3621: l_msg_data := '';
3622: l_msg_count := 0;
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:
3624: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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
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();
3642:
3643: FOR i in 1..x_msg_count LOOP
3644: l_msg_data := '';
3645: l_msg_count := 0;
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:
3647: x_msg_data := x_msg_data || ',' || l_msg_data;
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:
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:
3727: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_LOG_NULL_OBJ_F');
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
3760: FND_MESSAGE.SET_TOKEN ('APPLICATION_NAME', l_application_name);
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
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
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
3779:
3780: --DBMS_OUTPUT.Put_Line('v_numrows is '|| v_numrows);
3781: --DBMS_OUTPUT.Put_Line('l_action_code is '|| l_action_code);
3782:
3783: FND_MSG_PUB.Count_And_Get(
3784: p_count => x_msg_count,
3785: p_data => l_msg_data
3786: );
3787:
3784: p_count => x_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:
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
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: );
3804:
3802: p_data => l_msg_data
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:
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:
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
3822: );
3820: p_count => x_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:
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:
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
3839: );
3840:
3837: p_count => x_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:
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;
3926:
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();
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();
3936:
4008: end if ; -- ieu_action_object_code is not registered in ieu_uwq_nonmedia_actions
4009:
4010: end if;
4011: -- Standard call to get message count and if count is 1, get message info.
4012: FND_MSG_PUB.Count_And_Get(
4013: p_count => x_msg_count,
4014: p_data => l_msg_data
4015: );
4016:
4013: p_count => x_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:
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
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: );
4033:
4031: p_data => l_msg_data
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:
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:
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
4051: );
4049: p_count => x_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:
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:
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
4068: );
4069:
4066: p_count => x_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:
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;