46: l_count number;
47: x number;
48: BEGIN
49:
50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_search_result_PVT;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49:
50: -- Standard Start of API savepoint
51: SAVEPOINT CREATE_search_result_PVT;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
92: --
93: -- End of API body
94: --
95:
96: -- Standard check for p_commit
97: IF FND_API.to_Boolean( p_commit )
98: THEN
99: COMMIT WORK;
100: END IF;
102:
103: -- Debug Message
104: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
105:
106: -- Standard call to get message count and if count is 1, get message info.
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data
110: );
162: l_count number;
163: x number;
164: BEGIN
165:
166: -- Standard Start of API savepoint
167: SAVEPOINT Get_search_result_PVT;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
165:
166: -- Standard Start of API savepoint
167: SAVEPOINT Get_search_result_PVT;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
204: --
205: -- End of API body
206: --
207:
208: -- Standard check for p_commit
209: IF FND_API.to_Boolean( p_commit )
210: THEN
211: COMMIT WORK;
212: END IF;
214:
215: -- Debug Message
216: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
217:
218: -- Standard call to get message count and if count is 1, get message info.
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data
222: );
271: l_count number;
272: x number;
273:
274: BEGIN
275: -- Standard Start of API savepoint
276: SAVEPOINT Get_search_result_PVT;
277:
278: -- Standard call to check for call compatibility.
279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
274: BEGIN
275: -- Standard Start of API savepoint
276: SAVEPOINT Get_search_result_PVT;
277:
278: -- Standard call to check for call compatibility.
279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: p_api_version_number,
281: l_api_name,
282: G_PKG_NAME)
309: --
310: -- End of API body
311: --
312:
313: -- Standard check for p_commit
314: IF FND_API.to_Boolean( p_commit )
315: THEN
316: COMMIT WORK;
317: END IF;
319:
320: -- Debug Message
321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data
327: );
384: y INTEGER; -- For testing
385:
386: BEGIN
387:
388: -- Standard start of API savepoint
389: SAVEPOINT AST_Add_Party_Id;
390:
391: -- Standard call to check for call compatibility
392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
387:
388: -- Standard start of API savepoint
389: SAVEPOINT AST_Add_Party_Id;
390:
391: -- Standard call to check for call compatibility
392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
423: x_glb_count := g_count;
424:
425: -- End of API body
426: */
427: -- Standard check for p_commit
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
432:
433: -- Debug Message
434: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
435:
436: -- Standard call to get message count and if count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );
493: x INTEGER;
494: y INTEGER; -- For testing
495: BEGIN
496:
497: -- Standard start of API savepoint
498: SAVEPOINT AST_Get_Party_Id;
499:
500: -- Standard call to check for call compatibility
501: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
496:
497: -- Standard start of API savepoint
498: SAVEPOINT AST_Get_Party_Id;
499:
500: -- Standard call to check for call compatibility
501: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
523:
524: x_glb_count := x;
525: -- End of API body
526:
527: -- Standard check for p_commit
528: IF FND_API.to_Boolean( p_commit )
529: THEN
530: COMMIT WORK;
531: END IF;
532:
533: -- Debug Message
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
535:
536: -- Standard call to get message count and if count is 1, get message info.
537: FND_MSG_PUB.Count_And_Get
538: ( p_count => x_msg_count,
539: p_data => x_msg_data
540: );