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_PEL_BUS dependencies on FND_MESSAGE

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

57: close csr_sec_grp;
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,'ELEMENT_LINK_ID')
65: );

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

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140:
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140:
141: --
142: -- Set the global variables so the values are

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

330: (p_element_link_id => p_rec.element_link_id
331: ,p_effective_date => p_effective_date
332: ,p_object_version_number => p_rec.object_version_number
333: ) THEN
334: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE ', l_proc);
336: fnd_message.set_token('STEP ', '5');
337: fnd_message.raise_error;
338: END IF;

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

331: ,p_effective_date => p_effective_date
332: ,p_object_version_number => p_rec.object_version_number
333: ) THEN
334: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE ', l_proc);
336: fnd_message.set_token('STEP ', '5');
337: fnd_message.raise_error;
338: END IF;
339: End chk_non_updateable_args;

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

332: ,p_object_version_number => p_rec.object_version_number
333: ) THEN
334: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE ', l_proc);
336: fnd_message.set_token('STEP ', '5');
337: fnd_message.raise_error;
338: END IF;
339: End chk_non_updateable_args;
340: --

Line 337: fnd_message.raise_error;

333: ) THEN
334: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
335: fnd_message.set_token('PROCEDURE ', l_proc);
336: fnd_message.set_token('STEP ', '5');
337: fnd_message.raise_error;
338: END IF;
339: End chk_non_updateable_args;
340: --
341: -- ----------------------------------------------------------------------------

Line 413: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

409: ,p_base_key_column => 'PAYROLL_ID'
410: ,p_base_key_value => p_payroll_id
411: ,p_from_date => p_validation_start_date
412: ,p_to_date => p_validation_end_date))) Then
413: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
414: fnd_message.set_token('TABLE_NAME','all payrolls');
415: hr_multi_message.add
416: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.PAYROLL_ID');
417: End If;

Line 414: fnd_message.set_token('TABLE_NAME','all payrolls');

410: ,p_base_key_value => p_payroll_id
411: ,p_from_date => p_validation_start_date
412: ,p_to_date => p_validation_end_date))) Then
413: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
414: fnd_message.set_token('TABLE_NAME','all payrolls');
415: hr_multi_message.add
416: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.PAYROLL_ID');
417: End If;
418: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and

Line 425: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

421: ,p_base_key_column => 'ELEMENT_TYPE_ID'
422: ,p_base_key_value => p_element_type_id
423: ,p_from_date => p_validation_start_date
424: ,p_to_date => p_validation_end_date))) Then
425: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
426: fnd_message.set_token('TABLE_NAME','element types');
427: hr_multi_message.add
428: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
429: End If;

Line 426: fnd_message.set_token('TABLE_NAME','element types');

422: ,p_base_key_value => p_element_type_id
423: ,p_from_date => p_validation_start_date
424: ,p_to_date => p_validation_end_date))) Then
425: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
426: fnd_message.set_token('TABLE_NAME','element types');
427: hr_multi_message.add
428: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
429: End If;
430: --

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

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

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

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

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

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

Line 440: fnd_message.raise_error;

436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_update_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |--------------------------< dt_delete_validate >--------------------------|

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

527: ,p_base_key_value => p_element_link_id
528: ,p_from_date => p_validation_start_date
529: ,p_to_date => p_validation_end_date
530: )) Then
531: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
532: fnd_message.set_token('TABLE_NAME','link input values');
533: hr_multi_message.add;
534: End If;
535: If (dt_api.rows_exist

Line 532: fnd_message.set_token('TABLE_NAME','link input values');

528: ,p_from_date => p_validation_start_date
529: ,p_to_date => p_validation_end_date
530: )) Then
531: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
532: fnd_message.set_token('TABLE_NAME','link input values');
533: hr_multi_message.add;
534: End If;
535: If (dt_api.rows_exist
536: (p_base_table_name => 'pay_element_entries_f'

Line 542: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

538: ,p_base_key_value => p_element_link_id
539: ,p_from_date => p_validation_start_date
540: ,p_to_date => p_validation_end_date
541: )) Then
542: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
543: fnd_message.set_token('TABLE_NAME','element entries');
544: hr_multi_message.add;
545: End If;
546: --

