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

Line 109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');

105: IEX_TERR_WINNERS_PUB.Print_Debug('*** iextpawb.pls::IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records() ***');
106:
107: --l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY'); -- commented for bug 8708291
108: l_Assignlevel := p_assignlevel; -- Added for bug 8708291 pnaveenk multi level strategy
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');
110:
111: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
113: ELSE

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

108: l_Assignlevel := p_assignlevel; -- Added for bug 8708291 pnaveenk multi level strategy
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');
110:
111: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
113: ELSE
114: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
115: END IF;
116:

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

110:
111: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
112: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');
113: ELSE
114: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
115: END IF;
116:
117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449
118:

Line 117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449

113: ELSE
114: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
115: END IF;
116:
117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449
118:
119: l_worker_id:=p_terr_globals.worker_id;
120: l_var :=p_terr_globals.bulk_size;
121: IEX_TERR_WINNERS_PUB.Print_Debug('bulk size='||l_var);

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

254:
255: BEGIN
256:
257: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
258: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
259: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Party Level Collector Assignment ***');
261:
262: --l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG,'* Started Party Level Collector Assignment *');

256:
257: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
258: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
259: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Party Level Collector Assignment ***');
261:
262: --l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
264: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Party Level := ' ||l_Assignlevel);

Line 263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');

259: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Party Level Collector Assignment ***');
261:
262: --l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
264: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Party Level := ' ||l_Assignlevel);
265:
266: l_worker_id:=p_terr_globals.worker_id;
267: -- Bulk Read the Territory Assignments

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Party Level := ' ||l_Assignlevel);

260: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Party Level Collector Assignment ***');
261:
262: --l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
264: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Party Level := ' ||l_Assignlevel);
265:
266: l_worker_id:=p_terr_globals.worker_id;
267: -- Bulk Read the Territory Assignments
268: l_var :=p_terr_globals.bulk_size;

Line 273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Party Profiles started ... ');

269: l_max_fetches := p_terr_globals.cursor_limit;
270: IEX_TERR_WINNERS_PUB.Print_Debug('Bulk Size='||l_var);
271: IEX_TERR_WINNERS_PUB.Print_Debug('Cursor Fetch Size = ' || l_max_fetches);
272: IEX_TERR_WINNERS_PUB.Print_Debug('Updating Customer Party Profiles started ... ');
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Party Profiles started ... ');
274:
275: --Bug4650943. Fix By LKKUMAR on 04-Oct-2005. Start.
276: OPEN c_UpdateProfile(l_worker_id);
277: LOOP

Line 285: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');

281: LIMIT l_max_fetches;
282: IF l_customer_id.count = 0 THEN
283:
284: IEX_TERR_WINNERS_PUB.Print_Debug('Update Completed. Exiting the update loop');
285: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');
286: CLOSE C_UPDATEPROFILE;
287: EXIT;
288:
289: ELSE

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);

288:
289: ELSE
290:
291: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
293:
294: FORALL i in l_customer_id.first..l_customer_id.last
295: UPDATE HZ_CUSTOMER_PROFILES ACC
296: SET object_version_number = nvl(object_version_number,0) + 1,

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Party Profile Rows Updated ' || l_customer_id.count);

307: AND ACC.CUST_ACCOUNT_ID = -1
308: AND ACC.COLLECTOR_ID <> l_collector_id(i);
309: --Commit When the Bulk commit size is reached.
310: IEX_TERR_WINNERS_PUB.Print_Debug('Total Customer Party Profile Rows Updated ' || l_customer_id.count);
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Party Profile Rows Updated ' || l_customer_id.count);
312: COMMIT;
313: END IF;
314: EXCEPTION WHEN deadlock_detected THEN
315: BEGIN

Line 317: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during party bulk update.. Performing row update..');

313: END IF;
314: EXCEPTION WHEN deadlock_detected THEN
315: BEGIN
316: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during party bulk update.. Performing row update..');
317: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during party bulk update.. Performing row update..');
318: ROLLBACK;
319:
320: FOR i in l_first .. l_last LOOP
321: BEGIN

Line 345: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Party Profile Rows Updated ' ||l_cnt);

341: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
342: ' SQLERRM: ' || SQLERRM);
343: END;
344: END LOOP;
345: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Party Profile Rows Updated ' ||l_cnt);
346: l_cnt := 0;
347: END;
348: WHEN OTHERS THEN
349: IEX_TERR_WINNERS_PUB.Print_Debug('Exception occured while updating site profile '||sqlerrm);

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

469:
470: BEGIN
471:
472: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
474: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Account Level Collector Assignment ***');
476: -- l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG,'* Started Account Level Collector Assignment *');

471:
472: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
474: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Account Level Collector Assignment ***');
476: -- l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Account Level := ' ||l_Assignlevel);
479:

Line 477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');

473: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
474: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Account Level Collector Assignment ***');
476: -- l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Account Level := ' ||l_Assignlevel);
479:
480: l_worker_id:=p_terr_globals.worker_id;
481: -- Bulk Read the Territory Assignments

Line 478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Account Level := ' ||l_Assignlevel);

474: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Account Level Collector Assignment ***');
476: -- l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Account Level := ' ||l_Assignlevel);
479:
480: l_worker_id:=p_terr_globals.worker_id;
481: -- Bulk Read the Territory Assignments
482: l_var :=p_terr_globals.bulk_size;

Line 487: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Account Profiles started ... ');

483: l_max_fetches := p_terr_globals.cursor_limit;
484: IEX_TERR_WINNERS_PUB.Print_Debug('Bulk Size='||l_var);
485: IEX_TERR_WINNERS_PUB.Print_Debug('Cursor Fetch Size = ' || l_max_fetches);
486: IEX_TERR_WINNERS_PUB.Print_Debug('Updating Customer Account Profiles started ... ');
487: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Account Profiles started ... ');
488:
489: OPEN c_UpdateProfile(l_worker_id);
490: LOOP
491: BEGIN

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');

493: l_customer_id, l_salesforce_id, l_sales_group_id, l_org_id, l_Res_type, l_Collector_ID
494: LIMIT l_max_fetches;
495: IF l_customer_id.count = 0 THEN
496: IEX_TERR_WINNERS_PUB.Print_Debug('Update Completed. Exiting the update loop');
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');
498: CLOSE C_UPDATEPROFILE;
499: EXIT;
500: ELSE
501: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);

Line 502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);

498: CLOSE C_UPDATEPROFILE;
499: EXIT;
500: ELSE
501: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
503: FORALL i in l_customer_id.first..l_customer_id.last
504: UPDATE HZ_CUSTOMER_PROFILES ACC
505: SET object_version_number = nvl(object_version_number,0) + 1,
506: ACC.LAST_UPDATE_DATE = SYSDATE,

Line 520: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Account Pofile Rows Updated ' || l_customer_id.count);

516: AND ACC.CUST_ACCOUNT_ID <> -1
517: AND ACC.COLLECTOR_ID <> l_collector_id(i);
518: --Commit When the Bulk commit size is reached.
519: IEX_TERR_WINNERS_PUB.Print_Debug('Total Customer Account Profile Rows Updated ' || l_customer_id.count);
520: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Account Pofile Rows Updated ' || l_customer_id.count);
521: COMMIT;
522: END IF;
523: EXCEPTION WHEN deadlock_detected THEN
524: BEGIN

Line 526: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during bulk update.. Performing row update..');

522: END IF;
523: EXCEPTION WHEN deadlock_detected THEN
524: BEGIN
525: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during bulk update.. Performing row update..');
526: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during bulk update.. Performing row update..');
527: ROLLBACK;
528: FOR i in l_first .. l_last LOOP
529: BEGIN
530: l_cnt := l_cnt + 1;

Line 551: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Account Profile Rows Updated ' ||l_cnt);

547: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
548: ' SQLERRM: ' || SQLERRM);
549: END;
550: END LOOP;
551: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Account Profile Rows Updated ' ||l_cnt);
552: l_cnt := 0;
553: END;
554: WHEN OTHERS THEN
555: IEX_TERR_WINNERS_PUB.Print_Debug('Exception occured while updating site profile '||sqlerrm);

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

732: -------------------------------------------------------------------------------
733:
734: BEGIN
735: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
736: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
737: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Site Level Collector Assignment ***');
738: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Site Level Collector Assignment ***');
739:
740: -- l_Assignlevel := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

Line 738: FND_FILE.PUT_LINE(FND_FILE.LOG,'* Started Site Level Collector Assignment *');

734: BEGIN
735: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
736: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
737: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Site Level Collector Assignment ***');
738: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Site Level Collector Assignment ***');
739:
740: -- l_Assignlevel := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
741: l_worker_id :=p_terr_globals.worker_id;
742: l_var :=p_terr_globals.bulk_size;

Line 746: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Bill To Level := ' ||l_Assignlevel);

742: l_var :=p_terr_globals.bulk_size;
743: l_max_fetches := p_terr_globals.cursor_limit;
744:
745:
746: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level when assigning collectors at Bill To Level := ' ||l_Assignlevel);
747: IEX_TERR_WINNERS_PUB.Print_Debug('Bulk Size =' ||l_var);
748: IEX_TERR_WINNERS_PUB.Print_Debug('Cursor Fetch Size =' ||l_max_fetches);
749:
750: CheckCollectors(x_errbuf, x_retcode, l_worker_id, p_terr_globals);

Line 757: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Site Profiles started ... ');

753: IEX_TERR_WINNERS_PUB.Print_Debug('Not able to proceed with update, returning back');
754: return;
755: end if;
756: IEX_TERR_WINNERS_PUB.Print_Debug('Updating Customer Site Profiles started ... ');
757: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Customer Site Profiles started ... ');
758: --Bug4613487. Fix by lkkumar on 29-Sep-2005. Start.
759: OPEN c_UpdateProfile(l_worker_id);
760: LOOP
761: BEGIN

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');

764: l_org_id, l_Res_type, l_Collector_ID,l_cust_account_id, l_siteuse_id
765: LIMIT l_max_fetches;
766: IF l_customer_id.count = 0 THEN
767: IEX_TERR_WINNERS_PUB.Print_Debug('Update Completed. Exiting the update loop');
768: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update Completed. Exiting the update loop');
769: CLOSE C_UPDATEPROFILE;
770: EXIT;
771: ELSE
772: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);

Line 773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);

769: CLOSE C_UPDATEPROFILE;
770: EXIT;
771: ELSE
772: IEX_TERR_WINNERS_PUB.Print_Debug('Total Rows Fetched ' || l_customer_id.count);
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows Fetched ' || l_customer_id.count);
774:
775: FORALL i in l_customer_id.first..l_customer_id.last
776: UPDATE HZ_CUSTOMER_PROFILES ACC
777: SET object_version_number = nvl(object_version_number,0) + 1,

Line 792: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Site Profile Rows Updated ' || l_customer_id.count);

788: AND ACC.SITE_USE_ID = l_siteuse_id(i)
789: AND ACC.COLLECTOR_ID <> l_collector_id(i);
790: --Commit When the Bulk commit size is reached.
791: IEX_TERR_WINNERS_PUB.Print_Debug('Total Customer Site Profile Rows Updated ' || l_customer_id.count);
792: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Site Profile Rows Updated ' || l_customer_id.count);
793: COMMIT;
794: END IF;
795: EXCEPTION WHEN deadlock_detected THEN
796: BEGIN

Line 798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during bulk update.. Performing row update..');

794: END IF;
795: EXCEPTION WHEN deadlock_detected THEN
796: BEGIN
797: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during bulk update.. Performing row update..');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deadlock encountered during bulk update.. Performing row update..');
799: ROLLBACK;
800: FOR i in l_first .. l_last LOOP
801: BEGIN
802: l_cnt := l_cnt + 1;

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Site Profile Rows Updated ' ||l_cnt);

820: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
821: ' SQLERRM: ' || SQLERRM);
822: END;
823: END LOOP;
824: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Customer Site Profile Rows Updated ' ||l_cnt);
825: l_cnt := 0;
826: END;
827: WHEN OTHERS THEN
828: IEX_TERR_WINNERS_PUB.Print_Debug('Exception occured while updating site profile '||sqlerrm);

Line 1011: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted to the AR_COLLECTORS. Collector_ID ');

1007: 'A',
1008: l_missSF_id(i),
1009: decode(l_missResType(i),'RS_GROUP','RS_GROUP','RS_RESOURCE' )) ;
1010:
1011: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted to the AR_COLLECTORS. Collector_ID ');
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );

Line 1015: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );

1011: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted to the AR_COLLECTORS. Collector_ID ');
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
1016: END;
1017: COMMIT;
1018: END LOOP;
1019: l_attempts := 3;

Line 1069: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After Inserting in to the AR_COLLECTORS');

1065: 'A',
1066: l_missSF_id(i),
1067: decode(l_missResType(i),'RS_GROUP','RS_GROUP','RS_RESOURCE' )) ;
1068:
1069: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After Inserting in to the AR_COLLECTORS');
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: IEX_TERR_WINNERS_PUB.Print_Debug('Others Exception during single row update');

Line 1163: FND_FILE.PUT_LINE(FND_FILE.LOG,' * Creating Party Profiles..... *');

1159: GROUP BY WIN.TRANS_OBJECT_id;
1160: l_profile_id NUMBER;
1161:
1162: Begin
1163: FND_FILE.PUT_LINE(FND_FILE.LOG,' *** Creating Party Profiles..... ***');
1164:
1165: -- Bulk Read the Non-existents in AR_COLLECTORS
1166: l_loop_count := 0;
1167: l_max_fetches := p_terr_globals.cursor_limit;

Line 1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'--- Start. Creating customer Profiles = . ' || l_missCustomer.count);

1205: l_limit_flag := TRUE;
1206: end if;
1207:
1208: IEX_TERR_WINNERS_PUB.Print_Debug('--- Start. Creating customer Profiles = . ' || l_missCustomer.count);
1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'--- Start. Creating customer Profiles = . ' || l_missCustomer.count);
1210:
1211: IF l_missCustomer.count > 0 THEN -- if Missed Customer Profiles .count > 0
1212:
1213: IEX_TERR_WINNERS_PUB.Print_Debug('Inside IF, --- While Flag Loop -----');

Line 1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );

1246: IEX_TERR_WINNERS_PUB.Print_Debug('Created Profile Id ' || l_customer_profile_id);
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
1251: END;
1252: END;
1253: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. END.
1254: END LOOP;

Line 1258: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records Updated: ' || l_first || '-'|| l_last);

1254: END LOOP;
1255: COMMIT;
1256: l_attempts := 3;
1257: IEX_TERR_WINNERS_PUB.Print_Debug('Records Updated: ' || l_first || '-'|| l_last);
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records Updated: ' || l_first || '-'|| l_last);
1259: EXCEPTION
1260: WHEN deadlock_detected THEN
1261: begin
1262: IEX_TERR_WINNERS_PUB.Print_Debug('Deadlock encountered during bulk update-'||l_attempts);

Line 1392: FND_FILE.PUT_LINE(FND_FILE.LOG,'* Creating Site Profiles ...... *');

1388: GROUP BY WIN.TRANS_OBJECT_ID, acct_site.cust_account_id, hzp.SITE_USE_ID;
1389:
1390: Begin
1391:
1392: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Creating Site Profiles ...... ***');
1393: -- Bulk Read the Non-existents in HZ_CUSTOMER_PROFILES Customer Sites
1394: l_loop_count := 0;
1395: l_max_fetches := p_terr_globals.cursor_limit;
1396: LOOP

Line 1470: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );

1466: IEX_TERR_WINNERS_PUB.Print_Debug(' Created Profile Id ' || l_customer_profile_id);
1467:
1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
1471: END;
1472: COMMIT;
1473: END LOOP;
1474: l_attempts := 3;

Line 1527: FND_FILE.PUT_LINE(FND_FILE.LOG,'---Create SiteUse Profile.End-'|| l_missCustomer.count||' Rows Updated.');

1523: END LOOP; /* Update While loop; l_attempts < 3 */
1524:
1525: END IF; --l_missCustomer .count > 0
1526: IEX_TERR_WINNERS_PUB.Print_Debug('---Create SiteUse Profile.End-'|| l_missCustomer.count||' Rows Updated.');
1527: FND_FILE.PUT_LINE(FND_FILE.LOG,'---Create SiteUse Profile.End-'|| l_missCustomer.count||' Rows Updated.');
1528: --------------------------------
1529: END LOOP; -- End Bulk read non-existent Customer Profiles attempts < 3
1530:
1531: