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 126: l_params wip_logger.param_tbl_t;

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

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

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

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

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

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

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

Line 187: l_params wip_logger.param_tbl_t;

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

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

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

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

3061: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3062: end if;
3063:
3064: if (l_logLevel <= wip_constants.trace_logging) then
3065: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3066: p_procReturnStatus => x_returnStatus,
3067: p_msg => 'success',
3068: x_returnStatus => l_retStatus);
3069: end if;

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

3070:
3071: exception
3072: when others then
3073: if(l_logLevel <= wip_constants.trace_logging) then
3074: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3075: p_procReturnStatus => x_returnStatus,
3076: p_msg => 'unexp error:' || SQLERRM,
3077: x_returnStatus => l_retStatus);
3078: end if;

Line 3092: l_params wip_logger.param_tbl_t;

3088: procedure lineValidateMLHeader(p_groupID in number,
3089: p_validationLevel in number,
3090: x_returnStatus out nocopy varchar2,
3091: x_errorMsg out nocopy varchar2) is
3092: l_params wip_logger.param_tbl_t;
3093: l_procName varchar2(30) := 'lineValidateMLHeader';
3094: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
3095: l_retStatus varchar2(1);
3096: l_msg varchar2(2000);

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

3108: x_returnStatus := fnd_api.g_ret_sts_success;
3109: if (l_logLevel <= wip_constants.trace_logging) then
3110: l_params(2).paramName := 'p_validationLevel';
3111: l_params(2).paramValue := p_validationLevel;
3112: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
3113: p_params => l_params,
3114: x_returnStatus => x_returnStatus);
3115: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3116: raise fnd_api.g_exc_unexpected_error;

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

3121: begin
3122: setup(line.rowid);
3123:
3124: if (l_logLevel <= wip_constants.trace_logging) then
3125: wip_logger.log('begin to validate record with interface_id: ' || wjsi_row.interface_id,
3126: l_retStatus);
3127: end if;
3128:
3129: validateKanban(line.rowid, p_validationLevel, l_msg);

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

3192:
3193: exception
3194: when line_validation_error then
3195: if (l_logLevel <= wip_constants.trace_logging) then
3196: wip_logger.log('Validation Error happened on interface_id ' || line.interface_id || ': ' || l_msg,
3197: l_retStatus);
3198: end if;
3199: end;
3200: --Bug#13483213:bom_revision_Date and routing_revision_date are no longer truncated to the seconds. The actual timestamp is updated.

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

3232: end loop;
3233:
3234:
3235: if (l_logLevel <= wip_constants.trace_logging) then
3236: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3237: p_procReturnStatus => x_returnStatus,
3238: p_msg => 'success',
3239: x_returnStatus => l_retStatus);
3240: end if;

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

3241:
3242: exception
3243: when others then
3244: if(l_logLevel <= wip_constants.trace_logging) then
3245: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3246: p_procReturnStatus => x_returnStatus,
3247: p_msg => 'unexp error:' || SQLERRM,
3248: x_returnStatus => l_retStatus);
3249: end if;

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

3833: wip_constants.RESCHED_JOB --5194524
3834: )
3835: ) then
3836:
3837: wip_logger.log('ENTERED into Validate routing revision',l_ret_status);
3838:
3839: select count(*)
3840: into l_count
3841: from bom_operational_routings

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

3861: END;
3862: END IF;
3863: --Bug 5464449:End of changes.
3864: if(l_count > 0) then
3865: wip_logger.log('calling wip_revisions.routing_revision',l_ret_status);
3866: --l_start_date := greatest(nvl(wjsi_row.first_unit_start_date, wjsi_row.last_unit_completion_date), sysdate);
3867:
3868: wip_revisions.routing_revision(p_organization_id => wjsi_row.organization_id,
3869: p_item_id => l_rtgItemID,

Line 4761: l_params wip_logger.param_tbl_t;

4757: job
4758: */
4759: procedure deriveScheduleDate(p_rowid in rowid,
4760: x_errorMsg out nocopy varchar2) is
4761: l_params wip_logger.param_tbl_t;
4762: l_ret_status varchar2(20);
4763: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
4764: l_procName varchar2(30) := 'deriveScheduleDate';
4765: begin

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

4765: begin
4766: if (l_logLevel <= wip_constants.trace_logging) then
4767: l_params(1).paramName := 'p_rowid';
4768: l_params(1).paramValue := p_rowid;
4769: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
4770: p_params => l_params,
4771: x_returnStatus => l_ret_status);
4772: if(l_ret_status <> fnd_api.g_ret_sts_success) then
4773: raise fnd_api.g_exc_unexpected_error;

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

4799: where group_id = wjsi_row.group_id
4800: and parent_header_id = wjsi_row.header_id
4801: and load_type = WIP_JOB_DETAILS.WIP_OPERATION
4802: ) ;
4803: wip_logger.log(' Repopulated Scheduled Start Date as' || wjsi_row.first_unit_start_date,
4804: l_ret_status );
4805: exception
4806: when NO_DATA_FOUND then
4807: null;

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

4808: end;
4809: end if;
4810:
4811: if (l_logLevel <= wip_constants.trace_logging) then
4812: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
4813: p_procReturnStatus => null,
4814: p_msg => 'success',
4815: x_returnStatus => l_ret_status);
4816: end if;