APPS.IEX_TERR_ASSIGNMENT_CLEANUP dependencies on IEX_TERR_ASSIGNMENT_CLEANUP

Line 1: PACKAGE BODY IEX_TERR_ASSIGNMENT_CLEANUP AS

1: PACKAGE BODY IEX_TERR_ASSIGNMENT_CLEANUP AS
2: /* $Header: iexttacb.pls 120.1 2005/10/28 05:06:05 lkkumar noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: IEX_TERR_ASSIGNMENT_CLEANUP

3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
6: ---------------------------------------------------------------------------
7: -- PACKAGE NAME: IEX_TERR_ASSIGNMENT_CLEANUP
8: -- ---------------------------------------------------------------------
9: -- PURPOSE
10: --
11: -- Dependent Package for the concurrent program "Generate Access Records".

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_TERR_ASSIGNMENT_CLEANUP';

25:
26: /*-------------------------------------------------------------------------+
27: | PRIVATE CONSTANTS
28: +-------------------------------------------------------------------------*/
29: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_TERR_ASSIGNMENT_CLEANUP';
30: G_FILE_NAME CONSTANT VARCHAR2(12):='iexttacb.pls';
31:
32: -- ffang 121302, bug 2703096
33: -- Number of record to do an incremental commit

Line 77: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Cleanup_Duplicate_Resources');

73: BEGIN
74: NULL;
75: EXCEPTION
76: WHEN others THEN
77: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Cleanup_Duplicate_Resources');
78: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
79: ' SQLERRM: ' || SQLERRM);
80: x_errbuf := SQLERRM;
81: x_retcode := SQLCODE;

Line 158: IEX_TERR_WINNERS_PUB.Print_Debug('*** iexttacb.pls::IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Account_Cleanup() ***');

154: FROM JTF_TAE_1001_ACCOUNT_TRANS
155: WHERE worker_id=c_worker_id;
156:
157: BEGIN
158: IEX_TERR_WINNERS_PUB.Print_Debug('*** iexttacb.pls::IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Account_Cleanup() ***');
159:
160: /** Commented because we are not writing anything into as_access_all_all **/
161:
162: EXCEPTION

Line 164: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Account_Cleanup');

160: /** Commented because we are not writing anything into as_access_all_all **/
161:
162: EXCEPTION
163: WHEN others THEN
164: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Account_Cleanup');
165: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
166: ' SQLERRM: ' || SQLERRM);
167: x_errbuf := SQLERRM;
168: x_retcode := SQLCODE;

Line 240: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Chgd_Accts_Cleanup');

236: /** Commented because we are not writing anything into as_access_all_all **/
237:
238: EXCEPTION
239: WHEN others THEN
240: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_TERR_ASSIGNMENT_CLEANUP::Perform_Chgd_Accts_Cleanup');
241: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
242: ' SQLERRM: ' || SQLERRM);
243: x_errbuf := SQLERRM;
244: x_retcode := SQLCODE;

Line 249: END IEX_TERR_ASSIGNMENT_CLEANUP;

245: --RAISE;
246:
247: END Perform_Chgd_Accts_Cleanup;
248:
249: END IEX_TERR_ASSIGNMENT_CLEANUP;