[Home] [Help]
157: -- Get the Material Requirements details
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
176:
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
194: IF(l_create_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv) THEN
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
446: IF(p_module_type <> G_PKG_NAME ) THEN
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
726: IF(p_module_type <> G_PKG_NAME ) THEN
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
936: IF(p_module_type <> G_PKG_NAME ) THEN
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
955: OPEN get_mtl_req_dtls_csr(l_scheduled_material_id);
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;
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: (
1203: fnd_log.level_statement,
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;
1211: END IF;
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
1230: OPEN get_mtl_req_dtls_csr(l_scheduled_material_id);
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
1573: -- Get the Material Requirements details
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
1592:
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
1676: ELSE -- Check for Create/Update/Transfer
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
2123: END IF;
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
2312:
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
2329: */
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
2409: FOR j IN l_serial_tbl.FIRST..l_serial_tbl.LAST LOOP
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
2791: fnd_log.level_statement,
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;
3155: fnd_log.level_statement,
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;