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;Commented for bug 13011859 */
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;Commented for bug 13011859 */
179:
180: if (l_transition_flag = 'Y') then

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

274:
275: end if;Commented for bug 13011859 */
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 1066: 'G1', PJI_UTILS.GET_RATE_TYPE,

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

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

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

Line 1234: /* for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,

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

Line 1235: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop

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

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

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

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

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

Line 1247: pji_utils.write2out(

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

Line 1248: PJI_UTILS.getMissingRateText(c.RATE_TYPE,

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

Line 1264: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and

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

Line 1265: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;

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

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

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

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

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

Line 1282: pji_utils.write2out(

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

Line 1288: pji_utils.write2out(

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

Line 1296: pji_utils.write2out(

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

Line 1304: pji_utils.write2out(

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

Line 1314: pji_utils.write2out(l_newline);

1310: end if;
1311:
1312: end loop;
1313:
1314: pji_utils.write2out(l_newline);
1315:
1316: commit;Commented for bug 13011859 */
1317:
1318: end DANGLING_REPORT;

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

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

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

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

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

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

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

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

Line 1415: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

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

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

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

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

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

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

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

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

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

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

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

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

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