112: WHEN OTHERS THEN
113: IF l_func_name IS NULL THEN
114: l_func_name := 'chk_and_roll_ret';
115: END IF;
116: App_Exception.Raise_Exception;
117: END chk_and_roll_ret;
118:
119: -- To insert a date alias instance pair as part of the rollover process
120: FUNCTION calp_ins_rollvr_daip(
566: END IF;
567: IF l_func_name IS NULL THEN
568: l_func_name := 'calp_ins_rollvr_daip';
569: END IF;
570: App_Exception.Raise_Exception;
571: END;
572: END calp_ins_rollvr_daip;
573: --
574: -- To insert a dt alias inst offset constraint as part of the rollover.
662: WHEN OTHERS THEN
663: IF l_func_name IS NULL THEN
664: l_func_name := 'calp_ins_roll_daioc';
665: END IF;
666: App_Exception.Raise_Exception;
667: END;
668: END calp_ins_roll_daioc;
669: --
670: -- Validate the adm period IGS_PS_COURSE off option date date alias
1226: END IF;
1227: IF l_func_name IS NULL THEN
1228: l_func_name := 'calp_ins_rollvr_daio';
1229: END IF;
1230: App_Exception.Raise_Exception;
1231: END;
1232: END calp_ins_rollvr_daio;
1233: --
1234: -- To insert a date alias instance as part of the rollover process
1578: END IF;
1579: IF l_func_name IS NULL THEN
1580: l_func_name := 'calp_ins_rollvr_dai';
1581: END IF;
1582: App_Exception.Raise_Exception;
1583: END;
1584: END calp_ins_rollvr_dai;
1585: --
1586: -- To insert a ci relationship as part of the rollover process..
2036: END IF;
2037: IF l_func_name IS NULL THEN
2038: l_func_name := 'calp_ins_rollvr_cir';
2039: END IF;
2040: App_Exception.Raise_Exception;
2041: END calp_ins_rollvr_cir;
2042: --
2043: -- To insert a calendar instance as part of the rollover process
2044: FUNCTION calp_ins_rollvr_ci(
2113: WHEN OTHERS THEN
2114: IF l_func_name IS NULL THEN
2115: l_func_name := 'calpl_val_rolled_ci';
2116: END IF;
2117: App_Exception.Raise_Exception;
2118: END;
2119: END calpl_val_rolled_ci;
2120: FUNCTION calpl_ins_rollvr_ci(
2121: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
2506: ELSE
2507: l_error_code := 'E322';
2508: END IF;
2509: fnd_message.set_name('IGS',l_message_name);
2510: app_exception.raise_exception;*/
2511: END;
2512: END calpl_ins_rollvr_ci;
2513: BEGIN
2514: DECLARE
2822: l_func_name := 'calp_ins_rollvr_ci';
2823: END IF;
2824: fnd_message.set_token('FUNC_NAME',l_func_name);
2825: fnd_message.set_token('ERR_MSG',l_msg_txt);
2826: App_Exception.Raise_Exception;
2827: END;
2828: END calp_ins_rollvr_ci;
2829:
2830: END IGS_CA_INS_ROLL_CI;