DBA Data[Home] [Help]

APPS.OTA_LCI_BUS dependencies on FND_MESSAGE

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

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

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

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

Line 170: fnd_message.raise_error;

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

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

365: (p_learning_path_id => p_rec.learning_path_id
366: ,p_category_usage_id => p_rec.category_usage_id
367: ,p_object_version_number => p_rec.object_version_number
368: ) THEN
369: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
370: fnd_message.set_token('PROCEDURE ', l_proc);
371: fnd_message.set_token('STEP ', '5');
372: fnd_message.raise_error;
373: END IF;

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

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

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

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

Line 372: fnd_message.raise_error;

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

Line 443: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');

439: IF ( l_cat_start_date > l_lp_start_date
440: or l_cat_end_date < l_lp_end_date
441: ) THEN
442: --
443: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');
444: fnd_message.raise_error;
445: --
446: End IF;
447: ELSE

Line 444: fnd_message.raise_error;

440: or l_cat_end_date < l_lp_end_date
441: ) THEN
442: --
443: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');
444: fnd_message.raise_error;
445: --
446: End IF;
447: ELSE
448: CLOSE csr_cat_start_end_date;

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

624: --
625: if sel_multiple_primary%found then
626: close sel_multiple_primary;
627:
628: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
629: fnd_message.raise_error;
630: end if;
631: close sel_multiple_primary;
632: --

Line 629: fnd_message.raise_error;

625: if sel_multiple_primary%found then
626: close sel_multiple_primary;
627:
628: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
629: fnd_message.raise_error;
630: end if;
631: close sel_multiple_primary;
632: --
633: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

679: --
680: if sel_primary_category%found then
681: close sel_primary_category;
682:
683: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
684: fnd_message.raise_error;
685: end if;
686: close sel_primary_category;
687: --

Line 684: fnd_message.raise_error;

680: if sel_primary_category%found then
681: close sel_primary_category;
682:
683: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
684: fnd_message.raise_error;
685: end if;
686: close sel_primary_category;
687: --
688: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

774: --
775: if sel_unique_key%found then
776: close sel_unique_key;
777:
778: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
779: fnd_message.raise_error;
780: end if;
781: close sel_unique_key;
782: --

Line 779: fnd_message.raise_error;

775: if sel_unique_key%found then
776: close sel_unique_key;
777:
778: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
779: fnd_message.raise_error;
780: end if;
781: close sel_unique_key;
782: --
783: hr_utility.set_location(' Leaving:'|| v_proc, 10);