DBA Data[Home] [Help]

APPS.PER_RAA_BUS dependencies on FND_MESSAGE

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

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'RECRUITMENT_ACTIVITY_ID')
64: );

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: hr_utility.set_location(l_proc,30);
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: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

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

328: if NOT per_raa_shd.api_updating
329: (p_recruitment_activity_id => p_rec.recruitment_activity_id
330: ,p_object_version_number => p_rec.object_version_number
331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE ', l_proc);
334: fnd_message.set_token('STEP ', '5');
335: fnd_message.raise_error;
336: END if;

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

329: (p_recruitment_activity_id => p_rec.recruitment_activity_id
330: ,p_object_version_number => p_rec.object_version_number
331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE ', l_proc);
334: fnd_message.set_token('STEP ', '5');
335: fnd_message.raise_error;
336: END if;
337: --

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

330: ,p_object_version_number => p_rec.object_version_number
331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE ', l_proc);
334: fnd_message.set_token('STEP ', '5');
335: fnd_message.raise_error;
336: END if;
337: --
338: -- Add checks to ensure non-updateable args have

Line 335: fnd_message.raise_error;

331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE ', l_proc);
334: fnd_message.set_token('STEP ', '5');
335: fnd_message.raise_error;
336: END if;
337: --
338: -- Add checks to ensure non-updateable args have
339: -- not been updated.

Line 423: fnd_message.set_name('PER','IRC_412123_DUPLICATE_REC_ACTIV');

419: --
420: if(csr_name%found) then
421: hr_utility.set_location(l_proc,40);
422: close csr_name;
423: fnd_message.set_name('PER','IRC_412123_DUPLICATE_REC_ACTIV');
424: fnd_message.raise_error;
425: end if;
426: close csr_name;
427: end if;

Line 424: fnd_message.raise_error;

420: if(csr_name%found) then
421: hr_utility.set_location(l_proc,40);
422: close csr_name;
423: fnd_message.set_name('PER','IRC_412123_DUPLICATE_REC_ACTIV');
424: fnd_message.raise_error;
425: end if;
426: close csr_name;
427: end if;
428: --

Line 520: fnd_message.set_name('PER','PER_289429_RAA_INV_AUTH_PERSON');

516: open csr_authorising_person_id;
517: fetch csr_authorising_person_id into l_authorising_person_id;
518: if csr_authorising_person_id%NOTFOUND then
519: close csr_authorising_person_id;
520: fnd_message.set_name('PER','PER_289429_RAA_INV_AUTH_PERSON');
521: fnd_message.raise_error;
522: end if;
523: close csr_authorising_person_id;
524: -- check that system person type is EMP or CWK.

Line 521: fnd_message.raise_error;

517: fetch csr_authorising_person_id into l_authorising_person_id;
518: if csr_authorising_person_id%NOTFOUND then
519: close csr_authorising_person_id;
520: fnd_message.set_name('PER','PER_289429_RAA_INV_AUTH_PERSON');
521: fnd_message.raise_error;
522: end if;
523: close csr_authorising_person_id;
524: -- check that system person type is EMP or CWK.
525: hr_utility.set_location(l_proc,40);

Line 530: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');

526: open csr_system_person_type;
527: fetch csr_system_person_type into l_system_person_type;
528: if csr_system_person_type%NOTFOUND then
529: close csr_system_person_type;
530: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');
531: fnd_message.raise_error;
532: end if;
533: close csr_system_person_type;
534: --

Line 531: fnd_message.raise_error;

527: fetch csr_system_person_type into l_system_person_type;
528: if csr_system_person_type%NOTFOUND then
529: close csr_system_person_type;
530: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');
531: fnd_message.raise_error;
532: end if;
533: close csr_system_person_type;
534: --
535: end if;

Line 614: fnd_message.set_name('PER','PER_289431_RAA_INV_RUN_BY_ORG');

610: open csr_run_by_organization_id;
611: fetch csr_run_by_organization_id into l_run_by_organization_id;
612: if csr_run_by_organization_id%NOTFOUND then
613: close csr_run_by_organization_id;
614: fnd_message.set_name('PER','PER_289431_RAA_INV_RUN_BY_ORG');
615: fnd_message.raise_error;
616: end if;
617: close csr_run_by_organization_id;
618: --

Line 615: fnd_message.raise_error;

611: fetch csr_run_by_organization_id into l_run_by_organization_id;
612: if csr_run_by_organization_id%NOTFOUND then
613: close csr_run_by_organization_id;
614: fnd_message.set_name('PER','PER_289431_RAA_INV_RUN_BY_ORG');
615: fnd_message.raise_error;
616: end if;
617: close csr_run_by_organization_id;
618: --
619: end if;

Line 715: fnd_message.set_name('PER','PER_289432_RAA_INV_CONT_PERSON');

711: open csr_internal_contact_person_id;
712: fetch csr_internal_contact_person_id into l_internal_contact_person_id;
713: if csr_internal_contact_person_id%NOTFOUND then
714: close csr_internal_contact_person_id;
715: fnd_message.set_name('PER','PER_289432_RAA_INV_CONT_PERSON');
716: fnd_message.raise_error;
717: end if;
718: close csr_internal_contact_person_id;
719:

Line 716: fnd_message.raise_error;

712: fetch csr_internal_contact_person_id into l_internal_contact_person_id;
713: if csr_internal_contact_person_id%NOTFOUND then
714: close csr_internal_contact_person_id;
715: fnd_message.set_name('PER','PER_289432_RAA_INV_CONT_PERSON');
716: fnd_message.raise_error;
717: end if;
718: close csr_internal_contact_person_id;
719:
720: -- check that system person type is EMP or CWK.

Line 726: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');

722: open csr_system_person_type;
723: fetch csr_system_person_type into l_system_person_type;
724: if csr_system_person_type%NOTFOUND then
725: close csr_system_person_type;
726: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');
727: fnd_message.raise_error;
728: end if;
729: close csr_system_person_type;
730: --

Line 727: fnd_message.raise_error;

723: fetch csr_system_person_type into l_system_person_type;
724: if csr_system_person_type%NOTFOUND then
725: close csr_system_person_type;
726: fnd_message.set_name('PER','PER_289430_RAA_INV_PERSON_TYPE');
727: fnd_message.raise_error;
728: end if;
729: close csr_system_person_type;
730: --
731: end if;

Line 839: fnd_message.set_name('PER','PER_289433_RAA_INV_PARENT_ACTI');

835: open csr_parent_recruitment_activit;
836: fetch csr_parent_recruitment_activit into l_parent_recruitment_activity_;
837: if csr_parent_recruitment_activit%NOTFOUND then
838: close csr_parent_recruitment_activit;
839: fnd_message.set_name('PER','PER_289433_RAA_INV_PARENT_ACTI');
840: fnd_message.raise_error;
841: end if;
842: close csr_parent_recruitment_activit;
843:

Line 840: fnd_message.raise_error;

836: fetch csr_parent_recruitment_activit into l_parent_recruitment_activity_;
837: if csr_parent_recruitment_activit%NOTFOUND then
838: close csr_parent_recruitment_activit;
839: fnd_message.set_name('PER','PER_289433_RAA_INV_PARENT_ACTI');
840: fnd_message.raise_error;
841: end if;
842: close csr_parent_recruitment_activit;
843:
844: hr_utility.set_location(l_proc,35);

Line 850: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');

846: -- Checks that parent_recruitment_activity_id is not equal to
847: -- recruitment_activity_id of current row.
848: hr_utility.set_location(l_proc,40);
849: if p_parent_recruitment_activity = p_recruitment_activity_id then
850: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');
851: fnd_message.raise_error;
852: end if;
853: -- Checks that parent_recruitment_activity_id is not equal to
854: -- recruiment_activity_id of any row for which

Line 851: fnd_message.raise_error;

847: -- recruitment_activity_id of current row.
848: hr_utility.set_location(l_proc,40);
849: if p_parent_recruitment_activity = p_recruitment_activity_id then
850: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');
851: fnd_message.raise_error;
852: end if;
853: -- Checks that parent_recruitment_activity_id is not equal to
854: -- recruiment_activity_id of any row for which
855: -- parent_recruitment_activity_id

Line 862: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');

858: open csr_recruitment_activity_id;
859: fetch csr_recruitment_activity_id into l_recruitment_activity_id;
860: if csr_recruitment_activity_id%NOTFOUND then
861: close csr_recruitment_activity_id;
862: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');
863: fnd_message.raise_error;
864: end if;
865: close csr_recruitment_activity_id;
866: end if;

Line 863: fnd_message.raise_error;

859: fetch csr_recruitment_activity_id into l_recruitment_activity_id;
860: if csr_recruitment_activity_id%NOTFOUND then
861: close csr_recruitment_activity_id;
862: fnd_message.set_name('PER','PER_289434_RAA_INV_PARENT_ACTI');
863: fnd_message.raise_error;
864: end if;
865: close csr_recruitment_activity_id;
866: end if;
867: --

Line 953: fnd_message.set_name('PER','PER_289435_RAA_INV_CURRENCY_CO');

949: open csr_currency_code;
950: fetch csr_currency_code into l_currency_code;
951: if csr_currency_code%NOTFOUND then
952: close csr_currency_code;
953: fnd_message.set_name('PER','PER_289435_RAA_INV_CURRENCY_CO');
954: fnd_message.raise_error;
955: end if;
956: close csr_currency_code;
957: --

Line 954: fnd_message.raise_error;

950: fetch csr_currency_code into l_currency_code;
951: if csr_currency_code%NOTFOUND then
952: close csr_currency_code;
953: fnd_message.set_name('PER','PER_289435_RAA_INV_CURRENCY_CO');
954: fnd_message.raise_error;
955: end if;
956: close csr_currency_code;
957: --
958: end if;

Line 1037: fnd_message.set_name('PER','PER_289880_BAD_REC_SITE_ID');

1033: open csr_recruiting_site_id;
1034: fetch csr_recruiting_site_id into l_recruiting_site_id;
1035: if csr_recruiting_site_id%NOTFOUND then
1036: close csr_recruiting_site_id;
1037: fnd_message.set_name('PER','PER_289880_BAD_REC_SITE_ID');
1038: fnd_message.raise_error;
1039: end if;
1040: close csr_recruiting_site_id;
1041: end if;

Line 1038: fnd_message.raise_error;

1034: fetch csr_recruiting_site_id into l_recruiting_site_id;
1035: if csr_recruiting_site_id%NOTFOUND then
1036: close csr_recruiting_site_id;
1037: fnd_message.set_name('PER','PER_289880_BAD_REC_SITE_ID');
1038: fnd_message.raise_error;
1039: end if;
1040: close csr_recruiting_site_id;
1041: end if;
1042: end if;

Line 1120: fnd_message.set_name('PER','PER_289436_RAA_INV_PERSON_TYPE');

1116: open csr_posting_content_id;
1117: fetch csr_posting_content_id into l_posting_content_id;
1118: if csr_posting_content_id%NOTFOUND then
1119: close csr_posting_content_id;
1120: fnd_message.set_name('PER','PER_289436_RAA_INV_PERSON_TYPE');
1121: fnd_message.raise_error;
1122: end if;
1123: close csr_posting_content_id;
1124: end if;

Line 1121: fnd_message.raise_error;

1117: fetch csr_posting_content_id into l_posting_content_id;
1118: if csr_posting_content_id%NOTFOUND then
1119: close csr_posting_content_id;
1120: fnd_message.set_name('PER','PER_289436_RAA_INV_PERSON_TYPE');
1121: fnd_message.raise_error;
1122: end if;
1123: close csr_posting_content_id;
1124: end if;
1125: end if;

Line 1198: fnd_message.set_name('PER','PER_289438_RAA_START_DATE_REQ');

1194: ) or (NOT l_api_updating) then
1195: -- Checks that date_start is not null.
1196: hr_utility.set_location(l_proc,30);
1197: if p_date_start is null then
1198: fnd_message.set_name('PER','PER_289438_RAA_START_DATE_REQ');
1199: hr_multi_message.add
1200: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'
1201: );
1202: -- Call to raise any errors on multi-message list

Line 1208: fnd_message.set_name('PER','HR_6021_ALL_START_END_DATE');

1204: else
1205: -- Checks that date_start is not later then corresponding date_end
1206: hr_utility.set_location(l_proc,40);
1207: if p_date_start > p_date_end then
1208: fnd_message.set_name('PER','HR_6021_ALL_START_END_DATE');
1209: hr_multi_message.add
1210: (p_associated_column1 => 'PER_RECRUITMENT_ACTIVITIES.DATE_START'
1211: ,p_associated_column2 => 'PER_RECRUITMENT_ACTIVITIES.DATE_END'
1212: );

Line 1282: fnd_message.set_name('PER','PER_289439_RAA_INV_CHECK_TYPE');

1278: p_effective_date => p_effective_date
1279: ,p_lookup_type => 'REC_TYPE'
1280: ,p_lookup_code => p_type);
1281: if l_ret = true then
1282: fnd_message.set_name('PER','PER_289439_RAA_INV_CHECK_TYPE');
1283: fnd_message.raise_error;
1284: end if;
1285: end if;
1286: end if;

Line 1283: fnd_message.raise_error;

1279: ,p_lookup_type => 'REC_TYPE'
1280: ,p_lookup_code => p_type);
1281: if l_ret = true then
1282: fnd_message.set_name('PER','PER_289439_RAA_INV_CHECK_TYPE');
1283: fnd_message.raise_error;
1284: end if;
1285: end if;
1286: end if;
1287: --

Line 1360: fnd_message.set_name('PER','HR_6114_RAC_CLOSE_DATE');

1356:
1357: -- Checks that date_start is not later then corresponding date_closing
1358: hr_utility.set_location(l_proc,30);
1359: if p_date_start > p_date_closing then
1360: fnd_message.set_name('PER','HR_6114_RAC_CLOSE_DATE');
1361: fnd_message.raise_error;
1362: end if;
1363: end if;
1364: end if;

Line 1361: fnd_message.raise_error;

1357: -- Checks that date_start is not later then corresponding date_closing
1358: hr_utility.set_location(l_proc,30);
1359: if p_date_start > p_date_closing then
1360: fnd_message.set_name('PER','HR_6114_RAC_CLOSE_DATE');
1361: fnd_message.raise_error;
1362: end if;
1363: end if;
1364: end if;
1365: --

Line 1442: fnd_message.set_name('PER','PER_289440_RAA_INV_CHECK_STATU');

1438: p_effective_date => p_effective_date
1439: ,p_lookup_type => 'REC_STATUS'
1440: ,p_lookup_code => p_status);
1441: if l_ret = true then
1442: fnd_message.set_name('PER','PER_289440_RAA_INV_CHECK_STATU');
1443: fnd_message.raise_error;
1444: end if;
1445: end if;
1446: end if;

Line 1443: fnd_message.raise_error;

1439: ,p_lookup_type => 'REC_STATUS'
1440: ,p_lookup_code => p_status);
1441: if l_ret = true then
1442: fnd_message.set_name('PER','PER_289440_RAA_INV_CHECK_STATU');
1443: fnd_message.raise_error;
1444: end if;
1445: end if;
1446: end if;
1447: --

Line 1516: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');

1512:
1513: -- Checks that actual_cost is greater then zero
1514: hr_utility.set_location(l_proc,30);
1515: if p_actual_cost < 0 then
1516: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1517: fnd_message.raise_error;
1518: end if;
1519: end if;
1520: end if;

Line 1517: fnd_message.raise_error;

1513: -- Checks that actual_cost is greater then zero
1514: hr_utility.set_location(l_proc,30);
1515: if p_actual_cost < 0 then
1516: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1517: fnd_message.raise_error;
1518: end if;
1519: end if;
1520: end if;
1521: --

Line 1591: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');

1587:
1588: -- Checks that planned_cost is greater then zero
1589: hr_utility.set_location(l_proc,30);
1590: if p_planned_cost < 0 then
1591: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1592: fnd_message.raise_error;
1593: end if;
1594: end if;
1595: end if;

Line 1592: fnd_message.raise_error;

1588: -- Checks that planned_cost is greater then zero
1589: hr_utility.set_location(l_proc,30);
1590: if p_planned_cost < 0 then
1591: fnd_message.set_name( 'PER','PAY_6779_DEF_CURR_UNIT_ZERO');
1592: fnd_message.raise_error;
1593: end if;
1594: end if;
1595: end if;
1596: --