DBA Data[Home] [Help]

APPS.PV_ENTYRLS_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_entyrls;

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

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

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

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

Line 273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 277: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 283: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 287: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 293: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 296: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 299: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

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

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

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

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

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

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

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

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

Line 417: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 421: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 431: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 437: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 440: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 443: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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