DBA Data[Home] [Help]

APPS.IEX_EXT_AGNCY_PUB dependencies on FND_MSG_PUB

Line 145: FND_MSG_PUB.count_and_get(

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

Line 153: FND_MSG_PUB.count_and_get(

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

Line 161: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');

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

Line 162: FND_MSG_PUB.count_and_get(

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

Line 304: FND_MSG_PUB.count_and_get(

300: ROLLBACK TO ext_agncy_insert;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: x_msg_count := l_msg_count ;
303: x_msg_data := l_msg_data ;
304: FND_MSG_PUB.count_and_get(
305: p_count => x_msg_count
306: ,p_data => x_msg_data);
307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
308: ROLLBACK TO ext_agncy_insert;

Line 312: FND_MSG_PUB.count_and_get(

308: ROLLBACK TO ext_agncy_insert;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: x_msg_count := l_msg_count ;
311: x_msg_data := l_msg_data ;
312: FND_MSG_PUB.count_and_get(
313: p_count => x_msg_count
314: ,p_data => x_msg_data);
315: WHEN OTHERS THEN
316: ROLLBACK TO ext_agncy_insert;

Line 320: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');

316: ROLLBACK TO ext_agncy_insert;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: x_msg_count := l_msg_count ;
319: x_msg_data := l_msg_data ;
320: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');
321: FND_MSG_PUB.count_and_get(
322: p_count => x_msg_count
323: ,p_data => x_msg_data);
324: END insert_ext_agncy;

Line 321: FND_MSG_PUB.count_and_get(

317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: x_msg_count := l_msg_count ;
319: x_msg_data := l_msg_data ;
320: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');
321: FND_MSG_PUB.count_and_get(
322: p_count => x_msg_count
323: ,p_data => x_msg_data);
324: END insert_ext_agncy;
325:

Line 353: FND_MSG_PUB.count_and_get(

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

Line 357: FND_MSG_PUB.count_and_get(

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

Line 362: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');

358: p_count => x_msg_count
359: ,p_data => x_msg_data);
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END lock_ext_agncy;

Line 363: FND_MSG_PUB.count_and_get(

359: ,p_data => x_msg_data);
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END lock_ext_agncy;
367:

Line 395: FND_MSG_PUB.count_and_get(

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

Line 399: FND_MSG_PUB.count_and_get(

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

Line 404: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');

400: p_count => x_msg_count
401: ,p_data => x_msg_data);
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');
405: FND_MSG_PUB.count_and_get(
406: p_count => x_msg_count
407: ,p_data => x_msg_data);
408: END lock_ext_agncy;

Line 405: FND_MSG_PUB.count_and_get(

401: ,p_data => x_msg_data);
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','lock_ext_agncy');
405: FND_MSG_PUB.count_and_get(
406: p_count => x_msg_count
407: ,p_data => x_msg_data);
408: END lock_ext_agncy;
409:

Line 549: FND_MSG_PUB.count_and_get(

545: ROLLBACK TO ext_agncy_update;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: x_msg_count := l_msg_count ;
548: x_msg_data := l_msg_data ;
549: FND_MSG_PUB.count_and_get(
550: p_count => x_msg_count
551: ,p_data => x_msg_data);
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: ROLLBACK TO ext_agncy_update;

Line 557: FND_MSG_PUB.count_and_get(

553: ROLLBACK TO ext_agncy_update;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: x_msg_count := l_msg_count ;
556: x_msg_data := l_msg_data ;
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: WHEN OTHERS THEN
561: ROLLBACK TO ext_agncy_update;

Line 565: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');

561: ROLLBACK TO ext_agncy_update;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: x_msg_count := l_msg_count ;
564: x_msg_data := l_msg_data ;
565: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
566: FND_MSG_PUB.count_and_get(
567: p_count => x_msg_count
568: ,p_data => x_msg_data);
569: END update_ext_agncy;

Line 566: FND_MSG_PUB.count_and_get(

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: x_msg_count := l_msg_count ;
564: x_msg_data := l_msg_data ;
565: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
566: FND_MSG_PUB.count_and_get(
567: p_count => x_msg_count
568: ,p_data => x_msg_data);
569: END update_ext_agncy;
570:

Line 708: FND_MSG_PUB.count_and_get(

704: ROLLBACK TO ext_agncy_update;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO ext_agncy_update;

Line 716: FND_MSG_PUB.count_and_get(

712: ROLLBACK TO ext_agncy_update;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.count_and_get(
717: p_count => x_msg_count
718: ,p_data => x_msg_data);
719: WHEN OTHERS THEN
720: ROLLBACK TO ext_agncy_update;

Line 724: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');

720: ROLLBACK TO ext_agncy_update;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;
724: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
725: FND_MSG_PUB.count_and_get(
726: p_count => x_msg_count
727: ,p_data => x_msg_data);
728: END update_ext_agncy;

Line 725: FND_MSG_PUB.count_and_get(

721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;
724: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
725: FND_MSG_PUB.count_and_get(
726: p_count => x_msg_count
727: ,p_data => x_msg_data);
728: END update_ext_agncy;
729:

Line 864: FND_MSG_PUB.count_and_get(

860: ROLLBACK TO ext_agncy_delete_rec;
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: x_msg_count := l_msg_count ;
863: x_msg_data := l_msg_data ;
864: FND_MSG_PUB.count_and_get(
865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO ext_agncy_delete_rec;

Line 872: FND_MSG_PUB.count_and_get(

868: ROLLBACK TO ext_agncy_delete_rec;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: x_msg_count := l_msg_count ;
871: x_msg_data := l_msg_data ;
872: FND_MSG_PUB.count_and_get(
873: p_count => x_msg_count
874: ,p_data => x_msg_data);
875: WHEN OTHERS THEN
876: ROLLBACK TO ext_agncy_delete_rec;

Line 880: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');

876: ROLLBACK TO ext_agncy_delete_rec;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_msg_count := l_msg_count ;
879: x_msg_data := l_msg_data ;
880: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
881: FND_MSG_PUB.count_and_get(
882: p_count => x_msg_count
883: ,p_data => x_msg_data);
884: END delete_ext_agncy;

Line 881: FND_MSG_PUB.count_and_get(

877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_msg_count := l_msg_count ;
879: x_msg_data := l_msg_data ;
880: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
881: FND_MSG_PUB.count_and_get(
882: p_count => x_msg_count
883: ,p_data => x_msg_data);
884: END delete_ext_agncy;
885:

Line 1035: FND_MSG_PUB.count_and_get(

1031: ROLLBACK TO ext_agncy_delete_tbl;
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: x_msg_count := l_msg_count ;
1034: x_msg_data := l_msg_data ;
1035: FND_MSG_PUB.count_and_get(
1036: p_count => x_msg_count
1037: ,p_data => x_msg_data);
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO ext_agncy_delete_tbl;

Line 1043: FND_MSG_PUB.count_and_get(

1039: ROLLBACK TO ext_agncy_delete_tbl;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: x_msg_count := l_msg_count ;
1042: x_msg_data := l_msg_data ;
1043: FND_MSG_PUB.count_and_get(
1044: p_count => x_msg_count
1045: ,p_data => x_msg_data);
1046: WHEN OTHERS THEN
1047: ROLLBACK TO ext_agncy_delete_tbl;

Line 1051: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');

1047: ROLLBACK TO ext_agncy_delete_tbl;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: x_msg_count := l_msg_count ;
1050: x_msg_data := l_msg_data ;
1051: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
1052: FND_MSG_PUB.count_and_get(
1053: p_count => x_msg_count
1054: ,p_data => x_msg_data);
1055: END delete_ext_agncy;

Line 1052: FND_MSG_PUB.count_and_get(

1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: x_msg_count := l_msg_count ;
1050: x_msg_data := l_msg_data ;
1051: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
1052: FND_MSG_PUB.count_and_get(
1053: p_count => x_msg_count
1054: ,p_data => x_msg_data);
1055: END delete_ext_agncy;
1056:

Line 1199: FND_MSG_PUB.count_and_get(

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

Line 1207: FND_MSG_PUB.count_and_get(

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

Line 1215: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','validate_ext_agncy');

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

Line 1216: FND_MSG_PUB.count_and_get(

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

Line 1357: FND_MSG_PUB.count_and_get(

1353: ROLLBACK TO ext_agncy_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 ext_agncy_validate;

Line 1365: FND_MSG_PUB.count_and_get(

1361: ROLLBACK TO ext_agncy_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 ext_agncy_validate;

Line 1373: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','validate_ext_agncy');

1369: ROLLBACK TO ext_agncy_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_EXT_AGNCY_PUB','validate_ext_agncy');
1374: FND_MSG_PUB.count_and_get(
1375: p_count => x_msg_count
1376: ,p_data => x_msg_data);
1377: END validate_ext_agncy;

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_EXT_AGNCY_PUB','validate_ext_agncy');
1374: FND_MSG_PUB.count_and_get(
1375: p_count => x_msg_count
1376: ,p_data => x_msg_data);
1377: END validate_ext_agncy;
1378: