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_MTLPROC_PRIV dependencies on WIP_MTLPROC_PRIV

Line 1: package body wip_mtlProc_priv as

1: package body wip_mtlProc_priv as
2: /* $Header: wipmtlpb.pls 120.11.12000000.3 2007/05/07 11:25:53 akbhatia ship $ */
3:
4: /* History
5: *

Line 71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',

67:
68: if (l_logLevel <= wip_constants.trace_logging) then
69: l_params(1).paramName := 'p_txnTmpID';
70: l_params(1).paramValue := p_txnTmpID;
71: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTemp',
72: p_params => l_params,
73: x_returnStatus => x_returnStatus);
74: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
75: raise fnd_api.g_exc_unexpected_error;

Line 239: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

235: end if;
236: end if;
237:
238: if (l_logLevel <= wip_constants.trace_logging) then
239: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
240: p_procReturnStatus => x_returnStatus,
241: p_msg => 'Transaction Succeeded',
242: x_returnStatus => l_returnStatus); --discard logging return status
243: end if;

Line 253: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

249: when no_data_found then
250: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
251: rollback to wipmtlpb_SP1;
252: if (l_logLevel <= wip_constants.trace_logging) then
253: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
254: p_procReturnStatus => x_returnStatus,
255: p_msg => 'no data found exception. tmpID:' || p_txnTmpID,
256: x_returnStatus => l_returnStatus); --discard logging return status
257: end if;

Line 272: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

268: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
269:
270: writeError(p_txnTmpID); --update the MMTT line to error for wip failures
271: if (l_logLevel <= wip_constants.trace_logging) then
272: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
273: p_procReturnStatus => x_returnStatus,
274: p_msg => l_errMsg,
275: x_returnStatus => l_returnStatus); --discard logging return status
276: end if;

Line 283: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',

279: end if;
280: when others then
281: rollback to wipmtlpb_SP1;
282: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
283: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
284: p_procedure_name => 'processTemp',
285: p_error_text => SQLERRM);
286: writeError(p_txnTmpID);
287: if (l_logLevel <= wip_constants.trace_logging) then

Line 288: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',

284: p_procedure_name => 'processTemp',
285: p_error_text => SQLERRM);
286: writeError(p_txnTmpID);
287: if (l_logLevel <= wip_constants.trace_logging) then
288: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTemp',
289: p_procReturnStatus => x_returnStatus,
290: p_msg => 'item' || l_issueRec.itemID || ' unexpected error: ' || SQLERRM,
291: x_returnStatus => l_returnStatus); --discard logging return status
292: end if;

Line 389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',

385: l_params(l_paramCount + 1).paramName := 'p_issueQty';
386: l_params(l_paramCount + 1).paramValue := p_issueQty;
387: l_params(l_paramCount + 2).paramName := 'p_repSchedID';
388: l_params(l_paramCount + 2).paramValue := p_repSchedID;
389: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processTxn',
390: p_params => l_params,
391: x_returnStatus => x_returnStatus);
392: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
393: raise fnd_api.g_exc_unexpected_error;

Line 585: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

581:
582: x_returnStatus := fnd_api.g_ret_sts_success;
583:
584: if (l_logLevel <= wip_constants.trace_logging) then
585: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
586: p_procReturnStatus => x_returnStatus,
587: p_msg => 'procedure success',
588: x_returnStatus => l_returnStatus); --discard logging return status
589: end if;

Line 594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

590: exception
591: when fnd_api.g_exc_unexpected_error then
592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
593: if (l_logLevel <= wip_constants.trace_logging) then
594: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
595: p_procReturnStatus => x_returnStatus,
596: p_msg => l_errMsg,
597: x_returnStatus => l_returnStatus); --discard logging return status
598: end if;

Line 605: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

601: --need to add a message to the stack and count it
602: when wip_constants.records_locked then
603: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
604: if (l_logLevel <= wip_constants.trace_logging) then
605: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
606: p_procReturnStatus => x_returnStatus,
607: p_msg => 'records locked',
608: x_returnStatus => l_returnStatus);
609: end if;

Line 614: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',

610: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
611: fnd_msg_pub.add;
612: when others then
613: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
614: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
615: p_procedure_name => 'processTxn',
616: p_error_text => SQLERRM);
617: if (l_logLevel <= wip_constants.trace_logging) then
618: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

Line 618: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',

614: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
615: p_procedure_name => 'processTxn',
616: p_error_text => SQLERRM);
617: if (l_logLevel <= wip_constants.trace_logging) then
618: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processTxn',
619: p_procReturnStatus => x_returnStatus,
620: p_msg => 'unexpected error: ' || SQLERRM,
621: x_returnStatus => l_returnStatus); --discard logging return status
622: end if;

Line 931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

927: begin
928: if (l_logLevel <= wip_constants.trace_logging) then
929: fillIssueParamTbl(p_issueRec => p_issueRec,
930: x_params => l_params);
931: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
932: p_params => l_params,
933: x_returnStatus => x_returnStatus);
934: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
935: raise fnd_api.g_exc_unexpected_error;

Line 1124: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1120: wip_logger.log('txn id' || p_issueRec.mtlTxnID, l_returnStatus);
1121: end if;
1122:
1123: if (l_logLevel <= wip_constants.trace_logging) then
1124: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1125: p_procReturnStatus => x_returnStatus,
1126: p_msg => 'procedure success.',
1127: x_returnStatus => l_returnStatus); --discard logging return status
1128: end if;

Line 1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1129: exception
1130: when fnd_api.g_exc_unexpected_error then
1131: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1132: if (l_logLevel <= wip_constants.trace_logging) then
1133: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1134: p_procReturnStatus => x_returnStatus,
1135: p_msg => l_errMsg,
1136: x_returnStatus => l_returnStatus); --discard logging return status
1137: end if;

Line 1140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',

1136: x_returnStatus => l_returnStatus); --discard logging return status
1137: end if;
1138: when others then
1139: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
1141: p_procedure_name => 'processRepetitive',
1142: p_error_text => SQLERRM);
1143: if (l_logLevel <= wip_constants.trace_logging) then
1144: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

Line 1144: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',

1140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_mtlProc_priv',
1141: p_procedure_name => 'processRepetitive',
1142: p_error_text => SQLERRM);
1143: if (l_logLevel <= wip_constants.trace_logging) then
1144: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processRepetitive',
1145: p_procReturnStatus => x_returnStatus,
1146: p_msg => 'unexpected error: ' || SQLERRM,
1147: x_returnStatus => l_returnStatus); --discard logging return status
1148: end if;

Line 1191: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1187: l_process_phase := '1';
1188: IF (l_log_level <= wip_constants.trace_logging) THEN
1189: l_params(1).paramName := 'p_mtl_header_id';
1190: l_params(1).paramValue := p_mtl_header_id;
1191: wip_logger.entryPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1192: p_params => l_params,
1193: x_returnStatus => l_return_status);
1194: END IF;
1195: l_process_phase := '2';

Line 1227: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1223: x_returnStatus := fnd_api.g_ret_sts_success;
1224:
1225: -- write to the log file
1226: IF (l_log_level <= wip_constants.trace_logging) THEN
1227: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1228: p_procReturnStatus => x_returnStatus,
1229: p_msg => 'procedure complete',
1230: x_returnStatus => l_return_status);
1231: END IF;

Line 1240: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',

1236: ROLLBACK TO SAVEPOINT s_oa_txn_proc;
1237: x_returnStatus := fnd_api.g_ret_sts_error;
1238:
1239: IF (l_log_level <= wip_constants.trace_logging) THEN
1240: wip_logger.exitPoint(p_procName => 'wip_mtlProc_priv.processOATxn',
1241: p_procReturnStatus => x_returnStatus,
1242: p_msg => 'wip_cplProc_priv.processOATxn failed : '
1243: || l_process_phase,
1244: x_returnStatus => l_return_status);

Line 1268: end wip_mtlProc_priv;

1264: -- close log file
1265: wip_logger.cleanUp(x_returnStatus => l_return_status);
1266: END processOATxn;
1267:
1268: end wip_mtlProc_priv;