Line 543: fnd_message.set_token('TABLE_NAME','element entries');

539: ,p_from_date => p_validation_start_date
540: ,p_to_date => p_validation_end_date
541: )) Then
542: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
543: fnd_message.set_token('TABLE_NAME','element entries');
544: hr_multi_message.add;
545: End If;
546: --
547: End If;

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

551: --
552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: --

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

552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: --
560: End dt_delete_validate;

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

553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: --
560: End dt_delete_validate;
561:

Line 558: fnd_message.raise_error;

554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: --
560: End dt_delete_validate;
561:
562: --

Line 618: fnd_message.set_name('PAY', 'PAY_33096_QUALI_AGE_CHECK');

614: hr_utility.set_location('Entering:'||l_proc,10);
615: --
616: if p_qualifying_age is not null and
617: (p_qualifying_age < 0 or length(p_qualifying_age) > 2) then
618: fnd_message.set_name('PAY', 'PAY_33096_QUALI_AGE_CHECK');
619: fnd_message.raise_error;
620: end if;
621:
622: begin

Line 619: fnd_message.raise_error;

615: --
616: if p_qualifying_age is not null and
617: (p_qualifying_age < 0 or length(p_qualifying_age) > 2) then
618: fnd_message.set_name('PAY', 'PAY_33096_QUALI_AGE_CHECK');
619: fnd_message.raise_error;
620: end if;
621:
622: begin
623: if p_qualifying_length_of_service is not null

Line 627: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');

623: if p_qualifying_length_of_service is not null
624: and (p_qualifying_length_of_service < 0
625: or to_number(p_qualifying_length_of_service,'9999.99')
626: <> to_number(p_qualifying_length_of_service)) then
627: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');
628: fnd_message.raise_error;
629: end if;
630: exception
631: when others then

Line 628: fnd_message.raise_error;

624: and (p_qualifying_length_of_service < 0
625: or to_number(p_qualifying_length_of_service,'9999.99')
626: <> to_number(p_qualifying_length_of_service)) then
627: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');
628: fnd_message.raise_error;
629: end if;
630: exception
631: when others then
632: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');

Line 632: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');

628: fnd_message.raise_error;
629: end if;
630: exception
631: when others then
632: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');
633: fnd_message.raise_error;
634: end;
635:
636: if p_qualifying_units is not null then

Line 633: fnd_message.raise_error;

629: end if;
630: exception
631: when others then
632: fnd_message.set_name('PAY', 'PAY_33097_QUALI_LOS_CHECK');
633: fnd_message.raise_error;
634: end;
635:
636: if p_qualifying_units is not null then
637: if hr_api.not_exists_in_hr_lookups

Line 642: fnd_message.set_name('PAY', 'PAY_33098_QUALI_UNIT_CHECK');

638: (p_effective_date
639: ,'QUALIFYING_UNITS'
640: ,p_qualifying_units) then
641: --
642: fnd_message.set_name('PAY', 'PAY_33098_QUALI_UNIT_CHECK');
643: fnd_message.raise_error;
644: --
645: end if;
646: end if;

Line 643: fnd_message.raise_error;

639: ,'QUALIFYING_UNITS'
640: ,p_qualifying_units) then
641: --
642: fnd_message.set_name('PAY', 'PAY_33098_QUALI_UNIT_CHECK');
643: fnd_message.raise_error;
644: --
645: end if;
646: end if;
647:

Line 872: fnd_message.set_name('PAY', 'PAY_33086_LINK_NO_EFF_CONTRI');

868: Fetch csr_BenContri into l_exists;
869: If csr_BenContri%notfound then
870: Close csr_ben_contri_used;
871: Close csr_BenContri;
872: fnd_message.set_name('PAY', 'PAY_33086_LINK_NO_EFF_CONTRI');
873: fnd_message.raise_error;
874: End If;
875: Close csr_BenContri;
876: --

Line 873: fnd_message.raise_error;

869: If csr_BenContri%notfound then
870: Close csr_ben_contri_used;
871: Close csr_BenContri;
872: fnd_message.set_name('PAY', 'PAY_33086_LINK_NO_EFF_CONTRI');
873: fnd_message.raise_error;
874: End If;
875: Close csr_BenContri;
876: --
877: End If;

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

917: (p_effective_date
918: ,'EMP_CAT'
919: ,p_employment_category) Then
920: --
921: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
922: fnd_message.set_token('COLUMN','EMPLOYMENT_CATEGORY');
923: fnd_message.set_token('LOOKUP_TYPE','EMP_CAT');
924: fnd_message.raise_error;
925: --

Line 922: fnd_message.set_token('COLUMN','EMPLOYMENT_CATEGORY');

918: ,'EMP_CAT'
919: ,p_employment_category) Then
920: --
921: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
922: fnd_message.set_token('COLUMN','EMPLOYMENT_CATEGORY');
923: fnd_message.set_token('LOOKUP_TYPE','EMP_CAT');
924: fnd_message.raise_error;
925: --
926: End If;

Line 923: fnd_message.set_token('LOOKUP_TYPE','EMP_CAT');

919: ,p_employment_category) Then
920: --
921: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
922: fnd_message.set_token('COLUMN','EMPLOYMENT_CATEGORY');
923: fnd_message.set_token('LOOKUP_TYPE','EMP_CAT');
924: fnd_message.raise_error;
925: --
926: End If;
927: End If;

Line 924: fnd_message.raise_error;

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

Line 962: fnd_message.set_name('PAY', 'PAY_33087_LINK_ORG_INVALID');

958: open csr_OrgUnit;
959: fetch csr_OrgUnit into l_dummy;
960: if csr_OrgUnit%notfound then
961: close csr_OrgUnit;
962: fnd_message.set_name('PAY', 'PAY_33087_LINK_ORG_INVALID');
963: fnd_message.raise_error;
964: end if;
965: close csr_OrgUnit;
966:

Line 963: fnd_message.raise_error;

959: fetch csr_OrgUnit into l_dummy;
960: if csr_OrgUnit%notfound then
961: close csr_OrgUnit;
962: fnd_message.set_name('PAY', 'PAY_33087_LINK_ORG_INVALID');
963: fnd_message.raise_error;
964: end if;
965: close csr_OrgUnit;
966:
967: --p_location_id := nvl(p_location_id,l_dummy);

Line 1027: fnd_message.set_name('PAY', 'PAY_33094_LINK_POS_INVALID');

1023: open csr_position;
1024: fetch csr_position into l_dummy;
1025: if csr_position%notfound then
1026: close csr_position;
1027: fnd_message.set_name('PAY', 'PAY_33094_LINK_POS_INVALID');
1028: fnd_message.raise_error;
1029: end if;
1030: close csr_position;
1031: --

Line 1028: fnd_message.raise_error;

1024: fetch csr_position into l_dummy;
1025: if csr_position%notfound then
1026: close csr_position;
1027: fnd_message.set_name('PAY', 'PAY_33094_LINK_POS_INVALID');
1028: fnd_message.raise_error;
1029: end if;
1030: close csr_position;
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');

1080: open csr_jobs;
1081: fetch csr_jobs into l_dummy;
1082: if csr_jobs%notfound then
1083: close csr_jobs;
1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;

Line 1085: fnd_message.set_token('COLUMN','Job Id');

1081: fetch csr_jobs into l_dummy;
1082: if csr_jobs%notfound then
1083: close csr_jobs;
1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;
1089: end if;

Line 1086: fnd_message.set_token('TABLE','per_jobs');

1082: if csr_jobs%notfound then
1083: close csr_jobs;
1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;
1089: end if;
1090: close csr_jobs;

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

1083: close csr_jobs;
1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;
1089: end if;
1090: close csr_jobs;
1091: --

Line 1088: fnd_message.raise_error;

1084: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1085: fnd_message.set_token('COLUMN','Job Id');
1086: fnd_message.set_token('TABLE','per_jobs');
1087: fnd_message.set_token('PROCEDURE',l_proc);
1088: fnd_message.raise_error;
1089: end if;
1090: close csr_jobs;
1091: --
1092: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');

1141: open csr_grades;
1142: fetch csr_grades into l_dummy;
1143: if csr_grades%notfound then
1144: close csr_grades;
1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1146: fnd_message.set_token('COLUMN','Grade Id');
1147: fnd_message.set_token('TABLE','per_grades');
1148: fnd_message.set_token('PROCEDURE',l_proc);
1149: fnd_message.raise_error;

Line 1146: fnd_message.set_token('COLUMN','Grade Id');

1142: fetch csr_grades into l_dummy;
1143: if csr_grades%notfound then
1144: close csr_grades;
1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1146: fnd_message.set_token('COLUMN','Grade Id');
1147: fnd_message.set_token('TABLE','per_grades');
1148: fnd_message.set_token('PROCEDURE',l_proc);
1149: fnd_message.raise_error;
1150: end if;

Line 1147: fnd_message.set_token('TABLE','per_grades');

1143: if csr_grades%notfound then
1144: close csr_grades;
1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1146: fnd_message.set_token('COLUMN','Grade Id');
1147: fnd_message.set_token('TABLE','per_grades');
1148: fnd_message.set_token('PROCEDURE',l_proc);
1149: fnd_message.raise_error;
1150: end if;
1151: close csr_grades;

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

1144: close csr_grades;
1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1146: fnd_message.set_token('COLUMN','Grade Id');
1147: fnd_message.set_token('TABLE','per_grades');
1148: fnd_message.set_token('PROCEDURE',l_proc);
1149: fnd_message.raise_error;
1150: end if;
1151: close csr_grades;
1152: --

Line 1149: fnd_message.raise_error;

1145: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1146: fnd_message.set_token('COLUMN','Grade Id');
1147: fnd_message.set_token('TABLE','per_grades');
1148: fnd_message.set_token('PROCEDURE',l_proc);
1149: fnd_message.raise_error;
1150: end if;
1151: close csr_grades;
1152: --
1153: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');

1197: open csr_people_group_id;
1198: fetch csr_people_group_id into l_dummy;
1199: if csr_people_group_id%notfound then
1200: close csr_people_group_id;
1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;

Line 1202: fnd_message.set_token('COLUMN','People Group Id');

1198: fetch csr_people_group_id into l_dummy;
1199: if csr_people_group_id%notfound then
1200: close csr_people_group_id;
1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;
1206: end if;

Line 1203: fnd_message.set_token('TABLE','pay_people_groups');

1199: if csr_people_group_id%notfound then
1200: close csr_people_group_id;
1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;
1206: end if;
1207: close csr_people_group_id;

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

1200: close csr_people_group_id;
1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;
1206: end if;
1207: close csr_people_group_id;
1208: --

Line 1205: fnd_message.raise_error;

1201: fnd_message.set_name('PAY', 'PAY_33452_FK_DATA_INACTIVE');
1202: fnd_message.set_token('COLUMN','People Group Id');
1203: fnd_message.set_token('TABLE','pay_people_groups');
1204: fnd_message.set_token('PROCEDURE',l_proc);
1205: fnd_message.raise_error;
1206: end if;
1207: close csr_people_group_id;
1208: --
1209: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1247: fnd_message.set_name('PAY', 'PAY_33088_LINK_ALL_PAYROLLS');

1243: begin
1244: hr_utility.set_location('Entering:'||l_proc,10);
1245: --
1246: if p_link_to_all_payrolls_flag = 'Y' and p_payroll_id is not null then
1247: fnd_message.set_name('PAY', 'PAY_33088_LINK_ALL_PAYROLLS');
1248: fnd_message.raise_error;
1249: end if;
1250: --
1251: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1248: fnd_message.raise_error;

1244: hr_utility.set_location('Entering:'||l_proc,10);
1245: --
1246: if p_link_to_all_payrolls_flag = 'Y' and p_payroll_id is not null then
1247: fnd_message.set_name('PAY', 'PAY_33088_LINK_ALL_PAYROLLS');
1248: fnd_message.raise_error;
1249: end if;
1250: --
1251: hr_utility.set_location(' Leaving:'||l_proc,20);
1252:

Line 1431: fnd_message.set_name('PAY','PAY_33089_COST_FLAG_TYPE_MISMATCH');

1427: fetch csr_legcode_cr_db_type into l_costing_dc,l_leg_code;
1428: close csr_legcode_cr_db_type;
1429:
1430: if l_costable_flag = 'N' and p_costable_type <> 'N' then
1431: fnd_message.set_name('PAY','PAY_33089_COST_FLAG_TYPE_MISMATCH');
1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');
1433: fnd_message.raise_error;
1434: end if;
1435:

Line 1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');

1428: close csr_legcode_cr_db_type;
1429:
1430: if l_costable_flag = 'N' and p_costable_type <> 'N' then
1431: fnd_message.set_name('PAY','PAY_33089_COST_FLAG_TYPE_MISMATCH');
1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');
1433: fnd_message.raise_error;
1434: end if;
1435:
1436: if p_costable_type = 'N'

Line 1433: fnd_message.raise_error;

1429:
1430: if l_costable_flag = 'N' and p_costable_type <> 'N' then
1431: fnd_message.set_name('PAY','PAY_33089_COST_FLAG_TYPE_MISMATCH');
1432: fnd_message.set_token('TABLE_NAME','pay_element_links_f');
1433: fnd_message.raise_error;
1434: end if;
1435:
1436: if p_costable_type = 'N'
1437: and

Line 1442: fnd_message.set_name('PAY','PAY_33091_COST_BAL_ELESET_NC');

1438: (p_transfer_to_gl <> 'N'
1439: or p_cost_allocation_keyflex_id is not null
1440: or p_balancing_keyflex_id is not null
1441: or p_element_set_id is not null) then
1442: fnd_message.set_name('PAY','PAY_33091_COST_BAL_ELESET_NC');
1443: fnd_message.raise_error;
1444: elsif (p_costable_type = 'C' or p_costable_type = 'F')
1445: and
1446: ( p_element_set_id is not null or p_balancing_keyflex_id is null) then

Line 1443: fnd_message.raise_error;

1439: or p_cost_allocation_keyflex_id is not null
1440: or p_balancing_keyflex_id is not null
1441: or p_element_set_id is not null) then
1442: fnd_message.set_name('PAY','PAY_33091_COST_BAL_ELESET_NC');
1443: fnd_message.raise_error;
1444: elsif (p_costable_type = 'C' or p_costable_type = 'F')
1445: and
1446: ( p_element_set_id is not null or p_balancing_keyflex_id is null) then
1447: fnd_message.set_name('PAY','PAY_33092_BAL_MAND_ELE_SET_NM');

Line 1447: fnd_message.set_name('PAY','PAY_33092_BAL_MAND_ELE_SET_NM');

1443: fnd_message.raise_error;
1444: elsif (p_costable_type = 'C' or p_costable_type = 'F')
1445: and
1446: ( p_element_set_id is not null or p_balancing_keyflex_id is null) then
1447: fnd_message.set_name('PAY','PAY_33092_BAL_MAND_ELE_SET_NM');
1448: fnd_message.raise_error;
1449: elsif p_costable_type = 'D' then
1450: if p_element_set_id is null or p_balancing_keyflex_id is null
1451: then

Line 1448: fnd_message.raise_error;

1444: elsif (p_costable_type = 'C' or p_costable_type = 'F')
1445: and
1446: ( p_element_set_id is not null or p_balancing_keyflex_id is null) then
1447: fnd_message.set_name('PAY','PAY_33092_BAL_MAND_ELE_SET_NM');
1448: fnd_message.raise_error;
1449: elsif p_costable_type = 'D' then
1450: if p_element_set_id is null or p_balancing_keyflex_id is null
1451: then
1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');

Line 1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');

1448: fnd_message.raise_error;
1449: elsif p_costable_type = 'D' then
1450: if p_element_set_id is null or p_balancing_keyflex_id is null
1451: then
1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');
1453: fnd_message.raise_error;
1454: elsif l_uom <> 'M' then
1455: fnd_message.set_name('PAY','PAY_33090_UOM_COST_TYPE_DISTRI');
1456: fnd_message.raise_error;

Line 1453: fnd_message.raise_error;

1449: elsif p_costable_type = 'D' then
1450: if p_element_set_id is null or p_balancing_keyflex_id is null
1451: then
1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');
1453: fnd_message.raise_error;
1454: elsif l_uom <> 'M' then
1455: fnd_message.set_name('PAY','PAY_33090_UOM_COST_TYPE_DISTRI');
1456: fnd_message.raise_error;
1457: elsif pay_element_links_pkg.element_in_distribution_set

Line 1455: fnd_message.set_name('PAY','PAY_33090_UOM_COST_TYPE_DISTRI');

1451: then
1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');
1453: fnd_message.raise_error;
1454: elsif l_uom <> 'M' then
1455: fnd_message.set_name('PAY','PAY_33090_UOM_COST_TYPE_DISTRI');
1456: fnd_message.raise_error;
1457: elsif pay_element_links_pkg.element_in_distribution_set
1458: ( p_element_type_id,
1459: p_business_group_id,

Line 1456: fnd_message.raise_error;

1452: fnd_message.set_name('PAY','PAY_33095_LINK_MAN_BAL_ELE_SET');
1453: fnd_message.raise_error;
1454: elsif l_uom <> 'M' then
1455: fnd_message.set_name('PAY','PAY_33090_UOM_COST_TYPE_DISTRI');
1456: fnd_message.raise_error;
1457: elsif pay_element_links_pkg.element_in_distribution_set
1458: ( p_element_type_id,
1459: p_business_group_id,
1460: l_leg_code) then

Line 1461: fnd_message.set_name('PAY','PAY_6462_LINK_DIST_IN_DIST');

1457: elsif pay_element_links_pkg.element_in_distribution_set
1458: ( p_element_type_id,
1459: p_business_group_id,
1460: l_leg_code) then
1461: fnd_message.set_name('PAY','PAY_6462_LINK_DIST_IN_DIST');
1462: fnd_message.raise_error;
1463: else
1464: open csr_cr_db_class(l_costing_dc,l_leg_code);
1465: fetch csr_cr_db_class into l_dummy;

Line 1462: fnd_message.raise_error;

1458: ( p_element_type_id,
1459: p_business_group_id,
1460: l_leg_code) then
1461: fnd_message.set_name('PAY','PAY_6462_LINK_DIST_IN_DIST');
1462: fnd_message.raise_error;
1463: else
1464: open csr_cr_db_class(l_costing_dc,l_leg_code);
1465: fetch csr_cr_db_class into l_dummy;
1466: if csr_cr_db_class%notfound then

Line 1467: fnd_message.set_name('PAY','PAY_33451_CR_DB_CLASS_MISMA');

1463: else
1464: open csr_cr_db_class(l_costing_dc,l_leg_code);
1465: fetch csr_cr_db_class into l_dummy;
1466: if csr_cr_db_class%notfound then
1467: fnd_message.set_name('PAY','PAY_33451_CR_DB_CLASS_MISMA');
1468: fnd_message.raise_error;
1469: end if;
1470: close csr_cr_db_class;
1471: end if;

Line 1468: fnd_message.raise_error;

1464: open csr_cr_db_class(l_costing_dc,l_leg_code);
1465: fetch csr_cr_db_class into l_dummy;
1466: if csr_cr_db_class%notfound then
1467: fnd_message.set_name('PAY','PAY_33451_CR_DB_CLASS_MISMA');
1468: fnd_message.raise_error;
1469: end if;
1470: close csr_cr_db_class;
1471: end if;
1472: end if;

Line 1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');

1507: begin
1508: hr_utility.set_location('Entering:'||l_proc,10);
1509: if pay_pel_shd.g_old_rec.costable_type <> p_costable_type
1510: and p_datetrack_mode = hr_api.g_update then
1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');
1512: fnd_message.raise_error;
1513: end if;
1514: hr_utility.set_location(' Leaving:'||l_proc,20);
1515: end;

Line 1512: fnd_message.raise_error;

1508: hr_utility.set_location('Entering:'||l_proc,10);
1509: if pay_pel_shd.g_old_rec.costable_type <> p_costable_type
1510: and p_datetrack_mode = hr_api.g_update then
1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');
1512: fnd_message.raise_error;
1513: end if;
1514: hr_utility.set_location(' Leaving:'||l_proc,20);
1515: end;
1516:

Line 1604: fnd_message.set_name('PAY', 'PAY_6733_LINK_NO_UPD_STAN_FLAG');

1600: open csr_DateEffRecs;
1601: fetch csr_DateEffRecs into l_dummy;
1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then
1603: close csr_DateEffRecs;
1604: fnd_message.set_name('PAY', 'PAY_6733_LINK_NO_UPD_STAN_FLAG');
1605: fnd_message.raise_error;
1606: end if;
1607: close csr_DateEffRecs;
1608: end if;

Line 1605: fnd_message.raise_error;

1601: fetch csr_DateEffRecs into l_dummy;
1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then
1603: close csr_DateEffRecs;
1604: fnd_message.set_name('PAY', 'PAY_6733_LINK_NO_UPD_STAN_FLAG');
1605: fnd_message.raise_error;
1606: end if;
1607: close csr_DateEffRecs;
1608: end if;
1609: end if;

Line 1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');

1620: if (l_processing_type = 'N')
1621: then
1622: hr_utility.set_location(l_proc,40);
1623: -- Standard link flag can only be 'Y' if processing type is 'R', i.e. recurring
1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');
1625: fnd_message.raise_error;
1626: end if;
1627: --
1628: hr_utility.set_location(l_proc,40);

Line 1625: fnd_message.raise_error;

1621: then
1622: hr_utility.set_location(l_proc,40);
1623: -- Standard link flag can only be 'Y' if processing type is 'R', i.e. recurring
1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');
1625: fnd_message.raise_error;
1626: end if;
1627: --
1628: hr_utility.set_location(l_proc,40);
1629: --

Line 1639: fnd_message.set_name('PAY', 'PAY_33093_LINK_NO_PAY_BASIS');

1635: open csr_pay_basis_exists;
1636: fetch csr_pay_basis_exists into l_pay_basis_exists;
1637: if csr_pay_basis_exists%found then
1638: close csr_pay_basis_exists;
1639: fnd_message.set_name('PAY', 'PAY_33093_LINK_NO_PAY_BASIS');
1640: fnd_message.raise_error;
1641: end if;
1642: close csr_pay_basis_exists;
1643:

Line 1640: fnd_message.raise_error;

1636: fetch csr_pay_basis_exists into l_pay_basis_exists;
1637: if csr_pay_basis_exists%found then
1638: close csr_pay_basis_exists;
1639: fnd_message.set_name('PAY', 'PAY_33093_LINK_NO_PAY_BASIS');
1640: fnd_message.raise_error;
1641: end if;
1642: close csr_pay_basis_exists;
1643:
1644: */