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 1243: -- Standard Start of API savepoint

1239: l_org_id NUMBER;
1240:
1241: BEGIN
1242:
1243: -- Standard Start of API savepoint
1244: SAVEPOINT Create_listheaders_PVT;
1245: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1244: SAVEPOINT Create_listheaders_PVT;
1245: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;
1248: -- Standard call to check for call compatibility.
1249: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1250: p_api_version,
1251: l_api_name,
1252: G_PKG_NAME) THEN

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

1481: decode(l_listheader_rec.ARC_LIST_USED_BY ,FND_API.g_miss_char,'NONE',nvl(l_listheader_rec.ARC_LIST_USED_BY,'NONE')) ,
1482: decode(l_listheader_rec.LIST_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.LIST_TYPE) ,
1483: decode(l_listheader_rec.STATUS_CODE ,FND_API.g_miss_char,'DRAFT',nvl(l_listheader_rec.STATUS_CODE,'DRAFT')) ,
1484: decode(l_listheader_rec.STATUS_DATE ,FND_API.g_miss_date,sysdate,nvl(l_listheader_rec.STATUS_DATE,sysdate)) ,
1485: decode(l_listheader_rec.GENERATION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.GENERATION_TYPE,'STANDARD')) ,
1486: decode(l_listheader_rec.REPEAT_EXCLUDE_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.REPEAT_EXCLUDE_TYPE) ,
1487: decode(l_listheader_rec.ROW_SELECTION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.ROW_SELECTION_TYPE,'STANDARD')) ,
1488: decode(l_listheader_rec.OWNER_USER_ID ,FND_API.g_miss_num,null,l_listheader_rec.OWNER_USER_ID) ,
1489: decode(l_listheader_rec.ACCESS_LEVEL ,FND_API.g_miss_char,'USER',nvl(l_listheader_rec.ACCESS_LEVEL,'USER')) ,

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

1483: decode(l_listheader_rec.STATUS_CODE ,FND_API.g_miss_char,'DRAFT',nvl(l_listheader_rec.STATUS_CODE,'DRAFT')) ,
1484: decode(l_listheader_rec.STATUS_DATE ,FND_API.g_miss_date,sysdate,nvl(l_listheader_rec.STATUS_DATE,sysdate)) ,
1485: decode(l_listheader_rec.GENERATION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.GENERATION_TYPE,'STANDARD')) ,
1486: decode(l_listheader_rec.REPEAT_EXCLUDE_TYPE ,FND_API.g_miss_char,null,l_listheader_rec.REPEAT_EXCLUDE_TYPE) ,
1487: decode(l_listheader_rec.ROW_SELECTION_TYPE ,FND_API.g_miss_char,'STANDARD',nvl(l_listheader_rec.ROW_SELECTION_TYPE,'STANDARD')) ,
1488: decode(l_listheader_rec.OWNER_USER_ID ,FND_API.g_miss_num,null,l_listheader_rec.OWNER_USER_ID) ,
1489: decode(l_listheader_rec.ACCESS_LEVEL ,FND_API.g_miss_char,'USER',nvl(l_listheader_rec.ACCESS_LEVEL,'USER')) ,
1490: decode(l_listheader_rec.ENABLE_LOG_FLAG ,FND_API.g_miss_char,'Y',nvl(l_listheader_rec.ENABLE_LOG_FLAG,'Y')) ,
1491: decode(l_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG ,FND_API.g_miss_char,'N',nvl(l_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG,'N')) ,

Line 1629: -- Standard check of p_commit.

1625:
1626: -- set OUT value
1627: x_listheader_id := l_listheader_rec.list_header_id;
1628:
1629: -- Standard check of p_commit.
1630: IF FND_API.To_Boolean ( p_commit ) THEN
1631: COMMIT WORK;
1632: END IF;
1633:

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

1645: FND_MSG_PUB.Add;
1646: END IF; */
1647:
1648:
1649: -- Standard call to get message count AND IF count is 1, get message info.
1650: FND_MSG_PUB.Count_AND_Get
1651: ( p_count => x_msg_count,
1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE

Line 1744: -- Standard Start of API savepoint

1740: and item_key like p_listheader_rec.list_header_id || '_%'
1741: and activity_status in ('ERROR','ACTIVE');
1742:
1743: BEGIN
1744: -- Standard Start of API savepoint
1745: SAVEPOINT Update_listheaders_PVT;
1746: -- Standard call to check for call compatibility.
1747: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1748: p_api_version,

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

1742:
1743: BEGIN
1744: -- Standard Start of API savepoint
1745: SAVEPOINT Update_listheaders_PVT;
1746: -- Standard call to check for call compatibility.
1747: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1748: p_api_version,
1749: l_api_name,
1750: G_PKG_NAME) THEN

Line 2090: -- Standard check of p_commit.

2086: END IF;
2087: --end added tdonohoe 03/02/2000
2088:
2089:
2090: -- Standard check of p_commit.
2091: IF FND_API.To_Boolean ( p_commit ) THEN
2092: COMMIT WORK;
2093: END IF;
2094:

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

2104: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: END', TRUE);
2105: FND_MSG_PUB.Add;
2106: END IF; */
2107:
2108: -- Standard call to get message count AND IF count is 1, get message info.
2109: FND_MSG_PUB.Count_AND_Get
2110: ( p_count => x_msg_count,
2111: p_data => x_msg_data,
2112: p_encoded => FND_API.G_FALSE

Line 2187: -- Standard Start of API savepoint

2183: l_list_header_id NUMBER := p_listheader_id;
2184: l_return_val VARCHAR2(1);
2185:
2186: BEGIN
2187: -- Standard Start of API savepoint
2188: SAVEPOINT Delete_listheader_PVT;
2189:
2190: -- Standard call to check for call compatibility.
2191: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

2186: BEGIN
2187: -- Standard Start of API savepoint
2188: SAVEPOINT Delete_listheader_PVT;
2189:
2190: -- Standard call to check for call compatibility.
2191: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2192: p_api_version,
2193: l_api_name,
2194: G_PKG_NAME) THEN

Line 2246: -- Standard check of p_commit.

2242: DELETE FROM ams_list_headers_all
2243: WHERE list_header_id = l_list_header_id;
2244:
2245:
2246: -- Standard check of p_commit.
2247: IF FND_API.To_Boolean ( p_commit ) THEN
2248: COMMIT WORK;
2249: END IF;
2250:

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

2262: FND_MSG_PUB.Add;
2263: END IF;
2264:
2265:
2266: -- Standard call to get message count AND IF count is 1, get message info.
2267: FND_MSG_PUB.Count_AND_Get
2268: ( p_count => x_msg_count,
2269: p_data => x_msg_data,
2270: p_encoded => FND_API.G_FALSE

Line 3322: -- Standard Start of API savepoint

3318: l_trg_listheader_rec list_header_rec_type;
3319:
3320: BEGIN
3321:
3322: -- Standard Start of API savepoint
3323: SAVEPOINT Copy_Lists_PVT;
3324:
3325: x_return_status := FND_API.G_RET_STS_SUCCESS;
3326: -- Standard call to check for call compatibility.

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

3322: -- Standard Start of API savepoint
3323: SAVEPOINT Copy_Lists_PVT;
3324:
3325: x_return_status := FND_API.G_RET_STS_SUCCESS;
3326: -- Standard call to check for call compatibility.
3327: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3328: p_api_version,
3329: l_api_name,
3330: G_PKG_NAME) THEN

Line 3451: -- Standard check of p_commit.

3447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3448: END IF;
3449:
3450:
3451: -- Standard check of p_commit.
3452: IF FND_API.To_Boolean ( p_commit ) THEN
3453: COMMIT WORK;
3454: END IF;
3455:

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

3467: FND_MSG_PUB.Add;
3468: END IF; */
3469:
3470:
3471: -- Standard call to get message count AND IF count is 1, get message info.
3472: FND_MSG_PUB.Count_AND_Get
3473: ( p_count => x_msg_count,
3474: p_data => x_msg_data,
3475: p_encoded => FND_API.G_FALSE