DBA Data[Home] [Help]

APPS.WIP_RESERVATIONS_GRP dependencies on WIP_LOGGER

Line 29: l_params wip_logger.param_tbl_t;

25: , p_project_id IN NUMBER default null
26: , p_task_id IN NUMBER default null
27: , p_return_txn IN NUMBER default 0
28: ) IS
29: l_params wip_logger.param_tbl_t;
30: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
31: l_returnStatus VARCHAR2(1);
32: l_errMsg VARCHAR2(240);
33: l_msgCount NUMBER;

Line 61: wip_logger.entryPoint

57: l_params(9).paramValue := p_supply_demand_header_id;
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;

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 159: l_params wip_logger.param_tbl_t;

155: , p_expected_receipt_date IN DATE
156: , p_api_version_number IN NUMBER default 1.0
157: ,p_init_msg_lst IN VARCHAR2
158: ) IS
159: l_params wip_logger.param_tbl_t;
160: L_logLevel NUMBER := fnd_log.g_current_runtime_level;
161: l_returnStatus VARCHAR2(1);
162: l_errMsg VARCHAR2(240);
163: l_msgCount NUMBER;

Line 182: wip_logger.entryPoint

178: l_params(4).paramValue := p_supply_demand_type_id;
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;

Line 249: -- wip_logger.exitPoint().

245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF ; -- p_supply_demand_code if condition
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);

Line 252: wip_logger.log(p_msg => 'x_valid_status = ' || x_valid_status,

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,
256: p_msg => 'Success',

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;