eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_STS_BUS dependencies on FND_MESSAGE

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

66: close csr_sec_grp;
67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: hr_multi_message.add
72: (p_associated_column1
73: => nvl(p_associated_column1,'STATUTORY_SITUATION_ID')
74: );

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

160: --
161: -- The primary key is invalid therefore we must error
162: --
163: close csr_leg_code;
164: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
165: fnd_message.raise_error;
166: end if;
167:
168: if g_debug then

Line 165: fnd_message.raise_error;

161: -- The primary key is invalid therefore we must error
162: --
163: close csr_leg_code;
164: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
165: fnd_message.raise_error;
166: end if;
167:
168: if g_debug then
169: --

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

231: IF NOT pqh_sts_shd.api_updating
232: (p_statutory_situation_id => p_rec.statutory_situation_id
233: ,p_object_version_number => p_rec.object_version_number
234: ) THEN
235: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
236: fnd_message.set_token('PROCEDURE ', l_proc);
237: fnd_message.set_token('STEP ', '5');
238: fnd_message.raise_error;
239: END IF;

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

232: (p_statutory_situation_id => p_rec.statutory_situation_id
233: ,p_object_version_number => p_rec.object_version_number
234: ) THEN
235: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
236: fnd_message.set_token('PROCEDURE ', l_proc);
237: fnd_message.set_token('STEP ', '5');
238: fnd_message.raise_error;
239: END IF;
240:

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

233: ,p_object_version_number => p_rec.object_version_number
234: ) THEN
235: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
236: fnd_message.set_token('PROCEDURE ', l_proc);
237: fnd_message.set_token('STEP ', '5');
238: fnd_message.raise_error;
239: END IF;
240:
241: if nvl(p_rec.business_group_id, hr_api.g_number) <>

Line 238: fnd_message.raise_error;

234: ) THEN
235: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
236: fnd_message.set_token('PROCEDURE ', l_proc);
237: fnd_message.set_token('STEP ', '5');
238: fnd_message.raise_error;
239: END IF;
240:
241: if nvl(p_rec.business_group_id, hr_api.g_number) <>
242: nvl(pqh_sts_shd.g_old_rec.business_group_id

Line 346: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');

342:
343: if (p_renewable_allowed = 'N') then
344: --
345:
346: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
347: fnd_message.set_token('ATTRIBUTE','MAX_NO_OF_RENEWALS');
348:
349: hr_multi_message.add(p_associated_column1=> 'MAX_NO_OF_RENEWALS',
350: p_associated_column2=> 'MAX_DURATION_PER_RENEWAL');

Line 347: fnd_message.set_token('ATTRIBUTE','MAX_NO_OF_RENEWALS');

343: if (p_renewable_allowed = 'N') then
344: --
345:
346: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
347: fnd_message.set_token('ATTRIBUTE','MAX_NO_OF_RENEWALS');
348:
349: hr_multi_message.add(p_associated_column1=> 'MAX_NO_OF_RENEWALS',
350: p_associated_column2=> 'MAX_DURATION_PER_RENEWAL');
351: end if;

Line 374: fnd_message.set_name('PQH','PQH_FR_FREQUENCY_MUST_SELECT');

370: p_rec.MAX_TOT_CONTINUOUS_DURATION is not null ) then
371: --
372: if (p_rec.FREQUENCY is null ) then
373: --
374: fnd_message.set_name('PQH','PQH_FR_FREQUENCY_MUST_SELECT');
375:
376: hr_multi_message.add(p_associated_column1=> 'FREQUENCY_NAME');
377: end if;
378: --

Line 408: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

404: Fetch csr_frequency into l_value;
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;

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 437: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');

433: p_pay_periods is not null) then
434: --
435: if (p_remuneration_paid = 'N') then
436: --
437: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
438: fnd_message.set_token('ATTRIBUTE','PAY_SHARE');
439:
440: hr_multi_message.add(p_associated_column1=> 'REMUNERATION_PAID');
441: end if;

Line 438: fnd_message.set_token('ATTRIBUTE','PAY_SHARE');

434: --
435: if (p_remuneration_paid = 'N') then
436: --
437: fnd_message.set_name('PQH','PQH_FR_VALUE_NOT_ALLOWED');
438: fnd_message.set_token('ATTRIBUTE','PAY_SHARE');
439:
440: hr_multi_message.add(p_associated_column1=> 'REMUNERATION_PAID');
441: end if;
442: --

Line 461: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE_DATE_FROM');

457: If (p_date_to is not null) then
458: --
459: if (trunc(p_date_from) > trunc(p_date_to)) then
460: --
461: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE_DATE_FROM');
462:
463: hr_multi_message.add(p_associated_column1=> 'DATE_TO');
464:
465: --

Line 499: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

495: Fetch csr_reason into l_value;
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');

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 537: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

533: Fetch csr_location into l_value;
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

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 578: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

574: Fetch csr_source into l_value;
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

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 619: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

615: Fetch csr_sub_type into l_value ;
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');

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 642: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

638: begin
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');

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 650: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');

646: => '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:

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 673: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

669: begin
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');

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 681: fnd_message.set_name('PQH','PQH_FR_STAT_CHECK_REMUNERATION');

677: => '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: --

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 702: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

698: begin
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');

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 723: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

719: begin
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');

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 744: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

740: begin
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');

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 765: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

761: begin
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');

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 787: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

783: begin
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');

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 796: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');

792: --
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');

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 822: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

818:
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');

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 831: fnd_message.set_name('PQH','PQH_FR_STAT_RENEWABLE_ALLOWED');

827: --
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');

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 853: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

849:
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');

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 897: fnd_message.set_name('PQH','PQH_FR_STAT_DUP_DEFAULT');

893: Fetch csr_chk_default into l_value;
894:
895: if csr_chk_default%FOUND then
896: --
897: fnd_message.set_name('PQH','PQH_FR_STAT_DUP_DEFAULT');
898: hr_multi_message.add
899: (p_associated_column1 => 'DEFAULT_FLAG');
900:
901: end if;

Line 935: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

931: Fetch csr_type_of_ps into l_value;
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:

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 974: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

970: Fetch csr_situation_type into l_value;
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:

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;

Line 1013: fnd_message.set_name('PQH','PQH_FR_UNIQUE_STAT_SIT_NAME');

1009: Fetch csr_situation_name into l_value;
1010:
1011: if csr_situation_name%found then
1012: --
1013: fnd_message.set_name('PQH','PQH_FR_UNIQUE_STAT_SIT_NAME');
1014: hr_multi_message.add
1015: (p_associated_column1
1016: => 'SITUATION_NAME');
1017:

Line 1061: fnd_message.set_name('PQH','PQH_FR_UNIQUE_COMBINATION');

1057: Fetch csr_unique_situation into l_value;
1058:
1059: if csr_unique_situation%FOUND then
1060: --
1061: fnd_message.set_name('PQH','PQH_FR_UNIQUE_COMBINATION');
1062: hr_multi_message.add
1063: (p_associated_column1
1064: => 'SITUATION_NAME');
1065:

Line 1088: fnd_message.set_name('PQH','PQH_FR_STAT_MIN_MAX_PER_RQST');

1084: if nvl(p_min_duration_per_request,0) >
1085: nvl(p_max_duration_per_request,0) then
1086: --
1087: --
1088: fnd_message.set_name('PQH','PQH_FR_STAT_MIN_MAX_PER_RQST');
1089: hr_multi_message.add
1090: (p_associated_column1=> 'MIN_DURATION_PER_REQUEST');
1091: --
1092: end if;

Line 1110: fnd_message.set_name('PQH','PQH_FR_STAT_DURATION_WHOLE');

1106: if p_max_duration_whole_career is not null and p_first_period_max_duration is not null then
1107: --
1108: if nvl(p_max_duration_whole_career,0) < nvl(p_first_period_max_duration,0) then
1109: --
1110: fnd_message.set_name('PQH','PQH_FR_STAT_DURATION_WHOLE');
1111: hr_multi_message.add
1112: (p_associated_column1=> 'FIRST_PERIOD_MAX_DURATION');
1113: --
1114: end if;