DBA Data[Home] [Help]

APPS.PER_CPA_BUS dependencies on HR_API

Line 48: hr_api.mandatory_arg_error

44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'cagr_api_param_id'
51: ,p_argument_value => p_cagr_api_param_id
52: );

Line 71: hr_api.set_security_group_id

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

Line 112: hr_api.mandatory_arg_error

108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Ensure that all the mandatory parameter are not null
111: --
112: hr_api.mandatory_arg_error
113: (p_api_name => l_proc
114: ,p_argument => 'cagr_api_param_id'
115: ,p_argument_value => p_cagr_api_param_id
116: );

Line 118: if ( nvl(per_cpa_bus.g_cagr_api_param_id, hr_api.g_number)

114: ,p_argument => 'cagr_api_param_id'
115: ,p_argument_value => p_cagr_api_param_id
116: );
117: --
118: if ( nvl(per_cpa_bus.g_cagr_api_param_id, hr_api.g_number)
119: = p_cagr_api_param_id) then
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global

Line 481: hr_api.mandatory_arg_error

477: hr_utility.set_location('Entering '||l_proc, 10);
478: --
479: -- Check mandatory parameters has been set
480: --
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc
483: ,p_argument => 'HIDDEN'
484: ,p_argument_value => p_hidden);
485: --

Line 498: IF hr_api.not_exists_in_hr_lookups

494: hr_utility.set_location(l_proc, 20);
495: --
496: -- Check that the type exists in HR_LOOKUPS
497: --
498: IF hr_api.not_exists_in_hr_lookups
499: (p_effective_date => p_effective_date
500: ,p_lookup_type => 'YES_NO'
501: ,p_lookup_code => p_hidden) THEN
502: --

Line 575: IF hr_api.not_exists_in_hr_lookups

571: hr_utility.set_location(l_proc, 20);
572: --
573: -- Check that the type exists in HR_LOOKUPS
574: --
575: IF hr_api.not_exists_in_hr_lookups
576: (p_effective_date => p_effective_date
577: ,p_lookup_type => 'CAGR_PARAM_TYPES'
578: ,p_lookup_code => p_column_type) THEN
579: --

Line 787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>

783: -- b) The value for consultation type has changed
784: --
785: IF ( (p_cagr_api_param_id IS NULL) OR
786: ((p_cagr_api_param_id IS NOT NULL) AND
787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>
788: NVL(p_uom_lookup,hr_api.g_varchar2)))) THEN
789: --
790: hr_utility.set_location(l_proc, 20);
791: --

Line 788: NVL(p_uom_lookup,hr_api.g_varchar2)))) THEN

784: --
785: IF ( (p_cagr_api_param_id IS NULL) OR
786: ((p_cagr_api_param_id IS NOT NULL) AND
787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>
788: NVL(p_uom_lookup,hr_api.g_varchar2)))) THEN
789: --
790: hr_utility.set_location(l_proc, 20);
791: --
792: -- Check that the type exists in HR_LOOKUPS

Line 887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>

883: -- b) The value for consultation type has changed
884: --
885: IF ( (p_cagr_api_param_id IS NULL) OR
886: ((p_cagr_api_param_id IS NOT NULL) AND
887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>
888: NVL(p_default_uom,hr_api.g_varchar2)))) THEN
889: --
890: hr_utility.set_location(l_proc, 20);
891: --

Line 888: NVL(p_default_uom,hr_api.g_varchar2)))) THEN

884: --
885: IF ( (p_cagr_api_param_id IS NULL) OR
886: ((p_cagr_api_param_id IS NOT NULL) AND
887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>
888: NVL(p_default_uom,hr_api.g_varchar2)))) THEN
889: --
890: hr_utility.set_location(l_proc, 20);
891: --
892: -- Check that the default_uom exists in HR_LOOKUPS

Line 895: IF hr_api.not_exists_in_hr_lookups

891: --
892: -- Check that the default_uom exists in HR_LOOKUPS
893: -- for the UNITS lookup type
894: --
895: IF hr_api.not_exists_in_hr_lookups
896: (p_effective_date => p_effective_date
897: ,p_lookup_type => 'UNITS'
898: ,p_lookup_code => p_default_uom) THEN
899: --

Line 1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>

1042: fnd_message.set_token('STEP ', '5');
1043: fnd_message.raise_error;
1044: END IF;
1045: --
1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN
1048: --
1049: l_argument := 'cagr_api_params_id';
1050: RAISE l_error;

Line 1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN

1043: fnd_message.raise_error;
1044: END IF;
1045: --
1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN
1048: --
1049: l_argument := 'cagr_api_params_id';
1050: RAISE l_error;
1051: --

Line 1054: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>

1050: RAISE l_error;
1051: --
1052: END IF;
1053: --
1054: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>
1055: nvl(per_cpa_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN
1056: --
1057: l_argument := 'cagr_api_id';
1058: RAISE l_error;

Line 1055: nvl(per_cpa_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN

1051: --
1052: END IF;
1053: --
1054: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>
1055: nvl(per_cpa_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN
1056: --
1057: l_argument := 'cagr_api_id';
1058: RAISE l_error;
1059: --

Line 1062: IF nvl(p_rec.parameter_name, hr_api.g_varchar2) <>

1058: RAISE l_error;
1059: --
1060: END IF;
1061: --
1062: IF nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
1063: nvl(per_cpa_shd.g_old_rec.parameter_name,hr_api.g_varchar2) THEN
1064: --
1065: l_argument := 'parameter_name';
1066: RAISE l_error;

Line 1063: nvl(per_cpa_shd.g_old_rec.parameter_name,hr_api.g_varchar2) THEN

1059: --
1060: END IF;
1061: --
1062: IF nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
1063: nvl(per_cpa_shd.g_old_rec.parameter_name,hr_api.g_varchar2) THEN
1064: --
1065: l_argument := 'parameter_name';
1066: RAISE l_error;
1067: --

Line 1072: hr_api.argument_changed_error

1068: END IF;
1069: --
1070: EXCEPTION
1071: WHEN l_error THEN
1072: hr_api.argument_changed_error
1073: (p_api_name => l_proc
1074: ,p_argument => l_argument);
1075: WHEN OTHERS THEN
1076: RAISE;