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

Line 81: hr_utility.trace( 'Entering '||l_proc);

77: l_text VARCHAR2(1000);
78: BEGIN
79: l_proc := g_proc_name||'get_message_text';
80: IF g_debug THEN
81: hr_utility.trace( 'Entering '||l_proc);
82: END IF;
83: IF p_act_info3 = 'CN_EMP_CATEGORY' THEN
84: fnd_message.set_name('PER', 'CN_EMP_CATEGORY');
85: fnd_message.set_token('EMPNUM', p_act_info1);

Line 94: l_text := hr_utility.get_message();

90: fnd_message.set_token('PNAME', p_act_info5);
91:
92: END IF;
93:
94: l_text := hr_utility.get_message();
95: IF g_debug THEN
96: hr_utility.trace( 'Leaving '||l_proc);
97: END IF;
98: RETURN l_text;

Line 96: hr_utility.trace( 'Leaving '||l_proc);

92: END IF;
93:
94: l_text := hr_utility.get_message();
95: IF g_debug THEN
96: hr_utility.trace( 'Leaving '||l_proc);
97: END IF;
98: RETURN l_text;
99: END;
100:

Line 126: hr_utility.trace ('Entering '||l_proc);

122:
123: l_proc := g_proc_name||'range_cursor';
124:
125: IF g_debug THEN
126: hr_utility.trace ('Entering '||l_proc);
127: END IF ;
128:
129: p_sqlstr := 'SELECT DISTINCT person_id
130: FROM per_people_f ppf,

Line 139: hr_utility.trace ('Leaving '||l_proc);

135:
136: initialization_code (p_pactid);
137:
138: IF g_debug THEN
139: hr_utility.trace ('Leaving '||l_proc);
140: END IF ;
141:
142: END range_cursor;
143: --

Line 243: hr_utility.trace ('Entering '||l_proc);

239:
240: l_proc := g_proc_name||'action_creation';
241:
242: IF g_debug THEN
243: hr_utility.trace ('Entering '||l_proc);
244: END IF ;
245:
246: IF g_bg_id IS NULL THEN
247: initialization_code (p_pactid);

Line 253: hr_utility.trace (' Picking Assignment ID '||i.assignment_id);

249:
250:
251: FOR i IN csr_assignments LOOP
252: IF g_debug THEN
253: hr_utility.trace (' Picking Assignment ID '||i.assignment_id);
254: END IF;
255:
256: FOR q IN c_get_periods(i.assignment_id) LOOP
257: IF g_debug THEN

Line 258: hr_utility.trace (' Picking Period NUmber '||q.pnum);

254: END IF;
255:
256: FOR q IN c_get_periods(i.assignment_id) LOOP
257: IF g_debug THEN
258: hr_utility.trace (' Picking Period NUmber '||q.pnum);
259: END IF;
260:
261: SELECT pay_assignment_actions_s.NEXTVAL
262: INTO l_actid

Line 278: hr_utility.trace ('Leaving '||l_proc);

274: END LOOP;
275: END LOOP;
276:
277: IF g_debug THEN
278: hr_utility.trace ('Leaving '||l_proc);
279: END IF ;
280:
281: END action_creation;
282:

Line 314: hr_utility.trace ('Entering '||l_proc);

310:
311: l_proc := g_proc_name||'get_parameters';
312:
313: IF g_debug THEN
314: hr_utility.trace ('Entering '||l_proc);
315: END IF ;
316:
317: OPEN csr_parameter_info(p_payroll_action_id);
318: FETCH csr_parameter_info INTO l_param_string,l_bg_id;

Line 347: hr_utility.trace ('Leaving '||l_proc);

343: p_token_value := '%';
344: END IF;
345:
346: IF g_debug THEN
347: hr_utility.trace ('Leaving '||l_proc);
348: END IF ;
349:
350: END get_parameters;
351:

Line 375: hr_utility.trace ('Entering '||l_proc_name);

371: --
372: BEGIN
373: IF g_debug THEN
374: l_proc_name := g_proc_name || 'GENERATE_XML';
375: hr_utility.trace ('Entering '||l_proc_name);
376: END IF ;
377:
378: l_cur_assact := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID' );
379: l_cur_pact := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID' );

Line 385: hr_utility.trace ('exiting from loop');

