eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PROCESS_RULES_PUB dependencies on AS_UTILITY_PVT

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

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

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

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

Line 80: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

76: IF (AS_DEBUG_HIGH_ON) THEN
77:
78:
79:
80: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);
81:
82: END IF;
83: -- Calling Private package: Create_PROCESS_RULES
84:

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

115:
116: -- Debug Message
117: IF (AS_DEBUG_HIGH_ON) THEN
118:
119: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
120: END IF;
121: IF (AS_DEBUG_HIGH_ON) THEN
122:
123: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

119: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
120: END IF;
121: IF (AS_DEBUG_HIGH_ON) THEN
122:
123: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124: END IF;
125: IF (AS_DEBUG_HIGH_ON) THEN
126:
127: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

Line 127: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

123: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124: END IF;
125: IF (AS_DEBUG_HIGH_ON) THEN
126:
127: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);
128: END IF;
129:
130: -- Standard call to get message count and if count is 1, get message info.
131: FND_MSG_PUB.Count_And_Get

Line 138: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

134: );
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
139: P_API_NAME => L_API_NAME
140: ,P_PKG_NAME => G_PKG_NAME
141: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
142: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 142: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

138: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
139: P_API_NAME => L_API_NAME
140: ,P_PKG_NAME => G_PKG_NAME
141: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
142: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
143: ,X_MSG_COUNT => X_MSG_COUNT
144: ,X_MSG_DATA => X_MSG_DATA
145: ,X_RETURN_STATUS => X_RETURN_STATUS);
146:

Line 148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

144: ,X_MSG_DATA => X_MSG_DATA
145: ,X_RETURN_STATUS => X_RETURN_STATUS);
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
149: P_API_NAME => L_API_NAME
150: ,P_PKG_NAME => G_PKG_NAME
151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
152: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 152: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
149: P_API_NAME => L_API_NAME
150: ,P_PKG_NAME => G_PKG_NAME
151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
152: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
153: ,X_MSG_COUNT => X_MSG_COUNT
154: ,X_MSG_DATA => X_MSG_DATA
155: ,X_RETURN_STATUS => X_RETURN_STATUS);
156:

Line 158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

154: ,X_MSG_DATA => X_MSG_DATA
155: ,X_RETURN_STATUS => X_RETURN_STATUS);
156:
157: WHEN OTHERS THEN
158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
159: P_API_NAME => L_API_NAME
160: ,P_PKG_NAME => G_PKG_NAME
161: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
162: ,P_SQLCODE => SQLCODE

Line 161: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

157: WHEN OTHERS THEN
158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
159: P_API_NAME => L_API_NAME
160: ,P_PKG_NAME => G_PKG_NAME
161: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
162: ,P_SQLCODE => SQLCODE
163: ,P_SQLERRM => SQLERRM
164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
165: ,X_MSG_COUNT => X_MSG_COUNT

Line 164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

160: ,P_PKG_NAME => G_PKG_NAME
161: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
162: ,P_SQLCODE => SQLCODE
163: ,P_SQLERRM => SQLERRM
164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
165: ,X_MSG_COUNT => X_MSG_COUNT
166: ,X_MSG_DATA => X_MSG_DATA
167: ,X_RETURN_STATUS => X_RETURN_STATUS);
168: End Create_process_rules;

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

207:
208: -- Debug Message
209: IF (AS_DEBUG_HIGH_ON) THEN
210:
211: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
212: END IF;
213:
214: IF (AS_DEBUG_HIGH_ON) THEN
215:

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

214: IF (AS_DEBUG_HIGH_ON) THEN
215:
216:
217:
218: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
219:
220: END IF;
221:
222: -- Initialize API return status to SUCCESS

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

257:
258: -- Debug Message
259: IF (AS_DEBUG_HIGH_ON) THEN
260:
261: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
262: END IF;
263:
264: IF (AS_DEBUG_HIGH_ON) THEN
265:

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

