' || p_input_string ||

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

203: if p_output_file_type = 'CSV' then
204: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
205: lv_format := p_input_string;
206: elsif p_output_file_type = 'HTML' then
207: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
208: lv_format := '

' || p_input_string ||
209: '

';
210: end if;
211:

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

208: lv_format := '

' || p_input_string ||
209: '

';
210: end if;
211:
212: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
213: return lv_format;
214:
215: END formated_header_string;
216:

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

269: if lv_ssl_number IS NULL
270: then
271: lv_ssl_number := 'National Identifier';
272: end if;
273: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
274:
275: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
276: lv_format1 :=
277: formated_data_string (p_input_string =>

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

271: lv_ssl_number := 'National Identifier';
272: end if;
273: hr_utility.trace('HR_NATIONAL_ID_NUMBER_'||lv_legislation_code ||' = ' || lv_ssl_number);
274:
275: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
276: lv_format1 :=
277: formated_data_string (p_input_string =>
278: hr_general.decode_fnd_comm_lookup
279: ('PAYROLL_REPORTS', --lookup_type

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

329: ,p_bold => 'Y'
330: ,p_output_file_type => p_output_file_type)
331: ;
332:
333: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
334: lv_format2 :=
335: formated_data_string (p_input_string =>
336: hr_general.decode_fnd_comm_lookup
337: ('PAYROLL_REPORTS', --lookup_type

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

417: /*******************************************************************
418: ** Print the User Defined data for each Employee Assignment at the
419: ** end of the report
420: *******************************************************************/
421: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
422:
423: /*******************************************************************
424: ** Only do this if there is some configuration data present
425: *******************************************************************/

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

439: end if;
440:
441: p_static_label1 := lv_format1;
442: p_static_label2 := lv_format2;
443: hr_utility.trace('Static Label1 = ' || lv_format1);
444: hr_utility.trace('Static Label2 = ' || lv_format2);
445: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
446:
447: END;

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

440:
441: p_static_label1 := lv_format1;
442: p_static_label2 := lv_format2;
443: hr_utility.trace('Static Label1 = ' || lv_format1);
444: hr_utility.trace('Static Label2 = ' || lv_format2);
445: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
446:
447: END;
448:

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

441: p_static_label1 := lv_format1;
442: p_static_label2 := lv_format2;
443: hr_utility.trace('Static Label1 = ' || lv_format1);
444: hr_utility.trace('Static Label2 = ' || lv_format2);
445: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
446:
447: END;
448:
449:

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

500: := to_char(p_action_effective_date, 'dd-MON-yyyy');
501:
502: BEGIN
503:
504: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
505: lv_format1 :=
506: formated_data_string (p_input_string => p_emp_last_name
507: ,p_output_file_type => p_output_file_type) ||
508: formated_data_string (p_input_string => p_emp_first_name

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

520: formated_data_string (p_input_string => lv_action_effective_date
521: ,p_output_file_type => p_output_file_type)
522: ;
523:
524: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
525: lv_format2 :=
526: formated_data_string (p_input_string => p_payroll_name
527: ,p_output_file_type => p_output_file_type) ||
528: formated_data_string (p_input_string => p_gre_name

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

550: /*******************************************************************
551: ** Print the User Defined data for each Employee Assignment at the
552: ** end of the report
553: *******************************************************************/
554: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
555:
556: /*******************************************************************
557: ** Only do this if there is some configuration data present
558: *******************************************************************/

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

570: end if;
571:
572: p_static_data1 := lv_format1;
573: p_static_data2 := lv_format2;
574: hr_utility.trace('Static Data1 = ' || lv_format1);
575: hr_utility.trace('Static Data2 = ' || lv_format2);
576: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
577:
578: END;

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

571:
572: p_static_data1 := lv_format1;
573: p_static_data2 := lv_format2;
574: hr_utility.trace('Static Data1 = ' || lv_format1);
575: hr_utility.trace('Static Data2 = ' || lv_format2);
576: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
577:
578: END;
579:

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

572: p_static_data1 := lv_format1;
573: p_static_data2 := lv_format2;
574: hr_utility.trace('Static Data1 = ' || lv_format1);
575: hr_utility.trace('Static Data2 = ' || lv_format2);
576: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
577:
578: END;
579:
580: FUNCTION get_element_set_where_clause (p_element_set_id in number)

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

1047:
1048: ltr_elements tab_element;
1049:
1050: BEGIN
1051: -- hr_utility.trace_on (null,'pyelerep');
1052:
1053: hr_utility.set_location(gv_package_name || '.element_extract', 10);
1054:
1055: formated_static_header( p_output_file_type

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

1049:
1050: BEGIN
1051: -- hr_utility.trace_on (null,'pyelerep');
1052:
1053: hr_utility.set_location(gv_package_name || '.element_extract', 10);
1054:
1055: formated_static_header( p_output_file_type
1056: ,lv_header_label1
1057: ,lv_header_label2

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

1059:
1060: lv_header_label := lv_header_label1;
1061:
1062: if p_element_set_id is not null then
1063: hr_utility.set_location(gv_package_name || '.element_extract', 20);
1064: open c_set_elements( p_element_set_id
1065: ,p_business_group_id
1066: ,fnd_date.canonical_to_date(p_start_date)
1067: ,fnd_date.canonical_to_date(p_end_date)

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

1066: ,fnd_date.canonical_to_date(p_start_date)
1067: ,fnd_date.canonical_to_date(p_end_date)
1068: );
1069: elsif p_element_classification_id is not null then
1070: hr_utility.set_location(gv_package_name || '.element_extract', 30);
1071: open c_class_elements( p_element_classification_id
1072: ,p_business_group_id
1073: ,fnd_date.canonical_to_date(p_start_date)
1074: ,fnd_date.canonical_to_date(p_end_date)

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

1073: ,fnd_date.canonical_to_date(p_start_date)
1074: ,fnd_date.canonical_to_date(p_end_date)
1075: );
1076: elsif p_element_type_id is not null then
1077: hr_utility.set_location(gv_package_name || '.element_extract', 40);
1078: open c_elements(p_element_type_id);
1079: end if;
1080:
1081: hr_utility.set_location(gv_package_name || '.element_extract', 50);

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

1077: hr_utility.set_location(gv_package_name || '.element_extract', 40);
1078: open c_elements(p_element_type_id);
1079: end if;
1080:
1081: hr_utility.set_location(gv_package_name || '.element_extract', 50);
1082: loop
1083: if p_element_set_id is not null then
1084: fetch c_set_elements into lv_element_name;
1085: hr_utility.trace(' lv_element_name 1 : ' || lv_element_name );

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

1081: hr_utility.set_location(gv_package_name || '.element_extract', 50);
1082: loop
1083: if p_element_set_id is not null then
1084: fetch c_set_elements into lv_element_name;
1085: hr_utility.trace(' lv_element_name 1 : ' || lv_element_name );
1086: if c_set_elements%notfound then
1087: exit;
1088: end if;
1089: elsif p_element_classification_id is not null then

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

1087: exit;
1088: end if;
1089: elsif p_element_classification_id is not null then
1090: fetch c_class_elements into lv_element_name;
1091: hr_utility.trace(' lv_element_name 2 : ' || lv_element_name );
1092: if c_class_elements%notfound then
1093: exit;
1094: end if;
1095: elsif p_element_type_id is not null then

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

1093: exit;
1094: end if;
1095: elsif p_element_type_id is not null then
1096: fetch c_elements into lv_element_name;
1097: hr_utility.trace(' lv_element_name 3 : ' || lv_element_name );
1098: if c_elements%notfound then
1099: exit;
1100: end if;
1101: end if;

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

1109: ,p_output_file_type
1110: ,'Y');
1111:
1112: end loop;
1113: hr_utility.set_location(gv_package_name || '.element_extract', 60);
1114:
1115: if p_element_set_id is not null then
1116: close c_set_elements;
1117: elsif p_element_classification_id is not null then

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

1119: elsif p_element_type_id is not null then
1120: close c_elements;
1121: end if;
1122:
1123: hr_utility.set_location(gv_package_name || '.element_extract', 70);
1124: /****************************************************************
1125: ** Concatnating the second Header Label which includes the User
1126: ** Defined data set so that it is printed at the end of the
1127: ** report.

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

1127: ** report.
1128: ****************************************************************/
1129: lv_header_label := lv_header_label || lv_header_label2;
1130:
1131: hr_utility.set_location(gv_package_name || '.element_extract', 80);
1132: hr_utility.trace('Static and Element Label = ' || lv_header_label);
1133:
1134: gv_title := hr_general.decode_fnd_comm_lookup
1135: ('PAYROLL_REPORTS',

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

1128: ****************************************************************/
1129: lv_header_label := lv_header_label || lv_header_label2;
1130:
1131: hr_utility.set_location(gv_package_name || '.element_extract', 80);
1132: hr_utility.trace('Static and Element Label = ' || lv_header_label);
1133:
1134: gv_title := hr_general.decode_fnd_comm_lookup
1135: ('PAYROLL_REPORTS',
1136: 'ELEMENT_REGISTER_TITLE');

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

1139: gv_title
1140: ,p_output_file_type
1141: ));
1142:
1143: hr_utility.set_location(gv_package_name || '.element_extract', 90);
1144: /****************************************************************
1145: ** Print the Header Information. If the format is HTML then open
1146: ** the body and table before printing the header info, otherwise
1147: ** just print the header information.

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

1157: if p_output_file_type ='HTML' then
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1159: end if;
1160:
1161: hr_utility.set_location(gv_package_name || '.element_extract', 100);
1162: /*****************************************************
1163: ** Start of the Data Section of the Report
1164: *****************************************************/
1165: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);

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

1161: hr_utility.set_location(gv_package_name || '.element_extract', 100);
1162: /*****************************************************
1163: ** Start of the Data Section of the Report
1164: *****************************************************/
1165: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1166:
1167: if p_element_classification_id is not null then
1168: lv_element_cls_where_clause
1169: := 'pet.classification_id = ' || p_element_classification_id;

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

1226: ,lv_assignment_number
1227: ,lv_employment_category_code;
1228:
1229: if c_assignments%notfound then
1230: hr_utility.set_location(gv_package_name || '.element_extract', 105);
1231: exit;
1232: end if;
1233: /*
1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );

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

1230: hr_utility.set_location(gv_package_name || '.element_extract', 105);
1231: exit;
1232: end if;
1233: /*
1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );

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

1231: exit;
1232: end if;
1233: /*
1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );

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

1232: end if;
1233: /*
1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );

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

1233: /*
1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );

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

1234: hr_utility.trace(' ln_assignment_action_id : ' || ln_assignment_action_id );
1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );

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

1235: hr_utility.trace(' lv_tax_unit_id : ' || lv_tax_unit_id );
1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );

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

1236: hr_utility.trace(' ln_assignment_id : ' || ln_assignment_id );
1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );

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

1237: hr_utility.trace(' ln_payroll_action_id : ' || ln_payroll_action_id );
1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );

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

1238: hr_utility.trace(' ln_person_id : ' || ln_person_id );
1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );

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

1239: hr_utility.trace(' ld_effective_date : ' || ld_effective_date );
1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );

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

1240: hr_utility.trace(' lv_action_type : ' || lv_action_type );
1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );

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

1241: hr_utility.trace(' lv_payroll_name : ' || lv_payroll_name );
1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );

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

1242: hr_utility.trace(' lv_emp_last_name : ' || lv_emp_last_name );
1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );

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

1243: hr_utility.trace(' lv_emp_first_name : ' || lv_emp_first_name );
1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );

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

1244: hr_utility.trace(' lv_emp_middle_names : ' || lv_emp_middle_names );
1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1252: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );

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

1245: hr_utility.trace(' lv_emp_employee_number : ' || lv_emp_employee_number );
1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1252: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1253: */

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

1246: hr_utility.trace(' lv_emp_national_identifier : ' || lv_emp_national_identifier );
1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1252: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1253: */
1254: BEGIN

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

1247: hr_utility.trace(' ld_emp_date_of_birth : ' || ld_emp_date_of_birth );
1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1252: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1253: */
1254: BEGIN
1255:

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

1248: hr_utility.trace(' lv_gender : ' || lv_gender );
1249: hr_utility.trace(' ld_emp_original_date_of_hire : ' || ld_emp_original_date_of_hire );
1250: hr_utility.trace(' ld_emp_projected_start_date : ' || ld_emp_projected_start_date );
1251: hr_utility.trace(' lv_assignment_number : ' || lv_assignment_number );
1252: hr_utility.trace(' lv_employment_category_code : ' || lv_employment_category_code );
1253: */
1254: BEGIN
1255:
1256: select hou_org.name

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

1303: ** If Assignment Set is used, pick up only those employee
1304: ** assignments which are part of the Assignment Set - STATIC
1305: ** or DYNAMIC.
1306: ************************************************************/
1307: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1308: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1309: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1310:
1311: if hr_assignment_set.assignment_in_set(

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

1304: ** assignments which are part of the Assignment Set - STATIC
1305: ** or DYNAMIC.
1306: ************************************************************/
1307: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1308: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1309: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1310:
1311: if hr_assignment_set.assignment_in_set(
1312: p_assignment_set_id

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

1305: ** or DYNAMIC.
1306: ************************************************************/
1307: hr_utility.set_location(gv_package_name || '.element_extract', 110);
1308: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1309: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1310:
1311: if hr_assignment_set.assignment_in_set(
1312: p_assignment_set_id
1313: ,ln_assignment_id) = 'Y' then

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

1312: p_assignment_set_id
1313: ,ln_assignment_id) = 'Y' then
1314:
1315:
1316: hr_utility.set_location(gv_package_name || '.element_extract', 120);
1317: /********************************************************************
1318: ** Populate the user defined PL/SQL table to print the additional
1319: ** columns in the report.
1320: ********************************************************************/

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

1328: open c_employment_category(lv_employment_category_code);
1329: fetch c_employment_category into lv_employment_category;
1330: close c_employment_category;
1331:
1332: hr_utility.set_location(gv_package_name || '.element_extract', 125);
1333: formated_static_data(
1334: lv_action_type
1335: ,ld_effective_date
1336: ,lv_payroll_name

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

1354: ,lv_data_row1
1355: ,lv_data_row2);
1356:
1357: lv_data_row := lv_data_row1;
1358: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1359: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));

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

1355: ,lv_data_row2);
1356:
1357: lv_data_row := lv_data_row1;
1358: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1359: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));
1363: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));

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

1356:
1357: lv_data_row := lv_data_row1;
1358: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1359: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));
1363: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1364: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));

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

1357: lv_data_row := lv_data_row1;
1358: hr_utility.set_location(gv_package_name || '.element_extract', 130);
1359: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));
1363: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1364: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1365:

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

1359: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,'dd-mon-yyyy'));
1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));
1363: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1364: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1365:
1366: -- Bug 3731178 -- Added NVL in select so that element
1367: -- name is fetched if reporting name is NULL.

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

1360: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1361: hr_utility.trace('Classification ID = ' ||
1362: nvl(to_char(p_element_classification_id), 'NULL'));
1363: hr_utility.trace('Element Set ID = ' || nvl(to_char(p_element_set_id), 'NULL'));
1364: hr_utility.trace('Element Type ID = ' || nvl(to_char(p_element_type_id), 'NULL'));
1365:
1366: -- Bug 3731178 -- Added NVL in select so that element
1367: -- name is fetched if reporting name is NULL.
1368: -- Also added a decode for garn elements.

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

1453: ,ld_effective_date
1454: ,ln_assignment_action_id
1455: ,ld_effective_date;
1456:
1457: hr_utility.set_location(gv_package_name || '.element_extract', 140);
1458: loop
1459: fetch c_element_results into lv_element_name
1460: ,lv_element_value
1461: ,lv_element_status

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

1460: ,lv_element_value
1461: ,lv_element_status
1462: ,ln_run_result_id;
1463: if c_element_results%notfound then
1464: hr_utility.set_location(gv_package_name || '.element_extract', 150);
1465: exit;
1466: end if;
1467:
1468: hr_utility.trace('Element Name = ' || lv_element_name ||

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

1464: hr_utility.set_location(gv_package_name || '.element_extract', 150);
1465: exit;
1466: end if;
1467:
1468: hr_utility.trace('Element Name = ' || lv_element_name ||
1469: ' Value = ' || lv_element_value);
1470: for i in ltr_elements.first .. ltr_elements.last loop
1471: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1472: if ltr_elements(i).element_name = lv_element_name then

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

1467:
1468: hr_utility.trace('Element Name = ' || lv_element_name ||
1469: ' Value = ' || lv_element_value);
1470: for i in ltr_elements.first .. ltr_elements.last loop
1471: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1472: if ltr_elements(i).element_name = lv_element_name then
1473: hr_utility.set_location(gv_package_name || '.element_extract', 155);
1474:
1475: /*******************************************************************

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

1469: ' Value = ' || lv_element_value);
1470: for i in ltr_elements.first .. ltr_elements.last loop
1471: hr_utility.trace('Element Name PL/SQL = ' || ltr_elements(i).element_name);
1472: if ltr_elements(i).element_name = lv_element_name then
1473: hr_utility.set_location(gv_package_name || '.element_extract', 155);
1474:
1475: /*******************************************************************
1476: Bug 4214739 Checked if element status is 'R' - Replaced then there is no need to
1477: add the value so made lv_element_value 0

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

1498: /*******************************************************************
1499: ** Do Not Print records of an employee, if the employee has non of
1500: ** the elements which are picked up by the report.
1501: *******************************************************************/
1502: hr_utility.set_location(gv_package_name || '.element_extract', 160);
1503: if ltr_elements.count > 0 then
1504: for i in ltr_elements.first .. ltr_elements.last loop
1505: if ltr_elements(i).value is not null then
1506: hr_utility.set_location(gv_package_name || '.element_extract', 165);

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

1502: hr_utility.set_location(gv_package_name || '.element_extract', 160);
1503: if ltr_elements.count > 0 then
1504: for i in ltr_elements.first .. ltr_elements.last loop
1505: if ltr_elements(i).value is not null then
1506: hr_utility.set_location(gv_package_name || '.element_extract', 165);
1507: lb_print_row := TRUE;
1508: exit;
1509: end if;
1510: end loop;

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

1514: ** If there is atleast one column which needs to be printed, print
1515: ** the entire row.
1516: *******************************************************************/
1517: if lb_print_row then
1518: hr_utility.set_location(gv_package_name || '.element_extract', 170);
1519: for i in ltr_elements.first .. ltr_elements.last loop
1520: lv_data_row := lv_data_row ||
1521: formated_data_string (
1522: p_input_string => ltr_elements(i).value

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

1566:
1567: if p_output_file_type ='HTML' then
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1569: end if;
1570: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
1571:
1572:
1573: /**********************************************************
1574: ** Not Required as the output file type is HTML by default

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

1585:
1586: END element_extract;
1587:
1588: --begin
1589: --hr_utility.trace_on(null, 'ELE');
1590: end pay_element_extract_pkg;