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 WIP_CONSTANTS

Line 1340: p_skip_serial => wip_constants.yes,

1336: p_group_mark_id => null,
1337: p_line_mark_id => null,
1338: p_rev => null,
1339: p_lot => null,
1340: p_skip_serial => wip_constants.yes,
1341: x_start_ser => l_serial_number,
1342: x_end_ser => l_serial_number,
1343: x_proc_msg => x_error_msg);
1344:

Line 1604: p_skip_serial => wip_constants.yes,

1600: p_group_mark_id => null,
1601: p_line_mark_id => null,
1602: p_rev => null,
1603: p_lot => null,
1604: p_skip_serial => wip_constants.yes,
1605: x_start_ser => p_serial_number,
1606: x_end_ser => p_serial_number,
1607: x_proc_msg => x_error_msg);
1608:

Line 3237: set process_status = wip_constants.error

3233: -- issue an update statement to the interface records setting them to errored..
3234: l_row_updated := 0;
3235: IF p_wsm_serial_nums_tbl.count = 0 THEN
3236: update wsm_serial_txn_interface
3237: set process_status = wip_constants.error
3238: where header_id = p_header_id
3239: and transaction_type_id = 2;
3240:
3241: l_row_updated := SQL%ROWCOUNT;

Line 3321: set wsti.process_status = wip_constants.error

3317: l_stmt_num := 70;
3318: l_row_updated := 0;
3319: IF p_wsm_serial_nums_tbl.count = 0 then
3320: update wsm_serial_txn_interface wsti
3321: set wsti.process_status = wip_constants.error
3322: where wsti.header_id = p_header_id
3323: and wsti.transaction_type_id = 2
3324: and wsti.action_flag in (5,6);
3325:

Line 3354: set wsti.process_status = wip_constants.error

3350: l_stmt_num := 90;
3351:
3352: IF p_wsm_serial_nums_tbl.count = 0 then
3353: update wsm_serial_txn_interface wsti
3354: set wsti.process_status = wip_constants.error
3355: where wsti.header_id = p_header_id
3356: and wsti.transaction_type_id = 2
3357: and wsti.action_flag in (5,6)
3358: and not exists( SELECT MSN.serial_number

Line 3364: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

3360: WHERE MSN.SERIAL_NUMBER = wsti.serial_number
3361: AND MSN.wip_entity_id = p_wip_entity_id
3362: AND MSN.current_organization_id = p_organization_id
3363: AND MSN.inventory_item_id = p_inventory_item_id
3364: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
3365: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
3366: --AND MSN.intraoperation_step_type = p_curr_job_intraop_step
3367: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
3368: );

Line 3367: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP

3363: AND MSN.inventory_item_id = p_inventory_item_id
3364: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
3365: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
3366: --AND MSN.intraoperation_step_type = p_curr_job_intraop_step
3367: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
3368: );
3369:
3370: if SQL%ROWCOUNT > 0 then
3371: -- Error out..

Line 3916: (p_to_intraoperation_step <> WIP_CONSTANTS.QUEUE OR

3912: -- iii) Completion txn
3913: -- iv) From operation is the serial start op and is a jump op and charge current op during jump is Yes
3914: If ( p_to_rtg_op_seq_num = p_job_serial_start_op
3915: AND
3916: (p_to_intraoperation_step <> WIP_CONSTANTS.QUEUE OR
3917: (nvl(p_scrap_qty,0) <> 0 AND nvl(p_scrap_at_operation,1) = 2)
3918: -- ST : Fix for bug 5140761 Added the above clause --
3919: )
3920: )

Line 3980: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP;

3976: FROM mtl_serial_numbers MSN
3977: where MSN.wip_entity_id = p_wip_entity_id
3978: AND MSN.current_organization_id = p_organization_id
3979: AND MSN.inventory_item_id = p_inventory_item_id
3980: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP;
3981:
3982: -- ST : Fix for bug 5190943 : Added the validation --
3983: -- Now validate the qty for a non-serial traked job
3984: IF x_serial_track_flag IS NULL THEN

Line 4221: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

4217: FROM MTL_SERIAL_NUMBERS MSN
4218: WHERE MSN.wip_entity_id = p_wip_entity_id
4219: AND MSN.current_organization_id = p_organization_id
4220: AND MSN.inventory_item_id = p_inventory_item_id
4221: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4222: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4223: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4224: AND NOT EXISTS (select 'Serial Already inserted for move'
4225: from WIP_SERIAL_MOVE_INTERFACE

Line 4223: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP

4219: AND MSN.current_organization_id = p_organization_id
4220: AND MSN.inventory_item_id = p_inventory_item_id
4221: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4222: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4223: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4224: AND NOT EXISTS (select 'Serial Already inserted for move'
4225: from WIP_SERIAL_MOVE_INTERFACE
4226: where TRANSACTION_ID = p_move_txn_id
4227: AND ASSEMBLY_SERIAL_NUMBER = MSN.SERIAL_NUMBER

Line 4353: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

4349: FROM MTL_SERIAL_NUMBERS MSN
4350: WHERE MSN.wip_entity_id = p_wip_entity_id
4351: AND MSN.current_organization_id = p_organization_id
4352: AND MSN.inventory_item_id = p_inventory_item_id
4353: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4354: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4355: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4356: AND NOT EXISTS (select 'Serial Already inserted for move'
4357: from WIP_SERIAL_MOVE_INTERFACE

Line 4355: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP

4351: AND MSN.current_organization_id = p_organization_id
4352: AND MSN.inventory_item_id = p_inventory_item_id
4353: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4354: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4355: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4356: AND NOT EXISTS (select 'Serial Already inserted for move'
4357: from WIP_SERIAL_MOVE_INTERFACE
4358: where TRANSACTION_ID = p_move_txn_id
4359: AND ASSEMBLY_SERIAL_NUMBER = MSN.SERIAL_NUMBER

Line 4426: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

4422: FROM MTL_SERIAL_NUMBERS MSN
4423: WHERE MSN.wip_entity_id = p_wip_entity_id
4424: AND MSN.current_organization_id = p_organization_id
4425: AND MSN.inventory_item_id = p_inventory_item_id
4426: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4427: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4428: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4429: );
4430:

Line 4428: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP

4424: AND MSN.current_organization_id = p_organization_id
4425: AND MSN.inventory_item_id = p_inventory_item_id
4426: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4427: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4428: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4429: );
4430:
4431: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4432: l_msg_tokens.delete;

Line 4484: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

4480: FROM MTL_SERIAL_NUMBERS MSN
4481: WHERE MSN.wip_entity_id = p_wip_entity_id
4482: AND MSN.current_organization_id = p_organization_id
4483: AND MSN.inventory_item_id = p_inventory_item_id
4484: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4485: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4486: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4487: );
4488:

Line 4486: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP

4482: AND MSN.current_organization_id = p_organization_id
4483: AND MSN.inventory_item_id = p_inventory_item_id
4484: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4485: -- AND MSN.operation_seq_num = p_curr_job_op_seq_num
4486: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP
4487: );
4488:
4489: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
4490: l_msg_tokens.delete;

Line 4752: --AND MSN.current_status = WIP_CONSTANTS.IN_STORES

4748: WHERE WSMT.transaction_id = v_txn_id
4749: )
4750: AND MSN.current_organization_id = p_organization_id
4751: AND MSN.inventory_item_id = p_inventory_item_id
4752: --AND MSN.current_status = WIP_CONSTANTS.IN_STORES
4753: FOR UPDATE NOWAIT;
4754:
4755: cursor c_undo_serial_num(v_txn_id IN NUMBER) IS
4756: SELECT MSN.serial_number,

Line 4765: --AND MSN.current_status = WIP_CONSTANTS.DEF_NOT_USED

4761: WHERE WSMT.transaction_id = v_txn_id
4762: )
4763: AND MSN.current_organization_id = p_organization_id
4764: AND MSN.inventory_item_id = p_inventory_item_id
4765: --AND MSN.current_status = WIP_CONSTANTS.DEF_NOT_USED
4766: AND MSN.wip_entity_id = p_wip_entity_id
4767: FOR UPDATE NOWAIT;
4768:
4769: type t_serial_txn_info_rec is RECORD

Line 5298: set wsti.process_status = wip_constants.error

5294: );
5295: END IF;
5296:
5297: update wsm_serial_txn_interface wsti
5298: set wsti.process_status = wip_constants.error
5299: where wsti.header_id = p_header_id
5300: and wsti.transaction_type_id = 3
5301: and serial_number not in ( SELECT MSN.serial_number
5302: FROM MTL_SERIAL_NUMBERS MSN

Line 5306: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

5302: FROM MTL_SERIAL_NUMBERS MSN
5303: WHERE MSN.wip_entity_id = l_wip_entity_id
5304: AND MSN.current_organization_id = p_organization_id
5305: AND MSN.inventory_item_id = l_inventory_item_id
5306: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES
5307: -- AND MSN.operation_seq_num = l_op_seq_num
5308: -- AND MSN.intraoperation_step_type = p_curr_job_intraop_step < not required...>
5309: AND nvl(MSN.intraoperation_step_type,-1) <> 5
5310: );

Line 5342: set wsti.process_status = wip_constants.error

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
5343: where wsti.header_id = p_header_id
5344: and wsti.transaction_type_id = 3
5345: and action_flag not in (WSM_GASSOC_SERIAL_NUM,WSM_ADD_SERIAL_NUM);
5346:

Line 5728: AND nvl(msn.INTRAOPERATION_STEP_TYPE,-1) <> WIP_CONSTANTS.SCRAP

5724: IS SELECT msn.serial_number
5725: FROM MTL_SERIAL_NUMBERS MSN
5726: WHERE msn.wip_entity_id = v_wip_entity_id
5727: AND msn.inventory_item_id = v_item_id
5728: AND nvl(msn.INTRAOPERATION_STEP_TYPE,-1) <> WIP_CONSTANTS.SCRAP
5729: AND msn.current_organization_id = p_organization_id;
5730:
5731: -- Logging variables.....
5732: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

Line 5847: l_curr_job_op_step := WIP_CONSTANTS.QUEUE;

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;
5850: l_curr_job_op_step := p_starting_jobs_tbl(l_rep_job_index).intraoperation_step;
5851: END IF;

Line 6537: l_temp_op_step := WIP_CONSTANTS.QUEUE;

6533:
6534: IF l_serial_start_flag IS NOT NULL THEN
6535: -- Indicates that serial tracking hasnt begun
6536: l_temp_op_seq_num := l_curr_job_op_seq_num + l_op_seq_incr;
6537: l_temp_op_step := WIP_CONSTANTS.QUEUE;
6538: ELSE
6539: l_temp_op_seq_num := NULL;
6540: l_temp_op_step := NULL;
6541: END IF;

Line 7593: precision => WIP_CONSTANTS.MAX_NUMBER_PRECISION,

7589: l_stmt_num := 60;
7590:
7591: -- get the conversion rate....
7592: l_conv_rate := inv_convert.inv_um_convert(item_id => p_primary_qty,
7593: precision => WIP_CONSTANTS.MAX_NUMBER_PRECISION,
7594: from_quantity => 1,
7595: from_unit => p_transaction_uom,
7596: to_unit => p_primary_uom,
7597: from_name => NULL,

Line 7623: IF ( floor(round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION))

7619: END IF;
7620:
7621: l_stmt_num := 70;
7622:
7623: IF ( floor(round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION))
7624: <>
7625: round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION)
7626: )
7627: THEN

Line 7625: round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION)

7621: l_stmt_num := 70;
7622:
7623: IF ( floor(round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION))
7624: <>
7625: round(l_conv_rate * p_transaction_qty, WIP_CONSTANTS.MAX_NUMBER_PRECISION)
7626: )
7627: THEN
7628:
7629: IF g_log_level_error >= l_log_level OR

Line 8202: and wlmti.status = WIP_CONSTANTS.COMPLETED

8198: where wlmti.group_id = p_group_id
8199: and wlmti.internal_group_id = p_internal_group_id
8200: and wlmti.wip_entity_id = wmt.wip_entity_id
8201: and wmt.group_id = p_internal_group_id
8202: and wlmti.status = WIP_CONSTANTS.COMPLETED
8203: and wmt.wip_entity_id = wlbj.wip_entity_id
8204: and wlbj.first_serial_txn_id IS NULL
8205: and msn.inventory_item_id = wmt.primary_item_id
8206: and msn.current_organization_id = wmt.organization_id

Line 8223: and wlmti.status = WIP_CONSTANTS.COMPLETED

8219: wsm_lot_based_jobs wlbj
8220: where wlmti.group_id = p_group_id
8221: and wlmti.internal_group_id = p_internal_group_id
8222: and wlmti.wip_entity_id = wdj.wip_entity_id
8223: and wlmti.status = WIP_CONSTANTS.COMPLETED
8224: and wdj.wip_entity_id = wlbj.wip_entity_id
8225: and wlbj.first_serial_txn_id = -1 -- It will be set to -1 only for those jobs created through Lot Creation form..
8226: and msn.inventory_item_id = wdj.primary_item_id
8227: and msn.current_organization_id = wdj.organization_id

Line 8362: and wlmti.status = WIP_CONSTANTS.COMPLETED

8358: wsm_lot_move_txn_interface wlmti
8359: where wlmti.group_id = p_group_id
8360: and wlmti.internal_group_id = p_internal_group_id
8361: and wlmti.wip_entity_id = wmt.wip_entity_id
8362: and wlmti.status = WIP_CONSTANTS.COMPLETED
8363: )
8364: and transaction_type_id = 5;
8365:
8366: cursor c_serials_attr_form

Line 8668: p_intraoperation_step_type => WIP_CONSTANTS.QUEUE ,

8664: p_inventory_item_id => l_serial_info_tbl(l_cntr).inventory_item_id ,
8665: p_organization_id => l_serial_info_tbl(l_cntr).organization_id ,
8666: p_wip_entity_id => l_serial_info_tbl(l_cntr).wip_entity_id ,
8667: p_operation_seq_num => 10 ,
8668: p_intraoperation_step_type => WIP_CONSTANTS.QUEUE ,
8669: x_return_status => x_return_status ,
8670: x_error_msg => x_error_msg ,
8671: x_error_count => x_error_count
8672: );

Line 8718: p_intraoperation_step_type => WIP_CONSTANTS.QUEUE ,

8714: p_inventory_item_id => l_serial_info_tbl(l_cntr).inventory_item_id ,
8715: p_organization_id => l_serial_info_tbl(l_cntr).organization_id ,
8716: p_wip_entity_id => l_serial_info_tbl(l_cntr).wip_entity_id ,
8717: p_operation_seq_num => 10 ,
8718: p_intraoperation_step_type => WIP_CONSTANTS.QUEUE ,
8719: x_return_status => x_return_status ,
8720: x_error_msg => x_error_msg ,
8721: x_error_count => x_error_count
8722: );