DBA Data[Home] [Help]

APPS.HXC_APP_COMP_NOTIFICATIONS_API dependencies on HR_UTILITY

Line 7: g_debug boolean :=hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'hxc_app_comp_notifications_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< >--------------|
11: -- ----------------------------------------------------------------------------

Line 95: g_debug:=hr_utility.debug_enabled;

91: AND comp_notification_ovn = l_comp_notification_ovn
92: AND enabled_flag = 'N';
93:
94: begin
95: g_debug:=hr_utility.debug_enabled;
96: if g_debug then
97: l_proc := g_package||'create_app_comp_notifications';
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: end if;

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

94: begin
95: g_debug:=hr_utility.debug_enabled;
96: if g_debug then
97: l_proc := g_package||'create_app_comp_notifications';
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: end if;
100: --
101: -- Issue a savepoint
102: --

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

101: -- Issue a savepoint
102: --
103: savepoint create_app_comp_notification;
104: if g_debug then
105: hr_utility.set_location(l_proc, 20);
106: end if;
107: --
108: -- Remember IN OUT parameter IN values
109: --

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

139: );
140: end;
141:
142: if g_debug then
143: hr_utility.set_location(l_proc, 30);
144: end if;
145: --
146: -- Validation in addition to Row Handlers
147: --

Line 155: hr_utility.set_location(l_proc, 40);

151: --
152: -- Process Logic
153: --
154: if g_debug then
155: hr_utility.set_location(l_proc, 40);
156: end if;
157:
158: --
159: -- Call row hadler

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

321:
322:
323:
324: if g_debug then
325: hr_utility.set_location(l_proc, 50);
326: end if;
327: --
328: -- Call After Process User Hook
329: --

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

345: );
346: end;
347:
348: if g_debug then
349: hr_utility.set_location(l_proc, 60);
350: end if;
351: --
352: -- When in validation only mode raise the Validate_Enabled exception
353: --

Line 368: hr_utility.set_location(l_proc, 70);

364: p_comp_notification_id(1) := l_comp_notification_id;
365: p_object_version_number(1) := l_object_version_number;
366: --
367: if g_debug then
368: hr_utility.set_location(l_proc, 70);
369: end if;
370: --commit; --Have to be removed*****
371: exception
372: when hr_api.validate_enabled then

Line 387: hr_utility.set_location(l_proc, 80);

383: p_comp_notification_id := null;
384: p_object_version_number := null;
385:
386: if g_debug then
387: hr_utility.set_location(l_proc, 80);
388: end if;
389: when others then
390: --
391: -- A validation or unexpected error has occured

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

396: -- OUT parameters, including warnings, to null
397: --
398: p_comp_notification_id := null;
399: p_object_version_number := null;
400: hr_utility.set_location(' Leaving:'||l_proc, 90);
401: raise;
402: end create_app_comp_notification;
403: --
404: -- ----------------------------------------------------------------------------

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

419: l_effective_date date;
420: l_proc varchar2(72) := g_package||'update_app_comp_notification';
421: begin
422: if g_debug then
423: hr_utility.set_location('Entering:'|| l_proc, 10);
424: end if;
425: --
426: -- Issue a savepoint
427: --

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

502:
503: p_object_version_number := l_object_version_number;
504: --
505: if g_debug then
506: hr_utility.set_location(' Leaving:'||l_proc, 70);
507: end if;
508: exception
509: when hr_api.validate_enabled then
510: --

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

520:
521: p_object_version_number := null;
522:
523: if g_debug then
524: hr_utility.set_location(' Leaving:'||l_proc, 80);
525: end if;
526: when others then
527: --
528: -- A validation or unexpected error has occured

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

534: --
535:
536: p_object_version_number := null;
537: if g_debug then
538: hr_utility.set_location(' Leaving:'||l_proc, 90);
539: end if;
540: raise;
541: end update_app_comp_notification;
542: --

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

557: l_effective_date date;
558: l_proc varchar2(72) := g_package||'delete_app_comp_notification';
559: begin
560: if g_debug then
561: hr_utility.set_location('Entering:'|| l_proc, 10);
562: end if;
563: --
564: -- Issue a savepoint
565: --

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

611:
612:
613: --
614: if g_debug then
615: hr_utility.set_location(' Leaving:'||l_proc, 70);
616: end if;
617: exception
618: when hr_api.validate_enabled then
619: --

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

626: -- (Any key or derived arguments must be set to null
627: -- when validation only mode is being used.)
628: --
629: if g_debug then
630: hr_utility.set_location(' Leaving:'||l_proc, 80);
631: end if;
632: when others then
633: --
634: -- A validation or unexpected error has occured

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

638: -- Reset IN OUT parameters and set all
639: -- OUT parameters, including warnings, to null
640: --
641: if g_debug then
642: hr_utility.set_location(' Leaving:'||l_proc, 90);
643: end if;
644: raise;
645: end delete_app_comp_notification;
646:

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

662: l_effective_date date;
663: l_proc varchar2(72) := g_package||'purge_comp_notification';
664: begin
665: if g_debug then
666: hr_utility.set_location('Entering:'|| l_proc, 10);
667: end if;
668: --
669: -- Issue a savepoint
670: --

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

698:
699:
700: --
701: if g_debug then
702: hr_utility.set_location(' Leaving:'||l_proc, 70);
703: end if;
704: exception
705: when hr_api.validate_enabled then
706: --

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

713: -- (Any key or derived arguments must be set to null
714: -- when validation only mode is being used.)
715: --
716: if g_debug then
717: hr_utility.set_location(' Leaving:'||l_proc, 80);
718: end if;
719: when others then
720: --
721: -- A validation or unexpected error has occured

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

725: -- Reset IN OUT parameters and set all
726: -- OUT parameters, including warnings, to null
727: --
728: if g_debug then
729: hr_utility.set_location(' Leaving:'||l_proc, 90);
730: end if;
731: raise;
732: end purge_comp_notification;
733:

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

766: AND hacn.notification_action_code = 'REQUEST-APPROVAL-RESEND';
767:
768: begin
769: if g_debug then
770: hr_utility.set_location('Entering:'|| l_proc, 10);
771: end if;
772: --
773: -- Issue a savepoint
774: --

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

814:
815:
816: --
817: if g_debug then
818: hr_utility.set_location(' Leaving:'||l_proc, 70);
819: end if;
820: exception
821: when hr_api.validate_enabled then
822: --

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

829: -- (Any key or derived arguments must be set to null
830: -- when validation only mode is being used.)
831: --
832: if g_debug then
833: hr_utility.set_location(' Leaving:'||l_proc, 80);
834: end if;
835: when others then
836: --
837: -- A validation or unexpected error has occured

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

841: -- Reset IN OUT parameters and set all
842: -- OUT parameters, including warnings, to null
843: --
844: if g_debug then
845: hr_utility.set_location(' Leaving:'||l_proc, 90);
846: end if;
847: raise;
848: end disable_timeout_notifications;
849: end hxc_app_comp_notifications_api;