DBA Data[Home] [Help]

APPS.AMS_LISTACTION_PVT dependencies on AMS_LISTHEADER_PVT

Line 832: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record: Start', TRUE);

828: -- Debug Message
829: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
830: THEN
831: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
832: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record: Start', TRUE);
833: FND_MSG_PUB.Add;
834: END IF; */
835:
836: IF (AMS_DEBUG_HIGH_ON) THEN

Line 897: -- FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', TRUE);

893: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
894: THEN
895: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
896: -- bmuthukr changes for bug 5185128. Implemented changes as suggested in bug 5191606.
897: -- FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', TRUE);
898: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', FALSE);
899: FND_MSG_PUB.Add;
900: END IF;
901:

Line 898: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', FALSE);

894: THEN
895: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
896: -- bmuthukr changes for bug 5185128. Implemented changes as suggested in bug 5191606.
897: -- FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', TRUE);
898: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListAction_Record', FALSE);
899: FND_MSG_PUB.Add;
900: END IF;
901:
902:

Line 907: 'AMS_ListHeader_PVT.Validate_ListAction_Record: END', TRUE);

903: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
904: THEN
905: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
906: FND_MESSAGE.Set_Token('ROW',
907: 'AMS_ListHeader_PVT.Validate_ListAction_Record: END', TRUE);
908: FND_MSG_PUB.Add;
909: END IF; */
910:
911:

Line 1566: l_init_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

1562: -- Status Local Variables
1563: l_return_status VARCHAR2(1); -- Return value from procedures
1564: l_init_action_rec action_rec_type;
1565: l_complete_action_rec action_rec_type;
1566: l_init_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
1567: l_complete_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
1568: BEGIN
1569:
1570: -- Standard Start of API savepoint

Line 1567: l_complete_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;

1563: l_return_status VARCHAR2(1); -- Return value from procedures
1564: l_init_action_rec action_rec_type;
1565: l_complete_action_rec action_rec_type;
1566: l_init_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
1567: l_complete_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
1568: BEGIN
1569:
1570: -- Standard Start of API savepoint
1571: SAVEPOINT Delete_ListAction_PVT;

Line 1628: AMS_ListHeader_PVT.Init_ListHeader_rec(x_listheader_rec => l_init_list_header_rec);

1624:
1625: IF (l_complete_action_rec.arc_action_used_by='LIST')
1626: THEN
1627:
1628: AMS_ListHeader_PVT.Init_ListHeader_rec(x_listheader_rec => l_init_list_header_rec);
1629: l_init_list_header_rec.list_header_id:=l_complete_action_rec.action_used_by_id;
1630:
1631: -- replace g_miss_char/num/date with current column values
1632: AMS_ListHeader_PVT.Complete_ListHeader_rec(l_init_list_header_rec, l_complete_list_header_rec);

Line 1632: AMS_ListHeader_PVT.Complete_ListHeader_rec(l_init_list_header_rec, l_complete_list_header_rec);

1628: AMS_ListHeader_PVT.Init_ListHeader_rec(x_listheader_rec => l_init_list_header_rec);
1629: l_init_list_header_rec.list_header_id:=l_complete_action_rec.action_used_by_id;
1630:
1631: -- replace g_miss_char/num/date with current column values
1632: AMS_ListHeader_PVT.Complete_ListHeader_rec(l_init_list_header_rec, l_complete_list_header_rec);
1633:
1634: -- allow delete only if list header status is Draft/ Scheduled/Available/Cancelled
1635: -- donot allow delete if list header status is generating,locked,archived,expired
1636: -- call reset_status in listheader pvt this will cancel the workflow and change the staus to draft

Line 1646: -- AMS_ListHeader_PVT.Reset_Status(l_complete_list_header_rec.action_used_by_id,)

1642: THEN
1643: DELETE FROM ams_list_select_actions
1644: WHERE list_select_action_id = p_action_id;
1645:
1646: -- AMS_ListHeader_PVT.Reset_Status(l_complete_list_header_rec.action_used_by_id,)
1647:
1648: ELSIF(l_complete_list_header_rec.status_code='GENERATING') OR
1649: (l_complete_list_header_rec.status_code='LOCKED') OR
1650: (l_complete_list_header_rec.status_code='ARCHIVED') OR

Line 1863: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Lock_ListAction', TRUE);

1859: -- MMSG
1860: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1861: THEN
1862: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1863: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Lock_ListAction', TRUE);
1864: FND_MSG_PUB.Add;
1865: END IF;
1866:
1867:

Line 1871: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Lock_ListAction: END', TRUE);

1867:
1868: /* ckapoor IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1869: THEN
1870: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1871: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Lock_ListAction: END', TRUE);
1872: FND_MSG_PUB.Add;
1873: END IF; */
1874:
1875: -- Standard call to get message count AND IF count is 1, get message info.