DBA Data[Home] [Help]

APPS.WIP_MOVPROC_GRP dependencies on WIP_LOGGER

Line 150: l_params wip_logger.param_tbl_t;

146: FROM wip_txn_interface_errors
147: WHERE transaction_id = p_transaction_id;
148:
149: l_returnStatus VARCHAR2(1);
150: l_params wip_logger.param_tbl_t;
151: l_groupID NUMBER;
152: l_move_mode NUMBER;
153: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
154: l_errors c_errors%ROWTYPE;

Line 171: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',

167: l_params(5).paramValue := p_cplTxnID;
168: l_params(6).paramName := 'p_commit';
169: l_params(6).paramValue := p_commit;
170:
171: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',
172: p_params => l_params,
173: x_returnStatus => l_returnStatus);
174:
175: END IF;

Line 215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

211: COMMIT;
212: END IF;
213:
214: IF (l_logLevel <= wip_constants.trace_logging) THEN
215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
216: p_procReturnStatus => x_returnStatus,
217: p_msg => 'procedure complete',
218: x_returnStatus => l_returnStatus);
219: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
216: p_procReturnStatus => x_returnStatus,
217: p_msg => 'procedure complete',
218: x_returnStatus => l_returnStatus);
219: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
220: END IF;
221: EXCEPTION
222: WHEN fnd_api.g_exc_error THEN
223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

233: inv_mobile_helper_functions.get_stacked_messages(x_errorMsg);
234: END IF;
235:
236: IF (l_logLevel <= wip_constants.trace_logging) THEN
237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'wip_movProc_priv.processIntf failed',
240: x_returnStatus => l_returnStatus);
241: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'wip_movProc_priv.processIntf failed',
240: x_returnStatus => l_returnStatus);
241: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
242: END IF;
243:
244: WHEN TOO_MANY_ROWS THEN
245: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

247: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
248: x_errorMsg := substr(fnd_message.get, 1, 1000);
249:
250: IF (l_logLevel <= wip_constants.trace_logging) THEN
251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
252: p_procReturnStatus => x_returnStatus,
253: p_msg => 'to many rows: ' || SQLERRM,
254: x_returnStatus => l_returnStatus);
255: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
252: p_procReturnStatus => x_returnStatus,
253: p_msg => 'to many rows: ' || SQLERRM,
254: x_returnStatus => l_returnStatus);
255: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
256: END IF;
257:
258: WHEN NO_DATA_FOUND THEN
259: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

262: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
263: x_errorMsg := substr(fnd_message.get, 1, 1000);
264:
265: IF (l_logLevel <= wip_constants.trace_logging) THEN
266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
267: p_procReturnStatus => x_returnStatus,
268: p_msg => 'no data found: ' || SQLERRM,
269: x_returnStatus => l_returnStatus);
270: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
267: p_procReturnStatus => x_returnStatus,
268: p_msg => 'no data found: ' || SQLERRM,
269: x_returnStatus => l_returnStatus);
270: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
271: END IF;
272:
273: WHEN others THEN
274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

273: WHEN others THEN
274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
275: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
278: p_procReturnStatus => x_returnStatus,
279: p_msg => x_errorMsg,
280: x_returnStatus => l_returnStatus);
281: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
278: p_procReturnStatus => x_returnStatus,
279: p_msg => x_errorMsg,
280: x_returnStatus => l_returnStatus);
281: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
282: END IF;
283:
284: END processInterface;
285:

Line 294: l_params wip_logger.param_tbl_t;

290: PROCEDURE processInterface(p_groupID IN NUMBER,
291: p_commit IN VARCHAR2 := NULL,
292: x_returnStatus OUT NOCOPY VARCHAR2) IS
293: l_returnStatus VARCHAR2(1);
294: l_params wip_logger.param_tbl_t;
295: l_groupID NUMBER;
296: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
297: BEGIN
298:

Line 304: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',

300: l_params(1).paramName := 'p_groupID';
301: l_params(1).paramValue := p_groupID;
302: l_params(2).paramName := 'p_commit';
303: l_params(2).paramValue := p_commit;
304: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',
305: p_params => l_params,
306: x_returnStatus => l_returnStatus);
307:
308: END IF;

Line 333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

329: COMMIT;
330: END IF;
331:
332: IF (l_logLevel <= wip_constants.trace_logging) THEN
333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
334: p_procReturnStatus => x_returnStatus,
335: p_msg => 'no record in this group error out',
336: x_returnStatus => l_returnStatus);
337: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
334: p_procReturnStatus => x_returnStatus,
335: p_msg => 'no record in this group error out',
336: x_returnStatus => l_returnStatus);
337: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
338: END IF;
339: EXCEPTION
340:
341: WHEN fnd_api.g_exc_error THEN

Line 345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

341: WHEN fnd_api.g_exc_error THEN
342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
343:
344: IF (l_logLevel <= wip_constants.trace_logging) THEN
345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => 'some records in this group error out',
348: x_returnStatus => l_returnStatus);
349: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => 'some records in this group error out',
348: x_returnStatus => l_returnStatus);
349: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
350: END IF;
351:
352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354:
355: IF (l_logLevel <= wip_constants.trace_logging) THEN
356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
357: p_procReturnStatus => x_returnStatus,
358: p_msg => 'unexpected error: ' || SQLERRM,
359: x_returnStatus => l_returnStatus);
360: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

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

356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
357: p_procReturnStatus => x_returnStatus,
358: p_msg => 'unexpected error: ' || SQLERRM,
359: x_returnStatus => l_returnStatus);
360: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
361: END IF;
362: END processInterface;
363:
364: END wip_movProc_grp;