APPS.ASF_USER_PREFERENCE_PUB dependencies on AS_UTILITY_PVT

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 45: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');

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;
48:
49: -- Initialize API return status to SUCCESS

Line 46: AS_UTILITY_PVT.Debug_Message(NULL,'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;
48:
49: -- Initialize API return status to SUCCESS
50: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 145: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

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');
146: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
147: END IF;
148:
149: -- Standard call to get message count and if count is 1, get message info.

Line 146: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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');
146: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
147: END IF;
148:
149: -- Standard call to get message count and if count is 1, get message info.
150:

Line 162: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

158: END IF;
159:
160: EXCEPTION
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

Line 166: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 172: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

168: ,X_MSG_DATA => X_MSG_DATA
169: ,X_RETURN_STATUS => X_RETURN_STATUS);
170:
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

Line 176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

178: ,X_MSG_DATA => X_MSG_DATA
179: ,X_RETURN_STATUS => X_RETURN_STATUS);
180:
181: WHEN OTHERS THEN
182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
183: P_API_NAME => L_API_NAME
184: ,P_PKG_NAME => G_PKG_NAME
185: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
186: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 185: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

181: WHEN OTHERS THEN
182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
183: P_API_NAME => L_API_NAME
184: ,P_PKG_NAME => G_PKG_NAME
185: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
186: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
187: ,X_MSG_COUNT => X_MSG_COUNT
188: ,X_MSG_DATA => X_MSG_DATA
189: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 186: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
183: P_API_NAME => L_API_NAME
184: ,P_PKG_NAME => G_PKG_NAME
185: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
186: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
187: ,X_MSG_COUNT => X_MSG_COUNT
188: ,X_MSG_DATA => X_MSG_DATA
189: ,X_RETURN_STATUS => X_RETURN_STATUS);
190:

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 218: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');

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;
221:
222: -- Initialize API return status to SUCCESS

Line 219: AS_UTILITY_PVT.Debug_Message(NULL,'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;
221:
222: -- Initialize API return status to SUCCESS
223: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 356: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

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');
357: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.

Line 357: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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');
357: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.
361:

Line 373: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

369: END IF;
370:
371: EXCEPTION
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

Line 377: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 383: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

379: ,X_MSG_DATA => X_MSG_DATA
380: ,X_RETURN_STATUS => X_RETURN_STATUS);
381:
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

Line 387: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 393: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

389: ,X_MSG_DATA => X_MSG_DATA
390: ,X_RETURN_STATUS => X_RETURN_STATUS);
391:
392: WHEN OTHERS THEN
393: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 396: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

392: WHEN OTHERS THEN
393: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
398: ,X_MSG_COUNT => X_MSG_COUNT
399: ,X_MSG_DATA => X_MSG_DATA
400: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

393: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
397: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
398: ,X_MSG_COUNT => X_MSG_COUNT
399: ,X_MSG_DATA => X_MSG_DATA
400: ,X_RETURN_STATUS => X_RETURN_STATUS);
401:

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 428: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' start');

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;
431:
432: -- Initialize API return status to SUCCESS

Line 429: AS_UTILITY_PVT.Debug_Message(NULL,'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;
431:
432: -- Initialize API return status to SUCCESS
433: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 495: AS_UTILITY_PVT.Debug_Message(NULL,'Public API: ' || l_api_name || ' end');

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

Line 496: AS_UTILITY_PVT.Debug_Message(NULL,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

Line 507: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

503: );
504:
505: EXCEPTION
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

Line 511: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 517: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

513: ,X_MSG_DATA => X_MSG_DATA
514: ,X_RETURN_STATUS => X_RETURN_STATUS);
515:
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

Line 521: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 527: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

523: ,X_MSG_DATA => X_MSG_DATA
524: ,X_RETURN_STATUS => X_RETURN_STATUS);
525:
526: WHEN OTHERS THEN
527: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
528: P_API_NAME => L_API_NAME
529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

526: WHEN OTHERS THEN
527: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
528: P_API_NAME => L_API_NAME
529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
532: ,X_MSG_COUNT => X_MSG_COUNT
533: ,X_MSG_DATA => X_MSG_DATA
534: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

527: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
528: P_API_NAME => L_API_NAME
529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
532: ,X_MSG_COUNT => X_MSG_COUNT
533: ,X_MSG_DATA => X_MSG_DATA
534: ,X_RETURN_STATUS => X_RETURN_STATUS);
535: