DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PVT dependencies on JTF_PLSQL_API

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

687:
688:
689: PROCEDURE check_st_assoc_uk_items(
690: p_st_assoc_rec IN st_assoc_rec_type,
691: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
692: x_return_status OUT NOCOPY VARCHAR2)
693: IS
694: l_valid_flag VARCHAR2(1);
695:

Line 698: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

694: l_valid_flag VARCHAR2(1);
695:
696: BEGIN
697: x_return_status := FND_API.g_ret_sts_success;
698: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
699: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
700: 'AMS_LIST_SRC_TYPE_ASSOCS',
701: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||''''
702: );

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

717: END check_st_assoc_uk_items;
718:
719: PROCEDURE check_st_assoc_req_items(
720: p_st_assoc_rec IN st_assoc_rec_type,
721: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
722: x_return_status OUT NOCOPY VARCHAR2
723: )
724: IS
725: BEGIN

Line 728: -- p_validation_mode is always passed in JTF_PLSQL_API.g_update.

724: IS
725: BEGIN
726: x_return_status := FND_API.g_ret_sts_success;
727:
728: -- p_validation_mode is always passed in JTF_PLSQL_API.g_update.
729: -- The following automatically generated validation need to be rewriten.
730:
731: /*
732: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 732: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

728: -- p_validation_mode is always passed in JTF_PLSQL_API.g_update.
729: -- The following automatically generated validation need to be rewriten.
730:
731: /*
732: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
733:
734:
735: IF p_st_assoc_rec.list_source_type_assoc_id = FND_API.g_miss_num OR p_st_assoc_rec.list_source_type_assoc_id IS NULL THEN
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_list_source_type_assoc_id');

Line 1087: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1083: THEN
1084: FND_MSG_PUB.initialize;
1085: END IF;
1086:
1087: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1088: Check_st_assoc_Items(
1089: p_st_assoc_rec => p_st_assoc_rec,
1090: p_validation_mode => JTF_PLSQL_API.g_update,
1091: x_return_status => x_return_status

Line 1090: p_validation_mode => JTF_PLSQL_API.g_update,

1086:
1087: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1088: Check_st_assoc_Items(
1089: p_st_assoc_rec => p_st_assoc_rec,
1090: p_validation_mode => JTF_PLSQL_API.g_update,
1091: x_return_status => x_return_status
1092: );
1093:
1094: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1107: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1103: x_complete_rec => l_st_assoc_rec
1104: );
1105:
1106:
1107: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1108: Validate_st_assoc_Rec(
1109: p_api_version_number => 1.0,
1110: p_init_msg_list => FND_API.G_FALSE,
1111: x_return_status => x_return_status,