DBA Data[Home] [Help]

APPS.WIP_MOVPROC_GRP dependencies on FND_API

Line 199: p_endDebug => fnd_api.g_false,

195: p_time_out => 0,
196: p_move_mode => l_move_mode,
197: p_bf_mode => WIP_CONSTANTS.ONLINE,
198: p_mtl_mode => p_mtlMode,
199: p_endDebug => fnd_api.g_false,
200: p_initMsgList => fnd_api.g_true,
201: p_insertAssy => fnd_api.g_true,
202: p_do_backflush => fnd_api.g_false,
203: p_cmp_txn_id => p_cplTxnID,

Line 200: p_initMsgList => fnd_api.g_true,

196: p_move_mode => l_move_mode,
197: p_bf_mode => WIP_CONSTANTS.ONLINE,
198: p_mtl_mode => p_mtlMode,
199: p_endDebug => fnd_api.g_false,
200: p_initMsgList => fnd_api.g_true,
201: p_insertAssy => fnd_api.g_true,
202: p_do_backflush => fnd_api.g_false,
203: p_cmp_txn_id => p_cplTxnID,
204: x_returnStatus => x_returnStatus);

Line 201: p_insertAssy => fnd_api.g_true,

197: p_bf_mode => WIP_CONSTANTS.ONLINE,
198: p_mtl_mode => p_mtlMode,
199: p_endDebug => fnd_api.g_false,
200: p_initMsgList => fnd_api.g_true,
201: p_insertAssy => fnd_api.g_true,
202: p_do_backflush => fnd_api.g_false,
203: p_cmp_txn_id => p_cplTxnID,
204: x_returnStatus => x_returnStatus);
205:

Line 202: p_do_backflush => fnd_api.g_false,

198: p_mtl_mode => p_mtlMode,
199: p_endDebug => fnd_api.g_false,
200: p_initMsgList => fnd_api.g_true,
201: p_insertAssy => fnd_api.g_true,
202: p_do_backflush => fnd_api.g_false,
203: p_cmp_txn_id => p_cplTxnID,
204: x_returnStatus => x_returnStatus);
205:
206: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 206: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

202: p_do_backflush => fnd_api.g_false,
203: p_cmp_txn_id => p_cplTxnID,
204: x_returnStatus => x_returnStatus);
205:
206: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
207: raise fnd_api.g_exc_error;
208: END IF;
209:
210: IF(fnd_api.to_boolean(p_commit)) THEN

Line 207: raise fnd_api.g_exc_error;

203: p_cmp_txn_id => p_cplTxnID,
204: x_returnStatus => x_returnStatus);
205:
206: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
207: raise fnd_api.g_exc_error;
208: END IF;
209:
210: IF(fnd_api.to_boolean(p_commit)) THEN
211: COMMIT;

Line 210: IF(fnd_api.to_boolean(p_commit)) THEN

206: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
207: raise fnd_api.g_exc_error;
208: END IF;
209:
210: IF(fnd_api.to_boolean(p_commit)) THEN
211: COMMIT;
212: END IF;
213:
214: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 222: WHEN fnd_api.g_exc_error THEN

218: x_returnStatus => l_returnStatus);
219: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
220: END IF;
221: EXCEPTION
222: WHEN fnd_api.g_exc_error THEN
223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
224:
225: IF(l_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
226: FOR l_errors IN c_errors(p_transaction_id => p_movTxnID) LOOP

Line 223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

219: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
220: END IF;
221: EXCEPTION
222: WHEN fnd_api.g_exc_error THEN
223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
224:
225: IF(l_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
226: FOR l_errors IN c_errors(p_transaction_id => p_movTxnID) LOOP
227: x_errorMsg := x_errorMsg || l_errors.error_column ||':' ||

Line 245: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

241: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
242: END IF;
243:
244: WHEN TOO_MANY_ROWS THEN
245: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
246: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
247: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
248: x_errorMsg := substr(fnd_message.get, 1, 1000);
249:

Line 259: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

255: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
256: END IF;
257:
258: WHEN NO_DATA_FOUND THEN
259: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
261: fnd_message.set_token('ENTITY',
262: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
263: x_errorMsg := substr(fnd_message.get, 1, 1000);

Line 274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

270: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
271: END IF;
272:
273: WHEN others THEN
274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
275: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
278: p_procReturnStatus => x_returnStatus,

Line 318: p_endDebug => fnd_api.g_false,

314: p_time_out => 0,
315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);

Line 319: p_initMsgList => fnd_api.g_true,

315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);
323:

Line 320: p_insertAssy => fnd_api.g_true,

316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);
323:
324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 321: p_do_backflush => fnd_api.g_true,

317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);
323:
324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
325: raise fnd_api.g_exc_error;

Line 324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);
323:
324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
325: raise fnd_api.g_exc_error;
326: END IF;
327:
328: IF(fnd_api.to_boolean(p_commit)) THEN

Line 325: raise fnd_api.g_exc_error;

321: p_do_backflush => fnd_api.g_true,
322: x_returnStatus => x_returnStatus);
323:
324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
325: raise fnd_api.g_exc_error;
326: END IF;
327:
328: IF(fnd_api.to_boolean(p_commit)) THEN
329: COMMIT;

Line 328: IF(fnd_api.to_boolean(p_commit)) THEN

324: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
325: raise fnd_api.g_exc_error;
326: END IF;
327:
328: IF(fnd_api.to_boolean(p_commit)) THEN
329: COMMIT;
330: END IF;
331:
332: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 341: WHEN fnd_api.g_exc_error THEN

337: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
338: END IF;
339: EXCEPTION
340:
341: WHEN fnd_api.g_exc_error THEN
342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
343:
344: IF (l_logLevel <= wip_constants.trace_logging) THEN
345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

Line 342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

338: END IF;
339: EXCEPTION
340:
341: WHEN fnd_api.g_exc_error THEN
342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
343:
344: IF (l_logLevel <= wip_constants.trace_logging) THEN
345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
346: p_procReturnStatus => x_returnStatus,

Line 353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

349: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
350: END IF;
351:
352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354:
355: IF (l_logLevel <= wip_constants.trace_logging) THEN
356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
357: p_procReturnStatus => x_returnStatus,