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

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

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

108: p_attributes => null);
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:

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

126: p_toSerial => 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

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

135: END LOOP; -- l_lotComp IN c_lotComp
136:
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);

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

161: p_attributes => null);
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

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

169: END LOOP; -- l_serialComp IN c_serialComp
170:
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);

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

179: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
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',

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

190:
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,

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

204: fnd_msg_pub.add;
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,

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

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
246: l_params(1).paramName := 'p_parentObjID';
247: l_params(1).paramValue := p_parentObjID;
248: l_params(2).paramName := 'p_orgID';
249: l_params(2).paramValue := p_orgID;

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

277: -- x_item.revision := l_revisionComp.revision;
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',

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

292: CLOSE c_revisionComp;
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,

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

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;
345: wip_logger.entryPoint(
346: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

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

360:
361: LOOP
362: IF(x_compLots.getCurrentItem(l_curItem)) THEN
363: l_txnTypeId := getTxnType(p_txnActionID => l_curItem.transaction_action_id);
364: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
365: WIP_CONSTANTS.OP_PULL,
366: WIP_CONSTANTS.ASSY_PULL)
367: OR
368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,

Line 365: WIP_CONSTANTS.OP_PULL,

361: LOOP
362: IF(x_compLots.getCurrentItem(l_curItem)) THEN
363: l_txnTypeId := getTxnType(p_txnActionID => l_curItem.transaction_action_id);
364: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
365: WIP_CONSTANTS.OP_PULL,
366: WIP_CONSTANTS.ASSY_PULL)
367: OR
368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
369: WIP_CONSTANTS.DYN_RCV_SN)

Line 366: WIP_CONSTANTS.ASSY_PULL)

362: IF(x_compLots.getCurrentItem(l_curItem)) THEN
363: l_txnTypeId := getTxnType(p_txnActionID => l_curItem.transaction_action_id);
364: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
365: WIP_CONSTANTS.OP_PULL,
366: WIP_CONSTANTS.ASSY_PULL)
367: OR
368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
369: WIP_CONSTANTS.DYN_RCV_SN)
370: /* Bug 9907143: added for serial tagging enhancement for SUN */

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

364: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,
365: WIP_CONSTANTS.OP_PULL,
366: WIP_CONSTANTS.ASSY_PULL)
367: OR
368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
369: WIP_CONSTANTS.DYN_RCV_SN)
370: /* Bug 9907143: added for serial tagging enhancement for SUN */
371: AND
372: inv_cache.get_serial_tagged(p_orgID, l_curItem.inventory_item_id, l_txnTypeId ) = WIP_CONSTANTS.NO_SER_TAGGED

Line 369: WIP_CONSTANTS.DYN_RCV_SN)

365: WIP_CONSTANTS.OP_PULL,
366: WIP_CONSTANTS.ASSY_PULL)
367: OR
368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
369: WIP_CONSTANTS.DYN_RCV_SN)
370: /* Bug 9907143: added for serial tagging enhancement for SUN */
371: AND
372: inv_cache.get_serial_tagged(p_orgID, l_curItem.inventory_item_id, l_txnTypeId ) = WIP_CONSTANTS.NO_SER_TAGGED
373: )

Line 372: inv_cache.get_serial_tagged(p_orgID, l_curItem.inventory_item_id, l_txnTypeId ) = WIP_CONSTANTS.NO_SER_TAGGED

368: (l_curItem.serial_number_control_code NOT IN(WIP_CONSTANTS.FULL_SN,
369: WIP_CONSTANTS.DYN_RCV_SN)
370: /* Bug 9907143: added for serial tagging enhancement for SUN */
371: AND
372: inv_cache.get_serial_tagged(p_orgID, l_curItem.inventory_item_id, l_txnTypeId ) = WIP_CONSTANTS.NO_SER_TAGGED
373: )
374: OR
375: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)
376: ) THEN

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

371: AND
372: inv_cache.get_serial_tagged(p_orgID, l_curItem.inventory_item_id, l_txnTypeId ) = WIP_CONSTANTS.NO_SER_TAGGED
373: )
374: OR
375: l_curItem.transaction_action_id NOT IN(WIP_CONSTANTS.RETCOMP_ACTION)
376: ) THEN
377: GOTO END_OF_LOOP;
378: ELSE
379: -- Instead of defaulting revision to the current revision, we should

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

405:
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',

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

416:
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,

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

427: ROLLBACK TO wipbflpb40;
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,

Line 444: if(p_txnActionID = wip_constants.isscomp_action) then

440: END deriveSerial;
441:
442: function getTxnType(p_txnActionID IN NUMBER) return NUMBER is
443: begin
444: if(p_txnActionID = wip_constants.isscomp_action) then
445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then

Line 445: return wip_constants.isscomp_type;

441:
442: function getTxnType(p_txnActionID IN NUMBER) return NUMBER is
443: begin
444: if(p_txnActionID = wip_constants.isscomp_action) then
445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;

Line 446: elsif(p_txnActionID = wip_constants.retnegc_action) then

442: function getTxnType(p_txnActionID IN NUMBER) return NUMBER is
443: begin
444: if(p_txnActionID = wip_constants.isscomp_action) then
445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then

Line 447: return wip_constants.retnegc_type;

443: begin
444: if(p_txnActionID = wip_constants.isscomp_action) then
445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then
451: return wip_constants.issnegc_type;

Line 448: elsif(p_txnActionID = wip_constants.retcomp_action) then

444: if(p_txnActionID = wip_constants.isscomp_action) then
445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then
451: return wip_constants.issnegc_type;
452: end if;

Line 449: return wip_constants.retcomp_type;

445: return wip_constants.isscomp_type;
446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then
451: return wip_constants.issnegc_type;
452: end if;
453: return -1; --this procedure only works for component txn types

Line 450: elsif(p_txnActionID = wip_constants.issnegc_action) then

446: elsif(p_txnActionID = wip_constants.retnegc_action) then
447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then
451: return wip_constants.issnegc_type;
452: end if;
453: return -1; --this procedure only works for component txn types
454: end getTxnType;

Line 451: return wip_constants.issnegc_type;

447: return wip_constants.retnegc_type;
448: elsif(p_txnActionID = wip_constants.retcomp_action) then
449: return wip_constants.retcomp_type;
450: elsif(p_txnActionID = wip_constants.issnegc_action) then
451: return wip_constants.issnegc_type;
452: end if;
453: return -1; --this procedure only works for component txn types
454: end getTxnType;
455: