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

Line 74: l_params wip_logger.param_tbl_t;

70: p_quantity IN NUMBER := null, -- Fix bug 5440007
71: x_returnStatus OUT NOCOPY VARCHAR2,
72: x_errorMsg OUT NOCOPY VARCHAR2) is
73: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
74: l_params wip_logger.param_tbl_t;
75: l_retStatus VARCHAR2(1);
76: l_resTbls wip_infResSched_grp.op_res_rectbl_t;
77: l_repLineID NUMBER;
78: l_assignedUnits num_tbl_t;

Line 108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

104: l_params(9).paramValue := p_subGrpNum;
105: l_params(10).paramName := 'p_quantity';
106: l_params(10).paramValue := p_quantity;
107:
108: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
109: p_params => l_params,
110: x_returnStatus => x_returnStatus);
111: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
112: raise fnd_api.g_exc_unexpected_error;

Line 122: wip_logger.log('reading job/schedule...', l_retStatus);

118: fnd_msg_pub.initialize;
119: end if;
120:
121: if (l_logLevel <= wip_constants.full_logging) then
122: wip_logger.log('reading job/schedule...', l_retStatus);
123: end if;
124: if(p_midPntMethod is not null) then
125: l_schedMethod := p_midPntMethod;
126: elsif(p_opSeqNum is not null) then

Line 171: wip_logger.log('scheduling job/schedule...', l_retStatus);

167: where repetitive_schedule_id = p_repSchedID;
168: end if;
169: */
170: if (l_logLevel <= wip_constants.full_logging) then
171: wip_logger.log('scheduling job/schedule...', l_retStatus);
172: end if;
173:
174: wip_infResSched_grp.schedule(p_orgID => p_orgID,
175: -- p_repLineID => l_repLineID,

Line 188: wip_logger.log('writing job/schedule...', l_retStatus);

184: raise fnd_api.g_exc_unexpected_error;
185: end if;
186:
187: if (l_logLevel <= wip_constants.full_logging) then
188: wip_logger.log('writing job/schedule...', l_retStatus);
189: end if;
190:
191: writeJobSchedule(p_wipEntityID => p_wipEntityID,
192: p_repSchedID => p_repSchedID,

Line 209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

205: raise fnd_api.g_exc_unexpected_error;
206: end if;
207:
208: if (l_logLevel <= wip_constants.trace_logging) then
209: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'success',
212: x_returnStatus => l_retStatus);
213: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 214: wip_logger.cleanup(l_retStatus);

210: p_procReturnStatus => x_returnStatus,
211: p_msg => 'success',
212: x_returnStatus => l_retStatus);
213: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
214: wip_logger.cleanup(l_retStatus);
215: end if;
216: end if;
217: exception
218: when fnd_api.g_exc_unexpected_error then

Line 224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

220: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
221: wip_utilities.get_message_stack(p_msg => x_errorMsg,
222: p_delete_stack => fnd_api.g_false);
223: if (l_logLevel <= wip_constants.trace_logging) then
224: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
225: p_procReturnStatus => x_returnStatus,
226: p_msg => 'error: ' || x_errorMsg,
227: x_returnStatus => l_retStatus);
228: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 229: wip_logger.cleanup(l_retStatus);

225: p_procReturnStatus => x_returnStatus,
226: p_msg => 'error: ' || x_errorMsg,
227: x_returnStatus => l_retStatus);
228: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
229: wip_logger.cleanup(l_retStatus);
230: end if;
231: end if;
232:
233: when others then

Line 242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

238: p_error_text => SQLERRM);
239: wip_utilities.get_message_stack(p_msg => x_errorMsg,
240: p_delete_stack => fnd_api.g_false);
241: if (l_logLevel <= wip_constants.trace_logging) then
242: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'unexp error: ' || x_errorMsg,
245: x_returnStatus => l_retStatus);
246: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 247: wip_logger.cleanup(l_retStatus);

243: p_procReturnStatus => x_returnStatus,
244: p_msg => 'unexp error: ' || x_errorMsg,
245: x_returnStatus => l_retStatus);
246: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then
247: wip_logger.cleanup(l_retStatus);
248: end if;
249: end if;
250: end schedule;
251:

Line 263: l_params wip_logger.param_tbl_t;

259: x_minSchedSeqNum OUT NOCOPY NUMBER,
260: x_maxOpSeqNum OUT NOCOPY NUMBER,
261: x_maxSchedSeqNum OUT NOCOPY NUMBER) is
262: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
263: l_params wip_logger.param_tbl_t;
264: l_retStatus VARCHAR2(1);
265: begin
266: if (l_logLevel <= wip_constants.trace_logging) then
267: l_params(1).paramName := 'p_midPntOpSeqNum';

