APPS.WIP_RESOURCE_DEFAULT dependencies on WIP_LOGGER

Line 27: l_params wip_logger.param_tbl_t;

23: l_scheduled_flag number := 2;
24: l_assigned_units number := 1;
25: l_retStatus varchar2(1);
26: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
27: l_params wip_logger.param_tbl_t;
28:
29: BEGIN
30: if (l_logLevel <= wip_constants.trace_logging) then
31: l_params(1).paramName := 'p_group_id';

Line 45: wip_logger.entryPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',

41: l_params(6).paramName := 'p_resource_seq_num';
42: l_params(6).paramValue := p_resource_seq_num;
43: l_params(7).paramName := 'p_resource_id_new';
44: l_params(7).paramValue := p_resource_id_new;
45: wip_logger.entryPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',
46: p_params => l_params,
47: x_returnStatus => l_retStatus);
48: end if;
49: begin

Line 89: wip_logger.log('scheduled_flag: ' || l_scheduled_flag, l_retStatus);

85: where WIP_ENTITY_ID = p_wip_entity_id
86: and OPERATION_SEQ_NUM = p_operation_seq_num
87: and RESOURCE_SEQ_NUM = p_resource_seq_num
88: and ORGANIZATION_ID = p_organization_id;
89: wip_logger.log('scheduled_flag: ' || l_scheduled_flag, l_retStatus);
90: wip_logger.log('assigned_units: ' || l_assigned_units, l_retStatus);
91: exception
92: when no_data_found then
93: wip_logger.log('WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE...this resouce doesnt currently exist on the job', l_retStatus);

Line 90: wip_logger.log('assigned_units: ' || l_assigned_units, l_retStatus);

86: and OPERATION_SEQ_NUM = p_operation_seq_num
87: and RESOURCE_SEQ_NUM = p_resource_seq_num
88: and ORGANIZATION_ID = p_organization_id;
89: wip_logger.log('scheduled_flag: ' || l_scheduled_flag, l_retStatus);
90: wip_logger.log('assigned_units: ' || l_assigned_units, l_retStatus);
91: exception
92: when no_data_found then
93: wip_logger.log('WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE...this resouce doesnt currently exist on the job', l_retStatus);
94: end;

Line 93: wip_logger.log('WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE...this resouce doesnt currently exist on the job', l_retStatus);

89: wip_logger.log('scheduled_flag: ' || l_scheduled_flag, l_retStatus);
90: wip_logger.log('assigned_units: ' || l_assigned_units, l_retStatus);
91: exception
92: when no_data_found then
93: wip_logger.log('WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE...this resouce doesnt currently exist on the job', l_retStatus);
94: end;
95:
96: UPDATE WIP_JOB_DTLS_INTERFACE
97: SET scheduled_flag = nvl(scheduled_flag,l_scheduled_flag),

Line 133: wip_logger.exitPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',

129: );
130:
131: x_state_num := x_state_num + 1;
132: IF(l_logLevel <= wip_constants.trace_logging) then
133: wip_logger.exitPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',
134: p_procReturnStatus => l_retStatus,
135: p_msg => 'success',
136: x_returnStatus => l_retStatus);
137: END IF;

Line 143: wip_logger.exitPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',

139: when others then
140: p_err_msg := 'WIPRSDFB(' || x_state_num || '): ' || SQLERRM;
141: p_err_code := SQLCODE;
142: IF(l_logLevel <= wip_constants.trace_logging) then
143: wip_logger.exitPoint(p_procName => 'WIP_RESOURCE_DEFAULT.DEFAULT_RESOURCE',
144: p_procReturnStatus => l_retStatus,
145: p_msg => 'exception error',
146: x_returnStatus => l_retStatus);
147: END IF;