DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_UTILS

Line 185: Pji_Utils.WRITE2LOG(

181:
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;

Line 230: Pji_Utils.WRITE2LOG(

226: RETURN;
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: );

Line 330: l_Currency_Code := Pji_Utils.get_global_primary_currency;

326:
327: IF l_currency_type_tbl(i) = 'G' THEN
328: l_currency_type_msg_name := 'PJI_REP_GLOBAL_CURRENCY';
329: l_currency_record_type := 1;
330: l_Currency_Code := Pji_Utils.get_global_primary_currency;
331: ELSIF l_currency_type_tbl(i) = 'G2' THEN
332: l_currency_type_msg_name := 'PJI_REP_GLOBAL2_CURRENCY';
333: l_currency_record_type := 2;
334: l_Currency_Code := Pji_Utils.get_global_secondary_currency;

Line 334: l_Currency_Code := Pji_Utils.get_global_secondary_currency;

330: l_Currency_Code := Pji_Utils.get_global_primary_currency;
331: ELSIF l_currency_type_tbl(i) = 'G2' THEN
332: l_currency_type_msg_name := 'PJI_REP_GLOBAL2_CURRENCY';
333: l_currency_record_type := 2;
334: l_Currency_Code := Pji_Utils.get_global_secondary_currency;
335: ELSIF l_currency_type_tbl(i) = 'F' THEN
336: l_currency_type_msg_name := 'PJI_REP_PROJ_FUNC_CURRENCY';
337: l_currency_record_type := 4;
338: BEGIN

Line 658: Pji_Utils.WRITE2LOG('entering get_financial_measures',TRUE, g_msg_level_runtime_info);

654: l_sql_errm VARCHAR2(255);
655:
656: BEGIN
657: IF g_debug_mode = 'Y' THEN
658: Pji_Utils.WRITE2LOG('entering get_financial_measures',TRUE, g_msg_level_runtime_info);
659: END IF;
660:
661: IF x_return_status IS NULL THEN
662: x_msg_count := 0;

Line 726: Pji_Utils.WRITE2LOG('leaving get_measure_attributes',TRUE, g_msg_level_runtime_info);

722:
723: END LOOP;
724:
725: IF g_debug_mode = 'Y' THEN
726: Pji_Utils.WRITE2LOG('leaving get_measure_attributes',TRUE, g_msg_level_runtime_info);
727: END IF;
728:
729: END Get_Measure_Attributes;
730:

Line 834: Pji_Utils.WRITE2LOG('entering get_measure_attributes',TRUE, g_msg_level_runtime_info);

830: BEGIN
831: NULL;
832:
833: IF g_debug_mode = 'Y' THEN
834: Pji_Utils.WRITE2LOG('entering get_measure_attributes',TRUE, g_msg_level_runtime_info);
835: END IF;
836:
837: x_msg_count := 0;
838: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1061: Pji_Utils.WRITE2LOG('leaving get_financial_measures',TRUE, g_msg_level_runtime_info);

1057: x_return_status := l_return_status;
1058: END IF;
1059:
1060: IF g_debug_mode = 'Y' THEN
1061: Pji_Utils.WRITE2LOG('leaving get_financial_measures',TRUE, g_msg_level_runtime_info);
1062: END IF;
1063:
1064: END Get_Financial_Measures;
1065:

Line 1496: Pji_Utils.WRITE2LOG('entering preparedata',TRUE, g_msg_level_runtime_info);

1492: BEGIN
1493: NULL;
1494:
1495: IF g_debug_mode = 'Y' THEN
1496: Pji_Utils.WRITE2LOG('entering preparedata',TRUE, g_msg_level_runtime_info);
1497: END IF;
1498:
1499:
1500: --

Line 1611: Pji_Utils.WRITE2LOG('leaving preparedata',TRUE, g_msg_level_runtime_info);

1607: x_ptd_meaning(i), x_qtd_meaning(i), x_ytd_meaning(i), x_itd_meaning(i), x_ac_meaning(i), x_prp_meaning(i)
1608: );
1609:
1610: IF g_debug_mode = 'Y' THEN
1611: Pji_Utils.WRITE2LOG('leaving preparedata',TRUE, g_msg_level_runtime_info);
1612: END IF;
1613:
1614: COMMIT;
1615:

Line 1869: Pji_Utils.WRITE2LOG(

1865:
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;

Line 2478: Pji_Utils.WRITE2LOG(

2474:
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;

Line 2673: Pji_Utils.WRITE2LOG(

2669: -- to leave the first cell empty to use when there isn't an available plan type
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 ||

Line 3348: Pji_Utils.WRITE2LOG('before calling exception API',TRUE, g_msg_level_runtime_info);

3344: -- calculate measure color indicators
3345: --
3346:
3347: IF g_debug_mode = 'Y' THEN
3348: Pji_Utils.WRITE2LOG('before calling exception API',TRUE, g_msg_level_runtime_info);
3349: END IF;
3350:
3351:
3352: IF g_debug_mode = 'Y' THEN

Line 3353: Pji_Utils.WRITE2LOG('after calling exception API',TRUE, g_msg_level_runtime_info);

3349: END IF;
3350:
3351:
3352: IF g_debug_mode = 'Y' THEN
3353: Pji_Utils.WRITE2LOG('after calling exception API',TRUE, g_msg_level_runtime_info);
3354: END IF;
3355:
3356: --
3357: -- the Pa_Perf_Excp_Utils.get_measure_indicator_list could return a NULL

Line 4149: Pji_Utils.WRITE2LOG(

4145: EXCEPTION
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: );

Line 9636: Pji_Utils.WRITE2LOG(

9632:
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;