DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_DEBUG

Line 13: g_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

9: g_package_name VARCHAR2(100) := 'PJI_FM_XBS_ACCUM_MAINT';
10: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_XBS_ACCUM_MAINT';
11: g_update_num_rows_limit NUMBER := 1; -- 1000;
12: g_smart_rows_deleted NUMBER :=0; --maintains the number of rows deleted in delete smart slice api
13: g_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
14: g_deffered_mode VARCHAR2(1) :='N';
15: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: Invalid_Excep Exception ;
17:

Line 127: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN

123: PROCEDURE debug_plan_lines
124: IS
125: BEGIN
126:
127: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN
128:
129: INSERT INTO pji_fm_extr_plan_lines_debug
130: (
131: PROJECT_ID ,

Line 420: pa_debug.write('PLAN_CREATE: ' || g_module_name,'Inside plan_create',1);

416: , x_return_status => x_return_status );
417:
418: print_time ( ' PLAN_CREATE api ' );
419: IF g_debug_mode = 'Y' THEN
420: pa_debug.write('PLAN_CREATE: ' || g_module_name,'Inside plan_create',1);
421: END IF;
422:
423: --Bug#13797526 FP of 13698963
424: IF (p_fp_version_ids.COUNT = 0) THEN

Line 460: pa_debug.write('PLAN_CREATE: ' || g_module_name,'Calling CREATE_PRIMARY_PVT',1);

456: , 1);
457: */
458:
459: IF g_debug_mode = 'Y' THEN
460: pa_debug.write('PLAN_CREATE: ' || g_module_name,'Calling CREATE_PRIMARY_PVT',1);
461: END IF;
462:
463: -- OLAP START CHANGE
464:

Line 543: pa_debug.write('PLAN_CREATE: ' || g_module_name,'After Calling CREATE_PRIMARY_PVT',1);

539:
540: -- OLAP END CHANGES
541:
542: IF g_debug_mode = 'Y' THEN
543: pa_debug.write('PLAN_CREATE: ' || g_module_name,'After Calling CREATE_PRIMARY_PVT',1);
544: END IF;
545:
546:
547:

Line 612: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Pa_Task_Pub1.G_CALL_PJI_ROLLUP '||Pa_Task_Pub1.G_CALL_PJI_ROLLUP,1);

608:
609:
610: BEGIN
611: IF g_debug_mode = 'Y' THEN
612: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Pa_Task_Pub1.G_CALL_PJI_ROLLUP '||Pa_Task_Pub1.G_CALL_PJI_ROLLUP,1);
613: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id '||p_plan_version_id,1);
614: END IF;
615:
616: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 613: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id '||p_plan_version_id,1);

609:
610: BEGIN
611: IF g_debug_mode = 'Y' THEN
612: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Pa_Task_Pub1.G_CALL_PJI_ROLLUP '||Pa_Task_Pub1.G_CALL_PJI_ROLLUP,1);
613: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id '||p_plan_version_id,1);
614: END IF;
615:
616: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
617: ( p_package_name => g_package_name

Line 627: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Inside plan_update',1);

623: RETURN;
624: END IF;
625:
626: IF g_debug_mode = 'Y' THEN
627: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Inside plan_update',1);
628: END IF;
629: print_time ( 'PLAN_UPDATE begin');
630:
631: INSERT_APPLY_PROG_VD;

Line 675: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_resource_list_id '||l_resource_list_id,1);

671:
672: END IF;
673:
674: IF g_debug_mode = 'Y' THEN
675: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_resource_list_id '||l_resource_list_id,1);
676: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_res_class_flag '||l_res_class_flag,1);
677: END IF;
678:
679: IF l_res_class_flag = 'N' THEN

Line 676: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_res_class_flag '||l_res_class_flag,1);

672: END IF;
673:
674: IF g_debug_mode = 'Y' THEN
675: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_resource_list_id '||l_resource_list_id,1);
676: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'l_res_class_flag '||l_res_class_flag,1);
677: END IF;
678:
679: IF l_res_class_flag = 'N' THEN
680:

Line 686: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines '||SQL%Rowcount,1);

682: SET RESOURCE_CLASS_CODE = 'PEOPLE-1'
683: WHERE RESOURCE_CLASS_CODE = 'PEOPLE';
684:
685: IF g_debug_mode = 'Y' THEN
686: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines '||SQL%Rowcount,1);
687: END IF;
688:
689: UPDATE pji_fm_extr_plan_lines
690: SET RESOURCE_CLASS_CODE = 'EQUIPMENT-1'

Line 694: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines '||SQL%Rowcount,1);

690: SET RESOURCE_CLASS_CODE = 'EQUIPMENT-1'
691: WHERE RESOURCE_CLASS_CODE = 'EQUIPMENT';
692:
693: IF g_debug_mode = 'Y' THEN
694: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines '||SQL%Rowcount,1);
695: END IF;
696:
697: END IF;
698:

Line 704: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id is not null '||p_plan_version_id ,1);

700:
701: if p_plan_version_id is not null then
702:
703: IF g_debug_mode = 'Y' THEN
704: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id is not null '||p_plan_version_id ,1);
705: END IF;
706:
707: select p.pjt_rollup_enabled_flag , p.CBS_ENABLE_FLAG, p.project_id , fpo.rbs_version_id , p.cbs_version_id
708: into l_pjt_rollup_enabled_flag , l_cbs_enable_flag, l_project_id , l_rbs_version_id , l_cbs_version_id

Line 737: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id is null ',1);

733:
734: if p_plan_version_id is null then
735:
736: IF g_debug_mode = 'Y' THEN
737: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id is null ',1);
738: END IF;
739:
740: for plan_versions_rec in plan_versions loop
741:

Line 743: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id loop '||plan_versions_rec.plan_version_id,1);

739:
740: for plan_versions_rec in plan_versions loop
741:
742: IF g_debug_mode = 'Y' THEN
743: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'p_plan_version_id loop '||plan_versions_rec.plan_version_id,1);
744: END IF;
745:
746: --if ( l_pjt_rollup_enabled_flag = 'Y' ) then
747: if plan_versions_rec.cbs_enable_flag = 'Y' THEN

Line 782: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines back',1);

778: SET RESOURCE_CLASS_CODE = 'EQUIPMENT'
779: WHERE RESOURCE_CLASS_CODE = 'EQUIPMENT-1';
780:
781: IF g_debug_mode = 'Y' THEN
782: pa_debug.write('PLAN_UPDATE: ' || g_module_name,'Updated pji_fm_extr_plan_lines back',1);
783: END IF;
784:
785: END IF;
786: