eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTI_INT dependencies on GHR_MTO_INT

Line 71: ghr_mto_int.put_line(l_proc||' - raised exception');

67: hr_utility.set_location('Leaving:'||l_proc, 10);
68:
69: exception
70: when others then
71: ghr_mto_int.put_line(l_proc||' - raised exception');
72: hr_utility.raise_error;
73:
74: end set_transfer_status;
75:

Line 128: ghr_mto_int.put_line(l_proc||' - raised exception');

124: hr_utility.set_location('Leaving:'||l_proc, 10);
125:
126: exception
127: when others then
128: ghr_mto_int.put_line(l_proc||' - raised exception');
129: hr_utility.raise_error;
130:
131: end;
132:

Line 168: ghr_mto_int.put('Person Extra Info: '|| p_information_type);

164: begin
165:
166: hr_utility.set_location('Entering:'||l_proc, 10);
167:
168: ghr_mto_int.put('Person Extra Info: '|| p_information_type);
169:
170: -- don't add info3 if DDF segment is GHR_US_PER_GROUP1
171: if p_information_type = 'GHR_US_PER_GROUP1' then
172: l_info3 := null;

Line 195: ghr_mto_int.put_line(' > not created.');

191: p_pei_information16 ||
192: p_pei_information17;
193:
194: if l_concat is null then
195: ghr_mto_int.put_line(' > not created.');
196: return;
197: end if;
198:
199: ghr_person_extra_info_api.create_person_extra_info (

Line 224: ghr_mto_int.put_line(' > ok, pei_id: '|| l_person_extra_info_id);

220: ,p_person_extra_info_id => l_person_extra_info_id
221: ,p_object_version_number => l_object_version_number
222: );
223:
224: ghr_mto_int.put_line(' > ok, pei_id: '|| l_person_extra_info_id);
225: hr_utility.set_location('Leaving:'||l_proc, 30);
226:
227: exception
228: when others then

Line 229: ghr_mto_int.put_line(l_proc||' - raised exception');

225: hr_utility.set_location('Leaving:'||l_proc, 30);
226:
227: exception
228: when others then
229: ghr_mto_int.put_line(l_proc||' - raised exception');
230: hr_utility.raise_error;
231:
232: end;
233:

Line 273: ghr_mto_int.put('Person Spcl Info: '|| p_id_flex_name);

269: begin
270:
271: hr_utility.set_location('Entering:'||l_proc, 10);
272:
273: ghr_mto_int.put('Person Spcl Info: '|| p_id_flex_name);
274:
275: l_concat := p_segment1 ||
276: p_segment2 ||
277: p_segment3 ||

Line 291: ghr_mto_int.put_line(' > not created.');

287: p_segment13 ||
288: p_segment14;
289:
290: if l_concat is null then
291: ghr_mto_int.put_line(' > not created.');
292: return;
293: end if;
294:
295: open cur_flex_num;

Line 331: ghr_mto_int.put_line(' > ok, criteria_id: '||

327: ,p_person_analysis_id => l_person_analysis_id
328: ,p_pea_object_version_number => l_pea_object_version_number
329: );
330:
331: ghr_mto_int.put_line(' > ok, criteria_id: '||
332: l_analysis_criteria_id||', analysis_id: '||
333: l_person_analysis_id);
334: hr_utility.set_location('Leaving:'||l_proc, 30);
335:

Line 338: ghr_mto_int.put_line(l_proc||' - raised exception');

334: hr_utility.set_location('Leaving:'||l_proc, 30);
335:
336: exception
337: when others then
338: ghr_mto_int.put_line(l_proc||' - raised exception');
339: hr_utility.raise_error;
340:
341: end;
342:

Line 439: ghr_mto_int.put_line('Transfering: '||p_tran.last_name);

435:
436: hr_utility.set_location('Entering:'||l_proc, 10);
437: p_result := 'P';
438:
439: ghr_mto_int.put_line('Transfering: '||p_tran.last_name);
440:
441: if ck_parameter_list(p_tran) = FALSE then
442: ghr_mto_int.put_line('Missing required data for transfer in');
443: ghr_mto_int.log_message(

Line 442: ghr_mto_int.put_line('Missing required data for transfer in');

438:
439: ghr_mto_int.put_line('Transfering: '||p_tran.last_name);
440:
441: if ck_parameter_list(p_tran) = FALSE then
442: ghr_mto_int.put_line('Missing required data for transfer in');
443: ghr_mto_int.log_message(
444: p_procedure => l_proc_name,
445: p_message => 'Missing last_name and/or '||
446: 'mt_person_id from ghr_mt_people_f_v');

Line 443: ghr_mto_int.log_message(

439: ghr_mto_int.put_line('Transfering: '||p_tran.last_name);
440:
441: if ck_parameter_list(p_tran) = FALSE then
442: ghr_mto_int.put_line('Missing required data for transfer in');
443: ghr_mto_int.log_message(
444: p_procedure => l_proc_name,
445: p_message => 'Missing last_name and/or '||
446: 'mt_person_id from ghr_mt_people_f_v');
447:

Line 461: ghr_mto_int.put_line(report_state(g_validate, 'Validate Flag:'));

457:
458: l_applicant_date := trunc(p_effective_date) - 1;
459: l_accept_date := trunc(p_effective_date) - 1;
460:
461: ghr_mto_int.put_line(report_state(g_validate, 'Validate Flag:'));
462: hr_utility.set_location('Create Applicant:'||l_proc, 20);
463:
464: for cur_person_exists_rec in cur_person_exists
465: loop

Line 597: ghr_mto_int.put_line('===== Create Applicant =============');

593: -- assign out parameter p_person_id
594: p_person_id := l_person_id;
595:
596: if g_validate = FALSE then
597: ghr_mto_int.put_line('===== Create Applicant =============');
598: ghr_mto_int.put_line('Person ID:'||l_person_id);
599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);
600: ghr_mto_int.put_line('Application ID:'||l_application_id);
601: ghr_mto_int.put_line(

Line 598: ghr_mto_int.put_line('Person ID:'||l_person_id);

594: p_person_id := l_person_id;
595:
596: if g_validate = FALSE then
597: ghr_mto_int.put_line('===== Create Applicant =============');
598: ghr_mto_int.put_line('Person ID:'||l_person_id);
599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);
600: ghr_mto_int.put_line('Application ID:'||l_application_id);
601: ghr_mto_int.put_line(
602: report_state(l_name_combination_warning,'Name Warning:'));

Line 599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);

595:
596: if g_validate = FALSE then
597: ghr_mto_int.put_line('===== Create Applicant =============');
598: ghr_mto_int.put_line('Person ID:'||l_person_id);
599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);
600: ghr_mto_int.put_line('Application ID:'||l_application_id);
601: ghr_mto_int.put_line(
602: report_state(l_name_combination_warning,'Name Warning:'));
603: end if;

Line 600: ghr_mto_int.put_line('Application ID:'||l_application_id);

596: if g_validate = FALSE then
597: ghr_mto_int.put_line('===== Create Applicant =============');
598: ghr_mto_int.put_line('Person ID:'||l_person_id);
599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);
600: ghr_mto_int.put_line('Application ID:'||l_application_id);
601: ghr_mto_int.put_line(
602: report_state(l_name_combination_warning,'Name Warning:'));
603: end if;
604:

Line 601: ghr_mto_int.put_line(

597: ghr_mto_int.put_line('===== Create Applicant =============');
598: ghr_mto_int.put_line('Person ID:'||l_person_id);
599: ghr_mto_int.put_line('Assignment ID:'||l_assignment_id);
600: ghr_mto_int.put_line('Application ID:'||l_application_id);
601: ghr_mto_int.put_line(
602: report_state(l_name_combination_warning,'Name Warning:'));
603: end if;
604:
605: -------AVR bug 2467099

Line 635: ghr_mto_int.put_line('------- Accept Applicant -------------');

631: ,p_effective_start_date => l_per_effective_start_date
632: ,p_effective_end_date => l_per_effective_end_date
633: );
634:
635: ghr_mto_int.put_line('------- Accept Applicant -------------');
636: ghr_mto_int.put_line('Start Date: '||
637: to_char(l_per_effective_start_date,g_datefmt));
638: ghr_mto_int.put_line('End Date: '||
639: to_char(l_per_effective_end_date,g_datefmt));

Line 636: ghr_mto_int.put_line('Start Date: '||

632: ,p_effective_end_date => l_per_effective_end_date
633: );
634:
635: ghr_mto_int.put_line('------- Accept Applicant -------------');
636: ghr_mto_int.put_line('Start Date: '||
637: to_char(l_per_effective_start_date,g_datefmt));
638: ghr_mto_int.put_line('End Date: '||
639: to_char(l_per_effective_end_date,g_datefmt));
640: ghr_mto_int.put_line('------------------------------------');

