DBA Data[Home] [Help]

APPS.WIP_DISCRETE_WS_MOVE dependencies on FND_API

Line 56: x_returnStatus := fnd_api.g_ret_sts_error;

52: if (periodID = -1 or periodID = 0) then
53: fnd_message.set_name(
54: application => 'INV',
55: name => 'INV_NO_OPEN_PERIOD');
56: x_returnStatus := fnd_api.g_ret_sts_error;
57: x_errMessage := fnd_message.get;
58: return;
59: end if;
60:

Line 113: x_returnStatus := fnd_api.g_ret_sts_success;

109: l_returnStatus VARCHAR2(1);
110: l_logLevel NUMBER;
111: l_params wip_logger.param_tbl_t;
112: begin
113: x_returnStatus := fnd_api.g_ret_sts_success;
114: l_totalNum := 0;
115: l_logLevel := to_number(fnd_log.g_current_runtime_level);
116: savepoint dsmove1;
117:

Line 252: p_addMsgToStack => fnd_api.g_true,

248: -- process online move transactions
249: if ( moveData.compHeaderID is not null ) then
250: wip_mtlTempProc_priv.validateInterfaceTxns(
251: p_txnHdrID => moveData.compHeaderID,
252: p_addMsgToStack => fnd_api.g_true,
253: p_rollbackOnErr => fnd_api.g_true,
254: x_returnStatus => l_returnStatus);
255: end if;
256:

Line 253: p_rollbackOnErr => fnd_api.g_true,

249: if ( moveData.compHeaderID is not null ) then
250: wip_mtlTempProc_priv.validateInterfaceTxns(
251: p_txnHdrID => moveData.compHeaderID,
252: p_addMsgToStack => fnd_api.g_true,
253: p_rollbackOnErr => fnd_api.g_true,
254: x_returnStatus => l_returnStatus);
255: end if;
256:
257: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then

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

253: p_rollbackOnErr => fnd_api.g_true,
254: x_returnStatus => l_returnStatus);
255: end if;
256:
257: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
258: x_returnStatus := fnd_api.g_ret_sts_error;
259: wip_utilities.get_message_stack(p_msg => x_errMessage);
260: return;
261: end if;

Line 258: x_returnStatus := fnd_api.g_ret_sts_error;

254: x_returnStatus => l_returnStatus);
255: end if;
256:
257: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
258: x_returnStatus := fnd_api.g_ret_sts_error;
259: wip_utilities.get_message_stack(p_msg => x_errMessage);
260: return;
261: end if;
262:

Line 266: p_addMsgToStack => fnd_api.g_true,

262:
263: if ( moveData.assyHeaderID is not null AND moveData.assyHeaderID <> moveData.compHeaderID ) then
264: wip_mtlTempProc_priv.validateInterfaceTxns(
265: p_txnHdrID => moveData.assyHeaderID,
266: p_addMsgToStack => fnd_api.g_true,
267: p_rollbackOnErr => fnd_api.g_true,
268: x_returnStatus => l_returnStatus);
269: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
270: x_returnStatus := fnd_api.g_ret_sts_error;

Line 267: p_rollbackOnErr => fnd_api.g_true,

263: if ( moveData.assyHeaderID is not null AND moveData.assyHeaderID <> moveData.compHeaderID ) then
264: wip_mtlTempProc_priv.validateInterfaceTxns(
265: p_txnHdrID => moveData.assyHeaderID,
266: p_addMsgToStack => fnd_api.g_true,
267: p_rollbackOnErr => fnd_api.g_true,
268: x_returnStatus => l_returnStatus);
269: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
270: x_returnStatus := fnd_api.g_ret_sts_error;
271: wip_utilities.get_message_stack(p_msg => x_errMessage);

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

265: p_txnHdrID => moveData.assyHeaderID,
266: p_addMsgToStack => fnd_api.g_true,
267: p_rollbackOnErr => fnd_api.g_true,
268: x_returnStatus => l_returnStatus);
269: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
270: x_returnStatus := fnd_api.g_ret_sts_error;
271: wip_utilities.get_message_stack(p_msg => x_errMessage);
272: return;
273: end if;

Line 270: x_returnStatus := fnd_api.g_ret_sts_error;

266: p_addMsgToStack => fnd_api.g_true,
267: p_rollbackOnErr => fnd_api.g_true,
268: x_returnStatus => l_returnStatus);
269: if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
270: x_returnStatus := fnd_api.g_ret_sts_error;
271: wip_utilities.get_message_stack(p_msg => x_errMessage);
272: return;
273: end if;
274: end if;

Line 283: p_endDebug => fnd_api.g_true,

279: p_time_out => 0,
280: p_move_mode => WIP_CONSTANTS.ONLINE,
281: p_bf_mode => WIP_CONSTANTS.ONLINE,
282: p_mtl_mode => moveData.mtlMode,
283: p_endDebug => fnd_api.g_true,
284: p_initMsgList => fnd_api.g_true,
285: p_insertAssy => fnd_api.g_false,
286: p_do_backflush => fnd_api.g_false,
287: p_assy_header_id => moveData.assyHeaderID,

Line 284: p_initMsgList => fnd_api.g_true,

280: p_move_mode => WIP_CONSTANTS.ONLINE,
281: p_bf_mode => WIP_CONSTANTS.ONLINE,
282: p_mtl_mode => moveData.mtlMode,
283: p_endDebug => fnd_api.g_true,
284: p_initMsgList => fnd_api.g_true,
285: p_insertAssy => fnd_api.g_false,
286: p_do_backflush => fnd_api.g_false,
287: p_assy_header_id => moveData.assyHeaderID,
288: p_mtl_header_id => moveData.compHeaderID,

Line 285: p_insertAssy => fnd_api.g_false,

281: p_bf_mode => WIP_CONSTANTS.ONLINE,
282: p_mtl_mode => moveData.mtlMode,
283: p_endDebug => fnd_api.g_true,
284: p_initMsgList => fnd_api.g_true,
285: p_insertAssy => fnd_api.g_false,
286: p_do_backflush => fnd_api.g_false,
287: p_assy_header_id => moveData.assyHeaderID,
288: p_mtl_header_id => moveData.compHeaderID,
289: x_returnStatus => x_returnStatus);

Line 286: p_do_backflush => fnd_api.g_false,

282: p_mtl_mode => moveData.mtlMode,
283: p_endDebug => fnd_api.g_true,
284: p_initMsgList => fnd_api.g_true,
285: p_insertAssy => fnd_api.g_false,
286: p_do_backflush => fnd_api.g_false,
287: p_assy_header_id => moveData.assyHeaderID,
288: p_mtl_header_id => moveData.compHeaderID,
289: x_returnStatus => x_returnStatus);
290: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

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

286: p_do_backflush => fnd_api.g_false,
287: p_assy_header_id => moveData.assyHeaderID,
288: p_mtl_header_id => moveData.compHeaderID,
289: x_returnStatus => x_returnStatus);
290: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
291: wip_utilities.get_message_stack(p_msg => x_errMessage);
292: rollback to dsmove1;
293: end if;
294:

Line 296: when fnd_api.g_exc_unexpected_error THEN

292: rollback to dsmove1;
293: end if;
294:
295: exception
296: when fnd_api.g_exc_unexpected_error THEN
297: rollback to dsmove1;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: wip_utilities.get_message_stack(p_msg => x_errMessage);
300: if (l_logLevel <= wip_constants.trace_logging) then

Line 298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

294:
295: exception
296: when fnd_api.g_exc_unexpected_error THEN
297: rollback to dsmove1;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: wip_utilities.get_message_stack(p_msg => x_errMessage);
300: if (l_logLevel <= wip_constants.trace_logging) then
301: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
302: p_procReturnStatus => x_returnStatus,

Line 309: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

305: end if;
306:
307: when others then
308: rollback to dsmove1;
309: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
310: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
311: fnd_message.set_token ('PROCEDURE', 'wip_discrete_ws_move.processMove');
312: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
313: x_errMessage := fnd_message.get;

Line 380: x_returnStatus := fnd_api.g_ret_sts_success;

376:
377: l_max_rem_primary_qty number;
378: l_inv_primary_rsv_quantity number;
379: begin
380: x_returnStatus := fnd_api.g_ret_sts_success;
381: l_wsh_minmax_in_rec.api_version_number := 1.0;
382: l_wsh_minmax_in_rec.source_code := 'OE';--Fix for Bug 4635597
383: l_wsh_minmax_in_rec.line_id := p_orderLineID;
384:

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

389: x_return_status => x_returnStatus,
390: x_msg_count => l_msg_count,
391: x_msg_data => l_msg_data);
392:
393: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
394: fnd_message.set_name(application => 'WIP',
395: name => 'WIP_WSH_MINMAX_API_FAILURE');
396: fnd_message.set_token(token => 'ENTITY1',
397: value => substr(l_msg_data, 1, 250),

Line 420: x_returnStatus := fnd_api.g_ret_sts_error;

416: and organization_id = p_orgID
417: and supply_source_type_id = 13;
418:
419: if ( p_primaryQty > l_max_rem_primary_qty - l_inv_primary_rsv_quantity ) then
420: x_returnStatus := fnd_api.g_ret_sts_error;
421: fnd_message.set_name('WIP', 'WIP_OSHP_TOLERANCE_FAIL');
422: x_errMessage := fnd_message.get;
423: end if;
424: