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 128: Name : HR_UTILITY_TRACE

124: g_custom_context pay_action_information.action_information_category%type;
125:
126:
127: /****************************************************************************
128: Name : HR_UTILITY_TRACE
129: Description : This procedure prints debug messages during diagnostics mode.
130: *****************************************************************************/
131:
132: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS

Line 132: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS

128: Name : HR_UTILITY_TRACE
129: Description : This procedure prints debug messages during diagnostics mode.
130: *****************************************************************************/
131:
132: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS
133: BEGIN
134: IF g_debug THEN
135: hr_utility.trace(trc_data);
136: END IF;

Line 135: hr_utility.trace(trc_data);

131:
132: PROCEDURE HR_UTILITY_TRACE(trc_data varchar2) IS
133: BEGIN
134: IF g_debug THEN
135: hr_utility.trace(trc_data);
136: END IF;
137: END HR_UTILITY_TRACE;
138:
139:

Line 137: END HR_UTILITY_TRACE;

133: BEGIN
134: IF g_debug THEN
135: hr_utility.trace(trc_data);
136: END IF;
137: END HR_UTILITY_TRACE;
138:
139:
140: /****************************************************************************
141: Name : PRINT_BLOB

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

162: l_data pay_action_information.action_information1%type;
163:
164: BEGIN
165: l_proc_name := g_proc_name || 'LOAD_XML_INTERNAL';
166: hr_utility_trace ('Entering '||l_proc_name);
167:
168: IF p_node_type = 'CS' THEN
169: load_xml ('<'||p_node||'>');
170: ELSIF p_node_type = 'CE' THEN

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

179: l_data := substr (l_data, 1, 200); --Added for GRE length issue Bug 16008057
180: load_xml ('<'||p_node||'>'||l_data||'');
181: END IF;
182:
183: hr_utility_trace ('Leaving '||l_proc_name);
184: END LOAD_XML_INTERNAL;
185:
186:
187: /****************************************************************************

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

252: l_data_tag varchar2(500);
253:
254: BEGIN
255: l_proc_name := g_proc_name || 'LOAD_XML';
256: hr_utility_trace ('Entering '||l_proc_name);
257:
258: IF p_node_type = 'D' THEN
259:
260: /* Fetch segment names */

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

311: END IF;
312:
313:
314:
315: hr_utility_trace ('Leaving '||l_proc_name);
316: END LOAD_XML;
317:
318:
319: /****************************************************************************

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

334: l_proc_name varchar2(100);
335:
336: BEGIN
337: l_proc_name := g_proc_name || 'LOAD_XML-4';
338: hr_utility_trace ('Entering '||l_proc_name);
339:
340: load_xml(p_node_type => p_node_type,
341: p_flexfield_name => 'Action Information DF',
342: p_context_code => p_context_code,

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

342: p_context_code => p_context_code,
343: p_node => p_node,
344: p_data => p_data);
345:
346: hr_utility_trace ('Leaving '||l_proc_name);
347:
348: END LOAD_XML;
349:
350: /****************************************************************************

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

373: l_struct_code fnd_id_flex_structures.id_flex_structure_code%type;
374:
375: BEGIN
376: l_proc_name := g_proc_name || 'LOAD_XML-2';
377: hr_utility_trace ('Entering '||l_proc_name);
378:
379: IF p_node_type = 'D' THEN
380: OPEN csr_get_tag_name (pay_payroll_xml_extract_pkg.g_leg_code||
381: '_BANK_DETAILS');

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

393: END IF;
394:
395: load_xml_internal (p_node_type, l_tag_name, p_data);
396:
397: hr_utility_trace ('Leaving '||l_proc_name);
398: END LOAD_XML;
399:
400: /****************************************************************************
401: Name : LOAD_XML

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

412: l_proc_name varchar2(100);
413:
414: BEGIN
415: l_proc_name := g_proc_name || 'LOAD_XML-3';
416: hr_utility_trace ('Entering '||l_proc_name);
417:
418: g_xml_table (g_xml_table.count() + 1) := p_xml;
419:
420: hr_utility_trace ('Leaving '||l_proc_name);

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

416: hr_utility_trace ('Entering '||l_proc_name);
417:
418: g_xml_table (g_xml_table.count() + 1) := p_xml;
419:
420: hr_utility_trace ('Leaving '||l_proc_name);
421: END;
422:
423: /****************************************************************************
424: Name : LOAD_XML_DATA

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

436: ) AS
437: l_proc_name varchar2(100);
438: BEGIN
439: l_proc_name := g_proc_name || 'LOAD_XML_DATA';
440: hr_utility_trace ('Entering '||l_proc_name);
441:
442: load_xml_internal (p_node_type,
443: p_node,
444: p_data);

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

442: load_xml_internal (p_node_type,
443: p_node,
444: p_data);
445:
446: hr_utility_trace ('Leaving '||l_proc_name);
447: END LOAD_XML_DATA;
448:
449: /****************************************************************************
450: Name : FLEX_SEG_ENABLED

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

471: l_exists varchar2(1);
472:
473: BEGIN
474: l_proc_name := g_proc_name || 'FLEX_SEG_ENABLED';
475: hr_utility_trace ('Entering '||l_proc_name);
476:
477: OPEN csr_seg_enabled;
478: FETCH csr_seg_enabled INTO l_exists;
479: CLOSE csr_seg_enabled;

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

477: OPEN csr_seg_enabled;
478: FETCH csr_seg_enabled INTO l_exists;
479: CLOSE csr_seg_enabled;
480:
481: hr_utility_trace ('Leaving '||l_proc_name);
482:
483: IF l_exists = 'Y' THEN
484: RETURN (TRUE);
485: ELSE

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

502: ) AS
503: l_proc_name varchar2(100);
504: BEGIN
505: l_proc_name := g_proc_name || 'BUILD_SQL';
506: hr_utility_trace ('Entering '||l_proc_name);
507: p_sqlstr_tab(p_cntr) := p_string;
508: p_cntr := p_cntr + 1;
509: hr_utility_trace ('Leaving '||l_proc_name);
510: END;

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

505: l_proc_name := g_proc_name || 'BUILD_SQL';
506: hr_utility_trace ('Entering '||l_proc_name);
507: p_sqlstr_tab(p_cntr) := p_string;
508: p_cntr := p_cntr + 1;
509: hr_utility_trace ('Leaving '||l_proc_name);
510: END;
511:
512:
513: /****************************************************************************

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

610: ln_amt number;
611:
612: BEGIN
613: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
614: hr_utility_trace ('Entering '||l_proc_name);
615: hr_utility_trace ('Parameters ....');
616: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN

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

611:
612: BEGIN
613: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
614: hr_utility_trace ('Entering '||l_proc_name);
615: hr_utility_trace ('Parameters ....');
616: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN
619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');

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

612: BEGIN
613: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
614: hr_utility_trace ('Entering '||l_proc_name);
615: hr_utility_trace ('Parameters ....');
616: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN
619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
620: ELSE

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

613: l_proc_name := g_proc_name || 'GENERATE_INTERNAL';
614: hr_utility_trace ('Entering '||l_proc_name);
615: hr_utility_trace ('Parameters ....');
616: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN
619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
620: ELSE
621: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');

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

615: hr_utility_trace ('Parameters ....');
616: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN
619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
620: ELSE
621: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
622: END IF;
623: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);

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

617: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
618: IF p_generate_header_flag THEN
619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
620: ELSE
621: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
622: END IF;
623: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
624:
625:

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

619: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
620: ELSE
621: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
622: END IF;
623: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
624:
625:
626: g_xml_table.delete();
627: l_flex_col_num := 30;

Line 769: hr_utility.trace('Entering employee net pay '||g_install_leg_check);

765: IF csr_get_archived_regions_rec.action_information_category =
766: 'EMPLOYEE NET PAY DISTRIBUTION'
767: AND g_install_leg_check = 'N' THEN
768:
769: hr_utility.trace('Entering employee net pay '||g_install_leg_check);
770: build_sql(sqlstr,
771: l_cntr_sql,
772: 'csr_get_archived_info_rec.action_information4 :=
773: pay_ip_utility.get_check_number(csr_get_archived_info_rec.action_information17

Line 1087: hr_utility_trace(sqlstr(cntr));

1083: l_cntr_sql,
1084: 'end;');
1085:
1086: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
1087: hr_utility_trace(sqlstr(cntr));
1088: END LOOP;
1089:
1090: csr := dbms_sql.open_cursor;
1091: dbms_sql.parse (csr,

Line 1116: hr_utility_trace (g_xml_table(cntr));

1112: dbms_lob.writeAppend(l_xml,
1113: ln_amt,
1114: lr_xml);
1115:
1116: hr_utility_trace (g_xml_table(cntr));
1117: END LOOP;
1118: p_xml := l_xml;
1119: dbms_lob.freeTemporary(l_xml);
1120: END IF;

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

1124: -- Unset globals before exit;
1125: g_xml_table.delete();
1126: g_custom_context := NULL;
1127:
1128: hr_utility_trace ('Leaving '||l_proc_name);
1129: END GENERATE_INTERNAL;
1130:
1131:
1132: /****************************************************************************

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

1151: l_proc_name varchar2(100);
1152: lb_header_flag boolean;
1153: BEGIN
1154: l_proc_name := g_proc_name || 'GENERATE';
1155: hr_utility_trace ('Entering '||l_proc_name);
1156:
1157: IF p_generate_header_flag = 'Y' THEN
1158: lb_header_flag := TRUE;
1159: ELSE

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

1169: p_root_tag,
1170: p_document_type,
1171: p_xml);
1172:
1173: hr_utility_trace ('Leaving '||l_proc_name);
1174: END GENERATE;
1175:
1176:
1177: /****************************************************************************

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

1203: lr_buf RAW (2000);
1204: l_last_param number;
1205: BEGIN
1206: l_proc_name := g_proc_name || 'GENERATE-2';
1207: hr_utility_trace ('Entering '||l_proc_name);
1208: hr_utility_trace ('Total action_information_IDs = '||
1209: p_action_inf_id_tab.count());
1210:
1211: IF p_action_inf_id_tab.count() > 0 THEN

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

1204: l_last_param number;
1205: BEGIN
1206: l_proc_name := g_proc_name || 'GENERATE-2';
1207: hr_utility_trace ('Entering '||l_proc_name);
1208: hr_utility_trace ('Total action_information_IDs = '||
1209: p_action_inf_id_tab.count());
1210:
1211: IF p_action_inf_id_tab.count() > 0 THEN
1212: FOR cntr_arch_rec IN

Line 1215: hr_utility_trace(p_action_inf_id_tab (cntr_arch_rec));

1211: IF p_action_inf_id_tab.count() > 0 THEN
1212: FOR cntr_arch_rec IN
1213: p_action_inf_id_tab.first()..p_action_inf_id_tab.last()
1214: LOOP
1215: hr_utility_trace(p_action_inf_id_tab (cntr_arch_rec));
1216: END LOOP;
1217: END IF;
1218:
1219: IF p_action_inf_id_tab.count() > 0 THEN

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

1258: p_xml := l_xml;
1259: dbms_lob.freeTemporary(l_xml);
1260: END IF;
1261:
1262: hr_utility_trace ('Leaving '||l_proc_name);
1263:
1264: -- Bug 6068599
1265: EXCEPTION
1266: WHEN OTHERS THEN

Line 1270: hr_utility_trace (sqlerrm);

1266: WHEN OTHERS THEN
1267: /* Remove the parameter 'action_information_id' in case of error. */
1268: pay_payroll_xml_extract_pkg.g_custom_params.delete(
1269: pay_payroll_xml_extract_pkg.g_custom_params.last());
1270: hr_utility_trace (sqlerrm);
1271: RAISE;
1272: END;
1273:
1274:

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

1348: ln_amt number;
1349:
1350: BEGIN
1351: l_proc_name := g_proc_name || 'GENERATE_THIRD_PARTY';
1352: hr_utility_trace ('Entering '||l_proc_name);
1353: hr_utility_trace ('Parameters ....');
1354: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN

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

1349:
1350: BEGIN
1351: l_proc_name := g_proc_name || 'GENERATE_THIRD_PARTY';
1352: hr_utility_trace ('Entering '||l_proc_name);
1353: hr_utility_trace ('Parameters ....');
1354: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN
1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');

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

1350: BEGIN
1351: l_proc_name := g_proc_name || 'GENERATE_THIRD_PARTY';
1352: hr_utility_trace ('Entering '||l_proc_name);
1353: hr_utility_trace ('Parameters ....');
1354: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN
1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
1358: ELSE

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

1351: l_proc_name := g_proc_name || 'GENERATE_THIRD_PARTY';
1352: hr_utility_trace ('Entering '||l_proc_name);
1353: hr_utility_trace ('Parameters ....');
1354: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN
1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
1358: ELSE
1359: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');

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

1353: hr_utility_trace ('Parameters ....');
1354: hr_utility_trace ('P_ACTION_INFORMATION_ID ='||P_ACTION_INFORMATION_ID);
1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN
1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
1358: ELSE
1359: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
1360: END IF;
1361: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);

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

1355: hr_utility_trace ('P_ACTION_CONTEXT_ID ='||P_ACTION_CONTEXT_ID);
1356: IF p_generate_header_flag THEN
1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
1358: ELSE
1359: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
1360: END IF;
1361: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
1362:
1363: g_xml_table.delete();

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

1357: hr_utility_trace ('P_GENERATE_HEADER_FLAG = TRUE');
1358: ELSE
1359: hr_utility_trace ('P_GENERATE_HEADER_FLAG = FALSE');
1360: END IF;
1361: hr_utility_trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
1362:
1363: g_xml_table.delete();
1364: l_flex_col_num := 30;
1365: l_cntr_sql := 1;

Line 1386: hr_utility_trace('p_generate_header_flag is true. p_root_tag is '||p_root_tag);

1382:
1383: build_sql(sqlstr, l_cntr_sql, 'begin ');
1384:
1385: if p_generate_header_flag then
1386: hr_utility_trace('p_generate_header_flag is true. p_root_tag is '||p_root_tag);
1387: else
1388: hr_utility_trace('p_generate_header_flag is false. p_root_tag is '||p_root_tag);
1389: end if;
1390:

Line 1388: hr_utility_trace('p_generate_header_flag is false. p_root_tag is '||p_root_tag);

1384:
1385: if p_generate_header_flag then
1386: hr_utility_trace('p_generate_header_flag is true. p_root_tag is '||p_root_tag);
1387: else
1388: hr_utility_trace('p_generate_header_flag is false. p_root_tag is '||p_root_tag);
1389: end if;
1390:
1391: hr_utility_trace('l_action_information_id is '||l_action_information_id);
1392: hr_utility_trace('l_action_context_id '||l_action_context_id);

Line 1391: hr_utility_trace('l_action_information_id is '||l_action_information_id);

1387: else
1388: hr_utility_trace('p_generate_header_flag is false. p_root_tag is '||p_root_tag);
1389: end if;
1390:
1391: hr_utility_trace('l_action_information_id is '||l_action_information_id);
1392: hr_utility_trace('l_action_context_id '||l_action_context_id);
1393:
1394: IF p_generate_header_flag THEN
1395: build_sql(sqlstr,

Line 1392: hr_utility_trace('l_action_context_id '||l_action_context_id);

1388: hr_utility_trace('p_generate_header_flag is false. p_root_tag is '||p_root_tag);
1389: end if;
1390:
1391: hr_utility_trace('l_action_information_id is '||l_action_information_id);
1392: hr_utility_trace('l_action_context_id '||l_action_context_id);
1393:
1394: IF p_generate_header_flag THEN
1395: build_sql(sqlstr,
1396: l_cntr_sql,

Line 1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);

1408: OPEN get_leg_code;
1409: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
1410: CLOSE get_leg_code;
1411: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);
1414:
1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN

Line 1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);

1409: FETCH get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
1410: CLOSE get_leg_code;
1411: FOR csr_get_archived_regions_rec IN csr_get_archived_regions LOOP
1412: hr_utility_trace('csr_get_archived_regions_rec = '||csr_get_archived_regions_rec.action_information_category);
1413: hr_utility_trace('pay_payroll_xml_extract_pkg.g_leg_code = '||pay_payroll_xml_extract_pkg.g_leg_code);
1414:
1415: IF (csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHECKS' OR
1416: csr_get_archived_regions_rec.action_information_category LIKE pay_payroll_xml_extract_pkg.g_leg_code||'%THIRD PARTY CHEQUES') THEN
1417: build_sql(sqlstr,

Line 1424: hr_utility_trace('Step 4');

1420: csr_get_archived_regions_rec.action_information_category
1421: ||''', :l_pre_payment_id) LOOP ');
1422: cntr_flex_col := 1;
1423: LOOP
1424: hr_utility_trace('Step 4');
1425: EXIT WHEN cntr_flex_col > l_flex_col_num;
1426: IF flex_seg_enabled (
1427: csr_get_archived_regions_rec.action_information_category,
1428: 'ACTION_INFORMATION'||cntr_flex_col) THEN

Line 1636: hr_utility_trace ('The dyn SQL start:');

1632: build_sql(sqlstr,
1633: l_cntr_sql,
1634: 'end;');
1635:
1636: hr_utility_trace ('The dyn SQL start:');
1637: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
1638: hr_utility_trace(sqlstr(cntr));
1639: END LOOP;
1640: hr_utility_trace ('The dyn SQL ends.');

Line 1638: hr_utility_trace(sqlstr(cntr));

1634: 'end;');
1635:
1636: hr_utility_trace ('The dyn SQL start:');
1637: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
1638: hr_utility_trace(sqlstr(cntr));
1639: END LOOP;
1640: hr_utility_trace ('The dyn SQL ends.');
1641:
1642: csr := dbms_sql.open_cursor;

Line 1640: hr_utility_trace ('The dyn SQL ends.');

1636: hr_utility_trace ('The dyn SQL start:');
1637: FOR cntr IN sqlstr.first()..sqlstr.last() LOOP
1638: hr_utility_trace(sqlstr(cntr));
1639: END LOOP;
1640: hr_utility_trace ('The dyn SQL ends.');
1641:
1642: csr := dbms_sql.open_cursor;
1643: dbms_sql.parse (csr,
1644: sqlstr,

Line 1657: exception when others then hr_utility_trace('exception in binding variables, procedure generate third party.'); end;

1653: p_action_context_id);
1654: dbms_sql.bind_variable (csr,
1655: ':l_pre_payment_id',
1656: p_pre_payment_id);
1657: exception when others then hr_utility_trace('exception in binding variables, procedure generate third party.'); end;
1658: ret := dbms_sql.execute(csr);
1659: dbms_sql.close_cursor(csr);
1660:
1661: IF g_xml_table.count() <> 0 THEN

Line 1671: hr_utility_trace (g_xml_table(cntr));

1667: dbms_lob.writeAppend(l_xml,
1668: ln_amt,
1669: lr_xml);
1670:
1671: hr_utility_trace (g_xml_table(cntr));
1672: END LOOP;
1673: p_xml := l_xml;
1674: dbms_lob.freeTemporary(l_xml);
1675: END IF;

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

1679: -- Unset globals before exit;
1680: g_xml_table.delete();
1681: g_custom_context := NULL;
1682:
1683: hr_utility_trace ('Leaving '||l_proc_name);
1684: END GENERATE_THIRD_PARTY;
1685:
1686: --13029999 procedure generate third party end.
1687:

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

1687:
1688:
1689:
1690: BEGIN
1691: --hr_utility.trace_on (null, 'MX_IDC');
1692: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1693: g_debug := hr_utility.debug_enabled;
1694: END PAY_PAYROLL_XML_EXTRACT_PKG;

Line 1693: g_debug := hr_utility.debug_enabled;

1689:
1690: BEGIN
1691: --hr_utility.trace_on (null, 'MX_IDC');
1692: g_proc_name := 'PAY_PAYROLL_XML_EXTRACT_PKG.';
1693: g_debug := hr_utility.debug_enabled;
1694: END PAY_PAYROLL_XML_EXTRACT_PKG;