DBA Data[Home] [Help]

APPS.PER_CN_ADD_LEG_HOOK dependencies on HR_CN_API

Line 89: hr_cn_api.set_location(g_trace,'Entering: '||l_proc,10);

85: BEGIN
86:
87: g_trace := hr_cn_person_address_api.g_trace;
88:
89: hr_cn_api.set_location(g_trace,'Entering: '||l_proc,10);
90:
91: --
92: -- Bug 3145322 Check the leg-specific validations only if the legislation
93: -- is installed

Line 97: hr_cn_api.set_location(g_trace,'Leaving: '||l_proc, 15);

93: -- is installed
94: --
95: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'CN') THEN
96: hr_utility.trace ('CN Legislation not installed. Not performing the validations');
97: hr_cn_api.set_location(g_trace,'Leaving: '||l_proc, 15);
98: RETURN;
99: END IF;
100:
101: if p_style = 'CN_GLB' then

Line 111: hr_cn_api.set_location (g_trace, l_proc, 20);

107: p_argument => 'P_ADDRESS_LINE1',
108: p_argument_value => p_address_line1
109: );
110:
111: hr_cn_api.set_location (g_trace, l_proc, 20);
112: hr_api.mandatory_arg_error
113: (p_api_name => l_proc,
114: p_argument => 'P_COUNTRY',
115: p_argument_value => p_country

Line 118: hr_cn_api.set_location (g_trace, l_proc, 30);

114: p_argument => 'P_COUNTRY',
115: p_argument_value => p_country
116: );
117:
118: hr_cn_api.set_location (g_trace, l_proc, 30);
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc,
121: p_argument => 'P_PROVINCE_CITY_SAR',
122: p_argument_value => p_town_or_city

Line 125: hr_cn_api.set_location (g_trace, l_proc, 30);

121: p_argument => 'P_PROVINCE_CITY_SAR',
122: p_argument_value => p_town_or_city
123: );
124:
125: hr_cn_api.set_location (g_trace, l_proc, 30);
126: hr_api.mandatory_arg_error
127: (p_api_name => l_proc,
128: p_argument => 'P_POSTAL_CODE',
129: p_argument_value => p_postal_code

Line 134: hr_cn_api.set_location (g_trace, l_proc, 40);

130: );
131: --
132: -- Check the valid values for country
133: --
134: hr_cn_api.set_location (g_trace, l_proc, 40);
135: IF p_country <> hr_api.g_varchar2 THEN
136: OPEN csr_country(p_country);
137: FETCH csr_country INTO l_territory_code;
138: IF csr_country%NOTFOUND THEN

Line 139: hr_cn_api.set_location (g_trace, l_proc, 50);

135: IF p_country <> hr_api.g_varchar2 THEN
136: OPEN csr_country(p_country);
137: FETCH csr_country INTO l_territory_code;
138: IF csr_country%NOTFOUND THEN
139: hr_cn_api.set_location (g_trace, l_proc, 50);
140: CLOSE csr_country;
141: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');
142: hr_utility.set_message_token('VALUE',p_country);
143: hr_utility.set_message_token('FIELD','P_COUNTRY');

Line 150: hr_cn_api.set_location (g_trace, l_proc, 60);

146: END IF;
147: --
148: -- Check the valid lookup values
149: --
150: hr_cn_api.set_location (g_trace, l_proc, 60);
151: IF p_town_or_city <> hr_api.g_varchar2 THEN
152: hr_cn_api.check_lookup (
153: p_lookup_type => 'CN_PROVINCE',
154: p_argument => 'P_PROVINCE_CITY_SAR',

Line 152: hr_cn_api.check_lookup (

148: -- Check the valid lookup values
149: --
150: hr_cn_api.set_location (g_trace, l_proc, 60);
151: IF p_town_or_city <> hr_api.g_varchar2 THEN
152: hr_cn_api.check_lookup (
153: p_lookup_type => 'CN_PROVINCE',
154: p_argument => 'P_PROVINCE_CITY_SAR',
155: p_argument_value => p_town_or_city
156: );

Line 159: hr_cn_api.set_location (g_trace, l_proc, 90);

155: p_argument_value => p_town_or_city
156: );
157: END IF;
158:
159: hr_cn_api.set_location (g_trace, l_proc, 90);
160: IF p_postal_code <> hr_api.g_varchar2 THEN
161: IF NOT hr_cn_api.is_valid_postal_code(p_postal_code) THEN
162: hr_cn_api.set_location (g_trace, l_proc, 100);
163: hr_utility.set_message(800,'HR_374603_INVALID_RANGE');

Line 161: IF NOT hr_cn_api.is_valid_postal_code(p_postal_code) THEN

157: END IF;
158:
159: hr_cn_api.set_location (g_trace, l_proc, 90);
160: IF p_postal_code <> hr_api.g_varchar2 THEN
161: IF NOT hr_cn_api.is_valid_postal_code(p_postal_code) THEN
162: hr_cn_api.set_location (g_trace, l_proc, 100);
163: hr_utility.set_message(800,'HR_374603_INVALID_RANGE');
164: hr_utility.set_message_token('NUMBER','P_POSTAL_CODE');
165: -- Bug 3226285

Line 162: hr_cn_api.set_location (g_trace, l_proc, 100);

158:
159: hr_cn_api.set_location (g_trace, l_proc, 90);
160: IF p_postal_code <> hr_api.g_varchar2 THEN
161: IF NOT hr_cn_api.is_valid_postal_code(p_postal_code) THEN
162: hr_cn_api.set_location (g_trace, l_proc, 100);
163: hr_utility.set_message(800,'HR_374603_INVALID_RANGE');
164: hr_utility.set_message_token('NUMBER','P_POSTAL_CODE');
165: -- Bug 3226285
166: hr_utility.set_message_token('LOW','000001');

Line 174: hr_cn_api.set_location (g_trace, 'Leaving: '||l_proc, 100);

170: END IF;
171:
172: END IF;
173:
174: hr_cn_api.set_location (g_trace, 'Leaving: '||l_proc, 100);
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: IF csr_country%ISOPEN THEN

Line 279: hr_cn_api.set_location(g_trace,'Entering: '||l_proc,10);

275: -- Added code to fetch address style.
276: --
277: g_trace := hr_cn_person_address_api.g_trace;
278:
279: hr_cn_api.set_location(g_trace,'Entering: '||l_proc,10);
280:
281: OPEN csr_addr_style(p_address_id);
282: FETCH csr_addr_style INTO l_style;
283:

Line 301: hr_cn_api.set_location(g_trace,'Leaving: '||l_proc,20);

297: ,p_town_or_city => p_town_or_city
298: ,p_country => p_country
299: ,p_postal_code => p_postal_code);
300:
301: hr_cn_api.set_location(g_trace,'Leaving: '||l_proc,20);
302:
303: END check_address_upd;
304:
305: