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_LIST_MAINT_PVT dependencies on AMS_LIST_MAINT_PVT

Line 1: Package Body AMS_LIST_MAINT_PVT AS

1: Package Body AMS_LIST_MAINT_PVT AS
2: /* $Header: amsvlmgb.pls 115.38 2002/11/20 23:00:16 jieli ship $ */
3:
4: /*==========================================================================+
5: | PROCEDURES. |

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Maint_PVT';

25: --This Variable stores a record from the AMS_LIST_SELECT_ACTIONS table. --
26: ----------------------------------------------------------------------------
27: g_listaction_rec AMS_LISTACTION_PVT.action_rec_type;
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Maint_PVT';
30: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlmgb.pls';
31:
32: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 432: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Create_Source_View: Start', TRUE);

428:
429: -- Debug Message
430: IF (AMS_DEBUG_HIGH_ON) THEN
431: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
432: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Create_Source_View: Start', TRUE);
433: FND_MSG_PUB.Add;
434: END IF;
435:
436: -- Initialize API return status to success

Line 541: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Create_Source_View', TRUE);

537: -- MMSG
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
539: THEN
540: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
541: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Create_Source_View', TRUE);
542: FND_MSG_PUB.Add;
543: END IF;
544:
545:

Line 548: FND_MESSAGE.Set_Token('ROW','AMS_List_Maint_PVT.Create_Source_View: END', TRUE);

544:
545:
546: IF (AMS_DEBUG_HIGH_ON) THEN
547: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
548: FND_MESSAGE.Set_Token('ROW','AMS_List_Maint_PVT.Create_Source_View: END', TRUE);
549: FND_MSG_PUB.Add;
550: END IF;
551:
552:

Line 570: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);

566: ROLLBACK TO Create_Source_View;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: g_sqlerrm := SQLERRM;
569: g_sqlcode := SQLCODE;
570: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);
571:
572: FND_MSG_PUB.Count_AND_Get
573: ( p_count => x_msg_count,
574: p_data => x_msg_data,

Line 586: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);

582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583:
584: g_sqlerrm := SQLERRM;
585: g_sqlcode := SQLCODE;
586: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);
587:
588: FND_MSG_PUB.Count_AND_Get
589: ( p_count => x_msg_count,
590: p_data => x_msg_data,

Line 601: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);

597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: g_sqlerrm := SQLERRM;
600: g_sqlcode := SQLCODE;
601: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);
602:
603: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
604: THEN
605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 868: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Copy_List: Start', TRUE);

864: -- Debug Message
865: IF (AMS_DEBUG_HIGH_ON) THEN
866: THEN
867: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
868: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Copy_List: Start', TRUE);
869: FND_MSG_PUB.Add;
870: END IF;
871:
872: -- Initialize API return status to success

Line 1111: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Copy_List', TRUE);

1107:
1108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1109: THEN
1110: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1111: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Maint_PVT.Copy_List', TRUE);
1112: FND_MSG_PUB.Add;
1113: END IF;
1114:
1115:

Line 1119: FND_MESSAGE.Set_Token('ROW','AMS_List_Maint_PVT.Copy_List: END', TRUE);

1115:
1116: IF (AMS_DEBUG_HIGH_ON) THEN
1117: THEN
1118: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1119: FND_MESSAGE.Set_Token('ROW','AMS_List_Maint_PVT.Copy_List: END', TRUE);
1120: FND_MSG_PUB.Add;
1121: END IF;
1122:
1123: -- Standard call to get message count AND IF count is 1, get message info.

Line 1137: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);

1133: ROLLBACK TO Copy_List;
1134: x_return_status := FND_API.G_RET_STS_ERROR ;
1135: g_sqlerrm := SQLERRM;
1136: g_sqlcode := SQLCODE;
1137: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);
1138:
1139: FND_MSG_PUB.Count_AND_Get
1140: ( p_count => x_msg_count,
1141: p_data => x_msg_data,

Line 1153: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);

1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150:
1151: g_sqlerrm := SQLERRM;
1152: g_sqlcode := SQLCODE;
1153: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);
1154:
1155: FND_MSG_PUB.Count_AND_Get
1156: ( p_count => x_msg_count,
1157: p_data => x_msg_data,

Line 1168: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);

1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165:
1166: g_sqlerrm := SQLERRM;
1167: g_sqlcode := SQLCODE;
1168: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);
1169:
1170: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1279: END AMS_LIST_MAINT_PVT;

1275:
1276: END Get_PinCodeData_Rec;
1277:
1278:
1279: END AMS_LIST_MAINT_PVT;