DBA Data[Home] [Help]

APPS.HR_H2PI_MAP dependencies on HR_UTILITY

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

24: INVALID_PARAM EXCEPTION;
25: PRAGMA EXCEPTION_INIT(INVALID_PARAM,-20001);
26:
27: BEGIN
28: hr_utility.set_location('Entering:'|| l_proc, 10);
29: --
30: IF p_table_name IS NULL THEN
31: hr_utility.set_location(l_proc, 20);
32: l_mesg :='FATAL - CREATE_ID_MAPPING:' ||

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

27: BEGIN
28: hr_utility.set_location('Entering:'|| l_proc, 10);
29: --
30: IF p_table_name IS NULL THEN
31: hr_utility.set_location(l_proc, 20);
32: l_mesg :='FATAL - CREATE_ID_MAPPING:' ||
33: ' The Parameter Value for TABLE_NAME cannot be null';
34: RAISE INVALID_PARAM;
35: ELSIF p_from_id IS NULL THEN

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

32: l_mesg :='FATAL - CREATE_ID_MAPPING:' ||
33: ' The Parameter Value for TABLE_NAME cannot be null';
34: RAISE INVALID_PARAM;
35: ELSIF p_from_id IS NULL THEN
36: hr_utility.set_location(l_proc, 30);
37: l_mesg := 'FATAL - CREATE_ID_MAPPING: '||
38: 'The Parameter Value for FROM_ID cannot be null';
39: RAISE INVALID_PARAM;
40: ELSIF p_to_id IS NULL THEN

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

37: l_mesg := 'FATAL - CREATE_ID_MAPPING: '||
38: 'The Parameter Value for FROM_ID cannot be null';
39: RAISE INVALID_PARAM;
40: ELSIF p_to_id IS NULL THEN
41: hr_utility.set_location(l_proc, 40);
42: l_mesg := 'FATAL - CREATE_ID_MAPPING: '||
43: 'The Parameter Value for TO_ID cannot be null';
44: RAISE INVALID_PARAM;
45: END IF;

Line 61: hr_utility.set_location('Leaving:'|| l_proc, 50);

57: hr_h2pi_upload.g_to_business_group_id
58: AND from_id = p_from_id
59: AND to_id = p_to_id
60: AND table_name = p_table_name);
61: hr_utility.set_location('Leaving:'|| l_proc, 50);
62: EXCEPTION
63: WHEN INVALID_PARAM THEN
64: hr_utility.set_location(l_proc, 60);
65: fnd_file.put_line(FND_FILE.LOG,l_mesg);

Line 64: hr_utility.set_location(l_proc, 60);

60: AND table_name = p_table_name);
61: hr_utility.set_location('Leaving:'|| l_proc, 50);
62: EXCEPTION
63: WHEN INVALID_PARAM THEN
64: hr_utility.set_location(l_proc, 60);
65: fnd_file.put_line(FND_FILE.LOG,l_mesg);
66: RAISE;
67: WHEN OTHERS THEN
68: hr_utility.set_location(l_proc, 70);

Line 68: hr_utility.set_location(l_proc, 70);

64: hr_utility.set_location(l_proc, 60);
65: fnd_file.put_line(FND_FILE.LOG,l_mesg);
66: RAISE;
67: WHEN OTHERS THEN
68: hr_utility.set_location(l_proc, 70);
69: fnd_file.put_line(FND_FILE.LOG, 'FATAL - ' || SQLERRM);
70: RAISE;
71: END create_id_mapping;
72: --