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_INFRESSCHED_GRP dependencies on WIP_INFRESSCHED_GRP

Line 1: package body wip_infResSched_grp as

1: package body wip_infResSched_grp as
2: /* $Header: wipinrsb.pls 120.13.12020000.6 2013/03/20 12:17:26 kswarna ship $ */
3:
4: --package constants
5: g_dateCursorLen CONSTANT NUMBER := 10;--must be greater than or equal to 1

Line 133: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removePriorsFromBatch',

129: l_retStatus VARCHAR2(1);
130: l_params wip_logger.param_tbl_t;
131: begin
132: if(l_logLevel <= wip_constants.trace_logging) then
133: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removePriorsFromBatch',
134: p_params => l_params,
135: x_returnStatus => l_retStatus);
136: end if;
137: while(i <= x_resTbls.resID.count) loop

Line 158: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removePriorsFromBatch',

154: end if;
155: i := i + 1;
156: end loop;
157: if (l_logLevel <= wip_constants.trace_logging) then
158: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removePriorsFromBatch',
159: p_procReturnStatus => null,
160: p_msg => 'success',
161: x_returnStatus => l_retStatus);
162: end if;

Line 173: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removePriors',

169: l_retStatus VARCHAR2(1);
170: l_params wip_logger.param_tbl_t;
171: begin
172: if(l_logLevel <= wip_constants.trace_logging) then
173: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removePriors',
174: p_params => l_params,
175: x_returnStatus => l_retStatus);
176: end if;
177: for i in 1..x_resTbls.resID.count loop

Line 189: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removePriors',

185: l_nonPriorExists := x_resTbls.schedFlag(i) not in (wip_constants.sched_prior, wip_constants.sched_no);
186: end if;
187: end loop;
188: if (l_logLevel <= wip_constants.trace_logging) then
189: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removePriors',
190: p_procReturnStatus => null,
191: p_msg => 'success',
192: x_returnStatus => l_retStatus);
193: end if;

Line 204: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removeNexts',

200: l_retStatus VARCHAR2(1);
201: l_params wip_logger.param_tbl_t;
202: begin
203: if(l_logLevel <= wip_constants.trace_logging) then
204: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.removeNexts',
205: p_params => l_params,
206: x_returnStatus => l_retStatus);
207: end if;
208: for i in reverse 1..x_resTbls.resID.count loop

Line 221: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removeNexts',

217: l_nonNextExists := x_resTbls.schedFlag(i) not in (wip_constants.sched_no, wip_constants.sched_next);
218: end if;
219: end loop;
220: if (l_logLevel <= wip_constants.trace_logging) then
221: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.removeNexts',
222: p_procReturnStatus => null,
223: p_msg => 'success',
224: x_returnStatus => l_retStatus);
225: end if;

Line 235: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.verifyResources',

231: l_retStatus VARCHAR2(1);
232: l_params wip_logger.param_tbl_t;
233: begin
234: if(l_logLevel <= wip_constants.trace_logging) then
235: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.verifyResources',
236: p_params => l_params,
237: x_returnStatus => l_retStatus);
238: end if;
239:

Line 261: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.verifyResources',

257: --changes schedule method of prior resources to yes if
258: -- + they are in a simultaneous batch with yes or next resources.
259: removePriorsFromBatch(x_resTbls => x_resTbls);
260: if (l_logLevel <= wip_constants.trace_logging) then
261: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.verifyResources',
262: p_procReturnStatus => null,
263: p_msg => 'success',
264: x_returnStatus => l_retStatus);
265: end if;

Line 274: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.dumpOps',

270: l_retStatus VARCHAR2(1);
271: l_params wip_logger.param_tbl_t;
272: begin
273: if(l_logLevel <= wip_constants.trace_logging) then
274: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.dumpOps',
275: p_params => l_params,
276: x_returnStatus => l_retStatus);
277: end if;
278: if(l_logLevel <= wip_constants.full_logging) then

Line 297: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpOps',

293: wip_logger.log('resRange:' || p_opTbl(i).resStartIdx || '-' || p_opTbl(i).resEndIdx, l_retStatus);
294: end loop;
295: end if;
296: if (l_logLevel <= wip_constants.trace_logging) then
297: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpOps',
298: p_procReturnStatus => null,
299: p_msg => 'success',
300: x_returnStatus => l_retStatus);
301: end if;

Line 319: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.buildOpStructure',

315: begin
316: if(l_logLevel <= wip_constants.trace_logging) then
317: l_params(1).paramName := 'p_anchorDate';
318: l_params(1).paramValue := to_char(p_anchorDate, g_logDateFmt);
319: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.buildOpStructure',
320: p_params => l_params,
321: x_returnStatus => l_retStatus);
322: end if;
323:

Line 393: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.buildOpStructure',

389: dumpOps(x_opTbl);
390: end if;
391:
392: if (l_logLevel <= wip_constants.trace_logging) then
393: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.buildOpStructure',
394: p_procReturnStatus => null,
395: p_msg => 'success',
396: x_returnStatus => l_retStatus);
397: end if;

Line 420: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.findMdPntRes',

416: l_params(3).paramName := 'p_isMdPntFwd';
417: if(p_isMdPntFwd) then l_params(3).paramValue := 'true';
418: else l_params(3).paramValue := 'false'; end if;
419:
420: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.findMdPntRes',
421: p_params => l_params,
422: x_returnStatus => l_retStatus);
423: end if;
424:

Line 512: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.findMdPntRes',

508: exit;
509: end if;
510: end loop;
511: if(l_logLevel <= wip_constants.trace_logging) then
512: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.findMdPntRes',
513: p_procReturnStatus => null,
514: p_msg => 'fwdIdx:' || x_midPntFwdIdx || '; bkwdIdx:' || x_midPntBkwdIdx,
515: x_returnStatus => l_retStatus);
516: end if;

Line 551: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.schedule',

547: l_params(4).paramName := 'p_endDate';
548: l_params(4).paramValue := to_char(p_endDate, g_logDateFmt);
549: l_params(5).paramName := 'p_opSeqNum';
550: l_params(5).paramValue := p_opSeqNum;
551: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.schedule',
552: p_params => l_params,
553: x_returnStatus => x_returnStatus);
554: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
555: raise fnd_api.g_exc_unexpected_error;

Line 562: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

558: x_returnStatus := fnd_api.g_ret_sts_success;
559:
560: if(x_resTbls.resID is null or x_resTbls.resID.count < 1) then
561: if (l_logLevel <= wip_constants.trace_logging) then
562: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
563: p_procReturnStatus => x_returnStatus,
564: p_msg => 'no resources to schedule!',
565: x_returnStatus => l_retStatus);
566: end if;

Line 774: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

770:
771:
772:
773: if(l_logLevel <= wip_constants.trace_logging) then
774: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
775: p_procReturnStatus => x_returnStatus,
776: p_msg => 'success',
777: x_returnStatus => l_retStatus);
778: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 789: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

785: if(l_logLevel <= wip_constants.trace_logging) then
786: wip_utilities.get_message_stack(p_msg => l_errMsg,
787: p_delete_stack => fnd_api.g_false);
788:
789: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
790: p_procReturnStatus => x_returnStatus,
791: p_msg => 'failure: ' || l_errMsg,
792: x_returnStatus => l_retStatus);
793: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

795: end if;
796: end if;
797: when others then
798: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
800: p_procedure_name => 'schedule',
801: p_error_text => SQLERRM);
802: if(l_logLevel <= wip_constants.trace_logging) then
803: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

Line 803: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
800: p_procedure_name => 'schedule',
801: p_error_text => SQLERRM);
802: if(l_logLevel <= wip_constants.trace_logging) then
803: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
804: p_procReturnStatus => x_returnStatus,
805: p_msg => 'unexpected error: ' || SQLERRM,
806: x_returnStatus => l_retStatus);
807: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

Line 873: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getStartDate',

869: end if;
870: l_params(6).paramName := 'p_prevIdx';
871: l_params(6).paramValue := p_prevIdx;
872:
873: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getStartDate',
874: p_params => l_params,
875: x_returnStatus => l_retStatus);
876: end if;
877:

Line 913: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getStartDate',

909: l_maxEndDate := p_resTbls.endDate(i);
910: end if;
911:
912: if (l_logLevel <= wip_constants.trace_logging) then
913: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getStartDate',
914: p_procReturnStatus => to_char(l_maxEndDate),
915: p_msg => 'finished scheduling',
916: x_returnStatus => l_retStatus);
917: end if;

Line 931: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_shift',

927: l_params wip_logger.param_tbl_t;
928: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
929: begin
930: if (l_logLevel <= wip_constants.trace_logging) then
931: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_shift',
932: p_params => l_params,
933: x_returnStatus => l_retStatus);
934: end if;
935: if(p_fwd_or_bk_flag = 1) then /*backward schedule*/

Line 989: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.process_shift',

985: x_shifts.shiftNum(i) := -1;
986: end if;
987: end if;
988: if(l_logLevel <= wip_constants.trace_logging) then
989: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.process_shift',
990: p_procReturnStatus => l_retStatus,
991: p_msg => 'successful complete',
992: x_returnStatus => l_retStatus);
993: end if;

Line 1007: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_overlap_shifts',

1003: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1004: l_shifts shift_recTbl_t;
1005: begin
1006: if (l_logLevel <= wip_constants.trace_logging) then
1007: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.process_overlap_shifts',
1008: p_params => l_params,
1009: x_returnStatus => l_retStatus);
1010:
1011: wip_logger.log('shifts BEFORE overlap processing', l_retStatus);

Line 1104: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.process_overlap_shifts',

1100: || ' endDate:' || to_char(x_shifts.endDate(i), g_logDateFmt), l_retStatus);
1101: end if;
1102: end loop;
1103: if(l_logLevel <= wip_constants.trace_logging) then
1104: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.process_overlap_shifts',
1105: p_procReturnStatus => l_retStatus,
1106: p_msg => 'successful complete',
1107: x_returnStatus => l_retStatus);
1108: end if;

Line 1222: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

1218: l_params(4).paramName := 'p_idx';
1219: l_params(4).paramValue := p_idx;
1220: l_params(5).paramName := 'p_repLineID';
1221: l_params(5).paramValue := p_repLineID;
1222: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1223: p_params => l_params,
1224: x_returnStatus => l_retStatus);
1225: end if;
1226: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1516: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

1512: end if;
1513: end if;
1514: end loop;
1515: if(l_logLevel <= wip_constants.trace_logging) then
1516: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1517: p_procReturnStatus => x_returnStatus,
1518: p_msg => 'success',
1519: x_returnStatus => l_retStatus);
1520: end if;

Line 1525: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

1521: exception
1522: when fnd_api.g_exc_unexpected_error then
1523: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1524: if(l_logLevel <= wip_constants.trace_logging) then
1525: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1526: p_procReturnStatus => x_returnStatus,
1527: p_msg => 'error',
1528: x_returnStatus => l_retStatus);
1529: end if;

Line 1532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

1528: x_returnStatus => l_retStatus);
1529: end if;
1530: when others then
1531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1533: p_procedure_name => 'forwardSchResource',
1534: p_error_text => SQLERRM);
1535: if(l_logLevel <= wip_constants.trace_logging) then
1536: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

Line 1536: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

1532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1533: p_procedure_name => 'forwardSchResource',
1534: p_error_text => SQLERRM);
1535: if(l_logLevel <= wip_constants.trace_logging) then
1536: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1537: p_procReturnStatus => x_returnStatus,
1538: p_msg => 'unexp error: ' || SQLERRM,
1539: x_returnStatus => l_retStatus);
1540: end if;

Line 1544: /* fix bug 7027946: Added procedure wip_infResSched_grp.capacityExceptions to handle resource capacity exceptions.

1540: end if;
1541:
1542: end forwardSchResource;
1543:
1544: /* fix bug 7027946: Added procedure wip_infResSched_grp.capacityExceptions to handle resource capacity exceptions.
1545: It will change the resource shifts (add day, delete day, modify shift times) as per capacity
1546: exceptions.
1547: */
1548: procedure capacityExceptions(p_resID IN NUMBER,

Line 1624: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

1620: l_params(2).paramValue := p_deptID;
1621: l_params(3).paramName := 'p_orgID';
1622: l_params(3).paramValue := p_orgID;
1623:
1624: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
1625: p_params => l_params,
1626: x_returnStatus => x_returnStatus);
1627: end if;
1628:

Line 2007: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

2003: end if;
2004: end loop;
2005:
2006: IF(l_logLevel <= wip_constants.trace_logging) then
2007: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
2008: p_procReturnStatus => x_returnStatus,
2009: p_msg => 'success',
2010: x_returnStatus => l_retStatus);
2011: END IF;

Line 2016: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

2012: EXCEPTION
2013: WHEN fnd_api.g_exc_unexpected_error THEN
2014: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2015: if(l_logLevel <= wip_constants.trace_logging) then
2016: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
2017: p_procReturnStatus => x_returnStatus,
2018: p_msg => 'error',
2019: x_returnStatus => l_retStatus);
2020: end if;

Line 2023: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

2019: x_returnStatus => l_retStatus);
2020: end if;
2021: WHEN others THEN
2022: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2023: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2024: p_procedure_name => 'capacityExceptions',
2025: p_error_text => SQLERRM);
2026: if(l_logLevel <= wip_constants.trace_logging) then
2027: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

Line 2027: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

2023: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2024: p_procedure_name => 'capacityExceptions',
2025: p_error_text => SQLERRM);
2026: if(l_logLevel <= wip_constants.trace_logging) then
2027: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
2028: p_procReturnStatus => x_returnStatus,
2029: p_msg => 'unexp error: ' || SQLERRM,
2030: x_returnStatus => l_retStatus);
2031: end if;

Line 2067: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

2063: l_params(4).paramValue := p_range(2);
2064: l_params(5).paramName := 'p_schedFlag';
2065: l_params(5).paramValue := p_schedFlag;
2066:
2067: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
2068: p_params => l_params,
2069: x_returnStatus => x_returnStatus);
2070: end if;
2071: --get the maximum date

Line 2129: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

2125: l_prevResIdx := i;
2126: end loop;
2127:
2128: if(l_logLevel <= wip_constants.trace_logging) then
2129: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
2130: p_procReturnStatus => x_returnStatus,
2131: p_msg => 'success',
2132: x_returnStatus => l_retStatus);
2133: end if;

Line 2138: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

2134: exception
2135: when fnd_api.g_exc_unexpected_error then
2136: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2137: if(l_logLevel <= wip_constants.trace_logging) then
2138: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
2139: p_procReturnStatus => x_returnStatus,
2140: p_msg => 'error',
2141: x_returnStatus => l_retStatus);
2142: end if;

Line 2145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

2141: x_returnStatus => l_retStatus);
2142: end if;
2143: when others then
2144: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2146: p_procedure_name => 'forwardSchedule',
2147: p_error_text => SQLERRM);
2148: if(l_logLevel <= wip_constants.trace_logging) then
2149: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

Line 2149: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

2145: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2146: p_procedure_name => 'forwardSchedule',
2147: p_error_text => SQLERRM);
2148: if(l_logLevel <= wip_constants.trace_logging) then
2149: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
2150: p_procReturnStatus => x_returnStatus,
2151: p_msg => 'unexp error: ' || SQLERRM,
2152: x_returnStatus => l_retStatus);
2153: end if;

Line 2186: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getEndDate',

2182: end if;
2183: l_params(6).paramName := 'p_prevIdx';
2184: l_params(6).paramValue := p_prevIdx;
2185:
2186: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getEndDate',
2187: p_params => l_params,
2188: x_returnStatus => l_retStatus);
2189: end if;
2190:

Line 2226: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getEndDate',

2222: l_minStartDate := p_resTbls.startDate(i);
2223: end if;
2224:
2225: if (l_logLevel <= wip_constants.trace_logging) then
2226: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getEndDate',
2227: p_procReturnStatus => to_char(l_minStartDate),
2228: p_msg => 'finished scheduling',
2229: x_returnStatus => l_retStatus);
2230: end if;

Line 2349: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',

2345: l_params(4).paramName := 'p_idx';
2346: l_params(4).paramValue := p_idx;
2347: l_params(5).paramName := 'p_repLineID';
2348: l_params(5).paramValue := p_repLineID;
2349: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2350: p_params => l_params,
2351: x_returnStatus => l_retStatus);
2352: end if;
2353: /* Fix for bug 5660475: If dealing with shift resource, first check if shifts are setup fine. */

Line 2609: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',

2605: l_prevProcTime := x_resTbls.usgCumMinProcTime(i);
2606: end loop;
2607:
2608: if(l_logLevel <= wip_constants.trace_logging) then
2609: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2610: p_procReturnStatus => null,
2611: p_msg => 'success',
2612: x_returnStatus => l_retStatus);
2613: end if;

Line 2618: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',

2614: exception
2615: when fnd_api.g_exc_unexpected_error then
2616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2617: if(l_logLevel <= wip_constants.trace_logging) then
2618: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2619: p_procReturnStatus => x_returnStatus,
2620: p_msg => 'error',
2621: x_returnStatus => l_retStatus);
2622: end if;

Line 2625: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

2621: x_returnStatus => l_retStatus);
2622: end if;
2623: when others then
2624: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2625: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2626: p_procedure_name => 'backwardSchResource',
2627: p_error_text => SQLERRM);
2628:
2629: if(l_logLevel <= wip_constants.trace_logging) then

Line 2630: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',

2626: p_procedure_name => 'backwardSchResource',
2627: p_error_text => SQLERRM);
2628:
2629: if(l_logLevel <= wip_constants.trace_logging) then
2630: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2631: p_procReturnStatus => x_returnStatus,
2632: p_msg => 'unexp error:' || SQLERRM,
2633: x_returnStatus => l_retStatus);
2634: end if;

Line 2664: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardScheduleBatch',

2660: l_params(5).paramValue := p_schedFlag;
2661: l_params(6).paramName := 'p_startIdx';
2662: l_params(6).paramValue := p_startIdx;
2663:
2664: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardScheduleBatch',
2665: p_params => l_params,
2666: x_returnStatus => x_returnStatus);
2667: end if;
2668:

Line 2700: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardScheduleBatch',

2696: x_resTbls => x_resTbls,
2697: x_returnStatus => x_returnStatus);
2698:
2699: if(l_logLevel <= wip_constants.trace_logging) then
2700: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardScheduleBatch',
2701: p_procReturnStatus => x_returnStatus,
2702: p_msg => 'success?',
2703: x_returnStatus => l_retStatus);
2704: end if;

Line 2744: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',

2740: l_params(5).paramValue := p_range(2);
2741: l_params(6).paramName := 'p_schedFlag';
2742: l_params(6).paramValue := p_schedFlag;
2743:
2744: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2745: p_params => l_params,
2746: x_returnStatus => x_returnStatus);
2747: end if;
2748: --get the maximum date

Line 2843: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',

2839: end if;
2840: end if;
2841:
2842: if(l_logLevel <= wip_constants.trace_logging) then
2843: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2844: p_procReturnStatus => x_returnStatus,
2845: p_msg => 'success',
2846: x_returnStatus => l_retStatus);
2847: end if;

Line 2853: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',

2849: exception
2850: when fnd_api.g_exc_unexpected_error then
2851: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2852: if(l_logLevel <= wip_constants.trace_logging) then
2853: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2854: p_procReturnStatus => x_returnStatus,
2855: p_msg => 'error',
2856: x_returnStatus => l_retStatus);
2857: end if;

Line 2860: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

2856: x_returnStatus => l_retStatus);
2857: end if;
2858: when others then
2859: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2860: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2861: p_procedure_name => 'backwardSchedule',
2862: p_error_text => SQLERRM);
2863:
2864: if(l_logLevel <= wip_constants.trace_logging) then

Line 2865: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',

2861: p_procedure_name => 'backwardSchedule',
2862: p_error_text => SQLERRM);
2863:
2864: if(l_logLevel <= wip_constants.trace_logging) then
2865: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2866: p_procReturnStatus => x_returnStatus,
2867: p_msg => 'unexp error:' || SQLERRM,
2868: x_returnStatus => l_retStatus);
2869: end if;

Line 2888: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',

2884: l_params(1).paramValue := p_orgID;
2885: l_params(2).paramName := 'p_repLineID';
2886: l_params(2).paramValue := p_repLineID;
2887:
2888: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2889: p_params => l_params,
2890: x_returnStatus => l_retStatus);
2891: end if;
2892:

Line 2911: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',

2907: end if;
2908: end loop;
2909:
2910: if(l_logLevel <= wip_constants.trace_logging) then
2911: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2912: p_procReturnStatus => x_returnStatus,
2913: p_msg => 'success',
2914: x_returnStatus => l_retStatus);
2915: end if;

Line 2920: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',

2916: exception
2917: when fnd_api.g_exc_unexpected_error then
2918: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2919: if(l_logLevel <= wip_constants.trace_logging) then
2920: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2921: p_procReturnStatus => x_returnStatus,
2922: p_msg => 'backward scheduling failed',
2923: x_returnStatus => l_retStatus);
2924: end if;

Line 2928: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',

2924: end if;
2925: when others then
2926: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2927: if(l_logLevel <= wip_constants.trace_logging) then
2928: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2929: p_procReturnStatus => x_returnStatus,
2930: p_msg => 'unexp error:' || SQLERRM,
2931: x_returnStatus => l_retStatus);
2932: end if;

Line 2951: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',

2947: l_params(1).paramValue := p_orgID;
2948: l_params(2).paramName := 'p_repLineID';
2949: l_params(2).paramValue := p_repLineID;
2950:
2951: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2952: p_params => l_params,
2953: x_returnStatus => l_retStatus);
2954: end if;
2955:

Line 2981: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',

2977: end if;
2978: end loop;
2979:
2980: if(l_logLevel <= wip_constants.trace_logging) then
2981: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2982: p_procReturnStatus => x_returnStatus,
2983: p_msg => 'success',
2984: x_returnStatus => l_retStatus);
2985: end if;

Line 2990: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',

2986: exception
2987: when fnd_api.g_exc_unexpected_error then
2988: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2989: if(l_logLevel <= wip_constants.trace_logging) then
2990: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2991: p_procReturnStatus => x_returnStatus,
2992: p_msg => 'backward scheduling failed',
2993: x_returnStatus => l_retStatus);
2994: end if;

Line 2997: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

2993: x_returnStatus => l_retStatus);
2994: end if;
2995: when others then
2996: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2997: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2998: p_procedure_name => 'scheduleNextResources',
2999: p_error_text => SQLERRM);
3000:
3001: if(l_logLevel <= wip_constants.trace_logging) then

Line 3002: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',

2998: p_procedure_name => 'scheduleNextResources',
2999: p_error_text => SQLERRM);
3000:
3001: if(l_logLevel <= wip_constants.trace_logging) then
3002: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
3003: p_procReturnStatus => x_returnStatus,
3004: p_msg => 'unexp error:' || SQLERRM,
3005: x_returnStatus => l_retStatus);
3006: end if;

Line 3035: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',

3031: l_params(2).paramName := 'p_repLineID';
3032: l_params(2).paramValue := p_repLineID;
3033: l_params(3).paramName := 'p_startDate';
3034: l_params(3).paramValue := to_char(p_startDate, g_logDateFmt);
3035: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
3036: p_params => l_params,
3037: x_returnStatus => x_returnStatus);
3038: end if;
3039: --this loop finds an exception

Line 3141: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',

3137: end if;
3138: end if;
3139:
3140: if(l_logLevel <= wip_constants.trace_logging) then
3141: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
3142: p_procReturnStatus => x_returnStatus,
3143: p_msg => 'success.',
3144: x_returnStatus => l_retStatus);
3145: end if;

Line 3150: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',

3146: exception
3147: when fnd_api.g_exc_unexpected_error then
3148: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3149: if(l_logLevel <= wip_constants.trace_logging) then
3150: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
3151: p_procReturnStatus => x_returnStatus,
3152: p_msg => 'errmsg: ' || l_errMsg,
3153: x_returnStatus => l_retStatus);
3154: end if;

Line 3157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

3153: x_returnStatus => l_retStatus);
3154: end if;
3155: when others then
3156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
3158: p_procedure_name => 'resolvePriorExceptions',
3159: p_error_text => SQLERRM);
3160:
3161: if(l_logLevel <= wip_constants.trace_logging) then

Line 3162: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',

3158: p_procedure_name => 'resolvePriorExceptions',
3159: p_error_text => SQLERRM);
3160:
3161: if(l_logLevel <= wip_constants.trace_logging) then
3162: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
3163: p_procReturnStatus => x_returnStatus,
3164: p_msg => 'unexp error:' || SQLERRM,
3165: x_returnStatus => l_retStatus);
3166: end if;

Line 3194: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',

3190: l_params(2).paramName := 'p_repLineID';
3191: l_params(2).paramValue := p_repLineID;
3192: l_params(3).paramName := 'p_endDate';
3193: l_params(3).paramValue := to_char(p_endDate, g_logDateFmt);
3194: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
3195: p_params => l_params,
3196: x_returnStatus => x_returnStatus);
3197: end if;
3198: --this loop finds an exception

Line 3305: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',

