86: END IF;
87:
88: -- Debug Message
89: IF l_debug THEN
90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
91: 'Public API: ' || l_api_name || 'start');
92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
94: END IF;
88: -- Debug Message
89: IF l_debug THEN
90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
91: 'Public API: ' || l_api_name || 'start');
92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
94: END IF;
95:
96: -- Initialize API return status to SUCCESS
100: -- API body
101: --
102:
103: IF l_debug THEN
104: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
105: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Oppty_Update');
106: END IF;
107:
108: AS_BUSINESS_EVENT_PVT.Before_Oppty_Update
128:
129:
130: -- Debug Message
131: IF l_debug THEN
132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
133: 'Public API: ' || l_api_name || 'end');
134:
135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
136: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
131: IF l_debug THEN
132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
133: 'Public API: ' || l_api_name || 'end');
134:
135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
136: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
137: END IF;
138:
139:
143: );
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
148: P_MODULE => l_module
149: ,P_API_NAME => L_API_NAME
150: ,P_PKG_NAME => G_PKG_NAME
151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
148: P_MODULE => l_module
149: ,P_API_NAME => L_API_NAME
150: ,P_PKG_NAME => G_PKG_NAME
151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_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:
154: ,X_MSG_DATA => X_MSG_DATA
155: ,X_RETURN_STATUS => X_RETURN_STATUS);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
159: P_MODULE => l_module
160: ,P_API_NAME => L_API_NAME
161: ,P_PKG_NAME => G_PKG_NAME
162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
159: P_MODULE => l_module
160: ,P_API_NAME => L_API_NAME
161: ,P_PKG_NAME => G_PKG_NAME
162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
163: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
164: ,X_MSG_COUNT => X_MSG_COUNT
165: ,X_MSG_DATA => X_MSG_DATA
166: ,X_RETURN_STATUS => X_RETURN_STATUS);
167:
165: ,X_MSG_DATA => X_MSG_DATA
166: ,X_RETURN_STATUS => X_RETURN_STATUS);
167:
168: WHEN OTHERS THEN
169: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
170: P_MODULE => l_module
171: ,P_API_NAME => L_API_NAME
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
169: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
170: P_MODULE => l_module
171: ,P_API_NAME => L_API_NAME
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
174: ,P_SQLCODE => SQLCODE
175: ,P_SQLERRM => SQLERRM
176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
177: ,X_MSG_COUNT => X_MSG_COUNT
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
174: ,P_SQLCODE => SQLCODE
175: ,P_SQLERRM => SQLERRM
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:
249: END IF;
250:
251: -- Debug Message
252: IF l_debug THEN
253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'Public API: ' || l_api_name || 'start');
255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
256: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257: END IF;
251: -- Debug Message
252: IF l_debug THEN
253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'Public API: ' || l_api_name || 'start');
255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
256: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257: END IF;
258:
259: -- Initialize API return status to SUCCESS
263: -- API body
264: --
265:
266: IF l_debug THEN
267: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
268: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Update_oppty_post_event');
269: END IF;
270:
271: AS_BUSINESS_EVENT_PVT.Update_oppty_post_event
291:
292:
293: -- Debug Message
294: IF l_debug THEN
295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
296: 'Public API: ' || l_api_name || 'end');
297:
298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
299: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
294: IF l_debug THEN
295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
296: 'Public API: ' || l_api_name || 'end');
297:
298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
299: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
300: END IF;
301:
302:
306: );
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
311: P_MODULE => l_module
312: ,P_API_NAME => L_API_NAME
313: ,P_PKG_NAME => G_PKG_NAME
314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
311: P_MODULE => l_module
312: ,P_API_NAME => L_API_NAME
313: ,P_PKG_NAME => G_PKG_NAME
314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
316: ,X_MSG_COUNT => X_MSG_COUNT
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);
319:
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);
319:
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
322: P_MODULE => l_module
323: ,P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
322: P_MODULE => l_module
323: ,P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
327: ,X_MSG_COUNT => X_MSG_COUNT
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);
330:
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);
330:
331: WHEN OTHERS THEN
332: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
333: P_MODULE => l_module
334: ,P_API_NAME => L_API_NAME
335: ,P_PKG_NAME => G_PKG_NAME
336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
332: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
333: P_MODULE => l_module
334: ,P_API_NAME => L_API_NAME
335: ,P_PKG_NAME => G_PKG_NAME
336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
337: ,P_SQLCODE => SQLCODE
338: ,P_SQLERRM => SQLERRM
339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
340: ,X_MSG_COUNT => X_MSG_COUNT
335: ,P_PKG_NAME => G_PKG_NAME
336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
337: ,P_SQLCODE => SQLCODE
338: ,P_SQLERRM => SQLERRM
339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
340: ,X_MSG_COUNT => X_MSG_COUNT
341: ,X_MSG_DATA => X_MSG_DATA
342: ,X_RETURN_STATUS => X_RETURN_STATUS);
343:
417: END IF;
418:
419: -- Debug Message
420: IF l_debug THEN
421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
422: 'Public API: ' || l_api_name || 'start');
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425: END IF;
419: -- Debug Message
420: IF l_debug THEN
421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
422: 'Public API: ' || l_api_name || 'start');
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425: END IF;
426:
427: -- Initialize API return status to SUCCESS
431: -- API body
432: --
433:
434: IF l_debug THEN
435: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
436: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update');
437: END IF;
438:
439: AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update
459:
460:
461: -- Debug Message
462: IF l_debug THEN
463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
464: 'Public API: ' || l_api_name || 'end');
465:
466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
467: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
462: IF l_debug THEN
463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
464: 'Public API: ' || l_api_name || 'end');
465:
466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
467: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
468: END IF;
469:
470:
474: );
475:
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
479: P_MODULE => l_module
480: ,P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
479: P_MODULE => l_module
480: ,P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
483: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
484: ,X_MSG_COUNT => X_MSG_COUNT
485: ,X_MSG_DATA => X_MSG_DATA
486: ,X_RETURN_STATUS => X_RETURN_STATUS);
487:
485: ,X_MSG_DATA => X_MSG_DATA
486: ,X_RETURN_STATUS => X_RETURN_STATUS);
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
490: P_MODULE => l_module
491: ,P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
490: P_MODULE => l_module
491: ,P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
494: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498:
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498:
499: WHEN OTHERS THEN
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
501: P_MODULE => l_module
502: ,P_API_NAME => L_API_NAME
503: ,P_PKG_NAME => G_PKG_NAME
504: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
501: P_MODULE => l_module
502: ,P_API_NAME => L_API_NAME
503: ,P_PKG_NAME => G_PKG_NAME
504: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
505: ,P_SQLCODE => SQLCODE
506: ,P_SQLERRM => SQLERRM
507: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
508: ,X_MSG_COUNT => X_MSG_COUNT
503: ,P_PKG_NAME => G_PKG_NAME
504: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
505: ,P_SQLCODE => SQLCODE
506: ,P_SQLERRM => SQLERRM
507: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
508: ,X_MSG_COUNT => X_MSG_COUNT
509: ,X_MSG_DATA => X_MSG_DATA
510: ,X_RETURN_STATUS => X_RETURN_STATUS);
511:
580: END IF;
581:
582: -- Debug Message
583: IF l_debug THEN
584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Public API: ' || l_api_name || 'start');
586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
587: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588: END IF;
582: -- Debug Message
583: IF l_debug THEN
584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Public API: ' || l_api_name || 'start');
586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
587: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588: END IF;
589:
590: -- Initialize API return status to SUCCESS
594: -- API body
595: --
596:
597: IF l_debug THEN
598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Opp_Lines_post_event');
600: END IF;
601:
602: AS_BUSINESS_EVENT_PVT.Upd_Opp_Lines_post_event
622:
623:
624: -- Debug Message
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Public API: ' || l_api_name || 'end');
628:
629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
630: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Public API: ' || l_api_name || 'end');
628:
629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
630: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
631: END IF;
632:
633:
637: );
638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
642: P_MODULE => l_module
643: ,P_API_NAME => L_API_NAME
644: ,P_PKG_NAME => G_PKG_NAME
645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
642: P_MODULE => l_module
643: ,P_API_NAME => L_API_NAME
644: ,P_PKG_NAME => G_PKG_NAME
645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
646: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
647: ,X_MSG_COUNT => X_MSG_COUNT
648: ,X_MSG_DATA => X_MSG_DATA
649: ,X_RETURN_STATUS => X_RETURN_STATUS);
650:
648: ,X_MSG_DATA => X_MSG_DATA
649: ,X_RETURN_STATUS => X_RETURN_STATUS);
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
653: P_MODULE => l_module
654: ,P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
653: P_MODULE => l_module
654: ,P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);
661:
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);
661:
662: WHEN OTHERS THEN
663: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
664: P_MODULE => l_module
665: ,P_API_NAME => L_API_NAME
666: ,P_PKG_NAME => G_PKG_NAME
667: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
663: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
664: P_MODULE => l_module
665: ,P_API_NAME => L_API_NAME
666: ,P_PKG_NAME => G_PKG_NAME
667: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
668: ,P_SQLCODE => SQLCODE
669: ,P_SQLERRM => SQLERRM
670: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
671: ,X_MSG_COUNT => X_MSG_COUNT
666: ,P_PKG_NAME => G_PKG_NAME
667: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
668: ,P_SQLCODE => SQLCODE
669: ,P_SQLERRM => SQLERRM
670: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
671: ,X_MSG_COUNT => X_MSG_COUNT
672: ,X_MSG_DATA => X_MSG_DATA
673: ,X_RETURN_STATUS => X_RETURN_STATUS);
674:
748: END IF;
749:
750: -- Debug Message
751: IF l_debug THEN
752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'Public API: ' || l_api_name || 'start');
754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
755: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
750: -- Debug Message
751: IF l_debug THEN
752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'Public API: ' || l_api_name || 'start');
754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
755: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
757:
758: -- Initialize API return status to SUCCESS
762: -- API body
763: --
764:
765: IF l_debug THEN
766: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
767: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update');
768: END IF;
769:
770: AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update
790:
791:
792: -- Debug Message
793: IF l_debug THEN
794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
795: 'Public API: ' || l_api_name || 'end');
796:
797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
798: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
793: IF l_debug THEN
794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
795: 'Public API: ' || l_api_name || 'end');
796:
797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
798: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
799: END IF;
800:
801:
805: );
806:
807: EXCEPTION
808: WHEN FND_API.G_EXC_ERROR THEN
809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
810: P_MODULE => l_module
811: ,P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME
813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
810: P_MODULE => l_module
811: ,P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME
813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
814: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);
818:
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
826: ,X_MSG_COUNT => X_MSG_COUNT
827: ,X_MSG_DATA => X_MSG_DATA
828: ,X_RETURN_STATUS => X_RETURN_STATUS);
829:
827: ,X_MSG_DATA => X_MSG_DATA
828: ,X_RETURN_STATUS => X_RETURN_STATUS);
829:
830: WHEN OTHERS THEN
831: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
832: P_MODULE => l_module
833: ,P_API_NAME => L_API_NAME
834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
831: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
832: P_MODULE => l_module
833: ,P_API_NAME => L_API_NAME
834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
836: ,P_SQLCODE => SQLCODE
837: ,P_SQLERRM => SQLERRM
838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
839: ,X_MSG_COUNT => X_MSG_COUNT
834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
836: ,P_SQLCODE => SQLCODE
837: ,P_SQLERRM => SQLERRM
838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
839: ,X_MSG_COUNT => X_MSG_COUNT
840: ,X_MSG_DATA => X_MSG_DATA
841: ,X_RETURN_STATUS => X_RETURN_STATUS);
842:
911: END IF;
912:
913: -- Debug Message
914: IF l_debug THEN
915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
916: 'Public API: ' || l_api_name || 'start');
917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
918: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
919: END IF;
913: -- Debug Message
914: IF l_debug THEN
915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
916: 'Public API: ' || l_api_name || 'start');
917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
918: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
919: END IF;
920:
921: -- Initialize API return status to SUCCESS
925: -- API body
926: --
927:
928: IF l_debug THEN
929: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
930: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Opp_STeam_post_event');
931: END IF;
932:
933: AS_BUSINESS_EVENT_PVT.Upd_Opp_STeam_post_event
953:
954:
955: -- Debug Message
956: IF l_debug THEN
957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'Public API: ' || l_api_name || 'end');
959:
960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
961: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
956: IF l_debug THEN
957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'Public API: ' || l_api_name || 'end');
959:
960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
961: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
962: END IF;
963:
964:
968: );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
973: P_MODULE => l_module
974: ,P_API_NAME => L_API_NAME
975: ,P_PKG_NAME => G_PKG_NAME
976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
973: P_MODULE => l_module
974: ,P_API_NAME => L_API_NAME
975: ,P_PKG_NAME => G_PKG_NAME
976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
977: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
978: ,X_MSG_COUNT => X_MSG_COUNT
979: ,X_MSG_DATA => X_MSG_DATA
980: ,X_RETURN_STATUS => X_RETURN_STATUS);
981:
979: ,X_MSG_DATA => X_MSG_DATA
980: ,X_RETURN_STATUS => X_RETURN_STATUS);
981:
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
983: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
984: P_MODULE => l_module
985: ,P_API_NAME => L_API_NAME
986: ,P_PKG_NAME => G_PKG_NAME
987: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
984: P_MODULE => l_module
985: ,P_API_NAME => L_API_NAME
986: ,P_PKG_NAME => G_PKG_NAME
987: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
988: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
989: ,X_MSG_COUNT => X_MSG_COUNT
990: ,X_MSG_DATA => X_MSG_DATA
991: ,X_RETURN_STATUS => X_RETURN_STATUS);
992:
990: ,X_MSG_DATA => X_MSG_DATA
991: ,X_RETURN_STATUS => X_RETURN_STATUS);
992:
993: WHEN OTHERS THEN
994: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
995: P_MODULE => l_module
996: ,P_API_NAME => L_API_NAME
997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
994: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
995: P_MODULE => l_module
996: ,P_API_NAME => L_API_NAME
997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
999: ,P_SQLCODE => SQLCODE
1000: ,P_SQLERRM => SQLERRM
1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1002: ,X_MSG_COUNT => X_MSG_COUNT
997: ,P_PKG_NAME => G_PKG_NAME
998: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
999: ,P_SQLCODE => SQLCODE
1000: ,P_SQLERRM => SQLERRM
1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1002: ,X_MSG_COUNT => X_MSG_COUNT
1003: ,X_MSG_DATA => X_MSG_DATA
1004: ,X_RETURN_STATUS => X_RETURN_STATUS);
1005:
1079: END IF;
1080:
1081: -- Debug Message
1082: IF l_debug THEN
1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'Public API: ' || l_api_name || 'start');
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087: END IF;
1081: -- Debug Message
1082: IF l_debug THEN
1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'Public API: ' || l_api_name || 'start');
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087: END IF;
1088:
1089: -- Initialize API return status to SUCCESS
1093: -- API body
1094: --
1095:
1096: IF l_debug THEN
1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1098: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update');
1099: END IF;
1100:
1101: AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update
1121:
1122:
1123: -- Debug Message
1124: IF l_debug THEN
1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1126: 'Public API: ' || l_api_name || 'end');
1127:
1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1129: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1124: IF l_debug THEN
1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1126: 'Public API: ' || l_api_name || 'end');
1127:
1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1129: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1130: END IF;
1131:
1132:
1136: );
1137:
1138: EXCEPTION
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1141: P_MODULE => l_module
1142: ,P_API_NAME => L_API_NAME
1143: ,P_PKG_NAME => G_PKG_NAME
1144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1141: P_MODULE => l_module
1142: ,P_API_NAME => L_API_NAME
1143: ,P_PKG_NAME => G_PKG_NAME
1144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1145: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1146: ,X_MSG_COUNT => X_MSG_COUNT
1147: ,X_MSG_DATA => X_MSG_DATA
1148: ,X_RETURN_STATUS => X_RETURN_STATUS);
1149:
1147: ,X_MSG_DATA => X_MSG_DATA
1148: ,X_RETURN_STATUS => X_RETURN_STATUS);
1149:
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1152: P_MODULE => l_module
1153: ,P_API_NAME => L_API_NAME
1154: ,P_PKG_NAME => G_PKG_NAME
1155: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1152: P_MODULE => l_module
1153: ,P_API_NAME => L_API_NAME
1154: ,P_PKG_NAME => G_PKG_NAME
1155: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1156: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1157: ,X_MSG_COUNT => X_MSG_COUNT
1158: ,X_MSG_DATA => X_MSG_DATA
1159: ,X_RETURN_STATUS => X_RETURN_STATUS);
1160:
1158: ,X_MSG_DATA => X_MSG_DATA
1159: ,X_RETURN_STATUS => X_RETURN_STATUS);
1160:
1161: WHEN OTHERS THEN
1162: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1163: P_MODULE => l_module
1164: ,P_API_NAME => L_API_NAME
1165: ,P_PKG_NAME => G_PKG_NAME
1166: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1162: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1163: P_MODULE => l_module
1164: ,P_API_NAME => L_API_NAME
1165: ,P_PKG_NAME => G_PKG_NAME
1166: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1167: ,P_SQLCODE => SQLCODE
1168: ,P_SQLERRM => SQLERRM
1169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1170: ,X_MSG_COUNT => X_MSG_COUNT
1165: ,P_PKG_NAME => G_PKG_NAME
1166: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1167: ,P_SQLCODE => SQLCODE
1168: ,P_SQLERRM => SQLERRM
1169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1170: ,X_MSG_COUNT => X_MSG_COUNT
1171: ,X_MSG_DATA => X_MSG_DATA
1172: ,X_RETURN_STATUS => X_RETURN_STATUS);
1173:
1242: END IF;
1243:
1244: -- Debug Message
1245: IF l_debug THEN
1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1247: 'Public API: ' || l_api_name || 'start');
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1250: END IF;
1244: -- Debug Message
1245: IF l_debug THEN
1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1247: 'Public API: ' || l_api_name || 'start');
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1250: END IF;
1251:
1252: -- Initialize API return status to SUCCESS
1256: -- API body
1257: --
1258:
1259: IF l_debug THEN
1260: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1261: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Cust_STeam_post_event');
1262: END IF;
1263:
1264: AS_BUSINESS_EVENT_PVT.Upd_Cust_STeam_post_event
1284:
1285:
1286: -- Debug Message
1287: IF l_debug THEN
1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'Public API: ' || l_api_name || 'end');
1290:
1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1292: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1287: IF l_debug THEN
1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'Public API: ' || l_api_name || 'end');
1290:
1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1292: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1293: END IF;
1294:
1295:
1299: );
1300:
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1304: P_MODULE => l_module
1305: ,P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1304: P_MODULE => l_module
1305: ,P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1308: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);
1312:
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1315: P_MODULE => l_module
1316: ,P_API_NAME => L_API_NAME
1317: ,P_PKG_NAME => G_PKG_NAME
1318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1315: P_MODULE => l_module
1316: ,P_API_NAME => L_API_NAME
1317: ,P_PKG_NAME => G_PKG_NAME
1318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1319: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1320: ,X_MSG_COUNT => X_MSG_COUNT
1321: ,X_MSG_DATA => X_MSG_DATA
1322: ,X_RETURN_STATUS => X_RETURN_STATUS);
1323:
1321: ,X_MSG_DATA => X_MSG_DATA
1322: ,X_RETURN_STATUS => X_RETURN_STATUS);
1323:
1324: WHEN OTHERS THEN
1325: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1326: P_MODULE => l_module
1327: ,P_API_NAME => L_API_NAME
1328: ,P_PKG_NAME => G_PKG_NAME
1329: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1325: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1326: P_MODULE => l_module
1327: ,P_API_NAME => L_API_NAME
1328: ,P_PKG_NAME => G_PKG_NAME
1329: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1330: ,P_SQLCODE => SQLCODE
1331: ,P_SQLERRM => SQLERRM
1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1333: ,X_MSG_COUNT => X_MSG_COUNT
1328: ,P_PKG_NAME => G_PKG_NAME
1329: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1330: ,P_SQLCODE => SQLCODE
1331: ,P_SQLERRM => SQLERRM
1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1333: ,X_MSG_COUNT => X_MSG_COUNT
1334: ,X_MSG_DATA => X_MSG_DATA
1335: ,X_RETURN_STATUS => X_RETURN_STATUS);
1336: