DBA Data[Home] [Help]

APPS.HR_QSA_BUS dependencies on FND_MESSAGE

Line 144: fnd_message.set_name('PER','PER_52430_QSA_MAND_TEMPLATE');

140: hr_utility.set_location('Entering: '||l_proc, 10);
141: --
142: if p_questionnaire_template_id is null then
143: -- Item is a mandatory parameter, thus error.
144: fnd_message.set_name('PER','PER_52430_QSA_MAND_TEMPLATE');
145: fnd_message.raise_error;
146: else
147: hr_utility.set_location(l_proc,20);
148: --

Line 145: fnd_message.raise_error;

141: --
142: if p_questionnaire_template_id is null then
143: -- Item is a mandatory parameter, thus error.
144: fnd_message.set_name('PER','PER_52430_QSA_MAND_TEMPLATE');
145: fnd_message.raise_error;
146: else
147: hr_utility.set_location(l_proc,20);
148: --
149: -- Check item exists in hr_questionnaires.

Line 170: fnd_message.set_name('PER','PER_52431_QSA_INVAL_TEMP_ID');

166: if csr_appraisal_valid%NOTFOUND then
167: -- Invalid questionnaire_template_id, according to
168: -- per_appraisal_templates and per_appraisals.
169: close csr_appraisal_valid;
170: fnd_message.set_name('PER','PER_52431_QSA_INVAL_TEMP_ID');
171: fnd_message.raise_error;
172: end if;
173: close csr_appraisal_valid;
174: --

Line 171: fnd_message.raise_error;

167: -- Invalid questionnaire_template_id, according to
168: -- per_appraisal_templates and per_appraisals.
169: close csr_appraisal_valid;
170: fnd_message.set_name('PER','PER_52431_QSA_INVAL_TEMP_ID');
171: fnd_message.raise_error;
172: end if;
173: close csr_appraisal_valid;
174: --
175: hr_utility.set_location(l_proc,40);

Line 198: fnd_message.set_name('PER','PER_52440_QSA_TEMPLT_NOT_IN_BG');

194: -- Check that business group = questionnaire templates business group.
195: /*
196: if l_bus_grp_id <> p_business_group_id then
197: -- Invalid business group
198: fnd_message.set_name('PER','PER_52440_QSA_TEMPLT_NOT_IN_BG');
199: fnd_message.raise_error;
200: end if;
201: */
202: --

Line 199: fnd_message.raise_error;

195: /*
196: if l_bus_grp_id <> p_business_group_id then
197: -- Invalid business group
198: fnd_message.set_name('PER','PER_52440_QSA_TEMPLT_NOT_IN_BG');
199: fnd_message.raise_error;
200: end if;
201: */
202: --
203: hr_utility.set_location(l_proc,70);

Line 238: fnd_message.set_name('PER','PER_52432_QSA_MAND_TYPE');

234: hr_qsa_shd.constraint_error('HR_QUEST_ANS_TYPE_CHK');
235: end if;
236: else
237: -- p_type is null
238: fnd_message.set_name('PER','PER_52432_QSA_MAND_TYPE');
239: fnd_message.raise_error;
240: end if;
241: --
242: hr_utility.set_location('Leaving: '||l_proc,20);

Line 239: fnd_message.raise_error;

235: end if;
236: else
237: -- p_type is null
238: fnd_message.set_name('PER','PER_52432_QSA_MAND_TYPE');
239: fnd_message.raise_error;
240: end if;
241: --
242: hr_utility.set_location('Leaving: '||l_proc,20);
243: --

Line 293: fnd_message.set_name('PER','PER_52433_QSA_MAND_OBJECT_ID');

289: hr_utility.set_location('Entering: '||l_proc, 10);
290: --
291: if p_type_object_id is null then
292: -- type_object_id is mandatory, thus raise error.
293: fnd_message.set_name('PER','PER_52433_QSA_MAND_OBJECT_ID');
294: fnd_message.raise_error;
295: else
296: -- Check that type_object_id is unique.
297: open csr_unique_id;

Line 294: fnd_message.raise_error;

290: --
291: if p_type_object_id is null then
292: -- type_object_id is mandatory, thus raise error.
293: fnd_message.set_name('PER','PER_52433_QSA_MAND_OBJECT_ID');
294: fnd_message.raise_error;
295: else
296: -- Check that type_object_id is unique.
297: open csr_unique_id;
298: fetch csr_unique_id into l_exists;

Line 317: fnd_message.set_name('PER','PER_52434_QSA_INVAL_TYPE_OBJ');

313: fetch csr_type_appraisal into l_bus_grp_id;
314: if csr_type_appraisal%NOTFOUND then
315: -- type_object_id doesnt exist as an appraisal_id
316: close csr_type_appraisal;
317: fnd_message.set_name('PER','PER_52434_QSA_INVAL_TYPE_OBJ');
318: fnd_message.raise_error;
319: else
320: --
321: hr_utility.set_location(l_proc,40);

Line 318: fnd_message.raise_error;

314: if csr_type_appraisal%NOTFOUND then
315: -- type_object_id doesnt exist as an appraisal_id
316: close csr_type_appraisal;
317: fnd_message.set_name('PER','PER_52434_QSA_INVAL_TYPE_OBJ');
318: fnd_message.raise_error;
319: else
320: --
321: hr_utility.set_location(l_proc,40);
322: --

Line 326: fnd_message.set_name('PER','PER_52435_QSA_OBJ_NOT_IN_BG');

322: --
323: close csr_type_appraisal;
324: if l_bus_grp_id <> p_business_group_id then
325: -- Appraisal doesnt exist in the given business group
326: fnd_message.set_name('PER','PER_52435_QSA_OBJ_NOT_IN_BG');
327: fnd_message.raise_error;
328: end if;
329: end if;
330: elsif p_type = 'PARTICIPANT' then

Line 327: fnd_message.raise_error;

323: close csr_type_appraisal;
324: if l_bus_grp_id <> p_business_group_id then
325: -- Appraisal doesnt exist in the given business group
326: fnd_message.set_name('PER','PER_52435_QSA_OBJ_NOT_IN_BG');
327: fnd_message.raise_error;
328: end if;
329: end if;
330: elsif p_type = 'PARTICIPANT' then
331: --

Line 342: fnd_message.set_name('PER','PER_52436_QSA_OBJ_ID_INVALID');

338: into l_bus_grp_id, l_part_in_tab, l_part_in_col;
339: if csr_type_participant%NOTFOUND then
340: -- type object_id doesnt exist as a participant_id
341: close csr_type_participant;
342: fnd_message.set_name('PER','PER_52436_QSA_OBJ_ID_INVALID');
343: fnd_message.raise_error;
344: else
345: close csr_type_participant;
346: --

Line 343: fnd_message.raise_error;

339: if csr_type_participant%NOTFOUND then
340: -- type object_id doesnt exist as a participant_id
341: close csr_type_participant;
342: fnd_message.set_name('PER','PER_52436_QSA_OBJ_ID_INVALID');
343: fnd_message.raise_error;
344: else
345: close csr_type_participant;
346: --
347: hr_utility.set_location(l_proc,60);

Line 352: fnd_message.set_name('PER','PER_52437_QSA_OBJ_NOT_IN_BG');

348: -- bug 1980440 fix starts
349: if lv_cross_business_group <> 'Y' THEN
350: if l_bus_grp_id <> p_business_group_id then
351: -- Participant doesnt exist in the given business group
352: fnd_message.set_name('PER','PER_52437_QSA_OBJ_NOT_IN_BG');
353: fnd_message.raise_error;
354: end if;
355: end if;
356: -- bug 1980440 fix ends

Line 353: fnd_message.raise_error;

349: if lv_cross_business_group <> 'Y' THEN
350: if l_bus_grp_id <> p_business_group_id then
351: -- Participant doesnt exist in the given business group
352: fnd_message.set_name('PER','PER_52437_QSA_OBJ_NOT_IN_BG');
353: fnd_message.raise_error;
354: end if;
355: end if;
356: -- bug 1980440 fix ends
357: --

Line 363: fnd_message.set_name('PER','PER_52438_QSA_OBJ_NOT_IN_APR');

359: --
360: if (l_part_in_tab <> 'PER_APPRAISALS') and
361: (l_part_in_col <> 'APPRAISAL_ID') then
362: -- Invalid combination, raise error.
363: fnd_message.set_name('PER','PER_52438_QSA_OBJ_NOT_IN_APR');
364: fnd_message.raise_error;
365: end if;
366: end if;
367: else

Line 364: fnd_message.raise_error;

360: if (l_part_in_tab <> 'PER_APPRAISALS') and
361: (l_part_in_col <> 'APPRAISAL_ID') then
362: -- Invalid combination, raise error.
363: fnd_message.set_name('PER','PER_52438_QSA_OBJ_NOT_IN_APR');
364: fnd_message.raise_error;
365: end if;
366: end if;
367: else
368: --

Line 371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

367: else
368: --
369: hr_utility.set_location(l_proc,80);
370: --
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE',l_proc);
373: fnd_message.set_token('STEP','80');
374: fnd_message.raise_error;
375: end if;

Line 372: fnd_message.set_token('PROCEDURE',l_proc);

368: --
369: hr_utility.set_location(l_proc,80);
370: --
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE',l_proc);
373: fnd_message.set_token('STEP','80');
374: fnd_message.raise_error;
375: end if;
376: --

Line 373: fnd_message.set_token('STEP','80');

369: hr_utility.set_location(l_proc,80);
370: --
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE',l_proc);
373: fnd_message.set_token('STEP','80');
374: fnd_message.raise_error;
375: end if;
376: --
377: hr_utility.set_location('Leaving: '||l_proc,90);

Line 374: fnd_message.raise_error;

370: --
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE',l_proc);
373: fnd_message.set_token('STEP','80');
374: fnd_message.raise_error;
375: end if;
376: --
377: hr_utility.set_location('Leaving: '||l_proc,90);
378: end if;

Line 417: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');

413: fetch csr_chk_child_row into l_exists;
414: if csr_chk_child_row%FOUND then
415: -- Raise error, as child row exists
416: close csr_chk_child_row;
417: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');
418: fnd_message.raise_error;
419: end if;
420: close csr_chk_child_row;
421: --

Line 418: fnd_message.raise_error;

414: if csr_chk_child_row%FOUND then
415: -- Raise error, as child row exists
416: close csr_chk_child_row;
417: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');
418: fnd_message.raise_error;
419: end if;
420: close csr_chk_child_row;
421: --
422: hr_utility.set_location('Leaving: '||l_proc, 20);

Line 546: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

542: --
543: -- The primary key is invalid, therefore we must error
544: --
545: close csr_leg_code;
546: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
547: fnd_message.raise_error;
548: end if;
549: hr_utility.set_location(l_proc,30);
550: --

Line 547: fnd_message.raise_error;

543: -- The primary key is invalid, therefore we must error
544: --
545: close csr_leg_code;
546: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
547: fnd_message.raise_error;
548: end if;
549: hr_utility.set_location(l_proc,30);
550: --
551: -- Set the global variable so the values are available for the