60: j :=0;
61: l_tmp :=0;
62: title :='';
63: --dbms_output.put_line('begin');
64: fnd_msg_pub.delete_msg();
65: x_return_status := fnd_api.g_ret_sts_success;
66: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
67: FND_MSG_PUB.initialize;
68: x_results := IEU_DIAG_DISTRIBUTING_NST();
63: --dbms_output.put_line('begin');
64: fnd_msg_pub.delete_msg();
65: x_return_status := fnd_api.g_ret_sts_success;
66: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
67: FND_MSG_PUB.initialize;
68: x_results := IEU_DIAG_DISTRIBUTING_NST();
69: FOR cur_rec IN cur_items
70: LOOP
71: --dbms_output.put_line('in the loop of cur_rec');
162:
163: WHEN FND_API.G_EXC_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: x_msg_data := sqlerrm;
166: x_msg_count := fnd_msg_pub.COUNT_MSG();
167: FOR i in 1..x_msg_count LOOP
168: l_msg_data := '';
169: l_msg_count := 0;
170: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
166: x_msg_count := fnd_msg_pub.COUNT_MSG();
167: FOR i in 1..x_msg_count LOOP
168: l_msg_data := '';
169: l_msg_count := 0;
170: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
171: x_msg_data := x_msg_data || ',' || l_msg_data;
172: END LOOP;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: END LOOP;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: x_msg_data := sqlerrm;
176: x_msg_count := fnd_msg_pub.COUNT_MSG();
177: FOR i in 1..x_msg_count LOOP
178: l_msg_data := '';
179: l_msg_count := 0;
180: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
176: x_msg_count := fnd_msg_pub.COUNT_MSG();
177: FOR i in 1..x_msg_count LOOP
178: l_msg_data := '';
179: l_msg_count := 0;
180: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
181: x_msg_data := x_msg_data || ',' || l_msg_data;
182: END LOOP;
183:
184:
184:
185: WHEN OTHERS THEN
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187: x_msg_data := sqlerrm;
188: x_msg_count := fnd_msg_pub.COUNT_MSG();
189: FOR i in 1..x_msg_count LOOP
190: l_msg_data := '';
191: l_msg_count := 0;
192: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
188: x_msg_count := fnd_msg_pub.COUNT_MSG();
189: FOR i in 1..x_msg_count LOOP
190: l_msg_data := '';
191: l_msg_count := 0;
192: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
193: x_msg_data := x_msg_data || ',' || l_msg_data;
194: END LOOP;
195:
196: end getUnDis;
258: l_count :=0;
259: j :=0;
260: l_tmp :=0;
261: --dbms_output.put_line('begin');
262: fnd_msg_pub.delete_msg();
263: x_return_status := fnd_api.g_ret_sts_success;
264: --x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
265: x_msg_data := '';
266: FND_MSG_PUB.initialize;
262: fnd_msg_pub.delete_msg();
263: x_return_status := fnd_api.g_ret_sts_success;
264: --x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
265: x_msg_data := '';
266: FND_MSG_PUB.initialize;
267: x_results := IEU_DIAG_DISTRIBUTING_NST();
268:
269: begin
270:
277:
278: EXCEPTION
279: WHEN NO_DATA_FOUND THEN
280: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_USER_INVALID');
281: FND_MSG_PUB.Add;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: x_msg_count := fnd_msg_pub.COUNT_MSG();
284:
285: FOR i in 1..x_msg_count LOOP
279: WHEN NO_DATA_FOUND THEN
280: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_USER_INVALID');
281: FND_MSG_PUB.Add;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: x_msg_count := fnd_msg_pub.COUNT_MSG();
284:
285: FOR i in 1..x_msg_count LOOP
286: l_msg_data := '';
287: l_msg_count := 0;
284:
285: FOR i in 1..x_msg_count LOOP
286: l_msg_data := '';
287: l_msg_count := 0;
288: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
289: x_msg_data := x_msg_data || ',' || l_msg_data;
290: END LOOP;
291:
292: end;
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: x_msg_data := sqlerrm;
394: x_msg_count := fnd_msg_pub.COUNT_MSG();
395: FOR i in 1..x_msg_count LOOP
396: l_msg_data := '';
397: l_msg_count := 0;
398: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
394: x_msg_count := fnd_msg_pub.COUNT_MSG();
395: FOR i in 1..x_msg_count LOOP
396: l_msg_data := '';
397: l_msg_count := 0;
398: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
399: x_msg_data := x_msg_data || ',' || l_msg_data;
400: END LOOP;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: END LOOP;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: x_msg_data := sqlerrm;
404: x_msg_count := fnd_msg_pub.COUNT_MSG();
405: FOR i in 1..x_msg_count LOOP
406: l_msg_data := '';
407: l_msg_count := 0;
408: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
404: x_msg_count := fnd_msg_pub.COUNT_MSG();
405: FOR i in 1..x_msg_count LOOP
406: l_msg_data := '';
407: l_msg_count := 0;
408: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
409: x_msg_data := x_msg_data || ',' || l_msg_data;
410: END LOOP;
411:
412: WHEN OTHERS THEN
411:
412: WHEN OTHERS THEN
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: x_msg_data := sqlerrm;
415: x_msg_count := fnd_msg_pub.COUNT_MSG();
416: FOR i in 1..x_msg_count LOOP
417: l_msg_data := '';
418: l_msg_count := 0;
419: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
415: x_msg_count := fnd_msg_pub.COUNT_MSG();
416: FOR i in 1..x_msg_count LOOP
417: l_msg_data := '';
418: l_msg_count := 0;
419: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
420: x_msg_data := x_msg_data || ',' || l_msg_data;
421: END LOOP;
422:
423: end getDisSpe;
478: l_count :=0;
479: j :=0;
480: l_tmp :=0;
481: --dbms_output.put_line('begin');
482: fnd_msg_pub.delete_msg();
483: x_return_status := fnd_api.g_ret_sts_success;
484: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
485: FND_MSG_PUB.initialize;
486: x_results := IEU_DIAG_REQUEUED_NST();
481: --dbms_output.put_line('begin');
482: fnd_msg_pub.delete_msg();
483: x_return_status := fnd_api.g_ret_sts_success;
484: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
485: FND_MSG_PUB.initialize;
486: x_results := IEU_DIAG_REQUEUED_NST();
487:
488: FOR cur_rec IN cur_items
489: LOOP
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: x_msg_data := sqlerrm;
622: x_msg_count := fnd_msg_pub.COUNT_MSG();
623: FOR i in 1..x_msg_count LOOP
624: l_msg_data := '';
625: l_msg_count := 0;
626: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
622: x_msg_count := fnd_msg_pub.COUNT_MSG();
623: FOR i in 1..x_msg_count LOOP
624: l_msg_data := '';
625: l_msg_count := 0;
626: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
627: x_msg_data := x_msg_data || ',' || l_msg_data;
628: END LOOP;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: END LOOP;
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: x_msg_data := sqlerrm;
632: x_msg_count := fnd_msg_pub.COUNT_MSG();
633: FOR i in 1..x_msg_count LOOP
634: l_msg_data := '';
635: l_msg_count := 0;
636: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
632: x_msg_count := fnd_msg_pub.COUNT_MSG();
633: FOR i in 1..x_msg_count LOOP
634: l_msg_data := '';
635: l_msg_count := 0;
636: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
637: x_msg_data := x_msg_data || ',' || l_msg_data;
638: END LOOP;
639:
640:
640:
641: WHEN OTHERS THEN
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_msg_data := sqlerrm;
644: x_msg_count := fnd_msg_pub.COUNT_MSG();
645: FOR i in 1..x_msg_count LOOP
646: l_msg_data := '';
647: l_msg_count := 0;
648: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
644: x_msg_count := fnd_msg_pub.COUNT_MSG();
645: FOR i in 1..x_msg_count LOOP
646: l_msg_data := '';
647: l_msg_count := 0;
648: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
649: x_msg_data := x_msg_data || ',' || l_msg_data;
650: END LOOP;
651:
652: end getReDis;
717: l_count :=0;
718: j :=0;
719: l_tmp :=0;
720: --dbms_output.put_line('begin');
721: fnd_msg_pub.delete_msg();
722: x_return_status := fnd_api.g_ret_sts_success;
723: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
724: FND_MSG_PUB.initialize;
725: x_results := IEU_DIAG_REQUEUED_NST();
720: --dbms_output.put_line('begin');
721: fnd_msg_pub.delete_msg();
722: x_return_status := fnd_api.g_ret_sts_success;
723: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
724: FND_MSG_PUB.initialize;
725: x_results := IEU_DIAG_REQUEUED_NST();
726:
727: FOR cur_rec IN cur_items
728: LOOP
856:
857: WHEN FND_API.G_EXC_ERROR THEN
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_msg_data := sqlerrm;
860: x_msg_count := fnd_msg_pub.COUNT_MSG();
861: FOR i in 1..x_msg_count LOOP
862: l_msg_data := '';
863: l_msg_count := 0;
864: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
860: x_msg_count := fnd_msg_pub.COUNT_MSG();
861: FOR i in 1..x_msg_count LOOP
862: l_msg_data := '';
863: l_msg_count := 0;
864: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
865: x_msg_data := x_msg_data || ',' || l_msg_data;
866: END LOOP;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: END LOOP;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: x_msg_data := sqlerrm;
870: x_msg_count := fnd_msg_pub.COUNT_MSG();
871: FOR i in 1..x_msg_count LOOP
872: l_msg_data := '';
873: l_msg_count := 0;
874: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
870: x_msg_count := fnd_msg_pub.COUNT_MSG();
871: FOR i in 1..x_msg_count LOOP
872: l_msg_data := '';
873: l_msg_count := 0;
874: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
875: x_msg_data := x_msg_data || ',' || l_msg_data;
876: END LOOP;
877:
878:
878:
879: WHEN OTHERS THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_msg_data := sqlerrm;
882: x_msg_count := fnd_msg_pub.COUNT_MSG();
883: FOR i in 1..x_msg_count LOOP
884: l_msg_data := '';
885: l_msg_count := 0;
886: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
882: x_msg_count := fnd_msg_pub.COUNT_MSG();
883: FOR i in 1..x_msg_count LOOP
884: l_msg_data := '';
885: l_msg_count := 0;
886: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
887: x_msg_data := x_msg_data || ',' || l_msg_data;
888: END LOOP;
889:
890: end getRequeued;
948: l_count :=0;
949: j :=0;
950: l_tmp :=0;
951: --dbms_output.put_line('begin');
952: fnd_msg_pub.delete_msg();
953: x_return_status := fnd_api.g_ret_sts_success;
954: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
955: FND_MSG_PUB.initialize;
956: x_results := IEU_DIAG_DISTRIBUTING_NST();
951: --dbms_output.put_line('begin');
952: fnd_msg_pub.delete_msg();
953: x_return_status := fnd_api.g_ret_sts_success;
954: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
955: FND_MSG_PUB.initialize;
956: x_results := IEU_DIAG_DISTRIBUTING_NST();
957: FOR cur_rec IN cur_items
958: LOOP
959: --dbms_output.put_line('in the loop of cur_rec');
1050:
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: x_msg_data := sqlerrm;
1054: x_msg_count := fnd_msg_pub.COUNT_MSG();
1055: FOR i in 1..x_msg_count LOOP
1056: l_msg_data := '';
1057: l_msg_count := 0;
1058: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1054: x_msg_count := fnd_msg_pub.COUNT_MSG();
1055: FOR i in 1..x_msg_count LOOP
1056: l_msg_data := '';
1057: l_msg_count := 0;
1058: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1059: x_msg_data := x_msg_data || ',' || l_msg_data;
1060: END LOOP;
1061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: END LOOP;
1061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: x_msg_data := sqlerrm;
1064: x_msg_count := fnd_msg_pub.COUNT_MSG();
1065: FOR i in 1..x_msg_count LOOP
1066: l_msg_data := '';
1067: l_msg_count := 0;
1068: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1064: x_msg_count := fnd_msg_pub.COUNT_MSG();
1065: FOR i in 1..x_msg_count LOOP
1066: l_msg_data := '';
1067: l_msg_count := 0;
1068: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1069: x_msg_data := x_msg_data || ',' || l_msg_data;
1070: END LOOP;
1071:
1072:
1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: x_msg_data := sqlerrm;
1076: x_msg_count := fnd_msg_pub.COUNT_MSG();
1077: FOR i in 1..x_msg_count LOOP
1078: l_msg_data := '';
1079: l_msg_count := 0;
1080: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1076: x_msg_count := fnd_msg_pub.COUNT_MSG();
1077: FOR i in 1..x_msg_count LOOP
1078: l_msg_data := '';
1079: l_msg_count := 0;
1080: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1081: x_msg_data := x_msg_data || ',' || l_msg_data;
1082: END LOOP;
1083:
1084: end getDistributing;
1144: l_count :=0;
1145: j :=0;
1146: l_tmp :=0;
1147: --dbms_output.put_line('begin');
1148: fnd_msg_pub.delete_msg();
1149: x_return_status := fnd_api.g_ret_sts_success;
1150: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
1151: FND_MSG_PUB.initialize;
1152: x_results := IEU_DIAG_NOTMEMBER_NST();
1147: --dbms_output.put_line('begin');
1148: fnd_msg_pub.delete_msg();
1149: x_return_status := fnd_api.g_ret_sts_success;
1150: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
1151: FND_MSG_PUB.initialize;
1152: x_results := IEU_DIAG_NOTMEMBER_NST();
1153: x_groups := IEU_DIAG_GROUP_NST();
1154: SELECT count(*) INTO l_tmp FROM ( select distinct a.workitem_pk_id, a.MODULE ,
1155: DECODE(a.WORKITEM_STATUS_ID_CURR,'0', 'Not Distributable', '1', 'Distributable',
1240:
1241: x_return_status := FND_API.G_RET_STS_ERROR;
1242: x_msg_data := sqlerrm;
1243:
1244: x_msg_count := fnd_msg_pub.COUNT_MSG();
1245:
1246: FOR i in 1..x_msg_count LOOP
1247: l_msg_data := '';
1248: l_msg_count := 0;
1245:
1246: FOR i in 1..x_msg_count LOOP
1247: l_msg_data := '';
1248: l_msg_count := 0;
1249: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1250: x_msg_data := x_msg_data || ',' || l_msg_data;
1251: END LOOP;
1252:
1253:
1260:
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: x_msg_data := sqlerrm;
1263:
1264: x_msg_count := fnd_msg_pub.COUNT_MSG();
1265:
1266: FOR i in 1..x_msg_count LOOP
1267: l_msg_data := '';
1268: l_msg_count := 0;
1265:
1266: FOR i in 1..x_msg_count LOOP
1267: l_msg_data := '';
1268: l_msg_count := 0;
1269: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1270: x_msg_data := x_msg_data || ',' || l_msg_data;
1271: END LOOP;
1272:
1273:
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: x_msg_data := sqlerrm;
1281:
1282: x_msg_count := fnd_msg_pub.COUNT_MSG();
1283:
1284: FOR i in 1..x_msg_count LOOP
1285: l_msg_data := '';
1286: l_msg_count := 0;
1283:
1284: FOR i in 1..x_msg_count LOOP
1285: l_msg_data := '';
1286: l_msg_count := 0;
1287: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1288: x_msg_data := x_msg_data || ',' || l_msg_data;
1289: END LOOP;
1290:
1291: end getNotMember;
1363: order by a.audit_log_id,a.creation_date;
1364:
1365: BEGIN
1366:
1367: fnd_msg_pub.delete_msg();
1368: x_return_status := fnd_api.g_ret_sts_success;
1369: FND_MSG_PUB.initialize;
1370: x_results := IEU_DIAG_WORKLIFE_NST();
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1365: BEGIN
1366:
1367: fnd_msg_pub.delete_msg();
1368: x_return_status := fnd_api.g_ret_sts_success;
1369: FND_MSG_PUB.initialize;
1370: x_results := IEU_DIAG_WORKLIFE_NST();
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1372:
1373: current_m :='';
1538: end loop;
1539:
1540:
1541: if cur_rec.return_status = 'E' then
1542: fnd_msg_pub.reset;
1543: fnd_msg_pub.initialize;
1544: fnd_message.parse_encoded(cur_rec.error_code, x_app_name, x_msg_name);
1545: fnd_message.set_encoded(cur_rec.error_code);
1546: fnd_msg_pub.add;
1539:
1540:
1541: if cur_rec.return_status = 'E' then
1542: fnd_msg_pub.reset;
1543: fnd_msg_pub.initialize;
1544: fnd_message.parse_encoded(cur_rec.error_code, x_app_name, x_msg_name);
1545: fnd_message.set_encoded(cur_rec.error_code);
1546: fnd_msg_pub.add;
1547: fnd_msg_pub.Count_and_Get
1542: fnd_msg_pub.reset;
1543: fnd_msg_pub.initialize;
1544: fnd_message.parse_encoded(cur_rec.error_code, x_app_name, x_msg_name);
1545: fnd_message.set_encoded(cur_rec.error_code);
1546: fnd_msg_pub.add;
1547: fnd_msg_pub.Count_and_Get
1548: (
1549: p_encoded => 'F',
1550: p_count => l_msg_count,
1543: fnd_msg_pub.initialize;
1544: fnd_message.parse_encoded(cur_rec.error_code, x_app_name, x_msg_name);
1545: fnd_message.set_encoded(cur_rec.error_code);
1546: fnd_msg_pub.add;
1547: fnd_msg_pub.Count_and_Get
1548: (
1549: p_encoded => 'F',
1550: p_count => l_msg_count,
1551: p_data => cur_rec.error_code
1552: );
1553: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_FAIL');
1554: return_status := FND_MESSAGE.GET();
1555: FOR l_index IN 1..l_msg_count LOOP
1556: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
1557: if my_message is not null then
1558: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_NEXT_LINE');
1559: return_status := return_status || FND_MESSAGE.get()|| my_message ;
1560: end if;
1560: end if;
1561: --dbms_output.put_line(l_index || ' = ' || my_message);
1562: --insert into p_temp(msg) values(l_index || ' = ' || my_message); commit;
1563: END LOOP;
1564: fnd_msg_pub.set_search_name(x_app_name, x_msg_name);
1565: l_del_msg := fnd_msg_pub.delete_msg;
1566: end if ;
1567:
1568:
1561: --dbms_output.put_line(l_index || ' = ' || my_message);
1562: --insert into p_temp(msg) values(l_index || ' = ' || my_message); commit;
1563: END LOOP;
1564: fnd_msg_pub.set_search_name(x_app_name, x_msg_name);
1565: l_del_msg := fnd_msg_pub.delete_msg;
1566: end if ;
1567:
1568:
1569: x_results(x_results.last) := IEU_DIAG_WORKLIFE_OBJ(
1609:
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611: x_msg_data := sqlerrm;
1612:
1613: x_msg_count := fnd_msg_pub.COUNT_MSG();
1614:
1615: FOR i in 1..x_msg_count LOOP
1616: l_msg_data := '';
1617: l_msg_count := 0;
1614:
1615: FOR i in 1..x_msg_count LOOP
1616: l_msg_data := '';
1617: l_msg_count := 0;
1618: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1619: x_msg_data := x_msg_data || ',' || l_msg_data;
1620: END LOOP;
1621:
1622:
1629:
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: x_msg_data := sqlerrm;
1632:
1633: x_msg_count := fnd_msg_pub.COUNT_MSG();
1634:
1635: FOR i in 1..x_msg_count LOOP
1636: l_msg_data := '';
1637: l_msg_count := 0;
1634:
1635: FOR i in 1..x_msg_count LOOP
1636: l_msg_data := '';
1637: l_msg_count := 0;
1638: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1639: x_msg_data := x_msg_data || ',' || l_msg_data;
1640: END LOOP;
1641:
1642:
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648:
1649: x_msg_data := sqlerrm;
1650:
1651: x_msg_count := fnd_msg_pub.COUNT_MSG();
1652:
1653: FOR i in 1..x_msg_count LOOP
1654: l_msg_data := '';
1655: l_msg_count := 0;
1652:
1653: FOR i in 1..x_msg_count LOOP
1654: l_msg_data := '';
1655: l_msg_count := 0;
1656: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1657: x_msg_data := x_msg_data || ',' || l_msg_data;
1658: END LOOP;
1659:
1660: