DBA Data[Home] [Help]

APPS.HXC_TBB_BUS dependencies on FND_MESSAGE

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

60: if not hxc_tbb_shd.api_updating
61: (p_time_building_block_id => p_rec.time_building_block_id
62: ,p_object_version_number => p_rec.object_version_number
63: ) then
64: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('procedure ', l_proc);
66: fnd_message.set_token('STEP ', '5');
67: fnd_message.raise_error;
68: end if;

Line 65: fnd_message.set_token('procedure ', l_proc);

61: (p_time_building_block_id => p_rec.time_building_block_id
62: ,p_object_version_number => p_rec.object_version_number
63: ) then
64: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('procedure ', l_proc);
66: fnd_message.set_token('STEP ', '5');
67: fnd_message.raise_error;
68: end if;
69:

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

62: ,p_object_version_number => p_rec.object_version_number
63: ) then
64: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('procedure ', l_proc);
66: fnd_message.set_token('STEP ', '5');
67: fnd_message.raise_error;
68: end if;
69:
70: if nvl(p_rec.type, hr_api.g_varchar2) <>

Line 67: fnd_message.raise_error;

63: ) then
64: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('procedure ', l_proc);
66: fnd_message.set_token('STEP ', '5');
67: fnd_message.raise_error;
68: end if;
69:
70: if nvl(p_rec.type, hr_api.g_varchar2) <>
71: nvl(hxc_tbb_shd.g_old_rec.type, hr_api.g_varchar2)

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

148: then
149: if g_debug then
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: end if;
152: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
153: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_TYPE');
154: fnd_message.set_token('VALUE', p_type);
155: fnd_message.raise_error;
156: end if;

Line 153: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_TYPE');

149: if g_debug then
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: end if;
152: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
153: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_TYPE');
154: fnd_message.set_token('VALUE', p_type);
155: fnd_message.raise_error;
156: end if;
157: */

Line 154: fnd_message.set_token('VALUE', p_type);

150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: end if;
152: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
153: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_TYPE');
154: fnd_message.set_token('VALUE', p_type);
155: fnd_message.raise_error;
156: end if;
157: */
158: if g_debug then

Line 155: fnd_message.raise_error;

151: end if;
152: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
153: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_TYPE');
154: fnd_message.set_token('VALUE', p_type);
155: fnd_message.raise_error;
156: end if;
157: */
158: if g_debug then
159: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 260: fnd_message.set_name('HXC', 'HXC_STOP_BEFORE_START');

256: -- check that stop_time is greater than start_time if start_time
257: -- is not null
258:
259: if p_stop_time < nvl(p_start_time, p_stop_time) then
260: fnd_message.set_name('HXC', 'HXC_STOP_BEFORE_START');
261: fnd_message.raise_error;
262: end if;
263:
264: if g_debug then

Line 261: fnd_message.raise_error;

257: -- is not null
258:
259: if p_stop_time < nvl(p_start_time, p_stop_time) then
260: fnd_message.set_name('HXC', 'HXC_STOP_BEFORE_START');
261: fnd_message.raise_error;
262: end if;
263:
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc,10);

Line 313: fnd_message.set_name('PAY', 'HXC_NO_PARENT_BUILDING_BLOCK');

309: open c_timecard_parent;
310: fetch c_timecard_parent into l_valid;
311: if c_timecard_parent%notfound then
312: close c_timecard_parent;
313: fnd_message.set_name('PAY', 'HXC_NO_PARENT_BUILDING_BLOCK');
314: fnd_message.raise_error;
315: else
316: close c_timecard_parent;
317: if((p_date_to = hr_general.end_of_time) and (p_scope in ('DAY','DETAIL'))) then

Line 314: fnd_message.raise_error;

310: fetch c_timecard_parent into l_valid;
311: if c_timecard_parent%notfound then
312: close c_timecard_parent;
313: fnd_message.set_name('PAY', 'HXC_NO_PARENT_BUILDING_BLOCK');
314: fnd_message.raise_error;
315: else
316: close c_timecard_parent;
317: if((p_date_to = hr_general.end_of_time) and (p_scope in ('DAY','DETAIL'))) then
318: open c_valid_parent;

Line 321: fnd_message.set_name('HXC','HXC_366502_INVALID_PARENT_DEP');

317: if((p_date_to = hr_general.end_of_time) and (p_scope in ('DAY','DETAIL'))) then
318: open c_valid_parent;
319: if(c_valid_parent%notfound) then
320: close c_valid_parent;
321: fnd_message.set_name('HXC','HXC_366502_INVALID_PARENT_DEP');
322: fnd_message.raise_error;
323: else
324: close c_valid_parent;
325: end if;

Line 322: fnd_message.raise_error;

318: open c_valid_parent;
319: if(c_valid_parent%notfound) then
320: close c_valid_parent;
321: fnd_message.set_name('HXC','HXC_366502_INVALID_PARENT_DEP');
322: fnd_message.raise_error;
323: else
324: close c_valid_parent;
325: end if;
326: end if;

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

371: then
372: if g_debug then
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: end if;
375: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
376: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_SCOPE');
377: fnd_message.set_token('VALUE', p_scope);
378: fnd_message.raise_error;
379: end if;

Line 376: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_SCOPE');

372: if g_debug then
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: end if;
375: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
376: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_SCOPE');
377: fnd_message.set_token('VALUE', p_scope);
378: fnd_message.raise_error;
379: end if;
380: */

Line 377: fnd_message.set_token('VALUE', p_scope);

373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: end if;
375: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
376: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_SCOPE');
377: fnd_message.set_token('VALUE', p_scope);
378: fnd_message.raise_error;
379: end if;
380: */
381: if g_debug then

Line 378: fnd_message.raise_error;

374: end if;
375: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
376: fnd_message.set_token('LOOKUP_TYPE', 'HXC_BUILDING_BLOCK_SCOPE');
377: fnd_message.set_token('VALUE', p_scope);
378: fnd_message.raise_error;
379: end if;
380: */
381: if g_debug then
382: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 446: fnd_message.set_name('HXC', 'HXC_OVERLAPPING_TIMECARDS');

442: if g_debug then
443: hr_utility.set_location(l_proc, 10);
444: end if;
445: close c_timecard_scope;
446: fnd_message.set_name('HXC', 'HXC_OVERLAPPING_TIMECARDS');
447: fnd_message.raise_error;
448:
449: end if;
450:

Line 447: fnd_message.raise_error;

443: hr_utility.set_location(l_proc, 10);
444: end if;
445: close c_timecard_scope;
446: fnd_message.set_name('HXC', 'HXC_OVERLAPPING_TIMECARDS');
447: fnd_message.raise_error;
448:
449: end if;
450:
451: end if; -- are we inserting a timecard scope building block

Line 496: fnd_message.set_name('HXC', 'HXC_NO_PERSON_RECORD');

492: open c_person;
493: fetch c_person into l_num_person_records;
494: close c_person;
495: if (l_num_person_records = 0) then
496: fnd_message.set_name('HXC', 'HXC_NO_PERSON_RECORD');
497: fnd_message.raise_error;
498: end if;
499: elsif p_resource_type = 'ROOM' then
500: null; -- check validity of room

Line 497: fnd_message.raise_error;

493: fetch c_person into l_num_person_records;
494: close c_person;
495: if (l_num_person_records = 0) then
496: fnd_message.set_name('HXC', 'HXC_NO_PERSON_RECORD');
497: fnd_message.raise_error;
498: end if;
499: elsif p_resource_type = 'ROOM' then
500: null; -- check validity of room
501: elsif p_resource_type = 'MACHINE' then

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

536: then
537: if g_debug then
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: end if;
540: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
541: fnd_message.set_token('LOOKUP_TYPE', 'HXC_RESOURCE_TYPE');
542: fnd_message.set_token('VALUE', p_resource_type);
543: fnd_message.raise_error;
544: end if;

Line 541: fnd_message.set_token('LOOKUP_TYPE', 'HXC_RESOURCE_TYPE');

537: if g_debug then
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: end if;
540: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
541: fnd_message.set_token('LOOKUP_TYPE', 'HXC_RESOURCE_TYPE');
542: fnd_message.set_token('VALUE', p_resource_type);
543: fnd_message.raise_error;
544: end if;
545: */

Line 542: fnd_message.set_token('VALUE', p_resource_type);

538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: end if;
540: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
541: fnd_message.set_token('LOOKUP_TYPE', 'HXC_RESOURCE_TYPE');
542: fnd_message.set_token('VALUE', p_resource_type);
543: fnd_message.raise_error;
544: end if;
545: */
546: if g_debug then

Line 543: fnd_message.raise_error;

539: end if;
540: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
541: fnd_message.set_token('LOOKUP_TYPE', 'HXC_RESOURCE_TYPE');
542: fnd_message.set_token('VALUE', p_resource_type);
543: fnd_message.raise_error;
544: end if;
545: */
546: if g_debug then
547: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

586: then
587: if g_debug then
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: end if;
590: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
591: fnd_message.set_token('LOOKUP_TYPE', 'HXC_APPROVAL_STATUS');
592: fnd_message.set_token('VALUE', p_approval_status);
593: fnd_message.raise_error;
594: end if;

Line 591: fnd_message.set_token('LOOKUP_TYPE', 'HXC_APPROVAL_STATUS');

587: if g_debug then
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: end if;
590: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
591: fnd_message.set_token('LOOKUP_TYPE', 'HXC_APPROVAL_STATUS');
592: fnd_message.set_token('VALUE', p_approval_status);
593: fnd_message.raise_error;
594: end if;
595: */

Line 592: fnd_message.set_token('VALUE', p_approval_status);

588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: end if;
590: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
591: fnd_message.set_token('LOOKUP_TYPE', 'HXC_APPROVAL_STATUS');
592: fnd_message.set_token('VALUE', p_approval_status);
593: fnd_message.raise_error;
594: end if;
595: */
596: if g_debug then

Line 593: fnd_message.raise_error;

589: end if;
590: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
591: fnd_message.set_token('LOOKUP_TYPE', 'HXC_APPROVAL_STATUS');
592: fnd_message.set_token('VALUE', p_approval_status);
593: fnd_message.raise_error;
594: end if;
595: */
596: if g_debug then
597: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 624: fnd_message.set_name('HXC', 'HXC_TC_OFFLINE_PERIOD_CONFLICT');

620: open c_data_set(p_rec.stop_time);
621: fetch c_data_set into l_dummy;
622: if c_data_set%found then
623: close c_data_set;
624: fnd_message.set_name('HXC', 'HXC_TC_OFFLINE_PERIOD_CONFLICT');
625: fnd_message.raise_error;
626: end if;
627: close c_data_set;
628: end if;

Line 625: fnd_message.raise_error;

621: fetch c_data_set into l_dummy;
622: if c_data_set%found then
623: close c_data_set;
624: fnd_message.set_name('HXC', 'HXC_TC_OFFLINE_PERIOD_CONFLICT');
625: fnd_message.raise_error;
626: end if;
627: close c_data_set;
628: end if;
629: end chk_data_set_offline;