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_MTI_PUB dependencies on WIP_MTI_PUB

Line 1: package body wip_mti_pub as

1: package body wip_mti_pub as
2: /* $Header: wipmtivb.pls 120.11.12020000.5 2013/02/22 17:46:20 sjallipa ship $ */
3:
4: type num_tbl_t is table of number;
5: type date_tbl_t is table of date;

Line 122: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',

118: begin
119: if (l_logLevel <= wip_constants.trace_logging) then
120: l_params(1).paramName := 'p_txnHeaderID';
121: l_params(1).paramValue := p_txnHeaderID;
122: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',
123: p_params => l_params,
124: x_returnStatus => x_returnStatus);
125: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
126: raise fnd_api.g_exc_unexpected_error;

Line 222: error_code = 'wip_mti_pub.preInvWIPProcessing',

218: program_update_date = sysdate,
219: request_id = fnd_global.conc_request_id,
220: process_flag = 3,
221: lock_flag = 2,
222: error_code = 'wip_mti_pub.preInvWIPProcessing',
223: error_explanation = l_errExp
224: where transaction_interface_id = l_tbls.txnIntID(i);
225:
226: elsif(l_convPriQty <> l_tbls.priQty(i) or l_tbls.priQty(i) is null or

Line 296: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

292: x_returnStatus => l_returnStatus);
293:
294:
295: if (l_logLevel <= wip_constants.trace_logging) then
296: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
297: p_procReturnStatus => x_returnStatus,
298: p_msg => 'success',
299: x_returnStatus => l_returnStatus);
300: wip_logger.cleanup(l_returnStatus);

Line 318: error_code = 'wip_mti_pub.preInvWIPProcessing',

314: program_update_date = sysdate,
315: request_id = fnd_global.conc_request_id,
316: process_flag = 3,
317: lock_flag = 2,
318: error_code = 'wip_mti_pub.preInvWIPProcessing',
319: error_explanation = l_errExp
320: where transaction_header_id = p_txnHeaderID
321: and transaction_source_type_id = 5
322: and process_flag = wip_constants.mti_inventory;

Line 325: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

321: and transaction_source_type_id = 5
322: and process_flag = wip_constants.mti_inventory;
323:
324: if(l_logLevel <= wip_constants.trace_logging) then
325: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
326: p_procReturnStatus => x_returnStatus,
327: p_msg => 'unexpected error: ' || SQLERRM,
328: x_returnStatus => l_returnStatus); --discard logging return status
329: wip_logger.cleanup(l_returnStatus);

Line 356: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',

352: l_params(1).paramValue := p_txnHeaderID;
353: l_params(2).paramName := 'p_index';
354: l_params(2).paramValue := p_index;
355:
356: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',
357: p_params => l_params,
358: x_returnStatus => x_returnStatus);
359: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
360: raise fnd_api.g_exc_unexpected_error;

Line 372: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

368: elsif(p_tbls.txnActionID(p_index) = wip_constants.retassy_action) then
369: l_txnType := wip_constants.ret_txn;
370: else --scrap. don't do anything
371: if (l_logLevel <= wip_constants.trace_logging) then
372: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
373: p_procReturnStatus => x_returnStatus,
374: p_msg => 'success (scrap txn)',
375: x_returnStatus => l_returnStatus);
376: end if;

Line 459: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

455: end if;
456:
457: end if;
458: if (l_logLevel <= wip_constants.trace_logging) then
459: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
460: p_procReturnStatus => x_returnStatus,
461: p_msg => 'success',
462: x_returnStatus => l_returnStatus);
463: end if;

Line 473: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

469: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
470: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
471: wip_utilities.get_message_stack(p_msg => l_msg);
472: if(l_logLevel <= wip_constants.trace_logging) then
473: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
474: p_procReturnStatus => x_returnStatus,
475: p_msg => 'error:' || l_msg,
476: x_returnStatus => l_returnStatus);
477: end if;

Line 481: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

477: end if;
478: p_errTbls.errExpl(l_errCount) := substrb(l_msg, 1, 240);
479: when others then
480: if(l_logLevel <= wip_constants.trace_logging) then
481: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
482: p_procReturnStatus => x_returnStatus,
483: p_msg => 'unexp error:' || SQLERRM,
484: x_returnStatus => l_returnStatus);
485: end if;

Line 491: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mti_pub',

487: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
488: l_errCount := extendErrTbls(p_errTbls);
489: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
490: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
491: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mti_pub',
492: p_procedure_name => 'preInvProcessWorkOrder',
493: p_error_text => SQLERRM);
494: wip_utilities.get_message_stack(p_msg => l_msg);
495: p_errTbls.errExpl(l_errCount) := substrb(l_msg, 1, 240);

Line 575: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

571:
572: if (l_logLevel <= wip_constants.trace_logging) then
573: l_params(1).paramName := 'p_txnHeaderID';
574: l_params(1).paramValue := p_txnHeaderID;
575: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
576: p_params => l_params,
577: x_returnStatus => x_returnStatus);
578: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
579: raise fnd_api.g_exc_unexpected_error;

Line 587: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

583: -- do derivation and validation only for flow records
584: wip_flowUtil_priv.processFlowInterfaceRecords(p_txnHeaderID);
585:
586: if (l_logLevel <= wip_constants.trace_logging) then
587: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
588: p_procReturnStatus => x_returnStatus,
589: p_msg => 'Finished pre inventory flow processing!',
590: x_returnStatus => l_returnStatus); --discard logging return status
591: end if;

Line 596: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

592: exception
593: when others then
594: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
595: if (l_logLevel <= wip_constants.trace_logging) then
596: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
597: p_procReturnStatus => x_returnStatus,
598: p_msg => 'unexpected error: ' || SQLERRM,
599: x_returnStatus => l_returnStatus); --discard logging return status
600: end if;

Line 601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mti_pub',

597: p_procReturnStatus => x_returnStatus,
598: p_msg => 'unexpected error: ' || SQLERRM,
599: x_returnStatus => l_returnStatus); --discard logging return status
600: end if;
601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mti_pub',
602: p_procedure_name => 'preInvProcessFlow',
603: p_error_text => SQLERRM);
604: wip_utilities.get_message_stack(p_msg => l_bigErrMsg);
605: l_errMsg := substrb(l_bigErrMsg, 1, 240);

Line 775: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',

771:
772: if (l_logLevel <= wip_constants.trace_logging) then
773: l_params(1).paramName := 'p_txnHeaderID';
774: l_params(1).paramValue := p_txnHeaderID;
775: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',
776: p_params => l_params,
777: x_returnStatus => x_returnStatus);
778: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
779: raise fnd_api.g_exc_unexpected_error;

Line 1987: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',

1983: end if;
1984: end loop;
1985:
1986: if(l_logLevel <= wip_constants.trace_logging) then
1987: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1988: p_procReturnStatus => x_returnStatus,
1989: p_msg => 'Finished validating interface rows!',
1990: x_returnStatus => l_returnStatus); --discard logging return status
1991: end if;

Line 1996: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',

1992: exception
1993: when others then
1994: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1995: if (l_logLevel <= wip_constants.trace_logging) then
1996: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1997: p_procReturnStatus => x_returnStatus,
1998: p_msg => 'unexpected error: ' || SQLERRM,
1999: x_returnStatus => l_returnStatus); --discard logging return status
2000: end if;

Line 2102: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2098: begin
2099: if (l_logLevel <= wip_constants.trace_logging) then
2100: l_params(1).paramName := 'p_txnHeaderID';
2101: l_params(1).paramValue := p_txnHeaderID;
2102: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2103: p_params => l_params,
2104: x_returnStatus => l_returnStatus);
2105: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2106: raise fnd_api.g_exc_unexpected_error;

Line 2657: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2653: and wfs.wip_entity_id = mti.transaction_source_id
2654: and wfs.status = 2);
2655:
2656: if (l_logLevel <= wip_constants.trace_logging) then
2657: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2658: p_procReturnStatus => x_returnStatus,
2659: p_msg => 'normal completion',
2660: x_returnStatus => l_returnStatus);
2661: end if;

Line 2676: error_code = 'wip_mti_pub.doPreProcessingValidations',

2672: program_update_date = sysdate,
2673: request_id = fnd_global.conc_request_id,
2674: process_flag = 3,
2675: lock_flag = 2,
2676: error_code = 'wip_mti_pub.doPreProcessingValidations',
2677: error_explanation = l_errMsg
2678: where transaction_header_id = p_txnHeaderID
2679: and transaction_source_type_id = 5
2680: and process_flag = wip_constants.mti_inventory;

Line 2683: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2679: and transaction_source_type_id = 5
2680: and process_flag = wip_constants.mti_inventory;
2681:
2682: if(l_logLevel <= wip_constants.trace_logging) then
2683: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2684: p_procReturnStatus => x_returnStatus,
2685: p_msg => 'unexpected error: ' || SQLERRM,
2686: x_returnStatus => l_returnStatus); --discard logging return status
2687: end if;

Line 2711: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWipProcessing',

2707: l_params(1).paramName := 'p_txnHeaderID';
2708: l_params(1).paramValue := p_txnHeaderID;
2709: l_params(2).paramName := 'p_txnBatchID';
2710: l_params(2).paramValue := p_txnBatchID;
2711: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWipProcessing',
2712: p_params => l_params,
2713: x_returnStatus => l_retStatus);
2714: end if;
2715: --delete any pre-allocations that occurred for errored records

Line 2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',

2794: wip_logger.log('done calling inventory api to release locks on MOQD', l_retStatus);
2795: end if;
2796:
2797: if (l_logLevel <= wip_constants.trace_logging) then
2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2799: p_procReturnStatus => x_returnStatus,
2800: p_msg => 'success',
2801: x_returnStatus => l_retStatus); --discard logging return status
2802: wip_logger.cleanup(l_retStatus);

Line 2809: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',

2805: exception
2806: when others then
2807: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2808: if(l_logLevel <= wip_constants.trace_logging) then
2809: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2810: p_procReturnStatus => x_returnStatus,
2811: p_msg => 'unexpected error: ' || SQLERRM,
2812: x_returnStatus => l_retStatus); --discard logging return status
2813: wip_logger.cleanup(l_retStatus);

Line 2816: end wip_mti_pub;

2812: x_returnStatus => l_retStatus); --discard logging return status
2813: wip_logger.cleanup(l_retStatus);
2814: end if;
2815: end postInvWIPProcessing;
2816: end wip_mti_pub;