157: ,p_program_id =>p_program_id
158: ,p_program_update_date =>p_program_update_date
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
164: ,p_hook_type => 'BP'
165: );
158: ,p_program_update_date =>p_program_update_date
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
164: ,p_hook_type => 'BP'
165: );
166: end;
303: ,p_veh_repos_extra_info_id =>p_veh_repos_extra_info_id
304: ,p_object_version_number =>p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
310: ,p_hook_type => 'AP'
311: );
304: ,p_object_version_number =>p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
310: ,p_hook_type => 'AP'
311: );
312: end;
313: --
314: -- When in validation only mode raise the Validate_Enabled exception
315: --
316: if p_validate then
317: raise hr_api.validate_enabled;
318: end if;
319: --
320: -- Set all IN OUT and OUT parameters with out values
321: --
323: p_object_version_number :=p_object_version_number;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --
505: ,p_program_id =>p_program_id
506: ,p_program_update_date =>p_program_update_date
507: );
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
512: ,p_hook_type => 'BP'
513: );
506: ,p_program_update_date =>p_program_update_date
507: );
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
512: ,p_hook_type => 'BP'
513: );
514: end;
651: ,p_program_id =>p_program_id
652: ,p_program_update_date =>p_program_update_date
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
658: ,p_hook_type => 'AP'
659: );
652: ,p_program_update_date =>p_program_update_date
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
658: ,p_hook_type => 'AP'
659: );
660: end;
661: --
662: -- When in validation only mode raise the Validate_Enabled exception
663: --
664: if p_validate then
665: raise hr_api.validate_enabled;
666: end if;
667: --
668: -- Set all IN OUT and OUT parameters with out values
669: --
669: --
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 70);
672: exception
673: when hr_api.validate_enabled then
674: --
675: -- As the Validate_Enabled exception has been raised
676: -- we must rollback to the savepoint
677: --
739: ,p_vehicle_repository_id => l_vehicle_repository_id
740: ,p_object_version_number =>p_object_version_number
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
746: ,p_hook_type => 'BP'
747: );
740: ,p_object_version_number =>p_object_version_number
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
746: ,p_hook_type => 'BP'
747: );
748: end;
766: ,p_vehicle_repository_id => l_vehicle_repository_id
767: ,p_object_version_number => p_object_version_number
768: );
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
773: ,p_hook_type => 'AP'
774: );
767: ,p_object_version_number => p_object_version_number
768: );
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'
773: ,p_hook_type => 'AP'
774: );
775: end;
776: --
777: -- When in validation only mode raise the Validate_Enabled exception
778: --
779: if p_validate then
780: raise hr_api.validate_enabled;
781: end if;
782: --
783: -- Set all IN OUT and OUT parameters with out values
784: --
784: --
785: --
786: hr_utility.set_location(' Leaving:'||l_proc, 70);
787: exception
788: when hr_api.validate_enabled then
789: --
790: -- As the Validate_Enabled exception has been raised
791: -- we must rollback to the savepoint
792: --