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 817: raise fnd_api.g_exc_unexpected_error;

813: wip_ws_custom.reorder_ops_for_shortage(g_wip_job_op_tbl, l_return_status, l_return_code);
814: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:get_job_ops:back from custom procedure for reordering operations with status='||l_return_status);
815:
816: if(l_return_status <> 'S') then
817: raise fnd_api.g_exc_unexpected_error;
818: end if;
819: exception
820: when others then
821: raise;

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

2361: l_params(1).paramValue := p_org_id;
2362: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2363: p_params => l_params,
2364: x_returnStatus => l_returnStatus);
2365: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
2366: raise fnd_api.g_exc_unexpected_error;
2367: end if;
2368: end if;
2369:

Line 2366: raise fnd_api.g_exc_unexpected_error;

2362: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2363: p_params => l_params,
2364: x_returnStatus => l_returnStatus);
2365: if(l_returnStatus <> fnd_api.g_ret_sts_success) then
2366: raise fnd_api.g_exc_unexpected_error;
2367: end if;
2368: end if;
2369:
2370: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(

Line 2389: raise FND_API.G_EXC_ERROR;

2385: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_shortage: returned from get_org_comp_calc_param with '||l_pref_exists);
2386: if(l_pref_exists = 'N') then
2387: wip_ws_util.trace_log('WIP_WS_SHORTAGE:calc_shortage:No Preference exists for this organization');
2388: fnd_message.set_name('WIP','WIP_WS_SHORTAGE_NOPREF');
2389: raise FND_API.G_EXC_ERROR;
2390: end if;
2391:
2392: wip_ws_util.trace_log( 'WIP_WS_SHORTAGE:calc_shortage: calling get_period_end_time' );
2393: g_period_end_time := get_period_end_time(p_org_id);

Line 2426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2422: x_returnStatus => l_returnStatus);
2423: end if;
2424:
2425: EXCEPTION
2426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2427: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Exception: Unexpected error');
2428: ROLLBACK TO WIP_SHORT_CALC_START;
2429: retcode := 2; -- End with error
2430: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

Line 2440: WHEN FND_API.G_EXC_ERROR THEN

2436: p_msg => 'unexpected error: ' || SQLERRM,
2437: x_returnStatus => l_returnStatus);
2438: end if;
2439:
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: retcode := 1;
2442: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Exception: Expected Error');
2443: ROLLBACK TO WIP_SHORT_CALC_START;
2444: --bug 6756693 Get the message and write it