APPS.AMS_CT_RULE_PVT dependencies on JTF_PLSQL_API

Line 147: p_validation_mode => JTF_PLSQL_API.g_create,

143: Validate_ct_rule(
144: p_api_version_number => 1.0,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => p_validation_level,
147: p_validation_mode => JTF_PLSQL_API.g_create,
148: p_ct_rule_rec => p_ct_rule_rec,
149: x_return_status => x_return_status,
150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);

Line 383: p_validation_mode => JTF_PLSQL_API.g_update,

379: Validate_ct_rule(
380: p_api_version_number => 1.0,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_validation_level => p_validation_level,
383: p_validation_mode => JTF_PLSQL_API.g_update,
384: p_ct_rule_rec => p_ct_rule_rec,
385: x_return_status => x_return_status,
386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data);

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

867:
868:
869: PROCEDURE check_ct_rule_uk_items(
870: p_ct_rule_rec IN ct_rule_rec_type,
871: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
872: x_return_status OUT NOCOPY VARCHAR2)
873: IS
874: l_valid_flag VARCHAR2(1);
875: l_sql VARCHAR2(400);

Line 883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

879: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items start');
880: END IF;
881:
882: x_return_status := FND_API.g_ret_sts_success;
883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
884: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
885: 'AMS_CONTENT_RULES_B',
886: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||''''
887: );

Line 896: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

892: ''' AND CONTENT_RULE_ID <> ' || p_ct_rule_rec.CONTENT_RULE_ID
893: );
894: END IF;
895:
896: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
897: IF (AMS_DEBUG_HIGH_ON) THEN
898:
899: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items before unique check');
900: END IF;

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

965: --===================================================================
966:
967: PROCEDURE check_ct_rule_req_items(
968: p_ct_rule_rec IN ct_rule_rec_type,
969: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
970: x_return_status OUT NOCOPY VARCHAR2
971: )
972: IS
973: BEGIN

Line 975: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

971: )
972: IS
973: BEGIN
974: x_return_status := FND_API.g_ret_sts_success;
975: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
976:
977:
978: IF p_ct_rule_rec.object_type = FND_API.g_miss_char OR p_ct_rule_rec.object_type IS NULL THEN
979: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJECT_TYPE');

Line 1302: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1298: IF FND_API.to_Boolean( p_init_msg_list )
1299: THEN
1300: FND_MSG_PUB.initialize;
1301: END IF;
1302: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1303: Check_ct_rule_Items(
1304: p_ct_rule_rec => p_ct_rule_rec,
1305: p_validation_mode => p_validation_mode,
1306: x_return_status => x_return_status

Line 1321: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1317: p_ct_rule_rec => p_ct_rule_rec,
1318: x_complete_rec => l_ct_rule_rec
1319: );
1320:
1321: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1322: Validate_ct_rule_Rec(
1323: p_api_version_number => 1.0,
1324: p_init_msg_list => FND_API.G_FALSE,
1325: x_return_status => x_return_status,