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_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 726: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

722: BEGIN
723: -- establish save point
724: SAVEPOINT copy_vo_header;
725: -- check api version compatibility
726: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
727: p_api_version,
728: l_api_name,
729: G_PKG_NAME)
730: THEN

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: p_api_version,
728: l_api_name,
729: G_PKG_NAME)
730: THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 735: IF FND_API.to_Boolean( p_init_msg_list ) THEN

731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to SUCCESS

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to SUCCESS
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: -- initialize the record sent to api for creation
743: l_modifier_list_rec := null;
744:

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

798: l_modifier_list_rec.orig_org_id := l_offer_details.orig_org_id;
799: l_modifier_list_rec.modifier_operation := G_CREATE;
800: l_modifier_list_rec.offer_operation := G_CREATE;
801:
802: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
803: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
804: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
805: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
806:

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

799: l_modifier_list_rec.modifier_operation := G_CREATE;
800: l_modifier_list_rec.offer_operation := G_CREATE;
801:
802: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
803: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
804: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
805: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
806:
807:

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

800: l_modifier_list_rec.offer_operation := G_CREATE;
801:
802: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
803: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
804: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
805: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
806:
807:
808: l_modifier_list_rec.context := l_offer_details.context;

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

801:
802: l_modifier_list_rec.offer_id := FND_API.G_MISS_NUM;
803: l_modifier_list_rec.amount_limit_id := FND_API.G_MISS_NUM;
804: l_modifier_list_rec.uses_limit_id := FND_API.G_MISS_NUM;
805: l_modifier_list_rec.qp_list_header_id := FND_API.G_MISS_NUM;
806:
807:
808: l_modifier_list_rec.context := l_offer_details.context;
809: l_modifier_list_rec.attribute1 := l_offer_details.attribute1;

Line 830: p_init_msg_list => FND_API.G_FALSE

826:
827: -- call api to create new header
828: OZF_OFFER_PVT.process_modifiers
829: (
830: p_init_msg_list => FND_API.G_FALSE
831: ,p_api_version => 1.0
832: ,p_commit => FND_API.G_FALSE
833: ,x_return_status => x_return_status
834: ,x_msg_count => x_msg_count

Line 832: ,p_commit => FND_API.G_FALSE

828: OZF_OFFER_PVT.process_modifiers
829: (
830: p_init_msg_list => FND_API.G_FALSE
831: ,p_api_version => 1.0
832: ,p_commit => FND_API.G_FALSE
833: ,x_return_status => x_return_status
834: ,x_msg_count => x_msg_count
835: ,x_msg_data => x_msg_data
836: ,p_offer_type => l_offer_type

Line 842: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

838: ,p_modifier_line_tbl => l_modifier_line_tbl
839: ,x_qp_list_header_id => l_listHeaderId
840: ,x_error_location => l_errLoc
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: ,x_qp_list_header_id => l_listHeaderId
840: ,x_error_location => l_errLoc
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: ,x_error_location => l_errLoc
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: l_offer_id := null;

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: l_offer_id := null;
849:

Line 860: , p_init_msg_list => FND_API.G_FALSE

856:
857: copy_vo_discounts
858: (
859: p_api_version => 1.0
860: , p_init_msg_list => FND_API.G_FALSE
861: , p_commit => FND_API.G_FALSE
862: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
863: , x_return_status => x_return_status
864: , x_msg_count => x_msg_count

Line 861: , p_commit => FND_API.G_FALSE

857: copy_vo_discounts
858: (
859: p_api_version => 1.0
860: , p_init_msg_list => FND_API.G_FALSE
861: , p_commit => FND_API.G_FALSE
862: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
863: , x_return_status => x_return_status
864: , x_msg_count => x_msg_count
865: , x_msg_data => x_msg_data

Line 862: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

858: (
859: p_api_version => 1.0
860: , p_init_msg_list => FND_API.G_FALSE
861: , p_commit => FND_API.G_FALSE
862: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
863: , x_return_status => x_return_status
864: , x_msg_count => x_msg_count
865: , x_msg_data => x_msg_data
866: , p_sourceObjectId => p_listHeaderId

Line 869: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

865: , x_msg_data => x_msg_data
866: , p_sourceObjectId => p_listHeaderId
867: , p_destOfferId => l_offer_id
868: );
869: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
870: RAISE FND_API.G_EXC_ERROR;
871: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;

Line 870: RAISE FND_API.G_EXC_ERROR;

866: , p_sourceObjectId => p_listHeaderId
867: , p_destOfferId => l_offer_id
868: );
869: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
870: RAISE FND_API.G_EXC_ERROR;
871: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874:

Line 871: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

867: , p_destOfferId => l_offer_id
868: );
869: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
870: RAISE FND_API.G_EXC_ERROR;
871: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874:
875: -- copy qualifiers

Line 872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

868: );
869: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
870: RAISE FND_API.G_EXC_ERROR;
871: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874:
875: -- copy qualifiers
876: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

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

872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874:
875: -- copy qualifiers
876: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
877: ozf_utility_pvt.debug_message('Copy Eligibility');
878: copy_vo_qualifiers
879: (
880: p_api_version => 1.0

Line 881: , p_init_msg_list => FND_API.G_FALSE

877: ozf_utility_pvt.debug_message('Copy Eligibility');
878: copy_vo_qualifiers
879: (
880: p_api_version => 1.0
881: , p_init_msg_list => FND_API.G_FALSE
882: , p_commit => FND_API.G_FALSE
883: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
884: , x_return_status => x_return_status
885: , x_msg_count => x_msg_count

Line 882: , p_commit => FND_API.G_FALSE

878: copy_vo_qualifiers
879: (
880: p_api_version => 1.0
881: , p_init_msg_list => FND_API.G_FALSE
882: , p_commit => FND_API.G_FALSE
883: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
884: , x_return_status => x_return_status
885: , x_msg_count => x_msg_count
886: , x_msg_data => x_msg_data

Line 883: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

879: (
880: p_api_version => 1.0
881: , p_init_msg_list => FND_API.G_FALSE
882: , p_commit => FND_API.G_FALSE
883: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
884: , x_return_status => x_return_status
885: , x_msg_count => x_msg_count
886: , x_msg_data => x_msg_data
887: , p_sourceListHeaderId => p_listHeaderId

Line 890: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

886: , x_msg_data => x_msg_data
887: , p_sourceListHeaderId => p_listHeaderId
888: , p_destListHeaderId => l_listHeaderId
889: );
890: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;

Line 891: RAISE FND_API.G_EXC_ERROR;

887: , p_sourceListHeaderId => p_listHeaderId
888: , p_destListHeaderId => l_listHeaderId
889: );
890: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- copy market options

Line 892: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

888: , p_destListHeaderId => l_listHeaderId
889: );
890: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- copy market options
896: -- market options are created with default options, so update the market options to the ones in the source offer

Line 893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

889: );
890: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- copy market options
896: -- market options are created with default options, so update the market options to the ones in the source offer
897: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN

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

893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- copy market options
896: -- market options are created with default options, so update the market options to the ones in the source offer
897: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN
898: ozf_utility_pvt.debug_message('Copy Market Options');
899: copy_vo_mkt_options
900: (
901: p_api_version => 1.0

Line 902: , p_init_msg_list => FND_API.G_FALSE

898: ozf_utility_pvt.debug_message('Copy Market Options');
899: copy_vo_mkt_options
900: (
901: p_api_version => 1.0
902: , p_init_msg_list => FND_API.G_FALSE
903: , p_commit => FND_API.G_FALSE
904: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
905: , x_return_status => x_return_status
906: , x_msg_count => x_msg_count

Line 903: , p_commit => FND_API.G_FALSE

899: copy_vo_mkt_options
900: (
901: p_api_version => 1.0
902: , p_init_msg_list => FND_API.G_FALSE
903: , p_commit => FND_API.G_FALSE
904: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
905: , x_return_status => x_return_status
906: , x_msg_count => x_msg_count
907: , x_msg_data => x_msg_data

Line 904: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

900: (
901: p_api_version => 1.0
902: , p_init_msg_list => FND_API.G_FALSE
903: , p_commit => FND_API.G_FALSE
904: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
905: , x_return_status => x_return_status
906: , x_msg_count => x_msg_count
907: , x_msg_data => x_msg_data
908: , p_sourceObjectId => p_listHeaderId

Line 912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

908: , p_sourceObjectId => p_listHeaderId
909: , p_destOfferId => l_offer_id
910: );
911:
912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
913: RAISE FND_API.G_EXC_ERROR;
914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;

Line 913: RAISE FND_API.G_EXC_ERROR;

909: , p_destOfferId => l_offer_id
910: );
911:
912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
913: RAISE FND_API.G_EXC_ERROR;
914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917: END IF;

Line 914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

910: );
911:
912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
913: RAISE FND_API.G_EXC_ERROR;
914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917: END IF;
918: END IF;

Line 915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

911:
912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
913: RAISE FND_API.G_EXC_ERROR;
914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917: END IF;
918: END IF;
919:

Line 928: WHEN Fnd_Api.G_EXC_ERROR THEN

924: x_listHeaderId := l_listHeaderId;
925: -- exception
926: EXCEPTION
927:
928: WHEN Fnd_Api.G_EXC_ERROR THEN
929: x_return_status := Fnd_Api.g_ret_sts_error;
930: ROLLBACK TO copy_vo_header;
931: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
932: THEN

Line 929: x_return_status := Fnd_Api.g_ret_sts_error;

925: -- exception
926: EXCEPTION
927:
928: WHEN Fnd_Api.G_EXC_ERROR THEN
929: x_return_status := Fnd_Api.g_ret_sts_error;
930: ROLLBACK TO copy_vo_header;
931: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
932: THEN
933: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 938: p_encoded => Fnd_Api.G_FALSE

934: END IF;
935: Fnd_Msg_Pub.Count_AND_Get
936: ( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => Fnd_Api.G_FALSE
939: );
940:
941: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 941: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

937: p_data => x_msg_data,
938: p_encoded => Fnd_Api.G_FALSE
939: );
940:
941: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
943: ROLLBACK TO copy_vo_header;
944: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
945: THEN

Line 942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

938: p_encoded => Fnd_Api.G_FALSE
939: );
940:
941: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
943: ROLLBACK TO copy_vo_header;
944: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
945: THEN
946: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 951: p_encoded => Fnd_Api.G_FALSE

947: END IF;
948: Fnd_Msg_Pub.Count_AND_Get
949: ( p_count => x_msg_count,
950: p_data => x_msg_data,
951: p_encoded => Fnd_Api.G_FALSE
952: );
953:
954: WHEN OTHERS THEN
955: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 955: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

951: p_encoded => Fnd_Api.G_FALSE
952: );
953:
954: WHEN OTHERS THEN
955: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
956: ROLLBACK TO copy_vo_header;
957: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 964: p_encoded => Fnd_Api.G_FALSE

960: END IF;
961: Fnd_Msg_Pub.Count_AND_Get
962: ( p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => Fnd_Api.G_FALSE
965: );
966:
967: END copy_vo_header;
968:

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

1554:
1555:
1556: PROCEDURE copy_offer_detail(
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,

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

1555:
1556: PROCEDURE copy_offer_detail(
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,

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

1556: PROCEDURE copy_offer_detail(
1557: p_api_version IN NUMBER,
1558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1559: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1560: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,
1564: p_source_object_id IN NUMBER,

Line 1767: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1763: -- Standard Start of API savepoint
1764: SAVEPOINT copy_offer_detail;
1765:
1766: -- Standard call to check for call compatibility.
1767: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1768: p_api_version,
1769: l_api_name,
1770: G_PKG_NAME)
1771: THEN

Line 1772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1768: p_api_version,
1769: l_api_name,
1770: G_PKG_NAME)
1771: THEN
1772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1773: END IF;
1774:
1775: -- Initialize message list if p_init_msg_list is set to TRUE.
1776: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1776: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1773: END IF;
1774:
1775: -- Initialize message list if p_init_msg_list is set to TRUE.
1776: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1777: FND_MSG_PUB.initialize;
1778: END IF;
1779:
1780: -- Initialize API return status to SUCCESS

Line 1781: x_return_status := FND_API.G_RET_STS_SUCCESS;

1777: FND_MSG_PUB.initialize;
1778: END IF;
1779:
1780: -- Initialize API return status to SUCCESS
1781: x_return_status := FND_API.G_RET_STS_SUCCESS;
1782:
1783: OPEN c_offer_detail;
1784: FETCH c_offer_detail INTO l_offer_rec;
1785: CLOSE c_offer_detail;

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

1797:
1798: /*ninarasi bug 12621645 - removed start date validation for copy offer.
1799: -- bug fix 2779988: validate start date and end date
1800: IF l_modifier_list_rec.start_date_active IS NOT NULL
1801: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1802: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1803: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1804: Fnd_Msg_Pub.ADD;
1805: RAISE FND_API.G_EXC_ERROR;

Line 1805: RAISE FND_API.G_EXC_ERROR;

1801: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1802: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1803: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1804: Fnd_Msg_Pub.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: END IF; -- end validation start date if
1808: */
1809:

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

1807: END IF; -- end validation start date if
1808: */
1809:
1810: IF l_modifier_list_rec.end_date_active IS NOT NULL
1811: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1812: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1813: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1814: Fnd_Msg_Pub.ADD;
1815: RAISE FND_API.G_EXC_ERROR;

Line 1815: RAISE FND_API.G_EXC_ERROR;

1811: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1812: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1813: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1814: Fnd_Msg_Pub.ADD;
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;
1817: END IF; -- end end date validation if
1818:
1819: 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 1822: RAISE FND_API.G_EXC_ERROR;

1818:
1819: 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
1820: IF l_modifier_list_rec.start_date_active IS NULL THEN
1821: ozf_utility_pvt.error_message('OZF_OFFR_NO_START_DATE');
1822: RAISE FND_API.G_EXC_ERROR;
1823: END IF;
1824: END IF; -- end scan data lumpsum start date validation if
1825:
1826: IF l_modifier_list_rec.start_date_active IS NOT NULL

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

1823: END IF;
1824: END IF; -- end scan data lumpsum start date validation if
1825:
1826: IF l_modifier_list_rec.start_date_active IS NOT NULL
1827: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE
1828: AND l_modifier_list_rec.end_date_active IS NOT NULL
1829: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1830: THEN
1831: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN

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

1825:
1826: IF l_modifier_list_rec.start_date_active IS NOT NULL
1827: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE
1828: AND l_modifier_list_rec.end_date_active IS NOT NULL
1829: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1830: THEN
1831: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1832: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1833: Fnd_Msg_Pub.ADD;

Line 1834: RAISE FND_API.G_EXC_ERROR;

1830: THEN
1831: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1832: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1833: Fnd_Msg_Pub.ADD;
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836: END IF; -- end start date before end date validation
1837:
1838: -- validate source code

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

1835: END IF;
1836: END IF; -- end start date before end date validation
1837:
1838: -- validate source code
1839: IF l_offer_rec.offer_code IS NULL OR l_offer_rec.offer_code = FND_API.G_MISS_CHAR THEN
1840: LOOP
1841: l_count_ozf_code := 0;
1842: l_count_qp_code := 0;
1843:

Line 1847: p_global_flag => Fnd_Api.g_false

1843:
1844: l_offer_rec.offer_code := Ams_Sourcecode_Pvt.get_new_source_code (
1845: p_object_type => 'OFFR',
1846: p_custsetup_id => l_offer_rec.custom_setup_id,
1847: p_global_flag => Fnd_Api.g_false
1848: );
1849:
1850: OPEN c_count_ozf_code(l_offer_rec.offer_code);
1851: FETCH c_count_ozf_code INTO l_count_ozf_code;

Line 1877: RAISE FND_API.G_EXC_ERROR;

1873: CLOSE c_count_qp_code;
1874:
1875: IF l_count_ozf_code > 0 OR l_count_qp_code > 0 THEN
1876: ozf_utility_pvt.error_message('OZF_OFFR_COPY_DUP_CODE');
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF;
1879: END IF; -- end validate source code
1880:
1881: IF l_offer_rec.offer_type <> 'VOLUME_OFFER' THEN

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

2134:
2135: -- create access for default team
2136: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2137:
2138: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN
2139:
2140: --nepanda For Bug 10385923. Getting the admin flag for default team and the offer from which this offer is getting copied.
2141: OPEN c_edit_metrics_detail(l_default_team);
2142: FETCH c_edit_metrics_detail INTO l_admin_flag;

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

2461: END IF;
2462: END LOOP;
2463:
2464: IF l_related_deal_line.related_modifier_id IS NOT NULL
2465: AND l_related_deal_line.related_modifier_id <> FND_API.G_MISS_NUM
2466: THEN
2467: -- get new rltd line id
2468: FOR i IN 1..l_line_mapping_tbl.count LOOP
2469: IF l_related_deal_line.related_modifier_id = l_line_mapping_tbl(i).org_line_id THEN

Line 2556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2552: ,x_msg_data => x_msg_data
2553: ,p_act_Product_rec => l_act_product_rec
2554: ,x_act_Product_id => l_act_product_id);
2555:
2556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;

Line 2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2553: ,p_act_Product_rec => l_act_product_rec
2554: ,x_act_Product_id => l_act_product_id);
2555:
2556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:

Line 2558: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2554: ,x_act_Product_id => l_act_product_id);
2555:
2556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:
2562: l_temp_id := l_act_product_id;

Line 2559: RAISE FND_API.G_EXC_ERROR;

2555:
2556: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:
2562: l_temp_id := l_act_product_id;
2563:

Line 2613: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2609: ,x_msg_data => x_msg_data
2610: ,p_act_Product_rec => l_act_product_rec
2611: ,x_act_Product_id => l_act_product_id);
2612:
2613: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;

Line 2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2610: ,p_act_Product_rec => l_act_product_rec
2611: ,x_act_Product_id => l_act_product_id);
2612:
2613: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: END LOOP;

Line 2615: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2611: ,x_act_Product_id => l_act_product_id);
2612:
2613: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: END LOOP;
2619: -- end copying exclusion

Line 2616: RAISE FND_API.G_EXC_ERROR;

2612:
2613: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: END LOOP;
2619: -- end copying exclusion
2620: END LOOP;

Line 2633: , p_init_msg_list => FND_API.G_FALSE

2629: BEGIN
2630: copy_vo_header
2631: (
2632: p_api_version => 1.0
2633: , p_init_msg_list => FND_API.G_FALSE
2634: , p_commit => FND_API.G_FALSE
2635: , p_validation_level => p_validation_level
2636: , x_return_status => x_return_status
2637: , x_msg_count => x_msg_count

Line 2634: , p_commit => FND_API.G_FALSE

2630: copy_vo_header
2631: (
2632: p_api_version => 1.0
2633: , p_init_msg_list => FND_API.G_FALSE
2634: , p_commit => FND_API.G_FALSE
2635: , p_validation_level => p_validation_level
2636: , x_return_status => x_return_status
2637: , x_msg_count => x_msg_count
2638: , x_msg_data => x_msg_data

Line 2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2642: , p_copy_columns_table => p_copy_columns_table
2643: , p_attributes_table => p_attributes_table
2644: , p_custom_setup_id => p_custom_setup_id
2645: );
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2650: END IF;

Line 2647: RAISE FND_API.G_EXC_ERROR;

2643: , p_attributes_table => p_attributes_table
2644: , p_custom_setup_id => p_custom_setup_id
2645: );
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2650: END IF;
2651: l_offer_rec.qp_list_header_id := l_listHeaderId;

Line 2648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2644: , p_custom_setup_id => p_custom_setup_id
2645: );
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2650: END IF;
2651: l_offer_rec.qp_list_header_id := l_listHeaderId;
2652: END;

Line 2649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2645: );
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2650: END IF;
2651: l_offer_rec.qp_list_header_id := l_listHeaderId;
2652: END;
2653: END IF;

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

2651: l_offer_rec.qp_list_header_id := l_listHeaderId;
2652: END;
2653: END IF;
2654:
2655: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN
2656: l_errnum := 0;
2657: l_errcode := NULL;
2658: l_errmsg := NULL;
2659: ams_copyelements_pvt.copy_act_attachments( p_src_act_type => 'OZF_OFFR',

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

2663: p_errcode => l_errcode,
2664: p_errmsg => l_errmsg);
2665: END IF;
2666:
2667: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2668: FOR l_contact_point IN c_contact_point LOOP
2669: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;

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

2665: END IF;
2666:
2667: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2668: FOR l_contact_point IN c_contact_point LOOP
2669: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
2672: l_contact_point_rec.creation_date := SYSDATE;
2673: l_contact_point_rec.created_by := FND_GLOBAL.user_id;

Line 2711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2707: ,p_cnt_point_rec => l_contact_point_rec
2708: ,x_contact_point_id => l_dummy
2709: );
2710:
2711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;

Line 2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2708: ,x_contact_point_id => l_dummy
2709: );
2710:
2711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716: END LOOP;

Line 2713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2709: );
2710:
2711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716: END LOOP;
2717: END IF;

Line 2714: RAISE FND_API.G_EXC_ERROR;

2710:
2711: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716: END LOOP;
2717: END IF;
2718: /* ELIG is copied by QP API

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

2715: END IF;
2716: END LOOP;
2717: END IF;
2718: /* ELIG is copied by QP API
2719: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
2720: FOR l_market_elig_rec IN c_market_elig LOOP
2721: l_index2 := l_index2 + 1;
2722: l_qualifier_tbl(l_index2).qualifier_context := l_market_elig_rec.qualifier_context;
2723: l_qualifier_tbl(l_index2).qualifier_attribute := l_market_elig_rec.qualifier_attribute;

Line 2746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2742: ,p_qualifiers_tbl => l_qualifier_tbl
2743: ,x_error_location => l_error_location);
2744: END IF;
2745:
2746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;

Line 2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2743: ,x_error_location => l_error_location);
2744: END IF;
2745:
2746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF;

Line 2748: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2744: END IF;
2745:
2746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF;
2752: */

Line 2749: RAISE FND_API.G_EXC_ERROR;

2745:
2746: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2748: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF;
2752: */
2753: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN

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

2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF;
2752: */
2753: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN
2754: IF l_offer_rec.offer_type IN ('ACCRUAL', 'OFF_INVOICE', 'TERMS', 'ORDER', 'OID') THEN
2755: DELETE FROM qp_qualifiers
2756: WHERE list_header_id = l_offer_rec.qp_list_header_id
2757: AND list_line_id = -1;

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

2762: ,p_new_offer_id => l_offer_rec.offer_id);
2763: END IF;
2764: END IF;
2765:
2766: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN
2767: l_errnum := 0;
2768: l_errcode := NULL;
2769: l_errmsg := NULL;
2770: ams_copyelements_pvt.copy_act_content(p_src_act_type => 'OZF_OFFR',

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

2774: p_errcode => l_errcode,
2775: p_errmsg => l_errmsg);
2776: END IF;
2777:
2778: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
2779: l_errnum := 0;
2780: l_errcode := NULL;
2781: l_errmsg := NULL;
2782: ams_copyelements_pvt.copy_act_access(p_src_act_type => 'OFFR',

Line 2795: WHEN Fnd_Api.G_EXC_ERROR THEN

2791: x_new_object_id := l_offer_rec.qp_list_header_id;
2792:
2793: EXCEPTION
2794:
2795: WHEN Fnd_Api.G_EXC_ERROR THEN
2796: x_return_status := Fnd_Api.g_ret_sts_error;
2797: ROLLBACK TO copy_offer_detail;
2798: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2799: THEN

Line 2796: x_return_status := Fnd_Api.g_ret_sts_error;

2792:
2793: EXCEPTION
2794:
2795: WHEN Fnd_Api.G_EXC_ERROR THEN
2796: x_return_status := Fnd_Api.g_ret_sts_error;
2797: ROLLBACK TO copy_offer_detail;
2798: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2799: THEN
2800: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2805: p_encoded => Fnd_Api.G_FALSE

2801: END IF;
2802: Fnd_Msg_Pub.Count_AND_Get
2803: ( p_count => x_msg_count,
2804: p_data => x_msg_data,
2805: p_encoded => Fnd_Api.G_FALSE
2806: );
2807:
2808: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2808: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2804: p_data => x_msg_data,
2805: p_encoded => Fnd_Api.G_FALSE
2806: );
2807:
2808: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2810: ROLLBACK TO copy_offer_detail;
2811: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2812: THEN

Line 2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2805: p_encoded => Fnd_Api.G_FALSE
2806: );
2807:
2808: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2810: ROLLBACK TO copy_offer_detail;
2811: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2812: THEN
2813: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2818: p_encoded => Fnd_Api.G_FALSE

2814: END IF;
2815: Fnd_Msg_Pub.Count_AND_Get
2816: ( p_count => x_msg_count,
2817: p_data => x_msg_data,
2818: p_encoded => Fnd_Api.G_FALSE
2819: );
2820:
2821: WHEN OTHERS THEN
2822: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2822: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2818: p_encoded => Fnd_Api.G_FALSE
2819: );
2820:
2821: WHEN OTHERS THEN
2822: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2823: ROLLBACK TO copy_offer_detail;
2824: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2825: THEN
2826: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2831: p_encoded => Fnd_Api.G_FALSE

2827: END IF;
2828: Fnd_Msg_Pub.Count_AND_Get
2829: ( p_count => x_msg_count,
2830: p_data => x_msg_data,
2831: p_encoded => Fnd_Api.G_FALSE
2832: );
2833:
2834: END copy_offer_detail;
2835:

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

2833:
2834: END copy_offer_detail;
2835:
2836: PROCEDURE copy_offer(p_api_version IN NUMBER,
2837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2839: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,

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

2834: END copy_offer_detail;
2835:
2836: PROCEDURE copy_offer(p_api_version IN NUMBER,
2837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2839: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,

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

2835:
2836: PROCEDURE copy_offer(p_api_version IN NUMBER,
2837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2839: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,
2843: p_source_object_id IN NUMBER,

Line 2860: x_return_status := FND_API.G_RET_STS_SUCCESS;

2856: l_api_name VARCHAR2(30) := 'copy_offer';
2857: BEGIN
2858: SAVEPOINT copy_offer;
2859: -- Initialize API return status to SUCCESS
2860: x_return_status := FND_API.G_RET_STS_SUCCESS;
2861:
2862: OPEN c_budget_offer_yn;
2863: FETCH c_budget_offer_yn INTO l_budget_offer_yn, l_offer_type, x_custom_setup_id;
2864: CLOSE c_budget_offer_yn;

Line 2888: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2884: p_copy_columns_table => p_copy_columns_table,
2885: x_new_object_id => x_new_object_id,
2886: p_custom_setup_id => x_custom_setup_id);
2887:
2888: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;

Line 2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2885: x_new_object_id => x_new_object_id,
2886: p_custom_setup_id => x_custom_setup_id);
2887:
2888: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893:

Line 2890: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2886: p_custom_setup_id => x_custom_setup_id);
2887:
2888: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893:
2894: EXCEPTION

Line 2891: RAISE FND_API.G_EXC_ERROR;

2887:
2888: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893:
2894: EXCEPTION
2895: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2895: WHEN Fnd_Api.G_EXC_ERROR THEN

2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893:
2894: EXCEPTION
2895: WHEN Fnd_Api.G_EXC_ERROR THEN
2896: x_return_status := Fnd_Api.g_ret_sts_error;
2897: ROLLBACK TO copy_offer;
2898: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2899: THEN

Line 2896: x_return_status := Fnd_Api.g_ret_sts_error;

2892: END IF;
2893:
2894: EXCEPTION
2895: WHEN Fnd_Api.G_EXC_ERROR THEN
2896: x_return_status := Fnd_Api.g_ret_sts_error;
2897: ROLLBACK TO copy_offer;
2898: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2899: THEN
2900: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2905: p_encoded => Fnd_Api.G_FALSE

2901: END IF;
2902: Fnd_Msg_Pub.Count_AND_Get
2903: ( p_count => x_msg_count,
2904: p_data => x_msg_data,
2905: p_encoded => Fnd_Api.G_FALSE
2906: );
2907:
2908: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2908: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2904: p_data => x_msg_data,
2905: p_encoded => Fnd_Api.G_FALSE
2906: );
2907:
2908: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2910: ROLLBACK TO copy_offer;
2911: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2912: THEN

Line 2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2905: p_encoded => Fnd_Api.G_FALSE
2906: );
2907:
2908: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2910: ROLLBACK TO copy_offer;
2911: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2912: THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2918: p_encoded => Fnd_Api.G_FALSE

2914: END IF;
2915: Fnd_Msg_Pub.Count_AND_Get
2916: ( p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => Fnd_Api.G_FALSE
2919: );
2920:
2921: WHEN OTHERS THEN
2922: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

Line 2922: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

2918: p_encoded => Fnd_Api.G_FALSE
2919: );
2920:
2921: WHEN OTHERS THEN
2922: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2923: ROLLBACK TO copy_offer;
2924: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2925: THEN
2926: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 2931: p_encoded => Fnd_Api.G_FALSE

2927: END IF;
2928: Fnd_Msg_Pub.Count_AND_Get
2929: ( p_count => x_msg_count,
2930: p_data => x_msg_data,
2931: p_encoded => Fnd_Api.G_FALSE
2932: );
2933:
2934: END copy_offer;
2935: