DBA Data[Home] [Help]

APPS.OZF_PRICE_LIST_PVT dependencies on OZF_UTILITY_PVT

Line 42: l_uk_flag := OZF_Utility_PVT.check_uniqueness

38:
39: IF p_validation_mode = JTF_PLSQL_API.g_create
40: AND p_ozf_price_list_rec.price_list_attribute_id IS NOT NULL AND p_ozf_price_list_rec.price_list_attribute_id <> FND_API.G_MISS_NUM
41: THEN
42: l_uk_flag := OZF_Utility_PVT.check_uniqueness
43: (
44: 'OZF_PRICE_LIST_ATTRIBUTES',
45: 'price_list_attribute_id = ' || p_ozf_price_list_rec.price_list_attribute_id
46: );

Line 62: l_uk_flag := OZF_Utility_PVT.check_uniqueness

58:
59: IF p_validation_mode = JTF_PLSQL_API.g_create
60: AND p_ozf_price_list_rec.qp_list_header_id IS NOT NULL
61: THEN
62: l_uk_flag := OZF_Utility_PVT.check_uniqueness
63: (
64: 'OZF_PRICE_LIST_ATTRIBUTES',
65: 'qp_list_header_id = ' || p_ozf_price_list_rec.qp_list_header_id
66: );

Line 93: l_fk_flag := OZF_Utility_PVT.check_fk_exists

89:
90: x_return_status := FND_API.g_ret_sts_success;
91:
92: IF p_ozf_price_list_rec.qp_list_header_id <> FND_API.g_miss_num THEN
93: l_fk_flag := OZF_Utility_PVT.check_fk_exists
94: (
95: 'QP_LIST_HEADERS_B',
96: 'list_header_id',
97: p_ozf_price_list_rec.qp_list_header_id

Line 126: IF OZF_Utility_PVT.check_lookup_exists(

122:
123: IF p_ozf_price_list_rec.status_code <> FND_API.g_miss_char
124: AND p_ozf_price_list_rec.status_code IS NOT NULL
125: THEN
126: IF OZF_Utility_PVT.check_lookup_exists(
127: p_lookup_type => 'OZF_PRICELIST_STATUS',
128: p_lookup_code => p_ozf_price_list_rec.status_code
129: ) = FND_API.g_false
130: THEN

Line 455: ozf_utility_pvt.debug_message(l_OZF_PRICE_LIST_rec.status_code);

451: p_OZF_PRICE_LIST_rec => p_OZF_PRICE_LIST_rec,
452: x_complete_rec => l_OZF_PRICE_LIST_rec
453: );
454: END IF;
455: ozf_utility_pvt.debug_message(l_OZF_PRICE_LIST_rec.status_code);
456: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
457: Check_OZF_PRICE_LIST_Items(
458: p_OZF_PRICE_LIST_rec => l_OZF_PRICE_LIST_rec,
459: p_validation_mode => p_validation_mode,

Line 462: ozf_utility_pvt.debug_message(x_return_status);

458: p_OZF_PRICE_LIST_rec => l_OZF_PRICE_LIST_rec,
459: p_validation_mode => p_validation_mode,
460: x_return_status => x_return_status
461: );
462: ozf_utility_pvt.debug_message(x_return_status);
463: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
464: RAISE FND_API.G_EXC_ERROR;
465: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;