355: ,p_attribute29 => p_attribute29
356: ,p_attribute30 => p_attribute30
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'Create_Complaint'
362: ,p_hook_type => 'BP'
363: );
356: ,p_attribute30 => p_attribute30
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'Create_Complaint'
362: ,p_hook_type => 'BP'
363: );
364: end;
701: ,p_complaint_id => l_complaint_id
702: ,p_object_version_number => l_object_version_number
703: );
704: exception
705: when hr_api.cannot_find_prog_unit then
706: hr_api.cannot_find_prog_unit_error
707: (p_module_name => 'Create_Complaint'
708: ,p_hook_type => 'AP'
709: );
702: ,p_object_version_number => l_object_version_number
703: );
704: exception
705: when hr_api.cannot_find_prog_unit then
706: hr_api.cannot_find_prog_unit_error
707: (p_module_name => 'Create_Complaint'
708: ,p_hook_type => 'AP'
709: );
710: end;
712: --
713: -- When in validation only mode raise the Validate_Enabled exception
714: --
715: if p_validate then
716: raise hr_api.validate_enabled;
717: end if;
718: --
719: -- Set all output arguments
720: --
722: p_object_version_number := l_object_version_number;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 70);
725: exception
726: when hr_api.validate_enabled then
727: --
728: -- As the Validate_Enabled exception has been raised
729: -- we must rollback to the savepoint
730: --
1101: ,p_attribute29 => p_attribute29
1102: ,p_attribute30 => p_attribute30
1103: );
1104: exception
1105: when hr_api.cannot_find_prog_unit then
1106: hr_api.cannot_find_prog_unit_error
1107: (p_module_name => 'Update_Complaint'
1108: ,p_hook_type => 'BP'
1109: );
1102: ,p_attribute30 => p_attribute30
1103: );
1104: exception
1105: when hr_api.cannot_find_prog_unit then
1106: hr_api.cannot_find_prog_unit_error
1107: (p_module_name => 'Update_Complaint'
1108: ,p_hook_type => 'BP'
1109: );
1110: end;
1450: ,p_attribute29 => p_attribute29
1451: ,p_attribute30 => p_attribute30
1452: );
1453: exception
1454: when hr_api.cannot_find_prog_unit then
1455: hr_api.cannot_find_prog_unit_error
1456: (p_module_name => 'Update_Complaint'
1457: ,p_hook_type => 'AP'
1458: );
1451: ,p_attribute30 => p_attribute30
1452: );
1453: exception
1454: when hr_api.cannot_find_prog_unit then
1455: hr_api.cannot_find_prog_unit_error
1456: (p_module_name => 'Update_Complaint'
1457: ,p_hook_type => 'AP'
1458: );
1459: end;
1461: --
1462: -- When in validation only mode raise the Validate_Enabled exception
1463: --
1464: if p_validate then
1465: raise hr_api.validate_enabled;
1466: end if;
1467: --
1468: -- Set all output arguments
1469: --
1470: p_object_version_number := l_object_version_number;
1471: --
1472: hr_utility.set_location(' Leaving:'||l_proc, 70);
1473: exception
1474: when hr_api.validate_enabled then
1475: --
1476: -- As the Validate_Enabled exception has been raised
1477: -- we must rollback to the savepoint
1478: --