DBA Data[Home] [Help]

APPS.IEX_EXCLUSION_HIST_PUB dependencies on FND_MSG_PUB

Line 146: FND_MSG_PUB.count_and_get(

142: ROLLBACK TO exclusion_hist_insert;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: x_msg_count := l_msg_count ;
145: x_msg_data := l_msg_data ;
146: FND_MSG_PUB.count_and_get(
147: p_count => x_msg_count
148: ,p_data => x_msg_data);
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: ROLLBACK TO exclusion_hist_insert;

Line 154: FND_MSG_PUB.count_and_get(

150: ROLLBACK TO exclusion_hist_insert;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: x_msg_count := l_msg_count ;
153: x_msg_data := l_msg_data ;
154: FND_MSG_PUB.count_and_get(
155: p_count => x_msg_count
156: ,p_data => x_msg_data);
157: WHEN OTHERS THEN
158: ROLLBACK TO exclusion_hist_insert;

Line 162: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');

158: ROLLBACK TO exclusion_hist_insert;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: x_msg_count := l_msg_count ;
161: x_msg_data := l_msg_data ;
162: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: END insert_exclusion_hist;

Line 163: FND_MSG_PUB.count_and_get(

159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: x_msg_count := l_msg_count ;
161: x_msg_data := l_msg_data ;
162: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: END insert_exclusion_hist;
167:

Line 307: FND_MSG_PUB.count_and_get(

303: ROLLBACK TO exclusion_hist_insert;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: x_msg_count := l_msg_count ;
306: x_msg_data := l_msg_data ;
307: FND_MSG_PUB.count_and_get(
308: p_count => x_msg_count
309: ,p_data => x_msg_data);
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: ROLLBACK TO exclusion_hist_insert;

Line 315: FND_MSG_PUB.count_and_get(

311: ROLLBACK TO exclusion_hist_insert;
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: x_msg_count := l_msg_count ;
314: x_msg_data := l_msg_data ;
315: FND_MSG_PUB.count_and_get(
316: p_count => x_msg_count
317: ,p_data => x_msg_data);
318: WHEN OTHERS THEN
319: ROLLBACK TO exclusion_hist_insert;

Line 323: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');

319: ROLLBACK TO exclusion_hist_insert;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: x_msg_count := l_msg_count ;
322: x_msg_data := l_msg_data ;
323: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');
324: FND_MSG_PUB.count_and_get(
325: p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END insert_exclusion_hist;

Line 324: FND_MSG_PUB.count_and_get(

320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: x_msg_count := l_msg_count ;
322: x_msg_data := l_msg_data ;
323: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');
324: FND_MSG_PUB.count_and_get(
325: p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END insert_exclusion_hist;
328:

Line 356: FND_MSG_PUB.count_and_get(

352:
353: EXCEPTION
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: FND_MSG_PUB.count_and_get(

Line 360: FND_MSG_PUB.count_and_get(

356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: FND_MSG_PUB.count_and_get(
361: p_count => x_msg_count
362: ,p_data => x_msg_data);
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 365: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');

361: p_count => x_msg_count
362: ,p_data => x_msg_data);
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');
366: FND_MSG_PUB.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: END lock_exclusion_hist;

Line 366: FND_MSG_PUB.count_and_get(

362: ,p_data => x_msg_data);
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');
366: FND_MSG_PUB.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: END lock_exclusion_hist;
370:

Line 398: FND_MSG_PUB.count_and_get(

394:
395: EXCEPTION
396:
397: WHEN FND_API.G_EXC_ERROR THEN
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: FND_MSG_PUB.count_and_get(

Line 402: FND_MSG_PUB.count_and_get(

398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: FND_MSG_PUB.count_and_get(
403: p_count => x_msg_count
404: ,p_data => x_msg_data);
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 407: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');

403: p_count => x_msg_count
404: ,p_data => x_msg_data);
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');
408: FND_MSG_PUB.count_and_get(
409: p_count => x_msg_count
410: ,p_data => x_msg_data);
411: END lock_exclusion_hist;

Line 408: FND_MSG_PUB.count_and_get(

404: ,p_data => x_msg_data);
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','lock_exclusion_hist');
408: FND_MSG_PUB.count_and_get(
409: p_count => x_msg_count
410: ,p_data => x_msg_data);
411: END lock_exclusion_hist;
412:

Line 552: FND_MSG_PUB.count_and_get(

548: ROLLBACK TO exclusion_hist_update;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: x_msg_count := l_msg_count ;
551: x_msg_data := l_msg_data ;
552: FND_MSG_PUB.count_and_get(
553: p_count => x_msg_count
554: ,p_data => x_msg_data);
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO exclusion_hist_update;

Line 560: FND_MSG_PUB.count_and_get(

556: ROLLBACK TO exclusion_hist_update;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: x_msg_count := l_msg_count ;
559: x_msg_data := l_msg_data ;
560: FND_MSG_PUB.count_and_get(
561: p_count => x_msg_count
562: ,p_data => x_msg_data);
563: WHEN OTHERS THEN
564: ROLLBACK TO exclusion_hist_update;

Line 568: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');

564: ROLLBACK TO exclusion_hist_update;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: x_msg_count := l_msg_count ;
567: x_msg_data := l_msg_data ;
568: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');
569: FND_MSG_PUB.count_and_get(
570: p_count => x_msg_count
571: ,p_data => x_msg_data);
572: END update_exclusion_hist;

Line 569: FND_MSG_PUB.count_and_get(

565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: x_msg_count := l_msg_count ;
567: x_msg_data := l_msg_data ;
568: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');
569: FND_MSG_PUB.count_and_get(
570: p_count => x_msg_count
571: ,p_data => x_msg_data);
572: END update_exclusion_hist;
573:

Line 712: FND_MSG_PUB.count_and_get(

708: ROLLBACK TO exclusion_hist_update;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: x_msg_count := l_msg_count ;
711: x_msg_data := l_msg_data ;
712: FND_MSG_PUB.count_and_get(
713: p_count => x_msg_count
714: ,p_data => x_msg_data);
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO exclusion_hist_update;

Line 720: FND_MSG_PUB.count_and_get(

716: ROLLBACK TO exclusion_hist_update;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: x_msg_count := l_msg_count ;
719: x_msg_data := l_msg_data ;
720: FND_MSG_PUB.count_and_get(
721: p_count => x_msg_count
722: ,p_data => x_msg_data);
723: WHEN OTHERS THEN
724: ROLLBACK TO exclusion_hist_update;

Line 728: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');

724: ROLLBACK TO exclusion_hist_update;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: x_msg_count := l_msg_count ;
727: x_msg_data := l_msg_data ;
728: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');
729: FND_MSG_PUB.count_and_get(
730: p_count => x_msg_count
731: ,p_data => x_msg_data);
732: END update_exclusion_hist;

Line 729: FND_MSG_PUB.count_and_get(

725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: x_msg_count := l_msg_count ;
727: x_msg_data := l_msg_data ;
728: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');
729: FND_MSG_PUB.count_and_get(
730: p_count => x_msg_count
731: ,p_data => x_msg_data);
732: END update_exclusion_hist;
733:

Line 870: FND_MSG_PUB.count_and_get(

866: ROLLBACK TO exclusion_hist_delete_rec;
867: x_return_status := FND_API.G_RET_STS_ERROR;
868: x_msg_count := l_msg_count ;
869: x_msg_data := l_msg_data ;
870: FND_MSG_PUB.count_and_get(
871: p_count => x_msg_count
872: ,p_data => x_msg_data);
873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
874: ROLLBACK TO exclusion_hist_delete_rec;

Line 878: FND_MSG_PUB.count_and_get(

874: ROLLBACK TO exclusion_hist_delete_rec;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: x_msg_count := l_msg_count ;
877: x_msg_data := l_msg_data ;
878: FND_MSG_PUB.count_and_get(
879: p_count => x_msg_count
880: ,p_data => x_msg_data);
881: WHEN OTHERS THEN
882: ROLLBACK TO exclusion_hist_delete_rec;

Line 886: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');

882: ROLLBACK TO exclusion_hist_delete_rec;
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884: x_msg_count := l_msg_count ;
885: x_msg_data := l_msg_data ;
886: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');
887: FND_MSG_PUB.count_and_get(
888: p_count => x_msg_count
889: ,p_data => x_msg_data);
890: END delete_exclusion_hist;

Line 887: FND_MSG_PUB.count_and_get(

883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
884: x_msg_count := l_msg_count ;
885: x_msg_data := l_msg_data ;
886: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');
887: FND_MSG_PUB.count_and_get(
888: p_count => x_msg_count
889: ,p_data => x_msg_data);
890: END delete_exclusion_hist;
891:

Line 1039: FND_MSG_PUB.count_and_get(

1035: ROLLBACK TO exclusion_hist_delete_tbl;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: x_msg_count := l_msg_count ;
1038: x_msg_data := l_msg_data ;
1039: FND_MSG_PUB.count_and_get(
1040: p_count => x_msg_count
1041: ,p_data => x_msg_data);
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043: ROLLBACK TO exclusion_hist_delete_tbl;

Line 1047: FND_MSG_PUB.count_and_get(

1043: ROLLBACK TO exclusion_hist_delete_tbl;
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: x_msg_count := l_msg_count ;
1046: x_msg_data := l_msg_data ;
1047: FND_MSG_PUB.count_and_get(
1048: p_count => x_msg_count
1049: ,p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: ROLLBACK TO exclusion_hist_delete_tbl;

Line 1055: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');

1051: ROLLBACK TO exclusion_hist_delete_tbl;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: x_msg_count := l_msg_count ;
1054: x_msg_data := l_msg_data ;
1055: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');
1056: FND_MSG_PUB.count_and_get(
1057: p_count => x_msg_count
1058: ,p_data => x_msg_data);
1059: END delete_exclusion_hist;

Line 1056: FND_MSG_PUB.count_and_get(

1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: x_msg_count := l_msg_count ;
1054: x_msg_data := l_msg_data ;
1055: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');
1056: FND_MSG_PUB.count_and_get(
1057: p_count => x_msg_count
1058: ,p_data => x_msg_data);
1059: END delete_exclusion_hist;
1060:

Line 1200: FND_MSG_PUB.count_and_get(

1196: ROLLBACK TO exclusion_hist_validate;
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: x_msg_count := l_msg_count ;
1199: x_msg_data := l_msg_data ;
1200: FND_MSG_PUB.count_and_get(
1201: p_count => x_msg_count
1202: ,p_data => x_msg_data);
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: ROLLBACK TO exclusion_hist_validate;

Line 1208: FND_MSG_PUB.count_and_get(

1204: ROLLBACK TO exclusion_hist_validate;
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: x_msg_count := l_msg_count ;
1207: x_msg_data := l_msg_data ;
1208: FND_MSG_PUB.count_and_get(
1209: p_count => x_msg_count
1210: ,p_data => x_msg_data);
1211: WHEN OTHERS THEN
1212: ROLLBACK TO exclusion_hist_validate;

Line 1216: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');

1212: ROLLBACK TO exclusion_hist_validate;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: x_msg_count := l_msg_count ;
1215: x_msg_data := l_msg_data ;
1216: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');
1217: FND_MSG_PUB.count_and_get(
1218: p_count => x_msg_count
1219: ,p_data => x_msg_data);
1220: END validate_exclusion_hist;

Line 1217: FND_MSG_PUB.count_and_get(

1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: x_msg_count := l_msg_count ;
1215: x_msg_data := l_msg_data ;
1216: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');
1217: FND_MSG_PUB.count_and_get(
1218: p_count => x_msg_count
1219: ,p_data => x_msg_data);
1220: END validate_exclusion_hist;
1221:

Line 1357: FND_MSG_PUB.count_and_get(

1353: ROLLBACK TO exclusion_hist_validate;
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: x_msg_count := l_msg_count ;
1356: x_msg_data := l_msg_data ;
1357: FND_MSG_PUB.count_and_get(
1358: p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO exclusion_hist_validate;

Line 1365: FND_MSG_PUB.count_and_get(

1361: ROLLBACK TO exclusion_hist_validate;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363: x_msg_count := l_msg_count ;
1364: x_msg_data := l_msg_data ;
1365: FND_MSG_PUB.count_and_get(
1366: p_count => x_msg_count
1367: ,p_data => x_msg_data);
1368: WHEN OTHERS THEN
1369: ROLLBACK TO exclusion_hist_validate;

Line 1373: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');

1369: ROLLBACK TO exclusion_hist_validate;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: x_msg_count := l_msg_count ;
1372: x_msg_data := l_msg_data ;
1373: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');
1374: FND_MSG_PUB.count_and_get(
1375: p_count => x_msg_count
1376: ,p_data => x_msg_data);
1377: END validate_exclusion_hist;

Line 1374: FND_MSG_PUB.count_and_get(

1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: x_msg_count := l_msg_count ;
1372: x_msg_data := l_msg_data ;
1373: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','validate_exclusion_hist');
1374: FND_MSG_PUB.count_and_get(
1375: p_count => x_msg_count
1376: ,p_data => x_msg_data);
1377: END validate_exclusion_hist;
1378: