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_BOMROUTING_PVT dependencies on FND_API

Line 46: x_returnStatus := fnd_api.g_ret_sts_success;

42: l_endDate date;
43: l_rtgItemID number;
44: l_bomItemID number;
45: begin
46: x_returnStatus := fnd_api.g_ret_sts_success;
47: if (l_logLevel <= wip_constants.trace_logging) then
48: l_params(1).paramName := 'p_orgID';
49: l_params(1).paramValue := p_orgID;
50: l_params(2).paramName := 'p_wipEntityID';

Line 83: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

79: l_params(16).paramValue := p_bomRefID;
80: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
81: p_params => l_params,
82: x_returnStatus => x_returnStatus);
83: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
84: raise fnd_api.g_exc_unexpected_error;
85: end if;
86: end if;
87:

Line 84: raise fnd_api.g_exc_unexpected_error;

80: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
81: p_params => l_params,
82: x_returnStatus => x_returnStatus);
83: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
84: raise fnd_api.g_exc_unexpected_error;
85: end if;
86: end if;
87:
88: if ( p_schedulingMethod = wip_constants.routing ) then

Line 94: raise fnd_api.g_exc_unexpected_error;

90: ((p_startDate is not null and p_endDate is not null) and
91: /* Bug 4515999 Non standard jobs cannot have both dates not null */
92: p_jobType = wip_constants.standard) ) then
93: x_errorMsg := 'Must only provide one of the p_startDate and p_endDate for routing based scheduling';
94: raise fnd_api.g_exc_unexpected_error;
95: else
96: -- populate some value and then we will reschedule it later on.
97: l_startDate := nvl(p_startDate, p_endDate);
98: l_endDate := l_startDate;

Line 103: raise fnd_api.g_exc_unexpected_error;

99: end if;
100: else
101: if ( p_startDate is null or p_endDate is null ) then
102: x_errorMsg := 'Must provide both of the dates if it is not routing based scheduling';
103: raise fnd_api.g_exc_unexpected_error;
104: else
105: l_startDate := p_startDate;
106: l_endDate := p_endDate;
107: end if;

Line 130: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

126: p_endDate => l_endDate,
127: x_serStartOp => x_serStartOp,
128: x_returnStatus => x_returnStatus,
129: x_errorMsg => x_errorMsg);
130: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
131: raise fnd_api.g_exc_unexpected_error;
132: end if;
133:
134: if ( p_schedulingMethod = wip_constants.routing ) then

Line 131: raise fnd_api.g_exc_unexpected_error;

127: x_serStartOp => x_serStartOp,
128: x_returnStatus => x_returnStatus,
129: x_errorMsg => x_errorMsg);
130: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
131: raise fnd_api.g_exc_unexpected_error;
132: end if;
133:
134: if ( p_schedulingMethod = wip_constants.routing ) then
135: wip_infinite_scheduler_pvt.schedule(

Line 142: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

138: p_startDate => p_startDate,
139: p_endDate => p_endDate,
140: x_returnStatus => x_returnStatus,
141: x_errorMsg => x_errorMsg);
142: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;
145: end if;
146:

Line 143: raise fnd_api.g_exc_unexpected_error;

139: p_endDate => p_endDate,
140: x_returnStatus => x_returnStatus,
141: x_errorMsg => x_errorMsg);
142: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;
145: end if;
146:
147: -- explode the bom

Line 171: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

167: p_taskID => p_taskID,
168: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
169: x_returnStatus => x_returnStatus,
170: x_errorMsg => x_errorMsg);
171: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
172: raise fnd_api.g_exc_unexpected_error;
173: end if;
174:
175: -- for bug 3041013

Line 172: raise fnd_api.g_exc_unexpected_error;

168: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
169: x_returnStatus => x_returnStatus,
170: x_errorMsg => x_errorMsg);
171: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
172: raise fnd_api.g_exc_unexpected_error;
173: end if;
174:
175: -- for bug 3041013
176: delete wip_operation_resource_usage

Line 192: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

188: x_returnStatus => l_retStatus);
189: end if;
190: exception
191: when others then
192: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
193: -- Fixed for bug 5255226
194: -- Don't need to add the x_errormsg again to stack by calling fnd_msg_pub.add_exc_msg
195: -- Removed this API call. Instead adding this error message to debug log using
196: if (l_logLevel <= wip_constants.trace_logging) then

Line 275: x_returnStatus := fnd_api.g_ret_sts_success;

271: and operation_seq_num < 0
272: and wip_supply_type = wip_constants.phantom;
273: begin
274:
275: x_returnStatus := fnd_api.g_ret_sts_success;
276: if (l_logLevel <= wip_constants.trace_logging) then
277: l_params(1).paramName := 'p_orgID';
278: l_params(1).paramValue := p_orgID;
279: l_params(2).paramName := 'p_wipEntityID';

Line 284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

280: l_params(2).paramValue := p_wipEntityID;
281: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
282: p_params => l_params,
283: x_returnStatus => x_returnStatus);
284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
285: raise fnd_api.g_exc_unexpected_error;
286: end if;
287: end if;
288:

Line 285: raise fnd_api.g_exc_unexpected_error;

281: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
282: p_params => l_params,
283: x_returnStatus => x_returnStatus);
284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
285: raise fnd_api.g_exc_unexpected_error;
286: end if;
287: end if;
288:
289: select job_type,

Line 312: nvl(p_altRouting, fnd_api.g_miss_char) <> nvl(l_altRtg, fnd_api.g_miss_char) or

308: where organization_id = p_orgID
309: and wip_entity_id = p_wipEntityID;
310:
311: if ( /*Fix for bug 5020741. Routing should be exploded if any relevant feild is not null.
312: nvl(p_altRouting, fnd_api.g_miss_char) <> nvl(l_altRtg, fnd_api.g_miss_char) or
313: nvl(p_routingRevDate, fnd_api.g_miss_date) <> nvl(l_rtgRevDate, fnd_api.g_miss_date)*/
314: --Bug 5464449:Comparision of routing info is fixed
315: --p_altRouting IS NOT NULL or
316: --p_routingRevDate IS NOT NULL or

Line 313: nvl(p_routingRevDate, fnd_api.g_miss_date) <> nvl(l_rtgRevDate, fnd_api.g_miss_date)*/

309: and wip_entity_id = p_wipEntityID;
310:
311: if ( /*Fix for bug 5020741. Routing should be exploded if any relevant feild is not null.
312: nvl(p_altRouting, fnd_api.g_miss_char) <> nvl(l_altRtg, fnd_api.g_miss_char) or
313: nvl(p_routingRevDate, fnd_api.g_miss_date) <> nvl(l_rtgRevDate, fnd_api.g_miss_date)*/
314: --Bug 5464449:Comparision of routing info is fixed
315: --p_altRouting IS NOT NULL or
316: --p_routingRevDate IS NOT NULL or
317: nvl(p_altRouting, nvl(l_altRtg,fnd_api.g_miss_char)) <> nvl(l_altRtg, fnd_api.g_miss_char) or

Line 317: nvl(p_altRouting, nvl(l_altRtg,fnd_api.g_miss_char)) <> nvl(l_altRtg, fnd_api.g_miss_char) or

313: nvl(p_routingRevDate, fnd_api.g_miss_date) <> nvl(l_rtgRevDate, fnd_api.g_miss_date)*/
314: --Bug 5464449:Comparision of routing info is fixed
315: --p_altRouting IS NOT NULL or
316: --p_routingRevDate IS NOT NULL or
317: nvl(p_altRouting, nvl(l_altRtg,fnd_api.g_miss_char)) <> nvl(l_altRtg, fnd_api.g_miss_char) or
318: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
319: --Bug 5464449:End of changes
320: (l_jobType = wip_constants.nonstandard and
321: nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then

Line 318: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR

314: --Bug 5464449:Comparision of routing info is fixed
315: --p_altRouting IS NOT NULL or
316: --p_routingRevDate IS NOT NULL or
317: nvl(p_altRouting, nvl(l_altRtg,fnd_api.g_miss_char)) <> nvl(l_altRtg, fnd_api.g_miss_char) or
318: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
319: --Bug 5464449:End of changes
320: (l_jobType = wip_constants.nonstandard and
321: nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
322: l_expRtgRequired := true;

Line 328: nvl(p_altBom, fnd_api.g_miss_char) <> nvl(l_altBom, fnd_api.g_miss_char) or

324: l_expRtgRequired := false;
325: end if;
326:
327: if ( /* Fix for bug 5020741. Bom should be exploded if any relevant feild is not null.
328: nvl(p_altBom, fnd_api.g_miss_char) <> nvl(l_altBom, fnd_api.g_miss_char) or
329: nvl(p_bomRevDate, fnd_api.g_miss_date) <> nvl(l_bomRevDate, fnd_api.g_miss_date)*/
330: --Bug 5464449:Comparision of bom info is fixed
331: --p_altBom IS NOT NULL or
332: --p_bomRevDate IS NOT NULL or

Line 329: nvl(p_bomRevDate, fnd_api.g_miss_date) <> nvl(l_bomRevDate, fnd_api.g_miss_date)*/

325: end if;
326:
327: if ( /* Fix for bug 5020741. Bom should be exploded if any relevant feild is not null.
328: nvl(p_altBom, fnd_api.g_miss_char) <> nvl(l_altBom, fnd_api.g_miss_char) or
329: nvl(p_bomRevDate, fnd_api.g_miss_date) <> nvl(l_bomRevDate, fnd_api.g_miss_date)*/
330: --Bug 5464449:Comparision of bom info is fixed
331: --p_altBom IS NOT NULL or
332: --p_bomRevDate IS NOT NULL or
333: nvl(p_altBom, nvl(l_altBom, fnd_api.g_miss_char)) <> nvl(l_altBom, fnd_api.g_miss_char) or

Line 333: nvl(p_altBom, nvl(l_altBom, fnd_api.g_miss_char)) <> nvl(l_altBom, fnd_api.g_miss_char) or

329: nvl(p_bomRevDate, fnd_api.g_miss_date) <> nvl(l_bomRevDate, fnd_api.g_miss_date)*/
330: --Bug 5464449:Comparision of bom info is fixed
331: --p_altBom IS NOT NULL or
332: --p_bomRevDate IS NOT NULL or
333: nvl(p_altBom, nvl(l_altBom, fnd_api.g_miss_char)) <> nvl(l_altBom, fnd_api.g_miss_char) or
334: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
335: --Bug 5464449:End of changes
336: (l_jobType = wip_constants.nonstandard and
337: nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then

Line 334: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or

330: --Bug 5464449:Comparision of bom info is fixed
331: --p_altBom IS NOT NULL or
332: --p_bomRevDate IS NOT NULL or
333: nvl(p_altBom, nvl(l_altBom, fnd_api.g_miss_char)) <> nvl(l_altBom, fnd_api.g_miss_char) or
334: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
335: --Bug 5464449:End of changes
336: (l_jobType = wip_constants.nonstandard and
337: nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
338: l_expBomRequired := true;

Line 353: raise fnd_api.g_exc_unexpected_error;

349: if ( p_schedulingMethod = wip_constants.routing ) then
350: if ( (p_startDate is null and p_endDate is null) or
351: (p_startDate is not null and p_endDate is not null) ) then
352: x_errorMsg := 'Must only provide one of the p_startDate and p_endDate for routing based scheduling';
353: raise fnd_api.g_exc_unexpected_error;
354: else
355: -- populate some value and then we will reschedule it later on.
356: l_startDate := nvl(p_startDate, p_endDate);
357: l_endDate := l_startDate;

Line 362: raise fnd_api.g_exc_unexpected_error;

358: end if;
359: else
360: if (p_schedulingMethod = wip_constants.ml_manual and (p_startDate is null or p_endDate is null) ) then
361: x_errorMsg := 'Must provide both of the dates if it is not routing based scheduling';
362: raise fnd_api.g_exc_unexpected_error;
363: end if;
364: l_startDate := p_startDate;
365: l_endDate := p_endDate;
366: end if;

Line 411: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

407: p_endDate => l_endDate,
408: x_serStartOp => l_serStartOp,
409: x_returnStatus => x_returnStatus,
410: x_errorMsg => x_errorMsg);
411: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
412: raise fnd_api.g_exc_unexpected_error;
413: end if;
414: end if;
415: /* fix bug 5238435. Move the scheduler call outside the if condition since job can be

Line 412: raise fnd_api.g_exc_unexpected_error;

408: x_serStartOp => l_serStartOp,
409: x_returnStatus => x_returnStatus,
410: x_errorMsg => x_errorMsg);
411: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
412: raise fnd_api.g_exc_unexpected_error;
413: end if;
414: end if;
415: /* fix bug 5238435. Move the scheduler call outside the if condition since job can be
416: rescheduled even without exploding the routing when user just changes the dates */

Line 427: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

423: p_endDate => p_endDate,
424: p_quantity => p_qty, --- Added for bug 5440007
425: x_returnStatus => x_returnStatus,
426: x_errorMsg => x_errorMsg);
427: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
428: raise fnd_api.g_exc_unexpected_error;
429: end if;
430:
431: select wdj.scheduled_start_date,

Line 428: raise fnd_api.g_exc_unexpected_error;

424: p_quantity => p_qty, --- Added for bug 5440007
425: x_returnStatus => x_returnStatus,
426: x_errorMsg => x_errorMsg);
427: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
428: raise fnd_api.g_exc_unexpected_error;
429: end if;
430:
431: select wdj.scheduled_start_date,
432: wdj.scheduled_completion_date

Line 494: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

490: p_taskID => p_taskID,
491: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
492: x_returnStatus => x_returnStatus,
493: x_errorMsg => x_errorMsg);
494: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
495: raise fnd_api.g_exc_unexpected_error;
496: end if;
497: end if;
498:

Line 495: raise fnd_api.g_exc_unexpected_error;

491: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
492: x_returnStatus => x_returnStatus,
493: x_errorMsg => x_errorMsg);
494: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
495: raise fnd_api.g_exc_unexpected_error;
496: end if;
497: end if;
498:
499: -- for bug 3041013

Line 518: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

514: p_wipEntityID => p_wipEntityID,
515: p_qty => p_qty,
516: x_returnStatus => x_returnStatus,
517: x_errorMsg => x_errorMsg);
518: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
519: raise fnd_api.g_exc_unexpected_error;
520: end if;
521: end if; --End of check on p_allowExplosion.
522: if ( p_schedulingMethod = wip_constants.routing ) then

Line 519: raise fnd_api.g_exc_unexpected_error;

515: p_qty => p_qty,
516: x_returnStatus => x_returnStatus,
517: x_errorMsg => x_errorMsg);
518: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
519: raise fnd_api.g_exc_unexpected_error;
520: end if;
521: end if; --End of check on p_allowExplosion.
522: if ( p_schedulingMethod = wip_constants.routing ) then
523: wip_infinite_scheduler_pvt.schedule(

Line 531: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

527: p_endDate => p_endDate,
528: p_quantity => p_qty,
529: x_returnStatus => x_returnStatus,
530: x_errorMsg => x_errorMsg);
531: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
532: raise fnd_api.g_exc_unexpected_error;
533: end if;
534: else
535: update wip_operations

Line 532: raise fnd_api.g_exc_unexpected_error;

528: p_quantity => p_qty,
529: x_returnStatus => x_returnStatus,
530: x_errorMsg => x_errorMsg);
531: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
532: raise fnd_api.g_exc_unexpected_error;
533: end if;
534: else
535: update wip_operations
536: set first_unit_start_date = p_startDate,

Line 576: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

572: x_returnStatus => l_retStatus);
573: end if;
574: exception
575: when others then
576: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
577: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
578: p_procedure_name => l_procName,
579: p_error_text => x_errorMsg);
580: if(l_logLevel <= wip_constants.trace_logging) then