DBA Data[Home] [Help]

APPS.WIP_EAMMTLPROC_PRIV dependencies on FND_API

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

19: l_params(1).paramValue := p_txnHdrID;
20: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.validateTxns',
21: p_params => l_params,
22: x_returnStatus => x_returnStatus);
23: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
24: raise fnd_api.g_exc_unexpected_error;
25: end if;
26: end if;
27: x_returnStatus := fnd_api.g_ret_sts_success;

Line 24: raise fnd_api.g_exc_unexpected_error;

20: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.validateTxns',
21: p_params => l_params,
22: x_returnStatus => x_returnStatus);
23: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
24: raise fnd_api.g_exc_unexpected_error;
25: end if;
26: end if;
27: x_returnStatus := fnd_api.g_ret_sts_success;
28:

Line 27: x_returnStatus := fnd_api.g_ret_sts_success;

23: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
24: raise fnd_api.g_exc_unexpected_error;
25: end if;
26: end if;
27: x_returnStatus := fnd_api.g_ret_sts_success;
28:
29:
30:
31: --rebuildable columns(rebuild_item_id, rebuild_serial_number, rebuild_activity_id, rebuild_job_name)

Line 361: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

357: x_returnStatus => l_returnStatus); --discard logging return status
358: end if;
359: exception
360: when others then
361: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
363: p_procedure_name => 'validateTxns',
364: p_error_text => SQLERRM);
365:

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

393: x_params => l_params);
394: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
395: p_params => l_params,
396: x_returnStatus => x_returnStatus);
397: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;
400: end if;
401: x_returnStatus := fnd_api.g_ret_sts_success;

Line 398: raise fnd_api.g_exc_unexpected_error;

394: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
395: p_params => l_params,
396: x_returnStatus => x_returnStatus);
397: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;
400: end if;
401: x_returnStatus := fnd_api.g_ret_sts_success;
402:

Line 401: x_returnStatus := fnd_api.g_ret_sts_success;

397: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;
400: end if;
401: x_returnStatus := fnd_api.g_ret_sts_success;
402:
403: if(p_compRec.eamItemType is null or
404: ((p_compRec.eamItemType <> wip_constants.rebuild_item_type) and
405: (p_compRec.eamItemType <> 1))) then

Line 460: x_returnStatus := fnd_api.g_ret_sts_success;

456: --insert the issued item into the asset's genealogy
457: if (l_logLevel <= wip_constants.full_logging) then
458: wip_logger.log('calling create gen', l_returnStatus);
459: end if;
460: x_returnStatus := fnd_api.g_ret_sts_success;
461:
462: if (l_logLevel <= wip_constants.full_logging) then
463: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
464: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);

Line 486: x_returnStatus := fnd_api.g_ret_sts_success;

482: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
483: if (l_logLevel <= wip_constants.full_logging) then
484: wip_logger.log('calling update gen', l_returnStatus);
485: end if;
486: x_returnStatus := fnd_api.g_ret_sts_success;
487: for i in 1..l_serialNumTbl.count loop
488: wip_eam_genealogy_pvt.update_eam_genealogy(p_api_version => 1.0,
489: p_object_type => 2, /* serial number */
490: p_serial_number => l_serialNumTbl(i),

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

500: wip_logger.log('upd gen returned: ' || x_returnStatus, l_returnStatus);
501: end if;
502: end if;
503:
504: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
505: l_errMsg := 'genealogy failed';
506: if(l_msgData is not null) then
507: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
508: fnd_message.set_token('MESSAGE', l_msgData);

Line 511: raise fnd_api.g_exc_unexpected_error;

507: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
508: fnd_message.set_token('MESSAGE', l_msgData);
509: fnd_msg_pub.add; --add the returned error message to the stack.
510: end if;
511: raise fnd_api.g_exc_unexpected_error;
512: end if;
513: end if;
514: end if; --For bug 6892336, we do not deal with genealogy for non-serial item
515:

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

523: ----------------------------------------------------------------------------------
524: eam_rebuild.create_rebuild_job(p_tempId => p_compRec.txnTmpID,
525: x_retVal => x_returnStatus,
526: x_errMsg => l_msgData);
527: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
528: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
529: fnd_message.set_token('MESSAGE', l_msgData);
530: fnd_msg_pub.add; --add the returned error message to the stack.
531: l_errMsg := 'rebuild job creation failed';

Line 532: raise fnd_api.g_exc_unexpected_error;

528: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
529: fnd_message.set_token('MESSAGE', l_msgData);
530: fnd_msg_pub.add; --add the returned error message to the stack.
531: l_errMsg := 'rebuild job creation failed';
532: raise fnd_api.g_exc_unexpected_error;
533: end if;
534: if (l_logLevel <= wip_constants.full_logging) then
535: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
536: end if;

Line 545: when fnd_api.g_exc_unexpected_error then

541: p_msg => 'procedure success.',
542: x_returnStatus => l_returnStatus); --discard logging return status
543: end if;
544: exception
545: when fnd_api.g_exc_unexpected_error then
546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
547: if (l_logLevel <= wip_constants.trace_logging) then
548: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
549: p_procReturnStatus => x_returnStatus,

Line 546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

542: x_returnStatus => l_returnStatus); --discard logging return status
543: end if;
544: exception
545: when fnd_api.g_exc_unexpected_error then
546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
547: if (l_logLevel <= wip_constants.trace_logging) then
548: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
549: p_procReturnStatus => x_returnStatus,
550: p_msg => l_errMsg,

Line 554: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

550: p_msg => l_errMsg,
551: x_returnStatus => l_returnStatus); --discard logging return status
552: end if;
553: when others then
554: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
556: p_procedure_name => 'processCompTxn',
557: p_error_text => SQLERRM);
558: if (l_logLevel <= wip_constants.trace_logging) then