APPS.WIP_INTERFACE_ERR_UTILS dependencies on WIP_CONSTANTS

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

48: n_errors := current_errors.count;
49:
50: WHILE (error_no <= n_errors) LOOP
51: l_logLevel := fnd_log.g_current_runtime_level;
52: if (l_logLevel <= wip_constants.trace_logging) then
53: wip_logger.log('error:' || current_errors(error_no).error, l_dummy2);
54: end if;
55: -- Added the following stmt for bug fix 5124822
56: -- selecting the audit column values from wip_job_schedule_interface

Line 65: l_WJSI_error_exist := WIP_CONSTANTS.YES;

61: /* Fix for bug 5507379. Errors can be either in WJSI or in WJDI */
62: /* Bug 13491954.
63: No Need to populate interface table WHO columns in WIE as this additional query cause performance issues.
64:
65: l_WJSI_error_exist := WIP_CONSTANTS.YES;
66: begin
67: select last_update_login,
68: last_updated_by,
69: created_by

Line 77: l_WJSI_error_exist := WIP_CONSTANTS.NO;

73: from wip_job_schedule_interface
74: where interface_id = current_errors(error_no).interface_id;
75: exception
76: when no_data_found then
77: l_WJSI_error_exist := WIP_CONSTANTS.NO;
78: --wip_logger.log('error - rec not found in WJSI', l_dummy2);
79: end;
80:
81: if (l_WJSI_error_exist = WIP_CONSTANTS.NO) then

Line 81: if (l_WJSI_error_exist = WIP_CONSTANTS.NO) then

77: l_WJSI_error_exist := WIP_CONSTANTS.NO;
78: --wip_logger.log('error - rec not found in WJSI', l_dummy2);
79: end;
80:
81: if (l_WJSI_error_exist = WIP_CONSTANTS.NO) then
82: begin
83: select last_update_login,
84: last_updated_by,
85: created_by

Line 93: l_WJSI_error_exist := WIP_CONSTANTS.NO;

89: from wip_job_dtls_interface
90: where interface_id = current_errors(error_no).interface_id;
91: exception
92: when no_data_found then
93: l_WJSI_error_exist := WIP_CONSTANTS.NO;
94: --wip_logger.log('error - rec not found in WJDI', l_dummy2);
95: end;
96: end if;
97: