DBA Data[Home] [Help]

APPS.HR_LIP_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

Line 213: fnd_message.set_name('PER', 'HR_DE_ORG_LINK_CHK');

209: (p_organization_link_id => p_organization_link_id);
210: fetch c_organization_link into l_org_link_type;
211: if c_organization_link%notfound then
212: close c_organization_link;
213: fnd_message.set_name('PER', 'HR_DE_ORG_LINK_CHK');
214: fnd_message.raise_error;
215: else
216: close c_organization_link;
217: end if;

Line 214: fnd_message.raise_error;

210: fetch c_organization_link into l_org_link_type;
211: if c_organization_link%notfound then
212: close c_organization_link;
213: fnd_message.set_name('PER', 'HR_DE_ORG_LINK_CHK');
214: fnd_message.raise_error;
215: else
216: close c_organization_link;
217: end if;
218: --

Line 225: fnd_message.set_name('PER', 'HR_DE_LINK_LIABILITY_INS');

221: --
222: -- Check that the organization link has a link type of 'DE_LIABILITY_INSURANCE'.
223: --
224: if not (l_org_link_type = 'DE_LIABILITY_INSURANCE') then
225: fnd_message.set_name('PER', 'HR_DE_LINK_LIABILITY_INS');
226: fnd_message.raise_error;
227: end if;
228: --
229: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 226: fnd_message.raise_error;

222: -- Check that the organization link has a link type of 'DE_LIABILITY_INSURANCE'.
223: --
224: if not (l_org_link_type = 'DE_LIABILITY_INSURANCE') then
225: fnd_message.set_name('PER', 'HR_DE_LINK_LIABILITY_INS');
226: fnd_message.raise_error;
227: end if;
228: --
229: hr_utility.set_location(' Leaving:'|| l_proc, 40);
230: end chk_organization_link_id;

Line 291: fnd_message.set_name('PER', 'HR_DE_CALC_METHOD_LOOKUP_CHK');

287: if hr_api.not_exists_in_hr_lookups
288: (p_effective_date => p_effective_date
289: ,p_lookup_type => 'DE_WORKING_HOURS_CALC_METHOD'
290: ,p_lookup_code => p_calculation_method) then
291: fnd_message.set_name('PER', 'HR_DE_CALC_METHOD_LOOKUP_CHK');
292: fnd_message.raise_error;
293: end if;
294: end if;
295: --

Line 292: fnd_message.raise_error;

288: (p_effective_date => p_effective_date
289: ,p_lookup_type => 'DE_WORKING_HOURS_CALC_METHOD'
290: ,p_lookup_code => p_calculation_method) then
291: fnd_message.set_name('PER', 'HR_DE_CALC_METHOD_LOOKUP_CHK');
292: fnd_message.raise_error;
293: end if;
294: end if;
295: --
296: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 355: fnd_message.set_name('PER', 'HR_DE_WORK_HRS_VALUE_CHK');

351: --
352: -- Check that it is between 0 and 999999999999999.
353: --
354: if not (p_std_working_hours_per_year >= 0 and p_std_working_hours_per_year <= 999999999999999) then
355: fnd_message.set_name('PER', 'HR_DE_WORK_HRS_VALUE_CHK');
356: fnd_message.raise_error;
357: end if;
358: end if;
359: --

Line 356: fnd_message.raise_error;

352: -- Check that it is between 0 and 999999999999999.
353: --
354: if not (p_std_working_hours_per_year >= 0 and p_std_working_hours_per_year <= 999999999999999) then
355: fnd_message.set_name('PER', 'HR_DE_WORK_HRS_VALUE_CHK');
356: fnd_message.raise_error;
357: end if;
358: end if;
359: --
360: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 419: fnd_message.set_name('PER', 'HR_DE_STD_PERC_VALUE_CHK');

415: --
416: -- Check that it is between 0 and 100.
417: --
418: if not (p_std_percentage >= 0 and p_std_percentage <= 100) then
419: fnd_message.set_name('PER', 'HR_DE_STD_PERC_VALUE_CHK');
420: fnd_message.raise_error;
421: end if;
422: end if;
423: --

Line 420: fnd_message.raise_error;

416: -- Check that it is between 0 and 100.
417: --
418: if not (p_std_percentage >= 0 and p_std_percentage <= 100) then
419: fnd_message.set_name('PER', 'HR_DE_STD_PERC_VALUE_CHK');
420: fnd_message.raise_error;
421: end if;
422: end if;
423: --
424: hr_utility.set_location(l_proc, 20);

Line 485: fnd_message.set_name('PER', 'HR_DE_MAX_REM_VALUE_CHK');

481: --
482: -- Check that it is between 0 and 9999999999.99.
483: --
484: if not (p_max_remuneration >= 0 and p_max_remuneration <= 9999999999.99) then
485: fnd_message.set_name('PER', 'HR_DE_MAX_REM_VALUE_CHK');
486: fnd_message.raise_error;
487: end if;
488: null;
489: end if;

Line 486: fnd_message.raise_error;

482: -- Check that it is between 0 and 9999999999.99.
483: --
484: if not (p_max_remuneration >= 0 and p_max_remuneration <= 9999999999.99) then
485: fnd_message.set_name('PER', 'HR_DE_MAX_REM_VALUE_CHK');
486: fnd_message.raise_error;
487: end if;
488: null;
489: end if;
490: --

Line 562: fnd_message.set_name('PER', 'HR_DE_SINGLE_LIAB_PREMIUM_CHK');

558: ,p_validation_end_date => p_validation_end_date);
559: fetch c_liability_premiums into l_dummy;
560: if c_liability_premiums%found then
561: close c_liability_premiums;
562: fnd_message.set_name('PER', 'HR_DE_SINGLE_LIAB_PREMIUM_CHK');
563: fnd_message.raise_error;
564: else
565: close c_liability_premiums;
566: end if;

Line 563: fnd_message.raise_error;

559: fetch c_liability_premiums into l_dummy;
560: if c_liability_premiums%found then
561: close c_liability_premiums;
562: fnd_message.set_name('PER', 'HR_DE_SINGLE_LIAB_PREMIUM_CHK');
563: fnd_message.raise_error;
564: else
565: close c_liability_premiums;
566: end if;
567: --

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

750: (p_liability_premiums_id => p_rec.liability_premiums_id
751: ,p_effective_date => p_effective_date
752: ,p_object_version_number => p_rec.object_version_number
753: ) THEN
754: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
755: fnd_message.set_token('PROCEDURE ', l_proc);
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;

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

751: ,p_effective_date => p_effective_date
752: ,p_object_version_number => p_rec.object_version_number
753: ) THEN
754: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
755: fnd_message.set_token('PROCEDURE ', l_proc);
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;
759: --

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

752: ,p_object_version_number => p_rec.object_version_number
753: ) THEN
754: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
755: fnd_message.set_token('PROCEDURE ', l_proc);
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;
759: --
760: IF NVL(p_rec.organization_link_id, hr_api.g_number) <> NVL(hr_lip_shd.g_old_rec.organization_link_id, hr_api.g_number) THEN

Line 757: fnd_message.raise_error;

753: ) THEN
754: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
755: fnd_message.set_token('PROCEDURE ', l_proc);
756: fnd_message.set_token('STEP ', '5');
757: fnd_message.raise_error;
758: END IF;
759: --
760: IF NVL(p_rec.organization_link_id, hr_api.g_number) <> NVL(hr_lip_shd.g_old_rec.organization_link_id, hr_api.g_number) THEN
761: l_argument := 'organization_link_id';

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

843: --
844: -- A referential integrity check was violated therefore
845: -- we must error
846: --
847: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
848: fnd_message.set_token('TABLE_NAME', l_table_name);
849: fnd_message.raise_error;
850: When Others Then
851: --

Line 848: fnd_message.set_token('TABLE_NAME', l_table_name);

844: -- A referential integrity check was violated therefore
845: -- we must error
846: --
847: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
848: fnd_message.set_token('TABLE_NAME', l_table_name);
849: fnd_message.raise_error;
850: When Others Then
851: --
852: -- An unhandled or unexpected error has occurred which

Line 849: fnd_message.raise_error;

845: -- we must error
846: --
847: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
848: fnd_message.set_token('TABLE_NAME', l_table_name);
849: fnd_message.raise_error;
850: When Others Then
851: --
852: -- An unhandled or unexpected error has occurred which
853: -- we must report

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

851: --
852: -- An unhandled or unexpected error has occurred which
853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;

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

852: -- An unhandled or unexpected error has occurred which
853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --

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

853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --
861: -- ----------------------------------------------------------------------------

Line 858: fnd_message.raise_error;

854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --
861: -- ----------------------------------------------------------------------------
862: -- |--------------------------< dt_delete_validate >--------------------------|

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

950: --
951: -- A referential integrity check was violated therefore
952: -- we must error
953: --
954: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
955: fnd_message.set_token('TABLE_NAME', l_table_name);
956: fnd_message.raise_error;
957: When Others Then
958: --

Line 955: fnd_message.set_token('TABLE_NAME', l_table_name);

951: -- A referential integrity check was violated therefore
952: -- we must error
953: --
954: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
955: fnd_message.set_token('TABLE_NAME', l_table_name);
956: fnd_message.raise_error;
957: When Others Then
958: --
959: -- An unhandled or unexpected error has occurred which

Line 956: fnd_message.raise_error;

952: -- we must error
953: --
954: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
955: fnd_message.set_token('TABLE_NAME', l_table_name);
956: fnd_message.raise_error;
957: When Others Then
958: --
959: -- An unhandled or unexpected error has occurred which
960: -- we must report

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

958: --
959: -- An unhandled or unexpected error has occurred which
960: -- we must report
961: --
962: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
963: fnd_message.set_token('PROCEDURE', l_proc);
964: fnd_message.set_token('STEP','15');
965: fnd_message.raise_error;
966: --

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

959: -- An unhandled or unexpected error has occurred which
960: -- we must report
961: --
962: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
963: fnd_message.set_token('PROCEDURE', l_proc);
964: fnd_message.set_token('STEP','15');
965: fnd_message.raise_error;
966: --
967: End dt_delete_validate;

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

960: -- we must report
961: --
962: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
963: fnd_message.set_token('PROCEDURE', l_proc);
964: fnd_message.set_token('STEP','15');
965: fnd_message.raise_error;
966: --
967: End dt_delete_validate;
968: --

Line 965: fnd_message.raise_error;

961: --
962: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
963: fnd_message.set_token('PROCEDURE', l_proc);
964: fnd_message.set_token('STEP','15');
965: fnd_message.raise_error;
966: --
967: End dt_delete_validate;
968: --
969: -- ----------------------------------------------------------------------------