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

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

84: -- 12-oct-2001 soagrawa Capitalizing the generated source code
85: -- 27-jun-2003 anchaudh added the extra columns to be inserted for triggers changes.
86: -- 29-May-2006 srivikri added column delivery_mode
87: --===================================================================
88: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
89: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
90: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
91:
92:

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

85: -- 27-jun-2003 anchaudh added the extra columns to be inserted for triggers changes.
86: -- 29-May-2006 srivikri added column delivery_mode
87: --===================================================================
88: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
89: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
90: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
91:
92:
93:

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

86: -- 29-May-2006 srivikri added column delivery_mode
87: --===================================================================
88: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
89: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
90: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
91:
92:
93:
94: PROCEDURE Create_Camp_Schedule(

Line 161: FND_MSG_PUB.initialize;

157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:
164: -- Debug Message
165: IF (AMS_DEBUG_HIGH_ON) THEN

Line 691: FND_MSG_PUB.Count_And_Get

687: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
688: END IF;
689:
690: -- Standard call to get message count and if count is 1, get message info.
691: FND_MSG_PUB.Count_And_Get
692: (p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695: EXCEPTION

Line 705: FND_MSG_PUB.Count_And_Get (

701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO CREATE_Camp_Schedule_PVT;
703: x_return_status := FND_API.G_RET_STS_ERROR;
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 715: FND_MSG_PUB.Count_And_Get (

711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO CREATE_Camp_Schedule_PVT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: -- Standard call to get message count and if count=1, get the message
715: FND_MSG_PUB.Count_And_Get (
716: p_encoded => FND_API.G_FALSE,
717: p_count => x_msg_count,
718: p_data => x_msg_data
719: );

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

720:
721: WHEN OTHERS THEN
722: ROLLBACK TO CREATE_Camp_Schedule_PVT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
727: END IF;
728: -- Standard call to get message count and if count=1, get the message

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

722: ROLLBACK TO CREATE_Camp_Schedule_PVT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
727: END IF;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,

Line 729: FND_MSG_PUB.Count_And_Get (

725: THEN
726: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
727: END IF;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );

Line 826: FND_MSG_PUB.initialize;

822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean( p_init_msg_list )
825: THEN
826: FND_MSG_PUB.initialize;
827: END IF;
828:
829: -- Debug Message
830: IF (AMS_DEBUG_HIGH_ON) THEN

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

846: OPEN c_get_Camp_Schedule(l_tar_schedule_rec.schedule_id);
847: FETCH c_get_Camp_Schedule INTO l_ref_schedule_rec ;
848:
849: If ( c_get_Camp_Schedule%NOTFOUND) THEN
850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
851: THEN
852: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
853: FND_MESSAGE.Set_Token ('INFO', 'Camp_Schedule', FALSE);
854: FND_MSG_PUB.Add;

Line 854: FND_MSG_PUB.Add;

850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
851: THEN
852: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
853: FND_MESSAGE.Set_Token ('INFO', 'Camp_Schedule', FALSE);
854: FND_MSG_PUB.Add;
855: END IF;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858: -- Debug Message

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

864:
865:
866: IF (l_tar_schedule_rec.object_version_number IS NULL OR
867: l_tar_schedule_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
871: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
872: FND_MSG_PUB.ADD;

Line 872: FND_MSG_PUB.ADD;

868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
871: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
872: FND_MSG_PUB.ADD;
873: END IF;
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876:

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

875: END IF;
876:
877: -- Check Whether record has been changed by someone else
878: IF (l_tar_schedule_rec.object_version_number <> l_ref_schedule_rec.object_version_number) Then
879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
880: THEN
881: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
882: FND_MESSAGE.Set_Token('INFO', 'Camp_Schedule', FALSE);
883: FND_MSG_PUB.ADD;

Line 883: FND_MSG_PUB.ADD;

879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
880: THEN
881: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
882: FND_MESSAGE.Set_Token('INFO', 'Camp_Schedule', FALSE);
883: FND_MSG_PUB.ADD;
884: END IF;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887:

Line 1395: FND_MSG_PUB.Count_And_Get

1391: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1392: END IF;
1393:
1394: -- Standard call to get message count and if count is 1, get message info.
1395: FND_MSG_PUB.Count_And_Get
1396: (p_count => x_msg_count,
1397: p_data => x_msg_data
1398: );
1399: EXCEPTION

Line 1409: FND_MSG_PUB.Count_And_Get (

1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: -- Standard call to get message count and if count=1, get the message
1409: FND_MSG_PUB.Count_And_Get (
1410: p_encoded => FND_API.G_FALSE,
1411: p_count => x_msg_count,
1412: p_data => x_msg_data
1413: );

Line 1419: FND_MSG_PUB.Count_And_Get (

1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );

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

1424:
1425: WHEN OTHERS THEN
1426: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1431: END IF;
1432: -- Standard call to get message count and if count=1, get the message

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

1426: ROLLBACK TO UPDATE_Camp_Schedule_PVT;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1431: END IF;
1432: -- Standard call to get message count and if count=1, get the message
1433: FND_MSG_PUB.Count_And_Get (
1434: p_encoded => FND_API.G_FALSE,

Line 1433: FND_MSG_PUB.Count_And_Get (

1429: THEN
1430: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1431: END IF;
1432: -- Standard call to get message count and if count=1, get the message
1433: FND_MSG_PUB.Count_And_Get (
1434: p_encoded => FND_API.G_FALSE,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data
1437: );

Line 1509: FND_MSG_PUB.initialize;

1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list )
1508: THEN
1509: FND_MSG_PUB.initialize;
1510: END IF;
1511:
1512: -- Debug Message
1513: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1590: FND_MSG_PUB.Count_And_Get

1586: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1587: END IF;
1588:
1589: -- Standard call to get message count and if count is 1, get message info.
1590: FND_MSG_PUB.Count_And_Get
1591: (p_count => x_msg_count,
1592: p_data => x_msg_data
1593: );
1594: EXCEPTION

Line 1604: FND_MSG_PUB.Count_And_Get (

1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data
1608: );

Line 1614: FND_MSG_PUB.Count_And_Get (

1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: -- Standard call to get message count and if count=1, get the message
1614: FND_MSG_PUB.Count_And_Get (
1615: p_encoded => FND_API.G_FALSE,
1616: p_count => x_msg_count,
1617: p_data => x_msg_data
1618: );

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

1619:
1620: WHEN OTHERS THEN
1621: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1626: END IF;
1627: -- Standard call to get message count and if count=1, get the message

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

1621: ROLLBACK TO DELETE_Camp_Schedule_PVT;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1626: END IF;
1627: -- Standard call to get message count and if count=1, get the message
1628: FND_MSG_PUB.Count_And_Get (
1629: p_encoded => FND_API.G_FALSE,

Line 1628: FND_MSG_PUB.Count_And_Get (

1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1626: END IF;
1627: -- Standard call to get message count and if count=1, get the message
1628: FND_MSG_PUB.Count_And_Get (
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data
1632: );

Line 1683: FND_MSG_PUB.initialize;

1679:
1680: -- Initialize message list if p_init_msg_list is set to TRUE.
1681: IF FND_API.to_Boolean( p_init_msg_list )
1682: THEN
1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1686: -- Standard call to check for call compatibility.
1687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1720: FND_MSG_PUB.count_and_get(

1716: END IF;
1717: CLOSE c_Camp_Schedule;
1718:
1719: -------------------- finish --------------------------
1720: FND_MSG_PUB.count_and_get(
1721: p_encoded => FND_API.g_false,
1722: p_count => x_msg_count,
1723: p_data => x_msg_data);
1724: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1738: FND_MSG_PUB.Count_And_Get (

1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: FND_MSG_PUB.Count_And_Get (
1739: p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );

Line 1748: FND_MSG_PUB.Count_And_Get (

1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: -- Standard call to get message count and if count=1, get the message
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data
1752: );

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

1753:
1754: WHEN OTHERS THEN
1755: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1758: THEN
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1760: END IF;
1761: -- Standard call to get message count and if count=1, get the message

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

1755: ROLLBACK TO LOCK_Camp_Schedule_PVT;
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1758: THEN
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1760: END IF;
1761: -- Standard call to get message count and if count=1, get the message
1762: FND_MSG_PUB.Count_And_Get (
1763: p_encoded => FND_API.G_FALSE,

Line 1762: FND_MSG_PUB.Count_And_Get (

1758: THEN
1759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1760: END IF;
1761: -- Standard call to get message count and if count=1, get the message
1762: FND_MSG_PUB.Count_And_Get (
1763: p_encoded => FND_API.G_FALSE,
1764: p_count => x_msg_count,
1765: p_data => x_msg_data
1766: );

Line 2935: FND_MSG_PUB.initialize;

2931:
2932: -- Initialize message list if p_init_msg_list is set to TRUE.
2933: IF FND_API.to_Boolean( p_init_msg_list )
2934: THEN
2935: FND_MSG_PUB.initialize;
2936: END IF;
2937:
2938: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2939: Check_schedule_Items(

Line 3023: FND_MSG_PUB.Count_And_Get

3019: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3020: END IF;
3021:
3022: -- Standard call to get message count and if count is 1, get message info.
3023: FND_MSG_PUB.Count_And_Get
3024: (p_count => x_msg_count,
3025: p_data => x_msg_data
3026: );
3027: EXCEPTION

Line 3037: FND_MSG_PUB.Count_And_Get (

3033: WHEN FND_API.G_EXC_ERROR THEN
3034: ROLLBACK TO VALIDATE_Camp_Schedule_;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: -- Standard call to get message count and if count=1, get the message
3037: FND_MSG_PUB.Count_And_Get (
3038: p_encoded => FND_API.G_FALSE,
3039: p_count => x_msg_count,
3040: p_data => x_msg_data
3041: );

Line 3047: FND_MSG_PUB.Count_And_Get (

3043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3044: ROLLBACK TO VALIDATE_Camp_Schedule_;
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: -- Standard call to get message count and if count=1, get the message
3047: FND_MSG_PUB.Count_And_Get (
3048: p_encoded => FND_API.G_FALSE,
3049: p_count => x_msg_count,
3050: p_data => x_msg_data
3051: );

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

3052:
3053: WHEN OTHERS THEN
3054: ROLLBACK TO VALIDATE_Camp_Schedule_;
3055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3056: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3059: END IF;
3060: -- Standard call to get message count and if count=1, get the message

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

3054: ROLLBACK TO VALIDATE_Camp_Schedule_;
3055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3056: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3059: END IF;
3060: -- Standard call to get message count and if count=1, get the message
3061: FND_MSG_PUB.Count_And_Get (
3062: p_encoded => FND_API.G_FALSE,

Line 3061: FND_MSG_PUB.Count_And_Get (

3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3059: END IF;
3060: -- Standard call to get message count and if count=1, get the message
3061: FND_MSG_PUB.Count_And_Get (
3062: p_encoded => FND_API.G_FALSE,
3063: p_count => x_msg_count,
3064: p_data => x_msg_data
3065: );

Line 3100: FND_MSG_PUB.initialize;

3096: BEGIN
3097: -- Initialize message list if p_init_msg_list is set to TRUE.
3098: IF FND_API.to_Boolean( p_init_msg_list )
3099: THEN
3100: FND_MSG_PUB.initialize;
3101: END IF;
3102:
3103: -- Initialize API return status to SUCCESS
3104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3176: -- FND_MSG_PUB.Count_And_Get

3172:
3173: -- Check the Schedule Uniqueness
3174:
3175: -- Standard call to get message count and if count is 1, get message info.
3176: -- FND_MSG_PUB.Count_And_Get
3177: -- (p_count => x_msg_count,
3178: -- p_data => x_msg_data
3179: -- );
3180: END Validate_schedule_Rec;

Line 3801: FND_MSG_PUB.initialize;

3797:
3798: -- Initialize message list if p_init_msg_list is set to TRUE.
3799: IF FND_API.to_Boolean( p_init_msg_list )
3800: THEN
3801: FND_MSG_PUB.initialize;
3802: END IF;
3803:
3804: -- Debug Message
3805: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4447: FND_MSG_PUB.Count_And_Get

4443: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4444: END IF;
4445:
4446: -- Standard call to get message count and if count is 1, get message info.
4447: FND_MSG_PUB.Count_And_Get
4448: (p_count => x_msg_count,
4449: p_data => x_msg_data
4450: );
4451:

Line 4458: FND_MSG_PUB.Count_And_Get (

4454: WHEN FND_API.G_EXC_ERROR THEN
4455: ROLLBACK TO COPY_Camp_Schedule_PVT;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457: -- Standard call to get message count and if count=1, get the message
4458: FND_MSG_PUB.Count_And_Get (
4459: p_encoded => FND_API.G_FALSE,
4460: p_count => x_msg_count,
4461: p_data => x_msg_data
4462: );

Line 4467: FND_MSG_PUB.Count_And_Get (

4463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4464: ROLLBACK TO COPY_Camp_Schedule_PVT;
4465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4466: -- Standard call to get message count and if count=1, get the message
4467: FND_MSG_PUB.Count_And_Get (
4468: p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data
4471: );

Line 4475: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4471: );
4472: WHEN OTHERS THEN
4473: ROLLBACK TO COPY_Camp_Schedule_PVT;
4474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4475: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4477: END IF;
4478: -- Standard call to get message count and if count=1, get the message
4479: FND_MSG_PUB.Count_And_Get (

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

4472: WHEN OTHERS THEN
4473: ROLLBACK TO COPY_Camp_Schedule_PVT;
4474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4475: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4477: END IF;
4478: -- Standard call to get message count and if count=1, get the message
4479: FND_MSG_PUB.Count_And_Get (
4480: p_encoded => FND_API.G_FALSE,

Line 4479: FND_MSG_PUB.Count_And_Get (

4475: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4477: END IF;
4478: -- Standard call to get message count and if count=1, get the message
4479: FND_MSG_PUB.Count_And_Get (
4480: p_encoded => FND_API.G_FALSE,
4481: p_count => x_msg_count,
4482: p_data => x_msg_data
4483: );