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.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_UTILS

Line 103: application => PJI_UTILS.GET_PJI_SCHEMA_NAME ,-- Application Name

99: exception
100: when no_data_found then null;
101: end;
102: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
103: application => PJI_UTILS.GET_PJI_SCHEMA_NAME ,-- Application Name
104: program => 'PJI_PJP_SUMMARIZE_INCR', -- Program Name
105: sub_request => FALSE, -- Sub Request
106: argument1 => 'I', -- p_run_mode varchar2
107: argument2 => '',

Line 3801: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_versioned_flag: '||p_versioned_flag||'p_struct_type:'||p_struct_type||'p_publish_flag:'||p_publish_flag||'p_rerun_flag :' || p_rerun_flag ,null,3);

3797: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3798: ( p_package_name => g_package_name
3799: , x_return_status => x_return_status );
3800: IF g_debug_mode='Y' THEN
3801: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_versioned_flag: '||p_versioned_flag||'p_struct_type:'||p_struct_type||'p_publish_flag:'||p_publish_flag||'p_rerun_flag :' || p_rerun_flag ,null,3);
3802: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_calling_Context: '||p_calling_Context||'p_deffered_mode:'||p_deffered_mode||'Event Id:' || p_event_id,null,3);
3803: end if;
3804:
3805: cleanup_temp_tables;

Line 3802: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_calling_Context: '||p_calling_Context||'p_deffered_mode:'||p_deffered_mode||'Event Id:' || p_event_id,null,3);

3798: ( p_package_name => g_package_name
3799: , x_return_status => x_return_status );
3800: IF g_debug_mode='Y' THEN
3801: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_versioned_flag: '||p_versioned_flag||'p_struct_type:'||p_struct_type||'p_publish_flag:'||p_publish_flag||'p_rerun_flag :' || p_rerun_flag ,null,3);
3802: Pji_Utils.write2log('calling WBS_MAINT_PVT :p_calling_Context: '||p_calling_Context||'p_deffered_mode:'||p_deffered_mode||'Event Id:' || p_event_id,null,3);
3803: end if;
3804:
3805: cleanup_temp_tables;
3806:

Line 3822: Pji_Utils.write2log('WBS_Maint_Pvt: l_new_wbs_version_id: '||l_new_wbs_version_id||'l_old_wbs_version_id: '||l_old_wbs_version_id,null,3);

3818: WHERE
3819: elog.EVENT_ID = p_event_id AND
3820: ROWNUM <= 1;
3821: IF g_debug_mode='Y' THEN
3822: Pji_Utils.write2log('WBS_Maint_Pvt: l_new_wbs_version_id: '||l_new_wbs_version_id||'l_old_wbs_version_id: '||l_old_wbs_version_id,null,3);
3823: end if;
3824: -----------------------------------------------
3825: --Determine the plan_version_id for the struct
3826: --for which we are running wbs_maint

Line 3843: Pji_Utils.write2log('WBS_Maint_Pvt: No data found for plan version');

3839: exception
3840: when no_data_found then
3841: null;
3842: IF g_debug_mode='Y' THEN
3843: Pji_Utils.write2log('WBS_Maint_Pvt: No data found for plan version');
3844: END IF;
3845: end;
3846:
3847: IF g_debug_mode='Y' THEN

Line 3848: Pji_Utils.write2log('WBS_Maint_Pvt:' || 'Plan version Id:' || l_plan_version_id);

3844: END IF;
3845: end;
3846:
3847: IF g_debug_mode='Y' THEN
3848: Pji_Utils.write2log('WBS_Maint_Pvt:' || 'Plan version Id:' || l_plan_version_id);
3849: END IF;
3850:
3851:
3852: ----------------------------------------------

Line 3886: Pji_Utils.write2log( 'WBS_MAINT_PVT NO DATA FOUND coming for the project _Id:'||l_project_id,null,3);

3882: end if;
3883: EXCEPTION
3884: WHEN NO_DATA_FOUND THEN
3885: IF g_debug_mode='Y' THEN
3886: Pji_Utils.write2log( 'WBS_MAINT_PVT NO DATA FOUND coming for the project _Id:'||l_project_id,null,3);
3887: END IF;
3888: l_prg_event_id:=null;
3889: END;
3890:

Line 3912: Pji_Utils.write2log( 'WBS_MAINT_PVT l_prg_event_id :'||l_prg_event_id||'l_struct_sharing_code'||l_struct_sharing_code ,null,3);

3908: project_id = l_project_id;
3909: end if ;
3910:
3911: IF g_debug_mode='Y' THEN
3912: Pji_Utils.write2log( 'WBS_MAINT_PVT l_prg_event_id :'||l_prg_event_id||'l_struct_sharing_code'||l_struct_sharing_code ,null,3);
3913: END IF;
3914: IF l_prg_event_id is not null then
3915:
3916: --Bug 4626803: Need this for preventing doubling

Line 3942: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');

3938:
3939: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3940: x_return_status := l_return_status;
3941: IF g_debug_mode='Y' THEN
3942: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
3943: END IF;
3944: RETURN;
3945: END IF;
3946: pa_task_pub1.G_CALL_PJI_ROLLUP := 'N';

Line 3972: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);

3968: l_chd_dev_status,
3969: l_chd_message
3970: )) then
3971:
3972: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);
3973:
3974: end if;
3975:
3976: if l_chd_dev_status ='ERROR' THEN

Line 3987: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

3983: p_procedure_name => 'WBS_MAINT_PVT',
3984: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3985:
3986: IF g_debug_mode='Y' THEN null;
3987: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3988: end if;
3989: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
3990: l_return_status:='E';
3991: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

Line 3998: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3996: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3997: IF g_debug_mode='Y' THEN null;
3998: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3999: end if;
4000:
4001: end if;
4002: END IF; -- Bug 5999999

Line 4022: Pji_Utils.write2log( 'WBS_MAINT_PVT l_plan_version_id_tbl.COUNT :'||l_plan_version_id_tbl.COUNT ,null,3);

4018: l_plan_version_id_tbl(l_plan_version_id_tbl.COUNT) := i.plan_version_id;
4019:
4020: END LOOP;
4021: IF g_debug_mode='Y' THEN
4022: Pji_Utils.write2log( 'WBS_MAINT_PVT l_plan_version_id_tbl.COUNT :'||l_plan_version_id_tbl.COUNT ,null,3);
4023: END IF;
4024: /*bug5353559*/
4025: IF (l_plan_version_id_tbl.COUNT <= 0) THEN
4026: --RETURN;

Line 4048: Pji_Utils.write2log('WBS Maint Pvt:' || 'New WBS Version ID:' || l_new_wbs_version_id);

4044: p_prg_group2 => NULL
4045: );
4046:
4047: IF g_debug_mode='Y' THEN
4048: Pji_Utils.write2log('WBS Maint Pvt:' || 'New WBS Version ID:' || l_new_wbs_version_id);
4049: Pji_Utils.write2log('WBS Maint Pvt:' || 'Old WBS Version ID:' || l_old_wbs_version_id);
4050: end if;
4051:
4052:

Line 4049: Pji_Utils.write2log('WBS Maint Pvt:' || 'Old WBS Version ID:' || l_old_wbs_version_id);

4045: );
4046:
4047: IF g_debug_mode='Y' THEN
4048: Pji_Utils.write2log('WBS Maint Pvt:' || 'New WBS Version ID:' || l_new_wbs_version_id);
4049: Pji_Utils.write2log('WBS Maint Pvt:' || 'Old WBS Version ID:' || l_old_wbs_version_id);
4050: end if;
4051:
4052:
4053: Pji_Pjp_Sum_Rollup.set_online_context (

Line 4068: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Pjp_Sum_Rollup.rollup_fpr_wbs',null,3);

4064: Pji_Pjp_Sum_Rollup.populate_xbs_denorm_delta;
4065:
4066: Pji_Pjp_Sum_Rollup.rollup_fpr_wbs;
4067: IF g_debug_mode='Y' THEN
4068: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Pjp_Sum_Rollup.rollup_fpr_wbs',null,3);
4069: end if;
4070: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;
4071:
4072: Pji_Pjp_Sum_Rollup.update_xbs_denorm;

Line 4079: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);

4075: p_worker_id => 1
4076: ,p_extraction_type => 'ONLINE');
4077:
4078: IF g_debug_mode='Y' THEN
4079: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);
4080: end if;
4081: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
4082:
4083:

Line 4133: Pji_Utils.write2log(' WBS_MAINT_PVT: RETURNING as table count is Zero',null,3);

