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.PAY_FRR_BUS dependencies on FND_MESSAGE

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

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

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

144: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --

Line 149: fnd_message.raise_error;

145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are

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

206: (p_formula_result_rule_id => p_rec.formula_result_rule_id
207: ,p_effective_date => p_effective_date
208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;

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

207: ,p_effective_date => p_effective_date
208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --

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

208: ,p_object_version_number => p_rec.object_version_number
209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --
216: -- Ensure that the following attributes are not updated.

Line 213: fnd_message.raise_error;

209: ) THEN
210: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
211: fnd_message.set_token('PROCEDURE ', l_proc);
212: fnd_message.set_token('STEP ', '5');
213: fnd_message.raise_error;
214: END IF;
215: --
216: -- Ensure that the following attributes are not updated.
217: --

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

334: --
335: -- An unhandled or unexpected error has occurred which
336: -- we must report
337: --
338: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
339: fnd_message.set_token('PROCEDURE', l_proc);
340: fnd_message.set_token('STEP','15');
341: fnd_message.raise_error;
342: End dt_update_validate;

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

335: -- An unhandled or unexpected error has occurred which
336: -- we must report
337: --
338: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
339: fnd_message.set_token('PROCEDURE', l_proc);
340: fnd_message.set_token('STEP','15');
341: fnd_message.raise_error;
342: End dt_update_validate;
343: --

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

336: -- we must report
337: --
338: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
339: fnd_message.set_token('PROCEDURE', l_proc);
340: fnd_message.set_token('STEP','15');
341: fnd_message.raise_error;
342: End dt_update_validate;
343: --
344: -- ----------------------------------------------------------------------------

Line 341: fnd_message.raise_error;

337: --
338: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
339: fnd_message.set_token('PROCEDURE', l_proc);
340: fnd_message.set_token('STEP','15');
341: fnd_message.raise_error;
342: End dt_update_validate;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |--------------------------< dt_delete_validate >--------------------------|

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

431: --
432: -- An unhandled or unexpected error has occurred which
433: -- we must report
434: --
435: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','15');
438: fnd_message.raise_error;
439: --

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

432: -- An unhandled or unexpected error has occurred which
433: -- we must report
434: --
435: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','15');
438: fnd_message.raise_error;
439: --
440: End dt_delete_validate;

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

433: -- we must report
434: --
435: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','15');
438: fnd_message.raise_error;
439: --
440: End dt_delete_validate;
441: --

Line 438: fnd_message.raise_error;

434: --
435: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','15');
438: fnd_message.raise_error;
439: --
440: End dt_delete_validate;
441: --
442: -- ----------------------------------------------------------------------------

Line 473: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

469: Fetch c_chk_leg_code into g_exists;
470: If c_chk_leg_code%notfound Then
471: --
472: Close c_chk_leg_code;
473: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
474: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
475: fnd_message.set_token('TABLE','FND_TERRITORIES');
476: fnd_message.raise_error;
477: --

Line 474: fnd_message.set_token('COLUMN','LEGISLATION_CODE');

470: If c_chk_leg_code%notfound Then
471: --
472: Close c_chk_leg_code;
473: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
474: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
475: fnd_message.set_token('TABLE','FND_TERRITORIES');
476: fnd_message.raise_error;
477: --
478: End If;

Line 475: fnd_message.set_token('TABLE','FND_TERRITORIES');

471: --
472: Close c_chk_leg_code;
473: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
474: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
475: fnd_message.set_token('TABLE','FND_TERRITORIES');
476: fnd_message.raise_error;
477: --
478: End If;
479: Close c_chk_leg_code;

Line 476: fnd_message.raise_error;

472: Close c_chk_leg_code;
473: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
474: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
475: fnd_message.set_token('TABLE','FND_TERRITORIES');
476: fnd_message.raise_error;
477: --
478: End If;
479: Close c_chk_leg_code;
480:

Line 531: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');

527: open c_chk_element_type;
528: fetch c_chk_element_type into g_exists;
529: if c_chk_element_type%notfound then
530: close c_chk_element_type;
531: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
532: fnd_message.set_token('1','element type');
533: fnd_message.raise_error;
534: end if;
535: close c_chk_element_type;

Line 532: fnd_message.set_token('1','element type');

528: fetch c_chk_element_type into g_exists;
529: if c_chk_element_type%notfound then
530: close c_chk_element_type;
531: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
532: fnd_message.set_token('1','element type');
533: fnd_message.raise_error;
534: end if;
535: close c_chk_element_type;
536: --

Line 533: fnd_message.raise_error;

529: if c_chk_element_type%notfound then
530: close c_chk_element_type;
531: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
532: fnd_message.set_token('1','element type');
533: fnd_message.raise_error;
534: end if;
535: close c_chk_element_type;
536: --
537: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 585: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');

581: open c_chk_spr;
582: fetch c_chk_spr into g_exists;
583: if c_chk_spr%notfound then
584: close c_chk_spr;
585: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
586: fnd_message.set_token('1','status processing rule');
587: fnd_message.raise_error;
588: end if;
589: close c_chk_spr;

Line 586: fnd_message.set_token('1','status processing rule');

582: fetch c_chk_spr into g_exists;
583: if c_chk_spr%notfound then
584: close c_chk_spr;
585: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
586: fnd_message.set_token('1','status processing rule');
587: fnd_message.raise_error;
588: end if;
589: close c_chk_spr;
590: --

Line 587: fnd_message.raise_error;

583: if c_chk_spr%notfound then
584: close c_chk_spr;
585: fnd_message.set_name('PAY','PAY_34171_FRR_INVALID_FK');
586: fnd_message.set_token('1','status processing rule');
587: fnd_message.raise_error;
588: end if;
589: close c_chk_spr;
590: --
591: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 633: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');

629: open c_chk_result_name;
630: fetch c_chk_result_name into g_exists;
631: if c_chk_result_name%notfound then
632: close c_chk_result_name;
633: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');
634: fnd_message.raise_error;
635: end if;
636: close c_chk_result_name;
637: --

Line 634: fnd_message.raise_error;

630: fetch c_chk_result_name into g_exists;
631: if c_chk_result_name%notfound then
632: close c_chk_result_name;
633: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');
634: fnd_message.raise_error;
635: end if;
636: close c_chk_result_name;
637: --
638: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 669: fnd_message.set_name('PAY','PAY_34168_FRR_NO_SEVERITY');

665: -- severity must be entered
666: --
667: If p_severity_level is not null then
668: --
669: fnd_message.set_name('PAY','PAY_34168_FRR_NO_SEVERITY');
670: fnd_message.raise_error;
671: --
672: End If;
673: --

Line 670: fnd_message.raise_error;

666: --
667: If p_severity_level is not null then
668: --
669: fnd_message.set_name('PAY','PAY_34168_FRR_NO_SEVERITY');
670: fnd_message.raise_error;
671: --
672: End If;
673: --
674: If p_result_rule_type in ('I','O','U','S') then -- others

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

676: -- element type must be entered
677: --
678: If p_element_type_id is null then
679: --
680: fnd_message.set_name('PAY','PAY_34158_FRR_ELEMENT_REQD');
681: fnd_message.raise_error;
682: --
683: End If;
684: --

Line 681: fnd_message.raise_error;

677: --
678: If p_element_type_id is null then
679: --
680: fnd_message.set_name('PAY','PAY_34158_FRR_ELEMENT_REQD');
681: fnd_message.raise_error;
682: --
683: End If;
684: --
685: If p_result_rule_type in ('I','U') then

Line 692: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');

688: -- rules.
689: --
690: If p_input_value_id is null then
691: --
692: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
693: fnd_message.raise_error;
694: --
695: End If;
696: --

Line 693: fnd_message.raise_error;

689: --
690: If p_input_value_id is null then
691: --
692: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
693: fnd_message.raise_error;
694: --
695: End If;
696: --
697: Else

Line 703: fnd_message.set_name('PAY','PAY_34169_FRR_NO_INPUT_VALUE');

699: -- input value must be null for other rules.
700: --
701: If p_input_value_id is not null then
702: --
703: fnd_message.set_name('PAY','PAY_34169_FRR_NO_INPUT_VALUE');
704: fnd_message.raise_error;
705: --
706: End If;
707: --

Line 704: fnd_message.raise_error;

700: --
701: If p_input_value_id is not null then
702: --
703: fnd_message.set_name('PAY','PAY_34169_FRR_NO_INPUT_VALUE');
704: fnd_message.raise_error;
705: --
706: End If;
707: --
708: End If;

Line 716: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');

712: -- input value must be entered for direct rule
713: --
714: If p_input_value_id is null then
715: --
716: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
717: fnd_message.raise_error;
718: --
719: End If;
720: --

Line 717: fnd_message.raise_error;

713: --
714: If p_input_value_id is null then
715: --
716: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
717: fnd_message.raise_error;
718: --
719: End If;
720: --
721: End If;

Line 780: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

776: (p_effective_date
777: ,'RESULT_RULE_TYPE'
778: ,p_result_rule_type) Then
779: --
780: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
781: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
782: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
783: fnd_message.raise_error;
784: --

Line 781: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');

777: ,'RESULT_RULE_TYPE'
778: ,p_result_rule_type) Then
779: --
780: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
781: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
782: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
783: fnd_message.raise_error;
784: --
785: End If;

Line 782: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');

778: ,p_result_rule_type) Then
779: --
780: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
781: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
782: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
783: fnd_message.raise_error;
784: --
785: End If;
786: --

Line 783: fnd_message.raise_error;

779: --
780: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
781: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
782: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
783: fnd_message.raise_error;
784: --
785: End If;
786: --
787: If p_element_type_id is not null then

Line 817: fnd_message.set_name('PAY','PAY_34163_FRR_PRIORITY');

813: --
814: If (l_spr_element_dets.processing_priority
815: > l_element_dets.processing_priority) then
816: --
817: fnd_message.set_name('PAY','PAY_34163_FRR_PRIORITY');
818: fnd_message.raise_error;
819: --
820: End If;
821: --

Line 818: fnd_message.raise_error;

814: If (l_spr_element_dets.processing_priority
815: > l_element_dets.processing_priority) then
816: --
817: fnd_message.set_name('PAY','PAY_34163_FRR_PRIORITY');
818: fnd_message.raise_error;
819: --
820: End If;
821: --
822: -- the element must be non-recurring and non-third party.

Line 827: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');

823: --
824: If (l_element_dets.processing_type <> 'N')
825: or (nvl(l_element_dets.third_party_pay_only_flag,'N') <> 'N') then
826: --
827: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
828: fnd_message.raise_error;
829: --
830: End If;
831: --

Line 828: fnd_message.raise_error;

824: If (l_element_dets.processing_type <> 'N')
825: or (nvl(l_element_dets.third_party_pay_only_flag,'N') <> 'N') then
826: --
827: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
828: fnd_message.raise_error;
829: --
830: End If;
831: --
832: Elsif p_result_rule_type in ('U','S') then -- update recurring or stop entry

Line 838: fnd_message.set_name('PAY','PAY_34161_FRR_RECURRING');

834: -- the element must be recurring
835: --
836: If l_element_dets.processing_type <> 'R' then
837: --
838: fnd_message.set_name('PAY','PAY_34161_FRR_RECURRING');
839: fnd_message.raise_error;
840: --
841: End If;
842: --

Line 839: fnd_message.raise_error;

835: --
836: If l_element_dets.processing_type <> 'R' then
837: --
838: fnd_message.set_name('PAY','PAY_34161_FRR_RECURRING');
839: fnd_message.raise_error;
840: --
841: End If;
842: --
843: -- if the element allows multiple entries then it

Line 849: fnd_message.set_name('PAY','PAY_34164_FRR_NO_MULTI_ENTRIES');

845: --
846: If (l_element_dets.multiple_entries_allowed_flag = 'Y'
847: and l_spr_element_id <> p_element_type_id) then
848: --
849: fnd_message.set_name('PAY','PAY_34164_FRR_NO_MULTI_ENTRIES');
850: fnd_message.raise_error;
851: --
852: End If;
853: --

