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 125: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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;
127: end if;
128: end if;
129:

Line 126: raise fnd_api.g_exc_unexpected_error;

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;
127: end if;
128: end if;
129:
130: --This procedure must be done before opening the cursor!

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

129:
130: --This procedure must be done before opening the cursor!
131: doPreProcessingValidations(p_txnHeaderID,
132: x_returnStatus);
133: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
134: raise fnd_api.g_exc_unexpected_error;
135: end if;
136:
137: open c_assyRecs;

Line 134: raise fnd_api.g_exc_unexpected_error;

130: --This procedure must be done before opening the cursor!
131: doPreProcessingValidations(p_txnHeaderID,
132: x_returnStatus);
133: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
134: raise fnd_api.g_exc_unexpected_error;
135: end if;
136:
137: open c_assyRecs;
138: fetch c_assyRecs

Line 306: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

302: exception
303: when others then
304: rollback to wipmtivb1;
305: l_errExp := substrb(SQLERRM, 1, 240);
306: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
307:
308: update mtl_transactions_interface
309: set last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,

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

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;
361: end if;
362: end if;
363:

Line 360: raise fnd_api.g_exc_unexpected_error;

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;
361: end if;
362: end if;
363:
364: x_returnStatus := fnd_api.g_ret_sts_success;

Line 364: x_returnStatus := fnd_api.g_ret_sts_success;

360: raise fnd_api.g_exc_unexpected_error;
361: end if;
362: end if;
363:
364: x_returnStatus := fnd_api.g_ret_sts_success;
365:
366: if(p_tbls.txnActionID(p_index) = wip_constants.cplassy_action) then
367: l_txnType := wip_constants.comp_txn;
368: elsif(p_tbls.txnActionID(p_index) = wip_constants.retassy_action) then

Line 400: p_endDebug => fnd_api.g_false,

396: p_txnActionID => p_tbls.txnActionID(p_index),
397: p_wipEntityID => p_tbls.wipEntityID(p_index),
398: p_repLineID => p_tbls.repLineID(p_index),
399: p_tblName => wip_constants.MTI_TBL,
400: p_endDebug => fnd_api.g_false,
401: x_returnStatus => x_returnStatus);
402: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
403: raise fnd_api.g_exc_error;
404: end if;

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

398: p_repLineID => p_tbls.repLineID(p_index),
399: p_tblName => wip_constants.MTI_TBL,
400: p_endDebug => fnd_api.g_false,
401: x_returnStatus => x_returnStatus);
402: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
403: raise fnd_api.g_exc_error;
404: end if;
405:
406: end if;

Line 403: raise fnd_api.g_exc_error;

399: p_tblName => wip_constants.MTI_TBL,
400: p_endDebug => fnd_api.g_false,
401: x_returnStatus => x_returnStatus);
402: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
403: raise fnd_api.g_exc_error;
404: end if;
405:
406: end if;
407: end if;

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

444: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
445: end if;
446: --if the procedure fails or some lot/serial info for backflush components can not
447: --be derived then error
448: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
449: raise fnd_api.g_exc_error;
450: end if;
451: if(l_lsRequired = wip_constants.yes) then
452: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

Line 449: raise fnd_api.g_exc_error;

445: end if;
446: --if the procedure fails or some lot/serial info for backflush components can not
447: --be derived then error
448: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
449: raise fnd_api.g_exc_error;
450: end if;
451: if(l_lsRequired = wip_constants.yes) then
452: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
453: fnd_msg_pub.add;

Line 454: raise fnd_api.g_exc_error;

450: end if;
451: if(l_lsRequired = wip_constants.yes) then
452: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
453: fnd_msg_pub.add;
454: raise fnd_api.g_exc_error;
455: end if;
456:
457: end if;
458: if (l_logLevel <= wip_constants.trace_logging) then

Line 465: when fnd_api.g_exc_error then

461: p_msg => 'success',
462: x_returnStatus => l_returnStatus);
463: end if;
464: exception
465: when fnd_api.g_exc_error then
466: rollback to wipmtivb10;
467: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
468: l_errCount := extendErrTbls(p_errTbls);
469: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);

Line 467: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

463: end if;
464: exception
465: when fnd_api.g_exc_error then
466: rollback to wipmtivb10;
467: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
468: l_errCount := extendErrTbls(p_errTbls);
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);

Line 487: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

483: p_msg => 'unexp error:' || SQLERRM,
484: x_returnStatus => l_returnStatus);
485: end if;
486: rollback to wipmtivb10;
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',

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

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;
580: end if;
581: end if;
582:

Line 579: raise fnd_api.g_exc_unexpected_error;

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;
580: end if;
581: end if;
582:
583: -- do derivation and validation only for flow records

Line 594: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

590: x_returnStatus => l_returnStatus); --discard logging return status
591: end if;
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,

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

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;
780: end if;
781: end if;
782:

Line 779: raise fnd_api.g_exc_unexpected_error;

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;
780: end if;
781: end if;
782:
783:

Line 1994: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1990: x_returnStatus => l_returnStatus); --discard logging return status
1991: end if;
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,

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

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;
2107: end if;
2108: end if;
2109: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2106: raise fnd_api.g_exc_unexpected_error;

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;
2107: end if;
2108: end if;
2109: x_returnStatus := fnd_api.g_ret_sts_success;
2110:

Line 2109: x_returnStatus := fnd_api.g_ret_sts_success;

2105: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2106: raise fnd_api.g_exc_unexpected_error;
2107: end if;
2108: end if;
2109: x_returnStatus := fnd_api.g_ret_sts_success;
2110:
2111: -- derive transaction action id and transaction source type id,
2112: -- we need that for the logic that follows. Even though inv validation does
2113: -- the deriviation, we still needs to do that since we call inv afterwards.

Line 2664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2660: x_returnStatus => l_returnStatus);
2661: end if;
2662: exception
2663: when others then
2664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2665: l_errMsg := substrb(SQLERRM, 1, 240);
2666: update mtl_transactions_interface
2667: set last_update_date = sysdate,
2668: last_updated_by = fnd_global.user_id,

Line 2704: x_returnStatus := fnd_api.g_ret_sts_success;

2700: l_retStatus VARCHAR2(1);
2701: l_params wip_logger.param_tbl_t;
2702: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2703: begin
2704: x_returnStatus := fnd_api.g_ret_sts_success;
2705:
2706: if(l_logLevel <= wip_constants.trace_logging) then
2707: l_params(1).paramName := 'p_txnHeaderID';
2708: l_params(1).paramValue := p_txnHeaderID;

Line 2807: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2803: end if;
2804:
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,