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 632: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');

628: --
629: open c_chk_result_name;
630: fetch c_chk_result_name into g_exists;
631: if c_chk_result_name%notfound then
632: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');
633: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
634: close c_chk_result_name;
635: fnd_message.raise_error;
636: ELSE

Line 635: fnd_message.raise_error;

631: if c_chk_result_name%notfound then
632: fnd_message.set_name('PAY','PAY_34156_FRR_NAME_INVALID');
633: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
634: close c_chk_result_name;
635: fnd_message.raise_error;
636: ELSE
637: hr_utility.trace('PAY_34156_FRR_NAME_INVALID Warning in startup mode: formula result_name:'
638: ||p_result_name|| ' not found for spr_id:'
639: ||to_char(p_status_processing_rule_id)

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

673: -- severity must be entered
674: --
675: If p_severity_level is not null then
676: --
677: fnd_message.set_name('PAY','PAY_34168_FRR_NO_SEVERITY');
678: fnd_message.raise_error;
679: --
680: End If;
681: --

Line 678: fnd_message.raise_error;

674: --
675: If p_severity_level is not null then
676: --
677: fnd_message.set_name('PAY','PAY_34168_FRR_NO_SEVERITY');
678: fnd_message.raise_error;
679: --
680: End If;
681: --
682: If p_result_rule_type in ('I','O','U','S') then -- others

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

684: -- element type must be entered
685: --
686: If p_element_type_id is null then
687: --
688: fnd_message.set_name('PAY','PAY_34158_FRR_ELEMENT_REQD');
689: fnd_message.raise_error;
690: --
691: End If;
692: --

Line 689: fnd_message.raise_error;

685: --
686: If p_element_type_id is null then
687: --
688: fnd_message.set_name('PAY','PAY_34158_FRR_ELEMENT_REQD');
689: fnd_message.raise_error;
690: --
691: End If;
692: --
693: If p_result_rule_type in ('I','U') then

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

696: -- rules.
697: --
698: If p_input_value_id is null then
699: --
700: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
701: fnd_message.raise_error;
702: --
703: End If;
704: --

Line 701: fnd_message.raise_error;

697: --
698: If p_input_value_id is null then
699: --
700: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
701: fnd_message.raise_error;
702: --
703: End If;
704: --
705: Else

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

707: -- input value must be null for other rules.
708: --
709: If p_input_value_id is not null then
710: --
711: fnd_message.set_name('PAY','PAY_34169_FRR_NO_INPUT_VALUE');
712: fnd_message.raise_error;
713: --
714: End If;
715: --

Line 712: fnd_message.raise_error;

708: --
709: If p_input_value_id is not null then
710: --
711: fnd_message.set_name('PAY','PAY_34169_FRR_NO_INPUT_VALUE');
712: fnd_message.raise_error;
713: --
714: End If;
715: --
716: End If;

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

720: -- input value must be entered for direct rule
721: --
722: If p_input_value_id is null then
723: --
724: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
725: fnd_message.raise_error;
726: --
727: End If;
728: --

Line 725: fnd_message.raise_error;

721: --
722: If p_input_value_id is null then
723: --
724: fnd_message.set_name('PAY','PAY_34159_FRR_INPUT_VALUE_REQD');
725: fnd_message.raise_error;
726: --
727: End If;
728: --
729: End If;

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

784: (p_effective_date
785: ,'RESULT_RULE_TYPE'
786: ,p_result_rule_type) Then
787: --
788: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
789: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
790: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
791: fnd_message.raise_error;
792: --

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

785: ,'RESULT_RULE_TYPE'
786: ,p_result_rule_type) Then
787: --
788: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
789: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
790: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
791: fnd_message.raise_error;
792: --
793: End If;

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

786: ,p_result_rule_type) Then
787: --
788: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
789: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
790: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
791: fnd_message.raise_error;
792: --
793: End If;
794: --

Line 791: fnd_message.raise_error;

787: --
788: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
789: fnd_message.set_token('COLUMN','RESULT_RULE_TYPE');
790: fnd_message.set_token('LOOKUP_TYPE','RESULT_RULE_TYPE');
791: fnd_message.raise_error;
792: --
793: End If;
794: --
795: If p_element_type_id is not null then

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

821: --
822: If (l_spr_element_dets.processing_priority
823: > l_element_dets.processing_priority) then
824: --
825: fnd_message.set_name('PAY','PAY_34163_FRR_PRIORITY');
826: fnd_message.raise_error;
827: --
828: End If;
829: --

Line 826: fnd_message.raise_error;

822: If (l_spr_element_dets.processing_priority
823: > l_element_dets.processing_priority) then
824: --
825: fnd_message.set_name('PAY','PAY_34163_FRR_PRIORITY');
826: fnd_message.raise_error;
827: --
828: End If;
829: --
830: -- the element must be non-recurring and non-third party.

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

830: -- the element must be non-recurring and non-third party.
831: --
832: if nvl(l_element_dets.third_party_pay_only_flag,'N') <> 'N' then
833: --
834: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
835: fnd_message.raise_error;
836: --
837: End If;
838: If (l_element_dets.processing_type <> 'N') then

Line 835: fnd_message.raise_error;

831: --
832: if nvl(l_element_dets.third_party_pay_only_flag,'N') <> 'N' then
833: --
834: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
835: fnd_message.raise_error;
836: --
837: End If;
838: If (l_element_dets.processing_type <> 'N') then
839: --

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

837: End If;
838: If (l_element_dets.processing_type <> 'N') then
839: --
840: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
841: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
842: fnd_message.raise_error;
843: ELSE
844: hr_utility.trace('PAY_34160_FRR_INDIRECT_RULE Warning in startup mode: p_element_type_id:'
845: ||p_element_type_id|| ' has processing_type:'

Line 842: fnd_message.raise_error;

838: If (l_element_dets.processing_type <> 'N') then
839: --
840: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
841: fnd_message.set_name('PAY','PAY_34160_FRR_INDIRECT_RULE');
842: fnd_message.raise_error;
843: ELSE
844: hr_utility.trace('PAY_34160_FRR_INDIRECT_RULE Warning in startup mode: p_element_type_id:'
845: ||p_element_type_id|| ' has processing_type:'
846: ||l_element_dets.processing_type);

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

853: -- the element must be recurring
854: --
855: If l_element_dets.processing_type <> 'R' then
856: --
857: fnd_message.set_name('PAY','PAY_34161_FRR_RECURRING');
858: fnd_message.raise_error;
859: --
860: End If;
861: --

Line 858: fnd_message.raise_error;

854: --
855: If l_element_dets.processing_type <> 'R' then
856: --
857: fnd_message.set_name('PAY','PAY_34161_FRR_RECURRING');
858: fnd_message.raise_error;
859: --
860: End If;
861: --
862: -- if the element allows multiple entries then it

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

864: --
865: If (l_element_dets.multiple_entries_allowed_flag = 'Y'
866: and l_spr_element_id <> p_element_type_id) then
867: --
868: fnd_message.set_name('PAY','PAY_34164_FRR_NO_MULTI_ENTRIES');
869: fnd_message.raise_error;
870: --
871: End If;
872: --

Line 869: fnd_message.raise_error;

865: If (l_element_dets.multiple_entries_allowed_flag = 'Y'
866: and l_spr_element_id <> p_element_type_id) then
867: --
868: fnd_message.set_name('PAY','PAY_34164_FRR_NO_MULTI_ENTRIES');
869: fnd_message.raise_error;
870: --
871: End If;
872: --
873: Elsif p_result_rule_type = 'M' then -- message

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

875: -- severity must be entered
876: --
877: If p_severity_level is null then
878: --
879: fnd_message.set_name('PAY','PAY_34167_FRR_SEVERITY_REQD');
880: fnd_message.raise_error;
881: --
882: End If;
883: --

Line 880: fnd_message.raise_error;

876: --
877: If p_severity_level is null then
878: --
879: fnd_message.set_name('PAY','PAY_34167_FRR_SEVERITY_REQD');
880: fnd_message.raise_error;
881: --
882: End If;
883: --
884: -- no element or input value can be entered

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

885: --
886: If (p_element_type_id is not null
887: or p_input_value_id is not null) then
888: --
889: fnd_message.set_name('PAY','PAY_34157_FRR_MSG_NO_ELEMENT');
890: fnd_message.raise_error;
891: --
892: End If;
893: --

Line 890: fnd_message.raise_error;

886: If (p_element_type_id is not null
887: or p_input_value_id is not null) then
888: --
889: fnd_message.set_name('PAY','PAY_34157_FRR_MSG_NO_ELEMENT');
890: fnd_message.raise_error;
891: --
892: End If;
893: --
894: End If;

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

919: (p_effective_date
920: ,'FORMULA_RESULT_MESSAGE_LEVEL'
921: ,p_severity_level) Then
922: --
923: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
924: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
925: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
926: fnd_message.raise_error;
927: --

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

920: ,'FORMULA_RESULT_MESSAGE_LEVEL'
921: ,p_severity_level) Then
922: --
923: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
924: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
925: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
926: fnd_message.raise_error;
927: --
928: End If;

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

921: ,p_severity_level) Then
922: --
923: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
924: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
925: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
926: fnd_message.raise_error;
927: --
928: End If;
929: --

Line 926: fnd_message.raise_error;

922: --
923: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
924: fnd_message.set_token('COLUMN','SEVERITY_LEVEL');
925: fnd_message.set_token('LOOKUP_TYPE','FORMULA_RESULT_MESSAGE_LEVEL');
926: fnd_message.raise_error;
927: --
928: End If;
929: --
930: hr_utility.set_location('Leaving:'||l_proc, 10);

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

984: Open c_chk_input_value;
985: Fetch c_chk_input_value into l_uom;
986: If c_chk_input_value%notfound then
987: Close c_chk_input_value;
988: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
989: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
991: fnd_message.raise_error;
992: End If;

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

985: Fetch c_chk_input_value into l_uom;
986: If c_chk_input_value%notfound then
987: Close c_chk_input_value;
988: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
989: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
991: fnd_message.raise_error;
992: End If;
993: Close c_chk_input_value;

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

986: If c_chk_input_value%notfound then
987: Close c_chk_input_value;
988: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
989: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
991: fnd_message.raise_error;
992: End If;
993: Close c_chk_input_value;
994: --

Line 991: fnd_message.raise_error;

987: Close c_chk_input_value;
988: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
989: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
991: fnd_message.raise_error;
992: End If;
993: Close c_chk_input_value;
994: --
995: If l_op_datatype = 'D' then -- date

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

993: Close c_chk_input_value;
994: --
995: If l_op_datatype = 'D' then -- date
996: If substr(l_uom,1,1) <> 'D' then
997: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
998: fnd_message.raise_error;
999: End If;
1000: --
1001: Elsif l_op_datatype = 'T' then -- text

Line 998: fnd_message.raise_error;

994: --
995: If l_op_datatype = 'D' then -- date
996: If substr(l_uom,1,1) <> 'D' then
997: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
998: fnd_message.raise_error;
999: End If;
1000: --
1001: Elsif l_op_datatype = 'T' then -- text
1002: If l_uom not in ('C','T') then

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

999: End If;
1000: --
1001: Elsif l_op_datatype = 'T' then -- text
1002: If l_uom not in ('C','T') then
1003: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
1004: fnd_message.raise_error;
1005: End If;
1006: --
1007: Elsif l_op_datatype = 'N' then -- numeric

Line 1004: fnd_message.raise_error;

1000: --
1001: Elsif l_op_datatype = 'T' then -- text
1002: If l_uom not in ('C','T') then
1003: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
1004: fnd_message.raise_error;
1005: End If;
1006: --
1007: Elsif l_op_datatype = 'N' then -- numeric
1008: If (substr(l_uom,1,1) not in ('H','I','M','N')) then

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

1005: End If;
1006: --
1007: Elsif l_op_datatype = 'N' then -- numeric
1008: If (substr(l_uom,1,1) not in ('H','I','M','N')) then
1009: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
1010: fnd_message.raise_error;
1011: End If;
1012: --
1013: End If;

Line 1010: fnd_message.raise_error;

1006: --
1007: Elsif l_op_datatype = 'N' then -- numeric
1008: If (substr(l_uom,1,1) not in ('H','I','M','N')) then
1009: fnd_message.set_name('PAY','PAY_34162_FRR_INVALID_UOM');
1010: fnd_message.raise_error;
1011: End If;
1012: --
1013: End If;
1014: --

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

1015: End If;
1016: --
1017: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
1018: --
1019: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1020: fnd_message.set_token('RULE','Order Indirect');
1021: fnd_message.set_token('TYPE','Numeric');
1022: fnd_message.raise_error;
1023: --

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

1016: --
1017: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
1018: --
1019: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1020: fnd_message.set_token('RULE','Order Indirect');
1021: fnd_message.set_token('TYPE','Numeric');
1022: fnd_message.raise_error;
1023: --
1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then

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

1017: If (p_result_rule_type = 'O' and l_op_datatype <> 'N') then
1018: --
1019: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1020: fnd_message.set_token('RULE','Order Indirect');
1021: fnd_message.set_token('TYPE','Numeric');
1022: fnd_message.raise_error;
1023: --
1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1025: --

Line 1022: fnd_message.raise_error;

1018: --
1019: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1020: fnd_message.set_token('RULE','Order Indirect');
1021: fnd_message.set_token('TYPE','Numeric');
1022: fnd_message.raise_error;
1023: --
1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1025: --
1026: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');

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

1022: fnd_message.raise_error;
1023: --
1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1025: --
1026: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1027: fnd_message.set_token('RULE','Message');
1028: fnd_message.set_token('TYPE','Text');
1029: fnd_message.raise_error;
1030: --

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

1023: --
1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1025: --
1026: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1027: fnd_message.set_token('RULE','Message');
1028: fnd_message.set_token('TYPE','Text');
1029: fnd_message.raise_error;
1030: --
1031: End If;

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

1024: Elsif (p_result_rule_type = 'M' and l_op_datatype <> 'T') then
1025: --
1026: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1027: fnd_message.set_token('RULE','Message');
1028: fnd_message.set_token('TYPE','Text');
1029: fnd_message.raise_error;
1030: --
1031: End If;
1032: --

Line 1029: fnd_message.raise_error;

1025: --
1026: fnd_message.set_name('PAY','PAY_34170_FRR_DATATYP_MISMATCH');
1027: fnd_message.set_token('RULE','Message');
1028: fnd_message.set_token('TYPE','Text');
1029: fnd_message.raise_error;
1030: --
1031: End If;
1032: --
1033: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1166: If (p_result_rule_type = 'M' and message_rule_not_unique)
1167: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1168: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then
1169: --
1170: fnd_message.set_name('PAY','HR_6478_FF_UNI_FRR');
1171: fnd_message.raise_error;
1172: --
1173: End If;
1174: --

Line 1171: fnd_message.raise_error;

1167: or (p_result_rule_type in ('S','U') and recurring_rule_not_unique)
1168: or (p_result_rule_type in ('I','D') and other_rule_type_not_unique) then
1169: --
1170: fnd_message.set_name('PAY','HR_6478_FF_UNI_FRR');
1171: fnd_message.raise_error;
1172: --
1173: End If;
1174: --
1175: hr_utility.set_location('Leaving:'||l_proc, 10);