APPS.WSMPLBMI dependencies on WIP_ENTITIES

Line 495: FROM wip_entities

491: BEGIN
492:
493: SELECT wip_entity_name, entity_type
494: INTO l_wip_entity_name_temp, l_entity_type
495: FROM wip_entities
496: WHERE organization_id = p_org_id
497: AND wip_entity_id = l_wip_entity_id;
498:
499: IF (l_entity_type <> 5) THEN

Line 503: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entities');

499: IF (l_entity_type <> 5) THEN
500: x_return_code := 1;
501:
502: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_WSM_LOT_JOB');
503: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entities');
504: x_err_buf := FND_MESSAGE.GET;
505:
506: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
507: return(x_return_code);

Line 545: FROM wip_entities

541: l_stmt_num := 34;
542:
543: SELECT wip_entity_id, entity_type
544: INTO l_wip_entity_id, l_entity_type
545: FROM wip_entities
546: WHERE organization_id = p_org_id
547: -- AND wip_entity_name = p_wip_entity_name;
548: AND wip_entity_name = NVL(p_wip_entity_name, l_wip_entity_name_temp); -- Fix for bug #2095035
549:

Line 554: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entities');

550: IF (l_entity_type <> 5) THEN
551: x_return_code := 1;
552:
553: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_WSM_LOT_JOB');
554: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entities');
555: x_err_buf := FND_MESSAGE.GET;
556:
557: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
558: return(x_return_code);

Line 8109: UPDATE wip_entities

8105: );
8106: END IF;
8107:
8108: IF ((l_new_name IS NOT NULL) AND (l_new_name <> '-1')) THEN
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

Line 10818: p_msg_text => 'b4 UPDATE wip_entities '||

10814: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10815: l_msg_tokens.delete;
10816: WSM_log_PVT.logMessage (
10817: p_module_name => l_module,
10818: p_msg_text => 'b4 UPDATE wip_entities '||
10819: ' rec.new_wip_entity_name '||rec.new_wip_entity_name||
10820: ' rec.wip_entity_id '||rec.wip_entity_id,
10821: p_stmt_num => l_stmt_num,
10822: p_msg_tokens => l_msg_tokens,

Line 10830: UPDATE wip_entities

10826: END IF;
10827:
10828: l_dup_flag:=0;
10829:
10830: UPDATE wip_entities
10831: SET wip_entity_name = rec.new_wip_entity_name
10832: WHERE wip_entity_id = rec.wip_entity_id;
10833:
10834:

Line 10837: fnd_file.put_line(fnd_file.log, 'wip_entities : Update failed '||l_new_jobname);

10833:
10834:
10835:
10836: IF (SQL%ROWCOUNT=0) THEN
10837: fnd_file.put_line(fnd_file.log, 'wip_entities : Update failed '||l_new_jobname);
10838: ELSE
10839: IF (g_mrp_debug='Y') THEN
10840: fnd_file.put_line(fnd_file.log, 'updated wip_entity_id= '||l_wip_entity_id||' with the new_job_name '||l_new_jobname);
10841: END IF;