67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74:
75: -- Debug Message
72: END IF;
73:
74:
75: -- Debug Message
76: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
77:
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: -- Validate Environment
88: -- ******************************************************************
89: IF FND_GLOBAL.User_Id IS NULL
90: THEN
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
93: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
94: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
95: FND_MSG_PUB.ADD;
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
93: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
94: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
95: FND_MSG_PUB.ADD;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:
150: END IF;
151:
152:
153: -- Debug Message
154: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
153: -- Debug Message
154: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
161:
163: WHEN FND_API.G_EXC_ERROR THEN
164: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
165: P_API_NAME => L_API_NAME
166: ,P_PKG_NAME => G_PKG_NAME
167: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
168: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
169: ,X_MSG_COUNT => X_MSG_COUNT
170: ,X_MSG_DATA => X_MSG_DATA
171: ,X_RETURN_STATUS => X_RETURN_STATUS);
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
175: P_API_NAME => L_API_NAME
176: ,P_PKG_NAME => G_PKG_NAME
177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
178: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
179: ,X_MSG_COUNT => X_MSG_COUNT
180: ,X_MSG_DATA => X_MSG_DATA
181: ,X_RETURN_STATUS => X_RETURN_STATUS);
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list )
228: THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:
232:
233: -- Debug Message
230: END IF;
231:
232:
233: -- Debug Message
234: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
235:
236:
237:
238: -- Initialize API return status to SUCCESS
254: END IF;
255:
256:
257: -- Debug Message
258: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
259:
260:
261:
262: -- Standard call to get message count and if count is 1, get message info.
259:
260:
261:
262: -- Standard call to get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267:
269: WHEN FND_API.G_EXC_ERROR THEN
270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
271: P_API_NAME => L_API_NAME
272: ,P_PKG_NAME => G_PKG_NAME
273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
275: ,X_MSG_COUNT => X_MSG_COUNT
276: ,X_MSG_DATA => X_MSG_DATA
277: ,X_RETURN_STATUS => X_RETURN_STATUS);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
281: P_API_NAME => L_API_NAME
282: ,P_PKG_NAME => G_PKG_NAME
283: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
284: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
285: ,X_MSG_COUNT => X_MSG_COUNT
286: ,X_MSG_DATA => X_MSG_DATA
287: ,X_RETURN_STATUS => X_RETURN_STATUS);
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean( p_init_msg_list )
329: THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332:
333:
334: -- Debug Message
331: END IF;
332:
333:
334: -- Debug Message
335: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
336:
337:
338:
339: -- Initialize API return status to SUCCESS
350: END IF;
351:
352:
353: -- Debug Message
354: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
355:
356:
357:
358: -- Standard call to get message count and if count is 1, get message info.
355:
356:
357:
358: -- Standard call to get message count and if count is 1, get message info.
359: FND_MSG_PUB.Count_And_Get
360: ( p_count => x_msg_count,
361: p_data => x_msg_data
362: );
363:
365: WHEN FND_API.G_EXC_ERROR THEN
366: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
367: P_API_NAME => L_API_NAME
368: ,P_PKG_NAME => G_PKG_NAME
369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
370: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
371: ,X_MSG_COUNT => X_MSG_COUNT
372: ,X_MSG_DATA => X_MSG_DATA
373: ,X_RETURN_STATUS => X_RETURN_STATUS);
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
377: P_API_NAME => L_API_NAME
378: ,P_PKG_NAME => G_PKG_NAME
379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
380: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
381: ,X_MSG_COUNT => X_MSG_COUNT
382: ,X_MSG_DATA => X_MSG_DATA
383: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:
437: -- Initialize message list if p_init_msg_list is set to TRUE.
438: IF FND_API.to_Boolean( p_init_msg_list )
439: THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442:
443:
444: -- Debug Message
441: END IF;
442:
443:
444: -- Debug Message
445: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
446: 'AST', 'Private API: ' || l_api_name || 'start');
447:
448: -- Initialize API return status to SUCCESS
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: END IF;
510:
511:
512: -- Debug Message
513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
514: 'AST', 'Private API: ' || l_api_name || 'end');
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
514: 'AST', 'Private API: ' || l_api_name || 'end');
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:
523: WHEN FND_API.G_EXC_ERROR THEN
524: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
525: P_API_NAME => L_API_NAME
526: ,P_PKG_NAME => G_PKG_NAME
527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
528: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
529: ,X_MSG_COUNT => X_MSG_COUNT
530: ,X_MSG_DATA => X_MSG_DATA
531: ,X_RETURN_STATUS => X_RETURN_STATUS);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
539: ,X_MSG_COUNT => X_MSG_COUNT
540: ,X_MSG_DATA => X_MSG_DATA
541: ,X_RETURN_STATUS => X_RETURN_STATUS);
580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.
582: IF FND_API.to_Boolean( p_init_msg_list )
583: THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586:
587:
588: -- Debug Message
585: END IF;
586:
587:
588: -- Debug Message
589: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
590:
591:
592:
593: -- Initialize API return status to SUCCESS
605: END IF;
606:
607:
608: -- Debug Message
609: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
610:
611:
612:
613: -- Standard call to get message count and if count is 1, get message info.
610:
611:
612:
613: -- Standard call to get message count and if count is 1, get message info.
614: FND_MSG_PUB.Count_And_Get
615: ( p_count => x_msg_count,
616: p_data => x_msg_data
617: );
618:
620: WHEN FND_API.G_EXC_ERROR THEN
621: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
622: P_API_NAME => L_API_NAME
623: ,P_PKG_NAME => G_PKG_NAME
624: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
625: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
626: ,X_MSG_COUNT => X_MSG_COUNT
627: ,X_MSG_DATA => X_MSG_DATA
628: ,X_RETURN_STATUS => X_RETURN_STATUS);
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
632: P_API_NAME => L_API_NAME
633: ,P_PKG_NAME => G_PKG_NAME
634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
635: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
636: ,X_MSG_COUNT => X_MSG_COUNT
637: ,X_MSG_DATA => X_MSG_DATA
638: ,X_RETURN_STATUS => X_RETURN_STATUS);