APPS.WIP_MASSLOAD_PVT dependencies on WIP_LOGGER

Line 13: l_params wip_logger.param_tbl_t;

9:
10: procedure processWJSI(p_rowid in rowid,
11: x_returnStatus out nocopy varchar2,
12: x_errorMsg out nocopy varchar2) is
13: l_params wip_logger.param_tbl_t;
14: l_procName varchar2(30) := 'processWJSI';
15: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
16: l_retStatus varchar2(1);
17: l_msg varchar2(240);

Line 43: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

39:
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_rowid';
42: l_params(1).paramValue := p_rowid;
43: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
44: p_params => l_params,
45: x_returnStatus => x_returnStatus);
46: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
47: raise fnd_api.g_exc_unexpected_error;

Line 57: wip_logger.log('Interface id: ' || wjsi_row.interface_id || ' load type is: ' || wjsi_row.load_type,

53: from wip_job_schedule_interface
54: where rowid = p_rowid;
55:
56: if ( l_logLevel <= wip_constants.trace_logging ) then
57: wip_logger.log('Interface id: ' || wjsi_row.interface_id || ' load type is: ' || wjsi_row.load_type,
58: l_retStatus);
59: end if;
60:
61:

Line 289: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

285: where wip_entity_id = wjsi_row.wip_entity_id;
286: End if;
287:
288: if (l_logLevel <= wip_constants.trace_logging) then
289: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
290: p_procReturnStatus => x_returnStatus,
291: p_msg => 'success',
292: x_returnStatus => l_retStatus);
293: end if;

Line 300: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

296: when fnd_api.g_exc_unexpected_error then
297: rollback to savepoint begin_process_wjsi;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: if(l_logLevel <= wip_constants.trace_logging) then
300: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
301: p_procReturnStatus => x_returnStatus,
302: p_msg => x_errorMsg,
303: x_returnStatus => l_retStatus);
304: end if;

Line 308: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

304: end if;
305: when others then
306: rollback to savepoint begin_process_wjsi;
307: if(l_logLevel <= wip_constants.trace_logging) then
308: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
309: p_procReturnStatus => x_returnStatus,
310: p_msg => 'unexp error:' || SQLERRM,
311: x_returnStatus => l_retStatus);
312: end if;