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.AMS_PS_STRATS_PUB dependencies on FND_MSG_PUB

Line 19: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Ps_Strats_PUB';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspstrb.pls';
18:
19: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Ps_Strats(

Line 20: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Ps_Strats_PUB';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspstrb.pls';
18:
19: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Ps_Strats(
24: p_api_version_number IN NUMBER,

Line 21: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspstrb.pls';
18:
19: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Ps_Strats(
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 56: FND_MSG_PUB.initialize;

52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Debug Message
60: IF (AMS_DEBUG_HIGH_ON) THEN

Line 110: FND_MSG_PUB.Count_And_Get

106: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
107: END IF;
108:
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: (p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114: EXCEPTION

Line 124: FND_MSG_PUB.Count_And_Get (

120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CREATE_Ps_Strats_PUB;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- Standard call to get message count and if count=1, get the message
124: FND_MSG_PUB.Count_And_Get (
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data
128: );

Line 134: FND_MSG_PUB.Count_And_Get (

130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO CREATE_Ps_Strats_PUB;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );

Line 143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

139:
140: WHEN OTHERS THEN
141: ROLLBACK TO CREATE_Ps_Strats_PUB;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147: -- Standard call to get message count and if count=1, get the message

Line 145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

141: ROLLBACK TO CREATE_Ps_Strats_PUB;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147: -- Standard call to get message count and if count=1, get the message
148: FND_MSG_PUB.Count_And_Get (
149: p_encoded => FND_API.G_FALSE,

Line 148: FND_MSG_PUB.Count_And_Get (

144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147: -- Standard call to get message count and if count=1, get the message
148: FND_MSG_PUB.Count_And_Get (
149: p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );

Line 190: FND_MSG_PUB.initialize;

186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.to_Boolean( p_init_msg_list )
189: THEN
190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: -- Debug Message
194: IF (AMS_DEBUG_HIGH_ON) THEN

Line 242: FND_MSG_PUB.Count_And_Get

238: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
239: END IF;
240:
241: -- Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get
243: (p_count => x_msg_count,
244: p_data => x_msg_data
245: );
246: EXCEPTION

Line 256: FND_MSG_PUB.Count_And_Get (

252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UPDATE_Ps_Strats_PUB;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );

Line 266: FND_MSG_PUB.Count_And_Get (

262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UPDATE_Ps_Strats_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );

Line 275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

271:
272: WHEN OTHERS THEN
273: ROLLBACK TO UPDATE_Ps_Strats_PUB;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;
279: -- Standard call to get message count and if count=1, get the message

Line 277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

273: ROLLBACK TO UPDATE_Ps_Strats_PUB;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,

Line 280: FND_MSG_PUB.Count_And_Get (

276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );

Line 321: FND_MSG_PUB.initialize;

317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list )
320: THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: -- Debug Message
325: IF (AMS_DEBUG_HIGH_ON) THEN

Line 373: FND_MSG_PUB.Count_And_Get

369: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
370: END IF;
371:
372: -- Standard call to get message count and if count is 1, get message info.
373: FND_MSG_PUB.Count_And_Get
374: (p_count => x_msg_count,
375: p_data => x_msg_data
376: );
377: EXCEPTION

Line 387: FND_MSG_PUB.Count_And_Get (

383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO DELETE_Ps_Strats_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );

Line 397: FND_MSG_PUB.Count_And_Get (

393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO DELETE_Ps_Strats_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

Line 406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

402:
403: WHEN OTHERS THEN
404: ROLLBACK TO DELETE_Ps_Strats_PUB;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message

Line 408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

404: ROLLBACK TO DELETE_Ps_Strats_PUB;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,

Line 411: FND_MSG_PUB.Count_And_Get (

407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );

Line 448: FND_MSG_PUB.initialize;

444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list )
447: THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:
451: -- Debug Message
452: IF (AMS_DEBUG_HIGH_ON) THEN

Line 502: FND_MSG_PUB.Count_And_Get (

498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO LOCK_Ps_Strats_PUB;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,
505: p_data => x_msg_data
506: );

Line 512: FND_MSG_PUB.Count_And_Get (

508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO LOCK_Ps_Strats_PUB;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );

Line 521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

517:
518: WHEN OTHERS THEN
519: ROLLBACK TO LOCK_Ps_Strats_PUB;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;
525: -- Standard call to get message count and if count=1, get the message

Line 523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

519: ROLLBACK TO LOCK_Ps_Strats_PUB;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,

Line 526: FND_MSG_PUB.Count_And_Get (

522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );