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.WSMPUTIL dependencies on WIP_CONSTANTS

Line 3942: AND bres.autocharge_type = WIP_CONSTANTS.PO_MOVE ;

3938: /*BA HH24MISS */
3939: AND nvl(p_routing_rev_date, SYSDATE) BETWEEN
3940: bos.effectivity_date AND nvl(bos.disable_date, nvl(p_routing_rev_date, SYSDATE)+1)
3941: /*EA HH24MISS */
3942: AND bres.autocharge_type = WIP_CONSTANTS.PO_MOVE ;
3943:
3944: -- when the id passed is operation_sequence_id
3945:
3946: elsif p_sequence_id_type = 'O' then

Line 3964: AND bres.autocharge_type = WIP_CONSTANTS.PO_MOVE ;

3960: /*BA HH24MISS */
3961: AND nvl(p_routing_rev_date, SYSDATE) BETWEEN
3962: bos.effectivity_date AND nvl(bos.disable_date, nvl(p_routing_rev_date, SYSDATE)+1)
3963: /*EA HH24MISS */
3964: AND bres.autocharge_type = WIP_CONSTANTS.PO_MOVE ;
3965:
3966: -- when the id passed is standard_operation_id
3967:
3968: elsif p_sequence_id_type = 'S' then

Line 3974: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE;

3970: SELECT count(*)
3971: INTO x_rowcount
3972: FROM bom_std_op_resources bsor
3973: WHERE bsor.standard_operation_id = p_sequence_id
3974: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE;
3975:
3976: end if;
3977:
3978: if x_rowcount <> 0 then

Line 4074: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

4070: from wsm_starting_jobs_interface wsji,
4071: wsm_split_merge_txn_interface wsmti
4072: where wsji.wip_entity_id = wt.wip_entity_id
4073: and wsmti.header_id = wsji.header_id
4074: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4075: or exists (
4076: select 1
4077: from wsm_resulting_jobs_interface wrji,
4078: wsm_split_merge_txn_interface wsmti

Line 4081: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

4077: from wsm_resulting_jobs_interface wrji,
4078: wsm_split_merge_txn_interface wsmti
4079: where wrji.wip_entity_name = wt.wip_entity_name
4080: and wsmti.header_id = wrji.header_id
4081: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4082: --Bug 4744794: Separate SQLs are used to select the records for the cases
4083: -- wip_entity_id is Null and wip_entity_id is NOT NULL
4084: or exists (
4085: select 1

Line 4090: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

4086: from wsm_lot_move_txn_interface wlmti
4087: --where (nvl(wlmti.wip_entity_id, -9999) = wt.wip_entity_id or
4088: -- nvl(wlmti.wip_entity_name, '@#$*') = wt.wip_entity_name)
4089: where wlmti.wip_entity_id = wt.wip_entity_id
4090: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4091: or exists (
4092: select 1
4093: from wsm_lot_move_txn_interface wlmti
4094: where wlmti.wip_entity_name = wt.wip_entity_name

Line 4096: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING)));

4092: select 1
4093: from wsm_lot_move_txn_interface wlmti
4094: where wlmti.wip_entity_name = wt.wip_entity_name
4095: and wlmti.organization_id = wt.organization_id
4096: and wlmti.status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING)));
4097:
4098: if sql%rowcount > 0 then
4099: x_err_code := 0; -- this is needed by WIP to figure out whether to end the request in warning or success.
4100: end if;

Line 4618: and wor.autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT,

4614: from wip_operation_resources wor
4615: where wor.organization_id = p_organization_id
4616: and wor.wip_entity_id = p_wip_entity_id
4617: and wor.operation_seq_num = nvl(p_operation_seq_num,wor.operation_seq_num)
4618: and wor.autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT,
4619: WIP_CONSTANTS.PO_MOVE);
4620: p_operation_seq_num := l_op_seq_num ;
4621: return true;
4622:

Line 4619: WIP_CONSTANTS.PO_MOVE);

4615: where wor.organization_id = p_organization_id
4616: and wor.wip_entity_id = p_wip_entity_id
4617: and wor.operation_seq_num = nvl(p_operation_seq_num,wor.operation_seq_num)
4618: and wor.autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT,
4619: WIP_CONSTANTS.PO_MOVE);
4620: p_operation_seq_num := l_op_seq_num ;
4621: return true;
4622:
4623: exception

Line 4682: AND WLMTI.status IN (WIP_CONSTANTS.PENDING,

4678: where exists (select 'Unprocessed WLMTI Record exists'
4679: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4680: WHERE WLMTI.entity_type = 5
4681: AND WLMTI.wip_entity_id = p_wip_entity_id
4682: AND WLMTI.status IN (WIP_CONSTANTS.PENDING,
4683: WIP_CONSTANTS.RUNNING,
4684: WIP_CONSTANTS.ERROR)
4685: AND WLMTI.transaction_date <= p_transaction_date
4686: AND WLMTI.header_id <> p_header_id);

Line 4683: WIP_CONSTANTS.RUNNING,

4679: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4680: WHERE WLMTI.entity_type = 5
4681: AND WLMTI.wip_entity_id = p_wip_entity_id
4682: AND WLMTI.status IN (WIP_CONSTANTS.PENDING,
4683: WIP_CONSTANTS.RUNNING,
4684: WIP_CONSTANTS.ERROR)
4685: AND WLMTI.transaction_date <= p_transaction_date
4686: AND WLMTI.header_id <> p_header_id);
4687: -- Use of header_id here in WLMTI is useful to support BULK MOVE Txns

Line 4684: WIP_CONSTANTS.ERROR)

4680: WHERE WLMTI.entity_type = 5
4681: AND WLMTI.wip_entity_id = p_wip_entity_id
4682: AND WLMTI.status IN (WIP_CONSTANTS.PENDING,
4683: WIP_CONSTANTS.RUNNING,
4684: WIP_CONSTANTS.ERROR)
4685: AND WLMTI.transaction_date <= p_transaction_date
4686: AND WLMTI.header_id <> p_header_id);
4687: -- Use of header_id here in WLMTI is useful to support BULK MOVE Txns
4688: -- Otherwise, I don't see any use for this. -- BBK.

Line 4707: AND WLMTI.status IN (WIP_CONSTANTS. PENDING,

4703: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4704: WHERE WLMTI.entity_type = 5
4705: AND WLMTI.wip_entity_name = p_wip_entity_name
4706: AND WLMTI.organization_id = decode(p_organization_id, 0, WLMTI.organization_id, p_organization_id)
4707: AND WLMTI.status IN (WIP_CONSTANTS. PENDING,
4708: WIP_CONSTANTS.RUNNING,
4709: WIP_CONSTANTS.ERROR)
4710: AND WLMTI.transaction_date <= p_transaction_date
4711: AND WLMTI.header_id <> p_header_id );

Line 4708: WIP_CONSTANTS.RUNNING,

4704: WHERE WLMTI.entity_type = 5
4705: AND WLMTI.wip_entity_name = p_wip_entity_name
4706: AND WLMTI.organization_id = decode(p_organization_id, 0, WLMTI.organization_id, p_organization_id)
4707: AND WLMTI.status IN (WIP_CONSTANTS. PENDING,
4708: WIP_CONSTANTS.RUNNING,
4709: WIP_CONSTANTS.ERROR)
4710: AND WLMTI.transaction_date <= p_transaction_date
4711: AND WLMTI.header_id <> p_header_id );
4712:

Line 4709: WIP_CONSTANTS.ERROR)

4705: AND WLMTI.wip_entity_name = p_wip_entity_name
4706: AND WLMTI.organization_id = decode(p_organization_id, 0, WLMTI.organization_id, p_organization_id)
4707: AND WLMTI.status IN (WIP_CONSTANTS. PENDING,
4708: WIP_CONSTANTS.RUNNING,
4709: WIP_CONSTANTS.ERROR)
4710: AND WLMTI.transaction_date <= p_transaction_date
4711: AND WLMTI.header_id <> p_header_id );
4712:
4713:

Line 4820: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,

4816: where exists (select 'Unprocessed WMTI Record exists'
4817: FROM WIP_MOVE_TXN_INTERFACE WMTI
4818: WHERE WMTI.entity_type = 5
4819: AND WMTI.wip_entity_id = p_wip_entity_id
4820: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4821: WIP_CONSTANTS.RUNNING,
4822: WIP_CONSTANTS.ERROR)
4823: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4824: ); -- So that it doesn't pick up itself

Line 4821: WIP_CONSTANTS.RUNNING,

4817: FROM WIP_MOVE_TXN_INTERFACE WMTI
4818: WHERE WMTI.entity_type = 5
4819: AND WMTI.wip_entity_id = p_wip_entity_id
4820: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4821: WIP_CONSTANTS.RUNNING,
4822: WIP_CONSTANTS.ERROR)
4823: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4824: ); -- So that it doesn't pick up itself
4825:

Line 4822: WIP_CONSTANTS.ERROR)

4818: WHERE WMTI.entity_type = 5
4819: AND WMTI.wip_entity_id = p_wip_entity_id
4820: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4821: WIP_CONSTANTS.RUNNING,
4822: WIP_CONSTANTS.ERROR)
4823: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4824: ); -- So that it doesn't pick up itself
4825:
4826:

Line 4845: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,

4841: FROM WIP_MOVE_TXN_INTERFACE WMTI
4842: WHERE WMTI.entity_type = 5
4843: AND WMTI.wip_entity_name = p_wip_entity_name
4844: AND WMTI.organization_id = decode(p_organization_id, 0, WMTI.organization_id, p_organization_id)
4845: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4846: WIP_CONSTANTS.RUNNING,
4847: WIP_CONSTANTS.ERROR)
4848: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4849: );

Line 4846: WIP_CONSTANTS.RUNNING,

4842: WHERE WMTI.entity_type = 5
4843: AND WMTI.wip_entity_name = p_wip_entity_name
4844: AND WMTI.organization_id = decode(p_organization_id, 0, WMTI.organization_id, p_organization_id)
4845: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4846: WIP_CONSTANTS.RUNNING,
4847: WIP_CONSTANTS.ERROR)
4848: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4849: );
4850:

Line 4847: WIP_CONSTANTS.ERROR)

4843: AND WMTI.wip_entity_name = p_wip_entity_name
4844: AND WMTI.organization_id = decode(p_organization_id, 0, WMTI.organization_id, p_organization_id)
4845: AND WMTI.process_status IN (WIP_CONSTANTS.PENDING,
4846: WIP_CONSTANTS.RUNNING,
4847: WIP_CONSTANTS.ERROR)
4848: AND WMTI.transaction_date < nvl(p_transaction_date, SYSDATE)
4849: );
4850:
4851:

Line 4978: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

4974: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
4975: WHERE
4976: WSSJ.wip_entity_id = p_wip_entity_id
4977: AND WSMT.transaction_id = WSSJ.transaction_id
4978: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
4979: WIP_CONSTANTS.RUNNING,
4980: WIP_CONSTANTS.ERROR)
4981: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
4982: );

Line 4979: WIP_CONSTANTS.RUNNING,

4975: WHERE
4976: WSSJ.wip_entity_id = p_wip_entity_id
4977: AND WSMT.transaction_id = WSSJ.transaction_id
4978: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
4979: WIP_CONSTANTS.RUNNING,
4980: WIP_CONSTANTS.ERROR)
4981: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
4982: );
4983:

Line 4980: WIP_CONSTANTS.ERROR)

4976: WSSJ.wip_entity_id = p_wip_entity_id
4977: AND WSMT.transaction_id = WSSJ.transaction_id
4978: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
4979: WIP_CONSTANTS.RUNNING,
4980: WIP_CONSTANTS.ERROR)
4981: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
4982: );
4983:
4984: EXCEPTION

Line 5004: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

5000: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5001: WHERE
5002: WSSJ.wip_entity_id = p_wip_entity_id
5003: AND WSMT.transaction_id = WSSJ.transaction_id
5004: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5005: WIP_CONSTANTS.RUNNING,
5006: WIP_CONSTANTS.ERROR)
5007: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5008: AND WSMT.transaction_id <> p_transaction_id

Line 5005: WIP_CONSTANTS.RUNNING,

5001: WHERE
5002: WSSJ.wip_entity_id = p_wip_entity_id
5003: AND WSMT.transaction_id = WSSJ.transaction_id
5004: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5005: WIP_CONSTANTS.RUNNING,
5006: WIP_CONSTANTS.ERROR)
5007: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5008: AND WSMT.transaction_id <> p_transaction_id
5009: );

Line 5006: WIP_CONSTANTS.ERROR)

5002: WSSJ.wip_entity_id = p_wip_entity_id
5003: AND WSMT.transaction_id = WSSJ.transaction_id
5004: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5005: WIP_CONSTANTS.RUNNING,
5006: WIP_CONSTANTS.ERROR)
5007: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5008: AND WSMT.transaction_id <> p_transaction_id
5009: );
5010:

Line 5041: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

5037: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5038: WHERE
5039: WSRJ.wip_entity_id = p_wip_entity_id
5040: AND WSMT.transaction_id = WSRJ.transaction_id
5041: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5042: WIP_CONSTANTS.RUNNING,
5043: WIP_CONSTANTS.ERROR)
5044: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5045: );

Line 5042: WIP_CONSTANTS.RUNNING,

5038: WHERE
5039: WSRJ.wip_entity_id = p_wip_entity_id
5040: AND WSMT.transaction_id = WSRJ.transaction_id
5041: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5042: WIP_CONSTANTS.RUNNING,
5043: WIP_CONSTANTS.ERROR)
5044: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5045: );
5046:

Line 5043: WIP_CONSTANTS.ERROR)

5039: WSRJ.wip_entity_id = p_wip_entity_id
5040: AND WSMT.transaction_id = WSRJ.transaction_id
5041: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5042: WIP_CONSTANTS.RUNNING,
5043: WIP_CONSTANTS.ERROR)
5044: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5045: );
5046:
5047: EXCEPTION

Line 5066: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

5062: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5063: WHERE
5064: WSRJ.wip_entity_id = p_wip_entity_id
5065: AND WSMT.transaction_id = WSRJ.transaction_id
5066: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5067: WIP_CONSTANTS.RUNNING,
5068: WIP_CONSTANTS.ERROR)
5069: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5070: AND WSMT.transaction_id <> p_transaction_id

Line 5067: WIP_CONSTANTS.RUNNING,

5063: WHERE
5064: WSRJ.wip_entity_id = p_wip_entity_id
5065: AND WSMT.transaction_id = WSRJ.transaction_id
5066: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5067: WIP_CONSTANTS.RUNNING,
5068: WIP_CONSTANTS.ERROR)
5069: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5070: AND WSMT.transaction_id <> p_transaction_id
5071: );

Line 5068: WIP_CONSTANTS.ERROR)

5064: WSRJ.wip_entity_id = p_wip_entity_id
5065: AND WSMT.transaction_id = WSRJ.transaction_id
5066: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5067: WIP_CONSTANTS.RUNNING,
5068: WIP_CONSTANTS.ERROR)
5069: AND WSMT.transaction_date <= nvl(p_transaction_date,SYSDATE)
5070: AND WSMT.transaction_id <> p_transaction_id
5071: );
5072: EXCEPTION

Line 5110: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

5106: WSRJ.wip_entity_name = p_wip_entity_name
5107: AND WSMT.organization_id = decode(p_organization_id,
5108: 0, WSMT.organization_id, p_organization_id)
5109: AND WSMT.transaction_id = WSRJ.transaction_id
5110: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5111: WIP_CONSTANTS.RUNNING,
5112: WIP_CONSTANTS.ERROR)
5113: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5114: );

Line 5111: WIP_CONSTANTS.RUNNING,

5107: AND WSMT.organization_id = decode(p_organization_id,
5108: 0, WSMT.organization_id, p_organization_id)
5109: AND WSMT.transaction_id = WSRJ.transaction_id
5110: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5111: WIP_CONSTANTS.RUNNING,
5112: WIP_CONSTANTS.ERROR)
5113: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5114: );
5115:

Line 5112: WIP_CONSTANTS.ERROR)

5108: 0, WSMT.organization_id, p_organization_id)
5109: AND WSMT.transaction_id = WSRJ.transaction_id
5110: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5111: WIP_CONSTANTS.RUNNING,
5112: WIP_CONSTANTS.ERROR)
5113: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5114: );
5115:
5116: EXCEPTION

Line 5138: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

5134: WSRJ.wip_entity_name = p_wip_entity_name
5135: AND WSMT.organization_id = decode(p_organization_id,
5136: 0, WSMT.organization_id, p_organization_id)
5137: AND WSMT.transaction_id = WSRJ.transaction_id
5138: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5139: WIP_CONSTANTS.RUNNING,
5140: WIP_CONSTANTS.ERROR)
5141: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5142: AND WSMT.transaction_id <> p_transaction_id

Line 5139: WIP_CONSTANTS.RUNNING,

5135: AND WSMT.organization_id = decode(p_organization_id,
5136: 0, WSMT.organization_id, p_organization_id)
5137: AND WSMT.transaction_id = WSRJ.transaction_id
5138: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5139: WIP_CONSTANTS.RUNNING,
5140: WIP_CONSTANTS.ERROR)
5141: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5142: AND WSMT.transaction_id <> p_transaction_id
5143: );

Line 5140: WIP_CONSTANTS.ERROR)

5136: 0, WSMT.organization_id, p_organization_id)
5137: AND WSMT.transaction_id = WSRJ.transaction_id
5138: AND WSMT.status IN (WIP_CONSTANTS.PENDING,
5139: WIP_CONSTANTS.RUNNING,
5140: WIP_CONSTANTS.ERROR)
5141: AND WSMT.transaction_date <= nvl(p_transaction_date, SYSDATE)
5142: AND WSMT.transaction_id <> p_transaction_id
5143: );
5144: EXCEPTION

Line 5367: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

5363: FROM WSM_STARTING_JOBS_INTERFACE WSJI,
5364: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5365: WHERE WSJI.wip_entity_id = p_wip_entity_id
5366: AND WSMTI.header_id = WSJI.header_id
5367: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5368: WIP_CONSTANTS.RUNNING,
5369: WIP_CONSTANTS.ERROR)
5370: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5371: );

Line 5368: WIP_CONSTANTS.RUNNING,

5364: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5365: WHERE WSJI.wip_entity_id = p_wip_entity_id
5366: AND WSMTI.header_id = WSJI.header_id
5367: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5368: WIP_CONSTANTS.RUNNING,
5369: WIP_CONSTANTS.ERROR)
5370: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5371: );
5372:

Line 5369: WIP_CONSTANTS.ERROR)

5365: WHERE WSJI.wip_entity_id = p_wip_entity_id
5366: AND WSMTI.header_id = WSJI.header_id
5367: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5368: WIP_CONSTANTS.RUNNING,
5369: WIP_CONSTANTS.ERROR)
5370: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5371: );
5372:
5373: EXCEPTION

Line 5405: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

5401: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5402: WHERE WRJI.wip_entity_name = l_wip_entity_name
5403: AND WSMTI.organization_id = l_organization_id
5404: AND WSMTI.header_id = WRJI.header_id
5405: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5406: WIP_CONSTANTS.RUNNING,
5407: WIP_CONSTANTS.ERROR)
5408: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5409: );

Line 5406: WIP_CONSTANTS.RUNNING,

5402: WHERE WRJI.wip_entity_name = l_wip_entity_name
5403: AND WSMTI.organization_id = l_organization_id
5404: AND WSMTI.header_id = WRJI.header_id
5405: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5406: WIP_CONSTANTS.RUNNING,
5407: WIP_CONSTANTS.ERROR)
5408: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5409: );
5410:

Line 5407: WIP_CONSTANTS.ERROR)

5403: AND WSMTI.organization_id = l_organization_id
5404: AND WSMTI.header_id = WRJI.header_id
5405: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5406: WIP_CONSTANTS.RUNNING,
5407: WIP_CONSTANTS.ERROR)
5408: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5409: );
5410:
5411: EXCEPTION

Line 5441: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

5437: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5438: WHERE WSJI.wip_entity_name = p_wip_entity_name
5439: AND WSMTI.organization_id = p_organization_id
5440: AND WSMTI.header_id = WSJI.header_id
5441: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5442: WIP_CONSTANTS.RUNNING,
5443: WIP_CONSTANTS.ERROR)
5444: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5445: );

Line 5442: WIP_CONSTANTS.RUNNING,

5438: WHERE WSJI.wip_entity_name = p_wip_entity_name
5439: AND WSMTI.organization_id = p_organization_id
5440: AND WSMTI.header_id = WSJI.header_id
5441: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5442: WIP_CONSTANTS.RUNNING,
5443: WIP_CONSTANTS.ERROR)
5444: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5445: );
5446:

Line 5443: WIP_CONSTANTS.ERROR)

5439: AND WSMTI.organization_id = p_organization_id
5440: AND WSMTI.header_id = WSJI.header_id
5441: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5442: WIP_CONSTANTS.RUNNING,
5443: WIP_CONSTANTS.ERROR)
5444: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5445: );
5446:
5447: EXCEPTION

Line 5472: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

5468: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5469: WHERE WRJI.wip_entity_name = p_wip_entity_name
5470: AND WSMTI.organization_id = p_organization_id
5471: AND WSMTI.header_id = WRJI.header_id
5472: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5473: WIP_CONSTANTS.RUNNING,
5474: WIP_CONSTANTS.ERROR)
5475: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5476: );

Line 5473: WIP_CONSTANTS.RUNNING,

5469: WHERE WRJI.wip_entity_name = p_wip_entity_name
5470: AND WSMTI.organization_id = p_organization_id
5471: AND WSMTI.header_id = WRJI.header_id
5472: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5473: WIP_CONSTANTS.RUNNING,
5474: WIP_CONSTANTS.ERROR)
5475: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5476: );
5477:

Line 5474: WIP_CONSTANTS.ERROR)

5470: AND WSMTI.organization_id = p_organization_id
5471: AND WSMTI.header_id = WRJI.header_id
5472: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5473: WIP_CONSTANTS.RUNNING,
5474: WIP_CONSTANTS.ERROR)
5475: AND WSMTI.transaction_date <= nvl(p_transaction_date,SYSDATE)
5476: );
5477:
5478: EXCEPTION

Line 5536: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then

5532: l_count NUMBER := 0;
5533:
5534: Begin
5535:
5536: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then
5537:
5538: Return FALSE;
5539:
5540: End If;

Line 5554: and wdj.status_type = WIP_CONSTANTS.RELEASED

5550: Where wdj.wip_entity_id = wo.wip_entity_id
5551: and NVL(wo.operation_sequence_id, -99999) =
5552: WSMPUTIL.replacement_op_seq_id (p_operation_sequence_id
5553: , wdj.routing_revision_date)
5554: and wdj.status_type = WIP_CONSTANTS.RELEASED
5555: and (
5556: wo.quantity_in_queue <> 0
5557: OR wo.quantity_running <> 0
5558: OR wo.quantity_waiting_to_move <> 0

Line 5597: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then

5593: l_count NUMBER := 0;
5594:
5595: Begin
5596:
5597: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then
5598:
5599: Return FALSE;
5600:
5601: End If;

Line 5613: and wdj.status_type = WIP_CONSTANTS.RELEASED

5609: from bom_operation_sequences bos
5610: , wip_discrete_jobs wdj
5611: , wip_operations wo
5612: Where wdj.common_routing_sequence_id = p_routing_sequence_id
5613: and wdj.status_type = WIP_CONSTANTS.RELEASED
5614: and bos.routing_sequence_id = wdj.common_routing_sequence_id
5615: and bos.operation_seq_num = p_operation_seq_num
5616: and wdj.routing_revision_date between
5617: bos.effectivity_date and

Line 5653: l_return_value NUMBER := WIP_CONSTANTS.NO;

5649: FUNCTION CREATE_LBJ_COPY_RTG_PROFILE
5650: RETURN NUMBER IS
5651:
5652: l_mfg_org_id varchar2(20);
5653: l_return_value NUMBER := WIP_CONSTANTS.NO;
5654:
5655: BEGIN
5656:
5657: /****************** I M P O R T A N T ********************************/

Line 5680: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then

5676: Select to_number(plan_code) into l_return_value
5677: from wsm_parameters
5678: where organization_id = to_number(l_mfg_org_id);
5679:
5680: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5681: return l_return_value;
5682: Else
5683: return WIP_CONSTANTS.NO;
5684: End If;

Line 5683: return WIP_CONSTANTS.NO;

5679:
5680: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5681: return l_return_value;
5682: Else
5683: return WIP_CONSTANTS.NO;
5684: End If;
5685:
5686: Exception
5687: When Others Then

Line 5688: return WIP_CONSTANTS.NO;

5684: End If;
5685:
5686: Exception
5687: When Others Then
5688: return WIP_CONSTANTS.NO;
5689:
5690: ----------------------------------------------------------------------
5691: ************** UPTO HERE, THE CODE SHOULD BE COMMENTED OUT **********/
5692: ----------------------------------------------------------------------

Line 5708: l_return_value NUMBER := WIP_CONSTANTS.NO;

5704: FUNCTION CREATE_LBJ_COPY_RTG_PROFILE
5705: (p_organization_id IN NUMBER)
5706: RETURN NUMBER IS
5707:
5708: l_return_value NUMBER := WIP_CONSTANTS.NO;
5709: l_plan_code VARCHAR2(30);
5710:
5711: BEGIN
5712:

Line 5732: return WIP_CONSTANTS.NO;

5728: return l_return_value;
5729:
5730: EXCEPTION
5731: WHEN OTHERS THEN
5732: return WIP_CONSTANTS.NO;
5733:
5734: /****************** I M P O R T A N T ********************************/
5735: -- YOU SHOULD UNCOMMENT THE NEXT LINE AFTER FP.J UT/ST ---------------
5736: -- return to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING'));

Line 5747: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then

5743: Select to_number(plan_code) into l_return_value
5744: from wsm_parameters
5745: where organization_id = p_organization_id;
5746:
5747: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5748: return l_return_value;
5749: Else
5750: return WIP_CONSTANTS.NO;
5751: End If;

Line 5750: return WIP_CONSTANTS.NO;

5746:
5747: If l_return_value IN (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO) Then
5748: return l_return_value;
5749: Else
5750: return WIP_CONSTANTS.NO;
5751: End If;
5752:
5753: Exception
5754: When Others Then

Line 5755: return WIP_CONSTANTS.NO;

5751: End If;
5752:
5753: Exception
5754: When Others Then
5755: return WIP_CONSTANTS.NO;
5756:
5757: ----------------------------------------------------------------------
5758: ************** UPTO HERE, THE CODE SHOULD BE COMMENTED OUT ************/
5759: ----------------------------------------------------------------------