[Home] [Help]
143: AND person_id=l_emp_id;
144: */
145: SELECT wms_dispatched_tasks_s.NEXTVAL
146: INTO l_task_id
147: FROM DUAL;
148:
149: INSERT INTO wms_dispatched_tasks
150: (
151: task_id
762: END IF;
763:
764: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
765: INTO l_txn_hdr_id
766: FROM DUAL;
767:
768: UPDATE mtl_material_transactions_temp
769: SET transaction_header_id = l_txn_hdr_id
770: WHERE transaction_temp_id = task_rec.task_id;
772: -- Insert into WMS_DISPATCHED_TASKS for this user
773:
774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;
777:
778: INSERT INTO wms_dispatched_tasks
779: (
780: task_id
1318: END IF;
1319:
1320: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
1321: INTO l_txn_hdr_id
1322: FROM DUAL;
1323:
1324: UPDATE mtl_material_transactions_temp
1325: SET transaction_header_id = l_txn_hdr_id
1326: WHERE transaction_temp_id = task_rec.task_id;
1327:
1328: -- Insert into WMS_DISPATCHED_TASKS for this user
1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:
1333: INSERT INTO wms_dispatched_tasks
1334: (
1335: task_id
1774:
1775: BEGIN
1776: SELECT 1
1777: INTO l_exist_lpn
1778: FROM DUAL
1779: WHERE EXISTS(SELECT 1
1780: FROM wms_license_plate_numbers
1781: WHERE license_plate_number = l_lpn
1782: AND organization_id = p_org_id);
2175:
2176: IF l_lot_ser_seq = 0 THEN
2177: SELECT mtl_material_transactions_s.NEXTVAL
2178: INTO l_ser_seq
2179: FROM DUAL;
2180: ELSE
2181: l_ser_seq := l_lot_ser_seq;
2182: END IF;
2183:
2788:
2789:
2790: SELECT 1
2791: INTO l_loaded
2792: FROM DUAL
2793: WHERE EXISTS(SELECT 1
2794: FROM mtl_material_transactions_temp
2795: WHERE (transfer_lpn_id = p_lpn
2796: OR content_lpn_id = p_lpn));
2971:
2972: BEGIN
2973: SELECT 1
2974: INTO l_item_cnt
2975: FROM DUAL
2976: WHERE EXISTS(
2977: SELECT 1
2978: FROM wms_lpn_contents wlc
2979: WHERE wlc.parent_lpn_id = p_lpn
3000:
3001: BEGIN
3002: SELECT 1
3003: INTO l_item_cnt
3004: FROM DUAL
3005: WHERE EXISTS(
3006: SELECT 1
3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
3008: WHERE wlc.parent_lpn_id = p_lpn
5303: --Check whether the from LPN is loaded already
5304: BEGIN
5305: SELECT 0
5306: INTO l_loaded
5307: FROM DUAL
5308: WHERE NOT EXISTS(SELECT 1
5309: FROM mtl_material_transactions_temp
5310: WHERE content_lpn_id = p_from_lpn_id
5311: AND transaction_temp_id<>p_temp_id);
5759:
5760: BEGIN
5761: SELECT 1
5762: INTO l_bulk_pick_flag
5763: FROM DUAL
5764: WHERE EXISTS(SELECT 1
5765: FROM mtl_material_transactions_temp mmtt
5766: WHERE mmtt.parent_line_id = p_temp_id);
5767: EXCEPTION
6144: AND organization_id=l_org_id;*/
6145: BEGIN
6146: SELECT 1
6147: INTO l_exist_lpn
6148: FROM DUAL
6149: WHERE EXISTS(SELECT 1
6150: FROM wms_license_plate_numbers
6151: WHERE license_plate_number = l_lpn
6152: AND organization_id = l_org_id);
6226: END IF;
6227:
6228: SELECT mtl_material_transactions_s.NEXTVAL
6229: INTO l_new_temp_id
6230: FROM DUAL;
6231:
6232: INSERT INTO mtl_material_transactions_temp
6233: (
6234: transaction_header_id
6702: AND lpn_context<>wms_container_pub.lpn_context_packing;*/
6703: BEGIN
6704: SELECT 1
6705: INTO l_exist_lpn
6706: FROM DUAL
6707: WHERE EXISTS(
6708: SELECT 1
6709: FROM wms_license_plate_numbers
6710: WHERE license_plate_number = l_lpn_name
6731: AND w.lpn_id=c.parent_lpn_id;*/
6732: BEGIN
6733: SELECT 1
6734: INTO l_exist_lpn2
6735: FROM DUAL
6736: WHERE EXISTS(SELECT 1
6737: FROM wms_license_plate_numbers w, wms_lpn_contents c
6738: WHERE w.license_plate_number = l_sug_lpn_name
6739: AND w.organization_id = l_org_id
7001: -- Create new MMTT line with qty and primary qty in the LPN, content_lpn_id, transfer_lpn_id
7002:
7003: SELECT mtl_material_transactions_s.NEXTVAL
7004: INTO l_new_temp_id
7005: FROM DUAL;
7006:
7007: IF (l_debug = 1) THEN
7008: mydebug('multiple_lpn_pick: l_new_temp_id = ' || l_new_temp_id);
7009: END IF;
7491: -- get new serial_transaction_id
7492:
7493: SELECT mtl_material_transactions_s.NEXTVAL
7494: INTO l_new_serial_temp_id
7495: FROM DUAL;
7496:
7497: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
7498:
7499: IF (l_debug = 1) THEN
7595: IF (l_serial_code > 1
7596: AND l_serial_code <> 6) THEN
7597: SELECT mtl_material_transactions_s.NEXTVAL
7598: INTO l_new_serial_temp_id
7599: FROM DUAL;
7600:
7601: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
7602: ELSE
7603: l_new_serial_temp_id := NULL;
7680: IF (l_serial_code > 1
7681: AND l_serial_code <> 6) THEN
7682: SELECT mtl_material_transactions_s.NEXTVAL
7683: INTO l_new_serial_temp_id
7684: FROM DUAL;
7685: ELSE
7686: l_new_serial_temp_id := NULL;
7687: END IF;
7688:
7798:
7799: --Get value from sequence for next task id
7800: SELECT wms_dispatched_tasks_s.NEXTVAL
7801: INTO l_next_task_id
7802: FROM DUAL;
7803:
7804: IF (l_debug = 1) THEN
7805: mydebug('multiple_lpn_pick: Before Insert into WMSDT');
7806: END IF;
8294: l_count := 0;
8295: BEGIN
8296: SELECT 1
8297: INTO l_count
8298: FROM DUAL
8299: WHERE EXISTS
8300: ( SELECT 'x'
8301: FROM mtl_material_transactions_temp mmtt
8302: , mtl_secondary_inventories msi
9398: -- Create new MMTT line with qty and primary qty picked
9399:
9400: SELECT mtl_material_transactions_s.NEXTVAL
9401: INTO l_new_temp_id
9402: FROM DUAL;
9403:
9404: l_progress := '210';
9405: l_local_temp_id := l_new_temp_id;
9406:
9852: END IF;
9853:
9854: SELECT mtl_material_transactions_s.NEXTVAL
9855: INTO l_new_serial_temp_id
9856: FROM DUAL;
9857:
9858: l_progress := '310';
9859:
9860: UPDATE mtl_serial_numbers_temp
9874: END IF;
9875:
9876: SELECT mtl_material_transactions_s.NEXTVAL
9877: INTO l_new_serial_temp_id
9878: FROM DUAL;
9879:
9880: l_progress := '330';
9881: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
9882: END IF;
9946:
9947: --Get value from sequence for next task id
9948: SELECT wms_dispatched_tasks_s.NEXTVAL
9949: INTO l_next_task_id
9950: FROM DUAL;
9951:
9952: l_progress := '410';
9953:
9954: IF (l_debug = 1) THEN
10111:
10112: IF l_lot_ser_seq = 0 THEN
10113: SELECT mtl_material_transactions_s.NEXTVAL
10114: INTO l_new_serial_temp_id
10115: FROM DUAL;
10116: ELSE
10117: l_new_serial_temp_id := l_lot_ser_seq;
10118: END IF;
10119:
10311:
10312: IF l_lot_ser_seq = 0 THEN
10313: SELECT mtl_material_transactions_s.NEXTVAL
10314: INTO l_new_serial_temp_id
10315: FROM DUAL;
10316: ELSE
10317: l_new_serial_temp_id := l_lot_ser_seq;
10318: END IF;
10319:
10549: WHERE license_plate_number=p_lpn;*/
10550: BEGIN
10551: SELECT 1
10552: INTO l_exist
10553: FROM DUAL
10554: WHERE EXISTS(SELECT 1
10555: FROM wms_license_plate_numbers
10556: WHERE license_plate_number = p_lpn);
10557: EXCEPTION
11215: THEN
11216: BEGIN
11217: SELECT 1
11218: INTO l_cnt
11219: FROM DUAL
11220: WHERE EXISTS(SELECT 1
11221: FROM mtl_material_transactions_temp
11222: WHERE parent_line_id = l_temp_id);
11223: EXCEPTION
12879: END IF;
12880:
12881: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
12882: INTO l_txn_hdr_id
12883: FROM DUAL;
12884:
12885: UPDATE mtl_material_transactions_temp
12886: SET transaction_header_id = l_txn_hdr_id
12887: WHERE transaction_temp_id = task_rec.task_id;
12890:
12891: --Get value from sequence for next task id
12892: SELECT wms_dispatched_tasks_s.NEXTVAL
12893: INTO l_next_task_id
12894: FROM DUAL;
12895:
12896: --mydebug('pick_by_label: Before Insert into WMSDT');
12897:
12898:
13128:
13129: BEGIN
13130: SELECT 1
13131: INTO l_mmtt_rowcnt
13132: FROM DUAL
13133: WHERE EXISTS(SELECT 1
13134: FROM mtl_material_transactions_temp
13135: WHERE transaction_temp_id = l_pick_slip_id
13136: AND parent_line_id is NULL);
13155:
13156: BEGIN
13157: SELECT 1
13158: INTO l_wdt_rowcnt
13159: FROM DUAL
13160: WHERE EXISTS(SELECT 1
13161: FROM wms_dispatched_tasks t
13162: WHERE t.transaction_temp_id = l_pick_slip_id);
13163: EXCEPTION
13247:
13248: --Get value from sequence for next task id
13249: SELECT wms_dispatched_tasks_s.NEXTVAL
13250: INTO l_next_task_id
13251: FROM DUAL;
13252:
13253: --mydebug('manual_pick: Before Insert into WMSDT');
13254:
13255: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
13253: --mydebug('manual_pick: Before Insert into WMSDT');
13254:
13255: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
13256: INTO l_txn_hdr_id
13257: FROM DUAL;
13258:
13259: UPDATE mtl_material_transactions_temp
13260: SET transaction_header_id = l_txn_hdr_id
13261: WHERE transaction_temp_id = l_pick_slip_id;
13617: l_msg VARCHAR2(5100);
13618: l_ts VARCHAR2(30);
13619: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13620: BEGIN
13621: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
13622: -- l_msg:=l_ts||' '||msg;
13623:
13624: l_msg := msg;
13625: inv_mobile_helper_functions.tracelog(p_err_msg => l_msg, p_module => 'WMS_Task_Dispatch_Gen', p_level => 4);
14510:
14511: BEGIN
14512: SELECT 1
14513: INTO l_count
14514: FROM DUAL
14515: WHERE EXISTS(
14516: SELECT 1
14517: FROM mtl_material_transactions_temp mmtt
14518: WHERE mmtt.transaction_temp_id <> p_temp_id
14640:
14641: BEGIN
14642: SELECT 1
14643: INTO l_count
14644: FROM DUAL
14645: WHERE EXISTS(
14646: SELECT 1
14647: FROM mtl_material_transactions_temp mmtt
14648: WHERE mmtt.transaction_temp_id <> p_temp_id
14805: END IF;
14806:
14807: SELECT mtl_material_transactions_s.NEXTVAL
14808: INTO x_new_txn_hdr_id
14809: FROM DUAL;
14810:
14811: OPEN c_parent_mmtt_lines;
14812:
14813: LOOP
14871: ELSE -- Current Child Qty is greater than Parent Picked Qty
14872:
14873: select mtl_material_transactions_s.NEXTVAL
14874: into l_new_temp_id
14875: from dual; --Added bug3765153
14876:
14877: INSERT INTO mtl_material_transactions_temp
14878: (
14879: transaction_header_id