125:
126: IF (l_future_versions = 'PRESENT') THEN
127: --
128: --
129: fnd_message.set_name('PQH','PQH_SS_DELETE_MODE_INVALID');
130: fnd_message.raise_error;
131:
132: --
133: ELSE -- No Futuer versions of Record is present .
126: IF (l_future_versions = 'PRESENT') THEN
127: --
128: --
129: fnd_message.set_name('PQH','PQH_SS_DELETE_MODE_INVALID');
130: fnd_message.raise_error;
131:
132: --
133: ELSE -- No Futuer versions of Record is present .
134: -- Then check for child records which has Future Effective Start Date
136: FETCH csr_future_eff_child_recs into l_eff_disp_date;
137: CLOSE csr_future_eff_child_recs;
138:
139: if (l_eff_disp_date is not null) then
140: fnd_message.set_name('PQH','PQH_SS_FTR_CHLD_RECS_PRSNT');
141: fnd_message.set_token('DATE_VALUE',l_eff_disp_date);
142: fnd_message.raise_error;
143: end if;
144:
137: CLOSE csr_future_eff_child_recs;
138:
139: if (l_eff_disp_date is not null) then
140: fnd_message.set_name('PQH','PQH_SS_FTR_CHLD_RECS_PRSNT');
141: fnd_message.set_token('DATE_VALUE',l_eff_disp_date);
142: fnd_message.raise_error;
143: end if;
144:
145: END IF;
138:
139: if (l_eff_disp_date is not null) then
140: fnd_message.set_name('PQH','PQH_SS_FTR_CHLD_RECS_PRSNT');
141: fnd_message.set_token('DATE_VALUE',l_eff_disp_date);
142: fnd_message.raise_error;
143: end if;
144:
145: END IF;
146:
150:
151: l_max_future_end_dt :=l_max_future_end_dt+1;
152:
153: IF (l_max_future_end_dt is not null) THEN
154: fnd_message.set_name('PQH','PQH_SS_FTR_ENDTD_CHLD_RECS');
155: fnd_message.set_token('DATE_VALUE',l_max_future_end_dt);
156: fnd_message.raise_error;
157: END IF;
158: --
151: l_max_future_end_dt :=l_max_future_end_dt+1;
152:
153: IF (l_max_future_end_dt is not null) THEN
154: fnd_message.set_name('PQH','PQH_SS_FTR_ENDTD_CHLD_RECS');
155: fnd_message.set_token('DATE_VALUE',l_max_future_end_dt);
156: fnd_message.raise_error;
157: END IF;
158: --
159: --
152:
153: IF (l_max_future_end_dt is not null) THEN
154: fnd_message.set_name('PQH','PQH_SS_FTR_ENDTD_CHLD_RECS');
155: fnd_message.set_token('DATE_VALUE',l_max_future_end_dt);
156: fnd_message.raise_error;
157: END IF;
158: --
159: --
160: For docAttributeCursorRow in CurRetrieveChildRecord