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 362: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

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

401: x_params => l_params);
402: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
403: p_params => l_params,
404: x_returnStatus => x_returnStatus);
405: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
406: raise fnd_api.g_exc_unexpected_error;
407: end if;
408: end if;
409: x_returnStatus := fnd_api.g_ret_sts_success;

Line 406: raise fnd_api.g_exc_unexpected_error;

402: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
403: p_params => l_params,
404: x_returnStatus => x_returnStatus);
405: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
406: raise fnd_api.g_exc_unexpected_error;
407: end if;
408: end if;
409: x_returnStatus := fnd_api.g_ret_sts_success;
410:

Line 409: x_returnStatus := fnd_api.g_ret_sts_success;

405: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
406: raise fnd_api.g_exc_unexpected_error;
407: end if;
408: end if;
409: x_returnStatus := fnd_api.g_ret_sts_success;
410:
411: if(p_compRec.eamItemType is null or
412: ((p_compRec.eamItemType <> wip_constants.rebuild_item_type) and
413: (p_compRec.eamItemType <> 1))) then

Line 482: x_returnStatus := fnd_api.g_ret_sts_success;

478: --insert the issued item into the asset's genealogy
479: if (l_logLevel <= wip_constants.full_logging) then
480: wip_logger.log('calling create gen', l_returnStatus);
481: end if;
482: x_returnStatus := fnd_api.g_ret_sts_success;
483:
484: if (l_logLevel <= wip_constants.full_logging) then
485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);

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

511: x_msg_count => l_msgCount,
512: x_msg_data => l_msgData);
513:
514: --If genealogy of one asset fails
515: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
516: l_errMsg := 'genealogy failed';
517: if(l_msgData is not null) then
518: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
519: fnd_message.set_token('MESSAGE', l_msgData);

Line 522: raise fnd_api.g_exc_unexpected_error;

518: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
519: fnd_message.set_token('MESSAGE', l_msgData);
520: fnd_msg_pub.add; --add the returned error message to the stack.
521: end if;
522: raise fnd_api.g_exc_unexpected_error;
523: end if;
524:
525: l_nxt_srl_num := inv_serial_number_pub.increment_ser_num(l_nxt_srl_num,1);
526: END LOOP;

Line 552: x_returnStatus := fnd_api.g_ret_sts_success;

548: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
549: if (l_logLevel <= wip_constants.full_logging) then
550: wip_logger.log('calling update gen', l_returnStatus);
551: end if;
552: x_returnStatus := fnd_api.g_ret_sts_success;
553: for i in 1..l_serialNumTbl.count loop
554: wip_eam_genealogy_pvt.update_eam_genealogy(p_api_version => 1.0,
555: p_object_type => 2, /* serial number */
556: p_serial_number => l_serialNumTbl(i),

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

566: wip_logger.log('upd gen returned: ' || x_returnStatus, l_returnStatus);
567: end if;
568: end if;
569:
570: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
571: l_errMsg := 'genealogy failed';
572: if(l_msgData is not null) then
573: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
574: fnd_message.set_token('MESSAGE', l_msgData);

Line 577: raise fnd_api.g_exc_unexpected_error;

573: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
574: fnd_message.set_token('MESSAGE', l_msgData);
575: fnd_msg_pub.add; --add the returned error message to the stack.
576: end if;
577: raise fnd_api.g_exc_unexpected_error;
578: end if;
579: end if;
580: end if; --For bug 6892336, we do not deal with genealogy for non-serial item
581:

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

589: ----------------------------------------------------------------------------------
590: eam_rebuild.create_rebuild_job(p_tempId => p_compRec.txnTmpID,
591: x_retVal => x_returnStatus,
592: x_errMsg => l_msgData);
593: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
594: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
595: fnd_message.set_token('MESSAGE', l_msgData);
596: fnd_msg_pub.add; --add the returned error message to the stack.
597: l_errMsg := 'rebuild job creation failed';

Line 598: raise fnd_api.g_exc_unexpected_error;

594: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
595: fnd_message.set_token('MESSAGE', l_msgData);
596: fnd_msg_pub.add; --add the returned error message to the stack.
597: l_errMsg := 'rebuild job creation failed';
598: raise fnd_api.g_exc_unexpected_error;
599: end if;
600: if (l_logLevel <= wip_constants.full_logging) then
601: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
602: end if;

Line 611: when fnd_api.g_exc_unexpected_error then

607: p_msg => 'procedure success.',
608: x_returnStatus => l_returnStatus); --discard logging return status
609: end if;
610: exception
611: when fnd_api.g_exc_unexpected_error then
612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
613: if (l_logLevel <= wip_constants.trace_logging) then
614: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
615: p_procReturnStatus => x_returnStatus,

Line 612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

608: x_returnStatus => l_returnStatus); --discard logging return status
609: end if;
610: exception
611: when fnd_api.g_exc_unexpected_error then
612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
613: if (l_logLevel <= wip_constants.trace_logging) then
614: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
615: p_procReturnStatus => x_returnStatus,
616: p_msg => l_errMsg,

Line 620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

616: p_msg => l_errMsg,
617: x_returnStatus => l_returnStatus); --discard logging return status
618: end if;
619: when others then
620: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
621: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
622: p_procedure_name => 'processCompTxn',
623: p_error_text => SQLERRM);
624: if (l_logLevel <= wip_constants.trace_logging) then