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_RM_SUM_MAIN dependencies on PJI_UTILS

Line 101: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');

97: l_settings_profit_flag := nvl(l_settings_profit_flag, 'N');
98: l_settings_util_flag := nvl(l_settings_util_flag, 'N');
99:
100: l_params_proj_perf_flag :=
101: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
102: l_params_cost_flag :=
103: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
104: l_params_profit_flag :=
105: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');

Line 103: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');

99:
100: l_params_proj_perf_flag :=
101: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
102: l_params_cost_flag :=
103: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
104: l_params_profit_flag :=
105: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
106: l_params_util_flag :=
107: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');

Line 105: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');

101: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
102: l_params_cost_flag :=
103: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
104: l_params_profit_flag :=
105: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
106: l_params_util_flag :=
107: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
108:
109: if (l_settings_profit_flag = 'Y' and l_settings_cost_flag = 'N') then

Line 107: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');

103: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
104: l_params_profit_flag :=
105: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
106: l_params_util_flag :=
107: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
108:
109: if (l_settings_profit_flag = 'Y' and l_settings_cost_flag = 'N') then
110: update PJI_SYSTEM_SETTINGS
111: set CONFIG_COST_FLAG = 'Y';

Line 125: PJI_UTILS.WRITE2LOG('Error: ' || l_setup_error);

121: if ((l_settings_proj_perf_flag = 'N' and l_params_proj_perf_flag = 'Y') or
122: (l_settings_cost_flag = 'N' and l_params_cost_flag = 'Y') or
123: (l_settings_profit_flag = 'N' and l_params_profit_flag = 'Y') or
124: (l_settings_util_flag = 'N' and l_params_util_flag = 'Y')) then
125: PJI_UTILS.WRITE2LOG('Error: ' || l_setup_error);
126: commit;
127: dbms_standard.raise_application_error(-20040, l_setup_error);
128: end if;
129:

Line 175: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);

171: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
172: (g_process, 'TRANSITION', 'N');
173: l_transition_flag := 'N';
174:
175: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);
176: PJI_UTILS.WRITE2OUT('Error: ' || l_dangling_error);
177:
178: end if;
179:

Line 176: PJI_UTILS.WRITE2OUT('Error: ' || l_dangling_error);

172: (g_process, 'TRANSITION', 'N');
173: l_transition_flag := 'N';
174:
175: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);
176: PJI_UTILS.WRITE2OUT('Error: ' || l_dangling_error);
177:
178: end if;
179:
180: if (l_transition_flag = 'Y') then

Line 278: pji_utils.write2log('Error: RM summarization is already running.');

274:
275: end if;
276:
277: if (l_count > 0) then
278: pji_utils.write2log('Error: RM summarization is already running.');
279: commit;
280: dbms_standard.raise_application_error(-20010, l_sum_rm_running);
281: end if;
282:

Line 439: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'P');

435: -- ------------------------------------------------------------------------
436: -- Initialize Resource Management portion of stage 2 PJI summarization.
437: -- ------------------------------------------------------------------------
438:
439: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'P');
440:
441: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
442: 'ORGANIZATION_ID',
443: p_organization_id);

Line 596: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

592: from PJI_RM_ORG_BATCH_MAP map
593: where map.WORKER_ID = 1) and
594: STATUS is null;
595:
596: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
597:
598: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
599: trunc(l_global_start_date, 'J') <>
600: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 598: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and

594: STATUS is null;
595:
596: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
597:
598: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
599: trunc(l_global_start_date, 'J') <>
600: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
601: g_date_mask), 'J')) then
602: pji_utils.write2log('WARNING: Global start date has changed.');

Line 600: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

596: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
597:
598: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
599: trunc(l_global_start_date, 'J') <>
600: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
601: g_date_mask), 'J')) then
602: pji_utils.write2log('WARNING: Global start date has changed.');
603: end if;
604:

Line 602: pji_utils.write2log('WARNING: Global start date has changed.');

598: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
599: trunc(l_global_start_date, 'J') <>
600: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
601: g_date_mask), 'J')) then
602: pji_utils.write2log('WARNING: Global start date has changed.');
603: end if;
604:
605: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',
606: to_char

Line 605: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',

601: g_date_mask), 'J')) then
602: pji_utils.write2log('WARNING: Global start date has changed.');
603: end if;
604:
605: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',
606: to_char
607: (
608: l_global_start_date,
609: g_date_mask

Line 612: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'Y' ) then

608: l_global_start_date,
609: g_date_mask
610: ));
611:
612: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'Y' ) then
613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,'PA_CALENDAR_FLAG','Y');
614: else
615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,'PA_CALENDAR_FLAG','N');
616: end if;

Line 618: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'Y' ) then

614: else
615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,'PA_CALENDAR_FLAG','N');
616: end if;
617:
618: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'Y' ) then
619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,'GL_CALENDAR_FLAG','Y');
620: else
621: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,'GL_CALENDAR_FLAG','N');
622: end if;

Line 676: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

672: END IF;
673:
674: PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_EXTR_SCOPE;
675:
676: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
677:
678: insert into PJI_PJI_PROJ_BATCH_MAP
679: (
680: WORKER_ID,

Line 1067: 'G1', PJI_UTILS.GET_RATE_TYPE,

1063: decode(invert.INVERT_ID,
1064: 'G1', p_g1_currency_code,
1065: 'G2', p_g2_currency_code) G_CURRENCY_CODE,
1066: decode(invert.INVERT_ID,
1067: 'G1', PJI_UTILS.GET_RATE_TYPE,
1068: 'G2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE')) RATE_TYPE
1069: from
1070: PJI_FM_EXTR_PLN_LOG log,
1071: PJI_ORG_EXTR_INFO info,

Line 1227: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'N');

1223: ';
1224:
1225: begin
1226:
1227: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'N');
1228:
1229: --
1230: -- Report dangling rates
1231: --

Line 1235: for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,

1231: --
1232:
1233: l_header_flag := 'Y';
1234:
1235: for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,
1236: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1237:
1238: if (l_header_flag = 'Y') then
1239:

Line 1236: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop

1232:
1233: l_header_flag := 'Y';
1234:
1235: for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,
1236: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1237:
1238: if (l_header_flag = 'Y') then
1239:
1240: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');

Line 1240: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');

1236: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1237:
1238: if (l_header_flag = 'Y') then
1239:
1240: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');
1241:
1242: pji_utils.write2out(l_newline || PJI_UTILS.getMissingRateHeader);
1243:
1244: l_header_flag := 'N';

Line 1242: pji_utils.write2out(l_newline || PJI_UTILS.getMissingRateHeader);

1238: if (l_header_flag = 'Y') then
1239:
1240: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');
1241:
1242: pji_utils.write2out(l_newline || PJI_UTILS.getMissingRateHeader);
1243:
1244: l_header_flag := 'N';
1245:
1246: end if;

Line 1248: pji_utils.write2out(

1244: l_header_flag := 'N';
1245:
1246: end if;
1247:
1248: pji_utils.write2out(
1249: PJI_UTILS.getMissingRateText(c.RATE_TYPE,
1250: c.PF_CURRENCY_CODE,
1251: c.G_CURRENCY_CODE,
1252: c.FROM_DATE,

Line 1249: PJI_UTILS.getMissingRateText(c.RATE_TYPE,

1245:
1246: end if;
1247:
1248: pji_utils.write2out(
1249: PJI_UTILS.getMissingRateText(c.RATE_TYPE,
1250: c.PF_CURRENCY_CODE,
1251: c.G_CURRENCY_CODE,
1252: c.FROM_DATE,
1253: to_char(c.FROM_DATE, 'YYYY/MM/DD')) ||

Line 1265: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and

1261:
1262: select CALENDAR_ID
1263: into l_calendar_id
1264: from FII_TIME_CAL_NAME
1265: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and
1266: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;
1267:
1268: l_header_flag := 'Y';
1269:

Line 1266: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;

1262: select CALENDAR_ID
1263: into l_calendar_id
1264: from FII_TIME_CAL_NAME
1265: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and
1266: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;
1267:
1268: l_header_flag := 'Y';
1269:
1270: for c in missing_time(l_calendar_id) loop

Line 1274: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');

1270: for c in missing_time(l_calendar_id) loop
1271:
1272: if (l_header_flag = 'Y') then
1273:
1274: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');
1275:
1276: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1277: l_header_flag := 'N';
1278: end if;

Line 1276: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);

1272: if (l_header_flag = 'Y') then
1273:
1274: PJI_UTILS.SET_PARAMETER('DANGLING_PJI_ROWS_EXIST', 'Y');
1275:
1276: pji_utils.write2out(PJI_RM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1277: l_header_flag := 'N';
1278: end if;
1279:
1280: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and

Line 1283: pji_utils.write2out(

1279:
1280: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and
1281: c.TO_DATE > c.CALENDAR_MAX_DATE) then
1282:
1283: pji_utils.write2out(
1284: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1285: c.USER_PERIOD_TYPE,
1286: c.FROM_DATE,
1287: c.CALENDAR_MIN_DATE));

Line 1289: pji_utils.write2out(

1285: c.USER_PERIOD_TYPE,
1286: c.FROM_DATE,
1287: c.CALENDAR_MIN_DATE));
1288:
1289: pji_utils.write2out(
1290: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1291: c.USER_PERIOD_TYPE,
1292: c.CALENDAR_MAX_DATE,
1293: c.TO_DATE));

Line 1297: pji_utils.write2out(

1293: c.TO_DATE));
1294:
1295: elsif (c.TO_DATE > c.CALENDAR_MAX_DATE) then
1296:
1297: pji_utils.write2out(
1298: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1299: c.USER_PERIOD_TYPE,
1300: c.CALENDAR_MAX_DATE,
1301: c.TO_DATE));

Line 1305: pji_utils.write2out(

1301: c.TO_DATE));
1302:
1303: elsif (c.FROM_DATE < c.CALENDAR_MIN_DATE) then
1304:
1305: pji_utils.write2out(
1306: PJI_RM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1307: c.USER_PERIOD_TYPE,
1308: c.FROM_DATE,
1309: c.CALENDAR_MIN_DATE));

Line 1315: pji_utils.write2out(l_newline);

1311: end if;
1312:
1313: end loop;
1314:
1315: pji_utils.write2out(l_newline);
1316:
1317: commit;
1318:
1319: end DANGLING_REPORT;

Line 1351: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');

1347: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1348: 'CONFIG_UTIL_FLAG'), 'N');
1349:
1350: if (l_params_proj_perf_flag = 'Y') then
1351: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');
1352: end if;
1353:
1354: if (l_params_cost_flag = 'Y') then
1355: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');

Line 1355: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');

1351: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');
1352: end if;
1353:
1354: if (l_params_cost_flag = 'Y') then
1355: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');
1356: end if;
1357:
1358: if (l_params_profit_flag = 'Y') then
1359: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');

Line 1359: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');

1355: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');
1356: end if;
1357:
1358: if (l_params_profit_flag = 'Y') then
1359: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');
1360: end if;
1361:
1362: if (l_params_util_flag = 'Y') then
1363: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');

Line 1363: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');

1359: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');
1360: end if;
1361:
1362: if (l_params_util_flag = 'Y') then
1363: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');
1364: end if;
1365:
1366: update PJI_SYSTEM_CONFIG_HIST
1367: set END_DATE = sysdate

Line 1416: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

1412:
1413: -- clean up worker tables
1414: PJI_FM_PLAN_EXTR.CLEANUP_LOG;
1415:
1416: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1417:
1418: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1419: 'PJI_RM_ORG_BATCH_MAP','NORMAL',null);
1420:

Line 1435: PJI_UTILS.SET_PARAMETER('LAST_PJI_EXTR_DATE', to_char(sysdate, 'YYYY/MM/DD'));

1431: COMPLETION_TEXT = 'Normal completion'
1432: where PROCESS_NAME = g_process || 1 and
1433: END_DATE is null;
1434:
1435: PJI_UTILS.SET_PARAMETER('LAST_PJI_EXTR_DATE', to_char(sysdate, 'YYYY/MM/DD'));
1436: commit;
1437:
1438: -- calculate statistics on temporary tables used to retrieve fact data
1439:

Line 1464: pji_utils.write2log(sqlerrm, true, 0);

1460: 'F');
1461:
1462: commit;
1463:
1464: pji_utils.write2log(sqlerrm, true, 0);
1465:
1466: l_sqlerrm := substr(sqlerrm, 1, 240);
1467:
1468: update PJI_SYSTEM_CONFIG_HIST

Line 1559: pji_utils.write2log('Error: PJI is not licensed.');

1555: PJI_FM_DEBUG.CONC_REQUEST_HOOK(g_process);
1556:
1557: /* this is removed as for bug#5075209
1558: if (PA_INSTALL.is_pji_licensed = 'N') then
1559: pji_utils.write2log('Error: PJI is not licensed.');
1560: commit;
1561: raise l_pji_not_licensed;
1562: end if;*/
1563:

Line 1578: pji_utils.write2log('Error: Summarization is already running.');

1574: 'RUNNING',
1575: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1576: g_incr_disp_name
1577: ))) then
1578: pji_utils.write2log('Error: Summarization is already running.');
1579: commit;
1580: dbms_standard.raise_application_error(-20010, l_sum_running);
1581: end if;
1582:

Line 1601: pji_utils.write2log('Nothing to summarize since pji_org_extr_status has 0 records');

1597: FROM pji_org_extr_status;
1598:
1599: IF l_org_count=0 THEN
1600:
1601: pji_utils.write2log('Nothing to summarize since pji_org_extr_status has 0 records');
1602: RETURN;
1603:
1604: END IF;
1605:

Line 1662: if (PJI_UTILS.GET_PARAMETER('DANGLING_PJI_ROWS_EXIST') = 'Y') then

1658:
1659: RUN_PROCESS;
1660: WRAPUP_PROCESS;
1661:
1662: if (PJI_UTILS.GET_PARAMETER('DANGLING_PJI_ROWS_EXIST') = 'Y') then
1663: retcode := 1;
1664: else
1665: retcode := 0;
1666: end if;