DBA Data[Home] [Help]

APPS.PV_LEADLOG_PVT dependencies on FND_API

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

165: --
166:
167: PROCEDURE CreateAssignLog
168: ( p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_assignlog_rec IN ASSIGNLOG_REC_TYPE := G_MISS_ASSIGNLOG_REC,
173: x_assignment_id OUT NOCOPY NUMBER,

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

166:
167: PROCEDURE CreateAssignLog
168: ( p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_assignlog_rec IN ASSIGNLOG_REC_TYPE := G_MISS_ASSIGNLOG_REC,
173: x_assignment_id OUT NOCOPY NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,

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

167: PROCEDURE CreateAssignLog
168: ( p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_assignlog_rec IN ASSIGNLOG_REC_TYPE := G_MISS_ASSIGNLOG_REC,
173: x_assignment_id OUT NOCOPY NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,

Line 196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

192: -- Standard Start of API savepoint
193: SAVEPOINT CREATE_AssignLog_PVT;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: fnd_message.Set_Name('PV', 'API_UNEXP_ERROR_IN_PROCESSING');
204: fnd_message.Set_Token('ROW', 'PV_LEADLOG', TRUE);
205: fnd_msg_pub.ADD;
206: END IF;
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210:
211: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 212: IF FND_API.to_Boolean( p_init_msg_list )

208: END IF;
209:
210:
211: -- Initialize message list if p_init_msg_list is set to TRUE.
212: IF FND_API.to_Boolean( p_init_msg_list )
213: THEN
214: fnd_msg_pub.initialize;
215: END IF;
216:

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: END IF;
223:
224: -- Initialize API return status to success
225: --
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: l_return_status_full := FND_API.G_RET_STS_SUCCESS;
228: l_assignment_id := NULL;
229:
230: --

Line 227: l_return_status_full := FND_API.G_RET_STS_SUCCESS;

223:
224: -- Initialize API return status to success
225: --
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: l_return_status_full := FND_API.G_RET_STS_SUCCESS;
228: l_assignment_id := NULL;
229:
230: --
231: -- API body

Line 246: RAISE FND_API.G_EXC_ERROR;

242: fnd_message.Set_Name('PV', 'UT_CANNOT_GET_PROFILE_VALUE');
243: fnd_message.Set_Token('PROFILE', 'USER_ID', FALSE);
244: fnd_msg_pub.ADD;
245: END IF;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248: -- ******************************************************************
249:
250:

Line 278: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

274: p_error_txt => l_assignlog_rec.error_txt ,
275: p_status_change_comments => l_assignlog_rec.status_change_comments,
276: x_return_status => l_return_status);
277:
278: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
279: raise FND_API.G_EXC_ERROR;
280: end if;
281:
282:

Line 279: raise FND_API.G_EXC_ERROR;

275: p_status_change_comments => l_assignlog_rec.status_change_comments,
276: x_return_status => l_return_status);
277:
278: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
279: raise FND_API.G_EXC_ERROR;
280: end if;
281:
282:
283:

Line 300: l_return_status_full = FND_API.G_RET_STS_SUCCESS

296: --
297:
298: -- Success Message
299: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_SUCCESS) and
300: l_return_status_full = FND_API.G_RET_STS_SUCCESS
301: THEN
302: fnd_message.Set_Name('PV', 'API_SUCCESS');
303: fnd_message.Set_Token('ROW', 'AS_ACCOUNT', TRUE);
304: fnd_msg_pub.Add;

Line 307: IF FND_API.To_Boolean ( p_commit )

303: fnd_message.Set_Token('ROW', 'AS_ACCOUNT', TRUE);
304: fnd_msg_pub.Add;
305: END IF;
306:
307: IF FND_API.To_Boolean ( p_commit )
308: THEN
309: COMMIT WORK;
310: END IF;
311:

Line 326: WHEN FND_API.G_EXC_ERROR THEN

322: );
323:
324: EXCEPTION
325:
326: WHEN FND_API.G_EXC_ERROR THEN
327:
328: ROLLBACK TO CREATE_AssignLog_PVT;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330:

Line 329: x_return_status := FND_API.G_RET_STS_ERROR ;

325:
326: WHEN FND_API.G_EXC_ERROR THEN
327:
328: ROLLBACK TO CREATE_AssignLog_PVT;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330:
331: fnd_msg_pub.Count_And_Get ( p_count => x_msg_count,
332: p_data => x_msg_data
333: );

Line 335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

331: fnd_msg_pub.Count_And_Get ( p_count => x_msg_count,
332: p_data => x_msg_data
333: );
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336:
337: ROLLBACK TO CREATE_AssignLog_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339:

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336:
337: ROLLBACK TO CREATE_AssignLog_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339:
340: fnd_msg_pub.Count_And_Get ( p_count => x_msg_count,
341: p_data => x_msg_data
342: );

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

343:
344: WHEN OTHERS THEN
345:
346: ROLLBACK TO CREATE_AssignLog_PVT;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF fnd_msg_pub.Check_Msg_Level ( fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR )
350: THEN
351: fnd_msg_pub.Add_Exc_Msg ( G_PKG_NAME,l_api_name );

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398:
399: BEGIN
400:
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: select pv_assignment_logs_s.nextval
405: into l_assignment_ID
406: from sys.dual;

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

447: EXCEPTION
448: WHEN OTHERS THEN
449:
450:
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
454:
455: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 455: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
454:
455: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data);
458:
459: