111: -- =============================================================================
112: l_proc varchar2(72) := g_package||'InsUpd_Offering';
113:
114: begin
115: --hr_utility.trace_on(null, 'Offer_Trace');
116: hr_utility.set_location('Entering: '|| l_proc, 11);
117: --
118: -- Issue a savepoint
119: --
112: l_proc varchar2(72) := g_package||'InsUpd_Offering';
113:
114: begin
115: --hr_utility.trace_on(null, 'Offer_Trace');
116: hr_utility.set_location('Entering: '|| l_proc, 11);
117: --
118: -- Issue a savepoint
119: --
120: savepoint InsUpd_Offering;
133: l_player_toolbar_bitset :=0;
134:
135: l_offering_id := p_offering_id;
136:
137: hr_utility.set_location('The offering id is : '||l_offering_id, 90);
138:
139: if l_offering_id is not null then
140: l_create_flag := 2; --Update Offering
141: else
364: ,p_language_code => p_language_code
365: );
366: end if;
367:
368: hr_utility.set_location(' Leaving:' || l_proc,30);
369: Exception
370: when e_upl_not_allowed then
371: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
367:
368: hr_utility.set_location(' Leaving:' || l_proc,30);
369: Exception
370: when e_upl_not_allowed then
371: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
368: hr_utility.set_location(' Leaving:' || l_proc,30);
369: Exception
370: when e_upl_not_allowed then
371: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
369: Exception
370: when e_upl_not_allowed then
371: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
370: when e_upl_not_allowed then
371: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
378: hr_utility.set_location('Leaving: ' || l_proc, 100);
372: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
378: hr_utility.set_location('Leaving: ' || l_proc, 100);
379: hr_utility.raise_error;
380: when others then
373: hr_utility.set_location('Leaving: ' || l_proc, 90);
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
378: hr_utility.set_location('Leaving: ' || l_proc, 100);
379: hr_utility.raise_error;
380: when others then
381:
374: hr_utility.raise_error;
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
378: hr_utility.set_location('Leaving: ' || l_proc, 100);
379: hr_utility.raise_error;
380: when others then
381:
382: --l_error_msg := Substr(SQLERRM,1,2000);
375: when e_crt_not_allowed then
376: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
378: hr_utility.set_location('Leaving: ' || l_proc, 100);
379: hr_utility.raise_error;
380: when others then
381:
382: --l_error_msg := Substr(SQLERRM,1,2000);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
379: hr_utility.raise_error;
380: when others then
381:
382: --l_error_msg := Substr(SQLERRM,1,2000);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
380: when others then
381:
382: --l_error_msg := Substr(SQLERRM,1,2000);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: hr_utility.raise_error;
381:
382: --l_error_msg := Substr(SQLERRM,1,2000);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: hr_utility.raise_error;
389:
382: --l_error_msg := Substr(SQLERRM,1,2000);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: hr_utility.raise_error;
389:
390:
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: hr_utility.raise_error;
389:
390:
391: end InsUpd_Offering;
384: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
385: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
386: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
387: hr_utility.set_location(' Leaving:' || l_proc,50);
388: hr_utility.raise_error;
389:
390:
391: end InsUpd_Offering;
392: end pqp_riw_offering_wrapper;