61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Debug Message
69: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Debug Message
69: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
70:
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
100: END IF;
101:
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,
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: );
111:
113: WHEN FND_API.G_EXC_ERROR THEN
114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
115: P_API_NAME => L_API_NAME
116: ,P_PKG_NAME => G_PKG_NAME
117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
119: ,X_MSG_COUNT => X_MSG_COUNT
120: ,X_MSG_DATA => X_MSG_DATA
121: ,X_RETURN_STATUS => X_RETURN_STATUS);
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
129: ,X_MSG_COUNT => X_MSG_COUNT
130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list )
180: THEN
181: FND_MSG_PUB.initialize;
182: END IF;
183:
184: -- Debug Message
185: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
181: FND_MSG_PUB.initialize;
182: END IF;
183:
184: -- Debug Message
185: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
186:
187: -- Initialize API return status to SUCCESS
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
212: END IF;
213:
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,
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: );
223:
225: WHEN FND_API.G_EXC_ERROR THEN
226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
240: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
241: ,X_MSG_COUNT => X_MSG_COUNT
242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list )
289: THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Debug Message
294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Debug Message
294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
317: END IF;
318:
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,
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: );
328:
330: WHEN FND_API.G_EXC_ERROR THEN
331: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
394: END IF;
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE
397: IF FND_API.To_Boolean(p_init_msg_list) THEN
398: FND_MSG_PUB.initialize;
399: END IF;
400:
401: -- Initialize API return status to success
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
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: );
441:
443: WHEN FND_API.G_EXC_ERROR THEN
444: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
448: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
449: ,X_MSG_COUNT => X_MSG_COUNT
450: ,X_MSG_DATA => X_MSG_DATA
451: ,X_RETURN_STATUS => X_RETURN_STATUS);
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
455: P_API_NAME => L_API_NAME
456: ,P_PKG_NAME => G_PKG_NAME
457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
458: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
459: ,X_MSG_COUNT => X_MSG_COUNT
460: ,X_MSG_DATA => X_MSG_DATA
461: ,X_RETURN_STATUS => X_RETURN_STATUS);
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE
506: IF FND_API.To_Boolean(p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
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: );
541:
543: WHEN FND_API.G_EXC_ERROR THEN
544: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
548: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
559: ,X_MSG_COUNT => X_MSG_COUNT
560: ,X_MSG_DATA => X_MSG_DATA
561: ,X_RETURN_STATUS => X_RETURN_STATUS);