67: end;
68:
69: if l_tp_exists = 'Y' then -- Bug 2593437
70:
71: -- Standard Start of API savepoint
72:
73: SAVEPOINT Create_Advice_PVT;
74:
75: -- Standard call to check for call compatibility.
71: -- Standard Start of API savepoint
72:
73: SAVEPOINT Create_Advice_PVT;
74:
75: -- Standard call to check for call compatibility.
76:
77: if NOT FND_API.Compatible_API_Call
78: (
79: l_api_version_number,
215: raise FND_API.G_EXC_ERROR;
216:
217: end if;
218:
219: -- Standard check of p_simulate and p_commit parameters
220:
221: if FND_API.To_Boolean( p_simulate)
222: then
223: ROLLBACK to Create_Advice_PVT;
226: then
227: commit work;
228: end if;
229:
230: -- Standard call to get message count and if count is 1, get message info.
231:
232: FND_MSG_PUB.Count_And_Get
233: (
234: p_count => p_msg_count,
338:
339: if l_document_exists = 'Y' then -- Bug 2593437
340:
341:
342: -- Standard Start of API savepoint
343:
344: SAVEPOINT Create_Advice_Line_PVT;
345:
346: -- Standard call to check for call compatibility.
342: -- Standard Start of API savepoint
343:
344: SAVEPOINT Create_Advice_Line_PVT;
345:
346: -- Standard call to check for call compatibility.
347:
348: if NOT FND_API.Compatible_API_Call
349: (
350: l_api_version_number,
430: raise FND_API.G_EXC_ERROR;
431:
432: end if;
433:
434: -- Standard check of p_simulate and p_commit parameters
435:
436: if FND_API.To_Boolean( p_simulate)
437: then
438: ROLLBACK to Create_Advice_Line_PVT;
441: then
442: commit work;
443: end if;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446:
447: FND_MSG_PUB.Count_And_Get
448: (
449: p_count => p_msg_count,