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.PQP_GB_SWF_EXTRACT dependencies on HR_UTILITY

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

53: PROCEDURE WRITE_LINE(p_tag_type varchar2,p_tag_name varchar2,p_tag_value varchar2) AS
54: l_proc constant varchar2(100):= g_package||'WRITE_LINE';
55: l_data pay_action_information.action_information1%type;
56: BEGIN
57: hr_utility.trace('Entering: '||l_proc);
58:
59: IF p_tag_type = 'O' THEN -- Open Tag
60: l_data:='<'||p_tag_name||'>';
61: hr_utility.set_location('Writing : '||l_data,2);

Line 61: hr_utility.set_location('Writing : '||l_data,2);

57: hr_utility.trace('Entering: '||l_proc);
58:
59: IF p_tag_type = 'O' THEN -- Open Tag
60: l_data:='<'||p_tag_name||'>';
61: hr_utility.set_location('Writing : '||l_data,2);
62: ELSIF p_tag_type = 'C' THEN -- Close Tag
63: l_data:='';
64: hr_utility.set_location('Writing : '||l_data,3);
65: ELSIF p_tag_type = 'D' THEN -- Data Tag

Line 64: hr_utility.set_location('Writing : '||l_data,3);

60: l_data:='<'||p_tag_name||'>';
61: hr_utility.set_location('Writing : '||l_data,2);
62: ELSIF p_tag_type = 'C' THEN -- Close Tag
63: l_data:='';
64: hr_utility.set_location('Writing : '||l_data,3);
65: ELSIF p_tag_type = 'D' THEN -- Data Tag
66: -- If the value is null do not display the tag
67: IF (p_tag_value is null OR trim(p_tag_value) ='') THEN
68: return;

Line 69: hr_utility.set_location(p_tag_name||' Value is null',4);

65: ELSIF p_tag_type = 'D' THEN -- Data Tag
66: -- If the value is null do not display the tag
67: IF (p_tag_value is null OR trim(p_tag_value) ='') THEN
68: return;
69: hr_utility.set_location(p_tag_name||' Value is null',4);
70: END IF;
71: -- Replace special characters with XML equivalents
72: l_data := REPLACE (p_tag_value, '&', '&');
73: l_data := REPLACE (l_data, '<', '<');

Line 79: hr_utility.set_location('Writing : '||l_data,5);

75: l_data := REPLACE (l_data, '''', ''');
76: l_data := REPLACE (l_data, '"', '"');
77: l_data:='<'||p_tag_name||'>'||l_data||'';
78:
79: hr_utility.set_location('Writing : '||l_data,5);
80: END IF;
81:
82: utl_file.put_line(g_file_handle, l_data);
83:

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

80: END IF;
81:
82: utl_file.put_line(g_file_handle, l_data);
83:
84: hr_utility.trace('Leaving: '||l_proc);
85: END WRITE_LINE;
86:
87: PROCEDURE PREPARE_FILE(p_lea_or_est_num number) AS
88: l_file_name varchar2(50);

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

87: PROCEDURE PREPARE_FILE(p_lea_or_est_num number) AS
88: l_file_name varchar2(50);
89: l_proc constant varchar2(100):= g_package||'PREPARE_FILE';
90: BEGIN
91: hr_utility.trace('Entering: '||l_proc);
92:
93: -- Bug#12586059
94:
95: -- IF g_data_return_type in ('TYPE1A','TYPE3','TYPE4') THEN

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

107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);
108: utl_file.put_line(g_file_handle, '');
109: WRITE_LINE('O','Message',null);
110:
111: hr_utility.trace('Leaving: '||l_proc);
112: END PREPARE_FILE;
113:
114: PROCEDURE CLOSE_FILE AS
115: l_proc constant varchar2(100):= g_package||'CLOSE_FILE';

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

113:
114: PROCEDURE CLOSE_FILE AS
115: l_proc constant varchar2(100):= g_package||'CLOSE_FILE';
116: BEGIN
117: hr_utility.trace('Entering: '||l_proc);
118: WRITE_LINE('C','Message',null);
119: utl_file.fclose (g_file_handle);
120: hr_utility.trace('Leaving: '||l_proc);
121: END CLOSE_FILE;

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

116: BEGIN
117: hr_utility.trace('Entering: '||l_proc);
118: WRITE_LINE('C','Message',null);
119: utl_file.fclose (g_file_handle);
120: hr_utility.trace('Leaving: '||l_proc);
121: END CLOSE_FILE;
122:
123: PROCEDURE WRITE_HEADER(p_est_number number) AS
124: l_proc constant varchar2(100):= g_package||'WRITE_HEADER';

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

135:
136: l_version varchar2(100);
137:
138: BEGIN
139: hr_utility.trace('Entering: '||l_proc);
140:
141: WRITE_LINE('O','Header',null);
142: WRITE_LINE('O','CollectionDetails',null);
143: WRITE_LINE('D','Collection','School Workforce Census');

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

168: WRITE_LINE('C','CBDSLevels',null);
169: WRITE_LINE('C','Content',null);
170: WRITE_LINE('C','Header',null);
171:
172: hr_utility.trace('Leaving: '||l_proc);
173: END WRITE_HEADER;
174:
175: PROCEDURE WRITE_STAFF_DETAILS(p_person_id pay_action_information.action_information1%type,
176: p_person_category number)

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

199: l_proc constant varchar2(100):= g_package||'WRITE_STAFF_DETAILS';
200: l_HLTA_Status varchar2(10);
201: l_QT_Status varchar2(10); -- Bug#12586059
202: BEGIN
203: hr_utility.trace('Entering: '||l_proc);
204:
205: FOR l_staff_rec in c_staff_details LOOP
206: WRITE_LINE('O','StaffDetails',null);
207: WRITE_LINE('D','TeacherNumber',l_staff_rec.teacher_number);

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

254: WRITE_LINE('C','StaffDetails',null);
255: EXIT; -- Do not want to display staff multiple times
256: END LOOP;
257:
258: hr_utility.trace('Entering: '||l_proc);
259: END WRITE_STAFF_DETAILS;
260:
261: PROCEDURE WRITE_CONTRACT_DETAILS(p_est_number pay_action_information.action_information11%type,
262: p_person_id pay_action_information.action_information1%type,

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

331: and pai.assignment_id = cp_assignment_id;
332:
333: l_proc constant varchar2(100):= g_package||'WRITE_CONTRACT_DETAILS';
334: BEGIN
335: hr_utility.trace('Entering: '||l_proc);
336:
337: WRITE_LINE('O','ContractOrServiceGroup',null);
338: FOR l_contract_rec in c_contract_details LOOP
339: WRITE_LINE('O','ContractOrService',null);

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

425: WRITE_LINE('C','ContractOrService',null);
426: END LOOP;
427: WRITE_LINE('C','ContractOrServiceGroup',null);
428:
429: hr_utility.trace('Leaving: '||l_proc);
430: END WRITE_CONTRACT_DETAILS;
431:
432: PROCEDURE WRITE_ABS_DETAILS(p_est_number pay_action_information.action_information6%type,
433: p_person_id pay_action_information.action_information1%type) AS

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

448: and pai.action_information6 = nvl(p_est_number,pai.action_information6);
449:
450: l_proc constant varchar2(100):= g_package||'WRITE_ABS_DETAILS';
451: BEGIN
452: hr_utility.trace('Entering: '||l_proc);
453:
454: WRITE_LINE('O','Absences',null);
455: FOR l_abs_rec in c_abs_details LOOP
456: WRITE_LINE('O','Absence',null);

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

462: WRITE_LINE('C','Absence',null);
463: END LOOP;
464: WRITE_LINE('C','Absences',null);
465:
466: hr_utility.trace('Leaving: '||l_proc);
467: END WRITE_ABS_DETAILS;
468:
469: PROCEDURE WRITE_QUAL_DETAILS(p_est_number pay_action_information.action_information6%type,
470: p_person_id pay_action_information.action_information1%type) AS

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

491: and pai.action_information6 = nvl(p_est_number,pai.action_information6);
492:
493: l_proc constant varchar2(100):= g_package||'WRITE_QUAL_DETAILS';
494: BEGIN
495: hr_utility.trace('Entering: '||l_proc);
496:
497: WRITE_LINE('O','Qualifications',null);
498: FOR l_qual_rec in c_qual_details LOOP
499: WRITE_LINE('O','Qualification',null);

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

511: WRITE_LINE('C','Qualification',null);
512: END LOOP;
513: WRITE_LINE('C','Qualifications',null);
514:
515: hr_utility.trace('Leaving: '||l_proc);
516: END WRITE_QUAL_DETAILS;
517:
518: PROCEDURE WRITE_LA AS
519:

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

553: and pai.action_information2 = 'P';
554:
555: l_proc constant varchar2(100):= g_package||'WRITE_LA';
556: BEGIN
557: hr_utility.trace('Entering: '||l_proc);
558:
559: OPEN c_edu_psy_ft;
560: FETCH c_edu_psy_ft INTO g_edu_psy_ft;
561: CLOSE c_edu_psy_ft;

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

575: WRITE_LINE('D','EdPsychsFTE',round(nvl(g_edu_psy_fte,0),1));
576: WRITE_LINE('C','EducationalPsychologists',null);
577: WRITE_LINE('C','LA',null);
578:
579: hr_utility.trace('Leaving: '||l_proc);
580: END WRITE_LA;
581:
582: PROCEDURE XML_EXTRACT(errbuf out nocopy varchar2
583: ,retcode out nocopy varchar2

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

656: l_person_category number;
657: l_estab_count number:=0;
658:
659: BEGIN
660: hr_utility.trace('Entering: '||l_proc);
661:
662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);

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

816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));
818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));
819: END IF;
820: hr_utility.trace('Leaving: '||l_proc);
821:
822: EXCEPTION
823: WHEN utl_file.invalid_path THEN
824: errbuf:='Output Directory specified is invalid. Please Verify.';