DBA Data[Home] [Help]

APPS.WIP_RESERVATIONS_GRP dependencies on WIP_RESERVATIONS_GRP

Line 1: PACKAGE BODY wip_reservations_grp AS

1: PACKAGE BODY wip_reservations_grp AS
2: /* $Header: wipsogpb.pls 120.5 2006/07/07 23:58:01 kboonyap noship $ */
3:
4: PROCEDURE get_available_supply_demand (
5: p_api_version_number IN NUMBER default 1.0

Line 62: (p_procName => 'wip_reservations_grp.get_available_supply_demand',

58: l_params(10).paramName := 'p_return_txn';
59: l_params(10).paramValue := p_return_txn;
60:
61: wip_logger.entryPoint
62: (p_procName => 'wip_reservations_grp.get_available_supply_demand',
63: p_params => l_params,
64: x_returnStatus => l_returnStatus);
65: END IF;
66:

Line 121: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',

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);
125: END IF;

Line 131: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.get_available_supply_demand',

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);
135: END IF;

Line 183: (p_procName => 'wip_reservations_grp.validate_supply_demand',

179: l_params(5).paramName := 'p_supply_demand_header_id';
180: l_params(5).paramValue := p_supply_demand_header_id;
181:
182: wip_logger.entryPoint
183: (p_procName => 'wip_reservations_grp.validate_supply_demand',
184: p_params => l_params,
185: x_returnStatus => l_returnStatus);
186: END IF;
187:

Line 254: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.validate_supply_demand',

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,
256: p_msg => 'Success',
257: x_returnStatus => l_returnStatus);
258: END IF;

Line 265: wip_logger.exitPoint(p_procName => 'wip_reservations_grp.validate_supply_demand',

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);
269: END IF;

Line 275: END wip_reservations_grp;

271: fnd_message.set_token('MESSAGE', l_errMsg);
272: fnd_msg_pub.add;
273: END validate_supply_demand ;
274:
275: END wip_reservations_grp;