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_CONSTANTS

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

65: -- Don't need to check the return status because already check in
66: -- deriveSerial()
67: l_cond := x_compLots.getCurrentItem(l_item);
68:
69: IF (l_logLevel <= wip_constants.trace_logging) THEN
70: l_params(1).paramName := 'p_parentObjID';
71: l_params(1).paramValue := p_parentObjID;
72: l_params(2).paramName := 'p_orgID';
73: l_params(2).paramValue := p_orgID;

Line 107: IF (l_logLevel <= wip_constants.full_logging) THEN

103: p_attributes => null);
104:
105: l_derivedQty := l_derivedQty + l_lotComp.lot_qty;
106:
107: IF (l_logLevel <= wip_constants.full_logging) THEN
108: wip_logger.log('Added Lot : ' || l_lotComp.lot, l_returnStatus);
109: wip_logger.log('Added Lot Qty : '|| l_lotComp.lot_qty, l_returnStatus);
110: END IF;
111:

Line 125: IF (l_logLevel <= wip_constants.full_logging) THEN

121: p_toSerial => l_serialComp.serial,
122: p_parentSerial => l_serialComp.parent_serial,
123: p_priQty => 1,
124: p_attributes => null);
125: IF (l_logLevel <= wip_constants.full_logging) THEN
126: wip_logger.log('Added Serial : ' || l_serialComp.serial,
127: l_returnStatus);
128: END IF;
129: END LOOP; -- l_serialComp IN c_serialComp

Line 134: IF(l_item.lot_control_code = WIP_CONSTANTS.LOT AND

130: END LOOP; -- l_lotComp IN c_lotComp
131:
132: -- Check whether derived quantity equal to backflush quantity or not
133: -- If not, error out. (for lot and serial control component)
134: IF(l_item.lot_control_code = WIP_CONSTANTS.LOT AND
135: l_item.primary_quantity <> l_derivedQty * -1) THEN
136: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
137: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
138: l_returnStatus);

Line 160: IF (l_logLevel <= wip_constants.full_logging) THEN

156: p_attributes => null);
157:
158: l_derivedQty := l_derivedQty + 1;
159:
160: IF (l_logLevel <= wip_constants.full_logging) THEN
161: wip_logger.log('Added Serial : ' || l_serialComp.serial,
162: l_returnStatus);
163: END IF;
164: END LOOP; -- l_serialComp IN c_serialComp

Line 168: IF(l_item.lot_control_code = WIP_CONSTANTS.NO_LOT AND

164: END LOOP; -- l_serialComp IN c_serialComp
165:
166: -- Check whether derived quantity equal to backflush quantity or not
167: -- If not, error out. (for serial control only component)
168: IF(l_item.lot_control_code = WIP_CONSTANTS.NO_LOT AND
169: l_item.primary_quantity <> l_derivedQty * -1) THEN
170: wip_logger.log('item : ' || l_item.item_name, l_returnStatus);
171: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
172: l_returnStatus);

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

174: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
175: raise fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: IF (l_logLevel <= wip_constants.trace_logging) THEN
179: wip_logger.exitPoint(
180: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
181: p_procReturnStatus => x_returnStatus,
182: p_msg => 'procedure success',

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

185:
186: EXCEPTION
187: WHEN fnd_api.g_exc_unexpected_error THEN
188: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
189: IF (l_logLevel <= wip_constants.trace_logging) THEN
190: wip_logger.exitPoint(
191: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
192: p_procReturnStatus => x_returnStatus,
193: p_msg => l_errMsg,

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

199: fnd_msg_pub.add;
200:
201: WHEN others THEN
202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
203: IF (l_logLevel <= wip_constants.trace_logging) THEN
204: wip_logger.exitPoint(
205: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
206: p_procReturnStatus => x_returnStatus,
207: p_msg => 'unexp error:' || SQLERRM,

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

236: l_params wip_logger.param_tbl_t;
237: l_revisionComp c_revisionComp%ROWTYPE;
238: BEGIN
239:
240: IF (l_logLevel <= wip_constants.trace_logging) THEN
241: l_params(1).paramName := 'p_parentObjID';
242: l_params(1).paramValue := p_parentObjID;
243: l_params(2).paramName := 'p_orgID';
244: l_params(2).paramValue := p_orgID;

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

272: -- x_item.revision := l_revisionComp.revision;
273: x_compLots.setRevision(p_revision => l_revisionComp.revision);
274: END IF;
275:
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(
278: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
279: p_procReturnStatus => x_returnStatus,
280: p_msg => 'procedure success',

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

287: CLOSE c_revisionComp;
288: END IF;
289:
290: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
291: IF (l_logLevel <= wip_constants.trace_logging) THEN
292: wip_logger.exitPoint(
293: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
294: p_procReturnStatus => x_returnStatus,
295: p_msg => 'unexp error:' || SQLERRM,

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

332: l_params wip_logger.param_tbl_t;
333: l_curItem system.wip_component_obj_t;
334: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
335: BEGIN
336: IF (l_logLevel <= wip_constants.trace_logging) THEN
337: l_params(1).paramName := 'p_objectID';
338: l_params(1).paramValue := p_objectID;
339: wip_logger.entryPoint(
340: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

Line 357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,

353: x_returnStatus := fnd_api.g_ret_sts_success;
354:
355: LOOP
356: IF(x_compLots.getCurrentItem(l_curItem)) THEN
357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
358: WIP_CONSTANTS.OP_PULL,
359: WIP_CONSTANTS.ASSY_PULL)
360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,

Line 358: WIP_CONSTANTS.OP_PULL,

354:
355: LOOP
356: IF(x_compLots.getCurrentItem(l_curItem)) THEN
357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
358: WIP_CONSTANTS.OP_PULL,
359: WIP_CONSTANTS.ASSY_PULL)
360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
362: WIP_CONSTANTS.DYN_RCV_SN)

Line 359: WIP_CONSTANTS.ASSY_PULL)

355: LOOP
356: IF(x_compLots.getCurrentItem(l_curItem)) THEN
357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
358: WIP_CONSTANTS.OP_PULL,
359: WIP_CONSTANTS.ASSY_PULL)
360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
362: WIP_CONSTANTS.DYN_RCV_SN)
363: OR

Line 361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,

357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
358: WIP_CONSTANTS.OP_PULL,
359: WIP_CONSTANTS.ASSY_PULL)
360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
362: WIP_CONSTANTS.DYN_RCV_SN)
363: OR
364: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)
365: ) THEN

Line 362: WIP_CONSTANTS.DYN_RCV_SN)

358: WIP_CONSTANTS.OP_PULL,
359: WIP_CONSTANTS.ASSY_PULL)
360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
362: WIP_CONSTANTS.DYN_RCV_SN)
363: OR
364: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)
365: ) THEN
366: GOTO END_OF_LOOP;

Line 364: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)

360: OR
361: l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
362: WIP_CONSTANTS.DYN_RCV_SN)
363: OR
364: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)
365: ) THEN
366: GOTO END_OF_LOOP;
367: ELSE
368: -- Instead of defaulting revision to the current revision, we should

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

394:
395: EXIT WHEN NOT x_compLots.setNextItem;
396: END LOOP;
397:
398: IF (l_logLevel <= wip_constants.trace_logging) THEN
399: wip_logger.exitPoint(
400: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
401: p_procReturnStatus => x_returnStatus,
402: p_msg => 'procedure success',

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

405:
406: EXCEPTION
407: WHEN fnd_api.g_exc_unexpected_error THEN
408: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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 => l_errMsg,

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

416: ROLLBACK TO wipbflpb40;
417:
418: WHEN others 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 => 'unexpected error:' || SQLERRM,