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_RES_INST_VALIDATIONS dependencies on WIP_JOB_DETAILS

Line 22: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

18: WHERE group_id = p_group_id
19: AND process_status = WIP_CONSTANTS.ERROR
20: AND wip_entity_id = p_wip_entity_id
21: AND organization_id = p_organization_id
22: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
23: AND substitution_type= p_substitution_type
24: AND operation_seq_num= p_operation_seq_num
25: AND resource_seq_num = p_resource_seq_num;
26:

Line 53: and wjdi.load_type = wip_job_details.wip_res_instance

49: and wjdi.process_status in (wip_constants.running,
50: wip_constants.warning)
51: and wjdi.wip_entity_id = p_wip_entity_id
52: and wjdi.organization_id = p_organization_id
53: and wjdi.load_type = wip_job_details.wip_res_instance
54: and wjdi.substitution_type = p_substitution_type
55: and wjdi.operation_seq_num = p_operation_seq_num
56: and wjdi.resource_seq_num = p_resource_seq_num /* fix for bug4238691 */
57: and wjdi.substitution_type in

Line 58: (wip_job_details.wip_add, wip_job_details.wip_change)

54: and wjdi.substitution_type = p_substitution_type
55: and wjdi.operation_seq_num = p_operation_seq_num
56: and wjdi.resource_seq_num = p_resource_seq_num /* fix for bug4238691 */
57: and wjdi.substitution_type in
58: (wip_job_details.wip_add, wip_job_details.wip_change)
59: and (wjdi.start_date > wjdi.completion_date
60: or exists
61: (select 1
62: from wip_operation_resources wor

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

80: for l_inv_row in c_invalid_rows loop
81: l_error_exists := true;
82: fnd_message.set_name('WIP', 'WIP_JDI_RI_INVALID_DATES');
83: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
84: if(wip_job_details.std_alone = 1) then
85: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
86: p_text => substr(fnd_message.get,1,500),
87: p_error_type => wip_jdi_utils.msg_error);
88: else

Line 104: and wjdi.load_type = wip_job_details.wip_res_instance

100: and wjdi.process_status in (wip_constants.running,
101: wip_constants.warning)
102: and wjdi.wip_entity_id = p_wip_entity_id
103: and wjdi.organization_id = p_organization_id
104: and wjdi.load_type = wip_job_details.wip_res_instance
105: and wjdi.substitution_type = p_substitution_type
106: and wjdi.operation_seq_num = p_operation_seq_num
107: and wjdi.substitution_type in
108: (wip_job_details.wip_add, wip_job_details.wip_change)

Line 108: (wip_job_details.wip_add, wip_job_details.wip_change)

104: and wjdi.load_type = wip_job_details.wip_res_instance
105: and wjdi.substitution_type = p_substitution_type
106: and wjdi.operation_seq_num = p_operation_seq_num
107: and wjdi.substitution_type in
108: (wip_job_details.wip_add, wip_job_details.wip_change)
109: and (wjdi.start_date > wjdi.completion_date
110: or exists
111: (select 1
112: from wip_operation_resources wor

Line 151: and wjdi.load_type = wip_job_details.wip_res_instance

147: and wjdi.process_status in (wip_constants.running,
148: wip_constants.warning)
149: and wjdi.wip_entity_id = p_wip_entity_id
150: and wjdi.organization_id = p_organization_id
151: and wjdi.load_type = wip_job_details.wip_res_instance
152: and wjdi.substitution_type = p_substitution_type
153: and wjdi.operation_seq_num = p_operation_seq_num
154: and wjdi.resource_seq_num = p_resource_seq_num
155: and wjdi.resource_instance_id = p_resource_instance_id

Line 157: or (wjdi.substitution_type <> wip_job_details.wip_delete

153: and wjdi.operation_seq_num = p_operation_seq_num
154: and wjdi.resource_seq_num = p_resource_seq_num
155: and wjdi.resource_instance_id = p_resource_instance_id
156: and ( wjdi.resource_seq_num is null
157: or (wjdi.substitution_type <> wip_job_details.wip_delete
158: and wjdi.resource_instance_id is null)
159: or (wjdi.substitution_type = wip_job_details.wip_add
160: and wjdi.resource_serial_number is null
161: and p_resource_type = 1 ));

Line 159: or (wjdi.substitution_type = wip_job_details.wip_add

155: and wjdi.resource_instance_id = p_resource_instance_id
156: and ( wjdi.resource_seq_num is null
157: or (wjdi.substitution_type <> wip_job_details.wip_delete
158: and wjdi.resource_instance_id is null)
159: or (wjdi.substitution_type = wip_job_details.wip_add
160: and wjdi.resource_serial_number is null
161: and p_resource_type = 1 ));
162:
163: l_error_exists boolean := false;

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

166: for l_inv_row in c_invalid_rows loop
167: l_error_exists := true;
168: fnd_message.set_name('WIP', 'WIP_JDI_RES_INST_INFO_MISSING');
169: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
170: if(wip_job_details.std_alone = 1) then
171: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
172: p_text => substr(fnd_message.get,1,500),
173: p_error_type => wip_jdi_utils.msg_error);
174: else

Line 190: and wjdi.load_type = wip_job_details.wip_res_instance

186: and wjdi.process_status in (wip_constants.running,
187: wip_constants.warning)
188: and wjdi.wip_entity_id = p_wip_entity_id
189: and wjdi.organization_id = p_organization_id
190: and wjdi.load_type = wip_job_details.wip_res_instance
191: and wjdi.substitution_type = p_substitution_type
192: and wjdi.operation_seq_num = p_operation_seq_num
193: and ( wjdi.resource_seq_num is null
194: or (wjdi.substitution_type <> wip_job_details.wip_delete

Line 194: or (wjdi.substitution_type <> wip_job_details.wip_delete

190: and wjdi.load_type = wip_job_details.wip_res_instance
191: and wjdi.substitution_type = p_substitution_type
192: and wjdi.operation_seq_num = p_operation_seq_num
193: and ( wjdi.resource_seq_num is null
194: or (wjdi.substitution_type <> wip_job_details.wip_delete
195: and wjdi.resource_instance_id is null)
196: or (wjdi.substitution_type = wip_job_details.wip_add
197: and wjdi.resource_serial_number is null
198: and p_resource_type = 1 ));

Line 196: or (wjdi.substitution_type = wip_job_details.wip_add

192: and wjdi.operation_seq_num = p_operation_seq_num
193: and ( wjdi.resource_seq_num is null
194: or (wjdi.substitution_type <> wip_job_details.wip_delete
195: and wjdi.resource_instance_id is null)
196: or (wjdi.substitution_type = wip_job_details.wip_add
197: and wjdi.resource_serial_number is null
198: and p_resource_type = 1 ));
199: end if;
200: end resinst_info_exist;

Line 220: and wjdi.load_type = wip_job_details.wip_res_instance

216: and wjdi.process_status in (wip_constants.running,
217: wip_constants.warning)
218: and wjdi.wip_entity_id = p_wip_entity_id
219: and wjdi.organization_id = p_organization_id
220: and wjdi.load_type = wip_job_details.wip_res_instance
221: and wjdi.substitution_type = p_substitution_type
222: and wjdi.operation_seq_num = p_operation_seq_num
223: and wjdi.resource_seq_num = p_resource_seq_num
224: and wjdi.resource_instance_id = p_resource_instance_id

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

253: for l_inv_row in c_invalid_rows(l_dept_id, l_resource_id) loop
254: l_error_exists := true;
255: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RES_INST_ID');
256: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
257: if(wip_job_details.std_alone = 1) then
258: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
259: p_text => substr(fnd_message.get,1,500),
260: p_error_type => wip_jdi_utils.msg_error);
261: else

Line 276: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)

272: and wjdi.process_status in (wip_constants.running,
273: wip_constants.warning)
274: and wjdi.wip_entity_id = p_wip_entity_id
275: and wjdi.organization_id = p_organization_id
276: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)
277: and wjdi.substitution_type = p_substitution_type
278: and wjdi.operation_seq_num = p_operation_seq_num
279: and wjdi.resource_seq_num = p_resource_seq_num
280: and wjdi.resource_instance_id = p_resource_instance_id

Line 312: and wjdi.load_type = wip_job_details.wip_res_instance

308: and wjdi.process_status in (wip_constants.running,
309: wip_constants.warning)
310: and wjdi.wip_entity_id = p_wip_entity_id
311: and wjdi.organization_id = p_organization_id
312: and wjdi.load_type = wip_job_details.wip_res_instance
313: and wjdi.substitution_type = p_substitution_type
314: and wjdi.operation_seq_num = p_operation_seq_num
315: and wjdi.resource_seq_num = p_resource_seq_num
316: and wjdi.resource_instance_id = p_resource_instance_id

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

356: for l_inv_row in c_invalid_rows(l_dept_id, l_resource_id) loop
357: l_error_exists := true;
358: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_INST_SERIAL');
359: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
360: if(wip_job_details.std_alone = 1) then
361: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
362: p_text => substr(fnd_message.get,1,500),
363: p_error_type => wip_jdi_utils.msg_error);
364: else

Line 380: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)

376: and wjdi.process_status in (wip_constants.running,
377: wip_constants.warning)
378: and wjdi.wip_entity_id = p_wip_entity_id
379: and wjdi.organization_id = p_organization_id
380: and wjdi.load_type in (wip_job_details.wip_res_instance, wjdi.load_type)
381: and wjdi.substitution_type = p_substitution_type
382: and wjdi.operation_seq_num = p_operation_seq_num
383: and wjdi.resource_seq_num = p_resource_seq_num
384: and wjdi.resource_instance_id = p_resource_instance_id

Line 430: and wjdi.load_type = wip_job_details.wip_res_instance

426: and wjdi.process_status in (wip_constants.running,
427: wip_constants.warning)
428: and wjdi.wip_entity_id = p_wip_entity_id
429: and wjdi.organization_id = p_organization_id
430: and wjdi.load_type = wip_job_details.wip_res_instance
431: and wjdi.substitution_type = wip_job_details.wip_add
432: and wjdi.operation_seq_num = p_operation_seq_num
433: and wjdi.resource_seq_num = p_resource_seq_num
434: and p_count <> p_assigned_units;

Line 431: and wjdi.substitution_type = wip_job_details.wip_add

427: wip_constants.warning)
428: and wjdi.wip_entity_id = p_wip_entity_id
429: and wjdi.organization_id = p_organization_id
430: and wjdi.load_type = wip_job_details.wip_res_instance
431: and wjdi.substitution_type = wip_job_details.wip_add
432: and wjdi.operation_seq_num = p_operation_seq_num
433: and wjdi.resource_seq_num = p_resource_seq_num
434: and p_count <> p_assigned_units;
435:

Line 514: and load_type = wip_job_details.wip_res_instance

510: from wip_job_dtls_interface
511: where group_id = p_group_id
512: and wip_entity_id = p_wip_entity_id
513: and organization_id = p_organization_id
514: and load_type = wip_job_details.wip_res_instance
515: and substitution_type = wip_job_details.wip_add
516: and operation_seq_num = p_operation_seq_num
517: and resource_seq_num = p_resource_seq_num;
518: Exception when no_data_found then

Line 515: and substitution_type = wip_job_details.wip_add

511: where group_id = p_group_id
512: and wip_entity_id = p_wip_entity_id
513: and organization_id = p_organization_id
514: and load_type = wip_job_details.wip_res_instance
515: and substitution_type = wip_job_details.wip_add
516: and operation_seq_num = p_operation_seq_num
517: and resource_seq_num = p_resource_seq_num;
518: Exception when no_data_found then
519: l_add_count := 0;

Line 529: and load_type = wip_job_details.wip_res_instance

525: from wip_job_dtls_interface
526: where group_id = p_group_id
527: and wip_entity_id = p_wip_entity_id
528: and organization_id = p_organization_id
529: and load_type = wip_job_details.wip_res_instance
530: and substitution_type = wip_job_details.wip_delete
531: and operation_seq_num = p_operation_seq_num
532: and resource_seq_num = p_resource_seq_num;
533: Exception when no_data_found then

Line 530: and substitution_type = wip_job_details.wip_delete

526: where group_id = p_group_id
527: and wip_entity_id = p_wip_entity_id
528: and organization_id = p_organization_id
529: and load_type = wip_job_details.wip_res_instance
530: and substitution_type = wip_job_details.wip_delete
531: and operation_seq_num = p_operation_seq_num
532: and resource_seq_num = p_resource_seq_num;
533: Exception when no_data_found then
534: l_del_count := 0;

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

546:
547: for l_inv_row in c_invalid_rows(l_count, l_assigned_units) loop
548: l_error_exists := true;
549: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_ERROR');
550: if(wip_job_details.std_alone = 1) then
551: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
552: p_text => to_char(l_inv_row.interface_id)
553: || ':' || substr(fnd_message.get,1,500),
554: p_error_type => wip_jdi_utils.msg_error);

Line 571: and wjdi.load_type = wip_job_details.wip_res_instance

567: and wjdi.process_status in (wip_constants.running,
568: wip_constants.warning)
569: and wjdi.wip_entity_id = p_wip_entity_id
570: and wjdi.organization_id = p_organization_id
571: and wjdi.load_type = wip_job_details.wip_res_instance
572: and wjdi.substitution_type = wip_job_details.wip_add
573: and wjdi.operation_seq_num = p_operation_seq_num
574: and wjdi.resource_seq_num = p_resource_seq_num
575: and l_count <> l_assigned_units;

Line 572: and wjdi.substitution_type = wip_job_details.wip_add

568: wip_constants.warning)
569: and wjdi.wip_entity_id = p_wip_entity_id
570: and wjdi.organization_id = p_organization_id
571: and wjdi.load_type = wip_job_details.wip_res_instance
572: and wjdi.substitution_type = wip_job_details.wip_add
573: and wjdi.operation_seq_num = p_operation_seq_num
574: and wjdi.resource_seq_num = p_resource_seq_num
575: and l_count <> l_assigned_units;
576: end if;

Line 613: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

609: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
610: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
611: AND wip_entity_id = p_wip_entity_id
612: AND organization_id = p_organization_id
613: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
614: AND substitution_type = p_substitution_type;
615:
616: l_resource_type number;
617: l_return_status varchar2(100);

Line 767: and wjdi.load_type = wip_job_details.wip_res_instance

763: and wjdi.process_status in (wip_constants.running,
764: wip_constants.warning)
765: and wjdi.wip_entity_id = p_wip_entity_id
766: and wjdi.organization_id = p_organization_id
767: and wjdi.load_type = wip_job_details.wip_res_instance
768: and wjdi.substitution_type = p_substitution_type
769: and wjdi.operation_seq_num = p_operation_seq_num
770: and wjdi.resource_seq_num = p_resource_seq_num
771: and wjdi.resource_instance_id= p_instance_id

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

784: for l_inv_row in c_invalid_rows loop
785: l_error_exists := true;
786: fnd_message.set_name('WIP', 'WIP_JDI_RES_INST_NOT_IN_JOB');
787: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
788: if(wip_job_details.std_alone = 1) then
789: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
790: p_text => substr(fnd_message.get,1,500),
791: p_error_type => wip_jdi_utils.msg_error);
792: else

Line 808: and wjdi.load_type in (wip_job_details.wip_res_instance)

804: and process_status in (wip_constants.running,
805: wip_constants.warning)
806: and wip_entity_id = p_wip_entity_id
807: and organization_id = p_organization_id
808: and wjdi.load_type in (wip_job_details.wip_res_instance)
809: and wjdi.substitution_type = p_substitution_type
810: and wjdi.operation_seq_num = p_operation_seq_num
811: and wjdi.resource_seq_num = p_resource_seq_num
812: and wjdi.resource_instance_id= p_instance_id

Line 859: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

855: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
856: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
857: AND wip_entity_id = p_wip_entity_id
858: AND organization_id = p_organization_id
859: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
860: AND substitution_type = p_substitution_type;
861:
862: l_resource_type number;
863:

Line 990: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE

986: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
987: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
988: AND wip_entity_id = p_wip_entity_id
989: AND organization_id = p_organization_id
990: AND load_type = WIP_JOB_DETAILS.WIP_RES_INSTANCE
991: AND substitution_type = p_substitution_type;
992:
993: BEGIN
994: