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_ALL_PEOPLE_F_ARIU dependencies on HR_UTILITY

Line 94: hr_utility.set_location('Entering:'||g_db_trigger,100);

90: return(l_person_number);
91: END get_next_value;
92: --
93: BEGIN
94: hr_utility.set_location('Entering:'||g_db_trigger,100);
95:
96: If hr_general.g_data_migrator_mode in ( 'Y','P') then --6365083
97: hr_utility.set_location('Data Migrator mode= '||hr_general.g_data_migrator_mode,101);
98: hr_utility.set_location('Leaving:'||g_db_trigger,996);

Line 97: hr_utility.set_location('Data Migrator mode= '||hr_general.g_data_migrator_mode,101);

93: BEGIN
94: hr_utility.set_location('Entering:'||g_db_trigger,100);
95:
96: If hr_general.g_data_migrator_mode in ( 'Y','P') then --6365083
97: hr_utility.set_location('Data Migrator mode= '||hr_general.g_data_migrator_mode,101);
98: hr_utility.set_location('Leaving:'||g_db_trigger,996);
99: return;
100: Else
101: open csr_method(:NEW.business_group_id);

Line 98: hr_utility.set_location('Leaving:'||g_db_trigger,996);

94: hr_utility.set_location('Entering:'||g_db_trigger,100);
95:
96: If hr_general.g_data_migrator_mode in ( 'Y','P') then --6365083
97: hr_utility.set_location('Data Migrator mode= '||hr_general.g_data_migrator_mode,101);
98: hr_utility.set_location('Leaving:'||g_db_trigger,996);
99: return;
100: Else
101: open csr_method(:NEW.business_group_id);
102: fetch csr_method into l_apl_method, l_emp_method, l_cwk_method;

Line 115: hr_utility.set_location(g_db_trigger,101);

111: )
112: AND not person_exists(:NEW.person_id, 'EMP')
113: then
114:
115: hr_utility.set_location(g_db_trigger,101);
116:
117: -- Special case for SSHR if the profile is set
118: -- as we need to make sure that the generation controls table is not
119: -- locked.

Line 124: hr_utility.set_location('Leaving:'||g_db_trigger,996);

120: -- if profile option is set that the employee number will not be generated and
121: -- instead a null employee number will be returned. (see bug 2552720)
122:
123: if fnd_profile.value('PER_SSHR_NO_EMPNUM_GENERATION') = 'Y' then
124: hr_utility.set_location('Leaving:'||g_db_trigger,996);
125: return;
126: end if;
127:
128: hr_utility.trace('>>> method found : '||l_emp_method);

Line 128: hr_utility.trace('>>> method found : '||l_emp_method);

124: hr_utility.set_location('Leaving:'||g_db_trigger,996);
125: return;
126: end if;
127:
128: hr_utility.trace('>>> method found : '||l_emp_method);
129:
130: if l_emp_method = 'A' then
131:
132: hr_utility.set_location(g_db_trigger,105);

Line 132: hr_utility.set_location(g_db_trigger,105);

128: hr_utility.trace('>>> method found : '||l_emp_method);
129:
130: if l_emp_method = 'A' then
131:
132: hr_utility.set_location(g_db_trigger,105);
133: l_next_value := get_next_value(:NEW.business_group_id,'EMP');
134: if l_next_value < 0 then -- global sequence has been used
135: hr_utility.set_location('Leaving:'||g_db_trigger,997);
136: return;

Line 135: hr_utility.set_location('Leaving:'||g_db_trigger,997);

131:
132: hr_utility.set_location(g_db_trigger,105);
133: l_next_value := get_next_value(:NEW.business_group_id,'EMP');
134: if l_next_value < 0 then -- global sequence has been used
135: hr_utility.set_location('Leaving:'||g_db_trigger,997);
136: return;
137: elsif l_next_value <> (to_number(:NEW.employee_number) + 1) then
138:
139: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));

Line 139: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));

135: hr_utility.set_location('Leaving:'||g_db_trigger,997);
136: return;
137: elsif l_next_value <> (to_number(:NEW.employee_number) + 1) then
138:
139: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
140: hr_utility.trace('>>>new employee number = '||:NEW.employee_number);
141:
142: -- method is already Automatic and employee number is out of sync ...
143:

Line 140: hr_utility.trace('>>>new employee number = '||:NEW.employee_number);

136: return;
137: elsif l_next_value <> (to_number(:NEW.employee_number) + 1) then
138:
139: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
140: hr_utility.trace('>>>new employee number = '||:NEW.employee_number);
141:
142: -- method is already Automatic and employee number is out of sync ...
143:
144: hr_utility.set_location(g_db_trigger,110);

Line 144: hr_utility.set_location(g_db_trigger,110);

140: hr_utility.trace('>>>new employee number = '||:NEW.employee_number);
141:
142: -- method is already Automatic and employee number is out of sync ...
143:
144: hr_utility.set_location(g_db_trigger,110);
145:
146: RAISE e_NumOutSync;
147: end if; -- next value check
148: end if; -- method check

Line 159: hr_utility.set_location(g_db_trigger,121);

155: (updating and :OLD.person_type_id <> :NEW.person_type_id)
156: )
157: AND not person_exists(:NEW.person_id, 'APL')
158: THEN
159: hr_utility.set_location(g_db_trigger,121);
160: hr_utility.trace('>>> method found : '||l_apl_method);
161:
162: if l_apl_method = 'A' then
163:

Line 160: hr_utility.trace('>>> method found : '||l_apl_method);

156: )
157: AND not person_exists(:NEW.person_id, 'APL')
158: THEN
159: hr_utility.set_location(g_db_trigger,121);
160: hr_utility.trace('>>> method found : '||l_apl_method);
161:
162: if l_apl_method = 'A' then
163:
164: hr_utility.set_location(g_db_trigger,125);

Line 164: hr_utility.set_location(g_db_trigger,125);

160: hr_utility.trace('>>> method found : '||l_apl_method);
161:
162: if l_apl_method = 'A' then
163:
164: hr_utility.set_location(g_db_trigger,125);
165: l_next_value := get_next_value(:NEW.business_group_id,'APL');
166: if l_next_value < 0 then -- global sequence has been used
167: hr_utility.set_location('Leaving:'||g_db_trigger,998);
168: return;

Line 167: hr_utility.set_location('Leaving:'||g_db_trigger,998);

163:
164: hr_utility.set_location(g_db_trigger,125);
165: l_next_value := get_next_value(:NEW.business_group_id,'APL');
166: if l_next_value < 0 then -- global sequence has been used
167: hr_utility.set_location('Leaving:'||g_db_trigger,998);
168: return;
169: elsif l_next_value <> (to_number(:NEW.applicant_number) + 1) then
170:
171: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));

Line 171: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));

167: hr_utility.set_location('Leaving:'||g_db_trigger,998);
168: return;
169: elsif l_next_value <> (to_number(:NEW.applicant_number) + 1) then
170:
171: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
172: hr_utility.trace('>>>new applicant number = '||:NEW.applicant_number);
173:
174: -- method is already Automatic and employee number is out of sync ...
175:

Line 172: hr_utility.trace('>>>new applicant number = '||:NEW.applicant_number);

168: return;
169: elsif l_next_value <> (to_number(:NEW.applicant_number) + 1) then
170:
171: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
172: hr_utility.trace('>>>new applicant number = '||:NEW.applicant_number);
173:
174: -- method is already Automatic and employee number is out of sync ...
175:
176: hr_utility.set_location(g_db_trigger,127);

Line 176: hr_utility.set_location(g_db_trigger,127);

172: hr_utility.trace('>>>new applicant number = '||:NEW.applicant_number);
173:
174: -- method is already Automatic and employee number is out of sync ...
175:
176: hr_utility.set_location(g_db_trigger,127);
177:
178: RAISE e_NumOutSync;
179: end if; -- next value check
180: end if; -- method check

Line 191: hr_utility.set_location(g_db_trigger,131);

187: (updating and :OLD.person_type_id <> :NEW.person_type_id)
188: )
189: AND not person_exists(:NEW.person_id, 'CWK')
190: THEN
191: hr_utility.set_location(g_db_trigger,131);
192: hr_utility.trace('>>> method found : '||l_cwk_method);
193:
194: if l_cwk_method = 'A' then
195:

Line 192: hr_utility.trace('>>> method found : '||l_cwk_method);

188: )
189: AND not person_exists(:NEW.person_id, 'CWK')
190: THEN
191: hr_utility.set_location(g_db_trigger,131);
192: hr_utility.trace('>>> method found : '||l_cwk_method);
193:
194: if l_cwk_method = 'A' then
195:
196: hr_utility.set_location(g_db_trigger,135);

Line 196: hr_utility.set_location(g_db_trigger,135);

192: hr_utility.trace('>>> method found : '||l_cwk_method);
193:
194: if l_cwk_method = 'A' then
195:
196: hr_utility.set_location(g_db_trigger,135);
197: l_next_value := get_next_value(:NEW.business_group_id,'CWK');
198: if l_next_value < 0 then
199: hr_utility.set_location('Leaving:'||g_db_trigger,999);
200: return;

Line 199: hr_utility.set_location('Leaving:'||g_db_trigger,999);

195:
196: hr_utility.set_location(g_db_trigger,135);
197: l_next_value := get_next_value(:NEW.business_group_id,'CWK');
198: if l_next_value < 0 then
199: hr_utility.set_location('Leaving:'||g_db_trigger,999);
200: return;
201: elsif l_next_value <> (to_number(:NEW.npw_number) + 1) then
202: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
203: hr_utility.trace('>>>new CWK number = '||:NEW.npw_number);

Line 202: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));

198: if l_next_value < 0 then
199: hr_utility.set_location('Leaving:'||g_db_trigger,999);
200: return;
201: elsif l_next_value <> (to_number(:NEW.npw_number) + 1) then
202: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
203: hr_utility.trace('>>>new CWK number = '||:NEW.npw_number);
204:
205: -- method is already Automatic and employee number is out of sync ...
206: hr_utility.set_location(g_db_trigger,137);

Line 203: hr_utility.trace('>>>new CWK number = '||:NEW.npw_number);

199: hr_utility.set_location('Leaving:'||g_db_trigger,999);
200: return;
201: elsif l_next_value <> (to_number(:NEW.npw_number) + 1) then
202: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
203: hr_utility.trace('>>>new CWK number = '||:NEW.npw_number);
204:
205: -- method is already Automatic and employee number is out of sync ...
206: hr_utility.set_location(g_db_trigger,137);
207:

Line 206: hr_utility.set_location(g_db_trigger,137);

202: hr_utility.trace('>>> l_next_value = '||to_char(l_next_value));
203: hr_utility.trace('>>>new CWK number = '||:NEW.npw_number);
204:
205: -- method is already Automatic and employee number is out of sync ...
206: hr_utility.set_location(g_db_trigger,137);
207:
208: RAISE e_NumOutSync;
209: end if; -- next value check
210: end if; -- method check

Line 213: hr_utility.set_location('Leaving:'||g_db_trigger,140);

209: end if; -- next value check
210: end if; -- method check
211: END IF;
212:
213: hr_utility.set_location('Leaving:'||g_db_trigger,140);
214: END IF; --6365083
215: EXCEPTION
216: when VALUE_ERROR then
217: -- error converting the employee number to numeric

Line 220: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');

216: when VALUE_ERROR then
217: -- error converting the employee number to numeric
218: -- raise error since it is already different from "sequence"
219:
220: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');
221: hr_utility.raise_error;
222:
223: when e_NumOutSync then
224: --

Line 221: hr_utility.raise_error;

217: -- error converting the employee number to numeric
218: -- raise error since it is already different from "sequence"
219:
220: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');
221: hr_utility.raise_error;
222:
223: when e_NumOutSync then
224: --
225: -- number does not match "sequence"

Line 227: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');

223: when e_NumOutSync then
224: --
225: -- number does not match "sequence"
226: --
227: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');
228: hr_utility.raise_error;
229:
230: when OTHERS then
231: -- error: abnormal condition

Line 228: hr_utility.raise_error;

224: --
225: -- number does not match "sequence"
226: --
227: hr_utility.set_message(800,'PER_289850_NUM_OUT_OF_SYNC');
228: hr_utility.raise_error;
229:
230: when OTHERS then
231: -- error: abnormal condition
232: