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_CASE_PVT dependencies on FND_FILE

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

90: -- IF PG_DEBUG < 10 THEN
91: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
92: IEX_DEBUG_PUB.logMessage('IEX_SCORE_CASE_PVT: Calculate_Score: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
93: END IF;
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
95:
96: --First we load our required variables only once per component
97: IF p_score_component_id = -1 or p_score_component_id is null THEN
98: -- IF PG_DEBUG < 10 THEN

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calculating Score for case: ' || p_case_id);

130: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: InvXPctGreaterLimit ' || s_nInvXPctGreaterLimit);
131: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: AnnualPayInXDays ' || s_nAnnualPayInXDays);
132: END IF;
133:
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calculating Score for case: ' || p_case_id);
135: -- begin raverma 04172003
136: -- get the Account for the case
137: -- IF PG_DEBUG < 10 THEN
138: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AccountID: ' || l_CustAccountID);

151: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: NO AccountID found for case');
152: END IF;
153: RAISE FND_API.G_EXC_ERROR;
154: END;
155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AccountID: ' || l_CustAccountID);
156:
157: -- IF PG_DEBUG < 10 THEN
158: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
159: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: AccountID found ' || l_CustAccountID);

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ContractID: ' || l_ContractID);

170: -- IF PG_DEBUG < 10 THEN
171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
172: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Contract ID ' || l_ContractID);
173: END IF;
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ContractID: ' || l_ContractID);
175:
176: -- --IF PG_DEBUG < 10 THEN
177: --IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
178: -- iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Getting Number of Contracts');

Line 204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Invalid contract found ' || l_ContractID);

200: -- IF PG_DEBUG < 10 THEN
201: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
202: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Invalid contract found ' || l_ContractID);
203: END IF;
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Invalid contract found ' || l_ContractID);
205: RAISE FND_API.G_EXC_ERROR;
206: else
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: contract found ' || l_ContractID);
208: end if;

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: contract found ' || l_ContractID);

203: END IF;
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Invalid contract found ' || l_ContractID);
205: RAISE FND_API.G_EXC_ERROR;
206: else
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: contract found ' || l_ContractID);
208: end if;
209:
210: -- 2) Is the amount outstanding > X?
211: -- IF PG_DEBUG < 10 THEN

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount outstanding is: ' || l_AmountOutstanding);

226: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Could not find an outstanding amount => default to 0');
227: END IF;
228: l_AmountOutstanding := 0;
229: END;
230: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount outstanding is: ' || l_AmountOutstanding);
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Amount Outstanding: ' || l_AmountOutstanding);
234: END IF;

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Days past due is: ' || l_DaysPastDue);

251: -- IF PG_DEBUG < 10 THEN
252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
253: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Calculate_Score: Days Past Due ' || l_DaysPastDue);
254: END IF;
255: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Days past due is: ' || l_DaysPastDue);
256:
257: if l_DaysPastDue > 0 and l_DaysPastDue > s_nDaysPastDueLimit then
258: l_tempScore := ReduceScore(l_tempScore,0);
259: end if;

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Last case score is: ' || l_LastScore);

292: -- IF PG_DEBUG < 10 THEN
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Last Case score: ' || l_LastScore);
295: END IF;
296: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Last case score is: ' || l_LastScore);
297:
298: if l_lastScore < s_nLastScoreLimit then
299: l_tempScore := ReduceScore(l_tempScore,0);
300: end if;

Line 330: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Number of broken promises is: ' || l_NumPromiseBroken);

326: -- IF PG_DEBUG < 10 THEN
327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
328: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Number of broken promises is ' || l_NumPromiseBroken);
329: END IF;
330: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Number of broken promises is: ' || l_NumPromiseBroken);
331:
332: if l_NumPromiseBroken > 0 then
333: l_tempScore := ReduceScore(l_tempScore,0);
334: end if;

Line 374: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Number of delinquencies in past ' || s_nConsiderPastXMonths ||

370: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
371: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Number of delinquencies in last ' || s_nConsiderPastXMonths ||
372: ' months: ' || l_NumDelinquencies);
373: END IF;
374: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Number of delinquencies in past ' || s_nConsiderPastXMonths ||
375: ' months: ' || l_NumDelinquencies);
376:
377: -- begin raverma 05302003 add l_AmountOutstanding > s_nAmountOutsdandingLimit clause according
378: -- to OKL documentation requirements

Line 412: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || l_nCurrAmount || ' greater than or less than ' || (l_nAmount * (1 + (s_nInvXPctGreaterLimit/100))));

408: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Previous Amount: ' || l_nCurrAmount);
409: END IF;
410:
411: if l_nAmount is not null then
412: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || l_nCurrAmount || ' greater than or less than ' || (l_nAmount * (1 + (s_nInvXPctGreaterLimit/100))));
413: if l_nCurrAmount > (l_nAmount * (1 + (s_nInvXPctGreaterLimit/100))) then
414: l_tempScore := ReduceScore(l_tempScore,1);
415: end if;
416: else

Line 474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || 'Coming due in ' || l_DueInDays || ' days');

470: --iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: due in days limit is ' || s_nAnnualPayInXDays || ' days');
471: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Next payment not coming due in next ' || s_nAnnualPayInXDays || ' days');
472: END IF;
473:
474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || 'Coming due in ' || l_DueInDays || ' days');
475: if l_DueInDays < s_nAnnualPayInXDays then
476: l_tempScore := ReduceScore(l_tempScore,1);
477: end if;
478: -- Payment Rejected (TBD)

Line 501: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

497: IEX_DEBUG_PUB.logMessage('IEX_SCORE_CASE_PVT: Calculate_Score: NO CONTRACTS FOUND');
498: END IF;
499: RAISE FND_API.G_EXC_ERROR;
500: END;
501: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
502:
503: RETURN l_caseScore;
504:
505: -- IF PG_DEBUG < 10 THEN

Line 512: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Exception ' || sqlerrm);

508: END IF;
509:
510: EXCEPTION
511: WHEN OTHERS THEN
512: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE_CASE_PVT: Calculate_Score: Exception ' || sqlerrm);
513: -- IF PG_DEBUG < 10 THEN
514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
515: iex_debug_pub.logmessage('IEX_SCORE_CASE_PVT: Calculate_Score: Exception ' || sqlerrm);
516: END IF;