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

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

98:
99: BEGIN
100:
101: l_proc_name := g_proc_name || 'GET_PARAMETERS';
102: hr_utility.trace ('Entering '|| l_proc_name);
103:
104: hr_utility.trace (' p_ppa_finder '|| p_ppa_finder );
105:
106: OPEN c_params(p_ppa_finder);

Line 104: hr_utility.trace (' p_ppa_finder '|| p_ppa_finder );

100:
101: l_proc_name := g_proc_name || 'GET_PARAMETERS';
102: hr_utility.trace ('Entering '|| l_proc_name);
103:
104: hr_utility.trace (' p_ppa_finder '|| p_ppa_finder );
105:
106: OPEN c_params(p_ppa_finder);
107: FETCH c_params INTO l_pact_id,
108: l_param,

Line 114: hr_utility.trace (' l_pact_id '|| l_pact_id );

110: l_start_date,
111: l_end_date;
112: CLOSE c_params;
113: /*
114: hr_utility.trace (' l_pact_id '|| l_pact_id );
115: hr_utility.trace (' l_param '|| l_param );
116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );
117: hr_utility.trace (' l_start_date '|| l_start_date );
118: hr_utility.trace (' l_end_date '|| l_end_date );

Line 115: hr_utility.trace (' l_param '|| l_param );

111: l_end_date;
112: CLOSE c_params;
113: /*
114: hr_utility.trace (' l_pact_id '|| l_pact_id );
115: hr_utility.trace (' l_param '|| l_param );
116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );
117: hr_utility.trace (' l_start_date '|| l_start_date );
118: hr_utility.trace (' l_end_date '|| l_end_date );
119: */

Line 116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );

112: CLOSE c_params;
113: /*
114: hr_utility.trace (' l_pact_id '|| l_pact_id );
115: hr_utility.trace (' l_param '|| l_param );
116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );
117: hr_utility.trace (' l_start_date '|| l_start_date );
118: hr_utility.trace (' l_end_date '|| l_end_date );
119: */
120: l_consolidation_set_id

Line 117: hr_utility.trace (' l_start_date '|| l_start_date );

113: /*
114: hr_utility.trace (' l_pact_id '|| l_pact_id );
115: hr_utility.trace (' l_param '|| l_param );
116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );
117: hr_utility.trace (' l_start_date '|| l_start_date );
118: hr_utility.trace (' l_end_date '|| l_end_date );
119: */
120: l_consolidation_set_id
121: := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);

Line 118: hr_utility.trace (' l_end_date '|| l_end_date );

114: hr_utility.trace (' l_pact_id '|| l_pact_id );
115: hr_utility.trace (' l_param '|| l_param );
116: hr_utility.trace (' l_business_group_id '|| l_business_group_id );
117: hr_utility.trace (' l_start_date '|| l_start_date );
118: hr_utility.trace (' l_end_date '|| l_end_date );
119: */
120: l_consolidation_set_id
121: := pay_paygtn_pkg.get_parameter('TRANSFER_CONC_SET',l_param);
122: l_payroll_id := pay_paygtn_pkg.get_parameter('TRANSFER_PAYROLL',l_param);

Line 129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );

125: l_sort2 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT2',l_param);
126: l_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
127: l_asg_flag := NVL(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
128: /*
129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );
130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );

Line 130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );

126: l_sort3 := pay_paygtn_pkg.get_parameter('TRANSFER_SORT3',l_param);
127: l_asg_flag := NVL(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
128: /*
129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );
130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );

Line 131: hr_utility.trace (' l_gre_id '|| l_gre_id );

127: l_asg_flag := NVL(pay_paygtn_pkg.get_parameter('TRANSFER_EMP_INFO',l_param),'N');
128: /*
129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );
130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );

Line 132: hr_utility.trace (' l_sort1 '|| l_sort1 );

128: /*
129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );
130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );
136: */

Line 133: hr_utility.trace (' l_sort2 '|| l_sort2 );

129: hr_utility.trace (' l_consolidation_set_id '|| l_consolidation_set_id );
130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );
136: */
137: hr_utility.trace ('Leaving '||l_proc_name);

Line 134: hr_utility.trace (' l_sort3 '|| l_sort3 );

130: hr_utility.trace (' l_payroll_id '|| l_payroll_id );
131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );
136: */
137: hr_utility.trace ('Leaving '||l_proc_name);
138:

Line 135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );

131: hr_utility.trace (' l_gre_id '|| l_gre_id );
132: hr_utility.trace (' l_sort1 '|| l_sort1 );
133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );
136: */
137: hr_utility.trace ('Leaving '||l_proc_name);
138:
139: EXCEPTION

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

133: hr_utility.trace (' l_sort2 '|| l_sort2 );
134: hr_utility.trace (' l_sort3 '|| l_sort3 );
135: hr_utility.trace (' l_asg_flag '|| l_asg_flag );
136: */
137: hr_utility.trace ('Leaving '||l_proc_name);
138:
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN
141: hr_utility.trace ('Inside Exception WHEN NO_DATA_FOUND for '|| l_proc_name);

Line 141: hr_utility.trace ('Inside Exception WHEN NO_DATA_FOUND for '|| l_proc_name);

137: hr_utility.trace ('Leaving '||l_proc_name);
138:
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN
141: hr_utility.trace ('Inside Exception WHEN NO_DATA_FOUND for '|| l_proc_name);
142: END GET_PARAMETERS;
143:
144: /* This Procedure writes the header details for GTN Report*/
145: PROCEDURE WRITE_HEADER

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

156:
157: BEGIN
158:
159: l_proc_name := g_proc_name || 'write_header';
160: hr_utility.trace ('Entering '|| l_proc_name);
161:
162: l_business_group_name := hr_reports.get_business_group(l_business_group_id);
163:
164: --hr_utility.trace (' l_business_group_name : '|| l_business_group_name );

Line 164: --hr_utility.trace (' l_business_group_name : '|| l_business_group_name );

160: hr_utility.trace ('Entering '|| l_proc_name);
161:
162: l_business_group_name := hr_reports.get_business_group(l_business_group_id);
163:
164: --hr_utility.trace (' l_business_group_name : '|| l_business_group_name );
165: --hr_utility.trace (' l_payroll_id : '|| l_payroll_id );
166:
167: IF l_payroll_id IS NOT NULL THEN
168: SELECT distinct substr(payroll_name,1,80),

Line 165: --hr_utility.trace (' l_payroll_id : '|| l_payroll_id );

161:
162: l_business_group_name := hr_reports.get_business_group(l_business_group_id);
163:
164: --hr_utility.trace (' l_business_group_name : '|| l_business_group_name );
165: --hr_utility.trace (' l_payroll_id : '|| l_payroll_id );
166:
167: IF l_payroll_id IS NOT NULL THEN
168: SELECT distinct substr(payroll_name,1,80),
169: substr('Payroll : '||payroll_name,1,80)

Line 178: --hr_utility.trace (' l_payroll_name : '|| l_payroll_name );

174: AND effective_start_date <= l_end_date
175: AND effective_end_date >= l_end_date;
176: END IF;
177:
178: --hr_utility.trace (' l_payroll_name : '|| l_payroll_name );
179: --hr_utility.trace (' l_print_set_payroll_name : '|| l_print_set_payroll_name );
180: --hr_utility.trace (' l_consolidation_set_id : '|| l_consolidation_set_id );
181:
182: IF l_payroll_id IS NULL AND l_consolidation_set_id IS NOT NULL THEN

Line 179: --hr_utility.trace (' l_print_set_payroll_name : '|| l_print_set_payroll_name );

175: AND effective_end_date >= l_end_date;
176: END IF;
177:
178: --hr_utility.trace (' l_payroll_name : '|| l_payroll_name );
179: --hr_utility.trace (' l_print_set_payroll_name : '|| l_print_set_payroll_name );
180: --hr_utility.trace (' l_consolidation_set_id : '|| l_consolidation_set_id );
181:
182: IF l_payroll_id IS NULL AND l_consolidation_set_id IS NOT NULL THEN
183: SELECT consolidation_set_name,

Line 180: --hr_utility.trace (' l_consolidation_set_id : '|| l_consolidation_set_id );

176: END IF;
177:
178: --hr_utility.trace (' l_payroll_name : '|| l_payroll_name );
179: --hr_utility.trace (' l_print_set_payroll_name : '|| l_print_set_payroll_name );
180: --hr_utility.trace (' l_consolidation_set_id : '|| l_consolidation_set_id );
181:
182: IF l_payroll_id IS NULL AND l_consolidation_set_id IS NOT NULL THEN
183: SELECT consolidation_set_name,
184: substr('Consolidation Set : '||consolidation_set_name,1,80)

Line 191: --hr_utility.trace (' consolidation_set_name : '|| l_consolidation_set_name );

187: FROM pay_consolidation_sets
188: WHERE consolidation_set_id = l_consolidation_set_id;
189: END IF;
190:
191: --hr_utility.trace (' consolidation_set_name : '|| l_consolidation_set_name );
192:
193: IF l_payroll_id IS NOT NULL AND l_consolidation_set_id IS NOT NULL THEN
194: SELECT consolidation_set_name,
195: substr('Consolidation Set : '||consolidation_set_name,1,80)

Line 202: --hr_utility.trace (' l_gre_id : '|| l_gre_id );

198: FROM pay_consolidation_sets
199: WHERE consolidation_set_id = l_consolidation_set_id;
200: END IF;
201:
202: --hr_utility.trace (' l_gre_id : '|| l_gre_id );
203:
204: IF l_gre_id IS NOT NULL THEN
205: SELECT substr(name,1,80)
206: INTO l_gre_name

Line 211: --hr_utility.trace (' l_gre_name : '|| l_gre_name );

207: FROM hr_organization_units
208: WHERE organization_id = l_gre_id;
209: END IF;
210:
211: --hr_utility.trace (' l_gre_name : '|| l_gre_name );
212:
213: IF l_sort1 IS NOT NULL THEN
214: l_print_sort1_name := hr_general.decode_lookup('PAY_GTN_SORT',l_sort1) || ' Name';
215: END IF;

Line 223: hr_utility.trace (' l_sort1 : '|| l_sort1 );

219: IF l_sort3 IS NOT NULL THEN
220: l_print_sort3_name := hr_general.decode_lookup('PAY_GTN_SORT',l_sort3) || ' Name';
221: END IF;
222: /*
223: hr_utility.trace (' l_sort1 : '|| l_sort1 );
224: hr_utility.trace (' l_sort2 : '|| l_sort2 );
225: hr_utility.trace (' l_sort3 : '|| l_sort3 );
226: */
227: vXMLTable.DELETE;

Line 224: hr_utility.trace (' l_sort2 : '|| l_sort2 );

220: l_print_sort3_name := hr_general.decode_lookup('PAY_GTN_SORT',l_sort3) || ' Name';
221: END IF;
222: /*
223: hr_utility.trace (' l_sort1 : '|| l_sort1 );
224: hr_utility.trace (' l_sort2 : '|| l_sort2 );
225: hr_utility.trace (' l_sort3 : '|| l_sort3 );
226: */
227: vXMLTable.DELETE;
228: vCtr := 0;

Line 225: hr_utility.trace (' l_sort3 : '|| l_sort3 );

221: END IF;
222: /*
223: hr_utility.trace (' l_sort1 : '|| l_sort1 );
224: hr_utility.trace (' l_sort2 : '|| l_sort2 );
225: hr_utility.trace (' l_sort3 : '|| l_sort3 );
226: */
227: vXMLTable.DELETE;
228: vCtr := 0;
229:

Line 279: -- hr_utility.trace (' vXMLTable(vCtr).xmlstring : '|| vXMLTable(vCtr).xmlstring );

275: || '';
276: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
277: || '';
278:
279: -- hr_utility.trace (' vXMLTable(vCtr).xmlstring : '|| vXMLTable(vCtr).xmlstring );
280:
281: hr_utility.trace ('Leaving '|| l_proc_name);
282:
283: END WRITE_HEADER;

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

277: || '';
278:
279: -- hr_utility.trace (' vXMLTable(vCtr).xmlstring : '|| vXMLTable(vCtr).xmlstring );
280:
281: hr_utility.trace ('Leaving '|| l_proc_name);
282:
283: END WRITE_HEADER;
284:
285:

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

533: l_temp_print varchar2 (1500);
534: BEGIN
535:
536: l_proc_name := g_proc_name || 'WRITE_DETAIL_RECORDS';
537: hr_utility.trace ('Entering '|| l_proc_name);
538: /*
539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );

Line 539: hr_utility.trace (' l_sort1 : ' || l_sort1 );

535:
536: l_proc_name := g_proc_name || 'WRITE_DETAIL_RECORDS';
537: hr_utility.trace ('Entering '|| l_proc_name);
538: /*
539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );
542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );
543: hr_utility.trace (' l_pact_id : ' || l_pact_id );

Line 540: hr_utility.trace (' l_sort2 : ' || l_sort2 );

536: l_proc_name := g_proc_name || 'WRITE_DETAIL_RECORDS';
537: hr_utility.trace ('Entering '|| l_proc_name);
538: /*
539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );
542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );
543: hr_utility.trace (' l_pact_id : ' || l_pact_id );
544: */

Line 541: hr_utility.trace (' l_sort3 : ' || l_sort3 );

537: hr_utility.trace ('Entering '|| l_proc_name);
538: /*
539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );
542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );
543: hr_utility.trace (' l_pact_id : ' || l_pact_id );
544: */
545: vCtr := vCtr + 1;

Line 542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );

538: /*
539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );
542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );
543: hr_utility.trace (' l_pact_id : ' || l_pact_id );
544: */
545: vCtr := vCtr + 1;
546: vXMLTable(vCtr).xmlstring := '';

Line 543: hr_utility.trace (' l_pact_id : ' || l_pact_id );

539: hr_utility.trace (' l_sort1 : ' || l_sort1 );
540: hr_utility.trace (' l_sort2 : ' || l_sort2 );
541: hr_utility.trace (' l_sort3 : ' || l_sort3 );
542: hr_utility.trace (' l_asg_flag : ' || l_asg_flag );
543: hr_utility.trace (' l_pact_id : ' || l_pact_id );
544: */
545: vCtr := vCtr + 1;
546: vXMLTable(vCtr).xmlstring := '';
547: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 557: -- hr_utility.trace (' Loop Start length of vXMLTable(vCtr).xmlstring : ' || length(vXMLTable(vCtr).xmlstring));

553: l_pact_id
554: )
555: LOOP
556: /* Check whether it is first record.If it is first record initialize the values*/
557: -- hr_utility.trace (' Loop Start length of vXMLTable(vCtr).xmlstring : ' || length(vXMLTable(vCtr).xmlstring));
558: -- bug 5862861 :
559: if length(vXMLTable(vCtr).xmlstring) > 30000 then
560: vCtr := vCtr + 1;
561: vXMLTable(vCtr).xmlstring := '';

Line 564: -- hr_utility.trace (' l_temp_count : ' || l_temp_count ||' , '||' row count : ' || c_detail_records%rowcount );

560: vCtr := vCtr + 1;
561: vXMLTable(vCtr).xmlstring := '';
562: end if;
563:
564: -- hr_utility.trace (' l_temp_count : ' || l_temp_count ||' , '||' row count : ' || c_detail_records%rowcount );
565:
566: IF l_temp_count <> 0 THEN
567: /* The record is not the first Record */
568: /* Check whether it is new sort clause.If it is a new sort group print the Summary values

Line 571: hr_utility.trace (' l_temp_count <> 0 ' );

567: /* The record is not the first Record */
568: /* Check whether it is new sort clause.If it is a new sort group print the Summary values
569: for Previous sort group, reset them and open new sort group*/
570: /*
571: hr_utility.trace (' l_temp_count <> 0 ' );
572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );

Line 572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );

568: /* Check whether it is new sort clause.If it is a new sort group print the Summary values
569: for Previous sort group, reset them and open new sort group*/
570: /*
571: hr_utility.trace (' l_temp_count <> 0 ' );
572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
576: */

Line 573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );

569: for Previous sort group, reset them and open new sort group*/
570: /*
571: hr_utility.trace (' l_temp_count <> 0 ' );
572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
576: */
577:

Line 574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );

570: /*
571: hr_utility.trace (' l_temp_count <> 0 ' );
572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
576: */
577:
578: if (l_sort1_name = detrec.sort1_name or (l_sort1_name is NULL AND detrec.sort1_name is NULL))

Line 575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );

571: hr_utility.trace (' l_temp_count <> 0 ' );
572: hr_utility.trace (' l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
573: hr_utility.trace (' l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
574: hr_utility.trace (' l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
575: hr_utility.trace (' l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
576: */
577:
578: if (l_sort1_name = detrec.sort1_name or (l_sort1_name is NULL AND detrec.sort1_name is NULL))
579: AND (l_sort2_name = detrec.sort2_name or (l_sort2_name is NULL AND detrec.sort2_name is NULL))

Line 584: hr_utility.trace (' Same sort Group ' );

580: AND (l_sort3_name = detrec.sort3_name or (l_sort3_name is NULL AND detrec.sort3_name is NULL))
581: AND (l_person_id = detrec.person_id or (l_person_id is NULL AND detrec.person_id is NULL)) THEN
582: /* Same sort Group*/
583: /* Check whether its a new classification*/
584: hr_utility.trace (' Same sort Group ' );
585: /*
586: hr_utility.trace (' l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
587:
588: hr_utility.trace (' l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );

Line 586: hr_utility.trace (' l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );

582: /* Same sort Group*/
583: /* Check whether its a new classification*/
584: hr_utility.trace (' Same sort Group ' );
585: /*
586: hr_utility.trace (' l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
587:
588: hr_utility.trace (' l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
589: */
590: if l_class_seq = detrec.class_seq1 and l_sub_class = detrec.sub_class1 THEN

Line 588: hr_utility.trace (' l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );

584: hr_utility.trace (' Same sort Group ' );
585: /*
586: hr_utility.trace (' l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
587:
588: hr_utility.trace (' l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
589: */
590: if l_class_seq = detrec.class_seq1 and l_sub_class = detrec.sub_class1 THEN
591: NULL;
592: else -- new classification

Line 598: hr_utility.trace (' l_class_seq not in 9,10 ' );

594: so added a check*/
595: if l_class_seq not in (9,10) then
596: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||'Total '||l_class_name||'';
597:
598: hr_utility.trace (' l_class_seq not in 9,10 ' );
599: --
600: if l_hours_sum = 0 THEN
601: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||NULL||'';
602: else

Line 628: --hr_utility.trace (' l_class_name : ' || l_class_name );

624: l_class_seq := detrec.class_seq1;
625: l_sub_class := detrec.sub_class1;
626: l_class_name := detrec.classification1;
627:
628: --hr_utility.trace (' l_class_name : ' || l_class_name );
629:
630: -- vCtr := vCtr + 1;
631: /* if vCtr >= 1000 THEN
632: WRITE_TO_CLOB(p_xfdf_blob);

Line 639: --hr_utility.trace (' vXMLTable(vCtr).xmlstring : ' || vXMLTable(vCtr).xmlstring );

635: end if;*/
636: -- vXMLTable(vCtr).xmlstring := ' ';
637:
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||detrec.classification1||'';
639: --hr_utility.trace (' vXMLTable(vCtr).xmlstring : ' || vXMLTable(vCtr).xmlstring );
640: /*to be deleted*/
641: --start
642: /*
643: if length(vXMLTable(vCtr).xmlstring) >= 1 then

Line 644: hr_utility.trace (' length of vXMLTable(vCtr).xmlstring : ' || length(vXMLTable(vCtr).xmlstring) );

640: /*to be deleted*/
641: --start
642: /*
643: if length(vXMLTable(vCtr).xmlstring) >= 1 then
644: hr_utility.trace (' length of vXMLTable(vCtr).xmlstring : ' || length(vXMLTable(vCtr).xmlstring) );
645: l_temp_print := substr(vXMLTable(vCtr).xmlstring , 1 , 1500);
646: hr_utility.trace (' l_temp_print : ' || l_temp_print );
647: end if;
648: */

Line 646: hr_utility.trace (' l_temp_print : ' || l_temp_print );

642: /*
643: if length(vXMLTable(vCtr).xmlstring) >= 1 then
644: hr_utility.trace (' length of vXMLTable(vCtr).xmlstring : ' || length(vXMLTable(vCtr).xmlstring) );
645: l_temp_print := substr(vXMLTable(vCtr).xmlstring , 1 , 1500);
646: hr_utility.trace (' l_temp_print : ' || l_temp_print );
647: end if;
648: */
649:
650: --end

Line 655: hr_utility.trace (' else of sort ' );

651: end if; -- new classification
652: else -- else of sort clause
653: /* For Totals By Classification Region Summary of totals should be displayed.
654: This section will calculate the same*/
655: hr_utility.trace (' else of sort ' );
656:
657: if l_sort2_name is NULL and l_sort3_name is NULL THEN
658: l_tot_gross_earn_class := l_tot_gross_earn_class + l_tot_gross_earn;
659: l_tot_imput_earn_class := l_tot_imput_earn_class + l_tot_imput_earn;

Line 702: --hr_utility.trace (' l_total_net : ' || l_total_net );

698: nvl(l_tot_vol_ded,0) -
699: nvl(l_tot_pre_tax_ded,0) -
700: nvl(l_tot_invol_ded,0);
701:
702: --hr_utility.trace (' l_total_net : ' || l_total_net );
703: --hr_utility.trace (' l_tot_gross_earn : ' || l_tot_gross_earn );
704:
705: --
706: if l_tot_gross_earn <> 0 THEN

Line 703: --hr_utility.trace (' l_tot_gross_earn : ' || l_tot_gross_earn );

699: nvl(l_tot_pre_tax_ded,0) -
700: nvl(l_tot_invol_ded,0);
701:
702: --hr_utility.trace (' l_total_net : ' || l_total_net );
703: --hr_utility.trace (' l_tot_gross_earn : ' || l_tot_gross_earn );
704:
705: --
706: if l_tot_gross_earn <> 0 THEN
707:

Line 821: --hr_utility.trace (' in else of l_temp_count <> 0 : ' );

817: end if; -- end if of sort clause
818: else -- l_temp_count <> 0
819: /* This Block will be executed for First Sort Group only,so this is called only once*/
820: /*Initialize Sort Group Variables */
821: --hr_utility.trace (' in else of l_temp_count <> 0 : ' );
822:
823: l_sort1_name := detrec.sort1_name;
824: l_sort2_name := detrec.sort2_name;
825: l_sort3_name := detrec.sort3_name;

Line 832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );

828: l_sub_class := detrec.sub_class1;
829: l_temp_count := 1;
830: /*Print header details for New Sort Group */
831: /*
832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );
833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );

Line 833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );

829: l_temp_count := 1;
830: /*Print header details for New Sort Group */
831: /*
832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );
833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );

Line 834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );

830: /*Print header details for New Sort Group */
831: /*
832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );
833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );

Line 835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );

831: /*
832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );
833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
839: */

Line 836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );

832: hr_utility.trace (' in else l_temp_count : ' || l_temp_count );
833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
839: */
840:

Line 837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );

833: hr_utility.trace (' in else l_sort1_name : ' || l_sort1_name ||' , '||' detrec.sort1_name : ' || detrec.sort1_name );
834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
839: */
840:
841: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );

834: hr_utility.trace (' in else l_sort2_name : ' || l_sort2_name ||' , '||' detrec.sort2_name : ' || detrec.sort2_name );
835: hr_utility.trace (' in else l_sort3_name : ' || l_sort3_name ||' , '||' detrec.sort3_name : ' || detrec.sort3_name );
836: hr_utility.trace (' in else l_person_id : ' || l_person_id ||' , '||' detrec.person_id : ' || detrec.person_id );
837: hr_utility.trace (' in else l_class_seq : ' || l_class_seq ||' , '||' detrec.class_seq1 : ' || detrec.class_seq1 );
838: hr_utility.trace (' in else l_sub_class : ' || l_sub_class ||' , '||' detrec.sub_class1 : ' || detrec.sub_class1 );
839: */
840:
841: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
842: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||''||'';

Line 908: --hr_utility.trace (' l_countloop : ' || l_countloop );

904: This can also be done after say loop has run n times.
905: */
906: l_countloop := l_countloop + 1;
907:
908: --hr_utility.trace (' l_countloop : ' || l_countloop );
909: --hr_utility.trace (' l_countlimit : ' || l_countlimit );
910:
911: IF l_countloop >= l_countlimit THEN
912: l_countloop := 0;

Line 909: --hr_utility.trace (' l_countlimit : ' || l_countlimit );

905: */
906: l_countloop := l_countloop + 1;
907:
908: --hr_utility.trace (' l_countloop : ' || l_countloop );
909: --hr_utility.trace (' l_countlimit : ' || l_countlimit );
910:
911: IF l_countloop >= l_countlimit THEN
912: l_countloop := 0;
913: vCtr := vCtr + 1;

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

1031: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1032: end if; --l_temp_count <> 0
1033: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1034:
1035: hr_utility.trace ('Leaving '|| l_proc_name);
1036:
1037: END WRITE_DETAIL_RECORDS;
1038:
1039: /* This Procedure writes the details of Totals By Classification Region */

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

1076: l_proc_name VARCHAR2(100);
1077:
1078: BEGIN
1079: l_proc_name := g_proc_name || 'WRITE_CLASSIF_DETAILS';
1080: hr_utility.trace ('Entering '|| l_proc_name);
1081:
1082: vCtr := vCtr + 1;
1083: vXMLTable(vCtr).xmlstring := ' ';
1084: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

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

1252: end if;
1253:
1254: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1255:
1256: hr_utility.trace ('Leaving '|| l_proc_name);
1257:
1258: END WRITE_CLASSIF_DETAILS;
1259:
1260: /****************************************************************

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

1320: l_proc_name VARCHAR2(100);
1321:
1322: BEGIN
1323: l_proc_name := g_proc_name || 'WRITE_UNPAY_DETAILS';
1324: hr_utility.trace ('Entering '|| l_proc_name);
1325:
1326: vCtr := vCtr + 1;
1327: vXMLTable(vCtr).xmlstring := '';
1328: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 1344: --hr_utility.trace (' l_temp_count : ' || l_temp_count );

1340: vCtr := vCtr + 1;
1341: vXMLTable(vCtr).xmlstring := '';
1342: end if;
1343:
1344: --hr_utility.trace (' l_temp_count : ' || l_temp_count );
1345: if l_temp_count <> 0 THEN
1346: --not the first record
1347: --hr_utility.trace (' l_temp_count <> 0 ' );
1348: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class ||' , '||' krec.unpaid_sub_class1 : ' || krec.unpaid_sub_class1 );

Line 1347: --hr_utility.trace (' l_temp_count <> 0 ' );

1343:
1344: --hr_utility.trace (' l_temp_count : ' || l_temp_count );
1345: if l_temp_count <> 0 THEN
1346: --not the first record
1347: --hr_utility.trace (' l_temp_count <> 0 ' );
1348: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class ||' , '||' krec.unpaid_sub_class1 : ' || krec.unpaid_sub_class1 );
1349:
1350: if l_unpaid_class = krec.unpaid_sub_class1 THEN
1351: /*

Line 1348: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class ||' , '||' krec.unpaid_sub_class1 : ' || krec.unpaid_sub_class1 );

1344: --hr_utility.trace (' l_temp_count : ' || l_temp_count );
1345: if l_temp_count <> 0 THEN
1346: --not the first record
1347: --hr_utility.trace (' l_temp_count <> 0 ' );
1348: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class ||' , '||' krec.unpaid_sub_class1 : ' || krec.unpaid_sub_class1 );
1349:
1350: if l_unpaid_class = krec.unpaid_sub_class1 THEN
1351: /*
1352: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 ||' , '||' krec.unpaid_sort1_name : ' || krec.unpaid_sort1_name );

Line 1352: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 ||' , '||' krec.unpaid_sort1_name : ' || krec.unpaid_sort1_name );

1348: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class ||' , '||' krec.unpaid_sub_class1 : ' || krec.unpaid_sub_class1 );
1349:
1350: if l_unpaid_class = krec.unpaid_sub_class1 THEN
1351: /*
1352: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 ||' , '||' krec.unpaid_sort1_name : ' || krec.unpaid_sort1_name );
1353: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 ||' , '||' krec.unpaid_sort2_name : ' || krec.unpaid_sort2_name );
1354: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 ||' , '||' krec.unpaid_sort3_name : ' || krec.unpaid_sort3_name );
1355: */
1356: if ((l_unpaid_sort1 = krec.unpaid_sort1_name) or

Line 1353: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 ||' , '||' krec.unpaid_sort2_name : ' || krec.unpaid_sort2_name );

1349:
1350: if l_unpaid_class = krec.unpaid_sub_class1 THEN
1351: /*
1352: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 ||' , '||' krec.unpaid_sort1_name : ' || krec.unpaid_sort1_name );
1353: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 ||' , '||' krec.unpaid_sort2_name : ' || krec.unpaid_sort2_name );
1354: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 ||' , '||' krec.unpaid_sort3_name : ' || krec.unpaid_sort3_name );
1355: */
1356: if ((l_unpaid_sort1 = krec.unpaid_sort1_name) or
1357: (l_unpaid_sort1 is NULL and krec.unpaid_sort1_name is NULL)) and

Line 1354: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 ||' , '||' krec.unpaid_sort3_name : ' || krec.unpaid_sort3_name );

1350: if l_unpaid_class = krec.unpaid_sub_class1 THEN
1351: /*
1352: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 ||' , '||' krec.unpaid_sort1_name : ' || krec.unpaid_sort1_name );
1353: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 ||' , '||' krec.unpaid_sort2_name : ' || krec.unpaid_sort2_name );
1354: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 ||' , '||' krec.unpaid_sort3_name : ' || krec.unpaid_sort3_name );
1355: */
1356: if ((l_unpaid_sort1 = krec.unpaid_sort1_name) or
1357: (l_unpaid_sort1 is NULL and krec.unpaid_sort1_name is NULL)) and
1358: ((l_unpaid_sort2 = krec.unpaid_sort2_name) or

Line 1364: hr_utility.trace (' in else of sort ');

1360: ((l_unpaid_sort3 = krec.unpaid_sort3_name) or
1361: (l_unpaid_sort3 is NULL and krec.unpaid_sort3_name is NULL)) THEN
1362: NULL;
1363: else --new sort by
1364: hr_utility.trace (' in else of sort ');
1365:
1366: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1367: || '';
1368: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1387: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );

1383: l_unpaid_sort1 := krec.unpaid_sort1_name;
1384: l_unpaid_sort2 := krec.unpaid_sort2_name;
1385: l_unpaid_sort3 := krec.unpaid_sort3_name;
1386: /*
1387: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1388: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1389: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1390: */
1391: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1388: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );

1384: l_unpaid_sort2 := krec.unpaid_sort2_name;
1385: l_unpaid_sort3 := krec.unpaid_sort3_name;
1386: /*
1387: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1388: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1389: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1390: */
1391: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1392: || ''

Line 1389: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );

1385: l_unpaid_sort3 := krec.unpaid_sort3_name;
1386: /*
1387: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1388: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1389: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1390: */
1391: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1392: || ''
1393: || l_unpaid_col1||'';

Line 1417: hr_utility.trace (' in else of new classification ');

1413:
1414: end if; --new sort by
1415: else --new classification
1416:
1417: hr_utility.trace (' in else of new classification ');
1418:
1419:
1420: l_unpaid_class := krec.unpaid_sub_class1;
1421:

Line 1422: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class );

1418:
1419:
1420: l_unpaid_class := krec.unpaid_sub_class1;
1421:
1422: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class );
1423:
1424: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1425: || '';
1426: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );

1452: l_unpaid_col6 := 'Account No.';
1453: l_unpaid_col7 := 'Routing No.';
1454: end if;
1455: /*
1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );

Line 1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );

1453: l_unpaid_col7 := 'Routing No.';
1454: end if;
1455: /*
1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );

Line 1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );

1454: end if;
1455: /*
1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );

Line 1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );

1455: /*
1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1463: */

Line 1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );

1456: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1463: */
1464:

Line 1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );

1457: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1463: */
1464:
1465: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );

1458: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1459: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1460: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1461: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1462: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1463: */
1464:
1465: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1466: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1484: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );

1480: l_unpaid_sort1 := krec.unpaid_sort1_name;
1481: l_unpaid_sort2 := krec.unpaid_sort2_name;
1482: l_unpaid_sort3 := krec.unpaid_sort3_name;
1483: /*
1484: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1485: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1486: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1487: */
1488:

Line 1485: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );

1481: l_unpaid_sort2 := krec.unpaid_sort2_name;
1482: l_unpaid_sort3 := krec.unpaid_sort3_name;
1483: /*
1484: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1485: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1486: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1487: */
1488:
1489: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1486: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );

1482: l_unpaid_sort3 := krec.unpaid_sort3_name;
1483: /*
1484: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1485: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1486: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1487: */
1488:
1489: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1490: || ''

Line 1521: hr_utility.trace (' in else of new record ' );

1517:
1518: end if; -- new classification
1519: else --new record
1520:
1521: hr_utility.trace (' in else of new record ' );
1522: l_temp_count := 1;
1523:
1524: l_unpaid_class := krec.unpaid_sub_class1;
1525:

Line 1526: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class );

1522: l_temp_count := 1;
1523:
1524: l_unpaid_class := krec.unpaid_sub_class1;
1525:
1526: --hr_utility.trace (' l_unpaid_class : ' || l_unpaid_class );
1527:
1528: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1529: || '';
1530: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );

1552: l_unpaid_col6 := 'Account No.';
1553: l_unpaid_col7 := 'Routing No.';
1554: end if;
1555: /*
1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );

Line 1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );

1553: l_unpaid_col7 := 'Routing No.';
1554: end if;
1555: /*
1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );

Line 1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );

1554: end if;
1555: /*
1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );

Line 1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );

1555: /*
1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1563: */

Line 1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );

1556: hr_utility.trace (' l_unpaid_col1 : ' || l_unpaid_col1 );
1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1563: */
1564:

Line 1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );

1557: hr_utility.trace (' l_unpaid_col2 : ' || l_unpaid_col2 );
1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1563: */
1564:
1565: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );

1558: hr_utility.trace (' l_unpaid_col3 : ' || l_unpaid_col3 );
1559: hr_utility.trace (' l_unpaid_col4 : ' || l_unpaid_col4 );
1560: hr_utility.trace (' l_unpaid_col5 : ' || l_unpaid_col5 );
1561: hr_utility.trace (' l_unpaid_col6 : ' || l_unpaid_col6 );
1562: hr_utility.trace (' l_unpaid_col7 : ' || l_unpaid_col7 );
1563: */
1564:
1565: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1566: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1584: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );

1580: l_unpaid_sort1 := krec.unpaid_sort1_name;
1581: l_unpaid_sort2 := krec.unpaid_sort2_name;
1582: l_unpaid_sort3 := krec.unpaid_sort3_name;
1583: /*
1584: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1585: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1586: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1587: */
1588:

Line 1585: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );

1581: l_unpaid_sort2 := krec.unpaid_sort2_name;
1582: l_unpaid_sort3 := krec.unpaid_sort3_name;
1583: /*
1584: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1585: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1586: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1587: */
1588:
1589: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring

Line 1586: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );

1582: l_unpaid_sort3 := krec.unpaid_sort3_name;
1583: /*
1584: hr_utility.trace (' l_unpaid_sort1 : ' || l_unpaid_sort1 );
1585: hr_utility.trace (' l_unpaid_sort2 : ' || l_unpaid_sort2 );
1586: hr_utility.trace (' l_unpaid_sort3 : ' || l_unpaid_sort3 );
1587: */
1588:
1589: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring
1590: || ''

Line 1687: --hr_utility.trace (' l_countloop : ' || l_countloop );

1683: /*To restrict the increase in the number of rows in vXMLTable.
1684: This can also be done after say loop has run n times.
1685: */
1686:
1687: --hr_utility.trace (' l_countloop : ' || l_countloop );
1688: --hr_utility.trace (' l_countlimit : ' || l_countlimit );
1689:
1690: l_countloop := l_countloop + 1;
1691: IF l_countloop >= l_countlimit THEN

Line 1688: --hr_utility.trace (' l_countlimit : ' || l_countlimit );

1684: This can also be done after say loop has run n times.
1685: */
1686:
1687: --hr_utility.trace (' l_countloop : ' || l_countloop );
1688: --hr_utility.trace (' l_countlimit : ' || l_countlimit );
1689:
1690: l_countloop := l_countloop + 1;
1691: IF l_countloop >= l_countlimit THEN
1692: l_countloop := 0;

Line 1698: hr_utility.trace (' out of loop l_temp_count : ' || l_temp_count );

1694: vXMLTable(vCtr).xmlstring := ' ';
1695: END IF;
1696:
1697: end loop;
1698: hr_utility.trace (' out of loop l_temp_count : ' || l_temp_count );
1699:
1700: if l_temp_count <> 0 THEN
1701: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1702: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

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

1704:
1705: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1706: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
1707:
1708: hr_utility.trace ('Leaving '|| l_proc_name);
1709:
1710: END WRITE_UNPAY_DETAILS;
1711:
1712: /****************************************************************************

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

1723: l_err_num number;
1724: l_err_msg varchar2(300);
1725: BEGIN
1726: l_proc_name := g_proc_name || 'POPULATE_GTN_REPORT_DATA';
1727: hr_utility.trace ('Entering '|| l_proc_name);
1728:
1729: hr_utility.trace (' p_ppa_finder : '|| p_ppa_finder );
1730:
1731: get_parameters(p_ppa_finder);

Line 1729: hr_utility.trace (' p_ppa_finder : '|| p_ppa_finder );

1725: BEGIN
1726: l_proc_name := g_proc_name || 'POPULATE_GTN_REPORT_DATA';
1727: hr_utility.trace ('Entering '|| l_proc_name);
1728:
1729: hr_utility.trace (' p_ppa_finder : '|| p_ppa_finder );
1730:
1731: get_parameters(p_ppa_finder);
1732: write_header;
1733: write_detail_records(p_xfdf_blob);

Line 1752: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS in Procedure' || l_proc_name);

1748: WHEN OTHERS THEN
1749: l_err_num := SQLCODE;
1750: l_err_msg := substr(SQLERRM , 1 , 300 );
1751:
1752: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS in Procedure' || l_proc_name);
1753: HR_UTILITY.TRACE('l_err_num : ' || l_err_num );
1754: HR_UTILITY.TRACE('l_err_msg : ' || l_err_msg );
1755:
1756: END;

Line 1753: HR_UTILITY.TRACE('l_err_num : ' || l_err_num );

1749: l_err_num := SQLCODE;
1750: l_err_msg := substr(SQLERRM , 1 , 300 );
1751:
1752: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS in Procedure' || l_proc_name);
1753: HR_UTILITY.TRACE('l_err_num : ' || l_err_num );
1754: HR_UTILITY.TRACE('l_err_msg : ' || l_err_msg );
1755:
1756: END;
1757:

Line 1754: HR_UTILITY.TRACE('l_err_msg : ' || l_err_msg );

1750: l_err_msg := substr(SQLERRM , 1 , 300 );
1751:
1752: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS in Procedure' || l_proc_name);
1753: HR_UTILITY.TRACE('l_err_num : ' || l_err_num );
1754: HR_UTILITY.TRACE('l_err_msg : ' || l_err_msg );
1755:
1756: END;
1757:
1758: hr_utility.trace ('Leaving '|| l_proc_name);

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

1754: HR_UTILITY.TRACE('l_err_msg : ' || l_err_msg );
1755:
1756: END;
1757:
1758: hr_utility.trace ('Leaving '|| l_proc_name);
1759:
1760: END POPULATE_GTN_REPORT_DATA;
1761:
1762: /****************************************************************************

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

1772: l_proc_name VARCHAR2(100);
1773:
1774: BEGIN
1775: l_proc_name := g_proc_name || 'WRITE_TO_CLOB';
1776: hr_utility.trace ('Entering '|| l_proc_name);
1777:
1778: DBMS_LOB.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1779: DBMS_LOB.open(l_xfdf_string,dbms_lob.lob_readwrite);
1780:

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

1788:
1789: DBMS_LOB.createtemporary(p_xfdf_blob,TRUE);
1790: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1791:
1792: hr_utility.trace ('Leaving '|| l_proc_name);
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || l_proc_name);
1796: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

Line 1795: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || l_proc_name);

1791:
1792: hr_utility.trace ('Leaving '|| l_proc_name);
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || l_proc_name);
1796: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1797: HR_UTILITY.RAISE_ERROR;
1798: END WRITE_TO_CLOB;
1799:

Line 1796: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1792: hr_utility.trace ('Leaving '|| l_proc_name);
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || l_proc_name);
1796: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1797: HR_UTILITY.RAISE_ERROR;
1798: END WRITE_TO_CLOB;
1799:
1800: /****************************************************************************

Line 1797: HR_UTILITY.RAISE_ERROR;

1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: HR_UTILITY.TRACE('Inside Exception WHEN OTHERS of Procedure' || l_proc_name);
1796: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1797: HR_UTILITY.RAISE_ERROR;
1798: END WRITE_TO_CLOB;
1799:
1800: /****************************************************************************
1801: Name : CLOB_TO_BLOB

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

1817: l_raw_length NUMBER; /* 7182157 */
1818:
1819: BEGIN
1820: l_proc_name := g_proc_name || 'CLOB_TO_BLOB';
1821: hr_utility.trace ('Entering '|| l_proc_name);
1822:
1823: l_length_clob := dbms_lob.getlength(p_clob);
1824: l_offset := 1;
1825:

Line 1828: hr_utility.trace('l_length_clob '|| l_length_clob);

1824: l_offset := 1;
1825:
1826: WHILE l_length_clob > 0
1827: LOOP
1828: hr_utility.trace('l_length_clob '|| l_length_clob);
1829:
1830: IF l_length_clob < l_buffer_len THEN
1831: l_chunk_len := l_length_clob;
1832: ELSE

Line 1843: --hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

1839: /*Commented the following trace sentence
1840: This used to create issues when we were asking
1841: traces from the customers
1842: */
1843: --hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1844: -- DBMS_LOB.writeappend(p_blob,l_chunk_len,l_raw_buffer); /* 7182157 */
1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */
1846: l_offset := l_offset + l_chunk_len;
1847: l_length_clob := l_length_clob - l_chunk_len;

Line 1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

1845: DBMS_LOB.writeappend(p_blob,l_raw_length,l_raw_buffer); /* 7182157 */
1846: l_offset := l_offset + l_chunk_len;
1847: l_length_clob := l_length_clob - l_chunk_len;
1848:
1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1850: END LOOP;
1851:
1852: hr_utility.trace ('Leaving '|| l_proc_name);
1853: END CLOB_TO_BLOB;

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

1848:
1849: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1850: END LOOP;
1851:
1852: hr_utility.trace ('Leaving '|| l_proc_name);
1853: END CLOB_TO_BLOB;
1854:
1855: BEGIN
1856: -- hr_utility.trace_on(NULL,'trc_payusxml');

Line 1856: -- hr_utility.trace_on(NULL,'trc_payusxml');

1852: hr_utility.trace ('Leaving '|| l_proc_name);
1853: END CLOB_TO_BLOB;
1854:
1855: BEGIN
1856: -- hr_utility.trace_on(NULL,'trc_payusxml');
1857: g_proc_name := 'PAY_US_XDO_REPORT.';
1858:
1859: END PAY_US_XDO_REPORT;