DBA Data[Home] [Help]

APPS.WIP_ONLINE_MTL_TXN_PROCESSOR dependencies on WIP_CONSTANTS

Line 218: if (l_logLevel <= wip_constants.trace_logging) then

214: labelStatus VARCHAR2(1);
215: l_paramTbl wip_logger.param_tbl_t;
216: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
217: BEGIN
218: if (l_logLevel <= wip_constants.trace_logging) then
219: l_paramTbl(1).paramName := 'not printing params';
220: l_paramTbl(1).paramValue := ' ';
221: wip_logger.entryPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
222: p_params => l_paramTbl,

Line 235: if (l_logLevel <= wip_constants.full_logging) then

231: -- lpnID inserted here for label printing
232: mmttParameter.environment := environment ;
233: mmttParameter.transactionDate := sysdate ;
234: mmttParameter.scheduledFlag := p_scheduledFlag ;
235: if (l_logLevel <= wip_constants.full_logging) then
236: wip_logger.log('scheduled flag: ' || mmttParameter.scheduledFlag, dummyErrCode);
237: end if;
238: mmttParameter.scheduleNumber := p_scheduleNumber ;
239: mmttParameter.transactionType := p_transactionTypeID ;

Line 283: if (l_logLevel <= wip_constants.full_logging) then

279:
280: wma_flow.insertParentRecordIntoMMTT(mmttParameter, l_ret_value , x_err_msg);
281: if ( l_ret_value = -1 ) then
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: if (l_logLevel <= wip_constants.full_logging) then
284: wip_logger.log('assy insert failed', dummyErrCode);
285: end if;
286: raise fnd_api.g_exc_unexpected_error;
287: end if;

Line 302: if (l_logLevel <= wip_constants.full_logging) then

298: p_business_flow_code => 33); -- discrete business flow code
299: -- do not error out if label printing, only put warning message in log
300: if(returnStatus <> fnd_api.g_ret_sts_success) then
301: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
302: if (l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
304: 'The following error has occurred during ' ||
305: 'printing: ' || l_msg_stack || '\n' ||
306: 'Please check the Inventory log file for more ' ||

Line 311: if (l_logLevel <= wip_constants.full_logging) then

307: 'information.',
308: x_returnStatus =>dummyErrCode);
309: end if;
310: end if;
311: if (l_logLevel <= wip_constants.full_logging) then
312: wip_logger.log(p_msg => 'Label printing returned with status ' ||
313: returnStatus,
314: x_returnStatus => dummyErrCode);
315: end if; */

Line 325: if (l_logLevel <= wip_constants.full_logging) then

321: x_return_status,
322: x_err_msg);
323:
324: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
325: if (l_logLevel <= wip_constants.full_logging) then
326: wip_logger.log('assy processing failed', dummyErrCode);
327: end if;
328: raise fnd_api.g_exc_unexpected_error;
329: end if;

Line 361: p_txnMode => wip_constants.online,

357:
358: --process the components
359: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
360: p_txnHdrID => p_processHeaderID,
361: p_txnMode => wip_constants.online,
362: p_destroyQtyTrees => fnd_api.g_true,
363: p_endDebug => fnd_api.g_false,
364: x_returnStatus => x_return_status,
365: x_errorMsg => x_err_msg);

Line 367: if (l_logLevel <= wip_constants.full_logging) then

363: p_endDebug => fnd_api.g_false,
364: x_returnStatus => x_return_status,
365: x_errorMsg => x_err_msg);
366: if(x_return_status <> fnd_api.g_ret_sts_success) then
367: if (l_logLevel <= wip_constants.full_logging) then
368: wip_logger.log('component processing failed', dummyErrCode);
369: end if;
370: raise fnd_api.g_exc_unexpected_error;
371: end if;

Line 403: if (l_logLevel <= wip_constants.full_logging) then

399: lpnParameter.demandSourceDelivery := p_demandSourceDelivery;
400: wma_cfm.process(lpnParameter, l_ret_value , x_err_msg);
401: if ( l_ret_value = -1 ) then
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: if (l_logLevel <= wip_constants.full_logging) then
404: wip_logger.log('assy lpn insert failed', dummyErrCode);
405: end if;
406: raise fnd_api.g_exc_unexpected_error;
407: end if;

Line 414: if (l_logLevel <= wip_constants.full_logging) then

410: x_err_msg => x_err_msg,
411: x_return_status => x_return_status);
412:
413: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
414: if (l_logLevel <= wip_constants.full_logging) then
415: wip_logger.log('updateSerials failed', dummyErrCode);
416: end if;
417: raise fnd_api.g_exc_unexpected_error;
418: end if;

Line 422: if (l_logLevel <= wip_constants.trace_logging) then

418: end if;
419:
420: x_return_status := fnd_api.G_RET_STS_SUCCESS;
421:
422: if (l_logLevel <= wip_constants.trace_logging) then
423: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
424: p_procReturnStatus => x_return_status,
425: p_msg => x_err_msg,
426: x_returnStatus => dummyErrCode);

Line 432: if (l_logLevel <= wip_constants.trace_logging) then

428: end if;
429:
430: EXCEPTION
431: when fnd_api.g_exc_unexpected_error then
432: if (l_logLevel <= wip_constants.trace_logging) then
433: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
434: p_procReturnStatus => x_return_status,
435: p_msg => 'error:' || x_err_msg,
436: x_returnStatus => dummyErrCode);

Line 443: if (l_logLevel <= wip_constants.trace_logging) then

439: when others then
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: x_err_msg := SQLERRM;
442: -- WIP_UTILITIES.get_message_stack(p_msg => x_err_msg);
443: if (l_logLevel <= wip_constants.trace_logging) then
444: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteFlow',
445: p_procReturnStatus => x_return_status,
446: p_msg => 'unexp error: ' || x_err_msg,
447: x_returnStatus => dummyErrCode);

Line 503: if (l_logLevel <= wip_constants.trace_logging) then

499: l_retStatus VARCHAR2(1);
500: error VARCHAR2(2000); -- error message
501:
502: BEGIN
503: if (l_logLevel <= wip_constants.trace_logging) then
504: l_paramTbl(1).paramName := 'not printing params';
505: l_paramTbl(1).paramValue := ' ';
506: wip_logger.entryPoint(p_procName => 'wipopsrb.lpnCompleteJob',
507: p_params => l_paramTbl,

Line 539: if (l_logLevel <= wip_constants.full_logging) then

535: errMessage => x_err_msg,
536: cmpl_txnTmpID => l_cmpl_txnTmpID); --Bug 6013398
537: if ( l_ret_value = -1 ) then
538: x_return_status := fnd_api.g_ret_sts_unexp_error;
539: if (l_logLevel <= wip_constants.full_logging) then
540: wip_logger.log('lpn processing failed', dummyErrCode);
541: end if;
542: raise fnd_api.g_exc_unexpected_error;
543: end if;

Line 550: if (l_logLevel <= wip_constants.full_logging) then

546: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => p_processHeaderID,
547: p_initMsgList => fnd_api.g_true,
548: x_returnStatus => x_return_status);
549: if(x_return_status <> fnd_api.g_ret_sts_success) then
550: if (l_logLevel <= wip_constants.full_logging) then
551: wip_logger.log('component validation failed', dummyErrCode);
552: end if;
553: wip_utilities.get_message_stack(p_msg => x_err_msg);
554: raise fnd_api.g_exc_unexpected_error;

Line 560: p_txnMode => wip_constants.online,

556:
557: --process the components
558: wip_mtlTempProc_priv.processTemp(p_initMsgList => fnd_api.g_true,
559: p_txnHdrID => p_processHeaderID,
560: p_txnMode => wip_constants.online,
561: p_destroyQtyTrees => fnd_api.g_true,
562: p_endDebug => fnd_api.g_false,
563: x_returnStatus => x_return_status,
564: x_errorMsg => x_err_msg);

Line 567: if (l_logLevel <= wip_constants.full_logging) then

563: x_returnStatus => x_return_status,
564: x_errorMsg => x_err_msg);
565:
566: if(x_return_status <> fnd_api.g_ret_sts_success) then
567: if (l_logLevel <= wip_constants.full_logging) then
568: wip_logger.log('component processing failed', dummyErrCode);
569: end if;
570: raise fnd_api.g_exc_unexpected_error;
571: end if;

Line 585: if (l_logLevel <= wip_constants.full_logging) then

581: p_business_flow_code => 26); -- discrete business flow code
582: -- do not error out if label printing, only put warning message in log
583: if(l_retStatus <> fnd_api.g_ret_sts_success) then
584: wip_utilities.get_message_stack(p_msg => l_msg_stack);
585: if (l_logLevel <= wip_constants.full_logging) then
586: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
587: 'The following error has occurred during ' ||
588: 'printing: ' || l_msg_stack || '\n' ||
589: 'Please check the Inventory log file for more ' ||

Line 594: if (l_logLevel <= wip_constants.full_logging) then

590: 'information.',
591: x_returnStatus =>dummy);
592: end if;
593: end if;
594: if (l_logLevel <= wip_constants.full_logging) then
595: wip_logger.log(p_msg => 'Label printing returned with status ' || l_retStatus,
596: x_returnStatus => dummy);
597: end if;
598: /* End of fix for bug 4253002 */

Line 623: if (l_logLevel <= wip_constants.full_logging) then

619: x_err_msg => x_err_msg,
620: x_return_status => x_return_status);
621:
622: if ( x_return_status <> fnd_api.g_ret_sts_success ) then
623: if (l_logLevel <= wip_constants.full_logging) then
624: wip_logger.log('updateSerials failed', dummyErrCode);
625: end if;
626: raise fnd_api.g_exc_unexpected_error;
627: end if;

Line 633: if (l_logLevel <= wip_constants.trace_logging) then

629:
630:
631: x_return_status := fnd_api.G_RET_STS_SUCCESS;
632:
633: if (l_logLevel <= wip_constants.trace_logging) then
634: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
635: p_procReturnStatus => x_return_status,
636: p_msg => x_err_msg,
637: x_returnStatus => dummyErrCode);

Line 643: if (l_logLevel <= wip_constants.trace_logging) then

639: end if;
640:
641: EXCEPTION
642: when fnd_api.g_exc_unexpected_error then
643: if (l_logLevel <= wip_constants.trace_logging) then
644: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
645: p_procReturnStatus => x_return_status,
646: p_msg => x_err_msg,
647: x_returnStatus => dummyErrCode);

Line 653: if (l_logLevel <= wip_constants.trace_logging) then

649: end if;
650: when others then
651: x_return_status := fnd_api.g_ret_sts_unexp_error;
652: WIP_UTILITIES.get_message_stack(p_msg => x_err_msg);
653: if (l_logLevel <= wip_constants.trace_logging) then
654: wip_logger.exitPoint(p_procName => 'wipopsrb.lpnCompleteJob',
655: p_procReturnStatus => x_return_status,
656: p_msg => SQLERRM,
657: x_returnStatus => dummyErrCode);