eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_FR_VALIDATE_DELETE_PKG dependencies on HR_UTILITY

Line 108: hr_utility.set_location('pefrorrvd package entered', 1);

104:
105: l_dummy varchar2(1);
106:
107: BEGIN
108: hr_utility.set_location('pefrorrvd package entered', 1);
109:
110: if hr_organization_units_pkg.get_org_class(X_Organization_Id, 'FR_SOCIETE') then
111: open csr_estab_comp;
112: fetch csr_estab_comp into l_dummy;

Line 113: hr_utility.set_location('FR societe!!', 10);

109:
110: if hr_organization_units_pkg.get_org_class(X_Organization_Id, 'FR_SOCIETE') then
111: open csr_estab_comp;
112: fetch csr_estab_comp into l_dummy;
113: hr_utility.set_location('FR societe!!', 10);
114: if csr_estab_comp%found then
115: hr_utility.set_location('FR societe failure!!', 10);
116: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
117: hr_utility.raise_error;

Line 115: hr_utility.set_location('FR societe failure!!', 10);

111: open csr_estab_comp;
112: fetch csr_estab_comp into l_dummy;
113: hr_utility.set_location('FR societe!!', 10);
114: if csr_estab_comp%found then
115: hr_utility.set_location('FR societe failure!!', 10);
116: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
117: hr_utility.raise_error;
118: end if;
119: close csr_estab_comp;

Line 116: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

112: fetch csr_estab_comp into l_dummy;
113: hr_utility.set_location('FR societe!!', 10);
114: if csr_estab_comp%found then
115: hr_utility.set_location('FR societe failure!!', 10);
116: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
117: hr_utility.raise_error;
118: end if;
119: close csr_estab_comp;
120: end if;

Line 117: hr_utility.raise_error;

113: hr_utility.set_location('FR societe!!', 10);
114: if csr_estab_comp%found then
115: hr_utility.set_location('FR societe failure!!', 10);
116: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
117: hr_utility.raise_error;
118: end if;
119: close csr_estab_comp;
120: end if;
121:

Line 123: hr_utility.set_location('FR centre urssaf!!', 10);

119: close csr_estab_comp;
120: end if;
121:
122: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_URSSAF') then
123: hr_utility.set_location('FR centre urssaf!!', 10);
124: open csr_estab_urssaf;
125: fetch csr_estab_urssaf into l_dummy;
126: if csr_estab_urssaf%found then
127: hr_utility.set_location('FR centre urssaf failure!!', 10);

Line 127: hr_utility.set_location('FR centre urssaf failure!!', 10);

123: hr_utility.set_location('FR centre urssaf!!', 10);
124: open csr_estab_urssaf;
125: fetch csr_estab_urssaf into l_dummy;
126: if csr_estab_urssaf%found then
127: hr_utility.set_location('FR centre urssaf failure!!', 10);
128: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
129: hr_utility.raise_error;
130: end if;
131: close csr_estab_urssaf;

Line 128: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

124: open csr_estab_urssaf;
125: fetch csr_estab_urssaf into l_dummy;
126: if csr_estab_urssaf%found then
127: hr_utility.set_location('FR centre urssaf failure!!', 10);
128: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
129: hr_utility.raise_error;
130: end if;
131: close csr_estab_urssaf;
132:

Line 129: hr_utility.raise_error;

125: fetch csr_estab_urssaf into l_dummy;
126: if csr_estab_urssaf%found then
127: hr_utility.set_location('FR centre urssaf failure!!', 10);
128: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
129: hr_utility.raise_error;
130: end if;
131: close csr_estab_urssaf;
132:
133: open csr_comp_urssaf;

Line 135: hr_utility.set_location('FR comp urssaf!!', 10);

131: close csr_estab_urssaf;
132:
133: open csr_comp_urssaf;
134: fetch csr_comp_urssaf into l_dummy;
135: hr_utility.set_location('FR comp urssaf!!', 10);
136: if csr_comp_urssaf%found then
137: hr_utility.set_location('FR comp urssaf!!', 10);
138: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
139: hr_utility.raise_error;

Line 137: hr_utility.set_location('FR comp urssaf!!', 10);

133: open csr_comp_urssaf;
134: fetch csr_comp_urssaf into l_dummy;
135: hr_utility.set_location('FR comp urssaf!!', 10);
136: if csr_comp_urssaf%found then
137: hr_utility.set_location('FR comp urssaf!!', 10);
138: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
139: hr_utility.raise_error;
140: end if;
141: close csr_comp_urssaf;

Line 138: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');

134: fetch csr_comp_urssaf into l_dummy;
135: hr_utility.set_location('FR comp urssaf!!', 10);
136: if csr_comp_urssaf%found then
137: hr_utility.set_location('FR comp urssaf!!', 10);
138: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
139: hr_utility.raise_error;
140: end if;
141: close csr_comp_urssaf;
142: end if;

Line 139: hr_utility.raise_error;

135: hr_utility.set_location('FR comp urssaf!!', 10);
136: if csr_comp_urssaf%found then
137: hr_utility.set_location('FR comp urssaf!!', 10);
138: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
139: hr_utility.raise_error;
140: end if;
141: close csr_comp_urssaf;
142: end if;
143:

Line 145: hr_utility.set_location('FR centre assedic!!', 10);

141: close csr_comp_urssaf;
142: end if;
143:
144: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_ASSEDIC') then
145: hr_utility.set_location('FR centre assedic!!', 10);
146: open csr_estab_assedic;
147: fetch csr_estab_assedic into l_dummy;
148: if csr_estab_assedic%found then
149: hr_utility.set_location('FR centre assedic failure!!', 10);

Line 149: hr_utility.set_location('FR centre assedic failure!!', 10);

145: hr_utility.set_location('FR centre assedic!!', 10);
146: open csr_estab_assedic;
147: fetch csr_estab_assedic into l_dummy;
148: if csr_estab_assedic%found then
149: hr_utility.set_location('FR centre assedic failure!!', 10);
150: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
151: hr_utility.raise_error;
152: end if;
153: close csr_estab_assedic;

Line 150: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

146: open csr_estab_assedic;
147: fetch csr_estab_assedic into l_dummy;
148: if csr_estab_assedic%found then
149: hr_utility.set_location('FR centre assedic failure!!', 10);
150: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
151: hr_utility.raise_error;
152: end if;
153: close csr_estab_assedic;
154: end if;

Line 151: hr_utility.raise_error;

147: fetch csr_estab_assedic into l_dummy;
148: if csr_estab_assedic%found then
149: hr_utility.set_location('FR centre assedic failure!!', 10);
150: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
151: hr_utility.raise_error;
152: end if;
153: close csr_estab_assedic;
154: end if;
155:

Line 157: hr_utility.set_location('FR pension!!', 9);

153: close csr_estab_assedic;
154: end if;
155:
156: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_PENSION') then
157: hr_utility.set_location('FR pension!!', 9);
158: open csr_estab_pens;
159: hr_utility.set_location('FR pension!!', 10);
160: fetch csr_estab_pens into l_dummy;
161: if csr_estab_pens%found then

Line 159: hr_utility.set_location('FR pension!!', 10);

155:
156: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_PENSION') then
157: hr_utility.set_location('FR pension!!', 9);
158: open csr_estab_pens;
159: hr_utility.set_location('FR pension!!', 10);
160: fetch csr_estab_pens into l_dummy;
161: if csr_estab_pens%found then
162: hr_utility.set_location('FR pension failure!!', 10);
163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

Line 162: hr_utility.set_location('FR pension failure!!', 10);

158: open csr_estab_pens;
159: hr_utility.set_location('FR pension!!', 10);
160: fetch csr_estab_pens into l_dummy;
161: if csr_estab_pens%found then
162: hr_utility.set_location('FR pension failure!!', 10);
163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
164: hr_utility.raise_error;
165: end if;
166: hr_utility.set_location('FR pension!!', 11);

Line 163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

159: hr_utility.set_location('FR pension!!', 10);
160: fetch csr_estab_pens into l_dummy;
161: if csr_estab_pens%found then
162: hr_utility.set_location('FR pension failure!!', 10);
163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
164: hr_utility.raise_error;
165: end if;
166: hr_utility.set_location('FR pension!!', 11);
167: close csr_estab_pens;

Line 164: hr_utility.raise_error;

160: fetch csr_estab_pens into l_dummy;
161: if csr_estab_pens%found then
162: hr_utility.set_location('FR pension failure!!', 10);
163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
164: hr_utility.raise_error;
165: end if;
166: hr_utility.set_location('FR pension!!', 11);
167: close csr_estab_pens;
168: hr_utility.set_location('FR pension!!', 12);

Line 166: hr_utility.set_location('FR pension!!', 11);

162: hr_utility.set_location('FR pension failure!!', 10);
163: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
164: hr_utility.raise_error;
165: end if;
166: hr_utility.set_location('FR pension!!', 11);
167: close csr_estab_pens;
168: hr_utility.set_location('FR pension!!', 12);
169:
170: open csr_comp_pens;

Line 168: hr_utility.set_location('FR pension!!', 12);

164: hr_utility.raise_error;
165: end if;
166: hr_utility.set_location('FR pension!!', 11);
167: close csr_estab_pens;
168: hr_utility.set_location('FR pension!!', 12);
169:
170: open csr_comp_pens;
171: hr_utility.set_location('FR pension!!', 13);
172: fetch csr_comp_pens into l_dummy;

Line 171: hr_utility.set_location('FR pension!!', 13);

167: close csr_estab_pens;
168: hr_utility.set_location('FR pension!!', 12);
169:
170: open csr_comp_pens;
171: hr_utility.set_location('FR pension!!', 13);
172: fetch csr_comp_pens into l_dummy;
173: hr_utility.set_location('FR comp pens!!', 10);
174: if csr_comp_pens%found then
175: hr_utility.set_location('FR comp pens failure!!', 10);

Line 173: hr_utility.set_location('FR comp pens!!', 10);

169:
170: open csr_comp_pens;
171: hr_utility.set_location('FR pension!!', 13);
172: fetch csr_comp_pens into l_dummy;
173: hr_utility.set_location('FR comp pens!!', 10);
174: if csr_comp_pens%found then
175: hr_utility.set_location('FR comp pens failure!!', 10);
176: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
177: hr_utility.raise_error;

Line 175: hr_utility.set_location('FR comp pens failure!!', 10);

171: hr_utility.set_location('FR pension!!', 13);
172: fetch csr_comp_pens into l_dummy;
173: hr_utility.set_location('FR comp pens!!', 10);
174: if csr_comp_pens%found then
175: hr_utility.set_location('FR comp pens failure!!', 10);
176: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
177: hr_utility.raise_error;
178: end if;
179: close csr_comp_pens;

Line 176: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');

172: fetch csr_comp_pens into l_dummy;
173: hr_utility.set_location('FR comp pens!!', 10);
174: if csr_comp_pens%found then
175: hr_utility.set_location('FR comp pens failure!!', 10);
176: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
177: hr_utility.raise_error;
178: end if;
179: close csr_comp_pens;
180: end if;

Line 177: hr_utility.raise_error;

173: hr_utility.set_location('FR comp pens!!', 10);
174: if csr_comp_pens%found then
175: hr_utility.set_location('FR comp pens failure!!', 10);
176: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
177: hr_utility.raise_error;
178: end if;
179: close csr_comp_pens;
180: end if;
181:

Line 183: hr_utility.set_location('FR assurance!!', 10);

179: close csr_comp_pens;
180: end if;
181:
182: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ASSURANCE') then
183: hr_utility.set_location('FR assurance!!', 10);
184: open csr_estab_insu;
185: fetch csr_estab_insu into l_dummy;
186: if csr_estab_insu%found then
187: hr_utility.set_location('FR assurance failure!!', 10);

Line 187: hr_utility.set_location('FR assurance failure!!', 10);

183: hr_utility.set_location('FR assurance!!', 10);
184: open csr_estab_insu;
185: fetch csr_estab_insu into l_dummy;
186: if csr_estab_insu%found then
187: hr_utility.set_location('FR assurance failure!!', 10);
188: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
189: hr_utility.raise_error;
190: end if;
191: close csr_estab_insu;

Line 188: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');

184: open csr_estab_insu;
185: fetch csr_estab_insu into l_dummy;
186: if csr_estab_insu%found then
187: hr_utility.set_location('FR assurance failure!!', 10);
188: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
189: hr_utility.raise_error;
190: end if;
191: close csr_estab_insu;
192:

Line 189: hr_utility.raise_error;

185: fetch csr_estab_insu into l_dummy;
186: if csr_estab_insu%found then
187: hr_utility.set_location('FR assurance failure!!', 10);
188: hr_utility.set_message(800,'PER_74848_ORG_DEL_EST');
189: hr_utility.raise_error;
190: end if;
191: close csr_estab_insu;
192:
193: open csr_comp_insu;

Line 195: hr_utility.set_location('FR comp insu!!', 10);

191: close csr_estab_insu;
192:
193: open csr_comp_insu;
194: fetch csr_comp_insu into l_dummy;
195: hr_utility.set_location('FR comp insu!!', 10);
196: if csr_comp_insu%found then
197: hr_utility.set_location('FR comp insu failure!!', 10);
198: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
199: hr_utility.raise_error;

Line 197: hr_utility.set_location('FR comp insu failure!!', 10);

193: open csr_comp_insu;
194: fetch csr_comp_insu into l_dummy;
195: hr_utility.set_location('FR comp insu!!', 10);
196: if csr_comp_insu%found then
197: hr_utility.set_location('FR comp insu failure!!', 10);
198: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
199: hr_utility.raise_error;
200: end if;
201: close csr_comp_insu;

Line 198: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');

194: fetch csr_comp_insu into l_dummy;
195: hr_utility.set_location('FR comp insu!!', 10);
196: if csr_comp_insu%found then
197: hr_utility.set_location('FR comp insu failure!!', 10);
198: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
199: hr_utility.raise_error;
200: end if;
201: close csr_comp_insu;
202: end if;

Line 199: hr_utility.raise_error;

195: hr_utility.set_location('FR comp insu!!', 10);
196: if csr_comp_insu%found then
197: hr_utility.set_location('FR comp insu failure!!', 10);
198: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
199: hr_utility.raise_error;
200: end if;
201: close csr_comp_insu;
202: end if;
203:

Line 205: hr_utility.set_location('FR etablissement!!', 10);

201: close csr_comp_insu;
202: end if;
203:
204: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ETABLISSEMENT') then
205: hr_utility.set_location('FR etablissement!!', 10);
206: open csr_comp_dads_estab;
207: fetch csr_comp_dads_estab into l_dummy;
208: if csr_comp_dads_estab%found then
209: hr_utility.set_location('FR etablissement failure!!', 10);

Line 209: hr_utility.set_location('FR etablissement failure!!', 10);

205: hr_utility.set_location('FR etablissement!!', 10);
206: open csr_comp_dads_estab;
207: fetch csr_comp_dads_estab into l_dummy;
208: if csr_comp_dads_estab%found then
209: hr_utility.set_location('FR etablissement failure!!', 10);
210: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
211: hr_utility.raise_error;
212: end if;
213: close csr_comp_dads_estab;

Line 210: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');

206: open csr_comp_dads_estab;
207: fetch csr_comp_dads_estab into l_dummy;
208: if csr_comp_dads_estab%found then
209: hr_utility.set_location('FR etablissement failure!!', 10);
210: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
211: hr_utility.raise_error;
212: end if;
213: close csr_comp_dads_estab;
214:

Line 211: hr_utility.raise_error;

207: fetch csr_comp_dads_estab into l_dummy;
208: if csr_comp_dads_estab%found then
209: hr_utility.set_location('FR etablissement failure!!', 10);
210: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
211: hr_utility.raise_error;
212: end if;
213: close csr_comp_dads_estab;
214:
215: open csr_comp_heaq_estab;

Line 217: hr_utility.set_location('FR comp heaq estab!!', 10);

213: close csr_comp_dads_estab;
214:
215: open csr_comp_heaq_estab;
216: fetch csr_comp_heaq_estab into l_dummy;
217: hr_utility.set_location('FR comp heaq estab!!', 10);
218: if csr_comp_heaq_estab%found then
219: hr_utility.set_location('FR comp heaq estab failure!!', 10);
220: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
221: hr_utility.raise_error;

Line 219: hr_utility.set_location('FR comp heaq estab failure!!', 10);

215: open csr_comp_heaq_estab;
216: fetch csr_comp_heaq_estab into l_dummy;
217: hr_utility.set_location('FR comp heaq estab!!', 10);
218: if csr_comp_heaq_estab%found then
219: hr_utility.set_location('FR comp heaq estab failure!!', 10);
220: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
221: hr_utility.raise_error;
222: end if;
223: close csr_comp_heaq_estab;

Line 220: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');

216: fetch csr_comp_heaq_estab into l_dummy;
217: hr_utility.set_location('FR comp heaq estab!!', 10);
218: if csr_comp_heaq_estab%found then
219: hr_utility.set_location('FR comp heaq estab failure!!', 10);
220: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
221: hr_utility.raise_error;
222: end if;
223: close csr_comp_heaq_estab;
224:

Line 221: hr_utility.raise_error;

217: hr_utility.set_location('FR comp heaq estab!!', 10);
218: if csr_comp_heaq_estab%found then
219: hr_utility.set_location('FR comp heaq estab failure!!', 10);
220: hr_utility.set_message(800,'PER_74849_ORG_DEL_COM');
221: hr_utility.raise_error;
222: end if;
223: close csr_comp_heaq_estab;
224:
225: open csr_assignments;

Line 227: hr_utility.set_location('FR assignments!!', 10);

223: close csr_comp_heaq_estab;
224:
225: open csr_assignments;
226: fetch csr_assignments into l_dummy;
227: hr_utility.set_location('FR assignments!!', 10);
228: if csr_assignments%found then
229: hr_utility.set_location('FR assignments failure!!', 10);
230: hr_utility.set_message(800,'PER_74853_ORG_DEL_ASG');
231: hr_utility.raise_error;

Line 229: hr_utility.set_location('FR assignments failure!!', 10);

225: open csr_assignments;
226: fetch csr_assignments into l_dummy;
227: hr_utility.set_location('FR assignments!!', 10);
228: if csr_assignments%found then
229: hr_utility.set_location('FR assignments failure!!', 10);
230: hr_utility.set_message(800,'PER_74853_ORG_DEL_ASG');
231: hr_utility.raise_error;
232: end if;
233: close csr_assignments;

Line 230: hr_utility.set_message(800,'PER_74853_ORG_DEL_ASG');

226: fetch csr_assignments into l_dummy;
227: hr_utility.set_location('FR assignments!!', 10);
228: if csr_assignments%found then
229: hr_utility.set_location('FR assignments failure!!', 10);
230: hr_utility.set_message(800,'PER_74853_ORG_DEL_ASG');
231: hr_utility.raise_error;
232: end if;
233: close csr_assignments;
234: end if;

Line 231: hr_utility.raise_error;

227: hr_utility.set_location('FR assignments!!', 10);
228: if csr_assignments%found then
229: hr_utility.set_location('FR assignments failure!!', 10);
230: hr_utility.set_message(800,'PER_74853_ORG_DEL_ASG');
231: hr_utility.raise_error;
232: end if;
233: close csr_assignments;
234: end if;
235:

Line 237: hr_utility.set_location('FR cpam!!', 10);

233: close csr_assignments;
234: end if;
235:
236: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CPAM' )then
237: hr_utility.set_location('FR cpam!!', 10);
238: open csr_cpam;
239: fetch csr_cpam into l_dummy;
240: if csr_cpam%found then
241: hr_utility.set_location('FR cpam failure!!', 10);

Line 241: hr_utility.set_location('FR cpam failure!!', 10);

237: hr_utility.set_location('FR cpam!!', 10);
238: open csr_cpam;
239: fetch csr_cpam into l_dummy;
240: if csr_cpam%found then
241: hr_utility.set_location('FR cpam failure!!', 10);
242: hr_utility.set_message(800,'PER_74852_ORG_DEL_PER');
243: hr_utility.raise_error;
244: end if;
245: close csr_cpam;

Line 242: hr_utility.set_message(800,'PER_74852_ORG_DEL_PER');

238: open csr_cpam;
239: fetch csr_cpam into l_dummy;
240: if csr_cpam%found then
241: hr_utility.set_location('FR cpam failure!!', 10);
242: hr_utility.set_message(800,'PER_74852_ORG_DEL_PER');
243: hr_utility.raise_error;
244: end if;
245: close csr_cpam;
246: end if;

Line 243: hr_utility.raise_error;

239: fetch csr_cpam into l_dummy;
240: if csr_cpam%found then
241: hr_utility.set_location('FR cpam failure!!', 10);
242: hr_utility.set_message(800,'PER_74852_ORG_DEL_PER');
243: hr_utility.raise_error;
244: end if;
245: close csr_cpam;
246: end if;
247: hr_utility.set_location('end of pefrorvd package', 10);

Line 247: hr_utility.set_location('end of pefrorvd package', 10);

243: hr_utility.raise_error;
244: end if;
245: close csr_cpam;
246: end if;
247: hr_utility.set_location('end of pefrorvd package', 10);
248:
249: end validate_delete;
250: --
251: END PER_FR_VALIDATE_DELETE_PKG;