APPS.WIP_WS_SHORTAGE dependencies on WIP_LOGGER

Line 39: l_params wip_logger.param_tbl_t;

35: p_org_id IN NUMBER,
36: x_pref_exists OUT NOCOPY VARCHAR2) IS
37:
38: l_returnStatus varchar2(1);
39: l_params wip_logger.param_tbl_t;
40: l_row_seq_num NUMBER;
41: l_cutoff_hr NUMBER;
42: l_cutoff_min NUMBER;
43: l_dtl_row_seq_num NUMBER;

Line 58: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',

54: x_pref_exists := 'Y';
55: if (g_logLevel <= wip_constants.trace_logging) then
56: l_params(1).paramName := 'p_org_id';
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;

Line 124: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',

120: g_org_comp_calc_rec.inc_unreleased_jobs := 1;
121: g_org_comp_calc_rec.inc_onhold_jobs := 2;
122: */
123: if (g_logLevel <= wip_constants.trace_logging) then
124: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
125: p_procReturnStatus => l_returnStatus,
126: p_msg => 'Request processed successfully!',
127: x_returnStatus => l_returnStatus);
128: end if;

Line 133: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',

129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: if (g_logLevel <= wip_constants.trace_logging) then
133: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
134: p_procReturnStatus => l_returnStatus,
135: p_msg => 'unexpected error: ' || SQLERRM,
136: x_returnStatus => l_returnStatus);
137: end if;

Line 2271: l_params wip_logger.param_tbl_t;

2267: p_calc_type IN NUMBER DEFAULT 1) IS
2268:
2269: l_return_status VARCHAR2(1);
2270: l_returnStatus VARCHAR2(1);
2271: l_params wip_logger.param_tbl_t;
2272: l_msg_data VARCHAR2(1000);
2273: l_msg_count NUMBER;
2274: l_lock_status NUMBER;
2275: x_return_status NUMBER;

Line 2291: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

2287:
2288: if (g_logLevel <= wip_constants.trace_logging) then
2289: l_params(1).paramName := 'p_org_id';
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;

Line 2348: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

2344: wip_ws_util.log_time('WIPWSSHB:calc_shortage:Done with db commit');
2345: wip_ws_util.trace_log('WIPWSSHB:calc_shortage:Done with db commit');
2346:
2347: if (g_logLevel <= wip_constants.trace_logging) then
2348: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2349: p_procReturnStatus => retcode,
2350: p_msg => 'Request processed successfully!',
2351: x_returnStatus => l_returnStatus);
2352: end if;

Line 2363: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

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,
2366: x_returnStatus => l_returnStatus);
2367: end if;

Line 2378: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

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',
2379: p_procReturnStatus => retcode,
2380: p_msg => 'expected error: ' || errbuf,
2381: x_returnStatus => l_returnStatus);
2382: end if;

Line 2389: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',

2385: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Others Exception: '|| SQLERRM);
2386: ROLLBACK TO WIP_SHORT_CALC_START;
2387: retcode := 2; --End with error
2388: if (g_logLevel <= wip_constants.trace_logging) then
2389: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2390: p_procReturnStatus => retcode,
2391: p_msg => 'error: ' || SQLERRM,
2392: x_returnStatus => l_returnStatus);
2393: end if;