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

Line 4: /* logging message cover for hr_utility */

1: package body pay_us_userra as
2: /* $Header: pyususer.pkb 120.5 2011/05/19 05:36:02 vvijayku ship $*/
3:
4: /********* logging message cover for hr_utility *********/
5:
6: PROCEDURE plog ( p_message IN varchar2 ) is
7:
8: /* output a message to the process log file */

Line 10: hr_utility.trace(p_message);

6: PROCEDURE plog ( p_message IN varchar2 ) is
7:
8: /* output a message to the process log file */
9: BEGIN
10: hr_utility.trace(p_message);
11: END plog;
12:
13: PROCEDURE insert_userra_balances(errbuf out nocopy varchar2,
14: retcode out nocopy number,

Line 79: --hr_utility.trace_on (null, 'USERRA');

75: where organization_id = cp_business_group_id;
76:
77: BEGIN
78:
79: --hr_utility.trace_on (null, 'USERRA');
80: ln_step := 10;
81:
82:
83: /* Initialize variables */

Line 139: hr_utility.trace('lv_balance ='||lv_balance);

135: lv_bal_cat_name := 'Voluntary Deductions';
136: ln_step := 40;
137: end if;
138:
139: hr_utility.trace('lv_balance ='||lv_balance);
140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);

Line 140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);

136: ln_step := 40;
137: end if;
138:
139: hr_utility.trace('lv_balance ='||lv_balance);
140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);

Line 141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);

137: end if;
138:
139: hr_utility.trace('lv_balance ='||lv_balance);
140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));

Line 142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);

138:
139: hr_utility.trace('lv_balance ='||lv_balance);
140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));
146: hr_utility.trace('Checking existence of lookup_code');

Line 143: hr_utility.trace('lv_year ='||lv_year);

139: hr_utility.trace('lv_balance ='||lv_balance);
140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));
146: hr_utility.trace('Checking existence of lookup_code');
147:

Line 144: hr_utility.trace('lv_short_year ='||lv_short_year);

140: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));
146: hr_utility.trace('Checking existence of lookup_code');
147:
148:

Line 145: hr_utility.trace('ld_year ='||to_char(ld_year));

141: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));
146: hr_utility.trace('Checking existence of lookup_code');
147:
148:
149: ln_step := 35;

Line 146: hr_utility.trace('Checking existence of lookup_code');

142: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
143: hr_utility.trace('lv_year ='||lv_year);
144: hr_utility.trace('lv_short_year ='||lv_short_year);
145: hr_utility.trace('ld_year ='||to_char(ld_year));
146: hr_utility.trace('Checking existence of lookup_code');
147:
148:
149: ln_step := 35;
150: open c_get_business_group(p_business_group_id);

Line 155: hr_utility.raise_error;

151:
152: fetch c_get_business_group INTO lv_business_group_name;
153:
154: if c_get_business_group%NOTFOUND THEN
155: hr_utility.raise_error;
156: end if;
157: close c_get_business_group;
158:
159: ln_step := 40;

Line 162: hr_utility.trace('lv_business_group_name ='||lv_business_group_name);

158:
159: ln_step := 40;
160:
161:
162: hr_utility.trace('lv_business_group_name ='||lv_business_group_name);
163:
164: open c_get_lookup_code(lv_lookup_type,
165: lv_lookup_code,
166: ln_application_id);

Line 171: hr_utility.trace('Fetched c_get_lookup_code ');

167: ln_step := 40;
168:
169: fetch c_get_lookup_code into lv_exists;
170:
171: hr_utility.trace('Fetched c_get_lookup_code ');
172:
173: if c_get_lookup_code%NOTFOUND then
174:
175: ln_step := 50;

Line 246: hr_utility.trace('ln_bal_type_id = '||to_char(ln_bal_type_id));

242:
243: /************************************************************
244: ** Create Defined Balance Id
245: ************************************************************/
246: hr_utility.trace('ln_bal_type_id = '||to_char(ln_bal_type_id));
247: hr_utility.trace('lv_dimension ='||lv_dimension);
248:
249: SELECT count(0)
250: INTO ln_exists

Line 247: hr_utility.trace('lv_dimension ='||lv_dimension);

243: /************************************************************
244: ** Create Defined Balance Id
245: ************************************************************/
246: hr_utility.trace('ln_bal_type_id = '||to_char(ln_bal_type_id));
247: hr_utility.trace('lv_dimension ='||lv_dimension);
248:
249: SELECT count(0)
250: INTO ln_exists
251: FROM pay_defined_balances db,

Line 288: hr_utility.trace('Checking existence of archive_dbi');

284:
285: /************************************************************
286: ** Create archive database item
287: ************************************************************/
288: hr_utility.trace('Checking existence of archive_dbi');
289: lv_exists := null;
290: open c_get_archive_dbi(lv_archive_dbi);
291: ln_step := 120;
292:

Line 296: hr_utility.trace('Archive dbi not found');

292:
293: fetch c_get_archive_dbi into lv_exists;
294: if c_get_archive_dbi%NOTFOUND then
295: ln_step := 130;
296: hr_utility.trace('Archive dbi not found');
297: py_w2_dbitems.create_eoy_archive_dbi(lv_archive_dbi);
298:
299: plog('Created Archive Database Item '||lv_archive_dbi);
300:

Line 307: hr_utility.trace('Error in inserting USERRA data at step '

303: commit;
304:
305: EXCEPTION
306: when others then
307: hr_utility.trace('Error in inserting USERRA data at step '
308: ||to_char(ln_step)|| ' - '|| to_char(sqlcode));
309: raise_application_error(-20001,'Error in create USERRA data at step '
310: ||to_char(ln_step)||' - '||to_char(sqlcode) || '-' || sqlerrm);
311: END; /*insert userra balances */