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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pay_con_shd.api_updating
47: (p_contr_history_id => p_contr_history_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_contr_history_id;
75: -- ----------------------------------------------------------------------------
76: -- |------< valid_date_return >------|

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

100: (p_from_date in date,
101: p_to_date in date) is
102: l_proc varchar2(72) := g_package||' valid_date_return';
103: begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: if (p_from_date is null) then
106: hr_utility.set_message(801, 'HR_7575_ALL_MAN_DATE_FIELD');
107: hr_utility.raise_error;
108: end if;

Line 106: hr_utility.set_message(801, 'HR_7575_ALL_MAN_DATE_FIELD');

102: l_proc varchar2(72) := g_package||' valid_date_return';
103: begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: if (p_from_date is null) then
106: hr_utility.set_message(801, 'HR_7575_ALL_MAN_DATE_FIELD');
107: hr_utility.raise_error;
108: end if;
109: if (p_from_date > p_to_date ) then
110: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');

Line 107: hr_utility.raise_error;

103: begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: if (p_from_date is null) then
106: hr_utility.set_message(801, 'HR_7575_ALL_MAN_DATE_FIELD');
107: hr_utility.raise_error;
108: end if;
109: if (p_from_date > p_to_date ) then
110: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
111: hr_utility.raise_error;

Line 110: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');

106: hr_utility.set_message(801, 'HR_7575_ALL_MAN_DATE_FIELD');
107: hr_utility.raise_error;
108: end if;
109: if (p_from_date > p_to_date ) then
110: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
111: hr_utility.raise_error;
112: end if;
113: -- Compares if the date_from is 01/01/YYYY or not
114: if (trunc(p_from_date) <> trunc(to_date('01/01/' || to_char(trunc(p_from_date),'YYYY'),'DD/MM/YYYY' ))) then

Line 111: hr_utility.raise_error;

107: hr_utility.raise_error;
108: end if;
109: if (p_from_date > p_to_date ) then
110: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
111: hr_utility.raise_error;
112: end if;
113: -- Compares if the date_from is 01/01/YYYY or not
114: if (trunc(p_from_date) <> trunc(to_date('01/01/' || to_char(trunc(p_from_date),'YYYY'),'DD/MM/YYYY' ))) then
115: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');

Line 115: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');

111: hr_utility.raise_error;
112: end if;
113: -- Compares if the date_from is 01/01/YYYY or not
114: if (trunc(p_from_date) <> trunc(to_date('01/01/' || to_char(trunc(p_from_date),'YYYY'),'DD/MM/YYYY' ))) then
115: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
116: hr_utility.raise_error;
117: end if;
118: -- Compares if the date_to is 31/12/YYYY or not
119: if (trunc(p_to_date) <> trunc(to_date('31/12/' || to_char(trunc(p_to_date),'YYYY'),'DD/MM/YYYY' ))) then

Line 116: hr_utility.raise_error;

112: end if;
113: -- Compares if the date_from is 01/01/YYYY or not
114: if (trunc(p_from_date) <> trunc(to_date('01/01/' || to_char(trunc(p_from_date),'YYYY'),'DD/MM/YYYY' ))) then
115: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
116: hr_utility.raise_error;
117: end if;
118: -- Compares if the date_to is 31/12/YYYY or not
119: if (trunc(p_to_date) <> trunc(to_date('31/12/' || to_char(trunc(p_to_date),'YYYY'),'DD/MM/YYYY' ))) then
120: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');

Line 120: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');

116: hr_utility.raise_error;
117: end if;
118: -- Compares if the date_to is 31/12/YYYY or not
119: if (trunc(p_to_date) <> trunc(to_date('31/12/' || to_char(trunc(p_to_date),'YYYY'),'DD/MM/YYYY' ))) then
120: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
121: hr_utility.raise_error;
122: end if;
123: -- Compares if the calender year of date_From and date_to are same or not
124: if (to_number(to_char(p_from_date,'YYYY')) <>

Line 121: hr_utility.raise_error;

117: end if;
118: -- Compares if the date_to is 31/12/YYYY or not
119: if (trunc(p_to_date) <> trunc(to_date('31/12/' || to_char(trunc(p_to_date),'YYYY'),'DD/MM/YYYY' ))) then
120: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
121: hr_utility.raise_error;
122: end if;
123: -- Compares if the calender year of date_From and date_to are same or not
124: if (to_number(to_char(p_from_date,'YYYY')) <>
125: to_number(to_char(p_to_date,'YYYY'))) then

Line 126: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');

122: end if;
123: -- Compares if the calender year of date_From and date_to are same or not
124: if (to_number(to_char(p_from_date,'YYYY')) <>
125: to_number(to_char(p_to_date,'YYYY'))) then
126: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
127: hr_utility.raise_error;
128: end if;
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: end valid_date_return;

Line 127: hr_utility.raise_error;

123: -- Compares if the calender year of date_From and date_to are same or not
124: if (to_number(to_char(p_from_date,'YYYY')) <>
125: to_number(to_char(p_to_date,'YYYY'))) then
126: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
127: hr_utility.raise_error;
128: end if;
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: end valid_date_return;
131: -- ----------------------------------------------------------------------------

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

125: to_number(to_char(p_to_date,'YYYY'))) then
126: hr_utility.set_message(801, 'PAY_6807_CALEND_INVALID_DATE');
127: hr_utility.raise_error;
128: end if;
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: end valid_date_return;
131: -- ----------------------------------------------------------------------------
132: -- |------< valid_employee_return >------|
133: -- ----------------------------------------------------------------------------

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

159: p_business_group_id IN NUMBER) IS
160: l_proc VARCHAR2(72) := g_package||' valid_date_return';
161: l_count NUMBER;
162: begin
163: hr_utility.set_location('Entering:'||l_proc, 5);
164:
165: -- following SQL checks if the person of type 'EMP' was valid or not during
166: -- a particular time or not
167:

Line 181: hr_utility.set_message(801, 'HR_7149_BOOKINGS_FLAG_CHANGE');

177: and ppf.person_id = p_person_id
178: and ptype.system_person_type = 'EMP'
179: and ppf.business_group_id = p_business_group_id;
180: if (l_count = 0) then
181: hr_utility.set_message(801, 'HR_7149_BOOKINGS_FLAG_CHANGE');
182: hr_utility.set_message_token('EMP_OR_APL', 'employee');
183: hr_utility.raise_error;
184: end if;
185: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 182: hr_utility.set_message_token('EMP_OR_APL', 'employee');

178: and ptype.system_person_type = 'EMP'
179: and ppf.business_group_id = p_business_group_id;
180: if (l_count = 0) then
181: hr_utility.set_message(801, 'HR_7149_BOOKINGS_FLAG_CHANGE');
182: hr_utility.set_message_token('EMP_OR_APL', 'employee');
183: hr_utility.raise_error;
184: end if;
185: hr_utility.set_location('Leaving:'||l_proc, 10);
186: end valid_employee_return;

Line 183: hr_utility.raise_error;

179: and ppf.business_group_id = p_business_group_id;
180: if (l_count = 0) then
181: hr_utility.set_message(801, 'HR_7149_BOOKINGS_FLAG_CHANGE');
182: hr_utility.set_message_token('EMP_OR_APL', 'employee');
183: hr_utility.raise_error;
184: end if;
185: hr_utility.set_location('Leaving:'||l_proc, 10);
186: end valid_employee_return;
187: --

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

181: hr_utility.set_message(801, 'HR_7149_BOOKINGS_FLAG_CHANGE');
182: hr_utility.set_message_token('EMP_OR_APL', 'employee');
183: hr_utility.raise_error;
184: end if;
185: hr_utility.set_location('Leaving:'||l_proc, 10);
186: end valid_employee_return;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------< valid_contr_type >----------------------|

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

222: l_api_updating boolean;
223: --
224: Begin
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- hr_api.mandatory_arg_error
229: -- (p_api_name => l_proc
230: -- ,p_argument => 'contr_type'

Line 247: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');

243: p_effective_date => p_effective_date) then
244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
248: hr_utility.raise_error;
249: end if;
250: else
251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');

Line 248: hr_utility.raise_error;

244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
248: hr_utility.raise_error;
249: end if;
250: else
251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
252: hr_utility.raise_error;

Line 251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');

247: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
248: hr_utility.raise_error;
249: end if;
250: else
251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
252: hr_utility.raise_error;
253: --
254: end if;
255: hr_utility.set_location('Leaving:'||l_proc,10);

Line 252: hr_utility.raise_error;

248: hr_utility.raise_error;
249: end if;
250: else
251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
252: hr_utility.raise_error;
253: --
254: end if;
255: hr_utility.set_location('Leaving:'||l_proc,10);
256: --

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

251: hr_utility.set_message(801,'HR_7209_API_LOOK_INVALID');
252: hr_utility.raise_error;
253: --
254: end if;
255: hr_utility.set_location('Leaving:'||l_proc,10);
256: --
257: end valid_contr_type;
258:
259:

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

265: --
266: l_proc varchar2(72) := g_package||'insert_validate';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: -- Call all supporting business operations
272: --
273: chk_contr_history_id

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

291: p_lookup_code => p_rec.contr_type ,
292: p_effective_date => p_rec.date_to );
293:
294:
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End insert_validate;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |---------------------------< update_validate >----------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'update_validate';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Call all supporting business operations
309: --
310: chk_contr_history_id

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

324: p_from_date => p_rec.date_from ,
325: p_business_group_id => p_rec.business_group_id
326: );
327:
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: End update_validate;
330: --
331: -- ----------------------------------------------------------------------------
332: -- |---------------------------< delete_validate >----------------------------|

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

335: --
336: l_proc varchar2(72) := g_package||'delete_validate';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call all supporting business operations
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call all supporting business operations
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: End delete_validate;
345: --
346: --
347: -- ---------------------------------------------------------------------------

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

366: l_proc varchar2(72) := g_package||'return_legislation_code';
367: --
368: begin
369: --
370: hr_utility.set_location('Entering:'|| l_proc, 10);
371: --
372: -- Ensure that all the mandatory parameter are not null
373: --
374: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 388: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

384: close csr_leg_code;
385: --
386: -- The primary key is invalid therefore we must error
387: --
388: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
389: hr_utility.raise_error;
390: --
391: end if;
392: --

Line 389: hr_utility.raise_error;

385: --
386: -- The primary key is invalid therefore we must error
387: --
388: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
389: hr_utility.raise_error;
390: --
391: end if;
392: --
393: close csr_leg_code;

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

391: end if;
392: --
393: close csr_leg_code;
394: --
395: hr_utility.set_location(' Leaving:'|| l_proc, 20);
396: --
397: return l_legislation_code;
398: --
399: end return_legislation_code;