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 FND_API

Line 61: if(l_ret_status = fnd_api.g_ret_sts_success) then

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,
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,

Line 70: if(l_ret_status = fnd_api.g_ret_sts_success) then

66: x_return_status => l_ret_status);
67: end if;
68:
69:
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,

Line 79: if(l_ret_status = fnd_api.g_ret_sts_success) then

75: x_return_status => l_ret_status);
76: end if;
77:
78: --if serials do not yet exist in msn, create them here.
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,

Line 87: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 95: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 103: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 124: if(l_ret_status = fnd_api.g_ret_sts_success) then

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,
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,

Line 132: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 141: if(l_ret_status = fnd_api.g_ret_sts_success) then

137: x_return_status => l_ret_status);
138: end if;
139:
140: --if serials do not yet exist in msn, create them here.
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,

Line 149: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 163: l_ret_status VARCHAR2(10) := fnd_api.g_ret_sts_success;

159: procedure delete_serial(p_group_id in number,
160: p_wip_entity_id in number,
161: p_organization_id in number,
162: p_substitution_type in number) is
163: l_ret_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
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,

Line 171: if(l_ret_status = fnd_api.g_ret_sts_success) then

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,
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,

Line 179: if(l_ret_status = fnd_api.g_ret_sts_success) then

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
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,

Line 188: if(l_ret_status = fnd_api.g_ret_sts_success) then

184: x_return_status => l_ret_status);
185: end if;
186:
187:
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,

Line 218: x_return_status := fnd_api.g_ret_sts_success;

214: and wjdi.substitution_type = p_substitution_type
215: and wjdi.serial_number_old is null;
216:
217: begin
218: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 220: x_return_status := fnd_api.g_ret_sts_error;

216:
217: begin
218: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 234: if(x_return_status <> fnd_api.g_ret_sts_success) then

230: p_error_type => wip_jdi_utils.msg_error);
231: end if;
232: end loop;
233:
234: if(x_return_status <> fnd_api.g_ret_sts_success) then
235: update wip_job_dtls_interface wjdi
236: set process_status = wip_constants.error
237: where group_id = p_group_id
238: and process_phase = wip_constants.ml_validation

Line 283: x_return_status := fnd_api.g_ret_sts_success;

279: l_end_serial_num VARCHAR2(30);
280: l_error_msg VARCHAR(2000);
281: l_return_status VARCHAR2(1);
282: begin
283: x_return_status := fnd_api.g_ret_sts_success;
284: for l_ser_rec in c_serials loop
285: l_start_serial_num := l_ser_rec.serial_number_new;
286: wip_utilities.generate_serials(p_org_id => p_organization_id,
287: p_item_id => l_ser_rec.primary_item_id,

Line 297: if(l_return_status <> fnd_api.g_ret_sts_success) then

293: x_end_serial => l_end_serial_num,
294: x_return_status => l_return_status,
295: x_err_msg => l_error_msg);
296:
297: if(l_return_status <> fnd_api.g_ret_sts_success) 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);

Line 298: x_return_status := fnd_api.g_ret_sts_error;

294: x_return_status => l_return_status,
295: x_err_msg => l_error_msg);
296:
297: if(l_return_status <> fnd_api.g_ret_sts_success) 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

Line 338: x_return_status := fnd_api.g_ret_sts_success;

334: and wjdi.substitution_type = p_substitution_type
335: and wjdi.serial_number_new is null;
336:
337: begin
338: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 340: x_return_status := fnd_api.g_ret_sts_error;

336:
337: begin
338: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 354: if(x_return_status <> fnd_api.g_ret_sts_success) then

350: p_error_type => wip_jdi_utils.msg_error);
351: end if;
352: end loop;
353:
354: if(x_return_status <> fnd_api.g_ret_sts_success) then
355: update wip_job_dtls_interface wjdi
356: set process_status = wip_constants.error
357: where group_id = p_group_id
358: and process_phase = wip_constants.ml_validation

Line 398: x_return_status := fnd_api.g_ret_sts_success;

394: and msn.inventory_item_id = we.primary_item_id
395: and we.wip_entity_id = p_wip_entity_id);
396:
397: begin
398: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 400: x_return_status := fnd_api.g_ret_sts_error;

396:
397: begin
398: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 414: if(x_return_status <> fnd_api.g_ret_sts_success) then

410: p_error_type => wip_jdi_utils.msg_error);
411: end if;
412: end loop;
413:
414: if(x_return_status <> fnd_api.g_ret_sts_success) then
415: update wip_job_dtls_interface wjdi
416: set process_status = wip_constants.error
417: where group_id = p_group_id
418: and process_phase = wip_constants.ml_validation

Line 469: x_return_status := fnd_api.g_ret_sts_success;

465: and msn.inventory_item_id = we.primary_item_id
466: and we.wip_entity_id = p_wip_entity_id);
467:
468: begin
469: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 471: x_return_status := fnd_api.g_ret_sts_error;

467:
468: begin
469: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 485: if(x_return_status <> fnd_api.g_ret_sts_success) then

481: p_error_type => wip_jdi_utils.msg_error);
482: end if;
483: end loop;
484:
485: if(x_return_status <> fnd_api.g_ret_sts_success) then
486: update wip_job_dtls_interface wjdi
487: set process_status = wip_constants.error
488: where group_id = p_group_id
489: and process_phase = wip_constants.ml_validation

Line 537: x_return_status := fnd_api.g_ret_sts_success;

533: wip_constants.create_ns_job,
534: wip_constants.resched_job));
535:
536: begin
537: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 539: x_return_status := fnd_api.g_ret_sts_error;

535:
536: begin
537: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 553: if(x_return_status <> fnd_api.g_ret_sts_success) then

549: p_error_type => wip_jdi_utils.msg_error);
550: end if;
551: end loop;
552:
553: if(x_return_status <> fnd_api.g_ret_sts_success) then
554: update wip_job_dtls_interface wjdi
555: set process_status = wip_constants.error
556: where group_id = p_group_id
557: and process_phase = wip_constants.ml_validation

Line 604: x_return_status := fnd_api.g_ret_sts_success;

600: wip_constants.hold,
601: wip_constants.comp_chrg));
602:
603: begin
604: x_return_status := fnd_api.g_ret_sts_success;
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));

Line 606: x_return_status := fnd_api.g_ret_sts_error;

602:
603: begin
604: x_return_status := fnd_api.g_ret_sts_success;
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,

Line 620: if(x_return_status <> fnd_api.g_ret_sts_success) then

616: p_error_type => wip_jdi_utils.msg_error);
617: end if;
618: end loop;
619:
620: if(x_return_status <> fnd_api.g_ret_sts_success) then
621: update wip_job_dtls_interface wjdi
622: set process_status = wip_constants.error
623: where group_id = p_group_id
624: and process_phase = wip_constants.ml_validation