3301: end if;
3302: end if;
3303:
3304: if(l_logLevel <= wip_constants.trace_logging) then
3305: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
3306: p_procReturnStatus => x_returnStatus,
3307: p_msg => 'success.',
3308: x_returnStatus => l_retStatus);
3309: end if;

Line 3314: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',

3310: exception
3311: when fnd_api.g_exc_unexpected_error then
3312: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3313: if(l_logLevel <= wip_constants.trace_logging) then
3314: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
3315: p_procReturnStatus => x_returnStatus,
3316: p_msg => l_errMsg,
3317: x_returnStatus => l_retStatus);
3318: end if;

Line 3321: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

3317: x_returnStatus => l_retStatus);
3318: end if;
3319: when others then
3320: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3321: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
3322: p_procedure_name => 'resolveNextExceptions',
3323: p_error_text => SQLERRM);
3324:
3325: if(l_logLevel <= wip_constants.trace_logging) then

Line 3326: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',

3322: p_procedure_name => 'resolveNextExceptions',
3323: p_error_text => SQLERRM);
3324:
3325: if(l_logLevel <= wip_constants.trace_logging) then
3326: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
3327: p_procReturnStatus => x_returnStatus,
3328: p_msg => 'unexp error:' || SQLERRM,
3329: x_returnStatus => l_retStatus);
3330: end if;

Line 3344: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.dumpResources',

3340: l_resCode VARCHAR2(10);
3341: begin
3342:
3343: if (l_logLevel <= wip_constants.trace_logging) then
3344: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.dumpResources',
3345: p_params => l_params,
3346: x_returnStatus => l_retStatus);
3347: end if;
3348:

Line 3351: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',

3347: end if;
3348:
3349: if(p_resTbls.resID is null or p_resTbls.resID.count < 1 and
3350: l_logLevel <= wip_constants.trace_logging) then
3351: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
3352: p_procReturnStatus => null,
3353: p_msg => 'no resources in table!',
3354: x_returnStatus => l_retStatus);
3355: return;

Line 3386: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',

3382: end if;
3383: end loop;
3384: end if;
3385: if (l_logLevel <= wip_constants.trace_logging) then
3386: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
3387: p_procReturnStatus => null,
3388: p_msg => 'success',
3389: x_returnStatus => l_retStatus);
3390: end if;

Line 3395: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',

3391:
3392: exception
3393: when others then
3394: if (l_logLevel <= wip_constants.trace_logging) then
3395: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
3396: p_procReturnStatus => null,
3397: p_msg => 'exception:' || SQLERRM,
3398: x_returnStatus => l_retStatus);
3399: end if;

Line 3420: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',

3416: begin
3417: if(l_logLevel <= wip_constants.trace_logging) then
3418: l_params(1).paramName := 'p_anchorDate';
3419: l_params(1).paramValue := to_char(p_anchorDate, g_logDateFmt);
3420: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
3421: p_params => l_params,
3422: x_returnStatus => l_retStatus);
3423: end if;
3424: x_returnStatus := fnd_api.g_ret_sts_success;

Line 3481: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',

3477:
3478: x_resTbls.endDate(i) := x_resTbls.startDate(i);
3479: end loop;
3480: if(l_logLevel <= wip_constants.trace_logging) then
3481: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
3482: p_procReturnStatus => x_returnStatus,
3483: p_msg => 'success',
3484: x_returnStatus => l_retStatus);
3485: end if;

Line 3490: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',

3486: exception
3487: when others then
3488: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
3489: if(l_logLevel <= wip_constants.trace_logging) then
3490: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
3491: p_procReturnStatus => x_returnStatus,
3492: p_msg => 'error: ' || SQLERRM,
3493: x_returnStatus => l_retStatus);
3494: end if;

Line 3495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',

3491: p_procReturnStatus => x_returnStatus,
3492: p_msg => 'error: ' || SQLERRM,
3493: x_returnStatus => l_retStatus);
3494: end if;
3495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
3496: p_procedure_name => 'scheduleNoResources',
3497: p_error_text => SQLERRM);
3498: end scheduleNoResources;
3499: end wip_infResSched_grp;

Line 3499: end wip_infResSched_grp;

3495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
3496: p_procedure_name => 'scheduleNoResources',
3497: p_error_text => SQLERRM);
3498: end scheduleNoResources;
3499: end wip_infResSched_grp;