DBA Data[Home] [Help]

APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on HR_UTILITY

Line 36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

32:
33: lv_format varchar2(1000);
34:
35: BEGIN
36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
37: if p_output_file_type = 'CSV' then
38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
39: lv_format := gc_csv_data_delimiter || p_input_string ||
40: gc_csv_data_delimiter || gc_csv_delimiter;

Line 38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

34:
35: BEGIN
36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
37: if p_output_file_type = 'CSV' then
38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
39: lv_format := gc_csv_data_delimiter || p_input_string ||
40: gc_csv_data_delimiter || gc_csv_delimiter;
41: elsif p_output_file_type = 'HTML' then
42: if p_input_string is null then

Line 43: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);

39: lv_format := gc_csv_data_delimiter || p_input_string ||
40: gc_csv_data_delimiter || gc_csv_delimiter;
41: elsif p_output_file_type = 'HTML' then
42: if p_input_string is null then
43: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
44: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
45: else
46: if p_bold = 'Y' then
47: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

Line 47: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

43: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
44: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
45: else
46: if p_bold = 'Y' then
47: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
48: lv_format := gv_html_start_data || ' ' || p_input_string
49: || '' || gv_html_end_data;
50: else
51: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

Line 51: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

47: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
48: lv_format := gv_html_start_data || ' ' || p_input_string
49: || '' || gv_html_end_data;
50: else
51: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
52: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
53: end if;
54: end if;
55: end if;

Line 57: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

53: end if;
54: end if;
55: end if;
56:
57: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
58: return lv_format;
59:
60: END formated_data_string;
61:

Line 74: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

70: RETURN VARCHAR2
71: IS
72: lv_format varchar2(1000);
73: BEGIN
74: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
75: if p_output_file_type = 'CSV' then
76: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
77: lv_format := p_input_string;
78: elsif p_output_file_type = 'HTML' then

Line 76: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);

72: lv_format varchar2(1000);
73: BEGIN
74: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
75: if p_output_file_type = 'CSV' then
76: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
77: lv_format := p_input_string;
78: elsif p_output_file_type = 'HTML' then
79: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
80: lv_format := '

' || p_input_string ||

Line 79: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);

75: if p_output_file_type = 'CSV' then
76: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
77: lv_format := p_input_string;
78: elsif p_output_file_type = 'HTML' then
79: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
80: lv_format := '

' || p_input_string ||
81: '

';
82: end if;
83: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

Line 83: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

79: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
80: lv_format := '

' || p_input_string ||
81: '

';
82: end if;
83: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
84: return lv_format;
85: END formated_header_string;
86:
87:

Line 144: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);

140: if lv_ssl_number IS NULL
141: then
142: lv_ssl_number := 'National Identifier';
143: end if;
144: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
145:
146:
147: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
148: lv_format1 :=

Line 147: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

143: end if;
144: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
145:
146:
147: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
148: lv_format1 :=
149: formated_data_string (p_input_string =>
150: hr_general.decode_fnd_comm_lookup
151: ('PAYROLL_REPORTS', --lookup_type

Line 229: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);

225: ,p_bold => 'Y'
226: ,p_output_file_type => p_output_file_type) ;
227:
228:
229: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
230: lv_format2 :=
231: formated_data_string (p_input_string =>
232: hr_general.decode_fnd_comm_lookup
233: ('PAYROLL_REPORTS', --lookup_type

Line 270: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);

266: ,p_bold => 'Y'
267: ,p_output_file_type => p_output_file_type)
268: ;
269:
270: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
271:
272: p_static_label1 := lv_format1;
273: p_static_label2 := lv_format2;
274: hr_utility.trace('Static Label1 = ' || lv_format1);

Line 274: hr_utility.trace('Static Label1 = ' || lv_format1);

270: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
271:
272: p_static_label1 := lv_format1;
273: p_static_label2 := lv_format2;
274: hr_utility.trace('Static Label1 = ' || lv_format1);
275: hr_utility.trace('Static Label2 = ' || lv_format2);
276: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
277:
278: END formated_static_header;

Line 275: hr_utility.trace('Static Label2 = ' || lv_format2);

271:
272: p_static_label1 := lv_format1;
273: p_static_label2 := lv_format2;
274: hr_utility.trace('Static Label1 = ' || lv_format1);
275: hr_utility.trace('Static Label2 = ' || lv_format2);
276: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
277:
278: END formated_static_header;
279:

Line 276: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

272: p_static_label1 := lv_format1;
273: p_static_label2 := lv_format2;
274: hr_utility.trace('Static Label1 = ' || lv_format1);
275: hr_utility.trace('Static Label2 = ' || lv_format2);
276: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
277:
278: END formated_static_header;
279:
280:

Line 329: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

325: lv_action_effective_date varchar2(20);
326:
327: BEGIN
328:
329: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
330: lv_action_effective_date := to_char(p_action_effective_date, 'dd-MON-yyyy');
331: lv_format1 :=
332: formated_data_string (p_input_string => p_consolidation_set_name
333: ,p_output_file_type => p_output_file_type) ||

Line 362: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

358: formated_data_string (p_input_string => p_accrual_type
359: ,p_output_file_type => p_output_file_type)
360: ;
361:
362: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
363:
364: lv_format2 :=
365: formated_data_string (p_input_string => p_org_name
366: ,p_output_file_type => p_output_file_type) ||

Line 384: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);

380: formated_data_string (p_input_string => p_assignment_number
381: ,p_output_file_type => p_output_file_type)
382: ;
383:
384: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
385:
386: p_static_data1 := lv_format1;
387: p_static_data2 := lv_format2;
388: hr_utility.trace('Static Data1 = ' || lv_format1);

Line 388: hr_utility.trace('Static Data1 = ' || lv_format1);

384: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
385:
386: p_static_data1 := lv_format1;
387: p_static_data2 := lv_format2;
388: hr_utility.trace('Static Data1 = ' || lv_format1);
389: hr_utility.trace('Static Data2 = ' || lv_format2);
390: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
391:
392: END;

Line 389: hr_utility.trace('Static Data2 = ' || lv_format2);

385:
386: p_static_data1 := lv_format1;
387: p_static_data2 := lv_format2;
388: hr_utility.trace('Static Data1 = ' || lv_format1);
389: hr_utility.trace('Static Data2 = ' || lv_format2);
390: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
391:
392: END;
393:

Line 390: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

386: p_static_data1 := lv_format1;
387: p_static_data2 := lv_format2;
388: hr_utility.trace('Static Data1 = ' || lv_format1);
389: hr_utility.trace('Static Data2 = ' || lv_format2);
390: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
391:
392: END;
393:
394: /******************************************************************

Line 598: hr_utility.trace('Cost Type = ' || p_cost_type);

594: c_clause1 varchar2(5000); --to store the optional where clause (Bug 3179050)
595:
596: BEGIN
597:
598: hr_utility.trace('Cost Type = ' || p_cost_type);
599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);

Line 599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);

595:
596: BEGIN
597:
598: hr_utility.trace('Cost Type = ' || p_cost_type);
599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));

Line 600: hr_utility.trace('Start Date = ' || p_start_date);

596: BEGIN
597:
598: hr_utility.trace('Cost Type = ' || p_cost_type);
599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));

Line 601: hr_utility.trace('End Date = ' || p_end_date);

597:
598: hr_utility.trace('Cost Type = ' || p_cost_type);
599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));

Line 602: hr_utility.trace('Business Group ID = '|| p_business_group_id);

598: hr_utility.trace('Cost Type = ' || p_cost_type);
599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);

Line 603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));

599: hr_utility.set_location(gv_package_name || '.costing_extract', 10);
600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);

Line 604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));

600: hr_utility.trace('Start Date = ' || p_start_date);
601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);

Line 605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));

601: hr_utility.trace('End Date = ' || p_end_date);
602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);

Line 606: hr_utility.trace('Person ID = ' || p_person_id);

602: hr_utility.trace('Business Group ID = '|| p_business_group_id);
603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);

Line 607: hr_utility.trace('Location ID = ' || p_location_id);

603: hr_utility.trace('Classification ID = '|| nvl(to_char(p_element_classification_id), 'NULL'));
604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);

Line 608: hr_utility.trace('Organization ID = ' || p_organization_id);

604: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);

Line 609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);

605: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);
613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);

Line 610: hr_utility.trace('Payroll ID = ' || p_payroll_id);

606: hr_utility.trace('Person ID = ' || p_person_id);
607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);
613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);
614:

Line 611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);

607: hr_utility.trace('Location ID = ' || p_location_id);
608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);
613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);
614:
615: /* Added by ssmukher for Bug 4142845 */

Line 612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);

608: hr_utility.trace('Organization ID = ' || p_organization_id);
609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);
613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);
614:
615: /* Added by ssmukher for Bug 4142845 */
616: open c_leg_code(p_business_group_id);

Line 613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);

609: hr_utility.trace('Tax Unit ID = ' || p_tax_unit_id);
610: hr_utility.trace('Payroll ID = ' || p_payroll_id);
611: hr_utility.trace('Consolidation ID = ' || p_consolidation_set_id);
612: hr_utility.trace('Asgn Set ID = ' || p_assignment_set_id);
613: hr_utility.set_location(gv_package_name || '.costing_extract', 20);
614:
615: /* Added by ssmukher for Bug 4142845 */
616: open c_leg_code(p_business_group_id);
617: fetch c_leg_code into lv_legislation_code;

Line 637: hr_utility.set_location(gv_package_name || '.costing_extract', 30);

633: ,p_business_group_id);
634:
635: lv_header_label := lv_header_label1;
636:
637: hr_utility.set_location(gv_package_name || '.costing_extract', 30);
638: lv_header_label := lv_header_label ||
639: formated_data_string (
640: p_input_string => 'Accrual Type'
641: ,p_bold => 'Y'

Line 647: hr_utility.set_location(gv_package_name || '.costing_extract', 40);

643:
644: open c_costing_flex_id (p_business_group_id);
645: fetch c_costing_flex_id into ln_costing_id_flex_num;
646: if c_costing_flex_id%found then
647: hr_utility.set_location(gv_package_name || '.costing_extract', 40);
648: open c_costing_flex_segments (ln_costing_id_flex_num);
649: loop
650: fetch c_costing_flex_segments into lv_segment_name, lv_column_name;
651: if c_costing_flex_segments%notfound then

Line 669: hr_utility.set_location(gv_package_name || '.costing_extract', 50);

665: close c_costing_flex_segments;
666:
667: end if;
668: close c_costing_flex_id;
669: hr_utility.set_location(gv_package_name || '.costing_extract', 50);
670:
671: /****************************************************************
672: ** Concatnating the second Header Label which includes the
673: ** data set which has to be printed at the end of the report.

Line 677: hr_utility.set_location(gv_package_name || '.costing_extract', 60);

673: ** data set which has to be printed at the end of the report.
674: ****************************************************************/
675: lv_header_label := lv_header_label || lv_header_label2;
676:
677: hr_utility.set_location(gv_package_name || '.costing_extract', 60);
678: hr_utility.trace('Static and Element Label = ' || lv_header_label);
679:
680: gv_title := hr_general.decode_fnd_comm_lookup
681: ('PAYROLL_REPORTS',

Line 678: hr_utility.trace('Static and Element Label = ' || lv_header_label);

674: ****************************************************************/
675: lv_header_label := lv_header_label || lv_header_label2;
676:
677: hr_utility.set_location(gv_package_name || '.costing_extract', 60);
678: hr_utility.trace('Static and Element Label = ' || lv_header_label);
679:
680: gv_title := hr_general.decode_fnd_comm_lookup
681: ('PAYROLL_REPORTS',
682: 'COSTING_REPORT_TITLE');

Line 689: hr_utility.set_location(gv_package_name || '.costing_extract', 70);

685: gv_title
686: ,p_output_file_type
687: ));
688:
689: hr_utility.set_location(gv_package_name || '.costing_extract', 70);
690: /****************************************************************
691: ** Print the Header Information. If the format is HTML then open
692: ** the body and table before printing the header info, otherwise
693: ** just print the header information.

Line 707: hr_utility.set_location(gv_package_name || '.costing_extract', 80);

703: if p_output_file_type ='HTML' then
704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
705: end if;
706:
707: hr_utility.set_location(gv_package_name || '.costing_extract', 80);
708: /*****************************************************
709: ** Start of the Data Section of the Report
710: *****************************************************/
711: /*Bug 3179050 - changed cursor c_asg_costing_details to a REF CURSOR*/

Line 1157: hr_utility.set_location(gv_package_name || '.costing_extract', 90);

1153: ,lv_segment30
1154: ;
1155:
1156: if c_asg_costing_details%notfound then
1157: hr_utility.set_location(gv_package_name || '.costing_extract', 90);
1158: exit;
1159: end if;
1160:
1161: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');

Line 1171: hr_utility.set_location(gv_package_name || '.costing_extract', 100);

1167: ** If Assignment Set is used, pick up only those employee
1168: ** assignments which are part of the Assignment Set - STATIC
1169: ** or DYNAMIC.
1170: ************************************************************/
1171: hr_utility.set_location(gv_package_name || '.costing_extract', 100);
1172: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1173:
1174: if hr_assignment_set.assignment_in_set(
1175: p_assignment_set_id

Line 1172: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1168: ** assignments which are part of the Assignment Set - STATIC
1169: ** or DYNAMIC.
1170: ************************************************************/
1171: hr_utility.set_location(gv_package_name || '.costing_extract', 100);
1172: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1173:
1174: if hr_assignment_set.assignment_in_set(
1175: p_assignment_set_id
1176: ,ln_assignment_id) = 'Y' then

Line 1179: hr_utility.set_location(gv_package_name || '.costing_extract', 110);

1175: p_assignment_set_id
1176: ,ln_assignment_id) = 'Y' then
1177:
1178:
1179: hr_utility.set_location(gv_package_name || '.costing_extract', 110);
1180:
1181: formated_static_data(
1182: p_consolidation_set_name => lv_consolidation_set_name
1183: ,p_payroll_name => lv_payroll_name

Line 1207: hr_utility.set_location(gv_package_name || '.costing_extract', 120);

1203: ,p_static_data1 => lv_data_row1
1204: ,p_static_data2 => lv_data_row2);
1205:
1206: lv_data_row := lv_data_row1;
1207: hr_utility.set_location(gv_package_name || '.costing_extract', 120);
1208:
1209: for i in ltr_costing_segment.first .. ltr_costing_segment.last loop
1210: if ltr_costing_segment(i).column_name = 'SEGMENT1' then
1211: lv_segment_value := lv_segment1;

Line 1277: hr_utility.set_location(gv_package_name || '.costing_extract', 130);

1273: formated_data_string (
1274: p_input_string => lv_segment_value
1275: ,p_output_file_type => p_output_file_type);
1276: end loop ;
1277: hr_utility.set_location(gv_package_name || '.costing_extract', 130);
1278:
1279: /****************************************************************
1280: ** Concatnating the second Header Label which includes the
1281: ** data set which is printed at the end of the report.

Line 1284: hr_utility.set_location(gv_package_name || '.costing_extract', 140);

1280: ** Concatnating the second Header Label which includes the
1281: ** data set which is printed at the end of the report.
1282: ****************************************************************/
1283: lv_data_row := lv_data_row || lv_data_row2;
1284: hr_utility.set_location(gv_package_name || '.costing_extract', 140);
1285:
1286: if p_output_file_type ='HTML' then
1287: lv_data_row := '' || lv_data_row || '' ;
1288: end if;

Line 1310: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);

1306:
1307: if p_output_file_type ='HTML' then
1308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1309: end if;
1310: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
1311:
1312: END costing_extract;
1313:
1314: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,

Line 1362: --hr_utility.trace_on(null, 'COSTING');

1358: g_tax_unit_name(p_tax_unit_id) := l_tax_unit_name;
1359: return l_tax_unit_name;
1360: END;
1361: --begin
1362: --hr_utility.trace_on(null, 'COSTING');
1363: end pay_costing_detail_rep_pkg;