eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_AUTOSERIALPROC_PRIV dependencies on WIP_LOGGER

Line 66: l_params wip_logger.param_tbl_t;

62: l_errMsg VARCHAR2(240);
63: l_returnStatus VARCHAR2(1);
64: l_item system.wip_component_obj_t;
65: l_lotComp c_lotComp%ROWTYPE;
66: l_params wip_logger.param_tbl_t;
67: l_serialComp c_serialComp%ROWTYPE;
68:
69: BEGIN
70: -- Don't need to check the return status because already check in

Line 93: wip_logger.entryPoint(

89: l_params(8).paramName := 'x_compLot(cur_item).primary_quantity';
90: l_params(8).paramValue := l_item.primary_quantity;
91: l_params(9).paramName := 'x_compLot(cur_item).transaction_action_id';
92: l_params(9).paramValue := l_item.transaction_action_id;
93: wip_logger.entryPoint(
94: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
95: p_params => l_params,
96: x_returnStatus => x_returnStatus);
97: END IF;

Line 113: wip_logger.log('Added Lot : ' || l_lotComp.lot, l_returnStatus);

109:
110: l_derivedQty := l_derivedQty + l_lotComp.lot_qty;
111:
112: IF (l_logLevel <= wip_constants.full_logging) THEN
113: wip_logger.log('Added Lot : ' || l_lotComp.lot, l_returnStatus);
114: wip_logger.log('Added Lot Qty : '|| l_lotComp.lot_qty, l_returnStatus);
115: END IF;
116:
117: -- derive lot/serial genealogy

Line 114: wip_logger.log('Added Lot Qty : '|| l_lotComp.lot_qty, l_returnStatus);

110: l_derivedQty := l_derivedQty + l_lotComp.lot_qty;
111:
112: IF (l_logLevel <= wip_constants.full_logging) THEN
113: wip_logger.log('Added Lot : ' || l_lotComp.lot, l_returnStatus);
114: wip_logger.log('Added Lot Qty : '|| l_lotComp.lot_qty, l_returnStatus);
115: END IF;
116:
117: -- derive lot/serial genealogy
118: FOR l_serialComp IN c_serialComp

Line 131: wip_logger.log('Added Serial : ' || l_serialComp.serial,

127: p_parentSerial => l_serialComp.parent_serial,
128: p_priQty => 1,
129: p_attributes => null);
130: IF (l_logLevel <= wip_constants.full_logging) THEN
131: wip_logger.log('Added Serial : ' || l_serialComp.serial,
132: l_returnStatus);
133: END IF;
134: END LOOP; -- l_serialComp IN c_serialComp
135: END LOOP; -- l_lotComp IN c_lotComp

Line 141: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);

137: -- Check whether derived quantity equal to backflush quantity or not
138: -- If not, error out. (for lot and serial control component)
139: IF(l_item.lot_control_code = WIP_CONSTANTS.LOT AND
140: l_item.primary_quantity <> l_derivedQty * -1) THEN
141: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
142: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
143: l_returnStatus);
144: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
145: l_errMsg := 'return quantity missmatch';

Line 142: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,

138: -- If not, error out. (for lot and serial control component)
139: IF(l_item.lot_control_code = WIP_CONSTANTS.LOT AND
140: l_item.primary_quantity <> l_derivedQty * -1) THEN
141: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
142: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
143: l_returnStatus);
144: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
145: l_errMsg := 'return quantity missmatch';
146: raise fnd_api.g_exc_unexpected_error;

Line 144: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);

140: l_item.primary_quantity <> l_derivedQty * -1) THEN
141: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
142: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
143: l_returnStatus);
144: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
145: l_errMsg := 'return quantity missmatch';
146: raise fnd_api.g_exc_unexpected_error;
147: END IF;
148:

Line 166: wip_logger.log('Added Serial : ' || l_serialComp.serial,

162:
163: l_derivedQty := l_derivedQty + 1;
164:
165: IF (l_logLevel <= wip_constants.full_logging) THEN
166: wip_logger.log('Added Serial : ' || l_serialComp.serial,
167: l_returnStatus);
168: END IF;
169: END LOOP; -- l_serialComp IN c_serialComp
170:

Line 175: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);

171: -- Check whether derived quantity equal to backflush quantity or not
172: -- If not, error out. (for serial control only component)
173: IF(l_item.lot_control_code = WIP_CONSTANTS.NO_LOT AND
174: l_item.primary_quantity <> l_derivedQty * -1) THEN
175: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
176: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
177: l_returnStatus);
178: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
179: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;

Line 176: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,

172: -- If not, error out. (for serial control only component)
173: IF(l_item.lot_control_code = WIP_CONSTANTS.NO_LOT AND
174: l_item.primary_quantity <> l_derivedQty * -1) THEN
175: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
176: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
177: l_returnStatus);
178: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
179: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
180: raise fnd_api.g_exc_unexpected_error;

Line 178: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);

174: l_item.primary_quantity <> l_derivedQty * -1) THEN
175: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
176: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
177: l_returnStatus);
178: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
179: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
180: raise fnd_api.g_exc_unexpected_error;
181: END IF;
182:

Line 184: wip_logger.exitPoint(

180: raise fnd_api.g_exc_unexpected_error;
181: END IF;
182:
183: IF (l_logLevel <= wip_constants.trace_logging) THEN
184: wip_logger.exitPoint(
185: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
186: p_procReturnStatus => x_returnStatus,
187: p_msg => 'procedure success',
188: x_returnStatus => l_returnStatus); --discard return status

Line 195: wip_logger.exitPoint(

191: EXCEPTION
192: WHEN fnd_api.g_exc_unexpected_error THEN
193: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
194: IF (l_logLevel <= wip_constants.trace_logging) THEN
195: wip_logger.exitPoint(
196: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
197: p_procReturnStatus => x_returnStatus,
198: p_msg => l_errMsg,
199: x_returnStatus => l_returnStatus); --discard return status

Line 209: wip_logger.exitPoint(

205:
206: WHEN others THEN
207: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
208: IF (l_logLevel <= wip_constants.trace_logging) THEN
209: wip_logger.exitPoint(
210: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
211: p_procReturnStatus => x_returnStatus,
212: p_msg => 'unexp error:' || SQLERRM,
213: x_returnStatus => l_returnStatus); --discard return status

Line 241: l_params wip_logger.param_tbl_t;

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:
245: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 264: wip_logger.entryPoint(

260: l_params(8).paramName := 'p_item.primary_quantity';
261: l_params(8).paramValue := p_item.primary_quantity;
262: l_params(9).paramName := 'p_item.transaction_action_id';
263: l_params(9).paramValue := p_item.transaction_action_id;
264: wip_logger.entryPoint(
265: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
266: p_params => l_params,
267: x_returnStatus => x_returnStatus);
268: END IF;

Line 282: wip_logger.exitPoint(

278: x_compLots.setRevision(p_revision => l_revisionComp.revision);
279: END IF;
280:
281: IF (l_logLevel <= wip_constants.trace_logging) THEN
282: wip_logger.exitPoint(
283: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
284: p_procReturnStatus => x_returnStatus,
285: p_msg => 'procedure success',
286: x_returnStatus => l_returnStatus); --discard return status

Line 297: wip_logger.exitPoint(

293: END IF;
294:
295: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
296: IF (l_logLevel <= wip_constants.trace_logging) THEN
297: wip_logger.exitPoint(
298: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
299: p_procReturnStatus => x_returnStatus,
300: p_msg => 'unexp error:' || SQLERRM,
301: x_returnStatus => l_returnStatus); --discard return status

Line 337: l_params wip_logger.param_tbl_t;

333: p_initMsgList IN VARCHAR2,
334: x_returnStatus OUT NOCOPY VARCHAR2) IS
335: l_returnStatus VARCHAR2(1);
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

Line 345: wip_logger.entryPoint(

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;
345: wip_logger.entryPoint(
346: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
347: p_params => l_params,
348: x_returnStatus => x_returnStatus);
349: END IF;

Line 410: wip_logger.exitPoint(

406: EXIT WHEN NOT x_compLots.setNextItem;
407: END LOOP;
408:
409: IF (l_logLevel <= wip_constants.trace_logging) THEN
410: wip_logger.exitPoint(
411: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
412: p_procReturnStatus => x_returnStatus,
413: p_msg => 'procedure success',
414: x_returnStatus => l_returnStatus);

Line 421: wip_logger.exitPoint(

417: EXCEPTION
418: WHEN fnd_api.g_exc_unexpected_error THEN
419: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
420: IF (l_logLevel <= wip_constants.trace_logging) THEN
421: wip_logger.exitPoint(
422: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
423: p_procReturnStatus => x_returnStatus,
424: p_msg => l_errMsg,
425: x_returnStatus => l_returnStatus); --discard return status

Line 432: wip_logger.exitPoint(

428:
429: WHEN others THEN
430: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
431: IF (l_logLevel <= wip_constants.trace_logging) THEN
432: wip_logger.exitPoint(
433: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
434: p_procReturnStatus => x_returnStatus,
435: p_msg => 'unexpected error:' || SQLERRM,
436: x_returnStatus => l_returnStatus); --discard return status