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

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

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

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

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

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

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

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

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

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

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

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);
225: END IF;
226:
227: IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED := l_weight_required;

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

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);
225: END IF;
226:
227: IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED := l_weight_required;
228: IEX_SCORE_NEW_PVT.G_MIN_SCORE := l_low;

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

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

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

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

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

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);
237: END IF;
238:
239: END getScoreRange;

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

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);
237: END IF;
238:
239: END getScoreRange;
240:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
479: -- end if;
480: --
481: -- /* executing dynamic sql for component */

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

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

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

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

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

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

Line 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);

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: --
565: -- -- BEGIN clchang added 10/18/04 for scr engine enhancement in 11.5.11

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
677: -- fill out return table

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

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

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

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

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

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');
837: FND_MSG_PUB.Add;

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

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

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

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

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

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

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

868: p_object_type => 'IEXSCORE',
869: p_last_object_scored => l_last_obj_scored,
870: x_end_of_universe => l_last_batch);
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');

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

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

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

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

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

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

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

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

Line 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'));

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:
959: l_submit_request_id := FND_REQUEST.SUBMIT_REQUEST(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1233: -- Begin bug 6128024

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

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:
1233: -- Begin bug 6128024
1234: begin

Line 1275: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1498: IEX_DEBUG_PUB.logMessage(vPLSQL2);

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

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

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

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

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

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

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

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

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

Line 1720: IEX_DEBUG_PUB.logMessage(vPLSQL);

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

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

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

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

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

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

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

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

1804:
1805:
1806: BEGIN
1807: IF PG_DEBUG < 10 THEN
1808: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Insert records!' );
1809: END IF;
1810:
1811: l_user := FND_GLOBAL.USER_ID;
1812: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);

Line 1818: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);

1814: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1815:
1816: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1817: IF PG_DEBUG < 10 THEN
1818: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);
1819: END IF;
1820:
1821: -- initial variables needed
1822: select jtf_object_code into l_object_type

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

1855: ,l_prog_appl
1856: ,sysdate);
1857:
1858: IF PG_DEBUG < 10 THEN
1859: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Commit records!' );
1860: END IF;
1861:
1862: commit;
1863: END IF; -- p_scores_tbl.count > 0

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

1862: commit;
1863: END IF; -- p_scores_tbl.count > 0
1864:
1865: IF PG_DEBUG < 10 THEN
1866: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Return' );
1867: END IF;
1868:
1869: Exception
1870: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

1916:
1917:
1918: BEGIN
1919: IF PG_DEBUG < 10 THEN
1920: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Insert records!' );
1921: END IF;
1922:
1923: l_bridge := p_bridge;
1924: l_user := FND_GLOBAL.USER_ID;

Line 1931: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);

1927: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
1928:
1929: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
1930: IF PG_DEBUG < 10 THEN
1931: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: p_score_id= ' || p_score_id || ' ; Number of scores= ' || p_scores_tbl.count);
1932: END IF;
1933:
1934: -- initial variables needed
1935: select jtf_object_code into l_object_type

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

1970: ,sysdate);
1971:
1972:
1973: IF PG_DEBUG < 10 THEN
1974: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Commit records!' );
1975: END IF;
1976:
1977: commit;
1978: END IF; -- p_scores_tbl.count > 0

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

1977: commit;
1978: END IF; -- p_scores_tbl.count > 0
1979:
1980: IF PG_DEBUG < 10 THEN
1981: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Return' );
1982: END IF;
1983:
1984: Exception
1985: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

2038:
2039:
2040: BEGIN
2041: IF PG_DEBUG < 10 THEN
2042: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Begin' );
2043: END IF;
2044:
2045: -- copied code
2046: /* 3. for each component, execute SQL and get value */

Line 2055: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);

2051: -- initialize this to the minimum for any given component
2052: --l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
2053:
2054: if PG_DEBUG <= 5 then
2055: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);
2056: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);
2057: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);
2058: end if;
2059:

Line 2056: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);

2052: --l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
2053:
2054: if PG_DEBUG <= 5 then
2055: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);
2056: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);
2057: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);
2058: end if;
2059:
2060: /* executing dynamic sql for component */

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

2053:
2054: if PG_DEBUG <= 5 then
2055: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: executing Component ' || l_count2 || ' CompID is: ' || l_score_component_id);
2056: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Execute Stmt: ' || l_score_component_sql || ' Execute Style: ' || l_execute_style);
2057: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Bind Variable: ' || p_object_id);
2058: end if;
2059:
2060: /* executing dynamic sql for component */
2061: --if l_score_component_sql is not null then

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

2086: Begin
2087: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2088: -- figure out whether the component details are better higher or worse higher
2089: IF PG_DEBUG <= 5 THEN
2090: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Failed to calculate for component ' || l_score_component_id );
2091: IEX_DEBUG_PUB.logMessage('Reason: ' || sqlerrm);
2092: END IF;
2093:
2094: SELECT Range_Low

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

2087: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2088: -- figure out whether the component details are better higher or worse higher
2089: IF PG_DEBUG <= 5 THEN
2090: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Failed to calculate for component ' || l_score_component_id );
2091: IEX_DEBUG_PUB.logMessage('Reason: ' || sqlerrm);
2092: END IF;
2093:
2094: SELECT Range_Low
2095: BULK COLLECT INTO l_component_range_tbl

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

2097: where score_component_id = l_score_component_id
2098: order by value;
2099:
2100: IF PG_DEBUG <= 5 THEN
2101: IEX_DEBUG_PUB.logMessage('Comparing Ranges');
2102: END IF;
2103:
2104: if l_component_range_tbl(1) < l_component_range_tbl(2) then
2105: -- assign first comnponent detail row range to value

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

2120: -- End - Andre Araujo - 12/17/2004 - If the detail is not defined this throws a NO DATA FOUND
2121: END; -- end for exception
2122:
2123: if PG_DEBUG <= 5 then
2124: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Successfully calculated component score: ' || l_component_score);
2125: end if;
2126:
2127: --end if;
2128:

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

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

Line 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);

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

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

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

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

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

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

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

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

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

Line 2179: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_raw_score=' || 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:
2183: l_weight_required := IEX_SCORE_NEW_PVT.G_WEIGHT_REQUIRED;

Line 2194: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_running_score=' || l_running_score);

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:
2198: --l_running_score:=l_running_score + round((l_raw_score * p_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT));

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

2195: END IF;
2196: -- END clchang added 10/18/04 for scr engine enhancement in 11.5.11
2197:
2198: --l_running_score:=l_running_score + round((l_raw_score * p_score_comp_tbl(l_count2).SCORE_COMP_WEIGHT));
2199: --IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: Component Running score is ' || l_running_score);
2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: IF PG_DEBUG < 10 THEN

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

2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: IF PG_DEBUG < 10 THEN
2204: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);
2205: END IF;
2206: l_running_score := l_running_score;
2207: WHEN OTHERS THEN
2208: IF PG_DEBUG < 10 THEN

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

2205: END IF;
2206: l_running_score := l_running_score;
2207: WHEN OTHERS THEN
2208: IF PG_DEBUG < 10 THEN
2209: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Error getting component detail: ' || sqlerrm);
2210: END IF;
2211: l_running_score := l_running_score;
2212: END;
2213:

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

2215:
2216: -- End copied code
2217:
2218: IF PG_DEBUG < 10 THEN
2219: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Return calculated score: ' || l_running_score );
2220: END IF;
2221:
2222: return l_running_score;
2223:

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

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

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

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