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

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

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

Line 31: Hr_Utility.set_location(' Before : ', 5);

27: g_number constant number := -987123654;
28: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
29: ==========================================================================
30: */
31: Hr_Utility.set_location(' Before : ', 5);
32:
33: l_class_rec.vendor_id := hr_api.g_number ;
34: l_class_rec.activity_version_id := hr_api.g_number ;
35: l_class_rec.business_group_id := hr_api.g_number ;

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

37: l_class_rec.event_type := hr_api.g_varchar2 ;
38: l_class_rec.title := hr_api.g_varchar2 ;
39: l_class_rec.budget_cost := hr_api.g_number ;
40: l_class_rec.actual_cost := hr_api.g_number ;
41: Hr_Utility.set_location(' One : ', 5);
42: l_class_rec.budget_currency_code := hr_api.g_varchar2 ;
43: Hr_Utility.set_location(' Two : ', 5);
44: l_class_rec.centre := hr_api.g_varchar2 ;
45: Hr_Utility.set_location(' Three : ', 5);

Line 43: Hr_Utility.set_location(' Two : ', 5);

39: l_class_rec.budget_cost := hr_api.g_number ;
40: l_class_rec.actual_cost := hr_api.g_number ;
41: Hr_Utility.set_location(' One : ', 5);
42: l_class_rec.budget_currency_code := hr_api.g_varchar2 ;
43: Hr_Utility.set_location(' Two : ', 5);
44: l_class_rec.centre := hr_api.g_varchar2 ;
45: Hr_Utility.set_location(' Three : ', 5);
46: l_class_rec.comments := hr_api.g_varchar2 ;
47: Hr_Utility.set_location(' Four : ', 5);

Line 45: Hr_Utility.set_location(' Three : ', 5);

41: Hr_Utility.set_location(' One : ', 5);
42: l_class_rec.budget_currency_code := hr_api.g_varchar2 ;
43: Hr_Utility.set_location(' Two : ', 5);
44: l_class_rec.centre := hr_api.g_varchar2 ;
45: Hr_Utility.set_location(' Three : ', 5);
46: l_class_rec.comments := hr_api.g_varchar2 ;
47: Hr_Utility.set_location(' Four : ', 5);
48: l_class_rec.course_end_date := hr_api.g_date ;
49: Hr_Utility.set_location(' Five : ', 5);

Line 47: Hr_Utility.set_location(' Four : ', 5);

43: Hr_Utility.set_location(' Two : ', 5);
44: l_class_rec.centre := hr_api.g_varchar2 ;
45: Hr_Utility.set_location(' Three : ', 5);
46: l_class_rec.comments := hr_api.g_varchar2 ;
47: Hr_Utility.set_location(' Four : ', 5);
48: l_class_rec.course_end_date := hr_api.g_date ;
49: Hr_Utility.set_location(' Five : ', 5);
50: -- l_class_rec.course_end_time := hr_api.g_varchar2 ;
51: g_course_end_time := hr_api.g_varchar2 ;

Line 49: Hr_Utility.set_location(' Five : ', 5);

45: Hr_Utility.set_location(' Three : ', 5);
46: l_class_rec.comments := hr_api.g_varchar2 ;
47: Hr_Utility.set_location(' Four : ', 5);
48: l_class_rec.course_end_date := hr_api.g_date ;
49: Hr_Utility.set_location(' Five : ', 5);
50: -- l_class_rec.course_end_time := hr_api.g_varchar2 ;
51: g_course_end_time := hr_api.g_varchar2 ;
52: Hr_Utility.set_location(' Siz : ', 5);
53: l_class_rec.course_start_date := hr_api.g_date ;

Line 52: Hr_Utility.set_location(' Siz : ', 5);

48: l_class_rec.course_end_date := hr_api.g_date ;
49: Hr_Utility.set_location(' Five : ', 5);
50: -- l_class_rec.course_end_time := hr_api.g_varchar2 ;
51: g_course_end_time := hr_api.g_varchar2 ;
52: Hr_Utility.set_location(' Siz : ', 5);
53: l_class_rec.course_start_date := hr_api.g_date ;
54: Hr_Utility.set_location(' Sev : ', 5);
55: -- l_class_rec.course_start_time := hr_api.g_varchar2 ;
56: g_course_start_time := hr_api.g_varchar2 ;

Line 54: Hr_Utility.set_location(' Sev : ', 5);

50: -- l_class_rec.course_end_time := hr_api.g_varchar2 ;
51: g_course_end_time := hr_api.g_varchar2 ;
52: Hr_Utility.set_location(' Siz : ', 5);
53: l_class_rec.course_start_date := hr_api.g_date ;
54: Hr_Utility.set_location(' Sev : ', 5);
55: -- l_class_rec.course_start_time := hr_api.g_varchar2 ;
56: g_course_start_time := hr_api.g_varchar2 ;
57: Hr_Utility.set_location(' Ei : ', 5);
58:

Line 57: Hr_Utility.set_location(' Ei : ', 5);

53: l_class_rec.course_start_date := hr_api.g_date ;
54: Hr_Utility.set_location(' Sev : ', 5);
55: -- l_class_rec.course_start_time := hr_api.g_varchar2 ;
56: g_course_start_time := hr_api.g_varchar2 ;
57: Hr_Utility.set_location(' Ei : ', 5);
58:
59: l_class_rec.duration := hr_api.g_number ;
60: l_class_rec.duration_units := hr_api.g_varchar2 ;
61: l_class_rec.enrolment_end_date := hr_api.g_date ;

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

107: l_class_rec.timezone := hr_api.g_varchar2 ;
108: l_class_rec.parent_offering_id := hr_api.g_number ;
109: l_class_rec.data_source := hr_api.g_varchar2 ;
110:
111: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
112: return l_class_rec;
113: exception
114: when others then
115: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

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

111: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
112: return l_class_rec;
113: exception
114: when others then
115: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
116: raise;
117:
118: end Default_Class_Rec;
119:

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

143: col_name varchar2(150);
144: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
145: begin
146:
147: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
148: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
149: l_class_rec := Default_Class_Rec;
150: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
151: hr_utility.set_location('g_interface_code'||g_interface_code, 5);

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

144: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
145: begin
146:
147: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
148: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
149: l_class_rec := Default_Class_Rec;
150: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
151: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
152:

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

146:
147: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
148: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
149: l_class_rec := Default_Class_Rec;
150: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
151: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
152:
153:
154: for col_rec in bne_cols (g_interface_code)

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

147: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
148: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
149: l_class_rec := Default_Class_Rec;
150: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
151: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
152:
153:
154: for col_rec in bne_cols (g_interface_code)
155: loop

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

152:
153:
154: for col_rec in bne_cols (g_interface_code)
155: loop
156: hr_utility.set_location(' in loop col_rec.interface_col_name'||col_rec.interface_col_name, 15);
157: case col_rec.interface_col_name
158:
159: when 'p_vendor_id' then
160: l_class_rec.vendor_id := g_class_rec.vendor_id;

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

302: else
303: null;
304: end case;
305: end loop;
306: Hr_Utility.set_location(' Leaving: '||l_proc_name, 80);
307: return l_class_rec;
308:
309: end Get_Record_Values;
310:

Line 431: --hr_utility.trace_on(null, 'Class_Trace');

427: l_crt_upd_len number;
428:
429:
430: Begin
431: --hr_utility.trace_on(null, 'Class_Trace');
432: hr_utility.set_location('Entering: '|| l_proc, 11);
433: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
434: l_event_id := p_event_id;
435: --

Line 432: hr_utility.set_location('Entering: '|| l_proc, 11);

428:
429:
430: Begin
431: --hr_utility.trace_on(null, 'Class_Trace');
432: hr_utility.set_location('Entering: '|| l_proc, 11);
433: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
434: l_event_id := p_event_id;
435: --
436: -- Call API

Line 468: hr_utility.set_location('The class Id is : '||l_event_id, 89);

464: if (l_crt_upd = 'U' and l_create_flag = 1) then
465: raise e_crt_not_allowed; -- Update only flag is enabled but Trying to Create
466: end if;
467:
468: hr_utility.set_location('The class Id is : '||l_event_id, 89);
469:
470: if l_create_flag = 1 then
471: ota_event_api.create_class
472: (p_effective_date => p_effective_date

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

545: if l_create_flag = 2 then
546: g_interface_code := nvl(l_interface_code,'PQP_OLM_CLASS_INTF');
547:
548: g_class_rec.vendor_id := p_vendor_id ;
549: Hr_Utility.set_location(' One : ', 5);
550: g_class_rec.activity_version_id := p_activity_version_id ;
551:
552: g_class_rec.business_group_id := p_business_group_id ;
553: g_class_rec.organization_id := p_organization_id ;

Line 562: Hr_Utility.set_location(' two : ', 5);

558: g_class_rec.budget_currency_code := p_budget_currency_code ;
559: g_class_rec.centre := p_centre ;
560: g_class_rec.comments := p_comments ;
561: g_class_rec.course_end_date := p_course_end_date ;
562: Hr_Utility.set_location(' two : ', 5);
563: g_class_rec.course_end_time := p_course_end_time ;
564: Hr_Utility.set_location(' three : ', 5);
565: g_class_rec.course_start_date := p_course_start_date ;
566: Hr_Utility.set_location(' Four : ', 5);

Line 564: Hr_Utility.set_location(' three : ', 5);

560: g_class_rec.comments := p_comments ;
561: g_class_rec.course_end_date := p_course_end_date ;
562: Hr_Utility.set_location(' two : ', 5);
563: g_class_rec.course_end_time := p_course_end_time ;
564: Hr_Utility.set_location(' three : ', 5);
565: g_class_rec.course_start_date := p_course_start_date ;
566: Hr_Utility.set_location(' Four : ', 5);
567: g_class_rec.course_start_time := p_course_start_time ;
568: Hr_Utility.set_location(' Five : ', 5);

Line 566: Hr_Utility.set_location(' Four : ', 5);

562: Hr_Utility.set_location(' two : ', 5);
563: g_class_rec.course_end_time := p_course_end_time ;
564: Hr_Utility.set_location(' three : ', 5);
565: g_class_rec.course_start_date := p_course_start_date ;
566: Hr_Utility.set_location(' Four : ', 5);
567: g_class_rec.course_start_time := p_course_start_time ;
568: Hr_Utility.set_location(' Five : ', 5);
569: g_class_rec.duration := p_duration ;
570: g_class_rec.duration_units := p_duration_units ;

Line 568: Hr_Utility.set_location(' Five : ', 5);

564: Hr_Utility.set_location(' three : ', 5);
565: g_class_rec.course_start_date := p_course_start_date ;
566: Hr_Utility.set_location(' Four : ', 5);
567: g_class_rec.course_start_time := p_course_start_time ;
568: Hr_Utility.set_location(' Five : ', 5);
569: g_class_rec.duration := p_duration ;
570: g_class_rec.duration_units := p_duration_units ;
571: g_class_rec.enrolment_end_date := p_enrolment_end_date ;
572: g_class_rec.enrolment_start_date := p_enrolment_start_date ;

Line 577: Hr_Utility.set_location(' Six : ', 5);

573: g_class_rec.language_id := p_language_id ;
574: g_class_rec.user_status := p_user_status ;
575: g_class_rec.development_event_type := p_development_event_type ;
576: g_class_rec.event_status := p_event_status ;
577: Hr_Utility.set_location(' Six : ', 5);
578: g_class_rec.price_basis := p_price_basis ;
579: g_class_rec.currency_code := p_currency_code ;
580: g_class_rec.maximum_attendees := p_maximum_attendees ;
581: g_class_rec.maximum_internal_attendees:= p_maximum_internal_attendees ;

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

697:
698: Exception
699:
700: when e_upl_not_allowed then
701: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
702: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then

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

698: Exception
699:
700: when e_upl_not_allowed then
701: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
702: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

699:
700: when e_upl_not_allowed then
701: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
702: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 704: hr_utility.raise_error;

700: when e_upl_not_allowed then
701: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
702: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
708: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

702: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
708: hr_utility.set_location('Leaving: ' || l_proc, 100);
709: hr_utility.raise_error;
710: when others then

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

703: hr_utility.set_location('Leaving: ' || l_proc, 90);
704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
708: hr_utility.set_location('Leaving: ' || l_proc, 100);
709: hr_utility.raise_error;
710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);

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

704: hr_utility.raise_error;
705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
708: hr_utility.set_location('Leaving: ' || l_proc, 100);
709: hr_utility.raise_error;
710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 709: hr_utility.raise_error;

705: when e_crt_not_allowed then
706: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
707: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
708: hr_utility.set_location('Leaving: ' || l_proc, 100);
709: hr_utility.raise_error;
710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

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

708: hr_utility.set_location('Leaving: ' || l_proc, 100);
709: hr_utility.raise_error;
710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);

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

709: hr_utility.raise_error;
710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);
717: hr_utility.raise_error;

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

710: when others then
711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);
717: hr_utility.raise_error;
718:

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

711: --l_error_msg := Substr(SQLERRM,1,2000);
712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);
717: hr_utility.raise_error;
718:
719:

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

712: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);
717: hr_utility.raise_error;
718:
719:
720:

Line 717: hr_utility.raise_error;

713: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
714: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
715: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
716: hr_utility.set_location(' Leaving:' || l_proc,50);
717: hr_utility.raise_error;
718:
719:
720:
721: end InsUpd_Class;