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

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

80: /*****************************************************************************************/
81:
82: PROCEDURE Create_Act_Resource
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,

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

81:
82: PROCEDURE Create_Act_Resource
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,

Line 86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

82: PROCEDURE Create_Act_Resource
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_act_Resource_rec IN act_Resource_rec_type,

Line 111: IF FND_API.to_Boolean( p_init_msg_list )

107: -- Standard Start of API savepoint
108: SAVEPOINT Create_Act_Resource_PUB;
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list )
112: THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
118:
119:
120: -- Initialize API return status to SUCCESS
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: -- convert public parameter to private-type
124: Convert_PubRec_To_PvtRec(l_pub_resource_rec,l_pvt_resource_rec);
125:

Line 134: IF l_return_status = FND_API.g_ret_sts_error THEN

130: l_pub_resource_rec,
131: l_return_status
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;

Line 135: RAISE FND_API.g_exc_error;

131: l_return_status
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: END IF;

Line 136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: END IF;
140:

Line 137: RAISE FND_API.g_exc_unexpected_error;

133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: RAISE FND_API.g_exc_error;
136: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139: END IF;
140:
141: -- vertical industry pre-processing

Line 149: IF l_return_status = FND_API.g_ret_sts_error THEN

145: l_pub_resource_rec,
146: l_return_status
147: );
148:
149: IF l_return_status = FND_API.g_ret_sts_error THEN
150: RAISE FND_API.g_exc_error;
151: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
152: RAISE FND_API.g_exc_unexpected_error;
153: END IF;

Line 150: RAISE FND_API.g_exc_error;

146: l_return_status
147: );
148:
149: IF l_return_status = FND_API.g_ret_sts_error THEN
150: RAISE FND_API.g_exc_error;
151: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
152: RAISE FND_API.g_exc_unexpected_error;
153: END IF;
154: END IF;

Line 151: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

147: );
148:
149: IF l_return_status = FND_API.g_ret_sts_error THEN
150: RAISE FND_API.g_exc_error;
151: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
152: RAISE FND_API.g_exc_unexpected_error;
153: END IF;
154: END IF;
155:

Line 152: RAISE FND_API.g_exc_unexpected_error;

148:
149: IF l_return_status = FND_API.g_ret_sts_error THEN
150: RAISE FND_API.g_exc_error;
151: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
152: RAISE FND_API.g_exc_unexpected_error;
153: END IF;
154: END IF;
155:
156:

Line 174: IF x_return_status = FND_API.G_RET_STS_ERROR then

170: );
171:
172:
173: -- Check return status from the above procedure call
174: IF x_return_status = FND_API.G_RET_STS_ERROR then
175: RAISE FND_API.G_EXC_ERROR;
176: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;

Line 175: RAISE FND_API.G_EXC_ERROR;

171:
172:
173: -- Check return status from the above procedure call
174: IF x_return_status = FND_API.G_RET_STS_ERROR then
175: RAISE FND_API.G_EXC_ERROR;
176: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: --

Line 176: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

172:
173: -- Check return status from the above procedure call
174: IF x_return_status = FND_API.G_RET_STS_ERROR then
175: RAISE FND_API.G_EXC_ERROR;
176: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: --
180: -- End of API body.

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: -- Check return status from the above procedure call
174: IF x_return_status = FND_API.G_RET_STS_ERROR then
175: RAISE FND_API.G_EXC_ERROR;
176: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: --
180: -- End of API body.
181: --

Line 191: IF l_return_status = FND_API.g_ret_sts_error THEN

187: x_act_resource_id,
188: l_return_status
189: );
190:
191: IF l_return_status = FND_API.g_ret_sts_error THEN
192: RAISE FND_API.g_exc_error;
193: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;

Line 192: RAISE FND_API.g_exc_error;

188: l_return_status
189: );
190:
191: IF l_return_status = FND_API.g_ret_sts_error THEN
192: RAISE FND_API.g_exc_error;
193: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196: END IF;

Line 193: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

189: );
190:
191: IF l_return_status = FND_API.g_ret_sts_error THEN
192: RAISE FND_API.g_exc_error;
193: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196: END IF;
197:

Line 194: RAISE FND_API.g_exc_unexpected_error;

190:
191: IF l_return_status = FND_API.g_ret_sts_error THEN
192: RAISE FND_API.g_exc_error;
193: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196: END IF;
197:
198: -- vertical industry post-processing

Line 207: IF l_return_status = FND_API.g_ret_sts_error THEN

203: x_act_resource_id,
204: l_return_status
205: );
206:
207: IF l_return_status = FND_API.g_ret_sts_error THEN
208: RAISE FND_API.g_exc_error;
209: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
210: RAISE FND_API.g_exc_unexpected_error;
211: END IF;

Line 208: RAISE FND_API.g_exc_error;

204: l_return_status
205: );
206:
207: IF l_return_status = FND_API.g_ret_sts_error THEN
208: RAISE FND_API.g_exc_error;
209: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
210: RAISE FND_API.g_exc_unexpected_error;
211: END IF;
212: END IF;

Line 209: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

205: );
206:
207: IF l_return_status = FND_API.g_ret_sts_error THEN
208: RAISE FND_API.g_exc_error;
209: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
210: RAISE FND_API.g_exc_unexpected_error;
211: END IF;
212: END IF;
213:

Line 210: RAISE FND_API.g_exc_unexpected_error;

206:
207: IF l_return_status = FND_API.g_ret_sts_error THEN
208: RAISE FND_API.g_exc_error;
209: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
210: RAISE FND_API.g_exc_unexpected_error;
211: END IF;
212: END IF;
213:
214:

Line 216: IF FND_API.to_Boolean( p_commit )

212: END IF;
213:
214:
215: -- Standard check for p_commit
216: IF FND_API.to_Boolean( p_commit )
217: THEN
218: COMMIT WORK;
219: END IF;
220:

Line 233: x_return_status := FND_API.g_ret_sts_error;

229: );
230:
231: EXCEPTION
232: WHEN AMS_Utility_PVT.resource_locked THEN
233: x_return_status := FND_API.g_ret_sts_error;
234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
235: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
236: FND_MSG_PUB.add;
237: END IF;

Line 239: WHEN FND_API.G_EXC_ERROR THEN

235: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
236: FND_MSG_PUB.add;
237: END IF;
238:
239: WHEN FND_API.G_EXC_ERROR THEN
240: ROLLBACK TO Create_Act_Resource_PUB;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237: END IF;
238:
239: WHEN FND_API.G_EXC_ERROR THEN
240: ROLLBACK TO Create_Act_Resource_PUB;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,

Line 244: p_encoded => FND_API.G_FALSE,

240: ROLLBACK TO Create_Act_Resource_PUB;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248:

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Create_Act_Resource_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: );
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Create_Act_Resource_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,

Line 254: p_encoded => FND_API.G_FALSE,

250: ROLLBACK TO Create_Act_Resource_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,
256: p_data => x_msg_data
257: );
258:

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: );
258:
259: WHEN OTHERS THEN
260: ROLLBACK TO Create_Act_Resource_PUB;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
265: END IF;

Line 268: p_encoded => FND_API.G_FALSE,

264: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
265: END IF;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272: End Create_Act_Resource;

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

286: /*****************************************************************************************/
287:
288: PROCEDURE Update_Act_Resource
289: ( p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,

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

287:
288: PROCEDURE Update_Act_Resource
289: ( p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,

Line 292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

288: PROCEDURE Update_Act_Resource
289: ( p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_act_Resource_rec IN act_Resource_rec_type

Line 312: IF FND_API.to_Boolean( p_init_msg_list )

308: -- Standard Start of API savepoint
309: SAVEPOINT Update_Act_Resource_PUB;
310:
311: -- Initialize message list if p_init_msg_list is set to TRUE.
312: IF FND_API.to_Boolean( p_init_msg_list )
313: THEN
314: FND_MSG_PUB.initialize;
315: END IF;
316:

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: -- Debug Message
318: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
319:
320: -- Initialize API return status to SUCCESS
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: -- convert public parameter to private-type
324: Convert_PubRec_To_PvtRec(l_pub_resource_rec,l_pvt_resource_rec);
325:

Line 334: IF l_return_status = FND_API.g_ret_sts_error THEN

330: l_pub_resource_rec,
331: l_return_status
332: );
333:
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;

Line 335: RAISE FND_API.g_exc_error;

331: l_return_status
332: );
333:
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: END IF;

Line 336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

332: );
333:
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: END IF;
340:

Line 337: RAISE FND_API.g_exc_unexpected_error;

333:
334: IF l_return_status = FND_API.g_ret_sts_error THEN
335: RAISE FND_API.g_exc_error;
336: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: END IF;
340:
341: -- vertical industry pre-processing

Line 349: IF l_return_status = FND_API.g_ret_sts_error THEN

345: l_pub_resource_rec,
346: l_return_status
347: );
348:
349: IF l_return_status = FND_API.g_ret_sts_error THEN
350: RAISE FND_API.g_exc_error;
351: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;

Line 350: RAISE FND_API.g_exc_error;

346: l_return_status
347: );
348:
349: IF l_return_status = FND_API.g_ret_sts_error THEN
350: RAISE FND_API.g_exc_error;
351: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354: END IF;

Line 351: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

347: );
348:
349: IF l_return_status = FND_API.g_ret_sts_error THEN
350: RAISE FND_API.g_exc_error;
351: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354: END IF;
355:

Line 352: RAISE FND_API.g_exc_unexpected_error;

348:
349: IF l_return_status = FND_API.g_ret_sts_error THEN
350: RAISE FND_API.g_exc_error;
351: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354: END IF;
355:
356: -- call business API

Line 370: IF x_return_status = FND_API.G_RET_STS_ERROR then

366: );
367:
368:
369: -- Check return status from the above procedure call
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: RAISE FND_API.G_EXC_ERROR;
372: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;

Line 371: RAISE FND_API.G_EXC_ERROR;

367:
368:
369: -- Check return status from the above procedure call
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: RAISE FND_API.G_EXC_ERROR;
372: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375: --

Line 372: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

368:
369: -- Check return status from the above procedure call
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: RAISE FND_API.G_EXC_ERROR;
372: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375: --
376: -- End of API body

Line 373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

369: -- Check return status from the above procedure call
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: RAISE FND_API.G_EXC_ERROR;
372: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375: --
376: -- End of API body
377: --

Line 387: IF l_return_status = FND_API.g_ret_sts_error THEN

383: l_pub_resource_rec,
384: l_return_status
385: );
386:
387: IF l_return_status = FND_API.g_ret_sts_error THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;

Line 388: RAISE FND_API.g_exc_error;

384: l_return_status
385: );
386:
387: IF l_return_status = FND_API.g_ret_sts_error THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392: END IF;

Line 389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

385: );
386:
387: IF l_return_status = FND_API.g_ret_sts_error THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392: END IF;
393:

Line 390: RAISE FND_API.g_exc_unexpected_error;

386:
387: IF l_return_status = FND_API.g_ret_sts_error THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392: END IF;
393:
394: -- customer post-processing

Line 402: IF l_return_status = FND_API.g_ret_sts_error THEN

398: l_pub_resource_rec,
399: l_return_status
400: );
401:
402: IF l_return_status = FND_API.g_ret_sts_error THEN
403: RAISE FND_API.g_exc_error;
404: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;

Line 403: RAISE FND_API.g_exc_error;

399: l_return_status
400: );
401:
402: IF l_return_status = FND_API.g_ret_sts_error THEN
403: RAISE FND_API.g_exc_error;
404: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407: END IF;

Line 404: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

400: );
401:
402: IF l_return_status = FND_API.g_ret_sts_error THEN
403: RAISE FND_API.g_exc_error;
404: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407: END IF;
408:

Line 405: RAISE FND_API.g_exc_unexpected_error;

401:
402: IF l_return_status = FND_API.g_ret_sts_error THEN
403: RAISE FND_API.g_exc_error;
404: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407: END IF;
408:
409: -- Standard check for p_commit

Line 410: IF FND_API.to_Boolean( p_commit )

406: END IF;
407: END IF;
408:
409: -- Standard check for p_commit
410: IF FND_API.to_Boolean( p_commit )
411: THEN
412: COMMIT WORK;
413: END IF;
414:

Line 428: x_return_status := FND_API.g_ret_sts_error;

424:
425: EXCEPTION
426:
427: WHEN AMS_Utility_PVT.resource_locked THEN
428: x_return_status := FND_API.g_ret_sts_error;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
430: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
431: FND_MSG_PUB.add;
432: END IF;

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
431: FND_MSG_PUB.add;
432: END IF;
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO Update_Act_Resource_PUB;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432: END IF;
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO Update_Act_Resource_PUB;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,

Line 439: p_encoded => FND_API.G_FALSE,

435: ROLLBACK TO Update_Act_Resource_PUB;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443:

Line 444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO Update_Act_Resource_PUB;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (

Line 446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

442: );
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO Update_Act_Resource_PUB;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,

Line 449: p_encoded => FND_API.G_FALSE,

445: ROLLBACK TO Update_Act_Resource_PUB;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453:

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: );
453:
454: WHEN OTHERS THEN
455: ROLLBACK TO Update_Act_Resource_PUB;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
460: END IF;

Line 463: p_encoded => FND_API.G_FALSE,

459: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message
462: FND_MSG_PUB.Count_And_Get (
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467: End Update_Act_Resource;

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

482: /*****************************************************************************************/
483:
484: PROCEDURE Delete_Act_Resource
485: ( p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
487: p_commit IN VARCHAR2 := FND_API.G_FALSE,
488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,

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

483:
484: PROCEDURE Delete_Act_Resource
485: ( p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
487: p_commit IN VARCHAR2 := FND_API.G_FALSE,
488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,
491: x_msg_data OUT NOCOPY VARCHAR2,

Line 488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

484: PROCEDURE Delete_Act_Resource
485: ( p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
487: p_commit IN VARCHAR2 := FND_API.G_FALSE,
488: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,
491: x_msg_data OUT NOCOPY VARCHAR2,
492: p_act_Resource_id IN NUMBER,

Line 507: IF FND_API.to_Boolean( p_init_msg_list )

503: -- Standard Start of API savepoint
504: SAVEPOINT Delete_Act_Resource_PUB;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF FND_API.to_Boolean( p_init_msg_list )
508: THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:

Line 516: x_return_status := FND_API.G_RET_STS_SUCCESS;

512: -- Debug Message
513: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
514:
515: -- Initialize API return status to SUCCESS
516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
518: -- customer pre-processing
519: IF JTF_USR_HKS.ok_to_execute(G_PACKAGE_NAME, l_api_name, 'B', 'C')
520: THEN

Line 527: IF l_return_status = FND_API.g_ret_sts_error THEN

523: l_object_version,
524: l_return_status
525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;

Line 528: RAISE FND_API.g_exc_error;

524: l_return_status
525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;

Line 529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;
533:

Line 530: RAISE FND_API.g_exc_unexpected_error;

526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;
533:
534: -- vertical industry pre-processing

Line 543: IF l_return_status = FND_API.g_ret_sts_error THEN

539: l_object_version,
540: l_return_status
541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;

Line 544: RAISE FND_API.g_exc_error;

540: l_return_status
541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;

Line 545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;
549:

Line 546: RAISE FND_API.g_exc_unexpected_error;

542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;
549:
550: -- call business API

Line 565: IF x_return_status = FND_API.G_RET_STS_ERROR then

561: );
562:
563:
564: -- Check return status from the above procedure call
565: IF x_return_status = FND_API.G_RET_STS_ERROR then
566: RAISE FND_API.G_EXC_ERROR;
567: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;

Line 566: RAISE FND_API.G_EXC_ERROR;

562:
563:
564: -- Check return status from the above procedure call
565: IF x_return_status = FND_API.G_RET_STS_ERROR then
566: RAISE FND_API.G_EXC_ERROR;
567: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: --

Line 567: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

563:
564: -- Check return status from the above procedure call
565: IF x_return_status = FND_API.G_RET_STS_ERROR then
566: RAISE FND_API.G_EXC_ERROR;
567: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: --
571: -- End of API body

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: -- Check return status from the above procedure call
565: IF x_return_status = FND_API.G_RET_STS_ERROR then
566: RAISE FND_API.G_EXC_ERROR;
567: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570: --
571: -- End of API body
572: --

Line 583: IF l_return_status = FND_API.g_ret_sts_error THEN

579: l_object_version,
580: l_return_status
581: );
582:
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;

Line 584: RAISE FND_API.g_exc_error;

580: l_return_status
581: );
582:
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;

Line 585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

581: );
582:
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;
589:

Line 586: RAISE FND_API.g_exc_unexpected_error;

582:
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;
589:
590: -- customer post-processing

Line 599: IF l_return_status = FND_API.g_ret_sts_error THEN

595: l_object_version,
596: l_return_status
597: );
598:
599: IF l_return_status = FND_API.g_ret_sts_error THEN
600: RAISE FND_API.g_exc_error;
601: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
602: RAISE FND_API.g_exc_unexpected_error;
603: END IF;

Line 600: RAISE FND_API.g_exc_error;

596: l_return_status
597: );
598:
599: IF l_return_status = FND_API.g_ret_sts_error THEN
600: RAISE FND_API.g_exc_error;
601: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
602: RAISE FND_API.g_exc_unexpected_error;
603: END IF;
604: END IF;

Line 601: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

597: );
598:
599: IF l_return_status = FND_API.g_ret_sts_error THEN
600: RAISE FND_API.g_exc_error;
601: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
602: RAISE FND_API.g_exc_unexpected_error;
603: END IF;
604: END IF;
605:

Line 602: RAISE FND_API.g_exc_unexpected_error;

598:
599: IF l_return_status = FND_API.g_ret_sts_error THEN
600: RAISE FND_API.g_exc_error;
601: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
602: RAISE FND_API.g_exc_unexpected_error;
603: END IF;
604: END IF;
605:
606: -- Standard check for p_commit

Line 607: IF FND_API.to_Boolean( p_commit )

603: END IF;
604: END IF;
605:
606: -- Standard check for p_commit
607: IF FND_API.to_Boolean( p_commit )
608: THEN
609: COMMIT WORK;
610: END IF;
611:

Line 625: x_return_status := FND_API.g_ret_sts_error;

621:
622: EXCEPTION
623:
624: WHEN AMS_Utility_PVT.resource_locked THEN
625: x_return_status := FND_API.g_ret_sts_error;
626: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
627: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
628: FND_MSG_PUB.add;
629: END IF;

Line 631: WHEN FND_API.G_EXC_ERROR THEN

627: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
628: FND_MSG_PUB.add;
629: END IF;
630:
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO Delete_Act_Resource_PUB;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: -- Standard call to get message count and if count=1, get the message
635: FND_MSG_PUB.Count_And_Get (

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629: END IF;
630:
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO Delete_Act_Resource_PUB;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: -- Standard call to get message count and if count=1, get the message
635: FND_MSG_PUB.Count_And_Get (
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,

Line 636: p_encoded => FND_API.G_FALSE,

632: ROLLBACK TO Delete_Act_Resource_PUB;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: -- Standard call to get message count and if count=1, get the message
635: FND_MSG_PUB.Count_And_Get (
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PUB;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PUB;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_msg_count,

Line 646: p_encoded => FND_API.G_FALSE,

642: ROLLBACK TO Delete_Act_Resource_PUB;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );
650:

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: );
650:
651: WHEN OTHERS THEN
652: ROLLBACK TO Delete_Act_Resource_PUB;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN
656: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
657: END IF;

Line 660: p_encoded => FND_API.G_FALSE,

656: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
657: END IF;
658: -- Standard call to get message count and if count=1, get the message
659: FND_MSG_PUB.Count_And_Get (
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_msg_count,
662: p_data => x_msg_data
663: );
664:

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

679: /*****************************************************************************************/
680:
681: PROCEDURE Lock_Act_Resource
682: ( p_api_version IN NUMBER,
683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685:
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,

Line 684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

680:
681: PROCEDURE Lock_Act_Resource
682: ( p_api_version IN NUMBER,
683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685:
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,

Line 704: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

700:
701: BEGIN
702:
703: -- Standard call to check for call compatibility.
704: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
705: p_api_version,
706: l_api_name,
707: G_PACKAGE_NAME)
708: THEN

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

705: p_api_version,
706: l_api_name,
707: G_PACKAGE_NAME)
708: THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Initialize message list if p_init_msg_list is set to TRUE.
713: IF FND_API.to_Boolean( p_init_msg_list )

Line 713: IF FND_API.to_Boolean( p_init_msg_list )

709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
710: END IF;
711:
712: -- Initialize message list if p_init_msg_list is set to TRUE.
713: IF FND_API.to_Boolean( p_init_msg_list )
714: THEN
715: FND_MSG_PUB.initialize;
716: END IF;
717:

Line 724: x_return_status := FND_API.G_RET_STS_SUCCESS;

720:
721: SAVEPOINT lock_act_resource_pub;
722:
723: -- Initialize API return status to SUCCESS
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: -- customer pre-processing
727: IF JTF_USR_HKS.ok_to_execute(G_PACKAGE_NAME, l_api_name, 'B', 'C')
728: THEN

Line 735: IF l_return_status = FND_API.g_ret_sts_error THEN

731: l_object_version,
732: l_return_status
733: );
734:
735: IF l_return_status = FND_API.g_ret_sts_error THEN
736: RAISE FND_API.g_exc_error;
737: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;

Line 736: RAISE FND_API.g_exc_error;

732: l_return_status
733: );
734:
735: IF l_return_status = FND_API.g_ret_sts_error THEN
736: RAISE FND_API.g_exc_error;
737: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740: END IF;

Line 737: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

733: );
734:
735: IF l_return_status = FND_API.g_ret_sts_error THEN
736: RAISE FND_API.g_exc_error;
737: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740: END IF;
741:

Line 738: RAISE FND_API.g_exc_unexpected_error;

734:
735: IF l_return_status = FND_API.g_ret_sts_error THEN
736: RAISE FND_API.g_exc_error;
737: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
738: RAISE FND_API.g_exc_unexpected_error;
739: END IF;
740: END IF;
741:
742: -- vertical industry pre-processing

Line 751: IF l_return_status = FND_API.g_ret_sts_error THEN

747: l_object_version,
748: l_return_status
749: );
750:
751: IF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
754: RAISE FND_API.g_exc_unexpected_error;
755: END IF;

Line 752: RAISE FND_API.g_exc_error;

748: l_return_status
749: );
750:
751: IF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
754: RAISE FND_API.g_exc_unexpected_error;
755: END IF;
756: END IF;

Line 753: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

749: );
750:
751: IF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
754: RAISE FND_API.g_exc_unexpected_error;
755: END IF;
756: END IF;
757:

Line 754: RAISE FND_API.g_exc_unexpected_error;

750:
751: IF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
754: RAISE FND_API.g_exc_unexpected_error;
755: END IF;
756: END IF;
757:
758: -- call business API

Line 771: IF x_return_status = FND_API.G_RET_STS_ERROR then

767: );
768:
769:
770: -- Check return status from the above procedure call
771: IF x_return_status = FND_API.G_RET_STS_ERROR then
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;

Line 772: RAISE FND_API.G_EXC_ERROR;

768:
769:
770: -- Check return status from the above procedure call
771: IF x_return_status = FND_API.G_RET_STS_ERROR then
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: --

Line 773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

769:
770: -- Check return status from the above procedure call
771: IF x_return_status = FND_API.G_RET_STS_ERROR then
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: --
777: -- End of API body.

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770: -- Check return status from the above procedure call
771: IF x_return_status = FND_API.G_RET_STS_ERROR then
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: --
777: -- End of API body.
778: --

Line 789: IF l_return_status = FND_API.g_ret_sts_error THEN

785: l_object_version,
786: l_return_status
787: );
788:
789: IF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
792: RAISE FND_API.g_exc_unexpected_error;
793: END IF;

Line 790: RAISE FND_API.g_exc_error;

786: l_return_status
787: );
788:
789: IF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
792: RAISE FND_API.g_exc_unexpected_error;
793: END IF;
794: END IF;

Line 791: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

787: );
788:
789: IF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
792: RAISE FND_API.g_exc_unexpected_error;
793: END IF;
794: END IF;
795:

Line 792: RAISE FND_API.g_exc_unexpected_error;

788:
789: IF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
792: RAISE FND_API.g_exc_unexpected_error;
793: END IF;
794: END IF;
795:
796: -- customer post-processing

Line 805: IF l_return_status = FND_API.g_ret_sts_error THEN

801: l_object_version,
802: l_return_status
803: );
804:
805: IF l_return_status = FND_API.g_ret_sts_error THEN
806: RAISE FND_API.g_exc_error;
807: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
808: RAISE FND_API.g_exc_unexpected_error;
809: END IF;

Line 806: RAISE FND_API.g_exc_error;

802: l_return_status
803: );
804:
805: IF l_return_status = FND_API.g_ret_sts_error THEN
806: RAISE FND_API.g_exc_error;
807: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
808: RAISE FND_API.g_exc_unexpected_error;
809: END IF;
810: END IF;

Line 807: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

803: );
804:
805: IF l_return_status = FND_API.g_ret_sts_error THEN
806: RAISE FND_API.g_exc_error;
807: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
808: RAISE FND_API.g_exc_unexpected_error;
809: END IF;
810: END IF;
811:

Line 808: RAISE FND_API.g_exc_unexpected_error;

804:
805: IF l_return_status = FND_API.g_ret_sts_error THEN
806: RAISE FND_API.g_exc_error;
807: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
808: RAISE FND_API.g_exc_unexpected_error;
809: END IF;
810: END IF;
811:
812: -- Debug Message

Line 818: x_return_status := FND_API.g_ret_sts_error;

814:
815: EXCEPTION
816:
817: WHEN AMS_Utility_PVT.resource_locked THEN
818: x_return_status := FND_API.g_ret_sts_error;
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
821: FND_MSG_PUB.add;
822: END IF;

Line 824: WHEN FND_API.G_EXC_ERROR THEN

820: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
821: FND_MSG_PUB.add;
822: END IF;
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO LOCK_Act_Resource_PUB;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: END IF;
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO LOCK_Act_Resource_PUB;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,

Line 829: p_encoded => FND_API.G_FALSE,

825: ROLLBACK TO LOCK_Act_Resource_PUB;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833:

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: ROLLBACK TO LOCK_Act_Resource_PUB;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: -- Standard call to get message count and if count=1, get the message
838: FND_MSG_PUB.Count_And_Get (

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: ROLLBACK TO LOCK_Act_Resource_PUB;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: -- Standard call to get message count and if count=1, get the message
838: FND_MSG_PUB.Count_And_Get (
839: p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,

Line 839: p_encoded => FND_API.G_FALSE,

835: ROLLBACK TO LOCK_Act_Resource_PUB;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: -- Standard call to get message count and if count=1, get the message
838: FND_MSG_PUB.Count_And_Get (
839: p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843:

Line 846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

842: );
843:
844: WHEN OTHERS THEN
845: ROLLBACK TO LOCK_Act_Resource_PUB;
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
850: END IF;

Line 853: p_encoded => FND_API.G_FALSE,

849: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
850: END IF;
851: -- Standard call to get message count and if count=1, get the message
852: FND_MSG_PUB.Count_And_Get (
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data
856: );
857: END Lock_Act_Resource;

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

871: /*****************************************************************************************/
872:
873: PROCEDURE Validate_Act_Resource
874: ( p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
876: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,
879: x_msg_data OUT NOCOPY VARCHAR2,

Line 876: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

872:
873: PROCEDURE Validate_Act_Resource
874: ( p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
876: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,
879: x_msg_data OUT NOCOPY VARCHAR2,
880: p_act_Resource_rec IN act_Resource_rec_type

Line 894: IF FND_API.to_boolean(p_init_msg_list) THEN

890: SAVEPOINT validate_act_resource_pub;
891:
892: -- initialize the message list;
893: -- won't do it again when calling private API
894: IF FND_API.to_boolean(p_init_msg_list) THEN
895: FND_MSG_PUB.initialize;
896: END IF;
897:
898: Convert_PubRec_To_PvtRec(l_pub_resource_rec,l_pvt_resource_rec);

Line 908: IF l_return_status = FND_API.g_ret_sts_error THEN

904: l_pub_resource_rec,
905: l_return_status
906: );
907:
908: IF l_return_status = FND_API.g_ret_sts_error THEN
909: RAISE FND_API.g_exc_error;
910: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: END IF;

Line 909: RAISE FND_API.g_exc_error;

905: l_return_status
906: );
907:
908: IF l_return_status = FND_API.g_ret_sts_error THEN
909: RAISE FND_API.g_exc_error;
910: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: END IF;
913: END IF;

Line 910: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

906: );
907:
908: IF l_return_status = FND_API.g_ret_sts_error THEN
909: RAISE FND_API.g_exc_error;
910: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: END IF;
913: END IF;
914:

Line 911: RAISE FND_API.g_exc_unexpected_error;

907:
908: IF l_return_status = FND_API.g_ret_sts_error THEN
909: RAISE FND_API.g_exc_error;
910: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: END IF;
913: END IF;
914:
915: -- vertical industry pre-processing

Line 923: IF l_return_status = FND_API.g_ret_sts_error THEN

919: l_pub_resource_rec,
920: l_return_status
921: );
922:
923: IF l_return_status = FND_API.g_ret_sts_error THEN
924: RAISE FND_API.g_exc_error;
925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
926: RAISE FND_API.g_exc_unexpected_error;
927: END IF;

Line 924: RAISE FND_API.g_exc_error;

920: l_return_status
921: );
922:
923: IF l_return_status = FND_API.g_ret_sts_error THEN
924: RAISE FND_API.g_exc_error;
925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
926: RAISE FND_API.g_exc_unexpected_error;
927: END IF;
928: END IF;

Line 925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

921: );
922:
923: IF l_return_status = FND_API.g_ret_sts_error THEN
924: RAISE FND_API.g_exc_error;
925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
926: RAISE FND_API.g_exc_unexpected_error;
927: END IF;
928: END IF;
929:

Line 926: RAISE FND_API.g_exc_unexpected_error;

922:
923: IF l_return_status = FND_API.g_ret_sts_error THEN
924: RAISE FND_API.g_exc_error;
925: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
926: RAISE FND_API.g_exc_unexpected_error;
927: END IF;
928: END IF;
929:
930: -- call business API

Line 941: IF l_return_status = FND_API.g_ret_sts_error THEN

937: x_msg_data => x_msg_data,
938: p_Act_Resource_rec => l_pvt_resource_rec
939: );
940:
941: IF l_return_status = FND_API.g_ret_sts_error THEN
942: RAISE FND_API.g_exc_error;
943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;

Line 942: RAISE FND_API.g_exc_error;

938: p_Act_Resource_rec => l_pvt_resource_rec
939: );
940:
941: IF l_return_status = FND_API.g_ret_sts_error THEN
942: RAISE FND_API.g_exc_error;
943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;
946:

Line 943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

939: );
940:
941: IF l_return_status = FND_API.g_ret_sts_error THEN
942: RAISE FND_API.g_exc_error;
943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;
946:
947: -- vertical industry post-processing

Line 944: RAISE FND_API.g_exc_unexpected_error;

940:
941: IF l_return_status = FND_API.g_ret_sts_error THEN
942: RAISE FND_API.g_exc_error;
943: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;
946:
947: -- vertical industry post-processing
948: IF JTF_USR_HKS.ok_to_execute(G_PACKAGE_NAME, l_api_name, 'A', 'V')

Line 955: IF l_return_status = FND_API.g_ret_sts_error THEN

951: l_pub_resource_rec,
952: l_return_status
953: );
954:
955: IF l_return_status = FND_API.g_ret_sts_error THEN
956: RAISE FND_API.g_exc_error;
957: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
958: RAISE FND_API.g_exc_unexpected_error;
959: END IF;

Line 956: RAISE FND_API.g_exc_error;

952: l_return_status
953: );
954:
955: IF l_return_status = FND_API.g_ret_sts_error THEN
956: RAISE FND_API.g_exc_error;
957: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
958: RAISE FND_API.g_exc_unexpected_error;
959: END IF;
960: END IF;

Line 957: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

953: );
954:
955: IF l_return_status = FND_API.g_ret_sts_error THEN
956: RAISE FND_API.g_exc_error;
957: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
958: RAISE FND_API.g_exc_unexpected_error;
959: END IF;
960: END IF;
961:

Line 958: RAISE FND_API.g_exc_unexpected_error;

954:
955: IF l_return_status = FND_API.g_ret_sts_error THEN
956: RAISE FND_API.g_exc_error;
957: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
958: RAISE FND_API.g_exc_unexpected_error;
959: END IF;
960: END IF;
961:
962: -- customer post-processing

Line 970: IF l_return_status = FND_API.g_ret_sts_error THEN

966: l_pub_resource_rec,
967: l_return_status
968: );
969:
970: IF l_return_status = FND_API.g_ret_sts_error THEN
971: RAISE FND_API.g_exc_error;
972: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
973: RAISE FND_API.g_exc_unexpected_error;
974: END IF;

Line 971: RAISE FND_API.g_exc_error;

967: l_return_status
968: );
969:
970: IF l_return_status = FND_API.g_ret_sts_error THEN
971: RAISE FND_API.g_exc_error;
972: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
973: RAISE FND_API.g_exc_unexpected_error;
974: END IF;
975: END IF;

Line 972: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

968: );
969:
970: IF l_return_status = FND_API.g_ret_sts_error THEN
971: RAISE FND_API.g_exc_error;
972: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
973: RAISE FND_API.g_exc_unexpected_error;
974: END IF;
975: END IF;
976:

Line 973: RAISE FND_API.g_exc_unexpected_error;

969:
970: IF l_return_status = FND_API.g_ret_sts_error THEN
971: RAISE FND_API.g_exc_error;
972: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
973: RAISE FND_API.g_exc_unexpected_error;
974: END IF;
975: END IF;
976:
977: -- Debug Message

Line 988: WHEN FND_API.g_exc_error THEN

984: );
985:
986: EXCEPTION
987:
988: WHEN FND_API.g_exc_error THEN
989: ROLLBACK TO validate_act_resource_pub;
990: x_return_status := FND_API.g_ret_sts_error;
991: FND_MSG_PUB.count_and_get(
992: p_encoded => FND_API.g_false,

Line 990: x_return_status := FND_API.g_ret_sts_error;

986: EXCEPTION
987:
988: WHEN FND_API.g_exc_error THEN
989: ROLLBACK TO validate_act_resource_pub;
990: x_return_status := FND_API.g_ret_sts_error;
991: FND_MSG_PUB.count_and_get(
992: p_encoded => FND_API.g_false,
993: p_count => x_msg_count,
994: p_data => x_msg_data

Line 992: p_encoded => FND_API.g_false,

988: WHEN FND_API.g_exc_error THEN
989: ROLLBACK TO validate_act_resource_pub;
990: x_return_status := FND_API.g_ret_sts_error;
991: FND_MSG_PUB.count_and_get(
992: p_encoded => FND_API.g_false,
993: p_count => x_msg_count,
994: p_data => x_msg_data
995: );
996:

Line 997: WHEN FND_API.g_exc_unexpected_error THEN

993: p_count => x_msg_count,
994: p_data => x_msg_data
995: );
996:
997: WHEN FND_API.g_exc_unexpected_error THEN
998: ROLLBACK TO validate_act_resource_pub;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: FND_MSG_PUB.count_and_get(
1001: p_encoded => FND_API.g_false,

Line 999: x_return_status := FND_API.g_ret_sts_unexp_error ;

995: );
996:
997: WHEN FND_API.g_exc_unexpected_error THEN
998: ROLLBACK TO validate_act_resource_pub;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: FND_MSG_PUB.count_and_get(
1001: p_encoded => FND_API.g_false,
1002: p_count => x_msg_count,
1003: p_data => x_msg_data

Line 1001: p_encoded => FND_API.g_false,

997: WHEN FND_API.g_exc_unexpected_error THEN
998: ROLLBACK TO validate_act_resource_pub;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: FND_MSG_PUB.count_and_get(
1001: p_encoded => FND_API.g_false,
1002: p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005:

Line 1009: x_return_status := FND_API.g_ret_sts_unexp_error ;

1005:
1006:
1007: WHEN OTHERS THEN
1008: ROLLBACK TO validate_act_resource_pub;
1009: x_return_status := FND_API.g_ret_sts_unexp_error ;
1010:
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1012: THEN
1013: FND_MSG_PUB.add_exc_msg(G_PACKAGE_NAME, l_api_name);

Line 1017: p_encoded => FND_API.g_false,

1013: FND_MSG_PUB.add_exc_msg(G_PACKAGE_NAME, l_api_name);
1014: END IF;
1015:
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021: END Validate_Act_Resource;