DBA Data[Home] [Help]

APPS.HR_APP_API_HOOK_CALL_INTERNAL dependencies on HR_UTILITY

Line 60: hr_utility.set_location('Entering:'|| l_proc, 5);

56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Set l_effective_date equal to truncated version of p_effective_date for
63: -- API work. Stops dates being passed to row handlers with time portion.
64: --

Line 71: hr_utility.set_location(l_proc, 10);

67: -- Issue a savepoint if operating in validation only mode.
68: --
69: savepoint create_app_api_hook_call;
70: --
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Validation in addition to Table Handlers
74: --
75: if (p_application_id is NULL) then

Line 77: hr_utility.set_message(800, 'PER_289090_AHC_APP_ID_NULL');

73: -- Validation in addition to Table Handlers
74: --
75: if (p_application_id is NULL) then
76: --
77: hr_utility.set_message(800, 'PER_289090_AHC_APP_ID_NULL');
78: hr_utility.raise_error;
79: --
80: end if;
81: --

Line 78: hr_utility.raise_error;

74: --
75: if (p_application_id is NULL) then
76: --
77: hr_utility.set_message(800, 'PER_289090_AHC_APP_ID_NULL');
78: hr_utility.raise_error;
79: --
80: end if;
81: --
82: if (p_app_install_status is NULL) then

Line 84: hr_utility.set_message(800,'PER_289091_AHC_INST_STAT_NULL');

80: end if;
81: --
82: if (p_app_install_status is NULL) then
83: --
84: hr_utility.set_message(800,'PER_289091_AHC_INST_STAT_NULL');
85: hr_utility.raise_error;
86: --
87: end if;
88: --

Line 85: hr_utility.raise_error;

81: --
82: if (p_app_install_status is NULL) then
83: --
84: hr_utility.set_message(800,'PER_289091_AHC_INST_STAT_NULL');
85: hr_utility.raise_error;
86: --
87: end if;
88: --
89: -- Process Logic

Line 124: hr_utility.set_location(l_proc, 20);

120: end if;
121:
122: close csr_valid_combo;
123:
124: hr_utility.set_location(l_proc, 20);
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then

Line 137: hr_utility.set_location(' Leaving:'||l_proc, 100);

133: --
134: p_api_hook_call_id := l_api_hook_call_id;
135: p_object_version_number := l_object_version_number;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 100);
138: exception
139: when hr_api.validate_enabled then
140: --
141: -- As the Validate_Enabled exception has been raised

Line 187: hr_utility.set_location('Entering:'|| l_proc, 5);

183: --
184: l_exists varchar2(1);
185: --
186: begin
187: hr_utility.set_location('Entering:'|| l_proc, 5);
188: --
189: -- Issue a savepoint if operating in validation only mode.
190: --
191: savepoint delete_app_api_hook_call;

Line 193: hr_utility.set_location(l_proc, 10);

189: -- Issue a savepoint if operating in validation only mode.
190: --
191: savepoint delete_app_api_hook_call;
192: --
193: hr_utility.set_location(l_proc, 10);
194: --
195: -- Validation in addition to Table Handlers
196: --
197: -- Ensure the hook call definition specified is an application specific

Line 211: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');

207: FETCH csr_check_exists INTO l_exists;
208: IF csr_check_exists%NOTFOUND THEN
209: -- Hook does not exist at all.
210: CLOSE csr_check_exists;
211: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');
212: hr_utility.raise_error;
213: ELSE
214: -- Hook exists, but is not application hook.
215: CLOSE csr_check_exists;

Line 212: hr_utility.raise_error;

208: IF csr_check_exists%NOTFOUND THEN
209: -- Hook does not exist at all.
210: CLOSE csr_check_exists;
211: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');
212: hr_utility.raise_error;
213: ELSE
214: -- Hook exists, but is not application hook.
215: CLOSE csr_check_exists;
216: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');

Line 216: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');

212: hr_utility.raise_error;
213: ELSE
214: -- Hook exists, but is not application hook.
215: CLOSE csr_check_exists;
216: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');
217: hr_utility.raise_error;
218: END IF;
219: END IF;
220: CLOSE csr_check_app;

Line 217: hr_utility.raise_error;

213: ELSE
214: -- Hook exists, but is not application hook.
215: CLOSE csr_check_exists;
216: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');
217: hr_utility.raise_error;
218: END IF;
219: END IF;
220: CLOSE csr_check_app;
221: --

Line 229: hr_utility.set_location(l_proc, 20);

225: hr_ahc_del.del
226: (p_api_hook_call_id => p_api_hook_call_id,
227: p_object_version_number => p_object_version_number);
228: --
229: hr_utility.set_location(l_proc, 20);
230: --
231: -- When in validation only mode raise the Validate_Enabled exception
232: --
233: if p_validate then

Line 237: hr_utility.set_location(' Leaving:'||l_proc, 100);

233: if p_validate then
234: raise hr_api.validate_enabled;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised

Line 296: hr_utility.set_location('Entering:'|| l_proc, 5);

292: --
293: l_exists varchar2(1);
294: --
295: begin
296: hr_utility.set_location('Entering:'|| l_proc, 5);
297: --
298: -- Set l_effective_date equal to truncated version of p_effective_date for
299: -- API work. Stops dates being passed to row handlers with time portion.
300: --

Line 311: hr_utility.set_location(l_proc, 10);

307: -- Issue a savepoint if operating in validation only mode.
308: --
309: savepoint update_app_api_hook_call;
310: --
311: hr_utility.set_location(l_proc, 10);
312: --
313: -- Validation in addition to Table Handlers
314: --
315: -- Ensure the hook call definition specified is an application specific

Line 328: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');

324: FETCH csr_check_exists INTO l_exists;
325: IF csr_check_exists%NOTFOUND THEN
326: CLOSE csr_check_exists;
327: -- Hook call does not exist at all
328: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');
329: hr_utility.raise_error;
330: ELSE
331: CLOSE csr_check_exists;
332: -- Hook call exists, but does not reference Application Hook call.

Line 329: hr_utility.raise_error;

325: IF csr_check_exists%NOTFOUND THEN
326: CLOSE csr_check_exists;
327: -- Hook call does not exist at all
328: hr_utility.set_message(800,'PER_289096_AHC_HOOK_NOT_EXIST');
329: hr_utility.raise_error;
330: ELSE
331: CLOSE csr_check_exists;
332: -- Hook call exists, but does not reference Application Hook call.
333: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');

Line 333: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');

329: hr_utility.raise_error;
330: ELSE
331: CLOSE csr_check_exists;
332: -- Hook call exists, but does not reference Application Hook call.
333: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337: CLOSE csr_check_app;

Line 334: hr_utility.raise_error;

330: ELSE
331: CLOSE csr_check_exists;
332: -- Hook call exists, but does not reference Application Hook call.
333: hr_utility.set_message(800,'PER_289092_AHC_NOT_APPL_HOOK');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337: CLOSE csr_check_app;
338: --

Line 355: hr_utility.set_location(l_proc, 20);

351: p_status => p_status,
352: p_object_version_number => p_object_version_number
353: );
354: --
355: hr_utility.set_location(l_proc, 20);
356: --
357: -- When in validation only mode raise the Validate_Enabled exception
358: --
359: if p_validate then

Line 367: hr_utility.set_location(' Leaving:'||l_proc, 100);

363: -- Set all output arguments
364: --
365: p_object_version_number := l_object_version_number;
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 100);
368: exception
369: when hr_api.validate_enabled then
370: --
371: -- Only set output warning arguments