DBA Data[Home] [Help]

APPS.PV_SELATTVAL_PUB dependencies on FND_MSG_PUB

Line 14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_SELATTVAL_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvrpsavb.pls';
13:
14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE Create_selattval(

Line 15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_SELATTVAL_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvrpsavb.pls';
13:
14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE Create_selattval(
19: P_Api_Version_Number IN NUMBER,

Line 16: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvrpsavb.pls';
13:
14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE Create_selattval(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 52: FND_MSG_PUB.initialize;

48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55:
56: -- Debug Message

Line 59: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

55:
56: -- Debug Message
57: IF (AS_DEBUG_HIGH_ON) THEN
58:
59: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
60: END IF;
61:
62: IF (AS_DEBUG_HIGH_ON) THEN
63:

Line 66: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

62: IF (AS_DEBUG_HIGH_ON) THEN
63:
64:
65:
66: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
67:
68: END IF;
69:
70: -- Initialize API return status to SUCCESS

Line 111: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

107:
108: -- Debug Message
109: IF (AS_DEBUG_HIGH_ON) THEN
110:
111: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
112: END IF;
113:
114: IF (AS_DEBUG_HIGH_ON) THEN
115:

Line 118: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

114: IF (AS_DEBUG_HIGH_ON) THEN
115:
116:
117:
118: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119:
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.

Line 123: FND_MSG_PUB.Count_And_Get

119:
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.
123: FND_MSG_PUB.Count_And_Get
124: ( p_count => x_msg_count,
125: p_data => x_msg_data
126: );
127:

Line 133: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

129: WHEN FND_API.G_EXC_ERROR THEN
130: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_API_NAME => L_API_NAME
132: ,P_PKG_NAME => G_PKG_NAME
133: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
134: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
135: ,X_MSG_COUNT => X_MSG_COUNT
136: ,X_MSG_DATA => X_MSG_DATA
137: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
144: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
145: ,X_MSG_COUNT => X_MSG_COUNT
146: ,X_MSG_DATA => X_MSG_DATA
147: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 196: FND_MSG_PUB.initialize;

192:
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:
199:
200: -- Debug Message

Line 203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

199:
200: -- Debug Message
201: IF (AS_DEBUG_HIGH_ON) THEN
202:
203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
204: END IF;
205: IF (AS_DEBUG_HIGH_ON) THEN
206:
207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
204: END IF;
205: IF (AS_DEBUG_HIGH_ON) THEN
206:
207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
208: END IF;
209:
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

245:
246: -- Debug Message
247: IF (AS_DEBUG_HIGH_ON) THEN
248:
249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
250: END IF;
251:
252: IF (AS_DEBUG_HIGH_ON) THEN
253:

Line 256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

252: IF (AS_DEBUG_HIGH_ON) THEN
253:
254:
255:
256: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257:
258: END IF;
259:
260: -- Standard call to get message count and if count is 1, get message info.

Line 261: FND_MSG_PUB.Count_And_Get

257:
258: END IF;
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get
262: ( p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 271: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

267: WHEN FND_API.G_EXC_ERROR THEN
268: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
269: P_API_NAME => L_API_NAME
270: ,P_PKG_NAME => G_PKG_NAME
271: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
272: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
273: ,X_MSG_COUNT => X_MSG_COUNT
274: ,X_MSG_DATA => X_MSG_DATA
275: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 281: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
279: P_API_NAME => L_API_NAME
280: ,P_PKG_NAME => G_PKG_NAME
281: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
282: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
283: ,X_MSG_COUNT => X_MSG_COUNT
284: ,X_MSG_DATA => X_MSG_DATA
285: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 335: FND_MSG_PUB.initialize;

331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:
338:
339: -- Debug Message

Line 342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

338:
339: -- Debug Message
340: IF (AS_DEBUG_HIGH_ON) THEN
341:
342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
343: END IF;
344:
345: IF (AS_DEBUG_HIGH_ON) THEN
346:

Line 349: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

345: IF (AS_DEBUG_HIGH_ON) THEN
346:
347:
348:
349: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
350:
351: END IF;
352:
353: -- Initialize API return status to SUCCESS

Line 393: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

389:
390: -- Debug Message
391: IF (AS_DEBUG_HIGH_ON) THEN
392:
393: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
394: END IF;
395:
396: IF (AS_DEBUG_HIGH_ON) THEN
397:

Line 400: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

396: IF (AS_DEBUG_HIGH_ON) THEN
397:
398:
399:
400: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
401:
402: END IF;
403:
404: -- Standard call to get message count and if count is 1, get message info.

Line 405: FND_MSG_PUB.Count_And_Get

401:
402: END IF;
403:
404: -- Standard call to get message count and if count is 1, get message info.
405: FND_MSG_PUB.Count_And_Get
406: ( p_count => x_msg_count,
407: p_data => x_msg_data
408: );
409:

Line 415: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

411: WHEN FND_API.G_EXC_ERROR THEN
412: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
413: P_API_NAME => L_API_NAME
414: ,P_PKG_NAME => G_PKG_NAME
415: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
416: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
417: ,X_MSG_COUNT => X_MSG_COUNT
418: ,X_MSG_DATA => X_MSG_DATA
419: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 425: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
423: P_API_NAME => L_API_NAME
424: ,P_PKG_NAME => G_PKG_NAME
425: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
426: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
427: ,X_MSG_COUNT => X_MSG_COUNT
428: ,X_MSG_DATA => X_MSG_DATA
429: ,X_RETURN_STATUS => X_RETURN_STATUS);