DBA Data[Home] [Help]

APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on FND_FILE

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

99: BEGIN
100: IEX_TERR_WINNERS_PUB.Print_Debug('*** iextpawb.pls::IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records() ***');
101:
102: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449
106:
107: l_worker_id:=p_terr_globals.worker_id;

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

100: IEX_TERR_WINNERS_PUB.Print_Debug('*** iextpawb.pls::IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records() ***');
101:
102: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449
106:
107: l_worker_id:=p_terr_globals.worker_id;
108: l_var :=p_terr_globals.bulk_size;

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

101:
102: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Process Accounts Program started');
104: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
105: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel); -- changed by gnramasa on 29/08/2006 for bug # 5487449
106:
107: l_worker_id:=p_terr_globals.worker_id;
108: l_var :=p_terr_globals.bulk_size;
109: IEX_TERR_WINNERS_PUB.Print_Debug('bulk size='||l_var);

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

242: BEGIN
243: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
244:
245: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
248:
249: l_worker_id:=p_terr_globals.worker_id;
250: -- Bulk Read the Territory Assignments

Line 247: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);

243: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
244:
245: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
248:
249: l_worker_id:=p_terr_globals.worker_id;
250: -- Bulk Read the Territory Assignments
251: l_var :=p_terr_globals.bulk_size;

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

436: BEGIN
437: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
438:
439: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
440: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
442:
443: l_worker_id:=p_terr_globals.worker_id;
444: -- Bulk Read the Territory Assignments

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);

437: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
438:
439: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
440: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Program started');
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
442:
443: l_worker_id:=p_terr_globals.worker_id;
444: -- Bulk Read the Territory Assignments
445: l_var :=p_terr_globals.bulk_size;

Line 697: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);

693: l_var :=p_terr_globals.bulk_size;
694: l_max_fetches := p_terr_globals.cursor_limit;
695:
696:
697: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Level (Picked from IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
698: IEX_TERR_WINNERS_PUB.Print_Debug('Bulk Size =' ||l_var);
699: IEX_TERR_WINNERS_PUB.Print_Debug('Cursor Fetch Size =' ||l_max_fetches);
700:
701: CheckCollectors(x_errbuf, x_retcode, l_worker_id, p_terr_globals);

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

949: 'A',
950: l_missSF_id(i),
951: decode(l_missResType(i),'RS_GROUP','RS_GROUP','RS_RESOURCE' )) ;
952:
953: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted to the AR_COLLECTORS. Collector_ID ');
954:
955: EXCEPTION
956: WHEN OTHERS THEN
957: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );

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

953: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted to the AR_COLLECTORS. Collector_ID ');
954:
955: EXCEPTION
956: WHEN OTHERS THEN
957: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
958: END;
959: COMMIT;
960: END LOOP;
961: l_attempts := 3;

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

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, ' After Inserting in to the AR_COLLECTORS');
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: IEX_TERR_WINNERS_PUB.Print_Debug('Others Exception during single row update');

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

1185: IEX_TERR_WINNERS_PUB.Print_Debug(' Created Profile Id ' || l_customer_profile_id);
1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
1190: END;
1191: END;
1192: --Bug4574749. Fix By LKKUMAR on 12-Oct-2005. END.
1193: END LOOP;

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

1401: IEX_TERR_WINNERS_PUB.Print_Debug(' Created Profile Id ' || l_customer_profile_id);
1402:
1403: EXCEPTION
1404: WHEN OTHERS THEN
1405: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error while selecting resource/groupname' );
1406: END;
1407: COMMIT;
1408: END LOOP;
1409: l_attempts := 3;