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 9769: UPDATE WSM_LOT_MOVE_TXN_INTERFACE

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

Line 10166: FROM wsm_lot_move_txn_interface WLMTI,

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

Line 10222: FROM wsm_lot_move_txn_interface WLMTI,

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

Line 10266: WSM_LOT_MOVE_TXN_INTERFACE WLMTI,

10262: SELECT WLMTI.header_id
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

Line 10354: WSM_LOT_MOVE_TXN_INTERFACE WLMTI

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

Line 10402: WSM_LOT_MOVE_TXN_INTERFACE wlmti

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

Line 10490: WSM_LOT_MOVE_TXN_INTERFACE wlmti

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

Line 10664: FROM wsm_lot_move_txn_interface wlmti

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

Line 10780: FROM wsm_lot_move_txn_interface wlmti

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

Line 11005: -- from wsm_lot_move_txn_interface wlmti

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

Line 11018: -- wsm_lot_move_txn_interface wlmti

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

Line 11025: DELETE wsm_lot_move_txn_interface wlmti

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

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

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

Line 11092: FROM wsm_lot_move_txn_interface

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

Line 11166: UPDATE wsm_lot_move_txn_interface WLMTI

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

Line 11187: UPDATE wsm_lot_move_txn_interface WLMTI

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

Line 11201: UPDATE wsm_lot_move_txn_interface WLMTI

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

Line 11243: UPDATE wsm_lot_move_txn_interface WLMTI

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

Line 11733: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE WHERE header_id = p_header_id;

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

Line 11735: INSERT into WSM_LOT_MOVE_TXN_INTERFACE

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

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

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

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

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