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 WIP_CONSTANTS

Line 47: if (l_logLevel <= wip_constants.trace_logging) then

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';
51: l_params(2).paramValue := p_wipEntityID;

Line 88: if ( p_schedulingMethod = wip_constants.routing ) then

84: raise fnd_api.g_exc_unexpected_error;
85: end if;
86: end if;
87:
88: if ( p_schedulingMethod = wip_constants.routing ) then
89: if ( (p_startDate is null and p_endDate is null) or
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

Line 92: p_jobType = wip_constants.standard) ) then

88: if ( p_schedulingMethod = wip_constants.routing ) then
89: if ( (p_startDate is null and p_endDate is null) or
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.

Line 110: if ( p_jobType = wip_constants.standard ) then

106: l_endDate := p_endDate;
107: end if;
108: end if;
109:
110: if ( p_jobType = wip_constants.standard ) then
111: l_rtgItemID := p_itemID;
112: l_bomItemID := p_itemID;
113: else
114: l_rtgItemID := p_rtgRefID;

Line 134: if ( p_schedulingMethod = wip_constants.routing ) then

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(
136: p_orgID => p_orgID,
137: p_wipEntityID => p_wipEntityID,
138: p_startDate => p_startDate,

Line 184: if (l_logLevel <= wip_constants.trace_logging) then

180: wip_op_resources_utilities.update_resource_instances(
181: p_wip_entity_id => p_wipEntityID,
182: p_org_id => p_orgID);
183:
184: if (l_logLevel <= wip_constants.trace_logging) then
185: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
186: p_procReturnStatus => x_returnStatus,
187: p_msg => 'success',
188: x_returnStatus => l_retStatus);

Line 196: if (l_logLevel <= wip_constants.trace_logging) 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
197: wip_logger.log(x_errorMsg,l_retstatus);
198: End if;
199: -- End of Fix for bug 5255226
200:

Line 201: if(l_logLevel <= wip_constants.trace_logging) then

197: wip_logger.log(x_errorMsg,l_retstatus);
198: End if;
199: -- End of Fix for bug 5255226
200:
201: if(l_logLevel <= wip_constants.trace_logging) then
202: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
203: p_procReturnStatus => x_returnStatus,
204: p_msg => x_errorMsg,
205: x_returnStatus => l_retStatus);

Line 272: and wip_supply_type = wip_constants.phantom;

268: from wip_requirement_operations
269: where organization_id = p_orgID
270: and wip_entity_id = p_wipEntityID
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

Line 276: if (l_logLevel <= wip_constants.trace_logging) then

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';
280: l_params(2).paramValue := p_wipEntityID;

Line 320: (l_jobType = wip_constants.nonstandard and

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;
323: else
324: l_expRtgRequired := false;

Line 336: (l_jobType = wip_constants.nonstandard and

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;
339: else
340: l_expBomRequired := false;

Line 344: if ( not p_allowExplosion or l_jobStatus <> wip_constants.unreleased ) then

340: l_expBomRequired := false;
341: end if;
342:
343: -- unless the job is unreleased, you can never explode again from bom
344: if ( not p_allowExplosion or l_jobStatus <> wip_constants.unreleased ) then
345: l_expRtgRequired := false;
346: l_expBomRequired := false;
347: end if;
348:

Line 349: if ( p_schedulingMethod = wip_constants.routing ) then

345: l_expRtgRequired := false;
346: l_expBomRequired := false;
347: end if;
348:
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;

Line 360: if (p_schedulingMethod = wip_constants.ml_manual and (p_startDate is null or p_endDate is null) ) then

356: l_startDate := nvl(p_startDate, p_endDate);
357: l_endDate := l_startDate;
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;

Line 392: if ( l_jobType = wip_constants.standard ) then

388: x_pk1_value => to_char(p_wipEntityID),
389: x_pk3_value => to_char(p_orgID),
390: x_delete_document_flag => 'Y');
391:
392: if ( l_jobType = wip_constants.standard ) then
393: l_rtgItemID := l_assemblyID;
394: else
395: l_rtgItemID := p_rtgRefID;
396: end if;

Line 418: if ( p_schedulingMethod = wip_constants.routing ) then

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 */
417:
418: if ( p_schedulingMethod = wip_constants.routing ) then
419: wip_infinite_scheduler_pvt.schedule(
420: p_orgID => p_orgID,
421: p_wipEntityID => p_wipEntityID,
422: p_startDate => p_startDate,

Line 444: if ( l_logLevel <= wip_constants.trace_logging ) then

440: -- after reexplode the routing, some op reference in WRO might be invalid. We need to set those
441: -- properly. We only need to do it if bom reexplosion is not required.
442: -- we also need to add the phantom resource back since it was deleted before
443: if ( l_expRtgRequired and not l_expBomRequired ) then
444: if ( l_logLevel <= wip_constants.trace_logging ) then
445: wip_logger.log('Resetting the op reference in WRO.....', l_retStatus);
446: end if;
447: wip_fix_req_ops_pkg.fix(x_wip_entity_id => p_wipEntityID,
448: x_organization_id => p_orgID,

Line 452: if ( l_usePhantomRouting = wip_constants.yes ) then

448: x_organization_id => p_orgID,
449: x_repetitive_schedule_id => null,
450: x_entity_start_date => l_startDate);
451: l_usePhantomRouting := wip_globals.use_phantom_routings(p_orgID);
452: if ( l_usePhantomRouting = wip_constants.yes ) then
453: for phan in c_phantoms loop
454: wip_explode_phantom_rtgs.explode_resources(
455: p_wip_entity_id => p_wipEntityID,
456: p_sched_id => null,

Line 458: p_entity_type => wip_constants.discrete,

454: wip_explode_phantom_rtgs.explode_resources(
455: p_wip_entity_id => p_wipEntityID,
456: p_sched_id => null,
457: p_org_id => p_orgID,
458: p_entity_type => wip_constants.discrete,
459: p_phantom_item_id => phan.inventory_item_id,
460: p_op_seq_num => phan.operation_seq_num,
461: p_rtg_rev_date => p_routingRevDate);
462: end loop;

Line 471: if ( l_jobType = wip_constants.standard ) then

467: delete from wip_requirement_operations
468: where wip_entity_id = p_wipEntityID
469: and organization_id = p_orgID;
470:
471: if ( l_jobType = wip_constants.standard ) then
472: l_bomItemID := l_assemblyID;
473: else
474: l_bomItemID := p_bomRefID;
475: end if;

Line 522: if ( p_schedulingMethod = wip_constants.routing ) then

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(
524: p_orgID => p_orgID,
525: p_wipEntityID => p_wipEntityID,
526: p_startDate => p_startDate,

Line 568: if (l_logLevel <= wip_constants.trace_logging) then

564: end if;
565:
566: end if;
567:
568: if (l_logLevel <= wip_constants.trace_logging) then
569: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
570: p_procReturnStatus => x_returnStatus,
571: p_msg => 'success',
572: x_returnStatus => l_retStatus);

Line 580: if(l_logLevel <= wip_constants.trace_logging) 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
581: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
582: p_procReturnStatus => x_returnStatus,
583: p_msg => x_errorMsg,
584: x_returnStatus => l_retStatus);