APPS.OZF_ADJ_NEW_LINE_PVT dependencies on JTF_PLSQL_API

Line 116: p_validation_mode => JTF_PLSQL_API.g_create,

112: Validate_adj_new_line(
113: p_api_version_number => 1.0,
114: p_init_msg_list => FND_API.G_FALSE,
115: p_validation_level => p_validation_level,
116: p_validation_mode => JTF_PLSQL_API.g_create,
117: p_adj_new_line_rec => p_adj_new_line_rec,
118: x_return_status => x_return_status,
119: x_msg_count => x_msg_count,
120: x_msg_data => x_msg_data);

Line 309: p_validation_mode => JTF_PLSQL_API.g_update,

305: Validate_adj_new_line(
306: p_api_version_number => 1.0,
307: p_init_msg_list => FND_API.G_FALSE,
308: p_validation_level => p_validation_level,
309: p_validation_mode => JTF_PLSQL_API.g_update,
310: p_adj_new_line_rec => p_adj_new_line_rec,
311: x_return_status => x_return_status,
312: x_msg_count => x_msg_count,
313: x_msg_data => x_msg_data);

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

659:
660:
661: PROCEDURE check_adj_new_line_uk_items(
662: p_adj_new_line_rec IN adj_new_line_rec_type,
663: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
664: x_return_status OUT NOCOPY VARCHAR2)
665: IS
666: l_valid_flag VARCHAR2(1);
667:

Line 670: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

666: l_valid_flag VARCHAR2(1);
667:
668: BEGIN
669: x_return_status := FND_API.g_ret_sts_success;
670: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
671: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
672: 'OZF_OFFER_ADJ_NEW_LINES',
673: 'OFFER_ADJ_NEW_LINE_ID = ''' || p_adj_new_line_rec.OFFER_ADJ_NEW_LINE_ID ||''''
674: );

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

690:
691:
692: PROCEDURE check_adj_pg_req_items(
693: p_adj_new_line_rec IN adj_new_line_rec_type,
694: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
695: x_return_status OUT NOCOPY VARCHAR2
696: )
697: IS
698: BEGIN

Line 701: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

697: IS
698: BEGIN
699: x_return_status := FND_API.g_ret_sts_success;
700:
701: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
702: IF p_adj_new_line_rec.discount = FND_API.g_miss_num OR p_adj_new_line_rec.discount IS NULL THEN
703: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'discount' );
704: x_return_status := FND_API.g_ret_sts_error;
705: RETURN;

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

724: END check_adj_pg_req_items;
725:
726: PROCEDURE check_adj_new_line_req_items(
727: p_adj_new_line_rec IN adj_new_line_rec_type,
728: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
729: x_return_status OUT NOCOPY VARCHAR2
730: )
731: IS
732: BEGIN

Line 735: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

731: IS
732: BEGIN
733: x_return_status := FND_API.g_ret_sts_success;
734:
735: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
736: IF p_adj_new_line_rec.offer_adjustment_id = FND_API.g_miss_num OR p_adj_new_line_rec.offer_adjustment_id IS NULL THEN
737: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adjustment_id' );
738: x_return_status := FND_API.g_ret_sts_error;
739: RETURN;

Line 818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

814: FETCH c_modifierLevelCode INTO l_modifierLevelCode;
815: CLOSE c_modifierLevelCode;
816:
817: IF l_modifierLevelCode.modifier_level_code = 'LINEGROUP' THEN
818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
819: IF (p_adj_new_line_rec.volume_from = FND_API.G_MISS_NUM OR p_adj_new_line_rec.volume_from IS NULL)
820: OR
821: (p_adj_new_line_rec.volume_type = FND_API.G_MISS_CHAR OR p_adj_new_line_rec.volume_type IS NULL)
822: THEN

Line 944: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

940: return;
941: END IF;
942: END IF;
943: IF p_adj_new_line_rec.tier_type = 'PBH' THEN
944: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
945: IF p_adj_new_line_rec.volume_type IS NULL OR p_adj_new_line_rec.volume_type = FND_API.G_MISS_CHAR THEN
946: OZF_Utility_PVT.Error_Message('OZF_PBH_VOL_TYPE_REQD' );
947: x_return_status := FND_API.g_ret_sts_error;
948: return;

Line 950: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

946: OZF_Utility_PVT.Error_Message('OZF_PBH_VOL_TYPE_REQD' );
947: x_return_status := FND_API.g_ret_sts_error;
948: return;
949: END IF;
950: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
951: IF p_adj_new_line_rec.volume_type = FND_API.G_MISS_CHAR THEN
952: OZF_Utility_PVT.Error_Message('OZF_PBH_VOL_TYPE_REQD' );
953: x_return_status := FND_API.g_ret_sts_error;
954: return;

Line 1157: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,

1153: PROCEDURE Validate_adj_new_line(
1154: p_api_version_number IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1157: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
1158: p_adj_new_line_rec IN adj_new_line_rec_type,
1159: x_return_status OUT NOCOPY VARCHAR2,
1160: x_msg_count OUT NOCOPY NUMBER,
1161: x_msg_data OUT NOCOPY VARCHAR2

Line 1192: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1188: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1189: -- Initialize API return status to SUCCESS
1190: x_return_status := FND_API.G_RET_STS_SUCCESS;
1191:
1192: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1193: Check_adj_new_line_Items(
1194: p_adj_new_line_rec => p_adj_new_line_rec,
1195: p_validation_mode => p_validation_mode,
1196: x_return_status => x_return_status

Line 1211: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1207: p_adj_new_line_rec => p_adj_new_line_rec,
1208: x_complete_rec => l_adj_new_line_rec
1209: );
1210:
1211: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1212: Validate_adj_new_line_Rec(
1213: p_api_version_number => 1.0,
1214: p_init_msg_list => FND_API.G_FALSE,
1215: x_return_status => x_return_status,