DBA Data[Home] [Help]

APPS.ASF_USER_PREFERENCE_PUB dependencies on FND_MSG_PUB

Line 37: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

33: SAVEPOINT CREATE_PREFERENCE_PUB;
34:
35:
36: -- Debug Message
37: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
38: -- 'Public API: ' || l_api_name || ' start');
39:
40: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
41: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 40: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

36: -- Debug Message
37: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
38: -- 'Public API: ' || l_api_name || ' start');
39:
40: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
41: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
42:
43: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
44: IF l_debug THEN

Line 43: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

39:
40: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
41: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
42:
43: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
44: IF l_debug THEN
45: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');
46: AS_UTILITY_PVT.Debug_Message(NULL,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
47: END IF;

Line 138: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

134: END IF;
135:
136:
137: -- Debug Message
138: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: -- 'Public API: ' || l_api_name || ' end');
140:
141: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
142: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 141: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

137: -- Debug Message
138: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: -- 'Public API: ' || l_api_name || ' end');
140:
141: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
142: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
143:
144: IF l_debug THEN
145: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

Line 151: FND_MSG_PUB.Count_And_Get

147: END IF;
148:
149: -- Standard call to get message count and if count is 1, get message info.
150:
151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155:

Line 165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

161: WHEN FND_API.G_EXC_ERROR THEN
162: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
163: P_API_NAME => L_API_NAME
164: ,P_PKG_NAME => G_PKG_NAME
165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
166: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
167: ,X_MSG_COUNT => X_MSG_COUNT
168: ,X_MSG_DATA => X_MSG_DATA
169: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
173: P_API_NAME => L_API_NAME
174: ,P_PKG_NAME => G_PKG_NAME
175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
177: ,X_MSG_COUNT => X_MSG_COUNT
178: ,X_MSG_DATA => X_MSG_DATA
179: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 210: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

206: SAVEPOINT UPDATE_PREFERENCE_PUB;
207:
208:
209: -- Debug Message
210: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
211: -- 'Public API: ' || l_api_name || ' start');
212:
213: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
214: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 213: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

209: -- Debug Message
210: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
211: -- 'Public API: ' || l_api_name || ' start');
212:
213: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
214: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
215:
216: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
217: IF l_debug THEN

Line 216: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

212:
213: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
214: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
215:
216: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
217: IF l_debug THEN
218: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');
219: AS_UTILITY_PVT.Debug_Message(NULL,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
220: END IF;

Line 254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

250: X_Msg_Data => x_msg_data);
251:
252: -- Debug Message
253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
254: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
255: 'Create_Preference fail');
256: END IF;
257: -- Check return status from the above procedure call
258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 349: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

345:
346:
347:
348: -- Debug Message
349: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
350: -- 'Public API: ' || l_api_name || ' end');
351:
352: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
353: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 352: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

348: -- Debug Message
349: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
350: -- 'Public API: ' || l_api_name || ' end');
351:
352: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
353: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
354:
355: IF l_debug THEN
356: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

Line 362: FND_MSG_PUB.Count_And_Get

358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.
361:
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366:

Line 376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

372: WHEN FND_API.G_EXC_ERROR THEN
373: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
374: P_API_NAME => L_API_NAME
375: ,P_PKG_NAME => G_PKG_NAME
376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
377: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
378: ,X_MSG_COUNT => X_MSG_COUNT
379: ,X_MSG_DATA => X_MSG_DATA
380: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 386: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
384: P_API_NAME => L_API_NAME
385: ,P_PKG_NAME => G_PKG_NAME
386: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
387: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
388: ,X_MSG_COUNT => X_MSG_COUNT
389: ,X_MSG_DATA => X_MSG_DATA
390: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 420: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

416: -- Standard Start of API savepoint
417: SAVEPOINT DELETE_PREFERENCE_PUB;
418:
419: -- Debug Message
420: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
421: -- 'Public API: ' || l_api_name || ' start');
422:
423: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 423: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

419: -- Debug Message
420: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
421: -- 'Public API: ' || l_api_name || ' start');
422:
423: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425:
426: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
427: IF l_debug THEN

Line 426: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

422:
423: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: -- 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425:
426: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
427: IF l_debug THEN
428: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');
429: AS_UTILITY_PVT.Debug_Message(NULL,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
430: END IF;

Line 488: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

484: raise FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: -- Debug Message
488: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
489: -- 'Public API: ' || l_api_name || ' end');
490:
491: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
492: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 491: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

487: -- Debug Message
488: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
489: -- 'Public API: ' || l_api_name || ' end');
490:
491: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
492: -- 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
493:
494: IF l_debug THEN
495: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

Line 500: FND_MSG_PUB.Count_And_Get

496: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
497: END IF;
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504:

Line 510: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

506: WHEN FND_API.G_EXC_ERROR THEN
507: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
508: P_API_NAME => L_API_NAME
509: ,P_PKG_NAME => G_PKG_NAME
510: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
511: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
512: ,X_MSG_COUNT => X_MSG_COUNT
513: ,X_MSG_DATA => X_MSG_DATA
514: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 520: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
518: P_API_NAME => L_API_NAME
519: ,P_PKG_NAME => G_PKG_NAME
520: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
521: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
522: ,X_MSG_COUNT => X_MSG_COUNT
523: ,X_MSG_DATA => X_MSG_DATA
524: ,X_RETURN_STATUS => X_RETURN_STATUS);