DBA Data[Home] [Help]

APPS.AST_SEARCH_RESULT_PVT dependencies on FND_MSG_PUB

Line 65: FND_MSG_PUB.initialize;

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');

Line 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:

Line 104: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 107: FND_MSG_PUB.Count_And_Get

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:

Line 117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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);

Line 127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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);

Line 181: FND_MSG_PUB.initialize;

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');

Line 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:

Line 216: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 219: FND_MSG_PUB.Count_And_Get

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:

Line 229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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);

Line 239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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);

Line 290: FND_MSG_PUB.initialize;

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');

Line 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:

Line 321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 324: FND_MSG_PUB.Count_And_Get

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:

Line 334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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);

Line 344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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);

Line 398: FND_MSG_PUB.initialize;

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;

Line 434: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 437: FND_MSG_PUB.Count_And_Get

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:

Line 447: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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);

Line 457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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);

Line 507: FND_MSG_PUB.initialize;

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;

Line 534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 537: FND_MSG_PUB.Count_And_Get

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:

Line 547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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);

Line 557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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);