DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on FND_MESSAGE

Line 2317: fnd_message.set_name('WIP','WIP_WS_SHORTAGE_NOPREF');

2313: get_org_comp_calc_param(p_org_id, l_pref_exists);
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' );

Line 2359: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

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');
2360: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2361: errbuf := fnd_message.get;
2362: if (g_logLevel <= wip_constants.trace_logging) then
2363: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

Line 2360: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);

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');
2360: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2361: errbuf := fnd_message.get;
2362: if (g_logLevel <= wip_constants.trace_logging) then
2363: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2364: p_procReturnStatus => retcode,

Line 2361: errbuf := fnd_message.get;

2357: ROLLBACK TO WIP_SHORT_CALC_START;
2358: retcode := 2; -- End with error
2359: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2360: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2361: errbuf := fnd_message.get;
2362: if (g_logLevel <= wip_constants.trace_logging) then
2363: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2364: p_procReturnStatus => retcode,
2365: p_msg => 'unexpected error: ' || SQLERRM,

Line 2374: errbuf := fnd_message.get;

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
2374: errbuf := fnd_message.get;
2375: fnd_file.put_line(fnd_file.log, errbuf);
2376: --end bug 6756693
2377: if (g_logLevel <= wip_constants.trace_logging) then
2378: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

Line 2394: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

2390: p_procReturnStatus => retcode,
2391: p_msg => 'error: ' || SQLERRM,
2392: x_returnStatus => l_returnStatus);
2393: end if;
2394: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2395: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2396: errbuf := fnd_message.get;
2397:
2398: END calc_shortage;

Line 2395: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);

2391: p_msg => 'error: ' || SQLERRM,
2392: x_returnStatus => l_returnStatus);
2393: end if;
2394: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2395: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2396: errbuf := fnd_message.get;
2397:
2398: END calc_shortage;
2399:

Line 2396: errbuf := fnd_message.get;

2392: x_returnStatus => l_returnStatus);
2393: end if;
2394: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2395: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2396: errbuf := fnd_message.get;
2397:
2398: END calc_shortage;
2399:
2400: