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

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

16: balance type, as it is mandatory from R12.2.
17: Also corrected the lookup description
18:
19: */
20: /********* logging message cover for hr_utility *********/
21:
22: PROCEDURE plog ( p_message IN varchar2 ) is
23:
24: /* output a message to the process log file */

Line 26: hr_utility.trace(p_message);

22: PROCEDURE plog ( p_message IN varchar2 ) is
23:
24: /* output a message to the process log file */
25: BEGIN
26: hr_utility.trace(p_message);
27: END plog;
28:
29: PROCEDURE insert_w2_box_balances(errbuf out nocopy varchar2,
30: retcode out nocopy number,

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

94: where organization_id = cp_business_group_id;
95:
96: BEGIN
97:
98: --hr_utility.trace_on (null, 'USERRA');
99:
100: ln_step := 10;
101:
102: /* Initialize variables */

Line 115: hr_utility.trace('Rasing error for nvalid value for W2 Box Code.Please enter an alphabetic Box code.');

111:
112: lv_lookup_type := 'W2 BOX 14 USER-DEFINED';-- Creating all user defined lookup codes under 'W2 BOX 14 USER-DEFINED'
113:
114: if replace(translate(p_w2_box_code,'ABCDEFGHIJKLMNOPQRSTUVWXYZ',' '),' ') IS NOT NULL then
115: hr_utility.trace('Rasing error for nvalid value for W2 Box Code.Please enter an alphabetic Box code.');
116: raise_application_error(-20001,'Invalid value for W2 Box Code.Please enter an alphabetic Box code.');
117:
118: else
119:

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

127: --lv_lookup_code := 'A_'||replace(lv_balance,' ','_');
128: lv_live_dbi := replace(lv_balance,' ','_')||'_PER_GRE_YTD';
129: lv_archive_dbi := 'A_'||lv_live_dbi ;
130:
131: hr_utility.trace('lv_balance ='||lv_balance);
132: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
133: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
134: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
135: hr_utility.trace('Checking existence of lookup_code');

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

128: lv_live_dbi := replace(lv_balance,' ','_')||'_PER_GRE_YTD';
129: lv_archive_dbi := 'A_'||lv_live_dbi ;
130:
131: hr_utility.trace('lv_balance ='||lv_balance);
132: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
133: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
134: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
135: hr_utility.trace('Checking existence of lookup_code');
136:

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

129: lv_archive_dbi := 'A_'||lv_live_dbi ;
130:
131: hr_utility.trace('lv_balance ='||lv_balance);
132: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
133: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
134: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
135: hr_utility.trace('Checking existence of lookup_code');
136:
137:

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

130:
131: hr_utility.trace('lv_balance ='||lv_balance);
132: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
133: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
134: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
135: hr_utility.trace('Checking existence of lookup_code');
136:
137:
138: ln_step := 35;

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

131: hr_utility.trace('lv_balance ='||lv_balance);
132: hr_utility.trace('lv_lookup_code ='||lv_lookup_code);
133: hr_utility.trace('lv_live_dbi ='||lv_live_dbi);
134: hr_utility.trace('lv_archive_dbi ='||lv_archive_dbi);
135: hr_utility.trace('Checking existence of lookup_code');
136:
137:
138: ln_step := 35;
139: open c_get_business_group(p_business_group_id);

Line 144: hr_utility.raise_error;

140:
141: fetch c_get_business_group INTO lv_business_group_name;
142:
143: if c_get_business_group%NOTFOUND THEN
144: hr_utility.raise_error;
145: end if;
146: close c_get_business_group;
147:
148: ln_step := 40;

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

147:
148: ln_step := 40;
149:
150:
151: hr_utility.trace('lv_business_group_name ='||lv_business_group_name);
152:
153: If length(p_w2_box_code) = 1 then
154:
155: open c_get_lookup_code(lv_lookup_type,

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

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

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

254:
255: /************************************************************
256: ** Create Defined Balance Id
257: ************************************************************/
258: hr_utility.trace('ln_bal_type_id = '||to_char(ln_bal_type_id));
259: hr_utility.trace('lv_dimension ='||lv_dimension);
260:
261: SELECT count(0)
262: INTO ln_exists

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

255: /************************************************************
256: ** Create Defined Balance Id
257: ************************************************************/
258: hr_utility.trace('ln_bal_type_id = '||to_char(ln_bal_type_id));
259: hr_utility.trace('lv_dimension ='||lv_dimension);
260:
261: SELECT count(0)
262: INTO ln_exists
263: FROM pay_defined_balances db,

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

298:
299: /************************************************************
300: ** Create archive database item
301: ************************************************************/
302: hr_utility.trace('Checking existence of archive_dbi');
303: lv_exists := null;
304: open c_get_archive_dbi(lv_archive_dbi);
305: ln_step := 120;
306:

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

306:
307: fetch c_get_archive_dbi into lv_exists;
308: if c_get_archive_dbi%NOTFOUND then
309: ln_step := 130;
310: hr_utility.trace('Archive dbi not found');
311: py_w2_dbitems.create_eoy_archive_dbi(lv_archive_dbi);
312:
313: plog('Created Archive Database Item '||lv_archive_dbi);
314:

Line 332: hr_utility.trace('Error in createing the setup for W2 BOX '||p_w2_box_number

328: end if;--lv_lookup_type
329:
330: EXCEPTION
331: when others then
332: hr_utility.trace('Error in createing the setup for W2 BOX '||p_w2_box_number
333: ||to_char(ln_step)|| ' - '|| to_char(sqlcode));
334: raise_application_error(-20001,'Error in createing the setup for W2 BOX '||p_w2_box_number
335: ||'in step: '||to_char(ln_step)||' - '||to_char(sqlcode) || '-' || sqlerrm);
336: END; /*insert balances */