eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CON_BUS dependencies on HR_API

Line 42: hr_api.mandatory_arg_error(p_api_name => l_proc

38: l_proc varchar2(72) := g_package || 'CHK_CONDITION_ID';
39: --
40: Begin
41: hr_utility.set_location('Entering:'||l_proc,10);
42: hr_api.mandatory_arg_error(p_api_name => l_proc
43: ,p_argument => 'CONDITION_ID'
44: ,p_argument_value => p_condition_id
45: );
46: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 91: hr_api.mandatory_arg_error(p_api_name => l_proc

87: l_proc varchar2(72) := g_package || 'CHK_CONDITION_TYPE';
88: --
89: Begin
90: hr_utility.set_location('Entering:'||l_proc,10);
91: hr_api.mandatory_arg_error(p_api_name => l_proc
92: ,p_argument => 'CONDITION_TYPE'
93: ,p_argument_value => p_condition_type
94: );
95: -- Check if the value exist in the lookup list

Line 167: hr_api.mandatory_arg_error(p_api_name => l_proc

163: hr_utility.set_location(' Entering:'||l_proc,10);
164: -- Check whether any dependencies on CONDITION_KEY have failed
165: if hr_multi_message.no_all_inclusive_error
166: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE') then
167: hr_api.mandatory_arg_error(p_api_name => l_proc
168: ,p_argument => 'ATTRIBUTE_ID'
169: ,p_argument_value => p_attribute_id
170: );
171: -- Check if the condition_type is ListModification type. Else check if

Line 261: hr_api.mandatory_arg_error(p_api_name => l_proc

257: open csr_atr_type;
258: fetch csr_atr_type into l_key;
259: close csr_atr_type;
260: if(l_key = ame_util.booleanAttributeType) then
261: hr_api.mandatory_arg_error(p_api_name => l_proc
262: ,p_argument => 'PARAMETER_ONE'
263: ,p_argument_value => p_parameter_one
264: );
265: elsif(l_key <> ame_util.stringAttributeType) then

Line 566: and nvl(parameter_one, hr_api.g_varchar2)

562: cursor csr_name is
563: select condition_id
564: from ame_conditions
565: where condition_type = p_rec.condition_type
566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)

Line 567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)

563: select condition_id
564: from ame_conditions
565: where condition_type = p_rec.condition_type
566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)

Line 568: and nvl(parameter_two, hr_api.g_varchar2)

564: from ame_conditions
565: where condition_type = p_rec.condition_type
566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)

Line 569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)

565: where condition_type = p_rec.condition_type
566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)

Line 570: and nvl(parameter_three, hr_api.g_varchar2)

566: and nvl(parameter_one, hr_api.g_varchar2)
567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)

Line 571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)

567: = nvl(p_rec.parameter_one, hr_api.g_varchar2)
568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)

Line 572: and nvl(include_lower_limit, hr_api.g_varchar2)

568: and nvl(parameter_two, hr_api.g_varchar2)
569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)
576: and p_effective_date between start_date

Line 573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)

569: = nvl(p_rec.parameter_two, hr_api.g_varchar2)
570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)
576: and p_effective_date between start_date
577: and nvl(end_date - ame_util.oneSecond, p_effective_date)

Line 574: and nvl(include_upper_limit, hr_api.g_varchar2)

570: and nvl(parameter_three, hr_api.g_varchar2)
571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)
576: and p_effective_date between start_date
577: and nvl(end_date - ame_util.oneSecond, p_effective_date)
578: and attribute_id = p_rec.attribute_id

Line 575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)

571: = nvl(p_rec.parameter_three, hr_api.g_varchar2)
572: and nvl(include_lower_limit, hr_api.g_varchar2)
573: = nvl(p_rec.include_lower_limit, hr_api.g_varchar2)
574: and nvl(include_upper_limit, hr_api.g_varchar2)
575: = nvl(p_rec.include_upper_limit, hr_api.g_varchar2)
576: and p_effective_date between start_date
577: and nvl(end_date - ame_util.oneSecond, p_effective_date)
578: and attribute_id = p_rec.attribute_id
579: and attribute_id not in ( select attribute_id

Line 787: hr_api.mandatory_arg_error(p_api_name => l_proc

783: l_key varchar2(1);
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc,10);
787: hr_api.mandatory_arg_error(p_api_name => l_proc
788: ,p_argument => 'CONDITION_KEY'
789: ,p_argument_value => p_condition_key
790: );
791: -- Check if the value already exists

Line 958: if nvl(p_rec.condition_type, hr_api.g_varchar2) <>

954: -- EDIT_HERE: Add checks to ensure non-updateable args have
955: -- not been updated.
956: --
957: -- CONDITION_TYPE is non-updateable
958: if nvl(p_rec.condition_type, hr_api.g_varchar2) <>
959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then
960: hr_api.argument_changed_error
961: (p_api_name => l_proc
962: ,p_argument => 'CONDITION_TYPE'

Line 959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then

955: -- not been updated.
956: --
957: -- CONDITION_TYPE is non-updateable
958: if nvl(p_rec.condition_type, hr_api.g_varchar2) <>
959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then
960: hr_api.argument_changed_error
961: (p_api_name => l_proc
962: ,p_argument => 'CONDITION_TYPE'
963: ,p_base_table => ame_con_shd.g_tab_nam

Line 960: hr_api.argument_changed_error

956: --
957: -- CONDITION_TYPE is non-updateable
958: if nvl(p_rec.condition_type, hr_api.g_varchar2) <>
959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then
960: hr_api.argument_changed_error
961: (p_api_name => l_proc
962: ,p_argument => 'CONDITION_TYPE'
963: ,p_base_table => ame_con_shd.g_tab_nam
964: );

Line 968: if nvl(p_rec.attribute_id, hr_api.g_number) <>

964: );
965: end if;
966: --
967: -- ATTRIBUTE_ID is non-updateable
968: if nvl(p_rec.attribute_id, hr_api.g_number) <>
969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then
970: hr_api.argument_changed_error
971: (p_api_name => l_proc
972: ,p_argument => 'ATTRIBUTE_ID'

Line 969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then

965: end if;
966: --
967: -- ATTRIBUTE_ID is non-updateable
968: if nvl(p_rec.attribute_id, hr_api.g_number) <>
969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then
970: hr_api.argument_changed_error
971: (p_api_name => l_proc
972: ,p_argument => 'ATTRIBUTE_ID'
973: ,p_base_table => ame_con_shd.g_tab_nam

Line 970: hr_api.argument_changed_error

966: --
967: -- ATTRIBUTE_ID is non-updateable
968: if nvl(p_rec.attribute_id, hr_api.g_number) <>
969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then
970: hr_api.argument_changed_error
971: (p_api_name => l_proc
972: ,p_argument => 'ATTRIBUTE_ID'
973: ,p_base_table => ame_con_shd.g_tab_nam
974: );

Line 978: if nvl(p_rec.condition_key, hr_api.g_varchar2) <>

974: );
975: end if;
976: --
977: -- CONDITION_KEY is non-updateable
978: if nvl(p_rec.condition_key, hr_api.g_varchar2) <>
979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then
980: hr_api.argument_changed_error
981: (p_api_name => l_proc
982: ,p_argument => 'CONDITION_KEY'

Line 979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then

975: end if;
976: --
977: -- CONDITION_KEY is non-updateable
978: if nvl(p_rec.condition_key, hr_api.g_varchar2) <>
979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then
980: hr_api.argument_changed_error
981: (p_api_name => l_proc
982: ,p_argument => 'CONDITION_KEY'
983: ,p_base_table => ame_con_shd.g_tab_nam

Line 980: hr_api.argument_changed_error

976: --
977: -- CONDITION_KEY is non-updateable
978: if nvl(p_rec.condition_key, hr_api.g_varchar2) <>
979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then
980: hr_api.argument_changed_error
981: (p_api_name => l_proc
982: ,p_argument => 'CONDITION_KEY'
983: ,p_base_table => ame_con_shd.g_tab_nam
984: );

Line 1030: hr_api.mandatory_arg_error

1026: Begin
1027: --
1028: -- Ensure that the p_datetrack_mode argument is not null
1029: --
1030: hr_api.mandatory_arg_error
1031: (p_api_name => l_proc
1032: ,p_argument => 'datetrack_mode'
1033: ,p_argument_value => p_datetrack_mode
1034: );

Line 1040: hr_api.mandatory_arg_error

1036: -- Mode will be valid, as this is checked at the start of the upd.
1037: --
1038: -- Ensure the arguments are not null
1039: --
1040: hr_api.mandatory_arg_error
1041: (p_api_name => l_proc
1042: ,p_argument => 'validation_start_date'
1043: ,p_argument_value => p_validation_start_date
1044: );

Line 1046: /*hr_api.mandatory_arg_error

1042: ,p_argument => 'validation_start_date'
1043: ,p_argument_value => p_validation_start_date
1044: );
1045: --
1046: /*hr_api.mandatory_arg_error
1047: (p_api_name => l_proc
1048: ,p_argument => 'validation_end_date'
1049: ,p_argument_value => p_validation_end_date
1050: );*/

Line 1112: hr_api.mandatory_arg_error

1108: Begin
1109: --
1110: -- Ensure that the p_datetrack_mode argument is not null
1111: --
1112: hr_api.mandatory_arg_error
1113: (p_api_name => l_proc
1114: ,p_argument => 'datetrack_mode'
1115: ,p_argument_value => p_datetrack_mode
1116: );

Line 1121: If (p_datetrack_mode = hr_api.g_delete or

1117: --
1118: -- Only perform the validation if the datetrack mode is either
1119: -- DELETE or ZAP
1120: --
1121: If (p_datetrack_mode = hr_api.g_delete or
1122: p_datetrack_mode = hr_api.g_zap) then
1123: --
1124: --
1125: -- Ensure the arguments are not null

Line 1122: p_datetrack_mode = hr_api.g_zap) then

1118: -- Only perform the validation if the datetrack mode is either
1119: -- DELETE or ZAP
1120: --
1121: If (p_datetrack_mode = hr_api.g_delete or
1122: p_datetrack_mode = hr_api.g_zap) then
1123: --
1124: --
1125: -- Ensure the arguments are not null
1126: --

Line 1127: hr_api.mandatory_arg_error

1123: --
1124: --
1125: -- Ensure the arguments are not null
1126: --
1127: hr_api.mandatory_arg_error
1128: (p_api_name => l_proc
1129: ,p_argument => 'validation_start_date'
1130: ,p_argument_value => p_validation_start_date
1131: );

Line 1133: /*hr_api.mandatory_arg_error

1129: ,p_argument => 'validation_start_date'
1130: ,p_argument_value => p_validation_start_date
1131: );
1132: --
1133: /*hr_api.mandatory_arg_error
1134: (p_api_name => l_proc
1135: ,p_argument => 'validation_end_date'
1136: ,p_argument_value => p_validation_end_date
1137: );*/

Line 1139: hr_api.mandatory_arg_error

1135: ,p_argument => 'validation_end_date'
1136: ,p_argument_value => p_validation_end_date
1137: );*/
1138: --
1139: hr_api.mandatory_arg_error
1140: (p_api_name => l_proc
1141: ,p_argument => 'condition_id'
1142: ,p_argument_value => p_condition_id
1143: );