Line 638: ghr_mto_int.put_line('End Date: '||

634:
635: ghr_mto_int.put_line('------- Accept Applicant -------------');
636: ghr_mto_int.put_line('Start Date: '||
637: to_char(l_per_effective_start_date,g_datefmt));
638: ghr_mto_int.put_line('End Date: '||
639: to_char(l_per_effective_end_date,g_datefmt));
640: ghr_mto_int.put_line('------------------------------------');
641: end if;
642:

Line 640: ghr_mto_int.put_line('------------------------------------');

636: ghr_mto_int.put_line('Start Date: '||
637: to_char(l_per_effective_start_date,g_datefmt));
638: ghr_mto_int.put_line('End Date: '||
639: to_char(l_per_effective_end_date,g_datefmt));
640: ghr_mto_int.put_line('------------------------------------');
641: end if;
642:
643: hr_utility.set_location('Person Extra Info:'||l_proc, 40);
644:

Line 788: ghr_mto_int.log_message(

784: ,p_country => l_address.COUNTRY
785: ,p_address_id => l_ADDRESS_ID
786: ,p_object_version_number => l_per_object_VERSION_NUMBER
787: );
788: ghr_mto_int.log_message(
789: p_procedure => l_proc_name,
790: p_message => 'Address created Successfully');
791:
792: exception

Line 799: ghr_mto_int.log_message(

795: -- Bug#3718167 Added Person Name and SSN in the log text
796: --Bug # 9329643 Modified SSN to Emp No
797: l_message := 'Error in INT Address creation for ' || l_full_name||
798: ' Emp No: '||p_tran.employee_number|| 'Error is:'||sqlerrm(sqlcode);
799: ghr_mto_int.log_message(
800: p_procedure => l_proc_name,
801: p_message => l_message);
802: end;
803:

Line 827: ghr_mto_int.log_message(

823: ,p_address_id => l_ADDRESS_ID
824: ,p_object_version_number => l_per_object_VERSION_NUMBER
825: );
826:
827: ghr_mto_int.log_message(
828: p_procedure => l_proc_name,
829: p_message => 'PER Address created Successfully');
830: exception when others then
831: hr_utility.set_location(' User type PER Error Address :'||l_proc, 56);

Line 836: ghr_mto_int.log_message(

832: -- Bug#3718167 Added Person Name and SSN in the log text
833: --Bug # 9329643 Modified SSN to Emp No
834: l_message := 'Error in PER Address creation for ' || l_full_name||
835: ' Emp No: '||p_tran.employee_number|| 'Error is:'||sqlerrm(sqlcode);
836: ghr_mto_int.log_message(
837: p_procedure => l_proc_name,
838: p_message => l_message);
839: end;
840: END IF;

Line 846: ghr_mto_int.put_line('* Successful');

842: END IF;
843:
844: close cur_address;
845:
846: ghr_mto_int.put_line('* Successful');
847: hr_utility.set_location('Leaving:'||l_proc, 50);
848:
849: ELSE
850: -- Employee exists with same SSN....

Line 853: ghr_mto_int.log_message(

849: ELSE
850: -- Employee exists with same SSN....
851: -- Bug#3718167 Added Person Full Name in the Log Message
852: --Bug # 9329643 Modified SSN to Emp No
853: ghr_mto_int.log_message(
854: p_procedure => l_proc_name,
855: p_message => 'Person exists with the same Emp No : ' || p_tran.employee_number ||
856: ' in the given business group with person Full Name as '||l_exists_full_name ||
857: ' and the person id is ' ||to_char(l_exists_person_id) );

Line 868: ghr_mto_int.put_line(l_proc||' - raised exception');

864: -- NOCOPY Changes Sundar 03Dec2003
865: p_person_id := NULL;
866: p_result := NULL;
867: -- End NOCOPY changes
868: ghr_mto_int.put_line(l_proc||' - raised exception');
869: ghr_mto_int.put_line(sqlerrm);
870:
871: ghr_mto_int.log_message(
872: p_procedure => l_proc_name,

Line 869: ghr_mto_int.put_line(sqlerrm);

865: p_person_id := NULL;
866: p_result := NULL;
867: -- End NOCOPY changes
868: ghr_mto_int.put_line(l_proc||' - raised exception');
869: ghr_mto_int.put_line(sqlerrm);
870:
871: ghr_mto_int.log_message(
872: p_procedure => l_proc_name,
873: p_message => l_message);

Line 871: ghr_mto_int.log_message(

867: -- End NOCOPY changes
868: ghr_mto_int.put_line(l_proc||' - raised exception');
869: ghr_mto_int.put_line(sqlerrm);
870:
871: ghr_mto_int.log_message(
872: p_procedure => l_proc_name,
873: p_message => l_message);
874:
875: hr_utility.raise_error;

Line 962: ghr_mto_int.set_log_program_name('Mass Transfer In');

958:
959: begin
960:
961: hr_utility.set_location('Entering:'||l_proc, 10);
962: ghr_mto_int.set_log_program_name('Mass Transfer In');
963:
964: ghr_mto_int.get_transfer_parameters(
965: p_mass_transfer_id => p_transfer_id,
966: p_transfer_name => l_transfer_name,

Line 964: ghr_mto_int.get_transfer_parameters(

960:
961: hr_utility.set_location('Entering:'||l_proc, 10);
962: ghr_mto_int.set_log_program_name('Mass Transfer In');
963:
964: ghr_mto_int.get_transfer_parameters(
965: p_mass_transfer_id => p_transfer_id,
966: p_transfer_name => l_transfer_name,
967: p_effective_date => l_effective_date,
968: p_inter_bg_transfer => l_inter_bg_transfer);

Line 971: ghr_mto_int.log_message(

967: p_effective_date => l_effective_date,
968: p_inter_bg_transfer => l_inter_bg_transfer);
969:
970: if l_effective_date is null then
971: ghr_mto_int.log_message(
972: p_procedure => l_proc_name,
973: p_message => 'Failed to get Transfer In information from'||
974: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||
975: p_transfer_id);

Line 981: ghr_mto_int.put_line('Starting Transfer In for:'||l_transfer_name);

977: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');
978: hr_utility.raise_error;
979: end if;
980:
981: ghr_mto_int.put_line('Starting Transfer In for:'||l_transfer_name);
982:
983: -- find the person type id for applicant in the business group
984: open cur_person_type;
985: fetch cur_person_type into l_person_type_id;

Line 989: ghr_mto_int.log_message(

985: fetch cur_person_type into l_person_type_id;
986: close cur_person_type;
987:
988: if l_person_type_id is null then
989: ghr_mto_int.log_message(
990: p_procedure => l_proc_name,
991: p_message =>
992: 'Failed to get the person_type_id for APPLICANT '||
993: 'in the business group');

Line 1014: ghr_mto_int.log_message(

1010:
1011: if l_person_type_mti = 'Employee' then
1012: -- Bug#3718167 Added Person Name, SSN
1013: --Bug # 9329643 Modified SSN to Emp No
1014: ghr_mto_int.log_message(
1015: p_procedure => l_proc_name,
1016: p_message =>
1017: 'Error: Selected person: '||c_person.full_name||'(Emp No: '||c_person.employee_number||
1018: ') contains an invalid Person Type as of the Effective ' ||

Line 1043: ghr_mto_int.log_message(

1039: l_result := 'E';
1040: l_error_count := l_error_count + 1;
1041: -- Bug#3718167 Added Full Name, SSN in the log message
1042: --Bug # 9329643 Modified SSN to Emp No
1043: ghr_mto_int.log_message(
1044: p_procedure => l_proc_name,
1045: p_message =>
1046: 'Mass Transfer In for person: '|| c_person.full_name||' Emp No: '||c_person.employee_number||
1047: ' Person ID: '||l_person_id||

Line 1069: ghr_mto_int.put_line('Committed');

1065: p_effective_date => l_effective_date);
1066: end if;
1067:
1068: commit;
1069: ghr_mto_int.put_line('Committed');
1070:
1071: l_transfer_count := l_transfer_count + 1;
1072:
1073: end loop;

Line 1089: ghr_mto_int.put_line('ghr_mti_app.populate_and_create_52'||

1085:
1086: exception
1087: when others then
1088:
1089: ghr_mto_int.put_line('ghr_mti_app.populate_and_create_52'||
1090: ' - raised exception');
1091:
1092: rollback; -- rollback changes made by the procedure
1093:

Line 1098: ghr_mto_int.log_message(

1094: -- return errbuf and retcode returned from sri's procedure
1095: p_errbuf := l_errbuf;
1096: p_retcode := l_retcode;
1097:
1098: ghr_mto_int.log_message(
1099: p_procedure => l_proc_name,
1100: p_message =>
1101: 'Mass Transfer In for '||
1102: l_transfer_name ||

Line 1120: ghr_mto_int.log_message(

1116:
1117: p_errbuf := null;
1118: p_retcode := 0;
1119:
1120: ghr_mto_int.log_message(
1121: p_procedure => l_proc_name,
1122: p_message =>
1123: 'Mass Transfer In for '||
1124: l_transfer_name || ' transfered '||l_transfer_count ||

Line 1136: ghr_mto_int.log_message(

1132: l_message := 'Warning: Mass Transfer In for transfer: '||
1133: l_transfer_name ||' was unable to transfer '||
1134: l_error_count || ' people out of '|| l_transfer_count;
1135:
1136: ghr_mto_int.log_message(
1137: p_procedure => l_proc_name,
1138: p_message => l_message);
1139:
1140: p_errbuf := l_message;

Line 1146: ghr_mto_int.put_line(l_proc||' - raised exception');

1142:
1143: commit;
1144:
1145: when others then
1146: ghr_mto_int.put_line(l_proc||' - raised exception');
1147:
1148: if l_person_type_mti <> 'Employee' then
1149: ghr_mto_int.log_message(
1150: p_procedure => l_proc_name,

Line 1149: ghr_mto_int.log_message(

1145: when others then
1146: ghr_mto_int.put_line(l_proc||' - raised exception');
1147:
1148: if l_person_type_mti <> 'Employee' then
1149: ghr_mto_int.log_message(
1150: p_procedure => l_proc_name,
1151: p_message =>
1152: 'Mass Transfer In for mass_transfer_id: '||
1153: p_transfer_id || ' failed with error message: '||