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 STANDARD

Line 146: -- Standard Start of API savepoint

142: l_event_offer_rec AMS_EventOffer_PVT.evo_rec_type;
143:
144:
145: BEGIN
146: -- Standard Start of API savepoint
147: SAVEPOINT CREATE_Camp_Schedule_PVT;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 149: -- Standard call to check for call compatibility.

145: BEGIN
146: -- Standard Start of API savepoint
147: SAVEPOINT CREATE_Camp_Schedule_PVT;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
151: p_api_version_number,
152: l_api_name,
153: G_PKG_NAME)

Line 678: -- Standard check for p_commit

674: --
675: -- End of API body
676: --
677:
678: -- Standard check for p_commit
679: IF FND_API.to_Boolean( p_commit )
680: THEN
681: COMMIT WORK;
682: END IF;

Line 690: -- Standard call to get message count and if count is 1, get message info.

686:
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: );

Line 704: -- Standard call to get message count and if count=1, get the message

700:
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

Line 714: -- Standard call to get message count and if count=1, get the message

710:
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

Line 728: -- Standard call to get message count and if count=1, get the message

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,
731: p_count => x_msg_count,
732: p_data => x_msg_data

Line 811: -- Standard Start of API savepoint

807: l_change_indicator_array JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
808:
809:
810: BEGIN
811: -- Standard Start of API savepoint
812: SAVEPOINT UPDATE_Camp_Schedule_PVT;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 814: -- Standard call to check for call compatibility.

810: BEGIN
811: -- Standard Start of API savepoint
812: SAVEPOINT UPDATE_Camp_Schedule_PVT;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
816: p_api_version_number,
817: l_api_name,
818: G_PKG_NAME)

Line 1381: -- Standard check for p_commit

1377: -- End of API body.
1378: --
1379:
1380:
1381: -- Standard check for p_commit
1382: IF FND_API.to_Boolean( p_commit )
1383: THEN
1384: COMMIT WORK;
1385: END IF;

Line 1394: -- Standard call to get message count and if count is 1, get message info.

1390:
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: );

Line 1408: -- Standard call to get message count and if count=1, get the message

1404:
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

Line 1418: -- Standard call to get message count and if count=1, get the message

1414:
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

Line 1432: -- Standard call to get message count and if count=1, get the message

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,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data

Line 1494: -- Standard Start of API savepoint

1490: AND active_flag = 'Y' ;
1491:
1492:
1493: BEGIN
1494: -- Standard Start of API savepoint
1495: SAVEPOINT DELETE_Camp_Schedule_PVT;
1496:
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1497: -- Standard call to check for call compatibility.

1493: BEGIN
1494: -- Standard Start of API savepoint
1495: SAVEPOINT DELETE_Camp_Schedule_PVT;
1496:
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1499: p_api_version_number,
1500: l_api_name,
1501: G_PKG_NAME)

Line 1576: -- Standard check for p_commit

1572: --
1573: -- End of API body
1574: --
1575:
1576: -- Standard check for p_commit
1577: IF FND_API.to_Boolean(p_commit)
1578: THEN
1579: COMMIT WORK;
1580: END IF;

Line 1589: -- Standard call to get message count and if count is 1, get message info.

1585:
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: );

Line 1603: -- Standard call to get message count and if count=1, get the message

1599:
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

Line 1613: -- Standard call to get message count and if count=1, get the message

1609:
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

Line 1627: -- Standard call to get message count and if count=1, get the message

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,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data

Line 1686: -- Standard call to check for call compatibility.

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,
1688: p_api_version_number,
1689: l_api_name,
1690: G_PKG_NAME)

Line 1737: -- Standard call to get message count and if count=1, get the message

1733:
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

Line 1747: -- Standard call to get message count and if count=1, get the message

1743:
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

Line 1761: -- Standard call to get message count and if count=1, get the message

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,
1764: p_count => x_msg_count,
1765: p_data => x_msg_data

Line 2920: -- Standard Start of API savepoint

2916: l_object_version_number NUMBER;
2917: l_schedule_rec AMS_Camp_Schedule_PVT.schedule_rec_type := p_schedule_rec ;
2918:
2919: BEGIN
2920: -- Standard Start of API savepoint
2921: SAVEPOINT VALIDATE_Camp_Schedule_;
2922:
2923: -- Standard call to check for call compatibility.
2924: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2923: -- Standard call to check for call compatibility.

2919: BEGIN
2920: -- Standard Start of API savepoint
2921: SAVEPOINT VALIDATE_Camp_Schedule_;
2922:
2923: -- Standard call to check for call compatibility.
2924: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2925: p_api_version_number,
2926: l_api_name,
2927: G_PKG_NAME)

Line 3022: -- Standard call to get message count and if count is 1, get message info.

3018:
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: );

Line 3036: -- Standard call to get message count and if count=1, get the message

3032:
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

Line 3046: -- Standard call to get message count and if count=1, get the message

3042:
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

Line 3060: -- Standard call to get message count and if count=1, get the message

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,
3063: p_count => x_msg_count,
3064: p_data => x_msg_data

Line 3175: -- Standard call to get message count and if count is 1, get message info.

3171: --end : triggers related validations
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: -- );

Line 3786: -- Standard Start of API savepoint

3782: l_errmsg VARCHAR2(4000);
3783:
3784: BEGIN
3785:
3786: -- Standard Start of API savepoint
3787: SAVEPOINT COPY_Camp_Schedule_PVT;
3788:
3789: -- Standard call to check for call compatibility.
3790: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3789: -- Standard call to check for call compatibility.

3785:
3786: -- Standard Start of API savepoint
3787: SAVEPOINT COPY_Camp_Schedule_PVT;
3788:
3789: -- Standard call to check for call compatibility.
3790: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3791: p_api_version,
3792: l_api_name,
3793: G_PKG_NAME)

Line 4446: -- Standard call to get message count and if count is 1, get message info.

4442:
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: );

Line 4457: -- Standard call to get message count and if count=1, get the message

4453: EXCEPTION
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

Line 4466: -- Standard call to get message count and if count=1, get the message

4462: );
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

Line 4478: -- Standard call to get message count and if count=1, get the message

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,
4481: p_count => x_msg_count,
4482: p_data => x_msg_data