APPS.AMS_PROD_TEMPLATE_PVT dependencies on JTF_PLSQL_API

Line 154: p_validation_mode => JTF_PLSQL_API.g_create,

150: Validate_prod_template(
151: p_api_version_number => 1.0,
152: p_init_msg_list => FND_API.G_FALSE,
153: p_validation_level => p_validation_level,
154: p_validation_mode => JTF_PLSQL_API.g_create,
155: p_prod_template_rec => p_prod_template_rec,
156: x_return_status => x_return_status,
157: x_msg_count => x_msg_count,
158: x_msg_data => x_msg_data);

Line 504: p_validation_mode => JTF_PLSQL_API.g_update,

500: Validate_prod_template(
501: p_api_version_number => 1.0,
502: p_init_msg_list => FND_API.G_FALSE,
503: p_validation_level => p_validation_level,
504: p_validation_mode => JTF_PLSQL_API.g_update,
505: p_prod_template_rec => p_prod_template_rec,
506: x_return_status => x_return_status,
507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data);

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

896:
897:
898: PROCEDURE check_prod_template_uk_items(
899: p_prod_template_rec IN prod_template_rec_type,
900: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
901: x_return_status OUT NOCOPY VARCHAR2)
902: IS
903:
904: l_valid_flag VARCHAR2(1);

Line 925: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

921:
922:
923: BEGIN
924: x_return_status := FND_API.g_ret_sts_success;
925: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
926: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
927: 'AMS_PROD_TEMPLATES_B',
928: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||''''
929: );

Line 948: IF p_validation_mode =JTF_PLSQL_API.g_create

944: IF p_prod_template_rec.template_name IS NOT NULL
945: AND p_prod_template_rec.template_name <> FND_API.g_miss_char
946: THEN
947:
948: IF p_validation_mode =JTF_PLSQL_API.g_create
949: THEN
950: OPEN c_check_unique(p_prod_template_rec.template_name);
951: FETCH c_check_unique INTO l_valid_flag;
952: CLOSE c_check_unique;

Line 954: ELSIF p_validation_mode =JTF_PLSQL_API.g_update

950: OPEN c_check_unique(p_prod_template_rec.template_name);
951: FETCH c_check_unique INTO l_valid_flag;
952: CLOSE c_check_unique;
953:
954: ELSIF p_validation_mode =JTF_PLSQL_API.g_update
955: THEN
956: OPEN c_check_unik_upd(p_prod_template_rec.template_name,p_prod_template_rec.template_id);
957: FETCH c_check_unik_upd INTO l_valid_flag;
958: CLOSE c_check_unik_upd;

Line 965: AMS_UTILITY_PVT.debug_message('l_valid_flag:'||l_valid_flag||' vd mode:'|| p_validation_mode||' g_create:'||JTF_PLSQL_API.g_create);

961: IF (AMS_DEBUG_HIGH_ON) THEN
962:
963:
964:
965: AMS_UTILITY_PVT.debug_message('l_valid_flag:'||l_valid_flag||' vd mode:'|| p_validation_mode||' g_create:'||JTF_PLSQL_API.g_create);
966:
967: END IF;
968:
969: IF l_valid_flag = 'Y'

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

983: END check_prod_template_uk_items;
984:
985: PROCEDURE check_prod_template_req_items(
986: p_prod_template_rec IN prod_template_rec_type,
987: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
988: x_return_status OUT NOCOPY VARCHAR2
989: )
990: IS
991: BEGIN

Line 1005: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

1001: x_return_status := FND_API.g_ret_sts_error;
1002: RETURN;
1003: END IF;
1004:
1005: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1006:
1007: IF p_prod_template_rec.template_id IS NULL THEN
1008: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_prod_template_NO_template_id');
1009: x_return_status := FND_API.g_ret_sts_error;

Line 1189: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1185: IF FND_API.to_Boolean( p_init_msg_list )
1186: THEN
1187: FND_MSG_PUB.initialize;
1188: END IF;
1189: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1190: Check_prod_template_Items(
1191: p_prod_template_rec => p_prod_template_rec,
1192: p_validation_mode => p_validation_mode,
1193: x_return_status => x_return_status

Line 1208: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1204: p_prod_template_rec => p_prod_template_rec,
1205: x_complete_rec => l_prod_template_rec
1206: );
1207:
1208: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1209: Validate_prod_template_Rec(
1210: p_api_version_number => 1.0,
1211: p_init_msg_list => FND_API.G_FALSE,
1212: x_return_status => x_return_status,