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

Line 27: and load_type in (wip_job_details.wip_res_usage,

23: and process_status in (wip_constants.running,
24: wip_constants.warning)
25: and wip_entity_id = p_wip_entity_id
26: and organization_id = p_organization_id
27: and load_type in (wip_job_details.wip_res_usage,
28: wip_job_details.wip_res_instance_usage)
29: and substitution_type = wip_job_details.wip_add;
30:
31: l_res_seq number;

Line 28: wip_job_details.wip_res_instance_usage)

24: wip_constants.warning)
25: and wip_entity_id = p_wip_entity_id
26: and organization_id = p_organization_id
27: and load_type in (wip_job_details.wip_res_usage,
28: wip_job_details.wip_res_instance_usage)
29: and substitution_type = wip_job_details.wip_add;
30:
31: l_res_seq number;
32: begin

Line 29: and substitution_type = wip_job_details.wip_add;

25: and wip_entity_id = p_wip_entity_id
26: and organization_id = p_organization_id
27: and load_type in (wip_job_details.wip_res_usage,
28: wip_job_details.wip_res_instance_usage)
29: and substitution_type = wip_job_details.wip_add;
30:
31: l_res_seq number;
32: begin
33: for cur_row in c_usage_rows loop

Line 124: and load_type in (wip_job_details.wip_res_usage,

120: and process_status in (wip_constants.running,
121: wip_constants.warning)
122: and wip_entity_id = p_wip_entity_id
123: and organization_id = p_organization_id
124: and load_type in (wip_job_details.wip_res_usage,
125: wip_job_details.wip_res_instance_usage)
126: and substitution_type = wip_job_details.wip_add
127: and (resource_seq_num is null
128: or (load_type = wip_job_details.wip_res_instance_usage

Line 125: wip_job_details.wip_res_instance_usage)

121: wip_constants.warning)
122: and wip_entity_id = p_wip_entity_id
123: and organization_id = p_organization_id
124: and load_type in (wip_job_details.wip_res_usage,
125: wip_job_details.wip_res_instance_usage)
126: and substitution_type = wip_job_details.wip_add
127: and (resource_seq_num is null
128: or (load_type = wip_job_details.wip_res_instance_usage
129: and resource_instance_id is null));

Line 126: and substitution_type = wip_job_details.wip_add

122: and wip_entity_id = p_wip_entity_id
123: and organization_id = p_organization_id
124: and load_type in (wip_job_details.wip_res_usage,
125: wip_job_details.wip_res_instance_usage)
126: and substitution_type = wip_job_details.wip_add
127: and (resource_seq_num is null
128: or (load_type = wip_job_details.wip_res_instance_usage
129: and resource_instance_id is null));
130: l_error_exists boolean := false;

Line 128: or (load_type = wip_job_details.wip_res_instance_usage

124: and load_type in (wip_job_details.wip_res_usage,
125: wip_job_details.wip_res_instance_usage)
126: and substitution_type = wip_job_details.wip_add
127: and (resource_seq_num is null
128: or (load_type = wip_job_details.wip_res_instance_usage
129: and resource_instance_id is null));
130: l_error_exists boolean := false;
131: begin
132: for l_inv_row in c_invalid_rows loop

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

132: for l_inv_row in c_invalid_rows loop
133: l_error_exists := true;
134: fnd_message.set_name('WIP', 'WIP_NOT_NULL_VAL_LACK');
135: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
136: if(wip_job_details.std_alone = 1) then
137: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);
140: else

Line 156: and load_type in (wip_job_details.wip_res_usage,

152: and process_status in (wip_constants.running,
153: wip_constants.warning)
154: and wip_entity_id = p_wip_entity_id
155: and organization_id = p_organization_id
156: and load_type in (wip_job_details.wip_res_usage,
157: wip_job_details.wip_res_instance_usage)
158: and substitution_type = wip_job_details.wip_add
159: and (resource_seq_num is null
160: or (load_type = wip_job_details.wip_res_instance_usage

Line 157: wip_job_details.wip_res_instance_usage)

153: wip_constants.warning)
154: and wip_entity_id = p_wip_entity_id
155: and organization_id = p_organization_id
156: and load_type in (wip_job_details.wip_res_usage,
157: wip_job_details.wip_res_instance_usage)
158: and substitution_type = wip_job_details.wip_add
159: and (resource_seq_num is null
160: or (load_type = wip_job_details.wip_res_instance_usage
161: and resource_instance_id is null));

Line 158: and substitution_type = wip_job_details.wip_add

154: and wip_entity_id = p_wip_entity_id
155: and organization_id = p_organization_id
156: and load_type in (wip_job_details.wip_res_usage,
157: wip_job_details.wip_res_instance_usage)
158: and substitution_type = wip_job_details.wip_add
159: and (resource_seq_num is null
160: or (load_type = wip_job_details.wip_res_instance_usage
161: and resource_instance_id is null));
162: end if;

Line 160: or (load_type = wip_job_details.wip_res_instance_usage

156: and load_type in (wip_job_details.wip_res_usage,
157: wip_job_details.wip_res_instance_usage)
158: and substitution_type = wip_job_details.wip_add
159: and (resource_seq_num is null
160: or (load_type = wip_job_details.wip_res_instance_usage
161: and resource_instance_id is null));
162: end if;
163: end validate_seq_num;
164:

Line 176: and substitution_type = wip_job_details.wip_add

172: and process_status in (wip_constants.running,
173: wip_constants.warning)
174: and wip_entity_id = p_wip_entity_id
175: and organization_id = p_organization_id
176: and substitution_type = wip_job_details.wip_add
177: and ((load_type = wip_job_details.wip_res_instance_usage
178: and not exists (select 1
179: from wip_op_resource_instances
180: where wip_entity_id = wjdi.wip_entity_id

Line 177: and ((load_type = wip_job_details.wip_res_instance_usage

173: wip_constants.warning)
174: and wip_entity_id = p_wip_entity_id
175: and organization_id = p_organization_id
176: and substitution_type = wip_job_details.wip_add
177: and ((load_type = wip_job_details.wip_res_instance_usage
178: and not exists (select 1
179: from wip_op_resource_instances
180: where wip_entity_id = wjdi.wip_entity_id
181: and organization_id = wjdi.organization_id

Line 185: or (load_type = wip_job_details.wip_res_usage

181: and organization_id = wjdi.organization_id
182: and operation_seq_num = wjdi.operation_seq_num
183: and resource_seq_num = wjdi.resource_seq_num
184: and instance_id = wjdi.resource_instance_id))
185: or (load_type = wip_job_details.wip_res_usage
186: and not exists (select 1
187: from wip_operation_resources
188: where wip_entity_id = wjdi.wip_entity_id
189: and organization_id = wjdi.organization_id

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

194: for l_inv_row in c_invalid_rows loop
195: l_error_exists := true;
196: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');
197: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
198: if(wip_job_details.std_alone = 1) then
199: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
200: p_text => substr(fnd_message.get,1,500),
201: p_error_type => wip_jdi_utils.msg_error);
202: else

Line 218: and substitution_type = wip_job_details.wip_add

214: and process_status in (wip_constants.running,
215: wip_constants.warning)
216: and wip_entity_id = p_wip_entity_id
217: and organization_id = p_organization_id
218: and substitution_type = wip_job_details.wip_add
219: and ((load_type = wip_job_details.wip_res_instance_usage
220: and not exists (select 1
221: from wip_op_resource_instances
222: where wip_entity_id = wjdi.wip_entity_id

Line 219: and ((load_type = wip_job_details.wip_res_instance_usage

215: wip_constants.warning)
216: and wip_entity_id = p_wip_entity_id
217: and organization_id = p_organization_id
218: and substitution_type = wip_job_details.wip_add
219: and ((load_type = wip_job_details.wip_res_instance_usage
220: and not exists (select 1
221: from wip_op_resource_instances
222: where wip_entity_id = wjdi.wip_entity_id
223: and organization_id = wjdi.organization_id

Line 227: or (load_type = wip_job_details.wip_res_usage

223: and organization_id = wjdi.organization_id
224: and operation_seq_num = wjdi.operation_seq_num
225: and resource_seq_num = wjdi.resource_seq_num
226: and instance_id = wjdi.resource_instance_id))
227: or (load_type = wip_job_details.wip_res_usage
228: and not exists (select 1
229: from wip_operation_resources
230: where wip_entity_id = wjdi.wip_entity_id
231: and organization_id = wjdi.organization_id

Line 248: and load_type in (wip_job_details.wip_res_usage,

244: and process_status in (wip_constants.running,
245: wip_constants.warning)
246: and wip_entity_id = p_wip_entity_id
247: and organization_id = p_organization_id
248: and load_type in (wip_job_details.wip_res_usage,
249: wip_job_details.wip_res_instance_usage)
250: and substitution_type = wip_job_details.wip_add
251: and ( start_date is null
252: or completion_date is null

Line 249: wip_job_details.wip_res_instance_usage)

245: wip_constants.warning)
246: and wip_entity_id = p_wip_entity_id
247: and organization_id = p_organization_id
248: and load_type in (wip_job_details.wip_res_usage,
249: wip_job_details.wip_res_instance_usage)
250: and substitution_type = wip_job_details.wip_add
251: and ( start_date is null
252: or completion_date is null
253: --Bug 5139799:Following 2 validations are added:

Line 250: and substitution_type = wip_job_details.wip_add

246: and wip_entity_id = p_wip_entity_id
247: and organization_id = p_organization_id
248: and load_type in (wip_job_details.wip_res_usage,
249: wip_job_details.wip_res_instance_usage)
250: and substitution_type = wip_job_details.wip_add
251: and ( start_date is null
252: or completion_date is null
253: --Bug 5139799:Following 2 validations are added:
254: -- 1.Start date of usage is greater than or equal to start date of the corresponding resource or instance.

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

272: for l_inv_row in c_invalid_rows loop
273: l_error_exists := true;
274: fnd_message.set_name('WIP', 'WIP_INV_START_OR_END');
275: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
276: if(wip_job_details.std_alone = 1) then
277: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
278: p_text => substr(fnd_message.get,1,500),
279: p_error_type => wip_jdi_utils.msg_error);
280: else

Line 297: and load_type in (wip_job_details.wip_res_usage,

293: and process_status in (wip_constants.running,
294: wip_constants.warning)
295: and wip_entity_id = p_wip_entity_id
296: and organization_id = p_organization_id
297: and load_type in (wip_job_details.wip_res_usage,
298: wip_job_details.wip_res_instance_usage)
299: and substitution_type = wip_job_details.wip_add
300: and ( start_date is null
301: or completion_date is null

Line 298: wip_job_details.wip_res_instance_usage)

294: wip_constants.warning)
295: and wip_entity_id = p_wip_entity_id
296: and organization_id = p_organization_id
297: and load_type in (wip_job_details.wip_res_usage,
298: wip_job_details.wip_res_instance_usage)
299: and substitution_type = wip_job_details.wip_add
300: and ( start_date is null
301: or completion_date is null
302: --Bug 5139799:Following 2 validations are added:

Line 299: and substitution_type = wip_job_details.wip_add

295: and wip_entity_id = p_wip_entity_id
296: and organization_id = p_organization_id
297: and load_type in (wip_job_details.wip_res_usage,
298: wip_job_details.wip_res_instance_usage)
299: and substitution_type = wip_job_details.wip_add
300: and ( start_date is null
301: or completion_date is null
302: --Bug 5139799:Following 2 validations are added:
303: -- 1.Start date of usage is greater than or equal to start date of the corresponding resource or instance.

Line 330: and load_type in (wip_job_details.wip_res_usage,

326: and process_status in (wip_constants.running,
327: wip_constants.warning)
328: and wip_entity_id = p_wip_entity_id
329: and organization_id = p_organization_id
330: and load_type in (wip_job_details.wip_res_usage,
331: wip_job_details.wip_res_instance_usage)
332: and substitution_type = wip_job_details.wip_add
333: and ( assigned_units is null
334: or assigned_units <= 0);

Line 331: wip_job_details.wip_res_instance_usage)

327: wip_constants.warning)
328: and wip_entity_id = p_wip_entity_id
329: and organization_id = p_organization_id
330: and load_type in (wip_job_details.wip_res_usage,
331: wip_job_details.wip_res_instance_usage)
332: and substitution_type = wip_job_details.wip_add
333: and ( assigned_units is null
334: or assigned_units <= 0);
335:

Line 332: and substitution_type = wip_job_details.wip_add

328: and wip_entity_id = p_wip_entity_id
329: and organization_id = p_organization_id
330: and load_type in (wip_job_details.wip_res_usage,
331: wip_job_details.wip_res_instance_usage)
332: and substitution_type = wip_job_details.wip_add
333: and ( assigned_units is null
334: or assigned_units <= 0);
335:
336: l_error_exists boolean := false;

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

339: for l_inv_row in c_invalid_rows loop
340: l_error_exists := true;
341: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
342: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
343: if(wip_job_details.std_alone = 1) then
344: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
345: p_text => substr(fnd_message.get,1,500),
346: p_error_type => wip_jdi_utils.msg_error);
347: else

Line 363: and load_type in (wip_job_details.wip_res_usage,

359: and process_status in (wip_constants.running,
360: wip_constants.warning)
361: and wip_entity_id = p_wip_entity_id
362: and organization_id = p_organization_id
363: and load_type in (wip_job_details.wip_res_usage,
364: wip_job_details.wip_res_instance_usage)
365: and substitution_type = wip_job_details.wip_add
366: and ( assigned_units is null
367: or assigned_units < 0);

Line 364: wip_job_details.wip_res_instance_usage)

360: wip_constants.warning)
361: and wip_entity_id = p_wip_entity_id
362: and organization_id = p_organization_id
363: and load_type in (wip_job_details.wip_res_usage,
364: wip_job_details.wip_res_instance_usage)
365: and substitution_type = wip_job_details.wip_add
366: and ( assigned_units is null
367: or assigned_units < 0);
368: end if;

Line 365: and substitution_type = wip_job_details.wip_add

361: and wip_entity_id = p_wip_entity_id
362: and organization_id = p_organization_id
363: and load_type in (wip_job_details.wip_res_usage,
364: wip_job_details.wip_res_instance_usage)
365: and substitution_type = wip_job_details.wip_add
366: and ( assigned_units is null
367: or assigned_units < 0);
368: end if;
369: end validate_assigned_units;

Line 382: and load_type = wip_job_details.wip_res_instance_usage

378: and process_status in (wip_constants.running,
379: wip_constants.warning)
380: and wip_entity_id = p_wip_entity_id
381: and organization_id = p_organization_id
382: and load_type = wip_job_details.wip_res_instance_usage
383: and substitution_type = wip_job_details.wip_add
384: and exists (select 1
385: from wip_job_dtls_interface wjdi2
386: where wjdi2.group_id = wjdi.group_id

Line 383: and substitution_type = wip_job_details.wip_add

379: wip_constants.warning)
380: and wip_entity_id = p_wip_entity_id
381: and organization_id = p_organization_id
382: and load_type = wip_job_details.wip_res_instance_usage
383: and substitution_type = wip_job_details.wip_add
384: and exists (select 1
385: from wip_job_dtls_interface wjdi2
386: where wjdi2.group_id = wjdi.group_id
387: and wjdi2.wip_entity_id = p_wip_entity_id

Line 391: and wjdi2.load_type = wip_job_details.wip_res_instance_usage

387: and wjdi2.wip_entity_id = p_wip_entity_id
388: and wjdi2.organization_id = p_organization_id
389: and wjdi2.operation_seq_num = wjdi.operation_seq_num
390: and wjdi2.resource_seq_num = wjdi.resource_seq_num
391: and wjdi2.load_type = wip_job_details.wip_res_instance_usage
392: and wjdi2.start_date < wjdi.start_date
393: and wjdi2.completion_date > wjdi.start_date);
394:
395: l_error_exists boolean := false;

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

398: for l_inv_row in c_invalid_res_inst_usage_rows loop
399: l_error_exists := true;
400: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
401: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
402: if(wip_job_details.std_alone = 1) then
403: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
404: p_text => substr(fnd_message.get,1,500),
405: p_error_type => wip_jdi_utils.msg_error);
406: else

Line 422: and load_type = wip_job_details.wip_res_instance_usage

418: and process_status in (wip_constants.running,
419: wip_constants.warning)
420: and wip_entity_id = p_wip_entity_id
421: and organization_id = p_organization_id
422: and load_type = wip_job_details.wip_res_instance_usage
423: and substitution_type = wip_job_details.wip_add
424: and exists (select 1
425: from wip_job_dtls_interface wjdi2
426: where wjdi2.group_id = wjdi.group_id

Line 423: and substitution_type = wip_job_details.wip_add

419: wip_constants.warning)
420: and wip_entity_id = p_wip_entity_id
421: and organization_id = p_organization_id
422: and load_type = wip_job_details.wip_res_instance_usage
423: and substitution_type = wip_job_details.wip_add
424: and exists (select 1
425: from wip_job_dtls_interface wjdi2
426: where wjdi2.group_id = wjdi.group_id
427: and wjdi2.wip_entity_id = p_wip_entity_id

Line 431: and load_type = wip_job_details.wip_res_instance_usage

427: and wjdi2.wip_entity_id = p_wip_entity_id
428: and wjdi2.organization_id = p_organization_id
429: and wjdi2.operation_seq_num = wjdi.operation_seq_num
430: and wjdi2.resource_seq_num = wjdi.resource_seq_num
431: and load_type = wip_job_details.wip_res_instance_usage
432: and wjdi2.rowid <> wjdi.rowid
433: and ( wjdi2.start_date between wjdi.start_date and wjdi.completion_date
434: or wjdi2.completion_date between wjdi.start_date and wjdi.completion_date));
435:

Line 450: and load_type = wip_job_details.wip_res_usage

446: and process_status in (wip_constants.running,
447: wip_constants.warning)
448: and wip_entity_id = p_wip_entity_id
449: and organization_id = p_organization_id
450: and load_type = wip_job_details.wip_res_usage
451: and substitution_type = wip_job_details.wip_add
452: and exists (select 1
453: from wip_job_dtls_interface wjdi2
454: where wjdi2.group_id = wjdi.group_id

Line 451: and substitution_type = wip_job_details.wip_add

447: wip_constants.warning)
448: and wip_entity_id = p_wip_entity_id
449: and organization_id = p_organization_id
450: and load_type = wip_job_details.wip_res_usage
451: and substitution_type = wip_job_details.wip_add
452: and exists (select 1
453: from wip_job_dtls_interface wjdi2
454: where wjdi2.group_id = wjdi.group_id
455: and wjdi2.wip_entity_id = p_wip_entity_id

Line 459: and wjdi2.load_type = wip_job_details.wip_res_usage

455: and wjdi2.wip_entity_id = p_wip_entity_id
456: and wjdi2.organization_id = p_organization_id
457: and wjdi2.operation_seq_num = wjdi.operation_seq_num
458: and wjdi2.resource_seq_num = wjdi.resource_seq_num
459: and wjdi2.load_type = wip_job_details.wip_res_usage
460: and wjdi2.start_date < wjdi.start_date
461: and wjdi2.completion_date > wjdi.start_date);
462:
463: l_error_exists boolean := false;

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

466: for l_inv_row in c_invalid_res_usage_rows loop
467: l_error_exists := true;
468: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
469: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
470: if(wip_job_details.std_alone = 1) then
471: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
472: p_text => substr(fnd_message.get,1,500),
473: p_error_type => wip_jdi_utils.msg_error);
474: else

Line 490: and load_type = wip_job_details.wip_res_usage

486: and process_status in (wip_constants.running,
487: wip_constants.warning)
488: and wip_entity_id = p_wip_entity_id
489: and organization_id = p_organization_id
490: and load_type = wip_job_details.wip_res_usage
491: and substitution_type = wip_job_details.wip_add
492: and exists (select 1
493: from wip_job_dtls_interface wjdi2
494: where wjdi2.group_id = wjdi.group_id

Line 491: and substitution_type = wip_job_details.wip_add

487: wip_constants.warning)
488: and wip_entity_id = p_wip_entity_id
489: and organization_id = p_organization_id
490: and load_type = wip_job_details.wip_res_usage
491: and substitution_type = wip_job_details.wip_add
492: and exists (select 1
493: from wip_job_dtls_interface wjdi2
494: where wjdi2.group_id = wjdi.group_id
495: and wjdi2.wip_entity_id = p_wip_entity_id

Line 499: and load_type = wip_job_details.wip_res_usage

495: and wjdi2.wip_entity_id = p_wip_entity_id
496: and wjdi2.organization_id = p_organization_id
497: and wjdi2.operation_seq_num = wjdi.operation_seq_num
498: and wjdi2.resource_seq_num = wjdi.resource_seq_num
499: and load_type = wip_job_details.wip_res_usage
500: and wjdi2.rowid <> wjdi.rowid
501: and ( wjdi2.start_date between wjdi.start_date and wjdi.completion_date
502: or wjdi2.completion_date between wjdi.start_date and wjdi.completion_date));
503:

Line 518: and load_type = wip_job_details.wip_res_usage

514: and process_status in (wip_constants.running,
515: wip_constants.warning)
516: and wip_entity_id = p_wip_entity_id
517: and organization_id = p_organization_id
518: and load_type = wip_job_details.wip_res_usage
519: and substitution_type = wip_job_details.wip_add
520: and ( not exists (select 1
521: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
522: where wjdi2.group_id = wjdi.group_id

Line 519: and substitution_type = wip_job_details.wip_add

515: wip_constants.warning)
516: and wip_entity_id = p_wip_entity_id
517: and organization_id = p_organization_id
518: and load_type = wip_job_details.wip_res_usage
519: and substitution_type = wip_job_details.wip_add
520: and ( not exists (select 1
521: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
522: where wjdi2.group_id = wjdi.group_id
523: and wjdi2.wip_entity_id = p_wip_entity_id

Line 527: and wjdi2.load_type = wip_job_details.wip_res_usage

523: and wjdi2.wip_entity_id = p_wip_entity_id
524: and wjdi2.organization_id = p_organization_id
525: and wjdi2.operation_seq_num = wjdi.operation_seq_num
526: and wjdi2.resource_seq_num = wjdi.resource_seq_num
527: and wjdi2.load_type = wip_job_details.wip_res_usage
528: and wjdi2.substitution_type = wip_job_details.wip_add
529: and wor.wip_entity_id = p_wip_entity_id
530: and wor.organization_id = p_organization_id
531: and wor.operation_seq_num = wjdi2.operation_seq_num

Line 528: and wjdi2.substitution_type = wip_job_details.wip_add

524: and wjdi2.organization_id = p_organization_id
525: and wjdi2.operation_seq_num = wjdi.operation_seq_num
526: and wjdi2.resource_seq_num = wjdi.resource_seq_num
527: and wjdi2.load_type = wip_job_details.wip_res_usage
528: and wjdi2.substitution_type = wip_job_details.wip_add
529: and wor.wip_entity_id = p_wip_entity_id
530: and wor.organization_id = p_organization_id
531: and wor.operation_seq_num = wjdi2.operation_seq_num
532: and wor.resource_seq_num = wjdi2.resource_seq_num

Line 541: and wjdi2.load_type = wip_job_details.wip_res_usage

537: and wjdi2.wip_entity_id = p_wip_entity_id
538: and wjdi2.organization_id = p_organization_id
539: and wjdi2.operation_seq_num = wjdi.operation_seq_num
540: and wjdi2.resource_seq_num = wjdi.resource_seq_num
541: and wjdi2.load_type = wip_job_details.wip_res_usage
542: and wjdi2.substitution_type = wip_job_details.wip_add
543: and wor.wip_entity_id = p_wip_entity_id
544: and wor.organization_id = p_organization_id
545: and wor.operation_seq_num = wjdi2.operation_seq_num

Line 542: and wjdi2.substitution_type = wip_job_details.wip_add

538: and wjdi2.organization_id = p_organization_id
539: and wjdi2.operation_seq_num = wjdi.operation_seq_num
540: and wjdi2.resource_seq_num = wjdi.resource_seq_num
541: and wjdi2.load_type = wip_job_details.wip_res_usage
542: and wjdi2.substitution_type = wip_job_details.wip_add
543: and wor.wip_entity_id = p_wip_entity_id
544: and wor.organization_id = p_organization_id
545: and wor.operation_seq_num = wjdi2.operation_seq_num
546: and wor.resource_seq_num = wjdi2.resource_seq_num

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

550: for l_inv_row in c_invalid_rows loop
551: l_error_exists := true;
552: fnd_message.set_name('WIP', 'WIP_DATE_NOT_MATCH');
553: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
554: if(wip_job_details.std_alone = 1) then
555: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
556: p_text => substr(fnd_message.get,1,500),
557: p_error_type => wip_jdi_utils.msg_error);
558: else

Line 574: and load_type = wip_job_details.wip_res_usage

570: and process_status in (wip_constants.running,
571: wip_constants.warning)
572: and wip_entity_id = p_wip_entity_id
573: and organization_id = p_organization_id
574: and load_type = wip_job_details.wip_res_usage
575: and substitution_type = wip_job_details.wip_add
576: and ( not exists (select 1
577: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
578: where wjdi2.group_id = wjdi.group_id

Line 575: and substitution_type = wip_job_details.wip_add

571: wip_constants.warning)
572: and wip_entity_id = p_wip_entity_id
573: and organization_id = p_organization_id
574: and load_type = wip_job_details.wip_res_usage
575: and substitution_type = wip_job_details.wip_add
576: and ( not exists (select 1
577: from wip_job_dtls_interface wjdi2, wip_operation_resources wor
578: where wjdi2.group_id = wjdi.group_id
579: and wjdi2.wip_entity_id = p_wip_entity_id

Line 583: and wjdi2.load_type = wip_job_details.wip_res_usage

579: and wjdi2.wip_entity_id = p_wip_entity_id
580: and wjdi2.organization_id = p_organization_id
581: and wjdi2.operation_seq_num = wjdi.operation_seq_num
582: and wjdi2.resource_seq_num = wjdi.resource_seq_num
583: and wjdi2.load_type = wip_job_details.wip_res_usage
584: and wjdi2.substitution_type = wip_job_details.wip_add
585: and wor.wip_entity_id = p_wip_entity_id
586: and wor.organization_id = p_organization_id
587: and wor.operation_seq_num = wjdi2.operation_seq_num

Line 584: and wjdi2.substitution_type = wip_job_details.wip_add

580: and wjdi2.organization_id = p_organization_id
581: and wjdi2.operation_seq_num = wjdi.operation_seq_num
582: and wjdi2.resource_seq_num = wjdi.resource_seq_num
583: and wjdi2.load_type = wip_job_details.wip_res_usage
584: and wjdi2.substitution_type = wip_job_details.wip_add
585: and wor.wip_entity_id = p_wip_entity_id
586: and wor.organization_id = p_organization_id
587: and wor.operation_seq_num = wjdi2.operation_seq_num
588: and wor.resource_seq_num = wjdi2.resource_seq_num

Line 597: and wjdi2.load_type = wip_job_details.wip_res_usage

593: and wjdi2.wip_entity_id = p_wip_entity_id
594: and wjdi2.organization_id = p_organization_id
595: and wjdi2.operation_seq_num = wjdi.operation_seq_num
596: and wjdi2.resource_seq_num = wjdi.resource_seq_num
597: and wjdi2.load_type = wip_job_details.wip_res_usage
598: and wjdi2.substitution_type = wip_job_details.wip_add
599: and wor.wip_entity_id = p_wip_entity_id
600: and wor.organization_id = p_organization_id
601: and wor.operation_seq_num = wjdi2.operation_seq_num

Line 598: and wjdi2.substitution_type = wip_job_details.wip_add

594: and wjdi2.organization_id = p_organization_id
595: and wjdi2.operation_seq_num = wjdi.operation_seq_num
596: and wjdi2.resource_seq_num = wjdi.resource_seq_num
597: and wjdi2.load_type = wip_job_details.wip_res_usage
598: and wjdi2.substitution_type = wip_job_details.wip_add
599: and wor.wip_entity_id = p_wip_entity_id
600: and wor.organization_id = p_organization_id
601: and wor.operation_seq_num = wjdi2.operation_seq_num
602: and wor.resource_seq_num = wjdi2.resource_seq_num