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 798: ghr_mto_int.log_message(

794: hr_utility.set_location(' User type INT Error Address :'||l_proc, 56);
795: -- Bug#3718167 Added Person Name and SSN in the log text
796: l_message := 'Error in INT Address creation for ' || l_full_name||
797: ' SSN: '||p_tran.national_identifier|| 'Error is:'||sqlerrm(sqlcode);
798: ghr_mto_int.log_message(
799: p_procedure => l_proc_name,
800: p_message => l_message);
801: end;
802:

Line 826: ghr_mto_int.log_message(

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

Line 834: ghr_mto_int.log_message(

830: hr_utility.set_location(' User type PER Error Address :'||l_proc, 56);
831: -- Bug#3718167 Added Person Name and SSN in the log text
832: l_message := 'Error in PER Address creation for ' || l_full_name||
833: ' SSN: '||p_tran.national_identifier|| 'Error is:'||sqlerrm(sqlcode);
834: ghr_mto_int.log_message(
835: p_procedure => l_proc_name,
836: p_message => l_message);
837: end;
838: END IF;

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

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

Line 850: ghr_mto_int.log_message(

846:
847: ELSE
848: -- Employee exists with same SSN....
849: -- Bug#3718167 Added Person Full Name in the Log Message
850: ghr_mto_int.log_message(
851: p_procedure => l_proc_name,
852: p_message => 'Person exists with the same SSN : ' || p_tran.national_identifier ||
853: ' in the given business group with person Full Name as '||l_exists_full_name ||
854: ' and the person id is ' ||to_char(l_exists_person_id) );

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

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

Line 866: ghr_mto_int.put_line(sqlerrm);

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

Line 868: ghr_mto_int.log_message(

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

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

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

Line 961: ghr_mto_int.get_transfer_parameters(

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

Line 968: ghr_mto_int.log_message(

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

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

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

Line 986: ghr_mto_int.log_message(

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

Line 1010: ghr_mto_int.log_message(

1006: end loop;
1007:
1008: if l_person_type_mti = 'Employee' then
1009: -- Bug#3718167 Added Person Name, SSN
1010: ghr_mto_int.log_message(
1011: p_procedure => l_proc_name,
1012: p_message =>
1013: 'Error: Selected person: '||c_person.full_name||'(SSN: '||c_person.national_identifier||
1014: ') contains an invalid Person Type as of the Effective ' ||

Line 1038: ghr_mto_int.log_message(

1034: when others then
1035: l_result := 'E';
1036: l_error_count := l_error_count + 1;
1037: -- Bug#3718167 Added Full Name, SSN in the log message
1038: ghr_mto_int.log_message(
1039: p_procedure => l_proc_name,
1040: p_message =>
1041: 'Mass Transfer In for person: '|| c_person.full_name||' SSN: '||c_person.national_identifier||
1042: ' Person ID: '||l_person_id||

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

1060: p_effective_date => l_effective_date);
1061: end if;
1062:
1063: commit;
1064: ghr_mto_int.put_line('Committed');
1065:
1066: l_transfer_count := l_transfer_count + 1;
1067:
1068: end loop;

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

1080:
1081: exception
1082: when others then
1083:
1084: ghr_mto_int.put_line('ghr_mti_app.populate_and_create_52'||
1085: ' - raised exception');
1086:
1087: rollback; -- rollback changes made by the procedure
1088:

Line 1093: ghr_mto_int.log_message(

1089: -- return errbuf and retcode returned from sri's procedure
1090: p_errbuf := l_errbuf;
1091: p_retcode := l_retcode;
1092:
1093: ghr_mto_int.log_message(
1094: p_procedure => l_proc_name,
1095: p_message =>
1096: 'Mass Transfer In for '||
1097: l_transfer_name ||

Line 1115: ghr_mto_int.log_message(

1111:
1112: p_errbuf := null;
1113: p_retcode := 0;
1114:
1115: ghr_mto_int.log_message(
1116: p_procedure => l_proc_name,
1117: p_message =>
1118: 'Mass Transfer In for '||
1119: l_transfer_name || ' transfered '||l_transfer_count ||

Line 1131: ghr_mto_int.log_message(

1127: l_message := 'Warning: Mass Transfer In for transfer: '||
1128: l_transfer_name ||' was unable to transfer '||
1129: l_error_count || ' people out of '|| l_transfer_count;
1130:
1131: ghr_mto_int.log_message(
1132: p_procedure => l_proc_name,
1133: p_message => l_message);
1134:
1135: p_errbuf := l_message;

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

1137:
1138: commit;
1139:
1140: when others then
1141: ghr_mto_int.put_line(l_proc||' - raised exception');
1142:
1143: if l_person_type_mti <> 'Employee' then
1144: ghr_mto_int.log_message(
1145: p_procedure => l_proc_name,

Line 1144: ghr_mto_int.log_message(

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