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_RIW_ENROLL_WRAPPER dependencies on HR_UTILITY

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

17: l_enroll_rec ota_delegate_bookings_v%rowtype;
18:
19: begin
20:
21: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
22: /*
23: ==========================================================================
24: g_varchar2 constant varchar2(9) := '$Sys_Def$';
25: g_number constant number := -987123654;

Line 29: Hr_Utility.set_location(' One : ', 5);

25: g_number constant number := -987123654;
26: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
27: ==========================================================================
28: */
29: Hr_Utility.set_location(' One : ', 5);
30:
31: l_enroll_rec.booking_status_type_id := hr_api.g_number ;
32: l_enroll_rec.delegate_person_id := hr_api.g_number ;
33: l_enroll_rec.sponsor_contact_id := hr_api.g_number ;

Line 100: Hr_Utility.set_location(' OneThree : ', 5);

96:
97: l_enroll_rec.booking_deal_type := hr_api.g_varchar2 ;
98:
99: l_enroll_rec.booking_deal_id := hr_api.g_number ;
100: Hr_Utility.set_location(' OneThree : ', 5);
101: -- l_enroll_rec.enrollment_type := hr_api.g_varchar2 ;
102: l_enroll_rec.organization_id := hr_api.g_number ;
103: l_enroll_rec.sponsor_person_id := hr_api.g_number ;
104: l_enroll_rec.sponsor_assignment_id := hr_api.g_number ;

Line 112: Hr_Utility.set_location(' OneFour : ', 5);

108: l_enroll_rec.correspondent_email := hr_api.g_varchar2 ;
109: l_enroll_rec.third_party_email := hr_api.g_varchar2 ;
110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);

Line 114: Hr_Utility.set_location(' 1 : ', 5);

110: l_enroll_rec.correspondent_address_type := hr_api.g_varchar2 ;
111: l_enroll_rec.line_id := hr_api.g_number ;
112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);

Line 116: Hr_Utility.set_location(' 2 : ', 5);

112: Hr_Utility.set_location(' OneFour : ', 5);
113: l_enroll_rec.org_id := hr_api.g_number ;
114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;

Line 118: Hr_Utility.set_location(' 3 : ', 5);

114: Hr_Utility.set_location(' 1 : ', 5);
115: -- l_enroll_rec.daemon_flag := hr_api.g_varchar2 ;
116: Hr_Utility.set_location(' 2 : ', 5);
117: -- l_enroll_rec.daemon_type := hr_api.g_varchar2 ;
118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);

Line 122: Hr_Utility.set_location(' 4 : ', 5);

118: Hr_Utility.set_location(' 3 : ', 5);
119: l_enroll_rec.old_event_id := hr_api.g_number ;
120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;

Line 124: Hr_Utility.set_location(' 5 : ', 5);

120: l_enroll_rec.quote_line_id := hr_api.g_number ;
121: l_enroll_rec.interface_source := hr_api.g_varchar2 ;
122: Hr_Utility.set_location(' 4 : ', 5);
123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;

Line 127: Hr_Utility.set_location(' OneTwo : ', 5);

123: l_enroll_rec.total_training_time := hr_api.g_varchar2 ;
124: Hr_Utility.set_location(' 5 : ', 5);
125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;

Line 129: Hr_Utility.set_location(' OneFive : ', 5);

125: l_enroll_rec.content_player_status := hr_api.g_varchar2 ;
126: l_enroll_rec.score := hr_api.g_number ;
127: Hr_Utility.set_location(' OneTwo : ', 5);
128: l_enroll_rec.completed_content := hr_api.g_number ;
129: Hr_Utility.set_location(' OneFive : ', 5);
130: l_enroll_rec.total_content := hr_api.g_number ;
131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;
133:

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

131: l_enroll_rec.booking_justification_id := hr_api.g_number ;
132: -- l_enroll_rec.is_history_flag := hr_api.g_varchar2 ;
133:
134:
135: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
136: return l_enroll_rec;
137: exception
138: when others then
139: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

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

135: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
136: return l_enroll_rec;
137: exception
138: when others then
139: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
140: raise;
141:
142: end Default_Enroll_Rec;
143:

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

167: col_name varchar2(150);
168: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
169: begin
170:
171: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
172: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
173: l_enroll_rec := Default_Enroll_Rec;
174: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
175: hr_utility.set_location('g_interface_code'||g_interface_code, 5);

Line 172: hr_utility.set_location('p_interface_code'||p_interface_code, 10);

168: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
169: begin
170:
171: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
172: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
173: l_enroll_rec := Default_Enroll_Rec;
174: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
175: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
176:

Line 174: hr_utility.set_location('p_interface_code'||p_interface_code, 20);

170:
171: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
172: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
173: l_enroll_rec := Default_Enroll_Rec;
174: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
175: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
176:
177:
178: for col_rec in bne_cols (g_interface_code)

Line 175: hr_utility.set_location('g_interface_code'||g_interface_code, 5);

171: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
172: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
173: l_enroll_rec := Default_Enroll_Rec;
174: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
175: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
176:
177:
178: for col_rec in bne_cols (g_interface_code)
179: loop

Line 180: hr_utility.set_location(' in loop col_rec.interface_col_name'||col_rec.interface_col_name, 15);

176:
177:
178: for col_rec in bne_cols (g_interface_code)
179: loop
180: hr_utility.set_location(' in loop col_rec.interface_col_name'||col_rec.interface_col_name, 15);
181: case col_rec.interface_col_name
182:
183: when 'p_booking_status_type_id' then
184: l_enroll_rec.booking_status_type_id := g_enroll_rec.booking_status_type_id;

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

358: else
359: null;
360: end case;
361: end loop;
362: Hr_Utility.set_location(' Leaving: '||l_proc_name, 80);
363: return l_enroll_rec;
364:
365: end Get_Record_Values;
366:

Line 542: -- hr_utility.trace_on(null , 'Enroll_Trace');

538: and per.person_id =p_sponsor_person_id;
539:
540: Begin
541:
542: -- hr_utility.trace_on(null , 'Enroll_Trace');
543: hr_utility.set_location(' Entering:' || l_proc,10);
544: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
545: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
546:

Line 543: hr_utility.set_location(' Entering:' || l_proc,10);

539:
540: Begin
541:
542: -- hr_utility.trace_on(null , 'Enroll_Trace');
543: hr_utility.set_location(' Entering:' || l_proc,10);
544: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
545: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
546:
547: l_crt_upd_len := LENGTH(p_crt_upd);

Line 544: hr_utility.trace('delegate person id : ' || p_delegate_person_id);

540: Begin
541:
542: -- hr_utility.trace_on(null , 'Enroll_Trace');
543: hr_utility.set_location(' Entering:' || l_proc,10);
544: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
545: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
546:
547: l_crt_upd_len := LENGTH(p_crt_upd);
548: g_crt_upd := SUBSTR(p_crt_upd, 1, 1);

Line 545: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);

541:
542: -- hr_utility.trace_on(null , 'Enroll_Trace');
543: hr_utility.set_location(' Entering:' || l_proc,10);
544: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
545: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
546:
547: l_crt_upd_len := LENGTH(p_crt_upd);
548: g_crt_upd := SUBSTR(p_crt_upd, 1, 1);
549: IF l_crt_upd_len > 1 THEN

Line 572: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);

568: FETCH spon_ass_id INTO c_sponsor_assignment_id;
569: CLOSE spon_ass_id;
570: end if;
571:
572: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
573: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
574:
575: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
576:

Line 573: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);

569: CLOSE spon_ass_id;
570: end if;
571:
572: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
573: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
574:
575: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
576:
577:

Line 575: hr_utility.trace('g_crt_upd : ' || g_crt_upd);

571:
572: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
573: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
574:
575: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
576:
577:
578:
579: --

Line 592: hr_utility.set_location('The booking_id is : ', l_booking_id);

588: else
589: l_create_flag := 1; --create booking
590: end if;
591:
592: hr_utility.set_location('The booking_id is : ', l_booking_id);
593:
594:
595:
596: hr_utility.trace('l_create_flag'||l_create_flag);

Line 596: hr_utility.trace('l_create_flag'||l_create_flag);

592: hr_utility.set_location('The booking_id is : ', l_booking_id);
593:
594:
595:
596: hr_utility.trace('l_create_flag'||l_create_flag);
597:
598:
599: if (g_crt_upd = 'D') then
600: raise e_upl_not_allowed; -- View only flag is enabled but Trying to Upload

Line 710: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);

706:
707: if(l_create_flag = 2) then
708:
709:
710: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);
711:
712: --p_object_version_number := 1;
713: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
714: g_interface_code := nvl(l_interface_code,'PQP_OLM_ENROL_INTF');

Line 713: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);

709:
710: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);
711:
712: --p_object_version_number := 1;
713: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
714: g_interface_code := nvl(l_interface_code,'PQP_OLM_ENROL_INTF');
715: hr_utility.set_location('g_interface_code'||g_interface_code, 95);
716:
717: g_enroll_rec.booking_status_type_id := p_booking_status_type_id ;

Line 715: hr_utility.set_location('g_interface_code'||g_interface_code, 95);

711:
712: --p_object_version_number := 1;
713: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
714: g_interface_code := nvl(l_interface_code,'PQP_OLM_ENROL_INTF');
715: hr_utility.set_location('g_interface_code'||g_interface_code, 95);
716:
717: g_enroll_rec.booking_status_type_id := p_booking_status_type_id ;
718: g_enroll_rec.delegate_person_id := p_delegate_person_id ;
719: g_enroll_rec.sponsor_contact_id := p_contact_id ;

Line 722: hr_utility.trace('global p_event_id : ' || p_event_id);

718: g_enroll_rec.delegate_person_id := p_delegate_person_id ;
719: g_enroll_rec.sponsor_contact_id := p_contact_id ;
720: g_enroll_rec.business_group_id := p_business_group_id ;
721: g_enroll_rec.event_id := p_event_id ;
722: hr_utility.trace('global p_event_id : ' || p_event_id);
723: hr_utility.trace('g_enroll_rec.event_id : ' || g_enroll_rec.event_id);
724: g_enroll_rec.customer_id := p_customer_id ;
725: g_enroll_rec.authorizer_person_id := p_authorizer_person_id ;
726: g_enroll_rec.date_booking_placed := p_date_booking_placed ;

Line 723: hr_utility.trace('g_enroll_rec.event_id : ' || g_enroll_rec.event_id);

719: g_enroll_rec.sponsor_contact_id := p_contact_id ;
720: g_enroll_rec.business_group_id := p_business_group_id ;
721: g_enroll_rec.event_id := p_event_id ;
722: hr_utility.trace('global p_event_id : ' || p_event_id);
723: hr_utility.trace('g_enroll_rec.event_id : ' || g_enroll_rec.event_id);
724: g_enroll_rec.customer_id := p_customer_id ;
725: g_enroll_rec.authorizer_person_id := p_authorizer_person_id ;
726: g_enroll_rec.date_booking_placed := p_date_booking_placed ;
727: g_enroll_rec.correspondent := p_corespondent ;

Line 808: hr_utility.trace('l_enroll_rec.event_id : ' || l_enroll_rec.event_id);

804: from ota_delegate_bookings where
805: booking_id = l_booking_id;
806:
807: l_enroll_rec := Get_Record_Values(g_interface_code);
808: hr_utility.trace('l_enroll_rec.event_id : ' || l_enroll_rec.event_id);
809:
810: update_delegate_booking
811: (p_effective_date => p_effective_date
812: ,p_booking_id => l_booking_id

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

917: --
918: -- p_object_version_number := null;
919: -- p_finance_line_id := l_finance_line_id;
920: -- p_return_status := hr_multi_message.get_return_status_disable;
921: -- hr_utility.set_location(' Leaving:' || l_proc, 30);
922: -- when others then
923: --
924: -- When Multiple Message Detection is enabled catch
925: -- any Application specific or other unexpected

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

930: -- rollback to enrollment_proc;
931:
932:
933: when e_upl_not_allowed then
934: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
935: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then

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

931:
932:
933: when e_upl_not_allowed then
934: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
935: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

932:
933: when e_upl_not_allowed then
934: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
935: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 937: hr_utility.raise_error;

933: when e_upl_not_allowed then
934: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
935: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
941: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

935: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
941: hr_utility.set_location('Leaving: ' || l_proc, 100);
942: hr_utility.raise_error;
943: when others then

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

936: hr_utility.set_location('Leaving: ' || l_proc, 90);
937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
941: hr_utility.set_location('Leaving: ' || l_proc, 100);
942: hr_utility.raise_error;
943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);

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

937: hr_utility.raise_error;
938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
941: hr_utility.set_location('Leaving: ' || l_proc, 100);
942: hr_utility.raise_error;
943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 942: hr_utility.raise_error;

938: when e_crt_not_allowed then
939: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
940: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
941: hr_utility.set_location('Leaving: ' || l_proc, 100);
942: hr_utility.raise_error;
943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

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

941: hr_utility.set_location('Leaving: ' || l_proc, 100);
942: hr_utility.raise_error;
943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);

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

942: hr_utility.raise_error;
943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;

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

943: when others then
944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;
951: --if hr_multi_message.unexpected_error_add(l_proc) then

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

944: --l_error_msg := Substr(SQLERRM,1,2000);
945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;
951: --if hr_multi_message.unexpected_error_add(l_proc) then
952: -- hr_utility.set_location(' Leaving:' || l_proc,40);

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

945: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;
951: --if hr_multi_message.unexpected_error_add(l_proc) then
952: -- hr_utility.set_location(' Leaving:' || l_proc,40);
953: --raise;

Line 950: hr_utility.raise_error;

946: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
947: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;
951: --if hr_multi_message.unexpected_error_add(l_proc) then
952: -- hr_utility.set_location(' Leaving:' || l_proc,40);
953: --raise;
954: --end if;

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

948: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
949: hr_utility.set_location('Leaving: ' || l_proc, 110);
950: hr_utility.raise_error;
951: --if hr_multi_message.unexpected_error_add(l_proc) then
952: -- hr_utility.set_location(' Leaving:' || l_proc,40);
953: --raise;
954: --end if;
955: --
956: -- Reset IN OUT and set OUT parameters

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

957: --
958: -- p_object_version_number := null;
959: -- p_finance_line_id := l_finance_line_id;
960: --p_return_status := hr_multi_message.get_return_status_disable;
961: -- hr_utility.set_location(' Leaving:' || l_proc,50);
962:
963: end InsUpd_Enroll;
964:
965:

Line 1069: hr_utility.set_location(' Entering:' || l_proc,10);

1065: -- Other variables
1066: l_booking_id number;
1067: l_proc varchar2(72) := g_package ||'create_delegate_booking';
1068: Begin
1069: hr_utility.set_location(' Entering:' || l_proc,10);
1070: --
1071: -- Issue a savepoint
1072: --
1073: savepoint create_delegate_booking;

Line 1201: hr_utility.set_location(' Leaving:' || l_proc,20);

1197: -- messages of any type exist in the Multiple Message List.
1198: -- Also disable Multiple Message Detection.
1199: --
1200: p_return_status := hr_multi_message.get_return_status_disable;
1201: hr_utility.set_location(' Leaving:' || l_proc,20);
1202: --
1203: exception
1204: when hr_multi_message.error_message_exist then
1205: --

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

1213: --
1214: p_object_version_number := null;
1215: p_finance_line_id := l_finance_line_id;
1216: p_return_status := hr_multi_message.get_return_status_disable;
1217: hr_utility.set_location(' Leaving:' || l_proc, 30);
1218: when others then
1219: --
1220: -- When Multiple Message Detection is enabled catch
1221: -- any Application specific or other unexpected

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

1224: -- error.
1225: --
1226: rollback to create_delegate_booking;
1227: -- if hr_multi_message.unexpected_error_add(l_proc) then
1228: hr_utility.set_location(' Leaving:' || l_proc,40);
1229: raise;
1230: -- end if;
1231: --
1232: -- Reset IN OUT and set OUT parameters

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

1233: --
1234: p_object_version_number := null;
1235: p_finance_line_id := l_finance_line_id;
1236: p_return_status := hr_multi_message.get_return_status_disable;
1237: hr_utility.set_location(' Leaving:' || l_proc,50);
1238: end create_delegate_booking;
1239:
1240:
1241: PROCEDURE update_delegate_booking

Line 1359: hr_utility.set_location(' Entering:' || l_proc,10);

1355:
1356: -- Other variables
1357: l_proc varchar2(72) := g_package ||'update_delegate_booking';
1358: Begin
1359: hr_utility.set_location(' Entering:' || l_proc,10);
1360: --
1361: -- Issue a savepoint
1362: --
1363: savepoint update_delegate_booking;

Line 1376: hr_utility.trace('SRK in update_deleg_booki booking p_booking_id '|| p_booking_id);

1372: l_tfl_object_version_number := p_tfl_object_version_number;
1373: l_finance_line_id := p_finance_line_id;
1374: --
1375: --
1376: hr_utility.trace('SRK in update_deleg_booki booking p_booking_id '|| p_booking_id);
1377: OPEN booking_csr;
1378: FETCH booking_csr INTO l_date_booking_placed;
1379: CLOSE booking_csr;
1380: l_date_status_changed := trunc(sysdate);

Line 1393: hr_utility.trace('SRK in update_deleg_booki before the api call p_booking_id '|| p_booking_id);

1389: --
1390: --
1391: -- Call API
1392: --
1393: hr_utility.trace('SRK in update_deleg_booki before the api call p_booking_id '|| p_booking_id);
1394: ota_delegate_booking_api.update_delegate_booking
1395: (p_effective_date => p_effective_date
1396: ,p_booking_id => p_booking_id
1397: ,p_booking_status_type_id => p_booking_status_type_id

Line 1500: hr_utility.set_location(' Leaving:' || l_proc,20);

1496: -- messages of any type exist in the Multiple Message List.
1497: -- Also disable Multiple Message Detection.
1498: --
1499: p_return_status := hr_multi_message.get_return_status_disable;
1500: hr_utility.set_location(' Leaving:' || l_proc,20);
1501: --
1502: end update_delegate_booking;
1503:
1504: