131: ,p_notification_recipient_code => p_notification_recipient_code
132: );
133:
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'create_app_comp_notification'
138: ,p_hook_type => 'BP'
139: );
132: );
133:
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'create_app_comp_notification'
138: ,p_hook_type => 'BP'
139: );
140: end;
337: ,p_notification_action_code => p_notification_action_code
338: ,p_notification_recipient_code => p_notification_recipient_code
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'create_app_comp_notification'
344: ,p_hook_type => 'AP'
345: );
338: ,p_notification_recipient_code => p_notification_recipient_code
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'create_app_comp_notification'
344: ,p_hook_type => 'AP'
345: );
346: end;
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
373: --
374: -- As the Validate_Enabled exception has been raised
375: -- we must rollback to the savepoint
376: --
408: procedure update_app_comp_notification
409: (
410: p_comp_notification_id in number,
411: p_object_version_number in out nocopy number,
412: p_notification_number_retries in number default hr_api.g_number,
413: p_notification_timeout_value in number default hr_api.g_number
414: ) is
415: --
416: -- Declare cursors and local variables
409: (
410: p_comp_notification_id in number,
411: p_object_version_number in out nocopy number,
412: p_notification_number_retries in number default hr_api.g_number,
413: p_notification_timeout_value in number default hr_api.g_number
414: ) is
415: --
416: -- Declare cursors and local variables
417: --
438: ,p_notification_number_retries => p_notification_number_retries
439: ,p_notification_timeout_value => p_notification_timeout_value
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'update_app_comp_notification'
445: ,p_hook_type => 'BP'
446: );
439: ,p_notification_timeout_value => p_notification_timeout_value
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'update_app_comp_notification'
445: ,p_hook_type => 'BP'
446: );
447: end;
485: ,p_notification_number_retries => p_notification_number_retries
486: ,p_notification_timeout_value => p_notification_timeout_value
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'update_app_comp_notification'
492: ,p_hook_type => 'AP'
493: );
486: ,p_notification_timeout_value => p_notification_timeout_value
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'update_app_comp_notification'
492: ,p_hook_type => 'AP'
493: );
494: end;
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: --
511: -- As the Validate_Enabled exception has been raised
512: -- we must rollback to the savepoint
513: --
574: (p_comp_notification_id => p_comp_notification_id
575: ,p_object_version_number => p_object_version_number
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'delete_app_comp_notification'
581: ,p_hook_type => 'BP'
582: );
575: ,p_object_version_number => p_object_version_number
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'delete_app_comp_notification'
581: ,p_hook_type => 'BP'
582: );
583: end;
598: hxc_app_comp_notifications_bk3.delete_app_comp_notification_a
599: (p_comp_notification_id => p_comp_notification_id
600: ,p_object_version_number => p_object_version_number
601: ); exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_app_comp_notification'
605: ,p_hook_type => 'AP'
606: );
599: (p_comp_notification_id => p_comp_notification_id
600: ,p_object_version_number => p_object_version_number
601: ); exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_app_comp_notification'
605: ,p_hook_type => 'AP'
606: );
607: end;
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: --
620: -- As the Validate_Enabled exception has been raised
621: -- we must rollback to the savepoint
622: --
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: --
707: -- As the Validate_Enabled exception has been raised
708: -- we must rollback to the savepoint
709: --
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: --
823: -- As the Validate_Enabled exception has been raised
824: -- we must rollback to the savepoint
825: --