[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;
208: p_wip_entity_id => p_wipEntityID,
209: p_org_id => p_orgID);
210:
211: if (l_logLevel <= wip_constants.trace_logging) then
212: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
213: p_procReturnStatus => x_returnStatus,
214: p_msg => 'success',
215: x_returnStatus => l_retStatus);
216: end if;
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
224: wip_logger.log(x_errorMsg,l_retstatus);
225: End if;
226: -- End of Fix for bug 5255226
227:
228: if(l_logLevel <= wip_constants.trace_logging) then
225: End if;
226: -- End of Fix for bug 5255226
227:
228: if(l_logLevel <= wip_constants.trace_logging) then
229: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
230: p_procReturnStatus => x_returnStatus,
231: p_msg => x_errorMsg,
232: x_returnStatus => l_retStatus);
233: end if;
265: p_allowExplosion in boolean,
266: p_unitNumber in varchar2 DEFAULT '', /* added for bug 5332615 */
267: x_returnStatus out nocopy varchar2,
268: x_errorMsg out nocopy varchar2) is
269: l_params wip_logger.param_tbl_t;
270: l_procName varchar2(30) := 'reexplodeJob';
271: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
272: l_retStatus varchar2(1);
273: l_msg varchar2(240);
310: l_params(1).paramName := 'p_orgID';
311: l_params(1).paramValue := p_orgID;
312: l_params(2).paramName := 'p_wipEntityID';
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;
512: -- we also need to add the phantom resource back since it was deleted before
513:
514: if ( l_expRtgRequired and not l_expBomRequired ) then
515: if ( l_logLevel <= wip_constants.trace_logging ) then
516: wip_logger.log('Resetting the op reference in WRO.....', l_retStatus);
517: end if;
518: wip_fix_req_ops_pkg.fix(x_wip_entity_id => p_wipEntityID,
519: x_organization_id => p_orgID,
520: x_repetitive_schedule_id => null,
693: p_org_id => p_orgID);
694:
695:
696: if (l_logLevel <= wip_constants.trace_logging) then
697: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
698: p_procReturnStatus => x_returnStatus,
699: p_msg => 'success',
700: x_returnStatus => l_retStatus);
701: end if;
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
709: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
710: p_procReturnStatus => x_returnStatus,
711: p_msg => x_errorMsg,
712: x_returnStatus => l_retStatus);
713: end if;