DBA Data[Home] [Help]

APPS.OTA_TCC_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

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

189: IF NOT ota_tcc_shd.api_updating
190: (p_cross_charge_id => p_rec.cross_charge_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;

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

190: (p_cross_charge_id => p_rec.cross_charge_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --

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

191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --
199: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 196: fnd_message.raise_error;

192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
194: fnd_message.set_token('PROCEDURE ', l_proc);
195: fnd_message.set_token('STEP ', '5');
196: fnd_message.raise_error;
197: END IF;
198: --
199: -- EDIT_HERE: Add checks to ensure non-updateable args have
200: -- not been updated.

Line 265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');

261: If ota_tcc_shd.g_old_rec.end_date_active is not null and
262: nvl(p_end_date_active,hr_api.g_date) >
263: ota_tcc_shd.g_old_rec.end_date_active then
264:
265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
266: fnd_message.raise_error;
267:
268: end if;
269: OPEN TCC;

Line 266: fnd_message.raise_error;

262: nvl(p_end_date_active,hr_api.g_date) >
263: ota_tcc_shd.g_old_rec.end_date_active then
264:
265: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
266: fnd_message.raise_error;
267:
268: end if;
269: OPEN TCC;
270: FETCH TCC INTO l_exists;

Line 272: fnd_message.set_name('OTA','OTA_13330_TCC_DATE_OVERLAP');

268: end if;
269: OPEN TCC;
270: FETCH TCC INTO l_exists;
271: IF TCC%found then
272: fnd_message.set_name('OTA','OTA_13330_TCC_DATE_OVERLAP');
273: fnd_message.raise_error;
274: END IF;
275: CLOSE TCC;
276:

Line 273: fnd_message.raise_error;

269: OPEN TCC;
270: FETCH TCC INTO l_exists;
271: IF TCC%found then
272: fnd_message.set_name('OTA','OTA_13330_TCC_DATE_OVERLAP');
273: fnd_message.raise_error;
274: END IF;
275: CLOSE TCC;
276:
277:

Line 307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');

303: If ota_tcc_shd.g_old_rec.end_date_active is not null and
304: nvl(p_end_date_active,hr_api.g_date) >
305: ota_tcc_shd.g_old_rec.end_date_active then
306:
307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
308: fnd_message.raise_error;
309:
310: end if;
311:

Line 308: fnd_message.raise_error;

304: nvl(p_end_date_active,hr_api.g_date) >
305: ota_tcc_shd.g_old_rec.end_date_active then
306:
307: fnd_message.set_name('OTA','OTA_13348_TCC_EXT_END_DATE');
308: fnd_message.raise_error;
309:
310: end if;
311:
312:

Line 353: fnd_message.set_name('OTA','OTA_13334_TCC_TYPE_INVALID');

349: if hr_api.not_exists_in_hrstanlookups
350: (p_effective_date => p_effective_date
351: ,p_lookup_type => 'OTA_CROSS_CHARGE_TYPE'
352: ,p_lookup_code => p_type) then
353: fnd_message.set_name('OTA','OTA_13334_TCC_TYPE_INVALID');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Leaving:'||l_proc, 30);
357:

Line 354: fnd_message.raise_error;

350: (p_effective_date => p_effective_date
351: ,p_lookup_type => 'OTA_CROSS_CHARGE_TYPE'
352: ,p_lookup_code => p_type) then
353: fnd_message.set_name('OTA','OTA_13334_TCC_TYPE_INVALID');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Leaving:'||l_proc, 30);
357:
358: end if;

Line 399: fnd_message.set_name('OTA','OTA_13341_TCC_FROM_TO_INVALID');

395: if hr_api.not_exists_in_hrstanlookups
396: (p_effective_date => p_effective_date
397: ,p_lookup_type => 'OTA_CROSS_CHARGE_FROM_TO'
398: ,p_lookup_code => p_from_to) then
399: fnd_message.set_name('OTA','OTA_13341_TCC_FROM_TO_INVALID');
400: fnd_message.raise_error;
401: end if;
402: hr_utility.set_location(' Leaving:'||l_proc, 30);
403:

Line 400: fnd_message.raise_error;

396: (p_effective_date => p_effective_date
397: ,p_lookup_type => 'OTA_CROSS_CHARGE_FROM_TO'
398: ,p_lookup_code => p_from_to) then
399: fnd_message.set_name('OTA','OTA_13341_TCC_FROM_TO_INVALID');
400: fnd_message.raise_error;
401: end if;
402: hr_utility.set_location(' Leaving:'||l_proc, 30);
403:
404: end if;