DBA Data[Home] [Help]

APPS.WIP_CFMPROC_PRIV dependencies on FND_API

Line 27: x_returnStatus := fnd_api.g_ret_sts_success;

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

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

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

Line 38: raise fnd_api.g_exc_unexpected_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 193: x_returnStatus := fnd_api.g_ret_sts_error;

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

Line 204: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 236: x_returnStatus := fnd_api.g_ret_sts_success;

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

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

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

Line 249: raise fnd_api.g_exc_unexpected_error;

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

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

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

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

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

Line 270: p_initMsgList => fnd_api.g_true,

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

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

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

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

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

Line 278: p_initMsgList => fnd_api.g_true,

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

Line 280: p_destroyQtyTrees => fnd_api.g_true,

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

Line 281: p_endDebug => fnd_api.g_false,

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

Line 287: p_processLpn => fnd_api.g_true,

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

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

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

Line 297: p_delete_stack => fnd_api.g_false);

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