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: /* -- Bug 11893957. Call Infinite Scheduler after BOM Explosion to consider resources from Phantom Routings.

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: /* -- Bug 11893957. Call Infinite Scheduler after BOM Explosion to consider resources from Phantom Routings.
135: if ( p_schedulingMethod = wip_constants.routing ) then

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

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

Line 144: raise fnd_api.g_exc_unexpected_error;

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

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

169: p_taskID => p_taskID,
170: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
171: x_returnStatus => x_returnStatus,
172: x_errorMsg => x_errorMsg);
173: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
174: raise fnd_api.g_exc_unexpected_error;
175: end if;
176:
177: -- Bug 11893957. Call Infinite Scheduler after BOM Explosion to consider resources from Phantom Routings.

Line 174: raise fnd_api.g_exc_unexpected_error;

170: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
171: x_returnStatus => x_returnStatus,
172: x_errorMsg => x_errorMsg);
173: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
174: raise fnd_api.g_exc_unexpected_error;
175: end if;
176:
177: -- Bug 11893957. Call Infinite Scheduler after BOM Explosion to consider resources from Phantom Routings.
178: if ( p_schedulingMethod = wip_constants.routing ) then

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

182: p_startDate => p_startDate,
183: p_endDate => p_endDate,
184: x_returnStatus => x_returnStatus,
185: x_errorMsg => x_errorMsg);
186: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
187: raise fnd_api.g_exc_unexpected_error;
188: end if;
189:
190: -- need to adjust the data required field

Line 187: raise fnd_api.g_exc_unexpected_error;

183: p_endDate => p_endDate,
184: x_returnStatus => x_returnStatus,
185: x_errorMsg => x_errorMsg);
186: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
187: raise fnd_api.g_exc_unexpected_error;
188: end if;
189:
190: -- need to adjust the data required field
191: update wip_requirement_operations wro

Line 219: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

215: x_returnStatus => l_retStatus);
216: end if;
217: exception
218: when others then
219: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
220: -- Fixed for bug 5255226
221: -- Don't need to add the x_errormsg again to stack by calling fnd_msg_pub.add_exc_msg
222: -- Removed this API call. Instead adding this error message to debug log using
223: if (l_logLevel <= wip_constants.trace_logging) then

Line 308: x_returnStatus := fnd_api.g_ret_sts_success;

304: and operation_seq_num < 0
305: and wip_supply_type = wip_constants.phantom;
306: begin
307:
308: x_returnStatus := fnd_api.g_ret_sts_success;
309: if (l_logLevel <= wip_constants.trace_logging) then
310: l_params(1).paramName := 'p_orgID';
311: l_params(1).paramValue := p_orgID;
312: l_params(2).paramName := 'p_wipEntityID';

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

313: l_params(2).paramValue := p_wipEntityID;
314: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
315: p_params => l_params,
316: x_returnStatus => x_returnStatus);
317: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
318: raise fnd_api.g_exc_unexpected_error;
319: end if;
320: end if;
321: l_inf_sch_flag := 0;

Line 318: raise fnd_api.g_exc_unexpected_error;

314: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
315: p_params => l_params,
316: x_returnStatus => x_returnStatus);
317: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
318: raise fnd_api.g_exc_unexpected_error;
319: end if;
320: end if;
321: l_inf_sch_flag := 0;
322: select job_type,

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

350: and wip_entity_id = p_wipEntityID;
351:
352: -- Bug 9834677. modified logic since forms will pass '@@@' for primary routings.
353: if ( nvl(p_altRouting, nvl(l_altRtg,'@@@')) <> nvl(l_altRtg, '@@@') or
354: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
355: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
356: nvl(p_routingRev, nvl(l_rtgRev, fnd_api.g_miss_char)) <> nvl(l_rtgRev, fnd_api.g_miss_char) OR
357: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
358: l_expRtgRequired := true;

Line 356: nvl(p_routingRev, nvl(l_rtgRev, fnd_api.g_miss_char)) <> nvl(l_rtgRev, fnd_api.g_miss_char) OR

352: -- Bug 9834677. modified logic since forms will pass '@@@' for primary routings.
353: if ( nvl(p_altRouting, nvl(l_altRtg,'@@@')) <> nvl(l_altRtg, '@@@') or
354: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
355: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
356: nvl(p_routingRev, nvl(l_rtgRev, fnd_api.g_miss_char)) <> nvl(l_rtgRev, fnd_api.g_miss_char) OR
357: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
358: l_expRtgRequired := true;
359: if (p_altRouting = '@@@' or p_altRouting = fnd_api.g_miss_char ) then
360: l_altRtg := null;

Line 359: if (p_altRouting = '@@@' or p_altRouting = fnd_api.g_miss_char ) then

355: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
356: nvl(p_routingRev, nvl(l_rtgRev, fnd_api.g_miss_char)) <> nvl(l_rtgRev, fnd_api.g_miss_char) OR
357: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
358: l_expRtgRequired := true;
359: if (p_altRouting = '@@@' or p_altRouting = fnd_api.g_miss_char ) then
360: l_altRtg := null;
361: else
362: l_altRtg := p_altRouting;
363: end if;

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

366: end if;
367:
368: -- Bug 9834677. modified logic since forms will pass '@@@' for primary bills.
369: if ( nvl(p_altBom, nvl(l_altBom, '@@@')) <> nvl(l_altBom, '@@@') or
370: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
371: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
372: nvl(p_bomRev, nvl(l_bomRev, fnd_api.g_miss_char)) <> nvl(l_bomRev, fnd_api.g_miss_char) OR
373: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
374: l_expBomRequired := true;

Line 372: nvl(p_bomRev, nvl(l_bomRev, fnd_api.g_miss_char)) <> nvl(l_bomRev, fnd_api.g_miss_char) OR

368: -- Bug 9834677. modified logic since forms will pass '@@@' for primary bills.
369: if ( nvl(p_altBom, nvl(l_altBom, '@@@')) <> nvl(l_altBom, '@@@') or
370: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
371: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
372: nvl(p_bomRev, nvl(l_bomRev, fnd_api.g_miss_char)) <> nvl(l_bomRev, fnd_api.g_miss_char) OR
373: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
374: l_expBomRequired := true;
375: if (p_altBom = '@@@' or p_altBom = fnd_api.g_miss_char) then
376: l_altBom := null;

Line 375: if (p_altBom = '@@@' or p_altBom = fnd_api.g_miss_char) then

371: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
372: nvl(p_bomRev, nvl(l_bomRev, fnd_api.g_miss_char)) <> nvl(l_bomRev, fnd_api.g_miss_char) OR
373: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
374: l_expBomRequired := true;
375: if (p_altBom = '@@@' or p_altBom = fnd_api.g_miss_char) then
376: l_altBom := null;
377: else
378: l_altBom := p_altBom;
379: end if;

Line 395: raise fnd_api.g_exc_unexpected_error;

391: if ( p_schedulingMethod = wip_constants.routing ) then
392: if ( (p_startDate is null and p_endDate is null) or
393: (p_startDate is not null and p_endDate is not null) ) then
394: x_errorMsg := 'Must only provide one of the p_startDate and p_endDate for routing based scheduling';
395: raise fnd_api.g_exc_unexpected_error;
396: else
397: -- populate some value and then we will reschedule it later on.
398: l_startDate := nvl(p_startDate, p_endDate);
399: l_endDate := l_startDate;

Line 404: raise fnd_api.g_exc_unexpected_error;

400: end if;
401: else
402: if (p_schedulingMethod = wip_constants.ml_manual and (p_startDate is null or p_endDate is null) ) then
403: x_errorMsg := 'Must provide both of the dates if it is not routing based scheduling';
404: raise fnd_api.g_exc_unexpected_error;
405: end if;
406: l_startDate := p_startDate;
407: l_endDate := p_endDate;
408: end if;

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

474: p_endDate => l_endDate,
475: x_serStartOp => l_serStartOp,
476: x_returnStatus => x_returnStatus,
477: x_errorMsg => x_errorMsg);
478: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
479: raise fnd_api.g_exc_unexpected_error;
480: end if;
481: end if;
482:

Line 479: raise fnd_api.g_exc_unexpected_error;

475: x_serStartOp => l_serStartOp,
476: x_returnStatus => x_returnStatus,
477: x_errorMsg => x_errorMsg);
478: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
479: raise fnd_api.g_exc_unexpected_error;
480: end if;
481: end if;
482:
483: /* fix bug 5238435. Move the scheduler call outside the if condition since job can be

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

493: p_endDate => p_endDate,
494: p_quantity => p_qty, --- Added for bug 5440007
495: x_returnStatus => x_returnStatus,
496: x_errorMsg => x_errorMsg);
497: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
498: raise fnd_api.g_exc_unexpected_error;
499: end if;
500:
501: select wdj.scheduled_start_date,

Line 498: raise fnd_api.g_exc_unexpected_error;

494: p_quantity => p_qty, --- Added for bug 5440007
495: x_returnStatus => x_returnStatus,
496: x_errorMsg => x_errorMsg);
497: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
498: raise fnd_api.g_exc_unexpected_error;
499: end if;
500:
501: select wdj.scheduled_start_date,
502: wdj.scheduled_completion_date

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

594: p_taskID => p_taskID,
595: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
596: x_returnStatus => x_returnStatus,
597: x_errorMsg => x_errorMsg);
598: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
599: raise fnd_api.g_exc_unexpected_error;
600: end if;
601: end if;
602:

Line 599: raise fnd_api.g_exc_unexpected_error;

595: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
596: x_returnStatus => x_returnStatus,
597: x_errorMsg => x_errorMsg);
598: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
599: raise fnd_api.g_exc_unexpected_error;
600: end if;
601: end if;
602:
603: -- if it is only date changes or qty changes, then the flow should be here

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

611: p_wipEntityID => p_wipEntityID,
612: p_qty => p_qty,
613: x_returnStatus => x_returnStatus,
614: x_errorMsg => x_errorMsg);
615: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
616: raise fnd_api.g_exc_unexpected_error;
617: end if;
618: -- end if; --End of check on p_allowExplosion.
619: end if;

Line 616: raise fnd_api.g_exc_unexpected_error;

612: p_qty => p_qty,
613: x_returnStatus => x_returnStatus,
614: x_errorMsg => x_errorMsg);
615: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
616: raise fnd_api.g_exc_unexpected_error;
617: end if;
618: -- end if; --End of check on p_allowExplosion.
619: end if;
620: if ( p_schedulingMethod = wip_constants.routing ) then

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

625: p_endDate => p_endDate,
626: p_quantity => p_qty,
627: x_returnStatus => x_returnStatus,
628: x_errorMsg => x_errorMsg);
629: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
630: raise fnd_api.g_exc_unexpected_error;
631: end if;
632:
633: update wip_requirement_operations wro

Line 630: raise fnd_api.g_exc_unexpected_error;

626: p_quantity => p_qty,
627: x_returnStatus => x_returnStatus,
628: x_errorMsg => x_errorMsg);
629: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
630: raise fnd_api.g_exc_unexpected_error;
631: end if;
632:
633: update wip_requirement_operations wro
634: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)

Line 704: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

700: x_returnStatus => l_retStatus);
701: end if;
702: exception
703: when others then
704: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
705: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
706: p_procedure_name => l_procName,
707: p_error_text => SUBSTRB(x_errorMsg, 1,240));--bug 13608871
708: if(l_logLevel <= wip_constants.trace_logging) then