DBA Data[Home] [Help]

APPS.PAY_SFR_BUS dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('PAY', 'PAY_50094_SFR_CORE_ROW_EXISTS');

51: fetch csr_disallow_update into l_disallow;
52: if csr_disallow_update%found then
53: hr_utility.set_location(l_proc, 20);
54: close csr_disallow_update;
55: fnd_message.set_name('PAY', 'PAY_50094_SFR_CORE_ROW_EXISTS');
56: fnd_message.raise_error;
57: end if;
58: close csr_disallow_update;
59: --

Line 56: fnd_message.raise_error;

52: if csr_disallow_update%found then
53: hr_utility.set_location(l_proc, 20);
54: close csr_disallow_update;
55: fnd_message.set_name('PAY', 'PAY_50094_SFR_CORE_ROW_EXISTS');
56: fnd_message.raise_error;
57: end if;
58: close csr_disallow_update;
59: --
60: -- p_shadow_element_type_id

Line 115: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');

111: fetch csr_shadow_element_type_exists into l_exists;
112: if csr_shadow_element_type_exists%notfound then
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: close csr_shadow_element_type_exists;
115: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');
116: fnd_message.raise_error;
117: end if;
118: close csr_shadow_element_type_exists;
119: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 116: fnd_message.raise_error;

112: if csr_shadow_element_type_exists%notfound then
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: close csr_shadow_element_type_exists;
115: fnd_message.set_name('PAY', 'PAY_50095_ETM_INVALID_ELE_TYPE');
116: fnd_message.raise_error;
117: end if;
118: close csr_shadow_element_type_exists;
119: hr_utility.set_location(' Leaving:'||l_proc, 20);
120: End chk_shadow_element_type_id;

Line 163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

159: ,p_lookup_code => p_result_rule_type
160: )
161: then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');
165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;
167: end if;

Line 164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');

160: )
161: then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');
165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;
167: end if;
168: end if;

Line 165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');

161: then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');
165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;
167: end if;
168: end if;
169: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 166: fnd_message.raise_error;

162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
164: fnd_message.set_token('LOOKUP_TYPE', 'RESULT_RULE_TYPE');
165: fnd_message.set_token('COLUMN', 'RESULT_RULE_TYPE');
166: fnd_message.raise_error;
167: end if;
168: end if;
169: hr_utility.set_location(' Leaving:'||l_proc, 20);
170: End chk_result_rule_type;

Line 217: fnd_message.set_name('PAY', 'PAY_50096_SFR_ELE_ETM_MISMATCH');

213: fetch csr_element_type_exists into l_exists;
214: if csr_element_type_exists%notfound then
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: close csr_element_type_exists;
217: fnd_message.set_name('PAY', 'PAY_50096_SFR_ELE_ETM_MISMATCH');
218: fnd_message.raise_error;
219: end if;
220: close csr_element_type_exists;
221: end if;

Line 218: fnd_message.raise_error;

214: if csr_element_type_exists%notfound then
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: close csr_element_type_exists;
217: fnd_message.set_name('PAY', 'PAY_50096_SFR_ELE_ETM_MISMATCH');
218: fnd_message.raise_error;
219: end if;
220: close csr_element_type_exists;
221: end if;
222: end if;

Line 229: fnd_message.set_name('PAY', 'PAY_50214_SFR_ELE_NOT_NULL');

225: -- null.
226: --
227: if p_element_type_id is not null and p_element_name is not null then
228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: fnd_message.set_name('PAY', 'PAY_50214_SFR_ELE_NOT_NULL');
230: fnd_message.raise_error;
231: end if;
232: hr_utility.set_location(' Leaving:'||l_proc, 20);
233: End chk_element_type_id;

Line 230: fnd_message.raise_error;

226: --
227: if p_element_type_id is not null and p_element_name is not null then
228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: fnd_message.set_name('PAY', 'PAY_50214_SFR_ELE_NOT_NULL');
230: fnd_message.raise_error;
231: end if;
232: hr_utility.set_location(' Leaving:'||l_proc, 20);
233: End chk_element_type_id;
234: -- ----------------------------------------------------------------------------

Line 281: fnd_message.set_name('PAY', 'PAY_50098_ETM_INVALID_INP_VAL');

277: fetch csr_input_value_exists into l_exists;
278: if csr_input_value_exists%notfound then
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: close csr_input_value_exists;
281: fnd_message.set_name('PAY', 'PAY_50098_ETM_INVALID_INP_VAL');
282: fnd_message.raise_error;
283: end if;
284: close csr_input_value_exists;
285: end if;

Line 282: fnd_message.raise_error;

278: if csr_input_value_exists%notfound then
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: close csr_input_value_exists;
281: fnd_message.set_name('PAY', 'PAY_50098_ETM_INVALID_INP_VAL');
282: fnd_message.raise_error;
283: end if;
284: close csr_input_value_exists;
285: end if;
286: end if;

Line 382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');

378: ,p_lookup_code => p_severity_level
379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');
384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');
385: fnd_message.raise_error;
386: end if;

Line 383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');

379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');
384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');
385: fnd_message.raise_error;
386: end if;
387: --

Line 384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');

380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');
384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');
385: fnd_message.raise_error;
386: end if;
387: --
388: -- Severity level must be null otherwise.

Line 385: fnd_message.raise_error;

381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
383: fnd_message.set_token('LOOKUP_TYPE', 'MESSAGE_LEVEL');
384: fnd_message.set_token('COLUMN', 'SEVERITY_LEVEL');
385: fnd_message.raise_error;
386: end if;
387: --
388: -- Severity level must be null otherwise.
389: --

Line 392: fnd_message.set_name('PAY', 'PAY_50097_SFR_SEV_LVL_NOT_NULL');

388: -- Severity level must be null otherwise.
389: --
390: elsif p_severity_level is not null then
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: fnd_message.set_name('PAY', 'PAY_50097_SFR_SEV_LVL_NOT_NULL');
393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);
394: fnd_message.raise_error;
395: end if;
396: end if;

Line 393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);

389: --
390: elsif p_severity_level is not null then
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: fnd_message.set_name('PAY', 'PAY_50097_SFR_SEV_LVL_NOT_NULL');
393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);
394: fnd_message.raise_error;
395: end if;
396: end if;
397: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 394: fnd_message.raise_error;

390: elsif p_severity_level is not null then
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: fnd_message.set_name('PAY', 'PAY_50097_SFR_SEV_LVL_NOT_NULL');
393: fnd_message.set_token('RESULT_RULE_TYPE', p_result_rule_type);
394: fnd_message.raise_error;
395: end if;
396: end if;
397: hr_utility.set_location(' Leaving:'||l_proc, 20);
398: End chk_severity_level;

Line 439: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');

435: fetch csr_exclusion_rule_id_valid into l_valid;
436: if csr_exclusion_rule_id_valid%notfound then
437: hr_utility.set_location('Leaving:'||l_proc, 10);
438: close csr_exclusion_rule_id_valid;
439: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
440: fnd_message.raise_error;
441: end if;
442: close csr_exclusion_rule_id_valid;
443: end if;

Line 440: fnd_message.raise_error;

436: if csr_exclusion_rule_id_valid%notfound then
437: hr_utility.set_location('Leaving:'||l_proc, 10);
438: close csr_exclusion_rule_id_valid;
439: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
440: fnd_message.raise_error;
441: end if;
442: close csr_exclusion_rule_id_valid;
443: end if;
444: end if;

Line 480: fnd_message.set_name('PAY', 'PAY_50099_SFR_INVALID_DELETE');

476: close csr_core_objects;
477: hr_utility.set_location(' Leaving:'||l_proc, 25);
478: exception
479: when l_error then
480: fnd_message.set_name('PAY', 'PAY_50099_SFR_INVALID_DELETE');
481: fnd_message.raise_error;
482: when others then
483: hr_utility.set_location(' Leaving:'||l_proc, 30);
484: raise;

Line 481: fnd_message.raise_error;

477: hr_utility.set_location(' Leaving:'||l_proc, 25);
478: exception
479: when l_error then
480: fnd_message.set_name('PAY', 'PAY_50099_SFR_INVALID_DELETE');
481: fnd_message.raise_error;
482: when others then
483: hr_utility.set_location(' Leaving:'||l_proc, 30);
484: raise;
485: End chk_delete;