APPS.WIP_INFRESSCHED_GRP dependencies on FND_API

Line 551: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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;
553: end if;
554: end if;
555: x_returnStatus := fnd_api.g_ret_sts_success;

Line 552: raise fnd_api.g_exc_unexpected_error;

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;
553: end if;
554: end if;
555: x_returnStatus := fnd_api.g_ret_sts_success;
556:

Line 555: x_returnStatus := fnd_api.g_ret_sts_success;

551: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
552: raise fnd_api.g_exc_unexpected_error;
553: end if;
554: end if;
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',

Line 659: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

655: p_schedFlag => wip_constants.sched_yes,
656: x_resTbls => x_resTbls,
657: x_returnStatus => x_returnStatus);
658:
659: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
660: wip_logger.log('fwdSch failed', l_retStatus);
661: raise fnd_api.g_exc_unexpected_error;
662: end if;
663:

Line 661: raise fnd_api.g_exc_unexpected_error;

657: x_returnStatus => x_returnStatus);
658:
659: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
660: wip_logger.log('fwdSch failed', l_retStatus);
661: raise fnd_api.g_exc_unexpected_error;
662: end if;
663:
664: if(l_logLevel <= wip_constants.full_logging) then
665: dumpResources(x_resTbls);

Line 681: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

677: p_range => l_range,
678: p_schedFlag => wip_constants.sched_yes,
679: x_resTbls => x_resTbls,
680: x_returnStatus => x_returnStatus);
681: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
682: wip_logger.log('bkwdSch failed', l_retStatus);
683: raise fnd_api.g_exc_unexpected_error;
684: end if;
685: end if;

Line 683: raise fnd_api.g_exc_unexpected_error;

679: x_resTbls => x_resTbls,
680: x_returnStatus => x_returnStatus);
681: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
682: wip_logger.log('bkwdSch failed', l_retStatus);
683: raise fnd_api.g_exc_unexpected_error;
684: end if;
685: end if;
686:
687: --build the operation structure

Line 699: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

695: p_opTbl => l_opTbl,
696: x_resTbls => x_resTbls,
697: x_returnStatus => x_returnStatus);
698:
699: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
700: wip_logger.log('schPriorRes failed', l_retStatus);
701: raise fnd_api.g_exc_unexpected_error;
702: end if;
703:

Line 701: raise fnd_api.g_exc_unexpected_error;

697: x_returnStatus => x_returnStatus);
698:
699: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
700: wip_logger.log('schPriorRes failed', l_retStatus);
701: raise fnd_api.g_exc_unexpected_error;
702: end if;
703:
704:
705: scheduleNextResources(p_orgID => p_orgID,

Line 711: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

707: p_opTbl => l_opTbl,
708: x_resTbls => x_resTbls,
709: x_returnStatus => x_returnStatus);
710:
711: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
712: wip_logger.log('schNextRes failed', l_retStatus);
713: raise fnd_api.g_exc_unexpected_error;
714: end if;
715:

Line 713: raise fnd_api.g_exc_unexpected_error;

709: x_returnStatus => x_returnStatus);
710:
711: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
712: wip_logger.log('schNextRes failed', l_retStatus);
713: raise fnd_api.g_exc_unexpected_error;
714: end if;
715:
716: if(l_logLevel <= wip_constants.full_logging) then
717: dumpResources(x_resTbls);

Line 727: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

723: p_repLineID => p_repLineID,
724: p_startDate => p_startDate,
725: x_resTbls => x_resTbls,
726: x_returnStatus => x_returnStatus);
727: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
728: wip_logger.log('resolvePriorRes failed', l_retStatus);
729: raise fnd_api.g_exc_unexpected_error;
730: end if;
731: --if backward scheduling

Line 729: raise fnd_api.g_exc_unexpected_error;

725: x_resTbls => x_resTbls,
726: x_returnStatus => x_returnStatus);
727: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
728: wip_logger.log('resolvePriorRes failed', l_retStatus);
729: raise fnd_api.g_exc_unexpected_error;
730: end if;
731: --if backward scheduling
732: elsif(p_opSeqNum is null and p_endDate is not null) then
733: resolveNextExceptions(p_orgID => p_orgID,

Line 738: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

734: p_repLineID => p_repLineID,
735: p_endDate => p_endDate,
736: x_resTbls => x_resTbls,
737: x_returnStatus => x_returnStatus);
738: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
739: wip_logger.log('resolveNextRes failed', l_retStatus);
740: raise fnd_api.g_exc_unexpected_error;
741: end if;
742: end if;

Line 740: raise fnd_api.g_exc_unexpected_error;

736: x_resTbls => x_resTbls,
737: x_returnStatus => x_returnStatus);
738: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
739: wip_logger.log('resolveNextRes failed', l_retStatus);
740: raise fnd_api.g_exc_unexpected_error;
741: end if;
742: end if;
743:
744:

Line 757: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) 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
758: wip_logger.cleanup(l_retStatus);
759: end if;
760: end if;
761: exception

Line 762: when fnd_api.g_exc_unexpected_error then

758: wip_logger.cleanup(l_retStatus);
759: end if;
760: end if;
761: exception
762: when fnd_api.g_exc_unexpected_error then
763: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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);

Line 763: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

759: end if;
760: end if;
761: exception
762: when fnd_api.g_exc_unexpected_error then
763: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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:

Line 766: p_delete_stack => fnd_api.g_false);

762: when fnd_api.g_exc_unexpected_error then
763: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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,

Line 772: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) then

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
773: wip_logger.cleanup(l_retStatus);
774: end if;
775: end if;
776: when others then

Line 777: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

773: wip_logger.cleanup(l_retStatus);
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

Line 786: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) 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
787: wip_logger.cleanup(l_retStatus);
788: end if;
789: end if;
790: end schedule;

Line 1007: x_returnStatus := fnd_api.g_ret_sts_success;

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;
1008:
1009: /* Fix for bug 5660475: If dealing with shift resource, first check if shifts are setup fine. */
1010: if( p_repLineID is null
1011: and x_resTbls.avail24Flag(p_idx) = wip_constants.no

Line 1042: raise fnd_api.g_exc_unexpected_error;

1038: fnd_message.set_name('WIP', 'WIP_SHIFT_RESOURCE');
1039: fnd_message.set_token('ENTITY1', x_resTbls.resSeqNum(p_idx));
1040: fnd_message.set_token('ENTITY2', x_resTbls.opSeqNum(p_idx));
1041: fnd_msg_pub.add;
1042: raise fnd_api.g_exc_unexpected_error;
1043: end;
1044: end if;
1045:
1046: x_resTbls.usgStartIdx(p_idx) := null;

Line 1269: raise fnd_api.g_exc_unexpected_error;

1265: wip_logger.log('exhausted calendar. remaining usage(HRS) is ' || round(l_remUsage*24, g_precision), l_retStatus);
1266: end if;
1267: fnd_message.set_name('WIP', 'WIP_NO_CALENDAR');
1268: fnd_msg_pub.add;
1269: raise fnd_api.g_exc_unexpected_error;
1270: end if;
1271: end if;
1272: end loop;
1273: if(l_logLevel <= wip_constants.trace_logging) then

Line 1280: when fnd_api.g_exc_unexpected_error then

1276: p_msg => 'success',
1277: x_returnStatus => l_retStatus);
1278: end if;
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,

Line 1281: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1277: x_returnStatus => l_retStatus);
1278: end if;
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',

Line 1289: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1285: p_msg => 'error',
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

Line 1461: WHEN fnd_api.g_exc_unexpected_error THEN

1457: p_msg => 'success',
1458: x_returnStatus => l_retStatus);
1459: END IF;
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,

Line 1462: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1458: x_returnStatus => l_retStatus);
1459: END IF;
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',

Line 1470: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1466: p_msg => 'error',
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

Line 1569: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

1565: l_resStartDate := getStartDate(p_range, p_schedFlag, x_resTbls, i, l_doneSchedBatch, l_prevResIdx);
1566: end if;
1567:
1568: forwardSchResource(p_orgID, l_resStartDate, l_maxDate, i, p_repLineID, x_resTbls, x_returnStatus);
1569: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1570: raise fnd_api.g_exc_unexpected_error;
1571: end if;
1572:
1573: l_prevResIdx := i;

Line 1570: raise fnd_api.g_exc_unexpected_error;

1566: end if;
1567:
1568: forwardSchResource(p_orgID, l_resStartDate, l_maxDate, i, p_repLineID, x_resTbls, x_returnStatus);
1569: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1570: raise fnd_api.g_exc_unexpected_error;
1571: end if;
1572:
1573: l_prevResIdx := i;
1574: end loop;

Line 1583: when fnd_api.g_exc_unexpected_error then

1579: p_msg => 'success',
1580: x_returnStatus => l_retStatus);
1581: end if;
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,

Line 1584: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1580: x_returnStatus => l_retStatus);
1581: end if;
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',

Line 1592: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1588: p_msg => 'error',
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

Line 1826: raise fnd_api.g_exc_unexpected_error;

1822: fnd_message.set_name('WIP', 'WIP_SHIFT_RESOURCE');
1823: fnd_message.set_token('ENTITY1', x_resTbls.resSeqNum(p_idx));
1824: fnd_message.set_token('ENTITY2', x_resTbls.opSeqNum(p_idx));
1825: fnd_msg_pub.add;
1826: raise fnd_api.g_exc_unexpected_error;
1827: end;
1828: end if;
1829:
1830: x_resTbls.usgStartIdx(p_idx) := null;

Line 2010: raise fnd_api.g_exc_unexpected_error;

2006: wip_logger.log('exhausted calendar. remaining usage(HRS) is ' || round(l_remUsage*24, g_precision), l_retStatus);
2007: end if;
2008: fnd_message.set_name('WIP', 'WIP_NO_CALENDAR');
2009: fnd_msg_pub.add;
2010: raise fnd_api.g_exc_unexpected_error;
2011: end if;
2012: end if;
2013: end loop;
2014:

Line 2044: when fnd_api.g_exc_unexpected_error then

2040: p_msg => 'success',
2041: x_returnStatus => l_retStatus);
2042: end if;
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,

Line 2045: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2041: x_returnStatus => l_retStatus);
2042: end if;
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',

Line 2053: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2049: p_msg => 'error',
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:

Line 2225: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2221: p_schedFlag => p_schedFlag,
2222: p_startIdx => l_prevResIdx,
2223: x_resTbls => x_resTbls,
2224: x_returnStatus => x_returnStatus);
2225: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2226: if(l_logLevel <= wip_constants.full_logging) then
2227: wip_logger.log('simult batch scheduling failed', l_retStatus);
2228: end if;
2229: raise fnd_api.g_exc_unexpected_error;

Line 2229: raise fnd_api.g_exc_unexpected_error;

2225: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2226: if(l_logLevel <= wip_constants.full_logging) then
2227: wip_logger.log('simult batch scheduling failed', l_retStatus);
2228: end if;
2229: raise fnd_api.g_exc_unexpected_error;
2230: end if;
2231: end if;
2232:
2233: if(l_prevResIdx is null) then

Line 2242: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2238: l_resEndDate := getEndDate(p_range, p_schedFlag, x_resTbls, i, l_doneSchedBatch, l_prevResIdx);
2239: end if;
2240:
2241: backwardSchResource(p_orgID, l_resEndDate, l_minDate, i, p_repLineID, x_resTbls, x_returnStatus);
2242: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2243: if(l_logLevel <= wip_constants.full_logging) then
2244: wip_logger.log('backward schedule failed', l_retStatus);
2245: end if;
2246: raise fnd_api.g_exc_unexpected_error;

Line 2246: raise fnd_api.g_exc_unexpected_error;

2242: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2243: if(l_logLevel <= wip_constants.full_logging) then
2244: wip_logger.log('backward schedule failed', l_retStatus);
2245: end if;
2246: raise fnd_api.g_exc_unexpected_error;
2247: end if;
2248:
2249: l_prevResIdx := i;
2250: end loop;

Line 2263: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2259: p_schedFlag => p_schedFlag,
2260: p_startIdx => l_prevResIdx,
2261: x_resTbls => x_resTbls,
2262: x_returnStatus => x_returnStatus);
2263: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2264: if(l_logLevel <= wip_constants.full_logging) then
2265: wip_logger.log('final simult batch scheduling failed', l_retStatus);
2266: end if;
2267: raise fnd_api.g_exc_unexpected_error;

Line 2267: raise fnd_api.g_exc_unexpected_error;

2263: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2264: if(l_logLevel <= wip_constants.full_logging) then
2265: wip_logger.log('final simult batch scheduling failed', l_retStatus);
2266: end if;
2267: raise fnd_api.g_exc_unexpected_error;
2268: end if;
2269: end if;
2270:
2271: if(l_logLevel <= wip_constants.trace_logging) then

Line 2279: when fnd_api.g_exc_unexpected_error then

2275: x_returnStatus => l_retStatus);
2276: end if;
2277:
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,

Line 2280: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2276: end if;
2277:
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',

Line 2288: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2284: p_msg => 'error',
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:

Line 2322: x_returnStatus := fnd_api.g_ret_sts_success;

2318: p_params => l_params,
2319: x_returnStatus => l_retStatus);
2320: end if;
2321:
2322: x_returnStatus := fnd_api.g_ret_sts_success;
2323:
2324: for i in 1..p_opTbl.count loop
2325: if(p_opTbl(i).priorsExist) then
2326: backwardSchedule(p_orgID => p_orgID,

Line 2333: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2329: p_range => num_tbl_t(p_opTbl(i).resStartIdx, p_opTbl(i).resEndIdx),
2330: p_schedFlag => wip_constants.sched_prior,
2331: x_resTbls => x_resTbls,
2332: x_returnStatus => x_returnStatus);
2333: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2334: raise fnd_api.g_exc_unexpected_error;
2335: end if;
2336: end if;
2337: end loop;

Line 2334: raise fnd_api.g_exc_unexpected_error;

2330: p_schedFlag => wip_constants.sched_prior,
2331: x_resTbls => x_resTbls,
2332: x_returnStatus => x_returnStatus);
2333: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2334: raise fnd_api.g_exc_unexpected_error;
2335: end if;
2336: end if;
2337: end loop;
2338:

Line 2346: when fnd_api.g_exc_unexpected_error then

2342: p_msg => 'success',
2343: x_returnStatus => l_retStatus);
2344: end if;
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,

Line 2347: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2343: x_returnStatus => l_retStatus);
2344: end if;
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',

Line 2355: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2351: p_msg => 'backward scheduling failed',
2352: x_returnStatus => l_retStatus);
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,

Line 2385: x_returnStatus := fnd_api.g_ret_sts_success;

2381: p_params => l_params,
2382: x_returnStatus => l_retStatus);
2383: end if;
2384:
2385: x_returnStatus := fnd_api.g_ret_sts_success;
2386:
2387: for i in 1..p_opTbl.count loop
2388: if(p_opTbl(i).nextsExist) then
2389: forwardSchedule(p_orgID => p_orgID,

Line 2396: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2392: p_range => num_tbl_t(p_opTbl(i).resStartIdx, p_opTbl(i).resEndIdx),
2393: p_schedFlag => wip_constants.sched_next,
2394: x_resTbls => x_resTbls,
2395: x_returnStatus => x_returnStatus);
2396: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2397: raise fnd_api.g_exc_unexpected_error;
2398: end if;
2399: end if;
2400: end loop;

Line 2397: raise fnd_api.g_exc_unexpected_error;

2393: p_schedFlag => wip_constants.sched_next,
2394: x_resTbls => x_resTbls,
2395: x_returnStatus => x_returnStatus);
2396: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2397: raise fnd_api.g_exc_unexpected_error;
2398: end if;
2399: end if;
2400: end loop;
2401:

Line 2409: when fnd_api.g_exc_unexpected_error then

2405: p_msg => 'success',
2406: x_returnStatus => l_retStatus);
2407: end if;
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,

Line 2410: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2406: x_returnStatus => l_retStatus);
2407: end if;
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',

Line 2418: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2414: p_msg => 'backward scheduling failed',
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:

Line 2449: x_returnStatus := fnd_api.g_ret_sts_success;

2445: i number;
2446: l_exceptionExists boolean := false;
2447: l_errMsg VARCHAR2(200);
2448: begin
2449: x_returnStatus := fnd_api.g_ret_sts_success;
2450: if(l_logLevel <= wip_constants.trace_logging) then
2451: l_params(1).paramName := 'p_orgID';
2452: l_params(1).paramValue := p_orgID;
2453: l_params(2).paramName := 'p_repLineID';

Line 2521: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2517: p_schedFlag => wip_constants.sched_prior,
2518: x_resTbls => x_resTbls,
2519: x_returnStatus => x_returnStatus);
2520:
2521: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2522: l_errMsg := 'forward schedule failed';
2523: raise fnd_api.g_exc_unexpected_error;
2524: end if;
2525:

Line 2523: raise fnd_api.g_exc_unexpected_error;

2519: x_returnStatus => x_returnStatus);
2520:
2521: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2522: l_errMsg := 'forward schedule failed';
2523: raise fnd_api.g_exc_unexpected_error;
2524: end if;
2525:
2526: --find latest completion date of the prior resources
2527: i := null;

Line 2538: p_endDebug => fnd_api.g_false,

2534: schedule(p_orgID => p_orgID,
2535: p_repLineID => p_repLineID,
2536: p_startDate => l_opStartDate,
2537: p_opSeqNum => x_resTbls.opSeqNum(l_opRange(1)),
2538: p_endDebug => fnd_api.g_false,
2539: x_resTbls => x_resTbls,
2540: x_returnStatus => x_returnStatus);
2541:
2542: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 2542: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2538: p_endDebug => fnd_api.g_false,
2539: x_resTbls => x_resTbls,
2540: x_returnStatus => x_returnStatus);
2541:
2542: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2543: l_errMsg := 'schedule() failed';
2544: raise fnd_api.g_exc_unexpected_error;
2545: end if;
2546:

Line 2544: raise fnd_api.g_exc_unexpected_error;

2540: x_returnStatus => x_returnStatus);
2541:
2542: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2543: l_errMsg := 'schedule() failed';
2544: raise fnd_api.g_exc_unexpected_error;
2545: end if;
2546:
2547: --There still might be other exceptions. Call resolvePriorExceptions recursively. Note that this
2548: --terminates (eventually) because if schedule is called again, the resources we just re-scheduled

Line 2556: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2552: p_startDate => p_startDate,
2553: x_resTbls => x_resTbls,
2554: x_returnStatus => x_returnStatus);
2555:
2556: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2557: l_errMsg := 'resolvePriorExceptions Failed';
2558: raise fnd_api.g_exc_unexpected_error;
2559: end if;
2560: end if;

Line 2558: raise fnd_api.g_exc_unexpected_error;

2554: x_returnStatus => x_returnStatus);
2555:
2556: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2557: l_errMsg := 'resolvePriorExceptions Failed';
2558: raise fnd_api.g_exc_unexpected_error;
2559: end if;
2560: end if;
2561:
2562: if(l_logLevel <= wip_constants.trace_logging) then

Line 2569: when fnd_api.g_exc_unexpected_error then

2565: p_msg => 'success.',
2566: x_returnStatus => l_retStatus);
2567: end if;
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,

