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 FND_MSG_PUB

Line 24: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

20: IS
21: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Type_Mappings';
22: i NUMBER;
23: l_last NUMBER;
24: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Insert_Type_Mappings';
26: BEGIN
27: -- Standard Start of API savepoint
28: SAVEPOINT INSERT_TYPE_MAPPINGS_PUB;

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 90: FND_MSG_PUB.Count_And_Get

86: i := i + 1;
87: END LOOP;
88:
89: -- Standard call to get message count and if count is 1, get message info.
90: FND_MSG_PUB.Count_And_Get
91: ( p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: EXCEPTION

Line 100: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 141: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

137: IS
138: l_api_name CONSTANT VARCHAR2(30) := 'Update_Type_Mappings';
139: i NUMBER;
140: l_last NUMBER;
141: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
142: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Update_Type_Mappings';
143: BEGIN
144: -- Standard Start of API savepoint
145: SAVEPOINT UPDATE_TYPE_MAPPINGS_PUB;

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 203: FND_MSG_PUB.Count_And_Get

199: i := i + 1;
200: END LOOP;
201:
202: -- Standard call to get message count and if count is 1, get message info.
203: FND_MSG_PUB.Count_And_Get
204: ( p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: EXCEPTION

Line 213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 224: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 254: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

250: IS
251: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Type_Mappings';
252: i NUMBER;
253: l_last NUMBER;
254: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
255: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Delete_Type_Mappings';
256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT DELETE_TYPE_MAPPINGS_PUB;

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 284: FND_MSG_PUB.Count_And_Get

280: i := i + 1;
281: END LOOP;
282:
283: -- Standard call to get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288:

Line 295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 337: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

333: IS
334: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Period_Rates';
335: i NUMBER;
336: l_last NUMBER;
337: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
338: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Insert_Period_Rates';
339: BEGIN
340: -- Standard Start of API savepoint
341: SAVEPOINT INSERT_PERIOD_RATES_PUB;

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 391: FND_MSG_PUB.Count_And_Get

387: i := i + 1;
388: END LOOP;
389:
390: -- Standard call to get message count and if count is 1, get message info.
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395: EXCEPTION

Line 401: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 444: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

440: IS
441: l_api_name CONSTANT VARCHAR2(30) := 'Update_Period_Rates';
442: i NUMBER;
443: l_last NUMBER;
444: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
445: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Update_Period_Rates';
446: BEGIN
447: -- Standard Start of API savepoint
448: SAVEPOINT UPDATE_PERIOD_RATES_PUB;

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 498: FND_MSG_PUB.Count_And_Get

494: i := i + 1;
495: END LOOP;
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get
499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502: EXCEPTION

Line 508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 519: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 551: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

547: IS
548: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Period_Rates';
549: i NUMBER;
550: l_last NUMBER;
551: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
552: l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Delete_Period_Rates';
553: BEGIN
554: -- Standard Start of API savepoint
555: SAVEPOINT DELETE_PERIOD_RATES_PUB;

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 604: FND_MSG_PUB.Count_And_Get

600: i := i + 1;
601: END LOOP;
602:
603: -- Standard call to get message count and if count is 1, get message info.
604: FND_MSG_PUB.Count_And_Get
605: ( p_count => x_msg_count,
606: p_data => x_msg_data
607: );
608: EXCEPTION

Line 614: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 625: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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