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

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

26: l_proc varchar2(72) := g_package||'get_business_group_id';
27: --
28: begin
29: --
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: select business_group_id
33: into p_business_group_id
34: from per_organization_structures

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

34: from per_organization_structures
35: where p_organization_structure_id = organization_structure_id;
36:
37: --
38: hr_utility.set_location(' Leaving:'|| l_proc, 20);
39: --
40: exception
41: when no_data_found then
42: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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

83: ,p_flag_name in varchar2)
84: IS
85: l_proc VARCHAR2(72) := g_package||'chk_sec_profile';
86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 10);
88: --
89: --
90: IF hr_api.not_exists_in_hrstanlookups
91: (p_effective_date => p_effective_date

Line 100: hr_utility.set_location('Leaving:'||l_proc, 30);

96: fnd_message.set_token('COLUMN',p_flag_name);
97: fnd_message.raise_error;
98: end if;
99: --
100: hr_utility.set_location('Leaving:'||l_proc, 30);
101: --
102: end chk_y_or_n;
103:
104: --

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

122: and nvl(p_org_structure_version_id,-1) <> org_structure_version_id
123: and p_organization_structure_id = organization_structure_id;
124: begin
125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: --
128: --
129: hr_api.mandatory_arg_error
130: (p_api_name => l_proc

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

133: );
134:
135: --
136: --
137: hr_utility.set_location(l_proc, 20);
138: --
139: --
140: for Crec in csr_org_version loop
141: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');

Line 141: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');

137: hr_utility.set_location(l_proc, 20);
138: --
139: --
140: for Crec in csr_org_version loop
141: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
142: hr_utility.raise_error;
143: end loop;
144: --
145: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 142: hr_utility.raise_error;

138: --
139: --
140: for Crec in csr_org_version loop
141: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
142: hr_utility.raise_error;
143: end loop;
144: --
145: hr_utility.set_location('Leaving:'||l_proc, 30);
146: --

Line 145: hr_utility.set_location('Leaving:'||l_proc, 30);

141: hr_utility.set_message(800, 'PER_7901_SYS_DUPLICATE_RECORDS');
142: hr_utility.raise_error;
143: end loop;
144: --
145: hr_utility.set_location('Leaving:'||l_proc, 30);
146: --
147: end chk_version_number;
148:
149: -- ---------------------------------------------------------------------------

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

164: where position_control_structure_flg = 'Y'
165: and p_organization_structure_id = organization_structure_id;
166: begin
167: --
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --
170: --
171: --
172: --

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

169: --
170: --
171: --
172: --
173: hr_utility.set_location(l_proc, 20);
174: --
175: --
176: for Crec in csr_parent loop
177: if p_topnode_pos_ctrl_enabled_f = 'Y'

Line 179: hr_utility.set_message(800, 'HR_6085_POS_ONE_PRIMARY');

175: --
176: for Crec in csr_parent loop
177: if p_topnode_pos_ctrl_enabled_f = 'Y'
178: and Crec.count = 0 then
179: hr_utility.set_message(800, 'HR_6085_POS_ONE_PRIMARY');
180: hr_utility.raise_error;
181: end if;
182: end loop;
183: --

Line 180: hr_utility.raise_error;

176: for Crec in csr_parent loop
177: if p_topnode_pos_ctrl_enabled_f = 'Y'
178: and Crec.count = 0 then
179: hr_utility.set_message(800, 'HR_6085_POS_ONE_PRIMARY');
180: hr_utility.raise_error;
181: end if;
182: end loop;
183: --
184: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 184: hr_utility.set_location('Leaving:'||l_proc, 30);

180: hr_utility.raise_error;
181: end if;
182: end loop;
183: --
184: hr_utility.set_location('Leaving:'||l_proc, 30);
185: --
186: end chk_top_node_pos_control;
187:
188: -- ---------------------------------------------------------------------------

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

199: -- Declare cursor
200: --
201: begin
202: --
203: hr_utility.set_location('Entering:'|| l_proc, 10);
204: --
205: --
206:
207: --

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

205: --
206:
207: --
208: --
209: hr_utility.set_location(l_proc, 20);
210: --
211: --
212: select count(*) as count
213: into l_count

Line 218: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');

214: from per_organization_structures
215: where p_organization_structure_id = organization_structure_id;
216:
217: if l_count =0 then
218: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');
219: hr_utility.raise_error;
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 219: hr_utility.raise_error;

215: where p_organization_structure_id = organization_structure_id;
216:
217: if l_count =0 then
218: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');
219: hr_utility.raise_error;
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc, 30);
223: --

Line 222: hr_utility.set_location('Leaving:'||l_proc, 30);

