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_LISTHEADER_PVT dependencies on STANDARD

Line 344: IF p_listheader_rec.list_type = 'STANDARD' then

340: END IF;
341:
342: ----------------------- LIST SOURCE TYPE ------------------------
343: -- validate if list type is only std. -- for telesales requirement
344: IF p_listheader_rec.list_type = 'STANDARD' then
345: IF p_listheader_rec.list_source_type <> FND_API.g_miss_char
346: AND p_listheader_rec.list_source_type IS NOT NULL THEN
347: IF p_listheader_rec.list_source_type <> 'EMPLOYEE_LIST' then
348: open c_check_source_type(p_listheader_rec.list_source_type );

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

1030: l_default_listhd_rec list_header_rec_type;
1031: l_listheader_id number;
1032:
1033: BEGIN
1034: -- Standard call to check for call compatibility.
1035: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1036: p_api_version,
1037: l_api_name,
1038: G_PKG_NAME) THEN

Line 1122: -- Standard call to get message count AND IF count is 1, get message info.

1118: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1119: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: END', TRUE);
1120: FND_MSG_PUB.Add;
1121: END IF; */
1122: -- Standard call to get message count AND IF count is 1, get message info.
1123: FND_MSG_PUB.Count_AND_Get
1124: ( p_count => x_msg_count,
1125: p_data => x_msg_data,
1126: p_encoded => FND_API.G_FALSE

Line 1239: -- Standard Start of API savepoint

1235: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1236:
1237: BEGIN
1238:
1239: -- Standard Start of API savepoint
1240: SAVEPOINT Create_listheaders_PVT;
1241:
1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243: -- Standard call to check for call compatibility.

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

1239: -- Standard Start of API savepoint
1240: SAVEPOINT Create_listheaders_PVT;
1241:
1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243: -- Standard call to check for call compatibility.
1244: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1245: p_api_version,
1246: l_api_name,
1247: G_PKG_NAME) THEN

Line 1475: decode(l_listheader_rec.GENERATION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.GENERATION_TYPE,'STANDARD')) ,

1471: decode(l_listheader_rec.ARC_LIST_USED_BY ,FND_API.g_miss_char,'NONE',nvl(l_listheader_rec.ARC_LIST_USED_BY,'NONE')) ,
1472: decode(l_listheader_rec.LIST_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.LIST_TYPE) ,
1473: decode(l_listheader_rec.STATUS_CODE ,FND_API.g_miss_char,'DRAFT',nvl(l_listheader_rec.STATUS_CODE,'DRAFT')) ,
1474: decode(l_listheader_rec.STATUS_DATE ,FND_API.g_miss_date,sysdate,nvl(l_listheader_rec.STATUS_DATE,sysdate)) ,
1475: decode(l_listheader_rec.GENERATION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.GENERATION_TYPE,'STANDARD')) ,
1476: decode(l_listheader_rec.REPEAT_EXCLUDE_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.REPEAT_EXCLUDE_TYPE) ,
1477: decode(l_listheader_rec.ROW_SELECTION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.ROW_SELECTION_TYPE,'STANDARD')) ,
1478: decode(l_listheader_rec.OWNER_USER_ID ,FND_API.g_miss_num,null,l_listheader_rec.OWNER_USER_ID) ,
1479: decode(l_listheader_rec.ACCESS_LEVEL ,FND_API.g_miss_char,'USER',nvl(l_listheader_rec.ACCESS_LEVEL,'USER')) ,

Line 1477: decode(l_listheader_rec.ROW_SELECTION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.ROW_SELECTION_TYPE,'STANDARD')) ,

1473: decode(l_listheader_rec.STATUS_CODE ,FND_API.g_miss_char,'DRAFT',nvl(l_listheader_rec.STATUS_CODE,'DRAFT')) ,
1474: decode(l_listheader_rec.STATUS_DATE ,FND_API.g_miss_date,sysdate,nvl(l_listheader_rec.STATUS_DATE,sysdate)) ,
1475: decode(l_listheader_rec.GENERATION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.GENERATION_TYPE,'STANDARD')) ,
1476: decode(l_listheader_rec.REPEAT_EXCLUDE_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.REPEAT_EXCLUDE_TYPE) ,
1477: decode(l_listheader_rec.ROW_SELECTION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.ROW_SELECTION_TYPE,'STANDARD')) ,
1478: decode(l_listheader_rec.OWNER_USER_ID ,FND_API.g_miss_num,null,l_listheader_rec.OWNER_USER_ID) ,
1479: decode(l_listheader_rec.ACCESS_LEVEL ,FND_API.g_miss_char,'USER',nvl(l_listheader_rec.ACCESS_LEVEL,'USER')) ,
1480: decode(l_listheader_rec.ENABLE_LOG_FLAG ,FND_API.g_miss_char,'Y',nvl(l_listheader_rec.ENABLE_LOG_FLAG,'Y')) ,
1481: decode(l_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG ,FND_API.g_miss_char,'N',nvl(l_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG,'N')) ,

Line 1616: -- Standard check of p_commit.

1612:
1613: -- set OUT value
1614: x_listheader_id := l_listheader_rec.list_header_id;
1615:
1616: -- Standard check of p_commit.
1617: IF FND_API.To_Boolean ( p_commit ) THEN
1618: COMMIT WORK;
1619: END IF;
1620:

Line 1636: -- Standard call to get message count AND IF count is 1, get message info.

1632: FND_MSG_PUB.Add;
1633: END IF; */
1634:
1635:
1636: -- Standard call to get message count AND IF count is 1, get message info.
1637: FND_MSG_PUB.Count_AND_Get
1638: ( p_count => x_msg_count,
1639: p_data => x_msg_data,
1640: p_encoded => FND_API.G_FALSE

Line 1731: -- Standard Start of API savepoint

1727: and item_key like p_listheader_rec.list_header_id || '_%'
1728: and activity_status in ('ERROR','ACTIVE');
1729:
1730: BEGIN
1731: -- Standard Start of API savepoint
1732: SAVEPOINT Update_listheaders_PVT;
1733: -- Standard call to check for call compatibility.
1734: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1735: p_api_version,

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

1729:
1730: BEGIN
1731: -- Standard Start of API savepoint
1732: SAVEPOINT Update_listheaders_PVT;
1733: -- Standard call to check for call compatibility.
1734: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1735: p_api_version,
1736: l_api_name,
1737: G_PKG_NAME) THEN

Line 2077: -- Standard check of p_commit.

2073: END IF;
2074: --end added tdonohoe 03/02/2000
2075:
2076:
2077: -- Standard check of p_commit.
2078: IF FND_API.To_Boolean ( p_commit ) THEN
2079: COMMIT WORK;
2080: END IF;
2081:

Line 2095: -- Standard call to get message count AND IF count is 1, get message info.

2091: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: END', TRUE);
2092: FND_MSG_PUB.Add;
2093: END IF; */
2094:
2095: -- Standard call to get message count AND IF count is 1, get message info.
2096: FND_MSG_PUB.Count_AND_Get
2097: ( p_count => x_msg_count,
2098: p_data => x_msg_data,
2099: p_encoded => FND_API.G_FALSE

Line 2174: -- Standard Start of API savepoint

2170: l_list_header_id NUMBER := p_listheader_id;
2171: l_return_val VARCHAR2(1);
2172:
2173: BEGIN
2174: -- Standard Start of API savepoint
2175: SAVEPOINT Delete_listheader_PVT;
2176:
2177: -- Standard call to check for call compatibility.
2178: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2173: BEGIN
2174: -- Standard Start of API savepoint
2175: SAVEPOINT Delete_listheader_PVT;
2176:
2177: -- Standard call to check for call compatibility.
2178: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2179: p_api_version,
2180: l_api_name,
2181: G_PKG_NAME) THEN

Line 2233: -- Standard check of p_commit.

2229: DELETE FROM ams_list_headers_all
2230: WHERE list_header_id = l_list_header_id;
2231:
2232:
2233: -- Standard check of p_commit.
2234: IF FND_API.To_Boolean ( p_commit ) THEN
2235: COMMIT WORK;
2236: END IF;
2237:

Line 2253: -- Standard call to get message count AND IF count is 1, get message info.

2249: FND_MSG_PUB.Add;
2250: END IF;
2251:
2252:
2253: -- Standard call to get message count AND IF count is 1, get message info.
2254: FND_MSG_PUB.Count_AND_Get
2255: ( p_count => x_msg_count,
2256: p_data => x_msg_data,
2257: p_encoded => FND_API.G_FALSE

Line 3309: -- Standard Start of API savepoint

3305: l_trg_listheader_rec list_header_rec_type;
3306:
3307: BEGIN
3308:
3309: -- Standard Start of API savepoint
3310: SAVEPOINT Copy_Lists_PVT;
3311:
3312: x_return_status := FND_API.G_RET_STS_SUCCESS;
3313: -- Standard call to check for call compatibility.

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

3309: -- Standard Start of API savepoint
3310: SAVEPOINT Copy_Lists_PVT;
3311:
3312: x_return_status := FND_API.G_RET_STS_SUCCESS;
3313: -- Standard call to check for call compatibility.
3314: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3315: p_api_version,
3316: l_api_name,
3317: G_PKG_NAME) THEN

Line 3438: -- Standard check of p_commit.

3434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3435: END IF;
3436:
3437:
3438: -- Standard check of p_commit.
3439: IF FND_API.To_Boolean ( p_commit ) THEN
3440: COMMIT WORK;
3441: END IF;
3442:

Line 3458: -- Standard call to get message count AND IF count is 1, get message info.

3454: FND_MSG_PUB.Add;
3455: END IF; */
3456:
3457:
3458: -- Standard call to get message count AND IF count is 1, get message info.
3459: FND_MSG_PUB.Count_AND_Get
3460: ( p_count => x_msg_count,
3461: p_data => x_msg_data,
3462: p_encoded => FND_API.G_FALSE