4129: /* bug5353559*/
4130: /* Bug 5609109
4131: IF (l_plan_version_id_tbl.COUNT <= 0) THEN
4132: IF g_debug_mode='Y' THEN
4133: Pji_Utils.write2log(' WBS_MAINT_PVT: RETURNING as table count is Zero',null,3);
4134: end if;
4135: RETURN;
4136: end if; */
4137:

Line 4139: Pji_Utils.write2log( 'calling APPLY_LP_PROG_ON_CWV :p_calling_Context: '||p_calling_Context||'p_deffered_mode:'||p_deffered_mode||'l_new_wbs_version_id:'||l_new_wbs_version_id ,null,3);

4135: RETURN;
4136: end if; */
4137:
4138: IF g_debug_mode='Y' THEN
4139: Pji_Utils.write2log( 'calling APPLY_LP_PROG_ON_CWV :p_calling_Context: '||p_calling_Context||'p_deffered_mode:'||p_deffered_mode||'l_new_wbs_version_id:'||l_new_wbs_version_id ,null,3);
4140: end if;
4141: IF p_calling_Context='APPLY_PROGRESS' and p_deffered_mode='Y' THEN
4142: PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV(
4143: p_project_id => l_project_id,

Line 4149: Pji_Utils.write2log( 'after call to APPLY_LP_PROG_ON_CWV :l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data||'CONC_REQUEST_Id:'||Fnd_Global.CONC_REQUEST_ID,null,3);

4145: x_return_status => l_return_status,
4146: x_msg_count => l_msg_count ,
4147: x_msg_data => l_msg_data);
4148: IF g_debug_mode='Y' THEN
4149: Pji_Utils.write2log( 'after call to APPLY_LP_PROG_ON_CWV :l_return_status:'||l_return_status||'l_msg_data:'||l_msg_data||'CONC_REQUEST_Id:'||Fnd_Global.CONC_REQUEST_ID,null,3);
4150: end if;
4151: END IF;
4152:
4153:

Line 4183: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');

4179:
4180: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4181: x_return_status := l_return_status;
4182: IF g_debug_mode='Y' THEN
4183: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4184: END IF;
4185: RETURN;
4186: END IF;
4187: pa_task_pub1.G_CALL_PJI_ROLLUP := 'N';

Line 4214: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);

4210: l_chd_dev_status,
4211: l_chd_message
4212: )) then
4213:
4214: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);
4215:
4216: end if;
4217: if l_chd_dev_status ='ERROR' THEN
4218: l_return_status:='E';

Line 4228: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

4224: p_procedure_name => 'WBS_MAINT_PVT',
4225: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4226:
4227: IF g_debug_mode='Y' THEN null;
4228: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4229: end if;
4230: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4231: l_return_status:='E';
4232: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

Line 4239: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4237: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4238: IF g_debug_mode='Y' THEN null;
4239: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4240: end if;
4241:
4242: end if;
4243: END IF ; --Bug 5999999

Line 4249: Pji_Utils.write2log( ' wbs maint pvt .. 0002 ::l_return_status'||l_return_status ,null,3);

4245:
4246:
4247: x_return_status:=l_return_status;
4248: IF g_debug_mode='Y' THEN
4249: Pji_Utils.write2log( ' wbs maint pvt .. 0002 ::l_return_status'||l_return_status ,null,3);
4250: end if;
4251:
4252: EXCEPTION
4253: WHEN OTHERS THEN

Line 4293: Pji_Utils.GET_PJI_SCHEMA_NAME, -- Application name

4289: ROWNUM <= 1;
4290:
4291: l_request_id:=
4292: Fnd_Request.SUBMIT_REQUEST (
4293: Pji_Utils.GET_PJI_SCHEMA_NAME, -- Application name
4294: 'PJI_FM_SUM_CHANGE', -- concurrent program name
4295: NULL, -- description (optional)
4296: NULL, -- Start Time (optional)
4297: FALSE, -- called from another conc. request

Line 4372: Pji_Utils.write2log('Coming IN WBS_MAINT :p_new_struct_ver_id: '||p_new_struct_ver_id||'p_old_struct_ver_id:'||p_old_struct_ver_id||'p_project_id: '||p_project_id||'p_publish_flag :' || p_publish_flag ,null,3);

4368: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
4369: ( p_package_name => g_package_name
4370: , x_return_status => x_return_status );
4371: IF g_debug_mode='Y' THEN
4372: Pji_Utils.write2log('Coming IN WBS_MAINT :p_new_struct_ver_id: '||p_new_struct_ver_id||'p_old_struct_ver_id:'||p_old_struct_ver_id||'p_project_id: '||p_project_id||'p_publish_flag :' || p_publish_flag ,null,3);
4373: Pji_Utils.write2log('Coming IN WBS_MAINT :p_online_flag: '||p_online_flag||'p_calling_Context : '||p_calling_Context ||'p_rerun_flag: '|| p_rerun_flag,null,3);
4374: end if;
4375:
4376: --Identify if the project has shared/split

Line 4373: Pji_Utils.write2log('Coming IN WBS_MAINT :p_online_flag: '||p_online_flag||'p_calling_Context : '||p_calling_Context ||'p_rerun_flag: '|| p_rerun_flag,null,3);

4369: ( p_package_name => g_package_name
4370: , x_return_status => x_return_status );
4371: IF g_debug_mode='Y' THEN
4372: Pji_Utils.write2log('Coming IN WBS_MAINT :p_new_struct_ver_id: '||p_new_struct_ver_id||'p_old_struct_ver_id:'||p_old_struct_ver_id||'p_project_id: '||p_project_id||'p_publish_flag :' || p_publish_flag ,null,3);
4373: Pji_Utils.write2log('Coming IN WBS_MAINT :p_online_flag: '||p_online_flag||'p_calling_Context : '||p_calling_Context ||'p_rerun_flag: '|| p_rerun_flag,null,3);
4374: end if;
4375:
4376: --Identify if the project has shared/split
4377: --versioned/non-versioned structure

Line 4760: Pji_Utils.write2log('Going out WBS_MAINT :x_request_id: '||x_request_id||'x_processing_code:'||x_processing_code||'x_msg_code: '||x_msg_code ,null,3);

4756: -- IF g_deffered_mode='Y' THEN
4757: -- x_online_flag:='N';
4758: -- END IF;
4759: IF g_debug_mode='Y' THEN
4760: Pji_Utils.write2log('Going out WBS_MAINT :x_request_id: '||x_request_id||'x_processing_code:'||x_processing_code||'x_msg_code: '||x_msg_code ,null,3);
4761: Pji_Utils.write2log('Going out WBS_MAINT :x_return_status: '||x_return_status||'x_online_flag :'||x_online_flag ,null,3);
4762: end if;
4763: EXCEPTION
4764: WHEN OTHERS THEN

Line 4761: Pji_Utils.write2log('Going out WBS_MAINT :x_return_status: '||x_return_status||'x_online_flag :'||x_online_flag ,null,3);

4757: -- x_online_flag:='N';
4758: -- END IF;
4759: IF g_debug_mode='Y' THEN
4760: Pji_Utils.write2log('Going out WBS_MAINT :x_request_id: '||x_request_id||'x_processing_code:'||x_processing_code||'x_msg_code: '||x_msg_code ,null,3);
4761: Pji_Utils.write2log('Going out WBS_MAINT :x_return_status: '||x_return_status||'x_online_flag :'||x_online_flag ,null,3);
4762: end if;
4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

Line 4795: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :p_event_id '||p_event_id ||'p_calling_context'||p_calling_context ,null,3);

4791: l_calling_context VARCHAR2(20);
4792:
4793: BEGIN
4794: IF g_debug_mode='Y' THEN
4795: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :p_event_id '||p_event_id ||'p_calling_context'||p_calling_context ,null,3);
4796: end if;
4797: select decode(p_calling_context, 'ONLINE_PUBLISH', 'CONC_PUBLISH'
4798: , 'ONLINE_UPDATE', 'CONC_UPDATE', p_calling_context)
4799: into l_calling_context

Line 4841: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);

4837: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4838: x_lock_mode => l_lock_mode ,
4839: x_return_status => l_return_status );
4840: IF g_debug_mode='Y' THEN
4841: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
4842: end if;
4843: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4844: UPDATE pa_proj_elem_ver_structure
4845: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'

Line 4870: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);

4866: p_deffered_mode =>'Y',
4867: p_rerun_flag => p_rerun_flag,
4868: x_return_status => l_return_status );
4869: IF g_debug_mode='Y' THEN
4870: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
4871: end if;
4872: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4873:
4874: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

Line 4910: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :Not able to take the lock showing the warning' ,null,4);

4906: END IF;
4907:
4908: ELSIF l_lock_mode = 'F' THEN
4909: IF g_debug_mode='Y' THEN
4910: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :Not able to take the lock showing the warning' ,null,4);
4911: end if;
4912: retcode := 1; --Unable to acquire lock and hence complete request as warning
4913:
4914: END IF;

Line 4930: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES : COMING to the exception' ,null,5);

4926: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
4927: x_return_status => l_return_status );
4928: END IF;
4929: IF g_debug_mode='Y' THEN
4930: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES : COMING to the exception' ,null,5);
4931: end if;
4932: retcode := 2;
4933: errbuf := SQLERRM;
4934: END;

Line 5449: Pji_Utils.write2log('maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||

5445: end if;
5446:
5447: IF g_debug_mode='Y' THEN
5448: -- write_log ( ' maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||'p_rbs_version_id'||p_rbs_version_id||'p_prg_rollup_flag'||p_prg_rollup_flag);
5449: Pji_Utils.write2log('maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||
5450: 'p_rbs_version_id'||p_rbs_version_id||'p_prg_rollup_flag'||p_prg_rollup_flag,null,3);
5451: end if;
5452: IF (l_rbs_version_id_tbl.COUNT=0) THEN
5453: Pji_Utils.write2log('p_rbs_version_id is NULL. Nothing to rollup by. Returning.',null,3);

Line 5453: Pji_Utils.write2log('p_rbs_version_id is NULL. Nothing to rollup by. Returning.',null,3);

5449: Pji_Utils.write2log('maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||
5450: 'p_rbs_version_id'||p_rbs_version_id||'p_prg_rollup_flag'||p_prg_rollup_flag,null,3);
5451: end if;
5452: IF (l_rbs_version_id_tbl.COUNT=0) THEN
5453: Pji_Utils.write2log('p_rbs_version_id is NULL. Nothing to rollup by. Returning.',null,3);
5454: RETURN;
5455: END IF;
5456:
5457: BEGIN

Line 5562: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||

5558:
5559: l_prg_project_id_tbl.EXTEND;
5560: l_prg_project_id_tbl(l_prg_count) := l_project_id;
5561: IF g_debug_mode='Y' THEN
5562: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||
5563: l_prg_plan_version_id_tbl(l_prg_count)||'l_prg_wbs_version_id_tbl'||l_prg_wbs_version_id_tbl(l_prg_count)||
5564: 'l_prg_project_id_tbl'||l_prg_project_id_tbl(l_prg_count) ,null,3);
5565: end if;
5566: l_prg_count := l_prg_count + 1;

Line 5582: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||

5578:
5579: l_prg_project_id_tbl.EXTEND;
5580: l_prg_project_id_tbl(l_prg_count) := il_project_id_tbl(i);
5581: IF g_debug_mode='Y' THEN
5582: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||
5583: l_prg_plan_version_id_tbl(l_prg_count)||'l_prg_wbs_version_id_tbl'||l_prg_wbs_version_id_tbl(l_prg_count)||
5584: 'l_prg_project_id_tbl'||l_prg_project_id_tbl(l_prg_count) ,null,3);
5585: end if;
5586: l_prg_count := l_prg_count + 1;

Line 5611: Pji_Utils.write2log(' maintain smart slice ..1.2 p_plan_version_id_tbl ('||i||') : ' || l_prg_plan_version_id_tbl(i) ,null,3);

5607: WHEN NO_DATA_FOUND THEN
5608: NULL;
5609: END;
5610: IF g_debug_mode='Y' THEN
5611: Pji_Utils.write2log(' maintain smart slice ..1.2 p_plan_version_id_tbl ('||i||') : ' || l_prg_plan_version_id_tbl(i) ,null,3);
5612: Pji_Utils.write2log(' maintain smart slice ..1.3 l_exists :' || l_exists ,null,3);
5613: end if;
5614:
5615: --If smart slice does not exist create the same

Line 5612: Pji_Utils.write2log(' maintain smart slice ..1.3 l_exists :' || l_exists ,null,3);

5608: NULL;
5609: END;
5610: IF g_debug_mode='Y' THEN
5611: Pji_Utils.write2log(' maintain smart slice ..1.2 p_plan_version_id_tbl ('||i||') : ' || l_prg_plan_version_id_tbl(i) ,null,3);
5612: Pji_Utils.write2log(' maintain smart slice ..1.3 l_exists :' || l_exists ,null,3);
5613: end if;
5614:
5615: --If smart slice does not exist create the same
5616: IF ( l_exists = 'N' ) THEN

Line 5626: Pji_Utils.write2log(' maintain smart slice44: '||l_count||':l_plan_version_id_tbl'||l_plan_version_id_tbl(l_count)||'l_wbs_version_id_tbl'

5622: l_project_id_tbl(l_count) := l_prg_project_id_tbl(i);
5623: l_wbs_version_id_tbl.EXTEND;
5624: l_wbs_version_id_tbl(l_count) := l_prg_wbs_version_id_tbl(i);
5625: IF g_debug_mode='Y' THEN
5626: Pji_Utils.write2log(' maintain smart slice44: '||l_count||':l_plan_version_id_tbl'||l_plan_version_id_tbl(l_count)||'l_wbs_version_id_tbl'
5627: ||l_wbs_version_id_tbl(l_count)||'l_project_id_tbl'||l_project_id_tbl(l_count) ,null,3);
5628: end if;
5629: l_count := l_count + 1;
5630:

Line 5702: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);

5698: p_fp_version_ids => l_plan_version_id_tbl
5699: , p_slice_type => 'PRI'
5700: );
5701: IF g_debug_mode='Y' THEN
5702: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);
5703: end if;
5704:
5705: IF g_debug_mode='Y' THEN
5706: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||

Line 5706: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||

5702: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);
5703: end if;
5704:
5705: IF g_debug_mode='Y' THEN
5706: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||
5707: '::l_roll_wbs_version_id_tbl.COUNT: '||l_roll_wbs_version_id_tbl.COUNT ,null,3);
5708: end if;
5709: --Inserting 'L' 'N' 'N' / 'L' 'N' 'Y' slices
5710: FOR k IN 1..l_rbs_version_id_tbl.COUNT LOOP

Line 5885: Pji_Utils.write2log(' Inserted L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);

5881: head.PLAN_TYPE_CODE = l_plan_type_code_tbl(j) ;
5882: END LOOP;/* end of RBS loop*/
5883:
5884: IF g_debug_mode='Y' THEN
5885: Pji_Utils.write2log(' Inserted L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);
5886: end if;
5887:
5888: --WBS rollup for LNN / LNY slices
5889: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT

Line 6079: Pji_Utils.write2log(' Inserted WBS rollup L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);

6075: fact.PLAN_TYPE_CODE; /*4471527 */
6076:
6077:
6078: IF g_debug_mode='Y' THEN
6079: Pji_Utils.write2log(' Inserted WBS rollup L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);
6080: end if;
6081:
6082: --XBS Rollup for WBS slice
6083: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT

Line 6275: Pji_Utils.write2log(' Inserted XBS rollup for WBS slices ' || SQL%ROWCOUNT ,null,3);

6271:
6272:
6273:
6274: IF g_debug_mode='Y' THEN
6275: Pji_Utils.write2log(' Inserted XBS rollup for WBS slices ' || SQL%ROWCOUNT ,null,3);
6276: end if;
6277: --RBS Rollup for all slices
6278: FORALL j IN 1..l_rbs_version_id_tbl.COUNT
6279: INSERT INTO pji_fp_aggr_pjp1_t (

Line 6454: Pji_Utils.write2log(' Inserted RBS rollup for all slices ' || SQL%ROWCOUNT ,null,3);

6450: fact.PLAN_TYPE_ID,
6451: fact.PLAN_TYPE_CODE;
6452:
6453: IF g_debug_mode='Y' THEN
6454: Pji_Utils.write2log(' Inserted RBS rollup for all slices ' || SQL%ROWCOUNT ,null,3);
6455: end if;
6456:
6457: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
6458:

Line 6464: Pji_Utils.write2log(' maintain smart slice .. 0003 ' ,null,3);

6460: COMMIT;
6461: END IF;
6462:
6463: IF g_debug_mode='Y' THEN
6464: Pji_Utils.write2log(' maintain smart slice .. 0003 ' ,null,3);
6465: end if;
6466:
6467: EXCEPTION
6468: WHEN Invalid_Excep THEN