DBA Data[Home] [Help]

APPS.OTA_ACI_BUS dependencies on FND_MESSAGE

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

70: close csr_sec_grp;
71: --
72: -- The primary key is invalid therefore we must error
73: --
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: hr_multi_message.add
76: (p_associated_column1
77: => nvl(p_associated_column1,'ACTIVITY_VERSION_ID')
78: ,p_associated_column2

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

164: --
165: -- The primary key is invalid therefore we must error
166: --
167: close csr_leg_code;
168: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location(v_proc,30);
172: --

Line 169: fnd_message.raise_error;

165: -- The primary key is invalid therefore we must error
166: --
167: close csr_leg_code;
168: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location(v_proc,30);
172: --
173: -- Set the global variables so the values are

Line 371: fnd_message.set_name('PER', 'HR_6153_ALv_procEDURE_FAIL');

367: (p_activity_version_id => p_rec.activity_version_id
368: ,p_category_usage_id => p_rec.category_usage_id
369: ,p_object_version_number => p_rec.object_version_number
370: ) THEN
371: fnd_message.set_name('PER', 'HR_6153_ALv_procEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE ', v_proc);
373: fnd_message.set_token('STEP ', '5');
374: fnd_message.raise_error;
375: END IF;

Line 372: fnd_message.set_token('PROCEDURE ', v_proc);

368: ,p_category_usage_id => p_rec.category_usage_id
369: ,p_object_version_number => p_rec.object_version_number
370: ) THEN
371: fnd_message.set_name('PER', 'HR_6153_ALv_procEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE ', v_proc);
373: fnd_message.set_token('STEP ', '5');
374: fnd_message.raise_error;
375: END IF;
376: --

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

369: ,p_object_version_number => p_rec.object_version_number
370: ) THEN
371: fnd_message.set_name('PER', 'HR_6153_ALv_procEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE ', v_proc);
373: fnd_message.set_token('STEP ', '5');
374: fnd_message.raise_error;
375: END IF;
376: --
377: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 374: fnd_message.raise_error;

370: ) THEN
371: fnd_message.set_name('PER', 'HR_6153_ALv_procEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE ', v_proc);
373: fnd_message.set_token('STEP ', '5');
374: fnd_message.raise_error;
375: END IF;
376: --
377: -- EDIT_HERE: Add checks to ensure non-updateable args have
378: -- not been updated.

Line 450: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');

446: IF ( l_cat_start_date > l_course_start_date
447: or l_cat_end_date < l_course_end_date
448: ) THEN
449: --
450: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
451: fnd_message.raise_error;
452: --
453: End IF;
454: --

Line 451: fnd_message.raise_error;

447: or l_cat_end_date < l_course_end_date
448: ) THEN
449: --
450: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
451: fnd_message.raise_error;
452: --
453: End IF;
454: --
455: End IF;

Line 531: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');

527: --
528: if sel_multiple_primary%found then
529: close sel_multiple_primary;
530:
531: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
532: fnd_message.raise_error;
533: end if;
534: close sel_multiple_primary;
535: --

Line 532: fnd_message.raise_error;

528: if sel_multiple_primary%found then
529: close sel_multiple_primary;
530:
531: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
532: fnd_message.raise_error;
533: end if;
534: close sel_multiple_primary;
535: --
536: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 573: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');

569: --
570: if sel_primary_category%found then
571: close sel_primary_category;
572:
573: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
574: fnd_message.raise_error;
575: end if;
576: close sel_primary_category;
577: --

Line 574: fnd_message.raise_error;

570: if sel_primary_category%found then
571: close sel_primary_category;
572:
573: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
574: fnd_message.raise_error;
575: end if;
576: close sel_primary_category;
577: --
578: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 723: fnd_message.set_name('OTA', 'OTA_443267_DCI_DATES');

719: End if;
720: --
721:
722: if l_error = true then
723: fnd_message.set_name('OTA', 'OTA_443267_DCI_DATES');
724: fnd_message.raise_error;
725: l_error := false;
726: end if;
727:

Line 724: fnd_message.raise_error;

720: --
721:
722: if l_error = true then
723: fnd_message.set_name('OTA', 'OTA_443267_DCI_DATES');
724: fnd_message.raise_error;
725: l_error := false;
726: end if;
727:
728: Fetch sel_check_dates into v_start_date

Line 843: fnd_message.set_name('OTA', 'OTA_443533_ACI_AVT_DATES');

839: End if;
840: --
841:
842: if l_error = true then
843: fnd_message.set_name('OTA', 'OTA_443533_ACI_AVT_DATES');
844: fnd_message.raise_error;
845: l_error := false;
846: end if;
847:

Line 844: fnd_message.raise_error;

840: --
841:
842: if l_error = true then
843: fnd_message.set_name('OTA', 'OTA_443533_ACI_AVT_DATES');
844: fnd_message.raise_error;
845: l_error := false;
846: end if;
847:
848: Fetch sel_check_dates into v_start_date

Line 906: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');

902: --
903: if sel_unique_key%found then
904: close sel_unique_key;
905:
906: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
907: fnd_message.raise_error;
908: end if;
909: close sel_unique_key;
910: --

Line 907: fnd_message.raise_error;

903: if sel_unique_key%found then
904: close sel_unique_key;
905:
906: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
907: fnd_message.raise_error;
908: end if;
909: close sel_unique_key;
910: --
911: hr_utility.set_location(' Leaving:'|| v_proc, 10);