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 103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program iextpinb.pls : * IEX_ATA_PUB.Asssign_Territory_Access starts *');

99: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID);
100: END IF;
101:
102: IEX_DEBUG('Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access starts ***');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program iextpinb.pls : *** IEX_ATA_PUB.Asssign_Territory_Access starts ***');
104: FND_FILE.put_line(fnd_file.log, ' Strategy Level' || P_STR_LEVEL);
105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
106: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level(IEX_DEBUG_LEVEL) is : ' || l_debug);
107:

Line 104: FND_FILE.put_line(fnd_file.log, ' Strategy Level' || P_STR_LEVEL);

100: END IF;
101:
102: IEX_DEBUG('Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access starts ***');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program iextpinb.pls : *** IEX_ATA_PUB.Asssign_Territory_Access starts ***');
104: FND_FILE.put_line(fnd_file.log, ' Strategy Level' || P_STR_LEVEL);
105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
106: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level(IEX_DEBUG_LEVEL) is : ' || l_debug);
107:
108: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN

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

102: IEX_DEBUG('Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access starts ***');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program iextpinb.pls : *** IEX_ATA_PUB.Asssign_Territory_Access starts ***');
104: FND_FILE.put_line(fnd_file.log, ' Strategy Level' || P_STR_LEVEL);
105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
106: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level(IEX_DEBUG_LEVEL) is : ' || l_debug);
107:
108: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
110: ELSE

Line 109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');

105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
106: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level(IEX_DEBUG_LEVEL) is : ' || l_debug);
107:
108: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
110: ELSE
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
112: END IF;
113:

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);

107:
108: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
110: ELSE
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
112: END IF;
113:
114: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
115: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

112: END IF;
113:
114: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
115: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
116: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, Profile IEX: Territory Access Level(IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
117:
118: -- Start for bug 8708291 pnaveenk
119: /* If iex_utilities.validate_running_level(l_Assignlevel) <> 'Y' then
120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Territory Assignment Level at Profile IEX: Territory Level not exists in the Strategy Level set up');

Line 120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Territory Assignment Level at Profile IEX: Territory Level not exists in the Strategy Level set up');

116: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, Profile IEX: Territory Access Level(IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
117:
118: -- Start for bug 8708291 pnaveenk
119: /* If iex_utilities.validate_running_level(l_Assignlevel) <> 'Y' then
120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Territory Assignment Level at Profile IEX: Territory Level not exists in the Strategy Level set up');
121: End if; */
122:
123: Begin
124:

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Multiple Strategy Levels being used.');

132: from dual;
133:
134: If l_str_level_count > 1 then
135: If P_STR_LEVEL is null then
136: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Multiple Strategy Levels being used.');
137: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Please select the value for Parameter Territory Level');
138: return;
139: end if;
140:

Line 137: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Please select the value for Parameter Territory Level');

133:
134: If l_str_level_count > 1 then
135: If P_STR_LEVEL is null then
136: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Multiple Strategy Levels being used.');
137: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Please select the value for Parameter Territory Level');
138: return;
139: end if;
140:
141: if l_str_status = 'Y' then

Line 144: FND_FILE.put_line(fnd_file.log, p_str_level || ' is not a valid level');

140:
141: if l_str_status = 'Y' then
142: l_Assignlevel := P_STR_LEVEL;
143: else
144: FND_FILE.put_line(fnd_file.log, p_str_level || ' is not a valid level');
145: return;
146: end if;
147: end if;
148:

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Territory Running Level is ' || l_Assignlevel);

150: When Others then
151: IEX_DEBUG(' Exception in finding strategy levels count');
152: End;
153:
154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Territory Running Level is ' || l_Assignlevel);
155: -- End for bug 8708291 pnaveenk
156:
157:
158: IF (l_debug <10) THEN

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

156:
157:
158: IF (l_debug <10) THEN
159: P_debug_mode := 'Y';
160: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug is Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) :' || l_debug);
161: ELSE
162: P_debug_mode := 'N';
163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug is not Enabled , Profile IEX: Debug Level(IEX_DEBUG_LEVEL) : ' || l_debug || '. Please set this profile value < 10 to enable debug ');
164: END IF;

Line 163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug is not Enabled , Profile IEX: Debug Level(IEX_DEBUG_LEVEL) : ' || l_debug || '. Please set this profile value < 10 to enable debug ');

159: P_debug_mode := 'Y';
160: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug is Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) :' || l_debug);
161: ELSE
162: P_debug_mode := 'N';
163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Debug is not Enabled , Profile IEX: Debug Level(IEX_DEBUG_LEVEL) : ' || l_debug || '. Please set this profile value < 10 to enable debug ');
164: END IF;
165:
166: IF (l_debug =1) THEN
167: P_trace_mode := 'Y';

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

174:
175: IF p_trace_mode = 'Y' THEN
176: l_temp := 'alter session set events = ''10046 trace name context forever, level 8'' ';
177: EXECUTE IMMEDIATE l_temp;
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) = 1');
179: ELSE
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is not Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) <> 1');
181: END IF;
182: --End changes by gnramasa on 29/08/2006 for bug # 5487449

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

176: l_temp := 'alter session set events = ''10046 trace name context forever, level 8'' ';
177: EXECUTE IMMEDIATE l_temp;
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) = 1');
179: ELSE
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Trace is not Enabled , IEX: Debug Level(IEX_DEBUG_LEVEL) <> 1');
181: END IF;
182: --End changes by gnramasa on 29/08/2006 for bug # 5487449
183: --Bug5043777 Removed the parameters which is no longer in use. Fix By LKKUMAR. End.
184:

Line 250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Territory Minimum Number of Records for Parallel Processing : ' || g_min_num_parallel_proc);

246: END IF;
247:
248: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);
249: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Territory Minimum Number of Records for Parallel Processing : ' || g_min_num_parallel_proc);
251:
252: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile IEX: Number of Child Account Workers for TAP : ' || g_NumChildAccountWorker);
254: if g_NumChildAccountWorker < 1 then

Line 253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile IEX: Number of Child Account Workers for TAP : ' || g_NumChildAccountWorker);

249: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Territory Minimum Number of Records for Parallel Processing : ' || g_min_num_parallel_proc);
251:
252: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile IEX: Number of Child Account Workers for TAP : ' || g_NumChildAccountWorker);
254: if g_NumChildAccountWorker < 1 then
255: g_NumChildAccountWorker:=1;
256: elsif g_NumChildAccountWorker > 10 then
257: g_NumChildAccountWorker:=10;

Line 259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Max no. of Parallel Account Workers allowed for TAP is : ' || g_NumChildAccountWorker);

255: g_NumChildAccountWorker:=1;
256: elsif g_NumChildAccountWorker > 10 then
257: g_NumChildAccountWorker:=10;
258: IEX_DEBUG('Max no. of Parallel Account Workers allowed for TAP is:' || g_NumChildAccountWorker);
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Max no. of Parallel Account Workers allowed for TAP is : ' || g_NumChildAccountWorker);
260: end if;
261: IEX_DEBUG('Max Parallel Account Workers (IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS)=' || g_NumChildAccountWorker);
262:
263: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);

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

265:
266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:
272: JTY_ASSIGN_BULK_PUB.collect_trans_data(
273: p_api_version_number => 1.0,

Line 270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');

266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:
272: JTY_ASSIGN_BULK_PUB.collect_trans_data(
273: p_api_version_number => 1.0,
274: p_init_msg_list => FND_API.G_FALSE,

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

287: RETCODE => lx_retcode);
288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');

288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error buffer ' || lx_errbuf);
298: END;
299:
300:

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error buffer ' || lx_errbuf);

293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error buffer ' || lx_errbuf);
298: END;
299:
300:
301: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_trans;

Line 303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_trans : ' || l_acc_count );

299:
300:
301: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_trans;
302: IEX_DEBUG('Number of records in jtf_tae_1600_cust_trans : ' || l_acc_count );
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_trans : ' || l_acc_count );
304:
305: IEX_DEBUG('Analyse values and Prepare Parallel Processing ...' );
306: -- populate worker_id in TRANS or NM_TRANS tables
307: Prepare_Parallel_Processing(

Line 319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Do the setup and run this program ');

315: IEX_DEBUG('Parallel Processing values analysed successfully...');
316:
317: IF (p_ActualAccountWorkersUsed = 0) THEN
318: IEX_DEBUG('No Records in JTF Trans Table, Do the Setup and then run this program');
319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Do the setup and run this program ');
320: END IF;
321:
322: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_WINNERS;
323: IEX_DEBUG('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

320: END IF;
321:
322: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_WINNERS;
323: IEX_DEBUG('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
325:
326: -- submit concurrent request IEXGAR for ACCOUNT
327: FOR i in 1..p_ActualAccountWorkersUsed LOOP
328: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.

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

326: -- submit concurrent request IEXGAR for ACCOUNT
327: FOR i in 1..p_ActualAccountWorkersUsed LOOP
328: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.
329: fnd_request.set_org_id(mo_global.get_current_org_id);
330: FND_FILE.put_line(fnd_file.log,'Operating Unit Before Submitting IEXGAR is : ' || mo_global.get_current_org_id );
331: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.
332:
333: IEX_DEBUG('Submiting IEXGAR(iextptwb.pls IEX_GAR_PUB.Generate_Access_Records)');
334: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submiting IEXGAR(iextptwb.pls IEX_GAR_PUB.Generate_Access_Records) ');

Line 334: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submiting IEXGAR(iextptwb.pls IEX_GAR_PUB.Generate_Access_Records) ');

330: FND_FILE.put_line(fnd_file.log,'Operating Unit Before Submitting IEXGAR is : ' || mo_global.get_current_org_id );
331: --Bug5043777. Fix By LKKUMAR. Set the Context for Spawn Program. Start.
332:
333: IEX_DEBUG('Submiting IEXGAR(iextptwb.pls IEX_GAR_PUB.Generate_Access_Records)');
334: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submiting IEXGAR(iextptwb.pls IEX_GAR_PUB.Generate_Access_Records) ');
335: l_req_id := FND_REQUEST.SUBMIT_REQUEST('IEX',
336: 'IEXGAR',
337: 'Generate Access Records Collections',
338: '',

Line 358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request for IEXGAR :' || l_req_id|| ' Worker Id:'||i);

354: l_msg:=FND_MESSAGE.GET;
355: IEX_DEBUG(l_msg);
356: END IF;
357: IEX_DEBUG('Submitted request for IEXGAR :' || l_req_id|| ' Worker Id:'||i);
358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request for IEXGAR :' || l_req_id|| ' Worker Id:'||i);
359: l_req_id_lst(i):=l_req_id;--Added for Bug 7697167 28-Jan-2009 barathsr
360:
361: END LOOP;
362:

Line 367: FND_FILE.PUT_LINE(FND_FILE.LOG,'Count of req_ids:' ||l_req_id_lst.count);

363:
364: --Begin Bug 7697167 27-Jan-2009 barathsr
365: cnt:=l_req_id_lst.count;
366: IEX_DEBUG('Count of req_ids:' ||l_req_id_lst.count);
367: FND_FILE.PUT_LINE(FND_FILE.LOG,'Count of req_ids:' ||l_req_id_lst.count);
368: while cnt > 0 loop
369: for k in l_req_id_lst.first..l_req_id_lst.last
370: loop
371: if l_req_id_lst(k)<>-1 then

Line 393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program iextpinb.pls : * IEX_ATA_PUB.Assign_Territory_Access Ends *');

389:
390:
391:
392: IEX_DEBUG('Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access Ends ***');
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access Ends ***');
394: EXCEPTION
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: IEX_DEBUG('Cannot Start');
397:

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Assign_Territory_Accesses');

398: WHEN others THEN
399: IEX_DEBUG('Exception: others in Assign_Territory_Accesses');
400: IEX_DEBUG('SQLCODE ' || to_char(SQLCODE) ||
401: ' SQLERRM ' || substr(SQLERRM, 1, 100));
402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Assign_Territory_Accesses');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) ||
404: ' SQLERRM ' || substr(SQLERRM, 1, 100));
405:
406: errbuf := SQLERRM;

Line 403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) ||

399: IEX_DEBUG('Exception: others in Assign_Territory_Accesses');
400: IEX_DEBUG('SQLCODE ' || to_char(SQLCODE) ||
401: ' SQLERRM ' || substr(SQLERRM, 1, 100));
402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Assign_Territory_Accesses');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) ||
404: ' SQLERRM ' || substr(SQLERRM, 1, 100));
405:
406: errbuf := SQLERRM;
407: retcode := FND_API.G_RET_STS_UNEXP_ERROR;

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

542: BEGIN
543: IF g_debug_flag = 'Y'
544: THEN
545: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
547:
548: -- chop the message to 255 long
549: l_length := length(msg);
550: WHILE l_length > 255 LOOP

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

548: -- chop the message to 255 long
549: l_length := length(msg);
550: WHILE l_length > 255 LOOP
551: l_substring := substr(msg, l_start, 255);
552: FND_FILE.PUT_LINE(FND_FILE.LOG, l_substring);
553: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. Start.
554: IEX_DEBUG_PUB.logmessage(l_substring);
555: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. End.
556: -- dbms_output.put_line(l_substring);

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

559: l_length := l_length - 255;
560: END LOOP;
561:
562: l_substring := substr(msg, l_start);
563: FND_FILE.PUT_LINE(FND_FILE.LOG,l_substring);
564: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. Start.
565: IEX_DEBUG_PUB.logmessage(l_substring);
566: --Bug4221324. Fix by LKKUMAR on 06-Dec-2005. End.
567: -- dbms_output.put_line(l_substring);

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

567: -- dbms_output.put_line(l_substring);
568: END IF;
569: EXCEPTION
570: WHEN others THEN
571: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in IEX_DEBUG');
572: FND_FILE.PUT_LINE(FND_FILE.LOG,
573: 'SQLCODE ' || to_char(SQLCODE) ||
574: ' SQLERRM ' || substr(SQLERRM, 1, 100));
575: END IEX_DEBUG;

Line 572: FND_FILE.PUT_LINE(FND_FILE.LOG,

568: END IF;
569: EXCEPTION
570: WHEN others THEN
571: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in IEX_DEBUG');
572: FND_FILE.PUT_LINE(FND_FILE.LOG,
573: 'SQLCODE ' || to_char(SQLCODE) ||
574: ' SQLERRM ' || substr(SQLERRM, 1, 100));
575: END IEX_DEBUG;
576:

Line 665: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Prepare_Parallel_Processing');

661: WHEN others THEN
662: IEX_DEBUG('Exception: others in Prepare_Parallel_Processing');
663: IEX_DEBUG('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
664:
665: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Prepare_Parallel_Processing');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
667: END Prepare_Parallel_Processing;
668:
669:

Line 666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));

662: IEX_DEBUG('Exception: others in Prepare_Parallel_Processing');
663: IEX_DEBUG('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
664:
665: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception: others in Prepare_Parallel_Processing');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
667: END Prepare_Parallel_Processing;
668:
669:
670: END IEX_ATA_PUB;