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.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_JOB_DETAILS

Line 20: and wjdi.load_type = wip_job_details.wip_mtl_requirement

16: and wjdi.process_status in (wip_constants.running,
17: wip_constants.warning)
18: and wjdi.wip_entity_id = p_wip_entity_id
19: and wjdi.organization_id = p_organization_id
20: and wjdi.load_type = wip_job_details.wip_mtl_requirement
21: and wjdi.substitution_type = p_substitution_type
22: and wjdi.operation_seq_num = p_operation_seq_num
23: and wjdi.inventory_item_id_old is null;
24:

Line 32: if(wip_job_details.std_alone = 1) then

28: for l_inv_row in c_invalid_rows loop
29: l_error_exists := true;
30: fnd_message.set_name('WIP', 'WIP_JDI_DEL_REQ_INFO_MISSING');
31: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
32: if(wip_job_details.std_alone = 1) then
33: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
34: p_text => substr(fnd_message.get,1,500),
35: p_error_type => wip_jdi_utils.msg_error);
36: else

Line 52: and wjdi.load_type = wip_job_details.wip_mtl_requirement

48: and process_status in (wip_constants.running,
49: wip_constants.warning)
50: and wip_entity_id = p_wip_entity_id
51: and organization_id = p_organization_id
52: and wjdi.load_type = wip_job_details.wip_mtl_requirement
53: and wjdi.substitution_type = p_substitution_type
54: and wjdi.operation_seq_num = p_operation_seq_num
55: and wjdi.inventory_item_id_old is null;
56: end if;

Line 85: and wjdi.load_type = wip_job_details.wip_mtl_requirement

81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
83: and wjdi.wip_entity_id = p_wip_entity_id
84: and wjdi.organization_id = p_organization_id
85: and wjdi.load_type = wip_job_details.wip_mtl_requirement
86: and wjdi.substitution_type = p_substitution_type
87: and wjdi.operation_seq_num = p_operation_seq_num
88: and wjdi.inventory_item_id_old = p_inventory_item_id_old
89: and wjdi.wip_entity_id = we.wip_entity_id

Line 112: if(wip_job_details.std_alone = 1) then

108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_id));
109: fnd_message.set_token('OPERATION', to_char(l_inv_row.operation_seq_num));
110: fnd_message.set_token('ITEM', l_inv_row.item_name);
111: fnd_message.set_token('ITEMID', to_char(l_inv_row.inventory_item_id_old));
112: if(wip_job_details.std_alone = 1) then
113: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
114: p_text => substr(fnd_message.get,1,500),
115: p_error_type => wip_jdi_utils.msg_error);
116: else

Line 132: and wjdi.load_type = wip_job_details.wip_mtl_requirement

128: and process_status in (wip_constants.running,
129: wip_constants.warning)
130: and wip_entity_id = p_wip_entity_id
131: and organization_id = p_organization_id
132: and wjdi.load_type = wip_job_details.wip_mtl_requirement
133: and wjdi.substitution_type = p_substitution_type
134: and wjdi.operation_seq_num = p_operation_seq_num
135: and wjdi.inventory_item_id_old = p_inventory_item_id_old
136: and not exists (select 1

Line 165: and wjdi.load_type = wip_job_details.wip_mtl_requirement

161: and wjdi.process_status in (wip_constants.running,
162: wip_constants.warning)
163: and wjdi.wip_entity_id = p_wip_entity_id
164: and wjdi.organization_id = p_organization_id
165: and wjdi.load_type = wip_job_details.wip_mtl_requirement
166: and wjdi.substitution_type = p_substitution_type
167: and wjdi.operation_seq_num = p_operation_seq_num
168: and wjdi.inventory_item_id_old = p_inventory_item_id_old
169: and exists (select 1

Line 186: and wjdi.load_type = wip_job_details.wip_mtl_requirement

182: and wjdi.process_status in (wip_constants.running,
183: wip_constants.warning)
184: and wjdi.wip_entity_id = p_wip_entity_id
185: and wjdi.organization_id = p_organization_id
186: and wjdi.load_type = wip_job_details.wip_mtl_requirement
187: and wjdi.substitution_type = p_substitution_type
188: and wjdi.operation_seq_num = p_operation_seq_num
189: and wjdi.inventory_item_id_old = p_inventory_item_id_old
190: and exists (select 1

Line 206: and wjdi.load_type = wip_job_details.wip_mtl_requirement

202: and wjdi.process_status in (wip_constants.running,
203: wip_constants.warning)
204: and wjdi.wip_entity_id = p_wip_entity_id
205: and wjdi.organization_id = p_organization_id
206: and wjdi.load_type = wip_job_details.wip_mtl_requirement
207: and wjdi.substitution_type = p_substitution_type
208: and wjdi.operation_seq_num = p_operation_seq_num
209: and wjdi.inventory_item_id_old = p_inventory_item_id_old
210: and exists (select 1

Line 224: if(wip_job_details.std_alone = 1) then

220: for l_inv_row in c_invalid_wro_rows loop
221: l_error_exists := true;
222: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
223: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
224: if(wip_job_details.std_alone = 1) then
225: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
226: p_text => substr(fnd_message.get,1,500),
227: p_error_type => wip_jdi_utils.msg_error);
228: else

Line 244: and wjdi.load_type = wip_job_details.wip_mtl_requirement

240: and process_status in (wip_constants.running,
241: wip_constants.warning)
242: and wip_entity_id = p_wip_entity_id
243: and organization_id = p_organization_id
244: and wjdi.load_type = wip_job_details.wip_mtl_requirement
245: and wjdi.substitution_type = p_substitution_type
246: and wjdi.operation_seq_num = p_operation_seq_num
247: and wjdi.inventory_item_id_old = p_inventory_item_id_old
248: and exists (select 1

Line 262: if(wip_job_details.std_alone = 1) then

258: for l_inv_row in c_invalid_mmtt_rows loop
259: l_error_exists := true;
260: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
261: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
262: if(wip_job_details.std_alone = 1) then
263: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
264: p_text => substr(fnd_message.get,1,500),
265: p_error_type => wip_jdi_utils.msg_error);
266: else

Line 282: and wjdi.load_type = wip_job_details.wip_mtl_requirement

278: and process_status in (wip_constants.running,
279: wip_constants.warning)
280: and wip_entity_id = p_wip_entity_id
281: and organization_id = p_organization_id
282: and wjdi.load_type = wip_job_details.wip_mtl_requirement
283: and wjdi.substitution_type = p_substitution_type
284: and wjdi.operation_seq_num = p_operation_seq_num
285: and wjdi.inventory_item_id_old = p_inventory_item_id_old
286: and exists (select 1

Line 299: if(wip_job_details.std_alone = 1) then

295: for l_inv_row in c_invalid_mmt_rows loop
296: l_error_exists := true;
297: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
298: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
299: if(wip_job_details.std_alone = 1) then
300: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
301: p_text => substr(fnd_message.get,1,500),
302: p_error_type => wip_jdi_utils.msg_error);
303: else

Line 319: and wjdi.load_type = wip_job_details.wip_mtl_requirement

315: and process_status in (wip_constants.running,
316: wip_constants.warning)
317: and wip_entity_id = p_wip_entity_id
318: and organization_id = p_organization_id
319: and wjdi.load_type = wip_job_details.wip_mtl_requirement
320: and wjdi.substitution_type = p_substitution_type
321: and wjdi.operation_seq_num = p_operation_seq_num
322: and wjdi.inventory_item_id_old = p_inventory_item_id_old
323: and exists (select 1

Line 363: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

359: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
360: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
361: AND wip_entity_id = p_wip_entity_id
362: AND organization_id = p_organization_id
363: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
364: AND substitution_type = p_substitution_type;
365:
366: BEGIN
367: FOR cur_row IN req_info(p_group_id,

Line 425: and wjdi.load_type = wip_job_details.wip_mtl_requirement

421: and wjdi.process_status in (wip_constants.running,
422: wip_constants.warning)
423: and wjdi.wip_entity_id = p_wip_entity_id
424: and wjdi.organization_id = p_organization_id
425: and wjdi.load_type = wip_job_details.wip_mtl_requirement
426: and wjdi.substitution_type = p_substitution_type
427: and wjdi.operation_seq_num = p_operation_seq_num
428: and ( wjdi.inventory_item_id_new is null
429: or wjdi.quantity_per_assembly is null);

Line 438: if(wip_job_details.std_alone = 1) then

434: for l_inv_row in c_invalid_rows loop
435: l_error_exists := true;
436: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
437: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
438: if(wip_job_details.std_alone = 1) then
439: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
440: p_text => substr(fnd_message.get,1,500),
441: p_error_type => wip_jdi_utils.msg_error);
442: else

Line 458: and wjdi.load_type = wip_job_details.wip_mtl_requirement

454: and process_status in (wip_constants.running,
455: wip_constants.warning)
456: and wip_entity_id = p_wip_entity_id
457: and organization_id = p_organization_id
458: and wjdi.load_type = wip_job_details.wip_mtl_requirement
459: and wjdi.substitution_type = p_substitution_type
460: and wjdi.operation_seq_num = p_operation_seq_num
461: and ( wjdi.inventory_item_id_new is null
462: or wjdi.quantity_per_assembly is null);

Line 485: and wjdi.load_type = wip_job_details.wip_mtl_requirement

481: and wjdi.process_status in (wip_constants.running,
482: wip_constants.warning)
483: and wjdi.wip_entity_id = p_wip_entity_id
484: and wjdi.organization_id = p_organization_id
485: and wjdi.load_type = wip_job_details.wip_mtl_requirement
486: and wjdi.substitution_type = p_substitution_type
487: and wjdi.operation_seq_num = p_operation_seq_num
488: and wjdi.inventory_item_id_new = p_inventory_item_id_new
489: /* bug#2814045 */

Line 514: if(wip_job_details.std_alone = 1) then

510: for l_inv_row in c_invalid_rows loop
511: l_error_exists := true;
512: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
513: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
514: if(wip_job_details.std_alone = 1) then
515: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
516: p_text => substr(fnd_message.get,1,500),
517: p_error_type => wip_jdi_utils.msg_error);
518: else

Line 534: and wjdi.load_type = wip_job_details.wip_mtl_requirement

530: and process_status in (wip_constants.running,
531: wip_constants.warning)
532: and wip_entity_id = p_wip_entity_id
533: and organization_id = p_organization_id
534: and wjdi.load_type = wip_job_details.wip_mtl_requirement
535: and wjdi.substitution_type = p_substitution_type
536: and wjdi.operation_seq_num = p_operation_seq_num
537: and wjdi.inventory_item_id_new = p_inventory_item_id_new
538: /* Fix for Bug 5632150 */

Line 577: and wjdi.load_type = wip_job_details.wip_mtl_requirement

573: and wjdi.process_status in (wip_constants.running,
574: wip_constants.warning)
575: and wjdi.wip_entity_id = p_wip_entity_id
576: and wjdi.organization_id = p_organization_id
577: and wjdi.load_type = wip_job_details.wip_mtl_requirement
578: and wjdi.substitution_type = p_substitution_type
579: and wjdi.operation_seq_num = p_operation_seq_num
580: and wjdi.inventory_item_id_new = p_inventory_item_id_new
581: and not exists (select 1

Line 596: and wjdi.load_type = wip_job_details.wip_mtl_requirement

592: and wjdi.process_status in (wip_constants.running,
593: wip_constants.warning)
594: and wjdi.wip_entity_id = p_wip_entity_id
595: and wjdi.organization_id = p_organization_id
596: and wjdi.load_type = wip_job_details.wip_mtl_requirement
597: and wjdi.substitution_type = p_substitution_type
598: and wjdi.operation_seq_num = p_operation_seq_num
599: and wjdi.inventory_item_id_new = p_inventory_item_id_new
600: and wjdi.parent_header_id = wjsi.header_id

Line 617: and wjdi.load_type = wip_job_details.wip_mtl_requirement

613: and wjdi.process_status in (wip_constants.running,
614: wip_constants.warning)
615: and wjdi.wip_entity_id = p_wip_entity_id
616: and wjdi.organization_id = p_organization_id
617: and wjdi.load_type = wip_job_details.wip_mtl_requirement
618: and wjdi.substitution_type = p_substitution_type
619: and wjdi.operation_seq_num = p_operation_seq_num
620: and wjdi.inventory_item_id_new = p_inventory_item_id_new
621: and wjdi.parent_header_id = wjsi.header_id

Line 636: and wjdi.load_type = wip_job_details.wip_mtl_requirement

632: and wjdi.process_status in (wip_constants.running,
633: wip_constants.warning)
634: and wjdi.wip_entity_id = p_wip_entity_id
635: and wjdi.organization_id = p_organization_id
636: and wjdi.load_type = wip_job_details.wip_mtl_requirement
637: and wjdi.substitution_type = p_substitution_type
638: and wjdi.operation_seq_num = p_operation_seq_num
639: and wjdi.inventory_item_id_new = p_inventory_item_id_new
640: and wjdi.parent_header_id = wjsi.header_id

Line 657: and wjdi.load_type = wip_job_details.wip_mtl_requirement

653: and wjdi.process_status in ( wip_constants.running,
654: wip_constants.warning )
655: and wjdi.wip_entity_id = p_wip_entity_id
656: and wjdi.organization_id = p_organization_id
657: and wjdi.load_type = wip_job_details.wip_mtl_requirement
658: and wjdi.substitution_type = p_substitution_type
659: and wjdi.operation_seq_num = p_operation_seq_num
660: and wjdi.inventory_item_id_new = p_inventory_item_id_new
661: and NOT exists ( select 1 from mtl_system_items msi

Line 679: if(wip_job_details.std_alone = 1) then

675: for l_inv_row in c_invalid_rows loop
676: l_error_exists := true;
677: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
678: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
679: if(wip_job_details.std_alone = 1) then
680: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
681: p_text => substr(fnd_message.get,1,500),
682: p_error_type => wip_jdi_utils.msg_error);
683: else

Line 695: if(wip_job_details.std_alone = 1) then

691: for l_inv_row in c_supply_types_invalid_rows loop
692: l_error_exists := true;
693: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
694: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
695: if(wip_job_details.std_alone = 1) then
696: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
697: p_text => substr(fnd_message.get,1,500),
698: p_error_type => wip_jdi_utils.msg_error);
699: else

Line 710: if(wip_job_details.std_alone = 1) then

706: for l_inv_row in c_mrp_net_flag_invalid_rows loop
707: l_error_exists := true;
708: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
709: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
710: if(wip_job_details.std_alone = 1) then
711: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
712: p_text => substr(fnd_message.get,1,500),
713: p_error_type => wip_jdi_utils.msg_error);
714: else

Line 725: if(wip_job_details.std_alone = 1) then

721: for l_inv_row in c_auto_req_mat_invalid_rows loop
722: l_error_exists := true;
723: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
724: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
725: if(wip_job_details.std_alone = 1) then
726: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
727: p_text => substr(fnd_message.get,1,500),
728: p_error_type => wip_jdi_utils.msg_error);
729: else

Line 742: if(wip_job_details.std_alone =1 ) then

738: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
739: l_error_exists := true ;
740: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');
741: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
742: if(wip_job_details.std_alone =1 ) then
743: wip_interface_err_utils.add_error (
744: p_interface_id => l_inv_row.interface_id,
745: p_text => substr(fnd_message.get,1,500),
746: p_error_type => wip_jdi_utils.msg_error);

Line 764: and wjdi.load_type = wip_job_details.wip_mtl_requirement

760: and process_status in (wip_constants.running,
761: wip_constants.warning)
762: and wip_entity_id = p_wip_entity_id
763: and organization_id = p_organization_id
764: and wjdi.load_type = wip_job_details.wip_mtl_requirement
765: and wjdi.substitution_type = p_substitution_type
766: and wjdi.operation_seq_num = p_operation_seq_num
767: and wjdi.inventory_item_id_new = p_inventory_item_id_new;
768: /* bug#2811687

Line 803: and wjdi.load_type = wip_job_details.wip_mtl_requirement

799: and wjdi.process_status in (wip_constants.running,
800: wip_constants.warning)
801: and wjdi.wip_entity_id = p_wip_entity_id
802: and wjdi.organization_id = p_organization_id
803: and wjdi.load_type = wip_job_details.wip_mtl_requirement
804: and wjdi.substitution_type = p_substitution_type
805: and wjdi.operation_seq_num = p_operation_seq_num
806: and (wjdi.inventory_item_id_new = p_inventory_item_id_new
807: or p_inventory_item_id_new is null)

Line 813: WIP_JOB_DETAILS.STD_ALONE = 1)*/

809: or p_inventory_item_id_old is null)
810: and (p_inventory_item_id_old is not null or
811: p_inventory_item_id_new is not null)
812: /*and (wjdi.parent_header_id = p_parent_header_id or
813: WIP_JOB_DETAILS.STD_ALONE = 1)*/
814: /*and wjdi.organization_id = wjsi.organization_id
815: and wjdi.wip_entity_id = wjsi.wip_entity_id*/
816: and wjdi.wip_supply_type = wip_constants.op_pull
817: and not exists

Line 830: if(wip_job_details.std_alone = 1) then

826: for l_inv_row in c_supply_types_invalid_rows loop
827: l_error_exists := true;
828: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
829: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
830: if(wip_job_details.std_alone = 1) then
831: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
832: p_text => substr(fnd_message.get,1,500),
833: p_error_type => wip_jdi_utils.msg_error);
834: else

Line 861: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

857: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
858: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
859: AND wip_entity_id = p_wip_entity_id
860: AND organization_id = p_organization_id
861: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
862: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
863: AND supply_subinventory is not null;
864: CURSOR changesubinv_check IS
865: SELECT wjdi.interface_id,NVL(wjdi.inventory_item_id_new,wjdi.inventory_item_id_old) inventory_item_id,Decode(NVL(wjdi.wip_supply_type, wro.wip_supply_type),

Line 862: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

858: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
859: AND wip_entity_id = p_wip_entity_id
860: AND organization_id = p_organization_id
861: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
862: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
863: AND supply_subinventory is not null;
864: CURSOR changesubinv_check IS
865: SELECT wjdi.interface_id,NVL(wjdi.inventory_item_id_new,wjdi.inventory_item_id_old) inventory_item_id,Decode(NVL(wjdi.wip_supply_type, wro.wip_supply_type),
866: 2, Decode(wjdi.supply_subinventory,

Line 908: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

904: AND wro.wip_entity_id=wjdi.wip_entity_id
905: AND wro.operation_seq_num=wjdi.operation_seq_num
906: AND wro.inventory_item_id=wjdi.inventory_item_id_old
907: AND wjdi.organization_id = p_organization_id
908: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
909: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
910: l_msg VARCHAR2(100);
911: l_inventory_itemid NUMBER;
912: rec changesubinv_check%ROWTYPE;

Line 909: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;

905: AND wro.operation_seq_num=wjdi.operation_seq_num
906: AND wro.inventory_item_id=wjdi.inventory_item_id_old
907: AND wjdi.organization_id = p_organization_id
908: AND wjdi.load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
909: AND wjdi.substitution_type = WIP_JOB_DETAILS.WIP_CHANGE;
910: l_msg VARCHAR2(100);
911: l_inventory_itemid NUMBER;
912: rec changesubinv_check%ROWTYPE;
913: TYPE errorrec is RECORD ( interface_id NUMBER,

Line 937: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN

933: l_dummy2 VARCHAR2(1);
934: l_projectLocID number;
935: l_indx NUMBER:=1;
936: BEGIN
937: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN
938: OPEN addsubinv_check;
939: ELSE
940: OPEN changesubinv_check;
941: END IF;

Line 944: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN

940: OPEN changesubinv_check;
941: END IF;
942:
943: Loop
944: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN
945: FETCH addsubinv_check into REC;
946: EXIT WHEN addsubinv_check%NOTFOUND;
947: ELSE
948: FETCH changesubinv_check into REC;

Line 1060: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN

1056:
1057: end loop;
1058: END IF;
1059:
1060: IF p_substitution_type= WIP_JOB_DETAILS.WIP_ADD THEN
1061: close addsubinv_check;
1062: ELSE
1063: close changesubinv_check;
1064: END IF;

Line 1102: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1098: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1099: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1100: AND wip_entity_id = p_wip_entity_id
1101: AND organization_id = p_organization_id
1102: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1103: AND substitution_type = p_substitution_type;
1104:
1105: BEGIN
1106: FOR cur_row IN req_info(p_group_id,

Line 1220: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1216: and wjdi.process_status in (wip_constants.running,
1217: wip_constants.warning)
1218: and wjdi.wip_entity_id = p_wip_entity_id
1219: and wjdi.organization_id = p_organization_id
1220: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1221: and wjdi.substitution_type = p_substitution_type
1222: and wjdi.operation_seq_num = p_operation_seq_num
1223: and wjdi.inventory_item_id_new = p_inventory_item_id_new
1224: and wjdi.wip_supply_type is null;

Line 1236: if(wip_job_details.std_alone = 1) then

1232: for l_inv_row in c_invalid_rows loop
1233: l_error_exists := true;
1234: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
1235: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1236: if(wip_job_details.std_alone = 1) then
1237: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1238: p_text => substr(fnd_message.get,1,500),
1239: p_error_type => wip_jdi_utils.msg_error);
1240: else

Line 1256: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1252: and process_status in (wip_constants.running,
1253: wip_constants.warning)
1254: and wip_entity_id = p_wip_entity_id
1255: and organization_id = p_organization_id
1256: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1257: and wjdi.substitution_type = p_substitution_type
1258: and wjdi.operation_seq_num = p_operation_seq_num
1259: and wjdi.inventory_item_id_new = p_inventory_item_id_new
1260: and wjdi.wip_supply_type is null;

Line 1280: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1276: and wjdi.process_status in (wip_constants.running,
1277: wip_constants.warning)
1278: and wjdi.wip_entity_id = p_wip_entity_id
1279: and wjdi.organization_id = p_organization_id
1280: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1281: and wjdi.substitution_type = p_substitution_type
1282: and wjdi.operation_seq_num = p_operation_seq_num
1283: and ( wjdi.inventory_item_id_old is null
1284: or (wjdi.inventory_item_id_old <> nvl(wjdi.inventory_item_id_new, wjdi.inventory_item_id_old)

Line 1313: if(wip_job_details.std_alone = 1) then

1309: for l_inv_row in c_invalid_rows loop
1310: l_error_exists := true;
1311: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
1312: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1313: if(wip_job_details.std_alone = 1) then
1314: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1315: p_text => substr(fnd_message.get,1,500),
1316: p_error_type => wip_jdi_utils.msg_error);
1317: else

Line 1333: and wjdi.load_type = wip_job_details.wip_mtl_requirement

1329: and process_status in (wip_constants.running,
1330: wip_constants.warning)
1331: and wip_entity_id = p_wip_entity_id
1332: and organization_id = p_organization_id
1333: and wjdi.load_type = wip_job_details.wip_mtl_requirement
1334: and wjdi.substitution_type = p_substitution_type
1335: and wjdi.operation_seq_num = p_operation_seq_num
1336: and ( wjdi.inventory_item_id_old is null
1337: or ( wjdi.inventory_item_id_old <> nvl(wjdi.inventory_item_id_new, wjdi.inventory_item_id_old)

Line 1478: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1474: /*Component Yield Enhancement(Bug 4369064)*/
1475: WHERE group_id = p_group_id
1476: AND wip_entity_id = p_wip_entity_id
1477: AND organization_id = p_organization_id
1478: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1479: AND substitution_type = p_substitution_type
1480: AND operation_seq_num = p_operation_seq_num
1481: AND inventory_item_id_old = p_inventory_item_id_old;
1482: end if;

Line 1524: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1520: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1521: AND process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1522: AND wip_entity_id = p_wip_entity_id
1523: AND organization_id = p_organization_id
1524: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1525: AND substitution_type = p_substitution_type;
1526:
1527: BEGIN
1528:

Line 1696: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN

1692: x_count number := 0;
1693:
1694: BEGIN
1695:
1696: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1697: SELECT count(*)
1698: INTO x_count
1699: FROM WIP_JOB_DTLS_INTERFACE
1700: WHERE group_id = p_group_id

Line 1704: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1700: WHERE group_id = p_group_id
1701: AND process_status = WIP_CONSTANTS.ERROR
1702: AND wip_entity_id = p_wip_entity_id
1703: AND organization_id = p_organization_id
1704: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1705: AND substitution_type= p_substitution_type
1706: AND operation_seq_num= p_operation_seq_num
1707: AND inventory_item_id_old = p_inventory_item_id_old;
1708:

Line 1709: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

1705: AND substitution_type= p_substitution_type
1706: AND operation_seq_num= p_operation_seq_num
1707: AND inventory_item_id_old = p_inventory_item_id_old;
1708:
1709: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1710: SELECT count(*)
1711: INTO x_count
1712: FROM WIP_JOB_DTLS_INTERFACE
1713: WHERE group_id = p_group_id

Line 1717: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1713: WHERE group_id = p_group_id
1714: AND process_status = WIP_CONSTANTS.ERROR
1715: AND wip_entity_id = p_wip_entity_id
1716: AND organization_id = p_organization_id
1717: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1718: AND substitution_type= p_substitution_type
1719: AND operation_seq_num= p_operation_seq_num
1720: AND inventory_item_id_new = p_inventory_item_id_new;
1721:

Line 1722: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN

1718: AND substitution_type= p_substitution_type
1719: AND operation_seq_num= p_operation_seq_num
1720: AND inventory_item_id_new = p_inventory_item_id_new;
1721:
1722: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1723: SELECT count(*)
1724: INTO x_count
1725: FROM WIP_JOB_DTLS_INTERFACE
1726: WHERE group_id = p_group_id

Line 1730: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1726: WHERE group_id = p_group_id
1727: AND process_status = WIP_CONSTANTS.ERROR
1728: AND wip_entity_id = p_wip_entity_id
1729: AND organization_id = p_organization_id
1730: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1731: AND substitution_type= p_substitution_type
1732: AND operation_seq_num= p_operation_seq_num
1733: AND inventory_item_id_old = p_inventory_item_id_old
1734: AND inventory_item_id_new = p_inventory_item_id_new;

Line 1756: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN

1752: x_count number := 0;
1753:
1754: BEGIN
1755:
1756: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1757: SELECT count(*)
1758: INTO x_count
1759: FROM WIP_JOB_DTLS_INTERFACE
1760: WHERE group_id = p_group_id

Line 1764: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1760: WHERE group_id = p_group_id
1761: AND process_status = WIP_CONSTANTS.ERROR
1762: AND wip_entity_id = p_wip_entity_id
1763: AND organization_id = p_organization_id
1764: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1765: AND substitution_type= p_substitution_type
1766: AND operation_seq_num= p_operation_seq_num
1767: AND inventory_item_id_old IS NULL;
1768:

Line 1769: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

1765: AND substitution_type= p_substitution_type
1766: AND operation_seq_num= p_operation_seq_num
1767: AND inventory_item_id_old IS NULL;
1768:
1769: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
1770: SELECT count(*)
1771: INTO x_count
1772: FROM WIP_JOB_DTLS_INTERFACE
1773: WHERE group_id = p_group_id

Line 1777: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1773: WHERE group_id = p_group_id
1774: AND process_status = WIP_CONSTANTS.ERROR
1775: AND wip_entity_id = p_wip_entity_id
1776: AND organization_id = p_organization_id
1777: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1778: AND substitution_type= p_substitution_type
1779: AND operation_seq_num= p_operation_seq_num
1780: AND (inventory_item_id_new IS NULL
1781: OR quantity_per_assembly IS NULL);

Line 1783: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN

1779: AND operation_seq_num= p_operation_seq_num
1780: AND (inventory_item_id_new IS NULL
1781: OR quantity_per_assembly IS NULL);
1782:
1783: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
1784: SELECT count(*)
1785: INTO x_count
1786: FROM WIP_JOB_DTLS_INTERFACE
1787: WHERE group_id = p_group_id

Line 1791: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

1787: WHERE group_id = p_group_id
1788: AND process_status = WIP_CONSTANTS.ERROR
1789: AND wip_entity_id = p_wip_entity_id
1790: AND organization_id = p_organization_id
1791: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
1792: AND substitution_type= p_substitution_type
1793: AND operation_seq_num= p_operation_seq_num
1794: AND (inventory_item_id_old IS NULL
1795: OR quantity_per_assembly IS NULL);