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 105: application => PJI_UTILS.GET_PJI_SCHEMA_NAME ,-- Application Name

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

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

4173: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
4174: ( p_package_name => g_package_name
4175: , x_return_status => x_return_status );
4176: IF g_debug_mode='Y' THEN
4177: 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);
4178: 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);
4179: end if;
4180:
4181: cleanup_temp_tables;

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

4174: ( p_package_name => g_package_name
4175: , x_return_status => x_return_status );
4176: IF g_debug_mode='Y' THEN
4177: 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);
4178: 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);
4179: end if;
4180:
4181: cleanup_temp_tables;
4182:

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

4194: WHERE
4195: elog.EVENT_ID = p_event_id AND
4196: ROWNUM <= 1;
4197: IF g_debug_mode='Y' THEN
4198: 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);
4199: end if;
4200: -----------------------------------------------
4201: --Determine the plan_version_id for the struct
4202: --for which we are running wbs_maint

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

4215: exception
4216: when no_data_found then
4217: null;
4218: IF g_debug_mode='Y' THEN
4219: Pji_Utils.write2log('WBS_Maint_Pvt: No data found for plan version');
4220: END IF;
4221: end;
4222:
4223: IF g_debug_mode='Y' THEN

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

4220: END IF;
4221: end;
4222:
4223: IF g_debug_mode='Y' THEN
4224: Pji_Utils.write2log('WBS_Maint_Pvt:' || 'Plan version Id:' || l_plan_version_id);
4225: END IF;
4226:
4227:
4228: ----------------------------------------------

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

4258: end if;
4259: EXCEPTION
4260: WHEN NO_DATA_FOUND THEN
4261: IF g_debug_mode='Y' THEN
4262: Pji_Utils.write2log( 'WBS_MAINT_PVT NO DATA FOUND coming for the project _Id:'||l_project_id,null,3);
4263: END IF;
4264: l_prg_event_id:=null;
4265: END;
4266:

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

4284: project_id = l_project_id;
4285: end if ;
4286:
4287: IF g_debug_mode='Y' THEN
4288: Pji_Utils.write2log( 'WBS_MAINT_PVT l_prg_event_id :'||l_prg_event_id||'l_struct_sharing_code'||l_struct_sharing_code ,null,3);
4289: END IF;
4290: IF l_prg_event_id is not null then
4291:
4292: --Bug 4626803: Need this for preventing doubling

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

4314:
4315: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4316: x_return_status := l_return_status;
4317: IF g_debug_mode='Y' THEN
4318: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4319: END IF;
4320: RETURN;
4321: END IF;
4322: pa_task_pub1.G_CALL_PJI_ROLLUP := 'N';

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

4345: l_chd_dev_status,
4346: l_chd_message
4347: )) then
4348:
4349: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);
4350:
4351: end if;
4352:
4353: if l_chd_dev_status ='ERROR' THEN

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

4360: p_procedure_name => 'WBS_MAINT_PVT',
4361: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4362:
4363: IF g_debug_mode='Y' THEN null;
4364: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4365: end if;
4366: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4367: l_return_status:='E';
4368: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

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

4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4374: IF g_debug_mode='Y' THEN null;
4375: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4376: end if;
4377:
4378: end if;
4379: END IF; -- Bug 5999999

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

4395: l_plan_version_id_tbl(l_plan_version_id_tbl.COUNT) := i.plan_version_id;
4396:
4397: END LOOP;
4398: IF g_debug_mode='Y' THEN
4399: Pji_Utils.write2log( 'WBS_MAINT_PVT l_plan_version_id_tbl.COUNT :'||l_plan_version_id_tbl.COUNT ,null,3);
4400: END IF;
4401: /*bug5353559*/
4402: IF (l_plan_version_id_tbl.COUNT <= 0) THEN
4403: --RETURN;

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

4421: p_prg_group2 => NULL
4422: );
4423:
4424: IF g_debug_mode='Y' THEN
4425: Pji_Utils.write2log('WBS Maint Pvt:' || 'New WBS Version ID:' || l_new_wbs_version_id);
4426: Pji_Utils.write2log('WBS Maint Pvt:' || 'Old WBS Version ID:' || l_old_wbs_version_id);
4427: end if;
4428:
4429:

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

4422: );
4423:
4424: IF g_debug_mode='Y' THEN
4425: Pji_Utils.write2log('WBS Maint Pvt:' || 'New WBS Version ID:' || l_new_wbs_version_id);
4426: Pji_Utils.write2log('WBS Maint Pvt:' || 'Old WBS Version ID:' || l_old_wbs_version_id);
4427: end if;
4428:
4429:
4430: Pji_Pjp_Sum_Rollup.set_online_context (

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

4441: Pji_Pjp_Sum_Rollup.populate_xbs_denorm_delta;
4442:
4443: Pji_Pjp_Sum_Rollup.rollup_fpr_wbs;
4444: IF g_debug_mode='Y' THEN
4445: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Pjp_Sum_Rollup.rollup_fpr_wbs',null,3);
4446: end if;
4447: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;
4448:
4449: Pji_Pjp_Sum_Rollup.update_xbs_denorm;

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

4452: p_worker_id => 1
4453: ,p_extraction_type => 'ONLINE');
4454:
4455: IF g_debug_mode='Y' THEN
4456: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);
4457: end if;
4458: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
4459:
4460:

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

4506: /* bug5353559*/
4507: /* Bug 5609109
4508: IF (l_plan_version_id_tbl.COUNT <= 0) THEN
4509: IF g_debug_mode='Y' THEN
4510: Pji_Utils.write2log(' WBS_MAINT_PVT: RETURNING as table count is Zero',null,3);
4511: end if;
4512: RETURN;
4513: end if; */
4514:

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

4512: RETURN;
4513: end if; */
4514:
4515: IF g_debug_mode='Y' THEN
4516: 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);
4517: end if;
4518: IF p_calling_Context='APPLY_PROGRESS' and p_deffered_mode='Y' THEN
4519: PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV(
4520: p_project_id => l_project_id,

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

4522: x_return_status => l_return_status,
4523: x_msg_count => l_msg_count ,
4524: x_msg_data => l_msg_data);
4525: IF g_debug_mode='Y' THEN
4526: 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);
4527: end if;
4528: END IF;
4529:
4530:

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

4556:
4557: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4558: x_return_status := l_return_status;
4559: IF g_debug_mode='Y' THEN
4560: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4561: END IF;
4562: RETURN;
4563: END IF;
4564: pa_task_pub1.G_CALL_PJI_ROLLUP := 'N';

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

4588: l_chd_dev_status,
4589: l_chd_message
4590: )) then
4591:
4592: Pji_Utils.write2log( '*********22Submitted status the l_dev_phase: '||l_chd_dev_phase||'l_dev_status'||l_chd_dev_status ,null,3);
4593:
4594: end if;
4595: if l_chd_dev_status ='ERROR' THEN
4596: l_return_status:='E';

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

4602: p_procedure_name => 'WBS_MAINT_PVT',
4603: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4604:
4605: IF g_debug_mode='Y' THEN null;
4606: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4607: end if;
4608: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4609: l_return_status:='E';
4610: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

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

4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4616: IF g_debug_mode='Y' THEN null;
4617: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4618: end if;
4619:
4620: end if;
4621: END IF ; --Bug 5999999

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

4623:
4624:
4625: x_return_status:=l_return_status;
4626: IF g_debug_mode='Y' THEN
4627: Pji_Utils.write2log( ' wbs maint pvt .. 0002 ::l_return_status'||l_return_status ,null,3);
4628: end if;
4629:
4630: EXCEPTION
4631: WHEN OTHERS THEN

Line 4671: Pji_Utils.GET_PJI_SCHEMA_NAME, -- Application name

4667: ROWNUM <= 1;
4668:
4669: l_request_id:=
4670: Fnd_Request.SUBMIT_REQUEST (
4671: Pji_Utils.GET_PJI_SCHEMA_NAME, -- Application name
4672: 'PJI_FM_SUM_CHANGE', -- concurrent program name
4673: NULL, -- description (optional)
4674: NULL, -- Start Time (optional)
4675: FALSE, -- called from another conc. request

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

4746: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
4747: ( p_package_name => g_package_name
4748: , x_return_status => x_return_status );
4749: IF g_debug_mode='Y' THEN
4750: 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);
4751: 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);
4752: end if;
4753:
4754: --Identify if the project has shared/split

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

4747: ( p_package_name => g_package_name
4748: , x_return_status => x_return_status );
4749: IF g_debug_mode='Y' THEN
4750: 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);
4751: 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);
4752: end if;
4753:
4754: --Identify if the project has shared/split
4755: --versioned/non-versioned structure

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

5134: -- IF g_deffered_mode='Y' THEN
5135: -- x_online_flag:='N';
5136: -- END IF;
5137: IF g_debug_mode='Y' THEN
5138: 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);
5139: Pji_Utils.write2log('Going out WBS_MAINT :x_return_status: '||x_return_status||'x_online_flag :'||x_online_flag ,null,3);
5140: end if;
5141: EXCEPTION
5142: WHEN OTHERS THEN

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

5135: -- x_online_flag:='N';
5136: -- END IF;
5137: IF g_debug_mode='Y' THEN
5138: 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);
5139: Pji_Utils.write2log('Going out WBS_MAINT :x_return_status: '||x_return_status||'x_online_flag :'||x_online_flag ,null,3);
5140: end if;
5141: EXCEPTION
5142: WHEN OTHERS THEN
5143: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

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

5169: l_calling_context VARCHAR2(20);
5170:
5171: BEGIN
5172: IF g_debug_mode='Y' THEN
5173: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :p_event_id '||p_event_id ||'p_calling_context'||p_calling_context ,null,3);
5174: end if;
5175: select decode(p_calling_context, 'ONLINE_PUBLISH', 'CONC_PUBLISH'
5176: , 'ONLINE_UPDATE', 'CONC_UPDATE', p_calling_context)
5177: into l_calling_context

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

5215: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5216: x_lock_mode => l_lock_mode ,
5217: x_return_status => l_return_status );
5218: IF g_debug_mode='Y' THEN
5219: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
5220: end if;
5221: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5222: UPDATE pa_proj_elem_ver_structure
5223: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'

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

5244: p_deffered_mode =>'Y',
5245: p_rerun_flag => p_rerun_flag,
5246: x_return_status => l_return_status );
5247: IF g_debug_mode='Y' THEN
5248: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
5249: end if;
5250: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5251:
5252: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN

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

5284: END IF;
5285:
5286: ELSIF l_lock_mode = 'F' THEN
5287: IF g_debug_mode='Y' THEN
5288: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :Not able to take the lock showing the warning' ,null,4);
5289: end if;
5290: retcode := 1; --Unable to acquire lock and hence complete request as warning
5291:
5292: END IF;

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

5304: p_conc_request_id => Fnd_Global.CONC_REQUEST_ID,
5305: x_return_status => l_return_status );
5306: END IF;
5307: IF g_debug_mode='Y' THEN
5308: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES : COMING to the exception' ,null,5);
5309: end if;
5310: retcode := 2;
5311: errbuf := SQLERRM;
5312: END;

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

5835: end if;
5836:
5837: IF g_debug_mode='Y' THEN
5838: -- 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);
5839: Pji_Utils.write2log('maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||
5840: 'p_rbs_version_id'||p_rbs_version_id||'p_prg_rollup_flag'||p_prg_rollup_flag,null,3);
5841: end if;
5842: IF (l_rbs_version_id_tbl.COUNT=0) THEN
5843: Pji_Utils.write2log('p_rbs_version_id is NULL. Nothing to rollup by. Returning.',null,3);

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

5839: Pji_Utils.write2log('maintain smart slice .. 0001 :p_wbs_version_id'||p_wbs_version_id ||
5840: 'p_rbs_version_id'||p_rbs_version_id||'p_prg_rollup_flag'||p_prg_rollup_flag,null,3);
5841: end if;
5842: IF (l_rbs_version_id_tbl.COUNT=0) THEN
5843: Pji_Utils.write2log('p_rbs_version_id is NULL. Nothing to rollup by. Returning.',null,3);
5844: RETURN;
5845: END IF;
5846:
5847: BEGIN

Line 5980: Pji_Utils.write2log(' maintain smart slice .. NEW MODEL END ' ,null,3);

5976: COMMIT;
5977: END IF;
5978:
5979: IF g_debug_mode='Y' THEN
5980: Pji_Utils.write2log(' maintain smart slice .. NEW MODEL END ' ,null,3);
5981: end if;
5982:
5983: return ; -- NO NEED TO EXECUTE THE BELOW CODE
5984:

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

6078:
6079: l_prg_project_id_tbl.EXTEND;
6080: l_prg_project_id_tbl(l_prg_count) := l_project_id;
6081: IF g_debug_mode='Y' THEN
6082: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||
6083: l_prg_plan_version_id_tbl(l_prg_count)||'l_prg_wbs_version_id_tbl'||l_prg_wbs_version_id_tbl(l_prg_count)||
6084: 'l_prg_project_id_tbl'||l_prg_project_id_tbl(l_prg_count) ,null,3);
6085: end if;
6086: l_prg_count := l_prg_count + 1;

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

6098:
6099: l_prg_project_id_tbl.EXTEND;
6100: l_prg_project_id_tbl(l_prg_count) := il_project_id_tbl(i);
6101: IF g_debug_mode='Y' THEN
6102: Pji_Utils.write2log(' maintain smart slice11: '||l_prg_count||':l_prg_plan_version_id_tbl'||
6103: l_prg_plan_version_id_tbl(l_prg_count)||'l_prg_wbs_version_id_tbl'||l_prg_wbs_version_id_tbl(l_prg_count)||
6104: 'l_prg_project_id_tbl'||l_prg_project_id_tbl(l_prg_count) ,null,3);
6105: end if;
6106: l_prg_count := l_prg_count + 1;

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

6127: WHEN NO_DATA_FOUND THEN
6128: NULL;
6129: END;
6130: IF g_debug_mode='Y' THEN
6131: Pji_Utils.write2log(' maintain smart slice ..1.2 p_plan_version_id_tbl ('||i||') : ' || l_prg_plan_version_id_tbl(i) ,null,3);
6132: Pji_Utils.write2log(' maintain smart slice ..1.3 l_exists :' || l_exists ,null,3);
6133: end if;
6134:
6135: --If smart slice does not exist create the same

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

6128: NULL;
6129: END;
6130: IF g_debug_mode='Y' THEN
6131: Pji_Utils.write2log(' maintain smart slice ..1.2 p_plan_version_id_tbl ('||i||') : ' || l_prg_plan_version_id_tbl(i) ,null,3);
6132: Pji_Utils.write2log(' maintain smart slice ..1.3 l_exists :' || l_exists ,null,3);
6133: end if;
6134:
6135: --If smart slice does not exist create the same
6136: IF ( l_exists = 'N' ) THEN

Line 6146: 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'

6142: l_project_id_tbl(l_count) := l_prg_project_id_tbl(i);
6143: l_wbs_version_id_tbl.EXTEND;
6144: l_wbs_version_id_tbl(l_count) := l_prg_wbs_version_id_tbl(i);
6145: IF g_debug_mode='Y' THEN
6146: 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'
6147: ||l_wbs_version_id_tbl(l_count)||'l_project_id_tbl'||l_project_id_tbl(l_count) ,null,3);
6148: end if;
6149: l_count := l_count + 1;
6150:

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

6218: p_fp_version_ids => l_plan_version_id_tbl
6219: , p_slice_type => 'PRI'
6220: );
6221: IF g_debug_mode='Y' THEN
6222: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);
6223: end if;
6224:
6225: IF g_debug_mode='Y' THEN
6226: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||

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

6222: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);
6223: end if;
6224:
6225: IF g_debug_mode='Y' THEN
6226: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||
6227: '::l_roll_wbs_version_id_tbl.COUNT: '||l_roll_wbs_version_id_tbl.COUNT ,null,3);
6228: end if;
6229: --Inserting 'L' 'N' 'N' / 'L' 'N' 'Y' slices
6230: FOR k IN 1..l_rbs_version_id_tbl.COUNT LOOP

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

6401: head.PLAN_TYPE_CODE = l_plan_type_code_tbl(j) ;
6402: END LOOP;/* end of RBS loop*/
6403:
6404: IF g_debug_mode='Y' THEN
6405: Pji_Utils.write2log(' Inserted L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);
6406: end if;
6407:
6408: --WBS rollup for LNN / LNY slices
6409: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT

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

6595: fact.PLAN_TYPE_CODE; /*4471527 */
6596:
6597:
6598: IF g_debug_mode='Y' THEN
6599: Pji_Utils.write2log(' Inserted WBS rollup L N N / L N Y slices ' || SQL%ROWCOUNT ,null,3);
6600: end if;
6601:
6602: --XBS Rollup for WBS slice
6603: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT

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

6791:
6792:
6793:
6794: IF g_debug_mode='Y' THEN
6795: Pji_Utils.write2log(' Inserted XBS rollup for WBS slices ' || SQL%ROWCOUNT ,null,3);
6796: end if;
6797: --RBS Rollup for all slices
6798: FORALL j IN 1..l_rbs_version_id_tbl.COUNT
6799: INSERT INTO pji_fp_aggr_pjp1_t (

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

6970: fact.PLAN_TYPE_ID,
6971: fact.PLAN_TYPE_CODE;
6972:
6973: IF g_debug_mode='Y' THEN
6974: Pji_Utils.write2log(' Inserted RBS rollup for all slices ' || SQL%ROWCOUNT ,null,3);
6975: end if;
6976:
6977: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
6978:

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

6980: COMMIT;
6981: END IF;
6982:
6983: IF g_debug_mode='Y' THEN
6984: Pji_Utils.write2log(' maintain smart slice .. 0003 ' ,null,3);
6985: end if;
6986:
6987: EXCEPTION
6988: WHEN Invalid_Excep THEN