[Home] [Help]
31: p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
32: x_serStartOp out nocopy number,
33: x_returnStatus out nocopy varchar2,
34: x_errorMsg out nocopy varchar2) is
35: l_params wip_logger.param_tbl_t;
36: l_procName varchar2(30) := 'createJob';
37: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
38: l_retStatus varchar2(1);
39: l_msg varchar2(240);
76: l_params(15).paramName := 'p_rtgRefID';
77: l_params(15).paramValue := p_rtgRefID;
78: l_params(16).paramName := 'p_bomRefID';
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;
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);
189: end if;
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:
201: if(l_logLevel <= wip_constants.trace_logging) then
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);
206: end if;
236: p_allowExplosion in boolean,
237: p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
238: x_returnStatus out nocopy varchar2,
239: x_errorMsg out nocopy varchar2) is
240: l_params wip_logger.param_tbl_t;
241: l_procName varchar2(30) := 'reexplodeJob';
242: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
243: l_retStatus varchar2(1);
244: l_msg varchar2(240);
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;
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;
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,
449: x_repetitive_schedule_id => null,
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);
573: end if;
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);
585: end if;