DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on FND_MESSAGE

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

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

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

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

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

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');
2431: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2432: errbuf := fnd_message.get;
2433: if (g_logLevel <= wip_constants.trace_logging) then
2434: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2435: p_procReturnStatus => retcode,

Line 2432: errbuf := fnd_message.get;

2428: ROLLBACK TO WIP_SHORT_CALC_START;
2429: retcode := 2; -- End with error
2430: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2431: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2432: errbuf := fnd_message.get;
2433: if (g_logLevel <= wip_constants.trace_logging) then
2434: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2435: p_procReturnStatus => retcode,
2436: p_msg => 'unexpected error: ' || SQLERRM,

Line 2445: errbuf := fnd_message.get;

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
2445: errbuf := fnd_message.get;
2446: fnd_file.put_line(fnd_file.log, errbuf);
2447: --end bug 6756693
2448: if (g_logLevel <= wip_constants.trace_logging) then
2449: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

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

2461: p_procReturnStatus => retcode,
2462: p_msg => 'error: ' || SQLERRM,
2463: x_returnStatus => l_returnStatus);
2464: end if;
2465: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2466: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2467: errbuf := fnd_message.get;
2468:
2469: END calc_shortage;

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

2462: p_msg => 'error: ' || SQLERRM,
2463: x_returnStatus => l_returnStatus);
2464: end if;
2465: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2466: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2467: errbuf := fnd_message.get;
2468:
2469: END calc_shortage;
2470:

Line 2467: errbuf := fnd_message.get;

2463: x_returnStatus => l_returnStatus);
2464: end if;
2465: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2466: fnd_message.set_token('ERROR_TEXT', 'wip_ws_shortage.calc_shortage: ' || SQLERRM);
2467: errbuf := fnd_message.get;
2468:
2469: END calc_shortage;
2470:
2471: