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_ALLOC_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_ALLOC_EXTRA_INFO_API'
164: ,p_hook_type => 'BP'
165: );
166: end;
303: ,p_veh_alloc_extra_info_id =>p_veh_alloc_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_ALLOC_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_ALLOC_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_ALLOC_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_ALLOC_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_ALLOC_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_ALLOC_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: --
740: ,p_vehicle_allocation_id => l_vehicle_allocation_id
741: ,p_object_version_number =>p_object_version_number
742: );
743: exception
744: when hr_api.cannot_find_prog_unit then
745: hr_api.cannot_find_prog_unit_error
746: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
747: ,p_hook_type => 'BP'
748: );
741: ,p_object_version_number =>p_object_version_number
742: );
743: exception
744: when hr_api.cannot_find_prog_unit then
745: hr_api.cannot_find_prog_unit_error
746: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
747: ,p_hook_type => 'BP'
748: );
749: end;
767: ,p_vehicle_allocation_id => l_vehicle_allocation_id
768: ,p_object_version_number =>p_object_version_number
769: );
770: exception
771: when hr_api.cannot_find_prog_unit then
772: hr_api.cannot_find_prog_unit_error
773: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
774: ,p_hook_type => 'AP'
775: );
768: ,p_object_version_number =>p_object_version_number
769: );
770: exception
771: when hr_api.cannot_find_prog_unit then
772: hr_api.cannot_find_prog_unit_error
773: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
774: ,p_hook_type => 'AP'
775: );
776: end;
777: --
778: -- When in validation only mode raise the Validate_Enabled exception
779: --
780: if p_validate then
781: raise hr_api.validate_enabled;
782: end if;
783: --
784: -- Set all IN OUT and OUT parameters with out values
785: --
785: --
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 70);
788: exception
789: when hr_api.validate_enabled then
790: --
791: -- As the Validate_Enabled exception has been raised
792: -- we must rollback to the savepoint
793: --