DBA Data[Home] [Help]

APPS.WIP_AUTOSERIALPROC_PRIV dependencies on FND_LOG

Line 60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

56: ORDER BY msn.serial_number;
57:
58: l_cond BOOLEAN;
59: l_derivedQty NUMBER := 0;
60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
61: l_curLot VARCHAR2(30) := null;
62: l_errMsg VARCHAR2(240);
63: l_returnStatus VARCHAR2(1);
64: l_item system.wip_component_obj_t;

Line 240: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

236: AND mmt.operation_seq_num = p_item.operation_seq_num;
237:
238: l_errMsg VARCHAR2(240);
239: l_returnStatus VARCHAR2(1);
240: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
241: l_params wip_logger.param_tbl_t;
242: l_revisionComp c_revisionComp%ROWTYPE;
243: BEGIN
244:

Line 340: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

336: l_errMsg VARCHAR2(80);
337: l_params wip_logger.param_tbl_t;
338: l_curItem system.wip_component_obj_t;
339: l_txnTypeId NUMBER;
340: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
341: BEGIN
342: IF (l_logLevel <= wip_constants.trace_logging) THEN
343: l_params(1).paramName := 'p_objectID';
344: l_params(1).paramValue := p_objectID;