' || p_input_string ||

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

194: if p_output_file_type = 'CSV' then
195: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
196: lv_format := p_input_string;
197: elsif p_output_file_type = 'HTML' then
198: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
199: lv_format := '

' || p_input_string ||
200: '

';
201: end if;
202:

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

199: lv_format := '

' || p_input_string ||
200: '

';
201: end if;
202:
203: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
204: return lv_format;
205:
206: END formated_header_string;
207:

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

260: if lv_ssl_number IS NULL
261: then
262: lv_ssl_number := 'National Identifier';
263: end if;
264: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
265:
266: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
267: lv_format1 :=
268: formated_data_string (p_input_string =>

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

262: lv_ssl_number := 'National Identifier';
263: end if;
264: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
265:
266: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
267: lv_format1 :=
268: formated_data_string (p_input_string =>
269: hr_general.decode_fnd_comm_lookup
270: ('PAYROLL_REPORTS', --lookup_type

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

320: ,p_bold => 'Y'
321: ,p_output_file_type => p_output_file_type)
322: ;
323:
324: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
325: lv_format2 :=
326: formated_data_string (p_input_string =>
327: hr_general.decode_fnd_comm_lookup
328: ('PAYROLL_REPORTS', --lookup_type

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

408: /*******************************************************************
409: ** Print the User Defined data for each Employee Assignment at the
410: ** end of the report
411: *******************************************************************/
412: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
413:
414: /*******************************************************************
415: ** Only do this if there is some configuration data present
416: *******************************************************************/

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

430: end if;
431:
432: p_static_label1 := lv_format1;
433: p_static_label2 := lv_format2;
434: hr_utility.trace('Static Label1 = ' || lv_format1);
435: hr_utility.trace('Static Label2 = ' || lv_format2);
436: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
437:
438: END;

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

431:
432: p_static_label1 := lv_format1;
433: p_static_label2 := lv_format2;
434: hr_utility.trace('Static Label1 = ' || lv_format1);
435: hr_utility.trace('Static Label2 = ' || lv_format2);
436: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
437:
438: END;
439:

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

432: p_static_label1 := lv_format1;
433: p_static_label2 := lv_format2;
434: hr_utility.trace('Static Label1 = ' || lv_format1);
435: hr_utility.trace('Static Label2 = ' || lv_format2);
436: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
437:
438: END;
439:
440:

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

491: := to_char(p_action_effective_date, 'dd-MON-yyyy');
492:
493: BEGIN
494:
495: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
496: lv_format1 :=
497: formated_data_string (p_input_string => p_emp_last_name
498: ,p_output_file_type => p_output_file_type) ||
499: formated_data_string (p_input_string => p_emp_first_name

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

511: formated_data_string (p_input_string => lv_action_effective_date
512: ,p_output_file_type => p_output_file_type)
513: ;
514:
515: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
516: lv_format2 :=
517: formated_data_string (p_input_string => p_payroll_name
518: ,p_output_file_type => p_output_file_type) ||
519: formated_data_string (p_input_string => p_gre_name

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

541: /*******************************************************************
542: ** Print the User Defined data for each Employee Assignment at the
543: ** end of the report
544: *******************************************************************/
545: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
546:
547: /*******************************************************************
548: ** Only do this if there is some configuration data present
549: *******************************************************************/

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

561: end if;
562:
563: p_static_data1 := lv_format1;
564: p_static_data2 := lv_format2;
565: hr_utility.trace('Static Data1 = ' || lv_format1);
566: hr_utility.trace('Static Data2 = ' || lv_format2);
567: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
568:
569: END;

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

562:
563: p_static_data1 := lv_format1;
564: p_static_data2 := lv_format2;
565: hr_utility.trace('Static Data1 = ' || lv_format1);
566: hr_utility.trace('Static Data2 = ' || lv_format2);
567: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
568:
569: END;
570:

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

563: p_static_data1 := lv_format1;
564: p_static_data2 := lv_format2;
565: hr_utility.trace('Static Data1 = ' || lv_format1);
566: hr_utility.trace('Static Data2 = ' || lv_format2);
567: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
568:
569: END;
570:
571: FUNCTION get_element_set_where_clause (p_element_set_id in number)

Line 1042: -- hr_utility.trace_on (null,'pyelerep');

1038:
1039: ltr_elements tab_element;
1040:
1041: BEGIN
1042: -- hr_utility.trace_on (null,'pyelerep');
1043:
1044: hr_utility.set_location(gv_package_name || '.element_extract', 10);
1045:
1046: formated_static_header( p_output_file_type

Line 1044: hr_utility.set_location(gv_package_name || '.element_extract', 10);

1040:
1041: BEGIN
1042: -- hr_utility.trace_on (null,'pyelerep');
1043:
1044: hr_utility.set_location(gv_package_name || '.element_extract', 10);
1045:
1046: formated_static_header( p_output_file_type
1047: ,lv_header_label1
1048: ,lv_header_label2

Line 1054: hr_utility.set_location(gv_package_name || '.element_extract', 20);

1050:
1051: lv_header_label := lv_header_label1;
1052:
1053: if p_element_set_id is not null then
1054: hr_utility.set_location(gv_package_name || '.element_extract', 20);
1055: open c_set_elements( p_element_set_id
1056: ,p_business_group_id
1057: ,fnd_date.canonical_to_date(p_start_date)
1058: ,fnd_date.canonical_to_date(p_end_date)

Line 1061: hr_utility.set_location(gv_package_name || '.element_extract', 30);

1057: ,fnd_date.canonical_to_date(p_start_date)
1058: ,fnd_date.canonical_to_date(p_end_date)
1059: );
1060: elsif p_element_classification_id is not null then
1061: hr_utility.set_location(gv_package_name || '.element_extract', 30);
1062: open c_class_elements( p_element_classification_id
1063: ,p_business_group_id
1064: ,fnd_date.canonical_to_date(p_start_date)
1065: ,fnd_date.canonical_to_date(p_end_date)

Line 1068: hr_utility.set_location(gv_package_name || '.element_extract', 40);

1064: ,fnd_date.canonical_to_date(p_start_date)
1065: ,fnd_date.canonical_to_date(p_end_date)
1066: );
1067: elsif p_element_type_id is not null then
1068: hr_utility.set_location(gv_package_name || '.element_extract', 40);
1069: open c_elements(p_element_type_id);
1070: end if;
1071:
1072: hr_utility.set_location(gv_package_name || '.element_extract', 50);

Line 1072: hr_utility.set_location(gv_package_name || '.element_extract', 50);

1068: hr_utility.set_location(gv_package_name || '.element_extract', 40);
1069: open c_elements(p_element_type_id);
1070: end if;
1071:
1072: hr_utility.set_location(gv_package_name || '.element_extract', 50);
1073: loop
1074: if p_element_set_id is not null then
1075: fetch c_set_elements into lv_element_name;
1076: hr_utility.trace(' lv_element_name 1 : ' || lv_element_name );

Line 1076: hr_utility.trace(' lv_element_name 1 : ' || lv_element_name );

1072: hr_utility.set_location(gv_package_name || '.element_extract', 50);
1073: loop
1074: if p_element_set_id is not null then
1075: fetch c_set_elements into lv_element_name;
1076: hr_utility.trace(' lv_element_name 1 : ' || lv_element_name );
1077: if c_set_elements%notfound then
1078: exit;
1079: end if;
1080: elsif p_element_classification_id is not null then

Line 1082: hr_utility.trace(' lv_element_name 2 : ' || lv_element_name );

1078: exit;
1079: end if;
1080: elsif p_element_classification_id is not null then
1081: fetch c_class_elements into lv_element_name;
1082: hr_utility.trace(' lv_element_name 2 : ' || lv_element_name );
1083: if c_class_elements%notfound then
1084: exit;
1085: end if;
1086: elsif p_element_type_id is not null then

Line 1088: hr_utility.trace(' lv_element_name 3 : ' || lv_element_name );

1084: exit;
1085: end if;
1086: elsif p_element_type_id is not null then
1087: fetch c_elements into lv_element_name;
1088: hr_utility.trace(' lv_element_name 3 : ' || lv_element_name );
1089: if c_elements%notfound then
1090: exit;
1091: end if;
1092: end if;

Line 1104: hr_utility.set_location(gv_package_name || '.element_extract', 60);

1100: ,p_output_file_type
1101: ,'Y');
1102:
1103: end loop;
1104: hr_utility.set_location(gv_package_name || '.element_extract', 60);
1105:
1106: if p_element_set_id is not null then
1107: close c_set_elements;
1108: elsif p_element_classification_id is not null then

Line 1114: hr_utility.set_location(gv_package_name || '.element_extract', 70);

1110: elsif p_element_type_id is not null then
1111: close c_elements;
1112: end if;
1113:
1114: hr_utility.set_location(gv_package_name || '.element_extract', 70);
1115: /****************************************************************
1116: ** Concatnating the second Header Label which includes the User
1117: ** Defined data set so that it is printed at the end of the
1118: ** report.

Line 1122: hr_utility.set_location(gv_package_name || '.element_extract', 80);

1118: ** report.
1119: ****************************************************************/
1120: lv_header_label := lv_header_label || lv_header_label2;
1121:
1122: hr_utility.set_location(gv_package_name || '.element_extract', 80);
1123: hr_utility.trace('Static and Element Label = ' || lv_header_label);
1124:
1125: gv_title := hr_general.decode_fnd_comm_lookup
1126: ('PAYROLL_REPORTS',

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

1119: ****************************************************************/
1120: lv_header_label := lv_header_label || lv_header_label2;
1121:
1122: hr_utility.set_location(gv_package_name || '.element_extract', 80);
1123: hr_utility.trace('Static and Element Label = ' || lv_header_label);
1124:
1125: gv_title := hr_general.decode_fnd_comm_lookup
1126: ('PAYROLL_REPORTS',
1127: 'ELEMENT_REGISTER_TITLE');

Line 1134: hr_utility.set_location(gv_package_name || '.element_extract', 90);

1130: gv_title
1131: ,p_output_file_type
1132: ));
1133:
1134: hr_utility.set_location(gv_package_name || '.element_extract', 90);
1135: /****************************************************************
1136: ** Print the Header Information. If the format is HTML then open
1137: ** the body and table before printing the header info, otherwise
1138: ** just print the header information.

Line 1152: hr_utility.set_location(gv_package_name || '.element_extract', 100);

1148: if p_output_file_type ='HTML' then
1149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1150: end if;
1151:
1152: hr_utility.set_location(gv_package_name || '.element_extract', 100);
1153: /*****************************************************
1154: ** Start of the Data Section of the Report
1155: *****************************************************/
1156: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);

Line 1156: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);

1152: hr_utility.set_location(gv_package_name || '.element_extract', 100);
1153: /*****************************************************
1154: ** Start of the Data Section of the Report
1155: *****************************************************/
1156: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1157:
1158: if p_element_classification_id is not null then
1159: lv_element_cls_where_clause
1160: := 'pet.classification_id = ' || p_element_classification_id;

Line 1221: hr_utility.set_location(gv_package_name || '.element_extract', 105);

1217: ,lv_assignment_number
1218: ,lv_employment_category_code;
1219:
1220: if c_assignments%notfound then
1221: hr_utility.set_location(gv_package_name || '.element_extract', 105);
1222: exit;
1223: end if;
1224: /*
1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );

Line 1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );

1221: hr_utility.set_location(gv_package_name || '.element_extract', 105);
1222: exit;
1223: end if;
1224: /*
1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );

Line 1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );

1222: exit;
1223: end if;
1224: /*
1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );

Line 1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );

1223: end if;
1224: /*
1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );

Line 1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );

1224: /*
1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );

Line 1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );

1225: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );

Line 1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );

1226: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );

Line 1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );

1227: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );

Line 1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );

1228: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );

Line 1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );

1229: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );

Line 1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );

1230: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );

Line 1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );

1231: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );

Line 1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );

1232: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );

Line 1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );

1233: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );

Line 1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );

1234: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );

Line 1239: hr_utility.trace(' lv_gender : ' || lv_gender );

1235: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );

Line 1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );

1236: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1244: */

Line 1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );

1237: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1244: */
1245: BEGIN

Line 1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );

1238: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1244: */
1245: BEGIN
1246:

Line 1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );

1239: hr_utility.trace(' lv_gender : ' || lv_gender );
1240: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1241: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1242: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1243: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1244: */
1245: BEGIN
1246:
1247: select hou_org.name

Line 1298: hr_utility.set_location(gv_package_name || '.element_extract', 110);

1294: ** If Assignment Set is used, pick up only those employee
1295: ** assignments which are part of the Assignment Set - STATIC
1296: ** or DYNAMIC.
1297: ************************************************************/
1298: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1299: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1300: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1301:
1302: if hr_assignment_set.assignment_in_set(

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

1295: ** assignments which are part of the Assignment Set - STATIC
1296: ** or DYNAMIC.
1297: ************************************************************/
1298: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1299: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1300: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1301:
1302: if hr_assignment_set.assignment_in_set(
1303: p_assignment_set_id

Line 1300: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

1296: ** or DYNAMIC.
1297: ************************************************************/
1298: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1299: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1300: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1301:
1302: if hr_assignment_set.assignment_in_set(
1303: p_assignment_set_id
1304: ,ln_assignment_id) = 'Y' then

Line 1307: hr_utility.set_location(gv_package_name || '.element_extract', 120);

1303: p_assignment_set_id
1304: ,ln_assignment_id) = 'Y' then
1305:
1306:
1307: hr_utility.set_location(gv_package_name || '.element_extract', 120);
1308: /********************************************************************
1309: ** Populate the user defined PL/SQL table to print the additional
1310: ** columns in the report.
1311: ********************************************************************/

Line 1323: hr_utility.set_location(gv_package_name || '.element_extract', 125);

1319: open c_employment_category(lv_employment_category_code);
1320: fetch c_employment_category into lv_employment_category;
1321: close c_employment_category;
1322:
1323: hr_utility.set_location(gv_package_name || '.element_extract', 125);
1324: formated_static_data(
1325: lv_action_type
1326: ,ld_effective_date
1327: ,lv_payroll_name

Line 1349: hr_utility.set_location(gv_package_name || '.element_extract', 130);

1345: ,lv_data_row1
1346: ,lv_data_row2);
1347:
1348: lv_data_row := lv_data_row1;
1349: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));

Line 1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));

1346: ,lv_data_row2);
1347:
1348: lv_data_row := lv_data_row1;
1349: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));
1354: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));

Line 1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

1347:
1348: lv_data_row := lv_data_row1;
1349: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));
1354: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1355: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));

Line 1352: hr_utility.trace('Classification ID = ' ||

1348: lv_data_row := lv_data_row1;
1349: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));
1354: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1355: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1356:

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

1350: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));
1354: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1355: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1356:
1357: -- Bug 3731178 -- Added NVL in select so that element
1358: -- name is fetched if reporting name is NULL.

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

1351: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1352: hr_utility.trace('Classification ID = ' ||
1353: nvl(to_char(p_element_classification_id), 'NULL'));
1354: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1355: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1356:
1357: -- Bug 3731178 -- Added NVL in select so that element
1358: -- name is fetched if reporting name is NULL.
1359: -- Also added a decode for garn elements.

Line 1449: hr_utility.set_location(gv_package_name || '.element_extract', 140);

1445: ,ld_effective_date
1446: ,ln_assignment_action_id
1447: ,ld_effective_date;
1448:
1449: hr_utility.set_location(gv_package_name || '.element_extract', 140);
1450: loop
1451: fetch c_element_results into lv_element_name
1452: ,lv_element_value
1453: ,lv_element_status

Line 1456: hr_utility.set_location(gv_package_name || '.element_extract', 150);

1452: ,lv_element_value
1453: ,lv_element_status
1454: ,ln_run_result_id;
1455: if c_element_results%notfound then
1456: hr_utility.set_location(gv_package_name || '.element_extract', 150);
1457: exit;
1458: end if;
1459:
1460: hr_utility.trace('Element Name = ' || lv_element_name ||

Line 1460: hr_utility.trace('Element Name = ' || lv_element_name ||

1456: hr_utility.set_location(gv_package_name || '.element_extract', 150);
1457: exit;
1458: end if;
1459:
1460: hr_utility.trace('Element Name = ' || lv_element_name ||
1461: ' Value = ' || lv_element_value);
1462: for i in ltr_elements.first .. ltr_elements.last loop
1463: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1464: if ltr_elements(i).element_name = lv_element_name then

Line 1463: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);

1459:
1460: hr_utility.trace('Element Name = ' || lv_element_name ||
1461: ' Value = ' || lv_element_value);
1462: for i in ltr_elements.first .. ltr_elements.last loop
1463: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1464: if ltr_elements(i).element_name = lv_element_name then
1465: hr_utility.set_location(gv_package_name || '.element_extract', 155);
1466:
1467: /*******************************************************************

Line 1465: hr_utility.set_location(gv_package_name || '.element_extract', 155);

1461: ' Value = ' || lv_element_value);
1462: for i in ltr_elements.first .. ltr_elements.last loop
1463: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1464: if ltr_elements(i).element_name = lv_element_name then
1465: hr_utility.set_location(gv_package_name || '.element_extract', 155);
1466:
1467: /*******************************************************************
1468: Bug 4214739 Checked if element status is 'R' - Replaced then there is no need to
1469: add the value so made lv_element_value 0

Line 1494: hr_utility.set_location(gv_package_name || '.element_extract', 160);

1490: /*******************************************************************
1491: ** Do Not Print records of an employee, if the employee has non of
1492: ** the elements which are picked up by the report.
1493: *******************************************************************/
1494: hr_utility.set_location(gv_package_name || '.element_extract', 160);
1495: if ltr_elements.count > 0 then
1496: for i in ltr_elements.first .. ltr_elements.last loop
1497: if ltr_elements(i).value is not null then
1498: hr_utility.set_location(gv_package_name || '.element_extract', 165);

Line 1498: hr_utility.set_location(gv_package_name || '.element_extract', 165);

1494: hr_utility.set_location(gv_package_name || '.element_extract', 160);
1495: if ltr_elements.count > 0 then
1496: for i in ltr_elements.first .. ltr_elements.last loop
1497: if ltr_elements(i).value is not null then
1498: hr_utility.set_location(gv_package_name || '.element_extract', 165);
1499: lb_print_row := TRUE;
1500: exit;
1501: end if;
1502: end loop;

Line 1510: hr_utility.set_location(gv_package_name || '.element_extract', 170);

1506: ** If there is atleast one column which needs to be printed, print
1507: ** the entire row.
1508: *******************************************************************/
1509: if lb_print_row then
1510: hr_utility.set_location(gv_package_name || '.element_extract', 170);
1511: for i in ltr_elements.first .. ltr_elements.last loop
1512: lv_data_row := lv_data_row ||
1513: formated_data_string (
1514: p_input_string => ltr_elements(i).value

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

1558:
1559: if p_output_file_type ='HTML' then
1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1561: end if;
1562: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
1563:
1564:
1565: /**********************************************************
1566: ** Not Required as the output file type is HTML by default

Line 1581: --hr_utility.trace_on(null, 'ELE');

1577:
1578: END element_extract;
1579:
1580: --begin
1581: --hr_utility.trace_on(null, 'ELE');
1582: end pay_element_extract_pkg;