229: FROM mtl_parameters
230: WHERE organization_id = l_trolin_tbl(1).organization_id;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
234: fnd_msg_pub.ADD;
235: RAISE fnd_api.g_exc_unexpected_error;
236: END;
237:
249: END IF;
250:
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
254: fnd_msg_pub.ADD;
255: RAISE fnd_api.g_exc_unexpected_error;
256: END;
257: END IF;
325: END IF;
326:
327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
326:
327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;
327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:
353: l_mold_tbl_temp := l_mold_tbl;
354:
355: IF (l_mold_tbl.COUNT = 0) THEN
356: l_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
358: fnd_msg_pub.ADD;
359: RAISE fnd_api.g_exc_unexpected_error;
360: ELSE
361: IF (l_debug = 1) THEN
551: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
552: IF (l_debug = 1) THEN
553: print_debug('failed to print labels');
554: END IF;
555: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
556: fnd_msg_pub.ADD;
557: END IF;
558: END IF;
559: EXCEPTION
560: WHEN OTHERS THEN
561: IF (l_debug = 1) THEN
562: print_debug('Exception occured while calling print_label');
563: END IF;
564: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
565: fnd_msg_pub.ADD;
566: END;
567: END IF;
568: --End Bug 6696594
798: FROM mtl_material_transactions_temp
799: WHERE transaction_temp_id = p_transaction_temp_id;
800:
801: IF (l_transaction_action_id = 1) THEN
802: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');
803:
804: SELECT project_id
805: , task_id
806: INTO l_project_id
1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: x_return_status := fnd_api.g_ret_sts_error;
1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1302: fnd_msg_pub.ADD;
1303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1304: WHEN OTHERS THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1359: x_return_status := l_return_status;
1360: EXCEPTION
1361: WHEN fnd_api.g_exc_error THEN
1362: x_return_status := fnd_api.g_ret_sts_error;
1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1369: fnd_msg_pub.ADD;
1370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1371: WHEN OTHERS THEN
1372: x_return_status := fnd_api.g_ret_sts_unexp_error;
1842: NULL;
1843: END LOOP;
1844: EXCEPTION
1845: WHEN record_locked THEN
1846: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');
1847: fnd_msg_pub.ADD;
1848: RAISE fnd_api.g_exc_error;
1849: END;
1850:
2414: print_debug('OVPK: pickedQty is not within overship tolerance level');
2415: print_debug('OVPK: Erroring out');
2416: END IF;
2417:
2418: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2419: x_ovpk_error_code := 3;
2420: fnd_msg_pub.ADD;
2421: RAISE fnd_api.g_exc_error;
2422: ELSE
2447: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
2448: print_debug('OVPK: Erroring out');
2449: END IF;
2450:
2451: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2452: x_ovpk_error_code := 2;
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;*/
2455: --END IF;
2459: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
2460: print_debug('OVPK: Erroring out');
2461: END IF;
2462:
2463: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2464: x_ovpk_error_code := 1;
2465: fnd_msg_pub.ADD;
2466: RAISE fnd_api.g_exc_error;
2467: END IF;
2715: print_debug('OVPK: pickedQty is not within overship tolerance level');
2716: print_debug('OVPK: Erroring out');
2717: END IF;
2718:
2719: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2720: x_ovpk_error_code := 3;
2721: fnd_msg_pub.ADD;
2722: RAISE fnd_api.g_exc_error;
2723: ELSE
2748: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
2749: print_debug('OVPK: Erroring out');
2750: END IF;
2751:
2752: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2753: x_ovpk_error_code := 2;
2754: fnd_msg_pub.ADD;
2755: RAISE fnd_api.g_exc_error;
2756: END IF;
2760: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
2761: print_debug('OVPK: Erroring out');
2762: END IF;
2763:
2764: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2765: x_ovpk_error_code := 1;
2766: fnd_msg_pub.ADD;
2767: RAISE fnd_api.g_exc_error;
2768: END IF;
3257: print_debug('OVPK: pickedQty is not within overship tolerance level');
3258: print_debug('OVPK: Erroring out');
3259: END IF;
3260:
3261: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
3262: x_ovpk_error_code := 3;
3263: fnd_msg_pub.ADD;
3264: RAISE fnd_api.g_exc_error;
3265: ELSE
3290: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
3291: print_debug('OVPK: Erroring out');
3292: END IF;
3293:
3294: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
3295: x_ovpk_error_code := 2;
3296: fnd_msg_pub.ADD;
3297: RAISE fnd_api.g_exc_error;
3298: END IF;*/
3302: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
3303: print_debug('OVPK: Erroring out');
3304: END IF;
3305:
3306: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
3307: x_ovpk_error_code := 1;
3308: fnd_msg_pub.ADD;
3309: RAISE fnd_api.g_exc_error;
3310: END IF;