DBA Data[Home] [Help]

APPS.PV_ENTYATTMAP_PUB dependencies on AS_UTILITY_PVT

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

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

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

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

Line 131: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

127: );
128:
129: EXCEPTION
130: WHEN FND_API.G_EXC_ERROR THEN
131: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
135: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 135: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

131: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
135: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:

Line 141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 145: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
145: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
149:

Line 151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
149:
150: WHEN OTHERS THEN
151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
155: ,P_SQLCODE => SQLCODE

Line 154: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

150: WHEN OTHERS THEN
151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
155: ,P_SQLCODE => SQLCODE
156: ,P_SQLERRM => SQLERRM
157: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
158: ,X_MSG_COUNT => X_MSG_COUNT

Line 157: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
155: ,P_SQLCODE => SQLCODE
156: ,P_SQLERRM => SQLERRM
157: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
158: ,X_MSG_COUNT => X_MSG_COUNT
159: ,X_MSG_DATA => X_MSG_DATA
160: ,X_RETURN_STATUS => X_RETURN_STATUS);
161: End Create_entyattmap;

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

200:
201: -- Debug Message
202: IF (AS_DEBUG_HIGH_ON) THEN
203:
204: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
205: END IF;
206:
207: IF (AS_DEBUG_HIGH_ON) THEN
208:

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

207: IF (AS_DEBUG_HIGH_ON) THEN
208:
209:
210:
211: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
212:
213: END IF;
214:
215: -- Initialize API return status to SUCCESS

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

251:
252: -- Debug Message
253: IF (AS_DEBUG_HIGH_ON) THEN
254:
255: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
256: END IF;
257:
258: IF (AS_DEBUG_HIGH_ON) THEN
259:

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

258: IF (AS_DEBUG_HIGH_ON) THEN
259:
260:
261:
262: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
263:
264: END IF;
265:
266: -- Standard call to get message count and if count is 1, get message info.

Line 274: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

270: );
271:
272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN
274: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
275: P_API_NAME => L_API_NAME
276: ,P_PKG_NAME => G_PKG_NAME
277: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
278: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 278: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

274: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
275: P_API_NAME => L_API_NAME
276: ,P_PKG_NAME => G_PKG_NAME
277: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
278: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
279: ,X_MSG_COUNT => X_MSG_COUNT
280: ,X_MSG_DATA => X_MSG_DATA
281: ,X_RETURN_STATUS => X_RETURN_STATUS);
282:

Line 284: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 288: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

284: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
285: P_API_NAME => L_API_NAME
286: ,P_PKG_NAME => G_PKG_NAME
287: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
288: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
289: ,X_MSG_COUNT => X_MSG_COUNT
290: ,X_MSG_DATA => X_MSG_DATA
291: ,X_RETURN_STATUS => X_RETURN_STATUS);
292:

Line 294: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

290: ,X_MSG_DATA => X_MSG_DATA
291: ,X_RETURN_STATUS => X_RETURN_STATUS);
292:
293: WHEN OTHERS THEN
294: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
295: P_API_NAME => L_API_NAME
296: ,P_PKG_NAME => G_PKG_NAME
297: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
298: ,P_SQLCODE => SQLCODE

Line 297: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

293: WHEN OTHERS THEN
294: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
295: P_API_NAME => L_API_NAME
296: ,P_PKG_NAME => G_PKG_NAME
297: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
298: ,P_SQLCODE => SQLCODE
299: ,P_SQLERRM => SQLERRM
300: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
301: ,X_MSG_COUNT => X_MSG_COUNT

Line 300: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

296: ,P_PKG_NAME => G_PKG_NAME
297: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
298: ,P_SQLCODE => SQLCODE
299: ,P_SQLERRM => SQLERRM
300: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
301: ,X_MSG_COUNT => X_MSG_COUNT
302: ,X_MSG_DATA => X_MSG_DATA
303: ,X_RETURN_STATUS => X_RETURN_STATUS);
304: End Update_entyattmap;

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

345:
346: -- Debug Message
347: IF (AS_DEBUG_HIGH_ON) THEN
348:
349: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
350: END IF;
351:
352: IF (AS_DEBUG_HIGH_ON) THEN
353:

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

352: IF (AS_DEBUG_HIGH_ON) THEN
353:
354:
355:
356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
357:
358: END IF;
359:
360: -- Initialize API return status to SUCCESS

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

395:
396: -- Debug Message
397: IF (AS_DEBUG_HIGH_ON) THEN
398:
399: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
400: END IF;
401:
402: IF (AS_DEBUG_HIGH_ON) THEN
403:

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

402: IF (AS_DEBUG_HIGH_ON) THEN
403:
404:
405:
406: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
407:
408: END IF;
409:
410: -- Standard call to get message count and if count is 1, get message info.

Line 418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

414: );
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
419: P_API_NAME => L_API_NAME
420: ,P_PKG_NAME => G_PKG_NAME
421: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
422: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 422: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
419: P_API_NAME => L_API_NAME
420: ,P_PKG_NAME => G_PKG_NAME
421: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
422: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
423: ,X_MSG_COUNT => X_MSG_COUNT
424: ,X_MSG_DATA => X_MSG_DATA
425: ,X_RETURN_STATUS => X_RETURN_STATUS);
426:

Line 428: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 432: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

428: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
429: P_API_NAME => L_API_NAME
430: ,P_PKG_NAME => G_PKG_NAME
431: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
432: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
433: ,X_MSG_COUNT => X_MSG_COUNT
434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:

Line 438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:
437: WHEN OTHERS THEN
438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
439: P_API_NAME => L_API_NAME
440: ,P_PKG_NAME => G_PKG_NAME
441: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
442: ,P_SQLCODE => SQLCODE

Line 441: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

437: WHEN OTHERS THEN
438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
439: P_API_NAME => L_API_NAME
440: ,P_PKG_NAME => G_PKG_NAME
441: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
442: ,P_SQLCODE => SQLCODE
443: ,P_SQLERRM => SQLERRM
444: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
445: ,X_MSG_COUNT => X_MSG_COUNT

Line 444: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

440: ,P_PKG_NAME => G_PKG_NAME
441: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
442: ,P_SQLCODE => SQLCODE
443: ,P_SQLERRM => SQLERRM
444: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
445: ,X_MSG_COUNT => X_MSG_COUNT
446: ,X_MSG_DATA => X_MSG_DATA
447: ,X_RETURN_STATUS => X_RETURN_STATUS);
448: End Delete_entyattmap;