DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_PK dependencies on WIP_LOGGER

Line 44: l_params wip_logger.param_tbl_t;

40: l_return_status varchar2(1);
41: l_msg_data varchar2(1000);
42: l_msg_count number;
43: l_lock_status number;
44: l_params wip_logger.param_tbl_t;
45: l_pref_exists varchar2(1);
46:
47: l_concurrent_count NUMBER;
48: l_conc_status boolean;

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

53:
54: l_params(1).paramName := 'p_org_id';
55: l_params(1).paramValue := p_org_id;
56:
57: wip_logger.entryPoint(p_procName => 'WIP_WS_SHORTAGE.get_org_comp_calc_param',
58: p_params => l_params,
59: x_returnStatus => l_return_Status);
60: if(l_return_Status <> fnd_api.g_ret_sts_success) then
61: raise fnd_api.g_exc_unexpected_error;

Line 63: wip_logger.log(' Start Time : = '||to_char(sysdate),l_return_status);

59: x_returnStatus => l_return_Status);
60: if(l_return_Status <> fnd_api.g_ret_sts_success) then
61: raise fnd_api.g_exc_unexpected_error;
62: end if;
63: wip_logger.log(' Start Time : = '||to_char(sysdate),l_return_status);
64:
65: end if;
66: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));
67: wip_ws_util.trace_log('Start time = '||to_char(sysdate));

Line 70: wip_logger.log(' Trying to get lock for this organization ',l_return_status);

66: wip_ws_util.trace_log('Org id = '||to_char(p_org_id));
67: wip_ws_util.trace_log('Start time = '||to_char(sysdate));
68:
69:
70: wip_logger.log(' Trying to get lock for this organization ',l_return_status);
71: savepoint wip_ws_ptpkpi_calc;
72:
73: l_concurrent_count := wip_ws_util.get_no_of_running_concurrent(
74: p_program_application_id => fnd_global.prog_appl_id,