[Home] [Help]
1128: ( 'Failed to lock lpn'
1129: , l_api_name
1130: );
1131: END IF;
1132: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOCKED');
1133: fnd_msg_pub.ADD;
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success
1136: THEN
1156: );
1157: END IF;
1158: CLOSE c_check_txns;
1159:
1160: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1161: fnd_msg_pub.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: CLOSE c_check_txns;
1264: , l_api_name
1265: );
1266: END IF;
1267:
1268: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1269: fnd_msg_pub.ADD;
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSE
1272: x_first_temp_id := l_txn_temp_id;
4022: END IF;
4023:
4024: IF NOT g_current_drop_lpn.current_drop_list.COUNT > 0
4025: THEN
4026: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
4027: fnd_msg_pub.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF;
4030:
4035: , l_api_name
4036: );
4037: END IF;
4038:
4039: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
4040: fnd_msg_pub.ADD;
4041: RAISE FND_API.G_EXC_ERROR;
4042: END IF; -- end if c_remaining_tasks%FOUND
4043:
5141: , l_api_name
5142: );
5143: END IF;
5144:
5145: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
5146: fnd_msg_pub.ADD;
5147: RAISE FND_API.G_EXC_ERROR;
5148: ELSE
5149: IF l_debug = 1 THEN
5743: , l_api_name
5744: );
5745: END IF;
5746:
5747: fnd_message.set_name('WMS', 'WMS_NOT_ENOUGH_LOOSE_QTY');
5748: fnd_msg_pub.ADD;
5749: RAISE FND_API.G_EXC_ERROR;
5750: ELSE
5751: IF l_debug = 1 THEN
6465: , l_api_name
6466: );
6467: END IF;
6468:
6469: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
6470: fnd_msg_pub.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: ELSE
6473: IF l_debug = 1 THEN
6498: , l_api_name
6499: );
6500: END IF;
6501: CLOSE c_get_lot_msnt;
6502: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6503: fnd_msg_pub.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END IF;
6506: IF c_get_lot_msnt%ISOPEN THEN
6523: , l_api_name
6524: );
6525: END IF;
6526: CLOSE c_get_loose_msnt;
6527: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6528: fnd_msg_pub.ADD;
6529: RAISE FND_API.G_EXC_ERROR;
6530: END IF;
6531: IF c_get_loose_msnt%ISOPEN THEN
6547: , l_api_name
6548: );
6549: END IF;
6550: CLOSE c_get_lpn_msnt;
6551: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6552: fnd_msg_pub.ADD;
6553: RAISE FND_API.G_EXC_ERROR;
6554: END IF;
6555: IF c_get_lpn_msnt%ISOPEN THEN
7827: IF (l_debug = 1) THEN
7828: print_debug ('LPN is outermost LPN, but not done', l_api_name);
7829: END IF;
7830:
7831: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
7832: fnd_msg_pub.ADD;
7833: RAISE FND_API.G_EXC_ERROR;
7834:
7835: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked
7841: , l_api_name
7842: );
7843: END IF;
7844:
7845: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
7846: fnd_msg_pub.ADD;
7847: RAISE FND_API.G_EXC_ERROR;
7848:
7849: ELSE
7863: , l_api_name
7864: );
7865: END IF;
7866:
7867: fnd_message.set_name('WMS', 'WMS_XFER_LPN_DIFF_SUBINV');
7868: fnd_msg_pub.ADD;
7869: RAISE FND_API.G_EXC_ERROR;
7870: ELSE
7871: OPEN c_get_lpn_delivery (to_lpn_rec.lpn_id, p_organization_id);
7880: , l_api_name
7881: );
7882: END IF;
7883:
7884: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
7885: fnd_msg_pub.ADD;
7886: RAISE FND_API.G_EXC_ERROR;
7887: END IF;
7888:
7920: , l_api_name
7921: );
7922: END IF;
7923:
7924: fnd_message.set_name('WMS', 'WMS_INVALID_PACK_DELIVERY');
7925: fnd_msg_pub.ADD;
7926: RAISE FND_API.G_EXC_ERROR;
7927: END IF;
7928:
9503: IF (l_debug = 1) THEN print_debug('exception selecting to_loc_type', l_api_name ); END IF;
9504: RAISE FND_API.G_exc_unexpected_error;
9505: END ;
9506: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN
9507: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN');
9508: fnd_msg_pub.ADD;
9509: IF l_debug = 1 THEN
9510: print_debug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be ' ||
9511: 'staging locator when one of the From LPNs is a consol LPN'
9924: ( 'wms_task_dispatch_gen.complete_pick returned not_ok_to_process'
9925: , l_api_name
9926: );
9927: END IF;
9928: fnd_message.set_name('INV', 'INV-SUBINV NOT RESERVABLE');
9929: fnd_msg_pub.ADD;
9930: RAISE FND_API.G_EXC_ERROR;
9931: END IF;
9932: END IF;
10870: ( 'Cannot use outer LPN as drop LPN'
10871: , l_api_name
10872: );
10873: END IF;
10874: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10875: fnd_msg_pub.ADD;
10876: RAISE FND_API.G_EXC_ERROR;
10877: RETURN;
10878: /*
10886: ( 'Outer LPN is not fully deconsolidated, so cannot use that as drop LPN'
10887: , l_api_name
10888: );
10889: END IF;
10890: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
10891: fnd_msg_pub.ADD;
10892: RAISE FND_API.G_EXC_ERROR;
10893: ELSIF g_current_drop_lpn.multiple_drops <> 'TRUE'
10894: THEN
10898: ( 'No deconsolidation, so cannot reuse outer as drop LPN'
10899: , l_api_name
10900: );
10901: END IF;
10902: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10903: fnd_msg_pub.ADD;
10904: RAISE FND_API.G_EXC_ERROR;
10905: END IF;
10906: RETURN; -- multiple drops is TRUE and outer LPN done
10923: || '/' || to_char(p_drop_loc_id)
10924: , l_api_name
10925: );
10926: END IF;
10927: fnd_message.set_name('WMS', 'WMS_DROP_LPN_SUBLOC_MISMATCH');
10928: fnd_msg_pub.ADD;
10929: RAISE FND_API.G_EXC_ERROR;
10930: END IF;
10931: ELSIF drop_lpn_rec.lpn_context =
10937: ( 'Drop LPN is loaded to dock door already'
10938: , l_api_name
10939: );
10940: END IF;
10941: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOADED');
10942: fnd_msg_pub.ADD;
10943: RAISE FND_API.G_EXC_ERROR;
10944: END IF;
10945:
11024: END IF;
11025:
11026: l_temp_tbl.DELETE;
11027:
11028: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
11029: fnd_msg_pub.ADD;
11030: RAISE FND_API.G_EXC_ERROR;
11031: END IF;
11032:
11056: ( 'Invalid LPN context: ' || to_char(drop_lpn_rec.lpn_context)
11057: , l_api_name
11058: );
11059: END IF;
11060: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_STATUS');
11061: fnd_msg_pub.ADD;
11062: RAISE FND_API.G_EXC_ERROR;
11063: END IF;
11064:
11128: ELSE
11129: IF (l_debug = 1) THEN
11130: print_debug('Picked LPN does not belong to same delivery as Drop LPN. So cannot be dropped', l_api_name);
11131: END IF;
11132: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
11133: fnd_msg_pub.ADD;
11134: RAISE FND_API.G_EXC_ERROR;
11135: END IF;
11136: