DBA Data[Home] [Help]

APPS.WIP_CFMPROC_PRIV dependencies on FND_API

Line 26: x_returnStatus := fnd_api.g_ret_sts_success;

22: l_msgData varchar2(2000);
23: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
24: begin
25:
26: x_returnStatus := fnd_api.g_ret_sts_success;
27:
28: if (l_logLevel <= wip_constants.trace_logging) then
29: l_params(1).paramName := 'p_initMsgList';
30: l_params(1).paramValue := p_initMsgList;

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

32: l_params(2).paramValue := p_txnTempID;
33: wip_logger.entryPoint(p_procName => 'wip_cfmProc_priv.processTemp',
34: p_params => l_params,
35: x_returnStatus => x_returnStatus);
36: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
37: raise fnd_api.g_exc_unexpected_error;
38: end if;
39: end if;
40:

Line 37: raise fnd_api.g_exc_unexpected_error;

33: wip_logger.entryPoint(p_procName => 'wip_cfmProc_priv.processTemp',
34: p_params => l_params,
35: x_returnStatus => x_returnStatus);
36: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
37: raise fnd_api.g_exc_unexpected_error;
38: end if;
39: end if;
40:
41: if(fnd_api.to_boolean(p_initMsgList)) then

Line 41: if(fnd_api.to_boolean(p_initMsgList)) then

37: raise fnd_api.g_exc_unexpected_error;
38: end if;
39: end if;
40:
41: if(fnd_api.to_boolean(p_initMsgList)) then
42: fnd_msg_pub.initialize;
43: end if;
44:
45: -- set a save point

Line 73: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

69: -- transactions and material transactions.
70:
71: wip_flowUtil_priv.createFlowSchedule(p_txnTempID,
72: l_returnStatus);
73: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
74: raise processing_exception;
75: end if;
76: */
77: -- Step 2:

Line 88: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

84: p_txnTempID,
85: l_returnStatus,
86: l_msgCount,
87: l_msgData);
88: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
89: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
90: fnd_message.set_token('MESSAGE', l_msgData);
91: fnd_msg_pub.add;
92: raise processing_exception;

Line 101: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

97: -- Explode the Routing and insert the resource and overhead charge
98: -- information into WCTI.
99: wip_flowResCharge.chargeResourceAndOverhead(p_txnTempID,
100: l_returnStatus);
101: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
102: raise processing_exception;
103: end if;
104:
105:

Line 110: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

106: -- Step 4:
107: -- Update the flow schedule
108: wip_flowUtil_priv.updateFlowSchedule(p_txnTempID,
109: l_returnStatus);
110: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
111: raise processing_exception;
112: end if;
113:
114:

Line 138: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then

134: 'with status ' || l_returnStatus,
135: x_returnStatus => l_returnStatus);
136: end if;
137:
138: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
139: raise processing_exception;
140: end if;
141: end if;
142:

Line 190: x_returnStatus := fnd_api.g_ret_sts_error;

186: end if;
187:
188: exception
189: when processing_exception then
190: x_returnStatus := fnd_api.g_ret_sts_error;
191: rollback to wip_cfmproc_s0;
192: wip_flowUtil_priv.setMmttError(p_txnTempID,
193: 'Processing Error');
194: if (l_logLevel <= wip_constants.trace_logging) then

Line 201: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

197: p_msg => 'Request failed!',
198: x_returnStatus => l_returnStatus); --discard logging return status
199: end if;
200: when others then
201: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
202: rollback to wip_cfmproc_s0;
203: wip_flowUtil_priv.setMmttError(p_txnTempID,
204: 'Unexpected Error');
205: if (l_logLevel <= wip_constants.trace_logging) then

Line 233: x_returnStatus := fnd_api.g_ret_sts_success;

229: begin
230:
231: savepoint wip_cfmproc_s100;
232:
233: x_returnStatus := fnd_api.g_ret_sts_success;
234:
235: if (l_logLevel <= wip_constants.trace_logging) then
236: l_params(1).paramName := 'p_txnHdrID';
237: l_params(1).paramValue := p_txnHdrID;

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

241: l_params(3).paramValue := p_processInv;
242: wip_logger.entryPoint(p_procName => 'wip_cfmProc_priv.processMobile',
243: p_params => l_params,
244: x_returnStatus => x_returnStatus);
245: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248: end if;
249:

Line 246: raise fnd_api.g_exc_unexpected_error;

242: wip_logger.entryPoint(p_procName => 'wip_cfmProc_priv.processMobile',
243: p_params => l_params,
244: x_returnStatus => x_returnStatus);
245: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
246: raise fnd_api.g_exc_unexpected_error;
247: end if;
248: end if;
249:
250: --need to create the flow schedule, this also updates component records

Line 252: if(fnd_api.to_boolean(p_processInv)) then

248: end if;
249:
250: --need to create the flow schedule, this also updates component records
251: --so they have the proper transaction_source_id
252: if(fnd_api.to_boolean(p_processInv)) then
253: --create the flow schedule from MTI
254: wip_flowUtil_priv.createFlowSchedule(p_txnInterfaceID => p_txnTmpID,
255: x_returnStatus => x_returnStatus,
256: x_wipEntityID => l_wipEntityID);

Line 264: if(x_returnStatus = fnd_api.g_ret_sts_success) then

260: x_returnStatus => x_returnStatus,
261: x_wipEntityID => l_wipEntityID);
262: end if;
263:
264: if(x_returnStatus = fnd_api.g_ret_sts_success) then
265: --move assy and component records to MMTT
266: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_txnHdrID,
267: p_initMsgList => fnd_api.g_true,
268: x_returnStatus => x_returnStatus);

Line 267: p_initMsgList => fnd_api.g_true,

263:
264: if(x_returnStatus = fnd_api.g_ret_sts_success) then
265: --move assy and component records to MMTT
266: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_txnHdrID,
267: p_initMsgList => fnd_api.g_true,
268: x_returnStatus => x_returnStatus);
269: end if;
270:
271: if(x_returnStatus = fnd_api.g_ret_sts_success) then

Line 271: if(x_returnStatus = fnd_api.g_ret_sts_success) then

267: p_initMsgList => fnd_api.g_true,
268: x_returnStatus => x_returnStatus);
269: end if;
270:
271: if(x_returnStatus = fnd_api.g_ret_sts_success) then
272: -- process the request
273: if(fnd_api.to_boolean(p_processInv)) then
274: wip_mtlTempProc_priv.processTemp(p_txnHdrID => p_txnHdrID,
275: p_initMsgList => fnd_api.g_true,

Line 273: if(fnd_api.to_boolean(p_processInv)) then

269: end if;
270:
271: if(x_returnStatus = fnd_api.g_ret_sts_success) then
272: -- process the request
273: if(fnd_api.to_boolean(p_processInv)) then
274: wip_mtlTempProc_priv.processTemp(p_txnHdrID => p_txnHdrID,
275: p_initMsgList => fnd_api.g_true,
276: p_txnMode => wip_constants.online,
277: p_destroyQtyTrees => fnd_api.g_true,

Line 275: p_initMsgList => fnd_api.g_true,

271: if(x_returnStatus = fnd_api.g_ret_sts_success) then
272: -- process the request
273: if(fnd_api.to_boolean(p_processInv)) then
274: wip_mtlTempProc_priv.processTemp(p_txnHdrID => p_txnHdrID,
275: p_initMsgList => fnd_api.g_true,
276: p_txnMode => wip_constants.online,
277: p_destroyQtyTrees => fnd_api.g_true,
278: p_endDebug => fnd_api.g_false,
279: x_returnStatus => x_returnStatus,

Line 277: p_destroyQtyTrees => fnd_api.g_true,

273: if(fnd_api.to_boolean(p_processInv)) then
274: wip_mtlTempProc_priv.processTemp(p_txnHdrID => p_txnHdrID,
275: p_initMsgList => fnd_api.g_true,
276: p_txnMode => wip_constants.online,
277: p_destroyQtyTrees => fnd_api.g_true,
278: p_endDebug => fnd_api.g_false,
279: x_returnStatus => x_returnStatus,
280: x_errorMsg => x_errorMessage);
281: else

Line 278: p_endDebug => fnd_api.g_false,

274: wip_mtlTempProc_priv.processTemp(p_txnHdrID => p_txnHdrID,
275: p_initMsgList => fnd_api.g_true,
276: p_txnMode => wip_constants.online,
277: p_destroyQtyTrees => fnd_api.g_true,
278: p_endDebug => fnd_api.g_false,
279: x_returnStatus => x_returnStatus,
280: x_errorMsg => x_errorMessage);
281: else
282: --only do wip processing

Line 284: p_processLpn => fnd_api.g_true,

280: x_errorMsg => x_errorMessage);
281: else
282: --only do wip processing
283: wip_mtlTempProc_priv.processWIP(p_txnTmpID => p_txnTmpID,
284: p_processLpn => fnd_api.g_true,
285: x_returnStatus => x_returnStatus,
286: x_errorMsg => x_errorMessage);
287: end if;
288: end if;

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

287: end if;
288: end if;
289:
290: --if validateInterfaceTxns or processing errors...
291: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
292: if(x_errorMessage is null) then
293: wip_utilities.get_message_stack(p_msg => x_errorMessage,
294: p_delete_stack => fnd_api.g_false);
295: end if;

Line 294: p_delete_stack => fnd_api.g_false);

290: --if validateInterfaceTxns or processing errors...
291: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
292: if(x_errorMessage is null) then
293: wip_utilities.get_message_stack(p_msg => x_errorMessage,
294: p_delete_stack => fnd_api.g_false);
295: end if;
296: if (l_logLevel <= wip_constants.trace_logging) then
297: wip_logger.exitPoint(p_procName => 'wip_cfmProc_priv.processMobile',
298: p_procReturnStatus => x_returnStatus,