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.XDP_CRON_UTIL dependencies on XDP_CRON_UTIL

Line 1: PACKAGE BODY XDP_CRON_UTIL AS

1: PACKAGE BODY XDP_CRON_UTIL AS
2: /* $Header: XDPCRONB.pls 120.1 2005/06/08 23:51:10 appldev $ */
3:
4: Procedure SubmitAdapterAdminJob (
5: p_request in number,

Line 13: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.SUBMITADAPTERADMINJOB',

9: IS
10: l_tmpdate varchar2(4000);
11: BEGIN
12: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
13: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.SUBMITADAPTERADMINJOB',
14: 'BEGIN:p_request: '||p_request);
15: END IF;
16:
17: if p_RunFreq is not null then

Line 29: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.SUBMITADAPTERADMINJOB',

25: next_date => p_RunDate,
26: interval =>l_tmpdate);
27:
28: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
29: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.SUBMITADAPTERADMINJOB',
30: 'END:Job: '||p_JobNumber);
31: END IF;
32:
33: END SubmitAdapterAdminJob;

Line 45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.UPDATEDBJOB',

41: is
42: l_tmpdate varchar2(4000);
43: begin
44: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
45: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.UPDATEDBJOB',
46: 'BEGIN:p_request: '||p_request);
47: END IF;
48:
49: if p_Freq is not null then

Line 83: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

79: l_User varchar2(40);
80:
81: BEGIN
82: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
83: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
84: 'BEGIN:p_request: '||p_request);
85: END IF;
86:
87: BEGIN

Line 109: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

105: -- With the deletion of request, job for future will anyway be deleted
106:
107: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
108: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
109: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
110: 'After FetchAdapterAdminReqInfo, SQLCODE: '||SQLCODE);
111: END IF;
112: return;
113: END;

Line 116: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

112: return;
113: END;
114:
115: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
116: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
117: 'Request Type: '||l_requestCode||
118: ', Job no.: '||l_job_no||
119: ', Channel name: '||l_ChannelName);
120: END IF;

Line 152: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

148: -- Following operation will also not get lock
149: -- and the logic will flow.
150: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
151: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
152: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
153: 'Could get lock after waiting for :'||l_LockTimeout||' secs');
154: END IF;
155: end if;
156:

Line 184: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

180: l_RetCode, l_ErrorMsg);
181: end if;
182:
183: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
184: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
185: 'After adapter operation, Return code: '||l_RetCode);
186: END IF;
187:
188: l_Status := XDP_ADAPTER.pv_adminStatusCompleted;

Line 206: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

202: if l_Freq is null then
203:
204: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
205: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
206: 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
207: 'Frequency is null, removing job');
208: END IF;
209: -- dbms_output.put_line('No Freq found... updating req');
210:

Line 217: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

213: -- Donot care for l_RetCode
214: end if;
215:
216: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
217: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
218: 'Request audited with status: '||l_Status);
219: END IF;
220:
221: XDP_ADAPTER_CORE_DB.Audit_Adapter_Admin_Request (

Line 238: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',

234: WHEN OTHERS THEN
235: -- Can come here only because of some SQL error in XDP_ADAPTER_CORE_DB.Audit_Adapter_Admin_Request
236: -- Still we need to commit;
237: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
238: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
239: 'Unhandled error, SQLCODE: '||SQLCODE);
240: END IF;
241: l_Status := XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName => l_ChannelName);
242: commit;

Line 246: end XDP_CRON_UTIL;

242: commit;
243:
244: END Execute_Adapter_Admin;
245:
246: end XDP_CRON_UTIL;