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

Line 89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);

85: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID);
86: END IF;
87:
88: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);
90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );
91: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
92: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);

Line 90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );

86: END IF;
87:
88: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);
90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );
91: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
92: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
94:

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);

89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);
90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );
91: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
92: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
94:
95: IF (l_debug <10) THEN
96: P_debug_mode := 'Y';
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) :' || l_debug);

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) :' || l_debug);

93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
94:
95: IF (l_debug <10) THEN
96: P_debug_mode := 'Y';
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) :' || l_debug);
98: ELSE
99: P_debug_mode := 'N';
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) < 10, Current value :' || l_debug);
101: END IF;

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) < 10, Current value :' || l_debug);

96: P_debug_mode := 'Y';
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) :' || l_debug);
98: ELSE
99: P_debug_mode := 'N';
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) < 10, Current value :' || l_debug);
101: END IF;
102:
103: IF (l_debug =1) THEN
104: P_trace_mode := 'Y';

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) = 1');

111:
112: IF p_trace_mode = 'Y' THEN
113: l_temp := 'alter session set events = ''10046 trace name context forever, level 8'' ';
114: EXECUTE IMMEDIATE l_temp;
115: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) = 1');
116: ELSE
117: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) <> 1');
118: END IF;
119: --End changes by gnramasa on 29/08/2006 for bug # 5487449

Line 117: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) <> 1');

113: l_temp := 'alter session set events = ''10046 trace name context forever, level 8'' ';
114: EXECUTE IMMEDIATE l_temp;
115: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) = 1');
116: ELSE
117: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is not Enabled , IEX: Debug Level (IEX_DEBUG_LEVEL) <> 1');
118: END IF;
119: --End changes by gnramasa on 29/08/2006 for bug # 5487449
120: --Bug5043777 Removed the parameters which is no longer in use. Fix By LKKUMAR. End.
121:

Line 256: FND_FILE.put_line(fnd_file.log,'Operating Unit Before Submitting IEXGAR is : ' || mo_global.get_current_org_id );

252: FOR i in 1..p_ActualAccountWorkersUsed
253: LOOP
254: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.
255: fnd_request.set_org_id(mo_global.get_current_org_id);
256: FND_FILE.put_line(fnd_file.log,'Operating Unit Before Submitting IEXGAR is : ' || mo_global.get_current_org_id );
257: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.
258:
259: IEX_DEBUG('Submiting IEXGAR for ACCOUNT');
260: l_req_id := FND_REQUEST.SUBMIT_REQUEST('IEX',

Line 431: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');

427: BEGIN
428: IF g_debug_flag = 'Y'
429: THEN
430: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
431: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
432:
433: -- chop the message to 255 long
434: l_length := length(msg);
435: WHILE l_length > 255 LOOP

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_substring);

433: -- chop the message to 255 long
434: l_length := length(msg);
435: WHILE l_length > 255 LOOP
436: l_substring := substr(msg, l_start, 255);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_substring);
438: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. Start.
439: IEX_DEBUG_PUB.logmessage(l_substring);
440: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. End.
441: -- dbms_output.put_line(l_substring);

Line 448: FND_FILE.PUT_LINE(FND_FILE.LOG,l_substring);

444: l_length := l_length - 255;
445: END LOOP;
446:
447: l_substring := substr(msg, l_start);
448: FND_FILE.PUT_LINE(FND_FILE.LOG,l_substring);
449: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. Start.
450: IEX_DEBUG_PUB.logmessage(l_substring);
451: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. End.
452: -- dbms_output.put_line(l_substring);

Line 456: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in IEX_DEBUG');

452: -- dbms_output.put_line(l_substring);
453: END IF;
454: EXCEPTION
455: WHEN others THEN
456: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in IEX_DEBUG');
457: FND_FILE.PUT_LINE(FND_FILE.LOG,
458: 'SQLCODE ' || to_char(SQLCODE) ||
459: ' SQLERRM ' || substr(SQLERRM, 1, 100));
460: END IEX_DEBUG;

Line 457: FND_FILE.PUT_LINE(FND_FILE.LOG,

453: END IF;
454: EXCEPTION
455: WHEN others THEN
456: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in IEX_DEBUG');
457: FND_FILE.PUT_LINE(FND_FILE.LOG,
458: 'SQLCODE ' || to_char(SQLCODE) ||
459: ' SQLERRM ' || substr(SQLERRM, 1, 100));
460: END IEX_DEBUG;
461: