DBA Data[Home] [Help]

APPS.MSC_CALENDAR dependencies on APP_EXCEPTION

Line 84: APP_EXCEPTION.RAISE_EXCEPTION;

80:
81: EXCEPTION
82: WHEN NO_DATA_FOUND THEN
83: FND_MESSAGE.SET_NAME('MRP', 'GEN-CALENDAR NOT COMPILED');
84: APP_EXCEPTION.RAISE_EXCEPTION;
85: END MSC_CAL_INIT_GLOBAL;
86:
87: FUNCTION MSC_CALC_PERIOD_OFFSET(arg_date IN DATE,
88: arg_offset IN NUMBER,

Line 144: APP_EXCEPTION.RAISE_EXCEPTION;

140: return var_return_date;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
144: APP_EXCEPTION.RAISE_EXCEPTION;
145: END;
146:
147: FUNCTION MSC_CALC_DATE_OFFSET(arg_seq_num IN NUMBER,
148: arg_offset IN NUMBER,

Line 183: APP_EXCEPTION.RAISE_EXCEPTION;

179: var_return_date := min_date;
180: END IF;
181: ELSE
182: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
183: APP_EXCEPTION.RAISE_EXCEPTION;
184: END IF;
185: END;
186: return var_return_date;
187: END;

Line 223: APP_EXCEPTION.RAISE_EXCEPTION;

219: var_return_date := min_week_date;
220: END IF;
221: ELSE
222: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
223: APP_EXCEPTION.RAISE_EXCEPTION;
224: END IF;
225: END;
226:
227: return var_return_date;

Line 300: APP_EXCEPTION.RAISE_EXCEPTION;

296: return var_return_date;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
300: APP_EXCEPTION.RAISE_EXCEPTION;
301: END NEXT_WORK_DAY;
302:
303: FUNCTION PREV_WORK_DAY(arg_org_id IN NUMBER,
304: arg_instance_id IN NUMBER,

Line 363: APP_EXCEPTION.RAISE_EXCEPTION;

359: return var_return_date;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END PREV_WORK_DAY;
365:
366: FUNCTION NEXT_WORK_DAY_SEQNUM(arg_org_id IN NUMBER,
367: arg_instance_id IN NUMBER,

Line 409: APP_EXCEPTION.RAISE_EXCEPTION;

405: return var_return_number;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
409: APP_EXCEPTION.RAISE_EXCEPTION;
410: END NEXT_WORK_DAY_SEQNUM;
411:
412: FUNCTION PREV_WORK_DAY_SEQNUM(arg_org_id IN NUMBER,
413: arg_instance_id IN NUMBER,

Line 456: APP_EXCEPTION.RAISE_EXCEPTION;

452: return var_return_number;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
456: APP_EXCEPTION.RAISE_EXCEPTION;
457: END PREV_WORK_DAY_SEQNUM;
458:
459: FUNCTION DATE_OFFSET( arg_org_id IN NUMBER,
460: arg_instance_id IN NUMBER,

Line 561: APP_EXCEPTION.RAISE_EXCEPTION;

557: return var_return_number;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
560: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
561: APP_EXCEPTION.RAISE_EXCEPTION;
562: END DAYS_BETWEEN;
563:
564: PROCEDURE select_calendar_defaults(
565: arg_org_id IN NUMBER,

Line 639: APP_EXCEPTION.RAISE_EXCEPTION;

635: return var_return_date;
636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
639: APP_EXCEPTION.RAISE_EXCEPTION;
640:
641:
642: END prev_delivery_calendar_day;
643:

Line 696: APP_EXCEPTION.RAISE_EXCEPTION;

692:
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: FND_MESSAGE.SET_NAME('MRP', 'GEN-CALENDAR NOT COMPILED');
696: APP_EXCEPTION.RAISE_EXCEPTION;
697: END CALENDAR_CAL_INIT_GLOBAL;
698:
699: ----------------------------------------------------------------------
700: -- CALENDAR_NEXT_WORK_DAY to fix bug# 2678523

Line 769: APP_EXCEPTION.RAISE_EXCEPTION;

765: return var_return_date;
766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN
768: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
769: APP_EXCEPTION.RAISE_EXCEPTION;
770: END CALENDAR_NEXT_WORK_DAY;
771:
772: --------------------------------------------------------------------------
773: -- CALENDAR_PREV_WORK_DAYto fix bug# 2678523

Line 835: APP_EXCEPTION.RAISE_EXCEPTION;

831: return var_return_date;
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN
834: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
835: APP_EXCEPTION.RAISE_EXCEPTION;
836: END CALENDAR_PREV_WORK_DAY;
837:
838: --------------------------------------------------------------------------
839: -- CALENDAR_PREV_WORK_DAY_SEQNUM to fix bug# 2678523

Line 889: APP_EXCEPTION.RAISE_EXCEPTION;

885:
886: EXCEPTION
887: WHEN NO_DATA_FOUND THEN
888: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
889: APP_EXCEPTION.RAISE_EXCEPTION;
890: END CALENDAR_PREV_WORK_DAY_SEQNUM;
891:
892: ------------------------------------------------------------------------
893: -- CALENDAR_DAYS_BETWEEN to fix bug# 2678523

Line 924: APP_EXCEPTION.RAISE_EXCEPTION;

920:
921: EXCEPTION
922: WHEN NO_DATA_FOUND THEN
923: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
924: APP_EXCEPTION.RAISE_EXCEPTION;
925: END CALENDAR_DAYS_BETWEEN;
926:
927: /*--------------------------------------------------------------------------
928: | Begin Functions added for ship_rec_cal project

Line 1374: APP_EXCEPTION.RAISE_EXCEPTION;

1370: l_next_work_day := l_first_work_day;
1371: END IF;
1372: ELSE
1373: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
1374: APP_EXCEPTION.RAISE_EXCEPTION;
1375: END IF;
1376: END;
1377: RETURN l_next_work_day;
1378:

Line 1432: APP_EXCEPTION.RAISE_EXCEPTION;

1428: l_prev_work_day := l_first_work_day;
1429: END IF;
1430: ELSE
1431: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
1432: APP_EXCEPTION.RAISE_EXCEPTION;
1433: END IF;
1434: END;
1435: RETURN l_prev_work_day;
1436: END PREV_WORK_DAY;

Line 1540: APP_EXCEPTION.RAISE_EXCEPTION;

1536: END IF;
1537:
1538: ELSE
1539: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
1540: APP_EXCEPTION.RAISE_EXCEPTION;
1541: END IF;
1542: END;
1543: ELSE
1544: BEGIN

Line 1591: APP_EXCEPTION.RAISE_EXCEPTION;

1587: l_offsetted_day := l_first_work_day;
1588: END IF;
1589: ELSE
1590: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
1591: APP_EXCEPTION.RAISE_EXCEPTION;
1592: END IF;
1593: END;
1594: END IF;
1595: END IF;