eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');

Line 58: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');

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: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');
59: hr_utility.raise_error;
60: ELSE
61:
62: OPEN cur_dept;

Line 59: hr_utility.raise_error;

55:
56: IF p_region_of_birth IS NOT NULL THEN
57: IF (p_country_of_birth <> 'FR') THEN
58: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');
59: hr_utility.raise_error;
60: ELSE
61:
62: OPEN cur_dept;
63: FETCH cur_dept INTO l_dept, l_dept_code;

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

62: OPEN cur_dept;
63: FETCH cur_dept INTO l_dept, l_dept_code;
64: IF cur_dept%NOTFOUND THEN
65: CLOSE cur_dept;
66: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
67: hr_utility.raise_error;
68: END IF;
69: CLOSE cur_dept;
70: END IF;

Line 67: hr_utility.raise_error;

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

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

71: END IF;
72:
73: IF p_country_of_birth = 'FR'
74: AND p_per_information10 IS NOT NULL THEN
75: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
76: hr_utility.raise_error;
77:
78: END IF;
79:

Line 76: hr_utility.raise_error;

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

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

76: hr_utility.raise_error;
77:
78: END IF;
79:
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
81: END check_regn_entry_ins;
82:
83:
84:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 156: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');

152: --
153: IF l_use_region_of_birth IS NOT NULL THEN
154: IF (nvl(l_use_country_of_birth, ' ' ) <> 'FR') THEN
155: --Error if region is set country must be France
156: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');
157: hr_utility.raise_error;
158: ELSE
159: -- Validate the department of birth
160: OPEN cur_dept;

Line 157: hr_utility.raise_error;

153: IF l_use_region_of_birth IS NOT NULL THEN
154: IF (nvl(l_use_country_of_birth, ' ' ) <> 'FR') THEN
155: --Error if region is set country must be France
156: hr_utility.set_message(800,'PER_FR_REGION_NULL_INFO');
157: hr_utility.raise_error;
158: ELSE
159: -- Validate the department of birth
160: OPEN cur_dept;
161: FETCH cur_dept INTO l_dept, l_dept_code;

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

160: OPEN cur_dept;
161: FETCH cur_dept INTO l_dept, l_dept_code;
162: IF cur_dept%NOTFOUND THEN
163: CLOSE cur_dept;
164: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
165: hr_utility.raise_error;
166: END IF;
167: CLOSE cur_dept;
168: END IF;

Line 165: hr_utility.raise_error;

161: FETCH cur_dept INTO l_dept, l_dept_code;
162: IF cur_dept%NOTFOUND THEN
163: CLOSE cur_dept;
164: hr_utility.set_message(800,'PER_FR_REGION_INVALID_INFO');
165: hr_utility.raise_error;
166: END IF;
167: CLOSE cur_dept;
168: END IF;
169: END IF;

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

169: END IF;
170:
171: IF nvl(l_use_country_of_birth,' ') = 'FR' AND l_use_information10 IS NOT NULL THEN
172: --Error must not set both FR as country, and date first entered France
173: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
174: hr_utility.raise_error;
175: END IF;
176:
177: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 174: hr_utility.raise_error;

170:
171: IF nvl(l_use_country_of_birth,' ') = 'FR' AND l_use_information10 IS NOT NULL THEN
172: --Error must not set both FR as country, and date first entered France
173: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
174: hr_utility.raise_error;
175: END IF;
176:
177: hr_utility.set_location(' Leaving:'||l_proc, 20);
178: END check_regn_entry_upd;

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

173: hr_utility.set_message(800,'PER_FR_DATE_ENTERED_INFO');
174: hr_utility.raise_error;
175: END IF;
176:
177: hr_utility.set_location(' Leaving:'||l_proc, 20);
178: END check_regn_entry_upd;
179: --
180: END per_fr_people_leg_hook;