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

Line 58: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

54: begin
55: valid_parent_load_type(p_group_id => p_group_id,
56: p_wip_entity_id => p_wip_entity_id,
57: p_organization_id => p_organization_id,
58: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
59: x_return_status => l_ret_status);
60:
61: if(l_ret_status = fnd_api.g_ret_sts_success) then
62: valid_job_exists(p_group_id => p_group_id,

Line 65: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

61: if(l_ret_status = fnd_api.g_ret_sts_success) then
62: valid_job_exists(p_group_id => p_group_id,
63: p_wip_entity_id => p_wip_entity_id,
64: p_organization_id => p_organization_id,
65: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
66: x_return_status => l_ret_status);
67: end if;
68:
69:

Line 74: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

70: if(l_ret_status = fnd_api.g_ret_sts_success) then
71: add_info_exists(p_group_id => p_group_id,
72: p_wip_entity_id => p_wip_entity_id,
73: p_organization_id => p_organization_id,
74: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
75: x_return_status => l_ret_status);
76: end if;
77:
78: --if serials do not yet exist in msn, create them here.

Line 83: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

79: if(l_ret_status = fnd_api.g_ret_sts_success) then
80: create_serials(p_group_id => p_group_id,
81: p_wip_entity_id => p_wip_entity_id,
82: p_organization_id => p_organization_id,
83: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
84: x_return_status => l_ret_status);
85: end if;
86:
87: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 91: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

87: if(l_ret_status = fnd_api.g_ret_sts_success) then
88: unused_serial_exists(p_group_id => p_group_id,
89: p_wip_entity_id => p_wip_entity_id,
90: p_organization_id => p_organization_id,
91: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
92: x_return_status => l_ret_status);
93: end if;
94:
95: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 99: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

95: if(l_ret_status = fnd_api.g_ret_sts_success) then
96: del_info_exists(p_group_id => p_group_id,
97: p_wip_entity_id => p_wip_entity_id,
98: p_organization_id => p_organization_id,
99: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
100: x_return_status => l_ret_status);
101: end if;
102:
103: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 107: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,

103: if(l_ret_status = fnd_api.g_ret_sts_success) then
104: used_serial_exists(p_group_id => p_group_id,
105: p_wip_entity_id => p_wip_entity_id,
106: p_organization_id => p_organization_id,
107: p_substitution_type => WIP_JOB_DETAILS.WIP_CHANGE,
108: x_return_status => l_ret_status);
109: end if;
110: end change_serial;
111:

Line 121: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,

117: begin
118: valid_parent_load_type(p_group_id => p_group_id,
119: p_wip_entity_id => p_wip_entity_id,
120: p_organization_id => p_organization_id,
121: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,
122: x_return_status => l_ret_status);
123:
124: if(l_ret_status = fnd_api.g_ret_sts_success) then
125: valid_job_exists(p_group_id => p_group_id,

Line 128: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,

124: if(l_ret_status = fnd_api.g_ret_sts_success) then
125: valid_job_exists(p_group_id => p_group_id,
126: p_wip_entity_id => p_wip_entity_id,
127: p_organization_id => p_organization_id,
128: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,
129: x_return_status => l_ret_status);
130: end if;
131:
132: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 136: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,

132: if(l_ret_status = fnd_api.g_ret_sts_success) then
133: add_info_exists(p_group_id => p_group_id,
134: p_wip_entity_id => p_wip_entity_id,
135: p_organization_id => p_organization_id,
136: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,
137: x_return_status => l_ret_status);
138: end if;
139:
140: --if serials do not yet exist in msn, create them here.

Line 145: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,

141: if(l_ret_status = fnd_api.g_ret_sts_success) then
142: create_serials(p_group_id => p_group_id,
143: p_wip_entity_id => p_wip_entity_id,
144: p_organization_id => p_organization_id,
145: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,
146: x_return_status => l_ret_status);
147: end if;
148:
149: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 153: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,

149: if(l_ret_status = fnd_api.g_ret_sts_success) then
150: unused_serial_exists(p_group_id => p_group_id,
151: p_wip_entity_id => p_wip_entity_id,
152: p_organization_id => p_organization_id,
153: p_substitution_type => WIP_JOB_DETAILS.WIP_ADD,
154: x_return_status => l_ret_status);
155: end if;
156: end add_serial;
157:

Line 168: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,

164: begin
165: valid_parent_load_type(p_group_id => p_group_id,
166: p_wip_entity_id => p_wip_entity_id,
167: p_organization_id => p_organization_id,
168: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,
169: x_return_status => l_ret_status);
170:
171: if(l_ret_status = fnd_api.g_ret_sts_success) then
172: valid_job_exists(p_group_id => p_group_id,

Line 175: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,

171: if(l_ret_status = fnd_api.g_ret_sts_success) then
172: valid_job_exists(p_group_id => p_group_id,
173: p_wip_entity_id => p_wip_entity_id,
174: p_organization_id => p_organization_id,
175: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,
176: x_return_status => l_ret_status);
177: end if;
178:
179: if(l_ret_status = fnd_api.g_ret_sts_success) then

Line 183: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,

179: if(l_ret_status = fnd_api.g_ret_sts_success) then
180: del_info_exists(p_group_id => p_group_id,
181: p_wip_entity_id => p_wip_entity_id,
182: p_organization_id => p_organization_id,
183: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,
184: x_return_status => l_ret_status);
185: end if;
186:
187:

Line 192: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,

188: if(l_ret_status = fnd_api.g_ret_sts_success) then
189: used_serial_exists(p_group_id => p_group_id,
190: p_wip_entity_id => p_wip_entity_id,
191: p_organization_id => p_organization_id,
192: p_substitution_type => WIP_JOB_DETAILS.WIP_DELETE,
193: x_return_status => l_ret_status);
194: end if;
195: end delete_serial;
196:

Line 213: and wjdi.load_type = wip_job_details.wip_serial

209: wip_constants.pending,
210: wip_constants.warning)
211: and wjdi.wip_entity_id = p_wip_entity_id
212: and wjdi.organization_id = p_organization_id
213: and wjdi.load_type = wip_job_details.wip_serial
214: and wjdi.substitution_type = p_substitution_type
215: and wjdi.serial_number_old is null;
216:
217: begin

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

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

Line 244: and wjdi.load_type = wip_job_details.wip_serial

240: wip_constants.pending,
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_serial
245: and wjdi.substitution_type = p_substitution_type
246: and wjdi.serial_number_old is null;
247: end if;
248: end del_info_exists;

Line 269: and wjdi.load_type = wip_job_details.wip_serial

265: wip_constants.pending,
266: wip_constants.warning)
267: and wjdi.wip_entity_id = p_wip_entity_id
268: and wjdi.organization_id = p_organization_id
269: and wjdi.load_type = wip_job_details.wip_serial
270: and wjdi.substitution_type = p_substitution_type
271: and wjdi.wip_entity_id = we.wip_entity_id
272: and not exists(select 1
273: from mtl_serial_numbers

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

298: x_return_status := fnd_api.g_ret_sts_error;
299: fnd_message.set_name('WIP', 'WIP_JDI_SER_CREATION_FAILED');
300: fnd_message.set_token('INTERFACE', l_ser_rec.interface_id);
301: fnd_message.set_token('MESSAGE', l_error_msg);
302: if(wip_job_details.std_alone = 1) then
303: wip_interface_err_Utils.add_error(p_interface_id => l_ser_rec.interface_id,
304: p_text => substr(fnd_message.get,1,500),
305: p_error_type => wip_jdi_utils.msg_error);
306: else

Line 333: and wjdi.load_type = wip_job_details.wip_serial

329: wip_constants.pending,
330: wip_constants.warning)
331: and wjdi.wip_entity_id = p_wip_entity_id
332: and wjdi.organization_id = p_organization_id
333: and wjdi.load_type = wip_job_details.wip_serial
334: and wjdi.substitution_type = p_substitution_type
335: and wjdi.serial_number_new is null;
336:
337: begin

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

339: for l_inv_row in c_invalid_rows loop
340: x_return_status := fnd_api.g_ret_sts_error;
341: fnd_message.set_name('WIP', 'WIP_JDI_NEW_SERIAL_MISSING');
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 364: and wjdi.load_type = wip_job_details.wip_serial

360: wip_constants.pending,
361: wip_constants.warning)
362: and wip_entity_id = p_wip_entity_id
363: and organization_id = p_organization_id
364: and wjdi.load_type = wip_job_details.wip_serial
365: and wjdi.substitution_type = p_substitution_type
366: and wjdi.serial_number_new is null;
367: end if;
368: end add_info_exists;

Line 385: and wjdi.load_type = wip_job_details.wip_serial

381: wip_constants.pending,
382: wip_constants.warning)
383: and wjdi.wip_entity_id = p_wip_entity_id
384: and wjdi.organization_id = p_organization_id
385: and wjdi.load_type = wip_job_details.wip_serial
386: and wjdi.substitution_type = p_substitution_type
387: and not exists(select 1
388: from mtl_serial_numbers msn, wip_entities we
389: where msn.serial_number = wjdi.serial_number_new

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

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

Line 424: and wjdi.load_type = wip_job_details.wip_serial

420: wip_constants.pending,
421: wip_constants.warning)
422: and wip_entity_id = p_wip_entity_id
423: and organization_id = p_organization_id
424: and wjdi.load_type = wip_job_details.wip_serial
425: and wjdi.substitution_type = p_substitution_type
426: and not exists(select 1
427: from mtl_serial_numbers msn, wip_entities we
428: where msn.serial_number = wjdi.serial_number_new

Line 455: and wjdi.load_type = wip_job_details.wip_serial

451: wip_constants.pending,
452: wip_constants.warning)
453: and wjdi.wip_entity_id = p_wip_entity_id
454: and wjdi.organization_id = p_organization_id
455: and wjdi.load_type = wip_job_details.wip_serial
456: and wjdi.substitution_type = p_substitution_type
457: and not exists(select 1
458: from mtl_serial_numbers msn, wip_entities we
459: where msn.serial_number = wjdi.serial_number_old

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

470: for l_inv_row in c_invalid_rows loop
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_USED_SERIAL');
473: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
474: if(wip_job_details.std_alone = 1) then
475: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
476: p_text => substr(fnd_message.get,1,500),
477: p_error_type => wip_jdi_utils.msg_error);
478: else

Line 495: and wjdi.load_type = wip_job_details.wip_serial

491: wip_constants.pending,
492: wip_constants.warning)
493: and wip_entity_id = p_wip_entity_id
494: and organization_id = p_organization_id
495: and wjdi.load_type = wip_job_details.wip_serial
496: and wjdi.substitution_type = p_substitution_type
497: and not exists(select 1
498: from mtl_serial_numbers msn, wip_entities we
499: where msn.serial_number = wjdi.serial_number_old

Line 527: and wjdi.load_type = wip_job_details.wip_serial

523: wip_constants.warning)
524: and wjdi.wip_entity_id = p_wip_entity_id
525: and wjdi.organization_id = p_organization_id
526: and wjdi.substitution_type = p_substitution_type
527: and wjdi.load_type = wip_job_details.wip_serial
528: and not exists (select 1
529: from wip_job_schedule_interface wjsi
530: where wjsi.header_id = wjdi.parent_header_id
531: and wjsi.group_id = wjdi.group_id

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

538: for l_inv_row in c_invalid_rows loop
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('WIP', 'WIP_JDI_SER_INV_LOAD_TYPE');
541: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
542: if(wip_job_details.std_alone = 1) then
543: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
544: p_text => substr(fnd_message.get,1,500),
545: p_error_type => wip_jdi_utils.msg_error);
546: else

Line 564: and wjdi.load_type = wip_job_details.wip_serial

560: wip_constants.warning)
561: and wip_entity_id = p_wip_entity_id
562: and organization_id = p_organization_id
563: and wjdi.substitution_type = p_substitution_type
564: and wjdi.load_type = wip_job_details.wip_serial
565: and not exists (select 1
566: from wip_job_schedule_interface wjsi
567: where wjsi.header_id = wjdi.parent_header_id
568: and wjsi.group_id = wjdi.group_id

Line 591: and wjdi.load_type = wip_job_details.wip_serial

587: wip_constants.warning)
588: and wjdi.wip_entity_id = p_wip_entity_id
589: and wjdi.organization_id = p_organization_id
590: and wjdi.substitution_type = p_substitution_type
591: and wjdi.load_type = wip_job_details.wip_serial
592: and not exists (select 1
593: from wip_job_schedule_interface wjsi, wip_discrete_jobs wdj
594: where wjsi.header_id = wjdi.parent_header_id
595: and wjsi.group_id = wjdi.group_id

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

605: for l_inv_row in c_invalid_rows loop
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name('WIP', 'WIP_JDI_SER_JOB_STATUS');
608: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
609: if(wip_job_details.std_alone = 1) then
610: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
611: p_text => substr(fnd_message.get,1,500),
612: p_error_type => wip_jdi_utils.msg_error);
613: else

Line 631: and wjdi.load_type = wip_job_details.wip_serial

627: wip_constants.warning)
628: and wip_entity_id = p_wip_entity_id
629: and organization_id = p_organization_id
630: and wjdi.substitution_type = p_substitution_type
631: and wjdi.load_type = wip_job_details.wip_serial
632: and not exists (select 1
633: from wip_discrete_jobs wdj
634: where wjdi.wip_entity_id = wdj.wip_entity_id
635: and wdj.serialization_start_op is not null