Line 850: fnd_message.raise_error;

846: If (l_element_dets.multiple_entries_allowed_flag = 'Y'
847: and l_spr_element_id <> p_element_type_id) then
848: --
849: fnd_message.set_name('PAY','PAY_34164_FRR_NO_MULTI_ENTRIES');
850: fnd_message.raise_error;
851: --
852: End If;
853: --
854: Elsif p_result_rule_type = 'M' then -- message

Line 860: fnd_message.set_name('PAY','PAY_34167_FRR_SEVERITY_REQD');

856: -- severity must be entered
857: --
858: If p_severity_level is null then
859: --
860: fnd_message.set_name('PAY','PAY_34167_FRR_SEVERITY_REQD');
861: fnd_message.raise_error;
862: --
863: End If;
864: --

Line 861: fnd_message.raise_error;

857: --
858: If p_severity_level is null then
859: --
860: fnd_message.set_name('PAY','PAY_34167_FRR_SEVERITY_REQD');
861: fnd_message.raise_error;
862: --
863: End If;
864: --
865: -- no element or input value can be entered

Line 870: fnd_message.set_name('PAY','PAY_34157_FRR_MSG_NO_ELEMENT');

866: --
867: If (p_element_type_id is not null
868: or p_input_value_id is not null) then
869: --
870: fnd_message.set_name('PAY','PAY_34157_FRR_MSG_NO_ELEMENT');
871: fnd_message.raise_error;
872: --
873: End If;
874: --

Line 871: fnd_message.raise_error;

867: If (p_element_type_id is not null
868: or p_input_value_id is not null) then
869: --
870: fnd_message.set_name('PAY','PAY_34157_FRR_MSG_NO_ELEMENT');
871: fnd_message.raise_error;
872: --
873: End If;
874: --
875: End If;

Line 904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

900: (p_effective_date
901: ,'FORMULA_RESULT_MESSAGE_LEVEL'
902: ,p_severity_level) Then
903: --
904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
905: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
906: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
907: fnd_message.raise_error;
908: --

Line 905: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');

901: ,'FORMULA_RESULT_MESSAGE_LEVEL'
902: ,p_severity_level) Then
903: --
904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
905: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
906: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
907: fnd_message.raise_error;
908: --
909: End If;

Line 906: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');

902: ,p_severity_level) Then
903: --
904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
905: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
906: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
907: fnd_message.raise_error;
908: --
909: End If;
910: --

Line 907: fnd_message.raise_error;

903: --
904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
905: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
906: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
907: fnd_message.raise_error;
908: --
909: End If;
910: --
911: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

965: Open c_chk_input_value;
966: Fetch c_chk_input_value into l_uom;
967: If c_chk_input_value%notfound then
968: Close c_chk_input_value;
969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
972: fnd_message.raise_error;
973: End If;

Line 970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');

966: Fetch c_chk_input_value into l_uom;
967: If c_chk_input_value%notfound then
968: Close c_chk_input_value;
969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
972: fnd_message.raise_error;
973: End If;
974: Close c_chk_input_value;

Line 971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');

967: If c_chk_input_value%notfound then
968: Close c_chk_input_value;
969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
972: fnd_message.raise_error;
973: End If;
974: Close c_chk_input_value;
975: --

Line 972: fnd_message.raise_error;

968: Close c_chk_input_value;
969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
972: fnd_message.raise_error;
973: End If;
974: Close c_chk_input_value;
975: --
976: If l_op_datatype = 'D' then -- date

Line 978: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');

974: Close c_chk_input_value;
975: --
976: If l_op_datatype = 'D' then -- date
977: If substr(l_uom,1,1) <> 'D' then
978: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
979: fnd_message.raise_error;
980: End If;
981: --
982: Elsif l_op_datatype = 'T' then -- text

Line 979: fnd_message.raise_error;

975: --
976: If l_op_datatype = 'D' then -- date
977: If substr(l_uom,1,1) <> 'D' then
978: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
979: fnd_message.raise_error;
980: End If;
981: --
982: Elsif l_op_datatype = 'T' then -- text
983: If l_uom <> 'C' then

Line 984: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');

980: End If;
981: --
982: Elsif l_op_datatype = 'T' then -- text
983: If l_uom <> 'C' then
984: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
985: fnd_message.raise_error;
986: End If;
987: --
988: Elsif l_op_datatype = 'N' then -- numeric

Line 985: fnd_message.raise_error;

981: --
982: Elsif l_op_datatype = 'T' then -- text
983: If l_uom <> 'C' then
984: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
985: fnd_message.raise_error;
986: End If;
987: --
988: Elsif l_op_datatype = 'N' then -- numeric
989: If (substr(l_uom,1,1) not in ('H','I','M','N')) then

Line 990: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');

986: End If;
987: --
988: Elsif l_op_datatype = 'N' then -- numeric
989: If (substr(l_uom,1,1) not in ('H','I','M','N')) then
990: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
991: fnd_message.raise_error;
992: End If;
993: --
994: End If;

Line 991: fnd_message.raise_error;

987: --
988: Elsif l_op_datatype = 'N' then -- numeric
989: If (substr(l_uom,1,1) not in ('H','I','M','N')) then
990: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
991: fnd_message.raise_error;
992: End If;
993: --
994: End If;
995: --

Line 1000: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');

996: End If;
997: --
998: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
999: --
1000: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1001: fnd_message.set_token('RULE','Order Indirect');
1002: fnd_message.set_token('TYPE','Numeric');
1003: fnd_message.raise_error;
1004: --

Line 1001: fnd_message.set_token('RULE','Order Indirect');

997: --
998: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
999: --
1000: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1001: fnd_message.set_token('RULE','Order Indirect');
1002: fnd_message.set_token('TYPE','Numeric');
1003: fnd_message.raise_error;
1004: --
1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then

Line 1002: fnd_message.set_token('TYPE','Numeric');

998: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
999: --
1000: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1001: fnd_message.set_token('RULE','Order Indirect');
1002: fnd_message.set_token('TYPE','Numeric');
1003: fnd_message.raise_error;
1004: --
1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1006: --

Line 1003: fnd_message.raise_error;

999: --
1000: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1001: fnd_message.set_token('RULE','Order Indirect');
1002: fnd_message.set_token('TYPE','Numeric');
1003: fnd_message.raise_error;
1004: --
1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1006: --
1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');

Line 1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');

1003: fnd_message.raise_error;
1004: --
1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1006: --
1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1008: fnd_message.set_token('RULE','Message');
1009: fnd_message.set_token('TYPE','Text');
1010: fnd_message.raise_error;
1011: --

Line 1008: fnd_message.set_token('RULE','Message');

1004: --
1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1006: --
1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1008: fnd_message.set_token('RULE','Message');
1009: fnd_message.set_token('TYPE','Text');
1010: fnd_message.raise_error;
1011: --
1012: End If;

Line 1009: fnd_message.set_token('TYPE','Text');

1005: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1006: --
1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1008: fnd_message.set_token('RULE','Message');
1009: fnd_message.set_token('TYPE','Text');
1010: fnd_message.raise_error;
1011: --
1012: End If;
1013: --

Line 1010: fnd_message.raise_error;

1006: --
1007: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1008: fnd_message.set_token('RULE','Message');
1009: fnd_message.set_token('TYPE','Text');
1010: fnd_message.raise_error;
1011: --
1012: End If;
1013: --
1014: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1151: fnd_message.set_name('PAY','HR_6478_FF_UNI_FRR');

1147: If (p_result_rule_type = 'M' and message_rule_not_unique)
1148: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1149: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then
1150: --
1151: fnd_message.set_name('PAY','HR_6478_FF_UNI_FRR');
1152: fnd_message.raise_error;
1153: --
1154: End If;
1155: --

Line 1152: fnd_message.raise_error;

1148: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1149: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then
1150: --
1151: fnd_message.set_name('PAY','HR_6478_FF_UNI_FRR');
1152: fnd_message.raise_error;
1153: --
1154: End If;
1155: --
1156: hr_utility.set_location('Leaving:'||l_proc, 10);