DBA Data[Home] [Help]

APPS.PQP_RIW_OFFERING_WRAPPER dependencies on HR_UTILITY

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

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: --

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

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;

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

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

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

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);

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

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

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

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');

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

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);

Line 374: hr_utility.raise_error;

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);

Line 376: 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);
379: hr_utility.raise_error;
380: when others then

Line 377: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_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
381:

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

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);

Line 379: 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);
383: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 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);

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

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;

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

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:

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

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:

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

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;

Line 388: hr_utility.raise_error;

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;