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_MULTI_CURRENCIES_PKG dependencies on AS_UTILITY_PVT

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

28: SAVEPOINT INSERT_TYPE_MAPPINGS_PUB;
29:
30: -- Debug Message
31: IF l_debug THEN
32: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
33: l_api_name || ' Start');
34: END IF;
35:
36: -- Initialize API return status to SUCCESS

Line 96: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

92: p_data => x_msg_data
93: );
94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
97: P_MODULE => l_module
98: ,P_API_NAME => L_API_NAME
99: ,P_PKG_NAME => G_PKG_NAME
100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 101: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

97: P_MODULE => l_module
98: ,P_API_NAME => L_API_NAME
99: ,P_PKG_NAME => G_PKG_NAME
100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
101: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
102: ,X_MSG_COUNT => X_MSG_COUNT
103: ,X_MSG_DATA => X_MSG_DATA
104: ,X_RETURN_STATUS => X_RETURN_STATUS);
105:

Line 107: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

103: ,X_MSG_DATA => X_MSG_DATA
104: ,X_RETURN_STATUS => X_RETURN_STATUS);
105:
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
108: P_MODULE => l_module
109: ,P_API_NAME => L_API_NAME
110: ,P_PKG_NAME => G_PKG_NAME
111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 112: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

108: P_MODULE => l_module
109: ,P_API_NAME => L_API_NAME
110: ,P_PKG_NAME => G_PKG_NAME
111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
112: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
113: ,X_MSG_COUNT => X_MSG_COUNT
114: ,X_MSG_DATA => X_MSG_DATA
115: ,X_RETURN_STATUS => X_RETURN_STATUS);
116:

Line 118: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

114: ,X_MSG_DATA => X_MSG_DATA
115: ,X_RETURN_STATUS => X_RETURN_STATUS);
116:
117: WHEN OTHERS THEN
118: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
119: P_MODULE => l_module
120: ,P_API_NAME => L_API_NAME
121: ,P_PKG_NAME => G_PKG_NAME
122: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 122: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

118: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
119: P_MODULE => l_module
120: ,P_API_NAME => L_API_NAME
121: ,P_PKG_NAME => G_PKG_NAME
122: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
123: ,P_SQLCODE => SQLCODE
124: ,P_SQLERRM => SQLERRM
125: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
126: ,X_MSG_COUNT => X_MSG_COUNT

Line 125: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

121: ,P_PKG_NAME => G_PKG_NAME
122: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
123: ,P_SQLCODE => SQLCODE
124: ,P_SQLERRM => SQLERRM
125: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
126: ,X_MSG_COUNT => X_MSG_COUNT
127: ,X_MSG_DATA => X_MSG_DATA
128: ,X_RETURN_STATUS => X_RETURN_STATUS);
129: End Insert_Type_Mappings;

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

145: SAVEPOINT UPDATE_TYPE_MAPPINGS_PUB;
146:
147: -- Debug Message
148: IF l_debug THEN
149: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
150: l_api_name || ' Start');
151: END IF;
152:
153: -- Initialize API return status to SUCCESS

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

158:
159: WHILE i <= l_last
160: LOOP
161: IF l_debug THEN
162: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
163: 'i=' || i);
164: END IF;
165: UPDATE AS_MC_TYPE_MAPPINGS
166: SET

Line 209: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

205: p_data => x_msg_data
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_MODULE => l_module
211: ,P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME
213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 214: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

210: P_MODULE => l_module
211: ,P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME
213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
214: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
215: ,X_MSG_COUNT => X_MSG_COUNT
216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:

Line 220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
221: P_MODULE => l_module
222: ,P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME
224: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 225: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

221: P_MODULE => l_module
222: ,P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME
224: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
225: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
226: ,X_MSG_COUNT => X_MSG_COUNT
227: ,X_MSG_DATA => X_MSG_DATA
228: ,X_RETURN_STATUS => X_RETURN_STATUS);
229:

Line 231: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

227: ,X_MSG_DATA => X_MSG_DATA
228: ,X_RETURN_STATUS => X_RETURN_STATUS);
229:
230: WHEN OTHERS THEN
231: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
232: P_MODULE => l_module
233: ,P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 235: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

231: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
232: P_MODULE => l_module
233: ,P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
236: ,P_SQLCODE => SQLCODE
237: ,P_SQLERRM => SQLERRM
238: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
239: ,X_MSG_COUNT => X_MSG_COUNT

Line 238: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
236: ,P_SQLCODE => SQLCODE
237: ,P_SQLERRM => SQLERRM
238: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
239: ,X_MSG_COUNT => X_MSG_COUNT
240: ,X_MSG_DATA => X_MSG_DATA
241: ,X_RETURN_STATUS => X_RETURN_STATUS);
242: END Update_Type_Mappings;

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

258: SAVEPOINT DELETE_TYPE_MAPPINGS_PUB;
259:
260: -- Debug Message
261: IF l_debug THEN
262: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
263: l_api_name || ' Start');
264: END IF;
265:
266: -- Initialize API return status to SUCCESS

Line 291: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

287: );
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
292: P_MODULE => l_module
293: ,P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 296: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

292: P_MODULE => l_module
293: ,P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
296: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
297: ,X_MSG_COUNT => X_MSG_COUNT
298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
300:

Line 302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 307: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
307: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
308: ,X_MSG_COUNT => X_MSG_COUNT
309: ,X_MSG_DATA => X_MSG_DATA
310: ,X_RETURN_STATUS => X_RETURN_STATUS);
311:

Line 313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

309: ,X_MSG_DATA => X_MSG_DATA
310: ,X_RETURN_STATUS => X_RETURN_STATUS);
311:
312: WHEN OTHERS THEN
313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
314: P_MODULE => l_module
315: ,P_API_NAME => L_API_NAME
316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 317: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
314: P_MODULE => l_module
315: ,P_API_NAME => L_API_NAME
316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
318: ,P_SQLCODE => SQLCODE
319: ,P_SQLERRM => SQLERRM
320: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
321: ,X_MSG_COUNT => X_MSG_COUNT

Line 320: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
318: ,P_SQLCODE => SQLCODE
319: ,P_SQLERRM => SQLERRM
320: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
321: ,X_MSG_COUNT => X_MSG_COUNT
322: ,X_MSG_DATA => X_MSG_DATA
323: ,X_RETURN_STATUS => X_RETURN_STATUS);
324: END Delete_Type_Mappings;

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

341: SAVEPOINT INSERT_PERIOD_RATES_PUB;
342:
343: -- Debug Message
344: IF l_debug THEN
345: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
346: l_api_name || ' Start');
347: END IF;
348:
349: -- Initialize API return status to SUCCESS

Line 397: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

393: p_data => x_msg_data
394: );
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
398: P_MODULE => l_module
399: ,P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 402: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

398: P_MODULE => l_module
399: ,P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
402: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:

Line 408: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
409: P_MODULE => l_module
410: ,P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 413: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

409: P_MODULE => l_module
410: ,P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
413: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
414: ,X_MSG_COUNT => X_MSG_COUNT
415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:

Line 419: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:
418: WHEN OTHERS THEN
419: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
420: P_MODULE => l_module
421: ,P_API_NAME => L_API_NAME
422: ,P_PKG_NAME => G_PKG_NAME
423: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 423: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

419: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
420: P_MODULE => l_module
421: ,P_API_NAME => L_API_NAME
422: ,P_PKG_NAME => G_PKG_NAME
423: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
424: ,P_SQLCODE => SQLCODE
425: ,P_SQLERRM => SQLERRM
426: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
427: ,X_MSG_COUNT => X_MSG_COUNT

Line 426: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

422: ,P_PKG_NAME => G_PKG_NAME
423: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
424: ,P_SQLCODE => SQLCODE
425: ,P_SQLERRM => SQLERRM
426: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
427: ,X_MSG_COUNT => X_MSG_COUNT
428: ,X_MSG_DATA => X_MSG_DATA
429: ,X_RETURN_STATUS => X_RETURN_STATUS);
430: End Insert_Period_Rates;

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

448: SAVEPOINT UPDATE_PERIOD_RATES_PUB;
449:
450: -- Debug Message
451: IF l_debug THEN
452: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
453: l_api_name || ' Start');
454: END IF;
455:
456: -- Initialize API return status to SUCCESS

Line 504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

500: p_data => x_msg_data
501: );
502: EXCEPTION
503: WHEN FND_API.G_EXC_ERROR THEN
504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
505: P_MODULE => l_module
506: ,P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

505: P_MODULE => l_module
506: ,P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:

Line 515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_MODULE => l_module
517: ,P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME
519: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 520: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

516: P_MODULE => l_module
517: ,P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME
519: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
520: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
521: ,X_MSG_COUNT => X_MSG_COUNT
522: ,X_MSG_DATA => X_MSG_DATA
523: ,X_RETURN_STATUS => X_RETURN_STATUS);
524:

Line 526: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

522: ,X_MSG_DATA => X_MSG_DATA
523: ,X_RETURN_STATUS => X_RETURN_STATUS);
524:
525: WHEN OTHERS THEN
526: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
527: P_MODULE => l_module
528: ,P_API_NAME => L_API_NAME
529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

526: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
527: P_MODULE => l_module
528: ,P_API_NAME => L_API_NAME
529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
531: ,P_SQLCODE => SQLCODE
532: ,P_SQLERRM => SQLERRM
533: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
534: ,X_MSG_COUNT => X_MSG_COUNT

Line 533: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

529: ,P_PKG_NAME => G_PKG_NAME
530: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
531: ,P_SQLCODE => SQLCODE
532: ,P_SQLERRM => SQLERRM
533: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
534: ,X_MSG_COUNT => X_MSG_COUNT
535: ,X_MSG_DATA => X_MSG_DATA
536: ,X_RETURN_STATUS => X_RETURN_STATUS);
537: End Update_Period_Rates;

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

555: SAVEPOINT DELETE_PERIOD_RATES_PUB;
556:
557: -- Debug Message
558: IF l_debug THEN
559: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
560: l_api_name || ' Start');
561: END IF;
562:
563: -- Initialize API return status to SUCCESS

Line 610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

606: p_data => x_msg_data
607: );
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_MODULE => l_module
612: ,P_API_NAME => L_API_NAME
613: ,P_PKG_NAME => G_PKG_NAME
614: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 615: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

611: P_MODULE => l_module
612: ,P_API_NAME => L_API_NAME
613: ,P_PKG_NAME => G_PKG_NAME
614: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
615: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
616: ,X_MSG_COUNT => X_MSG_COUNT
617: ,X_MSG_DATA => X_MSG_DATA
618: ,X_RETURN_STATUS => X_RETURN_STATUS);
619:

Line 621: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

617: ,X_MSG_DATA => X_MSG_DATA
618: ,X_RETURN_STATUS => X_RETURN_STATUS);
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
622: P_MODULE => l_module
623: ,P_API_NAME => L_API_NAME
624: ,P_PKG_NAME => G_PKG_NAME
625: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 626: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

622: P_MODULE => l_module
623: ,P_API_NAME => L_API_NAME
624: ,P_PKG_NAME => G_PKG_NAME
625: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
626: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
627: ,X_MSG_COUNT => X_MSG_COUNT
628: ,X_MSG_DATA => X_MSG_DATA
629: ,X_RETURN_STATUS => X_RETURN_STATUS);
630:

Line 632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

628: ,X_MSG_DATA => X_MSG_DATA
629: ,X_RETURN_STATUS => X_RETURN_STATUS);
630:
631: WHEN OTHERS THEN
632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_MODULE => l_module
634: ,P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_MODULE => l_module
634: ,P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
637: ,P_SQLCODE => SQLCODE
638: ,P_SQLERRM => SQLERRM
639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
640: ,X_MSG_COUNT => X_MSG_COUNT

Line 639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
637: ,P_SQLCODE => SQLCODE
638: ,P_SQLERRM => SQLERRM
639: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: End Delete_Period_Rates;