eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_QP_DISCOUNTS_PVT dependencies on FND_API

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: AND b.offer_discount_line_id = p_offer_discount_line_id
35: );
36: l_dummy NUMBER;
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: OPEN c_valid_offer(p_qp_disc_rec.offer_discount_line_id, p_qp_disc_rec.list_line_id);
40: FETCH c_valid_offer INTO l_dummy;
41: IF c_valid_offer%NOTFOUND THEN
42: OZF_UTILITY_PVT.Error_message('OZF_QP_DISC_INV_LL_DL');

Line 43: x_return_status := FND_API.G_RET_STS_ERROR;

39: OPEN c_valid_offer(p_qp_disc_rec.offer_discount_line_id, p_qp_disc_rec.list_line_id);
40: FETCH c_valid_offer INTO l_dummy;
41: IF c_valid_offer%NOTFOUND THEN
42: OZF_UTILITY_PVT.Error_message('OZF_QP_DISC_INV_LL_DL');
43: x_return_status := FND_API.G_RET_STS_ERROR;
44: CLOSE c_valid_offer;
45: RETURN;
46: ELSE
47: CLOSE c_valid_offer;

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: , x_return_status OUT NOCOPY VARCHAR2
56: )
57: IS
58: BEGIN
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
61: IF p_qp_disc_rec.list_line_id IS NULL OR p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
63: x_return_status := FND_API.g_ret_sts_error;

Line 61: IF p_qp_disc_rec.list_line_id IS NULL OR p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN

57: IS
58: BEGIN
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
61: IF p_qp_disc_rec.list_line_id IS NULL OR p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
63: x_return_status := FND_API.g_ret_sts_error;
64: return;
65: END IF;

Line 63: x_return_status := FND_API.g_ret_sts_error;

59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
61: IF p_qp_disc_rec.list_line_id IS NULL OR p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
63: x_return_status := FND_API.g_ret_sts_error;
64: return;
65: END IF;
66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
67: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');

Line 66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
63: x_return_status := FND_API.g_ret_sts_error;
64: return;
65: END IF;
66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
67: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
68: x_return_status := FND_API.g_ret_sts_error;
69: return;
70: END IF;

Line 68: x_return_status := FND_API.g_ret_sts_error;

64: return;
65: END IF;
66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
67: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
68: x_return_status := FND_API.g_ret_sts_error;
69: return;
70: END IF;
71: ELSE
72: IF p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN

Line 72: IF p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN

68: x_return_status := FND_API.g_ret_sts_error;
69: return;
70: END IF;
71: ELSE
72: IF p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN
73: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ozf_qp_discount_id');
74: x_return_status := FND_API.g_ret_sts_error;
75: return;
76: END IF;

Line 74: x_return_status := FND_API.g_ret_sts_error;

70: END IF;
71: ELSE
72: IF p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN
73: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ozf_qp_discount_id');
74: x_return_status := FND_API.g_ret_sts_error;
75: return;
76: END IF;
77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');

Line 77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN

73: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ozf_qp_discount_id');
74: x_return_status := FND_API.g_ret_sts_error;
75: return;
76: END IF;
77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
79: x_return_status := FND_API.g_ret_sts_error;
80: return;
81: END IF;

Line 79: x_return_status := FND_API.g_ret_sts_error;

75: return;
76: END IF;
77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
79: x_return_status := FND_API.g_ret_sts_error;
80: return;
81: END IF;
82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
83: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');

Line 82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
79: x_return_status := FND_API.g_ret_sts_error;
80: return;
81: END IF;
82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
83: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
84: x_return_status := FND_API.g_ret_sts_error;
85: return;
86: END IF;

Line 84: x_return_status := FND_API.g_ret_sts_error;

80: return;
81: END IF;
82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
83: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
84: x_return_status := FND_API.g_ret_sts_error;
85: return;
86: END IF;
87:
88: IF p_qp_disc_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 88: IF p_qp_disc_rec.object_version_number = FND_API.G_MISS_NUM THEN

84: x_return_status := FND_API.g_ret_sts_error;
85: return;
86: END IF;
87:
88: IF p_qp_disc_rec.object_version_number = FND_API.G_MISS_NUM THEN
89: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;

Line 90: x_return_status := FND_API.g_ret_sts_error;

86: END IF;
87:
88: IF p_qp_disc_rec.object_version_number = FND_API.G_MISS_NUM THEN
89: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;
93: END IF;
94: END check_qp_disc_req_items;

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: , x_return_status OUT NOCOPY VARCHAR2
101: )
102: IS
103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');

Line 106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN

102: IS
103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');
109: x_return_status := FND_API.g_ret_sts_error;
110: return;

Line 107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN

103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');
109: x_return_status := FND_API.g_ret_sts_error;
110: return;
111: END IF;

Line 109: x_return_status := FND_API.g_ret_sts_error;

105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');
109: x_return_status := FND_API.g_ret_sts_error;
110: return;
111: END IF;
112: END IF;
113: END IF;

Line 117: (p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM)

113: END IF;
114:
115: IF
116: (
117: (p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM)
118: AND
119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)
120: )
121: THEN

Line 119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)

115: IF
116: (
117: (p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM)
118: AND
119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)
120: )
121: THEN
122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN
123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');

Line 122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN

118: AND
119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)
120: )
121: THEN
122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN
123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');
124: x_return_status := FND_API.g_ret_sts_error;
125: return;
126: END IF;

Line 124: x_return_status := FND_API.g_ret_sts_error;

120: )
121: THEN
122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN
123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');
124: x_return_status := FND_API.g_ret_sts_error;
125: return;
126: END IF;
127: END IF;
128: END check_qp_disc_uk_items;

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: , x_return_status OUT NOCOPY VARCHAR2
135: )
136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;

Line 139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN

135: )
136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;

Line 140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN

136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;

Line 142: x_return_status := FND_API.g_ret_sts_error;

138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;
145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN

Line 146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN

142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;
145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');
149: x_return_status := FND_API.g_ret_sts_error;
150: return;

Line 147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN

143: return;
144: END IF;
145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');
149: x_return_status := FND_API.g_ret_sts_error;
150: return;
151: END IF;

Line 149: x_return_status := FND_API.g_ret_sts_error;

145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');
149: x_return_status := FND_API.g_ret_sts_error;
150: return;
151: END IF;
152: END IF;
153: END check_qp_disc_fk_items;

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161: , x_return_status OUT NOCOPY VARCHAR2
162: )
163: IS
164: BEGIN
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166: check_qp_disc_req_items
167: (
168: p_qp_disc_rec => p_qp_disc_rec
169: , p_validation_mode => p_validation_mode

Line 172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

168: p_qp_disc_rec => p_qp_disc_rec
169: , p_validation_mode => p_validation_mode
170: , x_return_status => x_return_status
171: );
172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;

Line 173: RAISE FND_API.G_EXC_ERROR;

169: , p_validation_mode => p_validation_mode
170: , x_return_status => x_return_status
171: );
172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:

Line 174: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

170: , x_return_status => x_return_status
171: );
172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: check_qp_disc_uk_items

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: );
172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: check_qp_disc_uk_items
179: (

Line 184: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

180: p_qp_disc_rec => p_qp_disc_rec
181: , p_validation_mode => p_validation_mode
182: , x_return_status => x_return_status
183: );
184: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;

Line 185: RAISE FND_API.G_EXC_ERROR;

181: , p_validation_mode => p_validation_mode
182: , x_return_status => x_return_status
183: );
184: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:

Line 186: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

182: , x_return_status => x_return_status
183: );
184: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: check_qp_disc_fk_items

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: );
184: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: check_qp_disc_fk_items
191: (

Line 196: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

192: p_qp_disc_rec => p_qp_disc_rec
193: , p_validation_mode => p_validation_mode
194: , x_return_status => x_return_status
195: );
196: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;

Line 197: RAISE FND_API.G_EXC_ERROR;

193: , p_validation_mode => p_validation_mode
194: , x_return_status => x_return_status
195: );
196: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:

Line 198: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

194: , x_return_status => x_return_status
195: );
196: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: check_qp_disc_inter_attr

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: );
196: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
197: RAISE FND_API.G_EXC_ERROR;
198: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: check_qp_disc_inter_attr
203: (

Line 208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

204: p_qp_disc_rec => p_qp_disc_rec
205: , p_validation_mode => p_validation_mode
206: , x_return_status => x_return_status
207: );
208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;

Line 209: RAISE FND_API.G_EXC_ERROR;

205: , p_validation_mode => p_validation_mode
206: , x_return_status => x_return_status
207: );
208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:

Line 210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

206: , x_return_status => x_return_status
207: );
208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: END check_ozf_qp_disc_items;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: );
208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: END check_ozf_qp_disc_items;
215:

Line 219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

215:
216: PROCEDURE Validate_ozf_qp_discounts
217: (
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

Line 220: p_commit IN VARCHAR2 := FND_API.G_FALSE,

216: PROCEDURE Validate_ozf_qp_discounts
217: (
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
224:

Line 221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

217: (
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
224:
225: x_return_status OUT NOCOPY VARCHAR2,

Line 236: IF NOT FND_API.Compatible_api_call(

232: l_api_version_number CONSTANT NUMBER := 1.0;
233: l_api_name CONSTANT VARCHAR2(30) := 'Validate_ozf_qp_discounts';
234:
235: BEGIN
236: IF NOT FND_API.Compatible_api_call(
237: l_api_version_number
238: , p_api_version_number
239: , l_api_name
240: , g_pkg_name

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: , p_api_version_number
239: , l_api_name
240: , g_pkg_name
241: ) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
246:

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: END IF;
244:
245: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
246:
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: IF p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM THEN
250: check_ozf_qp_disc_items(
251: p_qp_disc_rec => p_qp_disc_rec

Line 263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

259:
260: PROCEDURE Create_ozf_qp_discount
261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266:
267: x_return_status OUT NOCOPY VARCHAR2,

Line 264: p_commit IN VARCHAR2 := FND_API.G_FALSE,

260: PROCEDURE Create_ozf_qp_discount
261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266:
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,

Line 265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

261: (
262: p_api_version_number IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
266:
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,

Line 295: IF NOT FND_API.Compatible_API_Call( l_api_version_number

291: -- INITIALIZE
292: -- savepoint
293: SAVEPOINT Create_ozf_qp_discount;
294: -- check api compatibility
295: IF NOT FND_API.Compatible_API_Call( l_api_version_number
296: , p_api_version_number
297: , l_api_name
298: , G_PKG_NAME) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: IF NOT FND_API.Compatible_API_Call( l_api_version_number
296: , p_api_version_number
297: , l_api_name
298: , G_PKG_NAME) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301: -- initialize messages
302: FND_MSG_PUB.initialize;
303: -- debug start

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: FND_MSG_PUB.initialize;
303: -- debug start
304: ozf_utility_pvt.debug_message('Private API: '||l_api_name||' Start');
305: -- set return status
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: IF FND_GLOBAL.USER_ID IS NULL THEN
309: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: IF FND_GLOBAL.USER_ID IS NULL THEN
309: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312:
313: l_qp_disc_rec := p_qp_disc_rec;
314:

Line 315: IF p_qp_disc_rec.ozf_qp_discount_id IS NULL OR p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN

311: END IF;
312:
313: l_qp_disc_rec := p_qp_disc_rec;
314:
315: IF p_qp_disc_rec.ozf_qp_discount_id IS NULL OR p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN
316: LOOP
317: l_dummy := null;
318: OPEN c_id;
319: FETCH c_id INTO l_ozf_qp_discount_id;

Line 343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

339: , x_msg_count => x_msg_count
340: , x_msg_data => x_msg_data
341: , p_qp_disc_rec => p_qp_disc_rec
342: );
343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;

Line 344: RAISE FND_API.G_EXC_ERROR;

340: , x_msg_data => x_msg_data
341: , p_qp_disc_rec => p_qp_disc_rec
342: );
343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348: -- insert

Line 345: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

341: , p_qp_disc_rec => p_qp_disc_rec
342: );
343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348: -- insert
349: OZF_QP_DISCOUNTS_PKG.Insert_row

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

342: );
343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348: -- insert
349: OZF_QP_DISCOUNTS_PKG.Insert_row
350: (

Line 361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

357: , p_last_update_date => sysdate
358: , p_last_updated_by => FND_GLOBAL.user_id
359: , p_last_update_login => FND_GLOBAL.conc_login_id
360: );
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;

Line 362: RAISE FND_API.G_EXC_ERROR;

358: , p_last_updated_by => FND_GLOBAL.user_id
359: , p_last_update_login => FND_GLOBAL.conc_login_id
360: );
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:

Line 363: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

359: , p_last_update_login => FND_GLOBAL.conc_login_id
360: );
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: x_qp_discount_id := l_ozf_qp_discount_id;

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: );
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: x_qp_discount_id := l_ozf_qp_discount_id;
368: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');

Line 370: IF FND_API.to_boolean(p_commit) THEN

366:
367: x_qp_discount_id := l_ozf_qp_discount_id;
368: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
369: -- commit
370: IF FND_API.to_boolean(p_commit) THEN
371: COMMIT WORK;
372: END IF;
373: -- collect messages
374: FND_MSG_PUB.count_and_get

Line 381: WHEN FND_API.G_EXC_ERROR THEN

377: , p_data =>x_msg_data
378: );
379: -- exception
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO Create_ozf_qp_discount;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.count_and_get
385: (

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: -- exception
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO Create_ozf_qp_discount;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.count_and_get
385: (
386: p_encoded => FND_API.G_FALSE
387: , p_count => x_msg_count

Line 386: p_encoded => FND_API.G_FALSE

382: ROLLBACK TO Create_ozf_qp_discount;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.count_and_get
385: (
386: p_encoded => FND_API.G_FALSE
387: , p_count => x_msg_count
388: , p_data => x_msg_data
389: );
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

386: p_encoded => FND_API.G_FALSE
387: , p_count => x_msg_count
388: , p_data => x_msg_data
389: );
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO Create_ozf_qp_discount;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.count_and_get
394: (

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: , p_data => x_msg_data
389: );
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO Create_ozf_qp_discount;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.count_and_get
394: (
395: p_encoded => FND_API.G_FALSE
396: , p_count => x_msg_count

Line 395: p_encoded => FND_API.G_FALSE

391: ROLLBACK TO Create_ozf_qp_discount;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.count_and_get
394: (
395: p_encoded => FND_API.G_FALSE
396: , p_count => x_msg_count
397: , p_data => x_msg_data
398: );
399: WHEN OTHERS THEN

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

397: , p_data => x_msg_data
398: );
399: WHEN OTHERS THEN
400: ROLLBACK TO Create_ozf_qp_discount;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
403: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
404: END IF;
405: FND_MSG_PUB.count_and_get(

Line 406: p_encoded => FND_API.G_FALSE

402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
403: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
404: END IF;
405: FND_MSG_PUB.count_and_get(
406: p_encoded => FND_API.G_FALSE
407: , p_data => x_msg_data
408: , p_count => x_msg_count
409: );
410: END Create_ozf_qp_discount;

Line 417: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

413:
414: PROCEDURE Update_ozf_qp_discount
415: (
416: p_api_version_number IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
418: p_commit IN VARCHAR2 := FND_API.G_FALSE,
419: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
420:
421: x_return_status OUT NOCOPY VARCHAR2,

Line 418: p_commit IN VARCHAR2 := FND_API.G_FALSE,

414: PROCEDURE Update_ozf_qp_discount
415: (
416: p_api_version_number IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
418: p_commit IN VARCHAR2 := FND_API.G_FALSE,
419: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
420:
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,

Line 419: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

415: (
416: p_api_version_number IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
418: p_commit IN VARCHAR2 := FND_API.G_FALSE,
419: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
420:
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2,

Line 443: IF NOT FND_API.Compatible_api_call

439: l_tar_qp_disc qp_discount_rec_type := p_qp_disc_rec;
440:
441: BEGIN
442: SAVEPOINT Update_ozf_qp_discount;
443: IF NOT FND_API.Compatible_api_call
444: (
445: l_api_version_number
446: , p_api_version_number
447: , G_PKG_NAME

Line 451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

447: , G_PKG_NAME
448: , l_api_name
449: )
450: THEN
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;

Line 453: IF FND_API.to_boolean(p_init_msg_list) THEN

449: )
450: THEN
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
457: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459:
460:
461: IF l_tar_qp_disc.object_version_number IS NULL OR l_tar_qp_disc.object_version_number = FND_API.G_MISS_NUM THEN

Line 461: IF l_tar_qp_disc.object_version_number IS NULL OR l_tar_qp_disc.object_version_number = FND_API.G_MISS_NUM THEN

457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459:
460:
461: IF l_tar_qp_disc.object_version_number IS NULL OR l_tar_qp_disc.object_version_number = FND_API.G_MISS_NUM THEN
462: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
463: , p_token_name => 'COLUMN'
464: , p_token_value => 'Last_Update_Date') ;
465: RAISE FND_API.G_EXC_ERROR;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: IF l_tar_qp_disc.object_version_number IS NULL OR l_tar_qp_disc.object_version_number = FND_API.G_MISS_NUM THEN
462: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
463: , p_token_name => 'COLUMN'
464: , p_token_value => 'Last_Update_Date') ;
465: RAISE FND_API.G_EXC_ERROR;
466:
467: END IF;
468:
469: OPEN c_get_qp_disc(l_tar_qp_disc.ozf_qp_discount_id, l_tar_qp_disc.object_version_number);

Line 475: RAISE FND_API.G_EXC_ERROR;

471: IF (c_get_qp_disc%NOTFOUND) THEN
472: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
473: , p_token_name => 'INFO'
474: , p_token_value => 'OZF_QP_DISC') ;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: CLOSE c_get_qp_disc;
478:
479: IF l_tar_qp_disc.object_version_number <> l_ref_qp_disc.object_version_number THEN

Line 483: RAISE FND_API.G_EXC_ERROR;

479: IF l_tar_qp_disc.object_version_number <> l_ref_qp_disc.object_version_number THEN
480: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
481: , p_token_name => 'INFO'
482: , p_token_value => 'OZF_QP_DISC') ;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485:
486: Validate_ozf_qp_discounts
487: (

Line 498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

494: , x_msg_count => x_msg_count
495: , x_msg_data => x_msg_data
496: , p_qp_disc_rec => p_qp_disc_rec
497: );
498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;

Line 499: RAISE FND_API.G_EXC_ERROR;

495: , x_msg_data => x_msg_data
496: , p_qp_disc_rec => p_qp_disc_rec
497: );
498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:

Line 500: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

496: , p_qp_disc_rec => p_qp_disc_rec
497: );
498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: OZF_QP_DISCOUNTS_PKG.Update_row

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497: );
498: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: OZF_QP_DISCOUNTS_PKG.Update_row
505: (

Line 514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

510: , p_last_update_date => sysdate
511: , p_last_updated_by => FND_GLOBAL.user_id
512: , p_last_update_login => FND_GLOBAL.conc_login_id
513: );
514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;

Line 515: RAISE FND_API.G_EXC_ERROR;

511: , p_last_updated_by => FND_GLOBAL.user_id
512: , p_last_update_login => FND_GLOBAL.conc_login_id
513: );
514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:

Line 516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

512: , p_last_update_login => FND_GLOBAL.conc_login_id
513: );
514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: );
514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
521: IF FND_API.to_boolean(p_commit) THEN

Line 521: IF FND_API.to_boolean(p_commit) THEN

517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
521: IF FND_API.to_boolean(p_commit) THEN
522: COMMIT WORK;
523: END IF;
524:
525: FND_MSG_PUB.count_and_get

Line 533: x_return_status := FND_API.g_ret_sts_error;

529: );
530:
531: EXCEPTION
532: WHEN OZF_Utility_PVT.resource_locked THEN
533: x_return_status := FND_API.g_ret_sts_error;
534: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Update_ozf_qp_discount;

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532: WHEN OZF_Utility_PVT.resource_locked THEN
533: x_return_status := FND_API.g_ret_sts_error;
534: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Update_ozf_qp_discount;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Update_ozf_qp_discount;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false
541: , p_count => x_msg_count
542: , p_data => x_msg_data

Line 540: p_encoded => FND_API.g_false

536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Update_ozf_qp_discount;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false
541: , p_count => x_msg_count
542: , p_data => x_msg_data
543: );
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

540: p_encoded => FND_API.g_false
541: , p_count => x_msg_count
542: , p_data => x_msg_data
543: );
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO Update_ozf_qp_discount;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: , p_data => x_msg_data
543: );
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO Update_ozf_qp_discount;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false
549: , p_count => x_msg_count
550: , p_data => x_msg_data

Line 548: p_encoded => FND_API.g_false

544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO Update_ozf_qp_discount;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false
549: , p_count => x_msg_count
550: , p_data => x_msg_data
551: );
552: WHEN OTHERS THEN

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: , p_data => x_msg_data
551: );
552: WHEN OTHERS THEN
553: ROLLBACK TO Update_ozf_qp_discount;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
556: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME, l_api_name);
557: END IF;
558: FND_MSG_PUB.count_and_get(

Line 559: p_encoded => FND_API.g_false

555: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
556: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME, l_api_name);
557: END IF;
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false
560: , p_count => x_msg_count
561: , p_data => x_msg_data
562: );
563: END Update_ozf_qp_discount;

Line 568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

564:
565: PROCEDURE Delete_ozf_qp_discount
566: (
567: p_api_version_number IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571:
572: x_return_status OUT NOCOPY VARCHAR2,

Line 569: p_commit IN VARCHAR2 := FND_API.G_FALSE,

565: PROCEDURE Delete_ozf_qp_discount
566: (
567: p_api_version_number IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571:
572: x_return_status OUT NOCOPY VARCHAR2,
573: x_msg_count OUT NOCOPY NUMBER,

Line 570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

566: (
567: p_api_version_number IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571:
572: x_return_status OUT NOCOPY VARCHAR2,
573: x_msg_count OUT NOCOPY NUMBER,
574: x_msg_data OUT NOCOPY VARCHAR2,

Line 584: IF NOT FND_API.Compatible_api_call

580: l_api_version_number CONSTANT NUMBER := 1.0;
581: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ozf_qp_discount';
582: BEGIN
583: SAVEPOINT Delete_ozf_qp_discount;
584: IF NOT FND_API.Compatible_api_call
585: (
586: l_api_version_number
587: , p_api_version_number
588: , G_PKG_NAME

Line 592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

588: , G_PKG_NAME
589: , l_api_name
590: )
591: THEN
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;
594:
595: IF FND_API.to_boolean(p_init_msg_list) THEN
596: FND_MSG_PUB.initialize;

Line 595: IF FND_API.to_boolean(p_init_msg_list) THEN

591: THEN
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;
594:
595: IF FND_API.to_boolean(p_init_msg_list) THEN
596: FND_MSG_PUB.initialize;
597: END IF;
598: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| ' Start');
599:

Line 600: x_return_status := FND_API.G_RET_STS_SUCCESS;

596: FND_MSG_PUB.initialize;
597: END IF;
598: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| ' Start');
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: OZF_QP_DISCOUNTS_PKG.Delete_row(
603: p_qp_discount_id => p_qp_discount_id
604: , p_object_version_number => p_object_version_number

Line 606: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

602: OZF_QP_DISCOUNTS_PKG.Delete_row(
603: p_qp_discount_id => p_qp_discount_id
604: , p_object_version_number => p_object_version_number
605: );
606: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;

Line 607: RAISE FND_API.G_EXC_ERROR;

603: p_qp_discount_id => p_qp_discount_id
604: , p_object_version_number => p_object_version_number
605: );
606: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:

Line 608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

604: , p_object_version_number => p_object_version_number
605: );
606: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612: IF FND_API.to_boolean(p_commit) THEN

Line 609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

605: );
606: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
607: RAISE FND_API.G_EXC_ERROR;
608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612: IF FND_API.to_boolean(p_commit) THEN
613: COMMIT WORK;

Line 612: IF FND_API.to_boolean(p_commit) THEN

608: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612: IF FND_API.to_boolean(p_commit) THEN
613: COMMIT WORK;
614: END IF;
615:
616: FND_MSG_PUB.count_and_get(

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618: , p_data => x_msg_data
619: );
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO Delete_ozf_qp_discount;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: FND_MSG_PUB.count_and_get(
626: p_encoded => FND_API.g_false

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO Delete_ozf_qp_discount;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: FND_MSG_PUB.count_and_get(
626: p_encoded => FND_API.g_false
627: , p_count => x_msg_count
628: , p_data => x_msg_data

Line 626: p_encoded => FND_API.g_false

622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO Delete_ozf_qp_discount;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: FND_MSG_PUB.count_and_get(
626: p_encoded => FND_API.g_false
627: , p_count => x_msg_count
628: , p_data => x_msg_data
629: );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: p_encoded => FND_API.g_false
627: , p_count => x_msg_count
628: , p_data => x_msg_data
629: );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO Delete_ozf_qp_discount;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: , p_data => x_msg_data
629: );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO Delete_ozf_qp_discount;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false
635: , p_count => x_msg_count
636: , p_data => x_msg_data

Line 634: p_encoded => FND_API.g_false

630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO Delete_ozf_qp_discount;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false
635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );
638: WHEN OTHERS THEN

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: , p_data => x_msg_data
637: );
638: WHEN OTHERS THEN
639: ROLLBACK TO Delete_ozf_qp_discount;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
642: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
643: END IF;
644: FND_MSG_PUB.count_and_get(

Line 645: p_encoded => FND_API.g_false

641: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
642: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
643: END IF;
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false
646: , p_count => x_msg_count
647: , p_data => x_msg_data
648: );
649: END Delete_ozf_qp_discount;