APPS.WIP_RESERVATIONS_GRP dependencies on WIP_CONSTANTS

Line 39: IF (l_logLevel <= wip_constants.trace_logging) THEN

35: l_crossDock_qty NUMBER;
36: BEGIN
37:
38: -- write parameter value to log file
39: IF (l_logLevel <= wip_constants.trace_logging) THEN
40: l_params(1).paramName := ' p_organization_id';
41: l_params(1).paramValue := p_organization_id;
42: l_params(2).paramName := 'p_item_id';
43: l_params(2).paramValue := p_item_id;

Line 120: IF (l_logLevel <= wip_constants.trace_logging) THEN

116: fnd_message.set_name('WIP', 'WIP_SUPPLY_SOURCE');
117: fnd_msg_pub.ADD;
118: x_return_status := fnd_api.g_ret_sts_error;
119: END IF;
120: IF (l_logLevel <= wip_constants.trace_logging) THEN
121: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',
122: p_procReturnStatus => x_return_status,
123: p_msg => 'Success',
124: x_returnStatus => l_returnStatus);

Line 130: IF (l_logLevel <= wip_constants.trace_logging) THEN

126: EXCEPTION
127: WHEN OTHERS THEN
128: x_return_status := fnd_api.g_ret_sts_unexp_error;
129: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
130: IF (l_logLevel <= wip_constants.trace_logging) THEN
131: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',
132: p_procReturnStatus => x_return_status,
133: p_msg => l_errMsg,
134: x_returnStatus => l_returnStatus);

Line 170: IF (l_logLevel <= wip_constants.trace_logging) THEN

166: l_status_type NUMBER ;
167: l_crossDock_qty NUMBER;
168: BEGIN
169: -- write parameter value to log file
170: IF (l_logLevel <= wip_constants.trace_logging) THEN
171: l_params(1).paramName := ' p_organization_id';
172: l_params(1).paramValue := p_organization_id;
173: l_params(2).paramName := 'p_item_id';
174: l_params(2).paramValue := p_item_id;

Line 231: (WIP_CONSTANTS.UNRELEASED,

227: x_valid_status := 'N' ;
228: END IF;
229: */
230: IF ( (l_status_type NOT IN
231: (WIP_CONSTANTS.UNRELEASED,
232: WIP_CONSTANTS.RELEASED,
233: WIP_CONSTANTS.HOLD,
234: WIP_CONSTANTS.COMP_CHRG)) OR
235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND

Line 232: WIP_CONSTANTS.RELEASED,

228: END IF;
229: */
230: IF ( (l_status_type NOT IN
231: (WIP_CONSTANTS.UNRELEASED,
232: WIP_CONSTANTS.RELEASED,
233: WIP_CONSTANTS.HOLD,
234: WIP_CONSTANTS.COMP_CHRG)) OR
235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND
236: (NVL(l_crossDock_qty,0) <= 0 ) ) )

Line 233: WIP_CONSTANTS.HOLD,

229: */
230: IF ( (l_status_type NOT IN
231: (WIP_CONSTANTS.UNRELEASED,
232: WIP_CONSTANTS.RELEASED,
233: WIP_CONSTANTS.HOLD,
234: WIP_CONSTANTS.COMP_CHRG)) OR
235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND
236: (NVL(l_crossDock_qty,0) <= 0 ) ) )
237: THEN

Line 234: WIP_CONSTANTS.COMP_CHRG)) OR

230: IF ( (l_status_type NOT IN
231: (WIP_CONSTANTS.UNRELEASED,
232: WIP_CONSTANTS.RELEASED,
233: WIP_CONSTANTS.HOLD,
234: WIP_CONSTANTS.COMP_CHRG)) OR
235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND
236: (NVL(l_crossDock_qty,0) <= 0 ) ) )
237: THEN
238: x_valid_status := 'N' ;

Line 235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND

231: (WIP_CONSTANTS.UNRELEASED,
232: WIP_CONSTANTS.RELEASED,
233: WIP_CONSTANTS.HOLD,
234: WIP_CONSTANTS.COMP_CHRG)) OR
235: ((l_status_type = WIP_CONSTANTS.COMP_CHRG) AND
236: (NVL(l_crossDock_qty,0) <= 0 ) ) )
237: THEN
238: x_valid_status := 'N' ;
239: END IF;

Line 251: IF (l_logLevel <= wip_constants.trace_logging) THEN

247:
248: -- Fixed bug 5371701. x_valid_status was not set and there is no call to
249: -- wip_logger.exitPoint().
250: x_valid_status := 'Y';
251: IF (l_logLevel <= wip_constants.trace_logging) THEN
252: wip_logger.log(p_msg => 'x_valid_status = ' || x_valid_status,
253: x_returnStatus => l_returnStatus);
254: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.validate_supply_demand',
255: p_procReturnStatus => x_return_status,

Line 264: IF (l_logLevel <= wip_constants.trace_logging) THEN

260: EXCEPTION
261: WHEN OTHERS THEN
262: x_return_status := fnd_api.g_ret_sts_unexp_error;
263: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
264: IF (l_logLevel <= wip_constants.trace_logging) THEN
265: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.validate_supply_demand',
266: p_procReturnStatus => x_return_status,
267: p_msg => l_errMsg,
268: x_returnStatus => l_returnStatus);