Line 2570: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2566: x_returnStatus => l_retStatus);
2567: end if;
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,

Line 2578: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2574: p_msg => 'errmsg: ' || l_errMsg,
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:

Line 2608: x_returnStatus := fnd_api.g_ret_sts_success;

2604: i number;
2605: l_exceptionExists boolean := false;
2606: l_errMsg VARCHAR2(200);
2607: begin
2608: x_returnStatus := fnd_api.g_ret_sts_success;
2609: if(l_logLevel <= wip_constants.trace_logging) then
2610: l_params(1).paramName := 'p_orgID';
2611: l_params(1).paramValue := p_orgID;
2612: l_params(2).paramName := 'p_repLineID';

Line 2685: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2681: p_schedFlag => wip_constants.sched_next,
2682: x_resTbls => x_resTbls,
2683: x_returnStatus => x_returnStatus);
2684:
2685: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2686: l_errMsg := 'backward schedule failed';
2687: raise fnd_api.g_exc_unexpected_error;
2688: end if;
2689:

Line 2687: raise fnd_api.g_exc_unexpected_error;

2683: x_returnStatus => x_returnStatus);
2684:
2685: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2686: l_errMsg := 'backward schedule failed';
2687: raise fnd_api.g_exc_unexpected_error;
2688: end if;
2689:
2690: --find earliest start date of the next resources
2691: i := null;

Line 2702: p_endDebug => fnd_api.g_false,

2698: schedule(p_orgID => p_orgID,
2699: p_repLineID => p_repLineID,
2700: p_endDate => l_opEndDate,
2701: p_opSeqNum => x_resTbls.opSeqNum(l_opRange(1)),
2702: p_endDebug => fnd_api.g_false,
2703: x_resTbls => x_resTbls,
2704: x_returnStatus => x_returnStatus);
2705:
2706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 2706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2702: p_endDebug => fnd_api.g_false,
2703: x_resTbls => x_resTbls,
2704: x_returnStatus => x_returnStatus);
2705:
2706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2707: l_errMsg := 'schedule() failed';
2708: raise fnd_api.g_exc_unexpected_error;
2709: end if;
2710:

Line 2708: raise fnd_api.g_exc_unexpected_error;

2704: x_returnStatus => x_returnStatus);
2705:
2706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2707: l_errMsg := 'schedule() failed';
2708: raise fnd_api.g_exc_unexpected_error;
2709: end if;
2710:
2711: --There still might be other exceptions. Call resolveNextExceptions recursively. Note that this
2712: --terminates (eventually) because if schedule is called again, the resources we just re-scheduled

Line 2720: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

2716: p_endDate => p_endDate,
2717: x_resTbls => x_resTbls,
2718: x_returnStatus => x_returnStatus);
2719:
2720: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2721: l_errMsg := 'resolveNextExceptions Failed';
2722: raise fnd_api.g_exc_unexpected_error;
2723: end if;
2724: end if;

Line 2722: raise fnd_api.g_exc_unexpected_error;

2718: x_returnStatus => x_returnStatus);
2719:
2720: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2721: l_errMsg := 'resolveNextExceptions Failed';
2722: raise fnd_api.g_exc_unexpected_error;
2723: end if;
2724: end if;
2725:
2726: if(l_logLevel <= wip_constants.trace_logging) then

Line 2733: when fnd_api.g_exc_unexpected_error then

2729: p_msg => 'success.',
2730: x_returnStatus => l_retStatus);
2731: end if;
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,

Line 2734: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2730: x_returnStatus => l_retStatus);
2731: end if;
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,

Line 2742: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2738: p_msg => l_errMsg,
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:

Line 2843: x_returnStatus := fnd_api.g_ret_sts_success;

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;
2844:
2845: while(getNextResIdx(l_range, wip_constants.sched_no, g_forward, x_resTbls, i)) loop
2846:
2847: if(l_logLevel <= wip_constants.full_logging) then

Line 2888: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2884: x_returnStatus => l_retStatus);
2885: end if;
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,