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

Line 56: l_params wip_logger.param_tbl_t;

52: l_issueRec wip_mtlTempProc_grp.comp_rec_t;
53: l_returnStatus VARCHAR2(1);
54: l_invStatus NUMBER;
55: l_errMsg VARCHAR2(2400);
56: l_params wip_logger.param_tbl_t;
57: l_msgCount NUMBER;
58: l_jobStatus NUMBER;
59: l_jobStatusCode VARCHAR2(240);
60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;

Line 71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',

67:
68: if (l_logLevel <= wip_constants.trace_logging) then
69: l_params(1).paramName := 'p_txnTmpID';
70: l_params(1).paramValue := p_txnTmpID;
71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',
72: p_params => l_params,
73: x_returnStatus => x_returnStatus);
74: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
75: raise fnd_api.g_exc_unexpected_error;

Line 163: wip_logger.log('selected job status:' || l_jobStatus, l_returnStatus);

159: from wip_discrete_jobs
160: where wip_entity_id = l_issueRec.wipEntityID;
161:
162: if (l_logLevel <= wip_constants.full_logging) then
163: wip_logger.log('selected job status:' || l_jobStatus, l_returnStatus);
164: end if;
165:
166: if(l_jobStatus not in (wip_constants.released, wip_constants.comp_chrg)) then
167: begin

Line 198: wip_logger.log('about to call EAM processor ', l_returnStatus);

194: -------------------
195: if(l_issueRec.wipEntityType = wip_constants.eam) then
196: --if error occurs, processRebuildable should put an err msg on the stack
197: if (l_logLevel <= wip_constants.full_logging) then
198: wip_logger.log('about to call EAM processor ', l_returnStatus);
199: end if;
200: wip_eamMtlProc_priv.processCompTxn(p_compRec => l_issueRec,
201: x_returnStatus => x_returnStatus);
202: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 239: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

235: end if;
236: end if;
237:
238: if (l_logLevel <= wip_constants.trace_logging) then
239: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
240: p_procReturnStatus => x_returnStatus,
241: p_msg => 'Transaction Succeeded',
242: x_returnStatus => l_returnStatus); --discard logging return status
243: end if;

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

241: p_msg => 'Transaction Succeeded',
242: x_returnStatus => l_returnStatus); --discard logging return status
243: end if;
244: if(fnd_api.to_boolean(p_endDebug)) then
245: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
246: end if;
247: exception
248: --processing error. return status and error msg should have already been set.
249: when no_data_found then

Line 253: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

249: when no_data_found then
250: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
251: rollback to wipmtlpb_SP1;
252: if (l_logLevel <= wip_constants.trace_logging) then
253: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
254: p_procReturnStatus => x_returnStatus,
255: p_msg => 'no data found exception. tmpID:' || p_txnTmpID,
256: x_returnStatus => l_returnStatus); --discard logging return status
257: end if;

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

255: p_msg => 'no data found exception. tmpID:' || p_txnTmpID,
256: x_returnStatus => l_returnStatus); --discard logging return status
257: end if;
258: if(fnd_api.to_boolean(p_endDebug)) then
259: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
260: end if;
261: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
262: fnd_msg_pub.add;
263: writeError(p_txnTmpID);

Line 272: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

268: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
269:
270: writeError(p_txnTmpID); --update the MMTT line to error for wip failures
271: if (l_logLevel <= wip_constants.trace_logging) then
272: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
273: p_procReturnStatus => x_returnStatus,
274: p_msg => l_errMsg,
275: x_returnStatus => l_returnStatus); --discard logging return status
276: end if;

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

274: p_msg => l_errMsg,
275: x_returnStatus => l_returnStatus); --discard logging return status
276: end if;
277: if(fnd_api.to_boolean(p_endDebug)) then
278: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
279: end if;
280: when others then
281: rollback to wipmtlpb_SP1;
282: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 288: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

284: p_procedure_name => 'processTemp',
285: p_error_text => SQLERRM);
286: writeError(p_txnTmpID);
287: if (l_logLevel <= wip_constants.trace_logging) then
288: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
289: p_procReturnStatus => x_returnStatus,
290: p_msg => 'item' || l_issueRec.itemID || ' unexpected error: ' || SQLERRM,
291: x_returnStatus => l_returnStatus); --discard logging return status
292: end if;

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

290: p_msg => 'item' || l_issueRec.itemID || ' unexpected error: ' || SQLERRM,
291: x_returnStatus => l_returnStatus); --discard logging return status
292: end if;
293: if(fnd_api.to_boolean(p_endDebug)) then
294: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
295: end if;
296: end processTemp;
297:
298: procedure fillIssueParamTbl(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

Line 299: x_params OUT NOCOPY wip_logger.param_tbl_t)

295: end if;
296: end processTemp;
297:
298: procedure fillIssueParamTbl(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
299: x_params OUT NOCOPY wip_logger.param_tbl_t)
300: is begin
301:
302: x_params(1).paramName := 'p_issueRec.txnTmpID';
303: x_params(1).paramValue := p_issueRec.txnTmpID;

Line 367: l_params wip_logger.param_tbl_t;

363: p_repSchedID IN NUMBER,
364: x_returnStatus OUT NOCOPY VARCHAR2) IS
365: l_rowid ROWID;
366: l_doUpdate boolean := true;
367: l_params wip_logger.param_tbl_t;
368: l_paramCount NUMBER;
369: l_errMsg VARCHAR2(240);
370: l_returnStatus VARCHAR2(1);
371: l_newRequiredQty NUMBER;

Line 377: wip_logger.log('processTxn: p_issueQty: ' || p_issueQty, l_returnStatus);

373: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
374: l_dept_id NUMBER := null; /* Bugfix 5401362 */
375: begin
376: if (l_logLevel <= wip_constants.full_logging) then
377: wip_logger.log('processTxn: p_issueQty: ' || p_issueQty, l_returnStatus);
378: end if;
379: --just logs the issue record. moved to a helper just to keep procedure small
380:
381: if (l_logLevel <= wip_constants.trace_logging) then

Line 389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',

385: l_params(l_paramCount + 1).paramName := 'p_issueQty';
386: l_params(l_paramCount + 1).paramValue := p_issueQty;
387: l_params(l_paramCount + 2).paramName := 'p_repSchedID';
388: l_params(l_paramCount + 2).paramValue := p_repSchedID;
389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',
390: p_params => l_params,
391: x_returnStatus => x_returnStatus);
392: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
393: raise fnd_api.g_exc_unexpected_error;

Line 412: wip_logger.log('do update is true', l_returnStatus);

408: l_doUpdate := false;
409: end;
410: if(l_doUpdate) then
411: if (l_logLevel <= wip_constants.full_logging) then
412: wip_logger.log('do update is true', l_returnStatus);
413: end if;
414: --below, quantity_allocated must be >= 0. At the same time, it must never increase via a return, negative issue.
415: --only the component picking process should increase the quantity_allocated column
416: update wip_requirement_operations --try to update an existing requirement

Line 461: wip_logger.log('about to do insert', l_returnStatus);

457: end if;
458:
459: if(not l_doUpdate) then --create the requirement since we could not find an existing one
460: if (l_logLevel <= wip_constants.full_logging) then
461: wip_logger.log('about to do insert', l_returnStatus);
462: end if;
463:
464: /* Bugfix 5401362. Default department_id when null */
465: if (p_issueRec.deptID is null) then

Line 578: wip_logger.log('inserted ' || SQL %ROWCOUNT, l_returnStatus);

574: WHERE ORGANIZATION_ID = p_issueRec.orgID
575: AND INVENTORY_ITEM_ID = p_issueRec.itemID;
576:
577: if (l_logLevel <= wip_constants.full_logging) then
578: wip_logger.log('inserted ' || SQL %ROWCOUNT, l_returnStatus);
579: end if;
580: end if;
581:
582: x_returnStatus := fnd_api.g_ret_sts_success;

