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 FND_API

Line 118: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

114: l_params(1).paramValue := p_txnHeaderID;
115: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',
116: p_params => l_params,
117: x_returnStatus => x_returnStatus);
118: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
119: raise fnd_api.g_exc_unexpected_error;
120: end if;
121: end if;
122:

Line 119: raise fnd_api.g_exc_unexpected_error;

115: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',
116: p_params => l_params,
117: x_returnStatus => x_returnStatus);
118: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
119: raise fnd_api.g_exc_unexpected_error;
120: end if;
121: end if;
122:
123: --This procedure must be done before opening the cursor!

Line 126: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

122:
123: --This procedure must be done before opening the cursor!
124: doPreProcessingValidations(p_txnHeaderID,
125: x_returnStatus);
126: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
127: raise fnd_api.g_exc_unexpected_error;
128: end if;
129:
130: open c_assyRecs;

Line 127: raise fnd_api.g_exc_unexpected_error;

123: --This procedure must be done before opening the cursor!
124: doPreProcessingValidations(p_txnHeaderID,
125: x_returnStatus);
126: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
127: raise fnd_api.g_exc_unexpected_error;
128: end if;
129:
130: open c_assyRecs;
131: fetch c_assyRecs

Line 299: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

295: exception
296: when others then
297: rollback to wipmtivb1;
298: l_errExp := substrb(SQLERRM, 1, 240);
299: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
300:
301: update mtl_transactions_interface
302: set last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,

Line 352: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

348:
349: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',
350: p_params => l_params,
351: x_returnStatus => x_returnStatus);
352: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
353: raise fnd_api.g_exc_unexpected_error;
354: end if;
355: end if;
356:

Line 353: raise fnd_api.g_exc_unexpected_error;

349: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',
350: p_params => l_params,
351: x_returnStatus => x_returnStatus);
352: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
353: raise fnd_api.g_exc_unexpected_error;
354: end if;
355: end if;
356:
357: x_returnStatus := fnd_api.g_ret_sts_success;

Line 357: x_returnStatus := fnd_api.g_ret_sts_success;

353: raise fnd_api.g_exc_unexpected_error;
354: end if;
355: end if;
356:
357: x_returnStatus := fnd_api.g_ret_sts_success;
358:
359: if(p_tbls.txnActionID(p_index) = wip_constants.cplassy_action) then
360: l_txnType := wip_constants.comp_txn;
361: elsif(p_tbls.txnActionID(p_index) = wip_constants.retassy_action) then

Line 393: p_endDebug => fnd_api.g_false,

389: p_txnActionID => p_tbls.txnActionID(p_index),
390: p_wipEntityID => p_tbls.wipEntityID(p_index),
391: p_repLineID => p_tbls.repLineID(p_index),
392: p_tblName => wip_constants.MTI_TBL,
393: p_endDebug => fnd_api.g_false,
394: x_returnStatus => x_returnStatus);
395: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
396: raise fnd_api.g_exc_error;
397: end if;

Line 395: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

391: p_repLineID => p_tbls.repLineID(p_index),
392: p_tblName => wip_constants.MTI_TBL,
393: p_endDebug => fnd_api.g_false,
394: x_returnStatus => x_returnStatus);
395: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
396: raise fnd_api.g_exc_error;
397: end if;
398:
399: end if;

Line 396: raise fnd_api.g_exc_error;

392: p_tblName => wip_constants.MTI_TBL,
393: p_endDebug => fnd_api.g_false,
394: x_returnStatus => x_returnStatus);
395: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
396: raise fnd_api.g_exc_error;
397: end if;
398:
399: end if;
400: end if;

Line 441: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

437: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
438: end if;
439: --if the procedure fails or some lot/serial info for backflush components can not
440: --be derived then error
441: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
442: raise fnd_api.g_exc_error;
443: end if;
444: if(l_lsRequired = wip_constants.yes) then
445: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

Line 442: raise fnd_api.g_exc_error;

438: end if;
439: --if the procedure fails or some lot/serial info for backflush components can not
440: --be derived then error
441: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
442: raise fnd_api.g_exc_error;
443: end if;
444: if(l_lsRequired = wip_constants.yes) then
445: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
446: fnd_msg_pub.add;

Line 447: raise fnd_api.g_exc_error;

443: end if;
444: if(l_lsRequired = wip_constants.yes) then
445: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
446: fnd_msg_pub.add;
447: raise fnd_api.g_exc_error;
448: end if;
449:
450: end if;
451: if (l_logLevel <= wip_constants.trace_logging) then

Line 458: when fnd_api.g_exc_error then

454: p_msg => 'success',
455: x_returnStatus => l_returnStatus);
456: end if;
457: exception
458: when fnd_api.g_exc_error then
459: rollback to wipmtivb10;
460: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
461: l_errCount := extendErrTbls(p_errTbls);
462: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);

Line 460: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

456: end if;
457: exception
458: when fnd_api.g_exc_error then
459: rollback to wipmtivb10;
460: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
461: l_errCount := extendErrTbls(p_errTbls);
462: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
463: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
464: wip_utilities.get_message_stack(p_msg => l_msg);

Line 480: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

476: p_msg => 'unexp error:' || SQLERRM,
477: x_returnStatus => l_returnStatus);
478: end if;
479: rollback to wipmtivb10;
480: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
481: l_errCount := extendErrTbls(p_errTbls);
482: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
483: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
484: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mti_pub',

Line 571: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

567: l_params(1).paramValue := p_txnHeaderID;
568: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
569: p_params => l_params,
570: x_returnStatus => x_returnStatus);
571: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
572: raise fnd_api.g_exc_unexpected_error;
573: end if;
574: end if;
575:

Line 572: raise fnd_api.g_exc_unexpected_error;

568: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
569: p_params => l_params,
570: x_returnStatus => x_returnStatus);
571: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
572: raise fnd_api.g_exc_unexpected_error;
573: end if;
574: end if;
575:
576: -- do derivation and validation only for flow records

Line 587: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

583: x_returnStatus => l_returnStatus); --discard logging return status
584: end if;
585: exception
586: when others then
587: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
588: if (l_logLevel <= wip_constants.trace_logging) then
589: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
590: p_procReturnStatus => x_returnStatus,
591: p_msg => 'unexpected error: ' || SQLERRM,

Line 755: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

751: l_params(1).paramValue := p_txnHeaderID;
752: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',
753: p_params => l_params,
754: x_returnStatus => x_returnStatus);
755: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
756: raise fnd_api.g_exc_unexpected_error;
757: end if;
758: end if;
759:

Line 756: raise fnd_api.g_exc_unexpected_error;

752: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',
753: p_params => l_params,
754: x_returnStatus => x_returnStatus);
755: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
756: raise fnd_api.g_exc_unexpected_error;
757: end if;
758: end if;
759:
760:

Line 1945: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1941: x_returnStatus => l_returnStatus); --discard logging return status
1942: end if;
1943: exception
1944: when others then
1945: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1946: if (l_logLevel <= wip_constants.trace_logging) then
1947: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1948: p_procReturnStatus => x_returnStatus,
1949: p_msg => 'unexpected error: ' || SQLERRM,

Line 2056: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2052: l_params(1).paramValue := p_txnHeaderID;
2053: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2054: p_params => l_params,
2055: x_returnStatus => l_returnStatus);
2056: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2057: raise fnd_api.g_exc_unexpected_error;
2058: end if;
2059: end if;
2060: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2057: raise fnd_api.g_exc_unexpected_error;

2053: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2054: p_params => l_params,
2055: x_returnStatus => l_returnStatus);
2056: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2057: raise fnd_api.g_exc_unexpected_error;
2058: end if;
2059: end if;
2060: x_returnStatus := fnd_api.g_ret_sts_success;
2061:

Line 2060: x_returnStatus := fnd_api.g_ret_sts_success;

2056: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2057: raise fnd_api.g_exc_unexpected_error;
2058: end if;
2059: end if;
2060: x_returnStatus := fnd_api.g_ret_sts_success;
2061:
2062: -- derive transaction action id and transaction source type id,
2063: -- we need that for the logic that follows. Even though inv validation does
2064: -- the deriviation, we still needs to do that since we call inv afterwards.

Line 2615: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2611: x_returnStatus => l_returnStatus);
2612: end if;
2613: exception
2614: when others then
2615: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2616: l_errMsg := substrb(SQLERRM, 1, 240);
2617: update mtl_transactions_interface
2618: set last_update_date = sysdate,
2619: last_updated_by = fnd_global.user_id,

Line 2655: x_returnStatus := fnd_api.g_ret_sts_success;

2651: l_retStatus VARCHAR2(1);
2652: l_params wip_logger.param_tbl_t;
2653: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2654: begin
2655: x_returnStatus := fnd_api.g_ret_sts_success;
2656:
2657: if(l_logLevel <= wip_constants.trace_logging) then
2658: l_params(1).paramName := 'p_txnHeaderID';
2659: l_params(1).paramValue := p_txnHeaderID;

Line 2749: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2745: end if;
2746:
2747: exception
2748: when others then
2749: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2750: if(l_logLevel <= wip_constants.trace_logging) then
2751: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2752: p_procReturnStatus => x_returnStatus,
2753: p_msg => 'unexpected error: ' || SQLERRM,