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 43: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

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

Line 770: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 773: p_validation_mode => JTF_PLSQL_API.g_update,

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

Line 784: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

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

Line 954: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 957: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

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

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

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

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

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

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

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

Line 1460: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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