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_BFLPROC_PRIV dependencies on WIP_LOGGER

Line 274: l_params wip_logger.param_tbl_t;

270: l_openPastPeriod boolean := false;
271: l_acctPeriodID NUMBER;
272: l_deriveStatus VARCHAR2(1);
273: l_errMsg VARCHAR2(240);
274: l_params wip_logger.param_tbl_t;
275: l_returnStatus VARCHAR2(1);
276: l_extendCount NUMBER := 0;
277: l_index NUMBER;
278: l_revision VARCHAR2(3);

Line 341: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.processRequirements',

337: l_params(21).paramName := 'p_reference';
338: l_params(21).paramValue := p_reference;
339: l_params(22).paramName := 'p_mtlTxnMode';
340: l_params(22).paramValue := p_mtlTxnMode;
341: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.processRequirements',
342: p_params => l_params,
343: x_returnStatus => x_returnStatus);
344: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
345: raise fnd_api.g_exc_unexpected_error;

Line 357: wip_logger.log('processing repetitive...',l_returnStatus);

353: );
354:
355: if(p_wipEntityType = wip_constants.repetitive) then
356: if (l_logLevel <= wip_constants.full_logging) then
357: wip_logger.log('processing repetitive...',l_returnStatus);
358: end if;
359: --select the highest operation where the backflush flag is set
360: open c_repReqs;
361: else

Line 363: wip_logger.log('processing discrete...',l_returnStatus);

359: --select the highest operation where the backflush flag is set
360: open c_repReqs;
361: else
362: if (l_logLevel <= wip_constants.full_logging) then
363: wip_logger.log('processing discrete...',l_returnStatus);
364: end if;
365: open c_discReqs;
366: end if;
367: --no routing

Line 551: wip_logger.log('found existing requirement',l_returnStatus);

547:
548:
549: if(l_popRec.itemID = l_reqRec.itemID) then
550: if (l_logLevel <= wip_constants.full_logging) then
551: wip_logger.log('found existing requirement',l_returnStatus);
552: end if;
553: if(fnd_api.to_boolean(p_mergeMode)) then
554: --user wants to merge requirements. Update the txn qty
555: update mtl_transactions_interface

Line 618: wip_logger.log('inserting item:' || l_reqRec.itemID || ' opSeq:' || l_reqRec.opSeqNum || ' qty:' || l_compQty * -1,l_returnStatus);

614: end if;
615:
616:
617: if (l_logLevel <= wip_constants.full_logging) then
618: wip_logger.log('inserting item:' || l_reqRec.itemID || ' opSeq:' || l_reqRec.opSeqNum || ' qty:' || l_compQty * -1,l_returnStatus);
619: wip_logger.log('txnAction:' || l_txnActionID || ' txnType:' || l_txnTypeID,l_returnStatus);
620: end if;
621: if(x_compTbl is null) then
622:

Line 619: wip_logger.log('txnAction:' || l_txnActionID || ' txnType:' || l_txnTypeID,l_returnStatus);

615:
616:
617: if (l_logLevel <= wip_constants.full_logging) then
618: wip_logger.log('inserting item:' || l_reqRec.itemID || ' opSeq:' || l_reqRec.opSeqNum || ' qty:' || l_compQty * -1,l_returnStatus);
619: wip_logger.log('txnAction:' || l_txnActionID || ' txnType:' || l_txnTypeID,l_returnStatus);
620: end if;
621: if(x_compTbl is null) then
622:
623: /* Fix for Bug 5444243 */

Line 747: wip_logger.log('serial control code is ' || l_reqRec.serialNumControlCode,l_returnStatus);

743: x_compTbl.extend(g_compTblExtendSize);
744: l_extendCount := 0;
745: end if;
746: if (l_logLevel <= wip_constants.full_logging) then
747: wip_logger.log('serial control code is ' || l_reqRec.serialNumControlCode,l_returnStatus);
748: wip_logger.log('lot control code is ' || l_reqRec.lotControlCode,l_returnStatus);
749: end if;
750:
751: --pass movTxnID as the move needs to distinguish between the mtl requirements for the child

Line 748: wip_logger.log('lot control code is ' || l_reqRec.lotControlCode,l_returnStatus);

744: l_extendCount := 0;
745: end if;
746: if (l_logLevel <= wip_constants.full_logging) then
747: wip_logger.log('serial control code is ' || l_reqRec.serialNumControlCode,l_returnStatus);
748: wip_logger.log('lot control code is ' || l_reqRec.lotControlCode,l_returnStatus);
749: end if;
750:
751: --pass movTxnID as the move needs to distinguish between the mtl requirements for the child
752: --move transaction vs. the parent move transaction in the over move case. Over-completions do

Line 819: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

815: end if;
816:
817: x_returnStatus := fnd_api.g_ret_sts_success;
818: if (l_logLevel <= wip_constants.trace_logging) then
819: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
820: p_procReturnStatus => x_returnStatus,
821: p_msg => 'procedure succeeded',
822: x_returnStatus => l_returnStatus); --discard logging return status
823: end if;

Line 826: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

822: x_returnStatus => l_returnStatus); --discard logging return status
823: end if;
824:
825: if(fnd_api.to_boolean(p_endDebug)) then
826: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
827: end if;
828: exception
829: when fnd_api.g_exc_unexpected_error then
830: rollback to wipbflpb20;

Line 832: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

828: exception
829: when fnd_api.g_exc_unexpected_error then
830: rollback to wipbflpb20;
831: if (l_logLevel <= wip_constants.trace_logging) then
832: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
833: p_procReturnStatus => x_returnStatus,
834: p_msg => l_errMsg,
835: x_returnStatus => l_returnStatus); --discard logging return status
836: end if;

Line 839: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

835: x_returnStatus => l_returnStatus); --discard logging return status
836: end if;
837:
838: if(fnd_api.to_boolean(p_endDebug)) then
839: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
840: end if;
841: when others then
842: rollback to wipbflpb20;
843: x_returnStatus := fnd_api.g_ret_sts_unexp_error;--unexpec error if exception occurs

Line 848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',

844: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_bflProc_priv',
845: p_procedure_name => 'processRequirements',
846: p_error_text => SQLERRM);
847: if (l_logLevel <= wip_constants.trace_logging) then
848: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.processRequirements',
849: p_procReturnStatus => x_returnStatus,
850: p_msg => 'unexpected error: ' || SQLERRM,
851: x_returnStatus => l_returnStatus); --discard logging return status
852: end if;

Line 855: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

851: x_returnStatus => l_returnStatus); --discard logging return status
852: end if;
853:
854: if(fnd_api.to_boolean(p_endDebug)) then
855: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
856: end if;
857: end processRequirements;
858:
859:

Line 883: l_params wip_logger.param_tbl_t;

879: l_phantomRowID rowid;
880: l_opSeqNum NUMBER;
881: l_qtyMultiplier NUMBER := 1;
882: l_index NUMBER := 1;
883: l_params wip_logger.param_tbl_t;
884: l_errMsg VARCHAR2(240);
885: l_returnStatus VARCHAR2(1);
886: l_errCode NUMBER;
887: l_inheritPhOpSeq NUMBER;

Line 1040: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1036: l_params(8).paramName := 'p_implFlag';
1037: l_params(8).paramValue := p_implFlag;
1038:
1039:
1040: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1041: p_params => l_params,
1042: x_returnStatus => x_returnStatus);
1043: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1044: raise fnd_api.g_exc_unexpected_error;

Line 1099: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1095: x_returnStatus := fnd_api.g_ret_sts_success;
1096: x_compTbl := system.wip_component_tbl_t();
1097:
1098: if (l_logLevel <= wip_constants.trace_logging) then
1099: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1100: p_procReturnStatus => x_returnStatus,
1101: p_msg => 'no bom for this item!',
1102: x_returnStatus => l_returnStatus); --discard logging return status
1103: end if;

Line 1106: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

1102: x_returnStatus => l_returnStatus); --discard logging return status
1103: end if;
1104:
1105: if(fnd_api.to_boolean(p_endDebug)) then
1106: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1107: end if;
1108: return;
1109: end;
1110:

Line 1112: wip_logger.log('cmn bill id: ' || l_cmnBillID,l_returnStatus);

1108: return;
1109: end;
1110:
1111: if (l_logLevel <= wip_constants.full_logging) then
1112: wip_logger.log('cmn bill id: ' || l_cmnBillID,l_returnStatus);
1113: wip_logger.log('cmn org id: ' || l_cmnOrgID,l_returnStatus);
1114: end if;
1115:
1116: begin

Line 1113: wip_logger.log('cmn org id: ' || l_cmnOrgID,l_returnStatus);

1109: end;
1110:
1111: if (l_logLevel <= wip_constants.full_logging) then
1112: wip_logger.log('cmn bill id: ' || l_cmnBillID,l_returnStatus);
1113: wip_logger.log('cmn org id: ' || l_cmnOrgID,l_returnStatus);
1114: end if;
1115:
1116: begin
1117: select bp.inherit_phantom_op_seq,

Line 1186: wip_logger.log(l_errCode,l_returnStatus);

1182:
1183:
1184:
1185: if (l_logLevel <= wip_constants.full_logging) then
1186: wip_logger.log(l_errCode,l_returnStatus);
1187: end if;
1188: if(l_errCode <> 0) then
1189: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1190: fnd_message.set_token('MESSAGE', l_msgData);

Line 1223: wip_logger.log('process item ' || l_compRec.itemID || ' w/compCode= ' || l_compRec.compCode,l_returnStatus);

1219: close c_components;
1220: exit;
1221: end if;
1222: if (l_logLevel <= wip_constants.full_logging) then
1223: wip_logger.log('process item ' || l_compRec.itemID || ' w/compCode= ' || l_compRec.compCode,l_returnStatus);
1224: end if;
1225: --The op seq of a phantom component should be the op seq of it's ancestor that's on the assy_item's bom,
1226: --or in other words, a direct child of the assembly. If this check is not done, multiple levels of nesting
1227: --will cause problems.

Line 1232: wip_logger.log('--set all descendant op seqs to' || l_opSeqNum,l_returnStatus);

1228: if(l_inheritPhOpSeq = wip_constants.yes) then
1229: if(l_compRec.bomLevel = 2) then
1230: l_opSeqNum := l_compRec.opSeqNum;
1231: if (l_logLevel <= wip_constants.full_logging) then
1232: wip_logger.log('--set all descendant op seqs to' || l_opSeqNum,l_returnStatus);
1233: end if;
1234: end if;
1235: else
1236: if (l_logLevel <= wip_constants.full_logging) then

Line 1237: wip_logger.log('--retain op seqs',l_returnStatus);

1233: end if;
1234: end if;
1235: else
1236: if (l_logLevel <= wip_constants.full_logging) then
1237: wip_logger.log('--retain op seqs',l_returnStatus);
1238: end if;
1239: l_opSeqNum := null;
1240: end if;
1241:

Line 1261: wip_logger.log('--item is a phantom',l_returnStatus);

1257: --only needed to use l_opSeqNum for the above update
1258: l_opSeqNum := null;
1259: end if;
1260: if (l_logLevel <= wip_constants.full_logging) then
1261: wip_logger.log('--item is a phantom',l_returnStatus);
1262: end if;
1263: --update all the descendants quantity to reflect the phantom parent
1264: if(l_inheritPhOpSeq = wip_constants.yes and l_compRec.bomLevel = 1) then
1265: l_opSeqNum := l_compRec.opSeqNum;

Line 1270: wip_logger.log('--updated qty by ' || l_compRec.priQty,l_returnStatus);

1266: else
1267: l_opSeqNum := null;
1268: end if;
1269: if (l_logLevel <= wip_constants.full_logging) then
1270: wip_logger.log('--updated qty by ' || l_compRec.priQty,l_returnStatus);
1271: wip_logger.log('shrinkage_rate: ' || l_compRec.shrinkageRate,l_returnStatus);
1272: end if;
1273:
1274: /*For Component Yield Enhancement(Bug 4369064)

Line 1271: wip_logger.log('shrinkage_rate: ' || l_compRec.shrinkageRate,l_returnStatus);

1267: l_opSeqNum := null;
1268: end if;
1269: if (l_logLevel <= wip_constants.full_logging) then
1270: wip_logger.log('--updated qty by ' || l_compRec.priQty,l_returnStatus);
1271: wip_logger.log('shrinkage_rate: ' || l_compRec.shrinkageRate,l_returnStatus);
1272: end if;
1273:
1274: /*For Component Yield Enhancement(Bug 4369064)
1275: *Keep component_quantity free from component yield

Line 1315: wip_logger.log('--skipping item' || l_compRec.compCode,l_returnStatus);

1311: --e.g. Assy -> Ph(20) -> Ph(1) -> Ph(10) -> Comp(1). In this case, we would want to set the comp's op seq to 10, not 20.
1312: goto start_loop_processing; --outer loop will check notfound, but will continue processing since the attribute will be false
1313: end if;
1314: if (l_logLevel <= wip_constants.full_logging) then
1315: wip_logger.log('--skipping item' || l_compRec.compCode,l_returnStatus);
1316: end if;
1317: end loop;
1318: end if; ----if item is a phantom
1319: end loop;

Line 1486: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1482: where group_id = l_grpID;
1483:
1484: x_returnStatus := fnd_api.g_ret_sts_success;
1485: if (l_logLevel <= wip_constants.trace_logging) then
1486: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1487: p_procReturnStatus => x_returnStatus,
1488: p_msg => 'procedure success',
1489: x_returnStatus => l_returnStatus); --discard logging return status
1490: end if;

Line 1493: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

1489: x_returnStatus => l_returnStatus); --discard logging return status
1490: end if;
1491:
1492: if(fnd_api.to_boolean(p_endDebug)) then
1493: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1494: end if;
1495:
1496: exception
1497: when fnd_api.g_exc_unexpected_error then

Line 1501: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1497: when fnd_api.g_exc_unexpected_error then
1498: rollback to wipbflpb30;
1499: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1500: if (l_logLevel <= wip_constants.trace_logging) then
1501: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1502: p_procReturnStatus => x_returnStatus,
1503: p_msg => l_errMsg,
1504: x_returnStatus => l_returnStatus); --discard logging return status
1505: end if;

Line 1508: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

1504: x_returnStatus => l_returnStatus); --discard logging return status
1505: end if;
1506:
1507: if(fnd_api.to_boolean(p_endDebug)) then
1508: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1509: end if;
1510:
1511: when others then
1512: rollback to wipbflpb30;

Line 1518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',

1514: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1515: fnd_message.set_token('ERROR_TEXT', SQLERRM);
1516: fnd_msg_pub.add;
1517: if (l_logLevel <= wip_constants.trace_logging) then
1518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1519: p_procReturnStatus => x_returnStatus,
1520: p_msg => 'unexpected error: ' || SQLERRM,
1521: x_returnStatus => l_returnStatus); --discard logging return status
1522: end if;

Line 1525: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

1521: x_returnStatus => l_returnStatus); --discard logging return status
1522: end if;
1523:
1524: if(fnd_api.to_boolean(p_endDebug)) then
1525: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
1526: end if;
1527: end explodeRequirements;
1528:
1529:

Line 1586: l_params wip_logger.param_tbl_t;

1582: AND wmti.transaction_id = wmta.transaction_id
1583: AND wmti.transaction_id = p_txn_id;
1584:
1585: l_rsa wip_movProc_priv.rsa_tbl_t;
1586: l_params wip_logger.param_tbl_t;
1587: l_compTbl system.wip_component_tbl_t:=NULL;
1588: l_repAssyPull c_repAssyPull%ROWTYPE;
1589: l_wmta c_wmta%ROWTYPE;
1590: l_returnStatus VARCHAR(1);

Line 1668: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',

1664: l_params(24).paramValue := p_reasonID;
1665: l_params(25).paramName := 'p_reference';
1666: l_params(25).paramValue := p_reference;
1667:
1668: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',
1669: p_params => l_params,
1670: x_returnStatus => l_returnStatus);
1671: END IF;
1672: IF(p_batchSeq IS NULL) THEN

Line 1827: wip_logger.log(p_msg => 'l_proc_status = ' || l_proc_status,

1823: x_rsa => l_rsa,
1824: x_returnStatus => l_returnStatus);
1825:
1826: IF (l_logLevel <= wip_constants.full_logging) THEN
1827: wip_logger.log(p_msg => 'l_proc_status = ' || l_proc_status,
1828: x_returnStatus => l_returnStatus);
1829: wip_logger.log(p_msg => 'l_sche_count = ' || l_sche_count,
1830: x_returnStatus => l_returnStatus);
1831: END IF;

Line 1829: wip_logger.log(p_msg => 'l_sche_count = ' || l_sche_count,

1825:
1826: IF (l_logLevel <= wip_constants.full_logging) THEN
1827: wip_logger.log(p_msg => 'l_proc_status = ' || l_proc_status,
1828: x_returnStatus => l_returnStatus);
1829: wip_logger.log(p_msg => 'l_sche_count = ' || l_sche_count,
1830: x_returnStatus => l_returnStatus);
1831: END IF;
1832:
1833: IF(l_proc_status = TVE_OVERCOMPLETION_MISMATCH) THEN

Line 1853: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,

1849: END IF; -- check p_fmMoveProcessor
1850:
1851: IF (l_logLevel <= wip_constants.full_logging) THEN
1852: FOR i IN 1..l_sche_count LOOP
1853: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
1854: x_returnStatus => l_returnStatus);
1855: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
1856: x_returnStatus => l_returnStatus);
1857: END LOOP;

Line 1855: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,

1851: IF (l_logLevel <= wip_constants.full_logging) THEN
1852: FOR i IN 1..l_sche_count LOOP
1853: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
1854: x_returnStatus => l_returnStatus);
1855: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
1856: x_returnStatus => l_returnStatus);
1857: END LOOP;
1858: END IF;
1859: -- Check whether call from Completion form or not

Line 2048: wip_logger.log(p_msg => 'l_proc_status = ' ||

2044: x_rsa => l_rsa,
2045: x_returnStatus => l_returnStatus);
2046:
2047: IF (l_logLevel <= wip_constants.full_logging) THEN
2048: wip_logger.log(p_msg => 'l_proc_status = ' ||
2049: l_proc_status,
2050: x_returnStatus => l_returnStatus);
2051: wip_logger.log(p_msg => 'l_sche_count = ' ||
2052: l_sche_count,

Line 2051: wip_logger.log(p_msg => 'l_sche_count = ' ||

2047: IF (l_logLevel <= wip_constants.full_logging) THEN
2048: wip_logger.log(p_msg => 'l_proc_status = ' ||
2049: l_proc_status,
2050: x_returnStatus => l_returnStatus);
2051: wip_logger.log(p_msg => 'l_sche_count = ' ||
2052: l_sche_count,
2053: x_returnStatus => l_returnStatus);
2054: END IF;
2055:

Line 2076: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,

2072: END IF; -- check p_fmMoveProcessor
2073:
2074: IF (l_logLevel <= wip_constants.full_logging) THEN
2075: FOR i IN 1..l_sche_count LOOP
2076: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
2077: x_returnStatus => l_returnStatus);
2078: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
2079: x_returnStatus => l_returnStatus);
2080: END LOOP;

Line 2078: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,

2074: IF (l_logLevel <= wip_constants.full_logging) THEN
2075: FOR i IN 1..l_sche_count LOOP
2076: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
2077: x_returnStatus => l_returnStatus);
2078: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
2079: x_returnStatus => l_returnStatus);
2080: END LOOP;
2081: END IF;
2082:

Line 2181: wip_logger.log(p_msg => 'l_proc_status = ' ||

2177: x_rsa => l_rsa,
2178: x_returnStatus => l_returnStatus);
2179:
2180: IF (l_logLevel <= wip_constants.full_logging) THEN
2181: wip_logger.log(p_msg => 'l_proc_status = ' ||
2182: l_proc_status,
2183: x_returnStatus => l_returnStatus);
2184: wip_logger.log(p_msg => 'l_sche_count = ' ||
2185: l_sche_count,

Line 2184: wip_logger.log(p_msg => 'l_sche_count = ' ||

2180: IF (l_logLevel <= wip_constants.full_logging) THEN
2181: wip_logger.log(p_msg => 'l_proc_status = ' ||
2182: l_proc_status,
2183: x_returnStatus => l_returnStatus);
2184: wip_logger.log(p_msg => 'l_sche_count = ' ||
2185: l_sche_count,
2186: x_returnStatus => l_returnStatus);
2187: END IF;
2188:

Line 2209: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,

2205: END IF; -- check p_fmMoveProcessor
2206:
2207: IF (l_logLevel <= wip_constants.full_logging) THEN
2208: FOR i IN 1..l_sche_count LOOP
2209: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
2210: x_returnStatus => l_returnStatus);
2211: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
2212: x_returnStatus => l_returnStatus);
2213: END LOOP;

Line 2211: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,

2207: IF (l_logLevel <= wip_constants.full_logging) THEN
2208: FOR i IN 1..l_sche_count LOOP
2209: wip_logger.log(p_msg => 'sche_id = ' || l_rsa(i).scheID,
2210: x_returnStatus => l_returnStatus);
2211: wip_logger.log(p_msg => 'txn_qty = ' || l_rsa(i).scheQty,
2212: x_returnStatus => l_returnStatus);
2213: END LOOP;
2214: END IF;
2215: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty

Line 2989: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

2985: END IF; -- WIP_CONSTANTS.MMTT_TBL
2986:
2987: x_returnStatus := fnd_api.g_ret_sts_success;
2988: IF (l_logLevel <= wip_constants.trace_logging) THEN
2989: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
2990: p_procReturnStatus => x_returnStatus,
2991: p_msg => 'Succesfully inserted components into MMTT',
2992: x_returnStatus => l_returnStatus);
2993: END IF;

Line 2999: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

2995: WHEN fnd_api.g_exc_unexpected_error THEN
2996: ROLLBACK TO SAVEPOINT s_backflush;
2997: x_returnStatus := fnd_api.g_ret_sts_error;
2998: IF (l_logLevel <= wip_constants.trace_logging) THEN
2999: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3000: p_procReturnStatus => x_returnStatus,
3001: p_msg => l_errMsg,
3002: x_returnStatus => l_returnStatus);
3003: END IF;

Line 3008: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3004: WHEN others THEN
3005: ROLLBACK TO SAVEPOINT s_backflush;
3006: x_returnStatus := fnd_api.g_ret_sts_error;
3007: IF (l_logLevel <= wip_constants.trace_logging) THEN
3008: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3009: p_procReturnStatus => x_returnStatus,
3010: p_msg => 'Unexpected error : ' || SQLERRM,
3011: x_returnStatus => l_returnStatus);
3012: END IF;

Line 3059: l_params wip_logger.param_tbl_t;

3055: x_compInfo OUT NOCOPY system.wip_lot_serial_obj_t,
3056: x_lotSerRequired OUT NOCOPY NUMBER,
3057: x_returnStatus OUT NOCOPY VARCHAR2) IS
3058:
3059: l_params wip_logger.param_tbl_t;
3060: l_returnStatus VARCHAR(1);
3061: l_errMsg VARCHAR2(240);
3062: l_fm_op NUMBER;
3063: l_fm_step NUMBER;

Line 3107: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',

3103: l_params(13).paramValue := p_childMovTxnID;
3104: l_params(14).paramName := 'p_movTxnID';
3105: l_params(14).paramValue := p_movTxnID;
3106:
3107: wip_logger.entryPoint(p_procName => 'wip_bflProc_priv.backflush',
3108: p_params => l_params,
3109: x_returnStatus => l_returnStatus);
3110: END IF;
3111:

Line 3434: wip_logger.log(p_msg => 'before system.wip_lot_serial_obj_t',

3430: END IF; -- l_first_bf_op <> -1
3431: END IF; -- Overmove/ Overcompletion
3432:
3433: if (l_logLevel <= wip_constants.full_logging) then
3434: wip_logger.log(p_msg => 'before system.wip_lot_serial_obj_t',
3435: x_returnStatus => l_returnStatus);
3436: end if;
3437: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl,
3438: null, null);

Line 3440: wip_logger.log(p_msg => 'after system.wip_lot_serial_obj_t',

3436: end if;
3437: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl,
3438: null, null);
3439: if (l_logLevel <= wip_constants.full_logging) then
3440: wip_logger.log(p_msg => 'after system.wip_lot_serial_obj_t',
3441: x_returnStatus => l_returnStatus);
3442: end if;
3443: x_compInfo.initialize;
3444: if (l_logLevel <= wip_constants.full_logging) then

Line 3445: wip_logger.log(p_msg => 'after x_compInfo.initialize',

3441: x_returnStatus => l_returnStatus);
3442: end if;
3443: x_compInfo.initialize;
3444: if (l_logLevel <= wip_constants.full_logging) then
3445: wip_logger.log(p_msg => 'after x_compInfo.initialize',
3446: x_returnStatus => l_returnStatus);
3447: end if;
3448:
3449: -- If serialized return or serialized backward move, we have to derive

Line 3507: wip_logger.exitPoint(

3503: END IF; -- check serialized return or serialized backward move
3504:
3505: x_returnStatus := fnd_api.g_ret_sts_success;
3506: IF (l_logLevel <= wip_constants.trace_logging) THEN
3507: wip_logger.exitPoint(
3508: p_procName => 'wip_bflProc_priv.backflush',
3509: p_procReturnStatus => x_returnStatus,
3510: p_msg => 'Succesfully inserted components into PL/SQL object',
3511: x_returnStatus => l_returnStatus);

Line 3518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3514: WHEN fnd_api.g_exc_unexpected_error THEN
3515: ROLLBACK TO SAVEPOINT s_backflush2;
3516: x_returnStatus := fnd_api.g_ret_sts_error;
3517: IF (l_logLevel <= wip_constants.trace_logging) THEN
3518: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3519: p_procReturnStatus => x_returnStatus,
3520: p_msg => l_errMsg,
3521: x_returnStatus => l_returnStatus);
3522: END IF;

Line 3527: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',

3523: WHEN others THEN
3524: ROLLBACK TO SAVEPOINT s_backflush2;
3525: x_returnStatus := fnd_api.g_ret_sts_error;
3526: IF (l_logLevel <= wip_constants.trace_logging) THEN
3527: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.backflush',
3528: p_procReturnStatus => x_returnStatus,
3529: p_msg => 'Unexpected error : ' || SQLERRM,
3530: x_returnStatus => l_returnStatus);
3531: END IF;