APPS.OZF_COPY_OFFER_PVT dependencies on FND_API

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

10:
11: PROCEDURE copy_vo_mkt_options
12: (
13: p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: , p_commit IN VARCHAR2 := FND_API.G_FALSE
16: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
17: , x_return_status OUT NOCOPY VARCHAR2
18: , x_msg_count OUT NOCOPY NUMBER

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

11: PROCEDURE copy_vo_mkt_options
12: (
13: p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: , p_commit IN VARCHAR2 := FND_API.G_FALSE
16: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
17: , x_return_status OUT NOCOPY VARCHAR2
18: , x_msg_count OUT NOCOPY NUMBER
19: , x_msg_data OUT NOCOPY VARCHAR2

Line 16: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

12: (
13: p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: , p_commit IN VARCHAR2 := FND_API.G_FALSE
16: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
17: , x_return_status OUT NOCOPY VARCHAR2
18: , x_msg_count OUT NOCOPY NUMBER
19: , x_msg_data OUT NOCOPY VARCHAR2
20: , p_sourceObjectId IN NUMBER

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: FROM ozf_offr_market_options
38: WHERE offer_id = cp_offerId;
39:
40: BEGIN
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: FOR l_destMktOptions IN c_destMktOptions(cp_offerId => p_destOfferId) LOOP
43: l_mo_rec.offer_market_option_id := l_destMktOptions.offer_market_option_id;
44: l_mo_rec.object_version_number := l_destMktOptions.object_version_number;
45: l_mo_rec.group_number := l_destMktOptions.group_number;

Line 58: , p_init_msg_list => FND_API.G_FALSE

54:
55:
56: OZF_offer_Market_Options_PVT.Update_market_options(
57: p_api_version_number => 1.0
58: , p_init_msg_list => FND_API.G_FALSE
59: , p_commit => FND_API.G_FALSE
60: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
61:
62: , x_return_status => x_return_status

Line 59: , p_commit => FND_API.G_FALSE

55:
56: OZF_offer_Market_Options_PVT.Update_market_options(
57: p_api_version_number => 1.0
58: , p_init_msg_list => FND_API.G_FALSE
59: , p_commit => FND_API.G_FALSE
60: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
61:
62: , x_return_status => x_return_status
63: , x_msg_count => x_msg_count

Line 60: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

56: OZF_offer_Market_Options_PVT.Update_market_options(
57: p_api_version_number => 1.0
58: , p_init_msg_list => FND_API.G_FALSE
59: , p_commit => FND_API.G_FALSE
60: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
61:
62: , x_return_status => x_return_status
63: , x_msg_count => x_msg_count
64: , x_msg_data => x_msg_data

Line 68: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

64: , x_msg_data => x_msg_data
65:
66: , p_mo_rec => l_mo_rec
67: );
68: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;

Line 69: RAISE FND_API.G_EXC_ERROR;

65:
66: , p_mo_rec => l_mo_rec
67: );
68: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:

Line 70: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

66: , p_mo_rec => l_mo_rec
67: );
68: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: END LOOP;

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: );
68: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: END LOOP;
75:

Line 77: WHEN Fnd_Api.G_EXC_ERROR THEN

73:
74: END LOOP;
75:
76: EXCEPTION
77: WHEN Fnd_Api.G_EXC_ERROR THEN
78: x_return_status := Fnd_Api.g_ret_sts_error;
79: ROLLBACK TO copy_vo_mkt_options;
80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
81: THEN

Line 78: x_return_status := Fnd_Api.g_ret_sts_error;

74: END LOOP;
75:
76: EXCEPTION
77: WHEN Fnd_Api.G_EXC_ERROR THEN
78: x_return_status := Fnd_Api.g_ret_sts_error;
79: ROLLBACK TO copy_vo_mkt_options;
80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
81: THEN
82: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 87: p_encoded => Fnd_Api.G_FALSE

83: END IF;
84: Fnd_Msg_Pub.Count_AND_Get
85: ( p_count => x_msg_count,
86: p_data => x_msg_data,
87: p_encoded => Fnd_Api.G_FALSE
88: );
89:
90: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 90: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

86: p_data => x_msg_data,
87: p_encoded => Fnd_Api.G_FALSE
88: );
89:
90: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
92: ROLLBACK TO copy_vo_mkt_options;
93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
94: THEN

Line 91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

87: p_encoded => Fnd_Api.G_FALSE
88: );
89:
90: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
92: ROLLBACK TO copy_vo_mkt_options;
93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
94: THEN
95: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 100: p_encoded => Fnd_Api.G_FALSE

96: END IF;
97: Fnd_Msg_Pub.Count_AND_Get
98: ( p_count => x_msg_count,
99: p_data => x_msg_data,
100: p_encoded => Fnd_Api.G_FALSE
101: );
102:
103: WHEN OTHERS THEN
104: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 104: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

100: p_encoded => Fnd_Api.G_FALSE
101: );
102:
103: WHEN OTHERS THEN
104: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
105: ROLLBACK TO copy_vo_mkt_options;
106: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
107: THEN
108: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 113: p_encoded => Fnd_Api.G_FALSE

109: END IF;
110: Fnd_Msg_Pub.Count_AND_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data,
113: p_encoded => Fnd_Api.G_FALSE
114: );
115:
116: END copy_vo_mkt_options;
117:

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

118:
119: PROCEDURE copy_vo_products
120: (
121: p_api_version IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
125: , x_return_status OUT NOCOPY VARCHAR2
126: , x_msg_count OUT NOCOPY NUMBER

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

119: PROCEDURE copy_vo_products
120: (
121: p_api_version IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
125: , x_return_status OUT NOCOPY VARCHAR2
126: , x_msg_count OUT NOCOPY NUMBER
127: , x_msg_data OUT NOCOPY VARCHAR2

Line 124: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

120: (
121: p_api_version IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
125: , x_return_status OUT NOCOPY VARCHAR2
126: , x_msg_count OUT NOCOPY NUMBER
127: , x_msg_data OUT NOCOPY VARCHAR2
128: , p_sourceTierHeaderId IN NUMBER

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

146: l_vo_prod_rec OZF_Volume_Offer_disc_PVT.vo_prod_rec_type;
147: BEGIN
148: -- initialize
149: SAVEPOINT copy_vo_products;
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: -- loop thru and create products
152: FOR l_products IN c_products(cp_sourceTierHeaderId => p_sourceTierHeaderId) LOOP
153: l_vo_prod_rec.excluder_flag := l_products.excluder_flag;
154: l_vo_prod_rec.offer_discount_line_id := p_destTierHeaderId;

Line 164: , p_init_msg_list => FND_API.G_FALSE

160: l_vo_prod_rec.include_volume_flag := l_products.include_volume_flag;
161:
162: OZF_Volume_Offer_disc_PVT.Create_vo_product(
163: p_api_version_number => 1.0
164: , p_init_msg_list => FND_API.G_FALSE
165: , p_commit => FND_API.G_FALSE
166: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
167:
168: , x_return_status => x_return_status

Line 165: , p_commit => FND_API.G_FALSE

161:
162: OZF_Volume_Offer_disc_PVT.Create_vo_product(
163: p_api_version_number => 1.0
164: , p_init_msg_list => FND_API.G_FALSE
165: , p_commit => FND_API.G_FALSE
166: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
167:
168: , x_return_status => x_return_status
169: , x_msg_count => x_msg_count

Line 166: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

162: OZF_Volume_Offer_disc_PVT.Create_vo_product(
163: p_api_version_number => 1.0
164: , p_init_msg_list => FND_API.G_FALSE
165: , p_commit => FND_API.G_FALSE
166: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
167:
168: , x_return_status => x_return_status
169: , x_msg_count => x_msg_count
170: , x_msg_data => x_msg_data

Line 176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

172: , p_vo_prod_rec => l_vo_prod_rec
173: , x_off_discount_product_id => l_productId
174: );
175:
176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;

Line 177: RAISE FND_API.G_EXC_ERROR;

173: , x_off_discount_product_id => l_productId
174: );
175:
176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:

Line 178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

174: );
175:
176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: END LOOP;

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175:
176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: END LOOP;
183:

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

186:
187: PROCEDURE copy_vo_qualifiers
188: (
189: p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER

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

187: PROCEDURE copy_vo_qualifiers
188: (
189: p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER
195: , x_msg_data OUT NOCOPY VARCHAR2

Line 192: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

188: (
189: p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER
195: , x_msg_data OUT NOCOPY VARCHAR2
196: , p_destListHeaderId IN NUMBER

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: l_api_name CONSTANT VARCHAR2(30) := 'copy_vo_qualifiers';
233: BEGIN
234: -- initialize
235: SAVEPOINT copy_vo_qualifiers;
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: -- loop thru and create qualifiers
238: FOR l_qualifiers IN c_qualifiers(cp_listHeaderId => p_sourceListHeaderId) LOOP
239:
240: l_qualifiers_rec.qualifier_context := l_qualifiers.qualifier_context;

Line 271: , p_init_msg_list => FND_API.G_FALSE

267:
268: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier
269: (
270: p_api_version_number => 1.0
271: , p_init_msg_list => FND_API.G_FALSE
272: , p_commit => FND_API.G_FALSE
273: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
274:
275: , x_return_status => x_return_status

Line 272: , p_commit => FND_API.G_FALSE

268: OZF_Volume_Offer_Qual_PVT.create_vo_qualifier
269: (
270: p_api_version_number => 1.0
271: , p_init_msg_list => FND_API.G_FALSE
272: , p_commit => FND_API.G_FALSE
273: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
274:
275: , x_return_status => x_return_status
276: , x_msg_count => x_msg_count

Line 273: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

269: (
270: p_api_version_number => 1.0
271: , p_init_msg_list => FND_API.G_FALSE
272: , p_commit => FND_API.G_FALSE
273: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
274:
275: , x_return_status => x_return_status
276: , x_msg_count => x_msg_count
277: , x_msg_data => x_msg_data

Line 281: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

277: , x_msg_data => x_msg_data
278:
279: , p_qualifiers_rec => l_qualifiers_rec
280: );
281: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;

Line 282: RAISE FND_API.G_EXC_ERROR;

278:
279: , p_qualifiers_rec => l_qualifiers_rec
280: );
281: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:

Line 283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

279: , p_qualifiers_rec => l_qualifiers_rec
280: );
281: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: END LOOP;

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: );
281: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: END LOOP;
288:

Line 291: WHEN Fnd_Api.G_EXC_ERROR THEN

287: END LOOP;
288:
289: EXCEPTION
290:
291: WHEN Fnd_Api.G_EXC_ERROR THEN
292: x_return_status := Fnd_Api.g_ret_sts_error;
293: ROLLBACK TO copy_vo_qualifiers;
294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
295: THEN

Line 292: x_return_status := Fnd_Api.g_ret_sts_error;

288:
289: EXCEPTION
290:
291: WHEN Fnd_Api.G_EXC_ERROR THEN
292: x_return_status := Fnd_Api.g_ret_sts_error;
293: ROLLBACK TO copy_vo_qualifiers;
294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
295: THEN
296: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 301: p_encoded => Fnd_Api.G_FALSE

297: END IF;
298: Fnd_Msg_Pub.Count_AND_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => Fnd_Api.G_FALSE
302: );
303:
304: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 304: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

300: p_data => x_msg_data,
301: p_encoded => Fnd_Api.G_FALSE
302: );
303:
304: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
306: ROLLBACK TO copy_vo_qualifiers;
307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
308: THEN

Line 305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

301: p_encoded => Fnd_Api.G_FALSE
302: );
303:
304: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
306: ROLLBACK TO copy_vo_qualifiers;
307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
308: THEN
309: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 314: p_encoded => Fnd_Api.G_FALSE

310: END IF;
311: Fnd_Msg_Pub.Count_AND_Get
312: ( p_count => x_msg_count,
313: p_data => x_msg_data,
314: p_encoded => Fnd_Api.G_FALSE
315: );
316:
317: WHEN OTHERS THEN
318: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 318: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

314: p_encoded => Fnd_Api.G_FALSE
315: );
316:
317: WHEN OTHERS THEN
318: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
319: ROLLBACK TO copy_vo_qualifiers;
320: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
321: THEN
322: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 327: p_encoded => Fnd_Api.G_FALSE

323: END IF;
324: Fnd_Msg_Pub.Count_AND_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => Fnd_Api.G_FALSE
328: );
329:
330: -- exception
331: END copy_vo_qualifiers;

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

334:
335: PROCEDURE copy_vo_tiers
336: (
337: p_api_version IN NUMBER
338: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
339: , p_commit IN VARCHAR2 := FND_API.G_FALSE
340: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
341: , x_return_status OUT NOCOPY VARCHAR2
342: , x_msg_count OUT NOCOPY NUMBER

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

335: PROCEDURE copy_vo_tiers
336: (
337: p_api_version IN NUMBER
338: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
339: , p_commit IN VARCHAR2 := FND_API.G_FALSE
340: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
341: , x_return_status OUT NOCOPY VARCHAR2
342: , x_msg_count OUT NOCOPY NUMBER
343: , x_msg_data OUT NOCOPY VARCHAR2

Line 340: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

336: (
337: p_api_version IN NUMBER
338: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
339: , p_commit IN VARCHAR2 := FND_API.G_FALSE
340: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
341: , x_return_status OUT NOCOPY VARCHAR2
342: , x_msg_count OUT NOCOPY NUMBER
343: , x_msg_data OUT NOCOPY VARCHAR2
344: , p_sourceTierHeaderId IN NUMBER

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

365:
366: BEGIN
367: -- initialize
368: SAVEPOINT copy_vo_tiers;
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370: -- loop thru and populate discounts
371: -- create tiers
372: FOR l_tiers IN c_tiers(cp_parentDiscountId => p_sourceTierHeaderId) LOOP
373: l_vo_disc_rec.offer_id := p_destOfferId;

Line 386: , p_init_msg_list => FND_API.G_FALSE

382: l_vo_disc_rec.tier_level := l_tiers.tier_level;
383:
384: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
385: p_api_version_number => 1.0
386: , p_init_msg_list => FND_API.G_FALSE
387: , p_commit => FND_API.G_FALSE
388: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
389:
390: , x_return_status => x_return_status

Line 387: , p_commit => FND_API.G_FALSE

383:
384: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
385: p_api_version_number => 1.0
386: , p_init_msg_list => FND_API.G_FALSE
387: , p_commit => FND_API.G_FALSE
388: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
389:
390: , x_return_status => x_return_status
391: , x_msg_count => x_msg_count

Line 388: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

384: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
385: p_api_version_number => 1.0
386: , p_init_msg_list => FND_API.G_FALSE
387: , p_commit => FND_API.G_FALSE
388: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
389:
390: , x_return_status => x_return_status
391: , x_msg_count => x_msg_count
392: , x_msg_data => x_msg_data

Line 397: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

393:
394: , p_vo_disc_rec => l_vo_disc_rec
395: , x_vo_discount_line_id => l_discountLineId
396: );
397: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;

Line 398: RAISE FND_API.G_EXC_ERROR;

394: , p_vo_disc_rec => l_vo_disc_rec
395: , x_vo_discount_line_id => l_discountLineId
396: );
397: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:

Line 399: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

395: , x_vo_discount_line_id => l_discountLineId
396: );
397: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: ozf_utility_pvt.debug_message('Discount LineId created is: '||l_discountLineId);

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: );
397: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: ozf_utility_pvt.debug_message('Discount LineId created is: '||l_discountLineId);
404:

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

411:
412: PROCEDURE copy_vo_discounts
413: (
414: p_api_version IN NUMBER
415: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
416: , p_commit IN VARCHAR2 := FND_API.G_FALSE
417: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
418: , x_return_status OUT NOCOPY VARCHAR2
419: , x_msg_count OUT NOCOPY NUMBER

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

412: PROCEDURE copy_vo_discounts
413: (
414: p_api_version IN NUMBER
415: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
416: , p_commit IN VARCHAR2 := FND_API.G_FALSE
417: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
418: , x_return_status OUT NOCOPY VARCHAR2
419: , x_msg_count OUT NOCOPY NUMBER
420: , x_msg_data OUT NOCOPY VARCHAR2

Line 417: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

413: (
414: p_api_version IN NUMBER
415: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
416: , p_commit IN VARCHAR2 := FND_API.G_FALSE
417: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
418: , x_return_status OUT NOCOPY VARCHAR2
419: , x_msg_count OUT NOCOPY NUMBER
420: , x_msg_data OUT NOCOPY VARCHAR2
421: , p_sourceObjectId IN NUMBER

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: l_sourceOfferId NUMBER := null;
450: BEGIN
451: -- initialize
452: SAVEPOINT copy_vo_discounts;
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454: l_sourceOfferId := null;
455:
456: OPEN c_offerId(cp_listHeaderId => p_sourceObjectId);
457: FETCH c_offerId INTO l_sourceOfferId;

Line 460: RAISE FND_API.G_EXC_ERROR;

456: OPEN c_offerId(cp_listHeaderId => p_sourceObjectId);
457: FETCH c_offerId INTO l_sourceOfferId;
458: IF c_offerId%NOTFOUND THEN
459: OZF_Utility_PVT.Error_Message('OZF_OFFR_CPY_NO_OFFER');
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462: CLOSE c_offerId;
463:
464:

Line 480: , p_init_msg_list => FND_API.G_FALSE

476:
477: ozf_utility_pvt.debug_message('Calling create PBH disc');
478: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
479: p_api_version_number => 1.0
480: , p_init_msg_list => FND_API.G_FALSE
481: , p_commit => FND_API.G_FALSE
482: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
483:
484: , x_return_status => x_return_status

Line 481: , p_commit => FND_API.G_FALSE

477: ozf_utility_pvt.debug_message('Calling create PBH disc');
478: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
479: p_api_version_number => 1.0
480: , p_init_msg_list => FND_API.G_FALSE
481: , p_commit => FND_API.G_FALSE
482: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
483:
484: , x_return_status => x_return_status
485: , x_msg_count => x_msg_count

Line 482: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

478: OZF_Volume_Offer_disc_PVT.Create_vo_discount(
479: p_api_version_number => 1.0
480: , p_init_msg_list => FND_API.G_FALSE
481: , p_commit => FND_API.G_FALSE
482: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
483:
484: , x_return_status => x_return_status
485: , x_msg_count => x_msg_count
486: , x_msg_data => x_msg_data

Line 494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

490: );
491:
492: ozf_utility_pvt.debug_message('PBH Id is:'||l_discountLineId);
493:
494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;

Line 495: RAISE FND_API.G_EXC_ERROR;

491:
492: ozf_utility_pvt.debug_message('PBH Id is:'||l_discountLineId);
493:
494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:

Line 496: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

492: ozf_utility_pvt.debug_message('PBH Id is:'||l_discountLineId);
493:
494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: -- create discounts

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493:
494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: -- create discounts
501: copy_vo_tiers

Line 504: , p_init_msg_list => FND_API.G_FALSE

500: -- create discounts
501: copy_vo_tiers
502: (
503: p_api_version => 1.0
504: , p_init_msg_list => FND_API.G_FALSE
505: , p_commit => FND_API.G_FALSE
506: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
507: , x_return_status => x_return_status
508: , x_msg_count => x_msg_count

Line 505: , p_commit => FND_API.G_FALSE

501: copy_vo_tiers
502: (
503: p_api_version => 1.0
504: , p_init_msg_list => FND_API.G_FALSE
505: , p_commit => FND_API.G_FALSE
506: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
507: , x_return_status => x_return_status
508: , x_msg_count => x_msg_count
509: , x_msg_data => x_msg_data

Line 506: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

502: (
503: p_api_version => 1.0
504: , p_init_msg_list => FND_API.G_FALSE
505: , p_commit => FND_API.G_FALSE
506: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
507: , x_return_status => x_return_status
508: , x_msg_count => x_msg_count
509: , x_msg_data => x_msg_data
510: , p_sourceTierHeaderId => l_pbh.offer_discount_line_id

Line 514: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

510: , p_sourceTierHeaderId => l_pbh.offer_discount_line_id
511: , p_destTierHeaderId => l_discountLineId
512: , p_destOfferId => p_destOfferId
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_destTierHeaderId => l_discountLineId
512: , p_destOfferId => p_destOfferId
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: ozf_utility_pvt.debug_message('Discount Tier created is:'||l_discountLineId);

Line 516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

512: , p_destOfferId => p_destOfferId
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: ozf_utility_pvt.debug_message('Discount Tier created is:'||l_discountLineId);
520:

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: ozf_utility_pvt.debug_message('Discount Tier created is:'||l_discountLineId);
520:
521: -- create products

Line 525: , p_init_msg_list => FND_API.G_FALSE

521: -- create products
522: copy_vo_products
523: (
524: p_api_version => 1.0
525: , p_init_msg_list => FND_API.G_FALSE
526: , p_commit => FND_API.G_FALSE
527: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
528: , x_return_status => x_return_status
529: , x_msg_count => x_msg_count

Line 526: , p_commit => FND_API.G_FALSE

522: copy_vo_products
523: (
524: p_api_version => 1.0
525: , p_init_msg_list => FND_API.G_FALSE
526: , p_commit => FND_API.G_FALSE
527: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
528: , x_return_status => x_return_status
529: , x_msg_count => x_msg_count
530: , x_msg_data => x_msg_data

Line 527: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

523: (
524: p_api_version => 1.0
525: , p_init_msg_list => FND_API.G_FALSE
526: , p_commit => FND_API.G_FALSE
527: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
528: , x_return_status => x_return_status
529: , x_msg_count => x_msg_count
530: , x_msg_data => x_msg_data
531: , p_sourceTierHeaderId => l_pbh.offer_discount_line_id

Line 535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

531: , p_sourceTierHeaderId => l_pbh.offer_discount_line_id
532: , p_destTierHeaderId => l_discountLineId
533: , p_destOfferId => p_destOfferId
534: );
535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;

Line 536: RAISE FND_API.G_EXC_ERROR;

532: , p_destTierHeaderId => l_discountLineId
533: , p_destOfferId => p_destOfferId
534: );
535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:

Line 537: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

533: , p_destOfferId => p_destOfferId
534: );
535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:
541: END LOOP;

Line 538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

534: );
535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
536: RAISE FND_API.G_EXC_ERROR;
537: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:
541: END LOOP;
542:

Line 546: WHEN Fnd_Api.G_EXC_ERROR THEN

542:
543:
544: EXCEPTION
545:
546: WHEN Fnd_Api.G_EXC_ERROR THEN
547: x_return_status := Fnd_Api.g_ret_sts_error;
548: ROLLBACK TO copy_vo_discounts;
549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
550: THEN

Line 547: x_return_status := Fnd_Api.g_ret_sts_error;

543:
544: EXCEPTION
545:
546: WHEN Fnd_Api.G_EXC_ERROR THEN
547: x_return_status := Fnd_Api.g_ret_sts_error;
548: ROLLBACK TO copy_vo_discounts;
549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
550: THEN
551: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 556: p_encoded => Fnd_Api.G_FALSE

552: END IF;
553: Fnd_Msg_Pub.Count_AND_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data,
556: p_encoded => Fnd_Api.G_FALSE
557: );
558:
559: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 559: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

555: p_data => x_msg_data,
556: p_encoded => Fnd_Api.G_FALSE
557: );
558:
559: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
561: ROLLBACK TO copy_vo_discounts;
562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
563: THEN

Line 560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

556: p_encoded => Fnd_Api.G_FALSE
557: );
558:
559: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
561: ROLLBACK TO copy_vo_discounts;
562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
563: THEN
564: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 569: p_encoded => Fnd_Api.G_FALSE

565: END IF;
566: Fnd_Msg_Pub.Count_AND_Get
567: ( p_count => x_msg_count,
568: p_data => x_msg_data,
569: p_encoded => Fnd_Api.G_FALSE
570: );
571:
572: WHEN OTHERS THEN
573: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 573: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

569: p_encoded => Fnd_Api.G_FALSE
570: );
571:
572: WHEN OTHERS THEN
573: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
574: ROLLBACK TO copy_vo_discounts;
575: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
576: THEN
577: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 582: p_encoded => Fnd_Api.G_FALSE

578: END IF;
579: Fnd_Msg_Pub.Count_AND_Get
580: ( p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => Fnd_Api.G_FALSE
583: );
584:
585: -- loop thru source discounts
586: -- create pbh

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

592:
593: PROCEDURE copy_vo_preset_tiers
594: (
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: , p_commit IN VARCHAR2 := FND_API.G_FALSE
598: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
599: , x_return_status OUT NOCOPY VARCHAR2
600: , x_msg_count OUT NOCOPY NUMBER

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

593: PROCEDURE copy_vo_preset_tiers
594: (
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: , p_commit IN VARCHAR2 := FND_API.G_FALSE
598: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
599: , x_return_status OUT NOCOPY VARCHAR2
600: , x_msg_count OUT NOCOPY NUMBER
601: , x_msg_data OUT NOCOPY VARCHAR2

Line 598: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

594: (
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: , p_commit IN VARCHAR2 := FND_API.G_FALSE
598: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
599: , x_return_status OUT NOCOPY VARCHAR2
600: , x_msg_count OUT NOCOPY NUMBER
601: , x_msg_data OUT NOCOPY VARCHAR2
602: , p_sourceObjectId IN NUMBER

Line 610: x_return_status := FND_API.G_RET_STS_SUCCESS;

606: l_api_name CONSTANT VARCHAR2(30) := 'copy_vo_preset_tiers';
607: l_api_version_number CONSTANT NUMBER := 1.0;
608: BEGIN
609: -- initialize
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: -- loop thru. and copy the preset tiers for source object
612: /*l_preset_tier_rec.offer_market_option_id := 101000;
613: l_preset_tier_rec.pbh_offer_discount_id := 7001;
614: l_preset_tier_rec.dis_offer_discount_id := 7002;*/

Line 617: , p_init_msg_list => FND_API.G_FALSE

613: l_preset_tier_rec.pbh_offer_discount_id := 7001;
614: l_preset_tier_rec.dis_offer_discount_id := 7002;*/
615: /*OZF_MO_PRESET_TIERS_PVT.Create_mo_preset_tiers(
616: p_api_version_number => 1.0
617: , p_init_msg_list => FND_API.G_FALSE
618: , p_commit => FND_API.G_FALSE
619: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
620:
621: , x_return_status => x_return_status

Line 618: , p_commit => FND_API.G_FALSE

614: l_preset_tier_rec.dis_offer_discount_id := 7002;*/
615: /*OZF_MO_PRESET_TIERS_PVT.Create_mo_preset_tiers(
616: p_api_version_number => 1.0
617: , p_init_msg_list => FND_API.G_FALSE
618: , p_commit => FND_API.G_FALSE
619: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
620:
621: , x_return_status => x_return_status
622: , x_msg_count => x_msg_count

Line 619: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

615: /*OZF_MO_PRESET_TIERS_PVT.Create_mo_preset_tiers(
616: p_api_version_number => 1.0
617: , p_init_msg_list => FND_API.G_FALSE
618: , p_commit => FND_API.G_FALSE
619: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
620:
621: , x_return_status => x_return_status
622: , x_msg_count => x_msg_count
623: , x_msg_data => x_msg_data

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

631:
632:
633: PROCEDURE copy_vo_header(
634: p_api_version IN NUMBER
635: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
636: , p_commit IN VARCHAR2 := FND_API.G_FALSE
637: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
638: , x_return_status OUT NOCOPY VARCHAR2
639: , x_msg_count OUT NOCOPY NUMBER

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

632:
633: PROCEDURE copy_vo_header(
634: p_api_version IN NUMBER
635: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
636: , p_commit IN VARCHAR2 := FND_API.G_FALSE
637: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
638: , x_return_status OUT NOCOPY VARCHAR2
639: , x_msg_count OUT NOCOPY NUMBER
640: , x_msg_data OUT NOCOPY VARCHAR2

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

633: PROCEDURE copy_vo_header(
634: p_api_version IN NUMBER
635: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
636: , p_commit IN VARCHAR2 := FND_API.G_FALSE
637: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
638: , x_return_status OUT NOCOPY VARCHAR2
639: , x_msg_count OUT NOCOPY NUMBER
640: , x_msg_data OUT NOCOPY VARCHAR2
641: , p_listHeaderId IN NUMBER

Line 714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

710: BEGIN
711: -- establish save point
712: SAVEPOINT copy_vo_header;
713: -- check api version compatibility
714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
715: p_api_version,
716: l_api_name,
717: G_PKG_NAME)
718: THEN

Line 719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

715: p_api_version,
716: l_api_name,
717: G_PKG_NAME)
718: THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 723: IF FND_API.to_Boolean( p_init_msg_list ) THEN

719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF FND_API.to_Boolean( p_init_msg_list ) THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize API return status to SUCCESS

Line 728: x_return_status := FND_API.G_RET_STS_SUCCESS;

724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize API return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: -- initialize the record sent to api for creation
731: l_modifier_list_rec := null;
732:

Line 775: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;

771: l_modifier_list_rec.orig_org_id := l_offer_details.orig_org_id;
772: l_modifier_list_rec.modifier_operation := G_CREATE;
773: l_modifier_list_rec.offer_operation := G_CREATE;
774:
775: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
776: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
777: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
778: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
779:

Line 776: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;

772: l_modifier_list_rec.modifier_operation := G_CREATE;
773: l_modifier_list_rec.offer_operation := G_CREATE;
774:
775: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
776: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
777: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
778: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
779:
780:

Line 777: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;

773: l_modifier_list_rec.offer_operation := G_CREATE;
774:
775: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
776: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
777: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
778: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
779:
780:
781: l_modifier_list_rec.context := l_offer_details.context;

Line 778: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;

774:
775: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
776: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
777: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
778: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
779:
780:
781: l_modifier_list_rec.context := l_offer_details.context;
782: l_modifier_list_rec.attribute1 := l_offer_details.attribute1;

Line 803: p_init_msg_list => FND_API.G_FALSE

799:
800: -- call api to create new header
801: OZF_OFFER_PVT.process_modifiers
802: (
803: p_init_msg_list => FND_API.G_FALSE
804: ,p_api_version => 1.0
805: ,p_commit => FND_API.G_FALSE
806: ,x_return_status => x_return_status
807: ,x_msg_count => x_msg_count

Line 805: ,p_commit => FND_API.G_FALSE

801: OZF_OFFER_PVT.process_modifiers
802: (
803: p_init_msg_list => FND_API.G_FALSE
804: ,p_api_version => 1.0
805: ,p_commit => FND_API.G_FALSE
806: ,x_return_status => x_return_status
807: ,x_msg_count => x_msg_count
808: ,x_msg_data => x_msg_data
809: ,p_offer_type => l_offer_type

Line 815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

811: ,p_modifier_line_tbl => l_modifier_line_tbl
812: ,x_qp_list_header_id => l_listHeaderId
813: ,x_error_location => l_errLoc
814: );
815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: ,x_qp_list_header_id => l_listHeaderId
813: ,x_error_location => l_errLoc
814: );
815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:

Line 817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

813: ,x_error_location => l_errLoc
814: );
815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: l_offer_id := null;

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814: );
815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: l_offer_id := null;
822:

Line 833: , p_init_msg_list => FND_API.G_FALSE

829:
830: copy_vo_discounts
831: (
832: p_api_version => 1.0
833: , p_init_msg_list => FND_API.G_FALSE
834: , p_commit => FND_API.G_FALSE
835: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
836: , x_return_status => x_return_status
837: , x_msg_count => x_msg_count

Line 834: , p_commit => FND_API.G_FALSE

830: copy_vo_discounts
831: (
832: p_api_version => 1.0
833: , p_init_msg_list => FND_API.G_FALSE
834: , p_commit => FND_API.G_FALSE
835: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
836: , x_return_status => x_return_status
837: , x_msg_count => x_msg_count
838: , x_msg_data => x_msg_data

Line 835: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

831: (
832: p_api_version => 1.0
833: , p_init_msg_list => FND_API.G_FALSE
834: , p_commit => FND_API.G_FALSE
835: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
836: , x_return_status => x_return_status
837: , x_msg_count => x_msg_count
838: , x_msg_data => x_msg_data
839: , p_sourceObjectId => p_listHeaderId

Line 842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

838: , x_msg_data => x_msg_data
839: , p_sourceObjectId => p_listHeaderId
840: , p_destOfferId => l_offer_id
841: );
842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;

Line 843: RAISE FND_API.G_EXC_ERROR;

839: , p_sourceObjectId => p_listHeaderId
840: , p_destOfferId => l_offer_id
841: );
842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:

Line 844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

840: , p_destOfferId => l_offer_id
841: );
842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848: -- copy qualifiers

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: );
842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
843: RAISE FND_API.G_EXC_ERROR;
844: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848: -- copy qualifiers
849: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

Line 849: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848: -- copy qualifiers
849: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
850: ozf_utility_pvt.debug_message('Copy Eligibility');
851: copy_vo_qualifiers
852: (
853: p_api_version => 1.0

Line 854: , p_init_msg_list => FND_API.G_FALSE

850: ozf_utility_pvt.debug_message('Copy Eligibility');
851: copy_vo_qualifiers
852: (
853: p_api_version => 1.0
854: , p_init_msg_list => FND_API.G_FALSE
855: , p_commit => FND_API.G_FALSE
856: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
857: , x_return_status => x_return_status
858: , x_msg_count => x_msg_count

Line 855: , p_commit => FND_API.G_FALSE

851: copy_vo_qualifiers
852: (
853: p_api_version => 1.0
854: , p_init_msg_list => FND_API.G_FALSE
855: , p_commit => FND_API.G_FALSE
856: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
857: , x_return_status => x_return_status
858: , x_msg_count => x_msg_count
859: , x_msg_data => x_msg_data

Line 856: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

852: (
853: p_api_version => 1.0
854: , p_init_msg_list => FND_API.G_FALSE
855: , p_commit => FND_API.G_FALSE
856: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
857: , x_return_status => x_return_status
858: , x_msg_count => x_msg_count
859: , x_msg_data => x_msg_data
860: , p_sourceListHeaderId => p_listHeaderId

Line 863: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

859: , x_msg_data => x_msg_data
860: , p_sourceListHeaderId => p_listHeaderId
861: , p_destListHeaderId => l_listHeaderId
862: );
863: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
864: RAISE FND_API.G_EXC_ERROR;
865: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;

Line 864: RAISE FND_API.G_EXC_ERROR;

860: , p_sourceListHeaderId => p_listHeaderId
861: , p_destListHeaderId => l_listHeaderId
862: );
863: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
864: RAISE FND_API.G_EXC_ERROR;
865: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: -- copy market options

Line 865: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

861: , p_destListHeaderId => l_listHeaderId
862: );
863: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
864: RAISE FND_API.G_EXC_ERROR;
865: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: -- copy market options
869: -- market options are created with default options, so update the market options to the ones in the source offer

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

862: );
863: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
864: RAISE FND_API.G_EXC_ERROR;
865: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: -- copy market options
869: -- market options are created with default options, so update the market options to the ones in the source offer
870: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN

Line 870: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN

866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: -- copy market options
869: -- market options are created with default options, so update the market options to the ones in the source offer
870: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN
871: ozf_utility_pvt.debug_message('Copy Market Options');
872: copy_vo_mkt_options
873: (
874: p_api_version => 1.0

Line 875: , p_init_msg_list => FND_API.G_FALSE

871: ozf_utility_pvt.debug_message('Copy Market Options');
872: copy_vo_mkt_options
873: (
874: p_api_version => 1.0
875: , p_init_msg_list => FND_API.G_FALSE
876: , p_commit => FND_API.G_FALSE
877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
878: , x_return_status => x_return_status
879: , x_msg_count => x_msg_count

Line 876: , p_commit => FND_API.G_FALSE

872: copy_vo_mkt_options
873: (
874: p_api_version => 1.0
875: , p_init_msg_list => FND_API.G_FALSE
876: , p_commit => FND_API.G_FALSE
877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
878: , x_return_status => x_return_status
879: , x_msg_count => x_msg_count
880: , x_msg_data => x_msg_data

Line 877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

873: (
874: p_api_version => 1.0
875: , p_init_msg_list => FND_API.G_FALSE
876: , p_commit => FND_API.G_FALSE
877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
878: , x_return_status => x_return_status
879: , x_msg_count => x_msg_count
880: , x_msg_data => x_msg_data
881: , p_sourceObjectId => p_listHeaderId

Line 885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

881: , p_sourceObjectId => p_listHeaderId
882: , p_destOfferId => l_offer_id
883: );
884:
885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;

Line 886: RAISE FND_API.G_EXC_ERROR;

882: , p_destOfferId => l_offer_id
883: );
884:
885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: END IF;

Line 887: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

883: );
884:
885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: END IF;
891: END IF;

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

884:
885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: END IF;
891: END IF;
892:

Line 901: WHEN Fnd_Api.G_EXC_ERROR THEN

897: x_listHeaderId := l_listHeaderId;
898: -- exception
899: EXCEPTION
900:
901: WHEN Fnd_Api.G_EXC_ERROR THEN
902: x_return_status := Fnd_Api.g_ret_sts_error;
903: ROLLBACK TO copy_vo_header;
904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
905: THEN

Line 902: x_return_status := Fnd_Api.g_ret_sts_error;

898: -- exception
899: EXCEPTION
900:
901: WHEN Fnd_Api.G_EXC_ERROR THEN
902: x_return_status := Fnd_Api.g_ret_sts_error;
903: ROLLBACK TO copy_vo_header;
904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
905: THEN
906: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 911: p_encoded => Fnd_Api.G_FALSE

907: END IF;
908: Fnd_Msg_Pub.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
911: p_encoded => Fnd_Api.G_FALSE
912: );
913:
914: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 914: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

910: p_data => x_msg_data,
911: p_encoded => Fnd_Api.G_FALSE
912: );
913:
914: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
916: ROLLBACK TO copy_vo_header;
917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
918: THEN

Line 915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

911: p_encoded => Fnd_Api.G_FALSE
912: );
913:
914: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
916: ROLLBACK TO copy_vo_header;
917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
918: THEN
919: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 924: p_encoded => Fnd_Api.G_FALSE

920: END IF;
921: Fnd_Msg_Pub.Count_AND_Get
922: ( p_count => x_msg_count,
923: p_data => x_msg_data,
924: p_encoded => Fnd_Api.G_FALSE
925: );
926:
927: WHEN OTHERS THEN
928: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 928: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

924: p_encoded => Fnd_Api.G_FALSE
925: );
926:
927: WHEN OTHERS THEN
928: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
929: ROLLBACK TO copy_vo_header;
930: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 937: p_encoded => Fnd_Api.G_FALSE

933: END IF;
934: Fnd_Msg_Pub.Count_AND_Get
935: ( p_count => x_msg_count,
936: p_data => x_msg_data,
937: p_encoded => Fnd_Api.G_FALSE
938: );
939:
940: END copy_vo_header;
941:

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

1527:
1528:
1529: PROCEDURE copy_offer_detail(
1530: p_api_version IN NUMBER,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1534: x_return_status OUT NOCOPY VARCHAR2,
1535: x_msg_count OUT NOCOPY NUMBER,

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

1528:
1529: PROCEDURE copy_offer_detail(
1530: p_api_version IN NUMBER,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1534: x_return_status OUT NOCOPY VARCHAR2,
1535: x_msg_count OUT NOCOPY NUMBER,
1536: x_msg_data OUT NOCOPY VARCHAR2,

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

1529: PROCEDURE copy_offer_detail(
1530: p_api_version IN NUMBER,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1534: x_return_status OUT NOCOPY VARCHAR2,
1535: x_msg_count OUT NOCOPY NUMBER,
1536: x_msg_data OUT NOCOPY VARCHAR2,
1537: p_source_object_id IN NUMBER,

Line 1720: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1716: -- Standard Start of API savepoint
1717: SAVEPOINT copy_offer_detail;
1718:
1719: -- Standard call to check for call compatibility.
1720: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1721: p_api_version,
1722: l_api_name,
1723: G_PKG_NAME)
1724: THEN

Line 1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1721: p_api_version,
1722: l_api_name,
1723: G_PKG_NAME)
1724: THEN
1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: END IF;
1727:
1728: -- Initialize message list if p_init_msg_list is set to TRUE.
1729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: END IF;
1727:
1728: -- Initialize message list if p_init_msg_list is set to TRUE.
1729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1730: FND_MSG_PUB.initialize;
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS

Line 1734: x_return_status := FND_API.G_RET_STS_SUCCESS;

1730: FND_MSG_PUB.initialize;
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: OPEN c_offer_detail;
1737: FETCH c_offer_detail INTO l_offer_rec;
1738: CLOSE c_offer_detail;

Line 1753: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN

1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1750:
1751: -- bug fix 2779988: validate start date and end date
1752: IF l_modifier_list_rec.start_date_active IS NOT NULL
1753: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1754: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1755: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1756: Fnd_Msg_Pub.ADD;
1757: RAISE FND_API.G_EXC_ERROR;

Line 1757: RAISE FND_API.G_EXC_ERROR;

1753: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1754: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1755: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1756: Fnd_Msg_Pub.ADD;
1757: RAISE FND_API.G_EXC_ERROR;
1758: END IF;
1759: END IF; -- end validation start date if
1760:
1761: IF l_modifier_list_rec.end_date_active IS NOT NULL

Line 1762: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN

1758: END IF;
1759: END IF; -- end validation start date if
1760:
1761: IF l_modifier_list_rec.end_date_active IS NOT NULL
1762: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1763: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1764: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1765: Fnd_Msg_Pub.ADD;
1766: RAISE FND_API.G_EXC_ERROR;

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1763: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1764: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1765: Fnd_Msg_Pub.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768: END IF; -- end end date validation if
1769:
1770: IF l_offer_rec.offer_type IN ('SCAN_DATA', 'NET_ACCRUAL') OR (l_offer_rec.offer_type = 'LUMPSUM' AND l_offer_rec.custom_setup_id <> 110) THEN -- not applicable to soft fund

Line 1773: RAISE FND_API.G_EXC_ERROR;

1769:
1770: IF l_offer_rec.offer_type IN ('SCAN_DATA', 'NET_ACCRUAL') OR (l_offer_rec.offer_type = 'LUMPSUM' AND l_offer_rec.custom_setup_id <> 110) THEN -- not applicable to soft fund
1771: IF l_modifier_list_rec.start_date_active IS NULL THEN
1772: ozf_utility_pvt.error_message('OZF_OFFR_NO_START_DATE');
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775: END IF; -- end scan data lumpsum start date validation if
1776:
1777: IF l_modifier_list_rec.start_date_active IS NOT NULL

Line 1778: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE

1774: END IF;
1775: END IF; -- end scan data lumpsum start date validation if
1776:
1777: IF l_modifier_list_rec.start_date_active IS NOT NULL
1778: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE
1779: AND l_modifier_list_rec.end_date_active IS NOT NULL
1780: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1781: THEN
1782: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN

Line 1780: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE

1776:
1777: IF l_modifier_list_rec.start_date_active IS NOT NULL
1778: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE
1779: AND l_modifier_list_rec.end_date_active IS NOT NULL
1780: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1781: THEN
1782: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1783: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1784: Fnd_Msg_Pub.ADD;

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: THEN
1782: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1783: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1784: Fnd_Msg_Pub.ADD;
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787: END IF; -- end start date before end date validation
1788:
1789: -- validate source code

Line 1790: IF l_offer_rec.offer_code IS NULL OR l_offer_rec.offer_code = FND_API.G_MISS_CHAR THEN

1786: END IF;
1787: END IF; -- end start date before end date validation
1788:
1789: -- validate source code
1790: IF l_offer_rec.offer_code IS NULL OR l_offer_rec.offer_code = FND_API.G_MISS_CHAR THEN
1791: LOOP
1792: l_count_ozf_code := 0;
1793: l_count_qp_code := 0;
1794:

Line 1798: p_global_flag => Fnd_Api.g_false

1794:
1795: l_offer_rec.offer_code := Ams_Sourcecode_Pvt.get_new_source_code (
1796: p_object_type => 'OFFR',
1797: p_custsetup_id => l_offer_rec.custom_setup_id,
1798: p_global_flag => Fnd_Api.g_false
1799: );
1800:
1801: OPEN c_count_ozf_code(l_offer_rec.offer_code);
1802: FETCH c_count_ozf_code INTO l_count_ozf_code;

Line 1828: RAISE FND_API.G_EXC_ERROR;

1824: CLOSE c_count_qp_code;
1825:
1826: IF l_count_ozf_code > 0 OR l_count_qp_code > 0 THEN
1827: ozf_utility_pvt.error_message('OZF_OFFR_COPY_DUP_CODE');
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;
1830: END IF; -- end validate source code
1831:
1832: IF l_offer_rec.offer_type <> 'VOLUME_OFFER' THEN

Line 2075: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN

2071: -- end create access in ams_act_access_denorm
2072:
2073: -- create access for default team
2074: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2075: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN
2076: INSERT INTO ams_act_access
2077: (activity_access_id
2078: ,last_update_date
2079: ,last_updated_by

Line 2396: AND l_related_deal_line.related_modifier_id <> FND_API.G_MISS_NUM

2392: END IF;
2393: END LOOP;
2394:
2395: IF l_related_deal_line.related_modifier_id IS NOT NULL
2396: AND l_related_deal_line.related_modifier_id <> FND_API.G_MISS_NUM
2397: THEN
2398: -- get new rltd line id
2399: FOR i IN 1..l_line_mapping_tbl.count LOOP
2400: IF l_related_deal_line.related_modifier_id = l_line_mapping_tbl(i).org_line_id THEN

Line 2487: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2483: ,x_msg_data => x_msg_data
2484: ,p_act_Product_rec => l_act_product_rec
2485: ,x_act_Product_id => l_act_product_id);
2486:
2487: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;

Line 2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2484: ,p_act_Product_rec => l_act_product_rec
2485: ,x_act_Product_id => l_act_product_id);
2486:
2487: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492:

Line 2489: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2485: ,x_act_Product_id => l_act_product_id);
2486:
2487: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492:
2493: l_temp_id := l_act_product_id;

Line 2490: RAISE FND_API.G_EXC_ERROR;

2486:
2487: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492:
2493: l_temp_id := l_act_product_id;
2494:

Line 2544: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2540: ,x_msg_data => x_msg_data
2541: ,p_act_Product_rec => l_act_product_rec
2542: ,x_act_Product_id => l_act_product_id);
2543:
2544: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;

Line 2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2541: ,p_act_Product_rec => l_act_product_rec
2542: ,x_act_Product_id => l_act_product_id);
2543:
2544: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549: END LOOP;

Line 2546: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2542: ,x_act_Product_id => l_act_product_id);
2543:
2544: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549: END LOOP;
2550: -- end copying exclusion

Line 2547: RAISE FND_API.G_EXC_ERROR;

2543:
2544: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2546: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549: END LOOP;
2550: -- end copying exclusion
2551: END LOOP;

Line 2564: , p_init_msg_list => FND_API.G_FALSE

2560: BEGIN
2561: copy_vo_header
2562: (
2563: p_api_version => 1.0
2564: , p_init_msg_list => FND_API.G_FALSE
2565: , p_commit => FND_API.G_FALSE
2566: , p_validation_level => p_validation_level
2567: , x_return_status => x_return_status
2568: , x_msg_count => x_msg_count

Line 2565: , p_commit => FND_API.G_FALSE

2561: copy_vo_header
2562: (
2563: p_api_version => 1.0
2564: , p_init_msg_list => FND_API.G_FALSE
2565: , p_commit => FND_API.G_FALSE
2566: , p_validation_level => p_validation_level
2567: , x_return_status => x_return_status
2568: , x_msg_count => x_msg_count
2569: , x_msg_data => x_msg_data

Line 2577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2573: , p_copy_columns_table => p_copy_columns_table
2574: , p_attributes_table => p_attributes_table
2575: , p_custom_setup_id => p_custom_setup_id
2576: );
2577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: END IF;

Line 2578: RAISE FND_API.G_EXC_ERROR;

2574: , p_attributes_table => p_attributes_table
2575: , p_custom_setup_id => p_custom_setup_id
2576: );
2577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: END IF;
2582: l_offer_rec.qp_list_header_id := l_listHeaderId;

Line 2579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2575: , p_custom_setup_id => p_custom_setup_id
2576: );
2577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: END IF;
2582: l_offer_rec.qp_list_header_id := l_listHeaderId;
2583: END;

Line 2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2576: );
2577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: END IF;
2582: l_offer_rec.qp_list_header_id := l_listHeaderId;
2583: END;
2584: END IF;

Line 2586: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN

2582: l_offer_rec.qp_list_header_id := l_listHeaderId;
2583: END;
2584: END IF;
2585:
2586: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN
2587: l_errnum := 0;
2588: l_errcode := NULL;
2589: l_errmsg := NULL;
2590: ams_copyelements_pvt.copy_act_attachments( p_src_act_type => 'OZF_OFFR',

Line 2598: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN

2594: p_errcode => l_errcode,
2595: p_errmsg => l_errmsg);
2596: END IF;
2597:
2598: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2599: FOR l_contact_point IN c_contact_point LOOP
2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;

Line 2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;

2596: END IF;
2597:
2598: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2599: FOR l_contact_point IN c_contact_point LOOP
2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2603: l_contact_point_rec.creation_date := SYSDATE;
2604: l_contact_point_rec.created_by := FND_GLOBAL.user_id;

Line 2642: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2638: ,p_cnt_point_rec => l_contact_point_rec
2639: ,x_contact_point_id => l_dummy
2640: );
2641:
2642: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;

Line 2643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2639: ,x_contact_point_id => l_dummy
2640: );
2641:
2642: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647: END LOOP;

Line 2644: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2640: );
2641:
2642: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647: END LOOP;
2648: END IF;

Line 2645: RAISE FND_API.G_EXC_ERROR;

2641:
2642: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647: END LOOP;
2648: END IF;
2649: /* ELIG is copied by QP API

Line 2650: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

2646: END IF;
2647: END LOOP;
2648: END IF;
2649: /* ELIG is copied by QP API
2650: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
2651: FOR l_market_elig_rec IN c_market_elig LOOP
2652: l_index2 := l_index2 + 1;
2653: l_qualifier_tbl(l_index2).qualifier_context := l_market_elig_rec.qualifier_context;
2654: l_qualifier_tbl(l_index2).qualifier_attribute := l_market_elig_rec.qualifier_attribute;

Line 2677: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2673: ,p_qualifiers_tbl => l_qualifier_tbl
2674: ,x_error_location => l_error_location);
2675: END IF;
2676:
2677: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;

Line 2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2674: ,x_error_location => l_error_location);
2675: END IF;
2676:
2677: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: END IF;

Line 2679: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2675: END IF;
2676:
2677: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: END IF;
2683: */

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676:
2677: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2679: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: END IF;
2683: */
2684: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN

Line 2684: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN

2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: END IF;
2683: */
2684: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN
2685: IF l_offer_rec.offer_type IN ('ACCRUAL', 'OFF_INVOICE', 'TERMS', 'ORDER', 'OID') THEN
2686: DELETE FROM qp_qualifiers
2687: WHERE list_header_id = l_offer_rec.qp_list_header_id
2688: AND list_line_id = -1;

Line 2697: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN

2693: ,p_new_offer_id => l_offer_rec.offer_id);
2694: END IF;
2695: END IF;
2696:
2697: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN
2698: l_errnum := 0;
2699: l_errcode := NULL;
2700: l_errmsg := NULL;
2701: ams_copyelements_pvt.copy_act_content(p_src_act_type => 'OZF_OFFR',

Line 2709: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN

2705: p_errcode => l_errcode,
2706: p_errmsg => l_errmsg);
2707: END IF;
2708:
2709: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
2710: l_errnum := 0;
2711: l_errcode := NULL;
2712: l_errmsg := NULL;
2713: ams_copyelements_pvt.copy_act_access(p_src_act_type => 'OFFR',

Line 2726: WHEN Fnd_Api.G_EXC_ERROR THEN

2722: x_new_object_id := l_offer_rec.qp_list_header_id;
2723:
2724: EXCEPTION
2725:
2726: WHEN Fnd_Api.G_EXC_ERROR THEN
2727: x_return_status := Fnd_Api.g_ret_sts_error;
2728: ROLLBACK TO copy_offer_detail;
2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2730: THEN

Line 2727: x_return_status := Fnd_Api.g_ret_sts_error;

2723:
2724: EXCEPTION
2725:
2726: WHEN Fnd_Api.G_EXC_ERROR THEN
2727: x_return_status := Fnd_Api.g_ret_sts_error;
2728: ROLLBACK TO copy_offer_detail;
2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2730: THEN
2731: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2736: p_encoded => Fnd_Api.G_FALSE

2732: END IF;
2733: Fnd_Msg_Pub.Count_AND_Get
2734: ( p_count => x_msg_count,
2735: p_data => x_msg_data,
2736: p_encoded => Fnd_Api.G_FALSE
2737: );
2738:
2739: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2739: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2735: p_data => x_msg_data,
2736: p_encoded => Fnd_Api.G_FALSE
2737: );
2738:
2739: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2741: ROLLBACK TO copy_offer_detail;
2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2743: THEN

Line 2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2736: p_encoded => Fnd_Api.G_FALSE
2737: );
2738:
2739: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2741: ROLLBACK TO copy_offer_detail;
2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2743: THEN
2744: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2749: p_encoded => Fnd_Api.G_FALSE

2745: END IF;
2746: Fnd_Msg_Pub.Count_AND_Get
2747: ( p_count => x_msg_count,
2748: p_data => x_msg_data,
2749: p_encoded => Fnd_Api.G_FALSE
2750: );
2751:
2752: WHEN OTHERS THEN
2753: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2753: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2749: p_encoded => Fnd_Api.G_FALSE
2750: );
2751:
2752: WHEN OTHERS THEN
2753: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2754: ROLLBACK TO copy_offer_detail;
2755: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2756: THEN
2757: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2762: p_encoded => Fnd_Api.G_FALSE

2758: END IF;
2759: Fnd_Msg_Pub.Count_AND_Get
2760: ( p_count => x_msg_count,
2761: p_data => x_msg_data,
2762: p_encoded => Fnd_Api.G_FALSE
2763: );
2764:
2765: END copy_offer_detail;
2766:

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

2764:
2765: END copy_offer_detail;
2766:
2767: PROCEDURE copy_offer(p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2769: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2771: x_return_status OUT NOCOPY VARCHAR2,
2772: x_msg_count OUT NOCOPY NUMBER,

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

2765: END copy_offer_detail;
2766:
2767: PROCEDURE copy_offer(p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2769: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2771: x_return_status OUT NOCOPY VARCHAR2,
2772: x_msg_count OUT NOCOPY NUMBER,
2773: x_msg_data OUT NOCOPY VARCHAR2,

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

2766:
2767: PROCEDURE copy_offer(p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2769: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2770: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2771: x_return_status OUT NOCOPY VARCHAR2,
2772: x_msg_count OUT NOCOPY NUMBER,
2773: x_msg_data OUT NOCOPY VARCHAR2,
2774: p_source_object_id IN NUMBER,

Line 2791: x_return_status := FND_API.G_RET_STS_SUCCESS;

2787: l_api_name VARCHAR2(30) := 'copy_offer';
2788: BEGIN
2789: SAVEPOINT copy_offer;
2790: -- Initialize API return status to SUCCESS
2791: x_return_status := FND_API.G_RET_STS_SUCCESS;
2792:
2793: OPEN c_budget_offer_yn;
2794: FETCH c_budget_offer_yn INTO l_budget_offer_yn, l_offer_type, x_custom_setup_id;
2795: CLOSE c_budget_offer_yn;

Line 2819: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2815: p_copy_columns_table => p_copy_columns_table,
2816: x_new_object_id => x_new_object_id,
2817: p_custom_setup_id => x_custom_setup_id);
2818:
2819: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;

Line 2820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2816: x_new_object_id => x_new_object_id,
2817: p_custom_setup_id => x_custom_setup_id);
2818:
2819: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824:

Line 2821: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2817: p_custom_setup_id => x_custom_setup_id);
2818:
2819: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824:
2825: EXCEPTION

Line 2822: RAISE FND_API.G_EXC_ERROR;

2818:
2819: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2826: WHEN Fnd_Api.G_EXC_ERROR THEN

2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN Fnd_Api.G_EXC_ERROR THEN
2827: x_return_status := Fnd_Api.g_ret_sts_error;
2828: ROLLBACK TO copy_offer;
2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2830: THEN

Line 2827: x_return_status := Fnd_Api.g_ret_sts_error;

2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN Fnd_Api.G_EXC_ERROR THEN
2827: x_return_status := Fnd_Api.g_ret_sts_error;
2828: ROLLBACK TO copy_offer;
2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2830: THEN
2831: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2836: p_encoded => Fnd_Api.G_FALSE

2832: END IF;
2833: Fnd_Msg_Pub.Count_AND_Get
2834: ( p_count => x_msg_count,
2835: p_data => x_msg_data,
2836: p_encoded => Fnd_Api.G_FALSE
2837: );
2838:
2839: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2839: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2835: p_data => x_msg_data,
2836: p_encoded => Fnd_Api.G_FALSE
2837: );
2838:
2839: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2841: ROLLBACK TO copy_offer;
2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2843: THEN

Line 2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2836: p_encoded => Fnd_Api.G_FALSE
2837: );
2838:
2839: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2841: ROLLBACK TO copy_offer;
2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2843: THEN
2844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2849: p_encoded => Fnd_Api.G_FALSE

2845: END IF;
2846: Fnd_Msg_Pub.Count_AND_Get
2847: ( p_count => x_msg_count,
2848: p_data => x_msg_data,
2849: p_encoded => Fnd_Api.G_FALSE
2850: );
2851:
2852: WHEN OTHERS THEN
2853: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2853: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2849: p_encoded => Fnd_Api.G_FALSE
2850: );
2851:
2852: WHEN OTHERS THEN
2853: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2854: ROLLBACK TO copy_offer;
2855: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2856: THEN
2857: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2862: p_encoded => Fnd_Api.G_FALSE

2858: END IF;
2859: Fnd_Msg_Pub.Count_AND_Get
2860: ( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => Fnd_Api.G_FALSE
2863: );
2864:
2865: END copy_offer;
2866: