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.2.12010000.2 2008/09/10 00:33:10 ntangjee ship $ */
3:
4: --package constants
5: g_dateCursorLen CONSTANT NUMBER := 10;--must be greater than or equal to 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

749:
750:
751:
752: if(l_logLevel <= wip_constants.trace_logging) then
753: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
754: p_procReturnStatus => x_returnStatus,
755: p_msg => 'success',
756: x_returnStatus => l_retStatus);
757: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

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

764: if(l_logLevel <= wip_constants.trace_logging) then
765: wip_utilities.get_message_stack(p_msg => l_errMsg,
766: p_delete_stack => fnd_api.g_false);
767:
768: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
769: p_procReturnStatus => x_returnStatus,
770: p_msg => 'failure: ' || l_errMsg,
771: x_returnStatus => l_retStatus);
772: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

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

774: end if;
775: end if;
776: when others then
777: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
778: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
779: p_procedure_name => 'schedule',
780: p_error_text => SQLERRM);
781: if(l_logLevel <= wip_constants.trace_logging) then
782: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',

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

778: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
779: p_procedure_name => 'schedule',
780: p_error_text => SQLERRM);
781: if(l_logLevel <= wip_constants.trace_logging) then
782: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedule',
783: p_procReturnStatus => x_returnStatus,
784: p_msg => 'unexpected error: ' || SQLERRM,
785: x_returnStatus => l_retStatus);
786: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

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

848: end if;
849: l_params(6).paramName := 'p_prevIdx';
850: l_params(6).paramValue := p_prevIdx;
851:
852: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getStartDate',
853: p_params => l_params,
854: x_returnStatus => l_retStatus);
855: end if;
856:

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

888: l_maxEndDate := p_resTbls.endDate(i);
889: end if;
890:
891: if (l_logLevel <= wip_constants.trace_logging) then
892: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getStartDate',
893: p_procReturnStatus => to_char(l_maxEndDate),
894: p_msg => 'finished scheduling',
895: x_returnStatus => l_retStatus);
896: end if;

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

999: l_params(4).paramName := 'p_idx';
1000: l_params(4).paramValue := p_idx;
1001: l_params(5).paramName := 'p_repLineID';
1002: l_params(5).paramValue := p_repLineID;
1003: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1004: p_params => l_params,
1005: x_returnStatus => l_retStatus);
1006: end if;
1007: x_returnStatus := fnd_api.g_ret_sts_success;

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

1270: end if;
1271: end if;
1272: end loop;
1273: if(l_logLevel <= wip_constants.trace_logging) then
1274: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1275: p_procReturnStatus => x_returnStatus,
1276: p_msg => 'success',
1277: x_returnStatus => l_retStatus);
1278: end if;

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

1279: exception
1280: when fnd_api.g_exc_unexpected_error then
1281: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1282: if(l_logLevel <= wip_constants.trace_logging) then
1283: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1284: p_procReturnStatus => x_returnStatus,
1285: p_msg => 'error',
1286: x_returnStatus => l_retStatus);
1287: end if;

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

1286: x_returnStatus => l_retStatus);
1287: end if;
1288: when others then
1289: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1290: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1291: p_procedure_name => 'forwardSchResource',
1292: p_error_text => SQLERRM);
1293: if(l_logLevel <= wip_constants.trace_logging) then
1294: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',

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

1290: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1291: p_procedure_name => 'forwardSchResource',
1292: p_error_text => SQLERRM);
1293: if(l_logLevel <= wip_constants.trace_logging) then
1294: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchResource',
1295: p_procReturnStatus => x_returnStatus,
1296: p_msg => 'unexp error: ' || SQLERRM,
1297: x_returnStatus => l_retStatus);
1298: end if;

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

1298: end if;
1299:
1300: end forwardSchResource;
1301:
1302: /* fix bug 7027946: Added procedure wip_infResSched_grp.capacityExceptions to handle resource capacity exceptions.
1303: It will change the resource shifts (add day, delete day, modify shift times) as per capacity
1304: exceptions.
1305: */
1306: procedure capacityExceptions(p_resID IN NUMBER,

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

1360: l_params(2).paramValue := p_deptID;
1361: l_params(3).paramName := 'p_orgID';
1362: l_params(3).paramValue := p_orgID;
1363:
1364: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
1365: p_params => l_params,
1366: x_returnStatus => x_returnStatus);
1367: end if;
1368:

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

1451: END IF;
1452: END LOOP; -- end outer loop
1453:
1454: IF(l_logLevel <= wip_constants.trace_logging) then
1455: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
1456: p_procReturnStatus => x_returnStatus,
1457: p_msg => 'success',
1458: x_returnStatus => l_retStatus);
1459: END IF;

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

1460: EXCEPTION
1461: WHEN fnd_api.g_exc_unexpected_error THEN
1462: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1463: if(l_logLevel <= wip_constants.trace_logging) then
1464: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
1465: p_procReturnStatus => x_returnStatus,
1466: p_msg => 'error',
1467: x_returnStatus => l_retStatus);
1468: end if;

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

1467: x_returnStatus => l_retStatus);
1468: end if;
1469: WHEN others THEN
1470: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1471: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1472: p_procedure_name => 'capacityExceptions',
1473: p_error_text => SQLERRM);
1474: if(l_logLevel <= wip_constants.trace_logging) then
1475: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',

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

1471: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1472: p_procedure_name => 'capacityExceptions',
1473: p_error_text => SQLERRM);
1474: if(l_logLevel <= wip_constants.trace_logging) then
1475: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.capacityExceptions',
1476: p_procReturnStatus => x_returnStatus,
1477: p_msg => 'unexp error: ' || SQLERRM,
1478: x_returnStatus => l_retStatus);
1479: end if;

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

1511: l_params(4).paramValue := p_range(2);
1512: l_params(5).paramName := 'p_schedFlag';
1513: l_params(5).paramValue := p_schedFlag;
1514:
1515: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
1516: p_params => l_params,
1517: x_returnStatus => x_returnStatus);
1518: end if;
1519: --get the maximum date

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

1573: l_prevResIdx := i;
1574: end loop;
1575:
1576: if(l_logLevel <= wip_constants.trace_logging) then
1577: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
1578: p_procReturnStatus => x_returnStatus,
1579: p_msg => 'success',
1580: x_returnStatus => l_retStatus);
1581: end if;

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

1582: exception
1583: when fnd_api.g_exc_unexpected_error then
1584: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1585: if(l_logLevel <= wip_constants.trace_logging) then
1586: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
1587: p_procReturnStatus => x_returnStatus,
1588: p_msg => 'error',
1589: x_returnStatus => l_retStatus);
1590: end if;

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

1589: x_returnStatus => l_retStatus);
1590: end if;
1591: when others then
1592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1593: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1594: p_procedure_name => 'forwardSchedule',
1595: p_error_text => SQLERRM);
1596: if(l_logLevel <= wip_constants.trace_logging) then
1597: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',

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

1593: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
1594: p_procedure_name => 'forwardSchedule',
1595: p_error_text => SQLERRM);
1596: if(l_logLevel <= wip_constants.trace_logging) then
1597: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.forwardSchedule',
1598: p_procReturnStatus => x_returnStatus,
1599: p_msg => 'unexp error: ' || SQLERRM,
1600: x_returnStatus => l_retStatus);
1601: end if;

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

1630: end if;
1631: l_params(6).paramName := 'p_prevIdx';
1632: l_params(6).paramValue := p_prevIdx;
1633:
1634: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.getEndDate',
1635: p_params => l_params,
1636: x_returnStatus => l_retStatus);
1637: end if;
1638:

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

1670: l_minStartDate := p_resTbls.startDate(i);
1671: end if;
1672:
1673: if (l_logLevel <= wip_constants.trace_logging) then
1674: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.getEndDate',
1675: p_procReturnStatus => to_char(l_minStartDate),
1676: p_msg => 'finished scheduling',
1677: x_returnStatus => l_retStatus);
1678: end if;

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

1785: l_params(4).paramName := 'p_idx';
1786: l_params(4).paramValue := p_idx;
1787: l_params(5).paramName := 'p_repLineID';
1788: l_params(5).paramValue := p_repLineID;
1789: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
1790: p_params => l_params,
1791: x_returnStatus => l_retStatus);
1792: end if;
1793: /* Fix for bug 5660475: If dealing with shift resource, first check if shifts are setup fine. */

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

2034: l_prevProcTime := x_resTbls.usgCumMinProcTime(i);
2035: end loop;
2036:
2037: if(l_logLevel <= wip_constants.trace_logging) then
2038: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2039: p_procReturnStatus => null,
2040: p_msg => 'success',
2041: x_returnStatus => l_retStatus);
2042: end if;

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

2043: exception
2044: when fnd_api.g_exc_unexpected_error then
2045: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2046: if(l_logLevel <= wip_constants.trace_logging) then
2047: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2048: p_procReturnStatus => x_returnStatus,
2049: p_msg => 'error',
2050: x_returnStatus => l_retStatus);
2051: end if;

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

2050: x_returnStatus => l_retStatus);
2051: end if;
2052: when others then
2053: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2054: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2055: p_procedure_name => 'backwardSchResource',
2056: p_error_text => SQLERRM);
2057:
2058: if(l_logLevel <= wip_constants.trace_logging) then

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

2055: p_procedure_name => 'backwardSchResource',
2056: p_error_text => SQLERRM);
2057:
2058: if(l_logLevel <= wip_constants.trace_logging) then
2059: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchResource',
2060: p_procReturnStatus => x_returnStatus,
2061: p_msg => 'unexp error:' || SQLERRM,
2062: x_returnStatus => l_retStatus);
2063: end if;

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

2089: l_params(5).paramValue := p_schedFlag;
2090: l_params(6).paramName := 'p_startIdx';
2091: l_params(6).paramValue := p_startIdx;
2092:
2093: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.forwardScheduleBatch',
2094: p_params => l_params,
2095: x_returnStatus => x_returnStatus);
2096: end if;
2097:

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

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

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

2169: l_params(5).paramValue := p_range(2);
2170: l_params(6).paramName := 'p_schedFlag';
2171: l_params(6).paramValue := p_schedFlag;
2172:
2173: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2174: p_params => l_params,
2175: x_returnStatus => x_returnStatus);
2176: end if;
2177: --get the maximum date

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

2268: end if;
2269: end if;
2270:
2271: if(l_logLevel <= wip_constants.trace_logging) then
2272: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2273: p_procReturnStatus => x_returnStatus,
2274: p_msg => 'success',
2275: x_returnStatus => l_retStatus);
2276: end if;

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

2278: exception
2279: when fnd_api.g_exc_unexpected_error then
2280: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2281: if(l_logLevel <= wip_constants.trace_logging) then
2282: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2283: p_procReturnStatus => x_returnStatus,
2284: p_msg => 'error',
2285: x_returnStatus => l_retStatus);
2286: end if;

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

2285: x_returnStatus => l_retStatus);
2286: end if;
2287: when others then
2288: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2289: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2290: p_procedure_name => 'backwardSchedule',
2291: p_error_text => SQLERRM);
2292:
2293: if(l_logLevel <= wip_constants.trace_logging) then

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

2290: p_procedure_name => 'backwardSchedule',
2291: p_error_text => SQLERRM);
2292:
2293: if(l_logLevel <= wip_constants.trace_logging) then
2294: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.backwardSchedule',
2295: p_procReturnStatus => x_returnStatus,
2296: p_msg => 'unexp error:' || SQLERRM,
2297: x_returnStatus => l_retStatus);
2298: end if;

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

2313: l_params(1).paramValue := p_orgID;
2314: l_params(2).paramName := 'p_repLineID';
2315: l_params(2).paramValue := p_repLineID;
2316:
2317: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2318: p_params => l_params,
2319: x_returnStatus => l_retStatus);
2320: end if;
2321:

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

2336: end if;
2337: end loop;
2338:
2339: if(l_logLevel <= wip_constants.trace_logging) then
2340: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2341: p_procReturnStatus => x_returnStatus,
2342: p_msg => 'success',
2343: x_returnStatus => l_retStatus);
2344: end if;

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

2345: exception
2346: when fnd_api.g_exc_unexpected_error then
2347: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2348: if(l_logLevel <= wip_constants.trace_logging) then
2349: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2350: p_procReturnStatus => x_returnStatus,
2351: p_msg => 'backward scheduling failed',
2352: x_returnStatus => l_retStatus);
2353: end if;

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

2353: end if;
2354: when others then
2355: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2356: if(l_logLevel <= wip_constants.trace_logging) then
2357: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.schedulePriorResources',
2358: p_procReturnStatus => x_returnStatus,
2359: p_msg => 'unexp error:' || SQLERRM,
2360: x_returnStatus => l_retStatus);
2361: end if;

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

2376: l_params(1).paramValue := p_orgID;
2377: l_params(2).paramName := 'p_repLineID';
2378: l_params(2).paramValue := p_repLineID;
2379:
2380: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2381: p_params => l_params,
2382: x_returnStatus => l_retStatus);
2383: end if;
2384:

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

2399: end if;
2400: end loop;
2401:
2402: if(l_logLevel <= wip_constants.trace_logging) then
2403: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2404: p_procReturnStatus => x_returnStatus,
2405: p_msg => 'success',
2406: x_returnStatus => l_retStatus);
2407: end if;

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

2408: exception
2409: when fnd_api.g_exc_unexpected_error then
2410: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2411: if(l_logLevel <= wip_constants.trace_logging) then
2412: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2413: p_procReturnStatus => x_returnStatus,
2414: p_msg => 'backward scheduling failed',
2415: x_returnStatus => l_retStatus);
2416: end if;

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

2415: x_returnStatus => l_retStatus);
2416: end if;
2417: when others then
2418: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2420: p_procedure_name => 'scheduleNextResources',
2421: p_error_text => SQLERRM);
2422:
2423: if(l_logLevel <= wip_constants.trace_logging) then

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

2420: p_procedure_name => 'scheduleNextResources',
2421: p_error_text => SQLERRM);
2422:
2423: if(l_logLevel <= wip_constants.trace_logging) then
2424: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNextResources',
2425: p_procReturnStatus => x_returnStatus,
2426: p_msg => 'unexp error:' || SQLERRM,
2427: x_returnStatus => l_retStatus);
2428: end if;

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

2453: l_params(2).paramName := 'p_repLineID';
2454: l_params(2).paramValue := p_repLineID;
2455: l_params(3).paramName := 'p_startDate';
2456: l_params(3).paramValue := to_char(p_startDate, g_logDateFmt);
2457: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
2458: p_params => l_params,
2459: x_returnStatus => x_returnStatus);
2460: end if;
2461: --this loop finds an exception

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

2559: end if;
2560: end if;
2561:
2562: if(l_logLevel <= wip_constants.trace_logging) then
2563: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
2564: p_procReturnStatus => x_returnStatus,
2565: p_msg => 'success.',
2566: x_returnStatus => l_retStatus);
2567: end if;

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

2568: exception
2569: when fnd_api.g_exc_unexpected_error then
2570: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2571: if(l_logLevel <= wip_constants.trace_logging) then
2572: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
2573: p_procReturnStatus => x_returnStatus,
2574: p_msg => 'errmsg: ' || l_errMsg,
2575: x_returnStatus => l_retStatus);
2576: end if;

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

2575: x_returnStatus => l_retStatus);
2576: end if;
2577: when others then
2578: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2579: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2580: p_procedure_name => 'resolvePriorExceptions',
2581: p_error_text => SQLERRM);
2582:
2583: if(l_logLevel <= wip_constants.trace_logging) then

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

2580: p_procedure_name => 'resolvePriorExceptions',
2581: p_error_text => SQLERRM);
2582:
2583: if(l_logLevel <= wip_constants.trace_logging) then
2584: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolvePriorExceptions',
2585: p_procReturnStatus => x_returnStatus,
2586: p_msg => 'unexp error:' || SQLERRM,
2587: x_returnStatus => l_retStatus);
2588: end if;

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

2612: l_params(2).paramName := 'p_repLineID';
2613: l_params(2).paramValue := p_repLineID;
2614: l_params(3).paramName := 'p_endDate';
2615: l_params(3).paramValue := to_char(p_endDate, g_logDateFmt);
2616: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
2617: p_params => l_params,
2618: x_returnStatus => x_returnStatus);
2619: end if;
2620: --this loop finds an exception

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

