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.IEM_WFSTARTPROCESS_PUB dependencies on FND_API

Line 48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT CallWorkflow_PUB;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN

Line 56: IF FND_API.to_Boolean( p_init_msg_list )

52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60: -- Initialize API return status to SUCCESS

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: -- Standard callto get message count and if count is 1, get message info.
64: FND_MSG_PUB.Count_And_Get
65: ( p_count => x_msg_count,

Line 69: WHEN FND_API.G_EXC_ERROR THEN

65: ( p_count => x_msg_count,
66: p_data => x_msg_data
67: );
68: EXCEPTION
69: WHEN FND_API.G_EXC_ERROR THEN
70: ROLLBACK TO CallWorkFlow_PUB;
71: x_return_status := FND_API.G_RET_STS_ERROR ;
72: FND_MSG_PUB.Count_And_Get
73: ( p_count => x_msg_count,

Line 71: x_return_status := FND_API.G_RET_STS_ERROR ;

67: );
68: EXCEPTION
69: WHEN FND_API.G_EXC_ERROR THEN
70: ROLLBACK TO CallWorkFlow_PUB;
71: x_return_status := FND_API.G_RET_STS_ERROR ;
72: FND_MSG_PUB.Count_And_Get
73: ( p_count => x_msg_count,
74: p_data => x_msg_data
75: );

Line 76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

72: FND_MSG_PUB.Count_And_Get
73: ( p_count => x_msg_count,
74: p_data => x_msg_data
75: );
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO CallWorkFlow_PUB;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
79: FND_MSG_PUB.Count_And_Get
80: ( p_count => x_msg_count,

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

74: p_data => x_msg_data
75: );
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO CallWorkFlow_PUB;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
79: FND_MSG_PUB.Count_And_Get
80: ( p_count => x_msg_count,
81: p_data => x_msg_data
82: );

Line 87: x_return_status := FND_API.G_RET_STS_ERROR;

83: WHEN l_wf_excep THEN
84: ROLLBACK TO CallWorkFlow_PUB;
85: WHEN OTHERS THEN
86: ROLLBACK TO CallWorkFlow_PUB;
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level
89: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg

Line 106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

102:
103: PROCEDURE LaunchProcess(ERRBUF OUT NOCOPY VARCHAR2,
104: ERRRET OUT NOCOPY VARCHAR2,
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_workflowProcess in varchar2 :=null,
109: p_Item_Type in varchar2 :=null,
110: p_qopt in varchar2:='FOREVER',

Line 107: p_commit IN VARCHAR2 := FND_API.G_FALSE,

103: PROCEDURE LaunchProcess(ERRBUF OUT NOCOPY VARCHAR2,
104: ERRRET OUT NOCOPY VARCHAR2,
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_workflowProcess in varchar2 :=null,
109: p_Item_Type in varchar2 :=null,
110: p_qopt in varchar2:='FOREVER',
111: p_counter in number

Line 130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

126: BEGIN
127: -- Standard Start of API savepoint
128: SAVEPOINT LaunchProcess_PUB;
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)
134: THEN

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list )
139: THEN

Line 138: IF FND_API.to_Boolean( p_init_msg_list )

134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list )
139: THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:

Line 144: WHEN FND_API.G_EXC_ERROR THEN

140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: ROLLBACK TO LaunchProcess_PUB;
146: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
147: l_Error_Message := FND_MESSAGE.GET;
148: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
147: l_Error_Message := FND_MESSAGE.GET;
148: fnd_file.put_line(fnd_file.log, l_Error_Message);
149: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO LaunchProcess_PUB;
152: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');
153: l_Error_Message := FND_MESSAGE.GET;
154: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

163:
164: PROCEDURE ProcessRetry(ERRBUF OUT NOCOPY VARCHAR2,
165: ERRRET OUT NOCOPY VARCHAR2,
166: p_api_version_number in number,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_TRUE,
169: p_workflowProcess in varchar2 :=null,
170: p_Item_Type in varchar2 :=null
171: ) IS

Line 168: p_commit IN VARCHAR2 := FND_API.G_TRUE,

164: PROCEDURE ProcessRetry(ERRBUF OUT NOCOPY VARCHAR2,
165: ERRRET OUT NOCOPY VARCHAR2,
166: p_api_version_number in number,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
168: p_commit IN VARCHAR2 := FND_API.G_TRUE,
169: p_workflowProcess in varchar2 :=null,
170: p_Item_Type in varchar2 :=null
171: ) IS
172:

Line 179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

175: END ProcessRetry;
176: PROCEDURE StopWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
177: ERRRET OUT NOCOPY VARCHAR2,
178: p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_TRUE
181: ) IS
182: l_api_name VARCHAR2(255):='StopWorkflow';
183: l_api_version_number NUMBER:=1.0;

Line 180: p_commit IN VARCHAR2 := FND_API.G_TRUE

176: PROCEDURE StopWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
177: ERRRET OUT NOCOPY VARCHAR2,
178: p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_TRUE
181: ) IS
182: l_api_name VARCHAR2(255):='StopWorkflow';
183: l_api_version_number NUMBER:=1.0;
184: l_msg_count number;

Line 193: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

189: BEGIN
190: -- Standard Start of API savepoint
191: SAVEPOINT StopWorkflow_PUB;
192: -- Standard call to check for call compatibility.
193: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
194: p_api_version_number,
195: l_api_name,
196: G_PKG_NAME)
197: THEN

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: p_api_version_number,
195: l_api_name,
196: G_PKG_NAME)
197: THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN

Line 202: WHEN FND_API.G_EXC_ERROR THEN

198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO Stopworkflow_PUB;
204: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
205: l_Error_Message := FND_MESSAGE.GET;
206: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

204: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
205: l_Error_Message := FND_MESSAGE.GET;
206: fnd_file.put_line(fnd_file.log, l_Error_Message);
207: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO Stopworkflow_PUB;
210: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
211: l_Error_Message := FND_MESSAGE.GET;
212: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

221: END StopWorkflow;
222: PROCEDURE PurgeWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
223: ERRRET OUT NOCOPY VARCHAR2,
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_TRUE,
227: p_item_type IN VARCHAR2:='IEM_MAIL',
228: p_end_date IN varchar2
229: ) IS

Line 226: p_commit IN VARCHAR2 := FND_API.G_TRUE,

222: PROCEDURE PurgeWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
223: ERRRET OUT NOCOPY VARCHAR2,
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_TRUE,
227: p_item_type IN VARCHAR2:='IEM_MAIL',
228: p_end_date IN varchar2
229: ) IS
230: l_api_name VARCHAR2(255):='PurgeWorkflow';

Line 248: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

244: BEGIN
245: -- Standard Start of API savepoint
246: SAVEPOINT PurgeWorkflow_PUB;
247: -- Standard call to check for call compatibility.
248: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)
252: THEN

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)
252: THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255: -- Initialize message list if p_init_msg_list is set to TRUE.
256: IF FND_API.to_Boolean( p_init_msg_list )
257: THEN

Line 256: IF FND_API.to_Boolean( p_init_msg_list )

252: THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255: -- Initialize message list if p_init_msg_list is set to TRUE.
256: IF FND_API.to_Boolean( p_init_msg_list )
257: THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to SUCCESS

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: END LOOP;
268: l_date := to_date(p_end_Date,'YYYY/MM/DD HH24:MI:SS');
269: wf_purge.total(p_item_type,null,l_date);
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO Purgeworkflow_PUB;
273: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_EXEC_ERROR');
274: l_Error_Message := FND_MESSAGE.GET;
275: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

273: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_EXEC_ERROR');
274: l_Error_Message := FND_MESSAGE.GET;
275: fnd_file.put_line(fnd_file.log, l_Error_Message);
276: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO Purgeworkflow_PUB;
279: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_UNXPTD_ERR');
280: l_Error_Message := FND_MESSAGE.GET;
281: fnd_file.put_line(fnd_file.log, l_Error_Message);