eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPLBMI dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 293: l_source_code WSM_LOT_MOVE_TXN_INTERFACE.source_code%type;

289: l_scrap_txn_id NUMBER;
290: --end move enh
291: l_wmt_scrap_acc NUMBER;
292: --mes
293: l_source_code WSM_LOT_MOVE_TXN_INTERFACE.source_code%type;
294: -- Logging variables.....
295: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
296: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
297: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSMPLBMI.custom_validations';

Line 477: FROM wsm_lot_move_txn_interface

473: -- Start fix for bug #2095035
474: IF (p_wip_entity_name IS NULL) THEN -- if the user has passed wip_entity_id and not wip_entity_name
475: SELECT wip_entity_id
476: INTO l_wip_entity_id
477: FROM wsm_lot_move_txn_interface
478: WHERE header_id = p_header_id;
479:
480: IF (l_wip_entity_id IS NULL) THEN
481: x_return_code := 1;

Line 512: UPDATE wsm_lot_move_txn_interface

508: END IF;
509:
510: l_stmt_num := 33;
511:
512: UPDATE wsm_lot_move_txn_interface
513: SET wip_entity_name = l_wip_entity_name_temp
514: WHERE header_id = p_header_id;
515:
516: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 655: FROM wsm_lot_move_txn_interface

651:
652: -- Validate/Populate wip_entity_id
653: SELECT nvl(wip_entity_id, -1)
654: INTO l_wlmti_wip_entity_id
655: FROM wsm_lot_move_txn_interface
656: WHERE header_id = p_header_id
657: AND wip_entity_name = NVL(p_wip_entity_name, l_wip_entity_name_temp); -- Fix for bug #2095035
658:
659: l_stmt_num := 55;

Line 667: update wsm_lot_move_txn_interface

663: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id');
664: x_err_buf := FND_MESSAGE.GET;
665: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
666: -- CZH.BUG2135538
667: update wsm_lot_move_txn_interface
668: set wip_entity_id = l_wip_entity_id,
669: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
670: error = l_error_msg -- CZH.BUG2135538
671: where header_id = p_header_id;

Line 730: FROM wsm_lot_move_txn_interface

726: l_wlmti_scrap_acct_id,
727: l_scrap_at_operation_flag,
728: l_scrap_qty,
729: l_source_code
730: FROM wsm_lot_move_txn_interface
731: WHERE wip_entity_id = l_wip_entity_id
732: AND header_id = p_header_id;
733: --***VJ End Additions***--
734:

Line 755: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wsm_lot_move_txn_interface');

751: IF (l_entity_type <> 5) THEN
752: x_return_code := 1;
753:
754: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_WSM_LOT_JOB');
755: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wsm_lot_move_txn_interface');
756: x_err_buf := FND_MESSAGE.GET;
757:
758: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
759: return(x_return_code);

Line 769: update wsm_lot_move_txn_interface

765: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id');
766: x_err_buf := FND_MESSAGE.GET;
767: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
768: -- CZH.BUG2135538
769: update wsm_lot_move_txn_interface
770: set primary_item_id = l_primary_item_id,
771: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
772: error = l_error_msg -- CZH.BUG2135538
773: where header_id = p_header_id;

Line 794: update wsm_lot_move_txn_interface

790: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_code');
791: x_err_buf := FND_MESSAGE.GET;
792: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
793: -- CZH.BUG2135538
794: update wsm_lot_move_txn_interface
795: set organization_code = g_prev_org_code, --l_org_code,
796: --***VJ Changed for Performance Upgrade***--
797: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
798: error = l_error_msg -- CZH.BUG2135538

Line 881: update wsm_lot_move_txn_interface

877: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'last_updated_by_name');
878: x_err_buf := FND_MESSAGE.GET;
879: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
880: -- CZH.BUG2135538
881: update wsm_lot_move_txn_interface
882: set last_updated_by_name = g_prev_upd_user_name, --l_user_name,
883: --***VJ Changed for Performance Upgrade***--
884: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
885: error = l_error_msg -- CZH.BUG2135538

Line 940: update wsm_lot_move_txn_interface

936: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'created_by_name');
937: x_err_buf := FND_MESSAGE.GET;
938: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
939: -- CZH.BUG2135538
940: update wsm_lot_move_txn_interface
941: set created_by_name = g_prev_cr_user_name, --l_user_name,
942: --***VJ Changed for Performance Upgrade***--
943: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
944: error = l_error_msg -- CZH.BUG2135538

Line 1043: update wsm_lot_move_txn_interface

1039: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_name');
1040: x_err_buf := FND_MESSAGE.GET;
1041: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
1042: -- CZH.BUG2135538
1043: update wsm_lot_move_txn_interface
1044: set reason_name = l_mtr_reason_name,
1045: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
1046: error = l_error_msg -- CZH.BUG2135538
1047: where header_id = p_header_id;

Line 1058: update wsm_lot_move_txn_interface

1054: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_name');
1055: x_err_buf := FND_MESSAGE.GET;
1056: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
1057: -- CZH.BUG2135538
1058: update wsm_lot_move_txn_interface
1059: set reason_name = l_mtr_reason_name,
1060: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
1061: error = l_error_msg -- CZH.BUG2135538
1062: where header_id = p_header_id;

Line 1170: update wsm_lot_move_txn_interface

1166: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'p_primary_uom');
1167: x_err_buf := FND_MESSAGE.GET;
1168: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
1169: -- CZH.BUG2135538
1170: update wsm_lot_move_txn_interface
1171: set primary_uom = l_primary_uom,
1172: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
1173: error = l_error_msg -- CZH.BUG2135538
1174: where header_id = p_header_id;

Line 1479: UPDATE wsm_lot_move_txn_interface

1475: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
1476: return(x_return_code);
1477:
1478: elsif (p_fm_op_code is null and l_wo_op_code is not null) then
1479: UPDATE wsm_lot_move_txn_interface
1480: SET fm_operation_code = l_wo_op_code
1481: WHERE header_id = p_header_id;
1482:
1483: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');

Line 1574: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

1570: ************************************************************************************************************************/
1571: IF (g_aps_wps_profile='N') THEN
1572:
1573: l_stmt_num := 180;
1574: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
1575: SET (FM_DEPARTMENT_ID,
1576: FM_DEPARTMENT_CODE) =
1577: (SELECT bd.department_id,
1578: bd.department_code

Line 1741: update wsm_lot_move_txn_interface

1737: end if;
1738:
1739: if (p_to_op_code is NULL) AND (l_op_code is not NULL) then
1740: l_stmt_num := 215;
1741: update wsm_lot_move_txn_interface
1742: set to_operation_code = l_op_code
1743: where header_id = p_header_id;
1744: elsif nvl(l_op_code, '@@**') <> nvl(p_to_op_code, '@@**') then
1745: x_return_code := 1;

Line 1808: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

1804: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
1805: return(x_return_code);
1806: END IF;
1807:
1808: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
1809: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
1810: TO_DEPARTMENT_CODE )=
1811: (SELECT bd.department_id, -- Fix bug #1501376
1812: bd.department_code

Line 1993: update wsm_lot_move_txn_interface

1989:
1990: -- NSO Modification by abedajna: additions begin
1991: if (p_to_op_code is NULL) AND (l_jmp_op_code is not NULL) then
1992:
1993: update wsm_lot_move_txn_interface
1994: set to_operation_code = l_jmp_op_code
1995: where header_id = p_header_id;
1996:
1997: l_stmt_num := 260;

Line 2133: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2129: end if; /* scrap <> 0 */
2130: end if; /* g_param_jump_fm_q = 2 */
2131:
2132: l_stmt_num := 280;
2133: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2134: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2135: TO_DEPARTMENT_CODE )=
2136: (SELECT bd.department_id, -- Fix bug #1501376
2137: bd.department_code

Line 2178: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2174: ELSE --(g_aps_wps_profile='Y')
2175:
2176: l_stmt_num := 180;
2177:
2178: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2179: SET (FM_DEPARTMENT_ID,
2180: FM_DEPARTMENT_CODE) =
2181: (SELECT WCO.department_id,
2182: WCO.department_code

Line 2189: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2185: AND WCO.operation_sequence_id = l_op_seq_id)
2186: WHERE WLMTI.header_id = p_header_id;
2187:
2188: IF ((SQL%ROWCOUNT > 0) OR (SQL%NOTFOUND)) THEN
2189: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2190: SET (FM_DEPARTMENT_ID,
2191: FM_DEPARTMENT_CODE) =
2192: (SELECT bd.department_id,
2193: bd.department_code

Line 2319: update wsm_lot_move_txn_interface

2315: end if;
2316:
2317: if (p_to_op_code is NULL) AND (l_op_code is not NULL) then
2318: l_stmt_num := 215;
2319: update wsm_lot_move_txn_interface
2320: set to_operation_code = l_op_code
2321: where header_id = p_header_id;
2322: elsif nvl(l_op_code, '@@**') <> nvl(p_to_op_code, '@@**') then
2323: x_return_code := 1;

Line 2388: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2384: END IF;
2385:
2386: --move enh
2387: IF (l_to_dept_code IS NULL) THEN
2388: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2389: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2390: TO_DEPARTMENT_CODE )=
2391: (SELECT bd.department_id, -- Fix bug #1501376
2392: bd.department_code

Line 2418: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2414:
2415: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'):'||x_err_buf);
2416: END IF;
2417: ELSE --(l_to_dept_code IS NOT NULL)
2418: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2419: SET TO_DEPARTMENT_CODE=l_to_dept_code
2420: WHERE WLMTI.header_id = p_header_id;
2421: END IF;
2422:

Line 2539: update wsm_lot_move_txn_interface

2535:
2536: -- NSO Modification by abedajna: additions begin
2537: if (p_to_op_code is NULL) AND (l_jmp_op_code is not NULL) then
2538:
2539: update wsm_lot_move_txn_interface
2540: set to_operation_code = l_jmp_op_code
2541: where header_id = p_header_id;
2542:
2543: l_stmt_num := 260;

Line 2679: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

2675: end if; /* g_param_jump_fm_q = 2 */
2676:
2677: l_stmt_num := 280;
2678: IF (l_to_dept_code IS NULL) THEN
2679: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
2680: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2681: TO_DEPARTMENT_CODE )=
2682: (SELECT bd.department_id, -- Fix bug #1501376
2683: bd.department_code

Line 3216: update wsm_lot_move_txn_interface

3212: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
3213: x_err_buf := FND_MESSAGE.GET;
3214: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
3215: -- CZH.BUG2135538
3216: update wsm_lot_move_txn_interface
3217: set scrap_account_id = l_wlmti_scrap_acct_id,
3218: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
3219: error = l_error_msg -- CZH.BUG2135538
3220: where header_id = p_header_id;

Line 3349: update wsm_lot_move_txn_interface

3345: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
3346: x_err_buf := FND_MESSAGE.GET;
3347: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
3348:
3349: update wsm_lot_move_txn_interface
3350: set scrap_account_id = l_wlmti_scrap_acct_id,
3351: error = l_error_msg
3352: where header_id = p_header_id;
3353:

Line 3453: update wsm_lot_move_txn_interface

3449: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
3450: x_err_buf := FND_MESSAGE.GET;
3451: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
3452:
3453: update wsm_lot_move_txn_interface
3454: set scrap_account_id = l_wlmti_scrap_acct_id,
3455: error = l_error_msg
3456: where header_id = p_header_id;
3457:

Line 3699: UPDATE wsm_lot_move_txn_interface

3695: IF (l_txn_type <> 2) THEN -- Move and Completion
3696: --NSO Modification by abedajna end
3697: l_error_msg := substr(l_error_msg||'WARNING: Changing transaction_type to 2.| ', 1, 2000);
3698: -- CZH.BUG2135538
3699: UPDATE wsm_lot_move_txn_interface
3700: SET transaction_type = 2,
3701: --error = 'WARNING: Changing transaction_type to 2' -- CZH.BUG2135538
3702: error = l_error_msg -- CZH.BUG2135538
3703: WHERE header_id = p_header_id;

Line 3716: UPDATE wsm_lot_move_txn_interface

3712: ELSE -- not the last operation
3713: IF (l_txn_type <> 1) THEN -- Move only
3714: l_error_msg := substr(l_error_msg||'WARNING: Changing transaction_type to 1.| ', 1, 2000);
3715: -- CZH.BUG2135538
3716: UPDATE wsm_lot_move_txn_interface
3717: SET transaction_type = 1,
3718: --error = 'WARNING: Changing transaction_type to 1' -- CZH.BUG2135538
3719: error = l_error_msg -- CZH.BUG2135538
3720: WHERE header_id = p_header_id;

Line 3754: UPDATE wsm_lot_move_txn_interface

3750:
3751: IF (l_txn_type <> 2) THEN -- Move and Completion
3752: l_error_msg := substr(l_error_msg||'WARNING: Changing transaction_type to 2.| ', 1, 2000);
3753: -- CZH.BUG2135538
3754: UPDATE wsm_lot_move_txn_interface
3755: SET transaction_type = 2,
3756: --error = 'WARNING: Changing transaction_type to 2' -- CZH.BUG2135538
3757: error = l_error_msg -- CZH.BUG2135538
3758: WHERE header_id = p_header_id;

Line 3770: UPDATE wsm_lot_move_txn_interface

3766: ELSE -- not the last operation
3767: IF (l_txn_type <> 1) THEN -- Move only
3768: l_error_msg := substr(l_error_msg||'WARNING: Changing transaction_type to 1.| ', 1, 2000);
3769: -- CZH.BUG2135538
3770: UPDATE wsm_lot_move_txn_interface
3771: SET transaction_type = 1,
3772: --error = 'WARNING: Changing transaction_type to 1' -- CZH.BUG2135538
3773: error = l_error_msg -- CZH.BUG2135538
3774: WHERE header_id = p_header_id;

Line 3931: update wsm_lot_move_txn_interface

3927: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
3928: x_err_buf := FND_MESSAGE.GET;
3929: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
3930:
3931: update wsm_lot_move_txn_interface
3932: set scrap_account_id = l_wmt_scrap_acc,
3933: error = l_error_msg
3934: where header_id = p_header_id;
3935: END IF;

Line 3967: update wsm_lot_move_txn_interface

3963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'to_operation_seq_num/to_operation_code/to_intraoperation_step_type/transaction_quantity');
3964: x_err_buf := FND_MESSAGE.GET;
3965: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
3966: -- CZH.BUG2135538
3967: update wsm_lot_move_txn_interface
3968: set TO_OPERATION_SEQ_NUM = l_cmp_fm_op_seq_num,
3969: TO_OPERATION_CODE = l_cmp_fm_op_code,
3970: TO_INTRAOPERATION_STEP_TYPE = l_cmp_fm_intra_op_step,
3971: TRANSACTION_QUANTITY = l_cmp_txn_qty,

Line 4017: update wsm_lot_move_txn_interface

4013: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
4014: x_err_buf := FND_MESSAGE.GET;
4015: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
4016:
4017: update wsm_lot_move_txn_interface
4018: set scrap_account_id = l_wmt_scrap_acc,
4019: error = l_error_msg
4020: where header_id = p_header_id;
4021: END IF;

Line 4043: /* update wsm_lot_move_txn_interface

4039: END IF;
4040:
4041: -- Update WLMTI.from_op to NULL. No need to validate.
4042: --move enh moved the update further down
4043: /* update wsm_lot_move_txn_interface
4044: set FM_OPERATION_SEQ_NUM = NULL,
4045: FM_OPERATION_CODE = NULL,
4046: FM_INTRAOPERATION_STEP_TYPE = NULL
4047: where header_id = p_header_id;*/

Line 4158: update wsm_lot_move_txn_interface

4154: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_at_operation_flag');
4155: x_err_buf := FND_MESSAGE.GET;
4156: END IF;
4157:
4158: update wsm_lot_move_txn_interface
4159: set FM_OPERATION_SEQ_NUM = l_cmp_to_op_seq_num,
4160: FM_OPERATION_CODE = l_cmp_to_op_code,
4161: FM_INTRAOPERATION_STEP_TYPE = WIP_CONSTANTS.TOMOVE,
4162: SCRAP_QUANTITY = l_wmt_scrap_qty

Line 4699: update wsm_lot_move_txn_interface

4695: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
4696: --move enh added SCRAP_QUANTITY, SCRAP_QUANTITY
4697: -- CZH.BUG2135538
4698:
4699: update wsm_lot_move_txn_interface
4700: set FM_OPERATION_SEQ_NUM = l_to_op_seq_num,
4701: FM_OPERATION_CODE = l_to_op_code,
4702: FM_INTRAOPERATION_STEP_TYPE = l_to_intraop_step,
4703: FM_DEPARTMENT_ID = l_to_dept_id,

Line 4760: update wsm_lot_move_txn_interface

4756:
4757: IF (x_err_buf IS NOT NULL) THEN
4758: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
4759: -- CZH.BUG2135538
4760: update wsm_lot_move_txn_interface
4761: set TO_OPERATION_SEQ_NUM = l_fm_op_seq_num,
4762: TO_OPERATION_CODE = l_fm_op_code,
4763: TO_INTRAOPERATION_STEP_TYPE = l_fm_intraop_step,
4764: TO_DEPARTMENT_ID = l_fm_dept_id,

Line 4906: from wsm_lot_move_txn_interface

4902: if ((l_to_intraop_step = WIP_CONSTANTS.SCRAP) OR (nvl(l_converted_scrap_qty, 0) <> 0)) then -- Changed to fix bug #2083671
4903:
4904: select nvl(scrap_account_id,-1)
4905: into l_wlmti_scrap_acct_id
4906: from wsm_lot_move_txn_interface
4907: where header_id = p_header_id;
4908: l_stmt_num := 455;
4909:
4910: --abb H optional scrap acc begin

Line 4938: update wsm_lot_move_txn_interface

4934: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scrap_account_id');
4935: x_err_buf := FND_MESSAGE.GET;
4936: l_error_msg := substr(l_error_msg||'WARNING: '||x_err_buf||'| ', 1, 2000);
4937: -- CZH.BUG2135538
4938: update wsm_lot_move_txn_interface
4939: set scrap_account_id = l_wmt_scrap_acct_id,
4940: --ERROR = 'WARNING:'||x_err_buf -- CZH.BUG2135538
4941: error = l_error_msg -- CZH.BUG2135538
4942: where header_id = p_header_id;

Line 4966: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

4962: l_stmt_num := 470;
4963:
4964: --NSO Modification by abedajna addition begin
4965: --move enh? first look at copy table
4966: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4967: SET FM_DEPARTMENT_CODE = (select department_code
4968: from bom_departments
4969: where department_id = l_to_dept_id)
4970: WHERE WLMTI.header_id = p_header_id;

Line 4992: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

4988: END IF;
4989: --***VJ End Additions***--
4990:
4991: l_stmt_num := 475;
4992: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4993: SET TO_DEPARTMENT_CODE = (select department_code
4994: from bom_departments
4995: where department_id = l_fm_dept_id)
4996: WHERE WLMTI.header_id = p_header_id;

Line 5061: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

5057: -------------------------------------------------------------------------------------
5058: ----------------------------------END BACKWARD MOVES---------------------------------
5059: -------------------------------------------------------------------------------------
5060:
5061: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
5062: SET acct_period_id = g_acct_period_id --***VJ Changed for Performance Upgrade***--
5063: WHERE WLMTI.header_id = p_header_id;
5064:
5065: l_stmt_num := 490;

Line 5147: p_msg_text => 'B4 UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI'||

5143: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5144: l_msg_tokens.delete;
5145: WSM_log_PVT.logMessage (
5146: p_module_name => l_module,
5147: p_msg_text => 'B4 UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI'||
5148: ';l_converted_scrap_qty '||
5149: l_converted_scrap_qty,
5150: p_stmt_num => l_stmt_num,
5151: p_msg_tokens => l_msg_tokens,

Line 5157: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI

5153: p_run_log_level => l_log_level
5154: );
5155: END IF;
5156:
5157: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
5158: SET primary_quantity = NVL(l_converted_txn_qty,0),
5159: primary_scrap_quantity = NVL(l_converted_scrap_qty,0),
5160: scrap_at_operation_flag = l_scrap_at_operation_flag,
5161: internal_scrap_txn_id = l_scrap_txn_id

Line 5843: UPDATE wsm_lot_move_txn_interface WLMTI

5839: BEGIN
5840: l_stmt_num := 10;
5841: --move enh this logic is based on the fact that if even a single txn in WMTI errors out
5842: --WIP API will rollback all processing.
5843: UPDATE wsm_lot_move_txn_interface WLMTI
5844: SET status = 4
5845: WHERE WLMTI.internal_group_id=p_wmti_group_id
5846: AND WLMTI.group_id=p_group_id;
5847:

Line 5887: UPDATE wsm_lot_move_txn_interface

5883: return;
5884: end if;
5885:
5886: l_stmt_num := 20;
5887: UPDATE wsm_lot_move_txn_interface
5888: SET status = 3,
5889: ERROR = g_fnd_generic_err_msg
5890: WHERE header_id = p_header_id;
5891:

Line 5906: UPDATE wsm_lot_move_txn_interface

5902: p_header_id IN NUMBER,
5903: p_wmti_group_id IN NUMBER)
5904: IS
5905: BEGIN
5906: UPDATE wsm_lot_move_txn_interface
5907: SET internal_group_id = p_wmti_group_id
5908: WHERE header_id = p_header_id;
5909: END;
5910:

Line 6030: p_source_code IN wsm_lot_move_txn_interface.source_code%type,

6026: p_operation_completion_date IN DATE,
6027: p_expected_completion_date IN DATE,
6028: p_bonus_quantity IN NUMBER,
6029: p_low_yield_trigger_limit IN NUMBER,
6030: p_source_code IN wsm_lot_move_txn_interface.source_code%type,
6031: p_mtl_txn_hdr_id IN NUMBER,
6032: p_sec_uom_code_tbls IN t_sec_uom_code_tbls_type,
6033: p_sec_move_out_qty_tbls IN t_sec_move_out_qty_tbls_type,
6034: p_jobop_scrap_serials_tbls IN t_scrap_serials_tbls_type,

Line 6138: FROM wsm_lot_move_txn_interface

6134: nvl(jump_flag, 'N'), --bug 5469479 added nvl
6135: scrap_at_operation_flag,
6136: scrap_quantity,
6137: serial_start_flag -- ST : Serial Support Project --
6138: FROM wsm_lot_move_txn_interface
6139: WHERE group_id = p_group_id
6140: AND status = g_running -- WIP_CONSTANTS.RUNNING --Added condition to fix bug #1815584
6141: ORDER BY transaction_date, organization_id, wip_entity_id, processing_order;
6142:

Line 6185: l_reason_id wsm_lot_move_txn_interface.reason_id%TYPE;

6181: l_cpl_txn_id NUMBER;
6182: l_return_status VARCHAR2(1);
6183: l_max_acceptable_scrap_qty NUMBER;
6184: l_put_job_on_hold NUMBER;
6185: l_reason_id wsm_lot_move_txn_interface.reason_id%TYPE;
6186: l_transaction_reference wsm_lot_move_txn_interface.reference%TYPE;
6187: l_job_to_op_seq_num wsm_lot_move_txn_interface.to_operation_seq_num%TYPE;
6188: x_return_status VARCHAR2(1);
6189: x_msg_count NUMBER;

Line 6186: l_transaction_reference wsm_lot_move_txn_interface.reference%TYPE;

6182: l_return_status VARCHAR2(1);
6183: l_max_acceptable_scrap_qty NUMBER;
6184: l_put_job_on_hold NUMBER;
6185: l_reason_id wsm_lot_move_txn_interface.reason_id%TYPE;
6186: l_transaction_reference wsm_lot_move_txn_interface.reference%TYPE;
6187: l_job_to_op_seq_num wsm_lot_move_txn_interface.to_operation_seq_num%TYPE;
6188: x_return_status VARCHAR2(1);
6189: x_msg_count NUMBER;
6190:

Line 6187: l_job_to_op_seq_num wsm_lot_move_txn_interface.to_operation_seq_num%TYPE;

6183: l_max_acceptable_scrap_qty NUMBER;
6184: l_put_job_on_hold NUMBER;
6185: l_reason_id wsm_lot_move_txn_interface.reason_id%TYPE;
6186: l_transaction_reference wsm_lot_move_txn_interface.reference%TYPE;
6187: l_job_to_op_seq_num wsm_lot_move_txn_interface.to_operation_seq_num%TYPE;
6188: x_return_status VARCHAR2(1);
6189: x_msg_count NUMBER;
6190:
6191: l_wltx_transactions_rec WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE;

Line 6293: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||

6289: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6290: l_msg_tokens.delete;
6291: WSM_log_PVT.logMessage (
6292: p_module_name => l_module,
6293: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||
6294: ';g_user_id '||
6295: g_user_id||
6296: ';g_login_id '||
6297: g_login_id,

Line 6304: UPDATE wsm_lot_move_txn_interface wlmti

6300: p_fnd_log_level => G_LOG_LEVEL_STATEMENT,
6301: p_run_log_level => l_log_level
6302: );
6303: END IF;
6304: UPDATE wsm_lot_move_txn_interface wlmti
6305: /* LOTATTR: Changed the following so that transaction_id is
6306: updated ONLY if it wasn't populated by the user */
6307: SET transaction_id=nvl(transaction_id,wip_transactions_s.nextval),
6308: wlmti.error = NULL,

Line 6700: FROM wsm_lot_move_txn_interface

6696: l_transaction_reference,
6697: l_scrap_txn_id,
6698: l_job_to_op_seq_num,
6699: l_wip_entity_name
6700: FROM wsm_lot_move_txn_interface
6701: WHERE rowid=l_rowid;
6702:
6703: IF (l_debug = 'Y') THEN
6704: fnd_file.put_line(fnd_file.log, 'to_op_seq_num '||l_to_op_seq_num||' l_to_intraoperation_step_type '||l_to_intraoperation_step_type||

Line 7967: UPDATE wsm_lot_move_txn_interface

7963: );
7964: END IF;
7965:
7966: IF ((l_new_name IS NOT NULL) AND (l_new_name <> '-1')) THEN
7967: UPDATE wsm_lot_move_txn_interface
7968: SET new_wip_entity_name=l_new_name
7969: where rowid=l_rowid;
7970: ELSE
7971: l_error_msg := x_error_msg;

Line 8113: UPDATE wsm_lot_move_txn_interface

8109: UPDATE wip_entities
8110: SET wip_entity_name = l_new_name
8111: WHERE wip_entity_id = l_wip_entity_id;
8112:
8113: UPDATE wsm_lot_move_txn_interface
8114: SET wip_entity_name=l_new_name
8115: where rowid=l_rowid;
8116: ELSE
8117: l_error_msg := x_error_msg;

Line 8450: FROM wsm_lot_move_txn_interface

8446: g_comp_txn, g_ret_txn,
8447: 1), /*processing_order*/
8448: TRANSACTION_ID,
8449: p_employee_id
8450: FROM wsm_lot_move_txn_interface
8451: WHERE header_id = l_header_id);
8452:
8453: l_count := SQL%ROWCOUNT;
8454: IF (g_mrp_debug='Y') THEN

Line 8657: FROM wsm_lot_move_txn_interface

8653: OVERCOMPLETION_TRANSACTION_ID,
8654: decode(TRANSACTION_TYPE, 3, 1, 2), /*processing_order*/
8655: TRANSACTION_ID,
8656: p_employee_id
8657: FROM wsm_lot_move_txn_interface
8658: WHERE header_id = l_header_id
8659: );
8660:
8661: l_count := l_count+SQL%ROWCOUNT;

Line 9771: UPDATE WSM_LOT_MOVE_TXN_INTERFACE

9767:
9768: END IF; --(nvl(p_source_code, 'interface') IN ('move in oa page', 'move out oa page'))
9769:
9770: l_stmt_num := 253.7;
9771: UPDATE WSM_LOT_MOVE_TXN_INTERFACE
9772: SET status = 4,
9773: LAST_UPDATE_DATE = sysdate,
9774: LAST_UPDATED_BY = g_user_id
9775: WHERE header_id = l_header_id;

Line 10168: FROM wsm_lot_move_txn_interface WLMTI,

10164: WRO.QUANTITY_PER_ASSEMBLY,
10165: WRO.QUANTITY_RELIEVED,
10166: WRO.COMPONENT_YIELD_FACTOR,
10167: WRO.basis_type
10168: FROM wsm_lot_move_txn_interface WLMTI,
10169: WIP_REQUIREMENT_OPERATIONS WRO
10170: WHERE WLMTI.group_id = p_group_id
10171: AND WLMTI.wip_entity_id = 1439883
10172: AND WLMTI.wip_entity_id = WRO.wip_entity_id

Line 10224: FROM wsm_lot_move_txn_interface WLMTI,

10220: WRO.QUANTITY_PER_ASSEMBLY,
10221: WRO.QUANTITY_RELIEVED,
10222: WRO.COMPONENT_YIELD_FACTOR,
10223: WRO.basis_type
10224: FROM wsm_lot_move_txn_interface WLMTI,
10225: WIP_REQUIREMENT_OPERATIONS WRO
10226: WHERE WLMTI.group_id = p_group_id
10227: AND WLMTI.wip_entity_id = WRO.wip_entity_id
10228: AND WRO.operation_seq_num IN (WLMTI.FM_OPERATION_SEQ_NUM, WLMTI.TO_OPERATION_SEQ_NUM)

Line 10268: WSM_LOT_MOVE_TXN_INTERFACE WLMTI,

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

Line 10356: WSM_LOT_MOVE_TXN_INTERFACE WLMTI

10352: WHERE rowid IN
10353: (
10354: SELECT WO.rowid
10355: FROM WIP_OPERATIONS WO,
10356: WSM_LOT_MOVE_TXN_INTERFACE WLMTI
10357: WHERE WLMTI.group_id = p_group_id
10358: AND WLMTI.internal_group_id = l_wmti_group_id
10359: AND WLMTI.status = 4
10360: AND WO.wip_entity_id = WLMTI.wip_entity_id

Line 10404: WSM_LOT_MOVE_TXN_INTERFACE wlmti

10400: WIP_OPERATION_YIELDS woy2,
10401: WSM_PARAMETERS wp, -- ESA
10402: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10403: WIP_MOVE_TRANSACTIONS wmt,
10404: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10405: --bug 3615826
10406: -- WHERE wmt.group_id = l_wmti_group_id
10407: WHERE wlmti.group_id = p_group_id
10408: --mes commented out the following and added subsequent lines

Line 10492: WSM_LOT_MOVE_TXN_INTERFACE wlmti

10488: WIP_OPERATION_YIELDS woy2,
10489: WSM_PARAMETERS wp, -- ESA
10490: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10491: WIP_MOVE_TRANSACTIONS wmt,
10492: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10493: --bug 3615826
10494: -- WHERE wmt.group_id = l_wmti_group_id
10495: WHERE wlmti.group_id = p_group_id
10496: --mes commented out the following and added subsequent lines

Line 10666: FROM wsm_lot_move_txn_interface wlmti

10662: wlmti.to_intraoperation_step_type,
10663: wlmti.fm_intraoperation_step_type,
10664: wlmti.scrap_quantity,
10665: wlmti.source_code --Added for bug 5480482
10666: FROM wsm_lot_move_txn_interface wlmti
10667: WHERE wlmti.group_id = p_group_id
10668: AND wlmti.status = 4
10669: AND wlmti.transaction_type = 4
10670: --move enh 115.135 changed the AND clause for performance

Line 10782: FROM wsm_lot_move_txn_interface wlmti

10778: wlmti.fm_intraoperation_step_type,
10779: wlmti.scrap_quantity,
10780: wlmti.transaction_quantity,
10781: wlmti.source_code
10782: FROM wsm_lot_move_txn_interface wlmti
10783: WHERE wlmti.group_id = p_group_id
10784: AND wlmti.status = 4
10785: /* Added condition to fix bug #1815584 */
10786: AND wlmti.transaction_type in (2,3)

Line 11007: -- from wsm_lot_move_txn_interface wlmti

11003: -- User inserted records...
11004:
11005: -- DELETE wsm_serial_txn_interface
11006: -- WHERE header_id in (SELECT header_id
11007: -- from wsm_lot_move_txn_interface wlmti
11008: -- WHERE group_id = l_wmti_group_id
11009: -- and status = WIP_CONSTANTS.COMPLETED
11010: -- AND transaction_date <= decode(l_del_profile_value, NULL,
11011: -- transaction_date-1, SYSDATE-l_del_profile_value)

Line 11020: -- wsm_lot_move_txn_interface wlmti

11016: -- -- Delete the inserted records for Attributes...
11017: -- DELETE wsm_serial_txn_interface
11018: -- WHERE header_id IN (Select wmt.transaction_id
11019: -- from wip_move_transactions wmt,
11020: -- wsm_lot_move_txn_interface wlmti
11021: -- where wlmti.group_id = l_wmti_group_id
11022: -- and wlmti.wip_entity_id = wmt.wip_entity_id
11023: -- and wlmti.status = WIP_CONSTANTS.COMPLETED)
11024: -- AND transaction_type_id = 5;

Line 11027: DELETE wsm_lot_move_txn_interface wlmti

11023: -- and wlmti.status = WIP_CONSTANTS.COMPLETED)
11024: -- AND transaction_type_id = 5;
11025: -- ST : Serial Support Project --
11026:
11027: DELETE wsm_lot_move_txn_interface wlmti
11028: WHERE status = WIP_CONSTANTS.COMPLETED
11029: AND transaction_date <= decode(l_del_profile_value, NULL,
11030: transaction_date-1, SYSDATE-l_del_profile_value)
11031: RETURNING header_id BULK COLLECT INTO l_header_id_tbl;

Line 11057: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI

11053: UPDATE WIP_OPERATIONS
11054: SET wsm_costed_quantity_completed = quantity_completed
11055: WHERE ROWID IN
11056: (SELECT WO.ROWID
11057: FROM WIP_OPERATIONS WO, WIP_MOVE_TRANSACTIONS WMT, WSM_LOT_MOVE_TXN_INTERFACE WLMTI
11058: WHERE WLMTI.group_id = p_group_id
11059: AND WMT.transaction_id = WLMTI.transaction_id
11060: AND WO.wip_entity_id = WMT.wip_entity_id
11061: AND (WO.operation_seq_num IN (WMT.fm_operation_seq_num, WMT.to_operation_seq_num))

Line 11094: FROM wsm_lot_move_txn_interface

11090:
11091: BEGIN
11092: SELECT count(*)
11093: INTO l_err_count
11094: FROM wsm_lot_move_txn_interface
11095: WHERE group_id = p_group_id
11096: AND status = 3;
11097:
11098: IF (l_debug = 'Y') THEN

Line 11168: UPDATE wsm_lot_move_txn_interface WLMTI

11164: );
11165: END IF;
11166: retcode := 1;
11167: ROLLBACK;
11168: UPDATE wsm_lot_move_txn_interface WLMTI
11169: SET WLMTI.ERROR = 'Error WSMPLBMI.MoveTransaction' ||'(stmt_num='||l_stmt_num||')',
11170: WLMTI.STATUS = g_error,
11171: WLMTI.LAST_UPDATE_DATE = SYSDATE
11172: WHERE WLMTI.GROUP_ID = p_group_id

Line 11189: UPDATE wsm_lot_move_txn_interface WLMTI

11185: );
11186: END IF;
11187: retcode := -1;
11188: ROLLBACK;
11189: UPDATE wsm_lot_move_txn_interface WLMTI
11190: SET WLMTI.ERROR = 'Error WSMPLBMI.MoveTransaction' ||'(stmt_num='||l_stmt_num||')',
11191: WLMTI.STATUS = g_error,
11192: WLMTI.LAST_UPDATE_DATE = SYSDATE
11193: WHERE WLMTI.GROUP_ID = p_group_id

Line 11203: UPDATE wsm_lot_move_txn_interface WLMTI

11199: errbuf := 'WSMPLBMI.MoveTransaction' ||'(stmt_num='||l_stmt_num||') : '||x_error_msg;
11200: fnd_file.put_line(fnd_file.log, errbuf);
11201: ROLLBACK;
11202:
11203: UPDATE wsm_lot_move_txn_interface WLMTI
11204: SET WLMTI.ERROR = substrb('Error:' ||errbuf, 1, 2000),
11205: WLMTI.STATUS = g_error,
11206: WLMTI.LAST_UPDATE_DATE = SYSDATE
11207: WHERE WLMTI.GROUP_ID = p_group_id

Line 11245: UPDATE wsm_lot_move_txn_interface WLMTI

11241: errbuf :='WSMPLBMI.MoveTransaction' ||'(stmt_num='||l_stmt_num||') : '||sqlerrm;
11242: fnd_file.put_line(fnd_file.log, errbuf);
11243: ROLLBACK;
11244:
11245: UPDATE wsm_lot_move_txn_interface WLMTI
11246: SET WLMTI.ERROR = substrb('Unexpected SQL Error:' ||errbuf, 1, 2000),
11247: WLMTI.STATUS = g_error,
11248: WLMTI.LAST_UPDATE_DATE = SYSDATE
11249: WHERE WLMTI.GROUP_ID = p_group_id

Line 11735: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE WHERE header_id = p_header_id;

11731: END IF;
11732:
11733: END IF; --p_transaction_type IN (g_undo_txn, g_ret_txn)
11734:
11735: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE WHERE header_id = p_header_id;
11736:
11737: INSERT into WSM_LOT_MOVE_TXN_INTERFACE
11738: (
11739: -- INTERFACE_ID -- commented for bugfix 7163496

Line 11737: INSERT into WSM_LOT_MOVE_TXN_INTERFACE

11733: END IF; --p_transaction_type IN (g_undo_txn, g_ret_txn)
11734:
11735: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE WHERE header_id = p_header_id;
11736:
11737: INSERT into WSM_LOT_MOVE_TXN_INTERFACE
11738: (
11739: -- INTERFACE_ID -- commented for bugfix 7163496
11740: TRANSACTION_ID
11741: , LAST_UPDATE_DATE

Line 11858: , nvl(p_HEADER_ID, wsm_lot_move_txn_interface_s.nextval) --HEADER_ID

11854: , null --ATTRIBUTE14
11855: , null --ATTRIBUTE15
11856: , p_QA_COLLECTION_ID
11857: , p_JUMP_FLAG
11858: , nvl(p_HEADER_ID, wsm_lot_move_txn_interface_s.nextval) --HEADER_ID
11859: , p_PRIMARY_SCRAP_QUANTITY --PRIMARY_SCRAP_QUANTITY
11860: , p_PRIMARY_SCRAP_QUANTITY --SCRAP_QUANTITY
11861: , decode(p_primary_scrap_quantity, --bug 5584140 Added decode so that SCRAP_AT_OPERATION_FLAG=null when there is no scrap
11862: null, null,

Line 11873: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||

11869: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11870: l_msg_tokens.delete;
11871: WSM_log_PVT.logMessage (
11872: p_module_name => l_module,
11873: p_msg_text => 'B4 UPDATE wsm_lot_move_txn_interface wlmti '||
11874: ';g_user_id '||
11875: g_user_id||
11876: ';fnd_global.user_name '||
11877: fnd_global.user_name,