APPS.WIP_RESOURCE_DEFAULT dependencies on WIP_RESOURCE_DEFAULT

Line 1: Package BODY WIP_RESOURCE_DEFAULT AS

1: Package BODY WIP_RESOURCE_DEFAULT AS
2: /* $Header: wiprsdfb.pls 120.2.12020000.2 2012/07/18 18:15:57 ankohli ship $ */
3:
4: Procedure DEFAULT_RESOURCE(
5: p_group_id number,

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 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;

Line 152: END WIP_RESOURCE_DEFAULT;

148: end;
149:
150: END DEFAULT_RESOURCE;
151:
152: END WIP_RESOURCE_DEFAULT;