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 AMS_LISTHEADER_PVT

Line 1: PACKAGE BODY AMS_ListHeader_PVT as

1: PACKAGE BODY AMS_ListHeader_PVT as
2: /* $Header: amsvlshb.pls 120.4.12020000.2 2012/12/11 08:25:38 sagpraka ship $ */
3: -- Start of Comments
4: --
5: -- NAME

Line 6: -- AMS_ListHeader_PVT

2: /* $Header: amsvlshb.pls 120.4.12020000.2 2012/12/11 08:25:38 sagpraka ship $ */
3: -- Start of Comments
4: --
5: -- NAME
6: -- AMS_ListHeader_PVT
7: --
8: -- PURPOSE
9: -- Private API for Oracle Marketing(AMS) List Headers
10: --

Line 41: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListHeader_PVT';

37: -- to tl tables, cue cards validation
38:
39: -- End of Comments
40:
41: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListHeader_PVT';
42: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlshb.pls';
43:
44: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
45: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 721: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: Start', TRUE);

717: BEGIN
718: -- Debug Message
719: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
720: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
721: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: Start', TRUE);
722: FND_MSG_PUB.Add;
723: END IF; */
724:
725:

Line 727: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Validate_List_Record: Start');

723: END IF; */
724:
725:
726: IF (AMS_DEBUG_HIGH_ON) THEN
727: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Validate_List_Record: Start');
728: END IF;
729:
730:
731: -- Initialize API return status to success

Line 839: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record', TRUE);

835:
836: -- Success Message
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
838: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
839: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record', TRUE);
840: FND_MSG_PUB.Add;
841: END IF;
842:
843:

Line 846: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: END', TRUE);

842:
843:
844: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
845: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
846: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: END', TRUE);
847: FND_MSG_PUB.Add;
848: END IF; */
849:
850: EXCEPTION

Line 1050: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: Start', TRUE);

1046:
1047: -- Debug Message
1048: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1049: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1050: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: Start', TRUE);
1051: FND_MSG_PUB.Add;
1052: END IF; */
1053:
1054: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1112: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader', TRUE);

1108: -- MMSG
1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1110: THEN
1111: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1112: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader', TRUE);
1113: FND_MSG_PUB.Add;
1114: END IF;
1115:
1116:

Line 1119: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: END', TRUE);

1115:
1116:
1117: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
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

Line 1760: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Start', TRUE);

1756: END IF;
1757: -- Debug Message
1758: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1759: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1760: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Start', TRUE);
1761: FND_MSG_PUB.Add;
1762: END IF; */
1763:
1764: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1806: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Done Timezone', TRUE);

1802:
1803: -- Debug Message
1804: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1805: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1806: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Done Timezone', TRUE);
1807: FND_MSG_PUB.Add;
1808: END IF; */
1809:
1810: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1834: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Item Level Validation', TRUE);

1830:
1831: -- Debug Message
1832: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1833: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1834: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Item Level Validation', TRUE);
1835: FND_MSG_PUB.Add;
1836: END IF; */
1837:
1838: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1860: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT - update ams_listheaders', TRUE);

1856:
1857: -- Perform the database operation
1858: /* ckapoor IF (AMS_DEBUG_LOW_ON) THEN
1859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1860: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT - update ams_listheaders', TRUE);
1861: FND_MSG_PUB.Add;
1862: END IF; */
1863:
1864: IF (AMS_DEBUG_LOW_ON) THEN

Line 2043: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);

2039: -- API message list. --
2040: ------------------------------------------------------------------
2041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2042: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2043: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2044: FND_MSG_PUB.Add;
2045: END IF;
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;

Line 2066: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);

2062: -- API message list. --
2063: ------------------------------------------------------------------
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2065: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2066: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2067: FND_MSG_PUB.Add;
2068: END IF;
2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2070: END IF;

Line 2098: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders', TRUE);

2094:
2095: -- Success Message
2096: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2097: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2098: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders', TRUE);
2099: FND_MSG_PUB.Add;
2100: END IF;
2101:
2102: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 2104: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: END', TRUE);

2100: END IF;
2101:
2102: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2103: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
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.

Line 2206: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders: Start', TRUE);

2202:
2203: -- Debug Message
2204: IF (AMS_DEBUG_HIGH_ON) THEN
2205: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2206: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders: Start', TRUE);
2207: FND_MSG_PUB.Add;
2208: END IF;
2209:
2210: -- Initialize API return status to success

Line 2254: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders', TRUE);

2250:
2251: -- Success Message
2252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2253: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2254: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders', TRUE);
2255: FND_MSG_PUB.Add;
2256: END IF;
2257:
2258:

Line 2261: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheader: END', TRUE);

2257:
2258:
2259: IF (AMS_DEBUG_HIGH_ON) THEN
2260: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2261: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheader: END', TRUE);
2262: FND_MSG_PUB.Add;
2263: END IF;
2264:
2265:

Line 3348: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Copy_List: Start');

3344: FND_MSG_PUB.Add;
3345: END IF; */
3346:
3347: IF (AMS_DEBUG_HIGH_ON) THEN
3348: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Copy_List: Start');
3349: END IF;
3350:
3351: -- Initialize API return status to success
3352: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3516: END AMS_listheader_PVT;

3512: );
3513:
3514: END Copy_List;
3515:
3516: END AMS_listheader_PVT;