DBA Data[Home] [Help]

APPS.HR_CAL_ENTRY_VALUE_API dependencies on HR_UTILITY

Line 39: hr_utility.set_location('Entering:'|| l_proc, 10);

35: l_object_version_number number(15);
36: l_effective_date date;
37: --
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint create_cal_entry_value;

Line 128: hr_utility.set_location(' Leaving:'||l_proc, 70);

124: --
125: p_cal_entry_value_id := l_cal_entry_value_id;
126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: exception
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised

Line 143: hr_utility.set_location(' Leaving:'||l_proc, 80);

139: -- when validation only mode is being used.)
140: --
141: p_cal_entry_value_id := null;
142: p_object_version_number := null;
143: hr_utility.set_location(' Leaving:'||l_proc, 80);
144: when others then
145: --
146: -- A validation or unexpected error has occured
147: --

Line 149: hr_utility.set_location(' Leaving:'||l_proc, 90);

145: --
146: -- A validation or unexpected error has occured
147: --
148: rollback to create_cal_entry_value;
149: hr_utility.set_location(' Leaving:'||l_proc, 90);
150: raise;
151: end create_entry_value;
152: --
153: -- ----------------------------------------------------------------------------

Line 177: hr_utility.set_location('Entering:'|| l_proc, 10);

173: l_object_version_number per_cal_entry_values.object_version_number%TYPE;
174: l_effective_date date;
175: --
176: begin
177: hr_utility.set_location('Entering:'|| l_proc, 10);
178: --
179: -- Issue a savepoint
180: --
181: savepoint update_cal_entry_value;

Line 256: hr_utility.set_location(' Leaving:'||l_proc, 70);

252: -- Set all output arguments
253: --
254: p_object_version_number := l_object_version_number;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised

Line 269: hr_utility.set_location(' Leaving:'||l_proc, 80);

265: -- Only set output warning arguments
266: -- (Any key or derived arguments must be set to null
267: -- when validation only mode is being used.)
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 80);
270: when others then
271: --
272: -- A validation or unexpected error has occured
273: --

Line 275: hr_utility.set_location(' Leaving:'||l_proc, 90);

271: --
272: -- A validation or unexpected error has occured
273: --
274: rollback to update_cal_entry_value;
275: hr_utility.set_location(' Leaving:'||l_proc, 90);
276: raise;
277: end update_entry_value;
278: --
279: --

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

291: --
292: l_proc varchar2(72) := g_package||'delete_entry_value';
293: --
294: begin
295: hr_utility.set_location('Entering:'|| l_proc, 5);
296: --
297: -- Issue a savepoint if operating in validation only mode.
298: --
299: savepoint delete_cal_entry_value;

Line 317: hr_utility.set_location(l_proc, 7);

313: );
314: end;
315: --
316: --
317: hr_utility.set_location(l_proc, 7);
318: --
319: -- Process Logic
320: --
321: per_env_del.del

Line 326: hr_utility.set_location(l_proc, 8);

322: (p_cal_entry_value_id => p_cal_entry_value_id
323: ,p_object_version_number => p_object_version_number
324: );
325: --
326: hr_utility.set_location(l_proc, 8);
327: --
328: --
329: -- Call After Process User Hook
330: begin

Line 349: hr_utility.set_location(' Leaving:'||l_proc, 11);

345: if p_validate then
346: raise hr_api.validate_enabled;
347: end if;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 11);
350: exception
351: when hr_api.validate_enabled then
352: --
353: -- As the Validate_Enabled exception has been raised

Line 358: hr_utility.set_location(' Leaving:'||l_proc, 12);

354: -- we must rollback to the savepoint
355: --
356: ROLLBACK TO delete_cal_entry_value;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 12);
359: --
360: when others then
361: --
362: --

Line 491: hr_utility.set_location(l_proc, 30);

487: elsif l_validation_type = 'F' then
488:
489: --
490: -- next evaluate the value_set for the entity_id supplied
491: hr_utility.set_location(l_proc, 30);
492: --
493: l_sql_statement := get_sql_from_vset_id(p_vset_id => l_value_set_id);
494: --
495: l_sql_statement := REPLACE(l_sql_statement

Line 518: hr_utility.set_location(l_proc, 40);

514: l_sql_statement := l_sql_statement||' where '||l_id_column||' = :id ';
515: end if;
516: --
517: --
518: hr_utility.set_location(l_proc, 40);
519: --
520: BEGIN
521: --
522: EXECUTE IMMEDIATE l_sql_statement INTO l_value_id, l_name USING l_id;

Line 527: hr_utility.set_location(l_proc||l_sql_statement,45);

523: --
524: EXCEPTION
525: --
526: WHEN OTHERS THEN
527: hr_utility.set_location(l_proc||l_sql_statement,45);
528: l_name := 'INVALID_VALUE_SET SQL: ' || l_sql_statement ||
529: ', vs_id : ' || l_value_set_id ||
530: ', l_value_id: ' || l_id;
531: --

Line 533: hr_utility.set_location(l_proc, 50);

529: ', vs_id : ' || l_value_set_id ||
530: ', l_value_id: ' || l_id;
531: --
532: END;
533: hr_utility.set_location(l_proc, 50);
534: --
535: end if;
536:
537: end if;

Line 539: hr_utility.set_location('Leaving :'||l_proc, 60);

535: end if;
536:
537: end if;
538: --
539: hr_utility.set_location('Leaving :'||l_proc, 60);
540: --
541: RETURN l_name;
542: --
543: END get_display_value;