APPS.WSMPLBMI dependencies on WIP_MOVE_TXN_INTERFACE

Line 1083: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_txn_interface');

1079: IF ( (l_res_rows > 0) OR (x_return_code <> 0) ) THEN
1080: x_return_code := 1;
1081:
1082: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
1083: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_txn_interface');
1084: x_err_buf := FND_MESSAGE.GET;
1085:
1086: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
1087: return(x_return_code);

Line 6460: FROM wip_move_txn_interface

6456: l_stmt_num := 70;
6457: BEGIN
6458: SELECT 1
6459: INTO l_job_exists
6460: FROM wip_move_txn_interface
6461: WHERE group_id=l_wmti_group_id
6462: AND wip_entity_id=l_wip_entity_id
6463: AND process_status = g_running;
6464: EXCEPTION

Line 8251: INSERT INTO wip_move_txn_interface(

8247: p_run_log_level => l_log_level
8248: );
8249: END IF;
8250:
8251: INSERT INTO wip_move_txn_interface(
8252: TRANSACTION_ID,
8253: LAST_UPDATE_DATE,
8254: LAST_UPDATED_BY,
8255: LAST_UPDATED_BY_NAME,

Line 8463: FROM WIP_MOVE_TXN_INTERFACE

8459: --mes populate l_job_fm_op_seq_num, l_job_to_op_seq_num
8460: IF (l_transaction_quantity = 0) THEN
8461: SELECT fm_operation_seq_num, to_operation_seq_num
8462: INTO l_fm_op_seq_num, l_job_to_op_seq_num
8463: FROM WIP_MOVE_TXN_INTERFACE
8464: WHERE transaction_id = l_transaction_id;
8465: END IF;
8466: END IF;
8467:

Line 8495: INSERT INTO wip_move_txn_interface(

8491: p_run_log_level => l_log_level
8492: );
8493: END IF;
8494:
8495: INSERT INTO wip_move_txn_interface(
8496: TRANSACTION_ID,
8497: LAST_UPDATE_DATE,
8498: LAST_UPDATED_BY,
8499: LAST_UPDATED_BY_NAME,

Line 8670: FROM WIP_MOVE_TXN_INTERFACE

8666:
8667: --mes populate l_job_fm_op_seq_num, l_job_to_op_seq_num
8668: SELECT fm_operation_seq_num, to_operation_seq_num
8669: INTO l_fm_op_seq_num, l_job_to_op_seq_num
8670: FROM WIP_MOVE_TXN_INTERFACE
8671: WHERE transaction_id = l_transaction_id;
8672: END IF;
8673:
8674:

Line 8680: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_txn_interface');

8676: fnd_file.put_line(fnd_file.log, 'WARNING: Could not insert into WMTI');
8677:
8678: l_stmt_num := 230;
8679: FND_MESSAGE.SET_NAME('WSM', 'WSM_INS_TBL_FAILED');
8680: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_txn_interface');
8681: l_error_msg := FND_MESSAGE.GET;
8682: ROLLBACK TO VALIDATION;
8683:
8684: error_handler(p_header_id => l_header_id

Line 10267: WIP_MOVE_TXN_INTERFACE WMTI

10263: , wtie.transaction_id
10264: , wtie.error_message
10265: FROM WIP_TXN_INTERFACE_ERRORS wtie,
10266: WSM_LOT_MOVE_TXN_INTERFACE WLMTI,
10267: WIP_MOVE_TXN_INTERFACE WMTI
10268: WHERE WTIE.transaction_id = WMTI.transaction_id
10269: --FP bug 5178168 (base bug 5168406) changed the line below
10270: --AND WMTI.batch_id = WLMTI.transaction_id
10271: AND nvl(WMTI.batch_id, wmti.transaction_id) = WLMTI.transaction_id

Line 10302: FROM WIP_MOVE_TXN_INTERFACE

10298: l_wmti_err_txns := 0;
10299:
10300: SELECT count(*)
10301: INTO l_wmti_err_txns
10302: FROM WIP_MOVE_TXN_INTERFACE
10303: WHERE GROUP_ID=l_wmti_group_id
10304: AND PROCESS_STATUS = 3;
10305:
10306: IF (g_mrp_debug='Y') THEN

Line 10590: WIP_MOVE_TXN_INTERFACE wti

10586: FROM WIP_OPERATIONS wop2,
10587: WIP_OPERATION_YIELDS woy2,
10588: WSM_PARAMETERS wp, -- ESA
10589: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10590: WIP_MOVE_TXN_INTERFACE wti
10591: WHERE wti.group_id = l_wmti_group_id
10592: AND wti.process_phase = g_move_proc
10593: AND wti.process_status = g_running
10594: -- AND TRUNC(wti.transaction_date) = to_date(:l_temp_date, WCD_CANONICAL_DATE) --bugfix 2856703