DBA Data[Home] [Help]

APPS.AMS_LISTACTION_PVT dependencies on AMS_LISTACTION_PVT

Line 1: PACKAGE BODY AMS_ListAction_PVT as

1: PACKAGE BODY AMS_ListAction_PVT as
2: /* $Header: amsvlsab.pls 120.3 2006/04/28 03:59:39 bmuthukr ship $ */
3: ------------------------------------------------------------------
4: -- Copyright (c) 1999 Oracle Corporation --
5: -- Redwood Shores, California, USA --

Line 11: -- AMS_ListAction_PVT

7: ------------------------------------------------------------------
8: -- Start of Comments
9: --
10: -- PACKAGE
11: -- AMS_ListAction_PVT
12:
13: -- Procedures:
14:
15: -- Create_ListAction

Line 39: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListAction_PVT';

35: -- 14-Oct-2002 nyostos Added callout to Model/Score code to INVALIDATE
36: -- Model/Scoring Run when list select actions records
37: -- are added, deleted or updated.
38:
39: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListAction_PVT';
40: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlsab.pls';
41:
42: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
43:

Line 1041: FND_MESSAGE.Set_Token('ROW','AMS_ListAction_PVT.Create_ListAction: Start', TRUE);

1037: -- Debug Message
1038: /*ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1039: THEN
1040: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1041: FND_MESSAGE.Set_Token('ROW','AMS_ListAction_PVT.Create_ListAction: Start', TRUE);
1042: FND_MSG_PUB.Add;
1043: END IF; */
1044:
1045: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1183: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Create_ListAction', TRUE);

1179: -- MMSG
1180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1181: THEN
1182: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1183: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Create_ListAction', TRUE);
1184: FND_MSG_PUB.Add;
1185: END IF;
1186:
1187: /*ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

Line 1190: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Create_ListAction: END', TRUE);

1186:
1187: /*ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1188: THEN
1189: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1190: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Create_ListAction: END', TRUE);
1191: FND_MSG_PUB.Add;
1192: END IF; */
1193:
1194:

Line 1315: FND_MESSAGE.Set_Token('ROW','AMS_ListAction_PVT.Update_ListAction: Start', TRUE);

1311: -- Debug Message
1312: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1313: THEN
1314: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1315: FND_MESSAGE.Set_Token('ROW','AMS_ListAction_PVT.Update_ListAction: Start', TRUE);
1316: FND_MSG_PUB.Add;
1317: END IF; */
1318:
1319:

Line 1421: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction API', TRUE);

1417: -- API message list
1418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1419: THEN -- MMSG
1420: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
1421: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction API', TRUE);
1422: FND_MSG_PUB.Add;
1423: END IF;
1424:
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1457: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction', TRUE);

1453: -- MMSG
1454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1455: THEN
1456: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1457: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction', TRUE);
1458: FND_MSG_PUB.Add;
1459: END IF;
1460:
1461:

Line 1465: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction: END', TRUE);

1461:
1462: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1463: THEN
1464: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1465: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction: END', TRUE);
1466: FND_MSG_PUB.Add;
1467: END IF; */
1468:
1469:

Line 1485: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);

1481: ROLLBACK TO Update_ListAction_PVT;
1482: x_return_status := FND_API.G_RET_STS_ERROR ;
1483: l_sqlerrm := SQLERRM;
1484: l_sqlcode := SQLCODE;
1485: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1486:
1487: FND_MSG_PUB.Count_AND_Get
1488: ( p_count => x_msg_count,
1489: p_data => x_msg_data,

Line 1500: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);

1496: ROLLBACK TO Update_ListAction_PVT;
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1498: l_sqlerrm := SQLERRM;
1499: l_sqlcode := SQLCODE;
1500: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1501:
1502: FND_MSG_PUB.Count_AND_Get
1503: ( p_count => x_msg_count,
1504: p_data => x_msg_data,

Line 1515: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);

1511: ROLLBACK TO Update_ListAction_PVT;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: l_sqlerrm := SQLERRM;
1514: l_sqlcode := SQLCODE;
1515: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1516:
1517: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1518: THEN
1519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1593: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction: Start', TRUE);

1589: -- Debug Message
1590: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1591: THEN
1592: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1593: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction: Start', TRUE);
1594: FND_MSG_PUB.Add;
1595: END IF; */
1596:
1597: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1701: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction', TRUE);

1697: -- MMSG
1698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1699: THEN
1700: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1701: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction', TRUE);
1702: FND_MSG_PUB.Add;
1703: END IF;
1704:
1705:

Line 1709: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction: END', TRUE);

1705:
1706: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1707: THEN
1708: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1709: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Delete_ListAction: END', TRUE);
1710: FND_MSG_PUB.Add;
1711: END IF; */
1712:
1713:

Line 1834: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Lock_ListAction: Start', TRUE);

1830: -- Debug Message
1831: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1832: THEN
1833: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1834: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Lock_ListAction: Start', TRUE);
1835: FND_MSG_PUB.Add;
1836: END IF; */
1837:
1838: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2192: END AMS_ListAction_PVT;

2188: END IF;
2189:
2190: END check_list_action_changes;
2191:
2192: END AMS_ListAction_PVT;