APPS.WIP_MASSLOAD_PVT dependencies on WIP_LOGGER

Line 19: l_params wip_logger.param_tbl_t;

15:
16: procedure processWJSI(p_rowid in rowid,
17: x_returnStatus out nocopy varchar2,
18: x_errorMsg out nocopy varchar2) is
19: l_params wip_logger.param_tbl_t;
20: l_procName varchar2(30) := 'processWJSI';
21: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
22: l_retStatus varchar2(1);
23: l_msg varchar2(2000); --bug#16185044: changed the length from 240 to 2000

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

50:
51: if (l_logLevel <= wip_constants.trace_logging) then
52: l_params(1).paramName := 'p_rowid';
53: l_params(1).paramValue := p_rowid;
54: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
55: p_params => l_params,
56: x_returnStatus => x_returnStatus);
57: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
58: raise fnd_api.g_exc_unexpected_error;

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

68: g_wjsiClassCode := wjsi_row.class_code; --fix for bug 16079296
69: g_wjsiOrgId := wjsi_row.organization_id; --fix for bug 16079296
70:
71: if ( l_logLevel <= wip_constants.trace_logging ) then
72: wip_logger.log('Interface id: ' || wjsi_row.interface_id || ' load type is: ' || wjsi_row.load_type,
73: l_retStatus);
74: end if;
75:
76:

Line 358: wip_logger.log(l_msg, l_retStatus);

354: else -- not auto update PO quantity
355: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
356: l_msg := fnd_message.get;
357: if (l_logLevel <= wip_constants.trace_logging) then
358: wip_logger.log(l_msg, l_retStatus);
359: end if;
360: end if; -- check auto update PO quantity parameter
361: else -- customer does not have PO FPJ
362: --behave the old way by cutting new requisition

Line 406: wip_logger.log(l_msg, l_retStatus);

402: else -- not auto update PO quantity
403: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
404: l_msg := fnd_message.get;
405: if (l_logLevel <= wip_constants.trace_logging) then
406: wip_logger.log(l_msg, l_retStatus);
407: end if;
408: end if; -- check auto update PO quantity parameter
409: else -- customer does not have PO FPJ
410: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');

Line 413: wip_logger.log(l_msg, l_retStatus);

409: else -- customer does not have PO FPJ
410: fnd_message.set_name('WIP','WIP_OSP_CHANGE_JOB_QTY');
411: l_msg := fnd_message.get;
412: if (l_logLevel <= wip_constants.trace_logging) then
413: wip_logger.log(l_msg, l_retStatus);
414: end if;
415: end if;
416: end if; -- PO/requisition exist /* quantity decrease */
417: end if;

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

433: where wip_entity_id = wjsi_row.wip_entity_id;
434: End if;
435:
436: if (l_logLevel <= wip_constants.trace_logging) then
437: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
438: p_procReturnStatus => x_returnStatus,
439: p_msg => 'success',
440: x_returnStatus => l_retStatus);
441: end if;

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

444: when fnd_api.g_exc_unexpected_error then
445: rollback to savepoint begin_process_wjsi;
446: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
447: if(l_logLevel <= wip_constants.trace_logging) then
448: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
449: p_procReturnStatus => x_returnStatus,
450: p_msg => x_errorMsg,
451: x_returnStatus => l_retStatus);
452: end if;

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

452: end if;
453: when others then
454: rollback to savepoint begin_process_wjsi;
455: if(l_logLevel <= wip_constants.trace_logging) then
456: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
457: p_procReturnStatus => x_returnStatus,
458: p_msg => 'unexp error:' || SQLERRM,
459: x_returnStatus => l_retStatus);
460: end if;