[Home] [Help]
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: );
66: --
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: --
422: Close csr_record_type;
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:
448: --
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:
474: --
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: --
503: Close csr_INM_record_existence;
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;
533: --
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: --
565: Close csr_ind_existance;
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:
597:
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;
624: --
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;
654: --
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:
670: --
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;
686:
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;
702:
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;
719: --
743: (p_business_group_id => nvl(hr_general.get_business_group_id,0) );
744:
745: chk_unique_insert(p_rec.gross_index);
746:
747: hr_multi_message.end_validation_set;
748:
749: chk_record_type ( p_rec.type_of_record );
750:
751: chk_currency (p_rec.currency_code);
777: chk_is_negetive_II_rate(p_rec.increased_index);
778: --
779: End if;
780:
781: hr_multi_message.end_validation_set;
782:
783: --
784: -- Validate Dependent Attributes
785: --
790: chk_INM_values_inputted(p_rec.type_of_record ,
791: p_rec.housing_indemnity_rate ,
792: p_rec.basic_salary_rate );
793:
794: hr_multi_message.end_validation_set;
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: End insert_validate;
798: --
819: (p_business_group_id => nvl(hr_general.get_business_group_id,0) );
820:
821: chk_unique_update(p_rec.gross_index,p_rec.increased_index,p_rec.global_index_id);
822:
823: hr_multi_message.end_validation_set;
824:
825:
826: If (p_rec.type_of_record = 'INM') then
827: --
857: chk_INM_values_inputted(p_rec.type_of_record ,
858: p_rec.housing_indemnity_rate ,
859: p_rec.basic_salary_rate );
860:
861: hr_multi_message.end_validation_set;
862:
863: --
864: -- Call the datetrack update integrity operation
865: --