eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ELEMENT_TEMPLATE_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pyetmapi.pkb 120.0 2005/05/29 04:41:31 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: g_package varchar2(33) := ' pay_element_template_api.';
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_user_structure >-------------------------|
10: -- ----------------------------------------------------------------------------

Line 119: g_debug := hr_utility.debug_enabled;

115: -- Set the ALLOW_BASE_NAME_REUSE flag.
116: --
117: pay_etm_shd.g_allow_base_name_reuse := p_allow_base_name_reuse;
118: --
119: g_debug := hr_utility.debug_enabled;
120: if g_debug then
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: end if;
123: --

Line 121: hr_utility.set_location('Entering:'|| l_proc, 10);

117: pay_etm_shd.g_allow_base_name_reuse := p_allow_base_name_reuse;
118: --
119: g_debug := hr_utility.debug_enabled;
120: if g_debug then
121: hr_utility.set_location('Entering:'|| l_proc, 10);
122: end if;
123: --
124: -- Issue a savepoint
125: --

Line 128: hr_utility.set_location(l_proc, 20);

124: -- Issue a savepoint
125: --
126: savepoint create_user_structure;
127: if g_debug then
128: hr_utility.set_location(l_proc, 20);
129: end if;
130: --
131: -- Check mandatory arguments.
132: --

Line 160: hr_utility.set_location(l_proc, 30);

156: --
157: -- Call Before Process User Hook
158: --
159: if g_debug then
160: hr_utility.set_location(l_proc, 30);
161: end if;
162: --
163: -- Validation in addition to Row Handlers
164: --

Line 170: hr_utility.set_message(801, 'PAY_50057_BAD_SOURCE_TEMPLATE');

166: --
167: l_template_type :=
168: pay_element_template_util.get_template_type(p_source_template_id);
169: if l_template_type is null or l_template_type <> 'T' then
170: hr_utility.set_message(801, 'PAY_50057_BAD_SOURCE_TEMPLATE');
171: hr_utility.raise_error;
172: end if;
173: --
174: if g_debug then

Line 171: hr_utility.raise_error;

167: l_template_type :=
168: pay_element_template_util.get_template_type(p_source_template_id);
169: if l_template_type is null or l_template_type <> 'T' then
170: hr_utility.set_message(801, 'PAY_50057_BAD_SOURCE_TEMPLATE');
171: hr_utility.raise_error;
172: end if;
173: --
174: if g_debug then
175: hr_utility.set_location(l_proc, 50);

Line 175: hr_utility.set_location(l_proc, 50);

171: hr_utility.raise_error;
172: end if;
173: --
174: if g_debug then
175: hr_utility.set_location(l_proc, 50);
176: end if;
177: pay_element_template_util.create_plsql_template
178: (p_lock => false
179: ,p_template_id => p_source_template_id

Line 200: hr_utility.set_location(l_proc, 51);

196: ,p_bal_attributes => l_bal_attributes
197: );
198: --
199: if g_debug then
200: hr_utility.set_location(l_proc, 51);
201: end if;
202: pay_element_template_util.create_plsql_user_structure
203: (p_business_group_id => p_business_group_id
204: ,p_base_name => p_base_name

Line 288: hr_utility.set_location(l_proc, 52);

284: ,p_bal_attributes => l_bal_attributes
285: );
286: --
287: if g_debug then
288: hr_utility.set_location(l_proc, 52);
289: end if;
290: pay_element_template_util.plsql_to_db_template
291: (p_effective_date => p_effective_date
292: ,p_element_template => l_element_template

Line 314: hr_utility.set_location(l_proc, 60);

310: --
311: -- Call After Process User Hook
312: --
313: if g_debug then
314: hr_utility.set_location(l_proc, 60);
315: end if;
316: --
317: -- When in validation only mode raise the Validate_Enabled exception
318: --

Line 329: hr_utility.set_location(' Leaving:'||l_proc, 70);

325: p_template_id := l_template_id;
326: p_object_version_number := l_ovn;
327: --
328: if g_debug then
329: hr_utility.set_location(' Leaving:'||l_proc, 70);
330: end if;
331: exception
332: when hr_api.validate_enabled then
333: --

Line 346: hr_utility.set_location(' Leaving:'||l_proc, 80);

342: --
343: p_template_id := null;
344: p_object_version_number := null;
345: if g_debug then
346: hr_utility.set_location(' Leaving:'||l_proc, 80);
347: end if;
348: when others then
349: --
350: -- A validation or unexpected error has occured

Line 354: hr_utility.set_location(' Leaving:'||l_proc, 90);

350: -- A validation or unexpected error has occured
351: --
352: rollback to create_user_structure;
353: if g_debug then
354: hr_utility.set_location(' Leaving:'||l_proc, 90);
355: end if;
356: p_template_id := null;
357: p_object_version_number := null;
358: raise;

Line 373: g_debug := hr_utility.debug_enabled;

369: ) is
370: l_proc varchar2(72) := g_package||'generate_part1';
371: l_effective_date date;
372: begin
373: g_debug := hr_utility.debug_enabled;
374: if g_debug then
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: end if;
377: --

