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

Line 51: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

47: WHERE group_id = p_group_id
48: AND process_status = WIP_CONSTANTS.ERROR
49: AND wip_entity_id = p_wip_entity_id
50: AND organization_id = p_organization_id
51: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
52: AND substitution_type= p_substitution_type;
53:
54:
55: IF x_count <> 0 THEN

Line 132: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

128: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
129: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
130: AND wip_entity_id = p_wip_entity_id
131: AND organization_id = p_organization_id
132: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
133: AND substitution_type = p_subst_type;
134: /* AND exists (select 1
135: FROM WIP_OPERATION_NETWORKS
136: WHERE wip_entity_id = wjdi.wip_entity_id

Line 168: and load_type = wip_job_details.wip_op_link

164: wip_constants.pending,
165: wip_constants.warning)
166: and wip_entity_id = p_wip_entity_id
167: and organization_id = p_organization_id
168: and load_type = wip_job_details.wip_op_link
169: and substitution_type = p_subst_type;
170: end if;
171:
172: End Loop_Exists;

Line 188: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

184: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
185: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
186: AND wip_entity_id = p_wip_entity_id
187: AND organization_id = p_organization_id
188: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
189: AND substitution_type = p_subst_type
190: AND not exists (select 1
191: FROM WIP_OPERATIONS
192: WHERE wip_entity_id = p_wip_entity_id

Line 222: and load_type = wip_job_details.wip_op_link

218: wip_constants.pending,
219: wip_constants.warning)
220: and wip_entity_id = p_wip_entity_id
221: and organization_id = p_organization_id
222: and load_type = wip_job_details.wip_op_link
223: and substitution_type = p_subst_type;
224: end if;
225:
226: END Validate_Op_Seq_Num;

Line 247: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

243: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
244: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
245: AND wip_entity_id = p_wip_entity_id
246: AND organization_id = p_organization_id
247: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
248: AND substitution_type = p_subst_type;
249:
250: l_operation_seq_num number;
251: from_id number;

Line 287: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

283: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
284: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
285: AND wip_entity_id = p_wip_entity_id
286: AND organization_id = p_organization_id
287: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
288: AND substitution_type = p_subst_type;
289:
290: l_completed varchar2(30) := 'N';
291: l_prev_op_complete varchar2(30) := 'N';

Line 338: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

334: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
335: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
336: AND wip_entity_id = p_wip_entity_id
337: AND organization_id = p_organization_id
338: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
339: AND operation_seq_num = from_id
340: AND next_network_op_seq_num = to_id
341: AND substitution_type = p_subst_type;
342:

Line 383: and load_type = wip_job_details.wip_op_link

379: wip_constants.pending,
380: wip_constants.warning)
381: and wip_entity_id = p_wip_entity_id
382: and organization_id = p_organization_id
383: and load_type = wip_job_details.wip_op_link
384: and substitution_type = p_subst_type;
385:
386: end if;
387: END Loop;

Line 422: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

418: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
419: AND process_status in (WIP_CONSTANTS.RUNNING,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_OP_LINK
423: AND substitution_type = p_subst_type
424: AND exists (select 1
425: FROM WIP_OPERATION_NETWORKS
426: WHERE wip_entity_id = wjdi.wip_entity_id

Line 438: if (p_subst_type = WIP_JOB_DETAILS.WIP_DELETE) then

434: begin
435:
436: Open c_op_link_rows;
437: fetch c_op_link_rows into l_interface_id;
438: if (p_subst_type = WIP_JOB_DETAILS.WIP_DELETE) then
439: if c_op_link_rows%NOTFOUND then
440: l_error_exists := true;
441: fnd_message.set_name('WIP', 'WIP_OP_LINK_NOT_FOUND');
442: fnd_message.set_token('INTERFACE', to_char(l_interface_id));

Line 447: elsif (p_subst_type = WIP_JOB_DETAILS.WIP_ADD) then

443: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
444: p_text => substr(fnd_message.get,1,500),
445: p_error_type => wip_jdi_utils.msg_error);
446: end if;
447: elsif (p_subst_type = WIP_JOB_DETAILS.WIP_ADD) then
448: if c_op_link_rows%FOUND then
449: l_error_exists := true;
450: fnd_message.set_name('WIP', 'WIP_OP_LINK_EXISTS');
451: fnd_message.set_token('INTERFACE', to_char(l_interface_id));

Line 469: and load_type = wip_job_details.wip_op_link

465: wip_constants.pending,
466: wip_constants.warning)
467: and wip_entity_id = p_wip_entity_id
468: and organization_id = p_organization_id
469: and load_type = wip_job_details.wip_op_link
470: and substitution_type = p_subst_type;
471: end if;
472:
473: /* x_return_status := FND_API.G_RET_STS_ERROR;

Line 535: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK

531: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
532: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
533: AND wip_entity_id = p_wip_entity_id
534: AND organization_id = p_organization_id
535: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
536: AND substitution_type = p_substitution_type;
537:
538: BEGIN
539: