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.25.12010000.5 2009/01/07 14:21:38 rmandali 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 623: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '

619: p_app_short_name=>'PJI',
620: p_msg_name=> 'PJI_REP_GENERIC_MSG',
621: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,
622: p_token1=>'PROC_NAME',
623: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '
624: ||l_sql_errm
625: );
626: WHEN OTHERS THEN
627: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

630: p_app_short_name=>'PJI',
631: p_msg_name=> 'PJI_REP_GENERIC_MSG',
632: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,
633: p_token1=>'PROC_NAME',
634: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; SQL Error: '
635: ||l_sql_errm
636: );
637: END;
638: END LOOP;

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

713: p_app_short_name=> 'PJI',
714: p_msg_name=> 'PJI_REP_GENERIC_MSG',
715: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
716: p_token1=>'PROC_NAME',
717: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||
718: 'SQL Error: ' || l_sql_errm
719: );
720:
721: END;

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

898: p_app_short_name=> 'PJI',
899: p_msg_name=> 'PJI_REP_GENERIC_MSG',
900: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
901: p_token1=>'PROC_NAME',
902: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Financial_Measures; ' ||
903: 'SQL Error: ' || l_sql_errm
904: );
905:
906: END;

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

1183: p_app_short_name=>'PJI',
1184: p_msg_name=>'PJI_REP_GENERIC_MSG',
1185: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1186: p_token1=>'PROC_NAME',
1187: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1188: 'SQL Error during Cost Forecast query : ' || l_sql_errm
1189: );
1190:
1191: END;

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

1224: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1225: p_msg_name=>'PJI_REP_GENERIC_MSG',
1226: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1227: p_token1=>'PROC_NAME',
1228: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1229: 'SQL Error during Cost Budget query: ' || l_sql_errm
1230: );
1231: END;
1232:

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

1265: p_app_short_name=>'PJI',
1266: p_msg_name=>'PJI_REP_GENERIC_MSG',
1267: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1268: p_token1=>'PROC_NAME',
1269: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: '||
1270: 'SQL Error during Cost Budget 2 query: ' || l_sql_errm
1271: );
1272: END;
1273:

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

1306: p_app_short_name=>'PJI',
1307: p_msg_name=>'PJI_REP_GENERIC_MSG',
1308: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1309: p_token1=>'PROC_NAME',
1310: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1311: 'SQL Error during Revenue Forecast query: '|| l_sql_errm
1312: );
1313: END;
1314:

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

1346: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1347: p_msg_name=>'PJI_REP_GENERIC_MSG',
1348: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1349: p_token1=>'PROC_NAME',
1350: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1351: 'SQL Error during Revenue Budget query: ' || l_sql_errm
1352: );
1353: END;
1354:

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

1386: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
1387: p_msg_name=>'PJI_REP_GENERIC_MSG',
1388: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1389: p_token1=>'PROC_NAME',
1390: p_token1_value=>'PJI_REP_MEASURE_UTIL.get_plan_type_info: ' ||
1391: 'SQL Error during Revenue Budget 2 query: ' || l_sql_errm
1392: );
1393: END;
1394:

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

1547: p_app_short_name=>'PJI',
1548: p_msg_name=>'PJI_REP_GENERIC_MSG',
1549: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
1550: p_token1=>'PROC_NAME',
1551: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL_Error: ' || l_sql_errm
1552: );
1553:
1554: END;
1555:

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

1866: NULL;
1867:
1868: IF g_debug_mode = 'Y' THEN
1869: Pji_Utils.WRITE2LOG(
1870: 'PJI_REP_MEASURE_UTIL.retrieveData: beginning execution....',
1871: TRUE, g_msg_level_proc_call
1872: );
1873: END IF;
1874: --

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

2475: WHEN NO_DATA_FOUND THEN
2476: -- in case no data is found, we still can go on and return empty arrays
2477: IF g_debug_mode = 'Y' THEN
2478: Pji_Utils.WRITE2LOG(
2479: 'PJI_REP_MEASURE_UTIL.retrieveData: NO_DATA_FOUND on reporting lines SQL query.',
2480: TRUE, g_msg_level_low_detail
2481: );
2482: END IF;
2483: WHEN OTHERS THEN

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

2486: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
2487: p_msg_name=>'PJI_REP_GENERIC_MSG',
2488: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
2489: p_token1=>'PROC_NAME',
2490: p_token1_value=>'PJI_REP_MEASURE_UTIL; Reporting lines facts query SQL Error: ' || l_sql_errm);
2491:
2492: END;
2493:
2494:

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

2670: --
2671:
2672: IF g_debug_mode = 'Y' THEN
2673: Pji_Utils.WRITE2LOG(
2674: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||
2675: '; plan versions info: l_actual_index= ' || l_actual_index ||
2676: '; l_cost_forecast_index= ' || l_cost_forecast_index ||
2677: '; l_cost_budget_index= ' || l_cost_budget_index ||
2678: '; l_cost_budget2_index= ' || l_cost_budget2_index ||

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

3097: p_app_short_name=>'PJI',
3098: p_msg_name=> 'PJI_REP_GENERIC_MSG',
3099: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
3100: p_token1=>'PROC_NAME',
3101: p_token1_value=>'PJI_REP_MEASURE_UTIL; activity facts query SQL Error: ' || l_sql_errm);
3102: END;
3103:
3104: --
3105: -- need to consider the rollup element

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

4146: WHEN OTHERS THEN
4147: l_sql_errm := SQLERRM();
4148: IF g_debug_mode = 'Y' THEN
4149: Pji_Utils.WRITE2LOG(
4150: 'PJI_REP_MEASURE_UTIL.retrieveData: project_id= ' || pProjectId ||
4151: '; error during bulk collect on l_cus_meas_formats collection: '|| l_sql_errm,
4152: TRUE, g_msg_level_runtime_info
4153: );
4154: END IF;

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

9443: p_app_short_name=>'PJI',
9444: p_msg_name=> 'PJI_REP_GENERIC_MSG',
9445: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,
9446: p_token1=>'PROC_NAME',
9447: p_token1_value=>'PJI_REP_MEASURE_UTIL; SQL Error during computation '||
9448: 'of measure '||p_measure_set_code(i)||' : '|| l_sql_errm
9449: );
9450:
9451: END;

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

9633: END LOOP;
9634:
9635: IF g_debug_mode = 'Y' THEN
9636: Pji_Utils.WRITE2LOG(
9637: 'PJI_REP_MEASURE_UTIL.retrieveData: reached end.',
9638: TRUE, g_msg_level_proc_call
9639: );
9640: END IF;
9641:

Line 10046: END Pji_Rep_Measure_Util;

10042: g_RevFcstRevPriorfcst := g_RevFcst_is_present + g_RevPriorfcst_is_present;
10043: g_CstFcstCstPriorfcst := g_CstFcst_is_present + g_CstPriorfcst_is_present;
10044: g_Cst_FcstPriorfcst := g_CstBudget_is_present + g_CstPriorfcst_is_present;
10045:
10046: END Pji_Rep_Measure_Util;