Line 279: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.getMidPointInfo',

275: l_params(5).paramName := 'p_wipEntityID';
276: l_params(5).paramValue := p_wipEntityID;
277: l_params(6).paramName := 'p_orgID';
278: l_params(6).paramValue := p_orgID;
279: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.getMidPointInfo',
280: p_params => l_params,
281: x_returnStatus => l_retStatus);
282: end if;
283:

Line 289: wip_logger.log('entire job reschedule', l_retStatus);

285: wip_constants.backwards,
286: wip_constants.midpoint)) then
287:
288: if(l_logLevel <= wip_constants.full_logging) then
289: wip_logger.log('entire job reschedule', l_retStatus);
290: end if;
291:
292: select min(operation_seq_num),
293: max(operation_seq_num)

Line 303: wip_logger.log('midpoint forward', l_retStatus);

299:
300: elsif(p_schedMethod = wip_constants.midpoint_forwards) then
301:
302: if(l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log('midpoint forward', l_retStatus);
304: end if;
305:
306: x_minOpSeqNum := p_midPntOpSeqNum;
307:

Line 351: wip_logger.log('midpoint backward', l_retStatus);

347: x_maxSchedSeqNum := null;
348: end if;
349:
350: if(l_logLevel <= wip_constants.full_logging) then
351: wip_logger.log('midpoint backward', l_retStatus);
352: end if;
353:
354: select min(operation_seq_num)
355: into x_minOpSeqNum

Line 369: wip_logger.log('current op', l_retStatus);

365: and operation_seq_num = x_minOpSeqNum;
366: elsif(p_schedMethod = wip_constants.current_op) then
367:
368: if(l_logLevel <= wip_constants.full_logging) then
369: wip_logger.log('current op', l_retStatus);
370: end if;
371:
372: x_minOpSeqNum := p_midPntOpSeqNum;
373: x_maxOpSeqNum := p_midPntOpSeqNum;

Line 383: wip_logger.log('current sub grp', l_retStatus);

379: and operation_seq_num = p_midPntOpSeqNum;
380: elsif(p_schedMethod = wip_constants.current_sub_grp) then
381:
382: if(l_logLevel <= wip_constants.full_logging) then
383: wip_logger.log('current sub grp', l_retStatus);
384: end if;
385:
386: x_minOpSeqNum := p_midPntOpSeqNum;
387: x_maxOpSeqNum := p_midPntOpSeqNum;

Line 399: wip_logger.log('current op res', l_retStatus);

395: and substitute_group_num = p_subGrpNum;
396: else --current op resource
397:
398: if(l_logLevel <= wip_constants.full_logging) then
399: wip_logger.log('current op res', l_retStatus);
400: end if;
401:
402: x_minOpSeqNum := p_midPntOpSeqNum;
403: x_maxOpSeqNum := p_midPntOpSeqNum;

Line 422: wip_logger.log('min op seq' || x_minOpSeqNum, l_retStatus);

418: x_maxSchedSeqNum := x_minSchedSeqNum;
419: end if;
420:
421: if(l_logLevel <= wip_constants.full_logging) then
422: wip_logger.log('min op seq' || x_minOpSeqNum, l_retStatus);
423: wip_logger.log('min sched seq' || x_minSchedSeqNum, l_retStatus);
424: wip_logger.log('max op seq' || x_maxOpSeqNum, l_retStatus);
425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;

Line 423: wip_logger.log('min sched seq' || x_minSchedSeqNum, l_retStatus);

419: end if;
420:
421: if(l_logLevel <= wip_constants.full_logging) then
422: wip_logger.log('min op seq' || x_minOpSeqNum, l_retStatus);
423: wip_logger.log('min sched seq' || x_minSchedSeqNum, l_retStatus);
424: wip_logger.log('max op seq' || x_maxOpSeqNum, l_retStatus);
425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;
427:

Line 424: wip_logger.log('max op seq' || x_maxOpSeqNum, l_retStatus);

420:
421: if(l_logLevel <= wip_constants.full_logging) then
422: wip_logger.log('min op seq' || x_minOpSeqNum, l_retStatus);
423: wip_logger.log('min sched seq' || x_minSchedSeqNum, l_retStatus);
424: wip_logger.log('max op seq' || x_maxOpSeqNum, l_retStatus);
425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;
427:
428: if(l_logLevel <= wip_constants.trace_logging) then

Line 425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);

421: if(l_logLevel <= wip_constants.full_logging) then
422: wip_logger.log('min op seq' || x_minOpSeqNum, l_retStatus);
423: wip_logger.log('min sched seq' || x_minSchedSeqNum, l_retStatus);
424: wip_logger.log('max op seq' || x_maxOpSeqNum, l_retStatus);
425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;
427:
428: if(l_logLevel <= wip_constants.trace_logging) then
429: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

Line 429: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',

425: wip_logger.log('max sched seq' || x_maxSchedSeqNum, l_retStatus);
426: end if;
427:
428: if(l_logLevel <= wip_constants.trace_logging) then
429: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.schedule',
430: p_procReturnStatus => 'N/A',
431: p_msg => 'success',
432: x_returnStatus => l_retStatus);
433: end if;

Line 452: l_params wip_logger.param_tbl_t;

448: x_resTbls out nocopy wip_infResSched_grp.op_res_rectbl_t,
449: x_assignedUnits out nocopy num_tbl_t,
450: x_returnStatus out nocopy varchar2) is
451: l_loglevel NUMBER := fnd_log.g_current_runtime_level;
452: l_params wip_logger.param_tbl_t;
453: l_retStatus VARCHAR2(1);
454: l_hrUOM VARCHAR2(3);
455: l_hrVal NUMBER;
456: l_uomClass VARCHAR2(10);

Line 556: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

552: l_params(7).paramValue := p_maxSchedSeqNum;
553: l_params(8).ParamName := 'P_quantity';
554: l_params(8).ParamValue := p_quantity;
555:
556: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
557: p_params => l_params,
558: x_returnStatus => l_retStatus);
559: end if;
560: x_returnStatus := fnd_api.g_ret_sts_success;

Line 695: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

691: open c_resInsts;
692: close c_resInsts;
693:
694: if (l_logLevel <= wip_constants.trace_logging) then
695: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
696: p_procReturnStatus => x_returnStatus,
697: p_msg => 'success',
698: x_returnStatus => l_retStatus);
699: end if;

Line 707: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',

703: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
704: p_procedure_name => 'readJobSchedule',
705: p_error_text => SQLERRM);
706: if (l_logLevel <= wip_constants.trace_logging) then
707: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.readJobSchedule',
708: p_procReturnStatus => x_returnStatus,
709: p_msg => 'unexp error: ' || SQLERRM,
710: x_returnStatus => l_retStatus);
711: end if;

Line 748: l_params wip_logger.param_tbl_t;

744: l_maxResEndDate DATE;
745: l_jobStartDate DATE;
746: l_jobCplDate DATE;
747: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
748: l_params wip_logger.param_tbl_t;
749: l_retStatus VARCHAR2(1);
750: begin
751: savepoint wipiscdb100;
752: if (l_logLevel <= wip_constants.trace_logging) then

Line 775: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

771: for i in 1..p_assignedUnits.count loop
772: l_params(9+i).paramName := 'p_assignedUnits(' || i || ')';
773: l_params(9+i).paramValue := p_assignedUnits(i);
774: end loop;
775: wip_logger.entryPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
776: p_params => l_params,
777: x_returnStatus => l_retStatus);
778: end if;
779: x_returnStatus := fnd_api.g_ret_sts_success;

Line 799: wip_logger.log('wrote resources', l_retStatus);

795: and operation_seq_num = x_resTbls.opSeqNum(i)
796: and resource_seq_num = x_resTbls.resSeqNum(i);
797:
798: if(l_logLevel <= wip_constants.full_logging) then
799: wip_logger.log('wrote resources', l_retStatus);
800: end if;
801:
802:
803: forall i in 1..x_resTbls.resID.count

Line 816: wip_logger.log('wrote resource instances', l_retStatus);

812: and operation_seq_num = x_resTbls.opSeqNum(i)
813: and resource_seq_num = x_resTbls.resSeqNum(i);
814:
815: if(l_logLevel <= wip_constants.full_logging) then
816: wip_logger.log('wrote resource instances', l_retStatus);
817: end if;
818:
819: delete wip_operation_resource_usage
820: where (organization_id, wip_entity_id, operation_seq_num, resource_seq_num) in

Line 887: wip_logger.log('wrote resource usages', l_retStatus);

883: l_sysdate);
884: end if;
885: end loop;
886: if(l_logLevel <= wip_constants.full_logging) then
887: wip_logger.log('wrote resource usages', l_retStatus);
888: end if;
889:
890: insert into wip_operation_resource_usage
891: (wip_entity_id,

Line 960: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' resource instance usages', l_retStatus);

956: and woru.resource_seq_num = wor.resource_seq_num;
957:
958:
959: if(l_logLevel <= wip_constants.full_logging) then
960: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' resource instance usages', l_retStatus);
961: end if;
962:
963: if(l_logLevel <= wip_constants.full_logging) then
964: wip_logger.log('about to start op processing', l_retStatus);

Line 964: wip_logger.log('about to start op processing', l_retStatus);

960: wip_logger.log('wrote ' || SQL%ROWCOUNT || ' resource instance usages', l_retStatus);
961: end if;
962:
963: if(l_logLevel <= wip_constants.full_logging) then
964: wip_logger.log('about to start op processing', l_retStatus);
965: end if;
966: --base operation dates off of op resource dates
967: select wo.operation_seq_num,
968: min(wor.start_date),

Line 1001: wip_logger.log('about to start op processing', l_retStatus);

997: and wip_constants.sched_yes = wor.scheduled_flag (+)
998: group by wo.operation_seq_num;
999:
1000: if(l_logLevel <= wip_constants.full_logging) then
1001: wip_logger.log('about to start op processing', l_retStatus);
1002: end if;
1003:
1004: for i in 1..l_opTbls.opSeqNum.count loop
1005: if(l_opTbls.startDate(i) is null) then

Line 1062: wip_logger.log('about to write ops', l_retStatus);

1058: end if;
1059: end loop;
1060:
1061: if(l_logLevel <= wip_constants.full_logging) then
1062: wip_logger.log('about to write ops', l_retStatus);
1063: end if;
1064:
1065: if(l_startOpIdx is not null) then
1066: forall i in l_startOpIdx..l_endOpIdx

Line 1083: wip_logger.log('wrote ops', l_retStatus);

1079: where wip_entity_id = p_wipEntityID
1080: and organization_id = p_orgID
1081: and operation_seq_num = l_opTbls.opSeqNum(i);
1082: if(l_logLevel <= wip_constants.full_logging) then
1083: wip_logger.log('wrote ops', l_retStatus);
1084: end if;
1085:
1086: --update mtl requirement dates if job has routing
1087: forall i in l_startOpIdx..l_endOpIdx

Line 1117: wip_logger.log('wrote material requirements', l_retStatus);

1113: and operation_seq_num = 1;
1114: end if;
1115:
1116: if(l_logLevel <= wip_constants.full_logging) then
1117: wip_logger.log('wrote material requirements', l_retStatus);
1118: end if;
1119:
1120: --now update job dates
1121: --must select from table to get resource dates b/c of partial job scheduling

Line 1129: wip_logger.log('min res date:' || to_char(l_minResStartDate, g_logDateFmt), l_retStatus);

1125: where wip_entity_id = p_wipEntityID
1126: and organization_id = p_orgID;
1127:
1128: if(l_logLevel <= wip_constants.full_logging) then
1129: wip_logger.log('min res date:' || to_char(l_minResStartDate, g_logDateFmt), l_retStatus);
1130: wip_logger.log('max res date:' || to_char(l_maxResEndDate, g_logDateFmt), l_retStatus);
1131: end if;
1132: --if there are no resources, set the local variables to p_anchorDate
1133: --so below update is correct.

Line 1130: wip_logger.log('max res date:' || to_char(l_maxResEndDate, g_logDateFmt), l_retStatus);

1126: and organization_id = p_orgID;
1127:
1128: if(l_logLevel <= wip_constants.full_logging) then
1129: wip_logger.log('min res date:' || to_char(l_minResStartDate, g_logDateFmt), l_retStatus);
1130: wip_logger.log('max res date:' || to_char(l_maxResEndDate, g_logDateFmt), l_retStatus);
1131: end if;
1132: --if there are no resources, set the local variables to p_anchorDate
1133: --so below update is correct.
1134: l_jobStartDate := nvl(l_minResStartDate, p_anchorDate);

Line 1151: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

1147: where wip_entity_id = p_wipEntityID
1148: and organization_id = p_orgID;
1149:
1150: if (l_logLevel <= wip_constants.trace_logging) then
1151: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
1152: p_procReturnStatus => x_returnStatus,
1153: p_msg => 'success',
1154: x_returnStatus => l_retStatus);
1155: end if;

Line 1164: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',

1160: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infinite_scheduler_pvt',
1161: p_procedure_name => 'writeJobSchedule',
1162: p_error_text => SQLERRM);
1163: if (l_logLevel <= wip_constants.trace_logging) then
1164: wip_logger.exitPoint(p_procName => 'wip_infinite_scheduler_pvt.writeJobSchedule',
1165: p_procReturnStatus => x_returnStatus,
1166: p_msg => 'unexp error: ' || SQLERRM,
1167: x_returnStatus => l_retStatus);
1168: end if;