DBA Data[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on FND_MSG_PUB

Line 89: FND_MSG_PUB.initialize;

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:

Line 179: fnd_msg_pub.add;

175: x_return_status := FND_API.G_RET_STS_ERROR;
176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;
180: fnd_msg_pub.Count_And_Get(
181: p_count => x_msg_count,
182: p_data => x_msg_data);
183: return;

Line 180: fnd_msg_pub.Count_And_Get(

176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;
180: fnd_msg_pub.Count_And_Get(
181: p_count => x_msg_count,
182: p_data => x_msg_data);
183: return;
184: end if;

Line 191: fnd_msg_pub.add;

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;
192: fnd_msg_pub.Count_And_Get(
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: return;

Line 192: fnd_msg_pub.Count_And_Get(

188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;
192: fnd_msg_pub.Count_And_Get(
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: return;
196: end if;

Line 216: fnd_msg_pub.add;

212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;
217: fnd_msg_pub.Count_And_Get(
218: p_count => x_msg_count,
219: p_data => x_msg_data);
220: return;

Line 217: fnd_msg_pub.Count_And_Get(

213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;
217: fnd_msg_pub.Count_And_Get(
218: p_count => x_msg_count,
219: p_data => x_msg_data);
220: return;
221: end if;

Line 244: fnd_msg_pub.add;

240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;
245: fnd_msg_pub.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248: return;

Line 245: fnd_msg_pub.Count_And_Get(

241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;
245: fnd_msg_pub.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248: return;
249: end if;

Line 485: FND_MSG_PUB.Count_And_Get(

481: AND x_return_status = FND_API.g_RET_STS_SUCCESS THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.
485: FND_MSG_PUB.Count_And_Get(
486: p_count => x_msg_count,
487: p_data => x_msg_data);
488: EXCEPTION
489: WHEN OTHERS THEN

Line 495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

491: if (l_log) then
492: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );
493: end if;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499: FND_MSG_PUB.Count_And_Get(

Line 497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

493: end if;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499: FND_MSG_PUB.Count_And_Get(
500: p_count => x_msg_count,
501: p_data => x_msg_data);

Line 499: FND_MSG_PUB.Count_And_Get(

495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;
499: FND_MSG_PUB.Count_And_Get(
500: p_count => x_msg_count,
501: p_data => x_msg_data);
502:
503: end Fork_Logic;

Line 549: FND_MSG_PUB.initialize;

545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:

Line 605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

601: ROLLBACK TO PROCESS_MMTT;
602: /* Fix for bug no :2719414 */
603: if(x_msg_data is not null) then
604: x_msg_count := 1 ;
605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
609: FND_MSG_PUB.ADD;

Line 606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

602: /* Fix for bug no :2719414 */
603: if(x_msg_data is not null) then
604: x_msg_count := 1 ;
605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
609: FND_MSG_PUB.ADD;
610: end if;

Line 609: FND_MSG_PUB.ADD;

605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
609: FND_MSG_PUB.ADD;
610: end if;
611: end if;
612: /* end of fix for bug no:2719414 */
613: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 613: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

609: FND_MSG_PUB.ADD;
610: end if;
611: end if;
612: /* end of fix for bug no:2719414 */
613: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
614: return;
615: end if;
616: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
617: end if;

Line 625: FND_MSG_PUB.Count_And_Get(

621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get(
626: p_count => x_msg_count,
627: p_data => x_msg_data);
628: EXCEPTION
629: /* Added for bug 4041420 - Start */

Line 640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

636: if (l_log) then
637: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');
638: end if;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
643: END IF;
644: FND_MSG_PUB.Count_And_Get(

Line 642: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

638: end if;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
643: END IF;
644: FND_MSG_PUB.Count_And_Get(
645: p_count => x_msg_count,
646: p_data => x_msg_data);

Line 644: FND_MSG_PUB.Count_And_Get(

640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
643: END IF;
644: FND_MSG_PUB.Count_And_Get(
645: p_count => x_msg_count,
646: p_data => x_msg_data);
647: END process_mmtt;
648:

Line 821: fnd_msg_pub.initialize;

817: END IF;
818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF fnd_api.to_boolean(p_init_msg_list) THEN
821: fnd_msg_pub.initialize;
822: END IF;
823:
824: -- Initialize API return status to success
825: x_return_status := fnd_api.g_ret_sts_success; -- line 892

Line 856: fnd_msg_pub.count_and_get(

852:
853: -- l_stmt_num := 999;
854:
855: -- Standard call to get message count and if count is 1, get message info.
856: fnd_msg_pub.count_and_get(
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859: EXCEPTION
860: WHEN fnd_api.g_exc_error THEN

Line 863: fnd_msg_pub.count_and_get(

859: EXCEPTION
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO cancel_alloc_matl_del;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get(
864: -- p_encoded => FND_API.g_false
865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN fnd_api.g_exc_unexpected_error THEN

Line 871: fnd_msg_pub.count_and_get(

867: WHEN fnd_api.g_exc_unexpected_error THEN
868: ROLLBACK TO cancel_alloc_matl_del;
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870:
871: fnd_msg_pub.count_and_get(
872: p_count => x_msg_count
873: ,p_data => x_msg_data);
874: WHEN OTHERS THEN
875: ROLLBACK TO cancel_alloc_matl_del;

Line 877: IF fnd_msg_pub.check_msg_level(

873: ,p_data => x_msg_data);
874: WHEN OTHERS THEN
875: ROLLBACK TO cancel_alloc_matl_del;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;
877: IF fnd_msg_pub.check_msg_level(
878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:

Line 878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

874: WHEN OTHERS THEN
875: ROLLBACK TO cancel_alloc_matl_del;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;
877: IF fnd_msg_pub.check_msg_level(
878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

875: ROLLBACK TO cancel_alloc_matl_del;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;
877: IF fnd_msg_pub.check_msg_level(
878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: fnd_msg_pub.count_and_get(p_count => x_msg_count
883: ,p_data => x_msg_data);

Line 882: fnd_msg_pub.count_and_get(p_count => x_msg_count

878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: fnd_msg_pub.count_and_get(p_count => x_msg_count
883: ,p_data => x_msg_data);
884:
885:
886:

Line 956: fnd_msg_pub.initialize;

952: END IF;
953:
954: -- Initialize message list if p_init_msg_list is set to TRUE.
955: IF fnd_api.to_boolean(p_init_msg_list) THEN
956: fnd_msg_pub.initialize;
957: END IF;
958:
959: -- Initialize API return status to success
960: x_return_status := fnd_api.g_ret_sts_success;

Line 1114: fnd_msg_pub.count_and_get(

1110:
1111: -- l_stmt_num := 999;
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: fnd_msg_pub.count_and_get(
1115: p_count => x_msg_count
1116: ,p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN fnd_api.g_exc_error THEN

Line 1121: fnd_msg_pub.count_and_get(

1117: EXCEPTION
1118: WHEN fnd_api.g_exc_error THEN
1119: ROLLBACK TO comp_alloc_chng_qty;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_msg_pub.count_and_get(
1122: -- p_encoded => FND_API.g_false
1123: p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1129: fnd_msg_pub.count_and_get(

1125: WHEN fnd_api.g_exc_unexpected_error THEN
1126: ROLLBACK TO comp_alloc_chng_qty;
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: fnd_msg_pub.count_and_get(
1130: p_count => x_msg_count
1131: ,p_data => x_msg_data);
1132: WHEN OTHERS THEN
1133: ROLLBACK TO comp_alloc_chng_qty;

Line 1135: IF fnd_msg_pub.check_msg_level(

1131: ,p_data => x_msg_data);
1132: WHEN OTHERS THEN
1133: ROLLBACK TO comp_alloc_chng_qty;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135: IF fnd_msg_pub.check_msg_level(
1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1138: END IF;
1139:

Line 1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1132: WHEN OTHERS THEN
1133: ROLLBACK TO comp_alloc_chng_qty;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135: IF fnd_msg_pub.check_msg_level(
1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1138: END IF;
1139:
1140: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1133: ROLLBACK TO comp_alloc_chng_qty;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135: IF fnd_msg_pub.check_msg_level(
1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1138: END IF;
1139:
1140: fnd_msg_pub.count_and_get(p_count => x_msg_count
1141: ,p_data => x_msg_data);

Line 1140: fnd_msg_pub.count_and_get(p_count => x_msg_count

1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1138: END IF;
1139:
1140: fnd_msg_pub.count_and_get(p_count => x_msg_count
1141: ,p_data => x_msg_data);
1142:
1143:
1144:

Line 1203: fnd_msg_pub.initialize;

1199: END IF;
1200:
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean(p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: -- Initialize API return status to success
1207: x_return_status := fnd_api.g_ret_sts_success;

Line 1295: fnd_msg_pub.count_and_get(

1291:
1292: -- l_stmt_num := 999;
1293:
1294: -- Standard call to get message count and if count is 1, get message info.
1295: fnd_msg_pub.count_and_get(
1296: p_count => x_msg_count
1297: ,p_data => x_msg_data);
1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN

Line 1302: fnd_msg_pub.count_and_get(

1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK TO comp_alloc_new_mat;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302: fnd_msg_pub.count_and_get(
1303: -- p_encoded => FND_API.g_false
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1310: fnd_msg_pub.count_and_get(

1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO comp_alloc_new_mat;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_msg_pub.count_and_get(
1311: p_count => x_msg_count
1312: ,p_data => x_msg_data);
1313: WHEN OTHERS THEN
1314: ROLLBACK TO comp_alloc_new_mat;

Line 1316: IF fnd_msg_pub.check_msg_level(

1312: ,p_data => x_msg_data);
1313: WHEN OTHERS THEN
1314: ROLLBACK TO comp_alloc_new_mat;
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1319: END IF;
1320:

Line 1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1313: WHEN OTHERS THEN
1314: ROLLBACK TO comp_alloc_new_mat;
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1319: END IF;
1320:
1321: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1314: ROLLBACK TO comp_alloc_new_mat;
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1319: END IF;
1320:
1321: fnd_msg_pub.count_and_get(p_count => x_msg_count
1322: ,p_data => x_msg_data);

Line 1321: fnd_msg_pub.count_and_get(p_count => x_msg_count

1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1319: END IF;
1320:
1321: fnd_msg_pub.count_and_get(p_count => x_msg_count
1322: ,p_data => x_msg_data);
1323:
1324: END comp_alloc_new_mat;
1325:

Line 1381: fnd_msg_pub.initialize;

1377: END IF;
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: IF fnd_api.to_boolean(p_init_msg_list) THEN
1381: fnd_msg_pub.initialize;
1382: END IF;
1383:
1384: -- Initialize API return status to success
1385: x_return_status := fnd_api.g_ret_sts_success;

Line 1454: fnd_msg_pub.count_and_get(

1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
1453: end if;
1454: fnd_msg_pub.count_and_get(
1455: p_count => x_msg_count
1456: ,p_data => x_msg_data);
1457: EXCEPTION
1458: WHEN fnd_api.g_exc_error THEN

Line 1461: fnd_msg_pub.count_and_get(

1457: EXCEPTION
1458: WHEN fnd_api.g_exc_error THEN
1459: ROLLBACK TO alloc_at_release_cancel;
1460: x_return_status := fnd_api.g_ret_sts_error;
1461: fnd_msg_pub.count_and_get(
1462: -- p_encoded => FND_API.g_false
1463: p_count => x_msg_count
1464: ,p_data => x_msg_data);
1465: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1469: fnd_msg_pub.count_and_get(

1465: WHEN fnd_api.g_exc_unexpected_error THEN
1466: ROLLBACK TO alloc_at_release_cancel;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error;
1468:
1469: fnd_msg_pub.count_and_get(
1470: p_count => x_msg_count
1471: ,p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: ROLLBACK TO alloc_at_release_cancel;

Line 1475: IF fnd_msg_pub.check_msg_level(

1471: ,p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: ROLLBACK TO alloc_at_release_cancel;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(
1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1478: END IF;
1479:

Line 1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1472: WHEN OTHERS THEN
1473: ROLLBACK TO alloc_at_release_cancel;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(
1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1478: END IF;
1479:
1480: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1473: ROLLBACK TO alloc_at_release_cancel;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(
1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1478: END IF;
1479:
1480: fnd_msg_pub.count_and_get(p_count => x_msg_count
1481: ,p_data => x_msg_data);

Line 1480: fnd_msg_pub.count_and_get(p_count => x_msg_count

1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1478: END IF;
1479:
1480: fnd_msg_pub.count_and_get(p_count => x_msg_count
1481: ,p_data => x_msg_data);
1482:
1483: END alloc_at_release_cancel;
1484: