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_LISTSOURCETYPE_PVT dependencies on JTF_PLSQL_API

Line 45: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

41: );
42:
43: PROCEDURE Check_ListSrcType_UK_Items (
44: p_listsrctype_rec IN ListSourceType_Rec_Type,
45: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
46: x_return_status OUT NOCOPY VARCHAR2
47: );
48:
49: PROCEDURE Check_ListSrcType_FK_Items (

Line 772: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

768:
769: -- replace g_miss_char/num/date with current column values
770: Complete_ListSourceType_Rec (p_listsrctype_rec, l_listsrctype_rec);
771:
772: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
773: Check_ListSourceType_Items (
774: p_listsrctype_rec => l_listsrctype_rec,
775: p_validation_mode => JTF_PLSQL_API.g_update,
776: x_return_status => l_return_status

Line 775: p_validation_mode => JTF_PLSQL_API.g_update,

771:
772: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
773: Check_ListSourceType_Items (
774: p_listsrctype_rec => l_listsrctype_rec,
775: p_validation_mode => JTF_PLSQL_API.g_update,
776: x_return_status => l_return_status
777: );
778:
779: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

782: RAISE FND_API.g_exc_error;
783: END IF;
784: END IF;
785:
786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
787: Check_ListSourceType_Record (
788: p_listsrctype_rec => p_listsrctype_rec,
789: p_complete_rec => l_listsrctype_rec,
790: x_return_status => l_return_status

Line 956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

952:
953: ---------------------- validate ------------------------
954: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
955:
956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
957: Check_ListSourceType_Items (
958: p_listsrctype_rec => p_listsrctype_rec,
959: p_validation_mode => JTF_PLSQL_API.g_create,
960: x_return_status => l_return_status

Line 959: p_validation_mode => JTF_PLSQL_API.g_create,

955:
956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
957: Check_ListSourceType_Items (
958: p_listsrctype_rec => p_listsrctype_rec,
959: p_validation_mode => JTF_PLSQL_API.g_create,
960: x_return_status => l_return_status
961: );
962:
963: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 972: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

968: END IF;
969:
970: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
971:
972: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
973: Check_ListSourceType_Record (
974: p_listsrctype_rec => p_listsrctype_rec,
975: p_complete_rec => NULL,
976: x_return_status => l_return_status

Line 1086: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update

1082: -- required columns, foreign keys, domain constraints.
1083: --
1084: -- PARAMETERS
1085: -- p_listsrctype_rec: the record to be validated
1086: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
1087: ---------------------------------------------------------------------
1088: PROCEDURE Check_ListSourceType_Items (
1089: p_listsrctype_rec IN ListSourceType_Rec_Type,
1090: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

Line 1090: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1086: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
1087: ---------------------------------------------------------------------
1088: PROCEDURE Check_ListSourceType_Items (
1089: p_listsrctype_rec IN ListSourceType_Rec_Type,
1090: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1091: x_return_status OUT NOCOPY VARCHAR2
1092: )
1093: IS
1094: BEGIN

Line 1440: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1436: -- have been replaced by current database values
1437: ---------------------------------------------------------------------
1438: PROCEDURE Check_ListSrcType_UK_Items (
1439: p_listsrctype_rec IN ListSourceType_Rec_Type,
1440: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1441: x_return_status OUT NOCOPY VARCHAR2
1442: )
1443: IS
1444: l_list_src_types_table CONSTANT VARCHAR2(30) := 'ams_list_src_types';

Line 1462: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1458:
1459: BEGIN
1460: l_where_clause := 'list_source_type = ''' || p_listsrctype_rec.list_source_type || ''' ' ||
1461: 'AND source_type_code = ''' || p_listsrctype_rec.source_type_code || '''';
1462: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1463: -- Validate that the list_source_name is unique.
1464: OPEN c_name_create (p_listsrctype_rec.list_source_name);
1465: FETCH c_name_create INTO l_valid_flag;
1466: CLOSE c_name_create;