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

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

70: end_date
71: from per_time_periods
72: where time_period_id = p_time_period_id;
73: begin
74: hr_utility.set_location('Entering : ' || l_proc, 10);
75: --
76: -- p_upload_date must be within the payroll period specified.
77: -- Here checks whether p_upload_date is really within current payroll period.
78: --

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

88: fnd_message.raise_error;
89: end if;
90: close csr_time_period;
91: --
92: hr_utility.set_location('Leaving : ' || l_proc, 20);
93: end chk_upload_date;
94: -- ----------------------------------------------------------------------------
95: -- |----------------------< chk_date_effective_changes >----------------------|
96: -- ----------------------------------------------------------------------------

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

100: p_date_effective_changes in out nocopy varchar2)
101: is
102: l_proc varchar2(61) := c_package || 'chk_date_effective_changes';
103: begin
104: hr_utility.set_location('Entering : ' || l_proc, 10);
105: --
106: -- Date Effective Changes is available only when "Update",
107: -- not available when "Insert" and "Reject".
108: --

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

117: or ((p_reject_if_future_changes = 'Y') and (p_date_effective_changes = 'O')) then
118: p_date_effective_changes := 'U';
119: end if;
120: --
121: hr_utility.set_location('Leaving : ' || l_proc, 20);
122: end chk_date_effective_changes;
123: -- ----------------------------------------------------------------------------
124: -- |--------------------------------< get_iv >--------------------------------|
125: -- ----------------------------------------------------------------------------

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

146: and ivtl.input_value_id = iv.input_value_id
147: and ivtl.language = userenv('LANG')
148: order by iv.display_sequence;
149: begin
150: hr_utility.set_location('Entering : ' || l_proc, 10);
151: --
152: open csr_iv;
153: fetch csr_iv bulk collect into
154: p_eev_rec.name_tbl,

Line 165: hr_utility.trace('**********');

161: close csr_iv;
162: --
163: /*
164: for i in 1..p_eev_rec.entry_value_tbl.count loop
165: hr_utility.trace('**********');
166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));

Line 166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));

162: --
163: /*
164: for i in 1..p_eev_rec.entry_value_tbl.count loop
165: hr_utility.trace('**********');
166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));

Line 167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));

163: /*
164: for i in 1..p_eev_rec.entry_value_tbl.count loop
165: hr_utility.trace('**********');
166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));

Line 168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));

164: for i in 1..p_eev_rec.entry_value_tbl.count loop
165: hr_utility.trace('**********');
166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));

Line 169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));

165: hr_utility.trace('**********');
166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
173: end loop;

Line 170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));

166: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
173: end loop;
174: */

Line 171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));

167: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
173: end loop;
174: */
175: --

Line 172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));

168: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
169: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
170: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
171: -- hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
173: end loop;
174: */
175: --
176: hr_utility.set_location('Leaving : ' || l_proc, 20);

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

172: -- hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
173: end loop;
174: */
175: --
176: hr_utility.set_location('Leaving : ' || l_proc, 20);
177: end get_iv;
178: -- ----------------------------------------------------------------------------
179: -- |--------------------------------< get_ee >--------------------------------|
180: -- ----------------------------------------------------------------------------

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

324: and ivtl.input_value_id = iv.input_value_id
325: and ivtl.language = userenv('LANG')
326: order by iv.display_sequence;
327: begin
328: hr_utility.set_location('Entering : ' || l_proc, 10);
329: --
330: open csr_ee;
331: fetch csr_ee into p_ee_rec;
332: --

Line 333: hr_utility.trace('element_entry_id : ' || to_char(p_ee_rec.element_entry_id));

329: --
330: open csr_ee;
331: fetch csr_ee into p_ee_rec;
332: --
333: hr_utility.trace('element_entry_id : ' || to_char(p_ee_rec.element_entry_id));
334: hr_utility.trace('effective_start_date : ' || to_char(p_ee_rec.effective_start_date));
335: hr_utility.trace('effective_end_date : ' || to_char(p_ee_rec.effective_end_date));
336: hr_utility.trace('element_link_id : ' || to_char(p_ee_rec.element_link_id));
337: --

Line 334: hr_utility.trace('effective_start_date : ' || to_char(p_ee_rec.effective_start_date));

330: open csr_ee;
331: fetch csr_ee into p_ee_rec;
332: --
333: hr_utility.trace('element_entry_id : ' || to_char(p_ee_rec.element_entry_id));
334: hr_utility.trace('effective_start_date : ' || to_char(p_ee_rec.effective_start_date));
335: hr_utility.trace('effective_end_date : ' || to_char(p_ee_rec.effective_end_date));
336: hr_utility.trace('element_link_id : ' || to_char(p_ee_rec.element_link_id));
337: --
338: -- If element entry exists, derive element entry values

Line 335: hr_utility.trace('effective_end_date : ' || to_char(p_ee_rec.effective_end_date));

331: fetch csr_ee into p_ee_rec;
332: --
333: hr_utility.trace('element_entry_id : ' || to_char(p_ee_rec.element_entry_id));
334: hr_utility.trace('effective_start_date : ' || to_char(p_ee_rec.effective_start_date));
335: hr_utility.trace('effective_end_date : ' || to_char(p_ee_rec.effective_end_date));
336: hr_utility.trace('element_link_id : ' || to_char(p_ee_rec.element_link_id));
337: --
338: -- If element entry exists, derive element entry values
339: --

Line 336: hr_utility.trace('element_link_id : ' || to_char(p_ee_rec.element_link_id));

332: --
333: hr_utility.trace('element_entry_id : ' || to_char(p_ee_rec.element_entry_id));
334: hr_utility.trace('effective_start_date : ' || to_char(p_ee_rec.effective_start_date));
335: hr_utility.trace('effective_end_date : ' || to_char(p_ee_rec.effective_end_date));
336: hr_utility.trace('element_link_id : ' || to_char(p_ee_rec.element_link_id));
337: --
338: -- If element entry exists, derive element entry values
339: --
340: if csr_ee%FOUND then

Line 341: hr_utility.set_location(l_proc, 15);

337: --
338: -- If element entry exists, derive element entry values
339: --
340: if csr_ee%FOUND then
341: hr_utility.set_location(l_proc, 15);
342: --
343: open csr_eev;
344: fetch csr_eev bulk collect into
345: p_eev_rec.name_tbl,

Line 356: hr_utility.trace('**********');

352: close csr_eev;
353: --
354: /*
355: for i in 1..p_eev_rec.entry_value_tbl.count loop
356: hr_utility.trace('**********');
357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));

Line 357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));

353: --
354: /*
355: for i in 1..p_eev_rec.entry_value_tbl.count loop
356: hr_utility.trace('**********');
357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));

Line 358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));

354: /*
355: for i in 1..p_eev_rec.entry_value_tbl.count loop
356: hr_utility.trace('**********');
357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));

Line 359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));

355: for i in 1..p_eev_rec.entry_value_tbl.count loop
356: hr_utility.trace('**********');
357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));

Line 360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));

356: hr_utility.trace('**********');
357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
364: end loop;

Line 361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));

357: hr_utility.trace('name : ' || p_eev_rec.name_tbl(i));
358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
364: end loop;
365: */

Line 362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));

358: hr_utility.trace('mandatory_flag : ' || p_eev_rec.mandatory_flag_tbl(i));
359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
364: end loop;
365: */
366: --

Line 363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));

359: hr_utility.trace('hot_default_flag : ' || p_eev_rec.hot_default_flag_tbl(i));
360: hr_utility.trace('lookup_type : ' || p_eev_rec.lookup_type_tbl(i));
361: hr_utility.trace('default_value : ' || p_eev_rec.default_value_tbl(i));
362: hr_utility.trace('liv_default_value : ' || p_eev_rec.liv_default_value_tbl(i));
363: hr_utility.trace('entry_value : ' || p_eev_rec.entry_value_tbl(i));
364: end loop;
365: */
366: --
367: -- If element entry does not exist, derive input values definition.

Line 372: hr_utility.set_location(l_proc, 16);

368: -- Note link input value default value is not derived because element link is unknown.
369: -- It is not smart way to derive element_link_id here which should be done BEE validation process.
370: --
371: else
372: hr_utility.set_location(l_proc, 16);
373: --
374: p_ee_rec := null;
375: --
376: get_iv(

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

379: p_eev_rec => p_eev_rec);
380: end if;
381: close csr_ee;
382: --
383: hr_utility.set_location('Leaving : ' || l_proc, 20);
384: end get_ee;
385: -- ----------------------------------------------------------------------------
386: -- |-------------------------------< set_eev >--------------------------------|
387: -- ----------------------------------------------------------------------------

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

398: l_default_value pay_input_values_f.default_value%TYPE;
399: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
400: l_new_value pay_element_entry_values_f.screen_entry_value%TYPE;
401: begin
402: hr_utility.set_location('Entering : ' || l_proc, 10);
403: --
404: -- If element entry does not exist.
405: -- In this case, delete the entry from PL/SQL table for non-enterable input values.
406: --

Line 411: hr_utility.trace('Set IV' || to_char(l_index));

407: if p_ee_rec.element_entry_id is null then
408: p_is_different := true;
409: l_index := p_new_value_tbl.first;
410: while l_index is not null loop
411: hr_utility.trace('Set IV' || to_char(l_index));
412: --
413: if p_eev_rec.mandatory_flag_tbl(l_index) = 'X' then
414: hr_utility.trace('entry_value not enterable.');
415: --

Line 414: hr_utility.trace('entry_value not enterable.');

410: while l_index is not null loop
411: hr_utility.trace('Set IV' || to_char(l_index));
412: --
413: if p_eev_rec.mandatory_flag_tbl(l_index) = 'X' then
414: hr_utility.trace('entry_value not enterable.');
415: --
416: -- delete the entry from PL/SQL table.
417: --
418: p_new_value_tbl.delete(l_index);

Line 430: hr_utility.trace('Compare IV' || to_char(i));

426: --
427: else
428: p_is_different := false;
429: for i in 1..p_eev_rec.mandatory_flag_tbl.count loop
430: hr_utility.trace('Compare IV' || to_char(i));
431: --
432: -- Current entry_value is inherited in the following cases.
433: -- 1. The input value is not user enterable.
434: -- 2. The entry_value is not target to be transfered.

Line 439: hr_utility.trace('entry_value not enterable.');

435: -- Note that current value will be inherited regardless of BEE value
436: -- for non-enterable input value.
437: --
438: if p_eev_rec.mandatory_flag_tbl(i) = 'X' then
439: hr_utility.trace('entry_value not enterable.');
440: --
441: -- delete the entry from PL/SQL table.
442: -- If the entry does not exist, nothing happens.
443: --

Line 446: hr_utility.trace('entry_value not target.');

442: -- If the entry does not exist, nothing happens.
443: --
444: p_new_value_tbl.delete(i);
445: elsif not p_new_value_tbl.exists(i) then
446: hr_utility.trace('entry_value not target.');
447: p_new_value_tbl(i) := p_eev_rec.entry_value_tbl(i);
448: else
449: if p_eev_rec.hot_default_flag_tbl(i) = 'Y' then
450: l_default_value := nvl(p_eev_rec.liv_default_value_tbl(i), p_eev_rec.default_value_tbl(i));

Line 463: hr_utility.trace('IV different');

459: -- If new_value is different from current entry_value,
460: -- override it with the new_value. Or inherit the existing value.
461: --
462: if l_new_value <> l_entry_value then
463: hr_utility.trace('IV different');
464: --
465: p_is_different := true;
466: --
467: -- Set new entry value to PL/SQL table l_entry_value

Line 480: hr_utility.trace('IV same');

476: p_new_value_tbl(i) := null;
477: end if;
478: end if;
479: else
480: hr_utility.trace('IV same');
481: p_new_value_tbl(i) := p_eev_rec.entry_value_tbl(i);
482: end if;
483: end if;
484: end loop;

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

483: end if;
484: end loop;
485: end if;
486: --
487: hr_utility.set_location('Leaving : ' || l_proc, 20);
488: end set_eev;
489: -- ----------------------------------------------------------------------------
490: -- |---------------------------------< log >----------------------------------|
491: -- ----------------------------------------------------------------------------

Line 696: hr_utility.trace(rpad('value_' || to_char(p_index), 8) || ' : ' || l_value);

692: else
693: l_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(p_index), p_eev_rec.entry_value_tbl(p_index));
694: end if;
695: --
696: hr_utility.trace(rpad('value_' || to_char(p_index), 8) || ' : ' || l_value);
697: end if;
698: --
699: return l_value;
700: end decode_entry_value;

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

698: --
699: return l_value;
700: end decode_entry_value;
701: begin
702: hr_utility.set_location('Entering : ' || l_proc, 10);
703: --
704: l_value_1 := decode_entry_value(1);
705: l_value_2 := decode_entry_value(2);
706: l_value_3 := decode_entry_value(3);

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

834: p_value_15 => l_value_15,
835: p_batch_line_id => p_batch_line_id,
836: p_object_version_number => p_object_version_number);
837: --
838: hr_utility.set_location('Leaving : ' || l_proc, 20);
839: end create_batch_line;
840: --
841: end pay_jp_bee_utility_pkg;