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

Line 19: l_params wip_logger.param_tbl_t;

15: procedure processInterface(p_txnHdrID IN NUMBER,
16: p_commit IN VARCHAR2 := fnd_api.g_false,
17: x_returnStatus OUT NOCOPY VARCHAR2) is
18: l_returnStatus VARCHAR2(1);
19: l_params wip_logger.param_tbl_t;
20: l_errCodeTbl err_tbl_t;
21: l_errExpTbl err_tbl_t;
22: l_intTbl num_tbl_t;
23: l_errMessage VARCHAR2(2000);

Line 32: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

28:
29: if (l_logLevel <= wip_constants.trace_logging) then
30: l_params(1).paramName := 'p_txnHdrID';
31: l_params(1).paramValue := p_txnHdrID;
32: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
33: p_params => l_params,
34: x_returnStatus => x_returnStatus);
35: end if;
36:

Line 55: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

51: commit;
52: end if;
53:
54: if (l_logLevel <= wip_constants.trace_logging) then
55: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
56: p_procReturnStatus => x_returnStatus,
57: p_msg => 'attempted to process all rows successfully (no exceptions encountered).',
58: x_returnStatus => l_returnStatus); --discard logging return status
59: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

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

55: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
56: p_procReturnStatus => x_returnStatus,
57: p_msg => 'attempted to process all rows successfully (no exceptions encountered).',
58: x_returnStatus => l_returnStatus); --discard logging return status
59: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
60: end if;
61: exception
62: when fnd_api.g_exc_unexpected_error then
63: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 68: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

64: wip_utilities.get_message_stack(p_msg => l_errMessage,
65: p_separator => ' ',
66: p_delete_stack => fnd_api.g_false);
67: if (l_logLevel <= wip_constants.trace_logging) then
68: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
69: p_procReturnStatus => x_returnStatus,
70: p_msg => 'proc failure:' || l_errMessage,
71: x_returnStatus => l_returnStatus); --discard logging return status
72:

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

69: p_procReturnStatus => x_returnStatus,
70: p_msg => 'proc failure:' || l_errMessage,
71: x_returnStatus => l_returnStatus); --discard logging return status
72:
73: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
74: end if;
75:
76: l_errMessage := substr(l_errMessage,1,240);
77:

Line 97: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

93: end loop;
94: when others then --some unhandled exception occurred. rollback everything.
95: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
96: if (l_logLevel <= wip_constants.trace_logging) then
97: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
98: p_procReturnStatus => x_returnStatus,
99: p_msg => 'exception' || SQLERRM,
100: x_returnStatus => l_returnStatus); --discard logging return status
101:

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

98: p_procReturnStatus => x_returnStatus,
99: p_msg => 'exception' || SQLERRM,
100: x_returnStatus => l_returnStatus); --discard logging return status
101:
102: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
103: end if;
104: rollback to wipintpb0;
105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
106: p_procedure_name => 'processInterface',

Line 130: l_params wip_logger.param_tbl_t;

126: cursor c_mtiRow is
127: select error_explanation
128: from mtl_transactions_interface
129: where transaction_interface_id = p_txnIntID;
130: l_params wip_logger.param_tbl_t;
131: l_msg VARCHAR2(100);
132: l_returnStatus VARCHAR2(1);
133: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
134: begin

Line 140: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: l_params(1).paramName := 'p_txnIntID';
139: l_params(1).paramValue := p_txnIntID;
140: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
141: p_params => l_params,
142: x_returnStatus => x_returnStatus);
143:
144: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 147: wip_logger.cleanUp(x_returnStatus=>l_returnStatus);

143:
144: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
145: raise fnd_api.g_exc_error;
146: end if;
147: wip_logger.cleanUp(x_returnStatus=>l_returnStatus);
148: end if;
149:
150: --must be a single wip transaction that has not yet errored
151: select rowid, transaction_header_id

Line 178: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

174: end if;
175:
176: l_msg := 'success';
177: if (l_logLevel <= wip_constants.trace_logging) then
178: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
179: p_procReturnStatus => x_returnStatus,
180: p_msg => l_msg,
181: x_returnStatus => l_returnStatus); --discard logging return status
182:

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

179: p_procReturnStatus => x_returnStatus,
180: p_msg => l_msg,
181: x_returnStatus => l_returnStatus); --discard logging return status
182:
183: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
184: end if;
185:
186: exception
187: when fnd_api.g_exc_error then

Line 193: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

189: wip_utilities.get_message_stack(p_msg => x_errorMsg,
190: p_separator => ' ',
191: p_delete_stack => fnd_api.g_false);
192: if (l_logLevel <= wip_constants.trace_logging) then
193: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
194: p_procReturnStatus => x_returnStatus,
195: p_msg => 'MTI failure: ' || l_msg,
196: x_returnStatus => l_returnStatus); --discard logging return status
197: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

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

193: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
194: p_procReturnStatus => x_returnStatus,
195: p_msg => 'MTI failure: ' || l_msg,
196: x_returnStatus => l_returnStatus); --discard logging return status
197: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
198: end if;
199: when TOO_MANY_ROWS then
200: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

Line 209: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

205: p_separator => ' ',
206: p_delete_stack => fnd_api.g_false);
207:
208: if (l_logLevel <= wip_constants.trace_logging) then
209: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'to many rows: ' || SQLERRM,
212: x_returnStatus => l_returnStatus); --discard logging return status
213: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

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

209: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'to many rows: ' || SQLERRM,
212: x_returnStatus => l_returnStatus); --discard logging return status
213: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
214: end if;
215: when NO_DATA_FOUND then
216: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

Line 226: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

222: p_separator => ' ',
223: p_delete_stack => fnd_api.g_false);
224:
225: if (l_logLevel <= wip_constants.trace_logging) then
226: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
227: p_procReturnStatus => x_returnStatus,
228: p_msg => 'no data found: ' || SQLERRM,
229: x_returnStatus => l_returnStatus); --discard logging return status
230: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

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

226: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
227: p_procReturnStatus => x_returnStatus,
228: p_msg => 'no data found: ' || SQLERRM,
229: x_returnStatus => l_returnStatus); --discard logging return status
230: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
231: end if;
232: when others then
233: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',

Line 242: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',

238: p_separator => ' ',
239: p_delete_stack => fnd_api.g_false);
240:
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'MMTT failure: ' || l_msg,
245: x_returnStatus => l_returnStatus); --discard logging return status
246: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status

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

242: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterface',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'MMTT failure: ' || l_msg,
245: x_returnStatus => l_returnStatus); --discard logging return status
246: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
247: end if;
248: end processInterface;
249:
250:

Line 273: l_params wip_logger.param_tbl_t;

269: completion_transaction_id cplTxnID,
270: move_transaction_id movTxnID
271: from mtl_material_transactions_temp
272: where transaction_header_id = p_txnHdrID;
273: l_params wip_logger.param_tbl_t;
274: l_msg VARCHAR2(2000);/* Fix for bug 6034320 */
275: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
276: l_retStatus NUMBER;
277: l_msgCount NUMBER;

Line 287: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

283: l_params(1).paramName := 'p_processInv (now ignored)';
284: l_params(1).paramValue := p_processInv;
285: l_params(2).paramName := 'p_txnHdrID';
286: l_params(2).paramValue := p_txnHdrID;
287: wip_logger.entryPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
288: p_params => l_params,
289: x_returnStatus => x_returnStatus);
290:
291: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 294: wip_logger.cleanUp(x_returnStatus=>l_returnStatus);

290:
291: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
292: raise fnd_api.g_exc_unexpected_error;
293: end if;
294: wip_logger.cleanUp(x_returnStatus=>l_returnStatus);
295: end if;
296:
297: x_returnStatus := fnd_api.g_ret_sts_success;
298:

Line 322: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

318: raise fnd_api.g_exc_error;
319: end if;
320:
321: if (l_logLevel <= wip_constants.trace_logging) then
322: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
323: p_procReturnStatus => x_returnStatus,
324: p_msg => l_msg,
325: x_returnStatus => l_returnStatus); --discard logging return status
326: end if;

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

324: p_msg => l_msg,
325: x_returnStatus => l_returnStatus); --discard logging return status
326: end if;
327: if(fnd_api.to_boolean(p_endDebug)) then
328: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
329: end if;
330: exception
331: when fnd_api.g_exc_unexpected_error then
332: x_returnStatus := fnd_api.g_ret_sts_error;

Line 334: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

330: exception
331: when fnd_api.g_exc_unexpected_error then
332: x_returnStatus := fnd_api.g_ret_sts_error;
333: if (l_logLevel <= wip_constants.trace_logging) then
334: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
335: p_procReturnStatus => x_returnStatus,
336: p_msg => l_msg,
337: x_returnStatus => l_returnStatus); --discard logging return status
338: end if;

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

336: p_msg => l_msg,
337: x_returnStatus => l_returnStatus); --discard logging return status
338: end if;
339: if(fnd_api.to_boolean(p_endDebug)) then
340: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
341: end if;
342: when fnd_api.g_exc_error then
343: x_returnStatus := fnd_api.g_ret_sts_error;
344: if (l_logLevel <= wip_constants.trace_logging) then

Line 345: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

341: end if;
342: when fnd_api.g_exc_error then
343: x_returnStatus := fnd_api.g_ret_sts_error;
344: if (l_logLevel <= wip_constants.trace_logging) then
345: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => l_msg,
348: x_returnStatus => l_returnStatus); --discard logging return status
349: end if;

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

347: p_msg => l_msg,
348: x_returnStatus => l_returnStatus); --discard logging return status
349: end if;
350: if(fnd_api.to_boolean(p_endDebug)) then
351: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
352: end if;
353:
354: when others then
355: x_returnStatus := fnd_api.g_ret_sts_error;

Line 361: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',

357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlInterfaceProc_pub',
358: p_procedure_name => 'processInterfaceRows',
359: p_error_text => SQLERRM);
360: if (l_logLevel <= wip_constants.trace_logging) then
361: wip_logger.exitPoint(p_procName => 'wip_mtlInterfaceProc_pub.processInterfaceRows',
362: p_procReturnStatus => x_returnStatus,
363: p_msg => l_msg,
364: x_returnStatus => l_returnStatus); --discard logging return status
365: end if;

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

363: p_msg => l_msg,
364: x_returnStatus => l_returnStatus); --discard logging return status
365: end if;
366: if(fnd_api.to_boolean(p_endDebug)) then
367: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
368: end if;
369: end processInterfaceRows;
370:
371: end wip_mtlInterfaceProc_pub;