DBA Data[Home] [Help]

APPS.PQH_STS_BUS dependencies on HR_GENERAL

Line 409: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FREQUENCY'));

405:
406: if csr_frequency%NOTFOUND then
407: --
408: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
409: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FREQUENCY'));
410:
411: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');
412: end if;
413: --

Line 500: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','REASON'));

496:
497: if csr_reason%NOTFOUND then
498: --
499: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
500: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','REASON'));
501:
502: hr_multi_message.add
503: (p_associated_column1=> 'REASON');
504: end if;

Line 538: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','LOCATION'));

534:
535: if csr_location%NOTFOUND then
536: --
537: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
538: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','LOCATION'));
539:
540: hr_multi_message.add
541: (p_associated_column1
542: => 'LOCATION');

Line 579: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SOURCE'));

575:
576: if csr_source%NOTFOUND then
577: --
578: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
579: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SOURCE'));
580:
581: hr_multi_message.add
582: (p_associated_column1
583: => 'SOURCE');

Line 620: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SUB_TYPE'));

616:
617: If csr_sub_type%NOTFOUND then
618: --
619: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
620: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SUB_TYPE'));
621: hr_multi_message.add
622: (p_associated_column1
623: => 'SUB_TYPE_NAME');
624: --

Line 643: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));

639:
640: if (p_pay_share < 0 or p_pay_share >100) then
641: --
642: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
643: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));
644: hr_multi_message.add
645: (p_associated_column1
646: => 'PAY_SHARE');
647: --

Line 651: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));

647: --
648: elsif (p_pay_share >0 and p_remuneration_paid = 'N') then
649: --
650: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');
651: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_SHARE'));
652: hr_multi_message.add
653: (p_associated_column1=> 'REMUNERATION_PAID');
654:
655: hr_multi_message.end_validation_set;

Line 674: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));

670:
671: if (p_pay_periods < 0) then
672: --
673: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
674: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));
675: hr_multi_message.add
676: (p_associated_column1
677: => 'PAY_PERIODS');
678: --

Line 682: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));

678: --
679: elsif (p_pay_periods >0 and p_remuneration_paid = 'N') then
680: --
681: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');
682: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','PAY_PERIODS'));
683: hr_multi_message.add
684: (p_associated_column1=> 'REMUNERATION_PAID');
685: --
686: end if;

Line 703: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FIRST_PERIOD_MAX_DURATION'));

699:
700: if (p_first_period_max_duration < 0) then
701: --
702: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
703: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','FIRST_PERIOD_MAX_DURATION'));
704: hr_multi_message.add
705: (p_associated_column1
706: => 'FIRST_PERIOD_MAX_DURATION');
707: --

Line 724: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MIN_DURATION_PER_REQUEST'));

720:
721: if (p_min_duration_per_request < 0) then
722: --
723: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
724: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MIN_DURATION_PER_REQUEST'));
725: hr_multi_message.add
726: (p_associated_column1
727: => 'MIN_DURATION_PER_REQUEST');
728: --

Line 745: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_REQUEST'));

741:
742: if (p_max_duration_per_request < 0) then
743: --
744: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
745: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_REQUEST'));
746: hr_multi_message.add
747: (p_associated_column1
748: => 'MAX_DURATION_PER_REQUEST');
749: --

Line 766: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_WHOLE_CAREER'));

762:
763: if (p_max_duration_whole_career < 0) then
764: --
765: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
766: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_WHOLE_CAREER'));
767: hr_multi_message.add
768: (p_associated_column1
769: => 'MAX_DURATION_WHOLE_CAREER');
770: --

Line 788: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));

784:
785: if (p_max_no_of_renewals < 0) then
786: --
787: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
788: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));
789: hr_multi_message.add
790: (p_associated_column1
791: => 'MAX_NO_OF_RENEWALS');
792: --

Line 797: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));

793: elsif (p_max_no_of_renewals > 0 and p_renewable_allowed = 'N' ) then
794: --
795: --
796: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');
797: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_NO_OF_RENEWALS'));
798: hr_multi_message.add
799: (p_associated_column1
800: => 'RENEWABLE_ALLOWED');
801:

Line 823: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));

819:
820: if (p_max_duration_per_renewal < 0) then
821: --
822: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
823: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));
824: hr_multi_message.add
825: (p_associated_column1
826: => 'MAX_DURATION_PER_RENEWAL');
827: --

Line 832: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));

828: elsif (p_max_duration_per_renewal > 0 and p_renewable_allowed = 'N' ) then
829: --
830: --
831: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');
832: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_DURATION_PER_RENEWAL'));
833: hr_multi_message.add
834: (p_associated_column1
835: => 'RENEWABLE_ALLOWED');
836: --

Line 854: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_TOT_CONTINUOUS_DURATION'));

850: if (p_max_tot_continuous_duration is not null
851: and p_max_tot_continuous_duration < 0 ) then
852: --
853: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
854: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','MAX_TOT_CONTINUOUS_DURATION'));
855: hr_multi_message.add
856: (p_associated_column1
857: => ' MAX_TOT_CONTINUOUS_DURATION');
858: --

Line 936: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','TYPE_OF_PS'));

932:
933: if csr_type_of_ps%NOTFOUND then
934: --
935: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
936: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','TYPE_OF_PS'));
937: hr_multi_message.add
938: (p_associated_column1 => 'TYPE_OF_PS');
939:
940: end if;

Line 975: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SITUATION_TYPE'));

971:
972: if csr_situation_type%NOTFOUND then
973: --
974: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
975: fnd_message.set_token('ATTRIBUTE',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS','SITUATION_TYPE'));
976: hr_multi_message.add
977: (p_associated_column1 => 'SITUATION_TYPE');
978:
979: end if;