APPS.WIP_WS_SHORTAGE dependencies on FND_API

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

57: l_params(1).paramValue := p_org_id;
58: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
59: p_params => l_params,
60: x_returnStatus => l_returnStatus);
61: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
62: raise fnd_api.g_exc_unexpected_error;
63: end if;
64: end if;
65:

Line 62: raise fnd_api.g_exc_unexpected_error;

58: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
59: p_params => l_params,
60: x_returnStatus => l_returnStatus);
61: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
62: raise fnd_api.g_exc_unexpected_error;
63: end if;
64: end if;
65:
66: for c_cat_set_id_csr in cat_set_id_csr loop

Line 776: raise fnd_api.g_exc_unexpected_error;

772: wip_ws_custom.reorder_ops_for_shortage(g_wip_job_op_tbl, l_return_status, l_return_code);
773: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:back from custom procedure for reordering operations with status='||l_return_status);
774:
775: if(l_return_status <> 'S') then
776: raise fnd_api.g_exc_unexpected_error;
777: end if;
778: exception
779: when others then
780: raise;

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

2290: l_params(1).paramValue := p_org_id;
2291: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2292: p_params => l_params,
2293: x_returnStatus => l_returnStatus);
2294: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
2295: raise fnd_api.g_exc_unexpected_error;
2296: end if;
2297: end if;
2298:

Line 2295: raise fnd_api.g_exc_unexpected_error;

2291: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2292: p_params => l_params,
2293: x_returnStatus => l_returnStatus);
2294: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
2295: raise fnd_api.g_exc_unexpected_error;
2296: end if;
2297: end if;
2298:
2299: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(

Line 2318: raise FND_API.G_EXC_ERROR;

2314: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_shortage: returned from get_org_comp_calc_param with '||l_pref_exists);
2315: if(l_pref_exists = 'N') then
2316: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_shortage:No Preference exists for this organization');
2317: fnd_message.set_name('WIP','WIP_WS_SHORTAGE_NOPREF');
2318: raise FND_API.G_EXC_ERROR;
2319: end if;
2320:
2321: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:calc_shortage: calling get_period_end_time' );
2322: g_period_end_time := get_period_end_time(p_org_id);

Line 2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2351: x_returnStatus => l_returnStatus);
2352: end if;
2353:
2354: EXCEPTION
2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2356: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Exception: Unexpected error');
2357: ROLLBACK TO WIP_SHORT_CALC_START;
2358: retcode := 2; -- End with error
2359: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

Line 2369: WHEN FND_API.G_EXC_ERROR THEN

2365: p_msg => 'unexpected error: ' || SQLERRM,
2366: x_returnStatus => l_returnStatus);
2367: end if;
2368:
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: retcode := 1;
2371: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Exception: Expected Error');
2372: ROLLBACK TO WIP_SHORT_CALC_START;
2373: --bug 6756693 Get the message and write it