DBA Data[Home] [Help]

APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on IEX_PROCESS_ACCOUNT_WINNERS

Line 1: PACKAGE BODY IEX_PROCESS_ACCOUNT_WINNERS AS

1: PACKAGE BODY IEX_PROCESS_ACCOUNT_WINNERS AS
2: /* $Header: iextpawb.pls 120.15 2011/09/09 13:41:48 ehuh noship $ */
3:
4: /*-------------------------------------------------------------------------*
5: | PRIVATE CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_PROCESS_ACCOUNT_WINNERS';

3:
4: /*-------------------------------------------------------------------------*
5: | PRIVATE CONSTANTS
6: *-------------------------------------------------------------------------*/
7: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_PROCESS_ACCOUNT_WINNERS';
8: G_FILE_NAME CONSTANT VARCHAR2(12):='iextpawb.pls';
9: deadlock_detected EXCEPTION;
10: PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
11:

Line 105: IEX_TERR_WINNERS_PUB.Print_Debug('*** iextpawb.pls::IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records() ***');

101: -------------------------------------------------------------------------------
102:
103:
104: BEGIN
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');

Line 126: IEX_TERR_WINNERS_PUB.Print_Debug('CheckCollectors Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');

122:
123: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CheckCollectors');
124: CheckCollectors(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
125: if (x_retcode = 'E') then
126: IEX_TERR_WINNERS_PUB.Print_Debug('CheckCollectors Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
127: return;
128: end if;
129:
130: if (l_AssignLevel = 'PARTY') then

Line 134: IEX_TERR_WINNERS_PUB.Print_Debug('CreatePartyProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');

130: if (l_AssignLevel = 'PARTY') then
131: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CreatePartyProfiles');
132: CreatePartyProfiles(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
133: if (x_retcode = 'E') then
134: IEX_TERR_WINNERS_PUB.Print_Debug('CreatePartyProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
135: return;
136: end if;
137: IEX_TERR_WINNERS_PUB.Print_Debug('Calling AssignPartyCollectors');
138: AssignPartyCollectors(x_errbuf, x_retcode, p_terr_globals);

Line 148: IEX_TERR_WINNERS_PUB.Print_Debug('CreateSiteuseProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');

144: else
145: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CreateSiteUseProfiles');
146: CreateSiteUseProfiles(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
147: if (x_retcode = 'E') then
148: IEX_TERR_WINNERS_PUB.Print_Debug('CreateSiteuseProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
149: return;
150: end if;
151: IEX_TERR_WINNERS_PUB.Print_Debug('Calling AssignSiteUseCollectors ');
152: AssignSiteUseCollectors(x_errbuf, x_retcode, p_terr_globals);

Line 161: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');

157:
158: EXCEPTION
159:
160: WHEN others THEN
161: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
162: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
163: ' SQLERRM: ' || SQLERRM);
164: x_errbuf := SQLERRM;
165: x_retcode := SQLCODE;

Line 859: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::AssignSiteUseCollectors');

855: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;
856: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
857: RAISE;
858: WHEN others THEN
859: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::AssignSiteUseCollectors');
860: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
861: ' SQLERRM: ' || SQLERRM);
862: x_errbuf := SQLERRM;
863: x_retcode := SQLCODE;

Line 1541: END IEX_PROCESS_ACCOUNT_WINNERS;

1537: x_retcode := SQLCODE;
1538: RAISE;
1539: END CreateSiteUseProfiles;
1540:
1541: END IEX_PROCESS_ACCOUNT_WINNERS;