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.AS_BUSINESS_EVENT_PUB dependencies on AS_UTILITY_PVT

Line 90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 104: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 147: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 152: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 163: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 169: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 267: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 310: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 321: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 332: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 435: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 478: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 483: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 489: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 494: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 507: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 646: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 652: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 663: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 670: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 766: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 814: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 831: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 929: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 977: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 983: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 988: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 994: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 1001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 1140: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1145: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1156: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1162: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 1169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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;

Line 1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1260: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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:

Line 1303: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1308: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1314: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1319: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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:

Line 1325: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

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: