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.AHL_MM_MTL_MGT_PVT dependencies on FND_MSG_PUB

Line 229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;

Line 235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
234: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
236: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
237:
238: WHEN OTHERS THEN
239: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;

Line 241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

237:
238: WHEN OTHERS THEN
239: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
243: END IF;
244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
245: P_COUNT => X_MSG_COUNT,

Line 242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

238: WHEN OTHERS THEN
239: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
243: END IF;
244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
245: P_COUNT => X_MSG_COUNT,
246: P_DATA => X_MSG_DATA);

Line 244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
243: END IF;
244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
245: P_COUNT => X_MSG_COUNT,
246: P_DATA => X_MSG_DATA);
247:
248: END CHECK_AVAILABILITY;

Line 384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
389: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
391: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
392:
393: WHEN OTHERS THEN
394: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

392:
393: WHEN OTHERS THEN
394: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
398: END IF;
399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
400: P_COUNT => X_MSG_COUNT,

Line 397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

393: WHEN OTHERS THEN
394: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
398: END IF;
399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
400: P_COUNT => X_MSG_COUNT,
401: P_DATA => X_MSG_DATA);

Line 399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
398: END IF;
399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
400: P_COUNT => X_MSG_COUNT,
401: P_DATA => X_MSG_DATA);
402: END SCHEDULE_MATERIALS;
403: ---------------------------------------------------------------------------------------------------------

Line 493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
498: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
500: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
501:
502: WHEN OTHERS THEN
503: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

501:
502: WHEN OTHERS THEN
503: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
507: END IF;
508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
509: P_COUNT => X_MSG_COUNT,

Line 506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

502: WHEN OTHERS THEN
503: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
507: END IF;
508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
509: P_COUNT => X_MSG_COUNT,
510: P_DATA => X_MSG_DATA);

Line 508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
507: END IF;
508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
509: P_COUNT => X_MSG_COUNT,
510: P_DATA => X_MSG_DATA);
511: END Schedule_Visit_Materials;
512:

Line 757: FND_MSG_PUB.add;

753: 'The demand is not AOG');
754: END IF;
755:
756: FND_MESSAGE.set_name('AHL','AHL_MM_NO_MO_AOG');
757: FND_MSG_PUB.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761: --Throw error when demand location is not defined

Line 769: FND_MSG_PUB.add;

765: 'Visit Locator is not defined to create move order');
766: END IF;
767:
768: FND_MESSAGE.set_name('AHL','AHL_MM_NO_LOCATOR');
769: FND_MSG_PUB.add;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:
773: --Throw error if supply and demand locators are same

Line 778: FND_MSG_PUB.add;

774: FOR i in p_supply_tbl_type.FIRST .. p_supply_tbl_type.LAST
775: LOOP
776: IF (p_supply_tbl_type(i).Supply_Locator_Id = l_dmd_loc_id) THEN
777: FND_MESSAGE.set_name('AHL','AHL_MM_SAME_LOCATOR');
778: FND_MSG_PUB.add;
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: END LOOP;
782:

Line 1120: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1116: COMMIT;
1117: END IF;
1118:
1119: -- Count and Get messages
1120: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);
1123:
1124: IF (l_log_procedure >= l_log_current_level) THEN

Line 1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;

Line 1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO CREATE_MOVE_ORDER_SP;

Line 1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1141: p_data => x_msg_data);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
1147: END IF;
1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,

Line 1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);

1142: WHEN OTHERS THEN
1143: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
1147: END IF;
1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);

Line 1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
1147: END IF;
1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: END CREATE_MOVE_ORDER;

Line 1216: FND_MSG_PUB.Initialize;

1212: -- Standard start of API savepoint
1213: SAVEPOINT FLAG_REQUIREMENTS_SP;
1214:
1215: --Initialize error message stack by default
1216: FND_MSG_PUB.Initialize;
1217:
1218: FND_FILE.put_line(FND_FILE.log, 'At the start of the PLSQL procedure UPDATE_REQUIREMENTS_FOR_GOP');
1219:
1220: --Get the profile value

Line 1380: l_msg_count := Fnd_Msg_Pub.count_msg;

1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1379: retcode := 2;
1380: l_msg_count := Fnd_Msg_Pub.count_msg;
1381:
1382: IF (l_msg_count > 0) THEN
1383: FOR i IN 1..l_msg_count
1384: LOOP

Line 1385: fnd_msg_pub.get( p_msg_index => i,

1381:
1382: IF (l_msg_count > 0) THEN
1383: FOR i IN 1..l_msg_count
1384: LOOP
1385: fnd_msg_pub.get( p_msg_index => i,
1386: p_encoded => FND_API.G_FALSE,
1387: p_data => l_err_msg,
1388: p_msg_index_out => l_msg_index_out);
1389:

Line 1397: l_msg_count := Fnd_Msg_Pub.count_msg;

1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1396: retcode := 2;
1397: l_msg_count := Fnd_Msg_Pub.count_msg;
1398:
1399: IF (l_msg_count > 0) THEN
1400: FOR i IN 1..l_msg_count
1401: LOOP

Line 1402: fnd_msg_pub.get( p_msg_index => i,

1398:
1399: IF (l_msg_count > 0) THEN
1400: FOR i IN 1..l_msg_count
1401: LOOP
1402: fnd_msg_pub.get( p_msg_index => i,
1403: p_encoded => FND_API.G_FALSE,
1404: p_data => l_err_msg,
1405: p_msg_index_out => l_msg_index_out);
1406:

Line 1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1410:
1411: WHEN OTHERS THEN
1412: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1413: retcode := 2;
1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1416: p_procedure_name => 'UPDATE_REQUIREMENTS_FOR_GOP',
1417: p_error_text => SUBSTR(SQLERRM,1,500));
1418: END IF;

Line 1415: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1411: WHEN OTHERS THEN
1412: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1413: retcode := 2;
1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1416: p_procedure_name => 'UPDATE_REQUIREMENTS_FOR_GOP',
1417: p_error_text => SUBSTR(SQLERRM,1,500));
1418: END IF;
1419:

Line 1420: l_msg_count := Fnd_Msg_Pub.count_msg;

1416: p_procedure_name => 'UPDATE_REQUIREMENTS_FOR_GOP',
1417: p_error_text => SUBSTR(SQLERRM,1,500));
1418: END IF;
1419:
1420: l_msg_count := Fnd_Msg_Pub.count_msg;
1421: IF (l_msg_count > 0) THEN
1422: FOR i IN 1..l_msg_count
1423: LOOP
1424: fnd_msg_pub.get( p_msg_index => i,

Line 1424: fnd_msg_pub.get( p_msg_index => i,

1420: l_msg_count := Fnd_Msg_Pub.count_msg;
1421: IF (l_msg_count > 0) THEN
1422: FOR i IN 1..l_msg_count
1423: LOOP
1424: fnd_msg_pub.get( p_msg_index => i,
1425: p_encoded => FND_API.G_FALSE,
1426: p_data => l_err_msg,
1427: p_msg_index_out => l_msg_index_out);
1428:

Line 1493: FND_MSG_PUB.initialize;

1489: SAVEPOINT Invoke_AOG_Upd_Notification;
1490: -- Initialize message list if p_init_msg_list is set to TRUE.
1491: IF FND_API.to_boolean(p_init_msg_list)
1492: THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.

Line 1638: l_msg_count := Fnd_Msg_Pub.count_msg;

1634: RETURN;
1635: END IF;
1636: END LOOP;
1637:
1638: l_msg_count := Fnd_Msg_Pub.count_msg;
1639: -- Check the return status of API call.
1640: IF (l_return_status <> 'S' OR l_msg_count > 0) THEN
1641: x_msg_count := l_msg_count;
1642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1649: EXCEPTION
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: ROLLBACK TO Invoke_AOG_Upd_Notification;
1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;

Line 1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;
1658: X_return_status := FND_API.G_RET_STS_ERROR;
1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => X_msg_data);
1662: WHEN OTHERS THEN
1663: ROLLBACK TO Invoke_AOG_Upd_Notification;

Line 1665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1661: p_data => X_msg_data);
1662: WHEN OTHERS THEN
1663: ROLLBACK TO Invoke_AOG_Upd_Notification;
1664: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1666: THEN
1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1668: p_procedure_name => 'Invoke_AOG_Upd_Notification',
1669: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1663: ROLLBACK TO Invoke_AOG_Upd_Notification;
1664: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1666: THEN
1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1668: p_procedure_name => 'Invoke_AOG_Upd_Notification',
1669: p_error_text => SUBSTR(SQLERRM,1,240));
1670: END IF;
1671: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1671: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1668: p_procedure_name => 'Invoke_AOG_Upd_Notification',
1669: p_error_text => SUBSTR(SQLERRM,1,240));
1670: END IF;
1671: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1672: p_count => x_msg_count,
1673: p_data => X_msg_data);
1674: END Invoke_AOG_Upd_Notification;
1675:

Line 1912: FND_MSG_PUB.ADD;

1908: END IF;
1909:
1910: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_INVLD_ITEM_FOR_ISO');
1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );
1912: FND_MSG_PUB.ADD;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: P_DATA => X_MSG_DATA,
1915: p_encoded => fnd_api.g_false);
1916: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1909:
1910: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_INVLD_ITEM_FOR_ISO');
1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );
1912: FND_MSG_PUB.ADD;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: P_DATA => X_MSG_DATA,
1915: p_encoded => fnd_api.g_false);
1916: X_RETURN_STATUS := G_RET_STS_ERROR;
1917: WHEN OTHERS THEN

Line 2053: Fnd_Msg_Pub.initialize;

2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;
2055: x_return_status := G_RET_STS_SUCCESS;
2056:
2057: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 2551: FND_MSG_PUB.ADD;

2547: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2548: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_CUST_ASSOC block, Internal customer not defined or not associated to internal location');
2549: END IF;
2550: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_NO_CUST_ASSOC');
2551: FND_MSG_PUB.ADD;
2552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2553: P_DATA => X_MSG_DATA,
2554: P_ENCODED => FND_API.G_FALSE);
2555: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2548: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_CUST_ASSOC block, Internal customer not defined or not associated to internal location');
2549: END IF;
2550: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_NO_CUST_ASSOC');
2551: FND_MSG_PUB.ADD;
2552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2553: P_DATA => X_MSG_DATA,
2554: P_ENCODED => FND_API.G_FALSE);
2555: X_RETURN_STATUS := G_RET_STS_ERROR;
2556:

Line 2562: FND_MSG_PUB.ADD;

2558: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2559: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_SHIPPING_NETWORK block, Shipping network not defined for the org.');
2560: END IF;
2561: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_SHIPPING_NETWORK');
2562: FND_MSG_PUB.ADD;
2563: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2564: P_DATA => X_MSG_DATA,
2565: P_ENCODED => FND_API.G_FALSE);
2566: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2563: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2559: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_SHIPPING_NETWORK block, Shipping network not defined for the org.');
2560: END IF;
2561: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_SHIPPING_NETWORK');
2562: FND_MSG_PUB.ADD;
2563: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2564: P_DATA => X_MSG_DATA,
2565: P_ENCODED => FND_API.G_FALSE);
2566: X_RETURN_STATUS := G_RET_STS_ERROR;
2567:

Line 2573: FND_MSG_PUB.ADD;

2569: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2570: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_ISO_ENABLED_NETWORK block, Internal Order Enabled flag not selected');
2571: END IF;
2572: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_ISO_ENABLED_NETWORK');
2573: FND_MSG_PUB.ADD;
2574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2575: P_DATA => X_MSG_DATA,
2576: P_ENCODED => FND_API.G_FALSE);
2577: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2570: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_ISO_ENABLED_NETWORK block, Internal Order Enabled flag not selected');
2571: END IF;
2572: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_ISO_ENABLED_NETWORK');
2573: FND_MSG_PUB.ADD;
2574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2575: P_DATA => X_MSG_DATA,
2576: P_ENCODED => FND_API.G_FALSE);
2577: X_RETURN_STATUS := G_RET_STS_ERROR;
2578:

Line 2584: FND_MSG_PUB.ADD;

2580: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2581: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_IR_EXC block, add error message AHL_MM_IR_CREATION_ERR');
2582: END IF;
2583: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_CREATION_ERR');
2584: FND_MSG_PUB.ADD;
2585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2586: P_DATA => X_MSG_DATA,
2587: p_encoded => fnd_api.g_false);
2588: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2581: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_IR_EXC block, add error message AHL_MM_IR_CREATION_ERR');
2582: END IF;
2583: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_CREATION_ERR');
2584: FND_MSG_PUB.ADD;
2585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2586: P_DATA => X_MSG_DATA,
2587: p_encoded => fnd_api.g_false);
2588: X_RETURN_STATUS := G_RET_STS_ERROR;
2589: --rollback to RELEASE_SALESORDER;

Line 2596: FND_MSG_PUB.ADD;

2592: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2593: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_ISO_EXC block, add error message AHL_MM_ISO_CREATION_ERR');
2594: END IF;
2595: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_ISO_CREATION_ERR');
2596: FND_MSG_PUB.ADD;
2597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2598: P_DATA => X_MSG_DATA,
2599: p_encoded => fnd_api.g_false);
2600: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2593: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_ISO_EXC block, add error message AHL_MM_ISO_CREATION_ERR');
2594: END IF;
2595: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_ISO_CREATION_ERR');
2596: FND_MSG_PUB.ADD;
2597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2598: P_DATA => X_MSG_DATA,
2599: p_encoded => fnd_api.g_false);
2600: X_RETURN_STATUS := G_RET_STS_ERROR;
2601: --rollback to RELEASE_SALESORDER;

Line 2611: FND_MSG_PUB.ADD;

2607: END IF;
2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');
2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2613: P_DATA => X_MSG_DATA,
2614: p_encoded => fnd_api.g_false);
2615: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');
2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2613: P_DATA => X_MSG_DATA,
2614: p_encoded => fnd_api.g_false);
2615: X_RETURN_STATUS := G_RET_STS_ERROR;
2616: --rollback to CREATE_IR_RESERVATION;

Line 2627: FND_MSG_PUB.ADD;

2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2629: P_DATA => X_MSG_DATA,
2630: p_encoded => fnd_api.g_false);
2631: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2629: P_DATA => X_MSG_DATA,
2630: p_encoded => fnd_api.g_false);
2631: X_RETURN_STATUS := G_RET_STS_ERROR;
2632: --rollback to PERFORM_PICK_RELEASE;

Line 2636: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

2632: --rollback to PERFORM_PICK_RELEASE;
2633:
2634: when OTHERS then
2635: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_UNKNOWN_ERR');
2636: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2637: X_RETURN_STATUS := G_RET_STS_ERROR;
2638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2639: P_DATA => X_MSG_DATA,
2640: p_encoded => fnd_api.g_false);

Line 2638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2634: when OTHERS then
2635: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_UNKNOWN_ERR');
2636: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2637: X_RETURN_STATUS := G_RET_STS_ERROR;
2638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2639: P_DATA => X_MSG_DATA,
2640: p_encoded => fnd_api.g_false);
2641: --rollback to PERFORM_PICK_RELEASE;
2642: --rollback to CREATE_IR_RESERVATION;

Line 2732: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

2728: EXCEPTION
2729: WHEN fnd_api.g_exc_error
2730: THEN
2731: x_return_status := G_RET_STS_ERROR;
2732: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
2733: p_data => x_msg_data);
2734:
2735: --commit;
2736:

Line 3058: fnd_msg_pub.initialize;

3054: END IF;
3055:
3056: IF fnd_api.to_boolean(p_init_msg_list)
3057: THEN
3058: fnd_msg_pub.initialize;
3059: END IF;
3060:
3061: x_return_status := G_RET_STS_SUCCESS;
3062:

Line 3640: FND_MSG_PUB.ADD;

3636: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_PICK_RULE exception');
3637: end if;
3638: FND_MESSAGE.SET_NAME('AHL', 'AHL_PICKING_RULE_ID_INV');
3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );
3640: FND_MSG_PUB.ADD;
3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3642: p_data => x_msg_data,
3643: p_encoded => fnd_api.g_false);
3644: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3637: end if;
3638: FND_MESSAGE.SET_NAME('AHL', 'AHL_PICKING_RULE_ID_INV');
3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );
3640: FND_MSG_PUB.ADD;
3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3642: p_data => x_msg_data,
3643: p_encoded => fnd_api.g_false);
3644: X_RETURN_STATUS := G_RET_STS_ERROR;
3645: rollback to RELEASE_SALESORDER;

Line 3651: FND_MSG_PUB.ADD;

3647: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3648: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_DELIVERY_DETAIL exception');
3649: end if;
3650: FND_MESSAGE.SET_NAME('AHL', 'AHL_INVLD_DELIVERY_DETAILS');
3651: FND_MSG_PUB.ADD;
3652: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3653: p_data => x_msg_data,
3654: p_encoded => fnd_api.g_false);
3655: X_RETURN_STATUS := G_RET_STS_ERROR;

Line 3652: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3648: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_DELIVERY_DETAIL exception');
3649: end if;
3650: FND_MESSAGE.SET_NAME('AHL', 'AHL_INVLD_DELIVERY_DETAILS');
3651: FND_MSG_PUB.ADD;
3652: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3653: p_data => x_msg_data,
3654: p_encoded => fnd_api.g_false);
3655: X_RETURN_STATUS := G_RET_STS_ERROR;
3656: ROLLBACK TO RELEASE_SALESORDER;

Line 3662: FND_MSG_PUB.ADD;

3658: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3659: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In create_batch exception');
3660: end if;
3661: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_CRT_BTCH_FAIL');
3662: FND_MSG_PUB.ADD;
3663: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3664: p_data => x_msg_data,
3665: p_encoded => fnd_api.g_false);
3666: x_return_status := G_RET_STS_ERROR;

Line 3663: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3659: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In create_batch exception');
3660: end if;
3661: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_CRT_BTCH_FAIL');
3662: FND_MSG_PUB.ADD;
3663: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3664: p_data => x_msg_data,
3665: p_encoded => fnd_api.g_false);
3666: x_return_status := G_RET_STS_ERROR;
3667: ROLLBACK TO RELEASE_SALESORDER;

Line 3673: fnd_msg_pub.add;

3669: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3670: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In release_batch exception');
3671: end if;
3672: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_REL_BTCH_FAIL');
3673: fnd_msg_pub.add;
3674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3675: P_DATA => X_MSG_DATA,
3676: p_encoded => fnd_api.g_false);
3677: x_return_status := G_RET_STS_ERROR;

Line 3674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3670: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In release_batch exception');
3671: end if;
3672: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_REL_BTCH_FAIL');
3673: fnd_msg_pub.add;
3674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3675: P_DATA => X_MSG_DATA,
3676: p_encoded => fnd_api.g_false);
3677: x_return_status := G_RET_STS_ERROR;
3678: ROLLBACK TO RELEASE_SALESORDER;

Line 3684: fnd_msg_pub.add;

3680: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
3681: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In allocation_error exception');
3682: END IF;
3683: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_ALOC_FAIL');
3684: fnd_msg_pub.add;
3685: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3686: P_DATA => X_MSG_DATA,
3687: p_encoded => fnd_api.g_false);
3688: x_return_status := G_RET_STS_ERROR;

Line 3685: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3681: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In allocation_error exception');
3682: END IF;
3683: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_ALOC_FAIL');
3684: fnd_msg_pub.add;
3685: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3686: P_DATA => X_MSG_DATA,
3687: p_encoded => fnd_api.g_false);
3688: x_return_status := G_RET_STS_ERROR;
3689: ROLLBACK TO RELEASE_SALESORDER;

Line 3694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3690: WHEN NO_DATA_FOUND THEN
3691: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
3692: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In NO_DATA_FOUND exception');
3693: END IF;
3694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3695: P_DATA => X_MSG_DATA,
3696: p_encoded => fnd_api.g_false);
3697: X_RETURN_STATUS := G_RET_STS_ERROR;
3698: ROLLBACK TO RELEASE_SALESORDER;

Line 3703: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

3699: WHEN OTHERS THEN
3700: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
3701: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In OTHERS exception');
3702: END IF;
3703: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3704: P_DATA => X_MSG_DATA,
3705: p_encoded => fnd_api.g_false);
3706: X_RETURN_STATUS := G_RET_STS_ERROR;
3707: ROLLBACK TO RELEASE_SALESORDER;

Line 3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;

Line 3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3835: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3837: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3838:
3839: WHEN OTHERS THEN
3840: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;

Line 3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3838:
3839: WHEN OTHERS THEN
3840: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3844: END IF;
3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3846: P_COUNT => X_MSG_COUNT,

Line 3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

3839: WHEN OTHERS THEN
3840: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3844: END IF;
3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3846: P_COUNT => X_MSG_COUNT,
3847: P_DATA => X_MSG_DATA);

Line 3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3844: END IF;
3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3846: P_COUNT => X_MSG_COUNT,
3847: P_DATA => X_MSG_DATA);
3848:
3849: END AOG_UPD_NOTIFICATION;

Line 3929: FND_MSG_PUB.ADD;

3925: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
3926: WHERE SCHEDULED_MATERIAL_ID = P_AOG_TBL(I).SCHEDULE_MATERIAL_ID AND OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER;
3927: IF SQL%ROWCOUNT=0 THEN
3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3929: FND_MSG_PUB.ADD;
3930: RAISE FND_API.G_EXC_ERROR;
3931: END IF;
3932: END IF;
3933: END IF;

Line 3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: ROLLBACK TO MM_UPDATE_AOG_SP;
3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;

Line 3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;
3964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3966: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3967:
3968: WHEN OTHERS THEN
3969: ROLLBACK TO MM_UPDATE_AOG_SP;

Line 3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3967:
3968: WHEN OTHERS THEN
3969: ROLLBACK TO MM_UPDATE_AOG_SP;
3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3973: END IF;
3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3975: P_COUNT => X_MSG_COUNT,

Line 3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

3968: WHEN OTHERS THEN
3969: ROLLBACK TO MM_UPDATE_AOG_SP;
3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3973: END IF;
3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3975: P_COUNT => X_MSG_COUNT,
3976: P_DATA => X_MSG_DATA);

Line 3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3973: END IF;
3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3975: P_COUNT => X_MSG_COUNT,
3976: P_DATA => X_MSG_DATA);
3977:
3978: END UPDATE_AOG;

Line 4128: FND_MSG_PUB.Initialize;

4124: x_return_status := FND_API.G_RET_STS_SUCCESS;
4125:
4126: -- Initialize message list if p_init_msg_list is set to TRUE
4127: IF FND_API.To_Boolean(p_init_msg_list) THEN
4128: FND_MSG_PUB.Initialize;
4129: END IF;
4130:
4131: -- Standard start of API savepoint
4132: SAVEPOINT Perform_Inter_Org_Transfer;

Line 4141: FND_MSG_PUB.ADD;

4137: THEN
4138: G_DEBUG_LINE_NUM := 17;
4139: x_return_status := FND_API.G_RET_STS_ERROR;
4140: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4144: THEN
4145: G_DEBUG_LINE_NUM := 19;

Line 4148: FND_MSG_PUB.ADD;

4144: THEN
4145: G_DEBUG_LINE_NUM := 19;
4146: x_return_status := FND_API.G_RET_STS_ERROR;
4147: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4148: FND_MSG_PUB.ADD;
4149: RAISE FND_API.G_EXC_ERROR;
4150: END IF;
4151:
4152: G_DEBUG_LINE_NUM := 20;

Line 4321: --FND_MSG_PUB.ADD;

4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;
4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');
4320: --FND_MESSAGE.Set_Token('MSG','Material transfer is completed and reservation made');
4321: --FND_MSG_PUB.ADD;
4322: --FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Number of reservations = ' || l_reservation_id_tbl.COUNT);
4323: IF(l_reservation_id_tbl.COUNT > 0) THEN
4324: FOR i IN l_reservation_id_tbl.FIRST..l_reservation_id_tbl.LAST LOOP
4325: IF (l_log_statement >= l_log_current_level) THEN

Line 4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4348: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4349:
4350: END IF;
4351: ROLLBACK TO Perform_Inter_Org_Transfer;
4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4355: IF (l_log_error >= l_log_current_level) THEN
4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);

Line 4360: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4357: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4358: END IF;
4359: ROLLBACK TO Perform_Inter_Org_Transfer;
4360: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4361: WHEN OTHERS THEN
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF (l_log_exception >= l_log_current_level) THEN
4364: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);

Line 4368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer', p_error_text => SQLERRM);

4364: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4365: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4366: END IF;
4367: ROLLBACK TO Perform_Inter_Org_Transfer;
4368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer', p_error_text => SQLERRM);
4369: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4370: END;
4371: ------------------------------------------------------------------------------------------------------
4372: --------------------------------------------------------------------------------------------------------------------------------------

Line 4369: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4365: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4366: END IF;
4367: ROLLBACK TO Perform_Inter_Org_Transfer;
4368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer', p_error_text => SQLERRM);
4369: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4370: END;
4371: ------------------------------------------------------------------------------------------------------
4372: --------------------------------------------------------------------------------------------------------------------------------------
4373: -- Define Private APIs --

Line 4482: FND_MSG_PUB.Initialize;

4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: END IF;
4480: -- Initialize message list if p_init_msg_list is set to TRUE
4481: IF FND_API.To_Boolean(p_init_msg_list) THEN
4482: FND_MSG_PUB.Initialize;
4483: END IF;
4484: -- Initialize API return status to success
4485: x_return_status := FND_API.G_RET_STS_SUCCESS;
4486: -- Initialize shipping id table to null

Line 4494: FND_MSG_PUB.ADD;

4490: THEN
4491: G_DEBUG_LINE_NUM := 107;
4492: x_return_status := FND_API.G_RET_STS_ERROR;
4493: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4497: THEN
4498: G_DEBUG_LINE_NUM := 109;

Line 4501: FND_MSG_PUB.ADD;

4497: THEN
4498: G_DEBUG_LINE_NUM := 109;
4499: x_return_status := FND_API.G_RET_STS_ERROR;
4500: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: END IF;
4504:
4505: IF (p_x_mtltfr_tbl.COUNT > 0) THEN

Line 4705: FND_MSG_PUB.ADD;

4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);
4705: FND_MSG_PUB.ADD;
4706: l_error := true;
4707: END IF;
4708: CLOSE Transaction_Error_Cur;
4709: END LOOP;

Line 4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4719: EXCEPTION
4720: WHEN FND_API.G_EXC_ERROR THEN
4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);

Line 4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);

4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);
4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4733: END Perform_Inter_Org_Transfer_Inv;
4734: ------------------------------------------------------------------------------------------------------------
4735: PROCEDURE Insert_Material

Line 4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);
4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4733: END Perform_Inter_Org_Transfer_Inv;
4734: ------------------------------------------------------------------------------------------------------------
4735: PROCEDURE Insert_Material
4736: (

Line 5133: FND_MSG_PUB.ADD;

5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;
5134: RAISE FND_API.G_EXC_ERROR;
5135: END Insert_Material;
5136: ------------------------------------------------------------------------------------------------------------
5137: PROCEDURE Validate_Record

Line 5279: FND_MSG_PUB.ADD;

5275: -- Quantity validation
5276: IF(NVL(p_x_mtltfr_rec.quantity,0) <= 0) THEN
5277: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
5278: FND_MESSAGE.Set_Token('QUANTITY',p_x_mtltfr_rec.quantity);
5279: FND_MSG_PUB.ADD;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: END IF;
5282: G_DEBUG_LINE_NUM := 320;
5283: IF (l_log_statement >= l_log_current_level) THEN

Line 5304: FND_MSG_PUB.ADD;

5300: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item/Destination Org combination is invalid');
5301: END IF;
5302: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
5303: FND_MESSAGE.Set_Token('FIELD',NVL(l_concatenated_segments, p_x_mtltfr_rec.Inventory_Item_Id));
5304: FND_MSG_PUB.ADD;
5305: x_return_status := FND_API.G_RET_STS_ERROR;
5306: END IF;
5307: CLOSE ITEM_VALID_CUR_DEST;
5308: ELSE

Line 5319: FND_MSG_PUB.ADD;

5315: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Source Org is null');
5316: END IF;
5317: FND_MESSAGE.Set_Name('AHL','AHL_MM_SOURCE_ORG_NULL');
5318: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5319: FND_MSG_PUB.ADD;
5320: x_return_status := FND_API.G_RET_STS_ERROR;
5321: END IF;
5322: IF p_x_mtltfr_rec.dest_org_id IS NULL THEN
5323: G_DEBUG_LINE_NUM := 350;

Line 5329: FND_MSG_PUB.ADD;

5325: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Destination Org is null');
5326: END IF;
5327: FND_MESSAGE.Set_Name('AHL','AHL_MM_DEST_ORG_NULL');
5328: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5329: FND_MSG_PUB.ADD;
5330: x_return_status := FND_API.G_RET_STS_ERROR;
5331: END IF;
5332: END IF;
5333: G_DEBUG_LINE_NUM := 352;

Line 5343: FND_MSG_PUB.ADD;

5339: IF (l_log_statement >= l_log_current_level) THEN
5340: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is null');
5341: END IF;
5342: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');
5343: FND_MSG_PUB.ADD;
5344: x_return_status := FND_API.G_RET_STS_ERROR;
5345: END IF;
5346:
5347: IF (l_log_statement >= l_log_current_level) THEN

Line 5358: FND_MSG_PUB.ADD;

5354: IF (l_log_statement >= l_log_current_level) THEN
5355: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item serial is NULL. Can not be transfered');
5356: END IF;
5357: FND_MESSAGE.Set_Name('AHL','AHL_MM_SERIAL_NULL');
5358: FND_MSG_PUB.ADD;
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360: ELSE
5361: IF (p_x_mtltfr_rec.Serial_Number IS NOT NULL AND l_serial_Control_dest = 1) THEN
5362: G_DEBUG_LINE_NUM := 390;

Line 5369: FND_MSG_PUB.ADD;

5365: END IF;
5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
5369: FND_MSG_PUB.ADD;
5370: x_return_status := FND_API.G_RET_STS_ERROR;
5371: END IF;
5372: END IF;
5373: IF (l_log_statement >= l_log_current_level) THEN

Line 5383: FND_MSG_PUB.ADD;

5379: IF (l_log_statement >= l_log_current_level) THEN
5380: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is lot controlled in destination org. Can not be transfered');
5381: END IF;
5382: FND_MESSAGE.Set_Name('AHL','AHL_MM_LOT_BASED_ITEM');
5383: FND_MSG_PUB.ADD;
5384: x_return_status := FND_API.G_RET_STS_ERROR;
5385: END IF;
5386: -- Visit Locator validation
5387: IF (l_log_statement >= l_log_current_level) THEN

Line 5396: FND_MSG_PUB.ADD;

5392: IF (l_log_statement >= l_log_current_level) THEN
5393: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Visit locator is null');
5394: END IF;
5395: FND_MESSAGE.Set_Name('AHL','AHL_MM_NULL_VISIT_LOCATOR');
5396: FND_MSG_PUB.ADD;
5397: x_return_status := FND_API.G_RET_STS_ERROR;
5398: ELSE
5399: --Locator Validation for destination
5400: OPEN LOCATOR_VALID_CUR(p_x_mtltfr_rec.dest_org_id, p_x_mtltfr_rec.dest_locator_id);

Line 5409: FND_MSG_PUB.ADD;

5405: END IF;
5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));
5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5409: FND_MSG_PUB.ADD;
5410: x_return_status := FND_API.G_RET_STS_ERROR;
5411: END IF;
5412: CLOSE LOCATOR_VALID_CUR;
5413: END IF;

Line 5424: FND_MSG_PUB.ADD;

5420: END IF;
5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));
5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5424: FND_MSG_PUB.ADD;
5425: x_return_status := FND_API.G_RET_STS_ERROR;
5426: END IF;
5427: CLOSE LOCATOR_VALID_CUR;
5428: -- Check if already reserved

Line 5441: FND_MSG_PUB.ADD;

5437: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Reservation already exists on the serial');
5438: END IF;
5439: FND_MESSAGE.Set_Name('AHL','AHL_MM_EXIST_RES');
5440: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.serial_number);
5441: FND_MSG_PUB.ADD;
5442: x_return_status := FND_API.G_RET_STS_ERROR;
5443: END IF;
5444: CLOSE RESERVATION_VALID_CUR;
5445: -- Shipping network validation

Line 5457: FND_MSG_PUB.ADD;

5453: IF (l_log_statement >= l_log_current_level) THEN
5454: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'No shipping network between the organizations');
5455: END IF;
5456: FND_MESSAGE.Set_Name('AHL','AHL_MM_NO_SHIP_NETWORK');
5457: FND_MSG_PUB.ADD;
5458: x_return_status := FND_API.G_RET_STS_ERROR;
5459: END IF;
5460: CLOSE SHIPPING_NETWORK_CUR;
5461:

Line 5470: FND_MSG_PUB.ADD;

5466: IF (l_log_statement >= l_log_current_level) THEN
5467: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Internal Order required to transfer between the organizations');
5468: END IF;
5469: FND_MESSAGE.Set_Name('AHL','AHL_MM_INTERNAL_ORD_REQD');
5470: FND_MSG_PUB.ADD;
5471: x_return_status := FND_API.G_RET_STS_ERROR;
5472: END IF;
5473: CLOSE SHIPPING_ATTRIB_CUR;
5474: --This should be the last print

Line 5676: FND_MSG_PUB.initialize;

5672: END IF;
5673:
5674: -- Initialize message list if p_init_msg_list is set to TRUE.
5675: IF FND_API.to_boolean( p_init_msg_list ) THEN
5676: FND_MSG_PUB.initialize;
5677: END IF;
5678:
5679: -- Initialize API return status to success
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5831: l_msg_count := Fnd_Msg_Pub.count_msg;

5827: p_inv_item_id => l_inventory_item_id,
5828: p_inv_org_id => l_org_id,
5829: p_uc_header_id => l_uc_header_id);
5830:
5831: l_msg_count := Fnd_Msg_Pub.count_msg;
5832:
5833: IF (l_msg_count > 0) THEN
5834: FOR i IN 1..l_msg_count
5835: LOOP

Line 5836: fnd_msg_pub.get( p_msg_index => i,

5832:
5833: IF (l_msg_count > 0) THEN
5834: FOR i IN 1..l_msg_count
5835: LOOP
5836: fnd_msg_pub.get( p_msg_index => i,
5837: p_encoded => FND_API.G_FALSE,
5838: p_data => l_err_msg,
5839: p_msg_index_out => l_msg_index_out);
5840:

Line 6219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6215: COMMIT;
6216: END IF;
6217:
6218: -- Count and Get messages
6219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6220: p_count => x_msg_count,
6221: p_data => x_msg_data);
6222:
6223: IF (l_log_procedure >= l_log_current_level) THEN

Line 6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6227: EXCEPTION
6228: WHEN FND_API.G_EXC_ERROR THEN
6229: ROLLBACK TO FILTER_INSTANCES_SP;
6230: x_return_status := FND_API.G_RET_STS_ERROR;
6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6232: p_count => x_msg_count,
6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;

Line 6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;
6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6238: p_count => x_msg_count,
6239: p_data => x_msg_data);
6240: WHEN OTHERS THEN
6241: ROLLBACK TO FILTER_INSTANCES_SP;

Line 6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6239: p_data => x_msg_data);
6240: WHEN OTHERS THEN
6241: ROLLBACK TO FILTER_INSTANCES_SP;
6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
6245: END IF;
6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,

Line 6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);

6240: WHEN OTHERS THEN
6241: ROLLBACK TO FILTER_INSTANCES_SP;
6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
6245: END IF;
6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,
6248: p_data => x_msg_data);

Line 6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
6245: END IF;
6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,
6248: p_data => x_msg_data);
6249:
6250: END FILTER_INSTANCES_MATCHING_BG;

Line 6322: FND_MSG_PUB.INITIALIZE;

6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
6322: FND_MSG_PUB.INITIALIZE;
6323: END IF;
6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;
6325: -- Get Session ID
6326: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

Line 6333: FND_MSG_PUB.add;

6329: OPEN Instance_Id_Cur;
6330: FETCH Instance_Id_Cur INTO l_instance_id;
6331: IF instance_id_cur%notfound THEN
6332: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
6333: FND_MSG_PUB.add;
6334: CLOSE Instance_Id_Cur;
6335: RAISE FND_API.G_EXC_ERROR;
6336: END IF;
6337: CLOSE instance_id_cur;

Line 6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);
6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();
6366: END IF;
6367: -- Standard call to get message count and if count is 1, get message info
6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6369: -- Log API exit point
6370: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6371: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.end', 'At the end of PLSQL procedure');
6372: END IF;

Line 6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6373: EXCEPTION
6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

Line 6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );
6387: END IF;
6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6389: END GET_AVAILABLE_QUANTITY;

Line 6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );

6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );
6387: END IF;
6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6389: END GET_AVAILABLE_QUANTITY;
6390:

Line 6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );
6387: END IF;
6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6389: END GET_AVAILABLE_QUANTITY;
6390:
6391: -- Kasridha: Changes for Marshalling Phase II Begins
6392:

Line 6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6482: EXCEPTION
6483: WHEN FND_API.G_EXC_ERROR THEN
6484: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;

Line 6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6491: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6493: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6494:
6495: WHEN OTHERS THEN
6496: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;

Line 6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6494:
6495: WHEN OTHERS THEN
6496: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
6500: END IF;
6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6502: P_COUNT => X_MSG_COUNT,

Line 6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

6495: WHEN OTHERS THEN
6496: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
6500: END IF;
6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6502: P_COUNT => X_MSG_COUNT,
6503: P_DATA => X_MSG_DATA);

Line 6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
6500: END IF;
6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6502: P_COUNT => X_MSG_COUNT,
6503: P_DATA => X_MSG_DATA);
6504: END SCHED_ALL_VST_MTLS;
6505: -- Kasridha: Changes for Marshalling Phase II Ends