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

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

17: l_proc_name constant varchar2(150) := g_package||'Default_Course_Rec';
18: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
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(' Before : ', 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(' Before : ', 5);
30: l_course_rec.activity_id := hr_api.g_number;
31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;

Line 36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);

32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);

Line 38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);

34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);

Line 40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);

36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);

Line 42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);

38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;

Line 44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);

40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;

Line 51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);

47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;

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

90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;
93:
94: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
95: return l_course_rec;
96: exception
97: when others then
98: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

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

94: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
95: return l_course_rec;
96: exception
97: when others then
98: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
99: raise;
100:
101: end Default_Course_Rec;
102:

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

126: col_name varchar2(150);
127: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
128: begin
129:
130: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
131: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
132: l_course_rec := Default_Course_Rec;
133: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
134: hr_utility.set_location('g_interface_code'||g_interface_code, 5);

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

127: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
128: begin
129:
130: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
131: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
132: l_course_rec := Default_Course_Rec;
133: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
134: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
135:

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

129:
130: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
131: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
132: l_course_rec := Default_Course_Rec;
133: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
134: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
135:
136:
137: for col_rec in bne_cols (g_interface_code)

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

130: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
131: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
132: l_course_rec := Default_Course_Rec;
133: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
134: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
135:
136:
137: for col_rec in bne_cols (g_interface_code)
138: loop

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

135:
136:
137: for col_rec in bne_cols (g_interface_code)
138: loop
139: hr_utility.set_location(' in loop col_rec.interface_col_name'||col_rec.interface_col_name, 15);
140: case col_rec.interface_col_name
141:
142: when 'p_activity_id' then
143: l_course_rec.activity_id := g_course_rec.activity_id;

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

263: else
264: null;
265: end case;
266: end loop;
267: Hr_Utility.set_location(' Leaving: '||l_proc_name, 80);
268: return l_course_rec;
269:
270: end Get_Record_Values;
271: -- ----------------------------------------------------------------------------

Line 402: --hr_utility.trace_on(null, 'Course_Trace');

398: l_crt_upd_len number;
399:
400:
401: Begin
402: --hr_utility.trace_on(null, 'Course_Trace');
403: hr_utility.set_location(' Entering:' || l_proc,10);
404: --
405: -- Issue a savepoint
406: --

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

399:
400:
401: Begin
402: --hr_utility.trace_on(null, 'Course_Trace');
403: hr_utility.set_location(' Entering:' || l_proc,10);
404: --
405: -- Issue a savepoint
406: --
407: savepoint pqp_riw_course_wrapper;

Line 424: hr_utility.set_location('The version id is : '||l_activity_version_id, 89);

420: --
421: -- Call API
422: --
423: l_activity_version_id := p_activity_version_id;
424: hr_utility.set_location('The version id is : '||l_activity_version_id, 89);
425: if l_activity_version_id is not null then
426: l_create_flag := 2; --update course
427: else
428: l_create_flag := 1; --create course

Line 509: hr_utility.set_location('The code has created success', 90);

505: ,p_data_source => p_data_source
506: ,p_competency_update_level => p_competency_update_level
507: );
508:
509: hr_utility.set_location('The code has created success', 90);
510: Open C_Sel_one;
511: Fetch C_Sel_one into l_category_usage_id;
512: Close C_Sel_one;
513: hr_utility.set_location('After that success as well', 90);

Line 513: hr_utility.set_location('After that success as well', 90);

509: hr_utility.set_location('The code has created success', 90);
510: Open C_Sel_one;
511: Fetch C_Sel_one into l_category_usage_id;
512: Close C_Sel_one;
513: hr_utility.set_location('After that success as well', 90);
514:
515:
516:
517: ota_activity_category_api.create_act_cat_inclusion

Line 553: hr_utility.set_location('Inside the update', 90);

549: );
550: end if;
551:
552: if l_create_flag = 2 then
553: hr_utility.set_location('Inside the update', 90);
554: g_interface_code := nvl(l_interface_code,'PQP_OLM_COURSE_INTF');
555:
556: g_course_rec.activity_id := p_activity_id;
557: g_course_rec.superseded_by_act_version_id := p_superseded_by_act_version_id;

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

681: end if;
682:
683:
684:
685: hr_utility.set_location(' Leaving:' || l_proc,20);
686:
687: exception
688:
689: when e_upl_not_allowed then

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

686:
687: exception
688:
689: when e_upl_not_allowed then
690: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
691: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then

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

687: exception
688:
689: when e_upl_not_allowed then
690: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
691: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

688:
689: when e_upl_not_allowed then
690: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
691: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 693: hr_utility.raise_error;

689: when e_upl_not_allowed then
690: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
691: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
697: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

691: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
697: hr_utility.set_location('Leaving: ' || l_proc, 100);
698: hr_utility.raise_error;
699: when others then

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

692: hr_utility.set_location('Leaving: ' || l_proc, 90);
693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
697: hr_utility.set_location('Leaving: ' || l_proc, 100);
698: hr_utility.raise_error;
699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);

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

693: hr_utility.raise_error;
694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
697: hr_utility.set_location('Leaving: ' || l_proc, 100);
698: hr_utility.raise_error;
699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 698: hr_utility.raise_error;

694: when e_crt_not_allowed then
695: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
696: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
697: hr_utility.set_location('Leaving: ' || l_proc, 100);
698: hr_utility.raise_error;
699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

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

697: hr_utility.set_location('Leaving: ' || l_proc, 100);
698: hr_utility.raise_error;
699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);

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

698: hr_utility.raise_error;
699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);
706: hr_utility.raise_error;

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

699: when others then
700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);
706: hr_utility.raise_error;
707:

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

700: --l_error_msg := Substr(SQLERRM,1,2000);
701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);
706: hr_utility.raise_error;
707:
708: end InsUpd_Course;

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

701: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);
706: hr_utility.raise_error;
707:
708: end InsUpd_Course;
709: end pqp_riw_course_wrapper;

Line 706: hr_utility.raise_error;

702: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
703: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
704: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
705: hr_utility.set_location(' Leaving:' || l_proc,50);
706: hr_utility.raise_error;
707:
708: end InsUpd_Course;
709: end pqp_riw_course_wrapper;