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 IEX_DEBUG_PUB

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 295: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: score_id=' || p_score_id);

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
299: OPEN c_chk_range(p_score_id);

Line 307: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting score range: ' || sqlerrm);

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;
311: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;

Line 315: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: Error getting scr range: ' || sqlerrm);

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;
319: l_high := IEX_SCORE_NEW_PVT.G_MAX_SCORE;

Line 324: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: weight:' || l_weight_required);

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);
328: END IF;

Line 325: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: low:' || l_low);

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);
328: END IF;
329:

Line 326: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: high:' || l_high);

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);
328: END IF;
329:
330: IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED := l_weight_required;

Line 327: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: rule:' || l_rule);

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);
328: END IF;
329:
330: IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED := l_weight_required;
331: IEX_SCORE_NEW_PVT.G_MIN_SCORE := l_low;

Line 336: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_weight:' || IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED);

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);
340: END IF;

Line 337: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_low:' || IEX_SCORE_NEW_PVT.G_MIN_SCORE);

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);
340: END IF;
341:

Line 338: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_high:' || IEX_SCORE_NEW_PVT.G_MAX_SCORE);

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);
340: END IF;
341:
342: END getScoreRange;

Line 339: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreRange: g_rule:' || IEX_SCORE_NEW_PVT.G_RULE);

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);
340: END IF;
341:
342: END getScoreRange;
343:

Line 400: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: getting Score Engine Components for Engine: ' || p_score_id);

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);
404: LOOP

Line 420: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getComponents: components found ' || l_score_comp_tbl.count);

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:
424: CLOSE c_score_components;

Line 532: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
536: --

Line 547: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Universe size is ' || l_universe_size);

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
551: Begin -- This will be an exception block

Line 569: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Scoring item ' || l_count || ' in universe');

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;
573: l_running_score := 0;

Line 635: IEX_DEBUG_PUB.logMessage('error in get scores in getting jtf obj details'||sqlerrm);

631: --Commented to fix 12711600 SNUTHALA 5/JUL/11
632: exception
633: when others then
634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in get scores in getting jtf obj details'||sqlerrm);
635: IEX_DEBUG_PUB.logMessage('error in get scores in getting jtf obj details'||sqlerrm);
636: end;
637: --Begin fix 12711600 SNUTHALA 5/JUL/11
638: l_xml_body_2:=l_new_line||'';
639:

Line 668: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);

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;
672: -- end if;

Line 669: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);

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;
672: -- end if;
673: --

Line 670: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Bind Variable: ' || t_object_ids(l_count));

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;
672: -- end if;
673: --
674: -- /* executing dynamic sql for component */

Line 702: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Failed to calculate for component ' || l_score_component_id );

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
706: -- FROM iex_score_comp_det

Line 723: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Successfully calculated component score: ' || l_component_score);

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: --
727: -- end if;

Line 742: -- IEX_DEBUG_PUB.logMessage('getScores: ' || 'Getting Details for component with ' || vSQL);

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: --
746: -- -- clchang updated 10/18/04 for 11.5.11

Line 754: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || 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: --
758: --

Line 762: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_value=' || l_value);

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
766: -- l_new_value := replace(l_value, ':RESULT', l_component_score);

Line 768: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');

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

Line 769: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);

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';
772: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
773: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);

Line 773: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);

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;
777: -- ELSE

Line 781: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_raw_score=' || 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: --
785: -- l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;

Line 796: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_running_score=' || l_running_score);

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: --
800: -- /*

Line 805: -- --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);

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
809: -- IF PG_DEBUG < 10 THEN

Line 811: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);

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
815: -- IF PG_DEBUG < 10 THEN

Line 817: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Error getting component detail: ' || sqlerrm);

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

Line 867: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: score:' || l_running_score);

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
871: l_xml_body_2:=l_new_line||'';

Line 901: IEX_DEBUG_PUB.logMessage('IEX_STORE_PS_SCORE: getScores:Profile:Store Score Histories for Transactions: ' ||t_prf_score_trans);

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
905: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to

Line 945: IEX_DEBUG_PUB.logMessage('IEX_STORE_PS_SCORE: getScores:Profile:Store Score Histories for Transactions: ' ||t_prf_score_trans);

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
949: -- Begin - Andre Araujo - 12/17/2004 - Store del_buffers only if we need to

Line 968: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
972:

Line 1096: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1153: IEX_DEBUG_PUB.logMessage('error in score objects in getting score details'||sqlerrm);

1149: l_xml_body:= l_xml_body||l_new_line||'';
1150: exception
1151: when others then
1152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in score objects in getting score details'||sqlerrm);
1153: IEX_DEBUG_PUB.logMessage('error in score objects in getting score details'||sqlerrm);
1154: end;
1155: --End Bug 8933776 30-Nov-2009 barathsr
1156: -- enumerate components for this scoring engine
1157: iex_score_new_pvt.getComponents(p_score_id => p_score_id ,

Line 1162: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: No score components for engine');

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');
1166: --Begin Bug 8933776 30-Nov-2009 barathsr

Line 1178: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');

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;
1182: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

Line 1214: IEX_DEBUG_PUB.logMessage('error in score objects in getting score component details'||sqlerrm);

1210: l_xml_body:= l_xml_body||l_new_line||''||format_string(l_score_comp_val)||'';
1211: exception
1212: when others then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in score objects in getting score component details'||sqlerrm);
1214: IEX_DEBUG_PUB.logMessage('error in score objects in getting score component details'||sqlerrm);
1215: end;
1216:
1217:
1218: begin

Line 1245: IEX_DEBUG_PUB.logMessage('error in score objects in getting score component cnt/range details'||sqlerrm);

1241: l_xml_body:= l_xml_body||l_new_line||'';
1242: exception
1243: when others then
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in score objects in getting score component cnt/range details'||sqlerrm);
1245: IEX_DEBUG_PUB.logMessage('error in score objects in getting score component cnt/range details'||sqlerrm);
1246: end;
1247: end loop;
1248: end if;
1249:

Line 1258: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');

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
1262: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: building Universe');

Line 1262: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: building Universe');

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:
1266:

Line 1278: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: last object ' || l_last_obj_scored);

1274: p_object_type => 'IEXSCORE',
1275: p_last_object_scored => l_last_obj_scored,
1276: x_end_of_universe => l_last_batch);
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');

Line 1282: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Universe size is zero');

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:
1286: FND_MESSAGE.Set_Name('IEX', 'IEX_UNIVERSE_SIZE_ZERO');

Line 1348: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no comp weight');

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);
1352: FND_MESSAGE.Set_Name('IEX', 'IEX_WEIGHT_REQUIRED');

Line 1386: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Finding any process to spawn...');

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
1390: From IEX_SCORES scr, fnd_concurrent_programs cp

Line 1409: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name ||

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:
1413: --Start MOAC

Line 1417: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: spawning ' || l_conc_prog_name || ' for operating unit: ' ||

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
1421:

Line 1472: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: process spawned '

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:
1476: end if; --if conc_process is not 'X'

Line 1481: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: no process spawned');

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

Line 1496: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'PUB: ' || l_api_name || ' end');

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:
1500: FND_MSG_PUB.Count_And_Get

Line 1497: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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:
1500: FND_MSG_PUB.Count_And_Get
1501: (p_count => x_msg_count,

Line 1513: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);

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

Line 1520: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);

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

Line 1531: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: iex universe size zero Error ' || x_msg_data);

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

Line 1538: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Other Error ' || sqlerrm);

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

Line 1721: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Scoring Harness Accessed');

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')
1725: into l_sysdate

Line 1722: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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')
1725: into l_sysdate
1726: from dual;

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 1870: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);

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:
1874: -- START -jsanju 10/19/05 , set concurrent status to 'WARNING' if universe size exception occurs for bug 3549051

Line 1877: IEX_DEBUG_PUB.logMessage('IEX_SCORE: universe size is zero ' || l_msg_data);

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'
1881: , 'Universe size is zero');

Line 1889: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);

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

Line 1916: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'Return status is ' || l_return_status);

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
1920:

Line 1917: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
1920:
1921: WHEN FND_API.G_EXC_ERROR THEN

Line 1925: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm);

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:
1929: WHEN OTHERS THEN

Line 1933: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);

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

Line 2038: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores');

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:
2042: /* build where clause */

Line 2039: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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:
2042: /* build where clause */
2043: if P_SCORE_OBJECT_ID IS NOT NULL then

Line 2126: IEX_DEBUG_PUB.logMessage(vPLSQL2);

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
2130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SELECT SCORE_HISTORY_ID ' ||

Line 2172: IEX_DEBUG_PUB.logMessage('Schema:'||l_prod);

2168:
2169:
2170: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_prod);
2171:
2172: IEX_DEBUG_PUB.logMessage('Schema:'||l_prod);
2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');
2174:
2175:
2176: ad_ddl.do_ddl( l_prod,

Line 2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');

2169:
2170: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_prod);
2171:
2172: IEX_DEBUG_PUB.logMessage('Schema:'||l_prod);
2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');
2174:
2175:
2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',

Line 2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');

2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');
2183:
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');
2185: --Start bug 8605501 gnramasa 20th Oct 09
2186: BEGIN

Line 2274: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
2278: RETCODE := -1;

Line 2282: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm );

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:
2286: WHEN OTHERS THEN

Line 2291: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Unexpected Error ' || sqlerrm);

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);
2295:

Line 2349: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
2353: l_total := 0;

Line 2395: IEX_DEBUG_PUB.logMessage(vPLSQL);

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:
2399: /* execute history query and fetch */

Line 2427: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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
2431: WHEN FND_API.G_EXC_ERROR THEN

Line 2434: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Expected Error ' || sqlerrm );

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:
2438: WHEN OTHERS THEN

Line 2441: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: UnExpected Error ' || sqlerrm );

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:
2445: END getScoreHistory;

Line 2483: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );

2479: l_org_id NUMBER; -- added for bug 13335079 pnaveenk
2480:
2481: BEGIN
2482: IF PG_DEBUG < 10 THEN
2483: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
2484: END IF;
2485:
2486: l_user := FND_GLOBAL.USER_ID;
2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

Line 2496: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: p_score_id= ' || p_score_id ||

2492: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
2493:
2494: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2495: IF PG_DEBUG < 10 THEN
2496: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: p_score_id= ' || p_score_id ||
2497: ' ; Number of scores= ' || p_scores_tbl.count);
2498: END IF;
2499:
2500: -- initial variables needed

Line 2540: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Commit records!' );

2536: ,SYSDATE
2537: ,l_org_id);
2538:
2539: IF PG_DEBUG < 10 THEN
2540: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Commit records!' );
2541: END IF;
2542:
2543: commit;
2544: END IF; -- p_scores_tbl.count > 0

Line 2547: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Return' );

2543: commit;
2544: END IF; -- p_scores_tbl.count > 0
2545: -- end for bug 13335079
2546: IF PG_DEBUG < 10 THEN
2547: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Return' );
2548: END IF;
2549:
2550: Exception
2551: WHEN FND_API.G_EXC_ERROR THEN

Line 2553: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Expected Error ' || sqlerrm );

2549:
2550: Exception
2551: WHEN FND_API.G_EXC_ERROR THEN
2552: IF PG_DEBUG < 10 THEN
2553: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Expected Error ' || sqlerrm );
2554: END IF;
2555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);
2556:
2557: WHEN OTHERS THEN

Line 2559: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: UnExpected Error ' || sqlerrm );

2555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);
2556:
2557: WHEN OTHERS THEN
2558: IF PG_DEBUG < 10 THEN
2559: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: UnExpected Error ' || sqlerrm );
2560: END IF;
2561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory: UnExpected Error' || sqlerrm);
2562:
2563: END storeScoreHistory;

Line 2601: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Insert records!' );

2597:
2598:
2599: BEGIN
2600: IF PG_DEBUG < 10 THEN
2601: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Insert records!' );
2602: END IF;
2603:
2604: l_bridge := p_bridge;
2605: l_user := FND_GLOBAL.USER_ID;

Line 2612: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id ||

2608: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2609:
2610: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2611: IF PG_DEBUG < 10 THEN
2612: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id ||
2613: ' ; Number of scores= ' || p_scores_tbl.count);
2614: END IF;
2615:
2616: -- initial variables needed

Line 2656: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Commit records!' );

2652: ,sysdate);
2653:
2654:
2655: IF PG_DEBUG < 10 THEN
2656: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Commit records!' );
2657: END IF;
2658:
2659: commit;
2660: END IF; -- p_scores_tbl.count > 0

Line 2663: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Return' );

2659: commit;
2660: END IF; -- p_scores_tbl.count > 0
2661:
2662: IF PG_DEBUG < 10 THEN
2663: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Return' );
2664: END IF;
2665:
2666: Exception
2667: WHEN FND_API.G_EXC_ERROR THEN

Line 2669: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm );

2665:
2666: Exception
2667: WHEN FND_API.G_EXC_ERROR THEN
2668: IF PG_DEBUG < 10 THEN
2669: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm );
2670: END IF;
2671: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);
2672:
2673: WHEN OTHERS THEN

Line 2675: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm );

2671: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);
2672:
2673: WHEN OTHERS THEN
2674: IF PG_DEBUG < 10 THEN
2675: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm );
2676: END IF;
2677: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: UnExpected Error ' || sqlerrm);
2678:
2679: END storeDelBuffers;

Line 2735: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Begin' );

2731:
2732:
2733: BEGIN
2734: IF PG_DEBUG < 10 THEN
2735: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Begin' );
2736: END IF;
2737:
2738: -- l_xml_body_1:=l_new_line||'';
2739:

Line 2754: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 ||

2750: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'score_comp_id-->'|| p_score_comp_tbl(l_count2).score_component_id);
2751:
2752:
2753: if PG_DEBUG <= 5 then
2754: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 ||
2755: ' CompID is: ' || l_score_component_id);
2756: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql ||
2757: ' Execute Style: ' || l_execute_style);
2758: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);

Line 2756: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql ||

2752:
2753: if PG_DEBUG <= 5 then
2754: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 ||
2755: ' CompID is: ' || l_score_component_id);
2756: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql ||
2757: ' Execute Style: ' || l_execute_style);
2758: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);
2759: end if;
2760:

Line 2758: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);

2754: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 ||
2755: ' CompID is: ' || l_score_component_id);
2756: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql ||
2757: ' Execute Style: ' || l_execute_style);
2758: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);
2759: end if;
2760:
2761: /* executing dynamic sql for component */
2762: --if l_score_component_sql is not null then

Line 2791: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Failed to calculate for component ' || l_score_component_id );

2787: Begin
2788: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2789: -- figure out whether the component details are better higher or worse higher
2790: IF PG_DEBUG <= 5 THEN
2791: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Failed to calculate for component ' || l_score_component_id );
2792: IEX_DEBUG_PUB.logMessage('Reason: ' || sqlerrm);
2793: END IF;
2794:
2795: SELECT Range_Low

Line 2792: IEX_DEBUG_PUB.logMessage('Reason: ' || sqlerrm);

2788: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2789: -- figure out whether the component details are better higher or worse higher
2790: IF PG_DEBUG <= 5 THEN
2791: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Failed to calculate for component ' || l_score_component_id );
2792: IEX_DEBUG_PUB.logMessage('Reason: ' || sqlerrm);
2793: END IF;
2794:
2795: SELECT Range_Low
2796: BULK COLLECT INTO l_component_range_tbl

Line 2802: IEX_DEBUG_PUB.logMessage('Comparing Ranges');

2798: where score_component_id = l_score_component_id
2799: order by value;
2800:
2801: IF PG_DEBUG <= 5 THEN
2802: IEX_DEBUG_PUB.logMessage('Comparing Ranges');
2803: END IF;
2804:
2805: if l_component_range_tbl(1) < l_component_range_tbl(2) then
2806: -- assign first comnponent detail row range to value

Line 2826: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Successfully calculated component score: ' || l_component_score);

2822: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2823: END; -- end for exception
2824:
2825: if PG_DEBUG <= 5 then
2826: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Successfully calculated component score: ' || l_component_score);
2827: end if;
2828:
2829:
2830: /* exception

Line 2833: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error in getting tag details for report: ' || sqlerrm);

2829:
2830: /* exception
2831: WHEN NO_DATA_FOUND THEN
2832: IF PG_DEBUG < 10 THEN
2833: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error in getting tag details for report: ' || sqlerrm);
2834: END IF;
2835:
2836: WHEN OTHERS THEN
2837: IF PG_DEBUG < 10 THEN

Line 2838: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error in getting tag details for report: ' || sqlerrm);

2834: END IF;
2835:
2836: WHEN OTHERS THEN
2837: IF PG_DEBUG < 10 THEN
2838: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error in getting tag details for report: ' || sqlerrm);
2839: END IF;
2840:
2841: END; */
2842:

Line 2861: IEX_DEBUG_PUB.logMessage('error in get1score in getting score component details'||sqlerrm);

2857: l_xml_body_1:=l_xml_body_1||l_new_line||''||l_score_comp_wtg||'';
2858: exception
2859: when others then
2860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'error in get1score in getting score component details'||sqlerrm);
2861: IEX_DEBUG_PUB.logMessage('error in get1score in getting score component details'||sqlerrm);
2862: end;
2863: --End Bug 8933776 30-Nov-2009 barathsr
2864: /* 4. For each component value, get the details of the component
2865: and store the value for that score_comp_detail */

Line 2877: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: ' || 'Getting Details for component with ' || vSQL);

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:
2881: -- clchang updated 10/18/04 for 11.5.11

Line 2889: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component raw score is ' || 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:
2893: -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11

Line 2896: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_value=' || l_value);

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
2900: l_new_value := replace(l_value, ':RESULT', l_component_score);

Line 2902: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');

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

Line 2903: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);

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';
2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2907: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);

Line 2907: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);

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;
2911: ELSE

Line 2915: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_raw_score=' || 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
2919:

Line 2933: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_running_score=' || l_running_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||'';
2937: l_xml_body_1:=l_xml_body_1||l_new_line||'';

Line 2946: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);

2942:
2943: -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
2944:
2945: --l_running_score:=l_running_score + round((l_raw_score * p_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT));
2946: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);
2947:
2948: EXCEPTION
2949: WHEN NO_DATA_FOUND THEN
2950: IF PG_DEBUG < 10 THEN

Line 2951: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);

2947:
2948: EXCEPTION
2949: WHEN NO_DATA_FOUND THEN
2950: IF PG_DEBUG < 10 THEN
2951: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);
2952: END IF;
2953: l_running_score := l_running_score;
2954: WHEN OTHERS THEN
2955: IF PG_DEBUG < 10 THEN

Line 2956: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);

2952: END IF;
2953: l_running_score := l_running_score;
2954: WHEN OTHERS THEN
2955: IF PG_DEBUG < 10 THEN
2956: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);
2957: END IF;
2958: l_running_score := l_running_score;
2959: END;
2960:

Line 2968: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Return calculated score: ' || l_running_score );

2964:
2965: -- End copied code
2966:
2967: IF PG_DEBUG < 10 THEN
2968: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Return calculated score: ' || l_running_score );
2969: END IF;
2970:
2971: return l_running_score;
2972:

Line 2976: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Expected Error ' || sqlerrm );

2972:
2973: Exception
2974: WHEN FND_API.G_EXC_ERROR THEN
2975: IF PG_DEBUG < 10 THEN
2976: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Expected Error ' || sqlerrm );
2977: END IF;
2978: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);
2979:
2980: WHEN OTHERS THEN

Line 2982: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm );

2978: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);
2979:
2980: WHEN OTHERS THEN
2981: IF PG_DEBUG < 10 THEN
2982: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm );
2983: END IF;
2984: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: UnExpected Error ' || sqlerrm);
2985:
2986: END get1Score;