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_ADHOC_PARAM_PVT dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 163: FND_MSG_PUB.Count_And_Get

159: -- Debug Message
160: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
161:
162: -- Standard call to get message count and if count is 1, get message info.
163: FND_MSG_PUB.Count_And_Get
164: (p_count => x_msg_count,
165: p_data => x_msg_data
166: );
167: EXCEPTION

Line 177: FND_MSG_PUB.Count_And_Get (

173: WHEN FND_API.G_EXC_ERROR THEN
174: ROLLBACK TO CREATE_Adhoc_Param_PVT;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: -- Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data
181: );

Line 187: FND_MSG_PUB.Count_And_Get (

183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: ROLLBACK TO CREATE_Adhoc_Param_PVT;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );

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

192:
193: WHEN OTHERS THEN
194: ROLLBACK TO CREATE_Adhoc_Param_PVT;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
199: END IF;
200: -- Standard call to get message count and if count=1, get the message

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

194: ROLLBACK TO CREATE_Adhoc_Param_PVT;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
199: END IF;
200: -- Standard call to get message count and if count=1, get the message
201: FND_MSG_PUB.Count_And_Get (
202: p_encoded => FND_API.G_FALSE,

Line 201: FND_MSG_PUB.Count_And_Get (

197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
199: END IF;
200: -- Standard call to get message count and if count=1, get the message
201: FND_MSG_PUB.Count_And_Get (
202: p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data
205: );

Line 253: FND_MSG_PUB.initialize;

249:
250: -- Initialize message list if p_init_msg_list is set to TRUE.
251: IF FND_API.to_Boolean( p_init_msg_list )
252: THEN
253: FND_MSG_PUB.initialize;
254: END IF;
255:
256: -- Debug Message
257: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

315: END IF;
316:
317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row(
323: p_adhoc_param_id => p_adhoc_param_rec.adhoc_param_id,

Line 349: FND_MSG_PUB.Count_And_Get

345: -- Debug Message
346: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
347:
348: -- Standard call to get message count and if count is 1, get message info.
349: FND_MSG_PUB.Count_And_Get
350: (p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: EXCEPTION

Line 363: FND_MSG_PUB.Count_And_Get (

359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UPDATE_Adhoc_Param_PVT;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );

Line 373: FND_MSG_PUB.Count_And_Get (

369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UPDATE_Adhoc_Param_PVT;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );

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

378:
379: WHEN OTHERS THEN
380: ROLLBACK TO UPDATE_Adhoc_Param_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message

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

380: ROLLBACK TO UPDATE_Adhoc_Param_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
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,

Line 387: FND_MSG_PUB.Count_And_Get (

383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
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 428: FND_MSG_PUB.initialize;

424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 462: FND_MSG_PUB.Count_And_Get

458: -- Debug Message
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,
464: p_data => x_msg_data
465: );
466: EXCEPTION

Line 476: FND_MSG_PUB.Count_And_Get (

472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO DELETE_Adhoc_Param_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );

Line 486: FND_MSG_PUB.Count_And_Get (

482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO DELETE_Adhoc_Param_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );

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

491:
492: WHEN OTHERS THEN
493: ROLLBACK TO DELETE_Adhoc_Param_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message

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

493: ROLLBACK TO DELETE_Adhoc_Param_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,

Line 500: FND_MSG_PUB.Count_And_Get (

496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data
504: );

Line 543: FND_MSG_PUB.initialize;

539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.
541: IF FND_API.to_Boolean( p_init_msg_list )
542: THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

565: FETCH c_Adhoc_Param INTO l_ADHOC_PARAM_ID;
566:
567: IF (c_Adhoc_Param%NOTFOUND) THEN
568: CLOSE c_Adhoc_Param;
569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
570: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
571: FND_MSG_PUB.add;
572: END IF;
573: RAISE FND_API.g_exc_error;

Line 571: FND_MSG_PUB.add;

567: IF (c_Adhoc_Param%NOTFOUND) THEN
568: CLOSE c_Adhoc_Param;
569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
570: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
571: FND_MSG_PUB.add;
572: END IF;
573: RAISE FND_API.g_exc_error;
574: END IF;
575:

Line 579: FND_MSG_PUB.count_and_get(

575:
576: CLOSE c_Adhoc_Param;
577:
578: -------------------- finish --------------------------
579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,
581: p_count => x_msg_count,
582: p_data => x_msg_data);
583: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 594: FND_MSG_PUB.Count_And_Get (

590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO LOCK_Adhoc_Param_PVT;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
598: );

Line 604: FND_MSG_PUB.Count_And_Get (

600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO LOCK_Adhoc_Param_PVT;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: -- Standard call to get message count and if count=1, get the message
604: FND_MSG_PUB.Count_And_Get (
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data
608: );

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

609:
610: WHEN OTHERS THEN
611: ROLLBACK TO LOCK_Adhoc_Param_PVT;
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
616: END IF;
617: -- Standard call to get message count and if count=1, get the message

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

611: ROLLBACK TO LOCK_Adhoc_Param_PVT;
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
616: END IF;
617: -- Standard call to get message count and if count=1, get the message
618: FND_MSG_PUB.Count_And_Get (
619: p_encoded => FND_API.G_FALSE,

Line 618: FND_MSG_PUB.Count_And_Get (

614: THEN
615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
616: END IF;
617: -- Standard call to get message count and if count=1, get the message
618: FND_MSG_PUB.Count_And_Get (
619: p_encoded => FND_API.G_FALSE,
620: p_count => x_msg_count,
621: p_data => x_msg_data
622: );

Line 960: FND_MSG_PUB.initialize;

956:
957: -- Initialize message list if p_init_msg_list is set to TRUE.
958: IF FND_API.to_Boolean( p_init_msg_list )
959: THEN
960: FND_MSG_PUB.initialize;
961: END IF;
962: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
963: Check_adhoc_param_Items(
964: p_adhoc_param_rec => p_adhoc_param_rec,

Line 1010: FND_MSG_PUB.Count_And_Get

1006: -- Debug Message
1007: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1008:
1009: -- Standard call to get message count and if count is 1, get message info.
1010: FND_MSG_PUB.Count_And_Get
1011: (p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );
1014: EXCEPTION

Line 1024: FND_MSG_PUB.Count_And_Get (

1020: WHEN FND_API.G_EXC_ERROR THEN
1021: ROLLBACK TO VALIDATE_Adhoc_Param_;
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );

Line 1034: FND_MSG_PUB.Count_And_Get (

1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO VALIDATE_Adhoc_Param_;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: -- Standard call to get message count and if count=1, get the message
1034: FND_MSG_PUB.Count_And_Get (
1035: p_encoded => FND_API.G_FALSE,
1036: p_count => x_msg_count,
1037: p_data => x_msg_data
1038: );

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

1039:
1040: WHEN OTHERS THEN
1041: ROLLBACK TO VALIDATE_Adhoc_Param_;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1046: END IF;
1047: -- Standard call to get message count and if count=1, get the message

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

1041: ROLLBACK TO VALIDATE_Adhoc_Param_;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1046: END IF;
1047: -- Standard call to get message count and if count=1, get the message
1048: FND_MSG_PUB.Count_And_Get (
1049: p_encoded => FND_API.G_FALSE,

Line 1048: FND_MSG_PUB.Count_And_Get (

1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1046: END IF;
1047: -- Standard call to get message count and if count=1, get the message
1048: FND_MSG_PUB.Count_And_Get (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );

Line 1069: FND_MSG_PUB.initialize;

1065: BEGIN
1066: -- Initialize message list if p_init_msg_list is set to TRUE.
1067: IF FND_API.to_Boolean( p_init_msg_list )
1068: THEN
1069: FND_MSG_PUB.initialize;
1070: END IF;
1071:
1072: -- Initialize API return status to SUCCESS
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1083: FND_MSG_PUB.Count_And_Get

1079:
1080: -- Debug Message
1081: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: (p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );
1087: END Validate_adhoc_param_Rec;