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 4076: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))

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

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

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

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

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

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

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

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

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

Line 4616: WIP_CONSTANTS.PO_MOVE);

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

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

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

Line 4680: WIP_CONSTANTS.RUNNING,

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

Line 4681: WIP_CONSTANTS.ERROR)

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

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

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

Line 4705: WIP_CONSTANTS.RUNNING,

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

Line 4706: WIP_CONSTANTS.ERROR)

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

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

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

Line 4818: WIP_CONSTANTS.RUNNING,

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

Line 4819: WIP_CONSTANTS.ERROR)

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

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

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

Line 4843: WIP_CONSTANTS.RUNNING,

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

Line 4844: WIP_CONSTANTS.ERROR)

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

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

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

Line 4976: WIP_CONSTANTS.RUNNING,

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

Line 4977: WIP_CONSTANTS.ERROR)

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

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

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

Line 5002: WIP_CONSTANTS.RUNNING,

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

Line 5003: WIP_CONSTANTS.ERROR)

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

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

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

Line 5039: WIP_CONSTANTS.RUNNING,

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

Line 5040: WIP_CONSTANTS.ERROR)

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

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

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

Line 5064: WIP_CONSTANTS.RUNNING,

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

Line 5065: WIP_CONSTANTS.ERROR)

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

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

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

Line 5108: WIP_CONSTANTS.RUNNING,

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

Line 5109: WIP_CONSTANTS.ERROR)

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

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

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

Line 5136: WIP_CONSTANTS.RUNNING,

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

Line 5137: WIP_CONSTANTS.ERROR)

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

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

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

Line 5365: WIP_CONSTANTS.RUNNING,

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

Line 5366: WIP_CONSTANTS.ERROR)

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

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

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

Line 5403: WIP_CONSTANTS.RUNNING,

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

Line 5404: WIP_CONSTANTS.ERROR)

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

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

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

Line 5439: WIP_CONSTANTS.RUNNING,

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

Line 5440: WIP_CONSTANTS.ERROR)

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

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

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

Line 5470: WIP_CONSTANTS.RUNNING,

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

Line 5471: WIP_CONSTANTS.ERROR)

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

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

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

Line 5551: and wdj.status_type = WIP_CONSTANTS.RELEASED

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

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

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

Line 5610: and wdj.status_type = WIP_CONSTANTS.RELEASED

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

Line 5650: l_return_value NUMBER := WIP_CONSTANTS.NO;

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

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

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

Line 5680: return WIP_CONSTANTS.NO;

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

Line 5685: return WIP_CONSTANTS.NO;

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

Line 5705: l_return_value NUMBER := WIP_CONSTANTS.NO;

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

Line 5729: return WIP_CONSTANTS.NO;

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

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

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

Line 5747: return WIP_CONSTANTS.NO;

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

Line 5752: return WIP_CONSTANTS.NO;

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