Line 585: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

581:
582: x_returnStatus := fnd_api.g_ret_sts_success;
583:
584: if (l_logLevel <= wip_constants.trace_logging) then
585: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
586: p_procReturnStatus => x_returnStatus,
587: p_msg => 'procedure success',
588: x_returnStatus => l_returnStatus); --discard logging return status
589: end if;

Line 594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

590: exception
591: when fnd_api.g_exc_unexpected_error then
592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
593: if (l_logLevel <= wip_constants.trace_logging) then
594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
595: p_procReturnStatus => x_returnStatus,
596: p_msg => l_errMsg,
597: x_returnStatus => l_returnStatus); --discard logging return status
598: end if;

Line 605: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

601: --need to add a message to the stack and count it
602: when wip_constants.records_locked then
603: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
604: if (l_logLevel <= wip_constants.trace_logging) then
605: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
606: p_procReturnStatus => x_returnStatus,
607: p_msg => 'records locked',
608: x_returnStatus => l_returnStatus);
609: end if;

Line 618: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

614: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
615: p_procedure_name => 'processTxn',
616: p_error_text => SQLERRM);
617: if (l_logLevel <= wip_constants.trace_logging) then
618: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
619: p_procReturnStatus => x_returnStatus,
620: p_msg => 'unexpected error: ' || SQLERRM,
621: x_returnStatus => l_returnStatus); --discard logging return status
622: end if;

Line 916: l_params wip_logger.param_tbl_t;

912: l_schedID NUMBER;
913: l_excessQtySchedID NUMBER;--if not enough open qty for txn, excess qty goes to this sched
914: l_schedQty NUMBER;
915: l_issueQty NUMBER;
916: l_params wip_logger.param_tbl_t;
917: l_errMsg VARCHAR2(240);
918: l_returnStatus VARCHAR2(1);
919: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
920: l_schedTbl num_tbl_t;--TABLE OF NUMBER;

Line 931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

927: begin
928: if (l_logLevel <= wip_constants.trace_logging) then
929: fillIssueParamTbl(p_issueRec => p_issueRec,
930: x_params => l_params);
931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
932: p_params => l_params,
933: x_returnStatus => x_returnStatus);
934: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
935: raise fnd_api.g_exc_unexpected_error;

Line 940: wip_logger.log('remaining qty:' || l_remQty, l_returnStatus);

936: end if;
937: end if;
938:
939: if (l_logLevel <= wip_constants.full_logging) then
940: wip_logger.log('remaining qty:' || l_remQty, l_returnStatus);
941: end if;
942:
943: populateRepScheds(p_issueRec => p_issueRec,
944: x_schedTbl => l_schedTbl,

Line 974: wip_logger.log('start loop', l_returnStatus);

970: -- Fix for Bug#5374443 : Round l_qtyTbl(i) to 6 decimals as corresponding MMTT qty is rounded to 6 decimal precision.
971: l_qtyTbl(i) := round(l_qtyTbl(i),6);
972:
973: if (l_logLevel <= wip_constants.full_logging) then
974: wip_logger.log('start loop', l_returnStatus);
975: wip_logger.log(' sched_id:' || l_schedTbl(i), l_returnStatus);
976: wip_logger.log(' sched_qty:' || l_qtyTbl(i), l_returnStatus);
977: end if;
978:

Line 975: wip_logger.log(' sched_id:' || l_schedTbl(i), l_returnStatus);

971: l_qtyTbl(i) := round(l_qtyTbl(i),6);
972:
973: if (l_logLevel <= wip_constants.full_logging) then
974: wip_logger.log('start loop', l_returnStatus);
975: wip_logger.log(' sched_id:' || l_schedTbl(i), l_returnStatus);
976: wip_logger.log(' sched_qty:' || l_qtyTbl(i), l_returnStatus);
977: end if;
978:
979: if(round(l_qtyTbl(i), wip_constants.inv_max_precision) = 0) then

Line 976: wip_logger.log(' sched_qty:' || l_qtyTbl(i), l_returnStatus);

972:
973: if (l_logLevel <= wip_constants.full_logging) then
974: wip_logger.log('start loop', l_returnStatus);
975: wip_logger.log(' sched_id:' || l_schedTbl(i), l_returnStatus);
976: wip_logger.log(' sched_qty:' || l_qtyTbl(i), l_returnStatus);
977: end if;
978:
979: if(round(l_qtyTbl(i), wip_constants.inv_max_precision) = 0) then
980: goto END_OF_LOOP;

Line 990: wip_logger.log(' l_remQty:' || l_remQty, l_returnStatus);

986: l_issueQty := l_remQty * sign(p_issueRec.primaryQty);
987: l_remQty := 0;
988: end if;
989: if (l_logLevel <= wip_constants.full_logging) then
990: wip_logger.log(' l_remQty:' || l_remQty, l_returnStatus);
991: wip_logger.log(' l_issQty:' || l_issueQty, l_returnStatus);
992: wip_logger.log(' sign(priQty):' || sign(p_issueRec.primaryQty), l_returnStatus);
993: end if;
994:

Line 991: wip_logger.log(' l_issQty:' || l_issueQty, l_returnStatus);

987: l_remQty := 0;
988: end if;
989: if (l_logLevel <= wip_constants.full_logging) then
990: wip_logger.log(' l_remQty:' || l_remQty, l_returnStatus);
991: wip_logger.log(' l_issQty:' || l_issueQty, l_returnStatus);
992: wip_logger.log(' sign(priQty):' || sign(p_issueRec.primaryQty), l_returnStatus);
993: end if;
994:
995: if(mod(l_mmtaRowCount, g_extendAmount) = 0) then

Line 992: wip_logger.log(' sign(priQty):' || sign(p_issueRec.primaryQty), l_returnStatus);

988: end if;
989: if (l_logLevel <= wip_constants.full_logging) then
990: wip_logger.log(' l_remQty:' || l_remQty, l_returnStatus);
991: wip_logger.log(' l_issQty:' || l_issueQty, l_returnStatus);
992: wip_logger.log(' sign(priQty):' || sign(p_issueRec.primaryQty), l_returnStatus);
993: end if;
994:
995: if(mod(l_mmtaRowCount, g_extendAmount) = 0) then
996: l_mmta_schedIdTbl.extend(g_extendAmount);

Line 1006: wip_logger.log('inserted sched:' || l_schedTbl(i) || '; qty:' || l_mmta_priQtyTbl(l_mmtaRowCount), l_returnStatus);

1002: l_mmta_priQtyTbl(l_mmtaRowCount) := -1 * l_issueQty; --make qty relative to inv for quantities
1003: l_mmta_txnQtyTbl(l_mmtaRowCount) := round(-1 * (l_issueQty/p_issueRec.primaryQty) * p_issueRec.txnQty, wip_constants.inv_max_precision);
1004:
1005: if (l_logLevel <= wip_constants.full_logging) then
1006: wip_logger.log('inserted sched:' || l_schedTbl(i) || '; qty:' || l_mmta_priQtyTbl(l_mmtaRowCount), l_returnStatus);
1007: end if;
1008:
1009: processTxn(p_issueRec => p_issueRec,
1010: p_issueQty => l_issueQty, --override p_issueRec.primaryQty

Line 1022: wip_logger.log('remQty:' || l_remQty, l_returnStatus);

1018: <>
1019: null;
1020: end loop;
1021: if (l_logLevel <= wip_constants.full_logging) then
1022: wip_logger.log('remQty:' || l_remQty, l_returnStatus);
1023: end if;
1024:
1025: if(l_remQty > 0) then --should only happen for push txns
1026: if(l_excessQtySchedID is null) then

Line 1075: wip_logger.log('rowcount ' || l_mmtaRowCount || ' rows.', l_returnStatus);

1071: end if;
1072: end if;
1073:
1074: if (l_logLevel <= wip_constants.full_logging) then
1075: wip_logger.log('rowcount ' || l_mmtaRowCount || ' rows.', l_returnStatus);
1076: end if;
1077:
1078: --now trim unused rows
1079: l_mmta_schedIdTbl.trim(g_extendAmount - mod(l_mmtaRowCount, g_extendAmount));

Line 1119: wip_logger.log(SQL%ROWCOUNT || ' row inserted into MMTA', l_returnStatus);

1115: l_mmta_txnQtyTbl(i),
1116: p_issueRec.txnDate);
1117:
1118: if (l_logLevel <= wip_constants.full_logging) then
1119: wip_logger.log(SQL%ROWCOUNT || ' row inserted into MMTA', l_returnStatus);
1120: wip_logger.log('txn id' || p_issueRec.mtlTxnID, l_returnStatus);
1121: end if;
1122:
1123: if (l_logLevel <= wip_constants.trace_logging) then

Line 1120: wip_logger.log('txn id' || p_issueRec.mtlTxnID, l_returnStatus);

1116: p_issueRec.txnDate);
1117:
1118: if (l_logLevel <= wip_constants.full_logging) then
1119: wip_logger.log(SQL%ROWCOUNT || ' row inserted into MMTA', l_returnStatus);
1120: wip_logger.log('txn id' || p_issueRec.mtlTxnID, l_returnStatus);
1121: end if;
1122:
1123: if (l_logLevel <= wip_constants.trace_logging) then
1124: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

Line 1124: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1120: wip_logger.log('txn id' || p_issueRec.mtlTxnID, l_returnStatus);
1121: end if;
1122:
1123: if (l_logLevel <= wip_constants.trace_logging) then
1124: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1125: p_procReturnStatus => x_returnStatus,
1126: p_msg => 'procedure success.',
1127: x_returnStatus => l_returnStatus); --discard logging return status
1128: end if;

Line 1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1129: exception
1130: when fnd_api.g_exc_unexpected_error then
1131: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1132: if (l_logLevel <= wip_constants.trace_logging) then
1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1134: p_procReturnStatus => x_returnStatus,
1135: p_msg => l_errMsg,
1136: x_returnStatus => l_returnStatus); --discard logging return status
1137: end if;

Line 1144: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
1141: p_procedure_name => 'processRepetitive',
1142: p_error_text => SQLERRM);
1143: if (l_logLevel <= wip_constants.trace_logging) then
1144: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1145: p_procReturnStatus => x_returnStatus,
1146: p_msg => 'unexpected error: ' || SQLERRM,
1147: x_returnStatus => l_returnStatus); --discard logging return status
1148: end if;

Line 1163: wip_logger.log('writeError: tempID is ' || p_txnTmpID, l_returnStatus);

1159: p_msg => l_errExpl);
1160: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
1161: l_errCode := fnd_message.get;
1162: if (l_logLevel <= wip_constants.full_logging) then
1163: wip_logger.log('writeError: tempID is ' || p_txnTmpID, l_returnStatus);
1164: wip_logger.log('writeError: errCode is ' ||l_errCode, l_returnStatus);
1165: wip_logger.log('writeError: errExpl is ' ||l_errExpl, l_returnStatus);
1166: end if;
1167: update mtl_material_transactions_temp

Line 1164: wip_logger.log('writeError: errCode is ' ||l_errCode, l_returnStatus);

1160: fnd_message.set_name('WIP', 'MTL_PROC_FAIL');
1161: l_errCode := fnd_message.get;
1162: if (l_logLevel <= wip_constants.full_logging) then
1163: wip_logger.log('writeError: tempID is ' || p_txnTmpID, l_returnStatus);
1164: wip_logger.log('writeError: errCode is ' ||l_errCode, l_returnStatus);
1165: wip_logger.log('writeError: errExpl is ' ||l_errExpl, l_returnStatus);
1166: end if;
1167: update mtl_material_transactions_temp
1168: set error_code = substr(l_errCode, 1, 240),

Line 1165: wip_logger.log('writeError: errExpl is ' ||l_errExpl, l_returnStatus);

1161: l_errCode := fnd_message.get;
1162: if (l_logLevel <= wip_constants.full_logging) then
1163: wip_logger.log('writeError: tempID is ' || p_txnTmpID, l_returnStatus);
1164: wip_logger.log('writeError: errCode is ' ||l_errCode, l_returnStatus);
1165: wip_logger.log('writeError: errExpl is ' ||l_errExpl, l_returnStatus);
1166: end if;
1167: update mtl_material_transactions_temp
1168: set error_code = substr(l_errCode, 1, 240),
1169: error_explanation = substr(l_errExpl, 1, 240),

Line 1185: l_params wip_logger.param_tbl_t;

1181: l_ret_value NUMBER;
1182: l_error_msg VARCHAR2(1000);
1183: l_process_phase VARCHAR2(3);
1184: l_return_status VARCHAR(1);
1185: l_params wip_logger.param_tbl_t;
1186: BEGIN
1187: l_process_phase := '1';
1188: IF (l_log_level <= wip_constants.trace_logging) THEN
1189: l_params(1).paramName := 'p_mtl_header_id';

Line 1191: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1187: l_process_phase := '1';
1188: IF (l_log_level <= wip_constants.trace_logging) THEN
1189: l_params(1).paramName := 'p_mtl_header_id';
1190: l_params(1).paramValue := p_mtl_header_id;
1191: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1192: p_params => l_params,
1193: x_returnStatus => l_return_status);
1194: END IF;
1195: l_process_phase := '2';

Line 1227: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1223: x_returnStatus := fnd_api.g_ret_sts_success;
1224:
1225: -- write to the log file
1226: IF (l_log_level <= wip_constants.trace_logging) THEN
1227: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1228: p_procReturnStatus => x_returnStatus,
1229: p_msg => 'procedure complete',
1230: x_returnStatus => l_return_status);
1231: END IF;

Line 1233: wip_logger.cleanUp(x_returnStatus => l_return_status);

1229: p_msg => 'procedure complete',
1230: x_returnStatus => l_return_status);
1231: END IF;
1232: -- close log file
1233: wip_logger.cleanUp(x_returnStatus => l_return_status);
1234: EXCEPTION
1235: WHEN fnd_api.g_exc_unexpected_error THEN
1236: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1237: x_returnStatus := fnd_api.g_ret_sts_error;

Line 1240: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1236: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1237: x_returnStatus := fnd_api.g_ret_sts_error;
1238:
1239: IF (l_log_level <= wip_constants.trace_logging) THEN
1240: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1241: p_procReturnStatus => x_returnStatus,
1242: p_msg => 'wip_cplProc_priv.processOATxn failed : '
1243: || l_process_phase,
1244: x_returnStatus => l_return_status);

Line 1247: wip_logger.cleanUp(x_returnStatus => l_return_status);

1243: || l_process_phase,
1244: x_returnStatus => l_return_status);
1245: END IF;
1246: -- close log file
1247: wip_logger.cleanUp(x_returnStatus => l_return_status);
1248: WHEN others THEN
1249: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1250: x_returnStatus := fnd_api.g_ret_sts_error;
1251: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||

Line 1259: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',

1255: fnd_message.set_token('MESSAGE', l_error_msg);
1256: fnd_msg_pub.add;
1257:
1258: IF (l_log_level <= wip_constants.trace_logging) THEN
1259: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',
1260: p_procReturnStatus => x_returnStatus,
1261: p_msg => l_error_msg || ' : ' || l_process_phase,
1262: x_returnStatus => l_return_status);
1263: END IF;

Line 1265: wip_logger.cleanUp(x_returnStatus => l_return_status);

1261: p_msg => l_error_msg || ' : ' || l_process_phase,
1262: x_returnStatus => l_return_status);
1263: END IF;
1264: -- close log file
1265: wip_logger.cleanUp(x_returnStatus => l_return_status);
1266: END processOATxn;
1267:
1268: end wip_mtlProc_priv;