DBA Data[Home] [Help]

APPS.AME_CONDITION_API dependencies on HR_API

Line 146: when hr_api.cannot_find_prog_unit then

142: ,p_include_lower_limit => p_include_lower_limit
143: ,p_string_value => p_string_value
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (p_module_name => 'create_ame_condition'
149: ,p_hook_type => 'BP'
150: );

Line 147: hr_api.cannot_find_prog_unit_error

143: ,p_string_value => p_string_value
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (p_module_name => 'create_ame_condition'
149: ,p_hook_type => 'BP'
150: );
151: end;

Line 233: when hr_api.cannot_find_prog_unit then

229: ,p_stv_start_date => l_start_date_chd
230: ,p_stv_end_date => l_end_date_chd
231: );
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'create_ame_condition'
236: ,p_hook_type => 'AP'
237: );

Line 234: hr_api.cannot_find_prog_unit_error

230: ,p_stv_end_date => l_end_date_chd
231: );
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'create_ame_condition'
236: ,p_hook_type => 'AP'
237: );
238: end;

Line 243: raise hr_api.validate_enabled;

239: --
240: -- When in validation only mode raise the Validate_Enabled exception
241: --
242: if p_validate then
243: raise hr_api.validate_enabled;
244: end if;
245: --
246: -- Set all IN OUT and OUT parameters with out values
247: --

Line 258: when hr_api.validate_enabled then

254: p_stv_end_date := l_end_date_chd;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
261: -- we must rollback to the savepoint
262: --

Line 307: ,p_parameter_one in varchar2 default hr_api.g_varchar2

303: --
304: procedure update_ame_condition
305: (p_validate in boolean default false
306: ,p_condition_id in number
307: ,p_parameter_one in varchar2 default hr_api.g_varchar2
308: ,p_parameter_two in varchar2 default hr_api.g_varchar2
309: ,p_parameter_three in varchar2 default hr_api.g_varchar2
310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2

Line 308: ,p_parameter_two in varchar2 default hr_api.g_varchar2

304: procedure update_ame_condition
305: (p_validate in boolean default false
306: ,p_condition_id in number
307: ,p_parameter_one in varchar2 default hr_api.g_varchar2
308: ,p_parameter_two in varchar2 default hr_api.g_varchar2
309: ,p_parameter_three in varchar2 default hr_api.g_varchar2
310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number

Line 309: ,p_parameter_three in varchar2 default hr_api.g_varchar2

305: (p_validate in boolean default false
306: ,p_condition_id in number
307: ,p_parameter_one in varchar2 default hr_api.g_varchar2
308: ,p_parameter_two in varchar2 default hr_api.g_varchar2
309: ,p_parameter_three in varchar2 default hr_api.g_varchar2
310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_start_date out nocopy date

Line 310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2

306: ,p_condition_id in number
307: ,p_parameter_one in varchar2 default hr_api.g_varchar2
308: ,p_parameter_two in varchar2 default hr_api.g_varchar2
309: ,p_parameter_three in varchar2 default hr_api.g_varchar2
310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_start_date out nocopy date
314: ,p_end_date out nocopy date

Line 311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2

307: ,p_parameter_one in varchar2 default hr_api.g_varchar2
308: ,p_parameter_two in varchar2 default hr_api.g_varchar2
309: ,p_parameter_three in varchar2 default hr_api.g_varchar2
310: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
311: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_start_date out nocopy date
314: ,p_end_date out nocopy date
315: ) is

Line 353: when hr_api.cannot_find_prog_unit then

349: ,p_include_lower_limit => p_include_lower_limit
350: ,p_object_version_number => p_object_version_number
351: );
352: exception
353: when hr_api.cannot_find_prog_unit then
354: hr_api.cannot_find_prog_unit_error
355: (p_module_name => 'update_ame_condition'
356: ,p_hook_type => 'BP'
357: );

Line 354: hr_api.cannot_find_prog_unit_error

350: ,p_object_version_number => p_object_version_number
351: );
352: exception
353: when hr_api.cannot_find_prog_unit then
354: hr_api.cannot_find_prog_unit_error
355: (p_module_name => 'update_ame_condition'
356: ,p_hook_type => 'BP'
357: );
358: end;

Line 363: ,p_datetrack_mode => hr_api.g_update

359: --
360: -- Process Logic
361: --
362: ame_con_upd.upd(p_effective_date => sysdate
363: ,p_datetrack_mode => hr_api.g_update
364: ,p_condition_id => p_condition_id
365: ,p_object_version_number => p_object_version_number
366: ,p_parameter_one => p_parameter_one
367: ,p_parameter_two => p_parameter_two

Line 371: ,p_security_group_id => hr_api.g_number

367: ,p_parameter_two => p_parameter_two
368: ,p_parameter_three => p_parameter_three
369: ,p_include_upper_limit => p_include_upper_limit
370: ,p_include_lower_limit => p_include_lower_limit
371: ,p_security_group_id => hr_api.g_number
372: ,p_start_date => l_start_date
373: ,p_end_date => l_end_date
374: );
375: --

Line 391: when hr_api.cannot_find_prog_unit then

387: ,p_start_date => l_start_date
388: ,p_end_date => l_end_date
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'update_ame_condition'
394: ,p_hook_type => 'AP'
395: );

Line 392: hr_api.cannot_find_prog_unit_error

388: ,p_end_date => l_end_date
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'update_ame_condition'
394: ,p_hook_type => 'AP'
395: );
396: end;

Line 401: raise hr_api.validate_enabled;

397: --
398: -- When in validation only mode raise the Validate_Enabled exception
399: --
400: if p_validate then
401: raise hr_api.validate_enabled;
402: end if;
403: --
404: -- Set all IN OUT and OUT parameters with out values.
405: --

Line 411: when hr_api.validate_enabled then

407: p_end_date := l_end_date;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
414: -- we must rollback to the savepoint
415: --

Line 521: when hr_api.cannot_find_prog_unit then

517: (p_condition_id => p_condition_id
518: ,p_object_version_number => p_object_version_number
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'delete_ame_condition'
524: ,p_hook_type => 'BP'
525: );

Line 522: hr_api.cannot_find_prog_unit_error

518: ,p_object_version_number => p_object_version_number
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'delete_ame_condition'
524: ,p_hook_type => 'BP'
525: );
526: end;

Line 565: ,p_datetrack_mode => hr_api.g_delete

561: end loop;
562: end if;
563: end if;
564: ame_con_del.del(p_effective_date => sysdate
565: ,p_datetrack_mode => hr_api.g_delete
566: ,p_condition_id => p_condition_id
567: ,p_object_version_number => p_object_version_number
568: ,p_start_date => l_start_date
569: ,p_end_date => l_end_date

Line 582: when hr_api.cannot_find_prog_unit then

578: ,p_start_date => l_start_date
579: ,p_end_date => l_end_date
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'delete_ame_condition'
585: ,p_hook_type => 'AP'
586: );

Line 583: hr_api.cannot_find_prog_unit_error

579: ,p_end_date => l_end_date
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'delete_ame_condition'
585: ,p_hook_type => 'AP'
586: );
587: end;

Line 592: raise hr_api.validate_enabled;

588: --
589: -- When in validation only mode raise the Validate_Enabled exception
590: --
591: if p_validate then
592: raise hr_api.validate_enabled;
593: end if;
594: --
595: -- Set all IN OUT and OUT parameters with out values.
596: --

Line 603: when hr_api.validate_enabled then

599: --
600: end if;
601: hr_utility.set_location(' Leaving:'||l_proc, 70);
602: exception
603: when hr_api.validate_enabled then
604: --
605: -- As the Validate_Enabled exception has been raised
606: -- we must rollback to the savepoint
607: --

Line 673: when hr_api.cannot_find_prog_unit then

669: (p_condition_id => p_condition_id
670: ,p_string_value => p_string_value
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'create_ame_string_value'
676: ,p_hook_type => 'BP'
677: );

Line 674: hr_api.cannot_find_prog_unit_error

670: ,p_string_value => p_string_value
671: );
672: exception
673: when hr_api.cannot_find_prog_unit then
674: hr_api.cannot_find_prog_unit_error
675: (p_module_name => 'create_ame_string_value'
676: ,p_hook_type => 'BP'
677: );
678: end;

Line 702: when hr_api.cannot_find_prog_unit then

698: ,p_start_date => l_start_date
699: ,p_end_date => l_end_date
700: );
701: exception
702: when hr_api.cannot_find_prog_unit then
703: hr_api.cannot_find_prog_unit_error
704: (p_module_name => 'create_ame_string_value'
705: ,p_hook_type => 'AP'
706: );

Line 703: hr_api.cannot_find_prog_unit_error

699: ,p_end_date => l_end_date
700: );
701: exception
702: when hr_api.cannot_find_prog_unit then
703: hr_api.cannot_find_prog_unit_error
704: (p_module_name => 'create_ame_string_value'
705: ,p_hook_type => 'AP'
706: );
707: end;

Line 712: raise hr_api.validate_enabled;

708: --
709: -- When in validation only mode raise the Validate_Enabled exception
710: --
711: if p_validate then
712: raise hr_api.validate_enabled;
713: end if;
714: --
715: -- Set all IN OUT and OUT parameters with out values.
716: --

Line 723: when hr_api.validate_enabled then

719: p_end_date := l_end_date;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 70);
722: exception
723: when hr_api.validate_enabled then
724: --
725: -- As the Validate_Enabled exception has been raised
726: -- we must rollback to the savepoint
727: --

Line 797: when hr_api.cannot_find_prog_unit then

793: ,p_string_value => p_string_value
794: ,p_object_version_number => p_object_version_number
795: );
796: exception
797: when hr_api.cannot_find_prog_unit then
798: hr_api.cannot_find_prog_unit_error
799: (p_module_name => 'delete_ame_string_value'
800: ,p_hook_type => 'BP'
801: );

Line 798: hr_api.cannot_find_prog_unit_error

794: ,p_object_version_number => p_object_version_number
795: );
796: exception
797: when hr_api.cannot_find_prog_unit then
798: hr_api.cannot_find_prog_unit_error
799: (p_module_name => 'delete_ame_string_value'
800: ,p_hook_type => 'BP'
801: );
802: end;

Line 807: ,p_datetrack_mode => hr_api.g_delete

803: --
804: -- Process Logic
805: --
806: ame_stv_del.del(p_effective_date => sysdate
807: ,p_datetrack_mode => hr_api.g_delete
808: ,p_condition_id => p_condition_id
809: ,p_string_value => p_string_value
810: ,p_object_version_number => p_object_version_number
811: ,p_start_date => l_start_date

Line 826: when hr_api.cannot_find_prog_unit then

822: ,p_start_date => l_start_date
823: ,p_end_date => l_end_date
824: );
825: exception
826: when hr_api.cannot_find_prog_unit then
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_ame_string_value'
829: ,p_hook_type => 'AP'
830: );

Line 827: hr_api.cannot_find_prog_unit_error

823: ,p_end_date => l_end_date
824: );
825: exception
826: when hr_api.cannot_find_prog_unit then
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_ame_string_value'
829: ,p_hook_type => 'AP'
830: );
831: end;

Line 836: raise hr_api.validate_enabled;

832: --
833: -- When in validation only mode raise the Validate_Enabled exception
834: --
835: if p_validate then
836: raise hr_api.validate_enabled;
837: end if;
838: --
839: -- Set all IN OUT and OUT parameters with out values.
840: --

Line 846: when hr_api.validate_enabled then

842: p_end_date := l_end_date;
843: --
844: hr_utility.set_location(' Leaving:'||l_proc, 70);
845: exception
846: when hr_api.validate_enabled then
847: --
848: -- As the Validate_Enabled exception has been raised
849: -- we must rollback to the savepoint
850: --