DBA Data[Home] [Help]

APPS.IEX_OPEN_INT_HST_PUB dependencies on FND_MSG_PUB

Line 147: FND_MSG_PUB.count_and_get(

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

Line 155: FND_MSG_PUB.count_and_get(

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

Line 163: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');

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

Line 164: FND_MSG_PUB.count_and_get(

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

Line 305: FND_MSG_PUB.count_and_get(

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

Line 313: FND_MSG_PUB.count_and_get(

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

Line 321: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');

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

Line 322: FND_MSG_PUB.count_and_get(

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

Line 354: FND_MSG_PUB.count_and_get(

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

Line 358: FND_MSG_PUB.count_and_get(

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

Line 363: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','lock_open_int_hst');

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

Line 364: FND_MSG_PUB.count_and_get(

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

Line 396: FND_MSG_PUB.count_and_get(

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

Line 400: FND_MSG_PUB.count_and_get(

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

Line 405: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','lock_open_int_hst');

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

Line 406: FND_MSG_PUB.count_and_get(

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

Line 550: FND_MSG_PUB.count_and_get(

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

Line 558: FND_MSG_PUB.count_and_get(

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

Line 566: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');

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

Line 567: FND_MSG_PUB.count_and_get(

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

Line 710: FND_MSG_PUB.count_and_get(

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

Line 718: FND_MSG_PUB.count_and_get(

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

Line 726: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');

722: ROLLBACK TO open_int_hst_update;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');
727: FND_MSG_PUB.count_and_get(
728: p_count => x_msg_count
729: ,p_data => x_msg_data);
730: END update_open_int_hst;

Line 727: FND_MSG_PUB.count_and_get(

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');
727: FND_MSG_PUB.count_and_get(
728: p_count => x_msg_count
729: ,p_data => x_msg_data);
730: END update_open_int_hst;
731:

Line 867: FND_MSG_PUB.count_and_get(

863: ROLLBACK TO open_int_hst_delete_rec;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: x_msg_count := l_msg_count ;
866: x_msg_data := l_msg_data ;
867: FND_MSG_PUB.count_and_get(
868: p_count => x_msg_count
869: ,p_data => x_msg_data);
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO open_int_hst_delete_rec;

Line 875: FND_MSG_PUB.count_and_get(

871: ROLLBACK TO open_int_hst_delete_rec;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: x_msg_count := l_msg_count ;
874: x_msg_data := l_msg_data ;
875: FND_MSG_PUB.count_and_get(
876: p_count => x_msg_count
877: ,p_data => x_msg_data);
878: WHEN OTHERS THEN
879: ROLLBACK TO open_int_hst_delete_rec;

Line 883: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');

879: ROLLBACK TO open_int_hst_delete_rec;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_msg_count := l_msg_count ;
882: x_msg_data := l_msg_data ;
883: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
884: FND_MSG_PUB.count_and_get(
885: p_count => x_msg_count
886: ,p_data => x_msg_data);
887: END delete_open_int_hst;

Line 884: FND_MSG_PUB.count_and_get(

880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_msg_count := l_msg_count ;
882: x_msg_data := l_msg_data ;
883: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
884: FND_MSG_PUB.count_and_get(
885: p_count => x_msg_count
886: ,p_data => x_msg_data);
887: END delete_open_int_hst;
888:

Line 1037: FND_MSG_PUB.count_and_get(

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

Line 1045: FND_MSG_PUB.count_and_get(

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

Line 1053: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');

1049: ROLLBACK TO open_int_hst_delete_tbl;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: x_msg_count := l_msg_count ;
1052: x_msg_data := l_msg_data ;
1053: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
1054: FND_MSG_PUB.count_and_get(
1055: p_count => x_msg_count
1056: ,p_data => x_msg_data);
1057: END delete_open_int_hst;

Line 1054: FND_MSG_PUB.count_and_get(

1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: x_msg_count := l_msg_count ;
1052: x_msg_data := l_msg_data ;
1053: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
1054: FND_MSG_PUB.count_and_get(
1055: p_count => x_msg_count
1056: ,p_data => x_msg_data);
1057: END delete_open_int_hst;
1058:

Line 1197: FND_MSG_PUB.count_and_get(

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

Line 1205: FND_MSG_PUB.count_and_get(

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

Line 1213: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');

1209: ROLLBACK TO open_int_hst_validate;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: x_msg_count := l_msg_count ;
1212: x_msg_data := l_msg_data ;
1213: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1214: FND_MSG_PUB.count_and_get(
1215: p_count => x_msg_count
1216: ,p_data => x_msg_data);
1217: END validate_open_int_hst;

Line 1214: FND_MSG_PUB.count_and_get(

1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: x_msg_count := l_msg_count ;
1212: x_msg_data := l_msg_data ;
1213: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1214: FND_MSG_PUB.count_and_get(
1215: p_count => x_msg_count
1216: ,p_data => x_msg_data);
1217: END validate_open_int_hst;
1218:

Line 1352: FND_MSG_PUB.count_and_get(

1348: ROLLBACK TO open_int_hst_validate;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_msg_count := l_msg_count ;
1351: x_msg_data := l_msg_data ;
1352: FND_MSG_PUB.count_and_get(
1353: p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: ROLLBACK TO open_int_hst_validate;

Line 1360: FND_MSG_PUB.count_and_get(

1356: ROLLBACK TO open_int_hst_validate;
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358: x_msg_count := l_msg_count ;
1359: x_msg_data := l_msg_data ;
1360: FND_MSG_PUB.count_and_get(
1361: p_count => x_msg_count
1362: ,p_data => x_msg_data);
1363: WHEN OTHERS THEN
1364: ROLLBACK TO open_int_hst_validate;

Line 1368: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');

1364: ROLLBACK TO open_int_hst_validate;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: x_msg_count := l_msg_count ;
1367: x_msg_data := l_msg_data ;
1368: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1369: FND_MSG_PUB.count_and_get(
1370: p_count => x_msg_count
1371: ,p_data => x_msg_data);
1372: END validate_open_int_hst;

Line 1369: FND_MSG_PUB.count_and_get(

1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: x_msg_count := l_msg_count ;
1367: x_msg_data := l_msg_data ;
1368: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1369: FND_MSG_PUB.count_and_get(
1370: p_count => x_msg_count
1371: ,p_data => x_msg_data);
1372: END validate_open_int_hst;
1373: BEGIN