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 FND_MSG_PUB

Line 32: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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);
34: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36:

Line 33: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

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);
34: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36:
37: -----------------------------------------------------------------------------

Line 34: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

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);
34: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36:
37: -----------------------------------------------------------------------------
38: -- Procedure

Line 426: FND_MSG_PUB.initialize;

422:
423:
424: -- Initialize message list IF p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: -- Debug Message
430: IF (AMS_DEBUG_HIGH_ON) THEN

Line 433: FND_MSG_PUB.Add;

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
437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

534: END IF;
535:
536: -- Success Message
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;

Line 542: FND_MSG_PUB.Add;

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:
546: IF (AMS_DEBUG_HIGH_ON) THEN

Line 549: FND_MSG_PUB.Add;

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:
553: -- Standard call to get message count AND IF count is 1, get message info.

Line 554: FND_MSG_PUB.Count_AND_Get

550: END IF;
551:
552:
553: -- Standard call to get message count AND IF count is 1, get message info.
554: FND_MSG_PUB.Count_AND_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data,
557: p_encoded => FND_API.G_FALSE
558: );

Line 572: FND_MSG_PUB.Count_AND_Get

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,
575: p_encoded => FND_API.G_FALSE
576: );

Line 588: FND_MSG_PUB.Count_AND_Get

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,
591: p_encoded => FND_API.G_FALSE
592: );

Line 603: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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);
606: END IF;
607:

Line 605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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);
606: END IF;
607:
608: FND_MSG_PUB.Count_AND_Get
609: ( p_count => x_msg_count,

Line 608: FND_MSG_PUB.Count_AND_Get

604: THEN
605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
606: END IF;
607:
608: FND_MSG_PUB.Count_AND_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => FND_API.G_FALSE
612: );

Line 861: FND_MSG_PUB.initialize;

857:
858:
859: -- Initialize message list IF p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Debug Message
865: IF (AMS_DEBUG_HIGH_ON) THEN

Line 869: FND_MSG_PUB.Add;

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
873: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

876: --Check that(if specified) the entity to associate the list with is valid. --
877: --------------------------------------------------------------------------------
878: IF(p_list_used_by_id IS NOT NULL and p_arc_list_used_by IS NOT NULL)THEN
879: IF ( Check_List_Association(p_arc_list_used_by,p_list_used_by_id) = FND_API.g_false )THEN
880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
881: THEN
882: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_USED_BY_ID');
883: FND_MSG_PUB.add;
884: END IF;

Line 883: FND_MSG_PUB.add;

879: IF ( Check_List_Association(p_arc_list_used_by,p_list_used_by_id) = FND_API.g_false )THEN
880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
881: THEN
882: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_USED_BY_ID');
883: FND_MSG_PUB.add;
884: END IF;
885: x_return_status := FND_API.g_ret_sts_error;
886: RETURN;
887: END IF;

Line 898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

894: IF AMS_Utility_PVT.check_lookup_exists(
895: p_lookup_type => 'AMS_LIST_TYPE',
896: p_lookup_code => p_list_type) = FND_API.g_false THEN
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
899: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TYPE');
900: FND_MSG_PUB.add;
901: END IF;
902:

Line 900: FND_MSG_PUB.add;

896: p_lookup_code => p_list_type) = FND_API.g_false THEN
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
899: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TYPE');
900: FND_MSG_PUB.add;
901: END IF;
902:
903: x_return_status := FND_API.g_ret_sts_error;
904: RETURN;

Line 916: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

912: FETCH C_ListHeader_Dets INTO g_listheader_rec;
913:
914: IF(C_ListHeader_Dets%NOTFOUND)THEN
915: CLOSE C_ListHeader_Dets;
916: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
917: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ID_NOT_EXIST');
918: FND_MSG_PUB.Add;
919: END IF;
920: x_return_status := FND_API.G_RET_STS_ERROR;

Line 918: FND_MSG_PUB.Add;

914: IF(C_ListHeader_Dets%NOTFOUND)THEN
915: CLOSE C_ListHeader_Dets;
916: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
917: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ID_NOT_EXIST');
918: FND_MSG_PUB.Add;
919: END IF;
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: RETURN;
922: END IF;

Line 926: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

922: END IF;
923: CLOSE C_ListHeader_Dets;
924:
925: IF(g_listheader_rec.generation_type = 'INCREMENTAL')THEN
926: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
927: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_BAD_COPY_INC');
928: FND_MSG_PUB.Add;
929: END IF;
930: x_return_status := FND_API.G_RET_STS_ERROR;

Line 928: FND_MSG_PUB.Add;

924:
925: IF(g_listheader_rec.generation_type = 'INCREMENTAL')THEN
926: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
927: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_BAD_COPY_INC');
928: FND_MSG_PUB.Add;
929: END IF;
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: RETURN;
932: END IF;

Line 1108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1104: THEN
1105: COMMIT WORK;
1106: END IF;
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;

Line 1112: FND_MSG_PUB.Add;

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:
1116: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1120: FND_MSG_PUB.Add;

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.
1124: FND_MSG_PUB.Count_AND_Get

Line 1124: FND_MSG_PUB.Count_AND_Get

1120: FND_MSG_PUB.Add;
1121: END IF;
1122:
1123: -- Standard call to get message count AND IF count is 1, get message info.
1124: FND_MSG_PUB.Count_AND_Get
1125: ( p_count => x_msg_count,
1126: p_data => x_msg_data,
1127: p_encoded => FND_API.G_FALSE);
1128:

Line 1139: FND_MSG_PUB.Count_AND_Get

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,
1142: p_encoded => FND_API.G_FALSE
1143: );

Line 1155: FND_MSG_PUB.Count_AND_Get

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,
1158: p_encoded => FND_API.G_FALSE
1159: );

Line 1170: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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);
1173: END IF;
1174:

Line 1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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);
1173: END IF;
1174:
1175: FND_MSG_PUB.Count_AND_Get
1176: ( p_count => x_msg_count,

Line 1175: FND_MSG_PUB.Count_AND_Get

1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174:
1175: FND_MSG_PUB.Count_AND_Get
1176: ( p_count => x_msg_count,
1177: p_data => x_msg_data,
1178: p_encoded => FND_API.G_FALSE
1179: );

Line 1249: FND_MSG_PUB.initialize;

1245:
1246: END IF;
1247:
1248: IF FND_API.to_boolean (p_init_msg_list) THEN
1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:
1252: IF NOT FND_API.compatible_api_call (
1253: l_api_version,

Line 1268: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1264: OPEN C_ListEntry_Dets;
1265: FETCH C_ListEntry_Dets INTO x_listentry_rec;
1266: IF C_ListEntry_Dets%NOTFOUND THEN
1267: CLOSE C_ListEntry_Dets;
1268: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1269: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1270: FND_MSG_PUB.add;
1271: END IF;
1272: RAISE FND_API.g_exc_error;

Line 1270: FND_MSG_PUB.add;

1266: IF C_ListEntry_Dets%NOTFOUND THEN
1267: CLOSE C_ListEntry_Dets;
1268: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1269: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1270: FND_MSG_PUB.add;
1271: END IF;
1272: RAISE FND_API.g_exc_error;
1273: END IF;
1274: CLOSE C_ListEntry_Dets;