218: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');
219: hr_utility.raise_error;
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc, 30);
223: --
224: end chk_org_structure_id;
225:
226: -- ---------------------------------------------------------------------------

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

239: l_min_start_date DATE;
240: l_proc VARCHAR2(72) := g_package||'chk_dates';
241: begin
242: --
243: hr_utility.set_location('Entering:'|| l_proc, 10);
244: --
245: --
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc

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

250: );
251:
252: --
253: --
254: hr_utility.set_location(l_proc, 20);
255: --
256: -- Checks that date from is earlier than date to and neither
257: -- are before or after beginning/end of time
258: --

Line 263: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');

259:
260: if p_date_from > p_date_to
261: or p_date_from < hr_api.g_sot
262: or p_date_from > hr_api.g_eot then
263: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
264: hr_utility.raise_error;
265: end if;
266:
267: -- The code below checks for a gap between different versions

Line 264: hr_utility.raise_error;

260: if p_date_from > p_date_to
261: or p_date_from < hr_api.g_sot
262: or p_date_from > hr_api.g_eot then
263: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
264: hr_utility.raise_error;
265: end if;
266:
267: -- The code below checks for a gap between different versions
268: --

Line 311: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');

307: and osv.organization_structure_id = p_organization_structure_id
308: and osv.org_structure_version_id
309: <> nvl(p_org_structure_version_id,-1));
310: --
311: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
312: hr_utility.raise_error;
313: --
314: end;
315: exception

Line 312: hr_utility.raise_error;

308: and osv.org_structure_version_id
309: <> nvl(p_org_structure_version_id,-1));
310: --
311: hr_utility.set_message('801','HR_6076_PO_POS_OVERLAP');
312: hr_utility.raise_error;
313: --
314: end;
315: exception
316: when no_data_found then

Line 320: hr_utility.set_location('Leaving:'||l_proc, 30);

316: when no_data_found then
317: null;
318:
319: --
320: hr_utility.set_location('Leaving:'||l_proc, 30);
321: --
322: end chk_dates;
323: --
324: -- ---------------------------------------------------------------------------

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

344: l_proc varchar2(72) := g_package||'set_security_group_id';
345: --
346: begin
347: --
348: hr_utility.set_location('Entering:'|| l_proc, 10);
349: --
350: -- Ensure that all the mandatory parameter are not null
351: --
352: hr_api.mandatory_arg_error

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

375: hr_api.set_security_group_id
376: (p_security_group_id => l_security_group_id
377: );
378: --
379: hr_utility.set_location(' Leaving:'|| l_proc, 20);
380: --
381: end set_security_group_id;
382: --
383: -- ---------------------------------------------------------------------------

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

404: l_proc varchar2(72) := g_package||'return_legislation_code';
405: --
406: Begin
407: --
408: hr_utility.set_location('Entering:'|| l_proc, 10);
409: --
410: -- Ensure that all the mandatory parameter are not null
411: --
412: hr_api.mandatory_arg_error

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

422: -- call to this function. Just return the value in the global
423: -- variable.
424: --
425: l_legislation_code := per_osv_bus.g_legislation_code;
426: hr_utility.set_location(l_proc, 20);
427: else
428: --
429: -- The ID is different to the last call to this function
430: -- or this is the first call to this function.

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

439: close csr_leg_code;
440: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
441: fnd_message.raise_error;
442: end if;
443: hr_utility.set_location(l_proc,30);
444: --
445: -- Set the global variables so the values are
446: -- available for the next call to this function.
447: --

Line 452: hr_utility.set_location(' Leaving:'|| l_proc, 40);

448: close csr_leg_code;
449: per_osv_bus.g_org_structure_version_id := p_org_structure_version_id;
450: per_osv_bus.g_legislation_code := l_legislation_code;
451: end if;
452: hr_utility.set_location(' Leaving:'|| l_proc, 40);
453: return l_legislation_code;
454: end return_legislation_code;
455: --
456: -- ----------------------------------------------------------------------------

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

527: --
528: l_proc varchar2(72) := g_package||'insert_validate';
529: --
530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: if p_rec.business_group_id is not null then
534: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
535: end if;

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

560: p_gap_warning => p_gap_warning);
561:
562: --
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: End insert_validate;
566: --
567: -- ----------------------------------------------------------------------------
568: -- |---------------------------< update_validate >----------------------------|

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

575: --
576: l_proc varchar2(72) := g_package||'update_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: if p_rec.business_group_id is not null then
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: end if;

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

609: ,p_rec => p_rec
610: );
611: --
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End update_validate;
615: --
616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< delete_validate >----------------------------|

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

622: --
623: l_proc varchar2(72) := g_package||'delete_validate';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Call all supporting business operations
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Call all supporting business operations
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: End delete_validate;
632: --
633: end per_osv_bus;