eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_MATERIALISSUE_PVT dependencies on FND_MSG_PUB

Line 138: FND_MSG_PUB.initialize;

134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136: -- Initialize message list if p_init_msg_list is set to TRUE.
137: IF FND_API.to_Boolean( p_init_msg_list ) THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:

Line 272: fnd_msg_pub.add;

268:
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: fnd_message.set_name('EAM', 'EAM_INV_ONHAND_NOT_DETERMINED');
271: fnd_message.set_token('MATERIAL',l_material);
272: fnd_msg_pub.add;
273: fnd_msg_pub.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data);
276: return;

Line 273: fnd_msg_pub.Count_And_Get(

269: x_return_status := FND_API.G_RET_STS_ERROR;
270: fnd_message.set_name('EAM', 'EAM_INV_ONHAND_NOT_DETERMINED');
271: fnd_message.set_token('MATERIAL',l_material);
272: fnd_msg_pub.add;
273: fnd_msg_pub.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data);
276: return;
277:

Line 309: fnd_msg_pub.add;

305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');
306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;
310: fnd_msg_pub.Count_And_Get(
311: p_count => x_msg_count,
312: p_data => x_msg_data);
313: return;

Line 310: fnd_msg_pub.Count_And_Get(

306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;
310: fnd_msg_pub.Count_And_Get(
311: p_count => x_msg_count,
312: p_data => x_msg_data);
313: return;
314:

Line 340: fnd_msg_pub.add;

336: x_return_status := FND_API.G_RET_STS_ERROR;
337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');
338: fnd_message.set_token('OPERATION',p_operation_seq_num);
339: fnd_message.set_token('MATERIAL',l_material);
340: fnd_msg_pub.add;
341: fnd_msg_pub.Count_And_Get(
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344: return;

Line 341: fnd_msg_pub.Count_And_Get(

337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');
338: fnd_message.set_token('OPERATION',p_operation_seq_num);
339: fnd_message.set_token('MATERIAL',l_material);
340: fnd_msg_pub.add;
341: fnd_msg_pub.Count_And_Get(
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344: return;
345: END IF;

Line 373: fnd_msg_pub.add;

369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');
370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;
374: fnd_msg_pub.Count_And_Get(
375: p_count => x_msg_count,
376: p_data => x_msg_data);
377: return;

Line 374: fnd_msg_pub.Count_And_Get(

370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;
374: fnd_msg_pub.Count_And_Get(
375: p_count => x_msg_count,
376: p_data => x_msg_data);
377: return;
378: END IF;

Line 388: fnd_msg_pub.add;

384: x_return_status := FND_API.G_RET_STS_ERROR;
385: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
386: fnd_message.set_token('OPERATION',p_operation_seq_num);
387: fnd_message.set_token('MATERIAL',l_material);
388: fnd_msg_pub.add;
389: fnd_msg_pub.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data);
392: return;

Line 389: fnd_msg_pub.Count_And_Get(

385: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
386: fnd_message.set_token('OPERATION',p_operation_seq_num);
387: fnd_message.set_token('MATERIAL',l_material);
388: fnd_msg_pub.add;
389: fnd_msg_pub.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data);
392: return;
393: end if;

Line 400: fnd_msg_pub.add;

396: x_return_status := FND_API.G_RET_STS_ERROR;
397: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
398: fnd_message.set_token('OPERATION',p_operation_seq_num);
399: fnd_message.set_token('MATERIAL',l_material);
400: fnd_msg_pub.add;
401: fnd_msg_pub.Count_And_Get(
402: p_count => x_msg_count,
403: p_data => x_msg_data);
404: return;

Line 401: fnd_msg_pub.Count_And_Get(

397: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
398: fnd_message.set_token('OPERATION',p_operation_seq_num);
399: fnd_message.set_token('MATERIAL',l_material);
400: fnd_msg_pub.add;
401: fnd_msg_pub.Count_And_Get(
402: p_count => x_msg_count,
403: p_data => x_msg_data);
404: return;
405: end if;

Line 425: fnd_msg_pub.add;

421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;
426: fnd_msg_pub.Count_And_Get(
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429: return;

Line 426: fnd_msg_pub.Count_And_Get(

422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;
426: fnd_msg_pub.Count_And_Get(
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429: return;
430: end if;

Line 453: fnd_msg_pub.add;

449: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;
454: fnd_msg_pub.Count_And_Get(
455: p_count => x_msg_count,
456: p_data => x_msg_data);
457: return;

Line 454: fnd_msg_pub.Count_And_Get(

450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;
454: fnd_msg_pub.Count_And_Get(
455: p_count => x_msg_count,
456: p_data => x_msg_data);
457: return;
458: end if;

Line 712: FND_MSG_PUB.Count_And_Get(

708: AND x_return_status = FND_API.g_RET_STS_SUCCESS THEN
709: COMMIT WORK;
710: END IF;
711: -- Standard call to get message count and if count is 1, get message info.
712: FND_MSG_PUB.Count_And_Get(
713: p_count => x_msg_count,
714: p_data => x_msg_data);
715: EXCEPTION
716: WHEN OTHERS THEN

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

718: if (l_log) then
719: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );
720: end if;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(

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

720: end if;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(
727: p_count => x_msg_count,
728: p_data => x_msg_data);

Line 726: FND_MSG_PUB.Count_And_Get(

722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
725: END IF;
726: FND_MSG_PUB.Count_And_Get(
727: p_count => x_msg_count,
728: p_data => x_msg_data);
729:
730: end Fork_Logic;

Line 776: FND_MSG_PUB.initialize;

772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: END IF;
774: -- Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean( p_init_msg_list ) THEN
776: FND_MSG_PUB.initialize;
777: END IF;
778: -- Initialize API return status to success
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:

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

828: ROLLBACK TO PROCESS_MMTT;
829: /* Fix for bug no :2719414 */
830: if(x_msg_data is not null) then
831: x_msg_count := 1 ;
832: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
833: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
835: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
836: FND_MSG_PUB.ADD;

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

829: /* Fix for bug no :2719414 */
830: if(x_msg_data is not null) then
831: x_msg_count := 1 ;
832: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
833: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
835: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
836: FND_MSG_PUB.ADD;
837: end if;

Line 836: FND_MSG_PUB.ADD;

832: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
833: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
835: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
836: FND_MSG_PUB.ADD;
837: end if;
838: end if;
839: /* end of fix for bug no:2719414 */
840: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

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

836: FND_MSG_PUB.ADD;
837: end if;
838: end if;
839: /* end of fix for bug no:2719414 */
840: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
841: return;
842: end if;
843: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
844: end if;

Line 852: FND_MSG_PUB.Count_And_Get(

848: IF FND_API.To_Boolean( p_commit ) THEN
849: COMMIT WORK;
850: END IF;
851: -- Standard call to get message count and if count is 1, get message info.
852: FND_MSG_PUB.Count_And_Get(
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855: EXCEPTION
856: /* Added for bug 4041420 - Start */

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

863: if (l_log) then
864: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');
865: end if;
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN
869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
870: END IF;
871: FND_MSG_PUB.Count_And_Get(

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

865: end if;
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN
869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
870: END IF;
871: FND_MSG_PUB.Count_And_Get(
872: p_count => x_msg_count,
873: p_data => x_msg_data);

Line 871: FND_MSG_PUB.Count_And_Get(

867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN
869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
870: END IF;
871: FND_MSG_PUB.Count_And_Get(
872: p_count => x_msg_count,
873: p_data => x_msg_data);
874: END process_mmtt;
875:

Line 1048: fnd_msg_pub.initialize;

1044: END IF;
1045:
1046: -- Initialize message list if p_init_msg_list is set to TRUE.
1047: IF fnd_api.to_boolean(p_init_msg_list) THEN
1048: fnd_msg_pub.initialize;
1049: END IF;
1050:
1051: -- Initialize API return status to success
1052: x_return_status := fnd_api.g_ret_sts_success; -- line 892

Line 1083: fnd_msg_pub.count_and_get(

1079:
1080: -- l_stmt_num := 999;
1081:
1082: -- Standard call to get message count and if count is 1, get message info.
1083: fnd_msg_pub.count_and_get(
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086: EXCEPTION
1087: WHEN fnd_api.g_exc_error THEN

Line 1090: fnd_msg_pub.count_and_get(

1086: EXCEPTION
1087: WHEN fnd_api.g_exc_error THEN
1088: ROLLBACK TO cancel_alloc_matl_del;
1089: x_return_status := fnd_api.g_ret_sts_error;
1090: fnd_msg_pub.count_and_get(
1091: -- p_encoded => FND_API.g_false
1092: p_count => x_msg_count
1093: ,p_data => x_msg_data);
1094: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1098: fnd_msg_pub.count_and_get(

1094: WHEN fnd_api.g_exc_unexpected_error THEN
1095: ROLLBACK TO cancel_alloc_matl_del;
1096: x_return_status := fnd_api.g_ret_sts_unexp_error;
1097:
1098: fnd_msg_pub.count_and_get(
1099: p_count => x_msg_count
1100: ,p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: ROLLBACK TO cancel_alloc_matl_del;

Line 1104: IF fnd_msg_pub.check_msg_level(

1100: ,p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: ROLLBACK TO cancel_alloc_matl_del;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: IF fnd_msg_pub.check_msg_level(
1105: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1107: END IF;
1108:

Line 1105: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1101: WHEN OTHERS THEN
1102: ROLLBACK TO cancel_alloc_matl_del;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: IF fnd_msg_pub.check_msg_level(
1105: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1107: END IF;
1108:
1109: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

1102: ROLLBACK TO cancel_alloc_matl_del;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: IF fnd_msg_pub.check_msg_level(
1105: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1107: END IF;
1108:
1109: fnd_msg_pub.count_and_get(p_count => x_msg_count
1110: ,p_data => x_msg_data);

Line 1109: fnd_msg_pub.count_and_get(p_count => x_msg_count

1105: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1107: END IF;
1108:
1109: fnd_msg_pub.count_and_get(p_count => x_msg_count
1110: ,p_data => x_msg_data);
1111:
1112:
1113:

Line 1183: fnd_msg_pub.initialize;

1179: END IF;
1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE.
1182: IF fnd_api.to_boolean(p_init_msg_list) THEN
1183: fnd_msg_pub.initialize;
1184: END IF;
1185:
1186: -- Initialize API return status to success
1187: x_return_status := fnd_api.g_ret_sts_success;

Line 1341: fnd_msg_pub.count_and_get(

1337:
1338: -- l_stmt_num := 999;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: fnd_msg_pub.count_and_get(
1342: p_count => x_msg_count
1343: ,p_data => x_msg_data);
1344: EXCEPTION
1345: WHEN fnd_api.g_exc_error THEN

Line 1348: fnd_msg_pub.count_and_get(

1344: EXCEPTION
1345: WHEN fnd_api.g_exc_error THEN
1346: ROLLBACK TO comp_alloc_chng_qty;
1347: x_return_status := fnd_api.g_ret_sts_error;
1348: fnd_msg_pub.count_and_get(
1349: -- p_encoded => FND_API.g_false
1350: p_count => x_msg_count
1351: ,p_data => x_msg_data);
1352: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1356: fnd_msg_pub.count_and_get(

1352: WHEN fnd_api.g_exc_unexpected_error THEN
1353: ROLLBACK TO comp_alloc_chng_qty;
1354: x_return_status := fnd_api.g_ret_sts_unexp_error;
1355:
1356: fnd_msg_pub.count_and_get(
1357: p_count => x_msg_count
1358: ,p_data => x_msg_data);
1359: WHEN OTHERS THEN
1360: ROLLBACK TO comp_alloc_chng_qty;

Line 1362: IF fnd_msg_pub.check_msg_level(

1358: ,p_data => x_msg_data);
1359: WHEN OTHERS THEN
1360: ROLLBACK TO comp_alloc_chng_qty;
1361: x_return_status := fnd_api.g_ret_sts_unexp_error;
1362: IF fnd_msg_pub.check_msg_level(
1363: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1364: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1365: END IF;
1366:

Line 1363: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1359: WHEN OTHERS THEN
1360: ROLLBACK TO comp_alloc_chng_qty;
1361: x_return_status := fnd_api.g_ret_sts_unexp_error;
1362: IF fnd_msg_pub.check_msg_level(
1363: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1364: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1365: END IF;
1366:
1367: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

1360: ROLLBACK TO comp_alloc_chng_qty;
1361: x_return_status := fnd_api.g_ret_sts_unexp_error;
1362: IF fnd_msg_pub.check_msg_level(
1363: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1364: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1365: END IF;
1366:
1367: fnd_msg_pub.count_and_get(p_count => x_msg_count
1368: ,p_data => x_msg_data);

Line 1367: fnd_msg_pub.count_and_get(p_count => x_msg_count

1363: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1364: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1365: END IF;
1366:
1367: fnd_msg_pub.count_and_get(p_count => x_msg_count
1368: ,p_data => x_msg_data);
1369:
1370:
1371:

Line 1430: fnd_msg_pub.initialize;

1426: END IF;
1427:
1428: -- Initialize message list if p_init_msg_list is set to TRUE.
1429: IF fnd_api.to_boolean(p_init_msg_list) THEN
1430: fnd_msg_pub.initialize;
1431: END IF;
1432:
1433: -- Initialize API return status to success
1434: x_return_status := fnd_api.g_ret_sts_success;

Line 1522: fnd_msg_pub.count_and_get(

1518:
1519: -- l_stmt_num := 999;
1520:
1521: -- Standard call to get message count and if count is 1, get message info.
1522: fnd_msg_pub.count_and_get(
1523: p_count => x_msg_count
1524: ,p_data => x_msg_data);
1525: EXCEPTION
1526: WHEN fnd_api.g_exc_error THEN

Line 1529: fnd_msg_pub.count_and_get(

1525: EXCEPTION
1526: WHEN fnd_api.g_exc_error THEN
1527: ROLLBACK TO comp_alloc_new_mat;
1528: x_return_status := fnd_api.g_ret_sts_error;
1529: fnd_msg_pub.count_and_get(
1530: -- p_encoded => FND_API.g_false
1531: p_count => x_msg_count
1532: ,p_data => x_msg_data);
1533: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1537: fnd_msg_pub.count_and_get(

1533: WHEN fnd_api.g_exc_unexpected_error THEN
1534: ROLLBACK TO comp_alloc_new_mat;
1535: x_return_status := fnd_api.g_ret_sts_unexp_error;
1536:
1537: fnd_msg_pub.count_and_get(
1538: p_count => x_msg_count
1539: ,p_data => x_msg_data);
1540: WHEN OTHERS THEN
1541: ROLLBACK TO comp_alloc_new_mat;

Line 1543: IF fnd_msg_pub.check_msg_level(

1539: ,p_data => x_msg_data);
1540: WHEN OTHERS THEN
1541: ROLLBACK TO comp_alloc_new_mat;
1542: x_return_status := fnd_api.g_ret_sts_unexp_error;
1543: IF fnd_msg_pub.check_msg_level(
1544: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1545: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1546: END IF;
1547:

Line 1544: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1540: WHEN OTHERS THEN
1541: ROLLBACK TO comp_alloc_new_mat;
1542: x_return_status := fnd_api.g_ret_sts_unexp_error;
1543: IF fnd_msg_pub.check_msg_level(
1544: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1545: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1546: END IF;
1547:
1548: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

1541: ROLLBACK TO comp_alloc_new_mat;
1542: x_return_status := fnd_api.g_ret_sts_unexp_error;
1543: IF fnd_msg_pub.check_msg_level(
1544: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1545: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1546: END IF;
1547:
1548: fnd_msg_pub.count_and_get(p_count => x_msg_count
1549: ,p_data => x_msg_data);

Line 1548: fnd_msg_pub.count_and_get(p_count => x_msg_count

1544: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1545: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1546: END IF;
1547:
1548: fnd_msg_pub.count_and_get(p_count => x_msg_count
1549: ,p_data => x_msg_data);
1550:
1551: END comp_alloc_new_mat;
1552:

Line 1608: fnd_msg_pub.initialize;

1604: END IF;
1605:
1606: -- Initialize message list if p_init_msg_list is set to TRUE.
1607: IF fnd_api.to_boolean(p_init_msg_list) THEN
1608: fnd_msg_pub.initialize;
1609: END IF;
1610:
1611: -- Initialize API return status to success
1612: x_return_status := fnd_api.g_ret_sts_success;

Line 1697: fnd_msg_pub.count_and_get(

1693:
1694: -- Standard call to get message count and if count is 1, get message info.
1695: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
1696: end if;
1697: fnd_msg_pub.count_and_get(
1698: p_count => x_msg_count
1699: ,p_data => x_msg_data);
1700: EXCEPTION
1701: WHEN fnd_api.g_exc_error THEN

Line 1704: fnd_msg_pub.count_and_get(

1700: EXCEPTION
1701: WHEN fnd_api.g_exc_error THEN
1702: ROLLBACK TO alloc_at_release_cancel;
1703: x_return_status := fnd_api.g_ret_sts_error;
1704: fnd_msg_pub.count_and_get(
1705: -- p_encoded => FND_API.g_false
1706: p_count => x_msg_count
1707: ,p_data => x_msg_data);
1708: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1712: fnd_msg_pub.count_and_get(

1708: WHEN fnd_api.g_exc_unexpected_error THEN
1709: ROLLBACK TO alloc_at_release_cancel;
1710: x_return_status := fnd_api.g_ret_sts_unexp_error;
1711:
1712: fnd_msg_pub.count_and_get(
1713: p_count => x_msg_count
1714: ,p_data => x_msg_data);
1715: WHEN OTHERS THEN
1716: ROLLBACK TO alloc_at_release_cancel;

Line 1718: IF fnd_msg_pub.check_msg_level(

1714: ,p_data => x_msg_data);
1715: WHEN OTHERS THEN
1716: ROLLBACK TO alloc_at_release_cancel;
1717: x_return_status := fnd_api.g_ret_sts_unexp_error;
1718: IF fnd_msg_pub.check_msg_level(
1719: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1720: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1721: END IF;
1722:

Line 1719: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1715: WHEN OTHERS THEN
1716: ROLLBACK TO alloc_at_release_cancel;
1717: x_return_status := fnd_api.g_ret_sts_unexp_error;
1718: IF fnd_msg_pub.check_msg_level(
1719: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1720: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1721: END IF;
1722:
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

1716: ROLLBACK TO alloc_at_release_cancel;
1717: x_return_status := fnd_api.g_ret_sts_unexp_error;
1718: IF fnd_msg_pub.check_msg_level(
1719: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1720: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1721: END IF;
1722:
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count
1724: ,p_data => x_msg_data);

Line 1723: fnd_msg_pub.count_and_get(p_count => x_msg_count

1719: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1720: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1721: END IF;
1722:
1723: fnd_msg_pub.count_and_get(p_count => x_msg_count
1724: ,p_data => x_msg_data);
1725:
1726: END alloc_at_release_cancel;
1727: