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

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

62: l_settings_profit_flag := nvl(l_settings_profit_flag, 'N');
63: l_settings_util_flag := nvl(l_settings_util_flag, 'N');
64:
65: l_params_proj_perf_flag :=
66: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
67: l_params_cost_flag :=
68: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
69: l_params_profit_flag :=
70: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');

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

64:
65: l_params_proj_perf_flag :=
66: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
67: l_params_cost_flag :=
68: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
69: l_params_profit_flag :=
70: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
71: l_params_util_flag :=
72: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');

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

66: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
67: l_params_cost_flag :=
68: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
69: l_params_profit_flag :=
70: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
71: l_params_util_flag :=
72: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
73:
74: if (l_settings_profit_flag = 'Y' and l_settings_cost_flag = 'N') then

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

68: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
69: l_params_profit_flag :=
70: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
71: l_params_util_flag :=
72: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
73:
74: if (l_settings_profit_flag = 'Y' and l_settings_cost_flag = 'N') then
75: update PJI_SYSTEM_SETTINGS
76: set CONFIG_COST_FLAG = 'Y';

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

86: if ((l_settings_proj_perf_flag = 'N' and l_params_proj_perf_flag = 'Y') or
87: (l_settings_cost_flag = 'N' and l_params_cost_flag = 'Y') or
88: (l_settings_profit_flag = 'N' and l_params_profit_flag = 'Y') or
89: (l_settings_util_flag = 'N' and l_params_util_flag = 'Y')) then
90: PJI_UTILS.WRITE2LOG('Error: ' || l_setup_error);
91: commit;
92: dbms_standard.raise_application_error(-20040, l_setup_error);
93: end if;
94:

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

140: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
141: (g_process, 'TRANSITION', 'N');
142: l_transition_flag := 'N';
143:
144: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);
145: PJI_UTILS.WRITE2OUT('Error: ' || l_dangling_error);
146:
147: end if;
148:

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

141: (g_process, 'TRANSITION', 'N');
142: l_transition_flag := 'N';
143:
144: PJI_UTILS.WRITE2LOG('Error: ' || l_dangling_error);
145: PJI_UTILS.WRITE2OUT('Error: ' || l_dangling_error);
146:
147: end if;
148:
149: if (l_transition_flag = 'Y') then

Line 243: pji_utils.write2log('Error: FM summarization is already running.');

239:
240: end if;
241:
242: if (l_count > 0) then
243: pji_utils.write2log('Error: FM summarization is already running.');
244: commit;
245: dbms_standard.raise_application_error(-20010, l_sum_fm_running);
246: end if;
247:

Line 364: PJI_UTILS.SET_PARAMETER('EXTRACTION_TYPE', l_extraction_type);

360: rollback;
361: return;
362: end if;
363:
364: PJI_UTILS.SET_PARAMETER('EXTRACTION_TYPE', l_extraction_type);
365:
366: insert into PJI_SYSTEM_CONFIG_HIST
367: (
368: REQUEST_ID,

Line 404: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'P');

400: null COMPLETION_TEXT
401: from
402: dual;
403:
404: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'P');
405:
406: -- Update list of organizations to be extracted in case
407: -- users defined new organizations.
408: -- List of organizations is stored in table

Line 417: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

413: -- batch.
414:
415: PJI_EXTRACTION_UTIL.UPDATE_EXTR_SCOPE;
416:
417: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
418:
419: insert into PJI_FM_PROJ_BATCH_MAP
420: (
421: WORKER_ID,

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

665: -- dangling flag: R = Rate is missing
666: -- T = TIME_ID is outside a calendar range
667: -- null = not dangling
668:
669: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
670: trunc(l_global_start_date, 'J') <>
671: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
672: g_date_mask), 'J')) then
673: pji_utils.write2log('WARNING: Global start date has changed.');

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

667: -- null = not dangling
668:
669: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
670: trunc(l_global_start_date, 'J') <>
671: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
672: g_date_mask), 'J')) then
673: pji_utils.write2log('WARNING: Global start date has changed.');
674: end if;
675:

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

669: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
670: trunc(l_global_start_date, 'J') <>
671: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
672: g_date_mask), 'J')) then
673: pji_utils.write2log('WARNING: Global start date has changed.');
674: end if;
675:
676: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',
677: to_char

Line 676: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',

672: g_date_mask), 'J')) then
673: pji_utils.write2log('WARNING: Global start date has changed.');
674: end if;
675:
676: PJI_UTILS.SET_PARAMETER('GLOBAL_START_DATE',
677: to_char
678: (
679: l_global_start_date,
680: g_date_mask

Line 743: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then

739: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
740: 'PARALLEL_PROCESSES',
741: g_parallel_processes);
742:
743: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
744: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
745: 'PA_CALENDAR_FLAG',
746: 'N');
747: else

Line 753: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then

749: 'PA_CALENDAR_FLAG',
750: 'Y');
751: end if;
752:
753: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
754: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
755: 'GL_CALENDAR_FLAG',
756: 'N');
757: else

Line 1062: 'RECVR_GL1', PJI_UTILS.GET_RATE_TYPE,

1058: 'RECVR_GL2', p_g2_currency_code,
1059: 'RECVR_PA1', p_g1_currency_code,
1060: 'RECVR_PA2', p_g2_currency_code) G_CURRENCY_CODE,
1061: decode(invert.INVERT_ID,
1062: 'RECVR_GL1', PJI_UTILS.GET_RATE_TYPE,
1063: 'RECVR_GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1065: 'RECVR_PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1066: RATE_TYPE

Line 1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,

1060: 'RECVR_PA2', p_g2_currency_code) G_CURRENCY_CODE,
1061: decode(invert.INVERT_ID,
1062: 'RECVR_GL1', PJI_UTILS.GET_RATE_TYPE,
1063: 'RECVR_GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1064: 'RECVR_PA1', PJI_UTILS.GET_RATE_TYPE,
1065: 'RECVR_PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1066: RATE_TYPE
1067: from
1068: PJI_FM_DNGL_FIN tmp2,

Line 1118: 'GL1', PJI_UTILS.GET_RATE_TYPE,

1114: 'GL2', p_g2_currency_code,
1115: 'PA1', p_g1_currency_code,
1116: 'PA2', p_g2_currency_code) G_CURRENCY_CODE,
1117: decode(invert.INVERT_ID,
1118: 'GL1', PJI_UTILS.GET_RATE_TYPE,
1119: 'GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1120: 'PA1', PJI_UTILS.GET_RATE_TYPE,
1121: 'PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1122: RATE_TYPE

Line 1120: 'PA1', PJI_UTILS.GET_RATE_TYPE,

1116: 'PA2', p_g2_currency_code) G_CURRENCY_CODE,
1117: decode(invert.INVERT_ID,
1118: 'GL1', PJI_UTILS.GET_RATE_TYPE,
1119: 'GL2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'),
1120: 'PA1', PJI_UTILS.GET_RATE_TYPE,
1121: 'PA2', FND_PROFILE.VALUE('BIS_SECONDARY_RATE_TYPE'))
1122: RATE_TYPE
1123: from
1124: PJI_FM_DNGL_ACT tmp2,

Line 1298: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'N');

1294: ';
1295:
1296: begin
1297:
1298: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'N');
1299:
1300: --
1301: -- Report dangling rates
1302: --

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

1302: --
1303:
1304: l_header_flag := 'Y';
1305:
1306: for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,
1307: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1308:
1309: if (l_header_flag = 'Y') then
1310:

Line 1307: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop

1303:
1304: l_header_flag := 'Y';
1305:
1306: for c in missing_rates(PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY,
1307: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1308:
1309: if (l_header_flag = 'Y') then
1310:
1311: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');

Line 1311: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');

1307: PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY) loop
1308:
1309: if (l_header_flag = 'Y') then
1310:
1311: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');
1312:
1313: pji_utils.write2out(l_newline || PJI_UTILS.getMissingRateHeader);
1314:
1315: l_header_flag := 'N';

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

1309: if (l_header_flag = 'Y') then
1310:
1311: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');
1312:
1313: pji_utils.write2out(l_newline || PJI_UTILS.getMissingRateHeader);
1314:
1315: l_header_flag := 'N';
1316:
1317: end if;

Line 1319: pji_utils.write2out(

1315: l_header_flag := 'N';
1316:
1317: end if;
1318:
1319: pji_utils.write2out(
1320: PJI_UTILS.getMissingRateText(c.RATE_TYPE,
1321: c.PF_CURRENCY_CODE,
1322: c.G_CURRENCY_CODE,
1323: c.FROM_DATE,

Line 1320: PJI_UTILS.getMissingRateText(c.RATE_TYPE,

1316:
1317: end if;
1318:
1319: pji_utils.write2out(
1320: PJI_UTILS.getMissingRateText(c.RATE_TYPE,
1321: c.PF_CURRENCY_CODE,
1322: c.G_CURRENCY_CODE,
1323: c.FROM_DATE,
1324: to_char(c.FROM_DATE, 'YYYY/MM/DD')) ||

Line 1336: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and

1332:
1333: select CALENDAR_ID
1334: into l_calendar_id
1335: from FII_TIME_CAL_NAME
1336: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and
1337: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;
1338:
1339: l_header_flag := 'Y';
1340:

Line 1337: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;

1333: select CALENDAR_ID
1334: into l_calendar_id
1335: from FII_TIME_CAL_NAME
1336: where PERIOD_SET_NAME = PJI_UTILS.GET_PERIOD_SET_NAME and
1337: PERIOD_TYPE = PJI_UTILS.GET_PERIOD_TYPE;
1338:
1339: l_header_flag := 'Y';
1340:
1341: for c in missing_time(l_calendar_id) loop

Line 1345: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');

1341: for c in missing_time(l_calendar_id) loop
1342:
1343: if (l_header_flag = 'Y') then
1344:
1345: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');
1346:
1347: pji_utils.write2out(PJI_FM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1348: l_header_flag := 'N';
1349: end if;

Line 1347: pji_utils.write2out(PJI_FM_SUM_MAIN.GET_MISSING_TIME_HEADER);

1343: if (l_header_flag = 'Y') then
1344:
1345: PJI_UTILS.SET_PARAMETER('DANGLING_ROWS_EXIST', 'Y');
1346:
1347: pji_utils.write2out(PJI_FM_SUM_MAIN.GET_MISSING_TIME_HEADER);
1348: l_header_flag := 'N';
1349: end if;
1350:
1351: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and

Line 1354: pji_utils.write2out(

1350:
1351: if (c.FROM_DATE < c.CALENDAR_MIN_DATE and
1352: c.TO_DATE > c.CALENDAR_MAX_DATE) then
1353:
1354: pji_utils.write2out(
1355: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1356: c.USER_PERIOD_TYPE,
1357: c.FROM_DATE,
1358: c.CALENDAR_MIN_DATE));

Line 1360: pji_utils.write2out(

1356: c.USER_PERIOD_TYPE,
1357: c.FROM_DATE,
1358: c.CALENDAR_MIN_DATE));
1359:
1360: pji_utils.write2out(
1361: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1362: c.USER_PERIOD_TYPE,
1363: c.CALENDAR_MAX_DATE,
1364: c.TO_DATE));

Line 1368: pji_utils.write2out(

1364: c.TO_DATE));
1365:
1366: elsif (c.TO_DATE > c.CALENDAR_MAX_DATE) then
1367:
1368: pji_utils.write2out(
1369: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1370: c.USER_PERIOD_TYPE,
1371: c.CALENDAR_MAX_DATE,
1372: c.TO_DATE));

Line 1376: pji_utils.write2out(

1372: c.TO_DATE));
1373:
1374: elsif (c.FROM_DATE < c.CALENDAR_MIN_DATE) then
1375:
1376: pji_utils.write2out(
1377: PJI_FM_SUM_MAIN.GET_MISSING_TIME_TEXT(c.CALENDAR_NAME,
1378: c.USER_PERIOD_TYPE,
1379: c.FROM_DATE,
1380: c.CALENDAR_MIN_DATE));

Line 1386: pji_utils.write2out(l_newline);

1382: end if;
1383:
1384: end loop;
1385:
1386: pji_utils.write2out(l_newline);
1387:
1388: commit;
1389:
1390: end DANGLING_REPORT;

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

1418: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process,
1419: 'CONFIG_UTIL_FLAG'), 'N');
1420:
1421: if (l_params_proj_perf_flag = 'Y') then
1422: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');
1423: end if;
1424:
1425: if (l_params_cost_flag = 'Y') then
1426: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');

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

1422: PJI_UTILS.SET_PARAMETER('CONFIG_PROJ_PERF_FLAG', 'Y');
1423: end if;
1424:
1425: if (l_params_cost_flag = 'Y') then
1426: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');
1427: end if;
1428:
1429: if (l_params_profit_flag = 'Y') then
1430: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');

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

1426: PJI_UTILS.SET_PARAMETER('CONFIG_COST_FLAG', 'Y');
1427: end if;
1428:
1429: if (l_params_profit_flag = 'Y') then
1430: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');
1431: end if;
1432:
1433: if (l_params_util_flag = 'Y') then
1434: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');

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

1430: PJI_UTILS.SET_PARAMETER('CONFIG_PROFIT_FLAG', 'Y');
1431: end if;
1432:
1433: if (l_params_util_flag = 'Y') then
1434: PJI_UTILS.SET_PARAMETER('CONFIG_UTIL_FLAG', 'Y');
1435: end if;
1436:
1437: update PJI_SYSTEM_CONFIG_HIST
1438: set END_DATE = sysdate,

Line 1482: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

1478: end if;
1479:
1480: DANGLING_REPORT;
1481:
1482: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1483:
1484: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1485: 'PJI_FM_PROJ_BATCH_MAP',
1486: 'NORMAL',

Line 1502: PJI_UTILS.SET_PARAMETER('LAST_FM_EXTR_DATE',

1498: END_DATE is null;
1499:
1500: -- update default report as-of date
1501:
1502: PJI_UTILS.SET_PARAMETER('LAST_FM_EXTR_DATE',
1503: to_char(sysdate, PJI_FM_SUM_MAIN.g_date_mask));
1504:
1505: PJI_UTILS.SET_PARAMETER('LAST_EXTR_DATE',
1506: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'));

Line 1505: PJI_UTILS.SET_PARAMETER('LAST_EXTR_DATE',

1501:
1502: PJI_UTILS.SET_PARAMETER('LAST_FM_EXTR_DATE',
1503: to_char(sysdate, PJI_FM_SUM_MAIN.g_date_mask));
1504:
1505: PJI_UTILS.SET_PARAMETER('LAST_EXTR_DATE',
1506: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'));
1507:
1508: commit;
1509:

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

1526: 'F');
1527:
1528: commit;
1529:
1530: pji_utils.write2log(sqlerrm, true, 0);
1531:
1532: l_sqlerrm := substr(sqlerrm, 1, 240);
1533:
1534: update PJI_SYSTEM_CONFIG_HIST

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

1610: 'RUNNING',
1611: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, g_process),
1612: g_incr_disp_name
1613: ))) then
1614: pji_utils.write2log('Error: Summarization is already running.');
1615: commit;
1616: dbms_standard.raise_application_error(-20010, l_sum_running);
1617: end if;
1618:

Line 1668: if (PJI_UTILS.GET_PARAMETER('DANGLING_ROWS_EXIST') = 'Y') then

1664:
1665: RUN_PROCESS;
1666: WRAPUP_PROCESS;
1667:
1668: if (PJI_UTILS.GET_PARAMETER('DANGLING_ROWS_EXIST') = 'Y') then
1669: retcode := 1;
1670: else
1671: retcode := 0;
1672: end if;