2723: end if;
2724: end if;
2725:
2726: if(l_logLevel <= wip_constants.trace_logging) then
2727: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
2728: p_procReturnStatus => x_returnStatus,
2729: p_msg => 'success.',
2730: x_returnStatus => l_retStatus);
2731: end if;

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

2732: exception
2733: when fnd_api.g_exc_unexpected_error then
2734: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2735: if(l_logLevel <= wip_constants.trace_logging) then
2736: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
2737: p_procReturnStatus => x_returnStatus,
2738: p_msg => l_errMsg,
2739: x_returnStatus => l_retStatus);
2740: end if;

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

2739: x_returnStatus => l_retStatus);
2740: end if;
2741: when others then
2742: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2743: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2744: p_procedure_name => 'resolveNextExceptions',
2745: p_error_text => SQLERRM);
2746:
2747: if(l_logLevel <= wip_constants.trace_logging) then

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

2744: p_procedure_name => 'resolveNextExceptions',
2745: p_error_text => SQLERRM);
2746:
2747: if(l_logLevel <= wip_constants.trace_logging) then
2748: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.resolveNextExceptions',
2749: p_procReturnStatus => x_returnStatus,
2750: p_msg => 'unexp error:' || SQLERRM,
2751: x_returnStatus => l_retStatus);
2752: end if;

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

2762: l_resCode VARCHAR2(10);
2763: begin
2764:
2765: if (l_logLevel <= wip_constants.trace_logging) then
2766: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.dumpResources',
2767: p_params => l_params,
2768: x_returnStatus => l_retStatus);
2769: end if;
2770:

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

2769: end if;
2770:
2771: if(p_resTbls.resID is null or p_resTbls.resID.count < 1 and
2772: l_logLevel <= wip_constants.trace_logging) then
2773: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
2774: p_procReturnStatus => null,
2775: p_msg => 'no resources in table!',
2776: x_returnStatus => l_retStatus);
2777: return;

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

2804: end if;
2805: end loop;
2806: end if;
2807: if (l_logLevel <= wip_constants.trace_logging) then
2808: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
2809: p_procReturnStatus => null,
2810: p_msg => 'success',
2811: x_returnStatus => l_retStatus);
2812: end if;

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

2813:
2814: exception
2815: when others then
2816: if (l_logLevel <= wip_constants.trace_logging) then
2817: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.dumpResources',
2818: p_procReturnStatus => null,
2819: p_msg => 'exception:' || SQLERRM,
2820: x_returnStatus => l_retStatus);
2821: end if;

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

2835: begin
2836: if(l_logLevel <= wip_constants.trace_logging) then
2837: l_params(1).paramName := 'p_anchorDate';
2838: l_params(1).paramValue := to_char(p_anchorDate, g_logDateFmt);
2839: wip_logger.entryPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
2840: p_params => l_params,
2841: x_returnStatus => l_retStatus);
2842: end if;
2843: x_returnStatus := fnd_api.g_ret_sts_success;

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

2877:
2878: x_resTbls.endDate(i) := x_resTbls.startDate(i);
2879: end loop;
2880: if(l_logLevel <= wip_constants.trace_logging) then
2881: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
2882: p_procReturnStatus => x_returnStatus,
2883: p_msg => 'success',
2884: x_returnStatus => l_retStatus);
2885: end if;

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

2886: exception
2887: when others then
2888: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2889: if(l_logLevel <= wip_constants.trace_logging) then
2890: wip_logger.exitPoint(p_procName => 'wip_infResSched_grp.scheduleNoResources',
2891: p_procReturnStatus => x_returnStatus,
2892: p_msg => 'error: ' || SQLERRM,
2893: x_returnStatus => l_retStatus);
2894: end if;

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

2891: p_procReturnStatus => x_returnStatus,
2892: p_msg => 'error: ' || SQLERRM,
2893: x_returnStatus => l_retStatus);
2894: end if;
2895: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2896: p_procedure_name => 'scheduleNoResources',
2897: p_error_text => SQLERRM);
2898: end scheduleNoResources;
2899: end wip_infResSched_grp;

Line 2899: end wip_infResSched_grp;

2895: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_infResSched_grp',
2896: p_procedure_name => 'scheduleNoResources',
2897: p_error_text => SQLERRM);
2898: end scheduleNoResources;
2899: end wip_infResSched_grp;