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 2342: l_params wip_logger.param_tbl_t;

2338: p_calc_type IN NUMBER DEFAULT 1) IS
2339:
2340: l_return_status VARCHAR2(1);
2341: l_returnStatus VARCHAR2(1);
2342: l_params wip_logger.param_tbl_t;
2343: l_msg_data VARCHAR2(1000);
2344: l_msg_count NUMBER;
2345: l_lock_status NUMBER;
2346: x_return_status NUMBER;

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

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

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

2415: wip_ws_util.log_time('WIPWSSHB:calc_shortage:Done with db commit');
2416: wip_ws_util.trace_log('WIPWSSHB:calc_shortage:Done with db commit');
2417:
2418: if (g_logLevel <= wip_constants.trace_logging) then
2419: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2420: p_procReturnStatus => retcode,
2421: p_msg => 'Request processed successfully!',
2422: x_returnStatus => l_returnStatus);
2423: end if;

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

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

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

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',
2450: p_procReturnStatus => retcode,
2451: p_msg => 'expected error: ' || errbuf,
2452: x_returnStatus => l_returnStatus);
2453: end if;

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

2456: wip_ws_util.trace_log('WIPWSSHB:calc_shortage: Others Exception: '|| SQLERRM);
2457: ROLLBACK TO WIP_SHORT_CALC_START;
2458: retcode := 2; --End with error
2459: if (g_logLevel <= wip_constants.trace_logging) then
2460: wip_logger.exitPoint(p_procName => 'WIP_WS_SHORTAGE.calc_shortage',
2461: p_procReturnStatus => retcode,
2462: p_msg => 'error: ' || SQLERRM,
2463: x_returnStatus => l_returnStatus);
2464: end if;