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_MTLTEMPPROC_GRP dependencies on WIP_CONSTANTS

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

26: -------------------------------------------------------------
27:
28: savepoint wiptmppb0;
29:
30: if (l_logLevel <= wip_constants.trace_logging) then
31: l_params(1).paramName := 'p_initMsgList';
32: l_params(1).paramValue := p_initMsgList;
33: l_params(2).paramName := 'p_processInv';
34: l_params(2).paramValue := p_processInv;

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

58: else
59: x_returnStatus := fnd_api.g_ret_sts_success;
60: end if;
61:
62: if (l_logLevel <= wip_constants.trace_logging) then
63: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
64: p_procReturnStatus => x_returnStatus,
65: p_msg => 'normal completion. errMsg:' || x_errorMsg,
66: x_returnStatus => l_retStatus);

Line 89: and transaction_action_id in (wip_constants.isscomp_action,

85: error_explanation = substr(x_errorMsg,1,240)
86: where transaction_header_id = p_txnHdrID
87: and process_flag in ('Y', 'W')
88: and transaction_source_type_id = 5
89: and transaction_action_id in (wip_constants.isscomp_action,
90: wip_constants.retcomp_action,
91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:

Line 90: wip_constants.retcomp_action,

86: where transaction_header_id = p_txnHdrID
87: and process_flag in ('Y', 'W')
88: and transaction_source_type_id = 5
89: and transaction_action_id in (wip_constants.isscomp_action,
90: wip_constants.retcomp_action,
91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:
94: if (l_logLevel <= wip_constants.trace_logging) then

Line 91: wip_constants.issnegc_action,

87: and process_flag in ('Y', 'W')
88: and transaction_source_type_id = 5
89: and transaction_action_id in (wip_constants.isscomp_action,
90: wip_constants.retcomp_action,
91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 92: wip_constants.retnegc_action);

88: and transaction_source_type_id = 5
89: and transaction_action_id in (wip_constants.isscomp_action,
90: wip_constants.retcomp_action,
91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
96: p_procReturnStatus => x_returnStatus,

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

90: wip_constants.retcomp_action,
91: wip_constants.issnegc_action,
92: wip_constants.retnegc_action);
93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
96: p_procReturnStatus => x_returnStatus,
97: p_msg => 'unhandled exception: ' || SQLERRM,
98: x_returnStatus => l_retStatus);

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

106: l_reqID NUMBER;
107: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
108: begin
109: savepoint wiptmppb100;
110: if(l_logLevel <= wip_constants.trace_logging) then
111: --if a concurrent request, put the session ID in the concurrent
112: --request''s log file.
113: l_reqID := fnd_global.conc_request_id;
114: if(nvl(l_reqID, -1) <> -1) then

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

141: l_retStatus VARCHAR2(1);
142: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
143: l_params wip_logger.param_tbl_t;
144: begin
145: if (l_logLevel <= wip_constants.trace_logging) then
146: l_params(1).paramName := 'p_txnTmpID';
147: l_params(1).paramValue := p_txnTmpID;
148: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
149: p_params => l_params,

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

162: l_txnActionID
163: from mtl_material_transactions_temp
164: where transaction_temp_id = p_txnTmpID;
165:
166: if(l_logLevel <= wip_constants.full_logging) then
167: wip_logger.log(' txn src type:' || l_txnSrcTypID, l_retStatus);
168: wip_logger.log('wip entity type:' || l_wipEntityType, l_retStatus);
169: wip_logger.log(' wip entity id:' || l_wipEntityID, l_retStatus);
170: wip_logger.log(' org id:' || l_orgID, l_retStatus);

Line 175: if(l_wipEntityType = wip_constants.repetitive) then

171: wip_logger.log(' txn action id:' || l_txnActionID, l_retStatus);
172: end if;
173:
174: if(l_txnSrcTypID = 5) then
175: if(l_wipEntityType = wip_constants.repetitive) then
176: if (l_logLevel <= wip_constants.trace_logging) then
177: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
178: p_procReturnStatus => 'true',
179: p_msg => 'found repetitive',

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

172: end if;
173:
174: if(l_txnSrcTypID = 5) then
175: if(l_wipEntityType = wip_constants.repetitive) then
176: if (l_logLevel <= wip_constants.trace_logging) then
177: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
178: p_procReturnStatus => 'true',
179: p_msg => 'found repetitive',
180: x_returnStatus => l_retStatus);

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

187: from wip_entities
188: where wip_entity_id = l_wipEntityID
189: and organization_id = l_orgID;
190:
191: if (l_logLevel <= wip_constants.trace_logging) then
192: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
193: p_procReturnStatus => l_wipEntityType || '==' || wip_constants.repetitive,
194: p_msg => 'queried for wip_entity_type',
195: x_returnStatus => l_retStatus);

Line 193: p_procReturnStatus => l_wipEntityType || '==' || wip_constants.repetitive,

189: and organization_id = l_orgID;
190:
191: if (l_logLevel <= wip_constants.trace_logging) then
192: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
193: p_procReturnStatus => l_wipEntityType || '==' || wip_constants.repetitive,
194: p_msg => 'queried for wip_entity_type',
195: x_returnStatus => l_retStatus);
196: wip_logger.cleanup(l_retStatus);
197: end if;

Line 198: return (l_wipEntityType = wip_constants.repetitive);

194: p_msg => 'queried for wip_entity_type',
195: x_returnStatus => l_retStatus);
196: wip_logger.cleanup(l_retStatus);
197: end if;
198: return (l_wipEntityType = wip_constants.repetitive);
199: end if;
200: end if;
201:
202: if (l_logLevel <= wip_constants.trace_logging) then

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

198: return (l_wipEntityType = wip_constants.repetitive);
199: end if;
200: end if;
201:
202: if (l_logLevel <= wip_constants.trace_logging) then
203: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
204: p_procReturnStatus => 'false',
205: p_msg => 'not repetitive',
206: x_returnStatus => l_retStatus);

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

208: end if;
209: return false;
210: exception
211: when others then
212: if (l_logLevel <= wip_constants.trace_logging) then
213: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
214: p_procReturnStatus => 'false',
215: p_msg => 'sql error:' || SQLERRM,
216: x_returnStatus => l_retStatus);