APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on FND_API

Line 65: x_return_status := fnd_api.g_ret_sts_success;

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();
69: FOR cur_rec IN cur_items

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159:
160: end LOOP;
161: EXCEPTION
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

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: end LOOP;
161: EXCEPTION
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 := '';

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 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
175: x_msg_data := sqlerrm;
176: x_msg_count := fnd_msg_pub.COUNT_MSG();
177: FOR i in 1..x_msg_count LOOP

Line 174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

182: END LOOP;
183:
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 := '';

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 263: x_return_status := fnd_api.g_ret_sts_success;

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;
267: x_results := IEU_DIAG_DISTRIBUTING_NST();

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

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

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 391: WHEN FND_API.G_EXC_ERROR THEN

387: end LOOP;
388: end if;
389: EXCEPTION
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

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: end if;
389: EXCEPTION
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 := '';

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 401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
403: x_msg_data := sqlerrm;
404: x_msg_count := fnd_msg_pub.COUNT_MSG();
405: FOR i in 1..x_msg_count LOOP

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

409: x_msg_data := x_msg_data || ',' || l_msg_data;
410: END LOOP;
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 := '';

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 483: x_return_status := fnd_api.g_ret_sts_success;

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

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615: );
616: end LOOP;
617: EXCEPTION
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

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: end LOOP;
617: EXCEPTION
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 := '';

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 629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
631: x_msg_data := sqlerrm;
632: x_msg_count := fnd_msg_pub.COUNT_MSG();
633: FOR i in 1..x_msg_count LOOP

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: END LOOP;
639:
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 := '';

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 722: x_return_status := fnd_api.g_ret_sts_success;

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

Line 857: WHEN FND_API.G_EXC_ERROR THEN

853: );
854: end LOOP;
855: EXCEPTION
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

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: end LOOP;
855: EXCEPTION
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 := '';

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 867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
869: x_msg_data := sqlerrm;
870: x_msg_count := fnd_msg_pub.COUNT_MSG();
871: FOR i in 1..x_msg_count LOOP

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

876: END LOOP;
877:
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 := '';

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 953: x_return_status := fnd_api.g_ret_sts_success;

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();
957: FOR cur_rec IN cur_items

Line 1051: WHEN FND_API.G_EXC_ERROR THEN

1047: );
1048: end LOOP;
1049: EXCEPTION
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

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR;

1048: end LOOP;
1049: EXCEPTION
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 := '';

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 1061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
1063: x_msg_data := sqlerrm;
1064: x_msg_count := fnd_msg_pub.COUNT_MSG();
1065: FOR i in 1..x_msg_count LOOP

Line 1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1070: END LOOP;
1071:
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 := '';

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 1149: x_return_status := fnd_api.g_ret_sts_success;

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();
1153: x_groups := IEU_DIAG_GROUP_NST();

Line 1236: WHEN FND_API.G_EXC_ERROR THEN

1232:
1233:
1234: EXCEPTION
1235:
1236: WHEN FND_API.G_EXC_ERROR THEN
1237:
1238: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1239:
1240:

Line 1241: x_return_status := FND_API.G_RET_STS_ERROR;

1237:
1238: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1239:
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:

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 1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1252:
1253:
1254:
1255:
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257:
1258: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1259:
1260:

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1257:
1258: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1259:
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:

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 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274: WHEN OTHERS THEN
1275: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1276: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1277:
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();

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 1368: x_return_status := fnd_api.g_ret_sts_success;

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;
1372:

Line 1605: WHEN FND_API.G_EXC_ERROR THEN

1601:
1602: end LOOP;
1603: EXCEPTION
1604:
1605: WHEN FND_API.G_EXC_ERROR THEN
1606:
1607: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1608:
1609:

Line 1610: x_return_status := FND_API.G_RET_STS_ERROR;

1606:
1607: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1608:
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:

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 1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1621:
1622:
1623:
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626:
1627: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1628:
1629:

Line 1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1626:
1627: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1628:
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:

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 1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1643: WHEN OTHERS THEN
1644: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
1645: --dbms_output.PUT_LINE('Error : '||sqlerrm);
1646:
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();

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: