DBA Data[Home] [Help]

APPS.PAY_CAL_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

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

190: (p_cost_allocation_id => p_rec.cost_allocation_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;

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

191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --

Line 196: fnd_message.set_token('STEP ', '5');

192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- p_cost_allocation_id

Line 197: fnd_message.raise_error;

193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- p_cost_allocation_id
201: --

Line 273: fnd_message.set_name('PAY', 'PAY_50982_INVALID_COST_KEYFLEX');

269: open csr_combination_exists;
270: fetch csr_combination_exists into l_exists;
271: if csr_combination_exists%notfound then
272: close csr_combination_exists;
273: fnd_message.set_name('PAY', 'PAY_50982_INVALID_COST_KEYFLEX');
274: fnd_message.raise_error;
275: end if;
276: close csr_combination_exists;
277: End chk_cost_allocation_keyflex_id;

Line 274: fnd_message.raise_error;

270: fetch csr_combination_exists into l_exists;
271: if csr_combination_exists%notfound then
272: close csr_combination_exists;
273: fnd_message.set_name('PAY', 'PAY_50982_INVALID_COST_KEYFLEX');
274: fnd_message.raise_error;
275: end if;
276: close csr_combination_exists;
277: End chk_cost_allocation_keyflex_id;
278: --

Line 317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');

313: open csr_assignment_exists;
314: fetch csr_assignment_exists into l_exists;
315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;

Line 318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);

314: fetch csr_assignment_exists into l_exists;
315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;
322: End chk_assignment_id;

Line 319: fnd_message.raise_error;

315: if csr_assignment_exists%notfound then
316: close csr_assignment_exists;
317: fnd_message.set_name('PAY', 'HR_7467_PLK_NOT_ELGBLE_ASS_ID');
318: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
319: fnd_message.raise_error;
320: end if;
321: close csr_assignment_exists;
322: End chk_assignment_id;
323: --

Line 349: fnd_message.set_name('PAY', 'PAY_50983_INVALID_PROPORTION');

345: if ((nvl(pay_cal_shd.g_old_rec.proportion,hr_api.g_number) <> p_proportion)
346: or (p_cost_allocation_id is null)) then
347: --
348: if p_proportion not between 0 and 1 then
349: fnd_message.set_name('PAY', 'PAY_50983_INVALID_PROPORTION');
350: fnd_message.raise_error;
351: end if;
352: --
353: end if;

Line 350: fnd_message.raise_error;

346: or (p_cost_allocation_id is null)) then
347: --
348: if p_proportion not between 0 and 1 then
349: fnd_message.set_name('PAY', 'PAY_50983_INVALID_PROPORTION');
350: fnd_message.raise_error;
351: end if;
352: --
353: end if;
354: --

Line 490: fnd_message.set_name('PER','HR_6645_ASS_COST_DUPL');

486: fetch csr_duplicate_cost_keyflex into l_exists;
487: if csr_duplicate_cost_keyflex%found then
488: close csr_duplicate_cost_keyflex;
489:
490: fnd_message.set_name('PER','HR_6645_ASS_COST_DUPL');
491: fnd_message.raise_error;
492:
493: end if;
494: close csr_duplicate_cost_keyflex;

Line 491: fnd_message.raise_error;

487: if csr_duplicate_cost_keyflex%found then
488: close csr_duplicate_cost_keyflex;
489:
490: fnd_message.set_name('PER','HR_6645_ASS_COST_DUPL');
491: fnd_message.raise_error;
492:
493: end if;
494: close csr_duplicate_cost_keyflex;
495: end if;

Line 573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

569: --
570: -- A referential integrity check was violated therefore
571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --

Line 574: fnd_message.set_token('TABLE_NAME', l_table_name);

570: -- A referential integrity check was violated therefore
571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --
578: -- An unhandled or unexpected error has occurred which

Line 575: fnd_message.raise_error;

571: -- we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
574: fnd_message.set_token('TABLE_NAME', l_table_name);
575: fnd_message.raise_error;
576: When Others Then
577: --
578: -- An unhandled or unexpected error has occurred which
579: -- we must report

Line 581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

577: --
578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;

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

578: -- An unhandled or unexpected error has occurred which
579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --

Line 583: fnd_message.set_token('STEP','15');

579: -- we must report
580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------

Line 584: fnd_message.raise_error;

580: --
581: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582: fnd_message.set_token('PROCEDURE', l_proc);
583: fnd_message.set_token('STEP','15');
584: fnd_message.raise_error;
585: End dt_update_validate;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |--------------------------< dt_delete_validate >--------------------------|

Line 680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

676: --
677: -- A referential integrity check was violated therefore
678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --

Line 681: fnd_message.set_token('TABLE_NAME', l_table_name);

677: -- A referential integrity check was violated therefore
678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --
685: -- An unhandled or unexpected error has occurred which

Line 682: fnd_message.raise_error;

678: -- we must error
679: --
680: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME', l_table_name);
682: fnd_message.raise_error;
683: When Others Then
684: --
685: -- An unhandled or unexpected error has occurred which
686: -- we must report

Line 688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

684: --
685: -- An unhandled or unexpected error has occurred which
686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --

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

685: -- An unhandled or unexpected error has occurred which
686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;

Line 690: fnd_message.set_token('STEP','15');

686: -- we must report
687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;
694: --

Line 691: fnd_message.raise_error;

687: --
688: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
689: fnd_message.set_token('PROCEDURE', l_proc);
690: fnd_message.set_token('STEP','15');
691: fnd_message.raise_error;
692: --
693: End dt_delete_validate;
694: --
695: -- ----------------------------------------------------------------------------