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.PA_REP_UTIL_GLOB dependencies on PA_REP_UTIL_GLOB

Line 1: PACKAGE BODY PA_REP_UTIL_GLOB AS

1: PACKAGE BODY PA_REP_UTIL_GLOB AS
2: /* $Header: PARRGLBB.pls 120.1 2005/07/04 03:14:12 appldev ship $ */
3:
4: /*
5: * Procedure to cache the Organization ID for U1 screen

Line 141: * Call PA_REP_UTIL_GLOB procedure ...

137: */
138: retcode := 0;
139: /*
140: * Populate Globals for Subsequent Concurrent Processes
141: * Call PA_REP_UTIL_GLOB procedure ...
142: * Depending on Products Installed, Run Actuals
143: * Concurrent Processes
144: */
145: IF l_debug ='Y'THEN -- bug 2674619

Line 188: l_fnd_msg := PA_REP_UTIL_GLOB.G_util_fetch_size||' : '||FND_MESSAGE.Get;

184: , p_write_mode => 1
185: , p_write_file => 'OUT'
186: );
187: FND_MESSAGE.Set_Name('PA','PA_UTIL_FETCH_SIZE');
188: l_fnd_msg := PA_REP_UTIL_GLOB.G_util_fetch_size||' : '||FND_MESSAGE.Get;
189: PA_DEBUG.Log_Message(p_message => l_fnd_msg
190: , p_write_mode => 1
191: , p_write_file => 'OUT'
192: );

Line 205: PA_DEBUG.g_err_stage := '50 : Inside PA_REP_UTIL_GLOB.get_util_ac_parm';

201: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
202: PA_DEBUG.g_err_stage := '--------';
203: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
204:
205: PA_DEBUG.g_err_stage := '50 : Inside PA_REP_UTIL_GLOB.get_util_ac_parm';
206: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
207: END IF;
208:
209: IF TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS')) >

Line 227: PA_DEBUG.g_err_stage := '150 : Before Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

223: PA_Debug.Reset_Curr_Function;
224: RETURN;
225: END IF;
226: IF l_debug ='Y'THEN -- bug 2674619
227: PA_DEBUG.g_err_stage := '150 : Before Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
228: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
229: END IF;
230:
231: Get_Util_Prc_Switch (

Line 238: PA_DEBUG.g_err_stage := '200 : After Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

234: ,x_return_status => l_retcode
235: );
236:
237: IF l_debug ='Y'THEN -- bug 2674619
238: PA_DEBUG.g_err_stage := '200 : After Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
239: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
240: END IF;
241:
242: IF ( l_prc_switch = 'A' OR l_prc_switch = 'B') THEN

Line 244: PA_DEBUG.g_err_stage := '250 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';

240: END IF;
241:
242: IF ( l_prc_switch = 'A' OR l_prc_switch = 'B') THEN
243: IF l_debug ='Y'THEN -- bug 2674619
244: PA_DEBUG.g_err_stage := '250 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';
245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
246: END IF;
247:
248: PA_REP_UTIL_GLOB.initialize_util_cache(

Line 248: PA_REP_UTIL_GLOB.initialize_util_cache(

244: PA_DEBUG.g_err_stage := '250 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';
245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
246: END IF;
247:
248: PA_REP_UTIL_GLOB.initialize_util_cache(
249: p_ac_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
250: ,p_ac_end_date => TRUNC(TO_DATE(p_ac_end_date,'YYYY/MM/DD HH24:MI:SS'))
251: ,p_fc_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
252: ,p_fc_end_date => TRUNC(TO_DATE(p_fc_end_date,'YYYY/MM/DD HH24:MI:SS'))

Line 257: PA_DEBUG.g_err_stage := '300 : After calling PA_REP_UTIL_GLOB.initialize_util_cache';

253: ,p_org_rollup_method => p_org_rollup_method
254: ,p_debug_mode => p_debug_mode
255: );
256: IF l_debug ='Y'THEN -- bug 2674619
257: PA_DEBUG.g_err_stage := '300 : After calling PA_REP_UTIL_GLOB.initialize_util_cache';
258: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
259: END IF;
260: /*
261: * Bug 1810528

Line 269: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id

265: SELECT max(LAST_UPDATE_DATE)
266: INTO l_orghier_date_before
267: FROM pa_org_hierarchy_denorm
268: WHERE pa_org_use_type = 'REPORTING'
269: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
270: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
271: ;
272:
273: IF l_debug ='Y'THEN -- bug 2674619

Line 270: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id

266: INTO l_orghier_date_before
267: FROM pa_org_hierarchy_denorm
268: WHERE pa_org_use_type = 'REPORTING'
269: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
270: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
271: ;
272:
273: IF l_debug ='Y'THEN -- bug 2674619
274: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

Line 277: PA_DEBUG.g_err_stage := '350 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

273: IF l_debug ='Y'THEN -- bug 2674619
274: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';
275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
276:
277: PA_DEBUG.g_err_stage := '350 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280:
281: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN

Line 281: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN

277: PA_DEBUG.g_err_stage := '350 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280:
281: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
282: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
283: l_errbuf := NULL;
284: l_retcode := '0';
285: pa_rep_util_glob.Get_Effective_Start_Period_Num(

Line 282: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN

278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280:
281: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
282: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
283: l_errbuf := NULL;
284: l_retcode := '0';
285: pa_rep_util_glob.Get_Effective_Start_Period_Num(
286: errbuf => l_errbuf,

Line 285: pa_rep_util_glob.Get_Effective_Start_Period_Num(

281: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
282: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
283: l_errbuf := NULL;
284: l_retcode := '0';
285: pa_rep_util_glob.Get_Effective_Start_Period_Num(
286: errbuf => l_errbuf,
287: retcode => l_retcode,
288: effective_start_period_num => l_effect_start_period_num,
289: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

Line 289: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

285: pa_rep_util_glob.Get_Effective_Start_Period_Num(
286: errbuf => l_errbuf,
287: retcode => l_retcode,
288: effective_start_period_num => l_effect_start_period_num,
289: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
290: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
291: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
292: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
293: );

Line 290: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019

286: errbuf => l_errbuf,
287: retcode => l_retcode,
288: effective_start_period_num => l_effect_start_period_num,
289: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
290: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
291: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
292: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
293: );
294: IF l_retcode = '2' THEN

Line 291: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,

287: retcode => l_retcode,
288: effective_start_period_num => l_effect_start_period_num,
289: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
290: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
291: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
292: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
293: );
294: IF l_retcode = '2' THEN
295: retcode := '2';

Line 312: PA_REP_UTIL_GLOB.G_eff_ac_start_pa_period_num := l_effect_start_period_num;

308: IF l_debug ='Y'THEN -- bug 2674619
309: PA_DEBUG.g_err_stage := '400 : Eff pd Num-PA '||to_char(l_effect_start_period_num);
310: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
311: END IF;
312: PA_REP_UTIL_GLOB.G_eff_ac_start_pa_period_num := l_effect_start_period_num;
313: END IF;
314: END IF;
315: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
316: l_errbuf := NULL;

Line 315: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN

311: END IF;
312: PA_REP_UTIL_GLOB.G_eff_ac_start_pa_period_num := l_effect_start_period_num;
313: END IF;
314: END IF;
315: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
316: l_errbuf := NULL;
317: l_retcode := '0';
318: pa_rep_util_glob.Get_Effective_Start_Period_Num(
319: errbuf => l_errbuf,

Line 318: pa_rep_util_glob.Get_Effective_Start_Period_Num(

314: END IF;
315: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
316: l_errbuf := NULL;
317: l_retcode := '0';
318: pa_rep_util_glob.Get_Effective_Start_Period_Num(
319: errbuf => l_errbuf,
320: retcode => l_retcode,
321: effective_start_period_num => l_effect_start_period_num,
322: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

Line 322: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

318: pa_rep_util_glob.Get_Effective_Start_Period_Num(
319: errbuf => l_errbuf,
320: retcode => l_retcode,
321: effective_start_period_num => l_effect_start_period_num,
322: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
323: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
324: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
325: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
326: );

Line 323: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019

319: errbuf => l_errbuf,
320: retcode => l_retcode,
321: effective_start_period_num => l_effect_start_period_num,
322: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
323: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
324: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
325: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
326: );
327: IF l_retcode = '2' THEN

Line 324: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,

320: retcode => l_retcode,
321: effective_start_period_num => l_effect_start_period_num,
322: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
323: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
324: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
325: p_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
326: );
327: IF l_retcode = '2' THEN
328: retcode := '2';

Line 345: PA_REP_UTIL_GLOB.G_eff_ac_start_gl_period_num := l_effect_start_period_num;

341: IF l_debug ='Y'THEN -- bug 2674619
342: PA_DEBUG.g_err_stage := '500 : Eff pd Num-GL '||to_char(l_effect_start_period_num);
343: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
344: END IF;
345: PA_REP_UTIL_GLOB.G_eff_ac_start_gl_period_num := l_effect_start_period_num;
346: END IF;
347: END IF;
348: END IF;
349: IF l_debug ='Y'THEN -- bug 2674619

Line 350: PA_DEBUG.g_err_stage := '550 : After calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

346: END IF;
347: END IF;
348: END IF;
349: IF l_debug ='Y'THEN -- bug 2674619
350: PA_DEBUG.g_err_stage := '550 : After calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
351: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
352:
353: PA_DEBUG.g_err_stage := '600 : Before calling PA_SUMMARIZE_ACTUAL_UTIL_PVT.summarize_actual_util';
354: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 383: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id

379: SELECT max(LAST_UPDATE_DATE)
380: INTO l_orghier_date_after
381: FROM pa_org_hierarchy_denorm
382: WHERE pa_org_use_type = 'REPORTING'
383: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
384: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
385: ;
386:
387: IF ( l_orghier_date_after > l_orghier_date_before) then

Line 384: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id

380: INTO l_orghier_date_after
381: FROM pa_org_hierarchy_denorm
382: WHERE pa_org_use_type = 'REPORTING'
383: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
384: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
385: ;
386:
387: IF ( l_orghier_date_after > l_orghier_date_before) then
388: FND_MESSAGE.Set_Name('PA','PA_UTIL_ORGZ_HIER_CHANGE');

Line 408: PA_DEBUG.g_err_stage := '750 : Exiting PA_REP_UTIL_GLOB.get_util_ac_parm';

404: IF l_debug ='Y'THEN -- bug 2674619
405: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';
406: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
407:
408: PA_DEBUG.g_err_stage := '750 : Exiting PA_REP_UTIL_GLOB.get_util_ac_parm';
409: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
410: END IF;
411:
412: PA_Debug.Reset_Curr_Function;

Line 426: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_REP_UTIL_GLOB.get_util_ac_parm'

422: );
423: /*
424: * Set the excetption Message and the stack
425: */
426: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_REP_UTIL_GLOB.get_util_ac_parm'
427: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
428: RAISE;
429:
430: END Get_Util_Ac_Parm;

Line 483: * Call PA_REP_UTIL_GLOB procedure ...

479: * Assume Success
480: */
481: retcode := 0;
482: /* Populate Globals for Subsequent Concurrent Processes
483: * Call PA_REP_UTIL_GLOB procedure ...
484: * Depending on Products Installed, Run Forecasts
485: * Concurrent Processes
486: */
487: IF l_debug ='Y'THEN -- bug 2674619

Line 530: l_fnd_msg := PA_REP_UTIL_GLOB.G_util_fetch_size||' : '||FND_MESSAGE.Get;

526: , p_write_mode => 1
527: , p_write_file => 'OUT'
528: );
529: FND_MESSAGE.Set_Name('PA','PA_UTIL_FETCH_SIZE');
530: l_fnd_msg := PA_REP_UTIL_GLOB.G_util_fetch_size||' : '||FND_MESSAGE.Get;
531: PA_DEBUG.Log_Message(p_message => l_fnd_msg
532: , p_write_mode => 1
533: , p_write_file => 'OUT'
534: );

Line 548: PA_DEBUG.g_err_stage := '50 : Inside PA_REP_UTIL_GLOB.get_util_fc_parm';

544: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
545: PA_DEBUG.g_err_stage := '--------';
546: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
547:
548: PA_DEBUG.g_err_stage := '50 : Inside PA_REP_UTIL_GLOB.get_util_fc_parm';
549: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
550: END IF;
551:
552: IF TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS')) >

Line 570: PA_DEBUG.g_err_stage := '100 : Before Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

566: RETURN;
567: END IF;
568: IF l_debug ='Y'THEN -- bug 2674619
569:
570: PA_DEBUG.g_err_stage := '100 : Before Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
571: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
572: END IF;
573: Get_Util_Prc_Switch (
574: x_prc_switch => l_prc_switch

Line 579: PA_DEBUG.g_err_stage := '150 : After Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

575: ,x_msg_data => l_errbuf
576: ,x_return_status => l_retcode
577: );
578: IF l_debug ='Y'THEN -- bug 2674619
579: PA_DEBUG.g_err_stage := '150 : After Calling PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
580: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
581: END IF;
582:
583: IF ( l_prc_switch = 'F' OR l_prc_switch = 'B') THEN

Line 585: PA_DEBUG.g_err_stage := '200 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';

581: END IF;
582:
583: IF ( l_prc_switch = 'F' OR l_prc_switch = 'B') THEN
584: IF l_debug ='Y'THEN -- bug 2674619
585: PA_DEBUG.g_err_stage := '200 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';
586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
587: END IF;
588:
589: PA_REP_UTIL_GLOB.initialize_util_cache(

Line 589: PA_REP_UTIL_GLOB.initialize_util_cache(

585: PA_DEBUG.g_err_stage := '200 : Before calling PA_REP_UTIL_GLOB.initialize_util_cache';
586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
587: END IF;
588:
589: PA_REP_UTIL_GLOB.initialize_util_cache(
590: p_ac_start_date => TRUNC(TO_DATE(p_ac_start_date,'YYYY/MM/DD HH24:MI:SS'))
591: ,p_ac_end_date => TRUNC(TO_DATE(p_ac_end_date,'YYYY/MM/DD HH24:MI:SS'))
592: ,p_fc_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
593: ,p_fc_end_date => TRUNC(TO_DATE(p_fc_end_date,'YYYY/MM/DD HH24:MI:SS'))

Line 598: PA_DEBUG.g_err_stage := '250 : After calling PA_REP_UTIL_GLOB.initialize_util_cache';

594: ,p_org_rollup_method => p_org_rollup_method
595: ,p_debug_mode => p_debug_mode
596: );
597: IF l_debug ='Y'THEN -- bug 2674619
598: PA_DEBUG.g_err_stage := '250 : After calling PA_REP_UTIL_GLOB.initialize_util_cache';
599: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
600: END IF;
601:
602: /*

Line 611: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id

607: SELECT max(LAST_UPDATE_DATE)
608: INTO l_orghier_date_before
609: FROM pa_org_hierarchy_denorm
610: WHERE pa_org_use_type = 'REPORTING'
611: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
612: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.
613: G_org_structure_version_id
614: ;
615: IF l_debug ='Y'THEN -- bug 2674619

Line 612: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.

608: INTO l_orghier_date_before
609: FROM pa_org_hierarchy_denorm
610: WHERE pa_org_use_type = 'REPORTING'
611: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
612: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.
613: G_org_structure_version_id
614: ;
615: IF l_debug ='Y'THEN -- bug 2674619
616: PA_DEBUG.g_err_stage := '300 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

Line 618: PA_DEBUG.g_err_stage := '330 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

614: ;
615: IF l_debug ='Y'THEN -- bug 2674619
616: PA_DEBUG.g_err_stage := '300 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';
617: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
618: PA_DEBUG.g_err_stage := '330 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
619: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
620: END IF;
621:
622: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN

Line 622: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN

618: PA_DEBUG.g_err_stage := '330 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
619: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
620: END IF;
621:
622: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
623: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
624: l_errbuf := NULL;
625: l_retcode := '0';
626: pa_rep_util_glob.Get_Effective_Start_Period_Num(

Line 623: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN

619: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
620: END IF;
621:
622: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
623: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
624: l_errbuf := NULL;
625: l_retcode := '0';
626: pa_rep_util_glob.Get_Effective_Start_Period_Num(
627: errbuf => l_errbuf,

Line 626: pa_rep_util_glob.Get_Effective_Start_Period_Num(

622: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
623: IF pa_rep_util_glob.G_util_option_details.G_pa_period_flag = 'Y' THEN
624: l_errbuf := NULL;
625: l_retcode := '0';
626: pa_rep_util_glob.Get_Effective_Start_Period_Num(
627: errbuf => l_errbuf,
628: retcode => l_retcode,
629: effective_start_period_num => l_effect_start_period_num,
630: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

Line 630: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

626: pa_rep_util_glob.Get_Effective_Start_Period_Num(
627: errbuf => l_errbuf,
628: retcode => l_retcode,
629: effective_start_period_num => l_effect_start_period_num,
630: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
631: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
632: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
633: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
634: );

Line 631: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019

627: errbuf => l_errbuf,
628: retcode => l_retcode,
629: effective_start_period_num => l_effect_start_period_num,
630: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
631: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
632: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
633: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
634: );
635: IF l_retcode = '2' THEN

Line 632: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,

628: retcode => l_retcode,
629: effective_start_period_num => l_effect_start_period_num,
630: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
631: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_pa_period_set_name, -- bug 3434019
632: p_period_type => pa_rep_util_glob.G_implementation_details.G_pa_period_type,
633: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
634: );
635: IF l_retcode = '2' THEN
636: retcode := '2';

Line 653: PA_REP_UTIL_GLOB.G_eff_fc_start_pa_period_num := l_effect_start_period_num;

649: IF l_debug ='Y'THEN -- bug 2674619
650: PA_DEBUG.g_err_stage := '350 : Eff pd Num-PA '||to_char(l_effect_start_period_num);
651: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
652: END IF;
653: PA_REP_UTIL_GLOB.G_eff_fc_start_pa_period_num := l_effect_start_period_num;
654: END IF;
655: END IF;
656: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
657: l_errbuf := NULL;

Line 656: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN

652: END IF;
653: PA_REP_UTIL_GLOB.G_eff_fc_start_pa_period_num := l_effect_start_period_num;
654: END IF;
655: END IF;
656: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
657: l_errbuf := NULL;
658: l_retcode := '0';
659: pa_rep_util_glob.Get_Effective_Start_Period_Num(
660: errbuf => l_errbuf,

Line 659: pa_rep_util_glob.Get_Effective_Start_Period_Num(

655: END IF;
656: IF pa_rep_util_glob.G_util_option_details.G_gl_period_flag = 'Y' THEN
657: l_errbuf := NULL;
658: l_retcode := '0';
659: pa_rep_util_glob.Get_Effective_Start_Period_Num(
660: errbuf => l_errbuf,
661: retcode => l_retcode,
662: effective_start_period_num => l_effect_start_period_num,
663: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

Line 663: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,

659: pa_rep_util_glob.Get_Effective_Start_Period_Num(
660: errbuf => l_errbuf,
661: retcode => l_retcode,
662: effective_start_period_num => l_effect_start_period_num,
663: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
664: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
665: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
666: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
667: );

Line 664: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019

660: errbuf => l_errbuf,
661: retcode => l_retcode,
662: effective_start_period_num => l_effect_start_period_num,
663: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
664: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
665: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
666: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
667: );
668: IF l_retcode = '2' THEN

Line 665: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,

661: retcode => l_retcode,
662: effective_start_period_num => l_effect_start_period_num,
663: -- p_period_set_name => pa_rep_util_glob.G_implementation_details.G_period_set_name,
664: p_period_set_name => pa_rep_util_glob.G_implementation_details.G_gl_period_set_name, -- bug 3434019
665: p_period_type => pa_rep_util_glob.G_implementation_details.G_gl_period_type,
666: p_start_date => TRUNC(TO_DATE(p_fc_start_date,'YYYY/MM/DD HH24:MI:SS'))
667: );
668: IF l_retcode = '2' THEN
669: retcode := '2';

Line 687: PA_REP_UTIL_GLOB.G_eff_fc_start_gl_period_num := l_effect_start_period_num;

683:
684: PA_DEBUG.g_err_stage := '400 : Eff pd Num-GL '||to_char(l_effect_start_period_num);
685: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
686: END IF;
687: PA_REP_UTIL_GLOB.G_eff_fc_start_gl_period_num := l_effect_start_period_num;
688: END IF;
689: END IF;
690: END IF;
691:

Line 693: PA_DEBUG.g_err_stage := '450 : After calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

689: END IF;
690: END IF;
691:
692: IF l_debug ='Y'THEN -- bug 2674619
693: PA_DEBUG.g_err_stage := '450 : After calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
694: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
695: PA_DEBUG.g_err_stage := '500 : Before calling PA_SUMMARIZE_FORECAST_UTIL_PVT.summarize_forecast_util';
696: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
697: END IF;

Line 726: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id

722: SELECT max(LAST_UPDATE_DATE)
723: INTO l_orghier_date_after
724: FROM pa_org_hierarchy_denorm
725: WHERE pa_org_use_type = 'REPORTING'
726: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
727: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
728: ;
729:
730: IF ( l_orghier_date_after > l_orghier_date_before) then

Line 727: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id

723: INTO l_orghier_date_after
724: FROM pa_org_hierarchy_denorm
725: WHERE pa_org_use_type = 'REPORTING'
726: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
727: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
728: ;
729:
730: IF ( l_orghier_date_after > l_orghier_date_before) then
731: FND_MESSAGE.Set_Name('PA','PA_UTIL_ORGZ_HIER_CHANGE');

Line 751: PA_DEBUG.g_err_stage := '650 : Exiting PA_REP_UTIL_GLOB.get_util_fc_parm';

747: IF l_debug ='Y'THEN -- bug 2674619
748: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';
749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
750:
751: PA_DEBUG.g_err_stage := '650 : Exiting PA_REP_UTIL_GLOB.get_util_fc_parm';
752: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
753: END IF;
754: PA_DEBUG.Reset_Curr_Function;
755: EXCEPTION

Line 770: p_pkg_name => 'PA_REP_UTIL_GLOB.get_util_fc_parm'

766: /*
767: * Set the excetption Message and the stack
768: */
769: FND_MSG_PUB.add_exc_msg (
770: p_pkg_name => 'PA_REP_UTIL_GLOB.get_util_fc_parm'
771: ,p_procedure_name => PA_DEBUG.G_Err_Stack
772: );
773: RAISE;
774:

Line 789: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

785: BEGIN
786:
787: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Util_Prc_Switch');
788: IF l_debug ='Y'THEN -- bug 2674619
789: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
791: END IF;
792: /*
793: * assume success

Line 816: -- PA_DEBUG.init_err_stack('PA_REP_UTIL_GLOB.Get_Util_Prc_Switch');

812: IF l_debug ='Y'THEN -- bug 2674619
813: PA_DEBUG.g_err_stage := '100 : X_PRC_SWITCH Value : '||x_prc_switch;
814: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
815:
816: -- PA_DEBUG.init_err_stack('PA_REP_UTIL_GLOB.Get_Util_Prc_Switch');
817: PA_DEBUG.g_err_stage := '150 : Exiting PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
818: END IF;
819: PA_DEBUG.Reset_Curr_Function;
820:

Line 817: PA_DEBUG.g_err_stage := '150 : Exiting PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';

813: PA_DEBUG.g_err_stage := '100 : X_PRC_SWITCH Value : '||x_prc_switch;
814: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
815:
816: -- PA_DEBUG.init_err_stack('PA_REP_UTIL_GLOB.Get_Util_Prc_Switch');
817: PA_DEBUG.g_err_stage := '150 : Exiting PA_REP_UTIL_GLOB.Get_Util_Prc_Switch';
818: END IF;
819: PA_DEBUG.Reset_Curr_Function;
820:
821: EXCEPTION

Line 842: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.initialize_util_cache';

838: IS
839: BEGIN
840: PA_DEBUG.Set_Curr_Function( p_function => 'Initialize_Util_Cache');
841: IF l_debug ='Y'THEN -- bug 2674619
842: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.initialize_util_cache';
843: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
844: END IF;
845: /*
846: * Initialize the Global variables with the user specified

Line 867: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.initialize_util_cache';

863: TO_DATE('31-12-4712','DD-MM-YYYY'));
864: G_input_parameters.G_org_rollup_method := p_org_rollup_method;
865: G_input_parameters.G_debug_mode := p_debug_mode;
866: IF l_debug ='Y'THEN -- bug 2674619
867: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.initialize_util_cache';
868: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
869: PA_DEBUG.Reset_Curr_Function;
870: END IF;
871: EXCEPTION

Line 892: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

888:
889: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Effective_Start_Period_Num');
890: IF l_debug ='Y'THEN -- bug 2674619
891:
892: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
894: END IF;
895:
896: SELECT (g.period_year*10000) + g.period_num

Line 909: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';

905: -- AND map.period_set_name = G_implementation_details.G_period_set_name;
906: AND map.period_set_name = p_period_set_name; --bug 3434019
907:
908: IF l_debug ='Y'THEN -- bug 2674619
909: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
910: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
911: END IF;
912: EXCEPTION
913: WHEN NO_DATA_FOUND THEN

Line 924: * Its called from, PA_REP_UTIL_GLOB.auto_util_cache.

920: END Get_Effective_Start_Period_Num;
921:
922: /*
923: * This Procedure populates the Amount type ids Cache.
924: * Its called from, PA_REP_UTIL_GLOB.auto_util_cache.
925: */
926: PROCEDURE initialize_amt_type_id_cache
927: IS
928: BEGIN

Line 931: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.initialize_amt_type_id_cache';

927: IS
928: BEGIN
929: PA_DEBUG.Set_Curr_Function( p_function => 'Initialize_Amt_Type_Id_Cache');
930: IF l_debug ='Y'THEN -- bug 2674619
931: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.initialize_amt_type_id_cache';
932: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
933: END IF;
934: /*
935: * Initialize the amount type_id variables with their

Line 984: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.initialize_amt_type_id_cache';

980: G_amt_type_details.G_org_tot_headcount_id := 39;
981: G_amt_type_details.G_org_tot_empheadcount_id := 40;
982: G_amt_type_details.G_quantity_id := 41;
983: IF l_debug ='Y'THEN -- bug 2674619
984: PA_DEBUG.g_err_stage := '100 : Exiting PA_REP_UTIL_GLOB.initialize_amt_type_id_cache';
985: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
986: END IF;
987: PA_DEBUG.Reset_Curr_Function;
988:

Line 1053: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.auto_util_cache';

1049: IS
1050: BEGIN
1051: PA_DEBUG.Set_Curr_Function( p_function => 'Auto_Util_Cache');
1052: IF l_debug ='Y'THEN -- bug 2674619
1053: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.auto_util_cache';
1054: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1055: END IF;
1056:
1057: /*

Line 1216: PA_REP_UTIL_GLOB.initialize_amt_type_id_cache;

1212: PA_DEBUG.g_err_stage := '400 : Before calling initialize_amt_type_id_cache';
1213: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1214: END IF;
1215:
1216: PA_REP_UTIL_GLOB.initialize_amt_type_id_cache;
1217: IF l_debug ='Y'THEN -- bug 2674619
1218: PA_DEBUG.g_err_stage := '450 : After calling initialize_amt_type_id_cache';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1220:

Line 1221: PA_DEBUG.g_err_stage := '500 : Exiting PA_REP_UTIL_GLOB.auto_util_cache';

1217: IF l_debug ='Y'THEN -- bug 2674619
1218: PA_DEBUG.g_err_stage := '450 : After calling initialize_amt_type_id_cache';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1220:
1221: PA_DEBUG.g_err_stage := '500 : Exiting PA_REP_UTIL_GLOB.auto_util_cache';
1222: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1223: END IF;
1224: PA_DEBUG.Reset_Curr_Function;
1225: EXCEPTION

Line 1348: RETURN PA_REP_UTIL_GLOB.G_DUMMY_C;

1344: */
1345: FUNCTION GetDummy RETURN VARCHAR2
1346: IS
1347: BEGIN
1348: RETURN PA_REP_UTIL_GLOB.G_DUMMY_C;
1349: END GetDummy;
1350:
1351: FUNCTION GetDummyDate RETURN DATE
1352: IS

Line 1354: RETURN PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;

1350:
1351: FUNCTION GetDummyDate RETURN DATE
1352: IS
1353: BEGIN
1354: RETURN PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;
1355: END GetDummyDate;
1356:
1357: /*
1358: * Function to return org_id

Line 1480: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.update_util_cache';

1476: BEGIN
1477:
1478: PA_DEBUG.Set_Curr_Function( p_function => 'Update_Util_Cache');
1479: IF l_debug ='Y'THEN -- bug 2674619
1480: PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.update_util_cache';
1481: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1482:
1483: PA_DEBUG.g_err_stage := '100 : Before Accessing FND_PROFILE values';
1484: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1640: PA_REP_UTIL_GLOB.initialize_amt_type_id_cache;

1636: PA_DEBUG.g_err_stage := '400 : Before calling initialize_amt_type_id_cache';
1637: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1638: END IF;
1639:
1640: PA_REP_UTIL_GLOB.initialize_amt_type_id_cache;
1641: IF l_debug ='Y'THEN -- bug 2674619
1642: PA_DEBUG.g_err_stage := '450 : After calling initialize_amt_type_id_cache';
1643: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1644: END IF;

Line 1648: PA_DEBUG.g_err_stage := '500 : Exiting PA_REP_UTIL_GLOB.update_util_cache';

1644: END IF;
1645: END IF;
1646:
1647: IF l_debug ='Y'THEN -- bug 2674619
1648: PA_DEBUG.g_err_stage := '500 : Exiting PA_REP_UTIL_GLOB.update_util_cache';
1649: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1650: END IF;
1651: PA_DEBUG.Reset_Curr_Function;
1652:

Line 1665: END PA_REP_UTIL_GLOB;

1661: * Package is loaded.
1662: */
1663: auto_util_cache;
1664:
1665: END PA_REP_UTIL_GLOB;