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 FND_API

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

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;
556: end if;
557: end if;
558: x_returnStatus := fnd_api.g_ret_sts_success;

Line 555: raise fnd_api.g_exc_unexpected_error;

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;
556: end if;
557: end if;
558: x_returnStatus := fnd_api.g_ret_sts_success;
559:

Line 558: x_returnStatus := fnd_api.g_ret_sts_success;

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

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

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

Line 666: raise fnd_api.g_exc_unexpected_error;

662: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
663: if(l_logLevel <= wip_constants.full_logging) then
664: wip_logger.log('fwdSch failed', l_retStatus);
665: end if;
666: raise fnd_api.g_exc_unexpected_error;
667: end if;
668:
669: if(l_logLevel <= wip_constants.full_logging) then
670: dumpResources(x_resTbls);

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

682: p_range => l_range,
683: p_schedFlag => wip_constants.sched_yes,
684: x_resTbls => x_resTbls,
685: x_returnStatus => x_returnStatus);
686: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
687: if(l_logLevel <= wip_constants.full_logging) then
688: wip_logger.log('bkwdSch failed', l_retStatus);
689: end if;
690: raise fnd_api.g_exc_unexpected_error;

Line 690: raise fnd_api.g_exc_unexpected_error;

686: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
687: if(l_logLevel <= wip_constants.full_logging) then
688: wip_logger.log('bkwdSch failed', l_retStatus);
689: end if;
690: raise fnd_api.g_exc_unexpected_error;
691: end if;
692: end if;
693:
694: --build the operation structure

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

702: p_opTbl => l_opTbl,
703: x_resTbls => x_resTbls,
704: x_returnStatus => x_returnStatus);
705:
706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
707: if(l_logLevel <= wip_constants.full_logging) then
708: wip_logger.log('schPriorRes failed', l_retStatus);
709: end if;
710: raise fnd_api.g_exc_unexpected_error;

Line 710: raise fnd_api.g_exc_unexpected_error;

706: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
707: if(l_logLevel <= wip_constants.full_logging) then
708: wip_logger.log('schPriorRes failed', l_retStatus);
709: end if;
710: raise fnd_api.g_exc_unexpected_error;
711: end if;
712: -- Bug # 13388579 logic to identify back ward scheduling .
713: if(p_opSeqNum is null and p_endDate is not null) then
714: is_backWardSch := true;

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

720: x_resTbls => x_resTbls,
721: x_returnStatus => x_returnStatus);
722:
723:
724: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
725: if(l_logLevel <= wip_constants.full_logging) then
726: wip_logger.log('schNextRes failed', l_retStatus);
727: end if;
728: raise fnd_api.g_exc_unexpected_error;

Line 728: raise fnd_api.g_exc_unexpected_error;

724: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
725: if(l_logLevel <= wip_constants.full_logging) then
726: wip_logger.log('schNextRes failed', l_retStatus);
727: end if;
728: raise fnd_api.g_exc_unexpected_error;
729: end if;
730:
731: if(l_logLevel <= wip_constants.full_logging) then
732: dumpResources(x_resTbls);

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

738: p_repLineID => p_repLineID,
739: p_startDate => p_startDate,
740: x_resTbls => x_resTbls,
741: x_returnStatus => x_returnStatus);
742: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
743: if(l_logLevel <= wip_constants.full_logging) then
744: wip_logger.log('resolvePriorRes failed', l_retStatus);
745: end if;
746: raise fnd_api.g_exc_unexpected_error;

Line 746: raise fnd_api.g_exc_unexpected_error;

742: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
743: if(l_logLevel <= wip_constants.full_logging) then
744: wip_logger.log('resolvePriorRes failed', l_retStatus);
745: end if;
746: raise fnd_api.g_exc_unexpected_error;
747: end if;
748: --if backward scheduling
749: elsif(p_opSeqNum is null and p_endDate is not null) then
750: resolveNextExceptions(p_orgID => p_orgID,

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

753: x_resTbls => x_resTbls,
754: x_returnStatus => x_returnStatus);
755: -- Bug # 13388579 resetting the flag.
756: is_backWardSch := false;
757: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
758: if(l_logLevel <= wip_constants.full_logging) then
759: wip_logger.log('resolveNextRes failed', l_retStatus);
760: end if;
761: raise fnd_api.g_exc_unexpected_error;

Line 761: raise fnd_api.g_exc_unexpected_error;

757: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
758: if(l_logLevel <= wip_constants.full_logging) then
759: wip_logger.log('resolveNextRes failed', l_retStatus);
760: end if;
761: raise fnd_api.g_exc_unexpected_error;
762: end if;
763: end if;
764:
765:

Line 778: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) 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
779: wip_logger.cleanup(l_retStatus);
780: end if;
781: end if;
782: exception

Line 783: when fnd_api.g_exc_unexpected_error then

779: wip_logger.cleanup(l_retStatus);
780: end if;
781: end if;
782: exception
783: when fnd_api.g_exc_unexpected_error then
784: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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);

Line 784: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

780: end if;
781: end if;
782: exception
783: when fnd_api.g_exc_unexpected_error then
784: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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:

Line 787: p_delete_stack => fnd_api.g_false);

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

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

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
794: wip_logger.cleanup(l_retStatus);
795: end if;
796: end if;
797: when others then

Line 798: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 807: if(fnd_api.to_boolean(nvl(p_endDebug, fnd_api.g_true))) 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
808: wip_logger.cleanup(l_retStatus);
809: end if;
810: end if;
811: end schedule;

Line 1226: x_returnStatus := fnd_api.g_ret_sts_success;

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;
1227:
1228: /* Fix for bug 5660475: If dealing with shift resource, first check if shifts are setup fine. */
1229: -- Bug 16322124 . Modified for Performance. Validation is simplified since all shifts are assumed to have valid time setups .
1230: if( p_repLineID is null

Line 1259: raise fnd_api.g_exc_unexpected_error;

1255: fnd_message.set_name('WIP', 'WIP_SHIFT_RESOURCE');
1256: fnd_message.set_token('ENTITY1', x_resTbls.resSeqNum(p_idx));
1257: fnd_message.set_token('ENTITY2', x_resTbls.opSeqNum(p_idx));
1258: fnd_msg_pub.add;
1259: raise fnd_api.g_exc_unexpected_error;
1260: end;
1261: end if;
1262:
1263: x_resTbls.usgStartIdx(p_idx) := null;

Line 1511: raise fnd_api.g_exc_unexpected_error;

1507: wip_logger.log('exhausted calendar. remaining usage(HRS) is ' || round(l_remUsage*24, g_precision), l_retStatus);
1508: end if;
1509: fnd_message.set_name('WIP', 'WIP_NO_CALENDAR');
1510: fnd_msg_pub.add;
1511: raise fnd_api.g_exc_unexpected_error;
1512: end if;
1513: end if;
1514: end loop;
1515: if(l_logLevel <= wip_constants.trace_logging) then

Line 1522: when fnd_api.g_exc_unexpected_error then

1518: p_msg => 'success',
1519: x_returnStatus => l_retStatus);
1520: end if;
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,

Line 1523: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 1531: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2013: WHEN fnd_api.g_exc_unexpected_error THEN

2009: p_msg => 'success',
2010: x_returnStatus => l_retStatus);
2011: END IF;
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,

Line 2014: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2022: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

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

2117: l_resStartDate := getStartDate(p_range, p_schedFlag, x_resTbls, i, l_doneSchedBatch, l_prevResIdx);
2118: end if;
2119:
2120: forwardSchResource(p_orgID, l_resStartDate, l_maxDate, i, p_repLineID, x_resTbls, x_returnStatus);
2121: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2122: raise fnd_api.g_exc_unexpected_error;
2123: end if;
2124:
2125: l_prevResIdx := i;

Line 2122: raise fnd_api.g_exc_unexpected_error;

2118: end if;
2119:
2120: forwardSchResource(p_orgID, l_resStartDate, l_maxDate, i, p_repLineID, x_resTbls, x_returnStatus);
2121: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2122: raise fnd_api.g_exc_unexpected_error;
2123: end if;
2124:
2125: l_prevResIdx := i;
2126: end loop;

Line 2135: when fnd_api.g_exc_unexpected_error then

2131: p_msg => 'success',
2132: x_returnStatus => l_retStatus);
2133: end if;
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,

Line 2136: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2144: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2384: raise fnd_api.g_exc_unexpected_error;

2380: fnd_message.set_name('WIP', 'WIP_SHIFT_RESOURCE');
2381: fnd_message.set_token('ENTITY1', x_resTbls.resSeqNum(p_idx));
2382: fnd_message.set_token('ENTITY2', x_resTbls.opSeqNum(p_idx));
2383: fnd_msg_pub.add;
2384: raise fnd_api.g_exc_unexpected_error;
2385: end;
2386: end if;
2387:
2388: x_resTbls.usgStartIdx(p_idx) := null;

Line 2581: raise fnd_api.g_exc_unexpected_error;

2577: wip_logger.log('exhausted calendar. remaining usage(HRS) is ' || round(l_remUsage*24, g_precision), l_retStatus);
2578: end if;
2579: fnd_message.set_name('WIP', 'WIP_NO_CALENDAR');
2580: fnd_msg_pub.add;
2581: raise fnd_api.g_exc_unexpected_error;
2582: end if;
2583: end if;
2584: end loop;
2585:

Line 2615: when fnd_api.g_exc_unexpected_error then

2611: p_msg => 'success',
2612: x_returnStatus => l_retStatus);
2613: end if;
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,

Line 2616: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2624: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

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

2792: p_schedFlag => p_schedFlag,
2793: p_startIdx => l_prevResIdx,
2794: x_resTbls => x_resTbls,
2795: x_returnStatus => x_returnStatus);
2796: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2797: if(l_logLevel <= wip_constants.full_logging) then
2798: wip_logger.log('simult batch scheduling failed', l_retStatus);
2799: end if;
2800: raise fnd_api.g_exc_unexpected_error;

Line 2800: raise fnd_api.g_exc_unexpected_error;

2796: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2797: if(l_logLevel <= wip_constants.full_logging) then
2798: wip_logger.log('simult batch scheduling failed', l_retStatus);
2799: end if;
2800: raise fnd_api.g_exc_unexpected_error;
2801: end if;
2802: end if;
2803:
2804: if(l_prevResIdx is null) then

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

2809: l_resEndDate := getEndDate(p_range, p_schedFlag, x_resTbls, i, l_doneSchedBatch, l_prevResIdx);
2810: end if;
2811:
2812: backwardSchResource(p_orgID, l_resEndDate, l_minDate, i, p_repLineID, x_resTbls, x_returnStatus);
2813: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2814: if(l_logLevel <= wip_constants.full_logging) then
2815: wip_logger.log('backward schedule failed', l_retStatus);
2816: end if;
2817: raise fnd_api.g_exc_unexpected_error;

Line 2817: raise fnd_api.g_exc_unexpected_error;

2813: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2814: if(l_logLevel <= wip_constants.full_logging) then
2815: wip_logger.log('backward schedule failed', l_retStatus);
2816: end if;
2817: raise fnd_api.g_exc_unexpected_error;
2818: end if;
2819:
2820: l_prevResIdx := i;
2821: end loop;

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

2830: p_schedFlag => p_schedFlag,
2831: p_startIdx => l_prevResIdx,
2832: x_resTbls => x_resTbls,
2833: x_returnStatus => x_returnStatus);
2834: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2835: if(l_logLevel <= wip_constants.full_logging) then
2836: wip_logger.log('final simult batch scheduling failed', l_retStatus);
2837: end if;
2838: raise fnd_api.g_exc_unexpected_error;

Line 2838: raise fnd_api.g_exc_unexpected_error;

2834: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2835: if(l_logLevel <= wip_constants.full_logging) then
2836: wip_logger.log('final simult batch scheduling failed', l_retStatus);
2837: end if;
2838: raise fnd_api.g_exc_unexpected_error;
2839: end if;
2840: end if;
2841:
2842: if(l_logLevel <= wip_constants.trace_logging) then

Line 2850: when fnd_api.g_exc_unexpected_error then

2846: x_returnStatus => l_retStatus);
2847: end if;
2848:
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,

Line 2851: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

2847: end if;
2848:
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',

Line 2859: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2893: x_returnStatus := fnd_api.g_ret_sts_success;

2889: p_params => l_params,
2890: x_returnStatus => l_retStatus);
2891: end if;
2892:
2893: x_returnStatus := fnd_api.g_ret_sts_success;
2894:
2895: for i in 1..p_opTbl.count loop
2896: if(p_opTbl(i).priorsExist) then
2897: backwardSchedule(p_orgID => p_orgID,

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

2900: p_range => num_tbl_t(p_opTbl(i).resStartIdx, p_opTbl(i).resEndIdx),
2901: p_schedFlag => wip_constants.sched_prior,
2902: x_resTbls => x_resTbls,
2903: x_returnStatus => x_returnStatus);
2904: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2905: raise fnd_api.g_exc_unexpected_error;
2906: end if;
2907: end if;
2908: end loop;

Line 2905: raise fnd_api.g_exc_unexpected_error;

2901: p_schedFlag => wip_constants.sched_prior,
2902: x_resTbls => x_resTbls,
2903: x_returnStatus => x_returnStatus);
2904: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2905: raise fnd_api.g_exc_unexpected_error;
2906: end if;
2907: end if;
2908: end loop;
2909:

Line 2917: when fnd_api.g_exc_unexpected_error then

2913: p_msg => 'success',
2914: x_returnStatus => l_retStatus);
2915: end if;
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,

Line 2918: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2926: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2956: x_returnStatus := fnd_api.g_ret_sts_success;

2952: p_params => l_params,
2953: x_returnStatus => l_retStatus);
2954: end if;
2955:
2956: x_returnStatus := fnd_api.g_ret_sts_success;
2957:
2958: for i in 1..p_opTbl.count loop
2959: if(p_opTbl(i).nextsExist) then
2960: -- Bug #13388579 added below flag to identify the call to forwardSchedule procedure from scheduleNextResources procedure in backward scheduling

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

2970: x_returnStatus => x_returnStatus);
2971: if (is_backWardSch) then
2972: g_reset_date := 0; -- Bug #13388579
2973: end if;
2974: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2975: raise fnd_api.g_exc_unexpected_error;
2976: end if;
2977: end if;
2978: end loop;

Line 2975: raise fnd_api.g_exc_unexpected_error;

2971: if (is_backWardSch) then
2972: g_reset_date := 0; -- Bug #13388579
2973: end if;
2974: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2975: raise fnd_api.g_exc_unexpected_error;
2976: end if;
2977: end if;
2978: end loop;
2979:

Line 2987: when fnd_api.g_exc_unexpected_error then

2983: p_msg => 'success',
2984: x_returnStatus => l_retStatus);
2985: end if;
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,

Line 2988: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 2996: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 3027: x_returnStatus := fnd_api.g_ret_sts_success;

3023: i number;
3024: l_exceptionExists boolean := false;
3025: l_errMsg VARCHAR2(200);
3026: begin
3027: x_returnStatus := fnd_api.g_ret_sts_success;
3028: if(l_logLevel <= wip_constants.trace_logging) then
3029: l_params(1).paramName := 'p_orgID';
3030: l_params(1).paramValue := p_orgID;
3031: l_params(2).paramName := 'p_repLineID';

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

3095: p_schedFlag => wip_constants.sched_prior,
3096: x_resTbls => x_resTbls,
3097: x_returnStatus => x_returnStatus);
3098:
3099: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3100: l_errMsg := 'forward schedule failed';
3101: raise fnd_api.g_exc_unexpected_error;
3102: end if;
3103:

Line 3101: raise fnd_api.g_exc_unexpected_error;

3097: x_returnStatus => x_returnStatus);
3098:
3099: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3100: l_errMsg := 'forward schedule failed';
3101: raise fnd_api.g_exc_unexpected_error;
3102: end if;
3103:
3104: --find latest completion date of the prior resources
3105: i := null;

Line 3116: p_endDebug => fnd_api.g_false,

3112: schedule(p_orgID => p_orgID,
3113: p_repLineID => p_repLineID,
3114: p_startDate => l_opStartDate,
3115: p_opSeqNum => x_resTbls.opSeqNum(l_opRange(1)),
3116: p_endDebug => fnd_api.g_false,
3117: x_resTbls => x_resTbls,
3118: x_returnStatus => x_returnStatus);
3119:
3120: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

3116: p_endDebug => fnd_api.g_false,
3117: x_resTbls => x_resTbls,
3118: x_returnStatus => x_returnStatus);
3119:
3120: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3121: l_errMsg := 'schedule() failed';
3122: raise fnd_api.g_exc_unexpected_error;
3123: end if;
3124:

Line 3122: raise fnd_api.g_exc_unexpected_error;

3118: x_returnStatus => x_returnStatus);
3119:
3120: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3121: l_errMsg := 'schedule() failed';
3122: raise fnd_api.g_exc_unexpected_error;
3123: end if;
3124:
3125: --There still might be other exceptions. Call resolvePriorExceptions recursively. Note that this
3126: --terminates (eventually) because if schedule is called again, the resources we just re-scheduled

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

3130: p_startDate => p_startDate,
3131: x_resTbls => x_resTbls,
3132: x_returnStatus => x_returnStatus);
3133:
3134: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3135: l_errMsg := 'resolvePriorExceptions Failed';
3136: raise fnd_api.g_exc_unexpected_error;
3137: end if;
3138: end if;

Line 3136: raise fnd_api.g_exc_unexpected_error;

3132: x_returnStatus => x_returnStatus);
3133:
3134: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3135: l_errMsg := 'resolvePriorExceptions Failed';
3136: raise fnd_api.g_exc_unexpected_error;
3137: end if;
3138: end if;
3139:
3140: if(l_logLevel <= wip_constants.trace_logging) then

Line 3147: when fnd_api.g_exc_unexpected_error then

3143: p_msg => 'success.',
3144: x_returnStatus => l_retStatus);
3145: end if;
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,

Line 3148: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 3156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 3186: x_returnStatus := fnd_api.g_ret_sts_success;

3182: i number;
3183: l_exceptionExists boolean := false;
3184: l_errMsg VARCHAR2(200);
3185: begin
3186: x_returnStatus := fnd_api.g_ret_sts_success;
3187: if(l_logLevel <= wip_constants.trace_logging) then
3188: l_params(1).paramName := 'p_orgID';
3189: l_params(1).paramValue := p_orgID;
3190: l_params(2).paramName := 'p_repLineID';

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

3259: p_schedFlag => wip_constants.sched_next,
3260: x_resTbls => x_resTbls,
3261: x_returnStatus => x_returnStatus);
3262:
3263: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3264: l_errMsg := 'backward schedule failed';
3265: raise fnd_api.g_exc_unexpected_error;
3266: end if;
3267:

Line 3265: raise fnd_api.g_exc_unexpected_error;

3261: x_returnStatus => x_returnStatus);
3262:
3263: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3264: l_errMsg := 'backward schedule failed';
3265: raise fnd_api.g_exc_unexpected_error;
3266: end if;
3267:
3268: --find earliest start date of the next resources
3269: i := null;

Line 3280: p_endDebug => fnd_api.g_false,

3276: schedule(p_orgID => p_orgID,
3277: p_repLineID => p_repLineID,
3278: p_endDate => l_opEndDate,
3279: p_opSeqNum => x_resTbls.opSeqNum(l_opRange(1)),
3280: p_endDebug => fnd_api.g_false,
3281: x_resTbls => x_resTbls,
3282: x_returnStatus => x_returnStatus);
3283:
3284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

3280: p_endDebug => fnd_api.g_false,
3281: x_resTbls => x_resTbls,
3282: x_returnStatus => x_returnStatus);
3283:
3284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3285: l_errMsg := 'schedule() failed';
3286: raise fnd_api.g_exc_unexpected_error;
3287: end if;
3288:

Line 3286: raise fnd_api.g_exc_unexpected_error;

3282: x_returnStatus => x_returnStatus);
3283:
3284: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3285: l_errMsg := 'schedule() failed';
3286: raise fnd_api.g_exc_unexpected_error;
3287: end if;
3288:
3289: --There still might be other exceptions. Call resolveNextExceptions recursively. Note that this
3290: --terminates (eventually) because if schedule is called again, the resources we just re-scheduled

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

3294: p_endDate => p_endDate,
3295: x_resTbls => x_resTbls,
3296: x_returnStatus => x_returnStatus);
3297:
3298: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3299: l_errMsg := 'resolveNextExceptions Failed';
3300: raise fnd_api.g_exc_unexpected_error;
3301: end if;
3302: end if;

Line 3300: raise fnd_api.g_exc_unexpected_error;

3296: x_returnStatus => x_returnStatus);
3297:
3298: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
3299: l_errMsg := 'resolveNextExceptions Failed';
3300: raise fnd_api.g_exc_unexpected_error;
3301: end if;
3302: end if;
3303:
3304: if(l_logLevel <= wip_constants.trace_logging) then

Line 3311: when fnd_api.g_exc_unexpected_error then

3307: p_msg => 'success.',
3308: x_returnStatus => l_retStatus);
3309: end if;
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,

Line 3312: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 3320: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 3424: x_returnStatus := fnd_api.g_ret_sts_success;

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;
3425:
3426: while(getNextResIdx(l_range, wip_constants.sched_no, g_forward, x_resTbls, i)) loop
3427:
3428: if(l_logLevel <= wip_constants.full_logging) then

Line 3488: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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