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_REP_MEASURE_UTIL dependencies on PJI_REP_MEASURE_UTIL

Line 1: PACKAGE BODY Pji_Rep_Measure_Util AS

1: PACKAGE BODY Pji_Rep_Measure_Util AS
2: /* $Header: PJIRX15B.pls 120.38.12020000.2 2012/07/18 10:56:32 admarath ship $ */
3:
4: /**
5: ** constants for logging

Line 186: 'PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions: beginning execution....',

182: NULL;
183:
184: IF g_debug_mode = 'Y' THEN
185: Pji_Utils.WRITE2LOG(
186: 'PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions: beginning execution....',
187: TRUE, g_msg_level_proc_call
188: );
189: END IF;
190: l_msg_count := 0;

Line 231: 'PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions: l_project_ids_tbl.LAST ' ||

227: END IF;
228:
229: IF g_debug_mode = 'Y' THEN
230: Pji_Utils.WRITE2LOG(
231: 'PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions: l_project_ids_tbl.LAST ' ||
232: '(collected from table PA_PERF_TEMP_OBJ_MEASURE) = ' || l_project_ids_tbl.LAST,
233: TRUE, g_msg_level_runtime_info
234: );
235: END IF;

Line 239: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'l_project_ids_tbl.LAST='||TO_CHAR(x),SYSDATE);

235: END IF;
236:
237:
238: --x := l_project_ids_tbl.LAST;
239: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'l_project_ids_tbl.LAST='||TO_CHAR(x),SYSDATE);
240:
241:
242:
243: --

Line 249: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', project_id= '||TO_CHAR(l_project_ids_tbl(i)),SYSDATE);

245: -- and compute its excp
246: --
247: FOR i IN 1..l_project_ids_tbl.LAST LOOP
248:
249: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', project_id= '||TO_CHAR(l_project_ids_tbl(i)),SYSDATE);
250: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', calendar_type= '||l_calendar_type_tbl(i),SYSDATE);
251: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', currency type= '||l_currency_type_tbl(i),SYSDATE);
252:
253:

Line 250: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', calendar_type= '||l_calendar_type_tbl(i),SYSDATE);

246: --
247: FOR i IN 1..l_project_ids_tbl.LAST LOOP
248:
249: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', project_id= '||TO_CHAR(l_project_ids_tbl(i)),SYSDATE);
250: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', calendar_type= '||l_calendar_type_tbl(i),SYSDATE);
251: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', currency type= '||l_currency_type_tbl(i),SYSDATE);
252:
253:
254: --

Line 251: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', currency type= '||l_currency_type_tbl(i),SYSDATE);

247: FOR i IN 1..l_project_ids_tbl.LAST LOOP
248:
249: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', project_id= '||TO_CHAR(l_project_ids_tbl(i)),SYSDATE);
250: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', calendar_type= '||l_calendar_type_tbl(i),SYSDATE);
251: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', currency type= '||l_currency_type_tbl(i),SYSDATE);
252:
253:
254: --
255: -- first obtain the measures and the measures_sets that we'll compute in

Line 316: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_calendar_id = ' || TO_CHAR(l_calendar_id),SYSDATE);

312: , x_msg_data => x_msg_data
313: );
314:
315:
316: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_calendar_id = ' || TO_CHAR(l_calendar_id),SYSDATE);
317: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_org_id = ' || TO_CHAR(l_org_id),SYSDATE);
318: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_period_name = ' || l_period_name,SYSDATE);
319: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_report_date_julian = ' || l_report_date_julian,SYSDATE);
320:

Line 317: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_org_id = ' || TO_CHAR(l_org_id),SYSDATE);

313: );
314:
315:
316: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_calendar_id = ' || TO_CHAR(l_calendar_id),SYSDATE);
317: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_org_id = ' || TO_CHAR(l_org_id),SYSDATE);
318: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_period_name = ' || l_period_name,SYSDATE);
319: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_report_date_julian = ' || l_report_date_julian,SYSDATE);
320:
321:

Line 318: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_period_name = ' || l_period_name,SYSDATE);

314:
315:
316: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_calendar_id = ' || TO_CHAR(l_calendar_id),SYSDATE);
317: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_org_id = ' || TO_CHAR(l_org_id),SYSDATE);
318: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_period_name = ' || l_period_name,SYSDATE);
319: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_report_date_julian = ' || l_report_date_julian,SYSDATE);
320:
321:
322:

Line 319: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_report_date_julian = ' || l_report_date_julian,SYSDATE);

315:
316: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_calendar_id = ' || TO_CHAR(l_calendar_id),SYSDATE);
317: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_org_id = ' || TO_CHAR(l_org_id),SYSDATE);
318: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_period_name = ' || l_period_name,SYSDATE);
319: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_report_date_julian = ' || l_report_date_julian,SYSDATE);
320:
321:
322:
323: --

Line 362: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_currency_type_msg_name = ' || l_currency_type_msg_name,SYSDATE);

358: END;
359: END IF;
360:
361:
362: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions', 'i='||i||', l_currency_type_msg_name = ' || l_currency_type_msg_name,SYSDATE);
363:
364:
365: --
366: -- derive other default values parameters except calendar_type

Line 440: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

436: l_revforecast_plantype_id, l_revbudget_plantype_id, l_revbudget2_plantype_id,
437: l_Return_Status, l_Msg_Count, l_Msg_Data);
438:
439:
440: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
441: -- 'i='||i||', l_WBS_Element_Id = ' || TO_CHAR(l_WBS_Element_Id),SYSDATE);
442: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
443: -- 'i='||i||', l_cstbudget_version_id = ' || TO_CHAR(l_cstbudget_version_id),SYSDATE);
444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 442: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

438:
439:
440: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
441: -- 'i='||i||', l_WBS_Element_Id = ' || TO_CHAR(l_WBS_Element_Id),SYSDATE);
442: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
443: -- 'i='||i||', l_cstbudget_version_id = ' || TO_CHAR(l_cstbudget_version_id),SYSDATE);
444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
445: -- 'i='||i||', l_cstforecast_version_id = ' || TO_CHAR(l_cstforecast_version_id),SYSDATE);
446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

440: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
441: -- 'i='||i||', l_WBS_Element_Id = ' || TO_CHAR(l_WBS_Element_Id),SYSDATE);
442: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
443: -- 'i='||i||', l_cstbudget_version_id = ' || TO_CHAR(l_cstbudget_version_id),SYSDATE);
444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
445: -- 'i='||i||', l_cstforecast_version_id = ' || TO_CHAR(l_cstforecast_version_id),SYSDATE);
446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
447: -- 'i='||i||', l_revbudget_version_id = ' || TO_CHAR(l_revbudget_version_id),SYSDATE);
448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

442: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
443: -- 'i='||i||', l_cstbudget_version_id = ' || TO_CHAR(l_cstbudget_version_id),SYSDATE);
444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
445: -- 'i='||i||', l_cstforecast_version_id = ' || TO_CHAR(l_cstforecast_version_id),SYSDATE);
446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
447: -- 'i='||i||', l_revbudget_version_id = ' || TO_CHAR(l_revbudget_version_id),SYSDATE);
448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
449: -- 'i='||i||', l_revforecast_version_id = ' || TO_CHAR(l_revforecast_version_id),SYSDATE);
450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

444: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
445: -- 'i='||i||', l_cstforecast_version_id = ' || TO_CHAR(l_cstforecast_version_id),SYSDATE);
446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
447: -- 'i='||i||', l_revbudget_version_id = ' || TO_CHAR(l_revbudget_version_id),SYSDATE);
448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
449: -- 'i='||i||', l_revforecast_version_id = ' || TO_CHAR(l_revforecast_version_id),SYSDATE);
450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
451: -- 'i='||i||', l_cstbudget_plantype_id = ' || TO_CHAR(l_cstbudget_plantype_id),SYSDATE);
452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

446: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
447: -- 'i='||i||', l_revbudget_version_id = ' || TO_CHAR(l_revbudget_version_id),SYSDATE);
448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
449: -- 'i='||i||', l_revforecast_version_id = ' || TO_CHAR(l_revforecast_version_id),SYSDATE);
450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
451: -- 'i='||i||', l_cstbudget_plantype_id = ' || TO_CHAR(l_cstbudget_plantype_id),SYSDATE);
452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
453: -- 'i='||i||', l_cstforecast_plantype_id = ' || TO_CHAR(l_cstforecast_plantype_id),SYSDATE);
454: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

448: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
449: -- 'i='||i||', l_revforecast_version_id = ' || TO_CHAR(l_revforecast_version_id),SYSDATE);
450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
451: -- 'i='||i||', l_cstbudget_plantype_id = ' || TO_CHAR(l_cstbudget_plantype_id),SYSDATE);
452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
453: -- 'i='||i||', l_cstforecast_plantype_id = ' || TO_CHAR(l_cstforecast_plantype_id),SYSDATE);
454: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
455: -- 'i='||i||', l_revbudget_plantype_id = ' || TO_CHAR(l_revbudget_plantype_id),SYSDATE);
456: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

Line 454: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

450: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
451: -- 'i='||i||', l_cstbudget_plantype_id = ' || TO_CHAR(l_cstbudget_plantype_id),SYSDATE);
452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
453: -- 'i='||i||', l_cstforecast_plantype_id = ' || TO_CHAR(l_cstforecast_plantype_id),SYSDATE);
454: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
455: -- 'i='||i||', l_revbudget_plantype_id = ' || TO_CHAR(l_revbudget_plantype_id),SYSDATE);
456: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
457: -- 'i='||i||', l_revforecast_plantype_id = ' || TO_CHAR(l_revforecast_plantype_id),SYSDATE);
458:

Line 456: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',

452: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
453: -- 'i='||i||', l_cstforecast_plantype_id = ' || TO_CHAR(l_cstforecast_plantype_id),SYSDATE);
454: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
455: -- 'i='||i||', l_revbudget_plantype_id = ' || TO_CHAR(l_revbudget_plantype_id),SYSDATE);
456: --INSERT INTO pji_rep_debug_msg VALUES('PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions',
457: -- 'i='||i||', l_revforecast_plantype_id = ' || TO_CHAR(l_revforecast_plantype_id),SYSDATE);
458:
459:
460: -- retrieve data related to the wanted measures sets, using default parameters

Line 630: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '

626: p_app_short_name=>'PJI',
627: p_msg_name=> 'PJI_REP_GENERIC_MSG',
628: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,
629: p_token1=>'PROC_NAME',
630: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '
631: ||l_sql_errm
632: );
633: WHEN OTHERS THEN
634: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 641: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; SQL Error: '

637: p_app_short_name=>'PJI',
638: p_msg_name=> 'PJI_REP_GENERIC_MSG',
639: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,
640: p_token1=>'PROC_NAME',
641: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; SQL Error: '
642: ||l_sql_errm
643: );
644: END;
645: END LOOP;

Line 724: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||

720: p_app_short_name=> 'PJI',
721: p_msg_name=> 'PJI_REP_GENERIC_MSG',
722: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
723: p_token1=>'PROC_NAME',
724: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||
725: 'SQL Error: ' || l_sql_errm
726: );
727:
728: END;

Line 909: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||

905: p_app_short_name=> 'PJI',
906: p_msg_name=> 'PJI_REP_GENERIC_MSG',
907: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
908: p_token1=>'PROC_NAME',
909: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||
910: 'SQL Error: ' || l_sql_errm
911: );
912:
913: END;

Line 1194: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||

1190: p_app_short_name=>'PJI',
1191: p_msg_name=>'PJI_REP_GENERIC_MSG',
1192: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1193: p_token1=>'PROC_NAME',
1194: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1195: 'SQL Error during Cost Forecast query : ' || l_sql_errm
1196: );
1197:
1198: END;

Line 1235: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||

1231: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1232: p_msg_name=>'PJI_REP_GENERIC_MSG',
1233: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1234: p_token1=>'PROC_NAME',
1235: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1236: 'SQL Error during Cost Budget query: ' || l_sql_errm
1237: );
1238: END;
1239:

Line 1276: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: '||

1272: p_app_short_name=>'PJI',
1273: p_msg_name=>'PJI_REP_GENERIC_MSG',
1274: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1275: p_token1=>'PROC_NAME',
1276: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: '||
1277: 'SQL Error during Cost Budget 2 query: ' || l_sql_errm
1278: );
1279: END;
1280:

Line 1317: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||

1313: p_app_short_name=>'PJI',
1314: p_msg_name=>'PJI_REP_GENERIC_MSG',
1315: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1316: p_token1=>'PROC_NAME',
1317: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1318: 'SQL Error during Revenue Forecast query: '|| l_sql_errm
1319: );
1320: END;
1321:

Line 1357: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||

1353: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1354: p_msg_name=>'PJI_REP_GENERIC_MSG',
1355: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1356: p_token1=>'PROC_NAME',
1357: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1358: 'SQL Error during Revenue Budget query: ' || l_sql_errm
1359: );
1360: END;
1361:

Line 1397: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||

1393: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1394: p_msg_name=>'PJI_REP_GENERIC_MSG',
1395: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1396: p_token1=>'PROC_NAME',
1397: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1398: 'SQL Error during Revenue Budget 2 query: ' || l_sql_errm
1399: );
1400: END;
1401:

Line 1558: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL_Error: ' || l_sql_errm

1554: p_app_short_name=>'PJI',
1555: p_msg_name=>'PJI_REP_GENERIC_MSG',
1556: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1557: p_token1=>'PROC_NAME',
1558: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL_Error: ' || l_sql_errm
1559: );
1560:
1561: END;
1562:

Line 1877: 'PJI_REP_MEASURE_UTIL.retrieveData: beginning execution....',

1873: NULL;
1874:
1875: IF g_debug_mode = 'Y' THEN
1876: Pji_Utils.WRITE2LOG(
1877: 'PJI_REP_MEASURE_UTIL.retrieveData: beginning execution....',
1878: TRUE, g_msg_level_proc_call
1879: );
1880: END IF;
1881: --

Line 2486: 'PJI_REP_MEASURE_UTIL.retrieveData: NO_DATA_FOUND on reporting lines SQL query.',

2482: WHEN NO_DATA_FOUND THEN
2483: -- in case no data is found, we still can go on and return empty arrays
2484: IF g_debug_mode = 'Y' THEN
2485: Pji_Utils.WRITE2LOG(
2486: 'PJI_REP_MEASURE_UTIL.retrieveData: NO_DATA_FOUND on reporting lines SQL query.',
2487: TRUE, g_msg_level_low_detail
2488: );
2489: END IF;
2490: WHEN OTHERS THEN

Line 2497: p_token1_value=>'PJI_REP_MEASURE_UTIL; Reporting lines facts query SQL Error: ' || l_sql_errm);

2493: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
2494: p_msg_name=>'PJI_REP_GENERIC_MSG',
2495: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
2496: p_token1=>'PROC_NAME',
2497: p_token1_value=>'PJI_REP_MEASURE_UTIL; Reporting lines facts query SQL Error: ' || l_sql_errm);
2498:
2499: END;
2500:
2501:

Line 2681: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||

2677: --
2678:
2679: IF g_debug_mode = 'Y' THEN
2680: Pji_Utils.WRITE2LOG(
2681: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||
2682: '; plan versions info: l_actual_index= ' || l_actual_index ||
2683: '; l_cost_forecast_index= ' || l_cost_forecast_index ||
2684: '; l_cost_budget_index= ' || l_cost_budget_index ||
2685: '; l_cost_budget2_index= ' || l_cost_budget2_index ||

Line 3108: p_token1_value=>'PJI_REP_MEASURE_UTIL; activity facts query SQL Error: ' || l_sql_errm);

3104: p_app_short_name=>'PJI',
3105: p_msg_name=> 'PJI_REP_GENERIC_MSG',
3106: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
3107: p_token1=>'PROC_NAME',
3108: p_token1_value=>'PJI_REP_MEASURE_UTIL; activity facts query SQL Error: ' || l_sql_errm);
3109: END;
3110:
3111: --
3112: -- need to consider the rollup element

Line 4169: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||

4165: WHEN OTHERS THEN
4166: l_sql_errm := SQLERRM();
4167: IF g_debug_mode = 'Y' THEN
4168: Pji_Utils.WRITE2LOG(
4169: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||
4170: '; error during bulk collect on l_cus_meas_formats collection: '|| l_sql_errm,
4171: TRUE, g_msg_level_runtime_info
4172: );
4173: END IF;

Line 9468: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL Error during computation '||

9464: p_app_short_name=>'PJI',
9465: p_msg_name=> 'PJI_REP_GENERIC_MSG',
9466: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
9467: p_token1=>'PROC_NAME',
9468: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL Error during computation '||
9469: 'of measure '||p_measure_set_code(i)||' : '|| l_sql_errm
9470: );
9471:
9472: END;

Line 9658: 'PJI_REP_MEASURE_UTIL.retrieveData: reached end.',

9654: END LOOP;
9655:
9656: IF g_debug_mode = 'Y' THEN
9657: Pji_Utils.WRITE2LOG(
9658: 'PJI_REP_MEASURE_UTIL.retrieveData: reached end.',
9659: TRUE, g_msg_level_proc_call
9660: );
9661: END IF;
9662:

Line 10520: END Pji_Rep_Measure_Util;

10516: g_RevFcstRevPriorfcst := g_RevFcst_is_present + g_RevPriorfcst_is_present;
10517: g_CstFcstCstPriorfcst := g_CstFcst_is_present + g_CstPriorfcst_is_present;
10518: g_Cst_FcstPriorfcst := g_CstBudget_is_present + g_CstPriorfcst_is_present;
10519:
10520: END Pji_Rep_Measure_Util;