DBA Data[Home] [Help]

APPS.PQH_GIN_BUS dependencies on FND_MESSAGE

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

57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: hr_multi_message.add
63: (p_associated_column1
64: => nvl(p_associated_column1,'GLOBAL_INDEX_ID')
65: );

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

136: --
137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --

Line 141: fnd_message.raise_error;

137: -- The primary key is invalid therefore we must error
138: --
139: close csr_leg_code;
140: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: end if;
143: hr_utility.set_location(l_proc,30);
144: --
145: -- Set the global variables so the values are

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

196: (p_global_index_id => p_rec.global_index_id
197: ,p_effective_date => p_effective_date
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;

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

197: ,p_effective_date => p_effective_date
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205:

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

198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205:
206: -- GROSS_INDEX

Line 203: fnd_message.raise_error;

199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205:
206: -- GROSS_INDEX
207:

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

288: --
289: -- An unhandled or unexpected error has occurred which
290: -- we must report
291: --
292: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
293: fnd_message.set_token('PROCEDURE', l_proc);
294: fnd_message.set_token('STEP','15');
295: fnd_message.raise_error;
296: End dt_update_validate;

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

289: -- An unhandled or unexpected error has occurred which
290: -- we must report
291: --
292: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
293: fnd_message.set_token('PROCEDURE', l_proc);
294: fnd_message.set_token('STEP','15');
295: fnd_message.raise_error;
296: End dt_update_validate;
297: --

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

290: -- we must report
291: --
292: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
293: fnd_message.set_token('PROCEDURE', l_proc);
294: fnd_message.set_token('STEP','15');
295: fnd_message.raise_error;
296: End dt_update_validate;
297: --
298: -- ----------------------------------------------------------------------------

Line 295: fnd_message.raise_error;

291: --
292: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
293: fnd_message.set_token('PROCEDURE', l_proc);
294: fnd_message.set_token('STEP','15');
295: fnd_message.raise_error;
296: End dt_update_validate;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |--------------------------< dt_delete_validate >--------------------------|

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

385: --
386: -- An unhandled or unexpected error has occurred which
387: -- we must report
388: --
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','15');
392: fnd_message.raise_error;
393: --

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

386: -- An unhandled or unexpected error has occurred which
387: -- we must report
388: --
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','15');
392: fnd_message.raise_error;
393: --
394: End dt_delete_validate;

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

387: -- we must report
388: --
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','15');
392: fnd_message.raise_error;
393: --
394: End dt_delete_validate;
395: --

Line 392: fnd_message.raise_error;

388: --
389: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE', l_proc);
391: fnd_message.set_token('STEP','15');
392: fnd_message.raise_error;
393: --
394: End dt_delete_validate;
395: --
396: -- Check procedures

Line 417: fnd_message.set_name('PQH','PQH_FR_INVALID_INDICES_TYPE');

413: Fetch csr_record_type into l_value;
414:
415: If (csr_record_type%NOTFOUND) then
416: --
417: fnd_message.set_name('PQH','PQH_FR_INVALID_INDICES_TYPE');
418: hr_multi_message.add (p_associated_column1 => 'TYPE_OF_RECORD');
419: --
420: End If;
421: --

Line 443: fnd_message.set_name('PQH','PQH_FR_INVALID_INM_VALUES');

439: --
440: If (p_gross_index is not null or
441: p_increased_index is not null) then
442: --
443: fnd_message.set_name('PQH','PQH_FR_INVALID_INM_VALUES');
444: hr_multi_message.add;
445: --
446: End if;
447:

Line 469: fnd_message.set_name('PQH','PQH_FR_INVALID_IND_VALUES');

465: --
466: If (p_housing_indemnity_rate is not null or
467: p_basic_salary_rate is not null) then
468: --
469: fnd_message.set_name('PQH','PQH_FR_INVALID_IND_VALUES');
470: hr_multi_message.add;
471: --
472: End if;
473:

Line 498: fnd_message.set_name('PQH','PQH_FR_NO_SECOND_INM_ROW');

494: Fetch csr_INM_record_existence into l_value;
495:
496: If csr_INM_record_existence%FOUND then
497: --
498: fnd_message.set_name('PQH','PQH_FR_NO_SECOND_INM_ROW');
499: hr_multi_message.add;
500: --
501: End If;
502: --

Line 528: fnd_message.set_name('PQH','PQH_FR_INVALID_CURRENCY');

524: --
525: Fetch csr_currency into l_value;
526:
527: If csr_currency%notfound then
528: fnd_message.set_name('PQH','PQH_FR_INVALID_CURRENCY');
529: hr_multi_message.add;
530: End if;
531: --
532: Close csr_currency;

Line 559: fnd_message.set_name('PQH','PQH_FR_NO_INDM_RATES');

555: Fetch csr_ind_existance into l_value;
556:
557: If csr_ind_existance%NOTFOUND then
558: --
559: fnd_message.set_name('PQH','PQH_FR_NO_INDM_RATES');
560: fnd_message.set_token('DATE',p_effective_date);
561: hr_multi_message.add;
562: --
563: End if;

Line 560: fnd_message.set_token('DATE',p_effective_date);

556:
557: If csr_ind_existance%NOTFOUND then
558: --
559: fnd_message.set_name('PQH','PQH_FR_NO_INDM_RATES');
560: fnd_message.set_token('DATE',p_effective_date);
561: hr_multi_message.add;
562: --
563: End if;
564: --

Line 592: fnd_message.set_name('PQH','PQH_FR_STEPS_EXIST_FOR_INDEX');

588: Select pqh_corps_utility.chk_steps_exist_for_index(l_gross_index) into l_exists from dual;
589:
590: if (l_exists = 'Y') then
591: --
592: fnd_message.set_name('PQH','PQH_FR_STEPS_EXIST_FOR_INDEX');
593: hr_multi_message.add;
594: --
595: End if;
596:

Line 618: fnd_message.set_name('PQH','PQH_FR_RECORD_IB_EXIST');

614: Fetch csr_unique into l_value;
615:
616: If csr_unique%found Then
617: --
618: fnd_message.set_name('PQH','PQH_FR_RECORD_IB_EXIST');
619: fnd_message.set_token('IB',p_gross_index);
620: hr_multi_message.add;
621:
622: --

Line 619: fnd_message.set_token('IB',p_gross_index);

615:
616: If csr_unique%found Then
617: --
618: fnd_message.set_name('PQH','PQH_FR_RECORD_IB_EXIST');
619: fnd_message.set_token('IB',p_gross_index);
620: hr_multi_message.add;
621:
622: --
623: End if;

Line 647: fnd_message.set_name('PQH','PQH_FR_RECORD_COMB_EXIST');

643: Fetch csr_unique into l_value;
644:
645: If csr_unique%found Then
646: --
647: fnd_message.set_name('PQH','PQH_FR_RECORD_COMB_EXIST');
648: fnd_message.set_token('IB',p_gross_index);
649: fnd_message.set_token('INM',p_increased_index);
650: hr_multi_message.add;
651:

Line 648: fnd_message.set_token('IB',p_gross_index);

644:
645: If csr_unique%found Then
646: --
647: fnd_message.set_name('PQH','PQH_FR_RECORD_COMB_EXIST');
648: fnd_message.set_token('IB',p_gross_index);
649: fnd_message.set_token('INM',p_increased_index);
650: hr_multi_message.add;
651:
652: --

Line 649: fnd_message.set_token('INM',p_increased_index);

645: If csr_unique%found Then
646: --
647: fnd_message.set_name('PQH','PQH_FR_RECORD_COMB_EXIST');
648: fnd_message.set_token('IB',p_gross_index);
649: fnd_message.set_token('INM',p_increased_index);
650: hr_multi_message.add;
651:
652: --
653: End if;

Line 665: fnd_message.set_name('PQH','PQH_FR_NO_NEG_BS_RATE');

661: Begin
662:
663: If (round(p_basic_salary_rate,3) <= 0) then
664: --
665: fnd_message.set_name('PQH','PQH_FR_NO_NEG_BS_RATE');
666: hr_multi_message.add;
667: --
668: End if;
669:

Line 681: fnd_message.set_name('PQH','PQH_FR_NO_NEG_HI_RATE');

677: Begin
678: If (round(p_housing_indemnity_rate,3) <= 0) then
679: --
680:
681: fnd_message.set_name('PQH','PQH_FR_NO_NEG_HI_RATE');
682: hr_multi_message.add;
683:
684: --
685: End if;

Line 697: fnd_message.set_name('PQH','PQH_FR_NO_NEG_GI_RATE');

693: --
694: Begin
695: If (p_gross_index <= 0 ) then
696: --
697: fnd_message.set_name('PQH','PQH_FR_NO_NEG_GI_RATE');
698: hr_multi_message.add;
699:
700: --
701: End if;

Line 714: fnd_message.set_name('PQH','PQH_FR_NO_NEG_II_RATE');

710: --
711: Begin
712: If (p_increased_index <= 0 ) then
713: --
714: fnd_message.set_name('PQH','PQH_FR_NO_NEG_II_RATE');
715: hr_multi_message.add;
716:
717: --
718: End if;