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.PQP_HRTCA_INTEGRATION dependencies on HR_UTILITY

Line 194: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

190:
191: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_Per_Extra_info';
192: l_error_msg Varchar2(2000);
193: BEGIN
194: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
195: IF p_action = 'CREATE' THEN
196: Hr_Person_Extra_Info_Api.Create_Person_Extra_Info
197: (p_validate => p_validate
198: ,p_person_id => p_person_id

Line 325: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

321: ,p_person_extra_info_id => p_extra_info_rec.person_extra_info_id
322: ,p_object_version_number => p_extra_info_rec.object_version_number
323: );
324: END IF;
325: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
326: EXCEPTION
327: WHEN Others THEN
328: l_error_msg := Substrb(SQLERRM,1,2000);
329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

325: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
326: EXCEPTION
327: WHEN Others THEN
328: l_error_msg := Substrb(SQLERRM,1,2000);
329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
330: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
331: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
332: Hr_Utility.raise_error;
333:

Line 330: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

326: EXCEPTION
327: WHEN Others THEN
328: l_error_msg := Substrb(SQLERRM,1,2000);
329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
330: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
331: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
332: Hr_Utility.raise_error;
333:
334: END InsUpd_Per_Extra_info;

Line 331: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

327: WHEN Others THEN
328: l_error_msg := Substrb(SQLERRM,1,2000);
329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
330: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
331: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
332: Hr_Utility.raise_error;
333:
334: END InsUpd_Per_Extra_info;
335: -- =============================================================================

Line 332: Hr_Utility.raise_error;

328: l_error_msg := Substrb(SQLERRM,1,2000);
329: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
330: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
331: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
332: Hr_Utility.raise_error;
333:
334: END InsUpd_Per_Extra_info;
335: -- =============================================================================
336: -- ~ InsUpd_SIT_info:

Line 351: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

347:
348: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_SIT_info';
349: l_error_msg Varchar2(2000);
350: BEGIN
351: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
352: IF p_action = 'CREATE' THEN
353: Hr_SIT_Api.Create_SIT
354: (p_validate => p_validate
355: ,p_person_id => p_person_id

Line 503: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

499: ,p_person_analysis_id => p_analyses_rec.person_analysis_id
500: ,p_pea_object_version_number => p_analyses_rec.object_version_number
501: );
502: END IF;
503: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
504: EXCEPTION
505: WHEN Others THEN
506: l_error_msg := Substrb(SQLERRM,1,2000);
507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

503: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
504: EXCEPTION
505: WHEN Others THEN
506: l_error_msg := Substrb(SQLERRM,1,2000);
507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
508: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
509: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
510: Hr_Utility.raise_error;
511:

Line 508: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

504: EXCEPTION
505: WHEN Others THEN
506: l_error_msg := Substrb(SQLERRM,1,2000);
507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
508: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
509: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
510: Hr_Utility.raise_error;
511:
512: END InsUpd_SIT_info;

Line 509: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

505: WHEN Others THEN
506: l_error_msg := Substrb(SQLERRM,1,2000);
507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
508: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
509: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
510: Hr_Utility.raise_error;
511:
512: END InsUpd_SIT_info;
513: -- =============================================================================

Line 510: Hr_Utility.raise_error;

506: l_error_msg := Substrb(SQLERRM,1,2000);
507: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
508: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
509: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
510: Hr_Utility.raise_error;
511:
512: END InsUpd_SIT_info;
513: -- =============================================================================
514: -- ~ InsUpd_Asg_Extra_info: Insert, Update or Delete Assignment Extra Info.

Line 527: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

523: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_Asg_Extra_info';
524: l_error_msg Varchar2(2000);
525:
526: BEGIN
527: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
528: IF p_action = 'CREATE' THEN
529: Hr_Assignment_Extra_Info_Api.Create_Assignment_Extra_Info
530: (p_validate => p_validate
531: ,p_assignment_id => p_assignment_id

Line 659: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

655: ,p_assignment_extra_info_id => p_extra_info_rec.Assignment_extra_info_id
656: ,p_object_version_number => p_extra_info_rec.object_version_number
657: );
658: END IF;
659: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
660: EXCEPTION
661: WHEN Others THEN
662: l_error_msg := Substrb(SQLERRM,1,2000);
663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

659: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
660: EXCEPTION
661: WHEN Others THEN
662: l_error_msg := Substrb(SQLERRM,1,2000);
663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
664: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
666: Hr_Utility.raise_error;
667:

Line 664: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

660: EXCEPTION
661: WHEN Others THEN
662: l_error_msg := Substrb(SQLERRM,1,2000);
663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
664: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
666: Hr_Utility.raise_error;
667:
668: END InsUpd_Asg_Extra_info;

Line 665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

661: WHEN Others THEN
662: l_error_msg := Substrb(SQLERRM,1,2000);
663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
664: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
666: Hr_Utility.raise_error;
667:
668: END InsUpd_Asg_Extra_info;
669:

Line 666: Hr_Utility.raise_error;

662: l_error_msg := Substrb(SQLERRM,1,2000);
663: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
664: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
666: Hr_Utility.raise_error;
667:
668: END InsUpd_Asg_Extra_info;
669:
670: -- =============================================================================

Line 700: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

696: l_cntry_mapping csr_cntry_code%ROWTYPE;
697: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_OSS_PassPort';
698: l_error_msg Varchar2(2000);
699: BEGIN
700: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
701: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
702:
703: SQLstmt := ' SELECT pap.rowid '||
704: ' ,pap.passport_id '||

Line 777: Hr_Utility.set_location('..p_action :'||p_action, 10);

773: -- If expiry date is null then raise a warning that Passport was not
774: -- created in OSS for the student employee as its a required field in OSS
775:
776: ELSIF p_action = 'UPDATE' THEN
777: Hr_Utility.set_location('..p_action :'||p_action, 10);
778: Hr_Utility.set_location('..Old PP No:'||p_pei_info_rec_old.pei_information6, 10);
779: Hr_Utility.set_location('..New PP No:'||p_pei_info_rec_new.pei_information6, 10);
780: IF (Trim(p_pei_info_rec_old.pei_information6) =
781: Trim(p_pei_info_rec_new.pei_information6)) THEN

Line 778: Hr_Utility.set_location('..Old PP No:'||p_pei_info_rec_old.pei_information6, 10);

774: -- created in OSS for the student employee as its a required field in OSS
775:
776: ELSIF p_action = 'UPDATE' THEN
777: Hr_Utility.set_location('..p_action :'||p_action, 10);
778: Hr_Utility.set_location('..Old PP No:'||p_pei_info_rec_old.pei_information6, 10);
779: Hr_Utility.set_location('..New PP No:'||p_pei_info_rec_new.pei_information6, 10);
780: IF (Trim(p_pei_info_rec_old.pei_information6) =
781: Trim(p_pei_info_rec_new.pei_information6)) THEN
782: OPEN csr_pp FOR SQLstmt

Line 779: Hr_Utility.set_location('..New PP No:'||p_pei_info_rec_new.pei_information6, 10);

775:
776: ELSIF p_action = 'UPDATE' THEN
777: Hr_Utility.set_location('..p_action :'||p_action, 10);
778: Hr_Utility.set_location('..Old PP No:'||p_pei_info_rec_old.pei_information6, 10);
779: Hr_Utility.set_location('..New PP No:'||p_pei_info_rec_new.pei_information6, 10);
780: IF (Trim(p_pei_info_rec_old.pei_information6) =
781: Trim(p_pei_info_rec_new.pei_information6)) THEN
782: OPEN csr_pp FOR SQLstmt
783: Using p_party_id

Line 786: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);

782: OPEN csr_pp FOR SQLstmt
783: Using p_party_id
784: ,p_pei_info_rec_new.pei_information6;
785: FETCH csr_pp INTO l_oss_pp_rec_old;
786: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);
787: IF csr_pp%FOUND AND
788: (p_pei_info_rec_new.pei_information8 <>
789: p_pei_info_rec_old.pei_information8) OR
790: (p_pei_info_rec_new.pei_information5 <>

Line 806: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);

802: OPEN csr_pp FOR SQLstmt
803: Using p_party_id
804: ,p_pei_info_rec_new.pei_information6;
805: FETCH csr_pp INTO l_oss_pp_rec_old;
806: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);
807: IF csr_pp%NOTFOUND THEN
808: l_Insert_OSS_Rec := TRUE;
809: ELSIF (p_pei_info_rec_new.pei_information8 <>
810: p_pei_info_rec_old.pei_information8)

Line 840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);

836: ,l_oss_pp_rec.passport_cntry_code);
837:
838: -- Insert Into OSS
839: IF l_Insert_OSS_Rec THEN
840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);
841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);
842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);
843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);
844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);

Line 841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);

837:
838: -- Insert Into OSS
839: IF l_Insert_OSS_Rec THEN
840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);
841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);
842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);
843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);
844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);
845:

Line 842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);

838: -- Insert Into OSS
839: IF l_Insert_OSS_Rec THEN
840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);
841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);
842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);
843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);
844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);
845:
846: PLSQL_Block :=

Line 843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);

839: IF l_Insert_OSS_Rec THEN
840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);
841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);
842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);
843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);
844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);
845:
846: PLSQL_Block :=
847: 'DECLARE

Line 844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);

840: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: IGS_PE_Visapass_Pub.Create_Passport', 20);
841: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 20);
842: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 20);
843: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 20);
844: Hr_Utility.set_location('..l_cntry_mapping.irs_code: '||l_cntry_mapping.irs_code, 20);
845:
846: PLSQL_Block :=
847: 'DECLARE
848: l_passport_rec Igs_Pe_Visapass_Pub.Passport_Rec_TYPE;

Line 879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);

875: END IF;
876:
877: -- Update the existing OSS record
878: IF l_update_OSS_rec THEN
879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);
880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);

Line 880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);

876:
877: -- Update the existing OSS record
878: IF l_update_OSS_rec THEN
879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);
880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);
884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);

Line 881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);

877: -- Update the existing OSS record
878: IF l_update_OSS_rec THEN
879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);
880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);
884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);
885:

Line 882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);

878: IF l_update_OSS_rec THEN
879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);
880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);
884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);
885:
886: PLSQL_Block :=

Line 883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);

879: Hr_Utility.set_location('Calling Dynamic PL/SQL Block: Igs_Pe_Passport_Pkg.Update_Row', 21);
880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);
884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);
885:
886: PLSQL_Block :=
887: 'DECLARE

Line 884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);

880: Hr_Utility.set_location('..passport_number: '||l_oss_pp_rec.passport_number, 21);
881: Hr_Utility.set_location('..passport_expiry_date: '||l_oss_pp_rec.passport_expiry_date, 21);
882: Hr_Utility.set_location('..passport_cntry_code: '||l_oss_pp_rec.passport_cntry_code, 21);
883: Hr_Utility.set_location('..passport_id: '||l_oss_pp_rec.passport_id, 21);
884: Hr_Utility.set_location('..rowid: '||l_oss_pp_rec.pp_rowid, 21);
885:
886: PLSQL_Block :=
887: 'DECLARE
888: l_passport_rec Igs_Pe_Visapass_Pub.Passport_Rec_TYPE;

Line 916: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);

912: ,OUT l_msg_count
913: ,OUT l_msg_data;
914:
915: END IF;
916: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
917: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
918: IF l_return_status IN ('E','U') THEN
919: RAISE e_passport_err;
920: END IF;

Line 917: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);

913: ,OUT l_msg_data;
914:
915: END IF;
916: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
917: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
918: IF l_return_status IN ('E','U') THEN
919: RAISE e_passport_err;
920: END IF;
921: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

Line 921: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

917: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
918: IF l_return_status IN ('E','U') THEN
919: RAISE e_passport_err;
920: END IF;
921: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
922: EXCEPTION
923: WHEN e_passport_err THEN
924: l_error_msg := Substrb(l_msg_data,1,2000);
925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

921: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
922: EXCEPTION
923: WHEN e_passport_err THEN
924: l_error_msg := Substrb(l_msg_data,1,2000);
925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
926: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
928: Hr_Utility.raise_error;
929: WHEN Others THEN

Line 926: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

922: EXCEPTION
923: WHEN e_passport_err THEN
924: l_error_msg := Substrb(l_msg_data,1,2000);
925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
926: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
928: Hr_Utility.raise_error;
929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);

Line 927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

923: WHEN e_passport_err THEN
924: l_error_msg := Substrb(l_msg_data,1,2000);
925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
926: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
928: Hr_Utility.raise_error;
929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 928: Hr_Utility.raise_error;

924: l_error_msg := Substrb(l_msg_data,1,2000);
925: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
926: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
928: Hr_Utility.raise_error;
929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

Line 931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

927: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
928: Hr_Utility.raise_error;
929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
933: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
934: Hr_Utility.raise_error;
935: END InsUpd_OSS_PassPort;

Line 932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

928: Hr_Utility.raise_error;
929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
933: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
934: Hr_Utility.raise_error;
935: END InsUpd_OSS_PassPort;
936: -- =============================================================================

Line 933: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

929: WHEN Others THEN
930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
933: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
934: Hr_Utility.raise_error;
935: END InsUpd_OSS_PassPort;
936: -- =============================================================================
937: -- ~ InsUpd_OSS_Visa:

Line 934: Hr_Utility.raise_error;

930: l_error_msg := Substrb(SQLERRM,1,2000);
931: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
932: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
933: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
934: Hr_Utility.raise_error;
935: END InsUpd_OSS_PassPort;
936: -- =============================================================================
937: -- ~ InsUpd_OSS_Visa:
938: -- =============================================================================

Line 966: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

962: e_visa_syn_err EXCEPTION;
963: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_OSS_Visa';
964: l_dft_date Varchar2(150);
965: BEGIN
966: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
967: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);
968: Hr_Utility.set_location('..p_party_id: '||p_party_id, 5);
969: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
970:

Line 968: Hr_Utility.set_location('..p_party_id: '||p_party_id, 5);

964: l_dft_date Varchar2(150);
965: BEGIN
966: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
967: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);
968: Hr_Utility.set_location('..p_party_id: '||p_party_id, 5);
969: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
970:
971: SQLstmt:='SELECT '||
972: ' rowid '||

Line 1049: Hr_Utility.set_location('..Visa Number: '||p_pei_info_rec_new.pei_information6, 6);

1045: -- Expiry Date -R = pei_information8 = igs_pe_visa.visa_expiry_date
1046: -- J Visa Category = pei_information9 = default to 99
1047: -- Pass To Interface = pei_information10 = N
1048: -- ===========================================================================
1049: Hr_Utility.set_location('..Visa Number: '||p_pei_info_rec_new.pei_information6, 6);
1050: IF p_action = 'INSERT' THEN
1051: l_oss_visa_rec.visa_type := p_pei_info_rec_new.pei_information5;
1052: l_oss_visa_rec.visa_number := p_pei_info_rec_new.pei_information6;
1053: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date

Line 1068: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);

1064: OPEN csr_Visa FOR SQLstmt
1065: Using p_party_id
1066: ,p_pei_info_rec_old.pei_information6;
1067: FETCH csr_Visa INTO l_oss_visa_rec_old;
1068: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);
1069: IF csr_Visa%FOUND THEN
1070: IF (p_pei_info_rec_old.pei_information5 =
1071: p_pei_info_rec_new.pei_information5) AND
1072: (Fnd_Date.Canonical_To_Date

Line 1078: Hr_Utility.set_location('..Visa Number found. ', 12);

1074: Fnd_Date.Canonical_To_Date
1075: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1076: )
1077: THEN
1078: Hr_Utility.set_location('..Visa Number found. ', 12);
1079: -- The Visa being updated exists in OSS
1080: l_update_OSS_rec := TRUE;
1081: l_oss_visa_rec := l_oss_visa_rec_old;
1082: END IF;

Line 1084: Hr_Utility.set_location('..Visa Number NOT found. ', 12);

1080: l_update_OSS_rec := TRUE;
1081: l_oss_visa_rec := l_oss_visa_rec_old;
1082: END IF;
1083: ELSE
1084: Hr_Utility.set_location('..Visa Number NOT found. ', 12);
1085: -- That means the visa that is being updated in HR is not there
1086: -- in OSS, so create it.
1087: l_update_OSS_rec := FALSE;
1088: l_insert_OSS_rec := TRUE;

Line 1099: Hr_Utility.set_location('..After Dynamic SQL cursor ', 13);

1095: OPEN csr_Visa FOR SQLstmt
1096: Using p_party_id
1097: ,p_pei_info_rec_new.pei_information6;
1098: FETCH csr_Visa INTO l_oss_visa_rec_old;
1099: Hr_Utility.set_location('..After Dynamic SQL cursor ', 13);
1100: IF csr_Visa%NOTFOUND THEN
1101: Hr_Utility.set_location('..Visa Number NOT found. ', 14);
1102: l_Insert_OSS_Rec := TRUE;
1103: ELSIF (p_pei_info_rec_new.pei_information5 =

Line 1101: Hr_Utility.set_location('..Visa Number NOT found. ', 14);

1097: ,p_pei_info_rec_new.pei_information6;
1098: FETCH csr_Visa INTO l_oss_visa_rec_old;
1099: Hr_Utility.set_location('..After Dynamic SQL cursor ', 13);
1100: IF csr_Visa%NOTFOUND THEN
1101: Hr_Utility.set_location('..Visa Number NOT found. ', 14);
1102: l_Insert_OSS_Rec := TRUE;
1103: ELSIF (p_pei_info_rec_new.pei_information5 =
1104: p_pei_info_rec_old.pei_information5) OR
1105: (Fnd_Date.Canonical_To_Date

Line 1110: Hr_Utility.set_location('..Visa Number found. ', 15);

1106: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) <>
1107: Fnd_Date.Canonical_To_Date
1108: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1109: ) THEN
1110: Hr_Utility.set_location('..Visa Number found. ', 15);
1111: l_Update_OSS_Rec := TRUE;
1112: l_oss_visa_rec := l_oss_visa_rec_old;
1113: END IF;
1114: CLOSE csr_Visa;

Line 1127: Hr_Utility.set_location('..p_action: '||p_action, 19);

1123:
1124: END IF;
1125:
1126: -- Insert Into OSS
1127: Hr_Utility.set_location('..p_action: '||p_action, 19);
1128: IF l_insert_OSS_rec THEN
1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);
1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);
1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);

Line 1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);

1125:
1126: -- Insert Into OSS
1127: Hr_Utility.set_location('..p_action: '||p_action, 19);
1128: IF l_insert_OSS_rec THEN
1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);
1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);
1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);
1132: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 20);
1133:

Line 1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);

1126: -- Insert Into OSS
1127: Hr_Utility.set_location('..p_action: '||p_action, 19);
1128: IF l_insert_OSS_rec THEN
1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);
1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);
1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);
1132: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 20);
1133:
1134: PLSQL_Block :=

Line 1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);

1127: Hr_Utility.set_location('..p_action: '||p_action, 19);
1128: IF l_insert_OSS_rec THEN
1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);
1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);
1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);
1132: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 20);
1133:
1134: PLSQL_Block :=
1135: 'DECLARE

Line 1132: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 20);

1128: IF l_insert_OSS_rec THEN
1129: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 20);
1130: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,20);
1131: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 20);
1132: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 20);
1133:
1134: PLSQL_Block :=
1135: 'DECLARE
1136: l_visa_rec Igs_Pe_Visapass_Pub.Visa_Rec_TYPE;

Line 1168: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 21);

1164:
1165: END IF;
1166: -- Update Into OSS
1167: IF l_update_OSS_rec THEN
1168: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 21);
1169: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,21);
1170: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 21);
1171: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 21);
1172:

Line 1169: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,21);

1165: END IF;
1166: -- Update Into OSS
1167: IF l_update_OSS_rec THEN
1168: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 21);
1169: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,21);
1170: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 21);
1171: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 21);
1172:
1173: PLSQL_Block :=

Line 1170: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 21);

1166: -- Update Into OSS
1167: IF l_update_OSS_rec THEN
1168: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 21);
1169: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,21);
1170: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 21);
1171: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 21);
1172:
1173: PLSQL_Block :=
1174: 'DECLARE

Line 1171: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 21);

1167: IF l_update_OSS_rec THEN
1168: Hr_Utility.set_location('..visa_type: '||l_oss_visa_rec.visa_type, 21);
1169: Hr_Utility.set_location('..visa_number: '||l_oss_visa_rec.visa_number,21);
1170: Hr_Utility.set_location('..visa_issue_date: '||l_oss_visa_rec.visa_issue_date, 21);
1171: Hr_Utility.set_location('..visa_expiry_date: '||l_oss_visa_rec.visa_expiry_date, 21);
1172:
1173: PLSQL_Block :=
1174: 'DECLARE
1175: l_visa_rec Igs_Pe_Visapass_Pub.Visa_Rec_TYPE;

Line 1205: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);

1201: ,OUT l_msg_count
1202: ,OUT l_msg_data;
1203:
1204: END IF;
1205: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
1206: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
1207: IF l_return_status IN ('E','U') THEN
1208: RAISE e_visa_syn_err;
1209: END IF;

Line 1206: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);

1202: ,OUT l_msg_data;
1203:
1204: END IF;
1205: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
1206: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
1207: IF l_return_status IN ('E','U') THEN
1208: RAISE e_visa_syn_err;
1209: END IF;
1210:

Line 1211: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

1207: IF l_return_status IN ('E','U') THEN
1208: RAISE e_visa_syn_err;
1209: END IF;
1210:
1211: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
1212: EXCEPTION
1213: WHEN e_visa_syn_err THEN
1214: l_error_msg := Substrb(l_msg_data,1,2000);
1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1211: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
1212: EXCEPTION
1213: WHEN e_visa_syn_err THEN
1214: l_error_msg := Substrb(l_msg_data,1,2000);
1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1216: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1218: Hr_Utility.raise_error;
1219: WHEN Others THEN

Line 1216: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

1212: EXCEPTION
1213: WHEN e_visa_syn_err THEN
1214: l_error_msg := Substrb(l_msg_data,1,2000);
1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1216: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1218: Hr_Utility.raise_error;
1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);

Line 1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1213: WHEN e_visa_syn_err THEN
1214: l_error_msg := Substrb(l_msg_data,1,2000);
1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1216: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1218: Hr_Utility.raise_error;
1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 1218: Hr_Utility.raise_error;

1214: l_error_msg := Substrb(l_msg_data,1,2000);
1215: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1216: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1218: Hr_Utility.raise_error;
1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

Line 1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1217: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1218: Hr_Utility.raise_error;
1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1223: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1224: Hr_Utility.raise_error;
1225: END InsUpd_OSS_Visa;

Line 1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

1218: Hr_Utility.raise_error;
1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1223: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1224: Hr_Utility.raise_error;
1225: END InsUpd_OSS_Visa;
1226:

Line 1223: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1219: WHEN Others THEN
1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1223: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1224: Hr_Utility.raise_error;
1225: END InsUpd_OSS_Visa;
1226:
1227: -- =============================================================================

Line 1224: Hr_Utility.raise_error;

1220: l_error_msg := Substrb(SQLERRM,1,2000);
1221: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1222: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1223: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1224: Hr_Utility.raise_error;
1225: END InsUpd_OSS_Visa;
1226:
1227: -- =============================================================================
1228: -- ~ InsUpd_OSS_VistHistory:

Line 1265: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1261: l_Update_OSS_rec Boolean;
1262: l_Insert_OSS_rec Boolean;
1263: l_dft_date Varchar2(150);
1264: BEGIN
1265: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1266: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);
1267: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
1268: SQLstmt := ' SELECT row_id
1269: ,port_of_entry

Line 1334: Hr_Utility.set_location(' p_action: '||p_action, 10);

1330: -- Entry Number = pei_information12 = igs_pe_visit_histry.cntry_entry_form_num
1331: -- Port Of Entry (VS) = pei_information13 = igs_pe_visit_histry.port_of_entry
1332: -- ================================================================================
1333: IF p_action = 'INSERT' THEN
1334: Hr_Utility.set_location(' p_action: '||p_action, 10);
1335: l_oss_vvhist_rec_new.visit_start_date
1336: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information7);
1337: l_oss_vvhist_rec_new.visit_end_date
1338: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information8);

Line 1348: Hr_Utility.set_location(' p_action: '||p_action, 10);

1344: l_Insert_OSS_Rec := TRUE;
1345: l_visa_no := p_pei_info_rec_new.pei_information11;
1346:
1347: ELSIF p_action = 'UPDATE' THEN
1348: Hr_Utility.set_location(' p_action: '||p_action, 10);
1349: Hr_Utility.set_location(' Old Visa Number: '||p_pei_info_rec_old.pei_information11, 10);
1350: Hr_Utility.set_location(' New Visa Number: '||p_pei_info_rec_new.pei_information11, 10);
1351: IF (Trim(p_pei_info_rec_old.pei_information11) =
1352: Trim(p_pei_info_rec_new.pei_information11)) THEN

Line 1349: Hr_Utility.set_location(' Old Visa Number: '||p_pei_info_rec_old.pei_information11, 10);

1345: l_visa_no := p_pei_info_rec_new.pei_information11;
1346:
1347: ELSIF p_action = 'UPDATE' THEN
1348: Hr_Utility.set_location(' p_action: '||p_action, 10);
1349: Hr_Utility.set_location(' Old Visa Number: '||p_pei_info_rec_old.pei_information11, 10);
1350: Hr_Utility.set_location(' New Visa Number: '||p_pei_info_rec_new.pei_information11, 10);
1351: IF (Trim(p_pei_info_rec_old.pei_information11) =
1352: Trim(p_pei_info_rec_new.pei_information11)) THEN
1353: Hr_Utility.set_location(' Visa Number: '||p_pei_info_rec_new.pei_information11, 11);

Line 1350: Hr_Utility.set_location(' New Visa Number: '||p_pei_info_rec_new.pei_information11, 10);

1346:
1347: ELSIF p_action = 'UPDATE' THEN
1348: Hr_Utility.set_location(' p_action: '||p_action, 10);
1349: Hr_Utility.set_location(' Old Visa Number: '||p_pei_info_rec_old.pei_information11, 10);
1350: Hr_Utility.set_location(' New Visa Number: '||p_pei_info_rec_new.pei_information11, 10);
1351: IF (Trim(p_pei_info_rec_old.pei_information11) =
1352: Trim(p_pei_info_rec_new.pei_information11)) THEN
1353: Hr_Utility.set_location(' Visa Number: '||p_pei_info_rec_new.pei_information11, 11);
1354: OPEN csr_visit FOR SQLstmt

Line 1353: Hr_Utility.set_location(' Visa Number: '||p_pei_info_rec_new.pei_information11, 11);

1349: Hr_Utility.set_location(' Old Visa Number: '||p_pei_info_rec_old.pei_information11, 10);
1350: Hr_Utility.set_location(' New Visa Number: '||p_pei_info_rec_new.pei_information11, 10);
1351: IF (Trim(p_pei_info_rec_old.pei_information11) =
1352: Trim(p_pei_info_rec_new.pei_information11)) THEN
1353: Hr_Utility.set_location(' Visa Number: '||p_pei_info_rec_new.pei_information11, 11);
1354: OPEN csr_visit FOR SQLstmt
1355: Using p_party_id
1356: ,p_pei_info_rec_new.pei_information11;
1357: FETCH csr_visit INTO l_oss_vvhist_rec_old ;

Line 1359: Hr_Utility.set_location(' Visit History record found in OSS ', 11);

1355: Using p_party_id
1356: ,p_pei_info_rec_new.pei_information11;
1357: FETCH csr_visit INTO l_oss_vvhist_rec_old ;
1358: IF csr_visit%FOUND THEN
1359: Hr_Utility.set_location(' Visit History record found in OSS ', 11);
1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);
1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);
1362: IF Fnd_Date.Canonical_To_Date
1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>

Line 1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);

1356: ,p_pei_info_rec_new.pei_information11;
1357: FETCH csr_visit INTO l_oss_vvhist_rec_old ;
1358: IF csr_visit%FOUND THEN
1359: Hr_Utility.set_location(' Visit History record found in OSS ', 11);
1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);
1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);
1362: IF Fnd_Date.Canonical_To_Date
1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1364: Fnd_Date.Canonical_To_Date

Line 1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);

1357: FETCH csr_visit INTO l_oss_vvhist_rec_old ;
1358: IF csr_visit%FOUND THEN
1359: Hr_Utility.set_location(' Visit History record found in OSS ', 11);
1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);
1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);
1362: IF Fnd_Date.Canonical_To_Date
1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1364: Fnd_Date.Canonical_To_Date
1365: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))

Line 1367: Hr_Utility.set_location(' New End Date <> Old End Date ', 11);

1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1364: Fnd_Date.Canonical_To_Date
1365: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))
1366: THEN
1367: Hr_Utility.set_location(' New End Date <> Old End Date ', 11);
1368: -- The Visa Visit History being updated exists in OSS
1369: l_update_OSS_rec := TRUE;
1370: l_oss_vvhist_rec_new := l_oss_vvhist_rec_old;
1371: END IF;

Line 1373: Hr_Utility.set_location(' Visit History record NOT found in OSS ', 11);

1369: l_update_OSS_rec := TRUE;
1370: l_oss_vvhist_rec_new := l_oss_vvhist_rec_old;
1371: END IF;
1372: ELSE
1373: Hr_Utility.set_location(' Visit History record NOT found in OSS ', 11);
1374: -- That means the visa visit history that is being updated in
1375: -- HR is not there in OSS, so create it.
1376: l_update_OSS_rec := FALSE;
1377: l_insert_OSS_rec := TRUE;

Line 1384: Hr_Utility.set_location(' Old Visa Number : '||p_pei_info_rec_old.pei_information11, 11);

1380: CLOSE csr_visit;
1381:
1382: ELSIF (Trim(p_pei_info_rec_old.pei_information11) <>
1383: Trim(p_pei_info_rec_new.pei_information11)) THEN
1384: Hr_Utility.set_location(' Old Visa Number : '||p_pei_info_rec_old.pei_information11, 11);
1385: Hr_Utility.set_location(' New Visa Number : '||p_pei_info_rec_new.pei_information11, 11);
1386: OPEN csr_visit FOR SQLstmt
1387: Using p_party_id
1388: ,p_pei_info_rec_new.pei_information11;

Line 1385: Hr_Utility.set_location(' New Visa Number : '||p_pei_info_rec_new.pei_information11, 11);

1381:
1382: ELSIF (Trim(p_pei_info_rec_old.pei_information11) <>
1383: Trim(p_pei_info_rec_new.pei_information11)) THEN
1384: Hr_Utility.set_location(' Old Visa Number : '||p_pei_info_rec_old.pei_information11, 11);
1385: Hr_Utility.set_location(' New Visa Number : '||p_pei_info_rec_new.pei_information11, 11);
1386: OPEN csr_visit FOR SQLstmt
1387: Using p_party_id
1388: ,p_pei_info_rec_new.pei_information11;
1389: FETCH csr_visit INTO l_oss_vvhist_rec_old ;

Line 1412: Hr_Utility.set_location(' Get the visa_id for : '||p_pei_info_rec_old.pei_information11, 12);

1408: l_oss_vvhist_rec_new.port_of_entry := p_pei_info_rec_new.pei_information13;
1409:
1410: END IF;
1411: -- Insert Into OSS
1412: Hr_Utility.set_location(' Get the visa_id for : '||p_pei_info_rec_old.pei_information11, 12);
1413: SQLstmt:='SELECT visa_id
1414: FROM igs_pe_visa
1415: WHERE person_id = :c_party_id
1416: AND visa_number = :c_visa_number';

Line 1422: Hr_Utility.set_location(' Old Visa Id: '||l_old_visa_id, 13);

1418: OPEN csr_visa FOR SQLstmt Using p_party_id
1419: ,p_pei_info_rec_old.pei_information11;
1420: FETCH csr_visa INTO l_old_visa_id;
1421: CLOSE csr_visa;
1422: Hr_Utility.set_location(' Old Visa Id: '||l_old_visa_id, 13);
1423:
1424: OPEN csr_visa FOR SQLstmt Using p_party_id
1425: ,p_pei_info_rec_new.pei_information11;
1426: FETCH csr_visa INTO l_new_visa_id;

Line 1428: Hr_Utility.set_location(' New Visa Id: '||l_new_visa_id, 13);

1424: OPEN csr_visa FOR SQLstmt Using p_party_id
1425: ,p_pei_info_rec_new.pei_information11;
1426: FETCH csr_visa INTO l_new_visa_id;
1427: CLOSE csr_visa;
1428: Hr_Utility.set_location(' New Visa Id: '||l_new_visa_id, 13);
1429:
1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);
1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);
1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);

Line 1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);

1426: FETCH csr_visa INTO l_new_visa_id;
1427: CLOSE csr_visa;
1428: Hr_Utility.set_location(' New Visa Id: '||l_new_visa_id, 13);
1429:
1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);
1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);
1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);
1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);
1434:

Line 1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);

1427: CLOSE csr_visa;
1428: Hr_Utility.set_location(' New Visa Id: '||l_new_visa_id, 13);
1429:
1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);
1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);
1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);
1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);
1434:
1435: IF l_insert_OSS_rec THEN

Line 1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);

1428: Hr_Utility.set_location(' New Visa Id: '||l_new_visa_id, 13);
1429:
1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);
1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);
1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);
1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);
1434:
1435: IF l_insert_OSS_rec THEN
1436: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;

Line 1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);

1429:
1430: Hr_Utility.set_location(' port_of_entry: '||l_oss_vvhist_rec_new.port_of_entry, 15);
1431: Hr_Utility.set_location(' cntry_entry_form_num: '||l_oss_vvhist_rec_new.cntry_entry_form_num, 15);
1432: Hr_Utility.set_location(' visit_start_date: '||l_oss_vvhist_rec_new.visit_start_date, 15);
1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);
1434:
1435: IF l_insert_OSS_rec THEN
1436: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;
1437: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);

Line 1437: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);

1433: Hr_Utility.set_location(' visit_end_date: '||l_oss_vvhist_rec_new.visit_end_date, 15);
1434:
1435: IF l_insert_OSS_rec THEN
1436: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;
1437: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);
1438: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Create_VisitHistry', 21);
1439: PLSQL_Block :=
1440: 'DECLARE
1441: l_visit_hstry_rec Igs_Pe_Visapass_Pub.Visit_Hstry_Rec_TYPE;

Line 1438: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Create_VisitHistry', 21);

1434:
1435: IF l_insert_OSS_rec THEN
1436: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;
1437: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);
1438: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Create_VisitHistry', 21);
1439: PLSQL_Block :=
1440: 'DECLARE
1441: l_visit_hstry_rec Igs_Pe_Visapass_Pub.Visit_Hstry_Rec_TYPE;
1442: BEGIN

Line 1473: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);

1469: END IF;
1470: -- Update Into OSS
1471: IF l_update_OSS_rec THEN
1472: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;
1473: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);
1474: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Update_VisitHistry', 21);
1475:
1476: PLSQL_Block :=
1477: 'DECLARE

Line 1474: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Update_VisitHistry', 21);

1470: -- Update Into OSS
1471: IF l_update_OSS_rec THEN
1472: l_oss_vvhist_rec_new.visa_id := l_new_visa_id;
1473: Hr_Utility.set_location(' visa_id: '||l_new_visa_id, 21);
1474: Hr_Utility.set_location(' Calling: IGS_PE_VisaPass_Pub.Update_VisitHistry', 21);
1475:
1476: PLSQL_Block :=
1477: 'DECLARE
1478: l_visit_hstry_rec Igs_Pe_Visapass_Pub.Visit_Hstry_Rec_TYPE;

Line 1507: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);

1503: ,OUT l_return_status
1504: ,OUT l_msg_count
1505: ,OUT l_msg_data;
1506: END IF;
1507: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
1508: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
1509: IF l_return_status IN ('E','U') THEN
1510: RAISE e_visit_hstry_err;
1511: END IF;

Line 1508: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);

1504: ,OUT l_msg_count
1505: ,OUT l_msg_data;
1506: END IF;
1507: Hr_Utility.set_location(' l_return_status: '||l_return_status, 45);
1508: Hr_Utility.set_location(' l_msg_data: '||l_msg_data, 45);
1509: IF l_return_status IN ('E','U') THEN
1510: RAISE e_visit_hstry_err;
1511: END IF;
1512:

Line 1513: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

1509: IF l_return_status IN ('E','U') THEN
1510: RAISE e_visit_hstry_err;
1511: END IF;
1512:
1513: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
1514:
1515: EXCEPTION
1516: WHEN e_visit_hstry_err THEN
1517: l_error_msg := Substrb(l_msg_data,1,2000);

Line 1518: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1514:
1515: EXCEPTION
1516: WHEN e_visit_hstry_err THEN
1517: l_error_msg := Substrb(l_msg_data,1,2000);
1518: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1519: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1521: Hr_Utility.raise_error;
1522: WHEN Others THEN

Line 1519: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

1515: EXCEPTION
1516: WHEN e_visit_hstry_err THEN
1517: l_error_msg := Substrb(l_msg_data,1,2000);
1518: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1519: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1521: Hr_Utility.raise_error;
1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);

Line 1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1516: WHEN e_visit_hstry_err THEN
1517: l_error_msg := Substrb(l_msg_data,1,2000);
1518: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1519: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1521: Hr_Utility.raise_error;
1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 1521: Hr_Utility.raise_error;

1517: l_error_msg := Substrb(l_msg_data,1,2000);
1518: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1519: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1521: Hr_Utility.raise_error;
1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

Line 1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

1520: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1521: Hr_Utility.raise_error;
1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1526: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1527: Hr_Utility.raise_error;
1528: END InsUpd_OSS_VisitHistory;

Line 1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

1521: Hr_Utility.raise_error;
1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1526: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1527: Hr_Utility.raise_error;
1528: END InsUpd_OSS_VisitHistory;
1529:

Line 1526: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1522: WHEN Others THEN
1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1526: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1527: Hr_Utility.raise_error;
1528: END InsUpd_OSS_VisitHistory;
1529:
1530: -- =============================================================================

Line 1527: Hr_Utility.raise_error;

1523: l_error_msg := Substrb(SQLERRM,1,2000);
1524: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1525: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1526: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1527: Hr_Utility.raise_error;
1528: END InsUpd_OSS_VisitHistory;
1529:
1530: -- =============================================================================
1531: -- ~ InsUpd_InHR_PassPort:

Line 1570: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1566: --
1567: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_PassPort';
1568: --
1569: BEGIN
1570: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1571: SAVEPOINT oss_passport_dtls;
1572: l_passport_category := 'PER_US_PASSPORT_DETAILS';
1573: --
1574: SQLstmt := ' SELECT pap.rowid '||

Line 1606: Hr_Utility.set_location(' Creating: '||l_passport_category, 8);

1602:
1603:
1604: l_person_extra_info_rec := NULL;
1605: -- Create the Passport details in HRMS
1606: Hr_Utility.set_location(' Creating: '||l_passport_category, 8);
1607: l_person_extra_info_rec.information_type := l_passport_category;
1608: l_person_extra_info_rec.pei_information_category := l_passport_category;
1609: -- ===========================================================================
1610: -- Country (VS)-R = pei_information5 = igs_pe_passport.passport_cntry_code

Line 1661: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

1657: CLOSE csr_pp;
1658: p_passport_warning := FALSE;
1659: p_pp_error_code := NULL;
1660:
1661: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1662:
1663: EXCEPTION
1664: WHEN Others THEN
1665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

Line 1665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1661: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1662:
1663: EXCEPTION
1664: WHEN Others THEN
1665: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1666: IF csr_pp%ISOPEN THEN
1667: CLOSE csr_pp;
1668: END IF;
1669: IF csr_pe_pass%ISOPEN THEN

Line 1720: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1716: --
1717: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visa';
1718: --
1719: BEGIN
1720: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1721: SAVEPOINT oss_visa_dtls;
1722: l_visa_category := 'PER_US_VISA_DETAILS';
1723: --
1724: SQLstmt:='SELECT '||

Line 1765: Hr_Utility.set_location(' Creating: '||l_visa_category, 8);

1761:
1762:
1763: l_person_extra_info_rec := NULL;
1764: -- Create the Passport details in HRMS
1765: Hr_Utility.set_location(' Creating: '||l_visa_category, 8);
1766: l_person_extra_info_rec.information_type := l_visa_category;
1767: l_person_extra_info_rec.pei_information_category := l_visa_category;
1768: -- ===========================================================================
1769: -- Visa Type(VS)-R = pei_information5 = igs_pe_visa.visa_type

Line 1814: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

1810: END LOOP;
1811: CLOSE csr_visa;
1812: p_visa_warning := FALSE;
1813: p_visa_error_code := NULL;
1814: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1815:
1816: EXCEPTION
1817: WHEN Others THEN
1818: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

Line 1818: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1814: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1815:
1816: EXCEPTION
1817: WHEN Others THEN
1818: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1819: IF csr_visa%ISOPEN THEN
1820: CLOSE csr_visa;
1821: END IF;
1822: IF csr_pe_visa%ISOPEN THEN

Line 1872: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1868: --
1869: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visit';
1870: --
1871: BEGIN
1872: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1873: SAVEPOINT oss_vv_dtls;
1874: l_visit_category := 'PER_US_VISIT_HISTORY';
1875: --
1876: SQLstmt:=' SELECT row_id '||

Line 1895: Hr_Utility.set_location(' Creating: '||l_visit_category, 8);

1891: ' WHERE person_id = :c_party_id ';
1892:
1893: l_person_extra_info_rec := NULL;
1894: -- Create the Visa Visit History details in HRMS
1895: Hr_Utility.set_location(' Creating: '||l_visit_category, 8);
1896: l_person_extra_info_rec.information_type := l_visit_category;
1897: l_person_extra_info_rec.pei_information_category := l_visit_category;
1898: -- =================================================================================
1899: -- Purpose (VS)-R = pei_information5 = This is Specific to HRMS

Line 1947: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

1943: END LOOP;
1944: CLOSE csr_visit;
1945: p_visit_warning := FALSE;
1946: p_visit_error_code := NULL;
1947: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1948:
1949: EXCEPTION
1950: WHEN Others THEN
1951: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

Line 1951: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1947: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1948:
1949: EXCEPTION
1950: WHEN Others THEN
1951: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1952: IF csr_visit%ISOPEN THEN
1953: CLOSE csr_visit;
1954: END IF;
1955: IF csr_pe_visit%ISOPEN THEN

Line 2009: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2005: SELECT hzp.party_number
2006: FROM hz_parties hzp
2007: WHERE hzp.party_id = c_party_id;
2008: BEGIN
2009: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2010: SAVEPOINT oss_per_dtls;
2011: l_oss_person_details := 'PQP_OSS_PERSON_DETAILS';
2012: --
2013: SQLstmt:=

Line 2029: Hr_Utility.set_location(' Creating: PQP_OSS_PERSON_DETAILS', 8);

2025: '''FACULTY'''||','||'''OTHER''' ||')' ;
2026:
2027: l_person_extra_info_rec := NULL;
2028: -- Create the OSS Person EIT information
2029: Hr_Utility.set_location(' Creating: PQP_OSS_PERSON_DETAILS', 8);
2030:
2031: l_person_extra_info_rec.information_type := l_oss_person_details;
2032: l_person_extra_info_rec.pei_information_category := l_oss_person_details;
2033: -- ===========================================================================

Line 2043: Hr_Utility.set_location(' After Dyn SQL Ref Cursor', 8);

2039: -- ===========================================================================
2040: OPEN csr_igs FOR SQLstmt Using p_party_id;
2041: FETCH csr_igs INTO l_oss_per_details;
2042: CLOSE csr_igs;
2043: Hr_Utility.set_location(' After Dyn SQL Ref Cursor', 8);
2044: l_person_extra_info_rec.pei_information1 := Nvl(l_oss_per_details.system_type
2045: ,'STUDENT');
2046: l_person_extra_info_rec.pei_information2 := l_oss_per_details.person_number;
2047: IF l_oss_per_details.person_number IS NULL THEN

Line 2060: Hr_Utility.set_location(' After Cursor :csr_OSS_pe', 8);

2056: l_person_extra_info_rec.pei_information5 := 'Y';
2057: OPEN csr_OSS_pe (c_person_id => p_person_id
2058: ,c_information_type => l_oss_person_details);
2059: FETCH csr_OSS_pe INTO l_OSS_pe;
2060: Hr_Utility.set_location(' After Cursor :csr_OSS_pe', 8);
2061: IF csr_OSS_pe%NOTFOUND THEN
2062: InsUpd_Per_Extra_info
2063: (p_person_id => p_person_id
2064: ,p_business_group_id => p_business_group_id

Line 2084: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

2080: END IF;
2081: CLOSE csr_OSS_pe;
2082: p_oss_error_code := NULL;
2083: p_ossDtls_warning := FALSE;
2084: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2085:
2086: EXCEPTION
2087: WHEN Others THEN
2088: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

Line 2088: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

2084: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2085:
2086: EXCEPTION
2087: WHEN Others THEN
2088: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2089: IF csr_OSS_pe%ISOPEN THEN
2090: CLOSE csr_OSS_pe;
2091: END IF;
2092:

Line 2116: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2112:
2113: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Person_Address_API';
2114: l_error_msg Varchar2(2000);
2115: BEGIN
2116: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2117: IF Nvl(p_action,'CREATE') = 'CREATE' THEN
2118: Hr_Utility.set_location('..Creating primary address: '||p_HR_Address_Rec.Style, 6);
2119: Hr_Person_Address_Api.Create_Person_Address
2120: (p_validate => Nvl(p_validate,FALSE)

Line 2118: Hr_Utility.set_location('..Creating primary address: '||p_HR_Address_Rec.Style, 6);

2114: l_error_msg Varchar2(2000);
2115: BEGIN
2116: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2117: IF Nvl(p_action,'CREATE') = 'CREATE' THEN
2118: Hr_Utility.set_location('..Creating primary address: '||p_HR_Address_Rec.Style, 6);
2119: Hr_Person_Address_Api.Create_Person_Address
2120: (p_validate => Nvl(p_validate,FALSE)
2121: ,p_effective_date => p_effective_date
2122: ,p_pradd_ovlapval_override => Nvl(p_pradd_ovlapval_override,FALSE)

Line 2177: Hr_Utility.set_location('..Updating Primary Address: '||p_HR_Address_Rec.Style, 6);

2173: ,p_address_id => p_HR_address_id
2174: ,p_object_version_number => p_HR_object_version_number
2175: );
2176: ELSIF p_action ='UPDATE' THEN
2177: Hr_Utility.set_location('..Updating Primary Address: '||p_HR_Address_Rec.Style, 6);
2178: Hr_Person_Address_Api.Update_Person_Address
2179: (p_validate => Nvl(p_validate,FALSE)
2180: ,p_effective_date => p_effective_date
2181: ,p_validate_county => Nvl(p_validate_county,TRUE)

Line 2233: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

2229: ,p_add_information20 => p_HR_Address_Rec.add_information20
2230: ,p_party_id => p_HR_Address_Rec.party_id
2231: );
2232: END IF;
2233: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2234: EXCEPTION
2235: WHEN Others THEN
2236: l_error_msg := Substrb(SQLERRM,1,2000);
2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

2233: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2234: EXCEPTION
2235: WHEN Others THEN
2236: l_error_msg := Substrb(SQLERRM,1,2000);
2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2238: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2239: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2240: Hr_Utility.raise_error;
2241:

Line 2238: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

2234: EXCEPTION
2235: WHEN Others THEN
2236: l_error_msg := Substrb(SQLERRM,1,2000);
2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2238: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2239: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2240: Hr_Utility.raise_error;
2241:
2242: END Person_Address_API;

Line 2239: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

2235: WHEN Others THEN
2236: l_error_msg := Substrb(SQLERRM,1,2000);
2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2238: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2239: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2240: Hr_Utility.raise_error;
2241:
2242: END Person_Address_API;
2243:

Line 2240: Hr_Utility.raise_error;

2236: l_error_msg := Substrb(SQLERRM,1,2000);
2237: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2238: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2239: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2240: Hr_Utility.raise_error;
2241:
2242: END Person_Address_API;
2243:
2244: -- =============================================================================

Line 2274: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2270: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Address_TCA_To_HR';
2271: l_map_info_category Varchar2(150);
2272: l_error_msg Varchar2(2000);
2273: BEGIN
2274: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2275: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2276: EXCEPTION
2277: WHEN Others THEN
2278: l_error_msg := Substrb(SQLERRM,1,2000);

Line 2275: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

2271: l_map_info_category Varchar2(150);
2272: l_error_msg Varchar2(2000);
2273: BEGIN
2274: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2275: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2276: EXCEPTION
2277: WHEN Others THEN
2278: l_error_msg := Substrb(SQLERRM,1,2000);
2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

2275: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2276: EXCEPTION
2277: WHEN Others THEN
2278: l_error_msg := Substrb(SQLERRM,1,2000);
2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2280: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2281: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2282: Hr_Utility.raise_error;
2283:

Line 2280: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

2276: EXCEPTION
2277: WHEN Others THEN
2278: l_error_msg := Substrb(SQLERRM,1,2000);
2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2280: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2281: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2282: Hr_Utility.raise_error;
2283:
2284: END Create_Address_TCA_To_HR;

Line 2281: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

2277: WHEN Others THEN
2278: l_error_msg := Substrb(SQLERRM,1,2000);
2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2280: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2281: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2282: Hr_Utility.raise_error;
2283:
2284: END Create_Address_TCA_To_HR;
2285:

Line 2282: Hr_Utility.raise_error;

2278: l_error_msg := Substrb(SQLERRM,1,2000);
2279: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
2280: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
2281: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2282: Hr_Utility.raise_error;
2283:
2284: END Create_Address_TCA_To_HR;
2285:
2286: -- =============================================================================

Line 2309: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2305: ) AS
2306: l_proc_name Varchar2(150);
2307: BEGIN
2308: l_proc_name := g_pkg ||'Create_Address_TCA_To_HR';
2309: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2310:
2311:
2312: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2313: END Update_Address_TCA_To_HR;

Line 2312: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

2308: l_proc_name := g_pkg ||'Create_Address_TCA_To_HR';
2309: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2310:
2311:
2312: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
2313: END Update_Address_TCA_To_HR;
2314: -- =============================================================================
2315: -- ~ Check_HR_Validations:
2316: -- =============================================================================

Line 3346: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3342:
3343: l_valid_col_value Varchar2(150);
3344: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Map_To_TCA_Address';
3345: BEGIN
3346: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3347: Hr_Utility.set_location('..p_column_name : '||p_column_name, 6);
3348: Hr_Utility.set_location('..p_column_value : '||p_column_value, 6);
3349: Hr_Utility.set_location('..p_col_lookup_type: '||p_col_lookup_type, 6);
3350:

Line 3347: Hr_Utility.set_location('..p_column_name : '||p_column_name, 6);

3343: l_valid_col_value Varchar2(150);
3344: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Map_To_TCA_Address';
3345: BEGIN
3346: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3347: Hr_Utility.set_location('..p_column_name : '||p_column_name, 6);
3348: Hr_Utility.set_location('..p_column_value : '||p_column_value, 6);
3349: Hr_Utility.set_location('..p_col_lookup_type: '||p_col_lookup_type, 6);
3350:
3351: IF p_column_name IS NULL THEN

Line 3348: Hr_Utility.set_location('..p_column_value : '||p_column_value, 6);

3344: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'Map_To_TCA_Address';
3345: BEGIN
3346: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3347: Hr_Utility.set_location('..p_column_name : '||p_column_name, 6);
3348: Hr_Utility.set_location('..p_column_value : '||p_column_value, 6);
3349: Hr_Utility.set_location('..p_col_lookup_type: '||p_col_lookup_type, 6);
3350:
3351: IF p_column_name IS NULL THEN
3352: RETURN;

Line 3349: Hr_Utility.set_location('..p_col_lookup_type: '||p_col_lookup_type, 6);

3345: BEGIN
3346: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3347: Hr_Utility.set_location('..p_column_name : '||p_column_name, 6);
3348: Hr_Utility.set_location('..p_column_value : '||p_column_value, 6);
3349: Hr_Utility.set_location('..p_col_lookup_type: '||p_col_lookup_type, 6);
3350:
3351: IF p_column_name IS NULL THEN
3352: RETURN;
3353: ELSIF p_column_name = 'ADDRESS1' THEN

Line 3444: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3440:
3441: p_HZ_Location_Row.Country := l_valid_col_value;
3442:
3443: END IF;
3444: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3445: END Map_To_TCA_Address;
3446:
3447: -- =============================================================================
3448: -- Create_Address_HR_To_TCA:

Line 3492: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3488: e_oss_add_failure EXCEPTION;
3489: l_error_msg Varchar2(2000);
3490: --
3491: BEGIN
3492: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3493: -- Get the Person HR Address
3494: l_HR_Address_Rec := p_per_addr_rec_new;
3495:
3496: -- Get the business group's Leg. Code

Line 3500: Hr_Utility.set_location('..l_leg_code : '||l_leg_code, 5);

3496: -- Get the business group's Leg. Code
3497: OPEN csr_bg_code(l_HR_Address_Rec.Business_group_id);
3498: FETCH csr_bg_code INTO l_leg_code;
3499: CLOSE csr_bg_code;
3500: Hr_Utility.set_location('..l_leg_code : '||l_leg_code, 5);
3501: --
3502: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3503: l_lookup_map := l_add_map||'_LOOKUP';
3504: Hr_Utility.set_location('..l_add_map : '||l_add_map, 5);

Line 3504: Hr_Utility.set_location('..l_add_map : '||l_add_map, 5);

3500: Hr_Utility.set_location('..l_leg_code : '||l_leg_code, 5);
3501: --
3502: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3503: l_lookup_map := l_add_map||'_LOOKUP';
3504: Hr_Utility.set_location('..l_add_map : '||l_add_map, 5);
3505: Hr_Utility.set_location('..l_lookup_map : '||l_lookup_map, 5);
3506: -- Get the Address Column mappings for context: PER_TCA_ADD_[XX]
3507: OPEN csr_TCA_Map
3508: (c_info_category => l_add_map

Line 3505: Hr_Utility.set_location('..l_lookup_map : '||l_lookup_map, 5);

3501: --
3502: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3503: l_lookup_map := l_add_map||'_LOOKUP';
3504: Hr_Utility.set_location('..l_add_map : '||l_add_map, 5);
3505: Hr_Utility.set_location('..l_lookup_map : '||l_lookup_map, 5);
3506: -- Get the Address Column mappings for context: PER_TCA_ADD_[XX]
3507: OPEN csr_TCA_Map
3508: (c_info_category => l_add_map
3509: ,c_bg_grp_id => l_HR_Address_Rec.business_group_id

Line 3514: Hr_Utility.set_location('..Mapping for rec not found for : '||l_add_map, 5);

3510: ,c_bg_grp_leg_code => l_HR_Address_Rec.Style);
3511:
3512: FETCH csr_TCA_Map INTO l_Address_Mapping;
3513: IF csr_TCA_Map%NOTFOUND THEN
3514: Hr_Utility.set_location('..Mapping for rec not found for : '||l_add_map, 5);
3515: END IF;
3516: CLOSE csr_TCA_Map;
3517:
3518: -- Get Column Lookup mapping record for context: PER_TCA_ADD_[XX]_LOOKUP

Line 3526: Hr_Utility.set_location('..Mapping for rec not found for : '||l_lookup_map, 5);

3522: ,c_bg_grp_leg_code => l_HR_Address_Rec.Style);
3523:
3524: FETCH csr_TCA_Map INTO l_LookUp_Mapping;
3525: IF csr_TCA_Map%NOTFOUND THEN
3526: Hr_Utility.set_location('..Mapping for rec not found for : '||l_lookup_map, 5);
3527: END IF;
3528: CLOSE csr_TCA_Map;
3529: -- HR: Address Line1
3530: Map_To_TCA_Address

Line 3667: Hr_Utility.set_location('..Call OSS Package : Igs_Pe_Person_Addr_Pkg.Insert_Row', 5);

3663: (p_column_name => l_Address_Mapping.pcv_information20
3664: ,p_column_value => l_HR_Address_Rec.Telephone_Number_3
3665: ,p_col_lookup_type => l_LookUp_Mapping.pcv_information20
3666: ,p_HZ_Location_Row => l_HZ_Location_Row);
3667: Hr_Utility.set_location('..Call OSS Package : Igs_Pe_Person_Addr_Pkg.Insert_Row', 5);
3668: -- Call OSS API to create Student address in HZ
3669: PLSQL_Block :=
3670: 'BEGIN '||
3671: 'Igs_Pe_Person_Addr_Pkg.Insert_Row '||

Line 3747: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

3743: ,OUT p_msg_data;
3744: IF p_return_status IN ('E','U') THEN
3745: RAISE e_oss_add_failure;
3746: END IF;
3747: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
3748:
3749: EXCEPTION
3750: WHEN e_oss_add_failure THEN
3751: l_error_msg := Substrb(p_msg_data,1,2000);

Line 3752: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

3748:
3749: EXCEPTION
3750: WHEN e_oss_add_failure THEN
3751: l_error_msg := Substrb(p_msg_data,1,2000);
3752: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3753: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3754: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3755: Hr_Utility.raise_error;
3756:

Line 3753: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

3749: EXCEPTION
3750: WHEN e_oss_add_failure THEN
3751: l_error_msg := Substrb(p_msg_data,1,2000);
3752: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3753: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3754: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3755: Hr_Utility.raise_error;
3756:
3757: WHEN Others THEN

Line 3754: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3750: WHEN e_oss_add_failure THEN
3751: l_error_msg := Substrb(p_msg_data,1,2000);
3752: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3753: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3754: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3755: Hr_Utility.raise_error;
3756:
3757: WHEN Others THEN
3758: l_error_msg := Substrb(SQLERRM,1,2000);

Line 3755: Hr_Utility.raise_error;

3751: l_error_msg := Substrb(p_msg_data,1,2000);
3752: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3753: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3754: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3755: Hr_Utility.raise_error;
3756:
3757: WHEN Others THEN
3758: l_error_msg := Substrb(SQLERRM,1,2000);
3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

3755: Hr_Utility.raise_error;
3756:
3757: WHEN Others THEN
3758: l_error_msg := Substrb(SQLERRM,1,2000);
3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3760: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3761: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3762: Hr_Utility.raise_error;
3763:

Line 3760: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

3756:
3757: WHEN Others THEN
3758: l_error_msg := Substrb(SQLERRM,1,2000);
3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3760: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3761: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3762: Hr_Utility.raise_error;
3763:
3764: END Create_Address_HR_To_TCA;

Line 3761: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3757: WHEN Others THEN
3758: l_error_msg := Substrb(SQLERRM,1,2000);
3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3760: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3761: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3762: Hr_Utility.raise_error;
3763:
3764: END Create_Address_HR_To_TCA;
3765: -- =============================================================================

Line 3762: Hr_Utility.raise_error;

3758: l_error_msg := Substrb(SQLERRM,1,2000);
3759: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
3760: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
3761: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3762: Hr_Utility.raise_error;
3763:
3764: END Create_Address_HR_To_TCA;
3765: -- =============================================================================
3766: -- ~ Update_Address_HR_To_TCA

Line 3831: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3827: e_oss_add_failure EXCEPTION;
3828: l_error_msg Varchar2(2000);
3829:
3830: BEGIN
3831: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3832: -- Get the Person HR Address
3833: l_HR_Address_Rec := p_per_addr_rec_new;
3834: g_effective_date := p_effective_date;
3835: --

Line 3837: Hr_Utility.set_location('..Dyn SQL to get ovn of location and site', 6);

3833: l_HR_Address_Rec := p_per_addr_rec_new;
3834: g_effective_date := p_effective_date;
3835: --
3836: IF p_location_id IS NULL THEN
3837: Hr_Utility.set_location('..Dyn SQL to get ovn of location and site', 6);
3838: OPEN csr_party_add FOR g_hz_add_sql
3839: Using l_HR_Address_Rec.party_id;
3840: FETCH csr_party_add INTO
3841: p_location_id

Line 3847: Hr_Utility.set_location('..After Fetch of Dyn SQL.', 6);

3843: ,p_last_update_date
3844: ,p_party_site_ovn
3845: ,p_location_ovn
3846: ,p_rowid;
3847: Hr_Utility.set_location('..After Fetch of Dyn SQL.', 6);
3848: IF csr_party_add%NOTFOUND THEN
3849: Hr_Utility.set_location('..Cannot find existing party primary address', 7);
3850: CLOSE csr_party_add;
3851: ELSE

Line 3849: Hr_Utility.set_location('..Cannot find existing party primary address', 7);

3845: ,p_location_ovn
3846: ,p_rowid;
3847: Hr_Utility.set_location('..After Fetch of Dyn SQL.', 6);
3848: IF csr_party_add%NOTFOUND THEN
3849: Hr_Utility.set_location('..Cannot find existing party primary address', 7);
3850: CLOSE csr_party_add;
3851: ELSE
3852: Hr_Utility.set_location('..Dyn SQL found loc record', 7);
3853: CLOSE csr_party_add;

Line 3852: Hr_Utility.set_location('..Dyn SQL found loc record', 7);

3848: IF csr_party_add%NOTFOUND THEN
3849: Hr_Utility.set_location('..Cannot find existing party primary address', 7);
3850: CLOSE csr_party_add;
3851: ELSE
3852: Hr_Utility.set_location('..Dyn SQL found loc record', 7);
3853: CLOSE csr_party_add;
3854:
3855: OPEN csr_hz_loc(c_hz_location_id => p_location_id);
3856: FETCH csr_hz_loc INTO l_HZ_Location_Cur_Row;

Line 3858: Hr_Utility.set_location('..Dyn SQL against OSS to get start date', 8);

3854:
3855: OPEN csr_hz_loc(c_hz_location_id => p_location_id);
3856: FETCH csr_hz_loc INTO l_HZ_Location_Cur_Row;
3857: CLOSE csr_hz_loc;
3858: Hr_Utility.set_location('..Dyn SQL against OSS to get start date', 8);
3859: OPEN csr_dt FOR g_adddt_sql
3860: Using l_HR_Address_Rec.party_id
3861: ,p_location_id;
3862: FETCH csr_dt INTO l_OSS_Date_From,

Line 3884: Hr_Utility.set_location('..p_effective_date : '||p_effective_date, 8);

3880: END IF;
3881:
3882: END IF;
3883: --
3884: Hr_Utility.set_location('..p_effective_date : '||p_effective_date, 8);
3885: -- Get the business group's Leg. Code
3886: OPEN csr_bg_code(l_HR_Address_Rec.Business_group_id);
3887: FETCH csr_bg_code INTO l_leg_code;
3888: IF csr_bg_code%NOTFOUND THEN

Line 3889: Hr_Utility.set_location('..Leg Code not found for Id : '||

3885: -- Get the business group's Leg. Code
3886: OPEN csr_bg_code(l_HR_Address_Rec.Business_group_id);
3887: FETCH csr_bg_code INTO l_leg_code;
3888: IF csr_bg_code%NOTFOUND THEN
3889: Hr_Utility.set_location('..Leg Code not found for Id : '||
3890: l_HR_Address_Rec.Business_group_id,5);
3891: END IF;
3892: CLOSE csr_bg_code;
3893: --

Line 3894: Hr_Utility.set_location('..Bus Grp Leg Code: '||l_leg_code, 6);

3890: l_HR_Address_Rec.Business_group_id,5);
3891: END IF;
3892: CLOSE csr_bg_code;
3893: --
3894: Hr_Utility.set_location('..Bus Grp Leg Code: '||l_leg_code, 6);
3895: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3896: l_lookup_map := l_add_map||'_LOOKUP';
3897:
3898: Hr_Utility.set_location('..l_add_map : '||l_add_map, 7);

Line 3898: Hr_Utility.set_location('..l_add_map : '||l_add_map, 7);

3894: Hr_Utility.set_location('..Bus Grp Leg Code: '||l_leg_code, 6);
3895: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3896: l_lookup_map := l_add_map||'_LOOKUP';
3897:
3898: Hr_Utility.set_location('..l_add_map : '||l_add_map, 7);
3899: Hr_Utility.set_location('..l_lookup_map: '||l_lookup_map,7);
3900: -- Get the Address Column mappings for context: PQP_HRTCA_TCAADD_[XX]
3901: OPEN csr_TCA_Map
3902: (c_info_category => l_add_map

Line 3899: Hr_Utility.set_location('..l_lookup_map: '||l_lookup_map,7);

3895: l_add_map := 'PQP_HRTCA_TCAADD_'|| l_HR_Address_Rec.Style;
3896: l_lookup_map := l_add_map||'_LOOKUP';
3897:
3898: Hr_Utility.set_location('..l_add_map : '||l_add_map, 7);
3899: Hr_Utility.set_location('..l_lookup_map: '||l_lookup_map,7);
3900: -- Get the Address Column mappings for context: PQP_HRTCA_TCAADD_[XX]
3901: OPEN csr_TCA_Map
3902: (c_info_category => l_add_map
3903: ,c_bg_grp_id => l_HR_Address_Rec.business_group_id

Line 3908: Hr_Utility.set_location('..Mapping rec. not found for : '||l_add_map,8);

3904: ,c_bg_grp_leg_code => l_HR_Address_Rec.Style);
3905:
3906: FETCH csr_TCA_Map INTO l_Address_Mapping;
3907: IF csr_TCA_Map%NOTFOUND THEN
3908: Hr_Utility.set_location('..Mapping rec. not found for : '||l_add_map,8);
3909: END IF;
3910: CLOSE csr_TCA_Map;
3911:
3912: -- Get Column Lookup mapping record for context: PQP_HRTCA_TCAADD_[XX]_LOOKUP

Line 3920: Hr_Utility.set_location('..Mapping rec. not found for : '||l_lookup_map,8);

3916: ,c_bg_grp_leg_code => l_HR_Address_Rec.Style);
3917:
3918: FETCH csr_TCA_Map INTO l_LookUp_Mapping;
3919: IF csr_TCA_Map%NOTFOUND THEN
3920: Hr_Utility.set_location('..Mapping rec. not found for : '||l_lookup_map,8);
3921: END IF;
3922:
3923: CLOSE csr_TCA_Map;
3924: -- HR: Address Line1

Line 4064: Hr_Utility.set_location('..Calling OSS API : Igs_Pe_Person_Addr_Pkg.Update_Row',8);

4060: ,p_col_lookup_type => l_LookUp_Mapping.pcv_information20
4061: ,p_HZ_Location_Row => l_HZ_Location_Row);
4062:
4063: -- Call OSS API to update Student address in HZ
4064: Hr_Utility.set_location('..Calling OSS API : Igs_Pe_Person_Addr_Pkg.Update_Row',8);
4065: IF l_update_pri_add THEN
4066: PLSQL_Block :=
4067: 'BEGIN ' ||
4068: 'Igs_Pe_Person_Addr_Pkg.Update_Row ' ||

Line 4142: Hr_Utility.set_location('..Call OSS Package : Igs_Pe_Person_Addr_Pkg.Insert_Row', 8);

4138: ,OUT p_return_status
4139: ,OUT p_msg_data;
4140: END IF;
4141: IF l_create_pri_add THEN
4142: Hr_Utility.set_location('..Call OSS Package : Igs_Pe_Person_Addr_Pkg.Insert_Row', 8);
4143: -- Call OSS API to create Student address in HZ
4144: PLSQL_Block :=
4145: 'BEGIN '||
4146: 'Igs_Pe_Person_Addr_Pkg.Insert_Row '||

Line 4223: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);

4219: END IF;
4220: IF p_return_status IN ('E','U') THEN
4221: RAISE e_oss_add_failure;
4222: END IF;
4223: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
4224: EXCEPTION
4225: WHEN e_oss_add_failure THEN
4226: l_error_msg := Substrb(p_msg_data,1,2000);
4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

4223: Hr_Utility.set_location('Leaving: '||l_proc_name, 50);
4224: EXCEPTION
4225: WHEN e_oss_add_failure THEN
4226: l_error_msg := Substrb(p_msg_data,1,2000);
4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4228: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4229: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
4230: Hr_Utility.raise_error;
4231:

Line 4228: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

4224: EXCEPTION
4225: WHEN e_oss_add_failure THEN
4226: l_error_msg := Substrb(p_msg_data,1,2000);
4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4228: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4229: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
4230: Hr_Utility.raise_error;
4231:
4232: WHEN Others THEN

Line 4229: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

4225: WHEN e_oss_add_failure THEN
4226: l_error_msg := Substrb(p_msg_data,1,2000);
4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4228: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4229: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
4230: Hr_Utility.raise_error;
4231:
4232: WHEN Others THEN
4233: l_error_msg := Substrb(SQLERRM,1,2000);

Line 4230: Hr_Utility.raise_error;

4226: l_error_msg := Substrb(p_msg_data,1,2000);
4227: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4228: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4229: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
4230: Hr_Utility.raise_error;
4231:
4232: WHEN Others THEN
4233: l_error_msg := Substrb(SQLERRM,1,2000);
4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

4230: Hr_Utility.raise_error;
4231:
4232: WHEN Others THEN
4233: l_error_msg := Substrb(SQLERRM,1,2000);
4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4235: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4236: Hr_Utility.set_location('Leaving: '||l_proc_name, 91);
4237: Hr_Utility.raise_error;
4238:

Line 4235: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

4231:
4232: WHEN Others THEN
4233: l_error_msg := Substrb(SQLERRM,1,2000);
4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4235: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4236: Hr_Utility.set_location('Leaving: '||l_proc_name, 91);
4237: Hr_Utility.raise_error;
4238:
4239: END Update_Address_HR_To_TCA;

Line 4236: Hr_Utility.set_location('Leaving: '||l_proc_name, 91);

4232: WHEN Others THEN
4233: l_error_msg := Substrb(SQLERRM,1,2000);
4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4235: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4236: Hr_Utility.set_location('Leaving: '||l_proc_name, 91);
4237: Hr_Utility.raise_error;
4238:
4239: END Update_Address_HR_To_TCA;
4240:

Line 4237: Hr_Utility.raise_error;

4233: l_error_msg := Substrb(SQLERRM,1,2000);
4234: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
4235: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
4236: Hr_Utility.set_location('Leaving: '||l_proc_name, 91);
4237: Hr_Utility.raise_error;
4238:
4239: END Update_Address_HR_To_TCA;
4240:
4241: END PQP_HRTCA_Integration;