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.7.12010000.2 2008/08/06 09:03:21 schekuri ship $ */
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 100: IEX_TERR_WINNERS_PUB.Print_Debug('*** iextpawb.pls::IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records() ***');

96: -------------------------------------------------------------------------------
97:
98:
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);

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

110:
111: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CheckCollectors');
112: CheckCollectors(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
113: if (x_retcode = 'E') then
114: IEX_TERR_WINNERS_PUB.Print_Debug('CheckCollectors Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
115: return;
116: end if;
117:
118: if (l_AssignLevel = 'PARTY') then

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

118: if (l_AssignLevel = 'PARTY') then
119: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CreatePartyProfiles');
120: CreatePartyProfiles(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
121: if (x_retcode = 'E') then
122: IEX_TERR_WINNERS_PUB.Print_Debug('CreatePartyProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
123: return;
124: end if;
125: IEX_TERR_WINNERS_PUB.Print_Debug('Calling AssignPartyCollectors');
126: AssignPartyCollectors(x_errbuf, x_retcode, p_terr_globals);

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

132: else
133: IEX_TERR_WINNERS_PUB.Print_Debug('Calling CreateSiteUseProfiles');
134: CreateSiteUseProfiles(x_errbuf, x_retcode, l_worker_id, p_terr_globals);
135: if (x_retcode = 'E') then
136: IEX_TERR_WINNERS_PUB.Print_Debug('CreateSiteuseProfiles Exception: in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
137: return;
138: end if;
139: IEX_TERR_WINNERS_PUB.Print_Debug('Calling AssignSiteUseCollectors ');
140: AssignSiteUseCollectors(x_errbuf, x_retcode, p_terr_globals);

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

145:
146: EXCEPTION
147:
148: WHEN others THEN
149: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::Process_Account_Records');
150: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
151: ' SQLERRM: ' || SQLERRM);
152: x_errbuf := SQLERRM;
153: x_retcode := SQLCODE;

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

797: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;
798: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
799: RAISE;
800: WHEN others THEN
801: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_PROCESS_ACCOUNT_WINNERS::AssignSiteUseCollectors');
802: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
803: ' SQLERRM: ' || SQLERRM);
804: x_errbuf := SQLERRM;
805: x_retcode := SQLCODE;

Line 1475: END IEX_PROCESS_ACCOUNT_WINNERS;

1471: x_retcode := SQLCODE;
1472: RAISE;
1473: END CreateSiteUseProfiles;
1474:
1475: END IEX_PROCESS_ACCOUNT_WINNERS;