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

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

23: ,p_flag_name in varchar2)
24: IS
25: l_proc VARCHAR2(72) := g_package||'chk_sec_profile';
26: begin
27: hr_utility.set_location('Entering:'|| l_proc, 10);
28: --
29: --
30: IF hr_api.not_exists_in_hrstanlookups
31: (p_effective_date => p_effective_date

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

36: fnd_message.set_token('COLUMN',p_flag_name);
37: fnd_message.raise_error;
38: end if;
39: --
40: hr_utility.set_location('Leaving:'||l_proc, 30);
41: --
42: end chk_y_or_n;
43:
44: --

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

60: from per_position_structures
61: where name = p_name;
62: begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: --
67: hr_api.mandatory_arg_error
68: (p_api_name => l_proc

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

76: );
77:
78: --
79: --
80: hr_utility.set_location(l_proc, 20);
81: --
82: --
83:
84: for Crec in csr_pos_name loop

Line 87: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error

83:
84: for Crec in csr_pos_name loop
85: if Crec.position_structure_id <> nvl(p_position_structure_id,-1)
86: and Crec.business_group_id = p_business_group_id then
87: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error
88: hr_utility.raise_error;
89: end if;
90: end loop;
91: --

Line 88: hr_utility.raise_error;

84: for Crec in csr_pos_name loop
85: if Crec.position_structure_id <> nvl(p_position_structure_id,-1)
86: and Crec.business_group_id = p_business_group_id then
87: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error
88: hr_utility.raise_error;
89: end if;
90: end loop;
91: --
92: hr_utility.set_location('Leaving:'||l_proc, 30);

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

88: hr_utility.raise_error;
89: end if;
90: end loop;
91: --
92: hr_utility.set_location('Leaving:'||l_proc, 30);
93: --
94: end chk_pos_name;
95:
96: --

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

113: from per_position_structures
114: where primary_position_flag = 'Y';
115: begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: --
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc

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

129: );
130:
131: --
132: --
133: hr_utility.set_location(l_proc, 20);
134: --
135: --
136: if p_primary_position_flag = 'Y' then
137: for Crec in csr_pos_primary loop

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

136: if p_primary_position_flag = 'Y' then
137: for Crec in csr_pos_primary loop
138: if Crec.position_structure_id <> nvl(p_position_structure_id,-1)
139: and Crec.business_group_id = p_business_group_id then
140: hr_utility.set_message(800, 'HR_6085_POS_ONE_PRIMARY');
141: hr_utility.raise_error;
142: end if;
143: end loop;
144: end if;

Line 141: hr_utility.raise_error;

137: for Crec in csr_pos_primary loop
138: if Crec.position_structure_id <> nvl(p_position_structure_id,-1)
139: and Crec.business_group_id = p_business_group_id then
140: hr_utility.set_message(800, 'HR_6085_POS_ONE_PRIMARY');
141: hr_utility.raise_error;
142: end if;
143: end loop;
144: end if;
145: --

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

142: end if;
143: end loop;
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc, 30);
147: --
148: end chk_primary_flag;
149:
150: -- ---------------------------------------------------------------------------

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

157: l_proc VARCHAR2(72) := g_package||'chk_no_children';
158: l_count number(2);
159: begin
160: --
161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: --
163: --
164: hr_api.mandatory_arg_error
165: (p_api_name => l_proc

Line 174: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');

170: into l_count
171: from PER_POS_STRUCTURE_VERSIONS
172: where POSITION_STRUCTURE_ID = p_position_Structure_Id;
173: if l_count >0 then
174: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');
175: hr_utility.raise_error;
176: end if;
177:
178: --

Line 175: hr_utility.raise_error;

171: from PER_POS_STRUCTURE_VERSIONS
172: where POSITION_STRUCTURE_ID = p_position_Structure_Id;
173: if l_count >0 then
174: hr_utility.set_message('801','HR_6084_PO_POS_HAS_HIER_VER');
175: hr_utility.raise_error;
176: end if;
177:
178: --
179: hr_utility.set_location('Leaving:'||l_proc, 30);

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

175: hr_utility.raise_error;
176: end if;
177:
178: --
179: hr_utility.set_location('Leaving:'||l_proc, 30);
180: --
181: end chk_no_children;
182:
183: -- ---------------------------------------------------------------------------

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

190: l_proc VARCHAR2(72) := g_package||'chk_sec_profile';
191: l_count number(2);
192: begin
193: --
194: hr_utility.set_location('Entering:'|| l_proc, 10);
195: --
196: --
197: hr_api.mandatory_arg_error
198: (p_api_name => l_proc

Line 207: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');

203: into l_count
204: from per_security_profiles
205: where position_structure_id = p_position_structure_id;
206: if l_count >0 then
207: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
208: hr_utility.raise_error;
209: end if;
210:
211: --

Line 208: hr_utility.raise_error;

204: from per_security_profiles
205: where position_structure_id = p_position_structure_id;
206: if l_count >0 then
207: hr_utility.set_message('801','PAY_7694_PER_NO_DEL_STRUCTURE');
208: hr_utility.raise_error;
209: end if;
210:
211: --
212: hr_utility.set_location('Leaving:'||l_proc, 30);

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

208: hr_utility.raise_error;
209: end if;
210:
211: --
212: hr_utility.set_location('Leaving:'||l_proc, 30);
213: --
214: end chk_sec_profile;
215:
216: --

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

238: l_proc varchar2(72) := g_package||'set_security_group_id';
239: --
240: begin
241: --
242: hr_utility.set_location('Entering:'|| l_proc, 10);
243: --
244: -- Ensure that all the mandatory parameter are not null
245: --
246: hr_api.mandatory_arg_error

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

269: hr_api.set_security_group_id
270: (p_security_group_id => l_security_group_id
271: );
272: --
273: hr_utility.set_location(' Leaving:'|| l_proc, 20);
274: --
275: end set_security_group_id;
276: --
277: -- ---------------------------------------------------------------------------

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

298: l_proc varchar2(72) := g_package||'return_legislation_code';
299: --
300: Begin
301: --
302: hr_utility.set_location('Entering:'|| l_proc, 10);
303: --
304: -- Ensure that all the mandatory parameter are not null
305: --
306: hr_api.mandatory_arg_error

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

316: -- call to this function. Just return the value in the global
317: -- variable.
318: --
319: l_legislation_code := per_pst_bus.g_legislation_code;
320: hr_utility.set_location(l_proc, 20);
321: else
322: --
323: -- The ID is different to the last call to this function
324: -- or this is the first call to this function.

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

333: close csr_leg_code;
334: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
335: fnd_message.raise_error;
336: end if;
337: hr_utility.set_location(l_proc,30);
338: --
339: -- Set the global variables so the values are
340: -- available for the next call to this function.
341: --

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

342: close csr_leg_code;
343: per_pst_bus.g_position_structure_id := p_position_structure_id;
344: per_pst_bus.g_legislation_code := l_legislation_code;
345: end if;
346: hr_utility.set_location(' Leaving:'|| l_proc, 40);
347: return l_legislation_code;
348: end return_legislation_code;
349: --
350: -- ----------------------------------------------------------------------------

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

381: --
382: l_proc varchar2(72) := g_package || 'chk_df';
383: --
384: begin
385: hr_utility.set_location('Entering:'||l_proc,10);
386: --
387: if ((p_rec.position_structure_id is not null) and (
388: nvl(per_pst_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

480: ,p_attribute20_value => p_rec.attribute20
481: );
482: end if;
483: --
484: hr_utility.set_location(' Leaving:'||l_proc,20);
485: end chk_df;
486: --
487: -- ----------------------------------------------------------------------------
488: -- |-----------------------< chk_non_updateable_args >------------------------|

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

553: --
554: l_proc varchar2(72) := g_package||'insert_validate';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Call all supporting business operations
560: --
561:

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

580: --
581: --
582: per_pst_bus.chk_df(p_rec);
583: --
584: hr_utility.set_location(' Leaving:'||l_proc, 10);
585: End insert_validate;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< update_validate >----------------------------|

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

594: --
595: l_proc varchar2(72) := g_package||'update_validate';
596: --
597: Begin
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: --
600: -- Call all supporting business operations
601: --
602: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

624: ,p_primary_position_flag => p_rec.primary_position_flag);
625:
626: per_pst_bus.chk_df(p_rec);
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 10);
629: End update_validate;
630: --
631: -- ----------------------------------------------------------------------------
632: -- |---------------------------< delete_validate >----------------------------|

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

637: --
638: l_proc varchar2(72) := g_package||'delete_validate';
639: --
640: Begin
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: -- Call all supporting business operations
644: chk_no_children(p_position_structure_id => p_rec.position_Structure_id);
645: chk_sec_profile(p_position_structure_id => p_rec.position_Structure_id);

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

644: chk_no_children(p_position_structure_id => p_rec.position_Structure_id);
645: chk_sec_profile(p_position_structure_id => p_rec.position_Structure_id);
646:
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: End delete_validate;
650: --
651: end per_pst_bus;