DBA Data[Home] [Help]

APPS.HXC_TBB_BUS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- --------------------------------------------------------------------------
7:
8: g_package varchar2(33) := ' hxc_tbb_bus.'; -- global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: -- the following two global variables are only to be
13: -- used by the return_legislation_code function.
14:

Line 126: g_debug := hr_utility.debug_enabled;

122:
123: l_proc varchar2(72);
124:
125: begin
126: g_debug := hr_utility.debug_enabled;
127:
128: if g_debug then
129: l_proc := g_package||'chk_type';
130: hr_utility.set_location('Entering:'||l_proc, 5);

Line 130: hr_utility.set_location('Entering:'||l_proc, 5);

126: g_debug := hr_utility.debug_enabled;
127:
128: if g_debug then
129: l_proc := g_package||'chk_type';
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: end if;
132:
133: -- check that the type is not null.
134:

Line 150: hr_utility.set_location(' Leaving:'||l_proc, 10);

146: ,p_lookup_code => p_type
147: )
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);

Line 159: hr_utility.set_location(' Leaving:'||l_proc, 20);

155: fnd_message.raise_error;
156: end if;
157: */
158: if g_debug then
159: hr_utility.set_location(' Leaving:'||l_proc, 20);
160: end if;
161:
162: end chk_type;
163:

Line 176: g_debug := hr_utility.debug_enabled;

172: l_proc varchar2(72);
173:
174: begin
175:
176: g_debug := hr_utility.debug_enabled;
177:
178: if g_debug then
179: l_proc := g_package||'chk_measure';
180: hr_utility.set_location('Entering:'||l_proc, 5);

Line 180: hr_utility.set_location('Entering:'||l_proc, 5);

176: g_debug := hr_utility.debug_enabled;
177:
178: if g_debug then
179: l_proc := g_package||'chk_measure';
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: end if;
182:
183: -- check that measure is not null if building block is
184: -- of type 'MEASURE' (measure)

Line 196: hr_utility.set_location(' Leaving:'||l_proc,10);

192: );
193: end if;
194: */
195: if g_debug then
196: hr_utility.set_location(' Leaving:'||l_proc,10);
197: end if;
198:
199: end chk_measure;
200:

Line 213: g_debug := hr_utility.debug_enabled;

209: l_proc varchar2(72);
210:
211: begin
212:
213: g_debug := hr_utility.debug_enabled;
214:
215: if g_debug then
216: l_proc := g_package||'chk_start_time';
217: hr_utility.set_location('Entering:'||l_proc, 5);

Line 217: hr_utility.set_location('Entering:'||l_proc, 5);

213: g_debug := hr_utility.debug_enabled;
214:
215: if g_debug then
216: l_proc := g_package||'chk_start_time';
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: end if;
219:
220: -- check that start_time is not null if building block is
221: -- of type 'RANGE' (range)

Line 232: hr_utility.set_location(' Leaving:'||l_proc,10);

228: );
229: end if;
230:
231: if g_debug then
232: hr_utility.set_location(' Leaving:'||l_proc,10);
233: end if;
234:
235: end chk_start_time;
236:

Line 249: g_debug := hr_utility.debug_enabled;

245: l_proc varchar2(72);
246:
247: begin
248:
249: g_debug := hr_utility.debug_enabled;
250:
251: if g_debug then
252: l_proc := g_package||'chk_start_time';
253: hr_utility.set_location('Entering:'||l_proc, 5);

Line 253: hr_utility.set_location('Entering:'||l_proc, 5);

249: g_debug := hr_utility.debug_enabled;
250:
251: if g_debug then
252: l_proc := g_package||'chk_start_time';
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: end if;
255:
256: -- check that stop_time is greater than start_time if start_time
257: -- is not null

Line 265: hr_utility.set_location(' Leaving:'||l_proc,10);

261: fnd_message.raise_error;
262: end if;
263:
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc,10);
266: end if;
267:
268: end chk_stop_time;
269:

Line 301: g_debug := hr_utility.debug_enabled;

297: l_valid varchar2(1);
298:
299: begin
300:
301: g_debug := hr_utility.debug_enabled;
302:
303: if g_debug then
304: l_proc := g_package||'chk_parent_building_block_id';
305: hr_utility.set_location('Entering:'||l_proc, 5);

Line 305: hr_utility.set_location('Entering:'||l_proc, 5);

301: g_debug := hr_utility.debug_enabled;
302:
303: if g_debug then
304: l_proc := g_package||'chk_parent_building_block_id';
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: end if;
307:
308: if ((p_parent_building_block_id is not null)OR(p_scope in ('DAY','DETAIL'))) then
309: open c_timecard_parent;

Line 331: hr_utility.set_location(' Leaving:'||l_proc, 10);

327: end if;
328: end if;
329:
330: if g_debug then
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: end if;
333:
334: end chk_parent_building_block_id;
335:

Line 349: g_debug := hr_utility.debug_enabled;

345: l_proc varchar2(72);
346:
347: begin
348:
349: g_debug := hr_utility.debug_enabled;
350:
351: if g_debug then
352: l_proc := g_package||'chk_scope';
353: hr_utility.set_location('Entering:'||l_proc, 5);

Line 353: hr_utility.set_location('Entering:'||l_proc, 5);

349: g_debug := hr_utility.debug_enabled;
350:
351: if g_debug then
352: l_proc := g_package||'chk_scope';
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: end if;
355:
356: -- check that the scope is not null.
357:

Line 373: hr_utility.set_location(' Leaving:'||l_proc, 10);

369: ,p_lookup_code => p_scope
370: )
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);

Line 382: hr_utility.set_location(' Leaving:'||l_proc, 20);

378: fnd_message.raise_error;
379: end if;
380: */
381: if g_debug then
382: hr_utility.set_location(' Leaving:'||l_proc, 20);
383: end if;
384:
385: end chk_scope;
386:

Line 413: g_debug := hr_utility.debug_enabled;

409: l_proc varchar2(72);
410:
411: begin
412:
413: g_debug := hr_utility.debug_enabled;
414:
415: if g_debug then
416: l_proc := g_package||'chk_timecard_scope';
417: hr_utility.set_location('Entering:'||l_proc, 5);

Line 417: hr_utility.set_location('Entering:'||l_proc, 5);

413: g_debug := hr_utility.debug_enabled;
414:
415: if g_debug then
416: l_proc := g_package||'chk_timecard_scope';
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: end if;
419:
420: if p_scope = 'TIMECARD' then
421:

Line 423: hr_utility.set_location(l_proc, 10);

419:
420: if p_scope = 'TIMECARD' then
421:
422: if g_debug then
423: hr_utility.set_location(l_proc, 10);
424: end if;
425:
426: open c_timecard_scope;
427: fetch c_timecard_scope into l_two_timecards;

Line 432: hr_utility.set_location(l_proc, 10);

428:
429: if c_timecard_scope%NOTFOUND then
430:
431: if g_debug then
432: hr_utility.set_location(l_proc, 10);
433: end if;
434: close c_timecard_scope;
435:
436: else

Line 443: hr_utility.set_location(l_proc, 10);

439: -- Found a timecard scope building block with an overlapping
440: -- range, should error out.
441: --
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;

Line 454: hr_utility.set_location(' Leaving:'||l_proc, 10);

450:
451: end if; -- are we inserting a timecard scope building block
452:
453: if g_debug then
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: end if;
456:
457: end chk_timecard_scope;
458:

Line 484: g_debug := hr_utility.debug_enabled;

480: l_num_person_records number;
481:
482: begin
483:
484: g_debug := hr_utility.debug_enabled;
485:
486: if g_debug then
487: l_proc := g_package||'chk_resource_id';
488: hr_utility.set_location('Entering:'||l_proc, 5);

Line 488: hr_utility.set_location('Entering:'||l_proc, 5);

484: g_debug := hr_utility.debug_enabled;
485:
486: if g_debug then
487: l_proc := g_package||'chk_resource_id';
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: end if;
490:
491: if p_resource_type = 'PERSON' then
492: open c_person;

Line 505: hr_utility.set_location(' Leaving:'||l_proc, 10);

501: elsif p_resource_type = 'MACHINE' then
502: null; -- check validity of machine
503: end if;
504: if g_debug then
505: hr_utility.set_location(' Leaving:'||l_proc, 10);
506: end if;
507:
508: end chk_resource_id;
509:

Line 522: g_debug := hr_utility.debug_enabled;

518: l_proc varchar2(72);
519:
520: begin
521:
522: g_debug := hr_utility.debug_enabled;
523:
524: if g_debug then
525: l_proc := g_package||'chk_resource_type';
526: hr_utility.set_location('Entering:'||l_proc, 5);

Line 526: hr_utility.set_location('Entering:'||l_proc, 5);

522: g_debug := hr_utility.debug_enabled;
523:
524: if g_debug then
525: l_proc := g_package||'chk_resource_type';
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: end if;
528:
529: -- validate against hr_lookups.
530: /*

Line 538: hr_utility.set_location(' Leaving:'||l_proc, 10);

534: ,p_lookup_code => p_resource_type
535: )
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);

Line 547: hr_utility.set_location(' Leaving:'||l_proc, 20);

543: fnd_message.raise_error;
544: end if;
545: */
546: if g_debug then
547: hr_utility.set_location(' Leaving:'||l_proc, 20);
548: end if;
549:
550: end chk_resource_type;
551:

Line 564: g_debug := hr_utility.debug_enabled;

560: l_proc varchar2(72);
561:
562: begin
563:
564: g_debug := hr_utility.debug_enabled;
565:
566: if g_debug then
567: l_proc := g_package||'chk_approval_status';
568: hr_utility.set_location('Entering:'||l_proc, 5);

Line 568: hr_utility.set_location('Entering:'||l_proc, 5);

564: g_debug := hr_utility.debug_enabled;
565:
566: if g_debug then
567: l_proc := g_package||'chk_approval_status';
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: end if;
570:
571: -- check that the approval status is not null.
572:

Line 588: hr_utility.set_location(' Leaving:'||l_proc, 10);

584: ,p_lookup_code => p_approval_status
585: )
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);

Line 597: hr_utility.set_location(' Leaving:'||l_proc, 20);

593: fnd_message.raise_error;
594: end if;
595: */
596: if g_debug then
597: hr_utility.set_location(' Leaving:'||l_proc, 20);
598: end if;
599:
600: end chk_approval_status;
601:

Line 643: g_debug := hr_utility.debug_enabled;

639: l_proc varchar2(72);
640:
641: begin
642:
643: g_debug := hr_utility.debug_enabled;
644:
645: if g_debug then
646: l_proc := g_package||'insert_validate';
647: hr_utility.set_location('Entering:'||l_proc, 5);

Line 647: hr_utility.set_location('Entering:'||l_proc, 5);

643: g_debug := hr_utility.debug_enabled;
644:
645: if g_debug then
646: l_proc := g_package||'insert_validate';
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: end if;
649:
650: -- call all supporting business operations
651: -- (no business group context. HR_STANDARD_LOOKUPS used for validation)

Line 723: hr_utility.set_location(' Leaving:'||l_proc, 10);

719: (p_rec => p_rec
720: );
721:
722: if g_debug then
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
724: end if;
725:
726: end insert_validate;
727:

Line 740: g_debug := hr_utility.debug_enabled;

736: l_proc varchar2(72);
737:
738: begin
739:
740: g_debug := hr_utility.debug_enabled;
741:
742: if g_debug then
743: l_proc := g_package||'update_validate';
744: hr_utility.set_location('Entering:'||l_proc, 5);

Line 744: hr_utility.set_location('Entering:'||l_proc, 5);

740: g_debug := hr_utility.debug_enabled;
741:
742: if g_debug then
743: l_proc := g_package||'update_validate';
744: hr_utility.set_location('Entering:'||l_proc, 5);
745: end if;
746:
747: -- call all supporting business operations
748: -- (no business group context. HR_STANDARD_LOOKUPS used for validation)

Line 760: hr_utility.set_location(' Leaving:'||l_proc, 10);

756: (p_rec => p_rec
757: );
758:
759: if g_debug then
760: hr_utility.set_location(' Leaving:'||l_proc, 10);
761: end if;
762:
763: end update_validate;
764:

Line 776: g_debug := hr_utility.debug_enabled;

772: l_proc varchar2(72);
773:
774: begin
775:
776: g_debug := hr_utility.debug_enabled;
777:
778: if g_debug then
779: l_proc := g_package||'delete_validate';
780: hr_utility.set_location('Entering:'||l_proc, 5);

Line 780: hr_utility.set_location('Entering:'||l_proc, 5);

776: g_debug := hr_utility.debug_enabled;
777:
778: if g_debug then
779: l_proc := g_package||'delete_validate';
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: end if;
782:
783: -- call all supporting business operations
784:

Line 786: hr_utility.set_location(' Leaving:'||l_proc, 10);

782:
783: -- call all supporting business operations
784:
785: if g_debug then
786: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: end if;
788:
789: end delete_validate;
790: