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

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

39: BEGIN
40: -- To solve gscc error
41: l_proc := c_package || 'check_expiry';
42: --
43: hr_utility.set_location('Entering : ' || l_proc, 10);
44: --
45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));

Line 45: hr_utility.trace('dimension_name : ' || p_dimension_name);

41: l_proc := c_package || 'check_expiry';
42: --
43: hr_utility.set_location('Entering : ' || l_proc, 10);
44: --
45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));

Line 46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));

42: --
43: hr_utility.set_location('Entering : ' || l_proc, 10);
44: --
45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));

Line 47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));

43: hr_utility.set_location('Entering : ' || l_proc, 10);
44: --
45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));
51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));

Line 48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));

44: --
45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));
51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
52: --

Line 49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));

45: hr_utility.trace('dimension_name : ' || p_dimension_name);
46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));
51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
52: --
53: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));

Line 50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));

46: hr_utility.trace('user_pact : ' || to_char(p_user_payroll_action_id));
47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));
51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
52: --
53: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));
54: --

Line 51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));

47: hr_utility.trace('user_assact : ' || to_char(p_user_assignment_action_id));
48: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
49: hr_utility.trace('owner_pact : ' || to_char(p_owner_payroll_action_id));
50: hr_utility.trace('owner_assact : ' || to_char(p_owner_assignment_action_id));
51: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
52: --
53: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));
54: --
55: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN

Line 56: hr_utility.trace('Date Type : EFFECTIVE_DATE');

52: --
53: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));
54: --
55: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN
56: hr_utility.trace('Date Type : EFFECTIVE_DATE');
57: --
58: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(
59: p_dimension_name,
60: p_owner_effective_date);

Line 62: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));

58: l_owner_period_end_date := hr_jprts.dimension_reset_last_date(
59: p_dimension_name,
60: p_owner_effective_date);
61: --
62: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));
63: --
64: IF p_user_effective_date > l_owner_period_end_date THEN
65: p_expiry_information := 1;
66: ELSE

Line 78: hr_utility.trace('Date Type : DATE_EARNED');

74: -- Additionally, feed info on DATE_EARNED must be exactly the same as that of EFFECTIVE_DATE
75: -- because feeding by PYUGEN checks the feed info as of EFFECTIVE_DATE, not DATE_EARNED.
76: --
77: ELSIF l_dimension_date_type = 'DATE_EARNED' THEN
78: hr_utility.trace('Date Type : DATE_EARNED');
79: --
80: select ppa_user.business_group_id,
81: ppa_user.date_earned,
82: ppa_owner.date_earned

Line 104: hr_utility.trace('user_date_earned : ' || to_char(l_user_date_earned));

100: p_dimension_name,
101: l_owner_date_earned);
102: END IF;
103: --
104: hr_utility.trace('user_date_earned : ' || to_char(l_user_date_earned));
105: hr_utility.trace('owner_date_earned : ' || to_char(l_owner_date_earned));
106: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));
107: --
108: if l_user_date_earned > l_owner_period_end_date then

Line 105: hr_utility.trace('owner_date_earned : ' || to_char(l_owner_date_earned));

101: l_owner_date_earned);
102: END IF;
103: --
104: hr_utility.trace('user_date_earned : ' || to_char(l_user_date_earned));
105: hr_utility.trace('owner_date_earned : ' || to_char(l_owner_date_earned));
106: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));
107: --
108: if l_user_date_earned > l_owner_period_end_date then
109: p_expiry_information := 1;

Line 106: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));

102: END IF;
103: --
104: hr_utility.trace('user_date_earned : ' || to_char(l_user_date_earned));
105: hr_utility.trace('owner_date_earned : ' || to_char(l_owner_date_earned));
106: hr_utility.trace('owner_period_end_date : ' || to_char(l_owner_period_end_date));
107: --
108: if l_user_date_earned > l_owner_period_end_date then
109: p_expiry_information := 1;
110: else

Line 118: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));

114: fnd_message.set_name('PAY', 'This dimension is invalid');
115: fnd_message.raise_error;
116: END IF;
117: --
118: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
119: hr_utility.set_location('Leaving : ' || l_proc, 40);
120: END check_expiry;
121: --
122: /* Balance Adjustment */

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

115: fnd_message.raise_error;
116: END IF;
117: --
118: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
119: hr_utility.set_location('Leaving : ' || l_proc, 40);
120: END check_expiry;
121: --
122: /* Balance Adjustment */
123: --

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

145: BEGIN
146: -- To solve gscc error
147: l_proc := c_package || 'check_expiry';
148: --
149: hr_utility.set_location('Entering : ' || l_proc, 10);
150: --
151: hr_utility.trace('dimension_name : ' || p_dimension_name);
152: --
153: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));

Line 151: hr_utility.trace('dimension_name : ' || p_dimension_name);

147: l_proc := c_package || 'check_expiry';
148: --
149: hr_utility.set_location('Entering : ' || l_proc, 10);
150: --
151: hr_utility.trace('dimension_name : ' || p_dimension_name);
152: --
153: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));
154: --
155: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN

Line 156: hr_utility.trace('Date Type : EFFECTIVE_DATE');

152: --
153: l_dimension_date_type := rtrim(substrb(rpad(p_dimension_name, 44), -14));
154: --
155: IF l_dimension_date_type = 'EFFECTIVE_DATE' THEN
156: hr_utility.trace('Date Type : EFFECTIVE_DATE');
157: --
158: p_expiry_information := hr_jprts.dimension_reset_last_date(
159: p_dimension_name,
160: p_owner_effective_date);

Line 168: hr_utility.trace('Date Type : DATE_EARNED');

164: -- If your business process does not guarantee DATE_EARNED to be sequential,
165: -- never use DATE_EARNED based dimensions.
166: --
167: ELSIF l_dimension_date_type = 'DATE_EARNED' THEN
168: hr_utility.trace('Date Type : DATE_EARNED');
169: --
170: open csr_business_group;
171: fetch csr_business_group into
172: l_business_group_id,

Line 193: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));

189: fnd_message.set_name('PAY', 'This dimension is invalid');
190: fnd_message.raise_error;
191: END IF;
192: --
193: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
194: hr_utility.set_location('Leaving : ' || l_proc, 20);
195: END check_expiry;
196: --
197: -- Fix bug#3083339: Added function get_element_reference to retrieve element

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

190: fnd_message.raise_error;
191: END IF;
192: --
193: hr_utility.trace('expiry_information : ' || to_char(p_expiry_information));
194: hr_utility.set_location('Leaving : ' || l_proc, 20);
195: END check_expiry;
196: --
197: -- Fix bug#3083339: Added function get_element_reference to retrieve element
198: -- level balance references reporting purposes.

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

262: begin
263: -- To solve gscc error
264: l_proc := c_package || 'date_earned_fc';
265: --
266: hr_utility.set_location('Entering : ' || l_proc, 10);
267: --
268: select pbf.scale
269: into p_feed_scale
270: from pay_balance_feeds_f pbf,

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

276: between pbf.effective_start_date and pbf.effective_end_date;
277: --
278: p_feed_flag := 1;
279: --
280: hr_utility.set_location('Leaving : ' || l_proc, 20);
281: exception
282: when no_data_found then
283: hr_utility.set_location('Leaving : ' || l_proc, 25);
284: p_feed_flag := 0;

Line 283: hr_utility.set_location('Leaving : ' || l_proc, 25);

279: --
280: hr_utility.set_location('Leaving : ' || l_proc, 20);
281: exception
282: when no_data_found then
283: hr_utility.set_location('Leaving : ' || l_proc, 25);
284: p_feed_flag := 0;
285: p_feed_scale := 0;
286: end date_earned_fc;
287: */