DBA Data[Home] [Help]

APPS.PAY_RTU_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'run_type_usage_id'
47: ,p_argument_value => p_run_type_usage_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'run_type_usage_id'
107: ,p_argument_value => p_run_type_usage_id
108: );

Line 110: if ( nvl(pay_rtu_bus.g_run_type_usage_id, hr_api.g_number)

106: ,p_argument => 'run_type_usage_id'
107: ,p_argument_value => p_run_type_usage_id
108: );
109: --
110: if ( nvl(pay_rtu_bus.g_run_type_usage_id, hr_api.g_number)
111: = p_run_type_usage_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 202: if nvl(p_rec.business_group_id, hr_api.g_number) <>

198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
201: --
202: if nvl(p_rec.business_group_id, hr_api.g_number) <>
203: nvl(pay_rtu_shd.g_old_rec.business_group_id, hr_api.g_number) then
204: l_argument := 'business_group_id';
205: raise l_error;
206: end if;

Line 203: nvl(pay_rtu_shd.g_old_rec.business_group_id, hr_api.g_number) then

199: --
200: hr_utility.set_location(l_proc, 10);
201: --
202: if nvl(p_rec.business_group_id, hr_api.g_number) <>
203: nvl(pay_rtu_shd.g_old_rec.business_group_id, hr_api.g_number) then
204: l_argument := 'business_group_id';
205: raise l_error;
206: end if;
207: hr_utility.set_location(l_proc, 15);

Line 235: hr_api.argument_changed_error

231: hr_utility.set_location(l_proc, 35);
232: --
233: EXCEPTION
234: WHEN l_error THEN
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => l_argument);
238: WHEN OTHERS THEN
239: RAISE;

Line 337: nvl(pay_rtu_shd.g_old_rec.parent_run_type_id, hr_api.g_number) <>

333: -- primary key value. For update it will be not null. For insert it will be
334: -- null, because pre_inset has not been called yet.
335: --
336: IF (((p_run_type_usage_id is not null) and
337: nvl(pay_rtu_shd.g_old_rec.parent_run_type_id, hr_api.g_number) <>
338: nvl(p_parent_run_type_id, hr_api.g_number))
339: or
340: (p_run_type_usage_id is null)) then
341: --

Line 338: nvl(p_parent_run_type_id, hr_api.g_number))

334: -- null, because pre_inset has not been called yet.
335: --
336: IF (((p_run_type_usage_id is not null) and
337: nvl(pay_rtu_shd.g_old_rec.parent_run_type_id, hr_api.g_number) <>
338: nvl(p_parent_run_type_id, hr_api.g_number))
339: or
340: (p_run_type_usage_id is null)) then
341: --
342: hr_utility.set_location(l_proc, 10);

Line 523: nvl(pay_rtu_shd.g_old_rec.child_run_type_id, hr_api.g_number) <>

519: -- primary key value. For update it will be not null. For insert it will be
520: -- null, because pre_inset has not been called yet.
521: --
522: IF (((p_run_type_usage_id is not null) and
523: nvl(pay_rtu_shd.g_old_rec.child_run_type_id, hr_api.g_number) <>
524: nvl(p_child_run_type_id, hr_api.g_number))
525: or
526: (p_run_type_usage_id is null)) then
527: --

Line 524: nvl(p_child_run_type_id, hr_api.g_number))

520: -- null, because pre_inset has not been called yet.
521: --
522: IF (((p_run_type_usage_id is not null) and
523: nvl(pay_rtu_shd.g_old_rec.child_run_type_id, hr_api.g_number) <>
524: nvl(p_child_run_type_id, hr_api.g_number))
525: or
526: (p_run_type_usage_id is null)) then
527: --
528: hr_utility.set_location(l_proc, 10);

Line 793: nvl(pay_rtu_shd.g_old_rec.sequence, hr_api.g_number) <>

789: -- primary key value. For update it will be not null. For insert it will be
790: -- null, because pre_inset has not been called yet.
791: --
792: IF (((p_run_type_usage_id is not null) and
793: nvl(pay_rtu_shd.g_old_rec.sequence, hr_api.g_number) <>
794: nvl(p_sequence, hr_api.g_number))
795: or
796: (p_run_type_usage_id is null)) then
797: --

Line 794: nvl(p_sequence, hr_api.g_number))

790: -- null, because pre_inset has not been called yet.
791: --
792: IF (((p_run_type_usage_id is not null) and
793: nvl(pay_rtu_shd.g_old_rec.sequence, hr_api.g_number) <>
794: nvl(p_sequence, hr_api.g_number))
795: or
796: (p_run_type_usage_id is null)) then
797: --
798: hr_utility.set_location(l_proc, 10);

Line 850: (p_parent_run_type_id in number default hr_api.g_number

846: --
847: -- {End Of Comments}
848: -- ----------------------------------------------------------------------------
849: Procedure dt_update_validate
850: (p_parent_run_type_id in number default hr_api.g_number
851: ,p_child_run_type_id in number default hr_api.g_number
852: ,p_datetrack_mode in varchar2
853: ,p_validation_start_date in date
854: ,p_validation_end_date in date

Line 851: ,p_child_run_type_id in number default hr_api.g_number

847: -- {End Of Comments}
848: -- ----------------------------------------------------------------------------
849: Procedure dt_update_validate
850: (p_parent_run_type_id in number default hr_api.g_number
851: ,p_child_run_type_id in number default hr_api.g_number
852: ,p_datetrack_mode in varchar2
853: ,p_validation_start_date in date
854: ,p_validation_end_date in date
855: ) Is

Line 865: hr_api.mandatory_arg_error

861: Begin
862: --
863: -- Ensure that the p_datetrack_mode argument is not null
864: --
865: hr_api.mandatory_arg_error
866: (p_api_name => l_proc
867: ,p_argument => 'datetrack_mode'
868: ,p_argument_value => p_datetrack_mode
869: );

Line 875: hr_api.mandatory_arg_error

871: -- Mode will be valid, as this is checked at the start of the upd.
872: --
873: -- Ensure the arguments are not null
874: --
875: hr_api.mandatory_arg_error
876: (p_api_name => l_proc
877: ,p_argument => 'validation_start_date'
878: ,p_argument_value => p_validation_start_date
879: );

Line 881: hr_api.mandatory_arg_error

877: ,p_argument => 'validation_start_date'
878: ,p_argument_value => p_validation_start_date
879: );
880: --
881: hr_api.mandatory_arg_error
882: (p_api_name => l_proc
883: ,p_argument => 'validation_end_date'
884: ,p_argument_value => p_validation_end_date
885: );

Line 887: If ((nvl(p_parent_run_type_id, hr_api.g_number) <> hr_api.g_number) and

883: ,p_argument => 'validation_end_date'
884: ,p_argument_value => p_validation_end_date
885: );
886: --
887: If ((nvl(p_parent_run_type_id, hr_api.g_number) <> hr_api.g_number) and
888: NOT (dt_api.check_min_max_dates
889: (p_base_table_name => 'pay_run_types_f'
890: ,p_base_key_column => 'RUN_TYPE_ID'
891: ,p_base_key_value => p_parent_run_type_id

Line 897: If ((nvl(p_child_run_type_id, hr_api.g_number) <> hr_api.g_number) and

893: ,p_to_date => p_validation_end_date))) Then
894: l_table_name := 'run types';
895: raise l_integrity_error;
896: End If;
897: If ((nvl(p_child_run_type_id, hr_api.g_number) <> hr_api.g_number) and
898: NOT (dt_api.check_min_max_dates
899: (p_base_table_name => 'pay_run_types_f'
900: ,p_base_key_column => 'RUN_TYPE_ID'
901: ,p_base_key_value => p_child_run_type_id

Line 978: hr_api.mandatory_arg_error

974: Begin
975: --
976: -- Ensure that the p_datetrack_mode argument is not null
977: --
978: hr_api.mandatory_arg_error
979: (p_api_name => l_proc
980: ,p_argument => 'datetrack_mode'
981: ,p_argument_value => p_datetrack_mode
982: );

Line 987: If (p_datetrack_mode = hr_api.g_delete or

983: --
984: -- Only perform the validation if the datetrack mode is either
985: -- DELETE or ZAP
986: --
987: If (p_datetrack_mode = hr_api.g_delete or
988: p_datetrack_mode = hr_api.g_zap) then
989: --
990: --
991: -- Ensure the arguments are not null

Line 988: p_datetrack_mode = hr_api.g_zap) then

984: -- Only perform the validation if the datetrack mode is either
985: -- DELETE or ZAP
986: --
987: If (p_datetrack_mode = hr_api.g_delete or
988: p_datetrack_mode = hr_api.g_zap) then
989: --
990: --
991: -- Ensure the arguments are not null
992: --

Line 993: hr_api.mandatory_arg_error

989: --
990: --
991: -- Ensure the arguments are not null
992: --
993: hr_api.mandatory_arg_error
994: (p_api_name => l_proc
995: ,p_argument => 'validation_start_date'
996: ,p_argument_value => p_validation_start_date
997: );

Line 999: hr_api.mandatory_arg_error

995: ,p_argument => 'validation_start_date'
996: ,p_argument_value => p_validation_start_date
997: );
998: --
999: hr_api.mandatory_arg_error
1000: (p_api_name => l_proc
1001: ,p_argument => 'validation_end_date'
1002: ,p_argument_value => p_validation_end_date
1003: );

Line 1005: hr_api.mandatory_arg_error

1001: ,p_argument => 'validation_end_date'
1002: ,p_argument_value => p_validation_end_date
1003: );
1004: --
1005: hr_api.mandatory_arg_error
1006: (p_api_name => l_proc
1007: ,p_argument => 'run_type_usage_id'
1008: ,p_argument_value => p_run_type_usage_id
1009: );

Line 1104: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1100: --
1101: /* RET removed this call infavour or new chk_startup_action
1102: IF p_rec.business_group_id is not null THEN
1103: --
1104: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1105: --
1106: END IF;
1107: */
1108: chk_startup_action(true

Line 1114: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1110: ,p_rec.legislation_code
1111: );
1112: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP')
1113: THEN
1114: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1115: END IF;
1116: --
1117: hr_utility.set_location(l_proc, 10);
1118: --

Line 1167: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1163: --
1164: /* RET removed in favour of new chk_startup_data_api
1165: IF p_rec.business_group_id is not null THEN
1166: --
1167: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1168: --
1169: END IF;
1170: */
1171: chk_startup_action(false

Line 1177: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1173: ,p_rec.legislation_code
1174: );
1175: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP')
1176: THEN
1177: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1178: END IF;
1179: --
1180: hr_utility.set_location(l_proc, 10);
1181: --