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

Line 99: Name : HR_UTILITY_TRACE

95: g_custom_context pay_action_information.action_information_category%type;
96:
97:
98: /****************************************************************************
99: Name : HR_UTILITY_TRACE
100: Description : This procedure prints debug messages during diagnostics mode.
101: *****************************************************************************/
102:
103: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS

Line 103: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS

99: Name : HR_UTILITY_TRACE
100: Description : This procedure prints debug messages during diagnostics mode.
101: *****************************************************************************/
102:
103: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS
104: BEGIN
105: IF g_debug THEN
106: hr_utility.trace(trc_data);
107: END IF;

Line 106: hr_utility.trace(trc_data);

102:
103: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS
104: BEGIN
105: IF g_debug THEN
106: hr_utility.trace(trc_data);
107: END IF;
108: END HR_UTILITY_TRACE;
109:
110:

Line 108: END HR_UTILITY_TRACE;

104: BEGIN
105: IF g_debug THEN
106: hr_utility.trace(trc_data);
107: END IF;
108: END HR_UTILITY_TRACE;
109:
110:
111: /****************************************************************************
112: Name : PRINT_BLOB

Line 137: hr_utility_trace ('Entering '||l_proc_name);

133: l_data pay_action_information.action_information1%type;
134:
135: BEGIN
136: l_proc_name := g_proc_name || 'LOAD_XML_INTERNAL';
137: hr_utility_trace ('Entering '||l_proc_name);
138:
139: IF p_node_type = 'CS' THEN
140: load_xml ('<'||p_node||'>');
141: ELSIF p_node_type = 'CE' THEN

Line 153: hr_utility_trace ('Leaving '||l_proc_name);

149: l_data := REPLACE (l_data, '"', '"');
150: load_xml ('<'||p_node||'>'||l_data||'');
151: END IF;
152:
153: hr_utility_trace ('Leaving '||l_proc_name);
154: END LOAD_XML_INTERNAL;
155:
156:
157: /****************************************************************************

Line 223: hr_utility_trace ('Entering '||l_proc_name);

219: l_data pay_action_information.action_information1%type;
220:
221: BEGIN
222: l_proc_name := g_proc_name || 'LOAD_XML';
223: hr_utility_trace ('Entering '||l_proc_name);
224:
225: IF p_node_type = 'D' THEN
226:
227: /* Fetch segment names */

Line 254: hr_utility_trace ('Leaving '||l_proc_name);

250:
251: l_data := nvl(l_chk_no, p_data);
252: load_xml_internal (p_node_type, l_tag_name, l_data);
253:
254: hr_utility_trace ('Leaving '||l_proc_name);
255: END LOAD_XML;
256:
257:
258: /****************************************************************************

Line 277: hr_utility_trace ('Entering '||l_proc_name);

273: l_proc_name varchar2(100);
274:
275: BEGIN
276: l_proc_name := g_proc_name || 'LOAD_XML-4';
277: hr_utility_trace ('Entering '||l_proc_name);
278:
279: load_xml(p_node_type => p_node_type,
280: p_flexfield_name => 'Action Information DF',
281: p_context_code => p_context_code,

Line 285: hr_utility_trace ('Leaving '||l_proc_name);

281: p_context_code => p_context_code,
282: p_node => p_node,
283: p_data => p_data);
284:
285: hr_utility_trace ('Leaving '||l_proc_name);
286:
287: END LOAD_XML;
288:
289: /****************************************************************************

Line 316: hr_utility_trace ('Entering '||l_proc_name);

312: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;
313:
314: BEGIN
315: l_proc_name := g_proc_name || 'LOAD_XML-2';
316: hr_utility_trace ('Entering '||l_proc_name);
317:
318: IF p_node_type = 'D' THEN
319: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||
320: '_BANK_DETAILS');

Line 336: hr_utility_trace ('Leaving '||l_proc_name);

332: END IF;
333:
334: load_xml_internal (p_node_type, l_tag_name, p_data);
335:
336: hr_utility_trace ('Leaving '||l_proc_name);
337: END LOAD_XML;
338:
339: /****************************************************************************
340: Name : LOAD_XML

Line 355: hr_utility_trace ('Entering '||l_proc_name);

351: l_proc_name varchar2(100);
352:
353: BEGIN
354: l_proc_name := g_proc_name || 'LOAD_XML-3';
355: hr_utility_trace ('Entering '||l_proc_name);
356:
357: g_xml_table (g_xml_table.count() + 1) := p_xml;
358:
359: hr_utility_trace ('Leaving '||l_proc_name);

Line 359: hr_utility_trace ('Leaving '||l_proc_name);

355: hr_utility_trace ('Entering '||l_proc_name);
356:
357: g_xml_table (g_xml_table.count() + 1) := p_xml;
358:
359: hr_utility_trace ('Leaving '||l_proc_name);
360: END;
361:
362: /****************************************************************************
363: Name : LOAD_XML_DATA

Line 379: hr_utility_trace ('Entering '||l_proc_name);

375: ) AS
376: l_proc_name varchar2(100);
377: BEGIN
378: l_proc_name := g_proc_name || 'LOAD_XML_DATA';
379: hr_utility_trace ('Entering '||l_proc_name);
380:
381: load_xml_internal (p_node_type,
382: p_node,
383: p_data);

Line 385: hr_utility_trace ('Leaving '||l_proc_name);

381: load_xml_internal (p_node_type,
382: p_node,
383: p_data);
384:
385: hr_utility_trace ('Leaving '||l_proc_name);
386: END LOAD_XML_DATA;
387:
388: /****************************************************************************
389: Name : FLEX_SEG_ENABLED

Line 414: hr_utility_trace ('Entering '||l_proc_name);

410: l_exists varchar2(1);
411:
412: BEGIN
413: l_proc_name := g_proc_name || 'FLEX_SEG_ENABLED';
414: hr_utility_trace ('Entering '||l_proc_name);
415:
416: OPEN csr_seg_enabled;
417: FETCH csr_seg_enabled INTO l_exists;
418: CLOSE csr_seg_enabled;

Line 420: hr_utility_trace ('Leaving '||l_proc_name);

416: OPEN csr_seg_enabled;
417: FETCH csr_seg_enabled INTO l_exists;
418: CLOSE csr_seg_enabled;
419:
420: hr_utility_trace ('Leaving '||l_proc_name);
421:
422: IF l_exists = 'Y' THEN
423: RETURN (TRUE);
424: ELSE

Line 445: hr_utility_trace ('Entering '||l_proc_name);

441: ) AS
442: l_proc_name varchar2(100);
443: BEGIN
444: l_proc_name := g_proc_name || 'BUILD_SQL';
445: hr_utility_trace ('Entering '||l_proc_name);
446: p_sqlstr_tab(p_cntr) := p_string;
447: p_cntr := p_cntr + 1;
448: hr_utility_trace ('Leaving '||l_proc_name);
449: END;

Line 448: hr_utility_trace ('Leaving '||l_proc_name);

444: l_proc_name := g_proc_name || 'BUILD_SQL';
445: hr_utility_trace ('Entering '||l_proc_name);
446: p_sqlstr_tab(p_cntr) := p_string;
447: p_cntr := p_cntr + 1;
448: hr_utility_trace ('Leaving '||l_proc_name);
449: END;
450:
451:
452: /****************************************************************************

Line 543: hr_utility_trace ('Entering '||l_proc_name);

539: ln_amt number;
540:
541: BEGIN
542: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
543: hr_utility_trace ('Entering '||l_proc_name);
544: hr_utility_trace ('Parameters ....');
545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN

Line 544: hr_utility_trace ('Parameters ....');

540:
541: BEGIN
542: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
543: hr_utility_trace ('Entering '||l_proc_name);
544: hr_utility_trace ('Parameters ....');
545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN
548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');

Line 545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);

541: BEGIN
542: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
543: hr_utility_trace ('Entering '||l_proc_name);
544: hr_utility_trace ('Parameters ....');
545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN
548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
549: ELSE

Line 546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);

542: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
543: hr_utility_trace ('Entering '||l_proc_name);
544: hr_utility_trace ('Parameters ....');
545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN
548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
549: ELSE
550: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');

Line 548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');

544: hr_utility_trace ('Parameters ....');
545: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN
548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
549: ELSE
550: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
551: END IF;
552: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);

Line 550: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');

546: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
547: IF p_generate_header_flag THEN
548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
549: ELSE
550: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
551: END IF;
552: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
553:
554: g_xml_table.delete();

Line 552: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);

548: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
549: ELSE
550: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
551: END IF;
552: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
553:
554: g_xml_table.delete();
555: l_flex_col_num := 30;
556: l_kff_seg_start := 5;

Line 870: hr_utility_trace(sqlstr(cntr));

866: l_cntr_sql,
867: 'end;');
868:
869: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
870: hr_utility_trace(sqlstr(cntr));
871: END LOOP;
872:
873: csr := dbms_sql.open_cursor;
874: dbms_sql.parse (csr,

Line 899: hr_utility_trace (g_xml_table(cntr));

895: dbms_lob.writeAppend(l_xml,
896: ln_amt,
897: lr_xml);
898:
899: hr_utility_trace (g_xml_table(cntr));
900: END LOOP;
901: p_xml := l_xml;
902: dbms_lob.freeTemporary(l_xml);
903: END IF;

Line 911: hr_utility_trace ('Leaving '||l_proc_name);

907: -- Unset globals before exit;
908: g_xml_table.delete();
909: g_custom_context := NULL;
910:
911: hr_utility_trace ('Leaving '||l_proc_name);
912: END GENERATE_INTERNAL;
913:
914:
915: /****************************************************************************

Line 938: hr_utility_trace ('Entering '||l_proc_name);

934: l_proc_name varchar2(100);
935: lb_header_flag boolean;
936: BEGIN
937: l_proc_name := g_proc_name || 'GENERATE';
938: hr_utility_trace ('Entering '||l_proc_name);
939:
940: IF p_generate_header_flag = 'Y' THEN
941: lb_header_flag := TRUE;
942: ELSE

Line 956: hr_utility_trace ('Leaving '||l_proc_name);

952: p_root_tag,
953: p_document_type,
954: p_xml);
955:
956: hr_utility_trace ('Leaving '||l_proc_name);
957: END GENERATE;
958:
959:
960: /****************************************************************************

Line 990: hr_utility_trace ('Entering '||l_proc_name);

986: lr_buf RAW (2000);
987: l_last_param number;
988: BEGIN
989: l_proc_name := g_proc_name || 'GENERATE-2';
990: hr_utility_trace ('Entering '||l_proc_name);
991: hr_utility_trace ('Total action_information_IDs = '||
992: p_action_inf_id_tab.count());
993:
994: IF p_action_inf_id_tab.count() > 0 THEN

Line 991: hr_utility_trace ('Total action_information_IDs = '||

987: l_last_param number;
988: BEGIN
989: l_proc_name := g_proc_name || 'GENERATE-2';
990: hr_utility_trace ('Entering '||l_proc_name);
991: hr_utility_trace ('Total action_information_IDs = '||
992: p_action_inf_id_tab.count());
993:
994: IF p_action_inf_id_tab.count() > 0 THEN
995: FOR cntr_arch_rec IN

Line 998: hr_utility_trace(p_action_inf_id_tab (cntr_arch_rec));

994: IF p_action_inf_id_tab.count() > 0 THEN
995: FOR cntr_arch_rec IN
996: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
997: LOOP
998: hr_utility_trace(p_action_inf_id_tab (cntr_arch_rec));
999: END LOOP;
1000: END IF;
1001:
1002: IF p_action_inf_id_tab.count() > 0 THEN

Line 1045: hr_utility_trace ('Leaving '||l_proc_name);

1041: p_xml := l_xml;
1042: dbms_lob.freeTemporary(l_xml);
1043: END IF;
1044:
1045: hr_utility_trace ('Leaving '||l_proc_name);
1046:
1047: -- Bug 6068599
1048: EXCEPTION
1049: WHEN OTHERS THEN

Line 1053: hr_utility_trace (sqlerrm);

1049: WHEN OTHERS THEN
1050: /* Remove the parameter 'action_information_id' in case of error. */
1051: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1052: pay_payroll_xml_extract_pkg.g_custom_params.last());
1053: hr_utility_trace (sqlerrm);
1054: RAISE;
1055: END;
1056:
1057: BEGIN

Line 1058: --hr_utility.trace_on (null, 'MX_IDC');

1054: RAISE;
1055: END;
1056:
1057: BEGIN
1058: --hr_utility.trace_on (null, 'MX_IDC');
1059: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1060: g_debug := hr_utility.debug_enabled;
1061: END PAY_PAYROLL_XML_EXTRACT_PKG;

Line 1060: g_debug := hr_utility.debug_enabled;

1056:
1057: BEGIN
1058: --hr_utility.trace_on (null, 'MX_IDC');
1059: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1060: g_debug := hr_utility.debug_enabled;
1061: END PAY_PAYROLL_XML_EXTRACT_PKG;