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 191: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

187:
188: BEGIN
189:
190: -- chk the score range
191: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
192: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: score_id=' || p_score_id);
193: END IF;
194:
195: BEGIN

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

199: CLOSE c_chk_range;
200:
201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN
203: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
204: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting score range: ' || sqlerrm);
205: END IF;
206: l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;
207: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;

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

207: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;
208: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;
209: l_rule := IEX_SCORE_NEW_PVT.G_RULE;
210: WHEN OTHERS THEN
211: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
212: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting scr range: ' || sqlerrm);
213: END IF;
214: l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;
215: l_low := IEX_SCORE_NEW_PVT.G_MIN_SCORE;

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

216: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;
217: l_rule := IEX_SCORE_NEW_PVT.G_RULE;
218: END;
219:
220: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
221: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: weight:' || l_weight_required);
222: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: low:' || l_low);
223: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: high:' || l_high);
224: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: rule:' || l_rule);

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

228: IEX_SCORE_NEW_PVT.G_MIN_SCORE := l_low;
229: IEX_SCORE_NEW_PVT.G_MAX_SCORE := l_high;
230: IEX_SCORE_NEW_PVT.G_RULE := l_rule;
231:
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_weight:' || IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED);
234: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_low:' || IEX_SCORE_NEW_PVT.G_MIN_SCORE);
235: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_high:' || IEX_SCORE_NEW_PVT.G_MAX_SCORE);
236: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_rule:' || IEX_SCORE_NEW_PVT.G_RULE);

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

291:
292: Begin
293:
294: -- IF PG_DEBUG < 10 THEN
295: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
296: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: getting Score Engine Components for Engine: ' || p_score_id);
297: END IF;
298:
299: OPEN c_score_components(p_score_id);

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

311: --- End - Andre Araujo - 11/02/2004 - New storage mode, Scores_tbl becomes too big - TAR 4040621.994
312: END LOOP;
313:
314: -- IF PG_DEBUG < 10 THEN
315: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
316: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: components found ' || l_score_comp_tbl.count);
317: END IF;
318: x_score_comp_tbl := l_score_comp_tbl;
319:

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

414: l_api_name := 'getScores';
415: l_score_comp_tbl := p_score_comp_tbl;
416:
417: -- IF PG_DEBUG < 10 THEN
418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
419: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
420: END IF;
421: --
422: -- Api body

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

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);
435: END IF;
436:
437: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to

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

451:
452: FOR l_count IN 1..l_universe_size LOOP
453:
454: if PG_DEBUG <= 5 then
455: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
456: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Scoring item ' || l_count || ' in universe');
457: END IF;
458: end if;
459: l_components_count := p_score_comp_tbl.count;

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

470: -- -- initialize this to the minimum for any given component
471: -- --l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
472: --
473: -- if PG_DEBUG <= 5 then
474: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
475: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);
476: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);
477: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Bind Variable: ' || t_object_ids(l_count));
478: -- END IF;

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

504: --
505: -- WHEN OTHERS THEN
506: -- -- figure out whether the component details are better higher or worse higher
507: -- IF PG_DEBUG <= 5 THEN
508: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
509: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Failed to calculate for component ' || l_score_component_id );
510: -- END IF;
511: -- SELECT Range_Low
512: -- BULK COLLECT INTO l_component_range_tbl

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

525: --
526: -- END;
527: --
528: -- if PG_DEBUG <= 5 then
529: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
530: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Successfully calculated component score: ' || l_component_score);
531: -- END IF;
532: -- end if;
533: --

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

544: -- ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
545: -- ' :p_component_score >= RANGE_LOW AND ' ||
546: -- ' :p_component_score <= RANGE_HIGH ';
547: -- if PG_DEBUG <= 5 then
548: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
549: -- IEX_DEBUG_PUB.logMessage('getScores: ' || 'Getting Details for component with ' || vSQL);
550: -- END IF;
551: -- end if;
552: --

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

556: -- --INTO l_raw_score
557: -- INTO l_value
558: -- USING l_score_component_id, l_component_score, l_component_score;
559: --
560: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
561: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || l_raw_score || ' Component weight is ' || l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT);
562: -- --END IF;
563: --
564: --

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

563: --
564: --
565: -- -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11
566: --
567: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
568: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_value=' || l_value);
569: -- END IF;
570: -- -- chk the value is a formula or not
571: -- IF (INSTR(l_value, ':RESULT') > 0 ) THEN

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

569: -- END IF;
570: -- -- chk the value is a formula or not
571: -- IF (INSTR(l_value, ':RESULT') > 0 ) THEN
572: -- l_new_value := replace(l_value, ':RESULT', l_component_score);
573: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
574: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
575: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
576: -- END IF;
577: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

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

574: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
575: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
576: -- END IF;
577: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
578: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
579: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);
580: -- END IF;
581: -- Execute Immediate vSql
582: -- INTO l_raw_score;

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

582: -- INTO l_raw_score;
583: -- ELSE
584: -- l_raw_score := TO_NUMBER( l_value);
585: -- END IF;
586: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
587: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_raw_score=' || l_raw_score);
588: -- END IF;
589: --
590: --

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

597: -- ELSE
598: -- --l_running_score:=l_running_score + round(l_raw_score );
599: -- l_running_score:=l_running_score + round(l_raw_score,2 );
600: -- END IF;
601: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
602: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_running_score=' || l_running_score);
603: -- END IF;
604: -- -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
605: --

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

606: -- /*
607: -- l_running_score:=l_running_score + round((l_raw_score * l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT));
608: -- */
609: --
610: -- --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
611: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);
612: -- --END IF;
613: -- EXCEPTION
614: -- WHEN NO_DATA_FOUND THEN

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

612: -- --END IF;
613: -- EXCEPTION
614: -- WHEN NO_DATA_FOUND THEN
615: -- IF PG_DEBUG < 10 THEN
616: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
617: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);
618: -- END IF;
619: -- l_running_score := l_running_score;
620: -- WHEN OTHERS THEN

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

618: -- END IF;
619: -- l_running_score := l_running_score;
620: -- WHEN OTHERS THEN
621: -- IF PG_DEBUG < 10 THEN
622: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
623: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);
624: -- END IF;
625: -- l_running_score := l_running_score;
626: -- END;

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

668: elsif l_running_score > IEX_SCORE_NEW_PVT.G_MAX_SCORE then
669: l_running_score := IEX_SCORE_NEW_PVT.G_MIN_SCORE;
670: end if;
671: END IF;
672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: score:' || l_running_score);
674: END IF;
675: -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
676:

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

713:
714: x_scores_tbl := l_scores_tbl;
715:
716: -- IF PG_DEBUG < 10 THEN
717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
718: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
719: END IF;
720:
721: Exception

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

807: IF FND_API.to_Boolean( p_init_msg_list ) THEN
808: FND_MSG_PUB.initialize;
809: END IF;
810:
811: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
812: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
813: END IF;
814:
815: -- Initialize API return status to SUCCESS

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

828: iex_score_new_pvt.getComponents(p_score_id => p_score_id ,
829: X_SCORE_COMP_TBL => l_components_tbl);
830:
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');

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

837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: end if;
840:
841: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
842: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');
843: END IF;
844:
845: l_user := FND_GLOBAL.USER_ID;

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

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:
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

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:
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
858: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: building Universe');
859: END IF;
860:
861:

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

871:
872: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: last object ' || l_last_obj_scored);
873:
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:

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

895: IF (IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED = 'Y') Then
896: FOR i in 1..l_components_tbl.count
897: LOOP
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);

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

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;
927: Select NVL(cp.Concurrent_Program_Name, 'X')
928: Into l_conc_prog_name

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

942: --- End - LKKUMAR - 13-Apr-2006. Replace the SQL with MAX. --Bug5154199.
943:
944: -- spawn proces if conc_prog_id is there
945: if l_conc_prog_name <> 'X' then
946: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
947: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name ||
948: ' with bridge ' || l_bridge);
949: END IF;
950:

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

950:
951: --Start MOAC
952: fnd_request.set_org_id(mo_global.get_current_org_id);
953:
954: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
955: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name || ' for operating unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
956: END IF;
957: --End MOAC
958:

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

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;
1011:

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

1012: end if; --if conc_process is not 'X'
1013: Exception
1014: WHEN NO_DATA_FOUND THEN
1015:
1016: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1017: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no process spawned');
1018: END IF;
1019: NULL;
1020: End;

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

1027: THEN
1028: COMMIT WORK;
1029: END IF;
1030:
1031: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1032: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'PUB: ' || l_api_name || ' end');
1033: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1034: END IF;
1035:

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

1038: p_data => x_msg_data);
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1043: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1044: END IF;
1045: RAISE FND_API.G_EXC_ERROR;
1046: ROLLBACK TO scoreObjects_PVT;

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

1045: RAISE FND_API.G_EXC_ERROR;
1046: ROLLBACK TO scoreObjects_PVT;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1050: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1051: END IF;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ROLLBACK TO scoreObjects_PVT;

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

1056:
1057: WHEN IEX_UNIVERSE_SIZE_ZERO_ERROR THEN
1058: ROLLBACK TO scoreObjects_PVT;
1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1060: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1061: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: iex universe size zero Error ' || x_msg_data);
1062: END IF;
1063:
1064: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;

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

1063:
1064: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;
1065:
1066: WHEN OTHERS THEN
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Other Error ' || sqlerrm);
1069: END IF;
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: ROLLBACK TO scoreObjects_PVT;

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

1224:
1225: ---end moac
1226:
1227: -- IF PG_DEBUG < 10 THEN
1228: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1229: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Scoring Harness Accessed');
1230: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1231: END IF;
1232:

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

1270: -- note do not set retcode when error is expected
1271: WHEN FND_API.G_EXC_ERROR THEN
1272: RETCODE := -1;
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:

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

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
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'

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

1289:
1290: WHEN OTHERS THEN
1291: RETCODE := -1;
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;

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

1299: end if;
1300: end loop;
1301:
1302: -- IF PG_DEBUG < 10 THEN
1303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1304: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'Return status is ' || l_return_status);
1305: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1306: END IF;
1307: Exception

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

1308:
1309: WHEN FND_API.G_EXC_ERROR THEN
1310: RETCODE := -1;
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:

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

1316:
1317: WHEN OTHERS THEN
1318: RETCODE := -1;
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;

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

1414: vSelectCount := 'select count(1) from iex_score_histories ';
1415:
1416:
1417: -- IF PG_DEBUG < 10 THEN
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1419: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores');
1420: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1421: END IF;
1422:

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

1493: -- Andre Added
1494: vWhereClause := VPLSQL2;
1495:
1496: -- IF PG_DEBUG < 10 THEN
1497: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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

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

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'));
1600: END IF;
1601: Exception
1602: WHEN FND_API.G_EXC_ERROR THEN

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

1602: WHEN FND_API.G_EXC_ERROR THEN
1603: RETCODE := -1;
1604: ERRBUF := l_msg_data;
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:

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

1611: WHEN OTHERS THEN
1612: RETCODE := -1;
1613: ERRBUF := l_msg_data;
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);

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

1669: vSqlCur varchar2(1000);
1670:
1671: BEGIN
1672: -- IF PG_DEBUG < 10 THEN
1673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1674: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1675: END IF;
1676:
1677: --clchang updated 10/29/04 no default values in declare

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

1715: end if;
1716: vPLSQL := IEX_UTILITIES.buildWhereClause(l_conditions);
1717:
1718: -- IF PG_DEBUG < 10 THEN
1719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1720: IEX_DEBUG_PUB.logMessage(vPLSQL);
1721: END IF;
1722: --dbms_output.put_line(vPLSQL);
1723:

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

1747:
1748: return l_score_hist_tbl;
1749:
1750: -- IF PG_DEBUG < 10 THEN
1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1753: END IF;
1754:
1755: Exception

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

1754:
1755: Exception
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: -- IF PG_DEBUG < 10 THEN
1758: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1759: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Expected Error ' || sqlerrm );
1760: END IF;
1761: RETURN l_score_hist_tbl;
1762:

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

1761: RETURN l_score_hist_tbl;
1762:
1763: WHEN OTHERS THEN
1764: -- IF PG_DEBUG < 10 THEN
1765: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1766: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: UnExpected Error ' || sqlerrm );
1767: END IF;
1768: RETURN l_score_hist_tbl;
1769:

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

2137: ' WHERE SCORE_COMPONENT_ID = :p_score_comp_id AND ' ||
2138: ' :p_component_score >= RANGE_LOW AND ' ||
2139: ' :p_component_score <= RANGE_HIGH ';
2140: if PG_DEBUG <= 5 then
2141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2142: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: ' || 'Getting Details for component with ' || vSQL);
2143: END IF;
2144: end if;
2145:

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

2149: --INTO l_raw_score
2150: INTO l_value
2151: USING l_score_component_id, l_component_score, l_component_score;
2152:
2153: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2154: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || l_raw_score || ' Component weight is ' || l_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT);
2155: --END IF;
2156:
2157: -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11

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

2155: --END IF;
2156:
2157: -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11
2158:
2159: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2160: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_value=' || l_value);
2161: END IF;
2162: -- chk the value is a formula or not
2163: IF (INSTR(l_value, ':RESULT') > 0 ) THEN

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

2161: END IF;
2162: -- chk the value is a formula or not
2163: IF (INSTR(l_value, ':RESULT') > 0 ) THEN
2164: l_new_value := replace(l_value, ':RESULT', l_component_score);
2165: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2166: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2167: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2168: END IF;
2169: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

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

2166: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2167: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2168: END IF;
2169: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
2170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2171: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);
2172: END IF;
2173: Execute Immediate vSql
2174: INTO l_raw_score;

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

2174: INTO l_raw_score;
2175: ELSE
2176: l_raw_score := TO_NUMBER( l_value);
2177: END IF;
2178: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2179: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_raw_score=' || l_raw_score);
2180: END IF;
2181:
2182:

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

2189: ELSE
2190: --l_running_score:=l_running_score + round(l_raw_score );
2191: l_running_score:=l_running_score + round(l_raw_score,2 );
2192: END IF;
2193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2194: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_running_score=' || l_running_score);
2195: END IF;
2196: -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
2197:

Line 2246: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2242:
2243:
2244: BEGIN
2245: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2246: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2247:
2248: G_MIN_SCORE := '1';
2249: G_MAX_SCORE := '100';
2250: G_RULE := 'CLOSEST';