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.HR_JP_AST_UTILITY_PKG dependencies on HR_UTILITY

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

30: from hr_assignment_sets
31: where upper(assignment_set_name) = upper(p_assignment_set_name)
32: and business_group_id = p_business_group_id;
33: begin
34: hr_utility.set_location('Entering : ' || l_proc, 10);
35: --
36: open csr_asg_set;
37: fetch csr_asg_set into l_dummy;
38: if csr_asg_set%found then

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

54: p_bus_grp => p_business_group_id,
55: p_leg_code => hr_api.return_legislation_code(p_business_group_id));
56: end if;
57: --
58: hr_utility.set_location('Leaving : ' || l_proc, 20);
59: end chk_assignment_set_name;
60: -- ----------------------------------------------------------------------------
61: -- |----------------------------< create_asg_set >----------------------------|
62: -- ----------------------------------------------------------------------------

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

70: --
71: l_rowid varchar2(18);
72: l_assignment_set_id number;
73: begin
74: hr_utility.set_location('Entering : ' || l_proc, 10);
75: --
76: chk_assignment_set_name(
77: p_assignment_set_name => p_assignment_set_name,
78: p_business_group_id => p_business_group_id);

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

88: p_payroll_id => p_payroll_id,
89: p_assignment_set_name => p_assignment_set_name,
90: p_formula_id => null);
91: --
92: hr_utility.set_location('Leaving : ' || l_proc, 20);
93: end create_asg_set;
94: -- ----------------------------------------------------------------------------
95: -- |--------------------< create_asg_set_with_request_id >--------------------|
96: -- ----------------------------------------------------------------------------

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

111: l_assignment_set_name hr_assignment_sets.assignment_set_name%type
112: := p_prefix || to_char(greatest(fnd_global.conc_request_id, 0));
113: l_counter number := 0;
114: begin
115: hr_utility.set_location('Entering : ' || l_proc, 10);
116: --
117: -- Assignment Set Name : _
118: -- If the assignment name already exists, add sequence
119: -- to above assignment set name as suffix like this.

Line 129: hr_utility.trace('Assignment Set Name : ' || p_assignment_set_name);

125: else
126: p_assignment_set_name := l_assignment_set_name || '_' || to_char(l_counter);
127: end if;
128: --
129: hr_utility.trace('Assignment Set Name : ' || p_assignment_set_name);
130: --
131: begin
132: create_asg_set(
133: p_assignment_set_name => p_assignment_set_name,

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

151: end if;
152: end;
153: end loop;
154: --
155: hr_utility.set_location('Leaving : ' || l_proc, 20);
156: end create_asg_set_with_request_id;
157: -- ----------------------------------------------------------------------------
158: -- |--------------------------< create_asg_set_amd >--------------------------|
159: -- ----------------------------------------------------------------------------

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

199: --
200: return (l_exists = 'Y');
201: end amendment_exists;
202: begin
203: hr_utility.set_location('Entering: ' || l_proc, 10);
204: --
205: -- Setup assignment set information and cache those into global variables.
206: --
207: if g_assignment_set_id is null or g_assignment_set_id <> p_assignment_set_id then

Line 208: hr_utility.trace('Caching...');

204: --
205: -- Setup assignment set information and cache those into global variables.
206: --
207: if g_assignment_set_id is null or g_assignment_set_id <> p_assignment_set_id then
208: hr_utility.trace('Caching...');
209: --
210: g_assignment_set_id := null;
211: g_formula_id := null;
212: g_amendment_type := null;

Line 242: hr_utility.trace('assignment_set_id: ' || g_assignment_set_id);

238: --
239: g_assignment_set_id := p_assignment_set_id;
240: end if;
241: --
242: hr_utility.trace('assignment_set_id: ' || g_assignment_set_id);
243: hr_utility.trace('formula_id : ' || g_formula_id);
244: hr_utility.trace('amendment_type : ' || g_amendment_type);
245: hr_utility.set_location('Leaving : ' || l_proc, 100);
246: end get_assignment_set_info;

Line 243: hr_utility.trace('formula_id : ' || g_formula_id);

239: g_assignment_set_id := p_assignment_set_id;
240: end if;
241: --
242: hr_utility.trace('assignment_set_id: ' || g_assignment_set_id);
243: hr_utility.trace('formula_id : ' || g_formula_id);
244: hr_utility.trace('amendment_type : ' || g_amendment_type);
245: hr_utility.set_location('Leaving : ' || l_proc, 100);
246: end get_assignment_set_info;
247: --

Line 244: hr_utility.trace('amendment_type : ' || g_amendment_type);

240: end if;
241: --
242: hr_utility.trace('assignment_set_id: ' || g_assignment_set_id);
243: hr_utility.trace('formula_id : ' || g_formula_id);
244: hr_utility.trace('amendment_type : ' || g_amendment_type);
245: hr_utility.set_location('Leaving : ' || l_proc, 100);
246: end get_assignment_set_info;
247: --
248: procedure get_assignment_set_info(

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

241: --
242: hr_utility.trace('assignment_set_id: ' || g_assignment_set_id);
243: hr_utility.trace('formula_id : ' || g_formula_id);
244: hr_utility.trace('amendment_type : ' || g_amendment_type);
245: hr_utility.set_location('Leaving : ' || l_proc, 100);
246: end get_assignment_set_info;
247: --
248: procedure get_assignment_set_info(
249: p_assignment_set_id in number,

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

270: l_include_or_excludes t_include_or_exclude_tbl;
271: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
272: l_include_flag varchar2(1);
273: begin
274: hr_utility.set_location('Entering: ' || l_proc, 10);
275: --
276: get_assignment_set_info(p_assignment_set_id);
277: --
278: -- include_flag = F -> Additional formula validation required.

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

279: -- include_flag = Y -> To be included. No formula validation required.
280: -- include_flag = N -> To be excluded. No formula validation required.
281: --
282: if g_amendment_type = 'N' then
283: hr_utility.set_location(l_proc, 20);
284: --
285: if g_formula_id is null then
286: l_include_flag := 'Y';
287: else

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

287: else
288: l_include_flag := 'F';
289: end if;
290: else
291: hr_utility.set_location(l_proc, 30);
292: --
293: -- Cache amendment information into PL/SQL table.
294: -- In most cases, amendment information is very few (< 100 records),
295: -- which will raise performance when cached with bulk collect.

Line 298: hr_utility.trace('Caching...');

294: -- In most cases, amendment information is very few (< 100 records),
295: -- which will raise performance when cached with bulk collect.
296: --
297: if g_include_or_excludes.count = 0 then
298: hr_utility.trace('Caching...');
299: --
300: select assignment_id,
301: include_or_exclude
302: bulk collect into

Line 314: hr_utility.set_location(l_proc, 31);

310: end loop;
311: end if;
312: --
313: if g_include_or_excludes.exists(p_assignment_id) then
314: hr_utility.set_location(l_proc, 31);
315: --
316: l_include_or_exclude := g_include_or_excludes(p_assignment_id);
317: end if;
318: --

Line 336: hr_utility.trace('include_flag: ' || l_include_flag);

332: end if;
333: end if;
334: end if;
335: --
336: hr_utility.trace('include_flag: ' || l_include_flag);
337: hr_utility.set_location('Leaving: ' || l_proc, 100);
338: --
339: return l_include_flag;
340: end amendment_validate;

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

333: end if;
334: end if;
335: --
336: hr_utility.trace('include_flag: ' || l_include_flag);
337: hr_utility.set_location('Leaving: ' || l_proc, 100);
338: --
339: return l_include_flag;
340: end amendment_validate;
341: -- ----------------------------------------------------------------------------

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

355: --
356: l_rowid rowid;
357: l_effective_date date;
358: begin
359: hr_utility.set_location('Entering : ' || l_proc, 10);
360: --
361: ff_exec.init_formula(
362: p_formula_id => p_formula_id,
363: p_effective_date => p_effective_date,

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

439: else
440: return false;
441: end if;
442: --
443: hr_utility.set_location('Leaving : ' || l_proc, 20);
444: end formula_validate;
445: -- ----------------------------------------------------------------------------
446: -- |-----------------------< assignment_set_validate >------------------------|
447: -- ----------------------------------------------------------------------------

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

454: l_proc varchar2(61) := c_package || 'assignment_set_validate';
455: l_include_flag varchar2(1);
456: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
457: begin
458: hr_utility.set_location('Entering: ' || l_proc, 10);
459: --
460: get_assignment_set_info(p_assignment_set_id);
461: --
462: -- Check the assignment is to be included/excluded.

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

463: --
464: l_include_flag := amendment_validate(p_assignment_set_id, p_assignment_id);
465: --
466: if l_include_flag = 'F' then
467: hr_utility.set_location(l_proc, 20);
468: --
469: if formula_validate(g_formula_id, p_assignment_id, p_effective_date, (p_populate_fs_flag = 'Y')) then
470: l_include_flag := 'Y';
471: else

Line 476: hr_utility.trace('include_flag: ' || l_include_flag);

472: l_include_flag := 'N';
473: end if;
474: end if;
475: --
476: hr_utility.trace('include_flag: ' || l_include_flag);
477: hr_utility.set_location('Leaving: ' || l_proc, 100);
478: --
479: return l_include_flag;
480: end assignment_set_validate;

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

473: end if;
474: end if;
475: --
476: hr_utility.trace('include_flag: ' || l_include_flag);
477: hr_utility.set_location('Leaving: ' || l_proc, 100);
478: --
479: return l_include_flag;
480: end assignment_set_validate;
481: -- ----------------------------------------------------------------------------

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

638: between per.effective_start_date and per.effective_end_date
639: order by nvl(per.order_name, per.full_name), asg3.assignment_number;
640: --
641: begin
642: hr_utility.set_location('Entering : ' || l_proc, 10);
643: --
644: -- When assignment set is not specified,
645: -- all assignments are the target.
646: --

Line 648: hr_utility.trace('csr_asg_all bulk collect');

644: -- When assignment set is not specified,
645: -- all assignments are the target.
646: --
647: if p_assignment_set_id is null then
648: hr_utility.trace('csr_asg_all bulk collect');
649: --
650: open csr_asg_all;
651: fetch csr_asg_all bulk collect into
652: p_asg_rec.assignment_id_tbl,

Line 688: hr_utility.trace('csr_asg_inc bulk collect');

684: --
685: -- When only "Include" is set as amendments (no criteria)
686: --
687: if l_include_flag = 'Y' then
688: hr_utility.trace('csr_asg_inc bulk collect');
689: --
690: open csr_asg_inc;
691: fetch csr_asg_inc bulk collect into
692: p_asg_rec.assignment_id_tbl,

Line 701: hr_utility.trace('csr_asg_exc bulk collect');

697: --
698: -- When only "Exclude" is set as amendments (no criteria)
699: --
700: else
701: hr_utility.trace('csr_asg_exc bulk collect');
702: --
703: open csr_asg_exc;
704: fetch csr_asg_exc bulk collect into
705: p_asg_rec.assignment_id_tbl,

Line 719: hr_utility.trace('csr_asg_exc for loop');

715: else
716: --
717: -- Need to validate whether each assignment should be processed or not using FastFormula.
718: --
719: hr_utility.trace('csr_asg_exc for loop');
720: --
721: for l_asg_rec in csr_asg_exc loop
722: l_process := false;
723: --

Line 728: hr_utility.trace('INC : ' || to_char(l_asg_rec.assignment_id));

724: -- When include_or_exclude is 'I'(not null),
725: -- the assignment must be processed without validating FastFormula.
726: --
727: if l_asg_rec.include_or_exclude is not null then
728: hr_utility.trace('INC : ' || to_char(l_asg_rec.assignment_id));
729: --
730: l_process := true;
731: --
732: -- Validate the assignment with FastFormula as of Upload Date.

Line 735: hr_utility.trace('FF : ' || to_char(l_asg_rec.assignment_id));

731: --
732: -- Validate the assignment with FastFormula as of Upload Date.
733: --
734: elsif formula_validate(l_formula_id, l_asg_rec.assignment_id, l_asg_rec.effective_date) then
735: hr_utility.trace('FF : ' || to_char(l_asg_rec.assignment_id));
736: --
737: l_process := true;
738: end if;
739: --

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

749: end loop;
750: end if;
751: end if;
752: --
753: hr_utility.set_location('Leaving : ' || l_proc, 20);
754: end pay_asgs;
755: --
756: end hr_jp_ast_utility_pkg;