APPS.WIP_FLOWRESCHARGE dependencies on FND_API

Line 119: x_returnStatus := fnd_api.g_ret_sts_success;

115:
116: begin
117: l_params(1).paramName := 'p_txnTempID';
118: l_params(1).paramValue := p_txnTempID;
119: x_returnStatus := fnd_api.g_ret_sts_success;
120: if (l_logLevel <= wip_constants.trace_logging) then
121: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
122: p_params => l_params,
123: x_returnStatus => x_returnStatus);

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

120: if (l_logLevel <= wip_constants.trace_logging) then
121: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
122: p_params => l_params,
123: x_returnStatus => x_returnStatus);
124: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
125: raise fnd_api.g_exc_unexpected_error;
126: end if;
127: end if;
128:

Line 125: raise fnd_api.g_exc_unexpected_error;

121: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
122: p_params => l_params,
123: x_returnStatus => x_returnStatus);
124: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
125: raise fnd_api.g_exc_unexpected_error;
126: end if;
127: end if;
128:
129: begin

Line 621: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

617: x_returnStatus => l_returnStatus); --discard logging return status
618: end if;
619: exception
620: when others then
621: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
622: if (l_logLevel <= wip_constants.trace_logging) then
623: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
624: p_procReturnStatus => x_returnStatus,
625: p_msg => 'unexpected error: ' || SQLERRM,

Line 704: x_returnStatus := fnd_api.g_ret_sts_success;

700: l_params wip_logger.param_tbl_t;
701:
702: l_compID number;
703: begin
704: x_returnStatus := fnd_api.g_ret_sts_success;
705: l_params(1).paramName := 'p_txnTempID';
706: l_params(1).paramValue := p_txnTempID;
707: l_params(2).paramName := 'p_orgID';
708: l_params(2).paramValue := p_orgID;

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

715: if (l_logLevel <= wip_constants.trace_logging) then
716: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargePhantomResource',
717: p_params => l_params,
718: x_returnStatus => x_returnStatus);
719: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
720: raise fnd_api.g_exc_unexpected_error;
721: end if;
722: end if;
723:

Line 720: raise fnd_api.g_exc_unexpected_error;

716: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargePhantomResource',
717: p_params => l_params,
718: x_returnStatus => x_returnStatus);
719: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
720: raise fnd_api.g_exc_unexpected_error;
721: end if;
722: end if;
723:
724: -- now charge the phantom routing is applicable

Line 744: raise fnd_api.g_exc_unexpected_error;

740: p_comp_txn_id => phantoms_rec.completion_transaction_id,
741: p_txn_temp_id => phantoms_rec.transaction_temp_id,
742: p_line_id => phantoms_rec.repetitive_line_id,
743: p_rtg_rev_date => to_char(p_effDate, 'YYYY/MM/DD HH24:MI')) = 0 ) then
744: raise fnd_api.g_exc_unexpected_error;
745: end if;
746: end loop;
747: else -- it doens't have a routing, use the second cursor
748: for phantoms_rec in phantoms_c2 loop

Line 765: raise fnd_api.g_exc_unexpected_error;

761: p_comp_txn_id => phantoms_rec.completion_transaction_id,
762: p_txn_temp_id => phantoms_rec.transaction_temp_id,
763: p_line_id => phantoms_rec.repetitive_line_id,
764: p_rtg_rev_date => to_char(p_effDate, 'YYYY/MM/DD HH24:MI')) = 0 ) then
765: raise fnd_api.g_exc_unexpected_error;
766: end if;
767: end loop;
768: end if;
769: end if;

Line 774: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

770:
771:
772: exception
773: when others then
774: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
775: if (l_logLevel <= wip_constants.trace_logging) then
776: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargePhantomResource',
777: p_procReturnStatus => x_returnStatus,
778: p_msg => 'unexpected error: ' || SQLERRM,