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

Line 118: FND_MSG_PUB.INITIALIZE;

114:
115: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
116: IF FND_API.TO_BOOLEAN(p_init_msg_list)
117: THEN
118: FND_MSG_PUB.INITIALIZE;
119: END IF;
120:
121: -- Initialize the record to be send to the WMS package
122: Initialize_create_rec(l_scheduled_material_id, -- the schedule material id

Line 162: FND_MSG_PUB.add;

158: OPEN get_mtl_req_dtls_csr(l_scheduled_material_id);
159: FETCH get_mtl_req_dtls_csr INTO l_mtl_req_dtls_rec;
160: IF get_mtl_req_dtls_csr%NOTFOUND THEN
161: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
162: FND_MSG_PUB.add;
163: -- log the error
164: IF (l_log_error >= l_log_current_level) THEN
165: fnd_log.string
166: (

Line 181: FND_MSG_PUB.add;

177: -- Validate whether the sum of already issued + reserved quantities is not more than the initially requested quantity
178: IF l_mtl_req_dtls_rec.completed_quantity +
179: l_mtl_req_dtls_rec.reserved_quantity >= l_mtl_req_dtls_rec.requested_quantity THEN
180: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_QTY_EXCDS_REQSTD' );
181: FND_MSG_PUB.add;
182: -- log the error
183: IF (l_log_error >= l_log_current_level) THEN
184: fnd_log.string
185: (

Line 199: FND_MSG_PUB.add;

195:
196: -- Validate to make sure that the Serial Number is not empty, when Supply is Inventory.
197: IF (l_serial_number_tbl.COUNT < 1) THEN
198: FND_MESSAGE.set_name( 'AHL', 'AHL_PP_SERIAL_MISSING' );
199: FND_MSG_PUB.add;
200: -- log the error
201: IF (l_log_error >= l_log_current_level) THEN
202: fnd_log.string
203: (

Line 285: x_msg_count := FND_MSG_PUB.count_msg;

281: END IF;
282:
283:
284: -- Check Error Message stack.
285: x_msg_count := FND_MSG_PUB.count_msg;
286: IF x_msg_count > 0
287: THEN
288: -- log the error
289: IF (l_log_error >= l_log_current_level) THEN

Line 315: FND_MSG_PUB.count_and_get

311: END IF;
312: END IF;
313:
314: -- Standard call to get message count and if count is 1, get message info
315: FND_MSG_PUB.count_and_get
316: (
317: p_count => x_msg_count,
318: p_data => x_msg_data,
319: p_encoded => FND_API.G_FALSE

Line 336: FND_MSG_PUB.count_and_get

332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: ROLLBACK TO CREATE_RESERVATION_PVT;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.count_and_get
337: (
338: p_count => x_msg_count,
339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE

Line 346: FND_MSG_PUB.count_and_get

342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ROLLBACK TO CREATE_RESERVATION_PVT;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.count_and_get
347: (
348: p_count => x_msg_count,
349: p_data => x_msg_data,
350: p_encoded => FND_API.G_FALSE

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

352:
353: WHEN OTHERS THEN
354: ROLLBACK TO CREATE_RESERVATION_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: FND_MSG_PUB.add_exc_msg
359: (
360: p_pkg_name => G_PKG_NAME,

Line 358: FND_MSG_PUB.add_exc_msg

354: ROLLBACK TO CREATE_RESERVATION_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: FND_MSG_PUB.add_exc_msg
359: (
360: p_pkg_name => G_PKG_NAME,
361: p_procedure_name => 'create_reservation',
362: p_error_text => SUBSTR(SQLERRM,1,240)

Line 365: FND_MSG_PUB.count_and_get

361: p_procedure_name => 'create_reservation',
362: p_error_text => SUBSTR(SQLERRM,1,240)
363: );
364: END IF;
365: FND_MSG_PUB.count_and_get
366: (
367: p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE

Line 433: FND_MSG_PUB.INITIALIZE;

429:
430: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
431: IF FND_API.TO_BOOLEAN(p_init_msg_list)
432: THEN
433: FND_MSG_PUB.INITIALIZE;
434: END IF;
435:
436: -- Log API entry point
437: IF (l_log_procedure >= l_log_current_level)THEN

Line 451: FND_MSG_PUB.add;

447: -- Validate the reservation id
448: l_scheduled_material_id := validate_reservation_id(p_reservation_id);
449: IF (l_scheduled_material_id IS NULL) THEN
450: FND_MESSAGE.set_name( 'AHL', 'AHL_LTP_MULTI_ORG' );
451: FND_MSG_PUB.add;
452: -- log the error
453: IF (l_log_error >= l_log_current_level) THEN
454: fnd_log.string
455: (

Line 571: x_msg_count := FND_MSG_PUB.count_msg;

567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569:
570: -- Check Error Message stack.
571: x_msg_count := FND_MSG_PUB.count_msg;
572: IF x_msg_count > 0
573: THEN
574: -- log the error
575: IF (l_log_error >= l_log_current_level) THEN

Line 601: FND_MSG_PUB.count_and_get

597: END IF;
598: END IF;
599:
600: -- Standard call to get message count and if count is 1, get message info
601: FND_MSG_PUB.count_and_get
602: (
603: p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => FND_API.G_FALSE

Line 621: FND_MSG_PUB.count_and_get

617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: ROLLBACK TO UPDATE_RESERVATION_PVT;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: FND_MSG_PUB.count_and_get
622: (
623: p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => FND_API.G_FALSE

Line 631: FND_MSG_PUB.count_and_get

627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO UPDATE_RESERVATION_PVT;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.count_and_get
632: (
633: p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => FND_API.G_FALSE

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

637:
638: WHEN OTHERS THEN
639: ROLLBACK TO UPDATE_RESERVATION_PVT;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
642: THEN
643: FND_MSG_PUB.add_exc_msg
644: (
645: p_pkg_name => G_PKG_NAME,

Line 643: FND_MSG_PUB.add_exc_msg

639: ROLLBACK TO UPDATE_RESERVATION_PVT;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
642: THEN
643: FND_MSG_PUB.add_exc_msg
644: (
645: p_pkg_name => G_PKG_NAME,
646: p_procedure_name => 'update_reservation',
647: p_error_text => SUBSTR(SQLERRM,1,240)

Line 650: FND_MSG_PUB.count_and_get

646: p_procedure_name => 'update_reservation',
647: p_error_text => SUBSTR(SQLERRM,1,240)
648: );
649: END IF;
650: FND_MSG_PUB.count_and_get
651: (
652: p_count => x_msg_count,
653: p_data => x_msg_data,
654: p_encoded => FND_API.G_FALSE

Line 713: FND_MSG_PUB.INITIALIZE;

709:
710: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
711: IF FND_API.TO_BOOLEAN(p_init_msg_list)
712: THEN
713: FND_MSG_PUB.INITIALIZE;
714: END IF;
715:
716: -- Log API entry point
717: IF (l_log_procedure >= l_log_current_level)THEN

Line 731: FND_MSG_PUB.add;

727: -- Validate the reservation id
728: l_scheduled_material_id := validate_reservation_id(p_reservation_id);
729: IF (l_scheduled_material_id IS NULL) THEN
730: FND_MESSAGE.set_name( 'AHL', 'AHL_LTP_MULTI_ORG' );
731: FND_MSG_PUB.add;
732: -- log the error
733: IF (l_log_error >= l_log_current_level) THEN
734: fnd_log.string
735: (

Line 790: x_msg_count := FND_MSG_PUB.count_msg;

786: );
787: END IF;
788:
789: -- Check Error Message stack.
790: x_msg_count := FND_MSG_PUB.count_msg;
791: IF x_msg_count > 0
792: THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;

Line 811: FND_MSG_PUB.count_and_get

807: END IF;
808: END IF;
809:
810: -- Standard call to get message count and if count is 1, get message info
811: FND_MSG_PUB.count_and_get
812: (
813: p_count => x_msg_count,
814: p_data => x_msg_data,
815: p_encoded => FND_API.G_FALSE

Line 822: FND_MSG_PUB.count_and_get

818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO DELETE_RESERVATION_PVT;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.count_and_get
823: (
824: p_count => x_msg_count,
825: p_data => x_msg_data,
826: p_encoded => FND_API.G_FALSE

Line 832: FND_MSG_PUB.count_and_get

828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO DELETE_RESERVATION_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.count_and_get
833: (
834: p_count => x_msg_count,
835: p_data => x_msg_data,
836: p_encoded => FND_API.G_FALSE

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

838:
839: WHEN OTHERS THEN
840: ROLLBACK TO DELETE_RESERVATION_PVT;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.add_exc_msg
845: (
846: p_pkg_name => G_PKG_NAME,

Line 844: FND_MSG_PUB.add_exc_msg

840: ROLLBACK TO DELETE_RESERVATION_PVT;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: FND_MSG_PUB.add_exc_msg
845: (
846: p_pkg_name => G_PKG_NAME,
847: p_procedure_name => 'delete_reservation',
848: p_error_text => SUBSTR(SQLERRM,1,240)

Line 851: FND_MSG_PUB.count_and_get

847: p_procedure_name => 'delete_reservation',
848: p_error_text => SUBSTR(SQLERRM,1,240)
849: );
850: END IF;
851: FND_MSG_PUB.count_and_get
852: (
853: p_count => x_msg_count,
854: p_data => x_msg_data,
855: p_encoded => FND_API.G_FALSE

Line 916: FND_MSG_PUB.INITIALIZE;

912:
913: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
914: IF FND_API.TO_BOOLEAN(p_init_msg_list)
915: THEN
916: FND_MSG_PUB.INITIALIZE;
917: END IF;
918:
919: -- Log API entry point
920: IF (l_log_procedure >= l_log_current_level)THEN

Line 941: FND_MSG_PUB.add;

937: -- Validate the reservation id
938: l_scheduled_material_id := validate_reservation_id(p_reservation_id);
939: IF (l_scheduled_material_id IS NULL) THEN
940: FND_MESSAGE.set_name( 'AHL', 'AHL_LTP_MULTI_ORG' );
941: FND_MSG_PUB.add;
942: -- log the error
943: IF (l_log_error >= l_log_current_level) THEN
944: fnd_log.string
945: (

Line 960: FND_MSG_PUB.add;

956: FETCH get_mtl_req_dtls_csr INTO l_mtl_req_dtls_rec;
957: -- If the details are not found then raise exception
958: IF get_mtl_req_dtls_csr%NOTFOUND THEN
959: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
960: FND_MSG_PUB.add;
961: CLOSE get_mtl_req_dtls_csr;
962: RAISE FND_API.G_EXC_ERROR;
963: END IF; -- IF get_mtl_req_dtls_csr%NOTFOUND
964: CLOSE get_mtl_req_dtls_csr;

Line 969: FND_MSG_PUB.add;

965:
966: -- Validate the Serial Number
967: IF (l_serial_number_tbl.COUNT < 1) THEN
968: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_SL_NUM' );
969: FND_MSG_PUB.add;
970: IF (l_log_error>= l_log_current_level)THEN
971: fnd_log.string
972: (
973: fnd_log.level_error,

Line 1051: x_msg_count := FND_MSG_PUB.count_msg;

1047: );
1048: END IF;
1049:
1050: -- Check Error Message stack.
1051: x_msg_count := FND_MSG_PUB.count_msg;
1052: IF x_msg_count > 0
1053: THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;

Line 1064: FND_MSG_PUB.count_and_get

1060: COMMIT WORK;
1061: END IF;
1062:
1063: -- Standard call to get message count and if count is 1, get message info
1064: FND_MSG_PUB.count_and_get
1065: (
1066: p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => FND_API.G_FALSE

Line 1075: FND_MSG_PUB.count_and_get

1071: EXCEPTION
1072: WHEN FND_API.G_EXC_ERROR THEN
1073: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: FND_MSG_PUB.count_and_get
1076: (
1077: p_count => x_msg_count,
1078: p_data => x_msg_data,
1079: p_encoded => FND_API.G_FALSE

Line 1085: FND_MSG_PUB.count_and_get

1081:
1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1083: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1085: FND_MSG_PUB.count_and_get
1086: (
1087: p_count => x_msg_count,
1088: p_data => x_msg_data,
1089: p_encoded => FND_API.G_FALSE

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

1091:
1092: WHEN OTHERS THEN
1093: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1096: THEN
1097: FND_MSG_PUB.add_exc_msg
1098: (
1099: p_pkg_name => G_PKG_NAME,

Line 1097: FND_MSG_PUB.add_exc_msg

1093: ROLLBACK TO RELIEVE_RESERVATION_PVT;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1096: THEN
1097: FND_MSG_PUB.add_exc_msg
1098: (
1099: p_pkg_name => G_PKG_NAME,
1100: p_procedure_name => 'relieve_reservation',
1101: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1104: FND_MSG_PUB.count_and_get

1100: p_procedure_name => 'relieve_reservation',
1101: p_error_text => SUBSTR(SQLERRM,1,240)
1102: );
1103: END IF;
1104: FND_MSG_PUB.count_and_get
1105: (
1106: p_count => x_msg_count,
1107: p_data => x_msg_data,
1108: p_encoded => FND_API.G_FALSE

Line 1180: FND_MSG_PUB.INITIALIZE;

1176:
1177: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1178: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1179: THEN
1180: FND_MSG_PUB.INITIALIZE;
1181: END IF;
1182:
1183: l_from_rsv_rec.reservation_id := p_from_reservation_id;
1184:

Line 1208: FND_MSG_PUB.add;

1204: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1205: 'p_schedule_material_id is null for demand, p_schedule_material_id:' ||l_rsv_rec.demand_source_line_detail);
1206: END IF;
1207: FND_MESSAGE.set_name( 'AHL', 'AHL_MM_INV_REQ' );
1208: FND_MSG_PUB.add;
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: RETURN;
1211: END IF;
1212: -- Validate the reservation id

Line 1216: FND_MSG_PUB.add;

1212: -- Validate the reservation id
1213: l_scheduled_material_id := validate_reservation_id(p_from_reservation_id);
1214: IF (l_scheduled_material_id IS NULL) THEN
1215: FND_MESSAGE.set_name( 'AHL', 'AHL_LTP_MULTI_ORG' );
1216: FND_MSG_PUB.add;
1217: -- log the error
1218: IF (l_log_error >= l_log_current_level) THEN
1219: fnd_log.string
1220: (

Line 1235: FND_MSG_PUB.add;

1231: FETCH get_mtl_req_dtls_csr INTO l_mtl_req_dtls_rec;
1232: -- If the details are not found then raise exception
1233: IF get_mtl_req_dtls_csr%NOTFOUND THEN
1234: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1235: FND_MSG_PUB.add;
1236: CLOSE get_mtl_req_dtls_csr;
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF; -- IF get_mtl_req_dtls_csr%NOTFOUND
1239: CLOSE get_mtl_req_dtls_csr;

Line 1419: x_msg_count := FND_MSG_PUB.count_msg;

1415: );
1416: END IF;
1417:
1418: -- Check Error Message stack.
1419: x_msg_count := FND_MSG_PUB.count_msg;
1420: IF x_msg_count > 0
1421: THEN
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;

Line 1432: FND_MSG_PUB.count_and_get

1428: COMMIT WORK;
1429: END IF;
1430:
1431: -- Standard call to get message count and if count is 1, get message info
1432: FND_MSG_PUB.count_and_get
1433: (
1434: p_count => x_msg_count,
1435: p_data => x_msg_data,
1436: p_encoded => FND_API.G_FALSE

Line 1443: FND_MSG_PUB.count_and_get

1439: EXCEPTION
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: FND_MSG_PUB.count_and_get
1444: (
1445: p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => FND_API.G_FALSE

Line 1453: FND_MSG_PUB.count_and_get

1449:
1450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1451: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: FND_MSG_PUB.count_and_get
1454: (
1455: p_count => x_msg_count,
1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE

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

1459:
1460: WHEN OTHERS THEN
1461: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.add_exc_msg
1466: (
1467: p_pkg_name => G_PKG_NAME,

Line 1465: FND_MSG_PUB.add_exc_msg

1461: ROLLBACK TO TRANSFER_RESERVATION_PVT;
1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.add_exc_msg
1466: (
1467: p_pkg_name => G_PKG_NAME,
1468: p_procedure_name => 'transfer_reservation',
1469: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1472: FND_MSG_PUB.count_and_get

1468: p_procedure_name => 'transfer_reservation',
1469: p_error_text => SUBSTR(SQLERRM,1,240)
1470: );
1471: END IF;
1472: FND_MSG_PUB.count_and_get
1473: (
1474: p_count => x_msg_count,
1475: p_data => x_msg_data,
1476: p_encoded => FND_API.G_FALSE

Line 1559: FND_MSG_PUB.INITIALIZE;

1555:
1556: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
1557: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1558: THEN
1559: FND_MSG_PUB.INITIALIZE;
1560: END IF;
1561:
1562: -- Log API entry point
1563: IF (l_log_procedure >= l_log_current_level) THEN

Line 1578: FND_MSG_PUB.add;

1574: OPEN get_mtl_req_dtls_csr(l_scheduled_material_id);
1575: FETCH get_mtl_req_dtls_csr INTO l_mtl_req_dtls_rec;
1576: IF get_mtl_req_dtls_csr%NOTFOUND THEN
1577: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_INVLD_MAT_REQ' );
1578: FND_MSG_PUB.add;
1579: -- log the error
1580: IF (l_log_error >= l_log_current_level) THEN
1581: fnd_log.string
1582: (

Line 1597: FND_MSG_PUB.add;

1593: -- Validate whether the sum of already issued + reserved quantities is not more than the initially requested quantity
1594: IF l_mtl_req_dtls_rec.completed_quantity +
1595: l_mtl_req_dtls_rec.reserved_quantity >= l_mtl_req_dtls_rec.requested_quantity THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_QTY_EXCDS_REQSTD' );
1597: FND_MSG_PUB.add;
1598: -- log the error
1599: IF (l_log_error >= l_log_current_level) THEN
1600: fnd_log.string
1601: (

Line 1681: FND_MSG_PUB.add;

1677:
1678: -- Validate to make sure that the Serial Number is not empty, when Supply is Inventory.
1679: IF (l_serial_number_tbl.COUNT < 1) THEN
1680: FND_MESSAGE.set_name( 'AHL', 'AHL_PP_SERIAL_MISSING' );
1681: FND_MSG_PUB.add;
1682: -- log the error
1683: IF (l_log_error >= l_log_current_level) THEN
1684: fnd_log.string
1685: (

Line 2128: FND_MSG_PUB.add;

2124:
2125: ELSE -- Inventory, Workorder, IR is not the supply source thorw an error
2126:
2127: FND_MESSAGE.set_name( 'AHL', 'AHL_MM_INV_SUP_SRC_TYPE' );
2128: FND_MSG_PUB.add;
2129: -- log the error
2130: IF (l_log_error >= l_log_current_level) THEN
2131: fnd_log.string
2132: (

Line 2143: x_msg_count := FND_MSG_PUB.count_msg;

2139:
2140: END IF; -- supply type inventory => l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv
2141:
2142: -- Check Error Message stack.
2143: x_msg_count := FND_MSG_PUB.count_msg;
2144: IF x_msg_count > 0
2145: THEN
2146: -- log the error
2147: IF (l_log_error >= l_log_current_level) THEN

Line 2173: FND_MSG_PUB.count_and_get

2169: END IF;
2170: END IF;
2171:
2172: -- Standard call to get message count and if count is 1, get message info
2173: FND_MSG_PUB.count_and_get
2174: (
2175: p_count => x_msg_count,
2176: p_data => x_msg_data,
2177: p_encoded => FND_API.G_FALSE

Line 2194: FND_MSG_PUB.count_and_get

2190: EXCEPTION
2191: WHEN FND_API.G_EXC_ERROR THEN
2192: ROLLBACK TO PROCESS_RESERVATION_PVT;
2193: x_return_status := FND_API.G_RET_STS_ERROR;
2194: FND_MSG_PUB.count_and_get
2195: (
2196: p_count => x_msg_count,
2197: p_data => x_msg_data,
2198: p_encoded => FND_API.G_FALSE

Line 2204: FND_MSG_PUB.count_and_get

2200:
2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: ROLLBACK TO PROCESS_RESERVATION_PVT;
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: FND_MSG_PUB.count_and_get
2205: (
2206: p_count => x_msg_count,
2207: p_data => x_msg_data,
2208: p_encoded => FND_API.G_FALSE

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

2210:
2211: WHEN OTHERS THEN
2212: ROLLBACK TO PROCESS_RESERVATION_PVT;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.add_exc_msg
2217: (
2218: p_pkg_name => G_PKG_NAME,

Line 2216: FND_MSG_PUB.add_exc_msg

2212: ROLLBACK TO PROCESS_RESERVATION_PVT;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.add_exc_msg
2217: (
2218: p_pkg_name => G_PKG_NAME,
2219: p_procedure_name => 'PROCESS_RESERVATION',
2220: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2223: FND_MSG_PUB.count_and_get

2219: p_procedure_name => 'PROCESS_RESERVATION',
2220: p_error_text => SUBSTR(SQLERRM,1,240)
2221: );
2222: END IF;
2223: FND_MSG_PUB.count_and_get
2224: (
2225: p_count => x_msg_count,
2226: p_data => x_msg_data,
2227: p_encoded => FND_API.G_FALSE

Line 2300: FND_MSG_PUB.INITIALIZE;

2296:
2297: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
2298: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2299: THEN
2300: FND_MSG_PUB.INITIALIZE;
2301: END IF;
2302:
2303: -- Log API entry point
2304: IF (l_log_procedure >= l_log_current_level) THEN

Line 2317: FND_MSG_PUB.add;

2313: /*
2314: -- Validate to make sure that the Serial Number is not empty, when Supply is Inventory.
2315: IF (l_serial_number_tbl.COUNT < 1) THEN
2316: FND_MESSAGE.set_name( 'AHL', 'AHL_PP_SERIAL_MISSING' );
2317: FND_MSG_PUB.add;
2318: -- log the error
2319: IF (l_log_error >= l_log_current_level) THEN
2320: fnd_log.string
2321: (

Line 2334: FND_MSG_PUB.add;

2330:
2331: -- Validate to make sure that the Serial Number is not empty, when Supply is Inventory.
2332: IF (l_reservation_id_tbl.COUNT < 1) THEN
2333: FND_MESSAGE.set_name( 'AHL', 'AHL_LTP_MULTI_ORG' );
2334: FND_MSG_PUB.add;
2335: -- log the error
2336: IF (l_log_error >= l_log_current_level) THEN
2337: fnd_log.string
2338: (

Line 2414: FND_MSG_PUB.add;

2410: OPEN get_resrv_detials_csr(l_serial_tbl(j),l_reservation_id);
2411: FETCH get_resrv_detials_csr INTO l_inventory_item_id,l_resrv_quantity;
2412: IF (get_resrv_detials_csr%NOTFOUND) THEN
2413: FND_MESSAGE.set_name( 'AHL', 'AHL_MM_SRL_RSRV_INVALID' );
2414: FND_MSG_PUB.add;
2415: -- log the error
2416: IF (l_log_error >= l_log_current_level) THEN
2417: fnd_log.string
2418: (

Line 2538: x_msg_count := FND_MSG_PUB.count_msg;

2534: END LOOP;
2535:
2536:
2537: -- Check Error Message stack.
2538: x_msg_count := FND_MSG_PUB.count_msg;
2539: IF x_msg_count > 0
2540: THEN
2541: -- log the error
2542: IF (l_log_error >= l_log_current_level) THEN

Line 2568: FND_MSG_PUB.count_and_get

2564: END IF;
2565: END IF;
2566:
2567: -- Standard call to get message count and if count is 1, get message info
2568: FND_MSG_PUB.count_and_get
2569: (
2570: p_count => x_msg_count,
2571: p_data => x_msg_data,
2572: p_encoded => FND_API.G_FALSE

Line 2589: FND_MSG_PUB.count_and_get

2585: EXCEPTION
2586: WHEN FND_API.G_EXC_ERROR THEN
2587: ROLLBACK TO CANCEL_RESERVATION_PVT;
2588: x_return_status := FND_API.G_RET_STS_ERROR;
2589: FND_MSG_PUB.count_and_get
2590: (
2591: p_count => x_msg_count,
2592: p_data => x_msg_data,
2593: p_encoded => FND_API.G_FALSE

Line 2599: FND_MSG_PUB.count_and_get

2595:
2596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2597: ROLLBACK TO CANCEL_RESERVATION_PVT;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2599: FND_MSG_PUB.count_and_get
2600: (
2601: p_count => x_msg_count,
2602: p_data => x_msg_data,
2603: p_encoded => FND_API.G_FALSE

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

2605:
2606: WHEN OTHERS THEN
2607: ROLLBACK TO CANCEL_RESERVATION_PVT;
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2610: THEN
2611: FND_MSG_PUB.add_exc_msg
2612: (
2613: p_pkg_name => G_PKG_NAME,

Line 2611: FND_MSG_PUB.add_exc_msg

2607: ROLLBACK TO CANCEL_RESERVATION_PVT;
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2610: THEN
2611: FND_MSG_PUB.add_exc_msg
2612: (
2613: p_pkg_name => G_PKG_NAME,
2614: p_procedure_name => 'CANCEL_RESERVATION',
2615: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2618: FND_MSG_PUB.count_and_get

2614: p_procedure_name => 'CANCEL_RESERVATION',
2615: p_error_text => SUBSTR(SQLERRM,1,240)
2616: );
2617: END IF;
2618: FND_MSG_PUB.count_and_get
2619: (
2620: p_count => x_msg_count,
2621: p_data => x_msg_data,
2622: p_encoded => FND_API.G_FALSE

Line 2796: FND_MSG_PUB.add;

2792: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2793: 'Required demand is not for a workorder/wip_entity_id, p_schedule_material_id:' ||p_schedule_material_id);
2794: END IF;
2795: FND_MESSAGE.set_name( 'AHL', 'AHL_MM_INV_REQ' );
2796: FND_MSG_PUB.add;
2797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2798: RETURN;
2799: END IF;
2800:

Line 3160: FND_MSG_PUB.add;

3156: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3157: 'Required demand is not for a workorder/wip_entity_id, p_schedule_material_id:' ||p_schedule_material_id);
3158: END IF;
3159: FND_MESSAGE.set_name( 'AHL', 'AHL_MM_INV_REQ' );
3160: FND_MSG_PUB.add;
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3162: RETURN;
3163: END IF;
3164: