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

Line 70: hr_utility.set_location('v_index '||v_index,30);

66: p_ele_start_date,
67: p_ele_end_date) LOOP
68: --
69: --
70: hr_utility.set_location('v_index '||v_index,30);
71: --
72: if v_index = 1 then
73: g_input_name_value_tab(v_index).v_element_name := v_input_name_value.element_name;
74: g_input_name_value_tab(v_index).v_classification := v_input_name_value.classification;

Line 93: hr_utility.set_location('g_input_name_value_tab(v_index) '||

89: g_input_name_value_tab(v_index).v_input_value := v_input_name_value.value;
90: --
91: END IF;
92: --
93: hr_utility.set_location('g_input_name_value_tab(v_index) '||
94: g_input_name_value_tab(v_index).v_input_name,40);
95: hr_utility.set_location('g_input_name_value_tab(v_index) '||
96: g_input_name_value_tab(v_index).v_input_value,50);
97: v_index := v_index + 1 ;

Line 95: hr_utility.set_location('g_input_name_value_tab(v_index) '||

91: END IF;
92: --
93: hr_utility.set_location('g_input_name_value_tab(v_index) '||
94: g_input_name_value_tab(v_index).v_input_name,40);
95: hr_utility.set_location('g_input_name_value_tab(v_index) '||
96: g_input_name_value_tab(v_index).v_input_value,50);
97: v_index := v_index + 1 ;
98: --
99: END LOOP;

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

130: where territory_code = nvl(p_territory_code, hr_api.return_legislation_code(p_business_group_id));
131: --
132: BEGIN
133: --
134: hr_utility.set_location('Entering:'|| l_proc, 10);
135:
136: open csr_territory;
137: fetch csr_territory into l_territory_short_name;
138: close csr_territory;

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

136: open csr_territory;
137: fetch csr_territory into l_territory_short_name;
138: close csr_territory;
139:
140: hr_utility.set_location('Leaving:'|| l_proc, 20);
141: return l_territory_short_name;
142: --
143: END decode_OPM_territory;
144: --

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

155: where currency_code = p_currency_code;
156: --
157: BEGIN
158: --
159: hr_utility.set_location('Entering:'|| l_proc, 10);
160: if p_currency_code is not null then
161:
162: open csr_currency;
163: fetch csr_currency into l_currency_name;

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

164: close csr_currency;
165:
166: end if;
167:
168: hr_utility.set_location('Leaving:'|| l_proc, 20);
169: return l_currency_name;
170: --
171: END decode_currency_code;
172: --

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

183: where event_group_id = p_event_group_id;
184: --
185: BEGIN
186: --
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: if p_event_group_id is not null then
189:
190: open csr_event_group;
191: fetch csr_event_group into l_event_group_name;

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

192: close csr_event_group;
193:
194: end if;
195:
196: hr_utility.set_location('Leaving:'|| l_proc, 20);
197: return l_event_group_name;
198: --
199: END decode_event_group;
200: --

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

213: l_proc constant varchar2(72) := g_package||'get_element_link_status';
214: --
215: BEGIN
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: l_active := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'A');
219: l_inactive := hr_bis.bis_decode_lookup( 'ACTIVE_INACTIVE', 'I');
220:
221: -- If status is null, both active and inactive records are displayed.

Line 232: hr_utility.set_location(l_proc, 15);

228:
229: if p_status is null then
230: if p_effective_date between p_link_start_date and p_link_end_date then
231: if p_effective_date between p_effective_start_date and p_effective_end_date then
232: hr_utility.set_location(l_proc, 15);
233: return 'ACTIVE';
234: else
235: hr_utility.set_location(l_proc, 20);
236: return l_inactive;

Line 235: hr_utility.set_location(l_proc, 20);

231: if p_effective_date between p_effective_start_date and p_effective_end_date then
232: hr_utility.set_location(l_proc, 15);
233: return 'ACTIVE';
234: else
235: hr_utility.set_location(l_proc, 20);
236: return l_inactive;
237: end if;
238: else
239: if p_effective_start_date = p_link_start_date then

Line 240: hr_utility.set_location(l_proc, 25);

236: return l_inactive;
237: end if;
238: else
239: if p_effective_start_date = p_link_start_date then
240: hr_utility.set_location(l_proc, 25);
241: return 'ACTIVE';
242: else
243: hr_utility.set_location(l_proc, 30);
244: return l_inactive;

Line 243: hr_utility.set_location(l_proc, 30);

239: if p_effective_start_date = p_link_start_date then
240: hr_utility.set_location(l_proc, 25);
241: return 'ACTIVE';
242: else
243: hr_utility.set_location(l_proc, 30);
244: return l_inactive;
245: end if;
246: end if;
247: elsif p_status = l_active then

Line 249: hr_utility.set_location(l_proc, 35);

245: end if;
246: end if;
247: elsif p_status = l_active then
248: if p_effective_date between p_effective_start_date and p_effective_end_date then
249: hr_utility.set_location(l_proc, 35);
250: return l_active;
251: else
252: hr_utility.set_location(l_proc, 40);
253: return l_inactive;

Line 252: hr_utility.set_location(l_proc, 40);

248: if p_effective_date between p_effective_start_date and p_effective_end_date then
249: hr_utility.set_location(l_proc, 35);
250: return l_active;
251: else
252: hr_utility.set_location(l_proc, 40);
253: return l_inactive;
254: end if;
255: elsif p_status = l_inactive then
256: if p_effective_date not between p_link_start_date and p_link_end_date then

Line 258: hr_utility.set_location(l_proc, 45);

254: end if;
255: elsif p_status = l_inactive then
256: if p_effective_date not between p_link_start_date and p_link_end_date then
257: if p_effective_start_date = p_link_start_date then
258: hr_utility.set_location(l_proc, 45);
259: return l_inactive;
260: else
261: hr_utility.set_location(l_proc, 50);
262: return l_active;

Line 261: hr_utility.set_location(l_proc, 50);

257: if p_effective_start_date = p_link_start_date then
258: hr_utility.set_location(l_proc, 45);
259: return l_inactive;
260: else
261: hr_utility.set_location(l_proc, 50);
262: return l_active;
263: end if;
264: else
265: hr_utility.set_location(l_proc, 55);

Line 265: hr_utility.set_location(l_proc, 55);

261: hr_utility.set_location(l_proc, 50);
262: return l_active;
263: end if;
264: else
265: hr_utility.set_location(l_proc, 55);
266: return l_active;
267: end if;
268: end if;
269:

Line 270: hr_utility.set_location('Leaving:'|| l_proc, 60);

266: return l_active;
267: end if;
268: end if;
269:
270: hr_utility.set_location('Leaving:'|| l_proc, 60);
271: return l_active;
272: --
273: END get_element_link_status;
274: --

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

290: and p_effective_date between pet.effective_start_date and pet.effective_end_date;
291: --
292: BEGIN
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: if p_element_type_id is not null then
296:
297: open csr_element;
298: fetch csr_element into l_element_name;

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

299: close csr_element;
300:
301: end if;
302:
303: hr_utility.set_location('Leaving:'|| l_proc, 20);
304: return l_element_name;
305: --
306: END decode_element_type;
307: --

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

380: where exa.external_account_id = p_external_account_id;
381: --
382: BEGIN
383: --
384: hr_utility.set_location('Entering:'|| l_proc, 10);
385: if p_external_account_id is not null then
386:
387: open csr_flex_num;
388: fetch csr_flex_num into l_flex_num,

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

398: l_segment21, l_segment22, l_segment23, l_segment24, l_segment25, l_segment26, l_segment27, l_segment28, l_segment29, l_segment30 );
399:
400: end if;
401:
402: hr_utility.set_location('Leaving:'|| l_proc, 20);
403: return l_concat_string;
404: --
405: END get_bank_details;
406: --

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

473: end if;
474: end desc_flex_set_column_value;
475: --
476: begin
477: hr_utility.set_location('Entering:'|| l_proc, 10);
478: if flex_type = 'DESCRIPTIVE' then
479: --
480: fnd_flex_descval.set_context_value(flex_context_or_struct);
481: desc_flex_set_column_value(column_name,1,v1,no_of_columns);

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

578: return l_concat_string;
579: --
580: end if;
581: --
582: hr_utility.set_location('Leaving:'|| l_proc, 20);
583: return null;
584: --
585: end FLEX_CONCATENATED;
586: --

Line 699: hr_utility.set_location('g_element_entry_id '||g_element_entry_id,10);

695: p_end_date date,
696: p_ele_start_date date,
697: p_ele_end_date date ) return varchar2 is
698: BEGIN
699: hr_utility.set_location('g_element_entry_id '||g_element_entry_id,10);
700: hr_utility.set_location('p_element_entry_id '||p_element_entry_id,20);
701: --
702: IF g_element_entry_id = p_element_entry_id AND
703: g_effective_start_date = p_ele_start_date AND

Line 700: hr_utility.set_location('p_element_entry_id '||p_element_entry_id,20);

696: p_ele_start_date date,
697: p_ele_end_date date ) return varchar2 is
698: BEGIN
699: hr_utility.set_location('g_element_entry_id '||g_element_entry_id,10);
700: hr_utility.set_location('p_element_entry_id '||p_element_entry_id,20);
701: --
702: IF g_element_entry_id = p_element_entry_id AND
703: g_effective_start_date = p_ele_start_date AND
704: g_effective_end_date = p_ele_end_date THEN

Line 706: hr_utility.set_location('p_element_entry_id if'||p_element_entry_id,30);

702: IF g_element_entry_id = p_element_entry_id AND
703: g_effective_start_date = p_ele_start_date AND
704: g_effective_end_date = p_ele_end_date THEN
705: NULL;
706: hr_utility.set_location('p_element_entry_id if'||p_element_entry_id,30);
707: ELSE
708: pupulate_input_name(p_element_entry_id => p_element_entry_id,
709: p_start_date => p_start_date,
710: p_end_date => p_end_date,

Line 713: hr_utility.set_location('p_element_entry_id else'||p_element_entry_id,40);

709: p_start_date => p_start_date,
710: p_end_date => p_end_date,
711: p_ele_start_date => p_ele_start_date,
712: p_ele_end_date => p_ele_end_date);
713: hr_utility.set_location('p_element_entry_id else'||p_element_entry_id,40);
714: --
715: END IF;
716: --
717: IF g_element_entry_id = p_element_entry_id AND

Line 889: hr_utility.set_location(' g_balance_name if '||g_balance_name,10);

885: (p_balance_name IS NOT NULL AND p_attribute_name IS NULL) THEN
886: --
887: --
888: IF g_balance_name = p_balance_name THEN
889: hr_utility.set_location(' g_balance_name if '||g_balance_name,10);
890: RETURN(g_balance_load_date);
891: ELSE
892: OPEN get_balance_date ;
893: FETCH get_balance_date INTO ld_balance_load_date;

Line 898: hr_utility.set_location(' g_balance_name else '||g_balance_name,20);

894: CLOSE get_balance_date;
895: --
896: g_balance_load_date := ld_balance_load_date;
897: g_balance_name := p_balance_name;
898: hr_utility.set_location(' g_balance_name else '||g_balance_name,20);
899: --
900: RETURN(ld_balance_load_date);
901: END IF;
902: --

Line 906: hr_utility.set_location(' g_attribute_name if '||g_attribute_name,30);

902: --
903: ELSIF p_balance_name IS NULL AND p_attribute_name IS NOT NULL THEN
904: --
905: IF g_attribute_name = p_attribute_name THEN
906: hr_utility.set_location(' g_attribute_name if '||g_attribute_name,30);
907: RETURN(g_balance_load_date);
908: ELSE
909: OPEN get_attribute_bal_date(p_attribute_name,p_business_group_id,p_database_item_suffix) ;
910: FETCH get_attribute_bal_date INTO ld_balance_load_date;

Line 915: hr_utility.set_location(' g_attribute_name else '||g_attribute_name,40);

911: CLOSE get_attribute_bal_date;
912: --
913: g_balance_load_date := ld_balance_load_date;
914: g_attribute_name := p_attribute_name ;
915: hr_utility.set_location(' g_attribute_name else '||g_attribute_name,40);
916: --
917: RETURN(ld_balance_load_date);
918: END IF;
919: ELSE

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

967: and p_payroll_run_date between pee.effective_start_date and pee.effective_end_date;
968: --
969: BEGIN
970: --
971: hr_utility.set_location('Entering:'|| l_proc, 10);
972: --
973: if p_element_entry_id is not null then
974: open csr_element;
975: fetch csr_element into l_element_name;

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

975: fetch csr_element into l_element_name;
976: close csr_element;
977: end if;
978: --
979: hr_utility.set_location('Leaving:'|| l_proc, 20);
980: return l_element_name;
981: --
982: END get_element_name ;
983: --