DBA Data[Home] [Help]

APPS.IGS_FI_FEE_AS_RT_PKG dependencies on IGS_FI_VAL_CFAR

Line 80: IF IGS_FI_VAL_CFAR.finp_val_cfar_ins(

76: v_message_name varchar2(30);
77: BEGIN
78: -- Validate contract fee assessment rate
79: IF p_inserting THEN
80: IF IGS_FI_VAL_CFAR.finp_val_cfar_ins(
81: new_references.person_id,
82: new_references.course_cd,
83: new_references.fee_type,
84: v_message_name) = FALSE THEN

Line 93: IF IGS_FI_VAL_CFAR.finp_val_cfar_end_dt(

89: END IF;
90: IF p_inserting OR
91: (p_updating AND new_references.end_dt IS NOT NULL AND
92: (new_references.start_dt <> old_references.start_dt OR new_references.end_dt <> old_references.end_dt)) THEN
93: IF IGS_FI_VAL_CFAR.finp_val_cfar_end_dt(
94: new_references.start_dt,
95: new_references.end_dt,
96: v_message_name) = FALSE THEN
97: Fnd_Message.Set_Name('IGS',v_message_name);

Line 104: IF IGS_FI_VAL_CFAR.finp_val_ft_closed(

100: END IF;
101: END IF;
102: IF p_inserting OR (p_updating AND
103: new_references.fee_type <> old_references.fee_type) THEN
104: IF IGS_FI_VAL_CFAR.finp_val_ft_closed(
105: new_references.fee_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;

Line 114: IF IGS_FI_VAL_CFAR.finp_val_att_closed(

110: END IF;
111: END IF;
112: IF p_inserting OR (p_updating AND
113: new_references.attendance_type <> old_references.attendance_type) THEN
114: IF IGS_FI_VAL_CFAR.finp_val_att_closed(
115: new_references.attendance_type,
116: v_message_name) = FALSE THEN
117: Fnd_Message.Set_Name('IGS',v_message_name);
118: IGS_GE_MSG_STACK.ADD;

Line 124: IF IGS_FI_VAL_CFAR.finp_val_am_closed(

120: END IF;
121: END IF;
122: IF p_inserting OR (p_updating AND
123: new_references.attendance_mode <> old_references.attendance_mode) THEN
124: IF IGS_FI_VAL_CFAR.finp_val_am_closed(
125: new_references.attendance_mode,
126: v_message_name) = FALSE THEN
127: Fnd_Message.Set_Name('IGS',v_message_name);
128: IGS_GE_MSG_STACK.ADD;

Line 134: IF IGS_FI_VAL_CFAR.finp_val_loc_closed(

130: END IF;
131: END IF;
132: IF p_inserting OR (p_updating AND
133: new_references.location_cd <> old_references.location_cd) THEN
134: IF IGS_FI_VAL_CFAR.finp_val_loc_closed(
135: new_references.location_cd,
136: v_message_name) = FALSE THEN
137: Fnd_Message.Set_Name('IGS',v_message_name);
138: IGS_GE_MSG_STACK.ADD;

Line 190: IF IGS_FI_VAL_CFAR.finp_val_cfar_open (

186: BEGIN
187: -- Validate the start and end dates
188: IF p_inserting OR p_updating THEN
189: IF new_references.end_dt IS NULL THEN
190: IF IGS_FI_VAL_CFAR.finp_val_cfar_open (
191: new_references.person_id,
192: new_references.course_cd,
193: new_references.fee_type,
194: new_references.start_dt,

Line 201: IF IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (

197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
201: IF IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (
202: new_references.person_id,
203: new_references.course_cd,
204: new_references.fee_type,
205: new_references.start_dt,