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 665: Pji_Utils.WRITE2LOG('entering get_financial_measures',TRUE, g_msg_level_runtime_info);

661: l_sql_errm VARCHAR2(255);
662:
663: BEGIN
664: IF g_debug_mode = 'Y' THEN
665: Pji_Utils.WRITE2LOG('entering get_financial_measures',TRUE, g_msg_level_runtime_info);
666: END IF;
667:
668: IF x_return_status IS NULL THEN
669: x_msg_count := 0;

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

729:
730: END LOOP;
731:
732: IF g_debug_mode = 'Y' THEN
733: Pji_Utils.WRITE2LOG('leaving get_measure_attributes',TRUE, g_msg_level_runtime_info);
734: END IF;
735:
736: END Get_Measure_Attributes;
737:

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

837: BEGIN
838: NULL;
839:
840: IF g_debug_mode = 'Y' THEN
841: Pji_Utils.WRITE2LOG('entering get_measure_attributes',TRUE, g_msg_level_runtime_info);
842: END IF;
843:
844: x_msg_count := 0;
845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

1064: x_return_status := l_return_status;
1065: END IF;
1066:
1067: IF g_debug_mode = 'Y' THEN
1068: Pji_Utils.WRITE2LOG('leaving get_financial_measures',TRUE, g_msg_level_runtime_info);
1069: END IF;
1070:
1071: END Get_Financial_Measures;
1072:

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

1499: BEGIN
1500: NULL;
1501:
1502: IF g_debug_mode = 'Y' THEN
1503: Pji_Utils.WRITE2LOG('entering preparedata',TRUE, g_msg_level_runtime_info);
1504: END IF;
1505:
1506:
1507: --

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

1614: x_ptd_meaning(i), x_qtd_meaning(i), x_ytd_meaning(i), x_itd_meaning(i), x_ac_meaning(i), x_prp_meaning(i)
1615: );
1616:
1617: IF g_debug_mode = 'Y' THEN
1618: Pji_Utils.WRITE2LOG('leaving preparedata',TRUE, g_msg_level_runtime_info);
1619: END IF;
1620:
1621: COMMIT;
1622:

Line 1876: Pji_Utils.WRITE2LOG(

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

Line 2485: Pji_Utils.WRITE2LOG(

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

Line 2680: Pji_Utils.WRITE2LOG(

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

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

3351: -- calculate measure color indicators
3352: --
3353:
3354: IF g_debug_mode = 'Y' THEN
3355: Pji_Utils.WRITE2LOG('before calling exception API',TRUE, g_msg_level_runtime_info);
3356: END IF;
3357:
3358:
3359: IF g_debug_mode = 'Y' THEN

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

3356: END IF;
3357:
3358:
3359: IF g_debug_mode = 'Y' THEN
3360: Pji_Utils.WRITE2LOG('after calling exception API',TRUE, g_msg_level_runtime_info);
3361: END IF;
3362:
3363: --
3364: -- the Pa_Perf_Excp_Utils.get_measure_indicator_list could return a NULL

Line 4168: Pji_Utils.WRITE2LOG(

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

Line 9657: Pji_Utils.WRITE2LOG(

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