381: assact_xml(l_cur_assact);
382:
383: EXCEPTION
384: WHEN no_data_found THEN
385: hr_utility.trace ('exiting from loop');
386: --
387: IF g_debug THEN
388: hr_utility.trace ('Leaving '||l_proc_name);
389: END IF ;

Line 388: hr_utility.trace ('Leaving '||l_proc_name);

384: WHEN no_data_found THEN
385: hr_utility.trace ('exiting from loop');
386: --
387: IF g_debug THEN
388: hr_utility.trace ('Leaving '||l_proc_name);
389: END IF ;
390: END generate_xml;
391:
392: /****************************************************************************

Line 416: hr_utility.trace ('Entering '||l_proc);

412: --
413: l_proc := g_proc_name || 'initialization_code';
414:
415: if g_debug then
416: hr_utility.trace ('Entering '||l_proc);
417: end if ;
418:
419: g_payroll_action_id := p_payroll_action_id;
420: get_parameters(p_payroll_action_id,'YR',g_year);

Line 436: hr_utility.trace ('YR '||g_year);

432:
433:
434:
435: if g_debug then
436: hr_utility.trace ('YR '||g_year);
437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);

Line 437: hr_utility.trace ('g_bg_id '||g_bg_id);

433:
434:
435: if g_debug then
436: hr_utility.trace ('YR '||g_year);
437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);

Line 438: hr_utility.trace ('g_start_period '||g_start_period);

434:
435: if g_debug then
436: hr_utility.trace ('YR '||g_year);
437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);

Line 439: hr_utility.trace ('g_end_period '||g_end_period);

435: if g_debug then
436: hr_utility.trace ('YR '||g_year);
437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);

Line 440: hr_utility.trace ('g_start_date '||g_start_date);

436: hr_utility.trace ('YR '||g_year);
437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);

Line 441: hr_utility.trace ('g_end_date '||g_end_date);

437: hr_utility.trace ('g_bg_id '||g_bg_id);
438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);

Line 442: hr_utility.trace ('XML REPORT TAG '||l_tag);

438: hr_utility.trace ('g_start_period '||g_start_period);
439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);
446: hr_utility.trace ('Leaving '||l_proc);

Line 443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);

439: hr_utility.trace ('g_end_period '||g_end_period);
440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);
446: hr_utility.trace ('Leaving '||l_proc);
447: end if ;

Line 444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);

440: hr_utility.trace ('g_start_date '||g_start_date);
441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);
446: hr_utility.trace ('Leaving '||l_proc);
447: end if ;
448:

Line 445: hr_utility.trace ('Destination character set '||g_char_set);

441: hr_utility.trace ('g_end_date '||g_end_date);
442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);
446: hr_utility.trace ('Leaving '||l_proc);
447: end if ;
448:
449: EXCEPTION

Line 446: hr_utility.trace ('Leaving '||l_proc);

442: hr_utility.trace ('XML REPORT TAG '||l_tag);
443: hr_utility.trace ('SOE/MINISTRY Flag '||g_opt_soe_or_min);
444: hr_utility.trace ('TGL Date Used '||g_trfr_date_used);
445: hr_utility.trace ('Destination character set '||g_char_set);
446: hr_utility.trace ('Leaving '||l_proc);
447: end if ;
448:
449: EXCEPTION
450: WHEN OTHERS THEN

Line 640: hr_utility.trace ('Entering '||l_proc_name);

636:
637: BEGIN
638: IF g_debug THEN
639: l_proc_name := g_proc_name || 'gen_xml_header_pay';
640: hr_utility.trace ('Entering '||l_proc_name);
641: END IF ;
642:
643: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
644: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');

Line 765: hr_utility.trace('Emp Cat Code for '||group3rec.eno||' for period '||group3rec.accnt_prd);

761: ,p_action_information3 => 'CN_EMP_CATEGORY'
762: ,p_action_information_id => l_action_info_id
763: ,p_object_version_number => l_ovn
764: );
765: hr_utility.trace('Emp Cat Code for '||group3rec.eno||' for period '||group3rec.accnt_prd);
766: end if;
767: load_xml_internal('SG', g_ind_asg(0).p_meaning , null);
768: load_xml_internal('CG', g_ind_asg(1).p_meaning , group3rec.eno);
769:

Line 790: hr_utility.trace ('Leaving '||l_proc_name);

786: CLOSE csr_group3_data;
787: END LOOP;
788: END IF;
789: if g_debug then
790: hr_utility.trace ('Leaving '||l_proc_name);
791: end if ;
792:
793: END gen_xml_header_pay;
794:

Line 806: hr_utility.trace ('Entering '||l_proc_name);

802: l_head_trans1 VARCHAR2(1000);
803: BEGIN
804: if g_debug then
805: l_proc_name := g_proc_name || 'gen_xml_footer';
806: hr_utility.trace ('Entering '||l_proc_name);
807: end if ;
808: --
809: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
810: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');

Line 817: hr_utility.trace ('Leaving '||l_proc_name);

813: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');
814: load_xml_internal('EG',l_head_trans1,null);
815: END IF;
816: if g_debug then
817: hr_utility.trace ('Leaving '||l_proc_name);
818: end if ;
819:
820: END gen_xml_footer;
821:

Line 1045: hr_utility.trace('Payroll YearPeriod for assignment action'||l_serial_number);

1041:
1042:
1043: FOR i IN csr_assignments(l_assignment_id,l_period,l_year,l_payr_id) LOOP
1044:
1045: hr_utility.trace('Payroll YearPeriod for assignment action'||l_serial_number);
1046: if(l_assact_id is null or l_assact_id <> i.asg_action_id) then
1047:
1048: FOR j in csr_arch_elements(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1049: hr_utility.trace('XML elements being created for assignment_id id '||l_assignment_id);

Line 1049: hr_utility.trace('XML elements being created for assignment_id id '||l_assignment_id);

1045: hr_utility.trace('Payroll YearPeriod for assignment action'||l_serial_number);
1046: if(l_assact_id is null or l_assact_id <> i.asg_action_id) then
1047:
1048: FOR j in csr_arch_elements(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1049: hr_utility.trace('XML elements being created for assignment_id id '||l_assignment_id);
1050: hr_utility.trace('Period for assignment action'||l_period);
1051:
1052: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1053: load_xml_internal('CG',g_ind_detail(1).p_meaning,j.eno);

Line 1050: hr_utility.trace('Period for assignment action'||l_period);

1046: if(l_assact_id is null or l_assact_id <> i.asg_action_id) then
1047:
1048: FOR j in csr_arch_elements(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1049: hr_utility.trace('XML elements being created for assignment_id id '||l_assignment_id);
1050: hr_utility.trace('Period for assignment action'||l_period);
1051:
1052: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1053: load_xml_internal('CG',g_ind_detail(1).p_meaning,j.eno);
1054: load_xml_internal('CG',g_ind_detail(2).p_meaning,j.pay_name);

Line 1064: hr_utility.trace('XML balances being created for assignment_id id '||l_assignment_id);

1060: l_assact_id := i.asg_action_id;
1061:
1062: END LOOP;
1063: FOR k in csr_arch_balances(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1064: hr_utility.trace('XML balances being created for assignment_id id '||l_assignment_id);
1065: hr_utility.trace('Period for assignment action'||l_period);
1066:
1067: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1068: load_xml_internal('CG',g_ind_detail(1).p_meaning,k.eno);

Line 1065: hr_utility.trace('Period for assignment action'||l_period);

1061:
1062: END LOOP;
1063: FOR k in csr_arch_balances(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1064: hr_utility.trace('XML balances being created for assignment_id id '||l_assignment_id);
1065: hr_utility.trace('Period for assignment action'||l_period);
1066:
1067: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1068: load_xml_internal('CG',g_ind_detail(1).p_meaning,k.eno);
1069: load_xml_internal('CG',g_ind_detail(2).p_meaning,k.pay_name);

Line 1080: hr_utility.trace('XML stat balances being created for assignment_id id '||l_assignment_id);

1076:
1077: END LOOP;
1078:
1079: FOR x in csr_arch_stat_balances(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1080: hr_utility.trace('XML stat balances being created for assignment_id id '||l_assignment_id);
1081: hr_utility.trace('Period for assignment action'||l_period);
1082:
1083: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1084: load_xml_internal('CG',g_ind_detail(1).p_meaning,x.eno);

Line 1081: hr_utility.trace('Period for assignment action'||l_period);

1077: END LOOP;
1078:
1079: FOR x in csr_arch_stat_balances(l_assignment_id,i.payroll_id, i.asg_action_id,i.earn_date,i.eff_date) LOOP
1080: hr_utility.trace('XML stat balances being created for assignment_id id '||l_assignment_id);
1081: hr_utility.trace('Period for assignment action'||l_period);
1082:
1083: load_xml_internal('SG',g_ind_detail(0).p_meaning,NULL);
1084: load_xml_internal('CG',g_ind_detail(1).p_meaning,x.eno);
1085: load_xml_internal('CG',g_ind_detail(2).p_meaning,x.pay_name);

Line 1120: hr_utility.trace ('Entering '||l_proc_name);

1116: BEGIN
1117: l_proc_name := g_proc_name || 'LOAD_XML_INTERNAL';
1118:
1119: IF g_debug THEN
1120: hr_utility.trace ('Entering '||l_proc_name);
1121: END IF;
1122:
1123: IF p_node_type = 'ROOT' THEN
1124:

Line 1150: hr_utility.trace ('Leaving '||l_proc_name);

1146:
1147: pay_core_files.write_to_magtape_lob(l_xml);
1148:
1149: IF g_debug THEN
1150: hr_utility.trace ('Leaving '||l_proc_name);
1151: hr_utility.trace ('XML Data being written is '||l_xml);
1152: END IF;
1153:
1154: END load_xml_internal;

Line 1151: hr_utility.trace ('XML Data being written is '||l_xml);

1147: pay_core_files.write_to_magtape_lob(l_xml);
1148:
1149: IF g_debug THEN
1150: hr_utility.trace ('Leaving '||l_proc_name);
1151: hr_utility.trace ('XML Data being written is '||l_xml);
1152: END IF;
1153:
1154: END load_xml_internal;
1155:

Line 1196: hr_utility.trace('Entering set_globals procedure');

1192:
1193: BEGIN
1194:
1195: IF g_debug THEN
1196: hr_utility.trace('Entering set_globals procedure');
1197: END IF;
1198:
1199: -- capture the value of g_opt_soe_or_min
1200: OPEN gen_xml_opt_soe_min;

Line 1261: hr_utility.trace('Leaving set_globals procedure');

1257:
1258: END IF;
1259:
1260: IF g_debug THEN
1261: hr_utility.trace('Leaving set_globals procedure');
1262: END IF;
1263:
1264: END set_globals;
1265:

Line 1289: hr_utility.trace('Entering get_employee_number function');

1285:
1286: BEGIN
1287:
1288: IF g_debug THEN
1289: hr_utility.trace('Entering get_employee_number function');
1290: END IF;
1291:
1292: OPEN c_employee_number;
1293: FETCH c_employee_number INTO l_emp_num;

Line 1297: hr_utility.trace('Leaving get_employee_number function');

1293: FETCH c_employee_number INTO l_emp_num;
1294: CLOSE c_employee_number;
1295:
1296: IF g_debug THEN
1297: hr_utility.trace('Leaving get_employee_number function');
1298: END IF;
1299:
1300: RETURN l_emp_num ;
1301:

Line 1420: hr_utility.trace('Entering deinitialization_code procedure');

1416:
1417: BEGIN
1418:
1419: IF g_debug THEN
1420: hr_utility.trace('Entering deinitialization_code procedure');
1421: END IF;
1422:
1423: OPEN get_error;
1424: FETCH get_error INTO l_count;

Line 1513: hr_utility.trace('Leaving deinitialization_code procedure');

1509: );
1510: END IF; --lv_error_flag='W'
1511:
1512: IF g_debug THEN
1513: hr_utility.trace('Leaving deinitialization_code procedure');
1514: END IF;
1515:
1516: END;
1517:

Line 1540: hr_utility.trace('Entering sort action procedure');

1536: l_chardate_end VARCHAR2(255);
1537: BEGIN
1538:
1539: IF g_debug THEN
1540: hr_utility.trace('Entering sort action procedure');
1541: END IF;
1542:
1543: initialization_code(payactid);
1544:

Line 1566: hr_utility.trace('Leaving sort action procedure');

1562:
1563: len := length(sqlstr); -- return the length of the string.
1564:
1565: IF g_debug THEN
1566: hr_utility.trace('Leaving sort action procedure');
1567: END IF;
1568:
1569: END sort_action;
1570:

Line 1574: g_debug := hr_utility.debug_enabled;

1570:
1571: BEGIN
1572:
1573: g_proc_name := 'pay_cn_audit_xmlgen.';
1574: g_debug := hr_utility.debug_enabled;
1575: g_document_type := 'CNAO_XML_FOR_SOE_AND_MINISTRY';
1576:
1577: END pay_cn_audit_xmlgen;