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

Line 17: l_params wip_logger.param_tbl_t;

13: x_returnStatus OUT NOCOPY VARCHAR2,
14: x_errorMsg OUT NOCOPY VARCHAR2) IS
15: l_errMsg VARCHAR2(2000);
16: l_errCode VARCHAR2(2000);
17: l_params wip_logger.param_tbl_t;
18: l_retStatus VARCHAR2(1);
19: l_logRetStatus VARCHAR2(1);
20: l_retCode NUMBER;
21: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

41: l_params(3).paramName := 'p_txnMode';
42: l_params(3).paramValue := p_txnMode;
43: l_params(4).paramName := 'p_destroyQtyTrees';
44: l_params(4).paramValue := p_destroyQtyTrees;
45: wip_logger.entryPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
46: p_params => l_params,
47: x_returnStatus => x_returnStatus);
48: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
49: raise fnd_api.g_exc_unexpected_error;

Line 63: wip_logger.log('inv returned:' || l_retCode, l_retStatus);

59: p_proc_mode => p_txnMode,
60: x_proc_msg => l_errMsg);
61:
62: if(l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('inv returned:' || l_retCode, l_retStatus);
64: wip_logger.log('inv errmsg:' || l_errMsg, l_retStatus);
65: end if;
66:
67: --for some reason TM errors clear the stack so we must put the

Line 64: wip_logger.log('inv errmsg:' || l_errMsg, l_retStatus);

60: x_proc_msg => l_errMsg);
61:
62: if(l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('inv returned:' || l_retCode, l_retStatus);
64: wip_logger.log('inv errmsg:' || l_errMsg, l_retStatus);
65: end if;
66:
67: --for some reason TM errors clear the stack so we must put the
68: --error message back, but successful txns do not clear the stack

Line 90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

86: inv_quantity_tree_pub.clear_quantity_cache;
87: end if;
88:
89: if (l_logLevel <= wip_constants.trace_logging) then
90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
91: p_procReturnStatus => x_returnStatus,
92: p_msg => 'success',
93: x_returnStatus => l_retStatus);
94: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 95: wip_logger.cleanup(l_retStatus);

91: p_procReturnStatus => x_returnStatus,
92: p_msg => 'success',
93: x_returnStatus => l_retStatus);
94: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
95: wip_logger.cleanup(l_retStatus);
96: end if;
97: end if;
98: exception
99: when fnd_api.g_exc_unexpected_error then

Line 105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

101: wip_utilities.get_message_stack(p_msg => x_errorMsg,
102: p_delete_stack => fnd_api.g_false,
103: p_separator => ' ');
104: if (l_logLevel <= wip_constants.trace_logging) then
105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'unhandled exception: ' || SQLERRM,
108: x_returnStatus => l_retStatus);
109: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 110: wip_logger.cleanup(l_retStatus);

106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'unhandled exception: ' || SQLERRM,
108: x_returnStatus => l_retStatus);
109: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
110: wip_logger.cleanup(l_retStatus);
111: end if;
112: end if;
113: when others then
114: rollback to wiptmpvb0;

Line 138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
139: p_procReturnStatus => x_returnStatus,
140: p_msg => 'unhandled exception: ' || SQLERRM,
141: x_returnStatus => l_retStatus);
142: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 143: wip_logger.cleanup(l_retStatus);

139: p_procReturnStatus => x_returnStatus,
140: p_msg => 'unhandled exception: ' || SQLERRM,
141: x_returnStatus => l_retStatus);
142: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
143: wip_logger.cleanup(l_retStatus);
144: end if;
145: end if;
146: end processTemp;
147:

Line 154: l_params wip_logger.param_tbl_t;

150: p_endDebug in VARCHAR2 := null,
151: x_returnStatus OUT NOCOPY VARCHAR2,
152: x_errorMsg OUT NOCOPY VARCHAR2) is
153: l_retStatus VARCHAR2(1);
154: l_params wip_logger.param_tbl_t;
155: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
156: l_procName VARCHAR2(20) := 'processWIP';
157: l_txnActionID NUMBER;
158: l_wipEntityType NUMBER;

Line 184: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

180: l_params(1).paramName := 'p_txnTmpID';
181: l_params(1).paramValue := p_txnTmpID;
182: l_params(2).paramName := 'p_processLpn';
183: l_params(2).paramValue := p_processLpn;
184: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
185: p_params => l_params,
186: x_returnStatus => x_returnStatus);
187: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
188: raise fnd_api.g_exc_unexpected_error;

Line 229: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

225: delete mtl_material_transactions_temp
226: where transaction_temp_id = p_txnTmpID;
227:
228: if(l_logLevel <= wip_constants.trace_logging) then
229: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
230: p_procReturnStatus => x_returnStatus,
231: p_msg => 'success: phantom record deleted without any action',
232: x_returnStatus => l_retStatus);
233: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 234: wip_logger.cleanup(l_retStatus);

230: p_procReturnStatus => x_returnStatus,
231: p_msg => 'success: phantom record deleted without any action',
232: x_returnStatus => l_retStatus);
233: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
234: wip_logger.cleanup(l_retStatus);
235: end if;
236: end if;
237: return;
238: end if;

Line 250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);

246: and organization_id = l_orgID;
247: end if;
248:
249: if(l_logLevel <= wip_constants.full_logging) then
250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);

Line 251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);

247: end if;
248:
249: if(l_logLevel <= wip_constants.full_logging) then
250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);

Line 252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);

248:
249: if(l_logLevel <= wip_constants.full_logging) then
250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);
256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);

Line 253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);

249: if(l_logLevel <= wip_constants.full_logging) then
250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);
256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
257: end if;

Line 254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);

250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);
256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
257: end if;
258:

Line 255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);

251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);
256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
257: end if;
258:
259: --component issues

Line 256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);

252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);
254: wip_logger.log('orgID: ' || l_orgID, l_retStatus);
255: wip_logger.log('postingFlag: ' || l_postingFlag, l_retStatus);
256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
257: end if;
258:
259: --component issues
260: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 265: wip_logger.log('calling component processor', l_retStatus);

261: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
262: --no action is necessary for flow txns
263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);
266: end if;
267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
268: p_endDebug => fnd_api.g_false,
269: p_txnTmpID => p_txnTmpID,

Line 278: wip_logger.log('calling flow/wol processor', l_retStatus);

274: --no action is necessary for lpn completions
275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then
278: wip_logger.log('calling flow/wol processor', l_retStatus);
279: end if;
280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
281: p_txnTempID => p_txnTmpID,
282: x_returnStatus => x_returnStatus);

Line 285: wip_logger.log('calling cpl processor', l_retStatus);

281: p_txnTempID => p_txnTmpID,
282: x_returnStatus => x_returnStatus);
283: else --non flow completion
284: if(l_logLevel <= wip_constants.full_logging) then
285: wip_logger.log('calling cpl processor', l_retStatus);
286: end if;
287: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
288: p_initMsgList => fnd_api.g_false,
289: p_endDebug => fnd_api.g_false,

Line 297: wip_logger.log('calling rep scrap processor', l_retStatus);

293: elsif(l_txnActionID = wip_constants.scrassy_action) then
294: --for repetitive, must do allocation
295: if(l_wipEntityType = wip_constants.repetitive) then
296: if(l_logLevel <= wip_constants.full_logging) then
297: wip_logger.log('calling rep scrap processor', l_retStatus);
298: end if;
299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
300: x_returnStatus => x_returnStatus);
301: elsif (l_wipEntityType = wip_constants.flow) then

Line 303: wip_logger.log('calling flow/wol processor', l_retStatus);

299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
300: x_returnStatus => x_returnStatus);
301: elsif (l_wipEntityType = wip_constants.flow) then
302: if(l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log('calling flow/wol processor', l_retStatus);
304: end if;
305: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
306: p_txnTempID => p_txnTmpID,
307: x_returnStatus => x_returnStatus);

Line 316: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

312: raise fnd_api.g_exc_unexpected_error;
313: end if;
314:
315: if(l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
317: p_procReturnStatus => x_returnStatus,
318: p_msg => 'success',
319: x_returnStatus => l_retStatus);
320: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 321: wip_logger.cleanup(l_retStatus);

317: p_procReturnStatus => x_returnStatus,
318: p_msg => 'success',
319: x_returnStatus => l_retStatus);
320: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
321: wip_logger.cleanup(l_retStatus);
322: end if;
323: end if;
324:
325: /*Start - Bug 6417742(FP of 6342851): Added call label printing*/

Line 340: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||

336: -- do not error out if label printing, only put warning message in log
337: if(returnStatus <> fnd_api.g_ret_sts_success) then
338: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
339: if (l_logLevel <= wip_constants.full_logging) then
340: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
341: 'The following error has occurred during ' ||
342: 'printing: ' || l_msg_stack || '\n' ||
343: 'Please check the Inventory log file for more ' ||
344: 'information.',

Line 349: wip_logger.log(p_msg => 'Label printing returned with status ' ||

345: x_returnStatus =>dummyErrCode);
346: end if;
347: end if;
348: if (l_logLevel <= wip_constants.full_logging) then
349: wip_logger.log(p_msg => 'Label printing returned with status ' ||
350: returnStatus,
351: x_returnStatus => dummyErrCode);
352: end if;
353: end if;

Line 363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
360: wip_utilities.get_message_stack(p_msg => x_errorMsg,
361: p_delete_stack => fnd_api.g_false);
362: if(l_logLevel <= wip_constants.trace_logging) then
363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
364: p_procReturnStatus => x_returnStatus,
365: p_msg => 'error:' || x_errorMsg,
366: x_returnStatus => l_retStatus);
367: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 368: wip_logger.cleanup(l_retStatus);

364: p_procReturnStatus => x_returnStatus,
365: p_msg => 'error:' || x_errorMsg,
366: x_returnStatus => l_retStatus);
367: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
368: wip_logger.cleanup(l_retStatus);
369: end if;
370: end if;
371: when others then
372: rollback to wiptmpvb100;

Line 380: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

376: p_error_text => SQLERRM);
377: wip_utilities.get_message_stack(p_msg => x_errorMsg,
378: p_delete_stack => fnd_api.g_false);
379: if(l_logLevel <= wip_constants.trace_logging) then
380: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
381: p_procReturnStatus => x_returnStatus,
382: p_msg => 'unexp error:' || x_errorMsg,
383: x_returnStatus => l_retStatus);
384: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then

Line 385: wip_logger.cleanup(l_retStatus);

381: p_procReturnStatus => x_returnStatus,
382: p_msg => 'unexp error:' || x_errorMsg,
383: x_returnStatus => l_retStatus);
384: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_false))) then
385: wip_logger.cleanup(l_retStatus);
386: end if;
387: end if;
388: end processWIP;
389:

Line 404: l_params wip_logger.param_tbl_t;

400: l_numErrRows NUMBER;
401: l_msgCount NUMBER;
402: l_msgData VARCHAR2(2000);
403: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
404: l_params wip_logger.param_tbl_t;
405: type err_tbl_t is table of varchar2(240);
406: type item_tbl_t is table of varchar2(2000);
407: l_errExplTbl err_tbl_t;
408: l_itemNameTbl item_tbl_t;

Line 420: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

416: if (l_logLevel <= wip_constants.trace_logging) then
417: l_params(1).paramName := 'p_txnHdrID';
418: l_params(1).paramValue := p_txnHdrID;
419:
420: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
421: p_params => l_params,
422: x_returnStatus => x_returnStatus);
423: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
424: raise fnd_api.g_exc_unexpected_error;

Line 442: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

438: end if;
439:
440: if(l_numIntRows = 0) then
441: if(l_logLevel <= wip_constants.trace_logging) then
442: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
443: p_procReturnStatus => x_returnStatus,
444: p_msg => 'no rows to backflush',
445: x_returnStatus => l_retStatus);
446: if(fnd_api.to_boolean(l_endDebug)) then

Line 447: wip_logger.cleanup(l_retStatus);

443: p_procReturnStatus => x_returnStatus,
444: p_msg => 'no rows to backflush',
445: x_returnStatus => l_retStatus);
446: if(fnd_api.to_boolean(l_endDebug)) then
447: wip_logger.cleanup(l_retStatus);
448: end if;
449: end if;
450: return;
451: end if;

Line 480: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

476: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
477: fnd_msg_pub.initialize;
478: end if;
479: if(l_logLevel <= wip_constants.trace_logging) then
480: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
481: p_procReturnStatus => x_returnStatus,
482: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
483: x_returnStatus => l_retStatus);
484: if(fnd_api.to_boolean(l_endDebug)) then

Line 485: wip_logger.cleanup(l_retStatus);

481: p_procReturnStatus => x_returnStatus,
482: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
483: x_returnStatus => l_retStatus);
484: if(fnd_api.to_boolean(l_endDebug)) then
485: wip_logger.cleanup(l_retStatus);
486: end if;
487: end if;
488: return;
489: end if;

Line 516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);

512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
515: if(l_logLevel <= wip_constants.trace_logging) then
516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);
517: end if;
518: fnd_msg_pub.add;
519: end loop;
520: end if;

Line 527: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

523: rollback to wiptmpvb200;
524: end if;
525:
526: if(l_logLevel <= wip_constants.trace_logging) then
527: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
528: p_procReturnStatus => x_returnStatus,
529: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
530: x_returnStatus => l_retStatus);
531: if(fnd_api.to_boolean(l_endDebug)) then

Line 532: wip_logger.cleanup(l_retStatus);

528: p_procReturnStatus => x_returnStatus,
529: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
530: x_returnStatus => l_retStatus);
531: if(fnd_api.to_boolean(l_endDebug)) then
532: wip_logger.cleanup(l_retStatus);
533: end if;
534: end if;
535:
536: exception

Line 564: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

560: fnd_message.set_token('MESSAGE', l_msgData);
561: fnd_msg_pub.add;
562: end if;
563: if(l_logLevel <= wip_constants.trace_logging) then
564: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
565: p_procReturnStatus => x_returnStatus,
566: p_msg => 'error:' || l_msgData,
567: x_returnStatus => l_retStatus);
568: if(fnd_api.to_boolean(l_endDebug)) then

Line 569: wip_logger.cleanup(l_retStatus);

565: p_procReturnStatus => x_returnStatus,
566: p_msg => 'error:' || l_msgData,
567: x_returnStatus => l_retStatus);
568: if(fnd_api.to_boolean(l_endDebug)) then
569: wip_logger.cleanup(l_retStatus);
570: end if;
571: end if;
572: when others then
573: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 598: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

594: where transaction_header_id = p_txnHdrID;
595: end if;
596:
597: if(l_logLevel <= wip_constants.trace_logging) then
598: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
599: p_procReturnStatus => x_returnStatus,
600: p_msg => 'unexp error:' || l_msgData,
601: x_returnStatus => l_retStatus);
602: if(fnd_api.to_boolean(l_endDebug)) then

Line 603: wip_logger.cleanup(l_retStatus);

599: p_procReturnStatus => x_returnStatus,
600: p_msg => 'unexp error:' || l_msgData,
601: x_returnStatus => l_retStatus);
602: if(fnd_api.to_boolean(l_endDebug)) then
603: wip_logger.cleanup(l_retStatus);
604: end if;
605: end if;
606: end validateInterfaceTxns;
607: