APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on FND_MSG_PUB

Line 64: fnd_msg_pub.delete_msg();

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();

Line 67: FND_MSG_PUB.initialize;

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');

Line 166: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 176: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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:

Line 188: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 262: fnd_msg_pub.delete_msg();

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;

Line 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:

Line 281: FND_MSG_PUB.Add;

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

Line 283: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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;

Line 394: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 404: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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

Line 415: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 482: fnd_msg_pub.delete_msg();

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();

Line 485: FND_MSG_PUB.initialize;

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

Line 622: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 632: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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:

Line 644: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 721: fnd_msg_pub.delete_msg();

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();

Line 724: FND_MSG_PUB.initialize;

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

Line 860: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 870: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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:

Line 882: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 952: fnd_msg_pub.delete_msg();

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();

Line 955: FND_MSG_PUB.initialize;

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');

Line 1054: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 1064: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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:

Line 1076: x_msg_count := fnd_msg_pub.COUNT_MSG();

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);

Line 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;

Line 1148: fnd_msg_pub.delete_msg();

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();

Line 1151: FND_MSG_PUB.initialize;

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',

Line 1244: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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:

Line 1264: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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:

Line 1282: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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;

Line 1367: fnd_msg_pub.delete_msg();

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;

Line 1369: FND_MSG_PUB.initialize;

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 :='';

Line 1542: fnd_msg_pub.reset;

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;

Line 1543: fnd_msg_pub.initialize;

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

Line 1546: fnd_msg_pub.add;

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,

Line 1547: fnd_msg_pub.Count_and_Get

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

Line 1556: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

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;

Line 1564: fnd_msg_pub.set_search_name(x_app_name, x_msg_name);

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:

Line 1565: l_del_msg := fnd_msg_pub.delete_msg;

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(

Line 1613: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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:

Line 1633: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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:

Line 1651: x_msg_count := fnd_msg_pub.COUNT_MSG();

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;

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

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: