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.WSM_SERIAL_SUPPORT_PVT dependencies on WSMPCNST

Line 5195: if p_wlt_txn_type = (WSMPCNST.SPLIT) THEN -- check for the correctness..

5191: p_fnd_log_level => l_log_level
5192: );
5193: END IF;
5194:
5195: if p_wlt_txn_type = (WSMPCNST.SPLIT) THEN -- check for the correctness..
5196:
5197: IF p_wip_entity_id IS NULL THEN
5198: l_stmt_num := 20;
5199: BEGIN

Line 5338: elsif p_wlt_txn_type = (WSMPCNST.UPDATE_QUANTITY) THEN

5334: fetch c_wlt_serials
5335: bulk collect into x_serial_num_tbl;
5336: close c_wlt_serials;
5337:
5338: elsif p_wlt_txn_type = (WSMPCNST.UPDATE_QUANTITY) THEN
5339:
5340: l_stmt_num := 60;
5341: update wsm_serial_txn_interface wsti
5342: set wsti.process_status = wip_constants.error

Line 5791: IF p_wlt_txn_type = WSMPCNST.MERGE THEN

5787: end if;
5788: END IF;
5789:
5790: l_stmt_num := 20;
5791: IF p_wlt_txn_type = WSMPCNST.MERGE THEN
5792: l_index := p_starting_jobs_tbl.first;
5793:
5794: l_stmt_num := 25;
5795: while l_index is not null loop

Line 5803: ELSIF p_wlt_txn_type = WSMPCNST.BONUS THEN

5799: end if;
5800: l_index := p_starting_jobs_tbl.next(l_index);
5801: end loop;
5802:
5803: ELSIF p_wlt_txn_type = WSMPCNST.BONUS THEN
5804: return;
5805: ELSE
5806: l_rep_job_index := p_starting_jobs_tbl.first;
5807: END IF;

Line 5845: IF p_wlt_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) THEN

5841: into l_op_seq_incr
5842: from wsm_parameters
5843: where organization_id = p_organization_id;
5844:
5845: IF p_wlt_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) THEN
5846: l_curr_job_op_seq_num := p_starting_jobs_tbl(l_rep_job_index).operation_seq_num + l_op_seq_incr;
5847: l_curr_job_op_step := WIP_CONSTANTS.QUEUE;
5848: ELSE
5849: l_curr_job_op_seq_num := p_starting_jobs_tbl(l_rep_job_index).operation_seq_num;

Line 5899: IF p_wlt_txn_type = WSMPCNST.SPLIT THEN --split transaction

5895: RETURN;
5896: end if;
5897:
5898: l_stmt_num := 50;
5899: IF p_wlt_txn_type = WSMPCNST.SPLIT THEN --split transaction
5900:
5901: l_stmt_num := 60;
5902: -- For non-serial tracked jobs, the serial information should be complete...
5903: -- If the starting job is not a resulting job, then

Line 6598: p_wlt_txn_type => WSMPCNST.SPLIT ,

6594: p_serial_number_rec => p_serial_num_tbl(l_index1) ,
6595: p_inventory_item_id => l_inventory_item_id ,
6596: p_organization_id => p_organization_id ,
6597: p_clear_serial_attr => l_clear_serial_attr ,
6598: p_wlt_txn_type => WSMPCNST.SPLIT ,
6599: p_update_serial_attr => l_update_serial_attr ,
6600: p_update_desc_attr => 1 ,
6601: p_serial_attr_context => l_child_job_ser_context ,
6602: x_return_status => x_return_status ,

Line 6711: p_wlt_txn_type => WSMPCNST.SPLIT ,

6707: p_serial_number_rec => p_serial_num_tbl(l_index1) ,
6708: p_inventory_item_id => l_inventory_item_id ,
6709: p_organization_id => p_organization_id ,
6710: p_clear_serial_attr => l_clear_serial_attr ,
6711: p_wlt_txn_type => WSMPCNST.SPLIT ,
6712: p_update_serial_attr => l_update_serial_attr ,
6713: p_update_desc_attr => 1 ,
6714: x_return_status => x_return_status ,
6715: x_error_count => x_error_count ,

Line 6804: ELSIF p_wlt_txn_type = WSMPCNST.MERGE THEN -- Merge transaction

6800: where transaction_id = p_txn_id);
6801:
6802: END IF;
6803:
6804: ELSIF p_wlt_txn_type = WSMPCNST.MERGE THEN -- Merge transaction
6805:
6806: l_stmt_num := 160;
6807: -- Now the main processing part starts...
6808: if g_wms_installed IS NULL THEN

Line 7033: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_ASSEMBLY THEN -- Update Assembly transaction

7029: l_index := p_starting_jobs_tbl.next(l_index);
7030:
7031: END LOOP;
7032:
7033: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_ASSEMBLY THEN -- Update Assembly transaction
7034:
7035: l_stmt_num := 210;
7036: -- Now the main processing part starts...
7037: if g_wms_installed IS NULL THEN

Line 7133: p_transaction_type_id => WSMPCNST.UPDATE_ASSEMBLY ,

7129: end if;
7130:
7131: l_stmt_num := 240;
7132: Insert_into_WST ( p_transaction_id => p_txn_id ,
7133: p_transaction_type_id => WSMPCNST.UPDATE_ASSEMBLY ,
7134: p_old_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7135: p_new_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7136: p_wip_entity_id => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_id ,
7137: p_organization_id => p_organization_id ,

Line 7152: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_ROUTING THEN -- Update Routing transaction

7148: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7149: END IF;
7150: end if;
7151:
7152: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_ROUTING THEN -- Update Routing transaction
7153:
7154: l_stmt_num := 250;
7155:
7156: -- Invoke the new INV API procedure...

Line 7192: p_transaction_type_id => WSMPCNST.UPDATE_ROUTING ,

7188:
7189: l_stmt_num := 260;
7190: -- Invoke the call to insert into the new table...
7191: Insert_into_WST ( p_transaction_id => p_txn_id ,
7192: p_transaction_type_id => WSMPCNST.UPDATE_ROUTING ,
7193: p_old_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7194: p_new_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7195: p_wip_entity_id => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_id ,
7196: p_organization_id => p_organization_id ,

Line 7211: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_LOT_NAME THEN -- Update Lot Name transaction

7207: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7208: END IF;
7209: end if;
7210:
7211: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_LOT_NAME THEN -- Update Lot Name transaction
7212:
7213: l_stmt_num := 270;
7214: Insert_into_WST ( p_transaction_id => p_txn_id ,
7215: p_transaction_type_id => WSMPCNST.UPDATE_ROUTING ,

Line 7215: p_transaction_type_id => WSMPCNST.UPDATE_ROUTING ,

7211: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_LOT_NAME THEN -- Update Lot Name transaction
7212:
7213: l_stmt_num := 270;
7214: Insert_into_WST ( p_transaction_id => p_txn_id ,
7215: p_transaction_type_id => WSMPCNST.UPDATE_ROUTING ,
7216: p_old_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7217: p_new_wip_entity_name => p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).wip_entity_name ,
7218: p_wip_entity_id => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_id ,
7219: p_organization_id => p_organization_id ,

Line 7234: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_QUANTITY THEN -- Update Quantity transaction

7230: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7231: END IF;
7232: end if;
7233:
7234: ELSIF p_wlt_txn_type = WSMPCNST.UPDATE_QUANTITY THEN -- Update Quantity transaction
7235:
7236: l_stmt_num := 280;
7237: IF l_serial_start_flag IS NULL then
7238:

Line 7262: p_transaction_type_id => WSMPCNST.UPDATE_QUANTITY ,

7258: ELSE
7259: -- ST : Fix for bug 5143373
7260: -- Insert the existing serials...
7261: Insert_into_WST ( p_transaction_id => p_txn_id ,
7262: p_transaction_type_id => WSMPCNST.UPDATE_QUANTITY ,
7263: p_old_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7264: p_new_wip_entity_name => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_name ,
7265: p_wip_entity_id => p_starting_jobs_tbl(p_starting_jobs_tbl.first).wip_entity_id ,
7266: p_organization_id => p_organization_id ,