Line 375: hr_utility.set_location('Entering:'|| l_proc, 10);

371: l_effective_date date;
372: begin
373: g_debug := hr_utility.debug_enabled;
374: if g_debug then
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: end if;
377: --
378: -- Issue a savepoint
379: --

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

378: -- Issue a savepoint
379: --
380: savepoint generate_part1;
381: if g_debug then
382: hr_utility.set_location(l_proc, 20);
383: end if;
384: --
385: -- Check mandatory arguments.
386: --

Line 404: hr_utility.set_location(l_proc, 30);

400: --
401: -- Call Before Process User Hook
402: --
403: if g_debug then
404: hr_utility.set_location(l_proc, 30);
405: end if;
406: --
407: -- Validation in addition to Row Handlers
408: --

Line 412: hr_utility.set_location(l_proc, 50);

408: --
409: -- Process Logic
410: --
411: if g_debug then
412: hr_utility.set_location(l_proc, 50);
413: end if;
414: pay_element_template_gen.generate_part1
415: (p_effective_date => l_effective_date
416: ,p_hr_only => p_hr_only

Line 424: hr_utility.set_location(l_proc, 60);

420: --
421: -- Call After Process User Hook
422: --
423: if g_debug then
424: hr_utility.set_location(l_proc, 60);
425: end if;
426: --
427: -- When in validation only mode raise the Validate_Enabled exception
428: --

Line 436: hr_utility.set_location(' Leaving:'||l_proc, 70);

432: --
433: -- Set all output arguments
434: --
435: if g_debug then
436: hr_utility.set_location(' Leaving:'||l_proc, 70);
437: end if;
438: exception
439: when hr_api.validate_enabled then
440: --

Line 451: hr_utility.set_location(' Leaving:'||l_proc, 80);

447: -- (Any key or derived arguments must be set to null
448: -- when validation only mode is being used.)
449: --
450: if g_debug then
451: hr_utility.set_location(' Leaving:'||l_proc, 80);
452: end if;
453: when others then
454: --
455: -- A validation or unexpected error has occured

Line 459: hr_utility.set_location(' Leaving:'||l_proc, 90);

455: -- A validation or unexpected error has occured
456: --
457: rollback to generate_part1;
458: if g_debug then
459: hr_utility.set_location(' Leaving:'||l_proc, 90);
460: end if;
461: raise;
462: end generate_part1;
463: -- ----------------------------------------------------------------------------

Line 474: g_debug := hr_utility.debug_enabled;

470: ) is
471: l_proc varchar2(72) := g_package||'generate_part2';
472: l_effective_date date;
473: begin
474: g_debug := hr_utility.debug_enabled;
475: if g_debug then
476: hr_utility.set_location('Entering:'|| l_proc, 10);
477: end if;
478: --

Line 476: hr_utility.set_location('Entering:'|| l_proc, 10);

472: l_effective_date date;
473: begin
474: g_debug := hr_utility.debug_enabled;
475: if g_debug then
476: hr_utility.set_location('Entering:'|| l_proc, 10);
477: end if;
478: --
479: -- Issue a savepoint
480: --

Line 483: hr_utility.set_location(l_proc, 20);

479: -- Issue a savepoint
480: --
481: savepoint generate_part2;
482: if g_debug then
483: hr_utility.set_location(l_proc, 20);
484: end if;
485: --
486: -- Check mandatory arguments.
487: --

Line 505: hr_utility.set_location(l_proc, 30);

501: --
502: -- Call Before Process User Hook
503: --
504: if g_debug then
505: hr_utility.set_location(l_proc, 30);
506: end if;
507: --
508: -- Validation in addition to Row Handlers
509: --

Line 513: hr_utility.set_location(l_proc, 50);

509: --
510: -- Process Logic
511: --
512: if g_debug then
513: hr_utility.set_location(l_proc, 50);
514: end if;
515: pay_element_template_gen.generate_part2
516: (p_effective_date => l_effective_date
517: ,p_template_id => p_template_id

Line 523: hr_utility.set_location(l_proc, 60);

519: --
520: -- Call After Process User Hook
521: --
522: if g_debug then
523: hr_utility.set_location(l_proc, 60);
524: end if;
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --

Line 535: hr_utility.set_location(' Leaving:'||l_proc, 70);

531: --
532: -- Set all output arguments
533: --
534: if g_debug then
535: hr_utility.set_location(' Leaving:'||l_proc, 70);
536: end if;
537: exception
538: when hr_api.validate_enabled then
539: --

Line 550: hr_utility.set_location(' Leaving:'||l_proc, 80);

546: -- (Any key or derived arguments must be set to null
547: -- when validation only mode is being used.)
548: --
549: if g_debug then
550: hr_utility.set_location(' Leaving:'||l_proc, 80);
551: end if;
552: when others then
553: --
554: -- A validation or unexpected error has occured

Line 558: hr_utility.set_location(' Leaving:'||l_proc, 90);

554: -- A validation or unexpected error has occured
555: --
556: rollback to generate_part2;
557: if g_debug then
558: hr_utility.set_location(' Leaving:'||l_proc, 90);
559: end if;
560: raise;
561: end generate_part2;
562: -- ----------------------------------------------------------------------------

Line 592: g_debug := hr_utility.debug_enabled;

588: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
589: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
590: l_bal_attributes pay_element_template_util.t_bal_attributes;
591: begin
592: g_debug := hr_utility.debug_enabled;
593: if g_debug then
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: end if;
596: --

Line 594: hr_utility.set_location('Entering:'|| l_proc, 10);

590: l_bal_attributes pay_element_template_util.t_bal_attributes;
591: begin
592: g_debug := hr_utility.debug_enabled;
593: if g_debug then
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: end if;
596: --
597: -- Issue a savepoint
598: --

Line 601: hr_utility.set_location(l_proc, 20);

597: -- Issue a savepoint
598: --
599: savepoint delete_template;
600: if g_debug then
601: hr_utility.set_location(l_proc, 20);
602: end if;
603: --
604: -- Check mandatory arguments.
605: --

Line 617: hr_utility.set_location(l_proc, 30);

613: --
614: -- Call Before Process User Hook
615: --
616: if g_debug then
617: hr_utility.set_location(l_proc, 30);
618: end if;
619: --
620: -- Validation in addition to Row Handlers
621: --

Line 625: hr_utility.set_location(l_proc, 50);

621: --
622: -- Process Logic
623: --
624: if g_debug then
625: hr_utility.set_location(l_proc, 50);
626: end if;
627: pay_element_template_util.create_plsql_template
628: (p_lock => true
629: ,p_template_id => p_template_id

Line 650: hr_utility.set_location(l_proc, 55);

646: ,p_bal_attributes => l_bal_attributes
647: );
648: --
649: if g_debug then
650: hr_utility.set_location(l_proc, 55);
651: end if;
652: pay_element_template_util.delete_template
653: (p_template_id => p_template_id
654: ,p_formulas => l_formulas

Line 661: hr_utility.set_location(l_proc, 60);

657: --
658: -- Call After Process User Hook
659: --
660: if g_debug then
661: hr_utility.set_location(l_proc, 60);
662: end if;
663: --
664: -- When in validation only mode raise the Validate_Enabled exception
665: --

Line 673: hr_utility.set_location(' Leaving:'||l_proc, 70);

669: --
670: -- Set all output arguments
671: --
672: if g_debug then
673: hr_utility.set_location(' Leaving:'||l_proc, 70);
674: end if;
675: exception
676: when hr_api.validate_enabled then
677: --

Line 688: hr_utility.set_location(' Leaving:'||l_proc, 80);

684: -- (Any key or derived arguments must be set to null
685: -- when validation only mode is being used.)
686: --
687: if g_debug then
688: hr_utility.set_location(' Leaving:'||l_proc, 80);
689: end if;
690: when others then
691: --
692: -- A validation or unexpected error has occured

Line 696: hr_utility.set_location(' Leaving:'||l_proc, 90);

692: -- A validation or unexpected error has occured
693: --
694: rollback to delete_template;
695: if g_debug then
696: hr_utility.set_location(' Leaving:'||l_proc, 90);
697: end if;
698: raise;
699: end delete_template;
700: -- ----------------------------------------------------------------------------

Line 732: g_debug := hr_utility.debug_enabled;

728: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
729: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
730: l_bal_attributes pay_element_template_util.t_bal_attributes;
731: begin
732: g_debug := hr_utility.debug_enabled;
733: if g_debug then
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: end if;
736: --

Line 734: hr_utility.set_location('Entering:'|| l_proc, 10);

730: l_bal_attributes pay_element_template_util.t_bal_attributes;
731: begin
732: g_debug := hr_utility.debug_enabled;
733: if g_debug then
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: end if;
736: --
737: -- Issue a savepoint
738: --

Line 741: hr_utility.set_location(l_proc, 20);

737: -- Issue a savepoint
738: --
739: savepoint delete_template;
740: if g_debug then
741: hr_utility.set_location(l_proc, 20);
742: end if;
743: --
744: -- Check mandatory arguments.
745: --

Line 756: hr_utility.set_location(l_proc, 30);

752: --
753: --
754: -- Call Before Process User Hook
755: --
756: hr_utility.set_location(l_proc, 30);
757: --
758: -- Validation in addition to Row Handlers
759: --
760: -- Process Logic

Line 763: hr_utility.set_location(l_proc, 50);

759: --
760: -- Process Logic
761: --
762: if g_debug then
763: hr_utility.set_location(l_proc, 50);
764: end if;
765: pay_element_template_util.create_plsql_template
766: (p_lock => true
767: ,p_template_id => p_template_id

Line 791: hr_utility.set_location(l_proc, 51);

787: -- Zap the generated objects. Don't drop formula packages if
788: -- p_validate is true.
789: --
790: if g_debug then
791: hr_utility.set_location(l_proc, 51);
792: end if;
793: l_drop_formula_packages := not p_validate and p_drop_formula_packages;
794: pay_element_template_gen.zap_core_objects
795: (p_all_core_objects => l_core_objects

Line 802: hr_utility.set_location(l_proc, 52);

798: --
799: -- Delete the template.
800: --
801: if g_debug then
802: hr_utility.set_location(l_proc, 52);
803: end if;
804: pay_element_template_util.delete_template
805: (p_template_id => p_template_id
806: ,p_formulas => l_formulas

Line 813: hr_utility.set_location(l_proc, 60);

809: --
810: -- Call After Process User Hook
811: --
812: if g_debug then
813: hr_utility.set_location(l_proc, 60);
814: end if;
815: --
816: -- When in validation only mode raise the Validate_Enabled exception
817: --

Line 825: hr_utility.set_location(' Leaving:'||l_proc, 70);

821: --
822: -- Set all output arguments
823: --
824: if g_debug then
825: hr_utility.set_location(' Leaving:'||l_proc, 70);
826: end if;
827: exception
828: when hr_api.validate_enabled then
829: --

Line 840: hr_utility.set_location(' Leaving:'||l_proc, 80);

836: -- (Any key or derived arguments must be set to null
837: -- when validation only mode is being used.)
838: --
839: if g_debug then
840: hr_utility.set_location(' Leaving:'||l_proc, 80);
841: end if;
842: when others then
843: --
844: -- A validation or unexpected error has occured

Line 848: hr_utility.set_location(' Leaving:'||l_proc, 90);

844: -- A validation or unexpected error has occured
845: --
846: rollback to delete_template;
847: if g_debug then
848: hr_utility.set_location(' Leaving:'||l_proc, 90);
849: end if;
850: raise;
851: end delete_user_structure;
852: --