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_VALIDATEMLHEADER_PVT dependencies on WIP_LOGGER

Line 125: l_params wip_logger.param_tbl_t;

121: procedure validateMLHeader(p_groupID in number,
122: p_validationLevel in number,
123: x_returnStatus out nocopy varchar2,
124: x_errorMsg out nocopy varchar2) is
125: l_params wip_logger.param_tbl_t;
126: l_procName varchar2(30) := 'validateMLHeader';
127: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
128: l_retStatus varchar2(1);
129:

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

133: l_params(1).paramName := 'p_groupID';
134: l_params(1).paramValue := p_groupID;
135: l_params(2).paramName := 'p_validationLevel';
136: l_params(2).paramValue := p_validationLevel;
137: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
138: p_params => l_params,
139: x_returnStatus => x_returnStatus);
140: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
141: raise fnd_api.g_exc_unexpected_error;

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

160: raise fnd_api.g_exc_unexpected_error;
161: end if;
162:
163: if (l_logLevel <= wip_constants.trace_logging) then
164: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
165: p_procReturnStatus => x_returnStatus,
166: p_msg => 'success',
167: x_returnStatus => l_retStatus);
168: end if;

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

169:
170: exception
171: when fnd_api.g_exc_unexpected_error then
172: if(l_logLevel <= wip_constants.trace_logging) then
173: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
174: p_procReturnStatus => x_returnStatus,
175: p_msg => 'unexp error:' || x_errorMsg,
176: x_returnStatus => l_retStatus);
177: end if;

Line 186: l_params wip_logger.param_tbl_t;

182: procedure groupValidateMLHeader(p_groupID in number,
183: p_validationLevel in number,
184: x_returnStatus out nocopy varchar2,
185: x_errorMsg out nocopy varchar2) is
186: l_params wip_logger.param_tbl_t;
187: l_procName varchar2(30) := 'groupValidateMLHeader';
188: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
189: l_retStatus varchar2(1);
190: l_msg varchar2(2000);

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

211: l_params(1).paramName := 'p_groupID';
212: l_params(1).paramValue := p_groupID;
213: l_params(2).paramName := 'p_validationLevel';
214: l_params(2).paramValue := p_validationLevel;
215: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
216: p_params => l_params,
217: x_returnStatus => x_returnStatus);
218: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
219: raise fnd_api.g_exc_unexpected_error;

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

3032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3033: end if;
3034:
3035: if (l_logLevel <= wip_constants.trace_logging) then
3036: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3037: p_procReturnStatus => x_returnStatus,
3038: p_msg => 'success',
3039: x_returnStatus => l_retStatus);
3040: end if;

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

3041:
3042: exception
3043: when others then
3044: if(l_logLevel <= wip_constants.trace_logging) then
3045: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3046: p_procReturnStatus => x_returnStatus,
3047: p_msg => 'unexp error:' || SQLERRM,
3048: x_returnStatus => l_retStatus);
3049: end if;

Line 3063: l_params wip_logger.param_tbl_t;

3059: procedure lineValidateMLHeader(p_groupID in number,
3060: p_validationLevel in number,
3061: x_returnStatus out nocopy varchar2,
3062: x_errorMsg out nocopy varchar2) is
3063: l_params wip_logger.param_tbl_t;
3064: l_procName varchar2(30) := 'lineValidateMLHeader';
3065: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
3066: l_retStatus varchar2(1);
3067: l_msg varchar2(2000);

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

3079: x_returnStatus := fnd_api.g_ret_sts_success;
3080: if (l_logLevel <= wip_constants.trace_logging) then
3081: l_params(2).paramName := 'p_validationLevel';
3082: l_params(2).paramValue := p_validationLevel;
3083: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
3084: p_params => l_params,
3085: x_returnStatus => x_returnStatus);
3086: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3087: raise fnd_api.g_exc_unexpected_error;

Line 3096: wip_logger.log('begin to validate record with interface_id: ' || wjsi_row.interface_id,

3092: begin
3093: setup(line.rowid);
3094:
3095: if (l_logLevel <= wip_constants.trace_logging) then
3096: wip_logger.log('begin to validate record with interface_id: ' || wjsi_row.interface_id,
3097: l_retStatus);
3098: end if;
3099:
3100: validateKanban(line.rowid, p_validationLevel, l_msg);

Line 3167: wip_logger.log('Validation Error happened on interface_id ' || line.interface_id || ': ' || l_msg,

3163:
3164: exception
3165: when line_validation_error then
3166: if (l_logLevel <= wip_constants.trace_logging) then
3167: wip_logger.log('Validation Error happened on interface_id ' || line.interface_id || ': ' || l_msg,
3168: l_retStatus);
3169: end if;
3170: end;
3171:

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

3204: end loop;
3205:
3206:
3207: if (l_logLevel <= wip_constants.trace_logging) then
3208: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3209: p_procReturnStatus => x_returnStatus,
3210: p_msg => 'success',
3211: x_returnStatus => l_retStatus);
3212: end if;

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

3213:
3214: exception
3215: when others then
3216: if(l_logLevel <= wip_constants.trace_logging) then
3217: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3218: p_procReturnStatus => x_returnStatus,
3219: p_msg => 'unexp error:' || SQLERRM,
3220: x_returnStatus => l_retStatus);
3221: end if;

Line 3731: wip_logger.log('ENTERED into Validate routing revision',l_ret_status);

3727: wip_constants.RESCHED_JOB --5194524
3728: )
3729: ) then
3730:
3731: wip_logger.log('ENTERED into Validate routing revision',l_ret_status);
3732:
3733: select count(*)
3734: into l_count
3735: from bom_operational_routings

Line 3759: wip_logger.log('calling wip_revisions.routing_revision',l_ret_status);

3755: END;
3756: END IF;
3757: --Bug 5464449:End of changes.
3758: if(l_count > 0) then
3759: wip_logger.log('calling wip_revisions.routing_revision',l_ret_status);
3760: --l_start_date := greatest(nvl(wjsi_row.first_unit_start_date, wjsi_row.last_unit_completion_date), sysdate);
3761:
3762: wip_revisions.routing_revision(p_organization_id => wjsi_row.organization_id,
3763: p_item_id => l_rtgItemID,

Line 4632: l_params wip_logger.param_tbl_t;

4628: job
4629: */
4630: procedure deriveScheduleDate(p_rowid in rowid,
4631: x_errorMsg out nocopy varchar2) is
4632: l_params wip_logger.param_tbl_t;
4633: l_ret_status varchar2(20);
4634: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
4635: l_procName varchar2(30) := 'deriveScheduleDate';
4636: begin

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

4636: begin
4637: if (l_logLevel <= wip_constants.trace_logging) then
4638: l_params(1).paramName := 'p_rowid';
4639: l_params(1).paramValue := p_rowid;
4640: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
4641: p_params => l_params,
4642: x_returnStatus => l_ret_status);
4643: if(l_ret_status <> fnd_api.g_ret_sts_success) then
4644: raise fnd_api.g_exc_unexpected_error;

Line 4674: wip_logger.log(' Repopulated Scheduled Start Date as' || wjsi_row.first_unit_start_date,

4670: where group_id = wjsi_row.group_id
4671: and parent_header_id = wjsi_row.header_id
4672: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
4673: ) ;
4674: wip_logger.log(' Repopulated Scheduled Start Date as' || wjsi_row.first_unit_start_date,
4675: l_ret_status );
4676: exception
4677: when NO_DATA_FOUND then
4678: null;

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

4679: end;
4680: end if;
4681:
4682: if (l_logLevel <= wip_constants.trace_logging) then
4683: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
4684: p_procReturnStatus => null,
4685: p_msg => 'success',
4686: x_returnStatus => l_ret_status);
4687: end if;