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

Line 40: g_debug := hr_utility.debug_enabled;

36: l_procedure VARCHAR2(50);
37: l_message VARCHAR2(300);
38: --
39: BEGIN
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package||'get_max_act_sequence';
42: --
43: set_location(g_debug, 'Entered '|| l_procedure,10);
44: trace('Assignment ID ',p_assignment_id );

Line 90: hr_utility.set_location(SUBSTR('INLOG: '||p_message,1,72), p_step);

86: )
87: IS
88: BEGIN
89: IF p_trace THEN
90: hr_utility.set_location(SUBSTR('INLOG: '||p_message,1,72), p_step);
91: END IF;
92:
93: END set_location;
94:

Line 111: hr_utility.trace(RPAD(SUBSTR('INTRC: '||p_message,1,60),60,' ')||': '||p_value);

107: PROCEDURE trace (p_message IN VARCHAR2
108: ,p_value IN VARCHAR2)
109: IS
110: BEGIN
111: hr_utility.trace(RPAD(SUBSTR('INTRC: '||p_message,1,60),60,' ')||': '||p_value);
112: END trace;
113:
114: --------------------------------------------------------------------------
115: -- --

Line 178: g_debug := hr_utility.debug_enabled;

174: l_colon_position NUMBER;
175: l_proc VARCHAR2(50);
176: --
177: BEGIN
178: g_debug := hr_utility.debug_enabled;
179: l_proc := g_package||'get_pay_message';
180: --
181: set_location(g_debug, 'Entered '||l_proc,5);
182: set_location(g_debug, '. Message Name: '||p_message_name,40);

Line 184: hr_utility.set_message(800,p_message_name);

180: --
181: set_location(g_debug, 'Entered '||l_proc,5);
182: set_location(g_debug, '. Message Name: '||p_message_name,40);
183:
184: hr_utility.set_message(800,p_message_name);
185:
186: IF p_token1 IS NOT NULL THEN
187: /* Obtain token 1 name and value */
188: l_colon_position := INSTR(p_token1,':');

Line 191: hr_utility.set_message_token(l_token_name,l_token_value);

187: /* Obtain token 1 name and value */
188: l_colon_position := INSTR(p_token1,':');
189: l_token_name := SUBSTR(p_token1,1,l_colon_position-1);
190: l_token_value := SUBSTR(SUBSTR(p_token1,l_colon_position+1,LENGTH(p_token1)) ,1,77);
191: hr_utility.set_message_token(l_token_name,l_token_value);
192: set_location(g_debug,'. Token1: '||l_token_name||'. Value: '||l_token_value,50);
193: END IF;
194:
195: IF p_token2 IS NOT NULL THEN

Line 200: hr_utility.set_message_token(l_token_name,l_token_value);

196: /* Obtain token 2 name and value */
197: l_colon_position := INSTR(p_token2,':');
198: l_token_name := SUBSTR(p_token2,1,l_colon_position-1);
199: l_token_value := SUBSTR(SUBSTR(p_token2,l_colon_position+1,LENGTH(p_token2)) ,1,77);
200: hr_utility.set_message_token(l_token_name,l_token_value);
201: set_location(g_debug,'. Token2: '||l_token_name||'. Value: '||l_token_value,60);
202: END IF;
203:
204: IF p_token3 IS NOT NULL THEN

Line 209: hr_utility.set_message_token(l_token_name,l_token_value);

205: /* Obtain token 3 name and value */
206: l_colon_position := INSTR(p_token3,':');
207: l_token_name := SUBSTR(p_token3,1,l_colon_position-1);
208: l_token_value := SUBSTR(SUBSTR(p_token3,l_colon_position+1,LENGTH(p_token3)) ,1,77);
209: hr_utility.set_message_token(l_token_name,l_token_value);
210: set_location(g_debug,'. Token3: '||l_token_name||'. Value: '||l_token_value,70);
211: END IF;
212:
213: IF p_token4 IS NOT NULL THEN

Line 218: hr_utility.set_message_token(l_token_name,l_token_value);

214: /* Obtain token 4 name and value */
215: l_colon_position := INSTR(p_token4,':');
216: l_token_name := SUBSTR(p_token4,1,l_colon_position-1);
217: l_token_value := SUBSTR(SUBSTR(p_token4,l_colon_position+1,LENGTH(p_token4)) ,1,77);
218: hr_utility.set_message_token(l_token_name,l_token_value);
219: set_location(g_debug,'. Token4: '||l_token_name||'. Value: '||l_token_value,80);
220: END IF;
221:
222: l_message := SUBSTRB(hr_utility.get_message,1,250);

Line 222: l_message := SUBSTRB(hr_utility.get_message,1,250);

218: hr_utility.set_message_token(l_token_name,l_token_value);
219: set_location(g_debug,'. Token4: '||l_token_name||'. Value: '||l_token_value,80);
220: END IF;
221:
222: l_message := SUBSTRB(hr_utility.get_message,1,250);
223:
224: set_location(g_debug,'leaving '||l_proc,100);
225: RETURN l_message;
226:

Line 275: hr_utility.set_message(p_application_id, p_message_name);

271: cnt NUMBER;
272: BEGIN
273: IF p_message_name IS NOT NULL AND p_message_name <> 'SUCCESS' THEN
274: cnt:= p_token_name.count;
275: hr_utility.set_message(p_application_id, p_message_name);
276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;

Line 278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));

274: cnt:= p_token_name.count;
275: hr_utility.set_message(p_application_id, p_message_name);
276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;
280: hr_utility.raise_error;
281: END IF;
282:

Line 280: hr_utility.raise_error;

276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;
280: hr_utility.raise_error;
281: END IF;
282:
283: END raise_message;
284:

Line 323: g_debug := hr_utility.debug_enabled;

319: l_value pay_user_column_instances_f.value%TYPE;
320: l_proc VARCHAR2(100);
321: BEGIN
322: l_proc := g_package||'get_user_table_value';
323: g_debug := hr_utility.debug_enabled;
324:
325: set_location(g_debug, 'Entering : '||l_proc,10);
326:
327: l_value := hruserdt.get_table_value

Line 485: g_debug := hr_utility.debug_enabled;

481: --
482: BEGIN
483: --
484: l_proc := g_package||'get_person_id';
485: g_debug := hr_utility.debug_enabled;
486: set_location(g_debug, 'Entering: ' || l_proc, 10);
487: --
488: IF g_debug THEN
489: --

Line 558: g_debug := hr_utility.debug_enabled;

554: --
555: BEGIN
556: --
557: l_proc := g_package||'.get_assignment_id';
558: g_debug := hr_utility.debug_enabled;
559: set_location(g_debug, 'Entering: ' || l_proc, 10);
560: --
561: IF g_debug THEN
562: --

Line 909: g_debug := hr_utility.debug_enabled;

905:
906: BEGIN
907:
908: l_procedure := g_package||'get_org_id';
909: g_debug := hr_utility.debug_enabled;
910:
911: set_location(g_debug,'Entering : '||l_procedure, 10);
912:
913: OPEN cur_scl_value (p_assignment_id

Line 1437: g_debug := hr_utility.debug_enabled;

1433: l_formula_id NUMBER ;
1434: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_formula_id';
1435: l_message VARCHAR2(255);
1436: BEGIN
1437: g_debug := hr_utility.debug_enabled;
1438: set_location(g_debug, 'Entering: '||l_procedure,10);
1439:
1440: SELECT formula_id
1441: INTO l_formula_id

Line 1486: g_debug := hr_utility.debug_enabled;

1482: l_element_id NUMBER ;
1483: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_element_type_id';
1484: l_message VARCHAR2(255);
1485: BEGIN
1486: g_debug := hr_utility.debug_enabled;
1487: set_location(g_debug, 'Entering: '||l_procedure,10);
1488:
1489: SELECT element_type_id
1490: INTO l_element_id

Line 1532: g_debug := hr_utility.debug_enabled;

1528: l_balance_id NUMBER ;
1529: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_balance_type_id';
1530: l_message VARCHAR2(255);
1531: BEGIN
1532: g_debug := hr_utility.debug_enabled;
1533: set_location(g_debug, 'Entering: '||l_procedure,10);
1534:
1535: SELECT balance_type_id
1536: INTO l_balance_id

Line 1590: g_debug := hr_utility.debug_enabled;

1586: l_input_value_id NUMBER ;
1587: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_input_value_id';
1588: l_message VARCHAR2(255);
1589: BEGIN
1590: g_debug := hr_utility.debug_enabled;
1591: set_location(g_debug, 'Entering: '||l_procedure,10);
1592:
1593: OPEN c_input_value_id;
1594: FETCH c_input_value_id INTO l_input_value_id;

Line 1643: g_debug := hr_utility.debug_enabled;

1639: l_input_value_id NUMBER ;
1640: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_input_value_id';
1641: l_message VARCHAR2(255);
1642: BEGIN
1643: g_debug := hr_utility.debug_enabled;
1644: set_location(g_debug, 'Entering: '||l_procedure,10);
1645:
1646: l_input_value_id := get_input_value_id
1647: (p_effective_date

Line 2615: g_debug := hr_utility.debug_enabled;

2611:
2612: l_procedure VARCHAR2(250);
2613: l_message VARCHAR2(250);
2614: BEGIN
2615: g_debug := hr_utility.debug_enabled;
2616: l_procedure := g_package ||'get_age';
2617: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2618: IF (g_debug)
2619: THEN

Line 2747: g_debug := hr_utility.debug_enabled;

2743: BEGIN
2744:
2745: l_procedure := g_package ||'UPD_PUBLIC_SECTOR_PAY_PERIODS';
2746: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
2747: g_debug := hr_utility.debug_enabled;
2748:
2749: if g_debug then
2750: hr_utility.trace('---------------------------------------');
2751: hr_utility.trace('p_payroll_id :'||p_payroll_id);

Line 2750: hr_utility.trace('---------------------------------------');

2746: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
2747: g_debug := hr_utility.debug_enabled;
2748:
2749: if g_debug then
2750: hr_utility.trace('---------------------------------------');
2751: hr_utility.trace('p_payroll_id :'||p_payroll_id);
2752: hr_utility.trace('p_offset : '||p_offset);
2753: end if ;
2754:

Line 2751: hr_utility.trace('p_payroll_id :'||p_payroll_id);

2747: g_debug := hr_utility.debug_enabled;
2748:
2749: if g_debug then
2750: hr_utility.trace('---------------------------------------');
2751: hr_utility.trace('p_payroll_id :'||p_payroll_id);
2752: hr_utility.trace('p_offset : '||p_offset);
2753: end if ;
2754:
2755:

Line 2752: hr_utility.trace('p_offset : '||p_offset);

2748:
2749: if g_debug then
2750: hr_utility.trace('---------------------------------------');
2751: hr_utility.trace('p_payroll_id :'||p_payroll_id);
2752: hr_utility.trace('p_offset : '||p_offset);
2753: end if ;
2754:
2755:
2756:

Line 2764: hr_utility.set_location('Leaving: '||l_procedure,25);

2760:
2761: if l_payroll_actions > 0 then
2762:
2763: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 20);
2764: hr_utility.set_location('Leaving: '||l_procedure,25);
2765:
2766: fnd_message.set_name('PER','PER_IN_PAYROLL_ACTIONS_EXIST');
2767: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2768: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);

Line 2769: hr_utility.raise_error;

2765:
2766: fnd_message.set_name('PER','PER_IN_PAYROLL_ACTIONS_EXIST');
2767: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2768: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2769: hr_utility.raise_error;
2770: end if;
2771:
2772: select nvl(PRL_INFORMATION1,'N'),nvl(PAY_DATE_OFFSET,0) into l_public_sector_flag,l_date_offset
2773: from pay_payrolls_f

Line 2789: hr_utility.trace('---------------------------------------');

2785: REGULAR_PAYMENT_DATE=decode(to_char(end_date,'MM'),'03',end_date + p_offset,end_date)
2786: where PAYROLL_ID=p_payroll_id;
2787:
2788: if g_debug then
2789: hr_utility.trace('---------------------------------------');
2790: hr_utility.trace('Period Definition is successfully modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2791: hr_utility.trace('with an offset '||p_offset||' for March period.');
2792: end if ;
2793:

Line 2790: hr_utility.trace('Period Definition is successfully modified for Public Sector Requirement for payroll id -'||p_payroll_id);

2786: where PAYROLL_ID=p_payroll_id;
2787:
2788: if g_debug then
2789: hr_utility.trace('---------------------------------------');
2790: hr_utility.trace('Period Definition is successfully modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2791: hr_utility.trace('with an offset '||p_offset||' for March period.');
2792: end if ;
2793:
2794: fnd_message.set_name('PER','PER_IN_PUBLIC_PAYROLL_SUCCESS');

Line 2791: hr_utility.trace('with an offset '||p_offset||' for March period.');

2787:
2788: if g_debug then
2789: hr_utility.trace('---------------------------------------');
2790: hr_utility.trace('Period Definition is successfully modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2791: hr_utility.trace('with an offset '||p_offset||' for March period.');
2792: end if ;
2793:
2794: fnd_message.set_name('PER','PER_IN_PUBLIC_PAYROLL_SUCCESS');
2795: fnd_message.set_token('PAYROLL_ID', p_payroll_id);

Line 2801: hr_utility.trace('---------------------------------------');

2797: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 40);
2798: RETURN;
2799: else
2800: if g_debug then
2801: hr_utility.trace('---------------------------------------');
2802: hr_utility.trace('Period Definition is not modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2803: hr_utility.trace('as offset is non-zero value for the payroll.');
2804: end if ;
2805:

Line 2802: hr_utility.trace('Period Definition is not modified for Public Sector Requirement for payroll id -'||p_payroll_id);

2798: RETURN;
2799: else
2800: if g_debug then
2801: hr_utility.trace('---------------------------------------');
2802: hr_utility.trace('Period Definition is not modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2803: hr_utility.trace('as offset is non-zero value for the payroll.');
2804: end if ;
2805:
2806: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 45);

Line 2803: hr_utility.trace('as offset is non-zero value for the payroll.');

2799: else
2800: if g_debug then
2801: hr_utility.trace('---------------------------------------');
2802: hr_utility.trace('Period Definition is not modified for Public Sector Requirement for payroll id -'||p_payroll_id);
2803: hr_utility.trace('as offset is non-zero value for the payroll.');
2804: end if ;
2805:
2806: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 45);
2807: fnd_message.set_name('PER','PER_IN_DISALLOW_PERIOD_MODIFY');

Line 2810: hr_utility.raise_error;

2806: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 45);
2807: fnd_message.set_name('PER','PER_IN_DISALLOW_PERIOD_MODIFY');
2808: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2809: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2810: hr_utility.raise_error;
2811: end if;
2812: else
2813: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 50);
2814:

Line 2818: hr_utility.raise_error;

2814:
2815: fnd_message.set_name('PER','PER_IN_PUBLIC_FLAG_UNSELECTED');
2816: fnd_message.set_token('PAYROLL_ID', p_payroll_id);
2817: fnd_file.put(fnd_file.log, FND_MESSAGE.GET);
2818: hr_utility.raise_error;
2819: end if;
2820:
2821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 60);
2822:

Line 2825: p_errbuf := hr_utility.get_message;

2821: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 60);
2822:
2823: EXCEPTION
2824: WHEN OTHERS THEN
2825: p_errbuf := hr_utility.get_message;
2826: p_retcode := 2;
2827: END UPD_PUBLIC_SECTOR_PAY_PERIODS;
2828:
2829: BEGIN