DBA Data[Home] [Help]

APPS.PAY_SDB_BUS dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('PAY', 'PAY_50090_SDB_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_50090_SDB_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_50090_SDB_CORE_ROW_EXISTS');
56: fnd_message.raise_error;
57: end if;
58: close csr_disallow_update;
59: --
60: -- p_balance_type_id

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

117: fetch csr_exclusion_rule_id_valid into l_valid;
118: if csr_exclusion_rule_id_valid%notfound then
119: hr_utility.set_location('Leaving:'||l_proc, 10);
120: close csr_exclusion_rule_id_valid;
121: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
122: fnd_message.raise_error;
123: end if;
124: close csr_exclusion_rule_id_valid;
125: end if;

Line 122: fnd_message.raise_error;

118: if csr_exclusion_rule_id_valid%notfound then
119: hr_utility.set_location('Leaving:'||l_proc, 10);
120: close csr_exclusion_rule_id_valid;
121: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
122: fnd_message.raise_error;
123: end if;
124: close csr_exclusion_rule_id_valid;
125: end if;
126: end if;

Line 164: fnd_message.set_name('PAY', 'PAY_50086_ETM_INVALID_BAL_TYPE');

160: fetch csr_balance_type_exists into l_exists;
161: if csr_balance_type_exists%notfound then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: close csr_balance_type_exists;
164: fnd_message.set_name('PAY', 'PAY_50086_ETM_INVALID_BAL_TYPE');
165: fnd_message.raise_error;
166: end if;
167: close csr_balance_type_exists;
168: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 165: fnd_message.raise_error;

161: if csr_balance_type_exists%notfound then
162: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: close csr_balance_type_exists;
164: fnd_message.set_name('PAY', 'PAY_50086_ETM_INVALID_BAL_TYPE');
165: fnd_message.raise_error;
166: end if;
167: close csr_balance_type_exists;
168: hr_utility.set_location(' Leaving:'||l_proc, 15);
169: End chk_balance_type_id;

Line 219: fnd_message.set_name('PAY', 'PAY_50091_SDB_DEF_BAL_EXISTS');

215: fetch csr_defined_balance_exists into l_exists;
216: if csr_defined_balance_exists%found then
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: close csr_defined_balance_exists;
219: fnd_message.set_name('PAY', 'PAY_50091_SDB_DEF_BAL_EXISTS');
220: fnd_message.raise_error;
221: end if;
222: close csr_defined_balance_exists;
223: end if;

Line 220: fnd_message.raise_error;

216: if csr_defined_balance_exists%found then
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: close csr_defined_balance_exists;
219: fnd_message.set_name('PAY', 'PAY_50091_SDB_DEF_BAL_EXISTS');
220: fnd_message.raise_error;
221: end if;
222: close csr_defined_balance_exists;
223: end if;
224: hr_utility.set_location(' Leaving:'||l_proc, 25);

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

257: ,p_lookup_code => p_force_latest_balance_flag
258: )
259: then
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');
264: fnd_message.raise_error;
265: end if;

Line 262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

258: )
259: then
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');
264: fnd_message.raise_error;
265: end if;
266: end if;

Line 263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');

259: then
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');
264: fnd_message.raise_error;
265: end if;
266: end if;
267: end if;

Line 264: fnd_message.raise_error;

260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
262: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
263: fnd_message.set_token('COLUMN', 'FORCE_LATEST_BALANCE_FLAG');
264: fnd_message.raise_error;
265: end if;
266: end if;
267: end if;
268: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

301: ,p_lookup_code => p_grossup_allowed_flag
302: )
303: then
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');
308: fnd_message.raise_error;
309: end if;

Line 306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');

302: )
303: then
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');
308: fnd_message.raise_error;
309: end if;
310: end if;

Line 307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');

303: then
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');
308: fnd_message.raise_error;
309: end if;
310: end if;
311: end if;

Line 308: fnd_message.raise_error;

304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
306: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
307: fnd_message.set_token('COLUMN', 'GROSSUP_ALLOWED_FLAG');
308: fnd_message.raise_error;
309: end if;
310: end if;
311: end if;
312: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 362: fnd_message.set_name('PAY', 'PAY_50092_SDB_INVALID_DELETE');

358: close csr_bal_attributes;
359: hr_utility.set_location(' Leaving:'||l_proc, 15);
360: exception
361: when l_error then
362: fnd_message.set_name('PAY', 'PAY_50092_SDB_INVALID_DELETE');
363: fnd_message.raise_error;
364: when others then
365: hr_utility.set_location(' Leaving:'||l_proc, 20);
366: raise;

Line 363: fnd_message.raise_error;

359: hr_utility.set_location(' Leaving:'||l_proc, 15);
360: exception
361: when l_error then
362: fnd_message.set_name('PAY', 'PAY_50092_SDB_INVALID_DELETE');
363: fnd_message.raise_error;
364: when others then
365: hr_utility.set_location(' Leaving:'||l_proc, 20);
366: raise;
367: End chk_delete;