264: IF (AS_DEBUG_HIGH_ON) THEN
265:
266:
267:
268: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
269:
270: END IF;
271:
272: -- Standard call to get message count and if count is 1, get message info.

Line 280: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

276: );
277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_ERROR THEN
280: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
281: P_API_NAME => L_API_NAME
282: ,P_PKG_NAME => G_PKG_NAME
283: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
284: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 284: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 290: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

286: ,X_MSG_DATA => X_MSG_DATA
287: ,X_RETURN_STATUS => X_RETURN_STATUS);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
291: P_API_NAME => L_API_NAME
292: ,P_PKG_NAME => G_PKG_NAME
293: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
294: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 294: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

290: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
291: P_API_NAME => L_API_NAME
292: ,P_PKG_NAME => G_PKG_NAME
293: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
294: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
295: ,X_MSG_COUNT => X_MSG_COUNT
296: ,X_MSG_DATA => X_MSG_DATA
297: ,X_RETURN_STATUS => X_RETURN_STATUS);
298:

Line 300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

296: ,X_MSG_DATA => X_MSG_DATA
297: ,X_RETURN_STATUS => X_RETURN_STATUS);
298:
299: WHEN OTHERS THEN
300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
301: P_API_NAME => L_API_NAME
302: ,P_PKG_NAME => G_PKG_NAME
303: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
304: ,P_SQLCODE => SQLCODE

Line 303: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

299: WHEN OTHERS THEN
300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
301: P_API_NAME => L_API_NAME
302: ,P_PKG_NAME => G_PKG_NAME
303: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
304: ,P_SQLCODE => SQLCODE
305: ,P_SQLERRM => SQLERRM
306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
307: ,X_MSG_COUNT => X_MSG_COUNT

Line 306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

302: ,P_PKG_NAME => G_PKG_NAME
303: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
304: ,P_SQLCODE => SQLCODE
305: ,P_SQLERRM => SQLERRM
306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
307: ,X_MSG_COUNT => X_MSG_COUNT
308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);
310: End Update_process_rules;

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

350:
351: -- Debug Message
352: IF (AS_DEBUG_HIGH_ON) THEN
353:
354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
355: END IF;
356:
357: IF (AS_DEBUG_HIGH_ON) THEN
358:

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

357: IF (AS_DEBUG_HIGH_ON) THEN
358:
359:
360:
361: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
362:
363: END IF;
364:
365: -- Initialize API return status to SUCCESS

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

401:
402: -- Debug Message
403: IF (AS_DEBUG_HIGH_ON) THEN
404:
405: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
406: END IF;
407:
408: IF (AS_DEBUG_HIGH_ON) THEN
409:

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

408: IF (AS_DEBUG_HIGH_ON) THEN
409:
410:
411:
412: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
413:
414: END IF;
415:
416: -- Standard call to get message count and if count is 1, get message info.

Line 424: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
425: P_API_NAME => L_API_NAME
426: ,P_PKG_NAME => G_PKG_NAME
427: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
428: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 428: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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

Line 434: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

430: ,X_MSG_DATA => X_MSG_DATA
431: ,X_RETURN_STATUS => X_RETURN_STATUS);
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
435: P_API_NAME => L_API_NAME
436: ,P_PKG_NAME => G_PKG_NAME
437: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
438: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 438: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

434: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
435: P_API_NAME => L_API_NAME
436: ,P_PKG_NAME => G_PKG_NAME
437: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
438: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
439: ,X_MSG_COUNT => X_MSG_COUNT
440: ,X_MSG_DATA => X_MSG_DATA
441: ,X_RETURN_STATUS => X_RETURN_STATUS);
442:

Line 444: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

440: ,X_MSG_DATA => X_MSG_DATA
441: ,X_RETURN_STATUS => X_RETURN_STATUS);
442:
443: WHEN OTHERS THEN
444: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
448: ,P_SQLCODE => SQLCODE

Line 447: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

443: WHEN OTHERS THEN
444: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
448: ,P_SQLCODE => SQLCODE
449: ,P_SQLERRM => SQLERRM
450: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
451: ,X_MSG_COUNT => X_MSG_COUNT

Line 450: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
448: ,P_SQLCODE => SQLCODE
449: ,P_SQLERRM => SQLERRM
450: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
451: ,X_MSG_COUNT => X_MSG_COUNT
452: ,X_MSG_DATA => X_MSG_DATA
453: ,X_RETURN_STATUS => X_RETURN_STATUS);
454: End Delete_process_rules;

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

492:
493: -- Debug Message
494: IF (AS_DEBUG_HIGH_ON) THEN
495:
496: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
497: END IF;
498:
499: IF (AS_DEBUG_HIGH_ON) THEN
500:

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

499: IF (AS_DEBUG_HIGH_ON) THEN
500:
501:
502:
503: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
504:
505: END IF;
506:
507: -- Initialize API return status to SUCCESS

Line 518: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

514: IF (AS_DEBUG_HIGH_ON) THEN
515:
516:
517:
518: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);
519:
520: END IF;
521: -- Calling Private package: Copy_PROCESS_RULES
522:

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

553:
554: -- Debug Message
555: IF (AS_DEBUG_HIGH_ON) THEN
556:
557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
558: END IF;
559: IF (AS_DEBUG_HIGH_ON) THEN
560:
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
558: END IF;
559: IF (AS_DEBUG_HIGH_ON) THEN
560:
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
562: END IF;
563: IF (AS_DEBUG_HIGH_ON) THEN
564:
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

Line 565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);

561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
562: END IF;
563: IF (AS_DEBUG_HIGH_ON) THEN
564:
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Return status: ' || x_return_status);
566: END IF;
567:
568: -- Standard call to get message count and if count is 1, get message info.
569: FND_MSG_PUB.Count_And_Get

Line 576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

572: );
573:
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
577: P_API_NAME => L_API_NAME
578: ,P_PKG_NAME => G_PKG_NAME
579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
580: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 580: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
577: P_API_NAME => L_API_NAME
578: ,P_PKG_NAME => G_PKG_NAME
579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
580: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
581: ,X_MSG_COUNT => X_MSG_COUNT
582: ,X_MSG_DATA => X_MSG_DATA
583: ,X_RETURN_STATUS => X_RETURN_STATUS);
584:

Line 586: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

582: ,X_MSG_DATA => X_MSG_DATA
583: ,X_RETURN_STATUS => X_RETURN_STATUS);
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
587: P_API_NAME => L_API_NAME
588: ,P_PKG_NAME => G_PKG_NAME
589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
590: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 590: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

586: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
587: P_API_NAME => L_API_NAME
588: ,P_PKG_NAME => G_PKG_NAME
589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
590: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
591: ,X_MSG_COUNT => X_MSG_COUNT
592: ,X_MSG_DATA => X_MSG_DATA
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594:

Line 596: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

592: ,X_MSG_DATA => X_MSG_DATA
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594:
595: WHEN OTHERS THEN
596: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
597: P_API_NAME => L_API_NAME
598: ,P_PKG_NAME => G_PKG_NAME
599: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
600: ,P_SQLCODE => SQLCODE

Line 599: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

595: WHEN OTHERS THEN
596: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
597: P_API_NAME => L_API_NAME
598: ,P_PKG_NAME => G_PKG_NAME
599: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
600: ,P_SQLCODE => SQLCODE
601: ,P_SQLERRM => SQLERRM
602: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
603: ,X_MSG_COUNT => X_MSG_COUNT

Line 602: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

598: ,P_PKG_NAME => G_PKG_NAME
599: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
600: ,P_SQLCODE => SQLCODE
601: ,P_SQLERRM => SQLERRM
602: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
603: ,X_MSG_COUNT => X_MSG_COUNT
604: ,X_MSG_DATA => X_MSG_DATA
605: ,X_RETURN_STATUS => X_RETURN_STATUS);
606: End Copy_process_rules;