DBA Data[Home] [Help]

APPS.PAY_PTA_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 192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

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

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

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

Line 195: fnd_message.raise_error;

191: ) THEN
192: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE ', l_proc);
194: fnd_message.set_token('STEP ', '5');
195: fnd_message.raise_error;
196: END IF;
197: --
198: if (nvl(p_rec.table_name, hr_api.g_varchar2) <>
199: nvl(pay_pta_shd.g_old_rec.table_name, hr_api.g_varchar2)

Line 278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');

274: ,p_lookup_code => p_rec.dyn_trigger_type
275: )
276: then
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
282: end if;

Line 279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');

275: )
276: then
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
282: end if;
283: end if;

Line 280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);

276: then
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
282: end if;
283: end if;
284: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 281: fnd_message.raise_error;

277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
282: end if;
283: end if;
284: hr_utility.set_location(' Leaving:'||l_proc, 20);
285: End chk_dyn_trigger;

Line 330: fnd_message.set_name('PAY', 'HR_xxxx_INVALID_TABLE_NAME');

326: If paywsdyg_pkg.is_table_valid(p_rec.table_name) = 'N' Then
327: --
328: -- The table does not exist and therefore we must error
329: --
330: fnd_message.set_name('PAY', 'HR_xxxx_INVALID_TABLE_NAME');
331:
332: fnd_message.raise_error;
333: End If;
334: --

Line 332: fnd_message.raise_error;

328: -- The table does not exist and therefore we must error
329: --
330: fnd_message.set_name('PAY', 'HR_xxxx_INVALID_TABLE_NAME');
331:
332: fnd_message.raise_error;
333: End If;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: end chk_table_name;

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

378: ,p_lookup_code => p_rec.dyn_trig_pkg_generated
379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
383: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
386: end if;

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

379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
383: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
386: end if;
387: end if;

Line 384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);

380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
383: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
386: end if;
387: end if;
388: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 385: fnd_message.raise_error;

381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
383: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
386: end if;
387: end if;
388: hr_utility.set_location(' Leaving:'||l_proc, 20);
389: End chk_dyn_trig_pkg_generated;

Line 443: fnd_message.set_name('PAY', 'HR_xxxx_SURROGATE_KEY_NAME');

439: If paywsdyg_pkg.is_table_column_valid(p_rec.table_name,p_rec.surrogate_key_name) = 'N' Then
440: --
441: -- The column does not belong to the table therefore we must error
442: --
443: fnd_message.set_name('PAY', 'HR_xxxx_SURROGATE_KEY_NAME');
444:
445: fnd_message.raise_error;
446: End If;
447: --

Line 445: fnd_message.raise_error;

441: -- The column does not belong to the table therefore we must error
442: --
443: fnd_message.set_name('PAY', 'HR_xxxx_SURROGATE_KEY_NAME');
444:
445: fnd_message.raise_error;
446: End If;
447: --
448: --Bugfix 3114746
449: if (p_rec.start_date_name is not null

Line 455: fnd_message.set_name('PAY', 'HR_xxxx_START_DATE_NAME');

451: If paywsdyg_pkg.is_table_column_valid(p_rec.table_name,p_rec.start_date_name) = 'N' Then
452: --
453: -- The column does not belong to the table therefore we must error
454: --
455: fnd_message.set_name('PAY', 'HR_xxxx_START_DATE_NAME');
456:
457: fnd_message.raise_error;
458: End If;
459: --

Line 457: fnd_message.raise_error;

453: -- The column does not belong to the table therefore we must error
454: --
455: fnd_message.set_name('PAY', 'HR_xxxx_START_DATE_NAME');
456:
457: fnd_message.raise_error;
458: End If;
459: --
460: If paywsdyg_pkg.is_table_column_valid(p_rec.table_name,p_rec.end_date_name) = 'N' Then
461: --

Line 464: fnd_message.set_name('PAY', 'HR_xxxx_END_DATE_NAME');

460: If paywsdyg_pkg.is_table_column_valid(p_rec.table_name,p_rec.end_date_name) = 'N' Then
461: --
462: -- The column does not belong to the table therefore we must error
463: --
464: fnd_message.set_name('PAY', 'HR_xxxx_END_DATE_NAME');
465:
466: fnd_message.raise_error;
467: End If;
468: --

Line 466: fnd_message.raise_error;

462: -- The column does not belong to the table therefore we must error
463: --
464: fnd_message.set_name('PAY', 'HR_xxxx_END_DATE_NAME');
465:
466: fnd_message.raise_error;
467: End If;
468: --
469: end if;
470: hr_utility.set_location(' Leaving:'||l_proc, 10);