DBA Data[Home] [Help]

APPS.PQP_RIW_OFFERING_WRAPPER dependencies on HR_UTILITY

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

19: l_offering_rec ota_offerings_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: l_offering_rec.business_group_id := hr_api.g_number;
33: l_offering_rec.name := hr_api.g_varchar2 ;
34: l_offering_rec.start_date := hr_api.g_date ;
35: l_offering_rec.activity_version_id := hr_api.g_number ;

Line 40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);

36: l_offering_rec.end_date := hr_api.g_date ;
37: l_offering_rec.owner_id := hr_api.g_number ;
38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);

Line 42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);

38: l_offering_rec.delivery_mode_id := hr_api.g_number ;
39: l_offering_rec.language_id := hr_api.g_number ;
40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);

Line 44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);

40: Hr_Utility.set_location(' after : l_offering_rec.language_id', 5);
41: l_offering_rec.duration := hr_api.g_number ;
42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;

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

42: Hr_Utility.set_location(' after : l_offering_rec.duration', 5);
43: l_offering_rec.duration_units := hr_api.g_varchar2 ;
44: Hr_Utility.set_location(' after : l_offering_rec.duration_units', 5);
45: l_offering_rec.learning_object_id := hr_api.g_number ;
46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);

Line 50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);

46: Hr_Utility.set_location(' Before duration : ', 5);
47: -- l_offering_rec.player_toolbar_flag := hr_api.g_varchar2 ;
48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:

Line 52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);

48: g_player_toolbar_flag :=hr_api.g_varchar2;
49:
50: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_flag', 5);
51: l_offering_rec.player_toolbar_bitset := hr_api.g_number ;
52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);

Line 56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);

52: Hr_Utility.set_location(' after : l_offering_rec.player_toolbar_bitset', 5);
53: -- l_offering_rec.player_new_window_flag := hr_api.g_varchar2 ;
54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

Line 58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

54:
55: g_player_new_window_flag :=hr_api.g_varchar2;
56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;

Line 60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

56: Hr_Utility.set_location(' after :g_player_new_window_flag '||g_player_new_window_flag, 5);
57: l_offering_rec.maximum_attendees := hr_api.g_number ;
58: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;
63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
64:

Line 63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

59: l_offering_rec.maximum_internal_attendees := hr_api.g_number ;
60: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
61:
62: l_offering_rec.minimum_attendees := hr_api.g_number ;
63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
64:
65: l_offering_rec.actual_cost := hr_api.g_number ;
66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

Line 67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

63: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
64:
65: l_offering_rec.actual_cost := hr_api.g_number ;
66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

Line 69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

65: l_offering_rec.actual_cost := hr_api.g_number ;
66:
67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;

Line 71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);

67: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
68: l_offering_rec.budget_cost := hr_api.g_number ;
69: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
70: l_offering_rec.budget_currency_code := hr_api.g_varchar2 ;
71: Hr_Utility.set_location(' after :l_offering_rec.maximum_attendees ', 5);
72: l_offering_rec.price_basis := hr_api.g_varchar2 ;
73: l_offering_rec.currency_code := hr_api.g_varchar2 ;
74: l_offering_rec.standard_price := hr_api.g_number ;
75: l_offering_rec.attribute_category := hr_api.g_varchar2 ;

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

98: l_offering_rec.description := hr_api.g_varchar2 ;
99: l_offering_rec.competency_update_level := hr_api.g_varchar2 ;
100: l_offering_rec.language_code := hr_api.g_varchar2 ;
101:
102: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
103: return l_offering_rec;
104: exception
105: when others then
106: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

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

102: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
103: return l_offering_rec;
104: exception
105: when others then
106: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
107: raise;
108:
109: end Default_Offering_Rec;
110:

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

134: col_name varchar2(150);
135: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
136: begin
137:
138: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
139: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
140: l_offering_rec := Default_Offering_Rec;
141: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
142: hr_utility.set_location('g_interface_code'||g_interface_code, 5);

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

135: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
136: begin
137:
138: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
139: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
140: l_offering_rec := Default_Offering_Rec;
141: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
142: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
143:

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

137:
138: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
139: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
140: l_offering_rec := Default_Offering_Rec;
141: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
142: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
143:
144:
145: for col_rec in bne_cols (g_interface_code)

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

138: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
139: hr_utility.set_location('p_interface_code'||p_interface_code, 10);
140: l_offering_rec := Default_Offering_Rec;
141: hr_utility.set_location('p_interface_code'||p_interface_code, 20);
142: hr_utility.set_location('g_interface_code'||g_interface_code, 5);
143:
144:
145: for col_rec in bne_cols (g_interface_code)
146: loop

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

143:
144:
145: for col_rec in bne_cols (g_interface_code)
146: loop
147: hr_utility.set_location(' in loop col_rec.interface_col_name'||col_rec.interface_col_name, 15);
148: case col_rec.interface_col_name
149:
150: when 'p_business_group_id' then
151: l_offering_rec.business_group_id := g_offering_rec.business_group_id;

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

267: else
268: null;
269: end case;
270: end loop;
271: Hr_Utility.set_location(' Leaving: '||l_proc_name, 80);
272: return l_offering_rec;
273:
274: end Get_Record_Values;
275:

Line 391: --hr_utility.trace_on(null, 'Offer_Trace');

387: -- =============================================================================
388: l_proc varchar2(72) := g_package||'InsUpd_Offering';
389:
390: begin
391: --hr_utility.trace_on(null, 'Offer_Trace');
392: hr_utility.set_location('Entering: '|| l_proc, 11);
393: --
394: -- Issue a savepoint
395: --

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

388: l_proc varchar2(72) := g_package||'InsUpd_Offering';
389:
390: begin
391: --hr_utility.trace_on(null, 'Offer_Trace');
392: hr_utility.set_location('Entering: '|| l_proc, 11);
393: --
394: -- Issue a savepoint
395: --
396: savepoint InsUpd_Offering;

Line 413: hr_utility.set_location('The offering id is : '||l_offering_id, 90);

409: l_player_toolbar_bitset :=0;
410:
411: l_offering_id := p_offering_id;
412:
413: hr_utility.set_location('The offering id is : '||l_offering_id, 90);
414:
415: if l_offering_id is not null then
416: l_create_flag := 2; --Update Offering
417: else

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

590:
591: if l_create_flag = 2 then
592:
593: g_interface_code := nvl(l_interface_code,'PQP_OLM_OFFERING_INTF');
594: hr_utility.set_location('g_interface_code'||g_interface_code, 95);
595:
596: g_offering_rec.business_group_id := p_business_group_id ;
597: g_offering_rec.name := p_name ;
598: g_offering_rec.start_date := p_start_date ;

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

704: ,p_language_code => l_offering_rec.language_code
705: );
706: end if;
707:
708: hr_utility.set_location(' Leaving:' || l_proc,30);
709: Exception
710: when e_upl_not_allowed then
711: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);

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

707:
708: hr_utility.set_location(' Leaving:' || l_proc,30);
709: Exception
710: when e_upl_not_allowed then
711: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then

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

708: hr_utility.set_location(' Leaving:' || l_proc,30);
709: Exception
710: when e_upl_not_allowed then
711: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

709: Exception
710: when e_upl_not_allowed then
711: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 714: hr_utility.raise_error;

710: when e_upl_not_allowed then
711: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
718: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

712: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
718: hr_utility.set_location('Leaving: ' || l_proc, 100);
719: hr_utility.raise_error;
720: when others then

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

713: hr_utility.set_location('Leaving: ' || l_proc, 90);
714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
718: hr_utility.set_location('Leaving: ' || l_proc, 100);
719: hr_utility.raise_error;
720: when others then
721:

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

714: hr_utility.raise_error;
715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
718: hr_utility.set_location('Leaving: ' || l_proc, 100);
719: hr_utility.raise_error;
720: when others then
721:
722: --l_error_msg := Substr(SQLERRM,1,2000);

Line 719: hr_utility.raise_error;

715: when e_crt_not_allowed then
716: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
717: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
718: hr_utility.set_location('Leaving: ' || l_proc, 100);
719: hr_utility.raise_error;
720: when others then
721:
722: --l_error_msg := Substr(SQLERRM,1,2000);
723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

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

719: hr_utility.raise_error;
720: when others then
721:
722: --l_error_msg := Substr(SQLERRM,1,2000);
723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);

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

720: when others then
721:
722: --l_error_msg := Substr(SQLERRM,1,2000);
723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);
728: hr_utility.raise_error;

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

721:
722: --l_error_msg := Substr(SQLERRM,1,2000);
723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);
728: hr_utility.raise_error;
729:

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

722: --l_error_msg := Substr(SQLERRM,1,2000);
723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);
728: hr_utility.raise_error;
729:
730:

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

723: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);
728: hr_utility.raise_error;
729:
730:
731: end InsUpd_Offering;

Line 728: hr_utility.raise_error;

724: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
725: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
726: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
727: hr_utility.set_location(' Leaving:' || l_proc,50);
728: hr_utility.raise_error;
729:
730:
731: end InsUpd_Offering;
732: end pqp_riw_offering_wrapper;