DBA Data[Home] [Help]

APPS.HR_QSN_BUS dependencies on FND_MESSAGE

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

80: if not hr_qsn_shd.api_updating
81: (p_questionnaire_template_id => p_rec.questionnaire_template_id
82: ,p_object_version_number => p_rec.object_version_number
83: ) then
84: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE',l_proc);
86: fnd_message.set_token('STEP',20);
87: fnd_message.raise_error;
88: end if;

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

81: (p_questionnaire_template_id => p_rec.questionnaire_template_id
82: ,p_object_version_number => p_rec.object_version_number
83: ) then
84: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE',l_proc);
86: fnd_message.set_token('STEP',20);
87: fnd_message.raise_error;
88: end if;
89: hr_utility.set_location(l_proc,30);

Line 86: fnd_message.set_token('STEP',20);

82: ,p_object_version_number => p_rec.object_version_number
83: ) then
84: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE',l_proc);
86: fnd_message.set_token('STEP',20);
87: fnd_message.raise_error;
88: end if;
89: hr_utility.set_location(l_proc,30);
90: --

Line 87: fnd_message.raise_error;

83: ) then
84: fnd_message.set_name('PER','HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE',l_proc);
86: fnd_message.set_token('STEP',20);
87: fnd_message.raise_error;
88: end if;
89: hr_utility.set_location(l_proc,30);
90: --
91: if nvl(p_rec.name,hr_api.g_varchar2) <> hr_qsn_shd.g_old_rec.name then

Line 160: fnd_message.set_name('PER','PER_52412_QSN_MAND_NAME');

156: end if;
157: close csr_unique_name;
158: else
159: -- Name is null - raise error
160: fnd_message.set_name('PER','PER_52412_QSN_MAND_NAME');
161: fnd_message.raise_error;
162: end if;
163: --
164: hr_utility.set_location(' Leaving: '||l_proc, 50);

Line 161: fnd_message.raise_error;

157: close csr_unique_name;
158: else
159: -- Name is null - raise error
160: fnd_message.set_name('PER','PER_52412_QSN_MAND_NAME');
161: fnd_message.raise_error;
162: end if;
163: --
164: hr_utility.set_location(' Leaving: '||l_proc, 50);
165: exception when app_exception.application_exception then

Line 195: -- fnd_message.set_name('PER','PER_52414_QSN_TEXT_OVERSIZED');

191: if p_text is not null then
192: -- Check the size of the text is less than max size
193: -- if Length(p_text) > c_max_size then
194: -- greater then max, so raise error
195: -- fnd_message.set_name('PER','PER_52414_QSN_TEXT_OVERSIZED');
196: -- fnd_message.raise_error;
197: -- end if;
198: null;
199: else

Line 196: -- fnd_message.raise_error;

192: -- Check the size of the text is less than max size
193: -- if Length(p_text) > c_max_size then
194: -- greater then max, so raise error
195: -- fnd_message.set_name('PER','PER_52414_QSN_TEXT_OVERSIZED');
196: -- fnd_message.raise_error;
197: -- end if;
198: null;
199: else
200: -- Text is mandatory, thus error

Line 201: fnd_message.set_name('PER','PER_52413_QSN_MAND_TEXT');

197: -- end if;
198: null;
199: else
200: -- Text is mandatory, thus error
201: fnd_message.set_name('PER','PER_52413_QSN_MAND_TEXT');
202: fnd_message.raise_error;
203: end if;
204: --
205: hr_utility.set_location('Leaving: '||l_proc,50);

Line 202: fnd_message.raise_error;

198: null;
199: else
200: -- Text is mandatory, thus error
201: fnd_message.set_name('PER','PER_52413_QSN_MAND_TEXT');
202: fnd_message.raise_error;
203: end if;
204: --
205: hr_utility.set_location('Leaving: '||l_proc,50);
206: exception when app_exception.application_exception then

Line 260: fnd_message.set_name('PER','PER_52415_QSN_INVAL_FLG_ON_INS');

256: -- during the process of creation itself. hence foll. check is not required
257: /* elsif not l_api_updating then
258: -- INSERT - validate that flag is 'N'
259: if nvl(p_available_flag,hr_api.g_varchar2) <> 'N' then
260: fnd_message.set_name('PER','PER_52415_QSN_INVAL_FLG_ON_INS');
261: fnd_message.raise_error;
262: end if; */
263: else
264: -- UPDATE and not changed - no need to validate

Line 261: fnd_message.raise_error;

257: /* elsif not l_api_updating then
258: -- INSERT - validate that flag is 'N'
259: if nvl(p_available_flag,hr_api.g_varchar2) <> 'N' then
260: fnd_message.set_name('PER','PER_52415_QSN_INVAL_FLG_ON_INS');
261: fnd_message.raise_error;
262: end if; */
263: else
264: -- UPDATE and not changed - no need to validate
265: null;

Line 312: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');

308: fetch csr_chk_child_row into l_exists;
309: if csr_chk_child_row%FOUND then
310: -- Raise error, as child row exists
311: close csr_chk_child_row;
312: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');
313: fnd_message.raise_error;
314: end if;
315: close csr_chk_child_row;
316: --

Line 313: fnd_message.raise_error;

309: if csr_chk_child_row%FOUND then
310: -- Raise error, as child row exists
311: close csr_chk_child_row;
312: fnd_message.set_name('PER','PER_52442_QSA_CHILD_EXISTS');
313: fnd_message.raise_error;
314: end if;
315: close csr_chk_child_row;
316: --
317: hr_utility.set_location('Leaving: '||l_proc, 20);

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

459: --
460: -- The primary key is invalid therefore we must error
461: --
462: close csr_leg_code;
463: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
464: fnd_message.raise_error;
465: end if;
466: hr_utility.set_location(l_proc, 30);
467: --

Line 464: fnd_message.raise_error;

460: -- The primary key is invalid therefore we must error
461: --
462: close csr_leg_code;
463: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
464: fnd_message.raise_error;
465: end if;
466: hr_utility.set_location(l_proc, 30);
467: --
468: -- Set the global variables so the values are