DBA Data[Home] [Help]

APPS.PER_FR_PEOPLE_LEG_HOOK dependencies on HR_UTILITY

Line 49: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

45: BEGIN
46:
47: --
48: /* Added for GSI Bug 5472781 */
49: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
50: hr_utility.set_location('Leaving:'||l_proc , 10);
51: return;
52: END IF;
53: --

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

46:
47: --
48: /* Added for GSI Bug 5472781 */
49: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
50: hr_utility.set_location('Leaving:'||l_proc , 10);
51: return;
52: END IF;
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 10);

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

50: hr_utility.set_location('Leaving:'||l_proc , 10);
51: return;
52: END IF;
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55:
56: IF p_region_of_birth IS NOT NULL THEN
57: IF (p_country_of_birth <> 'FR') THEN
58: -- Bug 12403564

Line 59: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');

55:
56: IF p_region_of_birth IS NOT NULL THEN
57: IF (p_country_of_birth <> 'FR') THEN
58: -- Bug 12403564
59: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');
60: hr_utility.raise_error;
61: fnd_message.set_name('PER', 'PER_75058_REGION_NULL_INFO');
62: fnd_message.raise_error;
63: -- Bug 12403564

Line 60: hr_utility.raise_error;

56: IF p_region_of_birth IS NOT NULL THEN
57: IF (p_country_of_birth <> 'FR') THEN
58: -- Bug 12403564
59: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');
60: hr_utility.raise_error;
61: fnd_message.set_name('PER', 'PER_75058_REGION_NULL_INFO');
62: fnd_message.raise_error;
63: -- Bug 12403564
64: ELSE

Line 70: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');

66: OPEN cur_dept;
67: FETCH cur_dept INTO l_dept, l_dept_code;
68: IF cur_dept%NOTFOUND THEN
69: CLOSE cur_dept;
70: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
71: hr_utility.raise_error;
72: END IF;
73: CLOSE cur_dept;
74: END IF;

Line 71: hr_utility.raise_error;

67: FETCH cur_dept INTO l_dept, l_dept_code;
68: IF cur_dept%NOTFOUND THEN
69: CLOSE cur_dept;
70: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
71: hr_utility.raise_error;
72: END IF;
73: CLOSE cur_dept;
74: END IF;
75: END IF;

Line 79: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');

75: END IF;
76:
77: IF p_country_of_birth = 'FR'
78: AND p_per_information10 IS NOT NULL THEN
79: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
80: hr_utility.raise_error;
81:
82: END IF;
83:

Line 80: hr_utility.raise_error;

76:
77: IF p_country_of_birth = 'FR'
78: AND p_per_information10 IS NOT NULL THEN
79: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
80: hr_utility.raise_error;
81:
82: END IF;
83:
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 84: hr_utility.set_location(' Leaving:'|| l_proc, 20);

80: hr_utility.raise_error;
81:
82: END IF;
83:
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: END check_regn_entry_ins;
86:
87:
88:

Line 121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

117: BEGIN
118:
119: --
120: /* Added for GSI Bug 5472781 */
121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
122: hr_utility.set_location('Leaving:'|| l_proc , 10);
123: return;
124: END IF;
125: --

Line 122: hr_utility.set_location('Leaving:'|| l_proc , 10);

118:
119: --
120: /* Added for GSI Bug 5472781 */
121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
122: hr_utility.set_location('Leaving:'|| l_proc , 10);
123: return;
124: END IF;
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);

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

122: hr_utility.set_location('Leaving:'|| l_proc , 10);
123: return;
124: END IF;
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: hr_utility.trace('region:'|| p_region_of_birth);
128: hr_utility.trace('country:'|| p_country_of_birth);
129: hr_utility.trace('entered:'|| p_per_information10);
130: hr_utility.trace('date:'|| to_char(p_effective_date));

Line 127: hr_utility.trace('region:'|| p_region_of_birth);

123: return;
124: END IF;
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: hr_utility.trace('region:'|| p_region_of_birth);
128: hr_utility.trace('country:'|| p_country_of_birth);
129: hr_utility.trace('entered:'|| p_per_information10);
130: hr_utility.trace('date:'|| to_char(p_effective_date));
131: -- get the old values, or the updated new values - remove the default placeholders

Line 128: hr_utility.trace('country:'|| p_country_of_birth);

124: END IF;
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: hr_utility.trace('region:'|| p_region_of_birth);
128: hr_utility.trace('country:'|| p_country_of_birth);
129: hr_utility.trace('entered:'|| p_per_information10);
130: hr_utility.trace('date:'|| to_char(p_effective_date));
131: -- get the old values, or the updated new values - remove the default placeholders
132: select region_of_birth, country_of_birth, per_information10

Line 129: hr_utility.trace('entered:'|| p_per_information10);

125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: hr_utility.trace('region:'|| p_region_of_birth);
128: hr_utility.trace('country:'|| p_country_of_birth);
129: hr_utility.trace('entered:'|| p_per_information10);
130: hr_utility.trace('date:'|| to_char(p_effective_date));
131: -- get the old values, or the updated new values - remove the default placeholders
132: select region_of_birth, country_of_birth, per_information10
133: into l_old_region_of_birth, l_old_country_of_birth, l_old_information10

Line 130: hr_utility.trace('date:'|| to_char(p_effective_date));

126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: hr_utility.trace('region:'|| p_region_of_birth);
128: hr_utility.trace('country:'|| p_country_of_birth);
129: hr_utility.trace('entered:'|| p_per_information10);
130: hr_utility.trace('date:'|| to_char(p_effective_date));
131: -- get the old values, or the updated new values - remove the default placeholders
132: select region_of_birth, country_of_birth, per_information10
133: into l_old_region_of_birth, l_old_country_of_birth, l_old_information10
134: from per_all_people_f

Line 161: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');

157: IF l_use_region_of_birth IS NOT NULL THEN
158: IF (nvl(l_use_country_of_birth, ' ' ) <> 'FR') THEN
159: --Error if region is set country must be France
160: -- Bug 12403564
161: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');
162: hr_utility.raise_error;
163: fnd_message.set_name('PER', 'PER_75058_REGION_NULL_INFO');
164: fnd_message.raise_error;
165: -- Bug 12403564

Line 162: hr_utility.raise_error;

158: IF (nvl(l_use_country_of_birth, ' ' ) <> 'FR') THEN
159: --Error if region is set country must be France
160: -- Bug 12403564
161: hr_utility.set_message(800, 'PER_75058_REGION_NULL_INFO');
162: hr_utility.raise_error;
163: fnd_message.set_name('PER', 'PER_75058_REGION_NULL_INFO');
164: fnd_message.raise_error;
165: -- Bug 12403564
166: ELSE

Line 172: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');

168: OPEN cur_dept;
169: FETCH cur_dept INTO l_dept, l_dept_code;
170: IF cur_dept%NOTFOUND THEN
171: CLOSE cur_dept;
172: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE cur_dept;
176: END IF;

Line 173: hr_utility.raise_error;

169: FETCH cur_dept INTO l_dept, l_dept_code;
170: IF cur_dept%NOTFOUND THEN
171: CLOSE cur_dept;
172: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE cur_dept;
176: END IF;
177: END IF;

Line 181: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');

177: END IF;
178:
179: IF nvl(l_use_country_of_birth,' ') = 'FR' AND l_use_information10 IS NOT NULL THEN
180: --Error must not set both FR as country, and date first entered France
181: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
182: hr_utility.raise_error;
183: END IF;
184:
185: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 182: hr_utility.raise_error;

178:
179: IF nvl(l_use_country_of_birth,' ') = 'FR' AND l_use_information10 IS NOT NULL THEN
180: --Error must not set both FR as country, and date first entered France
181: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
182: hr_utility.raise_error;
183: END IF;
184:
185: hr_utility.set_location(' Leaving:'||l_proc, 20);
186: END check_regn_entry_upd;

Line 185: hr_utility.set_location(' Leaving:'||l_proc, 20);

181: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
182: hr_utility.raise_error;
183: END IF;
184:
185: hr_utility.set_location(' Leaving:'||l_proc, 20);
186: END check_regn_entry_upd;
187: --
188: END per_fr_people_leg_hook;