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_LOG

Line 227: --iex_debug_pub.LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

223: /*-----------------------------------------------------------------------+
224: | Cursor Declarations |
225: +-----------------------------------------------------------------------*/
226: BEGIN
227: --iex_debug_pub.LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
228: FND_FILE.put_line( FND_FILE.LOG,'inside print_clob');
229:
230: LOOP
231: l_end :=

Line 294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

290:
291: BEGIN
292:
293: -- chk the score range
294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
295: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: score_id=' || p_score_id);
296: END IF;
297:
298: BEGIN

Line 306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

302: CLOSE c_chk_range;
303:
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN
306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
307: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting score range: ' || sqlerrm);
308: END IF;
309: l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;
310: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;

Line 314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

310: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;
311: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;
312: l_rule := IEX_SCORE_NEW_PVT.G_RULE;
313: WHEN OTHERS THEN
314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
315: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting scr range: ' || sqlerrm);
316: END IF;
317: l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;
318: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;

Line 323: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

319: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;
320: l_rule := IEX_SCORE_NEW_PVT.G_RULE;
321: END;
322:
323: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
324: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: weight:' || l_weight_required);
325: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: low:' || l_low);
326: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: high:' || l_high);
327: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: rule:' || l_rule);

Line 335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

331: IEX_SCORE_NEW_PVT.G_MIN_SCORE := l_low;
332: IEX_SCORE_NEW_PVT.G_MAX_SCORE := l_high;
333: IEX_SCORE_NEW_PVT.G_RULE := l_rule;
334:
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_weight:' || IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED);
337: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_low:' || IEX_SCORE_NEW_PVT.G_MIN_SCORE);
338: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_high:' || IEX_SCORE_NEW_PVT.G_MAX_SCORE);
339: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_rule:' || IEX_SCORE_NEW_PVT.G_RULE);

Line 399: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

395:
396: Begin
397:
398: -- IF PG_DEBUG < 10 THEN
399: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
400: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: getting Score Engine Components for Engine: ' || p_score_id);
401: END IF;
402:
403: OPEN c_score_components(p_score_id);

Line 419: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

415: --- End - Andre Araujo - 11/02/2004 - New storage mode, Scores_tbl becomes too big - TAR 4040621.994
416: END LOOP;
417:
418: -- IF PG_DEBUG < 10 THEN
419: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
420: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: components found ' || l_score_comp_tbl.count);
421: END IF;
422: x_score_comp_tbl := l_score_comp_tbl;
423:

Line 531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

527: l_api_name := 'getScores';
528: l_score_comp_tbl := p_score_comp_tbl;
529:
530: -- IF PG_DEBUG < 10 THEN
531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
532: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
533: END IF;
534: --
535: -- Api body

Line 546: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

542: l_bridge := l_del_buff_bridge; --Added by schekuri for bug#6373998 by schekuri on 31-Aug-2007
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge id ' || l_bridge);
544: l_universe_size := t_object_ids.count;
545: -- IF PG_DEBUG < 10 THEN
546: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
547: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Universe size is ' || l_universe_size);
548: END IF;
549:
550: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to

Line 568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

564:
565: FOR l_count IN 1..l_universe_size LOOP
566:
567: if PG_DEBUG <= 5 then
568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
569: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Scoring item ' || l_count || ' in universe');
570: END IF;
571: end if;
572: l_components_count := p_score_comp_tbl.count;

Line 667: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

663: -- -- initialize this to the minimum for any given component
664: -- --l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
665: --
666: -- if PG_DEBUG <= 5 then
667: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);
669: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);
670: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Bind Variable: ' || t_object_ids(l_count));
671: -- END IF;

Line 701: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

697: --
698: -- WHEN OTHERS THEN
699: -- -- figure out whether the component details are better higher or worse higher
700: -- IF PG_DEBUG <= 5 THEN
701: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
702: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Failed to calculate for component ' || l_score_component_id );
703: -- END IF;
704: -- SELECT Range_Low
705: -- BULK COLLECT INTO l_component_range_tbl

Line 722: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

718: --
719: -- END;
720: --
721: -- if PG_DEBUG <= 5 then
722: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
723: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Successfully calculated component score: ' || l_component_score);
724: -- END IF;
725: -- end if;
726: --

Line 741: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

737: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
738: -- ' :p_component_score >= RANGE_LOW AND ' ||
739: -- ' :p_component_score <= RANGE_HIGH ';
740: -- if PG_DEBUG <= 5 then
741: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
742: -- IEX_DEBUG_PUB.logMessage('getScores: ' || 'Getting Details for component with ' || vSQL);
743: -- END IF;
744: -- end if;
745: --

Line 753: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

749: -- --INTO l_raw_score
750: -- INTO l_value
751: -- USING l_score_component_id, l_component_score, l_component_score;
752: --
753: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
754: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || l_raw_score ||
755: -- ' Component weight is ' || l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT);
756: -- --END IF;
757: --

Line 761: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

757: --
758: --
759: -- -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11
760: --
761: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
762: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_value=' || l_value);
763: -- END IF;
764: -- -- chk the value is a formula or not
765: -- IF (INSTR(l_value, ':RESULT') > 0 ) THEN

Line 767: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

763: -- END IF;
764: -- -- chk the value is a formula or not
765: -- IF (INSTR(l_value, ':RESULT') > 0 ) THEN
766: -- l_new_value := replace(l_value, ':RESULT', l_component_score);
767: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
768: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
769: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
770: -- END IF;
771: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

Line 772: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

768: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
769: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
770: -- END IF;
771: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
772: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
773: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);
774: -- END IF;
775: -- Execute Immediate vSql
776: -- INTO l_raw_score;

Line 780: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

776: -- INTO l_raw_score;
777: -- ELSE
778: -- l_raw_score := TO_NUMBER( l_value);
779: -- END IF;
780: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
781: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_raw_score=' || l_raw_score);
782: -- END IF;
783: --
784: --

Line 795: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

791: -- ELSE
792: -- --l_running_score:=l_running_score + round(l_raw_score );
793: -- l_running_score:=l_running_score + round(l_raw_score,2 );
794: -- END IF;
795: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
796: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_running_score=' || l_running_score);
797: -- END IF;
798: -- -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
799: --

Line 804: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

800: -- /*
801: -- l_running_score:=l_running_score + round((l_raw_score * l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT));
802: -- */
803: --
804: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
805: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);
806: -- --END IF;
807: -- EXCEPTION
808: -- WHEN NO_DATA_FOUND THEN

Line 810: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

806: -- --END IF;
807: -- EXCEPTION
808: -- WHEN NO_DATA_FOUND THEN
809: -- IF PG_DEBUG < 10 THEN
810: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
811: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);
812: -- END IF;
813: -- l_running_score := l_running_score;
814: -- WHEN OTHERS THEN

Line 816: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

812: -- END IF;
813: -- l_running_score := l_running_score;
814: -- WHEN OTHERS THEN
815: -- IF PG_DEBUG < 10 THEN
816: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
817: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);
818: -- END IF;
819: -- l_running_score := l_running_score;
820: -- END;

Line 866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

862: elsif l_running_score > IEX_SCORE_NEW_PVT.G_MAX_SCORE then
863: l_running_score := IEX_SCORE_NEW_PVT.G_MIN_SCORE;
864: end if;
865: END IF;
866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
867: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: score:' || l_running_score);
868: END IF;
869: -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
870: --Begin Bug 8933776 30-Nov-2009 barathsr

Line 900: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

896: if t_object_code<>'IEX_INVOICES' then
897: storeScoreHistory ( l_score_comp_tbl(1).SCORE_ID, l_objects_tbl, l_new_scores_tbl );
898: end if;
899: end if;
900: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
901: IEX_DEBUG_PUB.logMessage('IEX_STORE_PS_SCORE: getScores:Profile:Store Score Histories for Transactions: ' ||t_prf_score_trans);
902: END IF;
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile:Store Score Histories for Transactions: '||t_prf_score_trans);
904: --end bug 13426796 by sunagesh on 25-11-2011

Line 944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

940: if t_object_code<>'IEX_INVOICES' then
941: storeScoreHistory ( l_score_comp_tbl(1).SCORE_ID, l_objects_tbl, l_new_scores_tbl );
942: end if;
943: end if;
944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
945: IEX_DEBUG_PUB.logMessage('IEX_STORE_PS_SCORE: getScores:Profile:Store Score Histories for Transactions: ' ||t_prf_score_trans);
946: END IF;
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile:Store Score Histories for Transactions: '||t_prf_score_trans);
948: --end bug 13426796 by sunagesh on 25-11-2011

Line 967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

963:
964: x_scores_tbl := l_scores_tbl;
965:
966: -- IF PG_DEBUG < 10 THEN
967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
968: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
969: END IF;
970:
971: Exception

Line 1095: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1096: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1097: END IF;
1098:
1099: -- Initialize API return status to SUCCESS

Line 1161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1157: iex_score_new_pvt.getComponents(p_score_id => p_score_id ,
1158: X_SCORE_COMP_TBL => l_components_tbl);
1159:
1160: if l_components_tbl is null or l_components_tbl.count < 1 then
1161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1162: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: No score components for engine');
1163: END IF;
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: No score components for engine ' || p_score_id);
1165: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE_ENG_COMPONENTS');

Line 1177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: end if;
1176:
1177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1178: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
1179: END IF;
1180:
1181: l_user := FND_GLOBAL.USER_ID;

Line 1257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1253:
1254:
1255: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007
1256: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');
1257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1258: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');
1259: END IF;
1260:
1261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1258: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');
1259: END IF;
1260:
1261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1262: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: building Universe');
1263: END IF;
1264:
1265:

Line 1281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1277:
1278: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: last object ' || l_last_obj_scored);
1279:
1280: if (l_universe is null or l_universe.count < 1) and not l_last_batch then
1281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1282: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Universe size is zero');
1283: END IF;
1284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero or Invalid for Engine ' || p_score_id);
1285:

Line 1347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1343: IF (IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED = 'Y') Then
1344: FOR i in 1..l_components_tbl.count
1345: LOOP
1346: if (l_components_tbl(i).score_comp_weight is null) then
1347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1348: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no comp weight');
1349: END IF;
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,
1351: 'Score Comp Weight are required for Engine '|| p_score_id);

Line 1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1381:
1382:
1383: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Completed Scoring ' || ' objects of type ' || l_object_type);
1384: Begin
1385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1386: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Finding any process to spawn...');
1387: END IF;
1388: Select NVL(cp.Concurrent_Program_Name, 'X')
1389: Into l_conc_prog_name

Line 1408: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1404: --- End - LKKUMAR - 13-Apr-2006. Replace the SQL with MAX. --Bug5154199.
1405:
1406: -- spawn proces if conc_prog_id is there
1407: if l_conc_prog_name <> 'X' then
1408: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1409: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name ||
1410: ' with bridge ' || l_bridge);
1411: END IF;
1412:

Line 1416: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1412:
1413: --Start MOAC
1414: fnd_request.set_org_id(mo_global.get_current_org_id);
1415:
1416: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1417: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name || ' for operating unit: ' ||
1418: nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
1419: END IF;
1420: --End MOAC

Line 1471: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: Launched cp '
1468: || l_submit_request_id || ' successfully');
1469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' ||
1470: nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added OU Name for MOAC
1471: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1472: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: process spawned '
1473: || l_submit_request_id);
1474: END IF;
1475:

Line 1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1476: end if; --if conc_process is not 'X'
1477: Exception
1478: WHEN NO_DATA_FOUND THEN
1479:
1480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1481: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no process spawned');
1482: END IF;
1483: NULL;
1484: End;

Line 1495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1491: THEN
1492: COMMIT WORK;
1493: END IF;
1494:
1495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1496: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'PUB: ' || l_api_name || ' end');
1497: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1498: END IF;
1499:

Line 1512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1508: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '***close score details body***');
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1513: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ROLLBACK TO scoreObjects_PVT;

Line 1519: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1515: RAISE FND_API.G_EXC_ERROR;
1516: ROLLBACK TO scoreObjects_PVT;
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1520: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ROLLBACK TO scoreObjects_PVT;

Line 1530: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1526:
1527: WHEN IEX_UNIVERSE_SIZE_ZERO_ERROR THEN
1528: ROLLBACK TO scoreObjects_PVT;
1529: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1530: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1531: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: iex universe size zero Error ' || x_msg_data);
1532: END IF;
1533:
1534: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;

Line 1537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1533:
1534: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;
1535:
1536: WHEN OTHERS THEN
1537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1538: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Other Error ' || sqlerrm);
1539: END IF;
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: ROLLBACK TO scoreObjects_PVT;

Line 1720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1716:
1717: ---end moac
1718:
1719: -- IF PG_DEBUG < 10 THEN
1720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1721: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Scoring Harness Accessed');
1722: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1723: END IF;
1724: select TO_CHAR(sysdate,'YYYY-MM-DD')

Line 1831: iex_debug_pub.LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-'||sqlerrm);

1827: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');
1828: exception
1829: when others then
1830: FND_FILE.put_line( FND_FILE.LOG,'err in xml header-->'||sqlerrm);
1831: iex_debug_pub.LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || '-'||sqlerrm);
1832: end;
1833: --End Bug 8933776 30-Nov-2009 barathsr
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch Size: ' || G_BATCH_SIZE);

Line 1869: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1865: -- note do not set retcode when error is expected
1866: WHEN FND_API.G_EXC_ERROR THEN
1867: RETCODE := -1;
1868: ERRBUF := l_msg_data;
1869: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1870: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);
1871: END IF;
1872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);
1873:

Line 1876: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);
1873:
1874: -- START -jsanju 10/19/05 , set concurrent status to 'WARNING' if universe size exception occurs for bug 3549051
1875: WHEN IEX_UNIVERSE_SIZE_ZERO_ERROR THEN
1876: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1877: IEX_DEBUG_PUB.logMessage('IEX_SCORE: universe size is zero ' || l_msg_data);
1878: END IF;
1879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Universe Size is Zero ');
1880: request_status := fnd_concurrent.set_completion_status('WARNING'

Line 1888: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1884:
1885: WHEN OTHERS THEN
1886: RETCODE := -1;
1887: ERRBUF := l_msg_data;
1888: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1889: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
1890: END IF;
1891: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm || ERRBUF);
1892: END;

Line 1915: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1911: -- Fnd_File.PUT_line(FND_FILE.LOG,substr(tempResult,1,length(tempResult)));
1912: FND_FILE.PUT_LINE(FND_FILE.LOG,'3');
1913:
1914: -- IF PG_DEBUG < 10 THEN
1915: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1916: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'Return status is ' || l_return_status);
1917: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1918: END IF;
1919: Exception

Line 1924: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1920:
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: RETCODE := -1;
1923: ERRBUF := l_msg_data;
1924: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1925: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm);
1926: END IF;
1927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1928:

Line 1932: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1928:
1929: WHEN OTHERS THEN
1930: RETCODE := -1;
1931: ERRBUF := l_msg_data;
1932: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1933: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
1934: END IF;
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1936: END SCORE_CONCUR;

Line 2037: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2033: vSelectCount := 'select count(1) from iex_score_histories ';
2034:
2035:
2036: -- IF PG_DEBUG < 10 THEN
2037: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2038: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores');
2039: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2040: END IF;
2041:

Line 2125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2121: -- Andre Added
2122: vWhereClause := VPLSQL2;
2123:
2124: -- IF PG_DEBUG < 10 THEN
2125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2126: IEX_DEBUG_PUB.logMessage(vPLSQL2);
2127: END IF;
2128:
2129: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007

Line 2273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2269: END;
2270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);
2271:
2272: -- IF PG_DEBUG < 10 THEN
2273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2274: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2275: END IF;
2276: Exception
2277: WHEN FND_API.G_EXC_ERROR THEN

Line 2281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2277: WHEN FND_API.G_EXC_ERROR THEN
2278: RETCODE := -1;
2279: ERRBUF := l_msg_data;
2280: -- IF PG_DEBUG < 10 THEN
2281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2282: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm );
2283: END IF;
2284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
2285:

Line 2290: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2286: WHEN OTHERS THEN
2287: RETCODE := -1;
2288: ERRBUF := l_msg_data;
2289: -- IF PG_DEBUG < 10 THEN
2290: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2291: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);
2292: END IF;
2293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
2294: --dbms_output.put_line(sqlerrm);

Line 2348: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2344: vSqlCur varchar2(1000);
2345:
2346: BEGIN
2347: -- IF PG_DEBUG < 10 THEN
2348: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2349: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2350: END IF;
2351:
2352: --clchang updated 10/29/04 no default values in declare

Line 2394: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2390: end if;
2391: vPLSQL := IEX_UTILITIES.buildWhereClause(l_conditions);
2392:
2393: -- IF PG_DEBUG < 10 THEN
2394: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2395: IEX_DEBUG_PUB.logMessage(vPLSQL);
2396: END IF;
2397: --dbms_output.put_line(vPLSQL);
2398:

Line 2426: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2422:
2423: return l_score_hist_tbl;
2424:
2425: -- IF PG_DEBUG < 10 THEN
2426: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2427: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2428: END IF;
2429:
2430: Exception

Line 2433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2429:
2430: Exception
2431: WHEN FND_API.G_EXC_ERROR THEN
2432: -- IF PG_DEBUG < 10 THEN
2433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2434: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Expected Error ' || sqlerrm );
2435: END IF;
2436: RETURN l_score_hist_tbl;
2437:

Line 2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2436: RETURN l_score_hist_tbl;
2437:
2438: WHEN OTHERS THEN
2439: -- IF PG_DEBUG < 10 THEN
2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2441: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: UnExpected Error ' || sqlerrm );
2442: END IF;
2443: RETURN l_score_hist_tbl;
2444:

Line 2876: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2872: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
2873: ' :p_component_score >= RANGE_LOW AND ' ||
2874: ' :p_component_score <= RANGE_HIGH ';
2875: if PG_DEBUG <= 5 then
2876: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2877: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: ' || 'Getting Details for component with ' || vSQL);
2878: END IF;
2879: end if;
2880:

Line 2888: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2884: --INTO l_raw_score
2885: INTO l_value
2886: USING l_score_component_id, l_component_score, l_component_score;
2887:
2888: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2889: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || l_raw_score ||
2890: --' Component weight is ' || l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT);
2891: --END IF;
2892:

Line 2895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2891: --END IF;
2892:
2893: -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11
2894:
2895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2896: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_value=' || l_value);
2897: END IF;
2898: -- chk the value is a formula or not
2899: IF (INSTR(l_value, ':RESULT') > 0 ) THEN

Line 2901: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2897: END IF;
2898: -- chk the value is a formula or not
2899: IF (INSTR(l_value, ':RESULT') > 0 ) THEN
2900: l_new_value := replace(l_value, ':RESULT', l_component_score);
2901: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2902: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2903: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2904: END IF;
2905: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

Line 2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2902: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2903: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2904: END IF;
2905: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2907: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);
2908: END IF;
2909: Execute Immediate vSql
2910: INTO l_raw_score;

Line 2914: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2910: INTO l_raw_score;
2911: ELSE
2912: l_raw_score := TO_NUMBER( l_value);
2913: END IF;
2914: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2915: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_raw_score=' || l_raw_score);
2916: END IF;
2917:
2918: l_xml_body_1:=l_xml_body_1||l_new_line||''||l_raw_score||'';--Added for Bug 8933776 30-Nov-2009 barathsr

Line 2932: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2928: --l_running_score:=l_running_score + round(l_raw_score );
2929: l_wtg_com_score:=round(l_raw_score,2);
2930: l_running_score:=l_running_score + round(l_raw_score,2 );
2931: END IF;
2932: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2933: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_running_score=' || l_running_score);
2934: END IF;
2935: --Begin Bug 8933776 30-Nov-2009 barathsr
2936: l_xml_body_1:=l_xml_body_1||l_new_line||''||l_wtg_com_score||'';

Line 3037: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3033:
3034:
3035: BEGIN
3036: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
3037: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3038:
3039: G_MIN_SCORE := '1';
3040: G_MAX_SCORE := '100';
3041: G_RULE := 'CLOSEST';