[Home] [Help]
479: mydebug('Conversion Factor2: ' || l_conversion_factor2, 'WMS_TASK_LOAD.UPDATE_LOADED_PART');
480: END IF;
481:
482: IF p_lot_controlled <> 'Y' AND p_serial_controlled <> 'Y' THEN -- No Lot or serial control
483: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
484: fnd_msg_pub.ADD;
485: l_primary_quantity := Round(p_transaction_quantity/l_conversion_factor, l_g_decimal_precision);
486: l_secondary_quantity := p_secondary_quantity;
487: ELSE
509: END IF;
510:
511: IF x_return_status <> l_g_ret_sts_success
512: THEN
513: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
514: -- Internal Error $ROUTINE
515: fnd_message.set_token('ROUTINE', ' - proc_parse_lot_serial_catchwt API ' );
516: mydebug('Error parsing lot/serial/catch weight string' );
517: -- "Error reserving Serial Number/s"
511: IF x_return_status <> l_g_ret_sts_success
512: THEN
513: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
514: -- Internal Error $ROUTINE
515: fnd_message.set_token('ROUTINE', ' - proc_parse_lot_serial_catchwt API ' );
516: mydebug('Error parsing lot/serial/catch weight string' );
517: -- "Error reserving Serial Number/s"
518: fnd_msg_pub.ADD;
519: RAISE fnd_api.g_exc_error;
1395: x_cms_check := can_pickdrop(p_transaction_temp_id );
1396: mydebug ('x_cms_check: ' || x_cms_check );
1397: IF x_cms_check = 'FAIL'
1398: THEN
1399: --fnd_message.set_name('WMS', 'WMS_CANCELLED_SOURCE');
1400: -- Source of the task is cancelled by source.. F2 to rollback
1401: --fnd_msg_pub.ADD;
1402: RAISE fnd_api.g_exc_error;
1403: END IF;
1431: AND organization_id = p_organization_id;
1432:
1433: IF SQL%NOTFOUND THEN
1434: mydebug ('Cannot find LPNs to update the context' );
1435: fnd_message.set_name('WMS', 'WMS_WRONG_FROM_LPN_CONTEXT');
1436: -- FROM LPN Context is not valid '
1437: fnd_msg_pub.ADD;
1438: RAISE fnd_api.g_exc_error;
1439:
1455: AND organization_id = p_organization_id;
1456:
1457: IF SQL%NOTFOUND THEN
1458: mydebug ('Cannot find LPNs to update the context' );
1459: fnd_message.set_name('WMS', 'WMS_WRONG_FROM_LPN_CONTEXT');
1460: -- FROM LPN Context is not valid '
1461: fnd_msg_pub.ADD;
1462: RAISE fnd_api.g_exc_error;
1463:
1491: AND organization_id = p_organization_id;
1492:
1493: IF SQL%NOTFOUND THEN
1494: mydebug ('Cannot find LPNs to update the context' );
1495: fnd_message.set_name('WMS', 'WMS_WRONG_TO_LPN_CONTEXT');
1496: -- To LPN Context is not valid
1497: fnd_msg_pub.ADD;
1498:
1499: RAISE fnd_api.g_exc_error;
1792: FROM wms_dispatched_tasks
1793: WHERE transaction_temp_id = p_temp_id);
1794: IF SQL%NOTFOUND THEN
1795: myDebug('Error inserting a new task using WDT record for : '|| p_temp_id);
1796: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1797: -- Internal Error $ROUTINE
1798: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1799: fnd_msg_pub.ADD;
1800: RAISE fnd_api.G_EXC_ERROR;
1794: IF SQL%NOTFOUND THEN
1795: myDebug('Error inserting a new task using WDT record for : '|| p_temp_id);
1796: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1797: -- Internal Error $ROUTINE
1798: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1799: fnd_msg_pub.ADD;
1800: RAISE fnd_api.G_EXC_ERROR;
1801: END IF;
1802: ELSE
1818: WHERE transaction_temp_id = l_transaction_temp_id;
1819: IF SQL%NOTFOUND THEN
1820: mydebug('l_progress : ' || l_progress);
1821: myDebug('Error updating task for : '|| l_transaction_temp_id);
1822: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1823: -- Internal Error $ROUTINE
1824: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1825: fnd_msg_pub.ADD;
1826: RAISE fnd_api.G_EXC_ERROR;
1820: mydebug('l_progress : ' || l_progress);
1821: myDebug('Error updating task for : '|| l_transaction_temp_id);
1822: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1823: -- Internal Error $ROUTINE
1824: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1825: fnd_msg_pub.ADD;
1826: RAISE fnd_api.G_EXC_ERROR;
1827: END IF;
1828: IF p_update = 'Y2' AND p_action = l_g_action_load_multiple THEN
1825: fnd_msg_pub.ADD;
1826: RAISE fnd_api.G_EXC_ERROR;
1827: END IF;
1828: IF p_update = 'Y2' AND p_action = l_g_action_load_multiple THEN
1829: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1830: fnd_msg_pub.ADD;
1831: l_progress := '300';
1832: mydebug('l_progress: ' || l_progress );
1833: -- delete the original one with p_transaction_temp_id
1834: DELETE wms_dispatched_tasks
1835: WHERE transaction_temp_id = p_temp_id;
1836: IF SQL%NOTFOUND THEN
1837: myDebug('Error deleting task for : '|| l_transaction_temp_id);
1838: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1839: -- Internal Error $ROUTINE
1840: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1841: fnd_msg_pub.ADD;
1842: RAISE fnd_api.G_EXC_ERROR;
1836: IF SQL%NOTFOUND THEN
1837: myDebug('Error deleting task for : '|| l_transaction_temp_id);
1838: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
1839: -- Internal Error $ROUTINE
1840: fnd_message.set_token('ROUTINE', '- proc_insert_update_task' );
1841: fnd_msg_pub.ADD;
1842: RAISE fnd_api.G_EXC_ERROR;
1843: END IF;
1844: END IF;
2148: mydebug ('l_confirmed_sec_qty after adding qty for above lot is :' || l_confirmed_sec_qty);
2149: mydebug ('l_confirmed_prim_qty after adding qty for above lot is:' || l_confirmed_prim_qty);
2150:
2151: ELSE --Quantity tree errored out
2152: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2153: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2154: fnd_msg_pub.ADD;
2155: RAISE fnd_api.g_exc_error;
2156: END IF;--}
2149: mydebug ('l_confirmed_prim_qty after adding qty for above lot is:' || l_confirmed_prim_qty);
2150:
2151: ELSE --Quantity tree errored out
2152: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2153: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2154: fnd_msg_pub.ADD;
2155: RAISE fnd_api.g_exc_error;
2156: END IF;--}
2157: ELSE --fulfillment base is 'P'
2333: x_att := l_att;
2334: x_satt := l_satt;
2335:
2336: ELSE --Quantity tree errored out
2337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2339: fnd_msg_pub.ADD;
2340: RAISE fnd_api.g_exc_error;
2341: END IF;--}
2334: x_satt := l_satt;
2335:
2336: ELSE --Quantity tree errored out
2337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2339: fnd_msg_pub.ADD;
2340: RAISE fnd_api.g_exc_error;
2341: END IF;--}
2342: ELSE --fulfillment base is 'P'
3087: FROM mtl_material_transactions_temp
3088: WHERE transaction_temp_id = p_transaction_temp_id);
3089: IF SQL%NOTFOUND THEN
3090: mydebug (' p_transaction_temp_id: NOT found : ' || p_transaction_temp_id);
3091: fnd_message.set_name('WMS', 'WMS_INSERT_ALLOCATION'); -- NEWMSG
3092: -- "Error Inserting Allocation ."
3093: fnd_msg_pub.ADD;
3094: RAISE fnd_api.G_EXC_ERROR;
3095: END IF;
3124: ,x_msg_count => x_msg_count
3125: ,x_msg_data => x_msg_data);
3126: IF x_return_status <> l_g_ret_sts_success
3127: THEN
3128: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
3129: fnd_message.set_token('ROUTINE', ' - proc_parse_lot_serial_catchwt API ' );
3130: mydebug('Error parsing lot/serial/catch weight string' );
3131: RAISE fnd_api.G_EXC_ERROR;
3132: END IF;
3125: ,x_msg_data => x_msg_data);
3126: IF x_return_status <> l_g_ret_sts_success
3127: THEN
3128: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
3129: fnd_message.set_token('ROUTINE', ' - proc_parse_lot_serial_catchwt API ' );
3130: mydebug('Error parsing lot/serial/catch weight string' );
3131: RAISE fnd_api.G_EXC_ERROR;
3132: END IF;
3133: END IF;
3171: ,p_fulfillment_base => NVL(l_fulfillment_base, 'P') -- 16070349
3172: ,p_orig_mmtt_txn_uom => l_orig_mmtt_txn_uom); -- 16070349
3173: IF x_return_status <> l_g_ret_sts_success THEN
3174: mydebug('proc_process_confirmed_lots.x_return_status : ' || x_return_status);
3175: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
3176: fnd_message.set_token('ROUTINE', '- proc_process_confirmed_lots API' );
3177: fnd_msg_pub.ADD;
3178: RAISE fnd_api.g_exc_error;
3179: END IF;
3172: ,p_orig_mmtt_txn_uom => l_orig_mmtt_txn_uom); -- 16070349
3173: IF x_return_status <> l_g_ret_sts_success THEN
3174: mydebug('proc_process_confirmed_lots.x_return_status : ' || x_return_status);
3175: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
3176: fnd_message.set_token('ROUTINE', '- proc_process_confirmed_lots API' );
3177: fnd_msg_pub.ADD;
3178: RAISE fnd_api.g_exc_error;
3179: END IF;
3180: mydebug ('Return from proc_process_confirmed_lots ' );
3216: ,p_substitute_lots => p_substitute_lots --BUG12670785
3217: ,p_full_lot_allocation => p_full_lot_allocation); -- Added for 14699845 (Flexible Lot Allocation)
3218: IF x_return_status <> l_g_ret_sts_success THEN
3219: mydebug('proc_process_confirmed_serials.x_return_status : ' || x_return_status);
3220: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
3221: -- Internal Error $ROUTINE
3222: fnd_message.set_token('ROUTINE', '- proc_process_confirmed_serials API' );
3223: fnd_msg_pub.ADD;
3224: RAISE fnd_api.g_exc_error;
3218: IF x_return_status <> l_g_ret_sts_success THEN
3219: mydebug('proc_process_confirmed_serials.x_return_status : ' || x_return_status);
3220: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
3221: -- Internal Error $ROUTINE
3222: fnd_message.set_token('ROUTINE', '- proc_process_confirmed_serials API' );
3223: fnd_msg_pub.ADD;
3224: RAISE fnd_api.g_exc_error;
3225: END IF;
3226: l_progress := '330';
4807:
4808: EXCEPTION
4809: WHEN No_Data_Found THEN
4810: mydebug ('ERROR !!! MSN and MOQD mismatch exists.' );
4811: fnd_message.set_name('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
4812: fnd_message.set_token('ROUTINE', '- MSN and MOQD mismatch error !' );
4813: fnd_msg_pub.ADD;
4814: RAISE fnd_api.g_exc_error;
4815: WHEN OTHERS THEN
4808: EXCEPTION
4809: WHEN No_Data_Found THEN
4810: mydebug ('ERROR !!! MSN and MOQD mismatch exists.' );
4811: fnd_message.set_name('WMS', 'WMS_LOT_SER_VALIDATION_FAIL');
4812: fnd_message.set_token('ROUTINE', '- MSN and MOQD mismatch error !' );
4813: fnd_msg_pub.ADD;
4814: RAISE fnd_api.g_exc_error;
4815: WHEN OTHERS THEN
4816: mydebug ('ERROR while checking MSN and MOQD mismatch.' );
5267: AND lpn_id = p_lpn_id ;
5268: --AND group_mark_id IS NULL;
5269:
5270: IF SQL%NOTFOUND THEN
5271: fnd_message.set_name('WMS', 'WMS_ERROR_MARKING_SERIAL'); --NEWMSG
5272: -- "Error reserving Serial Number/s"
5273: fnd_msg_pub.ADD;
5274: RAISE fnd_api.G_EXC_ERROR;
5275: END IF;
5289: FROM mtl_allocations_gtmp
5290: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@'));
5291:
5292: IF SQL%NOTFOUND THEN
5293: fnd_message.set_name('WMS', 'WMS_ERROR_MARKING_SERIAL'); --NEWMSG
5294: -- "Error reserving Serial Number/s"
5295: fnd_msg_pub.ADD;
5296: RAISE fnd_api.G_EXC_ERROR;
5297: END IF;
5649: mydebug('rec_mmtt1.SECONDARY_UOM_CODE = ' || rec_mmtt1.SECONDARY_UOM_CODE);
5650: mydebug('rec_mmtt1.fulfillment_base = ' || rec_mmtt1.fulfillment_base);
5651:
5652: IF rec_mmtt1.item_primary_uom_code IS NULL THEN
5653: fnd_message.set_name('WMS', 'WMS_NULL_PRIM_UOM');
5654: -- Item primary UOM is null for this task
5655: fnd_msg_pub.ADD;
5656: RAISE fnd_api.g_exc_unexpected_error;
5657: END IF;
6400: mydebug('End .. ' || l_proc_name);
6401: EXCEPTION
6402: WHEN fnd_api.g_exc_error THEN
6403: x_return_status := l_g_ret_sts_error;
6404: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6405: -- Internal Error $ROUTINE
6406: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6407: fnd_msg_pub.ADD;
6408: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6402: WHEN fnd_api.g_exc_error THEN
6403: x_return_status := l_g_ret_sts_error;
6404: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6405: -- Internal Error $ROUTINE
6406: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6407: fnd_msg_pub.ADD;
6408: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6409: mydebug('ROLLBACK ' );
6410: ROLLBACK ;
6411: mydebug('l_progress = ' || l_proc_name || ':'|| l_progress);
6412: mydebug('fnd_api.g_exc_error: ' || SQLERRM);
6413: WHEN fnd_api.g_exc_unexpected_error THEN
6414: x_return_status := fnd_api.g_ret_sts_unexp_error;
6415: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6416: -- Internal Error $ROUTINE
6417: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6418: fnd_msg_pub.ADD;
6419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6413: WHEN fnd_api.g_exc_unexpected_error THEN
6414: x_return_status := fnd_api.g_ret_sts_unexp_error;
6415: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6416: -- Internal Error $ROUTINE
6417: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6418: fnd_msg_pub.ADD;
6419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6420: mydebug('ROLLBACK ' );
6421: mydebug('l_progress = ' || l_proc_name || ':'|| l_progress);
6423: mydebug('x_msg_count/Data = ' || x_msg_count || '/'|| x_msg_data);
6424: ROLLBACK ;
6425: WHEN OTHERS THEN
6426: x_return_status := l_g_ret_sts_unexp_error;
6427: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6428: -- Internal Error $ROUTINE
6429: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6430: fnd_msg_pub.ADD;
6431: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6425: WHEN OTHERS THEN
6426: x_return_status := l_g_ret_sts_unexp_error;
6427: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6428: -- Internal Error $ROUTINE
6429: fnd_message.set_token('ROUTINE', '- Process_f2 API' );
6430: fnd_msg_pub.ADD;
6431: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6432: mydebug('ROLLBACK ' );
6433: ROLLBACK ;
6659: , last_update_date = SYSDATE
6660: , last_updated_by = p_user_id
6661: WHERE line_id = rec_cancelled_mols.line_id;
6662: IF SQL%NOTFOUND THEN
6663: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6664: -- Internal Error $ROUTINE
6665: fnd_message.set_token('ROUTINE', '-proc_process_cancelled_MOLs' );
6666: myDebug('Error updating MTRL in proc_process_cancelled_MOLs for line: ' || rec_cancelled_mols.line_id);
6667: fnd_msg_pub.ADD;
6661: WHERE line_id = rec_cancelled_mols.line_id;
6662: IF SQL%NOTFOUND THEN
6663: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR'); --NEWMSG
6664: -- Internal Error $ROUTINE
6665: fnd_message.set_token('ROUTINE', '-proc_process_cancelled_MOLs' );
6666: myDebug('Error updating MTRL in proc_process_cancelled_MOLs for line: ' || rec_cancelled_mols.line_id);
6667: fnd_msg_pub.ADD;
6668: END IF;
6669: END LOOP;
7635: l_progress := '130';
7636: IF (l_debug = 1) THEN mydebug ('l_progress: ' || l_progress ); END IF;
7637: IF p_confirmed_qty = 0 AND p_exception <> l_g_exception_short
7638: THEN
7639: fnd_message.set_name('WMS', 'WMS_PICK_ZERO_QTY');
7640: -- Confirmed qty for this task is zero
7641: fnd_msg_pub.ADD;
7642: RAISE fnd_api.g_exc_unexpected_error;
7643: END IF;
7746: x_return_status => l_return_status,
7747: x_msg_data => l_msg_data);
7748: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7749: THEN
7750: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7751: -- Internal Error $ROUTINE
7752: fnd_message.set_token('ROUTINE', '-INSERT_SERIAL API - ' || p_action);
7753: fnd_msg_pub.ADD;
7754: RAISE fnd_api.g_exc_unexpected_error;
7748: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7749: THEN
7750: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7751: -- Internal Error $ROUTINE
7752: fnd_message.set_token('ROUTINE', '-INSERT_SERIAL API - ' || p_action);
7753: fnd_msg_pub.ADD;
7754: RAISE fnd_api.g_exc_unexpected_error;
7755: ELSE
7756: IF (l_debug = 1) THEN
7779: x_return_status => l_return_status,
7780: x_msg_data => l_msg_data);
7781: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7782: THEN
7783: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7784: -- Internal Error $ROUTINE
7785: fnd_message.set_token('ROUTINE', '- INSERT_SERIAL API - ');
7786: fnd_msg_pub.ADD;
7787: RAISE fnd_api.g_exc_unexpected_error;
7781: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7782: THEN
7783: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7784: -- Internal Error $ROUTINE
7785: fnd_message.set_token('ROUTINE', '- INSERT_SERIAL API - ');
7786: fnd_msg_pub.ADD;
7787: RAISE fnd_api.g_exc_unexpected_error;
7788: ELSE
7789: IF (l_debug = 1) THEN
7841: ,p_fulfillment_base => p_fulfillment_base); -- 16070349
7842:
7843: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7844: THEN
7845: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7846: -- Internal Error $ROUTINE
7847: fnd_message.set_token('ROUTINE', '-Task_Merge_Split API - ' || p_action);
7848: fnd_msg_pub.ADD;
7849: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7843: IF l_return_status IN ( fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error)
7844: THEN
7845: fnd_message.set_name('WMS', 'WMS_INTERNAL_ERROR');
7846: -- Internal Error $ROUTINE
7847: fnd_message.set_token('ROUTINE', '-Task_Merge_Split API - ' || p_action);
7848: fnd_msg_pub.ADD;
7849: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7850: RAISE fnd_api.g_exc_unexpected_error;
7851: ELSE
8002: mydebug ('l_new_txn_hdr_id: ' || l_new_txn_hdr_id );
8003: mydebug ('x_return_status: ' || x_return_status );
8004: END IF;
8005: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8006: --fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
8007: --fnd_msg_pub.ADD;
8008: RAISE fnd_api.g_exc_unexpected_error;
8009: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8010: --fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
8006: --fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
8007: --fnd_msg_pub.ADD;
8008: RAISE fnd_api.g_exc_unexpected_error;
8009: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8010: --fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
8011: --fnd_msg_pub.ADD;
8012: RAISE fnd_api.g_exc_error;
8013: END IF;
8014:
8658: IF (l_debug = 1) THEN
8659: mydebug('lpn does not exist in org');
8660: END IF;
8661:
8662: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8663: fnd_msg_pub.ADD;
8664: RAISE fnd_api.g_exc_error;
8665: END;
8666:
8670: IF (l_debug = 1) THEN
8671: mydebug('LPN does not exist in org');
8672: END IF;
8673:
8674: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8675: fnd_msg_pub.ADD;
8676: RAISE fnd_api.g_exc_error;
8677: END IF;
8678:
8700: END;
8701:
8702: IF l_loaded > 0 THEN
8703: x_match := 7;
8704: fnd_message.set_name('WMS', 'WMS_LOADED_ERROR');
8705: fnd_msg_pub.ADD;
8706: RAISE fnd_api.g_exc_error;
8707: END IF;
8708:
8730: IF l_sub IS NULL THEN
8731: -- The calling java code treats this condition as an error
8732:
8733: x_match := 10;
8734: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
8735: fnd_msg_pub.ADD;
8736: RAISE fnd_api.g_exc_error;
8737: END IF;
8738:
8746: AND secondary_inventory_name = l_sub;
8747:
8748: IF l_sub_active = 0 THEN
8749: x_match := 10;
8750: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
8751: fnd_msg_pub.ADD;
8752: RAISE fnd_api.g_exc_error;
8753: END IF;
8754:
8762: AND inventory_location_id = l_loc_id;
8763:
8764: IF l_loc_active = 0 THEN
8765: x_match := 10;
8766: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
8767: fnd_msg_pub.ADD;
8768: RAISE fnd_api.g_exc_error;
8769: END IF;
8770: -- Begin fix for 2774506
8800: mydebug('mil task id = '||l_mil_task_id);
8801:
8802: IF ((l_mil_proj_id <> l_mmtt_proj_id ) or ( l_mil_task_id <> l_mmtt_task_id )) THEN
8803: mydebug('lpn : the project/tak information does not match');
8804: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
8805: FND_MSG_PUB.ADD;
8806: RAISE FND_API.G_EXC_ERROR;
8807: END IF;
8808:
8814: x_loc_id := l_loc_id;
8815: EXCEPTION
8816: WHEN NO_DATA_FOUND THEN
8817: x_match := 6;
8818: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
8819: fnd_msg_pub.ADD;
8820: RAISE fnd_api.g_exc_error;
8821: END;
8822:
8845: END;
8846:
8847: IF l_so_cnt > 0 THEN
8848: x_match := 12;
8849: fnd_message.set_name('WMS', 'WMS_LPN_STAGED');
8850: fnd_msg_pub.ADD;
8851: RAISE fnd_api.g_exc_error;
8852: END IF;
8853:
8901: mydebug('item lot rev combo does not exist');
8902: END IF;
8903:
8904: x_match := 13;
8905: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8906: fnd_msg_pub.ADD;
8907: RAISE fnd_api.g_exc_error;
8908: END;
8909:
8938: mydebug('lot rev combo for the item does not exist');
8939: END IF;
8940:
8941: x_match := 5;
8942: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT_LPN');
8943: fnd_msg_pub.ADD;
8944: RAISE fnd_api.g_exc_error;
8945: END;
8946: END IF;
8991: IF (l_debug = 1) THEN
8992: mydebug('transaction does not exist in mmtt');
8993: END IF;
8994:
8995: fnd_message.set_name('INV', 'INV_INVALID_TRANSACTION');
8996: fnd_msg_pub.ADD;
8997: RAISE fnd_api.g_exc_error;
8998: END;
8999:
9078: END IF;
9079:
9080: -- Serial numbers missing for the transaction
9081: x_match := 9;
9082: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
9083: fnd_msg_pub.ADD;
9084: RAISE fnd_api.g_exc_error;
9085: END IF;
9086: END IF;
9147: IF (l_debug = 1) THEN
9148: mydebug('calling update qty tree with lpn 1st time failed ');
9149: END IF;
9150:
9151: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9152: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9153: fnd_msg_pub.ADD;
9154: RAISE fnd_api.g_exc_error;
9155: END IF;
9148: mydebug('calling update qty tree with lpn 1st time failed ');
9149: END IF;
9150:
9151: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9152: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9153: fnd_msg_pub.ADD;
9154: RAISE fnd_api.g_exc_error;
9155: END IF;
9156: --Bug#5649056: only update if subinventory and locator match
9199: IF (l_debug = 1) THEN
9200: mydebug('calling update qty tree back without lpn 1st time failed ');
9201: END IF;
9202:
9203: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9204: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9205: fnd_msg_pub.ADD;
9206: RAISE fnd_api.g_exc_error;
9207: END IF;
9200: mydebug('calling update qty tree back without lpn 1st time failed ');
9201: END IF;
9202:
9203: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9204: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9205: fnd_msg_pub.ADD;
9206: RAISE fnd_api.g_exc_error;
9207: END IF;
9208: END IF; --}
9304: IF (l_debug = 1) THEN
9305: mydebug('calling qty tree 1st time failed ');
9306: END IF;
9307:
9308: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9309: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9310: fnd_msg_pub.ADD;
9311: RAISE fnd_api.g_exc_error;
9312: END IF; --}
9305: mydebug('calling qty tree 1st time failed ');
9306: END IF;
9307:
9308: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9309: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9310: fnd_msg_pub.ADD;
9311: RAISE fnd_api.g_exc_error;
9312: END IF; --}
9313:
9358: IF (l_debug = 1) THEN
9359: mydebug('calling update qty tree back with lpn 1st time failed ');
9360: END IF;
9361:
9362: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9363: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9364: fnd_msg_pub.ADD;
9365: RAISE fnd_api.g_exc_error;
9366: END IF;
9359: mydebug('calling update qty tree back with lpn 1st time failed ');
9360: END IF;
9361:
9362: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9363: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9364: fnd_msg_pub.ADD;
9365: RAISE fnd_api.g_exc_error;
9366: END IF;
9367: --Bug#5649056: only update if subinventory and locator match
9410: IF (l_debug = 1) THEN
9411: mydebug('calling update qty tree back without lpn 1st time failed ');
9412: END IF;
9413:
9414: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9415: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9416: fnd_msg_pub.ADD;
9417: RAISE fnd_api.g_exc_error;
9418: END IF;
9411: mydebug('calling update qty tree back without lpn 1st time failed ');
9412: END IF;
9413:
9414: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9415: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9416: fnd_msg_pub.ADD;
9417: RAISE fnd_api.g_exc_error;
9418: END IF;
9419: END IF; --}
9468: END IF;
9469:
9470: -- Serial numbers missing for the transaction
9471: x_match := 9;
9472: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
9473: fnd_msg_pub.ADD;
9474: RAISE fnd_api.g_exc_error;
9475: END IF;
9476: END IF;
9527: IF (l_debug = 1) THEN
9528: mydebug('calling update qty tree with lpn 2nd time failed ');
9529: END IF;
9530:
9531: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9532: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9533: fnd_msg_pub.ADD;
9534: RAISE fnd_api.g_exc_error;
9535: END IF;
9528: mydebug('calling update qty tree with lpn 2nd time failed ');
9529: END IF;
9530:
9531: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9532: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9533: fnd_msg_pub.ADD;
9534: RAISE fnd_api.g_exc_error;
9535: END IF;
9536: --Bug#5649056: only update if subinventory and locator match
9579: IF (l_debug = 1) THEN
9580: mydebug('calling update qty tree back without lpn 2nd time failed ');
9581: END IF;
9582:
9583: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9584: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9585: fnd_msg_pub.ADD;
9586: RAISE fnd_api.g_exc_error;
9587: END IF;
9580: mydebug('calling update qty tree back without lpn 2nd time failed ');
9581: END IF;
9582:
9583: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9584: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9585: fnd_msg_pub.ADD;
9586: RAISE fnd_api.g_exc_error;
9587: END IF;
9588: END IF; --}
9652: IF (l_debug = 1) THEN
9653: mydebug('calling qty tree 2nd time failed ');
9654: END IF;
9655:
9656: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9657: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9658: fnd_msg_pub.ADD;
9659: RAISE fnd_api.g_exc_error;
9660: END IF;
9653: mydebug('calling qty tree 2nd time failed ');
9654: END IF;
9655:
9656: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9657: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9658: fnd_msg_pub.ADD;
9659: RAISE fnd_api.g_exc_error;
9660: END IF;
9661:
9706: IF (l_debug = 1) THEN
9707: mydebug('calling update qty tree with lpn 2nd time failed ');
9708: END IF;
9709:
9710: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9711: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9712: fnd_msg_pub.ADD;
9713: RAISE fnd_api.g_exc_error;
9714: END IF;
9707: mydebug('calling update qty tree with lpn 2nd time failed ');
9708: END IF;
9709:
9710: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9711: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9712: fnd_msg_pub.ADD;
9713: RAISE fnd_api.g_exc_error;
9714: END IF;
9715: --Bug#5649056: only update if subinventory and locator match
9758: IF (l_debug = 1) THEN
9759: mydebug('calling update qty tree back without lpn 2nd time failed ');
9760: END IF;
9761:
9762: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9763: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9764: fnd_msg_pub.ADD;
9765: RAISE fnd_api.g_exc_error;
9766: END IF;
9759: mydebug('calling update qty tree back without lpn 2nd time failed ');
9760: END IF;
9761:
9762: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9763: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9764: fnd_msg_pub.ADD;
9765: RAISE fnd_api.g_exc_error;
9766: END IF;
9767: END IF; --}
9826: END IF;
9827:
9828: -- Serial numbers missing for the transaction
9829: x_match := 9;
9830: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
9831: fnd_msg_pub.ADD;
9832: RAISE fnd_api.g_exc_error;
9833: END IF;
9834: END IF; --}
9906: IF (l_debug = 1) THEN
9907: mydebug('calling update qty tree with lpn 3rd time failed ');
9908: END IF;
9909:
9910: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9911: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9912: fnd_msg_pub.ADD;
9913: RAISE fnd_api.g_exc_error;
9914: END IF;
9907: mydebug('calling update qty tree with lpn 3rd time failed ');
9908: END IF;
9909:
9910: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9911: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9912: fnd_msg_pub.ADD;
9913: RAISE fnd_api.g_exc_error;
9914: END IF;
9915: --Bug#5649056: only update if subinventory and locator match
9958: IF (l_debug = 1) THEN
9959: mydebug('calling update qty tree back 3rd time without lpn 3rd time failed ');
9960: END IF;
9961:
9962: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9963: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9964: fnd_msg_pub.ADD;
9965: RAISE fnd_api.g_exc_error;
9966: END IF;
9959: mydebug('calling update qty tree back 3rd time without lpn 3rd time failed ');
9960: END IF;
9961:
9962: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9963: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9964: fnd_msg_pub.ADD;
9965: RAISE fnd_api.g_exc_error;
9966: END IF;
9967: END IF;--}
10081: IF (l_debug = 1) THEN
10082: mydebug('calling qty tree 3rd time failed ');
10083: END IF;
10084:
10085: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10086: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10087: fnd_msg_pub.ADD;
10088: RAISE fnd_api.g_exc_error;
10089: END IF; --}
10082: mydebug('calling qty tree 3rd time failed ');
10083: END IF;
10084:
10085: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10086: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10087: fnd_msg_pub.ADD;
10088: RAISE fnd_api.g_exc_error;
10089: END IF; --}
10090:
10258: IF (l_debug = 1) THEN
10259: mydebug('calling update qty tree with lpn 3rd time failed ');
10260: END IF;
10261:
10262: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10263: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10264: fnd_msg_pub.ADD;
10265: RAISE fnd_api.g_exc_error;
10266: END IF;
10259: mydebug('calling update qty tree with lpn 3rd time failed ');
10260: END IF;
10261:
10262: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10263: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10264: fnd_msg_pub.ADD;
10265: RAISE fnd_api.g_exc_error;
10266: END IF;
10267: --Bug#5649056: only update if subinventory and locator match
10310: IF (l_debug = 1) THEN
10311: mydebug('calling update qty tree back without lpn 3rd time failed ');
10312: END IF;
10313:
10314: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10315: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10316: fnd_msg_pub.ADD;
10317: RAISE fnd_api.g_exc_error;
10318: END IF;
10311: mydebug('calling update qty tree back without lpn 3rd time failed ');
10312: END IF;
10313:
10314: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10315: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10316: fnd_msg_pub.ADD;
10317: RAISE fnd_api.g_exc_error;
10318: END IF;
10319: END IF; --}
10426: END IF;
10427:
10428: -- Serial numbers missing for the transaction
10429: x_match := 9;
10430: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
10431: fnd_msg_pub.ADD;
10432: RAISE fnd_api.g_exc_error;
10433: END IF;
10434: END IF; --}
10486: IF (l_debug = 1) THEN
10487: mydebug('calling update qty tree with lpn 4th time failed ');
10488: END IF;
10489:
10490: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10491: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10492: fnd_msg_pub.ADD;
10493: RAISE fnd_api.g_exc_error;
10494: END IF;
10487: mydebug('calling update qty tree with lpn 4th time failed ');
10488: END IF;
10489:
10490: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10491: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10492: fnd_msg_pub.ADD;
10493: RAISE fnd_api.g_exc_error;
10494: END IF;
10495: --Bug#5649056: only update if subinventory and locator match
10539: IF (l_debug = 1) THEN
10540: mydebug('calling update qty tree without lpn 4th time failed ');
10541: END IF;
10542:
10543: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10544: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10545: fnd_msg_pub.ADD;
10546: RAISE fnd_api.g_exc_error;
10547: END IF;
10540: mydebug('calling update qty tree without lpn 4th time failed ');
10541: END IF;
10542:
10543: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10544: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10545: fnd_msg_pub.ADD;
10546: RAISE fnd_api.g_exc_error;
10547: END IF;
10548: END IF; --}
10646: IF (l_debug = 1) THEN
10647: mydebug('calling qty tree 4th time failed');
10648: END IF;
10649:
10650: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10651: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10652: fnd_msg_pub.ADD;
10653: RAISE fnd_api.g_exc_error;
10654: END IF; --}
10647: mydebug('calling qty tree 4th time failed');
10648: END IF;
10649:
10650: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10651: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10652: fnd_msg_pub.ADD;
10653: RAISE fnd_api.g_exc_error;
10654: END IF; --}
10655:
10700: IF (l_debug = 1) THEN
10701: mydebug('calling update qty tree back with lpn 4th time failed ');
10702: END IF;
10703:
10704: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10705: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10706: fnd_msg_pub.ADD;
10707: RAISE fnd_api.g_exc_error;
10708: END IF;
10701: mydebug('calling update qty tree back with lpn 4th time failed ');
10702: END IF;
10703:
10704: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10705: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10706: fnd_msg_pub.ADD;
10707: RAISE fnd_api.g_exc_error;
10708: END IF;
10709: --Bug#5649056: only update if subinventory and locator match
10752: IF (l_debug = 1) THEN
10753: mydebug('calling update qty tree back without lpn 4th time failed ');
10754: END IF;
10755:
10756: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10757: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10758: fnd_msg_pub.ADD;
10759: RAISE fnd_api.g_exc_error;
10760: END IF;
10753: mydebug('calling update qty tree back without lpn 4th time failed ');
10754: END IF;
10755:
10756: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10757: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10758: fnd_msg_pub.ADD;
10759: RAISE fnd_api.g_exc_error;
10760: END IF;
10761: END IF; --}
10890: IF (l_debug = 1) THEN
10891: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
10892: END IF;
10893:
10894: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10895: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10896: fnd_msg_pub.ADD;
10897: RAISE fnd_api.g_exc_error;
10898: END IF;
10891: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
10892: END IF;
10893:
10894: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10895: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10896: fnd_msg_pub.ADD;
10897: RAISE fnd_api.g_exc_error;
10898: END IF;
10899:
10940: IF (l_debug = 1) THEN
10941: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
10942: END IF;
10943:
10944: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10945: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10946: fnd_msg_pub.ADD;
10947: RAISE fnd_api.g_exc_error;
10948: END IF;
10941: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
10942: END IF;
10943:
10944: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10945: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10946: fnd_msg_pub.ADD;
10947: RAISE fnd_api.g_exc_error;
10948: END IF;
10949: END IF;
11136: IF (l_debug = 1) THEN
11137: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
11138: END IF;
11139:
11140: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11141: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11142: fnd_msg_pub.ADD;
11143: RAISE fnd_api.g_exc_error;
11144: END IF;
11137: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
11138: END IF;
11139:
11140: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11141: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11142: fnd_msg_pub.ADD;
11143: RAISE fnd_api.g_exc_error;
11144: END IF;
11145: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
11185: IF (l_debug = 1) THEN
11186: mydebug('calling update qty tree back for +ve qty without lpn for FlexiLotAlloc failed ');
11187: END IF;
11188:
11189: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11190: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11191: fnd_msg_pub.ADD;
11192: RAISE fnd_api.g_exc_error;
11193: END IF;
11186: mydebug('calling update qty tree back for +ve qty without lpn for FlexiLotAlloc failed ');
11187: END IF;
11188:
11189: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11190: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11191: fnd_msg_pub.ADD;
11192: RAISE fnd_api.g_exc_error;
11193: END IF;
11194: END IF;
11409: END IF;
11410:
11411: x_match := 11;
11412: CLOSE ser_csr;
11413: fnd_message.set_name('INV', 'INV_SER_STATUS_NA');
11414: fnd_message.set_token('TOKEN', l_serial_number);
11415: fnd_msg_pub.ADD;
11416: RAISE fnd_api.g_exc_error;
11417: END IF;
11410:
11411: x_match := 11;
11412: CLOSE ser_csr;
11413: fnd_message.set_name('INV', 'INV_SER_STATUS_NA');
11414: fnd_message.set_token('TOKEN', l_serial_number);
11415: fnd_msg_pub.ADD;
11416: RAISE fnd_api.g_exc_error;
11417: END IF;
11418: END LOOP;
11438: ) = 'N' THEN
11439: x_match := 8;
11440: -- LPN status is invalid for this operation
11441:
11442: fnd_message.set_name('INV', 'INV_INVALID_LPN_STATUS');
11443: fnd_message.set_token('TOKEN1', TO_CHAR(p_fromlpn_id));
11444: fnd_msg_pub.ADD;
11445: RAISE fnd_api.g_exc_error;
11446: END IF;
11439: x_match := 8;
11440: -- LPN status is invalid for this operation
11441:
11442: fnd_message.set_name('INV', 'INV_INVALID_LPN_STATUS');
11443: fnd_message.set_token('TOKEN1', TO_CHAR(p_fromlpn_id));
11444: fnd_msg_pub.ADD;
11445: RAISE fnd_api.g_exc_error;
11446: END IF;
11447: END IF;
11873: EXCEPTION
11874: WHEN OTHERS THEN
11875: IF SQLCODE = -54 THEN -- ORA-0054: resource busy and acquire with NOWAIT specified
11876: mydebug('LPN record is locked by another user... cannot pick this LPN' );
11877: fnd_message.set_name('WMS', 'WMS_LPN_LOCKED_ERROR');
11878: -- LPN is in use by another user
11879: fnd_msg_pub.ADD;
11880: RAISE fnd_api.g_exc_error;
11881: ELSE
12452: ELSE
12453: IF (l_debug = 1) THEN
12454: mydebug('calling qty tree 1st time failed ');
12455: END IF;
12456: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
12457: fnd_message.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
12458: fnd_msg_pub.ADD;
12459: RAISE fnd_api.g_exc_error;
12460: END IF; --}
12453: IF (l_debug = 1) THEN
12454: mydebug('calling qty tree 1st time failed ');
12455: END IF;
12456: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
12457: fnd_message.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
12458: fnd_msg_pub.ADD;
12459: RAISE fnd_api.g_exc_error;
12460: END IF; --}
12461:
12692: ) THEN
12693: IF (l_debug = 1) THEN
12694: mydebug('check_pack_lpn: LPN already exists but with different context or Org');
12695: END IF;--bug9165521
12696: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_ORG');
12697: fnd_msg_pub.ADD;
12698:
12699:
12700: x_return_status := fnd_api.g_ret_sts_error;
12737:
12738: IF (l_debug = 1) THEN
12739: mydebug('check_pack_lpn: LPN already exists but with different context or Org');
12740: END IF;--bug9165521
12741: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_CONTEXT');
12742: fnd_msg_pub.ADD;
12743:
12744:
12745: x_return_status := fnd_api.g_ret_sts_error;
12761:
12762: IF (l_debug = 1) THEN
12763: mydebug('check_pack_lpn: LPN already exists but with different context or Org');
12764: END IF;--bug9165521
12765: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_CONTEXT');
12766: fnd_msg_pub.ADD;
12767:
12768:
12769: x_return_status := fnd_api.g_ret_sts_error;
12813: END IF;
12814:
12815: IF l_return_status = fnd_api.g_ret_sts_unexp_error
12816: OR l_return_status = fnd_api.g_ret_sts_error THEN
12817: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
12818: fnd_msg_pub.ADD;
12819: RAISE fnd_api.g_exc_unexpected_error;
12820: END IF;
12821:
13062: --
13063: -- Standard call to check for call compatibility
13064: --
13065: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
13066: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
13067: fnd_msg_pub.ADD;
13068: RAISE fnd_api.g_exc_error;
13069: END IF;
13070:
13183: OR x_return_status = fnd_api.g_ret_sts_error THEN
13184: RAISE fnd_api.g_exc_error;
13185: END IF;
13186: ELSE
13187: fnd_message.set_name('WMS','WMS_INVALID_PACK_DELIVERY');
13188: fnd_msg_pub.ADD;
13189: RAISE fnd_api.g_exc_error;
13190: END IF;
13191: END;
13222: EXCEPTION
13223: WHEN no_data_found THEN
13224: -- error out and assuming it should exist
13225: -- tolpn doesn't existing or if existing, but has wrong context
13226: fnd_message.set_name('WMS', 'WMS_LPN_NOT_FOUND');
13227: fnd_msg_pub.ADD;
13228: RAISE fnd_api.g_exc_error;
13229: END;
13230: IF (l_debug = 1) THEN
13233: IF (l_container_item_id = -999) THEN --lpn does not use any container
13234: IF (l_debug = 1) THEN
13235: mydebug('LPN does not use any container');
13236: END IF;
13237: fnd_message.set_name('WMS', 'WMS_LPN_NOT_LINKTO_CONT');
13238: fnd_message.set_token('LPN', p_pick_to_lpn );
13239: fnd_msg_pub.ADD;
13240: RAISE fnd_api.g_exc_error;
13241: ELSIF (l_container_item_id <> p_container_item_id) THEN
13234: IF (l_debug = 1) THEN
13235: mydebug('LPN does not use any container');
13236: END IF;
13237: fnd_message.set_name('WMS', 'WMS_LPN_NOT_LINKTO_CONT');
13238: fnd_message.set_token('LPN', p_pick_to_lpn );
13239: fnd_msg_pub.ADD;
13240: RAISE fnd_api.g_exc_error;
13241: ELSIF (l_container_item_id <> p_container_item_id) THEN
13242: IF (l_debug = 1) THEN
13251: EXCEPTION
13252: WHEN OTHERS THEN
13253: l_concatenated_segments := '';
13254: END;
13255: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13256: fnd_message.set_token('LPN', p_pick_to_lpn );
13257: fnd_message.set_token('CONTAINER', l_concatenated_segments);
13258: fnd_msg_pub.ADD;
13259: RAISE fnd_api.g_exc_error;
13252: WHEN OTHERS THEN
13253: l_concatenated_segments := '';
13254: END;
13255: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13256: fnd_message.set_token('LPN', p_pick_to_lpn );
13257: fnd_message.set_token('CONTAINER', l_concatenated_segments);
13258: fnd_msg_pub.ADD;
13259: RAISE fnd_api.g_exc_error;
13260: END IF;
13253: l_concatenated_segments := '';
13254: END;
13255: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13256: fnd_message.set_token('LPN', p_pick_to_lpn );
13257: fnd_message.set_token('CONTAINER', l_concatenated_segments);
13258: fnd_msg_pub.ADD;
13259: RAISE fnd_api.g_exc_error;
13260: END IF;
13261: ELSE
13269: ELSE
13270: IF (l_debug = 1) THEN
13271: mydebug('Container changed. error out');
13272: END IF;
13273: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13274: fnd_message.set_token('LPN', p_pick_to_lpn );
13275: fnd_message.set_token('CONTAINER', p_suggested_container_item );
13276: fnd_msg_pub.ADD;
13277: RAISE fnd_api.g_exc_error;
13270: IF (l_debug = 1) THEN
13271: mydebug('Container changed. error out');
13272: END IF;
13273: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13274: fnd_message.set_token('LPN', p_pick_to_lpn );
13275: fnd_message.set_token('CONTAINER', p_suggested_container_item );
13276: fnd_msg_pub.ADD;
13277: RAISE fnd_api.g_exc_error;
13278: END IF;
13271: mydebug('Container changed. error out');
13272: END IF;
13273: fnd_message.set_name('WMS', 'WMS_LPN_ASSOC_WITH_CONT');
13274: fnd_message.set_token('LPN', p_pick_to_lpn );
13275: fnd_message.set_token('CONTAINER', p_suggested_container_item );
13276: fnd_msg_pub.ADD;
13277: RAISE fnd_api.g_exc_error;
13278: END IF;
13279: END IF;
13338: IF l_commingle_exist = 'Y' THEN
13339: IF (l_debug = 1) THEN
13340: mydebug('Cost group commigle exist.');
13341: END IF;
13342: fnd_message.set_name('WMS', 'WMS_CG_COMMINGLE');
13343: fnd_msg_pub.ADD;
13344: RAISE fnd_api.g_exc_error;
13345: ELSE
13346: IF (l_debug = 1) THEN
13392: from mtl_material_transactions_temp
13393: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
13394: and transaction_header_id <>l_transaction_header_id);
13395:
13396: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_NOT_NEW'); -- new message
13397: fnd_msg_pub.ADD;
13398: RAISE fnd_api.g_exc_error;
13399: EXCEPTION
13400: WHEN NO_DATA_FOUND THEN RETURN; -- this lpn is fine and no need to do all
13409: from mtl_material_transactions_temp
13410: where transfer_lpn_id = pick_to_lpn_rec.lpn_id
13411: and transaction_temp_id = parent_line_id -- bulk task
13412: );
13413: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_BULK');
13414: fnd_msg_pub.ADD;
13415: RAISE fnd_api.g_exc_error;
13416: EXCEPTION
13417: WHEN NO_DATA_FOUND THEN null;
13469: mydebug(' l_mmtt_mo_type => ' || l_mmtt_mo_type);
13470: mydebug(' l_mo_type_in_lpn => ' || l_mo_type_in_lpn);
13471: END IF;
13472:
13473: fnd_message.set_name('WMS', 'WMS_LPN_FB_COMINGLE');
13474: fnd_msg_pub.ADD;
13475: RAISE fnd_api.g_exc_error;
13476: ELSIF l_mmtt_txn_type_id = 35
13477: OR l_mmtt_txn_type_id = 51 THEN -- Mfg pick
13479: IF (l_debug = 1) THEN
13480: mydebug('validate_pick_to_lpn: This is a manufacturing component pick.');
13481: mydebug('WIP entity type IS NOT the same AS that OF the old mmtt RECORD');
13482: END IF;
13483: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_MFG_MODE');
13484: fnd_msg_pub.ADD;
13485: RAISE fnd_api.g_exc_error;
13486: END IF;
13487: END IF;
13550: mydebug('validate_pick_to_lpn: Drop LPN is going to an LPN controlled sub');
13551: mydebug('validate_pick_to_lpn: Cannot add picks not going to the same sub');
13552: END IF;
13553:
13554: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_SUBINV');
13555: fnd_msg_pub.ADD;
13556: RAISE fnd_api.g_exc_error;
13557: END IF;
13558: ELSE
13591: IF (l_debug = 1) THEN
13592: mydebug('validate_pick_to_lpn: Drop LPN has pick(s) for an LPN-controlled sub');
13593: END IF;
13594:
13595: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_SUBINV');
13596: fnd_msg_pub.ADD;
13597: RAISE fnd_api.g_exc_error;
13598: END IF;
13599: END IF;
13624: IF (l_debug = 1) THEN
13625: mydebug('validate_pick_to_lpn: Txfer LPN is associated with material FOR a different fulfillment base');
13626: END IF;
13627:
13628: fnd_message.set_name('WMS', 'WMS_LPN_FB_COMINGLE');
13629: fnd_msg_pub.ADD;
13630: RAISE fnd_api.g_exc_error;
13631: END IF;
13632:
13654: IF (l_debug = 1) THEN
13655: mydebug('validate_pick_to_lpn: Drop LPN is associated with material FOR a different operation plan');
13656: END IF;
13657:
13658: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_OPER_PLAN');
13659: fnd_msg_pub.ADD;
13660: RAISE fnd_api.g_exc_error;
13661: END IF;
13662:
13704: IF (l_debug = 1) THEN
13705: mydebug('validate_pick_to_lpn: can NOT find move order line for current task');
13706: END IF;
13707:
13708: fnd_message.set_name('WMS', 'WMS_NO_MOL');
13709: fnd_msg_pub.ADD;
13710: RAISE fnd_api.g_exc_error;
13711: END IF;
13712:
13749: IF (l_debug = 1) THEN
13750: mydebug('validate_pick_to_lpn: can NOT find either wdd or wda for tasks in the lpn');
13751: END IF;
13752:
13753: fnd_message.set_name('WMS', 'WMS_NO_WDD_WDA');
13754: fnd_msg_pub.ADD;
13755: RAISE fnd_api.g_exc_error;
13756: END IF;
13757:
13766: IF (l_debug = 1) THEN
13767: mydebug('validate_pick_to_lpn: other tasks in lpn have different deliveries');
13768: END IF;
13769:
13770: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
13771: fnd_msg_pub.ADD;
13772: RAISE fnd_api.g_exc_error;
13773: END IF;
13774: ELSE -- they have different carton_grouping_id
13830: --}
13831: END;
13832: --
13833: IF (l_same_carton_grouping = FALSE) then
13834: fnd_message.set_name('WMS', 'WMS_DIFF_CARTON_GROUP');
13835: fnd_msg_pub.ADD;
13836: RAISE fnd_api.g_exc_error;
13837: END IF;
13838: --
13842: ELSE -- some of carton_grouping_id is null
13843: IF (l_debug = 1) THEN
13844: mydebug('validate_pick_to_lpn: some of tasks in lpn have NULL carton_grouping_id');
13845: END IF;
13846: fnd_message.set_name('WMS', 'WMS_CARTON_GROUP_NULL');
13847: fnd_msg_pub.ADD;
13848: RAISE fnd_api.g_exc_error;
13849: END IF;
13850: ELSE --carton_grouping_id is null
13852: mydebug('validate_pick_to_lpn: carton_grouping_id of current task is null');
13853: END IF;
13854: --bug3481923 only fail if it is not requisition on repl mo
13855: if (l_mmtt_mo_type not in(1,2)) then
13856: fnd_message.set_name('WMS', 'WMS_CARTON_GROUP_NULL');
13857: fnd_msg_pub.ADD;
13858: RAISE fnd_api.g_exc_error;
13859: end if;
13860: END IF;
13885: IF (l_debug = 1) THEN
13886: mydebug('validate_pick_to_lpn: Picked LPN and current MMTT go to different deliveries.');
13887: END IF;
13888:
13889: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
13890: fnd_msg_pub.ADD;
13891: RAISE fnd_api.g_exc_error;
13892: END IF;
13893: ELSIF l_pick_to_lpn_delivery_id2 IS NULL THEN
13900: mydebug('validate_pick_to_lpn: Current task has delivery.');
13901: mydebug('validate_pick_to_lpn: Picked LPN does not have delivery and current task has delivery.');
13902: END IF;
13903:
13904: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
13905: fnd_msg_pub.ADD;
13906: RAISE fnd_api.g_exc_error;
13907: END IF;
13908: ELSIF l_pick_to_lpn_delivery_id2 = -999 THEN
13934: IF (l_debug = 1) THEN
13935: mydebug('validate_pick_to_lpn: Picked LPN and current MMTT go to different deliveries.');
13936: END IF;
13937:
13938: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
13939: fnd_msg_pub.ADD;
13940: RAISE fnd_api.g_exc_error;
13941: NULL;
13942: ELSE
13982: IF (l_debug = 1) THEN
13983: mydebug('validate_pick_to_lpn: LPNs are on diff deliveries.');
13984: END IF;
13985:
13986: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
13987: fnd_msg_pub.ADD;
13988: RAISE fnd_api.g_exc_error;
13989: ELSE
13990: --
14278: l_count := 0;
14279: END;
14280:
14281: IF l_count <> 0 THEN
14282: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
14283: fnd_msg_pub.ADD;
14284: RAISE fnd_api.g_exc_error;
14285: END IF;
14286:
15710:
15711: FETCH get_item_details INTO l_lot_divisible_flag;
15712: IF (get_item_details%NOTFOUND) THEN
15713: CLOSE get_item_details;
15714: FND_MESSAGE.SET_NAME('INV','ITEM_NOT_FOUND');
15715: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_org_id);
15716: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
15717: FND_MSG_PUB.ADD;
15718: RAISE FND_API.G_EXC_ERROR;
15711: FETCH get_item_details INTO l_lot_divisible_flag;
15712: IF (get_item_details%NOTFOUND) THEN
15713: CLOSE get_item_details;
15714: FND_MESSAGE.SET_NAME('INV','ITEM_NOT_FOUND');
15715: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_org_id);
15716: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
15717: FND_MSG_PUB.ADD;
15718: RAISE FND_API.G_EXC_ERROR;
15719: END IF;
15712: IF (get_item_details%NOTFOUND) THEN
15713: CLOSE get_item_details;
15714: FND_MESSAGE.SET_NAME('INV','ITEM_NOT_FOUND');
15715: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', p_org_id);
15716: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inventory_item_id);
15717: FND_MSG_PUB.ADD;
15718: RAISE FND_API.G_EXC_ERROR;
15719: END IF;
15720:
15999: IF (l_debug = 1) THEN
16000: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
16001: END IF;
16002:
16003: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16004: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16005: fnd_msg_pub.ADD;
16006: RAISE fnd_api.g_exc_error;
16007: END IF;
16000: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
16001: END IF;
16002:
16003: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16004: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16005: fnd_msg_pub.ADD;
16006: RAISE fnd_api.g_exc_error;
16007: END IF;
16008:
16049: IF (l_debug = 1) THEN
16050: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
16051: END IF;
16052:
16053: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16054: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16055: fnd_msg_pub.ADD;
16056: RAISE fnd_api.g_exc_error;
16057: END IF;
16050: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
16051: END IF;
16052:
16053: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16054: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16055: fnd_msg_pub.ADD;
16056: RAISE fnd_api.g_exc_error;
16057: END IF;
16058: END IF;