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

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

19: g_count NUMBER := 1;
20: g_remote_list VARCHAR2(1) := 'N';
21: g_message_table AMS_LISTGENERATION_PKG.sql_string;
22: g_message_table_null AMS_LISTGENERATION_PKG.sql_string;
23: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE copy_selections

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

20: g_remote_list VARCHAR2(1) := 'N';
21: g_message_table AMS_LISTGENERATION_PKG.sql_string;
22: g_message_table_null AMS_LISTGENERATION_PKG.sql_string;
23: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE copy_selections
28: (p_old_header_id in number,

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

21: g_message_table AMS_LISTGENERATION_PKG.sql_string;
22: g_message_table_null AMS_LISTGENERATION_PKG.sql_string;
23: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE copy_selections
28: (p_old_header_id in number,
29: p_new_header_id in number,

Line 200: FND_MSG_PUB.Add;

196: AMS_Utility_PVT.debug_message('FROM:' || l_found);
197: END IF;
198: IF l_found = 'N' THEN
199: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
200: FND_MSG_PUB.Add;
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: l_found := 'N';

Line 223: FND_MSG_PUB.Add;

219: AMS_Utility_PVT.debug_message('MASTER_TYPE:' || l_found);
220: END IF;
221: IF nvl(l_found,'N') = 'N' THEN
222: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
223: FND_MSG_PUB.Add;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: END IF;
227: IF (AMS_DEBUG_HIGH_ON) THEN

Line 231: FND_MSG_PUB.count_and_get(

227: IF (AMS_DEBUG_HIGH_ON) THEN
228: AMS_Utility_PVT.debug_message('sucess full:' );
229: END IF;
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,
234: p_data => x_msg_data);
235:

Line 240: FND_MSG_PUB.Add;

236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
240: FND_MSG_PUB.Add;
241: -- Check if reset of the status is required
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,

Line 243: FND_MSG_PUB.count_and_get(

239: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
240: FND_MSG_PUB.Add;
241: -- Check if reset of the status is required
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,
245: p_count => x_msg_count,
246: p_data => x_msg_data);
247:

Line 250: FND_MSG_PUB.Add;

246: p_data => x_msg_data);
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: FND_MSG_PUB.count_and_get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,

Line 252: FND_MSG_PUB.count_and_get(

248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: FND_MSG_PUB.count_and_get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:

Line 259: FND_MSG_PUB.Add;

255: p_data => x_msg_data);
256:
257: WHEN OTHERS THEN
258: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
259: FND_MSG_PUB.Add;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: FND_MSG_PUB.count_and_get(
262: p_encoded => FND_API.g_false,
263: p_count => x_msg_count,

Line 261: FND_MSG_PUB.count_and_get(

257: WHEN OTHERS THEN
258: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
259: FND_MSG_PUB.Add;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: FND_MSG_PUB.count_and_get(
262: p_encoded => FND_API.g_false,
263: p_count => x_msg_count,
264: p_data => x_msg_data);
265: END validate_segment;

Line 435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

431: end if;
432: IF l_action_type <> FND_API.G_MISS_CHAR
433: AND l_action_type IS NOT NULL THEN
434: IF(l_action_type <>'INCLUDE')THEN
435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
436: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
437: FND_MSG_PUB.Add;
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 437: FND_MSG_PUB.Add;

433: AND l_action_type IS NOT NULL THEN
434: IF(l_action_type <>'INCLUDE')THEN
435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
436: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
437: FND_MSG_PUB.Add;
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF; --end if l_action_type <>'INCLUDE'

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

626: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
627: END IF;
628:
629: -- Standard call to get message count and if count is 1, get message info.
630: FND_MSG_PUB.Count_And_Get
631: (p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: EXCEPTION

Line 644: FND_MSG_PUB.Count_And_Get (

640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO CREATE_Act_List_PVT;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: -- Standard call to get message count and if count=1, get the message
644: FND_MSG_PUB.Count_And_Get (
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );

Line 654: FND_MSG_PUB.Count_And_Get (

650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: ROLLBACK TO CREATE_Act_List_PVT;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );

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

659:
660: WHEN OTHERS THEN
661: ROLLBACK TO CREATE_Act_List_PVT;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message

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

661: ROLLBACK TO CREATE_Act_List_PVT;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,

Line 668: FND_MSG_PUB.Count_And_Get (

664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data
672: );

Line 874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

870: end if;
871: IF l_action_type <> FND_API.G_MISS_CHAR
872: AND l_action_type IS NOT NULL THEN
873: IF(l_action_type <>'INCLUDE')THEN
874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
876: FND_MSG_PUB.Add;
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR;

Line 876: FND_MSG_PUB.Add;

872: AND l_action_type IS NOT NULL THEN
873: IF(l_action_type <>'INCLUDE')THEN
874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
876: FND_MSG_PUB.Add;
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: RAISE FND_API.G_EXC_ERROR;
880: END IF; --end if l_action_type <>'INCLUDE'

Line 889: FND_MSG_PUB.initialize;

885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.
887: IF FND_API.to_Boolean( p_init_msg_list )
888: THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891:
892: -- Debug Message
893: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1040: FND_MSG_PUB.Count_And_Get

1036: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1037: END IF;
1038:
1039: -- Standard call to get message count and if count is 1, get message info.
1040: FND_MSG_PUB.Count_And_Get
1041: (p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044: EXCEPTION

Line 1053: FND_MSG_PUB.Count_And_Get (

1049: WHEN FND_API.G_EXC_ERROR THEN
1050: ROLLBACK TO UPDATE_Act_List_PVT;
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: -- Standard call to get message count and if count=1, get the message
1053: FND_MSG_PUB.Count_And_Get (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );

Line 1063: FND_MSG_PUB.Count_And_Get (

1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO UPDATE_Act_List_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );

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

1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK TO UPDATE_Act_List_PVT;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1075: END IF;
1076: -- Standard call to get message count and if count=1, get the message

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

1070: ROLLBACK TO UPDATE_Act_List_PVT;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1075: END IF;
1076: -- Standard call to get message count and if count=1, get the message
1077: FND_MSG_PUB.Count_And_Get (
1078: p_encoded => FND_API.G_FALSE,

Line 1077: FND_MSG_PUB.Count_And_Get (

1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1075: END IF;
1076: -- Standard call to get message count and if count=1, get the message
1077: FND_MSG_PUB.Count_And_Get (
1078: p_encoded => FND_API.G_FALSE,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );

Line 1136: FND_MSG_PUB.initialize;

1132:
1133: -- Initialize message list if p_init_msg_list is set to TRUE.
1134: IF FND_API.to_Boolean( p_init_msg_list )
1135: THEN
1136: FND_MSG_PUB.initialize;
1137: END IF;
1138:
1139: -- Debug Message
1140: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1162: FND_MSG_PUB.add;

1158:
1159: -- Invoke table handler(AMS_ACT_LISTS_PKG.Delete_Row)
1160: if l_char = 'x' then
1161: FND_MESSAGE.set_name('AMS', 'AMS_DELETE_TARGET');
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_error;
1164: else
1165: AMS_ACT_LISTS_PKG.Delete_Row(
1166: p_ACT_LIST_HEADER_ID => p_ACT_LIST_HEADER_ID);

Line 1186: FND_MSG_PUB.Count_And_Get

1182: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1183: END IF;
1184:
1185: -- Standard call to get message count and if count is 1, get message info.
1186: FND_MSG_PUB.Count_And_Get
1187: (p_count => x_msg_count,
1188: p_data => x_msg_data
1189: );
1190: EXCEPTION

Line 1199: FND_MSG_PUB.Count_And_Get (

1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO DELETE_Act_List_PVT;
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get (
1200: p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,
1202: p_data => x_msg_data
1203: );

Line 1209: FND_MSG_PUB.Count_And_Get (

1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1206: ROLLBACK TO DELETE_Act_List_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208: -- Standard call to get message count and if count=1, get the message
1209: FND_MSG_PUB.Count_And_Get (
1210: p_encoded => FND_API.G_FALSE,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data
1213: );

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

1214:
1215: WHEN OTHERS THEN
1216: ROLLBACK TO DELETE_Act_List_PVT;
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1221: END IF;
1222: -- Standard call to get message count and if count=1, get the message

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

1216: ROLLBACK TO DELETE_Act_List_PVT;
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1221: END IF;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,

Line 1223: FND_MSG_PUB.Count_And_Get (

1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1221: END IF;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1227: );

Line 1266: FND_MSG_PUB.initialize;

1262: END IF;
1263: -- Initialize message list if p_init_msg_list is set to TRUE.
1264: IF FND_API.to_Boolean( p_init_msg_list )
1265: THEN
1266: FND_MSG_PUB.initialize;
1267: END IF;
1268:
1269: -- Standard call to check for call compatibility.
1270: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1291: FETCH c_Act_List INTO l_ACT_LIST_HEADER_ID;
1292:
1293: IF (c_Act_List%NOTFOUND) THEN
1294: CLOSE c_Act_List;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1296: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: RAISE FND_API.g_exc_error;

Line 1297: FND_MSG_PUB.add;

1293: IF (c_Act_List%NOTFOUND) THEN
1294: CLOSE c_Act_List;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1296: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: RAISE FND_API.g_exc_error;
1300: END IF;
1301:

Line 1305: FND_MSG_PUB.count_and_get(

1301:
1302: CLOSE c_Act_List;
1303:
1304: -------------------- finish --------------------------
1305: FND_MSG_PUB.count_and_get(
1306: p_encoded => FND_API.g_false,
1307: p_count => x_msg_count,
1308: p_data => x_msg_data);
1309: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1322: FND_MSG_PUB.Count_And_Get (

1318: WHEN FND_API.G_EXC_ERROR THEN
1319: ROLLBACK TO LOCK_Act_List_PVT;
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: -- Standard call to get message count and if count=1, get the message
1322: FND_MSG_PUB.Count_And_Get (
1323: p_encoded => FND_API.G_FALSE,
1324: p_count => x_msg_count,
1325: p_data => x_msg_data
1326: );

Line 1332: FND_MSG_PUB.Count_And_Get (

1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1329: ROLLBACK TO LOCK_Act_List_PVT;
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: -- Standard call to get message count and if count=1, get the message
1332: FND_MSG_PUB.Count_And_Get (
1333: p_encoded => FND_API.G_FALSE,
1334: p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );

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

1337:
1338: WHEN OTHERS THEN
1339: ROLLBACK TO LOCK_Act_List_PVT;
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1342: THEN
1343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1344: END IF;
1345: -- Standard call to get message count and if count=1, get the message

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

1339: ROLLBACK TO LOCK_Act_List_PVT;
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1342: THEN
1343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1344: END IF;
1345: -- Standard call to get message count and if count=1, get the message
1346: FND_MSG_PUB.Count_And_Get (
1347: p_encoded => FND_API.G_FALSE,

Line 1346: FND_MSG_PUB.Count_And_Get (

1342: THEN
1343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1344: END IF;
1345: -- Standard call to get message count and if count=1, get the message
1346: FND_MSG_PUB.Count_And_Get (
1347: p_encoded => FND_API.G_FALSE,
1348: p_count => x_msg_count,
1349: p_data => x_msg_data
1350: );

Line 1574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1570: THEN
1571: x_return_status := FND_API.G_RET_STS_SUCCESS;
1572:
1573: ELSE
1574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1575: THEN
1576: FND_MESSAGE.set_name('AMS', 'AMS_SCHEDULE_ID_MISSING');
1577: FND_MSG_PUB.Add;
1578: END IF;

Line 1577: FND_MSG_PUB.Add;

1573: ELSE
1574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1575: THEN
1576: FND_MESSAGE.set_name('AMS', 'AMS_SCHEDULE_ID_MISSING');
1577: FND_MSG_PUB.Add;
1578: END IF;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;

Line 1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1606: THEN
1607: x_return_status := FND_API.G_RET_STS_SUCCESS;
1608:
1609: ELSE
1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');
1613: FND_MSG_PUB.Add;
1614: END IF;

Line 1613: FND_MSG_PUB.Add;

1609: ELSE
1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');
1613: FND_MSG_PUB.Add;
1614: END IF;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;

Line 1638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1634: p_lookup_type => 'AMS_LIST_ACT_TYPE',
1635: p_lookup_code => p_act_list_rec.list_act_type
1636: ) = FND_API.g_false
1637: THEN
1638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1639: THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1641: FND_MESSAGE.set_token('LIST_ACT_TYPE',
1642: p_act_list_rec.list_act_type);

Line 1643: FND_MSG_PUB.add;

1639: THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1641: FND_MESSAGE.set_token('LIST_ACT_TYPE',
1642: p_act_list_rec.list_act_type);
1643: FND_MSG_PUB.add;
1644: END IF;
1645:
1646: x_return_status := FND_API.g_ret_sts_error;
1647: RETURN;

Line 1659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1655: p_lookup_type => 'AMS_LIST_SELECT_ACTION',
1656: p_lookup_code => p_act_list_rec.list_action_type
1657: ) = FND_API.g_false
1658: THEN
1659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1660: THEN
1661: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1662: FND_MESSAGE.set_token('LIST_ACT_TYPE', p_act_list_rec.list_action_type);
1663: FND_MSG_PUB.add;

Line 1663: FND_MSG_PUB.add;

1659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1660: THEN
1661: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1662: FND_MESSAGE.set_token('LIST_ACT_TYPE', p_act_list_rec.list_action_type);
1663: FND_MSG_PUB.add;
1664: END IF;
1665:
1666: x_return_status := FND_API.g_ret_sts_error;
1667: RETURN;

Line 1783: FND_MSG_PUB.initialize;

1779:
1780: -- Initialize message list if p_init_msg_list is set to TRUE.
1781: IF FND_API.to_Boolean( p_init_msg_list )
1782: THEN
1783: FND_MSG_PUB.initialize;
1784: END IF;
1785:
1786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1787: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1841: FND_MSG_PUB.Count_And_Get (

1837: WHEN FND_API.G_EXC_ERROR THEN
1838: ROLLBACK TO VALIDATE_Act_List_;
1839: x_return_status := FND_API.G_RET_STS_ERROR;
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,
1843: p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );

Line 1851: FND_MSG_PUB.Count_And_Get (

1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: ROLLBACK TO VALIDATE_Act_List_;
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1850: -- Standard call to get message count and if count=1, get the message
1851: FND_MSG_PUB.Count_And_Get (
1852: p_encoded => FND_API.G_FALSE,
1853: p_count => x_msg_count,
1854: p_data => x_msg_data
1855: );

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

1856:
1857: WHEN OTHERS THEN
1858: ROLLBACK TO VALIDATE_Act_List_;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1861: THEN
1862: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1863: END IF;
1864: -- Standard call to get message count and if count=1, get the message

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

1858: ROLLBACK TO VALIDATE_Act_List_;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1861: THEN
1862: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1863: END IF;
1864: -- Standard call to get message count and if count=1, get the message
1865: FND_MSG_PUB.Count_And_Get (
1866: p_encoded => FND_API.G_FALSE,

Line 1865: FND_MSG_PUB.Count_And_Get (

1861: THEN
1862: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1863: END IF;
1864: -- Standard call to get message count and if count=1, get the message
1865: FND_MSG_PUB.Count_And_Get (
1866: p_encoded => FND_API.G_FALSE,
1867: p_count => x_msg_count,
1868: p_data => x_msg_data
1869: );

Line 1886: FND_MSG_PUB.initialize;

1882: BEGIN
1883: -- Initialize message list if p_init_msg_list is set to TRUE.
1884: IF FND_API.to_Boolean( p_init_msg_list )
1885: THEN
1886: FND_MSG_PUB.initialize;
1887: END IF;
1888:
1889: -- Initialize API return status to SUCCESS
1890: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1903: FND_MSG_PUB.Count_And_Get

1899:
1900: AMS_Utility_PVT.debug_message('Private API: Validate_rec');
1901: END IF;
1902: -- Standard call to get message count and if count is 1, get message info.
1903: FND_MSG_PUB.Count_And_Get
1904: (p_count => x_msg_count,
1905: p_data => x_msg_data
1906: );
1907: END Validate_act_list_Rec;

Line 1951: FND_MSG_PUB.initialize;

1947:
1948:
1949: -- Initialize message list IF p_init_msg_list is set to TRUE.
1950: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1951: FND_MSG_PUB.initialize;
1952: END IF;
1953:
1954: -- Debug Message
1955: /*

Line 1959: FND_MSG_PUB.Add;

1955: /*
1956: IF (AMS_DEBUG_HIGH_ON) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1958: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
1959: FND_MSG_PUB.Add;
1960: END IF;
1961: */
1962: -- Initialize API return status to success
1963: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2013: END IF;
2014:
2015: -- Success Message
2016: -- MMSG
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2018: THEN
2019: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2020: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2021: FND_MSG_PUB.Add;

Line 2021: FND_MSG_PUB.Add;

2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2018: THEN
2019: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2020: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2021: FND_MSG_PUB.Add;
2022: END IF;
2023:
2024:
2025: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 2028: FND_MSG_PUB.Add;

2024:
2025: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2026: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2027: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2028: FND_MSG_PUB.Add;
2029: END IF; */
2030: FND_MSG_PUB.count_and_get(
2031: p_encoded => FND_API.g_false,
2032: p_count => x_msg_count,

Line 2030: FND_MSG_PUB.count_and_get(

2026: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2027: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2028: FND_MSG_PUB.Add;
2029: END IF; */
2030: FND_MSG_PUB.count_and_get(
2031: p_encoded => FND_API.g_false,
2032: p_count => x_msg_count,
2033: p_data => x_msg_data
2034: );

Line 2040: FND_MSG_PUB.Add;

2036: EXCEPTION
2037: WHEN FND_API.G_EXC_ERROR THEN
2038: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2039: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2040: FND_MSG_PUB.Add;
2041: -- Check if reset of the status is required
2042: x_return_status := FND_API.G_RET_STS_ERROR ;
2043: FND_MSG_PUB.count_and_get(
2044: p_encoded => FND_API.g_false,

Line 2043: FND_MSG_PUB.count_and_get(

2039: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2040: FND_MSG_PUB.Add;
2041: -- Check if reset of the status is required
2042: x_return_status := FND_API.G_RET_STS_ERROR ;
2043: FND_MSG_PUB.count_and_get(
2044: p_encoded => FND_API.g_false,
2045: p_count => x_msg_count,
2046: p_data => x_msg_data);
2047:

Line 2051: FND_MSG_PUB.Add;

2047:
2048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2049: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2050: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2051: FND_MSG_PUB.Add;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2053: FND_MSG_PUB.count_and_get(
2054: p_encoded => FND_API.g_false,
2055: p_count => x_msg_count,

Line 2053: FND_MSG_PUB.count_and_get(

2049: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2050: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2051: FND_MSG_PUB.Add;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2053: FND_MSG_PUB.count_and_get(
2054: p_encoded => FND_API.g_false,
2055: p_count => x_msg_count,
2056: p_data => x_msg_data);
2057:

Line 2061: FND_MSG_PUB.Add;

2057:
2058: WHEN OTHERS THEN
2059: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2060: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2061: FND_MSG_PUB.Add;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2063: FND_MSG_PUB.count_and_get(
2064: p_encoded => FND_API.g_false,
2065: p_count => x_msg_count,

Line 2063: FND_MSG_PUB.count_and_get(

2059: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2060: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2061: FND_MSG_PUB.Add;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2063: FND_MSG_PUB.count_and_get(
2064: p_encoded => FND_API.g_false,
2065: p_count => x_msg_count,
2066: p_data => x_msg_data);
2067: END create_target_group_list;

Line 2479: FND_MSG_PUB.Add;

2475: /* ckapoor
2476: IF (AMS_DEBUG_HIGH_ON) THEN
2477: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2478: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: Start', TRUE);
2479: FND_MSG_PUB.Add;
2480: END IF; */
2481:
2482: IF (AMS_DEBUG_HIGH_ON) THEN
2483: AMS_Utility_PVT.debug_message('Update_Source_Code:Start');

Line 2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2520:
2521: if x_return_status <> FND_API.g_ret_sts_success THEN
2522: RAISE FND_API.G_EXC_ERROR;
2523: end if;
2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2525: THEN
2526: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2527: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT.Update_ListEntry_Source_Code', TRUE);
2528: FND_MSG_PUB.Add;

Line 2528: FND_MSG_PUB.Add;

2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2525: THEN
2526: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2527: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT.Update_ListEntry_Source_Code', TRUE);
2528: FND_MSG_PUB.Add;
2529: END IF;
2530:
2531:
2532: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 2535: FND_MSG_PUB.Add;

2531:
2532: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2533: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2534: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: END', TRUE);
2535: FND_MSG_PUB.Add;
2536: END IF; */
2537:
2538:
2539: EXCEPTION

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

2540: WHEN OTHERS THEN
2541:
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543:
2544: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2545: THEN
2546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'get_source_code');
2547: END IF;
2548: End get_source_code;

Line 2546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'get_source_code');

2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543:
2544: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2545: THEN
2546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'get_source_code');
2547: END IF;
2548: End get_source_code;
2549:
2550: PROCEDURE generate_target_group_list_old

Line 2693: FND_MSG_PUB.initialize;

2689: END IF;
2690:
2691: -- Initialize message list IF p_init_msg_list is set to TRUE.
2692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2693: FND_MSG_PUB.initialize;
2694: END IF;
2695:
2696: get_Source_Code(
2697: x_return_status => x_return_status,

Line 2945: FND_MSG_PUB.Add;

2941: -- --------------------------------------------------------
2942: IF (AMS_DEBUG_HIGH_ON) THEN
2943: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2944: FND_MESSAGE.Set_Token('TEXT', 'AMS_LISTGENERATION_PKG.cerate_list: Start', TRUE);
2945: FND_MSG_PUB.Add;
2946: END IF;
2947: write_to_act_log(p_msg_data => 'Target Group available ' ,
2948: p_arc_log_used_by => 'LIST',
2949: p_log_used_by_id => g_list_header_id,

Line 2964: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2960: END IF;
2961:
2962: -- Success Message
2963: -- MMSG
2964: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2965: THEN
2966: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2967: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2968: FND_MSG_PUB.Add;

Line 2968: FND_MSG_PUB.Add;

2964: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2965: THEN
2966: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2967: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2968: FND_MSG_PUB.Add;
2969: END IF;
2970:
2971: IF (AMS_DEBUG_HIGH_ON) THEN
2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

Line 2974: FND_MSG_PUB.Add;

2970:
2971: IF (AMS_DEBUG_HIGH_ON) THEN
2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2973: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2974: FND_MSG_PUB.Add;
2975: END IF;
2976: FND_MSG_PUB.count_and_get(
2977: p_encoded => FND_API.g_false,
2978: p_count => x_msg_count,

Line 2976: FND_MSG_PUB.count_and_get(

2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2973: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2974: FND_MSG_PUB.Add;
2975: END IF;
2976: FND_MSG_PUB.count_and_get(
2977: p_encoded => FND_API.g_false,
2978: p_count => x_msg_count,
2979: p_data => x_msg_data
2980: );

Line 2986: FND_MSG_PUB.Add;

2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2985: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2986: FND_MSG_PUB.Add;
2987: -- Check if reset of the status is required
2988: x_return_status := FND_API.G_RET_STS_ERROR ;
2989: FND_MSG_PUB.count_and_get(
2990: p_encoded => FND_API.g_false,

Line 2989: FND_MSG_PUB.count_and_get(

2985: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2986: FND_MSG_PUB.Add;
2987: -- Check if reset of the status is required
2988: x_return_status := FND_API.G_RET_STS_ERROR ;
2989: FND_MSG_PUB.count_and_get(
2990: p_encoded => FND_API.g_false,
2991: p_count => x_msg_count,
2992: p_data => x_msg_data);
2993:

Line 2997: FND_MSG_PUB.Add;

2993:
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2996: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2997: FND_MSG_PUB.Add;
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2999: FND_MSG_PUB.count_and_get(
3000: p_encoded => FND_API.g_false,
3001: p_count => x_msg_count,

Line 2999: FND_MSG_PUB.count_and_get(

2995: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2996: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2997: FND_MSG_PUB.Add;
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2999: FND_MSG_PUB.count_and_get(
3000: p_encoded => FND_API.g_false,
3001: p_count => x_msg_count,
3002: p_data => x_msg_data);
3003:

Line 3007: FND_MSG_PUB.Add;

3003:
3004: WHEN OTHERS THEN
3005: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3006: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3007: FND_MSG_PUB.Add;
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3009: FND_MSG_PUB.count_and_get(
3010: p_encoded => FND_API.g_false,
3011: p_count => x_msg_count,

Line 3009: FND_MSG_PUB.count_and_get(

3005: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3006: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3007: FND_MSG_PUB.Add;
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3009: FND_MSG_PUB.count_and_get(
3010: p_encoded => FND_API.g_false,
3011: p_count => x_msg_count,
3012: p_data => x_msg_data);
3013: END generate_target_group_list_old;

Line 3067: FND_MSG_PUB.initialize;

3063:
3064:
3065: -- Initialize message list IF p_init_msg_list is set to TRUE.
3066: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3067: FND_MSG_PUB.initialize;
3068: END IF;
3069:
3070:
3071: open c1;

Line 3080: FND_MSG_PUB.Add;

3076: FETCH c_status INTO l_status_code;
3077: CLOSE c_status ;
3078: IF l_status_code = 'GENERATING' THEN
3079: FND_MESSAGE.Set_Name('AMS','AMS_GENERATING');
3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: END IF;
3083:
3084:

Line 3117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3113: END IF;
3114:
3115: -- Success Message
3116: -- MMSG
3117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3118: THEN
3119: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
3120: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
3121: FND_MSG_PUB.Add;

Line 3121: FND_MSG_PUB.Add;

3117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3118: THEN
3119: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
3120: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
3121: FND_MSG_PUB.Add;
3122: END IF;
3123:
3124: /*
3125: IF (AMS_DEBUG_HIGH_ON) THEN

Line 3128: FND_MSG_PUB.Add;

3124: /*
3125: IF (AMS_DEBUG_HIGH_ON) THEN
3126: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3127: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
3128: FND_MSG_PUB.Add;
3129: END IF;
3130: */
3131: FND_MSG_PUB.count_and_get(
3132: p_encoded => FND_API.g_false,

Line 3131: FND_MSG_PUB.count_and_get(

3127: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
3128: FND_MSG_PUB.Add;
3129: END IF;
3130: */
3131: FND_MSG_PUB.count_and_get(
3132: p_encoded => FND_API.g_false,
3133: p_count => x_msg_count,
3134: p_data => x_msg_data
3135: );

Line 3140: --FND_MSG_PUB.Add;

3136: EXCEPTION
3137: WHEN FND_API.G_EXC_ERROR THEN
3138: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3139: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3140: --FND_MSG_PUB.Add;
3141: -- Check if reset of the status is required
3142: x_return_status := FND_API.G_RET_STS_ERROR ;
3143: FND_MSG_PUB.count_and_get(
3144: p_encoded => FND_API.g_false,

Line 3143: FND_MSG_PUB.count_and_get(

3139: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3140: --FND_MSG_PUB.Add;
3141: -- Check if reset of the status is required
3142: x_return_status := FND_API.G_RET_STS_ERROR ;
3143: FND_MSG_PUB.count_and_get(
3144: p_encoded => FND_API.g_false,
3145: p_count => x_msg_count,
3146: p_data => x_msg_data);
3147:

Line 3151: --FND_MSG_PUB.Add;

3147:
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3150: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3151: --FND_MSG_PUB.Add;
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: FND_MSG_PUB.count_and_get(
3154: p_encoded => FND_API.g_false,
3155: p_count => x_msg_count,

Line 3153: FND_MSG_PUB.count_and_get(

3149: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3150: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3151: --FND_MSG_PUB.Add;
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: FND_MSG_PUB.count_and_get(
3154: p_encoded => FND_API.g_false,
3155: p_count => x_msg_count,
3156: p_data => x_msg_data);
3157:

Line 3161: --FND_MSG_PUB.Add;

3157:
3158: WHEN OTHERS THEN
3159: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3160: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3161: --FND_MSG_PUB.Add;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: FND_MSG_PUB.count_and_get(
3164: p_encoded => FND_API.g_false,
3165: p_count => x_msg_count,

Line 3163: FND_MSG_PUB.count_and_get(

3159: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3160: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3161: --FND_MSG_PUB.Add;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: FND_MSG_PUB.count_and_get(
3164: p_encoded => FND_API.g_false,
3165: p_count => x_msg_count,
3166: p_data => x_msg_data);
3167:

Line 3600: FND_MSG_PUB.Add;

3596: x_counter => l_from_counter) ;
3597:
3598: if l_found = 'N' then
3599: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
3600: FND_MSG_PUB.Add;
3601: RAISE FND_API.G_EXC_ERROR;
3602: end if;
3603: write_to_act_log('Process_all_sql: FROM Position ->'|| l_from_position ||
3604: '<--FROM Counter ->' || l_from_counter ||

Line 3619: FND_MSG_PUB.Add;

3615: x_source_object_name => l_source_object_name,
3616: x_source_object_pk_field => l_source_object_pk_field);
3617: if l_found = 'N' then
3618: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
3619: FND_MSG_PUB.Add;
3620: RAISE FND_API.G_EXC_ERROR;
3621: end if;
3622: --write_to_act_log('Process_all_sql: Master Type->'|| l_master_type ||'<--' );
3623:

Line 3691: FND_MSG_PUB.count_and_get(

3687: EXCEPTION
3688: WHEN FND_API.G_EXC_ERROR THEN
3689: write_to_act_log('Error: AMS_ListGeneration_PKG.process_all_sql: ',null,null);
3690: x_return_status := FND_API.G_RET_STS_ERROR ;
3691: FND_MSG_PUB.count_and_get(
3692: p_encoded => FND_API.g_false,
3693: p_count => x_msg_count,
3694: p_data => x_msg_data
3695: );

Line 3700: FND_MSG_PUB.count_and_get(

3696:
3697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3698: write_to_act_log('Error: AMS_ListGeneration_PKG.process_all_sql: ',null,null);
3699: x_return_status := FND_API.G_RET_STS_ERROR ;
3700: FND_MSG_PUB.count_and_get(
3701: p_encoded => FND_API.g_false,
3702: p_count => x_msg_count,
3703: p_data => x_msg_data
3704: );

Line 3709: FND_MSG_PUB.count_and_get(

3705:
3706: WHEN OTHERS THEN
3707: write_to_act_log('Error: AMS_ListGeneration_PKG.process_all_sql:' ,null,null);
3708: x_return_status := FND_API.G_RET_STS_ERROR ;
3709: FND_MSG_PUB.count_and_get(
3710: p_encoded => FND_API.g_false,
3711: p_count => x_msg_count,
3712: p_data => x_msg_data
3713: );

Line 4083: --FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

4079: );
4080: UPDATE ams_list_headers_all SET query_template_id = l_query_temp_id
4081: WHERE list_header_id = l_list_header_id;
4082: --for i in 1 .. l_msg_count loop
4083: --FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
4084: --FND_API.G_FALSE,
4085: --l_msg_data,
4086: --l_msg_count);
4087: --end loop;

Line 4289: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

4285:
4286: if j = 1 then
4287: --bug 4623994
4288: /*for i in 1 .. l_msg_count loop
4289: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
4290: FND_API.G_FALSE,
4291: l_msg_data,
4292: l_msg_count);
4293: end loop;*/

Line 4326: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

4322: x_act_list_header_id => l_act_list_header_id
4323: ) ;
4324: --bug 4623994
4325: /*for i in 1 .. l_msg_count loop
4326: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
4327: FND_API.G_FALSE,
4328: l_msg_data,
4329: l_msg_count);
4330: end loop;*/

Line 4390: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

4386: RAISE FND_API.g_exc_unexpected_error;
4387: END IF;
4388: --bug 4623994
4389: /*for i in 1 .. l_msg_count loop
4390: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
4391: FND_API.G_FALSE,
4392: l_msg_data,
4393: l_msg_count);
4394: end loop;*/

Line 4412: FND_MSG_PUB.Count_And_Get (

4408: WHEN FND_API.G_EXC_ERROR THEN
4409: ROLLBACK TO copy_target_group_pvt;
4410: x_return_status := FND_API.G_RET_STS_ERROR;
4411: -- Standard call to get message count and if count=1, get the message
4412: FND_MSG_PUB.Count_And_Get (
4413: p_encoded => FND_API.G_FALSE,
4414: p_count => x_msg_count,
4415: p_data => x_msg_data
4416: );

Line 4422: FND_MSG_PUB.Count_And_Get (

4418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4419: ROLLBACK TO copy_target_group_pvt;
4420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4421: -- Standard call to get message count and if count=1, get the message
4422: FND_MSG_PUB.Count_And_Get (
4423: p_encoded => FND_API.G_FALSE,
4424: p_count => x_msg_count,
4425: p_data => x_msg_data
4426: );

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

4427:
4428: WHEN OTHERS THEN
4429: ROLLBACK TO copy_target_group_pvt;
4430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4431: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4432: THEN
4433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4434: END IF;
4435: -- Standard call to get message count and if count=1, get the message

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

4429: ROLLBACK TO copy_target_group_pvt;
4430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4431: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4432: THEN
4433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4434: END IF;
4435: -- Standard call to get message count and if count=1, get the message
4436: FND_MSG_PUB.Count_And_Get (
4437: p_encoded => FND_API.G_FALSE,

Line 4436: FND_MSG_PUB.Count_And_Get (

4432: THEN
4433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4434: END IF;
4435: -- Standard call to get message count and if count=1, get the message
4436: FND_MSG_PUB.Count_And_Get (
4437: p_encoded => FND_API.G_FALSE,
4438: p_count => x_msg_count,
4439: p_data => x_msg_data
4440: );

Line 4589: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);

4585: ) ;
4586:
4587: -------------VBCHANGE--------------------
4588: /* FOR i IN 1 .. l_msg_count LOOP
4589: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
4590: AMS_Utility_PVT.debug_message('(' || i || ') ' || l_msg_data);
4591: END LOOP;*/
4592:
4593: IF (AMS_DEBUG_HIGH_ON) THEN