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

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

21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvcacb.pls';
22:
23:
24: -- Hint: Primary key needs to be returned.
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Create_Cat_Activity(

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

22:
23:
24: -- Hint: Primary key needs to be returned.
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Create_Cat_Activity(
30: p_api_version_number IN NUMBER,

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

23:
24: -- Hint: Primary key needs to be returned.
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Create_Cat_Activity(
30: p_api_version_number IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 77: FND_MSG_PUB.initialize;

73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )
76: THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: -- Debug Message
81: IF (AMS_DEBUG_HIGH_ON) THEN

Line 201: FND_MSG_PUB.Count_And_Get

197: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
198: END IF;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205: EXCEPTION

Line 215: FND_MSG_PUB.Count_And_Get (

211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Cat_Activity_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
219: );

Line 225: FND_MSG_PUB.Count_And_Get (

221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Cat_Activity_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );

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

230:
231: WHEN OTHERS THEN
232: ROLLBACK TO CREATE_Cat_Activity_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message

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

232: ROLLBACK TO CREATE_Cat_Activity_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,

Line 239: FND_MSG_PUB.Count_And_Get (

235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 295: FND_MSG_PUB.initialize;

291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean( p_init_msg_list )
294: THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Debug Message
299: IF (AMS_DEBUG_HIGH_ON) THEN

Line 414: FND_MSG_PUB.Count_And_Get

410: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
411: END IF;
412:
413: -- Standard call to get message count and if count is 1, get message info.
414: FND_MSG_PUB.Count_And_Get
415: (p_count => x_msg_count,
416: p_data => x_msg_data
417: );
418: EXCEPTION

Line 428: FND_MSG_PUB.Count_And_Get (

424: WHEN FND_API.G_EXC_ERROR THEN
425: ROLLBACK TO UPDATE_Cat_Activity_PVT;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: -- Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );

Line 438: FND_MSG_PUB.Count_And_Get (

434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: ROLLBACK TO UPDATE_Cat_Activity_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );

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

443:
444: WHEN OTHERS THEN
445: ROLLBACK TO UPDATE_Cat_Activity_PVT;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
450: END IF;
451: -- Standard call to get message count and if count=1, get the message

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

445: ROLLBACK TO UPDATE_Cat_Activity_PVT;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
450: END IF;
451: -- Standard call to get message count and if count=1, get the message
452: FND_MSG_PUB.Count_And_Get (
453: p_encoded => FND_API.G_FALSE,

Line 452: FND_MSG_PUB.Count_And_Get (

448: THEN
449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
450: END IF;
451: -- Standard call to get message count and if count=1, get the message
452: FND_MSG_PUB.Count_And_Get (
453: p_encoded => FND_API.G_FALSE,
454: p_count => x_msg_count,
455: p_data => x_msg_data
456: );

Line 493: FND_MSG_PUB.initialize;

489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.to_Boolean( p_init_msg_list )
492: THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Debug Message
497: IF (AMS_DEBUG_HIGH_ON) THEN

Line 537: FND_MSG_PUB.Count_And_Get

533: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
534: END IF;
535:
536: -- Standard call to get message count and if count is 1, get message info.
537: FND_MSG_PUB.Count_And_Get
538: (p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541: EXCEPTION

Line 551: FND_MSG_PUB.Count_And_Get (

547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO DELETE_Cat_Activity_PVT;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data
555: );

Line 561: FND_MSG_PUB.Count_And_Get (

557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558: ROLLBACK TO DELETE_Cat_Activity_PVT;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
565: );

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

566:
567: WHEN OTHERS THEN
568: ROLLBACK TO DELETE_Cat_Activity_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message

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

568: ROLLBACK TO DELETE_Cat_Activity_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,

Line 575: FND_MSG_PUB.Count_And_Get (

571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );

Line 621: FND_MSG_PUB.initialize;

617:
618: -- Initialize message list if p_init_msg_list is set to TRUE.
619: IF FND_API.to_Boolean( p_init_msg_list )
620: THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: -- Standard call to check for call compatibility.
625: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

649: FETCH c_Cat_Activity INTO l_CAT_ACTIVITY_ID;
650:
651: IF (c_Cat_Activity%NOTFOUND) THEN
652: CLOSE c_Cat_Activity;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
654: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
655: FND_MSG_PUB.add;
656: END IF;
657: RAISE FND_API.g_exc_error;

Line 655: FND_MSG_PUB.add;

651: IF (c_Cat_Activity%NOTFOUND) THEN
652: CLOSE c_Cat_Activity;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
654: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
655: FND_MSG_PUB.add;
656: END IF;
657: RAISE FND_API.g_exc_error;
658: END IF;
659:

Line 663: FND_MSG_PUB.count_and_get(

659:
660: CLOSE c_Cat_Activity;
661:
662: -------------------- finish --------------------------
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.g_false,
665: p_count => x_msg_count,
666: p_data => x_msg_data);
667: IF (AMS_DEBUG_HIGH_ON) THEN

Line 681: FND_MSG_PUB.Count_And_Get (

677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO LOCK_Cat_Activity_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );

Line 691: FND_MSG_PUB.Count_And_Get (

687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO LOCK_Cat_Activity_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

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

696:
697: WHEN OTHERS THEN
698: ROLLBACK TO LOCK_Cat_Activity_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message

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

698: ROLLBACK TO LOCK_Cat_Activity_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,

Line 705: FND_MSG_PUB.Count_And_Get (

701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data
709: );

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

779: END IF;
780:
781:
782: IF p_cat_activity_rec.activity_id = FND_API.g_miss_num OR p_cat_activity_rec.activity_id IS NULL THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
784: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_ACTIVITY_ID');
785: FND_MSG_PUB.add;
786: END IF;
787: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cat_activity_NO_activity_id');

Line 785: FND_MSG_PUB.add;

781:
782: IF p_cat_activity_rec.activity_id = FND_API.g_miss_num OR p_cat_activity_rec.activity_id IS NULL THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
784: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_ACTIVITY_ID');
785: FND_MSG_PUB.add;
786: END IF;
787: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cat_activity_NO_activity_id');
788: x_return_status := FND_API.g_ret_sts_error;
789: RETURN;

Line 1022: FND_MSG_PUB.initialize;

1018:
1019: -- Initialize message list if p_init_msg_list is set to TRUE.
1020: IF FND_API.to_Boolean( p_init_msg_list )
1021: THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1025: Check_cat_activity_Items(
1026: p_cat_activity_rec => p_cat_activity_rec,

Line 1079: FND_MSG_PUB.Count_And_Get

1075: AMS_UTILITY_PVT.debug_message('Private API: end of validate');
1076: END IF;
1077:
1078: -- Standard call to get message count and if count is 1, get message info.
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083: EXCEPTION

Line 1093: FND_MSG_PUB.Count_And_Get (

1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO VALIDATE_Cat_Activity_;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: -- Standard call to get message count and if count=1, get the message
1093: FND_MSG_PUB.Count_And_Get (
1094: p_encoded => FND_API.G_FALSE,
1095: p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );

Line 1103: FND_MSG_PUB.Count_And_Get (

1099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1100: ROLLBACK TO VALIDATE_Cat_Activity_;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: -- Standard call to get message count and if count=1, get the message
1103: FND_MSG_PUB.Count_And_Get (
1104: p_encoded => FND_API.G_FALSE,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );

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

1108:
1109: WHEN OTHERS THEN
1110: ROLLBACK TO VALIDATE_Cat_Activity_;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1113: THEN
1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1115: END IF;
1116: -- Standard call to get message count and if count=1, get the message

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

1110: ROLLBACK TO VALIDATE_Cat_Activity_;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1113: THEN
1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1115: END IF;
1116: -- Standard call to get message count and if count=1, get the message
1117: FND_MSG_PUB.Count_And_Get (
1118: p_encoded => FND_API.G_FALSE,

Line 1117: FND_MSG_PUB.Count_And_Get (

1113: THEN
1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1115: END IF;
1116: -- Standard call to get message count and if count=1, get the message
1117: FND_MSG_PUB.Count_And_Get (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data
1121: );

Line 1138: FND_MSG_PUB.initialize;

1134: BEGIN
1135: -- Initialize message list if p_init_msg_list is set to TRUE.
1136: IF FND_API.to_Boolean( p_init_msg_list )
1137: THEN
1138: FND_MSG_PUB.initialize;
1139: END IF;
1140:
1141: -- Initialize API return status to SUCCESS
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1155: FND_MSG_PUB.Count_And_Get

1151:
1152: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1153: END IF;
1154: -- Standard call to get message count and if count is 1, get message info.
1155: FND_MSG_PUB.Count_And_Get
1156: (p_count => x_msg_count,
1157: p_data => x_msg_data
1158: );
1159: END Validate_cat_activity_Rec;