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_RSV_RESERVATIONS_PVT dependencies on FND_MSG_PUB

Line 161: FND_MSG_PUB.INITIALIZE;

157:
158: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
159: IF FND_API.TO_BOOLEAN(p_init_msg_list)
160: THEN
161: FND_MSG_PUB.INITIALIZE;
162: END IF;
163:
164: -- Log API entry point
165: IF (l_log_procedure >= l_log_current_level) THEN

Line 179: FND_MSG_PUB.add;

175: -- Validate to make sure that the Serial Number table is not empty
176: l_sn_number := p_serial_number_tbl.COUNT;
177: IF l_sn_number = 0 THEN
178: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_SNQTY_GTR_ZRO' );
179: FND_MSG_PUB.add;
180: -- log the error
181: IF (l_log_error >= l_log_current_level) THEN
182: fnd_log.string
183: (

Line 197: FND_MSG_PUB.add;

193: OPEN get_mtl_req_dtls_csr(p_scheduled_material_id);
194: FETCH get_mtl_req_dtls_csr INTO l_mtl_req_dtls_rec;
195: IF get_mtl_req_dtls_csr%NOTFOUND THEN
196: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
197: FND_MSG_PUB.add;
198: -- log the error
199: IF (l_log_error >= l_log_current_level) THEN
200: fnd_log.string
201: (

Line 218: FND_MSG_PUB.add;

214: -- is not more than the initially requested quantity
215: IF l_sn_number + l_mtl_req_dtls_rec.completed_quantity +
216: l_mtl_req_dtls_rec.reserved_quantity > l_mtl_req_dtls_rec.requested_quantity THEN
217: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_QTY_EXCDS_REQSTD' );
218: FND_MSG_PUB.add;
219: -- log the error
220: IF (l_log_error >= l_log_current_level) THEN
221: fnd_log.string
222: (

Line 247: FND_MSG_PUB.add;

243: FETCH get_instance_dtls_csr INTO l_instance_details_rec;
244: IF get_instance_dtls_csr%NOTFOUND THEN
245: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
246: FND_MESSAGE.Set_Token('SERIALNUMBER',p_serial_number_tbl(i).serial_number);
247: FND_MSG_PUB.add;
248: -- log the error
249: IF (l_log_error >= l_log_current_level) THEN
250: fnd_log.string
251: (

Line 382: x_msg_count := FND_MSG_PUB.count_msg;

378: END IF;
379: END LOOP; -- FOR i IN p_serial_number_tbl.FIRST..p_serial_number_tbl.LAST
380:
381: -- Check Error Message stack.
382: x_msg_count := FND_MSG_PUB.count_msg;
383: IF x_msg_count > 0
384: THEN
385: -- log the error
386: IF (l_log_error >= l_log_current_level) THEN

Line 412: FND_MSG_PUB.count_and_get

408: END IF;
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info
412: FND_MSG_PUB.count_and_get
413: (
414: p_count => x_msg_count,
415: p_data => x_msg_data,
416: p_encoded => FND_API.G_FALSE

Line 433: FND_MSG_PUB.count_and_get

429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_RESERVATION_PVT;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get
434: (
435: p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => FND_API.G_FALSE

Line 443: FND_MSG_PUB.count_and_get

439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_RESERVATION_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.count_and_get
444: (
445: p_count => x_msg_count,
446: p_data => x_msg_data,
447: p_encoded => FND_API.G_FALSE

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

449:
450: WHEN OTHERS THEN
451: ROLLBACK TO CREATE_RESERVATION_PVT;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.add_exc_msg
456: (
457: p_pkg_name => G_PKG_NAME,

Line 455: FND_MSG_PUB.add_exc_msg

451: ROLLBACK TO CREATE_RESERVATION_PVT;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.add_exc_msg
456: (
457: p_pkg_name => G_PKG_NAME,
458: p_procedure_name => 'create_reservation',
459: p_error_text => SUBSTR(SQLERRM,1,240)

Line 462: FND_MSG_PUB.count_and_get

458: p_procedure_name => 'create_reservation',
459: p_error_text => SUBSTR(SQLERRM,1,240)
460: );
461: END IF;
462: FND_MSG_PUB.count_and_get
463: (
464: p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => FND_API.G_FALSE

Line 566: FND_MSG_PUB.INITIALIZE;

562:
563: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
564: IF FND_API.TO_BOOLEAN(p_init_msg_list)
565: THEN
566: FND_MSG_PUB.INITIALIZE;
567: END IF;
568:
569: -- Log API entry point
570: IF (l_log_procedure >= l_log_current_level)THEN

Line 583: FND_MSG_PUB.add;

579:
580: -- Validate the schedule material id
581: IF p_scheduled_material_id IS NULL THEN
582: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
583: FND_MSG_PUB.add;
584: -- log the error
585: IF (l_log_error >= l_log_current_level) THEN
586: fnd_log.string
587: (

Line 601: FND_MSG_PUB.add;

597: OPEN get_mtl_req_dtls_csr(p_scheduled_material_id);
598: FETCH get_mtl_req_dtls_csr INTO l_requested_date;
599: IF get_mtl_req_dtls_csr%NOTFOUND THEN
600: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
601: FND_MSG_PUB.add;
602: -- log the error
603: IF (l_log_error >= l_log_current_level) THEN
604: fnd_log.string
605: (

Line 619: FND_MSG_PUB.add;

615:
616: -- if the requested date is null, throw error
617: IF p_requested_date IS NULL THEN
618: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_REQ_DATE' );
619: FND_MSG_PUB.add;
620: -- log the error
621: IF (l_log_error >= l_log_current_level) THEN
622: fnd_log.string
623: (

Line 709: x_msg_count := FND_MSG_PUB.count_msg;

705: END IF;
706: END LOOP; -- All the reservations for this material requiement id
707:
708: -- Check Error Message stack.
709: x_msg_count := FND_MSG_PUB.count_msg;
710: IF x_msg_count > 0
711: THEN
712: -- log the error
713: IF (l_log_error >= l_log_current_level) THEN

Line 739: FND_MSG_PUB.count_and_get

735: END IF;
736: END IF;
737:
738: -- Standard call to get message count and if count is 1, get message info
739: FND_MSG_PUB.count_and_get
740: (
741: p_count => x_msg_count,
742: p_data => x_msg_data,
743: p_encoded => FND_API.G_FALSE

Line 759: FND_MSG_PUB.count_and_get

755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO UPDATE_RESERVATION_PVT;
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get
760: (
761: p_count => x_msg_count,
762: p_data => x_msg_data,
763: p_encoded => FND_API.G_FALSE

Line 769: FND_MSG_PUB.count_and_get

765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO UPDATE_RESERVATION_PVT;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.count_and_get
770: (
771: p_count => x_msg_count,
772: p_data => x_msg_data,
773: p_encoded => FND_API.G_FALSE

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

775:
776: WHEN OTHERS THEN
777: ROLLBACK TO UPDATE_RESERVATION_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: FND_MSG_PUB.add_exc_msg
782: (
783: p_pkg_name => G_PKG_NAME,

Line 781: FND_MSG_PUB.add_exc_msg

777: ROLLBACK TO UPDATE_RESERVATION_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
780: THEN
781: FND_MSG_PUB.add_exc_msg
782: (
783: p_pkg_name => G_PKG_NAME,
784: p_procedure_name => 'update_reservation',
785: p_error_text => SUBSTR(SQLERRM,1,240)

Line 788: FND_MSG_PUB.count_and_get

784: p_procedure_name => 'update_reservation',
785: p_error_text => SUBSTR(SQLERRM,1,240)
786: );
787: END IF;
788: FND_MSG_PUB.count_and_get
789: (
790: p_count => x_msg_count,
791: p_data => x_msg_data,
792: p_encoded => FND_API.G_FALSE

Line 898: FND_MSG_PUB.INITIALIZE;

894:
895: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
896: IF FND_API.TO_BOOLEAN(p_init_msg_list)
897: THEN
898: FND_MSG_PUB.INITIALIZE;
899: END IF;
900:
901: -- Log API entry point
902: IF (l_log_procedure >= l_log_current_level)THEN

Line 914: FND_MSG_PUB.add;

910:
911: -- Validate the schedule material id and p_sub_inventory_code
912: IF p_scheduled_material_id IS NULL THEN
913: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
914: FND_MSG_PUB.add;
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917:
918: -- log the p_scheduled_material_id and the p_sub_inventory_code

Line 943: FND_MSG_PUB.ADD;

939: WHERE scheduled_material_id = p_scheduled_material_id;
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: FND_MESSAGE.Set_Name('AHL','AHL_RSV_INVLD_MAT_REQ');
943: FND_MSG_PUB.ADD;
944: -- log the error
945: IF (l_log_error >= l_log_current_level) THEN
946: fnd_log.string
947: (

Line 1088: x_msg_count := FND_MSG_PUB.count_msg;

1084: );
1085: END IF;
1086:
1087: -- Check Error Message stack.
1088: x_msg_count := FND_MSG_PUB.count_msg;
1089: IF x_msg_count > 0
1090: THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;

Line 1109: FND_MSG_PUB.count_and_get

1105: END IF;
1106: END IF;
1107:
1108: -- Standard call to get message count and if count is 1, get message info
1109: FND_MSG_PUB.count_and_get
1110: (
1111: p_count => x_msg_count,
1112: p_data => x_msg_data,
1113: p_encoded => FND_API.G_FALSE

Line 1120: FND_MSG_PUB.count_and_get

1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN
1118: ROLLBACK TO DELETE_RESERVATION_PVT;
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.count_and_get
1121: (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE

Line 1130: FND_MSG_PUB.count_and_get

1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO DELETE_RESERVATION_PVT;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.count_and_get
1131: (
1132: p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE

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

1136:
1137: WHEN OTHERS THEN
1138: ROLLBACK TO DELETE_RESERVATION_PVT;
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: FND_MSG_PUB.add_exc_msg
1143: (
1144: p_pkg_name => G_PKG_NAME,

Line 1142: FND_MSG_PUB.add_exc_msg

1138: ROLLBACK TO DELETE_RESERVATION_PVT;
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: FND_MSG_PUB.add_exc_msg
1143: (
1144: p_pkg_name => G_PKG_NAME,
1145: p_procedure_name => 'delete_reservation',
1146: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1149: FND_MSG_PUB.count_and_get

1145: p_procedure_name => 'delete_reservation',
1146: p_error_text => SUBSTR(SQLERRM,1,240)
1147: );
1148: END IF;
1149: FND_MSG_PUB.count_and_get
1150: (
1151: p_count => x_msg_count,
1152: p_data => x_msg_data,
1153: p_encoded => FND_API.G_FALSE

Line 1286: FND_MSG_PUB.INITIALIZE;

1282:
1283: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1284: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1285: THEN
1286: FND_MSG_PUB.INITIALIZE;
1287: END IF;
1288:
1289: -- Log API entry point
1290: IF (l_log_procedure >= l_log_current_level)THEN

Line 1302: FND_MSG_PUB.add;

1298:
1299: -- Validate the schedule material id
1300: IF p_scheduled_material_id IS NULL THEN
1301: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1302: FND_MSG_PUB.add;
1303: -- log the error
1304: IF (l_log_error >= l_log_current_level) THEN
1305: fnd_log.string
1306: (

Line 1321: FND_MSG_PUB.add;

1317: FETCH get_mtl_req_dtls_csr INTO l_get_mtl_req_dtls_rec;
1318: -- If the details are not found then raise exception
1319: IF get_mtl_req_dtls_csr%NOTFOUND THEN
1320: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1321: FND_MSG_PUB.add;
1322: CLOSE get_mtl_req_dtls_csr;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF; -- IF get_mtl_req_dtls_csr%NOTFOUND
1325: CLOSE get_mtl_req_dtls_csr;

Line 1330: FND_MSG_PUB.add;

1326:
1327: -- Validate the Serial Number
1328: IF p_serial_number IS NULL THEN
1329: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
1330: FND_MSG_PUB.add;
1331: IF (l_log_error>= l_log_current_level)THEN
1332: fnd_log.string
1333: (
1334: fnd_log.level_error,

Line 1347: FND_MSG_PUB.add;

1343: OPEN get_instance_dtls_csr(l_get_mtl_req_dtls_rec.inventory_item_id,p_serial_number,l_get_mtl_req_dtls_rec.organization_id);
1344: FETCH get_instance_dtls_csr INTO l_get_instance_dtls_rec;
1345: IF get_instance_dtls_csr%NOTFOUND THEN
1346: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
1347: FND_MSG_PUB.add;
1348: CLOSE get_instance_dtls_csr;
1349: RAISE FND_API.G_EXC_ERROR;
1350: END IF; -- IF get_instance_dtls_csr%NOTFOUND
1351: CLOSE get_instance_dtls_csr;

Line 1473: x_msg_count := FND_MSG_PUB.count_msg;

1469: );
1470: END IF;
1471:
1472: -- Check Error Message stack.
1473: x_msg_count := FND_MSG_PUB.count_msg;
1474: IF x_msg_count > 0
1475: THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;

Line 1486: FND_MSG_PUB.count_and_get

1482: COMMIT WORK;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info
1486: FND_MSG_PUB.count_and_get
1487: (
1488: p_count => x_msg_count,
1489: p_data => x_msg_data,
1490: p_encoded => FND_API.G_FALSE

Line 1497: FND_MSG_PUB.count_and_get

1493: EXCEPTION
1494: WHEN FND_API.G_EXC_ERROR THEN
1495: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.count_and_get
1498: (
1499: p_count => x_msg_count,
1500: p_data => x_msg_data,
1501: p_encoded => FND_API.G_FALSE

Line 1507: FND_MSG_PUB.count_and_get

1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.count_and_get
1508: (
1509: p_count => x_msg_count,
1510: p_data => x_msg_data,
1511: p_encoded => FND_API.G_FALSE

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

1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1518: THEN
1519: FND_MSG_PUB.add_exc_msg
1520: (
1521: p_pkg_name => G_PKG_NAME,

Line 1519: FND_MSG_PUB.add_exc_msg

1515: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1518: THEN
1519: FND_MSG_PUB.add_exc_msg
1520: (
1521: p_pkg_name => G_PKG_NAME,
1522: p_procedure_name => 'relieve_reservation',
1523: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1526: FND_MSG_PUB.count_and_get

1522: p_procedure_name => 'relieve_reservation',
1523: p_error_text => SUBSTR(SQLERRM,1,240)
1524: );
1525: END IF;
1526: FND_MSG_PUB.count_and_get
1527: (
1528: p_count => x_msg_count,
1529: p_data => x_msg_data,
1530: p_encoded => FND_API.G_FALSE

Line 1640: FND_MSG_PUB.INITIALIZE;

1636:
1637: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1638: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1639: THEN
1640: FND_MSG_PUB.INITIALIZE;
1641: END IF;
1642:
1643: -- Log API entry point
1644: IF (l_log_procedure >= l_log_current_level)THEN

Line 1771: x_msg_count := FND_MSG_PUB.count_msg;

1767: );
1768: END IF;
1769:
1770: -- Check Error Message stack.
1771: x_msg_count := FND_MSG_PUB.count_msg;
1772: IF x_msg_count > 0
1773: THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: END IF;

Line 1784: FND_MSG_PUB.count_and_get

1780: COMMIT WORK;
1781: END IF;
1782:
1783: -- Standard call to get message count and if count is 1, get message info
1784: FND_MSG_PUB.count_and_get
1785: (
1786: p_count => x_msg_count,
1787: p_data => x_msg_data,
1788: p_encoded => FND_API.G_FALSE

Line 1795: FND_MSG_PUB.count_and_get

1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN
1793: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: FND_MSG_PUB.count_and_get
1796: (
1797: p_count => x_msg_count,
1798: p_data => x_msg_data,
1799: p_encoded => FND_API.G_FALSE

Line 1805: FND_MSG_PUB.count_and_get

1801:
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1805: FND_MSG_PUB.count_and_get
1806: (
1807: p_count => x_msg_count,
1808: p_data => x_msg_data,
1809: p_encoded => FND_API.G_FALSE

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

1811:
1812: WHEN OTHERS THEN
1813: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1816: THEN
1817: FND_MSG_PUB.add_exc_msg
1818: (
1819: p_pkg_name => G_PKG_NAME,

Line 1817: FND_MSG_PUB.add_exc_msg

1813: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1816: THEN
1817: FND_MSG_PUB.add_exc_msg
1818: (
1819: p_pkg_name => G_PKG_NAME,
1820: p_procedure_name => 'relieve_reservation',
1821: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1824: FND_MSG_PUB.count_and_get

1820: p_procedure_name => 'relieve_reservation',
1821: p_error_text => SUBSTR(SQLERRM,1,240)
1822: );
1823: END IF;
1824: FND_MSG_PUB.count_and_get
1825: (
1826: p_count => x_msg_count,
1827: p_data => x_msg_data,
1828: p_encoded => FND_API.G_FALSE

Line 1975: FND_MSG_PUB.add;

1971: OPEN get_mtl_req_id_csr(l_get_upd_rsv_rec.demand_source_header_id,l_get_upd_rsv_rec.demand_source_line_id,l_get_upd_rsv_rec.inventory_item_id);
1972: FETCH get_mtl_req_id_csr INTO l_get_mtl_req_id_rec;
1973: IF get_mtl_req_id_csr%NOTFOUND THEN
1974: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_UPD_VST_RSV_FAIL' );
1975: FND_MSG_PUB.add;
1976: -- log the error
1977: IF (l_log_error >= l_log_current_level) THEN
1978: fnd_log.string
1979: (

Line 2188: FND_MSG_PUB.INITIALIZE;

2184:
2185: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2186: /* IF FND_API.TO_BOOLEAN(p_init_msg_list)
2187: THEN
2188: FND_MSG_PUB.INITIALIZE;
2189: END IF;
2190: */
2191:
2192: -- Log API entry point

Line 2442: FND_MSG_PUB.ADD;

2438: x_rsv_rec.demand_source_header_id := l_get_mtl_req_dtls_rec.Visit_Task_ID;
2439: x_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.rt_oper_material_id;
2440: ELSE
2441: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ONLY_PLN_SPF_TSK' );
2442: FND_MSG_PUB.ADD;
2443: --RAISE FND_API.G_EXC_ERROR;
2444: x_return_status := FND_API.G_RET_STS_ERROR;
2445: END IF; -- l_get_mtl_req_dtls_rec.task_status_code = 'RELEASED'
2446:

Line 2540: FND_MSG_PUB.INITIALIZE;

2536:
2537: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2538: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2539: THEN
2540: FND_MSG_PUB.INITIALIZE;
2541: END IF;
2542:
2543: -- Log API entry point
2544: IF (l_log_procedure >= l_log_current_level)THEN

Line 2612: x_msg_count := FND_MSG_PUB.count_msg;

2608: );
2609: END IF;
2610:
2611: -- Check Error Message stack.
2612: x_msg_count := FND_MSG_PUB.count_msg;
2613: IF x_msg_count > 0
2614: THEN
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;

Line 2625: FND_MSG_PUB.count_and_get

2621: COMMIT WORK;
2622: END IF;
2623:
2624: -- Standard call to get message count and if count is 1, get message info
2625: FND_MSG_PUB.count_and_get
2626: (
2627: p_count => x_msg_count,
2628: p_data => x_msg_data,
2629: p_encoded => FND_API.G_FALSE

Line 2636: FND_MSG_PUB.count_and_get

2632: EXCEPTION
2633: WHEN FND_API.G_EXC_ERROR THEN
2634: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: FND_MSG_PUB.count_and_get
2637: (
2638: p_count => x_msg_count,
2639: p_data => x_msg_data,
2640: p_encoded => FND_API.G_FALSE

Line 2646: FND_MSG_PUB.count_and_get

2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.count_and_get
2647: (
2648: p_count => x_msg_count,
2649: p_data => x_msg_data,
2650: p_encoded => FND_API.G_FALSE

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

2652:
2653: WHEN OTHERS THEN
2654: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2657: THEN
2658: FND_MSG_PUB.add_exc_msg
2659: (
2660: p_pkg_name => G_PKG_NAME,

Line 2658: FND_MSG_PUB.add_exc_msg

2654: ROLLBACK TO TRNSFR_RSRV_FOR_MATRL_REQR_PVT;
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2657: THEN
2658: FND_MSG_PUB.add_exc_msg
2659: (
2660: p_pkg_name => G_PKG_NAME,
2661: p_procedure_name => 'TRANSFER_RESERVATION_MATRL_REQR_PVT',
2662: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2665: FND_MSG_PUB.count_and_get

2661: p_procedure_name => 'TRANSFER_RESERVATION_MATRL_REQR_PVT',
2662: p_error_text => SUBSTR(SQLERRM,1,240)
2663: );
2664: END IF;
2665: FND_MSG_PUB.count_and_get
2666: (
2667: p_count => x_msg_count,
2668: p_data => x_msg_data,
2669: p_encoded => FND_API.G_FALSE