375: END IF;
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
380: fnd_message.set_token('PROCEDURE',
381: 'GL_PARENT_SEGMENT_PKG.MERGE_CHILD_RANGES');
382: RAISE_APPLICATION_ERROR(-20150, fnd_message.get||SQLERRM);
383: END merge_child_ranges;
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
380: fnd_message.set_token('PROCEDURE',
381: 'GL_PARENT_SEGMENT_PKG.MERGE_CHILD_RANGES');
382: RAISE_APPLICATION_ERROR(-20150, fnd_message.get||SQLERRM);
383: END merge_child_ranges;
384:
378: WHEN OTHERS THEN
379: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
380: fnd_message.set_token('PROCEDURE',
381: 'GL_PARENT_SEGMENT_PKG.MERGE_CHILD_RANGES');
382: RAISE_APPLICATION_ERROR(-20150, fnd_message.get||SQLERRM);
383: END merge_child_ranges;
384:
385:
386: -- PROCEDURE
426: rec_count := 0;
427: min_val := NULL;
428: max_val := NULL;
429: WHEN OTHERS THEN
430: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
431: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
432: fnd_message.set_token('TABLE', 'GL_REVAL_CHD_RANGES_GT');
433: RAISE_APPLICATION_ERROR(-20160, fnd_message.get||SQLERRM);
434: END;
427: min_val := NULL;
428: max_val := NULL;
429: WHEN OTHERS THEN
430: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
431: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
432: fnd_message.set_token('TABLE', 'GL_REVAL_CHD_RANGES_GT');
433: RAISE_APPLICATION_ERROR(-20160, fnd_message.get||SQLERRM);
434: END;
435:
428: max_val := NULL;
429: WHEN OTHERS THEN
430: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
431: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
432: fnd_message.set_token('TABLE', 'GL_REVAL_CHD_RANGES_GT');
433: RAISE_APPLICATION_ERROR(-20160, fnd_message.get||SQLERRM);
434: END;
435:
436: IF g_debug_mode = 'Y' THEN
429: WHEN OTHERS THEN
430: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
431: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
432: fnd_message.set_token('TABLE', 'GL_REVAL_CHD_RANGES_GT');
433: RAISE_APPLICATION_ERROR(-20160, fnd_message.get||SQLERRM);
434: END;
435:
436: IF g_debug_mode = 'Y' THEN
437: debug_msg('get_min_max',
440: END IF;
441:
442: EXCEPTION
443: WHEN OTHERS THEN
444: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
445: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
446: RAISE_APPLICATION_ERROR(-20200, fnd_message.get||SQLERRM);
447: END get_min_max;
448:
441:
442: EXCEPTION
443: WHEN OTHERS THEN
444: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
445: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
446: RAISE_APPLICATION_ERROR(-20200, fnd_message.get||SQLERRM);
447: END get_min_max;
448:
449:
442: EXCEPTION
443: WHEN OTHERS THEN
444: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
445: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_MIN_MAX');
446: RAISE_APPLICATION_ERROR(-20200, fnd_message.get||SQLERRM);
447: END get_min_max;
448:
449:
450: -- PROCEDURE
482: WHERE fvs.flex_value_set_id = fv_set_id
483: AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
484: EXCEPTION
485: WHEN OTHERS THEN
486: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
487: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');
489: RAISE_APPLICATION_ERROR(-20210, fnd_message.get||SQLERRM);
490: END;
483: AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
484: EXCEPTION
485: WHEN OTHERS THEN
486: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
487: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');
489: RAISE_APPLICATION_ERROR(-20210, fnd_message.get||SQLERRM);
490: END;
491:
484: EXCEPTION
485: WHEN OTHERS THEN
486: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
487: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');
489: RAISE_APPLICATION_ERROR(-20210, fnd_message.get||SQLERRM);
490: END;
491:
492: IF g_debug_mode = 'Y' THEN
485: WHEN OTHERS THEN
486: fnd_message.set_name('SQLGL', 'MRC_TABLE_ERROR');
487: fnd_message.set_token('MODULE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
488: fnd_message.set_token('TABLE', 'FND_FLEX_VALUE_SETS');
489: RAISE_APPLICATION_ERROR(-20210, fnd_message.get||SQLERRM);
490: END;
491:
492: IF g_debug_mode = 'Y' THEN
493: debug_msg('get_fv_table',
496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
501: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
502: RAISE_APPLICATION_ERROR(-20250, fnd_message.get||SQLERRM);
503: END get_fv_table;
504:
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
501: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
502: RAISE_APPLICATION_ERROR(-20250, fnd_message.get||SQLERRM);
503: END get_fv_table;
504:
505: -- PROCEDURE
498: EXCEPTION
499: WHEN OTHERS THEN
500: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
501: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.GET_FV_TABLE');
502: RAISE_APPLICATION_ERROR(-20250, fnd_message.get||SQLERRM);
503: END get_fv_table;
504:
505: -- PROCEDURE
506: -- check_overlapping
626: END IF;
627:
628: EXCEPTION
629: WHEN OTHERS THEN
630: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
631: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.CHECK_OVERLAPPING');
632: RAISE_APPLICATION_ERROR(-20300, fnd_message.get||SQLERRM);
633: END check_overlapping;
634:
627:
628: EXCEPTION
629: WHEN OTHERS THEN
630: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
631: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.CHECK_OVERLAPPING');
632: RAISE_APPLICATION_ERROR(-20300, fnd_message.get||SQLERRM);
633: END check_overlapping;
634:
635: -- PROCEDURE
628: EXCEPTION
629: WHEN OTHERS THEN
630: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
631: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.CHECK_OVERLAPPING');
632: RAISE_APPLICATION_ERROR(-20300, fnd_message.get||SQLERRM);
633: END check_overlapping;
634:
635: -- PROCEDURE
636: -- debug_msg
651: END IF;
652:
653: EXCEPTION
654: WHEN OTHERS THEN
655: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
656: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.DEBUG_MSG');
657: RAISE_APPLICATION_ERROR(-20350, fnd_message.get||SQLERRM);
658: END debug_msg;
659:
652:
653: EXCEPTION
654: WHEN OTHERS THEN
655: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
656: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.DEBUG_MSG');
657: RAISE_APPLICATION_ERROR(-20350, fnd_message.get||SQLERRM);
658: END debug_msg;
659:
660: END GL_PARENT_SEGMENT_PKG;
653: EXCEPTION
654: WHEN OTHERS THEN
655: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
656: fnd_message.set_token('PROCEDURE', 'GL_PARENT_SEGMENT_PKG.DEBUG_MSG');
657: RAISE_APPLICATION_ERROR(-20350, fnd_message.get||SQLERRM);
658: END debug_msg;
659:
660: END GL_PARENT_SEGMENT_PKG;