DBA Data[Home] [Help]

APPS.PQP_RIW_LOCATION_WRAPPER dependencies on HR_UTILITY

Line 18: hr_utility.set_location('Entering Default Rec' , 25);

14: return hr_locations_all%rowtype is
15: l_proc_name constant varchar2(150) := g_package||'Default_Locations_Rec';
16: l_location_rec hr_locations_all%rowtype;
17: Begin
18: hr_utility.set_location('Entering Default Rec' , 25);
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;

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

108: return l_location_rec;
109:
110: exception
111: when others then
112: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
113: raise;
114:
115: end Default_Location_Rec;
116:

Line 446: hr_utility.set_location('Entered PQP_RIW_LOCATION_WRAPPER.INSUPD_LOCATION', 5);

442:
443: temp_rec hr_locations_all%rowtype;
444:
445: begin
446: hr_utility.set_location('Entered PQP_RIW_LOCATION_WRAPPER.INSUPD_LOCATION', 5);
447:
448: l_migration_flag := p_migration_flag;
449:
450: if p_global_flag = 'Y' then

Line 764: -- hr_utility.set_location(' Leaving:' || l_proc, 30);

760: --
761: -- p_object_version_number := null;
762: -- p_finance_line_id := l_finance_line_id;
763: -- p_return_status := hr_multi_message.get_return_status_disable;
764: -- hr_utility.set_location(' Leaving:' || l_proc, 30);
765: -- when others then
766: --
767: -- When Multiple Message Detection is enabled catch
768: -- any Application specific or other unexpected

Line 777: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

773: -- rollback to enrollment_proc;
774:
775:
776: when e_upl_not_allowed then
777: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then

Line 778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);

774:
775:
776: when e_upl_not_allowed then
777: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

Line 779: hr_utility.set_location('Leaving: ' || l_proc, 90);

775:
776: when e_upl_not_allowed then
777: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 780: hr_utility.raise_error;

776: when e_upl_not_allowed then
777: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
784: hr_utility.set_location('Leaving: ' || l_proc, 100);

Line 782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

778: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
784: hr_utility.set_location('Leaving: ' || l_proc, 100);
785: hr_utility.raise_error;
786: when others then

Line 783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

779: hr_utility.set_location('Leaving: ' || l_proc, 90);
780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
784: hr_utility.set_location('Leaving: ' || l_proc, 100);
785: hr_utility.raise_error;
786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);

Line 784: hr_utility.set_location('Leaving: ' || l_proc, 100);

780: hr_utility.raise_error;
781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
784: hr_utility.set_location('Leaving: ' || l_proc, 100);
785: hr_utility.raise_error;
786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 785: hr_utility.raise_error;

781: when e_crt_not_allowed then
782: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
783: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
784: hr_utility.set_location('Leaving: ' || l_proc, 100);
785: hr_utility.raise_error;
786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

784: hr_utility.set_location('Leaving: ' || l_proc, 100);
785: hr_utility.raise_error;
786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);

Line 789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

785: hr_utility.raise_error;
786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;

Line 790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

786: when others then
787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;
794: --if hr_multi_message.unexpected_error_add(l_proc) then

Line 791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );

787: --l_error_msg := Substr(SQLERRM,1,2000);
788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;
794: --if hr_multi_message.unexpected_error_add(l_proc) then
795: -- hr_utility.set_location(' Leaving:' || l_proc,40);

Line 792: hr_utility.set_location('Leaving: ' || l_proc, 110);

788: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;
794: --if hr_multi_message.unexpected_error_add(l_proc) then
795: -- hr_utility.set_location(' Leaving:' || l_proc,40);
796: --raise;

Line 793: hr_utility.raise_error;

789: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
790: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;
794: --if hr_multi_message.unexpected_error_add(l_proc) then
795: -- hr_utility.set_location(' Leaving:' || l_proc,40);
796: --raise;
797: --end if;

Line 795: -- hr_utility.set_location(' Leaving:' || l_proc,40);

791: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
792: hr_utility.set_location('Leaving: ' || l_proc, 110);
793: hr_utility.raise_error;
794: --if hr_multi_message.unexpected_error_add(l_proc) then
795: -- hr_utility.set_location(' Leaving:' || l_proc,40);
796: --raise;
797: --end if;
798: --
799: -- Reset IN OUT and set OUT parameters

Line 804: -- hr_utility.set_location(' Leaving:' || l_proc,50);

800: --
801: -- p_object_version_number := null;
802: -- p_finance_line_id := l_finance_line_id;
803: --p_return_status := hr_multi_message.get_return_status_disable;
804: -- hr_utility.set_location(' Leaving:' || l_proc,50);
805:
806:
807: end INSUPD_LOCATION;
808: end PQP_RIW_LOCATION_WRAPPER;