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.IEX_SCORE_NEW_PVT dependencies on FND_FILE

Line 430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge id ' || l_bridge);

426: --Select IEX_DEL_WF_S.NEXTVAL INTO l_bridge FROM Dual;
427: --- End - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
428:
429: l_bridge := l_del_buff_bridge; --Added by schekuri for bug#6373998 by schekuri on 31-Aug-2007
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge id ' || l_bridge);
431: l_universe_size := t_object_ids.count;
432: -- IF PG_DEBUG < 10 THEN
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Universe size is ' || l_universe_size);

Line 447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Exception getting the concurrent program. Error: ' || sqlerrm );

443: AND scr.Score_ID = scomp.score_id;
444: exception
445: when OTHERS THEN
446: l_conc_prog_name := 'X';
447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Exception getting the concurrent program. Error: ' || sqlerrm );
448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Program will continue, no concurrent program will be launched' );
449: end;
450: -- End - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to
451:

Line 448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Program will continue, no concurrent program will be launched' );

444: exception
445: when OTHERS THEN
446: l_conc_prog_name := 'X';
447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Exception getting the concurrent program. Error: ' || sqlerrm );
448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: getScores: Program will continue, no concurrent program will be launched' );
449: end;
450: -- End - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to
451:
452: FOR l_count IN 1..l_universe_size LOOP

Line 724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in getScores: ' || sqlerrm );

720:
721: Exception
722:
723: When Others Then
724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in getScores: ' || sqlerrm );
725: RAISE FND_API.G_EXC_ERROR;
726: END getScores;
727:
728: /*

Line 835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: No score components for engine ' || p_score_id);

831: if l_components_tbl is null or l_components_tbl.count < 1 then
832: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
833: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: No score components for engine');
834: END IF;
835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: No score components for engine ' || p_score_id);
836: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE_ENG_COMPONENTS');
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: end if;

Line 852: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');

848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:
850:
851: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007
852: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');
853: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
854: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');
855: END IF;
856:

Line 878: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero or Invalid for Engine ' || p_score_id);

874: if (l_universe is null or l_universe.count < 1) and not l_last_batch then
875: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
876: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Universe size is zero');
877: END IF;
878: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero or Invalid for Engine ' || p_score_id);
879:
880: FND_MESSAGE.Set_Name('IEX', 'IEX_UNIVERSE_SIZE_ZERO');
881: FND_MSG_PUB.Add;
882:

Line 902: FND_FILE.PUT_LINE(FND_FILE.LOG,

898: if (l_components_tbl(i).score_comp_weight is null) then
899: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
900: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no comp weight');
901: END IF;
902: FND_FILE.PUT_LINE(FND_FILE.LOG,
903: 'Score Comp Weight are required for Engine '|| p_score_id);
904: FND_MESSAGE.Set_Name('IEX', 'IEX_WEIGHT_REQUIRED');
905: FND_MSG_PUB.Add;
906: RAISE FND_API.G_EXC_ERROR;

Line 922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Scored ' || l_universe_size || ' objects of type ' || l_object_type);

918:
919: l_bridge := l_scores_tbl(1); -- The table now contains the bridge to the next concurrent program or nothing
920: l_universe_size := l_universe.count;
921:
922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Scored ' || l_universe_size || ' objects of type ' || l_object_type);
923: Begin
924: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
925: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Finding any process to spawn...');
926: END IF;

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Spawning ' || l_conc_prog_name);

928: Into l_conc_prog_name
929: From IEX_SCORES scr, fnd_concurrent_programs cp
930: Where scr.concurrent_prog_name = cp.concurrent_program_name AND
931: scr.Score_ID = p_score_id;
932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Spawning ' || l_conc_prog_name);
933:
934: --- Begin - Eun Huh - 02/15/2007 - bug 5763675/5696238 if run multiple Scoring Engine Harness program at the same time it will pick up only the last one always
935: --select MAX(request_id)
936: -- into l_bridge

Line 979: FND_FILE.PUT_LINE(FND_FILE.LOG,

975: --the main process should wait till the spawned process is
976: --over.
977: IF (l_submit_request_id IS NOT NULL AND l_submit_request_id <> 0) THEN
978: LOOP
979: FND_FILE.PUT_LINE(FND_FILE.LOG,
980: 'Start Time of the spawned Process ' ||
981: l_conc_prog_name || ' =>'||to_char (sysdate, 'dd/mon/yyyy :HH:MI:SS'));
982: l_bool := FND_CONCURRENT.wait_for_request(
983: request_id =>l_submit_request_id,

Line 996: FND_FILE.PUT_LINE(FND_FILE.LOG,

992: IF dphase = 'COMPLETE'
993: --and dstatus = 'NORMAL' --the possible
994: --values are NORMAL/ERROR/WARNING/CANCELLED/TERMINATED
995: THEN
996: FND_FILE.PUT_LINE(FND_FILE.LOG,
997: 'End Time of the spawned Process ' ||
998: l_conc_prog_name || ' =>'||to_char (sysdate, 'dd/mon/yyyy :HH:MI:SS'));
999: EXIT;
1000: END If; --dphase

Line 1004: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Launched cp '

1000: END If; --dphase
1001:
1002: END LOOP;
1003: END IF; -- if l_submit
1004: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Launched cp '
1005: || l_submit_request_id || ' successfully');
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added OU Name for MOAC
1007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1008: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: process spawned '

Line 1006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added OU Name for MOAC

1002: END LOOP;
1003: END IF; -- if l_submit
1004: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Launched cp '
1005: || l_submit_request_id || ' successfully');
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added OU Name for MOAC
1007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1008: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: process spawned '
1009: || l_submit_request_id);
1010: END IF;

Line 1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));

1237: exception
1238: when others then l_pf_name := null;
1239: end;
1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024

Line 1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));

1238: when others then l_pf_name := null;
1239: end;
1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024
1246:

Line 1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);

1239: end;
1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024
1246:
1247:

Line 1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024
1246:
1247:
1248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);

Line 1248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);

1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024
1246:
1247:
1248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);
1249: for x in 1..5 loop
1250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Running Scoring Engine: ' || to_char(l_num_score_engines(x)));
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added for moac
1252: if l_num_score_engines(x) is not null then

Line 1250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Running Scoring Engine: ' || to_char(l_num_score_engines(x)));

1246:
1247:
1248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);
1249: for x in 1..5 loop
1250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Running Scoring Engine: ' || to_char(l_num_score_engines(x)));
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added for moac
1252: if l_num_score_engines(x) is not null then
1253: BEGIN
1254: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,

Line 1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added for moac

1247:
1248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);
1249: for x in 1..5 loop
1250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Running Scoring Engine: ' || to_char(l_num_score_engines(x)));
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added for moac
1252: if l_num_score_engines(x) is not null then
1253: BEGIN
1254: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,
1255: p_init_msg_list => FND_API.G_TRUE,

Line 1261: FND_FILE.PUT_LINE(FND_FILE.LOG,

1257: x_return_status => l_return_status,
1258: x_msg_count => l_msg_count,
1259: x_msg_data => l_msg_data,
1260: p_score_id => l_num_score_engines(x));
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,
1262: 'Score Engine: ' || l_num_score_engines(x) ||
1263: ' Status: ' || l_return_status);
1264: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1265: RAISE FND_API.G_EXC_ERROR;

Line 1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);

1273: ERRBUF := l_msg_data;
1274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1275: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);
1276: END IF;
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);
1278:
1279: -- START -jsanju 10/19/05 , set concurrent status to 'WARNING' if universe size exception occurs for bug 3549051
1280: WHEN IEX_UNIVERSE_SIZE_ZERO_ERROR THEN
1281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero ');

1280: WHEN IEX_UNIVERSE_SIZE_ZERO_ERROR THEN
1281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1282: IEX_DEBUG_PUB.logMessage('IEX_SCORE: universe size is zero ' || l_msg_data);
1283: END IF;
1284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero ');
1285: request_status := fnd_concurrent.set_completion_status('WARNING'
1286: , 'Universe size is zero');
1287:
1288: -- END -jsanju 10/19/05 , set concurrent status to 'WARNING' if universe size exception occurs for bug 3549051

Line 1296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);

1292: ERRBUF := l_msg_data;
1293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1294: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
1295: END IF;
1296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);
1297: END;
1298:
1299: end if;
1300: end loop;

Line 1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

1311: ERRBUF := l_msg_data;
1312: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1313: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm);
1314: END IF;
1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1316:
1317: WHEN OTHERS THEN
1318: RETCODE := -1;
1319: ERRBUF := l_msg_data;

Line 1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

1319: ERRBUF := l_msg_data;
1320: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1321: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
1322: END IF;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1324: END SCORE_CONCUR;
1325:
1326: /*
1327: || Overview: delete rows from IEX_SCORE_HISTORIES to improve performance

Line 1425: FND_FILE.PUT_LINE(FND_FILE.LOG,P_SCORE_OBJECT_ID);

1421: END IF;
1422:
1423: /* build where clause */
1424: if P_SCORE_OBJECT_ID IS NOT NULL then
1425: FND_FILE.PUT_LINE(FND_FILE.LOG,P_SCORE_OBJECT_ID);
1426: i:= i + 1;
1427: l_conditions(i).Col_Name := 'SCORE_OBJECT_ID';
1428: l_conditions(i).Condition := '=';
1429: l_conditions(i).Value := P_SCORE_OBJECT_ID;

Line 1432: FND_FILE.PUT_LINE(FND_FILE.LOG,P_SCORE_OBJECT_CODE);

1428: l_conditions(i).Condition := '=';
1429: l_conditions(i).Value := P_SCORE_OBJECT_ID;
1430: end if;
1431: if P_SCORE_OBJECT_CODE IS NOT NULL then
1432: FND_FILE.PUT_LINE(FND_FILE.LOG,P_SCORE_OBJECT_CODE);
1433: i := i + 1;
1434: l_conditions(i).Col_Name := 'SCORE_OBJECT_CODE';
1435: l_conditions(i).Condition := '=';
1436: l_conditions(i).Value := '''' || P_SCORE_OBJECT_CODE || '''';

Line 1439: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR(P_FROM_DATE));

1435: l_conditions(i).Condition := '=';
1436: l_conditions(i).Value := '''' || P_SCORE_OBJECT_CODE || '''';
1437: end if;
1438: if P_FROM_DATE IS NOT NULL then
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR(P_FROM_DATE));
1440: i := i + 1;
1441: l_conditions(i).Col_Name := 'CREATION_DATE';
1442: l_conditions(i).Condition := '>';
1443: -- l_conditions(i).Value := '''' || to_char(P_FROM_DATE) || '''';

Line 1450: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR(P_TO_DATE));

1446: l_conditions(i).Value := '''' || to_char(v_FROM_DATE) || '''';
1447: -- end bug 4504193 by ctlee 2005/07/26
1448: end if;
1449: if P_TO_DATE IS NOT NULL then
1450: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR(P_TO_DATE));
1451: i := i + 1;
1452: l_conditions(i).Col_Name := 'CREATION_DATE';
1453: l_conditions(i).Condition := '<=';
1454: -- l_conditions(i).Value := '''' || to_char(P_TO_DATE) || '''';

Line 1461: FND_FILE.PUT_LINE(FND_FILE.LOG,P_REQUEST_ID);

1457: l_conditions(i).Value := '''' || to_char(v_TO_DATE) || '''';
1458: -- end bug 4504193 by ctlee 2005/07/26
1459: end if;
1460: if P_REQUEST_ID IS NOT NULL then
1461: FND_FILE.PUT_LINE(FND_FILE.LOG,P_REQUEST_ID);
1462: i := i + 1;
1463: l_conditions(i).Col_Name := 'REQUEST_ID';
1464: l_conditions(i).Condition := '=';
1465: l_conditions(i).Value := P_REQUEST_ID;

Line 1469: FND_FILE.PUT_LINE(FND_FILE.LOG,L_SAVE_LAST_RUN);

1465: l_conditions(i).Value := P_REQUEST_ID;
1466: end if;
1467: --if P_SAVE_LAST_RUN <> 'N' then
1468: if L_SAVE_LAST_RUN <> 'N' then
1469: FND_FILE.PUT_LINE(FND_FILE.LOG,L_SAVE_LAST_RUN);
1470: -- Begin - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception
1471: i := i + 1;
1472: l_conditions(i).Col_Name := 'trunc(CREATION_DATE)';
1473: l_conditions(i).Condition := '<>';

Line 1487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete Filter Applied => '|| vPLSQL2);

1483:
1484: vPLSQL2 := IEX_UTILITIES.buildWhereClause(l_conditions);
1485:
1486: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete Filter Applied => '|| vPLSQL2);
1488: end if;
1489:
1490: v_del_sql := v_del_sql || VPLSQL2 ;
1491: End If ;

Line 1502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SELECT SCORE_HISTORY_ID ' ||

1498: IEX_DEBUG_PUB.logMessage(vPLSQL2);
1499: END IF;
1500:
1501: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SELECT SCORE_HISTORY_ID ' ||
1503: ' FROM IEX_SCORE_HISTORIES ' ||
1504: vPLSQL2);
1505: End if;
1506:

Line 1511: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');

1507: vPLSQL := ' SELECT Count(1), Score_object_code ' ||
1508: ' FROM IEX_SCORE_HISTORIES ' ||
1509: 'GROUP BY SCORE_OBJECT_CODE ';
1510:
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1514: open sql_cur for
1515: vPLSQL;

Line 1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');

1508: ' FROM IEX_SCORE_HISTORIES ' ||
1509: 'GROUP BY SCORE_OBJECT_CODE ';
1510:
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1514: open sql_cur for
1515: vPLSQL;
1516: LOOP

Line 1513: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');

1509: 'GROUP BY SCORE_OBJECT_CODE ';
1510:
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1514: open sql_cur for
1515: vPLSQL;
1516: LOOP
1517: l_count := 0;

Line 1522: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OBJECT_CODE: ' || l_object_code || ' OBJECTS: ' || l_count);

1518: l_object_code := null;
1519: i := i + 1;
1520: fetch sql_cur into l_count, l_object_code;
1521: exit when sql_cur%NOTFOUND;
1522: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OBJECT_CODE: ' || l_object_code || ' OBJECTS: ' || l_count);
1523: v_tot_objects := v_tot_objects + l_count ;
1524: end loop;
1525: close sql_cur;
1526:

Line 1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES BEFORE PURGE: ' || v_tot_objects);

1523: v_tot_objects := v_tot_objects + l_count ;
1524: end loop;
1525: close sql_cur;
1526:
1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES BEFORE PURGE: ' || v_tot_objects);
1528:
1529: /* do erasing here */
1530: /* Removed by Andre 06/18/2004, we will need to delete in chunks
1531: EXECUTE IMMEDIATE v_del_sql ;

Line 1535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => '|| p_truncate);

1531: EXECUTE IMMEDIATE v_del_sql ;
1532: */
1533:
1534: If NVL(p_truncate,'Y') <> 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => '|| p_truncate);
1536: v_del_sql := 'truncate table '||l_prod||'.IEX_SCORE_HISTORIES'; -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1537: EXECUTE IMMEDIATE v_del_sql;
1538: Else -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1539:

Line 1553: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Final delete statement => '|| v_del_sql);

1549: open sql_cur for vSelectCount;
1550: fetch sql_cur into vLoopCount;
1551: close sql_cur;
1552:
1553: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Final delete statement => '|| v_del_sql);
1554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting => '|| vLoopCount || ' Records');
1555:
1556: loop
1557: EXECUTE IMMEDIATE v_del_sql;

Line 1554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting => '|| vLoopCount || ' Records');

1550: fetch sql_cur into vLoopCount;
1551: close sql_cur;
1552:
1553: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Final delete statement => '|| v_del_sql);
1554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting => '|| vLoopCount || ' Records');
1555:
1556: loop
1557: EXECUTE IMMEDIATE v_del_sql;
1558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'i => '|| i );

Line 1558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'i => '|| i );

1554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting => '|| vLoopCount || ' Records');
1555:
1556: loop
1557: EXECUTE IMMEDIATE v_del_sql;
1558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'i => '|| i );
1559: commit;
1560:
1561: i := i + p_batch_size;
1562: exit when i > vLoopCount;

Line 1572: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');

1568: End if; -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1569:
1570: -- End changes, Andre 06/18/2004
1571:
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1573: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AFTER PURGE');
1574: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1575:
1576: l_total := 0;

Line 1573: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AFTER PURGE');

1569:
1570: -- End changes, Andre 06/18/2004
1571:
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1573: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AFTER PURGE');
1574: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1575:
1576: l_total := 0;
1577: open sql_cur for

Line 1574: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');

1570: -- End changes, Andre 06/18/2004
1571:
1572: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1573: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AFTER PURGE');
1574: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1575:
1576: l_total := 0;
1577: open sql_cur for
1578: vPLSQL;

Line 1585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OBJECT_CODE: ' || l_object_code || ' OBJECTS: ' || l_count);

1581: l_object_code := null;
1582: i := i + 1;
1583: fetch sql_cur into l_count, l_object_code;
1584: exit when sql_cur%NOTFOUND;
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OBJECT_CODE: ' || l_object_code || ' OBJECTS: ' || l_count);
1586: end loop;
1587: close sql_cur;
1588:
1589: Begin

Line 1595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);

1591: From IEX_SCORE_HISTORIES;
1592: Exception When NO_DATA_FOUND Then
1593: l_total := 0;
1594: END;
1595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);
1596:
1597: -- IF PG_DEBUG < 10 THEN
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

1605: -- IF PG_DEBUG < 10 THEN
1606: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1607: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm );
1608: END IF;
1609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1610:
1611: WHEN OTHERS THEN
1612: RETCODE := -1;
1613: ERRBUF := l_msg_data;

Line 1618: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);

1614: -- IF PG_DEBUG < 10 THEN
1615: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1616: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
1617: END IF;
1618: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1619: --dbms_output.put_line(sqlerrm);
1620:
1621: END eraseScores;
1622:

Line 1874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);

1870: WHEN FND_API.G_EXC_ERROR THEN
1871: IF PG_DEBUG < 10 THEN
1872: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Expected Error ' || sqlerrm );
1873: END IF;
1874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);
1875:
1876: WHEN OTHERS THEN
1877: IF PG_DEBUG < 10 THEN
1878: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: UnExpected Error ' || sqlerrm );

Line 1880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory: UnExpected Error' || sqlerrm);

1876: WHEN OTHERS THEN
1877: IF PG_DEBUG < 10 THEN
1878: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: UnExpected Error ' || sqlerrm );
1879: END IF;
1880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory: UnExpected Error' || sqlerrm);
1881:
1882: END storeScoreHistory;
1883:
1884: /*

Line 1989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);

1985: WHEN FND_API.G_EXC_ERROR THEN
1986: IF PG_DEBUG < 10 THEN
1987: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm );
1988: END IF;
1989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);
1990:
1991: WHEN OTHERS THEN
1992: IF PG_DEBUG < 10 THEN
1993: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm );

Line 1995: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm);

1991: WHEN OTHERS THEN
1992: IF PG_DEBUG < 10 THEN
1993: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm );
1994: END IF;
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm);
1996:
1997: END storeDelBuffers;
1998:
1999:

Line 2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Exception selecting component detail range: WRONG ENGINE CONFIGURATION!!!!!');

2112: l_component_range_tbl.delete;
2113: -- Begin - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2114: EXCEPTION
2115: WHEN OTHERS THEN -- This will capture the exception from the component detail
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Exception selecting component detail range: WRONG ENGINE CONFIGURATION!!!!!');
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Score will be 1 - Execution will continue.');
2118: l_component_score := 1;
2119: END;
2120: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND

Line 2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Score will be 1 - Execution will continue.');

2113: -- Begin - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2114: EXCEPTION
2115: WHEN OTHERS THEN -- This will capture the exception from the component detail
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Exception selecting component detail range: WRONG ENGINE CONFIGURATION!!!!!');
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: get1Score: Score will be 1 - Execution will continue.');
2118: l_component_score := 1;
2119: END;
2120: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2121: END; -- end for exception

Line 2229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);

2225: WHEN FND_API.G_EXC_ERROR THEN
2226: IF PG_DEBUG < 10 THEN
2227: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Expected Error ' || sqlerrm );
2228: END IF;
2229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);
2230:
2231: WHEN OTHERS THEN
2232: IF PG_DEBUG < 10 THEN
2233: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm );

Line 2235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm);

2231: WHEN OTHERS THEN
2232: IF PG_DEBUG < 10 THEN
2233: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm );
2234: END IF;
2235: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm);
2236:
2237: END get1Score;
2238:
2239: --