APPS.AMS_AGENDAS_PVT dependencies on FND_MSG_PUB

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

17:
18: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_Agendas_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(15):='amsvagnb.pls';
20:
21: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Rollup_StTime_EdTime (

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

18: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_Agendas_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(15):='amsvagnb.pls';
20:
21: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Rollup_StTime_EdTime (
26: p_agenda_rec IN agenda_rec_type,

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

19: G_FILE_NAME CONSTANT VARCHAR2(15):='amsvagnb.pls';
20:
21: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Rollup_StTime_EdTime (
26: p_agenda_rec IN agenda_rec_type,
27: x_return_status OUT NOCOPY VARCHAR2

Line 128: FND_MSG_PUB.initialize;

124:
125: -- Initialize message list IF p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 435: FND_MSG_PUB.Count_AND_Get

431: COMMIT WORK;
432: END IF;
433:
434: -- Standard call to get message count AND IF count is 1, get message info.
435: FND_MSG_PUB.Count_AND_Get
436: ( p_count => x_msg_count,
437: p_data => x_msg_data,
438: p_encoded => FND_API.G_FALSE
439: );

Line 446: FND_MSG_PUB.Count_AND_Get

442: WHEN FND_API.G_EXC_ERROR THEN
443: ROLLBACK TO Create_Agenda_PVT;
444: x_return_status := FND_API.G_RET_STS_ERROR ;
445:
446: FND_MSG_PUB.Count_AND_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE
450: );

Line 456: FND_MSG_PUB.Count_AND_Get

452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO Create_Agenda_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: FND_MSG_PUB.Count_AND_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data,
459: p_encoded => FND_API.G_FALSE
460: );

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

462: WHEN OTHERS THEN
463: ROLLBACK TO Create_Agenda_PVT;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465:
466: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
467: THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
469: END IF;
470:

Line 468: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465:
466: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
467: THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
469: END IF;
470:
471: FND_MSG_PUB.Count_AND_Get
472: ( p_count => x_msg_count,

Line 471: FND_MSG_PUB.Count_AND_Get

467: THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
469: END IF;
470:
471: FND_MSG_PUB.Count_AND_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE
475: );

Line 546: FND_MSG_PUB.initialize;

542: END IF;
543:
544: -- Initialize message list IF p_init_msg_list is set to TRUE.
545: IF FND_API.to_Boolean( p_init_msg_list ) THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

851:
852: /*Error, check the msg level and added an error message to the
853: API message list
854: */
855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
856: THEN -- MMSG
857: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
858: FND_MSG_PUB.Add;
859: END IF;

Line 858: FND_MSG_PUB.Add;

854: */
855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
856: THEN -- MMSG
857: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
858: FND_MSG_PUB.Add;
859: END IF;
860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
862:

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

870: WHERE agenda_id = l_agenda_rec.agenda_id
871: AND USERENV('LANG') IN (language, source_lang);
872:
873: IF (SQL%NOTFOUND) THEN
874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
876: FND_MSG_PUB.add;
877: END IF;
878: RAISE FND_API.g_exc_error;

Line 876: FND_MSG_PUB.add;

872:
873: IF (SQL%NOTFOUND) THEN
874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
876: FND_MSG_PUB.add;
877: END IF;
878: RAISE FND_API.g_exc_error;
879: END IF;
880:

Line 901: FND_MSG_PUB.Count_AND_Get

897: COMMIT WORK;
898: END IF;
899:
900: -- Standard call to get message count AND IF count is 1, get message info.
901: FND_MSG_PUB.Count_AND_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE
905: );

Line 911: FND_MSG_PUB.Count_AND_Get

907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO Update_Agenda_PVT;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE
915: );

Line 920: FND_MSG_PUB.Count_AND_Get

916:
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Update_Agenda_PVT;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => FND_API.G_FALSE
924: );

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

926: WHEN OTHERS THEN
927: ROLLBACK TO Update_Agenda_PVT;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
929:
930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
933: END IF;
934:

Line 932: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
929:
930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
933: END IF;
934:
935: FND_MSG_PUB.Count_AND_Get
936: ( p_count => x_msg_count,

Line 935: FND_MSG_PUB.Count_AND_Get

931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
933: END IF;
934:
935: FND_MSG_PUB.Count_AND_Get
936: ( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => FND_API.G_FALSE
939: );

Line 1024: FND_MSG_PUB.initialize;

1020:
1021: -- Initialize message list IF p_init_msg_list is set to TRUE.
1022: IF FND_API.to_Boolean( p_init_msg_list )
1023: THEN
1024: FND_MSG_PUB.initialize;
1025: END IF;
1026:
1027: -- Initialize API return status to success
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1042: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1038: CLOSE c_event_status;
1039:
1040: IF(l_count > 0)
1041: THEN
1042: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1043: THEN
1044: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
1045: Fnd_Msg_Pub.ADD;
1046: END IF;

Line 1045: Fnd_Msg_Pub.ADD;

1041: THEN
1042: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1043: THEN
1044: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
1045: Fnd_Msg_Pub.ADD;
1046: END IF;
1047: RAISE FND_API.g_exc_error;
1048: END IF;
1049:

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

1139: WHERE agenda_id = p_agenda_id
1140: AND object_version_number = p_object_version;
1141:
1142: IF (SQL%NOTFOUND) THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1146: FND_MSG_PUB.add;
1147: END IF;

Line 1146: FND_MSG_PUB.add;

1142: IF (SQL%NOTFOUND) THEN
1143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1144: THEN
1145: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: RAISE FND_API.g_exc_error;
1149: END IF;
1150:

Line 1177: FND_MSG_PUB.Count_AND_Get

1173: COMMIT WORK;
1174: END IF;
1175:
1176: -- Standard call to get message count AND IF count is 1, get message info.
1177: FND_MSG_PUB.Count_AND_Get
1178: ( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE
1181: );

Line 1189: FND_MSG_PUB.Count_AND_Get

1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO Delete_Agenda_PVT;
1187: x_return_status := FND_API.G_RET_STS_ERROR ;
1188:
1189: FND_MSG_PUB.Count_AND_Get
1190: ( p_count => x_msg_count,
1191: p_data => x_msg_data,
1192: p_encoded => FND_API.G_FALSE
1193: );

Line 1199: FND_MSG_PUB.Count_AND_Get

1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO Delete_Agenda_PVT;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1198:
1199: FND_MSG_PUB.Count_AND_Get
1200: ( p_count => x_msg_count,
1201: p_data => x_msg_data,
1202: p_encoded => FND_API.G_FALSE
1203: );

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

1205: WHEN OTHERS THEN
1206: ROLLBACK TO Delete_Agenda_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208:
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1212: END IF;
1213:

Line 1211: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208:
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1212: END IF;
1213:
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,

Line 1214: FND_MSG_PUB.Count_AND_Get

1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1212: END IF;
1213:
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE
1218: );

Line 1272: FND_MSG_PUB.initialize;

1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list )
1271: THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: -- Initialize API return status to success
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1283:
1284: /* Error, check the msg level and added an error message to the
1285: API message list
1286: */
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1288: THEN -- MMSG
1289: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1290: FND_MSG_PUB.Add;
1291: END IF;

Line 1290: FND_MSG_PUB.Add;

1286: */
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1288: THEN -- MMSG
1289: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1290: FND_MSG_PUB.Add;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: CLOSE c_agenda;

Line 1297: FND_MSG_PUB.Count_AND_Get

1293: END IF;
1294: CLOSE c_agenda;
1295:
1296: -- Standard call to get message count AND IF count is 1, get message info.
1297: FND_MSG_PUB.Count_AND_Get
1298: ( p_count => x_msg_count,
1299: p_data => x_msg_data,
1300: p_encoded => FND_API.G_FALSE
1301: );

Line 1305: FND_MSG_PUB.Count_AND_Get

1301: );
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: x_return_status := FND_API.G_RET_STS_ERROR ;
1305: FND_MSG_PUB.Count_AND_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data,
1308: p_encoded => FND_API.G_FALSE
1309: );

Line 1313: FND_MSG_PUB.Count_AND_Get

1309: );
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1313: FND_MSG_PUB.Count_AND_Get
1314: ( p_count => x_msg_count,
1315: p_data => x_msg_data,
1316: p_encoded => FND_API.G_FALSE
1317: );

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

1317: );
1318:
1319: /* WHEN AMS_Utility_PVT.agenda_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF; */
1325:

Line 1323: FND_MSG_PUB.add;

1319: /* WHEN AMS_Utility_PVT.agenda_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF; */
1325:
1326: FND_MSG_PUB.Count_AND_Get
1327: ( p_count => x_msg_count,

Line 1326: FND_MSG_PUB.Count_AND_Get

1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF; */
1325:
1326: FND_MSG_PUB.Count_AND_Get
1327: ( p_count => x_msg_count,
1328: p_data => x_msg_data,
1329: p_encoded => FND_API.G_FALSE
1330: );

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

1330: );
1331:
1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1334: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1335: THEN
1336: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1337: END IF;
1338:

Line 1336: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1334: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1335: THEN
1336: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1337: END IF;
1338:
1339: FND_MSG_PUB.Count_AND_Get
1340: ( p_count => x_msg_count,

Line 1339: FND_MSG_PUB.Count_AND_Get

1335: THEN
1336: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1337: END IF;
1338:
1339: FND_MSG_PUB.Count_AND_Get
1340: ( p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE
1343: );

Line 1390: FND_MSG_PUB.initialize;

1386: END IF;
1387:
1388: -- Initialize message list if p_init_msg_list is set to TRUE.
1389: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: -- Initialize API return status to success
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1445: FND_MSG_PUB.count_and_get(

1441:
1442: END IF;
1443:
1444: -------------------- finish --------------------------
1445: FND_MSG_PUB.count_and_get(
1446: p_encoded => FND_API.g_false,
1447: p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );

Line 1454: FND_MSG_PUB.Count_AND_Get

1450:
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: x_return_status := FND_API.G_RET_STS_ERROR ;
1454: FND_MSG_PUB.Count_AND_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data,
1457: p_encoded => FND_API.G_FALSE
1458: );

Line 1461: FND_MSG_PUB.Count_AND_Get

1457: p_encoded => FND_API.G_FALSE
1458: );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.Count_AND_Get
1462: ( p_count => x_msg_count,
1463: p_data => x_msg_data,
1464: p_encoded => FND_API.G_FALSE
1465: );

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

1464: p_encoded => FND_API.G_FALSE
1465: );
1466: WHEN OTHERS THEN
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1471: END IF;
1472: FND_MSG_PUB.Count_AND_Get

Line 1470: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

1466: WHEN OTHERS THEN
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1471: END IF;
1472: FND_MSG_PUB.Count_AND_Get
1473: ( p_count => x_msg_count,
1474: p_data => x_msg_data,

Line 1472: FND_MSG_PUB.Count_AND_Get

1468: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1471: END IF;
1472: FND_MSG_PUB.Count_AND_Get
1473: ( p_count => x_msg_count,
1474: p_data => x_msg_data,
1475: p_encoded => FND_API.G_FALSE
1476: );

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

1494: x_return_status := FND_API.g_ret_sts_success;
1495:
1496: ------------------------ application_id --------------------------
1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;

Line 1500: FND_MSG_PUB.add;

1496: ------------------------ application_id --------------------------
1497: IF (p_agenda_rec.application_id IS NULL OR p_agenda_rec.application_id = FND_API.g_miss_num) THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;
1504: END IF;

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

1503: RETURN;
1504: END IF;
1505: ------------------------ parent_id--------------------------
1506: IF (p_agenda_rec.parent_id IS NULL OR p_agenda_rec.parent_id = FND_API.g_miss_num) THEN
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1508: IF (p_agenda_rec.agenda_type = 'TRACK')
1509: THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');
1511: -- ELSIF(p_agenda_rec.agenda_type = 'SESSION')

Line 1514: FND_MSG_PUB.add;

1510: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');
1511: -- ELSIF(p_agenda_rec.agenda_type = 'SESSION')
1512: -- FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_ID');
1513: END IF;
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;

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

1518: END IF;
1519:
1520: ------------------------ parent_type--------------------------
1521: IF (p_agenda_rec.parent_type IS NULL OR p_agenda_rec.parent_type = FND_API.g_miss_char) THEN
1522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1523: IF (p_agenda_rec.agenda_type = 'TRACK')
1524: THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');
1526: ELSIF(p_agenda_rec.agenda_type = 'SESSION')THEN

Line 1529: FND_MSG_PUB.add;

1525: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_TYPE');
1526: ELSIF(p_agenda_rec.agenda_type = 'SESSION')THEN
1527: FND_MESSAGE.set_name('AMS', 'AMS_NO_TRACK_TYPE');
1528: END IF;
1529: FND_MSG_PUB.add;
1530: END IF;
1531: x_return_status := FND_API.g_ret_sts_error;
1532: RETURN;
1533: END IF;

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

1533: END IF;
1534:
1535: ------------------------ agenda_type--------------------------
1536: IF (p_agenda_rec.agenda_type IS NULL OR p_agenda_rec.agenda_type = FND_API.g_miss_char) THEN
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: x_return_status := FND_API.g_ret_sts_error;

Line 1539: FND_MSG_PUB.add;

1535: ------------------------ agenda_type--------------------------
1536: IF (p_agenda_rec.agenda_type IS NULL OR p_agenda_rec.agenda_type = FND_API.g_miss_char) THEN
1537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1538: FND_MESSAGE.set_name('AMS', 'AMS_NO_AGENDA_TYPE');
1539: FND_MSG_PUB.add;
1540: END IF;
1541: x_return_status := FND_API.g_ret_sts_error;
1542: RETURN;
1543: END IF;

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

1581: 'ams_agendas_v',
1582: 'agenda_id = ' || p_agenda_rec.agenda_id
1583: ) = FND_API.g_false
1584: THEN
1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
1587: FND_MSG_PUB.add;
1588: END IF;
1589: x_return_status := FND_API.g_ret_sts_error;

Line 1587: FND_MSG_PUB.add;

1583: ) = FND_API.g_false
1584: THEN
1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1586: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
1587: FND_MSG_PUB.add;
1588: END IF;
1589: x_return_status := FND_API.g_ret_sts_error;
1590: RETURN;
1591: END IF;

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

1600: OPEN c_track_name;
1601: fetch c_track_name into l_dummy;
1602: close c_track_name;
1603: IF l_dummy = 1 THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1606: FND_MSG_PUB.add;
1607: END IF;
1608: x_return_status := FND_API.g_ret_sts_error;

Line 1606: FND_MSG_PUB.add;

1602: close c_track_name;
1603: IF l_dummy = 1 THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1606: FND_MSG_PUB.add;
1607: END IF;
1608: x_return_status := FND_API.g_ret_sts_error;
1609: RETURN;
1610: END IF;

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

1642: 'application_id',
1643: p_agenda_rec.application_id
1644: ) = FND_API.g_false
1645: THEN
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1647: THEN
1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1649: FND_MSG_PUB.add;
1650: END IF;

Line 1649: FND_MSG_PUB.add;

1645: THEN
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1647: THEN
1648: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1649: FND_MSG_PUB.add;
1650: END IF;
1651: x_return_status := FND_API.g_ret_sts_error;
1652: RETURN;
1653: END IF;

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

1664: 'event_offer_id',
1665: p_agenda_rec.parent_id
1666: ) = FND_API.g_false
1667: THEN
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1669: THEN
1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1671: FND_MSG_PUB.add;
1672: END IF;

Line 1671: FND_MSG_PUB.add;

1667: THEN
1668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1669: THEN
1670: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1671: FND_MSG_PUB.add;
1672: END IF;
1673: x_return_status := FND_API.g_ret_sts_error;
1674: RETURN;
1675: END IF;

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

1683: 'agenda_id',
1684: p_agenda_rec.parent_id
1685: ) = FND_API.g_false
1686: THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1690: FND_MSG_PUB.add;
1691: END IF;

Line 1690: FND_MSG_PUB.add;

1686: THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: x_return_status := FND_API.g_ret_sts_error;
1693: RETURN;
1694: END IF;

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

1704: 'upgrade_tz_id',
1705: p_agenda_rec.timezone_id
1706: ) = FND_API.g_false
1707: THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
1711: FND_MSG_PUB.add;
1712: END IF;

Line 1711: FND_MSG_PUB.add;

1707: THEN
1708: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1709: THEN
1710: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
1711: FND_MSG_PUB.add;
1712: END IF;
1713: x_return_status := FND_API.g_ret_sts_error;
1714: RETURN;
1715: END IF;

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

1723: 'venue_id',
1724: p_agenda_rec.room_id
1725: ) = FND_API.g_false
1726: THEN
1727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1728: THEN
1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');
1730: FND_MSG_PUB.add;
1731: END IF;

Line 1730: FND_MSG_PUB.add;

1726: THEN
1727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1728: THEN
1729: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');
1730: FND_MSG_PUB.add;
1731: END IF;
1732: x_return_status := FND_API.g_ret_sts_error;
1733: RETURN;
1734: END IF;

Line 1749: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1745: ,p_pk_name => l_pk_name
1746: ,p_pk_value => l_pk_value
1747: ) = FND_API.G_FALSE
1748: THEN
1749: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1752: FND_MSG_PUB.add;
1753: END IF;

Line 1752: FND_MSG_PUB.add;

1748: THEN
1749: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1752: FND_MSG_PUB.add;
1753: END IF;
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: -- If any errors happen abort API/Procedure.
1756: RETURN;

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

1784: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1785: p_lookup_code => p_agenda_rec.agenda_type
1786: ) = FND_API.g_false
1787: THEN
1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1789: THEN
1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');
1791: FND_MSG_PUB.add;
1792: END IF;

Line 1791: FND_MSG_PUB.add;

1787: THEN
1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1789: THEN
1790: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');
1791: FND_MSG_PUB.add;
1792: END IF;
1793: x_return_status := FND_API.g_ret_sts_error;
1794: RETURN;
1795: END IF;

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

1820: AND p_agenda_rec.active_flag IS NOT NULL
1821: THEN
1822: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.active_flag) = FND_API.g_false
1823: THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1825: THEN
1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');
1827: FND_MSG_PUB.add;
1828: END IF;

Line 1827: FND_MSG_PUB.add;

1823: THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1825: THEN
1826: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');
1827: FND_MSG_PUB.add;
1828: END IF;
1829: x_return_status := FND_API.g_ret_sts_error;
1830: RETURN;
1831: END IF;

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

1836: AND p_agenda_rec.default_track_flag IS NOT NULL
1837: THEN
1838: IF AMS_Utility_PVT.is_Y_or_N(p_agenda_rec.default_track_flag) = FND_API.g_false
1839: THEN
1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1841: THEN
1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');
1843: FND_MSG_PUB.add;
1844: END IF;

Line 1843: FND_MSG_PUB.add;

1839: THEN
1840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1841: THEN
1842: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TRACK_FLAG');
1843: FND_MSG_PUB.add;
1844: END IF;
1845: x_return_status := FND_API.g_ret_sts_error;
1846: RETURN;
1847: END IF;

Line 1954: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1950: close c_get_resource_dates;
1951: if (p_agenda_rec.START_DATE_TIME > l_start_date
1952: OR p_agenda_rec.END_DATE_TIME < l_end_date)
1953: THEN
1954: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1955: THEN
1956: Fnd_Message.set_name('AMS', 'AMS_EVT_RES_DATE_NOT_FIT_IN');
1957: Fnd_Msg_Pub.ADD;
1958: END IF;

Line 1957: Fnd_Msg_Pub.ADD;

1953: THEN
1954: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1955: THEN
1956: Fnd_Message.set_name('AMS', 'AMS_EVT_RES_DATE_NOT_FIT_IN');
1957: Fnd_Msg_Pub.ADD;
1958: END IF;
1959: RAISE FND_API.g_exc_error;
1960: END IF;
1961: END IF; */

Line 2049: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2045: CLOSE c_parent_status;
2046:
2047: IF(l_count > 0)
2048: THEN
2049: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2050: THEN
2051: IF p_agenda_rec.agenda_type = 'SESSION'
2052: THEN
2053: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');

Line 2054: Fnd_Msg_Pub.ADD;

2050: THEN
2051: IF p_agenda_rec.agenda_type = 'SESSION'
2052: THEN
2053: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2054: Fnd_Msg_Pub.ADD;
2055: ELSIF p_agenda_rec.agenda_type = 'TRACK'
2056: THEN
2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');
2058: Fnd_Msg_Pub.ADD;

Line 2058: Fnd_Msg_Pub.ADD;

2054: Fnd_Msg_Pub.ADD;
2055: ELSIF p_agenda_rec.agenda_type = 'TRACK'
2056: THEN
2057: Fnd_Message.set_name('AMS', 'AMS_NO_TRACK');
2058: Fnd_Msg_Pub.ADD;
2059: END IF;
2060: END IF;
2061: RAISE FND_API.g_exc_error;
2062: END IF;

Line 2071: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2067: CLOSE c_event_status;
2068:
2069: IF(l_count > 0)
2070: THEN
2071: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2072: THEN
2073: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2074: Fnd_Msg_Pub.ADD;
2075: END IF;

Line 2074: Fnd_Msg_Pub.ADD;

2070: THEN
2071: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2072: THEN
2073: Fnd_Message.set_name('AMS', 'AMS_NO_SESSION');
2074: Fnd_Msg_Pub.ADD;
2075: END IF;
2076: RAISE FND_API.g_exc_error;
2077: END IF;
2078: END IF;

Line 2086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2082:
2083: IF(p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
2084: THEN
2085: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The End time is lesser than Start time'); END IF;
2086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2087: THEN
2088: Fnd_Message.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
2089: Fnd_Msg_Pub.ADD;
2090: END IF;

Line 2089: Fnd_Msg_Pub.ADD;

2085: -- IF (AMS_DEBUG_HIGH_ON) THEN Ams_Utility_Pvt.debug_message('The End time is lesser than Start time'); END IF;
2086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2087: THEN
2088: Fnd_Message.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
2089: Fnd_Msg_Pub.ADD;
2090: END IF;
2091: RAISE FND_API.g_exc_error;
2092: END IF; -- (p_agenda_rec.start_date_time > p_agenda_rec.end_date_time)
2093:

Line 2204: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2200: IF (AMS_DEBUG_HIGH_ON) THEN
2201:
2202: Ams_Utility_Pvt.debug_message('Came to check with event dates');
2203: END IF;
2204: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2205: THEN
2206: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_DATE');
2207: Fnd_Msg_Pub.ADD;
2208: END IF;

Line 2207: Fnd_Msg_Pub.ADD;

2203: END IF;
2204: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2205: THEN
2206: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_DATE');
2207: Fnd_Msg_Pub.ADD;
2208: END IF;
2209: RAISE FND_API.g_exc_error;
2210: END IF; -- end of start_date_time < l_event_start_date_time
2211:

Line 2220: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2216: IF (AMS_DEBUG_HIGH_ON) THEN
2217:
2218: Ams_Utility_Pvt.debug_message('Came to check with event start time');
2219: END IF;
2220: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2221: THEN
2222: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_TIME');
2223: Fnd_Msg_Pub.ADD;
2224: END IF;

Line 2223: Fnd_Msg_Pub.ADD;

2219: END IF;
2220: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2221: THEN
2222: Fnd_Message.set_name('AMS', 'AMS_SESSION_LS_EVENT_TIME');
2223: Fnd_Msg_Pub.ADD;
2224: END IF;
2225: RAISE FND_API.g_exc_error;
2226: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))
2227: END IF;

Line 2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2233: IF (AMS_DEBUG_HIGH_ON) THEN
2234:
2235: Ams_Utility_Pvt.debug_message('Came to check with event end time');
2236: END IF;
2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2238: THEN
2239: Fnd_Message.set_name('AMS', 'AMS_SESSION_GT_EVENT_TIME');
2240: Fnd_Msg_Pub.ADD;
2241: END IF;

Line 2240: Fnd_Msg_Pub.ADD;

2236: END IF;
2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2238: THEN
2239: Fnd_Message.set_name('AMS', 'AMS_SESSION_GT_EVENT_TIME');
2240: Fnd_Msg_Pub.ADD;
2241: END IF;
2242: RAISE FND_API.g_exc_error;
2243: END IF; --IF( to_date(to_char(p_agenda_rec.start_date_time,'HH24:MI'))
2244: END IF;

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

2372: FETCH c_agenda INTO l_agenda_rec;
2373: IF c_agenda%NOTFOUND THEN
2374: CLOSE c_agenda;
2375:
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE FND_API.g_exc_error;

Line 2378: FND_MSG_PUB.add;

2374: CLOSE c_agenda;
2375:
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE FND_API.g_exc_error;
2381: END IF;
2382: