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_PRODUCTS_PVT dependencies on FND_API

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: , x_return_status OUT NOCOPY VARCHAR2
23: )
24: IS
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;

Line 28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN

24: IS
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;
31: return;
32: END IF;

Line 30: x_return_status := FND_API.g_ret_sts_error;

26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;
31: return;
32: END IF;
33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');

Line 33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;
31: return;
32: END IF;
33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
35: x_return_status := FND_API.g_ret_sts_error;
36: return;
37: END IF;

Line 35: x_return_status := FND_API.g_ret_sts_error;

31: return;
32: END IF;
33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
35: x_return_status := FND_API.g_ret_sts_error;
36: return;
37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN

Line 39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN

35: x_return_status := FND_API.g_ret_sts_error;
36: return;
37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN
40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');
41: x_return_status := FND_API.g_ret_sts_error;
42: return;
43: END IF;

Line 41: x_return_status := FND_API.g_ret_sts_error;

37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN
40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');
41: x_return_status := FND_API.g_ret_sts_error;
42: return;
43: END IF;
44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');

Line 44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN

40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');
41: x_return_status := FND_API.g_ret_sts_error;
42: return;
43: END IF;
44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');
46: x_return_status := FND_API.g_ret_sts_error;
47: return;
48: END IF;

Line 46: x_return_status := FND_API.g_ret_sts_error;

42: return;
43: END IF;
44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');
46: x_return_status := FND_API.g_ret_sts_error;
47: return;
48: END IF;
49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');

Line 49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');
46: x_return_status := FND_API.g_ret_sts_error;
47: return;
48: END IF;
49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
51: x_return_status := FND_API.g_ret_sts_error;
52: return;
53: END IF;

Line 51: x_return_status := FND_API.g_ret_sts_error;

47: return;
48: END IF;
49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
51: x_return_status := FND_API.g_ret_sts_error;
52: return;
53: END IF;
54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN
55: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');

Line 54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN

50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
51: x_return_status := FND_API.g_ret_sts_error;
52: return;
53: END IF;
54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN
55: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');
56: x_return_status := FND_API.g_ret_sts_error;
57: return;
58: END IF;

Line 56: x_return_status := FND_API.g_ret_sts_error;

52: return;
53: END IF;
54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN
55: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');
56: x_return_status := FND_API.g_ret_sts_error;
57: return;
58: END IF;
59: END IF;
60: END check_qp_prod_req_items;

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: , x_return_status OUT NOCOPY VARCHAR2
67: )
68: IS
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');

Line 72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN

68: IS
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;
76: return;

Line 73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN

69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;
76: return;
77: END IF;

Line 75: x_return_status := FND_API.g_ret_sts_error;

71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;
76: return;
77: END IF;
78: END IF;
79:

Line 82: p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM

78: END IF;
79:
80: IF
81: (
82: p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM
83: )
84: AND
85: (
86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM

Line 86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM

82: p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM
83: )
84: AND
85: (
86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM
87: )
88: THEN
89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN
90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');

Line 89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN

85: (
86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM
87: )
88: THEN
89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN
90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');
91: x_return_status := FND_API.g_ret_sts_error;
92: return;
93: END IF;

Line 91: x_return_status := FND_API.g_ret_sts_error;

87: )
88: THEN
89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN
90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');
91: x_return_status := FND_API.g_ret_sts_error;
92: return;
93: END IF;
94: END IF;
95: END IF;

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: , x_return_status OUT NOCOPY VARCHAR2
105: )
106: IS
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;

Line 109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN

105: )
106: IS
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;

Line 110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN

106: IS
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;
114: END IF;

Line 112: x_return_status := FND_API.g_ret_sts_error;

108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;
114: END IF;
115: END IF;
116:

Line 117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN

113: return;
114: END IF;
115: END IF;
116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;

Line 118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN

114: END IF;
115: END IF;
116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;
122: END IF;

Line 120: x_return_status := FND_API.g_ret_sts_error;

116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;
122: END IF;
123: END IF;
124: END check_qp_prod_fk_items;

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: IS
139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);
140: l_list_header2 NUMBER;
141: BEGIN
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: OPEN c_list_header(p_qp_product_rec.pricing_attribute_id);
144: FETCH c_list_header INTO l_list_header;
145: CLOSE c_list_header;
146:

Line 153: x_return_status := FND_API.g_ret_sts_error;

149: CLOSE c_list_header2;
150:
151: IF l_list_header2 <> l_list_header THEN
152: OZF_Utility_PVT.Error_Message('OZF_OFFR_INVALID_PROD_PAIR');
153: x_return_status := FND_API.g_ret_sts_error;
154: END IF;
155: END check_qp_prod_attr;
156:
157: PROCEDURE check_ozf_qp_prod_items(

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 171: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 172: RAISE FND_API.G_EXC_ERROR;

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

Line 173: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 183: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 184: RAISE FND_API.G_EXC_ERROR;

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

Line 185: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 196: RAISE FND_API.G_EXC_ERROR;

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

Line 197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: );
195: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
196: RAISE FND_API.G_EXC_ERROR;
197: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: /* check_qp_prod_attr(
202: p_qp_product_rec => p_qp_product_rec

Line 206: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 207: RAISE FND_API.G_EXC_ERROR;

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

Line 208: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

215: PROCEDURE Validate_ozf_qp_products
216: (
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: p_validation_mode IN VARCHAR2,
222:
223: x_return_status OUT NOCOPY VARCHAR2,

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

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

Line 239: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

235: BEGIN
236: -- initialize
237:
238: -- Standard call to check for call compatibility.
239: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
240: p_api_version_number,
241: l_api_name,
242: G_PKG_NAME)
243: THEN

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: p_api_version_number,
241: l_api_name,
242: G_PKG_NAME)
243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247:
248: -- Debug Message

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: -- Debug Message
249: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
250:
251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: -- check items
255: IF p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM THEN
256: check_ozf_qp_prod_items(

Line 261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

257: p_qp_product_rec => p_qp_product_rec
258: , p_validation_mode => p_validation_mode
259: , x_return_status => x_return_status
260: );
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;

Line 262: RAISE FND_API.G_EXC_ERROR;

258: , p_validation_mode => p_validation_mode
259: , x_return_status => x_return_status
260: );
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;

Line 263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

259: , x_return_status => x_return_status
260: );
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;
267: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: );
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;
267: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
268:

Line 272: x_return_status := FND_API.g_ret_sts_error;

268:
269: EXCEPTION
270:
271: WHEN OZF_Utility_PVT.resource_locked THEN
272: x_return_status := FND_API.g_ret_sts_error;
273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: -- ROLLBACK TO validate_market_options_pvt;

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271: WHEN OZF_Utility_PVT.resource_locked THEN
272: x_return_status := FND_API.g_ret_sts_error;
273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: -- ROLLBACK TO validate_market_options_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: -- ROLLBACK TO validate_market_options_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,

Line 280: p_encoded => FND_API.G_FALSE,

276: -- ROLLBACK TO validate_market_options_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284:

Line 285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: -- ROLLBACK TO validate_market_options_pvt;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: );
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: -- ROLLBACK TO validate_market_options_pvt;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,

Line 290: p_encoded => FND_API.G_FALSE,

286: -- ROLLBACK TO validate_market_options_pvt;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294:

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: );
294:
295: WHEN OTHERS THEN
296: -- ROLLBACK TO validate_market_options_pvt;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;

Line 304: p_encoded => FND_API.G_FALSE,

300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message
303: FND_MSG_PUB.Count_And_Get (
304: p_encoded => FND_API.G_FALSE,
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );
308:

Line 323: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

319: -- Parameters
320: --
321: -- IN
322: -- p_api_version_number IN NUMBER Required
323: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
324: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
325: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_qp_product_rec IN qp_product_rec_type
327: -- OUT NOCOPY

Line 324: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

320: --
321: -- IN
322: -- p_api_version_number IN NUMBER Required
323: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
324: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
325: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_qp_product_rec IN qp_product_rec_type
327: -- OUT NOCOPY
328: -- x_return_status OUT NOCOPY VARCHAR2

Line 325: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

321: -- IN
322: -- p_api_version_number IN NUMBER Required
323: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
324: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
325: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
326: -- p_qp_product_rec IN qp_product_rec_type
327: -- OUT NOCOPY
328: -- x_return_status OUT NOCOPY VARCHAR2
329: -- x_msg_count OUT NOCOPY NUMBER

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

339: -- ==============================================================================
340:
341: PROCEDURE Create_ozf_qp_product(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346:
347: x_return_status OUT NOCOPY VARCHAR2,

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

340:
341: PROCEDURE Create_ozf_qp_product(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346:
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,

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

341: PROCEDURE Create_ozf_qp_product(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346:
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,

Line 375: IF NOT FND_API.Compatible_Api_Call(

371: --INITIALIZE
372: -- save point
373: SAVEPOINT Create_ozf_qp_product_pvt;
374: -- check api compatibility
375: IF NOT FND_API.Compatible_Api_Call(
376: l_api_version_number
377: , p_api_version_number
378: , l_api_name
379: , G_PKG_NAME) THEN

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: l_api_version_number
377: , p_api_version_number
378: , l_api_name
379: , G_PKG_NAME) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382: -- initialize messages
383: IF FND_API.to_boolean(p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;

Line 383: IF FND_API.to_boolean(p_init_msg_list) THEN

379: , G_PKG_NAME) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382: -- initialize messages
383: IF FND_API.to_boolean(p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386: -- debug message start
387: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| 'start');

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385: END IF;
386: -- debug message start
387: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| 'start');
388: -- set return status
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: IF FND_GLOBAL.USER_ID IS NULL THEN
392: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
393: x_return_status := FND_API.G_RET_STS_ERROR;

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: IF FND_GLOBAL.USER_ID IS NULL THEN
392: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END IF;
395:
396: l_qp_product_rec := p_qp_product_rec;
397:

Line 398: IF p_qp_product_rec.qp_product_id IS NULL OR p_qp_product_rec.qp_product_id = FND_API.g_miss_num THEN

394: END IF;
395:
396: l_qp_product_rec := p_qp_product_rec;
397:
398: IF p_qp_product_rec.qp_product_id IS NULL OR p_qp_product_rec.qp_product_id = FND_API.g_miss_num THEN
399: LOOP
400: l_dummy := NULL;
401: OPEN c_id;
402: FETCH c_id INTO l_qp_product_id;

Line 426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

422: , x_msg_count => x_msg_count
423: , x_msg_data => x_msg_data
424: , p_qp_product_rec => l_qp_product_rec
425: );
426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: -- insert
430: OZF_QP_PRODUCTS_PKG.Insert_row

Line 427: RAISE FND_API.G_EXC_ERROR;

423: , x_msg_data => x_msg_data
424: , p_qp_product_rec => l_qp_product_rec
425: );
426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: -- insert
430: OZF_QP_PRODUCTS_PKG.Insert_row
431: (

Line 443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

439: , p_last_updated_by => FND_GLOBAL.USER_ID
440: , p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
441: );
442:
443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: x_qp_product_id := l_qp_product_id;

Line 444: RAISE FND_API.G_EXC_ERROR;

440: , p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
441: );
442:
443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: x_qp_product_id := l_qp_product_id;
448:

Line 449: IF FND_API.to_boolean(p_commit) THEN

445: END IF;
446:
447: x_qp_product_id := l_qp_product_id;
448:
449: IF FND_API.to_boolean(p_commit) THEN
450: COMMIT WORK;
451: END IF;
452:
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 463: WHEN FND_API.G_EXC_ERROR THEN

459: );
460:
461: -- exception
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK TO create_ozf_qp_product_pvt;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET
467: (

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461: -- exception
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK TO create_ozf_qp_product_pvt;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET
467: (
468: p_encoded => FND_API.G_FALSE
469: , p_count => x_msg_count

Line 468: p_encoded => FND_API.G_FALSE

464: ROLLBACK TO create_ozf_qp_product_pvt;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET
467: (
468: p_encoded => FND_API.G_FALSE
469: , p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:

Line 473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

469: , p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: ROLLBACK TO create_ozf_qp_products_pvt;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.COUNT_AND_GET
477: (

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: );
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: ROLLBACK TO create_ozf_qp_products_pvt;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.COUNT_AND_GET
477: (
478: p_encoded => FND_API.G_FALSE
479: , p_count => x_msg_count

Line 478: p_encoded => FND_API.G_FALSE

474: ROLLBACK TO create_ozf_qp_products_pvt;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.COUNT_AND_GET
477: (
478: p_encoded => FND_API.G_FALSE
479: , p_count => x_msg_count
480: , p_data => x_msg_data
481: );
482:

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: );
482:
483: WHEN OTHERS THEN
484: ROLLBACK TO create_ozf_qp_products_pvt;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;

Line 492: p_encoded => FND_API.G_FALSE,

488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 513: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

509: -- Parameters
510: --
511: -- IN
512: -- p_api_version_number IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
514: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
515: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
516: -- p_qp_product_rec IN qp_product_rec_type
517: -- OUT

Line 514: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

510: --
511: -- IN
512: -- p_api_version_number IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
514: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
515: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
516: -- p_qp_product_rec IN qp_product_rec_type
517: -- OUT
518: -- x_return_status OUT NOCOPY VARCHAR2

Line 515: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

511: -- IN
512: -- p_api_version_number IN NUMBER Required
513: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
514: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
515: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
516: -- p_qp_product_rec IN qp_product_rec_type
517: -- OUT
518: -- x_return_status OUT NOCOPY VARCHAR2
519: -- x_msg_count OUT NOCOPY NUMBER

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

527: -- End of Comments
528: -- ==============================================================================
529: PROCEDURE Update_ozf_qp_product(
530: p_api_version_number IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
534:
535: x_return_status OUT NOCOPY VARCHAR2,

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

528: -- ==============================================================================
529: PROCEDURE Update_ozf_qp_product(
530: p_api_version_number IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
534:
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,

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

529: PROCEDURE Update_ozf_qp_product(
530: p_api_version_number IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
534:
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,
537: x_msg_data OUT NOCOPY VARCHAR2,

Line 564: IF NOT FND_API.Compatible_api_call(l_api_version_number

560:
561: BEGIN
562: -- initialize
563: SAVEPOINT Update_ozf_qp_product_pvt;
564: IF NOT FND_API.Compatible_api_call(l_api_version_number
565: , p_api_version_number
566: , l_api_name
567: , g_pkg_name)
568: THEN

Line 569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

565: , p_api_version_number
566: , l_api_name
567: , g_pkg_name)
568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571:
572: IF FND_API.to_Boolean( p_init_msg_list )
573: THEN

Line 572: IF FND_API.to_Boolean( p_init_msg_list )

568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571:
572: IF FND_API.to_Boolean( p_init_msg_list )
573: THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576: -- Debug Message

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: -- Debug Message
577: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
578:
579: -- Initialize API return status to SUCCESS
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: OPEN c_get_qp_prod( l_tar_qp_prod_rec.qp_product_id,l_tar_qp_prod_rec.object_version_number);
583: FETCH c_get_qp_prod INTO l_ref_qp_prod_rec ;
584: If ( c_get_qp_prod%NOTFOUND) THEN

Line 588: RAISE FND_API.G_EXC_ERROR;

584: If ( c_get_qp_prod%NOTFOUND) THEN
585: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
586: , p_token_name => 'INFO'
587: , p_token_value => 'OZF_MARKET_OPTIONS') ;
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590: CLOSE c_get_qp_prod;
591:
592: If (l_tar_qp_prod_rec.object_version_number is NULL or

Line 593: l_tar_qp_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then

589: END IF;
590: CLOSE c_get_qp_prod;
591:
592: If (l_tar_qp_prod_rec.object_version_number is NULL or
593: l_tar_qp_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then
594: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
595: , p_token_name => 'COLUMN'
596: , p_token_value => 'Last_Update_Date') ;
597: RAISE FND_API.G_EXC_ERROR;

Line 597: RAISE FND_API.G_EXC_ERROR;

593: l_tar_qp_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then
594: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
595: , p_token_name => 'COLUMN'
596: , p_token_value => 'Last_Update_Date') ;
597: RAISE FND_API.G_EXC_ERROR;
598: End if;
599: -- Check Whether record has been changed by someone else
600: If (l_tar_qp_prod_rec.object_version_number <> l_ref_qp_prod_rec.object_version_number) Then
601: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'

Line 604: RAISE FND_API.G_EXC_ERROR;

600: If (l_tar_qp_prod_rec.object_version_number <> l_ref_qp_prod_rec.object_version_number) Then
601: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
602: , p_token_name => 'INFO'
603: , p_token_value => 'Ozf_Market_Options') ;
604: RAISE FND_API.G_EXC_ERROR;
605: End if;
606: -- validate
607: validate_ozf_qp_products
608: (

Line 618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

614: , x_msg_count => x_msg_count
615: , x_msg_data => x_msg_data
616: , p_qp_product_rec => l_tar_qp_prod_rec
617: );
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: -- update

Line 619: RAISE FND_API.G_EXC_ERROR;

615: , x_msg_data => x_msg_data
616: , p_qp_product_rec => l_tar_qp_prod_rec
617: );
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: -- update
623: OZF_QP_PRODUCTS_PKG.Update_Row(

Line 633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

629: , p_last_updated_by => FND_GLOBAL.USER_ID
630: , p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
631: );
632: -- get messages
633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: -- commit
637: IF FND_API.to_boolean(p_commit) THEN

Line 634: RAISE FND_API.G_EXC_ERROR;

630: , p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
631: );
632: -- get messages
633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: -- commit
637: IF FND_API.to_boolean(p_commit) THEN
638: COMMIT WORK;

Line 637: IF FND_API.to_boolean(p_commit) THEN

633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636: -- commit
637: IF FND_API.to_boolean(p_commit) THEN
638: COMMIT WORK;
639: END IF;
640: ozf_utility_pvt.debug_message('Private API : '||l_api_name || ' End');
641: FND_MSG_PUB.count_and_get

Line 649: x_return_status := FND_API.g_ret_sts_error;

645: );
646: -- exception
647: EXCEPTION
648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;

Line 652: WHEN FND_API.G_EXC_ERROR THEN

648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false

Line 654: x_return_status := FND_API.G_RET_STS_ERROR;

650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false
657: , p_count => x_msg_count
658: , p_data => x_msg_data

Line 656: p_encoded => FND_API.g_false

652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false
657: , p_count => x_msg_count
658: , p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

656: p_encoded => FND_API.g_false
657: , p_count => x_msg_count
658: , p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO Update_ozf_qp_product_pvt;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.G_FALSE

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

658: , p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO Update_ozf_qp_product_pvt;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.G_FALSE
665: , p_count => x_msg_count
666: , p_data => x_msg_data

Line 664: p_encoded => FND_API.G_FALSE

660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO Update_ozf_qp_product_pvt;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.G_FALSE
665: , p_count => x_msg_count
666: , p_data => x_msg_data
667: );
668: WHEN OTHERS THEN

Line 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

666: , p_data => x_msg_data
667: );
668: WHEN OTHERS THEN
669: ROLLBACK TO Update_ozf_qp_product_pvt;
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;

Line 677: p_encoded => FND_API.G_FALSE,

673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:

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

715: -- End of Comments
716: -- ==============================================================================
717: PROCEDURE Delete_ozf_qp_product(
718: p_api_version_number IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,

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

716: -- ==============================================================================
717: PROCEDURE Delete_ozf_qp_product(
718: p_api_version_number IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,

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

717: PROCEDURE Delete_ozf_qp_product(
718: p_api_version_number IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,
725: p_qp_product_id IN NUMBER,

Line 734: IF NOT FND_API.Compatible_API_call

730: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ozf_qp_product';
731: BEGIN
732: -- initialize
733: SAVEPOINT Delete_ozf_qp_product_pvt;
734: IF NOT FND_API.Compatible_API_call
735: (
736: l_api_version_number
737: , p_api_version_number
738: , l_api_name

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: , p_api_version_number
738: , l_api_name
739: , g_pkg_name
740: ) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;

Line 743: IF FND_API.to_boolean(p_init_msg_list) THEN

739: , g_pkg_name
740: ) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: -- delete

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

742: END IF;
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: -- delete
748: OZF_QP_PRODUCTS_PKG.Delete_Row(
749: p_qp_product_id => p_qp_product_id
750: , p_object_version_number => p_object_version_number

Line 754: IF FND_API.to_boolean(p_commit) THEN

750: , p_object_version_number => p_object_version_number
751: );
752:
753: -- commit
754: IF FND_API.to_boolean(p_commit) THEN
755: COMMIT WORK;
756: END IF;
757: -- get messages
758: FND_MSG_PUB.count_and_get(

Line 766: x_return_status := FND_API.g_ret_sts_error;

762: -- exception
763: EXCEPTION
764: WHEN OZF_UTILITY_PVT.resource_locked THEN
765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');
766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.COUNT_AND_GET(

Line 767: WHEN FND_API.G_EXC_ERROR THEN

763: EXCEPTION
764: WHEN OZF_UTILITY_PVT.resource_locked THEN
765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');
766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.COUNT_AND_GET(
771: p_encoded => FND_API.G_FALSE

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');
766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.COUNT_AND_GET(
771: p_encoded => FND_API.G_FALSE
772: , p_count => x_msg_count
773: , p_data => x_msg_data

Line 771: p_encoded => FND_API.G_FALSE

767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.COUNT_AND_GET(
771: p_encoded => FND_API.G_FALSE
772: , p_count => x_msg_count
773: , p_data => x_msg_data
774: );
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: p_encoded => FND_API.G_FALSE
772: , p_count => x_msg_count
773: , p_data => x_msg_data
774: );
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO Delete_ozf_qp_product_pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.count_and_get(
779: p_encoded => FND_API.G_FALSE

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

773: , p_data => x_msg_data
774: );
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO Delete_ozf_qp_product_pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.count_and_get(
779: p_encoded => FND_API.G_FALSE
780: , p_count => x_msg_count
781: , p_data => x_msg_data

Line 779: p_encoded => FND_API.G_FALSE

775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO Delete_ozf_qp_product_pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.count_and_get(
779: p_encoded => FND_API.G_FALSE
780: , p_count => x_msg_count
781: , p_data => x_msg_data
782: );
783: WHEN OTHERS THEN

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: , p_data => x_msg_data
782: );
783: WHEN OTHERS THEN
784: ROLLBACK TO Delete_market_options_PVT;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;

Line 792: p_encoded => FND_API.G_FALSE,

788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796: