[Home] [Help]
16: -------------------------------------------------------------------------------
17: PROCEDURE Create_Act_Offer
18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT NOCOPY VARCHAR2,
17: PROCEDURE Create_Act_Offer
18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
66:
67: -- initialize
68: SAVEPOINT create_act_offer;
69:
70: IF FND_API.to_boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: IF NOT FND_API.compatible_api_call
70: IF FND_API.to_boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: IF NOT FND_API.compatible_api_call
75: (
76: l_api_version,
77: p_api_version,
78: l_api_name,
78: l_api_name,
79: g_pkg_name
80: )
81: THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: x_return_status := FND_API.g_ret_sts_success;
86: /*
81: THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: x_return_status := FND_API.g_ret_sts_success;
86: /*
87: OPEN c_custom_setup;
88: FETCH c_custom_setup INTO l_custom_setup_id;
89: CLOSE c_custom_setup;
100: x_msg_data => x_msg_data,
101: p_act_offer_rec => l_act_offer_rec
102: );
103:
104: IF l_return_status = FND_API.g_ret_sts_error THEN
105: RAISE FND_API.g_exc_error;
106: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
107: RAISE FND_API.g_exc_unexpected_error;
108: END IF;
101: p_act_offer_rec => l_act_offer_rec
102: );
103:
104: IF l_return_status = FND_API.g_ret_sts_error THEN
105: RAISE FND_API.g_exc_error;
106: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
107: RAISE FND_API.g_exc_unexpected_error;
108: END IF;
109: END IF;
102: );
103:
104: IF l_return_status = FND_API.g_ret_sts_error THEN
105: RAISE FND_API.g_exc_error;
106: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
107: RAISE FND_API.g_exc_unexpected_error;
108: END IF;
109: END IF;
110:
103:
104: IF l_return_status = FND_API.g_ret_sts_error THEN
105: RAISE FND_API.g_exc_error;
106: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
107: RAISE FND_API.g_exc_unexpected_error;
108: END IF;
109: END IF;
110:
111: -- insert
139: -- NOTE: Need to implement global flag.]
140: -- l_act_offer_rec.offer_code := AMS_SourceCode_PVT.get_new_source_code (
141: -- p_object_type => 'OFFR',
142: -- p_custsetup_id => l_custom_setup_id,
143: -- p_global_flag => FND_API.g_false
144: -- );
145: l_act_offer_rec.offer_code := AMS_SourceCode_PVT.get_source_code
146: (
147: 'OFFR',
150: END IF;
151: */
152: -- set primary_offer_flag to default value
153: IF l_act_offer_rec.primary_offer_flag IS NULL
154: OR l_act_offer_rec.primary_offer_flag = FND_API.g_miss_char
155: THEN
156: l_act_offer_rec.primary_offer_flag := 'N';
157: END IF;
158:
224: -- insert offer_code into AMS_SOURCE_CODES
225: -- commented by julou 05/03/2001. offer_code is gone
226: /* AMS_SourceCode_PVT.create_sourcecode(
227: p_api_version => 1.0,
228: p_init_msg_list => FND_API.g_false,
229: p_commit => FND_API.g_false,
230: p_validation_level => FND_API.g_valid_level_full,
231:
232: x_return_status => l_return_status,
225: -- commented by julou 05/03/2001. offer_code is gone
226: /* AMS_SourceCode_PVT.create_sourcecode(
227: p_api_version => 1.0,
228: p_init_msg_list => FND_API.g_false,
229: p_commit => FND_API.g_false,
230: p_validation_level => FND_API.g_valid_level_full,
231:
232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
226: /* AMS_SourceCode_PVT.create_sourcecode(
227: p_api_version => 1.0,
228: p_init_msg_list => FND_API.g_false,
229: p_commit => FND_API.g_false,
230: p_validation_level => FND_API.g_valid_level_full,
231:
232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data,
244: -- added by julou on 03/08/2000
245: -- indicate offer has been defined for the campaign
246: /* AMS_ObjectAttribute_PVT.modify_object_attribute(
247: p_api_version => l_api_version,
248: p_init_msg_list => FND_API.g_false,
249: p_commit => FND_API.g_false,
250: p_validation_level => FND_API.g_valid_level_full,
251:
252: x_return_status => l_return_status,
245: -- indicate offer has been defined for the campaign
246: /* AMS_ObjectAttribute_PVT.modify_object_attribute(
247: p_api_version => l_api_version,
248: p_init_msg_list => FND_API.g_false,
249: p_commit => FND_API.g_false,
250: p_validation_level => FND_API.g_valid_level_full,
251:
252: x_return_status => l_return_status,
253: x_msg_count => x_msg_count,
246: /* AMS_ObjectAttribute_PVT.modify_object_attribute(
247: p_api_version => l_api_version,
248: p_init_msg_list => FND_API.g_false,
249: p_commit => FND_API.g_false,
250: p_validation_level => FND_API.g_valid_level_full,
251:
252: x_return_status => l_return_status,
253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data,
258: p_attr => 'OFFR',
259: p_attr_defined_flag => 'Y'
260: );
261:
262: IF l_return_status = FND_API.g_ret_sts_error THEN
263: RAISE FND_API.g_exc_error;
264: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF; */
259: p_attr_defined_flag => 'Y'
260: );
261:
262: IF l_return_status = FND_API.g_ret_sts_error THEN
263: RAISE FND_API.g_exc_error;
264: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF; */
267:
260: );
261:
262: IF l_return_status = FND_API.g_ret_sts_error THEN
263: RAISE FND_API.g_exc_error;
264: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF; */
267:
268: -- create attributes for this offer
261:
262: IF l_return_status = FND_API.g_ret_sts_error THEN
263: RAISE FND_API.g_exc_error;
264: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF; */
267:
268: -- create attributes for this offer
269: -- commented by julou 05/03/2001. custom_setup_id is gone
270: /*
271: IF l_custom_setup_id IS NOT NULL THEN
272: AMS_ObjectAttribute_PVT.create_object_attributes(
273: p_api_version => 1.0,
274: p_init_msg_list => FND_API.g_false,
275: p_commit => FND_API.g_false,
276: p_validation_level => FND_API.g_valid_level_full,
277: x_return_status => l_return_status,
278: x_msg_count => x_msg_count,
271: IF l_custom_setup_id IS NOT NULL THEN
272: AMS_ObjectAttribute_PVT.create_object_attributes(
273: p_api_version => 1.0,
274: p_init_msg_list => FND_API.g_false,
275: p_commit => FND_API.g_false,
276: p_validation_level => FND_API.g_valid_level_full,
277: x_return_status => l_return_status,
278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data,
272: AMS_ObjectAttribute_PVT.create_object_attributes(
273: p_api_version => 1.0,
274: p_init_msg_list => FND_API.g_false,
275: p_commit => FND_API.g_false,
276: p_validation_level => FND_API.g_valid_level_full,
277: x_return_status => l_return_status,
278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data,
280: p_object_type => 'OFFR',
280: p_object_type => 'OFFR',
281: p_object_id => l_act_offer_rec.activity_offer_id,
282: p_setup_id => l_custom_setup_id
283: );
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
281: p_object_id => l_act_offer_rec.activity_offer_id,
282: p_setup_id => l_custom_setup_id
283: );
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;
282: p_setup_id => l_custom_setup_id
283: );
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;
290: */
283: );
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;
290: */
291: -- end of comment
292:
293: -- finish
294: x_act_offer_id := l_act_offer_rec.activity_offer_id;
295:
296: IF FND_API.to_boolean(p_commit) THEN
297: COMMIT;
298: END IF;
299:
300: FND_MSG_PUB.count_and_get
298: END IF;
299:
300: FND_MSG_PUB.count_and_get
301: (
302: p_encoded => FND_API.g_false,
303: p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306:
304: p_data => x_msg_data
305: );
306:
307: EXCEPTION
308: WHEN FND_API.g_exc_error THEN
309: ROLLBACK TO create_act_offer;
310: x_return_status := FND_API.g_ret_sts_error;
311: FND_MSG_PUB.count_and_get
312: (
306:
307: EXCEPTION
308: WHEN FND_API.g_exc_error THEN
309: ROLLBACK TO create_act_offer;
310: x_return_status := FND_API.g_ret_sts_error;
311: FND_MSG_PUB.count_and_get
312: (
313: p_encoded => FND_API.g_false,
314: p_count => x_msg_count,
309: ROLLBACK TO create_act_offer;
310: x_return_status := FND_API.g_ret_sts_error;
311: FND_MSG_PUB.count_and_get
312: (
313: p_encoded => FND_API.g_false,
314: p_count => x_msg_count,
315: p_data => x_msg_data
316: );
317:
314: p_count => x_msg_count,
315: p_data => x_msg_data
316: );
317:
318: WHEN FND_API.g_exc_unexpected_error THEN
319: ROLLBACK TO create_act_offer;
320: x_return_status := FND_API.g_ret_sts_unexp_error;
321: FND_MSG_PUB.count_and_get
322: (
316: );
317:
318: WHEN FND_API.g_exc_unexpected_error THEN
319: ROLLBACK TO create_act_offer;
320: x_return_status := FND_API.g_ret_sts_unexp_error;
321: FND_MSG_PUB.count_and_get
322: (
323: p_encoded => FND_API.g_false,
324: p_count => x_msg_count,
319: ROLLBACK TO create_act_offer;
320: x_return_status := FND_API.g_ret_sts_unexp_error;
321: FND_MSG_PUB.count_and_get
322: (
323: p_encoded => FND_API.g_false,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327:
326: );
327:
328: WHEN OTHERS THEN
329: ROLLBACK TO create_act_offer;
330: x_return_status :=FND_API.g_ret_sts_unexp_error;
331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
333: END IF;
334: FND_MSG_PUB.count_and_get
332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
333: END IF;
334: FND_MSG_PUB.count_and_get
335: (
336: p_encoded => FND_API.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );
340: END Create_Act_Offer;
350: -------------------------------------------------------------------------------
351: PROCEDURE Update_Act_Offer
352: (
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
357:
358: x_return_status OUT NOCOPY VARCHAR2,
351: PROCEDURE Update_Act_Offer
352: (
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
357:
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
352: (
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
357:
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,
376:
377: -- initialize
378: SAVEPOINT update_act_offer;
379:
380: IF FND_API.to_boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: IF NOT FND_API.compatible_api_call
380: IF FND_API.to_boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: IF NOT FND_API.compatible_api_call
385: (
386: l_api_version,
387: p_api_version,
388: l_api_name,
388: l_api_name,
389: g_pkg_name
390: )
391: THEN
392: RAISE FND_API.g_exc_unexpected_error;
393: END IF;
394:
395: x_return_status := FND_API.g_ret_sts_success;
396:
391: THEN
392: RAISE FND_API.g_exc_unexpected_error;
393: END IF;
394:
395: x_return_status := FND_API.g_ret_sts_success;
396:
397: -- validate
398: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
399: check_items
402: x_return_status => l_return_status,
403: p_act_offer_rec => l_act_offer_rec
404: );
405:
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: RAISE FND_API.g_exc_error;
408: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
409: RAISE FND_API.g_exc_unexpected_error;
410: END IF;
403: p_act_offer_rec => l_act_offer_rec
404: );
405:
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: RAISE FND_API.g_exc_error;
408: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
409: RAISE FND_API.g_exc_unexpected_error;
410: END IF;
411: END IF;
404: );
405:
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: RAISE FND_API.g_exc_error;
408: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
409: RAISE FND_API.g_exc_unexpected_error;
410: END IF;
411: END IF;
412:
405:
406: IF l_return_status = FND_API.g_ret_sts_error THEN
407: RAISE FND_API.g_exc_error;
408: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
409: RAISE FND_API.g_exc_unexpected_error;
410: END IF;
411: END IF;
412:
413: complete_rec
423: p_complete_rec => l_act_offer_rec,
424: x_return_status => l_return_status
425: );
426:
427: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
428: RAISE FND_API.g_exc_unexpected_error;
429: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
430: RAISE FND_API.g_exc_error;
431: END IF;
424: x_return_status => l_return_status
425: );
426:
427: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
428: RAISE FND_API.g_exc_unexpected_error;
429: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
430: RAISE FND_API.g_exc_error;
431: END IF;
432: END IF;
425: );
426:
427: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
428: RAISE FND_API.g_exc_unexpected_error;
429: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
430: RAISE FND_API.g_exc_error;
431: END IF;
432: END IF;
433:
426:
427: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
428: RAISE FND_API.g_exc_unexpected_error;
429: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
430: RAISE FND_API.g_exc_error;
431: END IF;
432: END IF;
433:
434: -- The second line below is modified by ptendulk on Jan 14th:
435: -- if the flag is not sent for update, don't update it.
436:
437: -- set primary_offer_flag to default value
438: IF l_act_offer_rec.primary_offer_flag IS NULL
439: -- OR l_act_offer_rec.primary_offer_flag = FND_API.g_miss_char
440: THEN
441: l_act_offer_rec.primary_offer_flag := 'N';
442: END IF;
443:
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
475: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
476: FND_MSG_PUB.add;
477: END IF;
478: RAISE FND_API.g_exc_error;
479: END IF;
480:
481: -- finish
482: IF FND_API.to_boolean(p_commit) THEN
478: RAISE FND_API.g_exc_error;
479: END IF;
480:
481: -- finish
482: IF FND_API.to_boolean(p_commit) THEN
483: COMMIT;
484: END IF;
485:
486: FND_MSG_PUB.count_and_get
484: END IF;
485:
486: FND_MSG_PUB.count_and_get
487: (
488: P_ENCODED => FND_API.g_false,
489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );
492:
490: p_data => x_msg_data
491: );
492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: ROLLBACK TO update_act_offer;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (
492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: ROLLBACK TO update_act_offer;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (
499: p_encoded => FND_API.g_false,
500: p_count => x_msg_count,
495: ROLLBACK TO update_act_offer;
496: x_return_status := FND_API.g_ret_sts_error;
497: FND_MSG_PUB.count_and_get
498: (
499: p_encoded => FND_API.g_false,
500: p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503:
500: p_count => x_msg_count,
501: p_data => x_msg_data
502: );
503:
504: WHEN FND_API.g_exc_unexpected_error THEN
505: ROLLBACK TO update_act_offer;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (
502: );
503:
504: WHEN FND_API.g_exc_unexpected_error THEN
505: ROLLBACK TO update_act_offer;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (
509: p_encoded => FND_API.g_false,
510: p_count => x_msg_count,
505: ROLLBACK TO update_act_offer;
506: x_return_status := FND_API.g_ret_sts_unexp_error;
507: FND_MSG_PUB.count_and_get
508: (
509: p_encoded => FND_API.g_false,
510: p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513:
512: );
513:
514: WHEN OTHERS THEN
515: ROLLBACK TO update_act_offer;
516: x_return_status :=FND_API.g_ret_sts_unexp_error;
517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
518: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
519: END IF;
520: FND_MSG_PUB.count_and_get
518: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
519: END IF;
520: FND_MSG_PUB.count_and_get
521: (
522: p_encoded => FND_API.g_false,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526: END Update_Act_Offer;
534: -------------------------------------------------------------------------------
535: PROCEDURE Delete_Act_Offer
536: (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
539: p_commit IN VARCHAR2 := FND_API.g_false,
540:
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
535: PROCEDURE Delete_Act_Offer
536: (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
539: p_commit IN VARCHAR2 := FND_API.g_false,
540:
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
569:
570: -- initialize
571: SAVEPOINT delete_act_offer;
572:
573: IF FND_API.to_boolean(p_init_msg_list) THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576:
577: IF NOT FND_API.compatible_api_call
573: IF FND_API.to_boolean(p_init_msg_list) THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576:
577: IF NOT FND_API.compatible_api_call
578: (
579: l_api_version,
580: p_api_version,
581: l_api_name,
581: l_api_name,
582: g_pkg_name
583: )
584: THEN
585: RAISE FND_API.g_exc_unexpected_error;
586: END IF;
587:
588: x_return_status := FND_API.g_ret_sts_success;
589:
584: THEN
585: RAISE FND_API.g_exc_unexpected_error;
586: END IF;
587:
588: x_return_status := FND_API.g_ret_sts_success;
589:
590: OPEN c_used_by;
591: FETCH c_used_by INTO l_used_by_id, l_used_by;
592: CLOSE c_used_by;
600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
601: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
602: FND_MSG_PUB.add;
603: END IF;
604: RAISE FND_API.g_exc_error;
605: END IF;
606:
607: /* -- added by julou on 03/07/2000
608: -- indicate if there is any other offers for this campaign
612:
613: IF l_dummy IS NULL THEN
614: AMS_ObjectAttribute_PVT.modify_object_attribute(
615: p_api_version => l_api_version,
616: p_init_msg_list => FND_API.g_false,
617: p_commit => FND_API.g_false,
618: p_validation_level => FND_API.g_valid_level_full,
619:
620: x_return_status => x_return_status,
613: IF l_dummy IS NULL THEN
614: AMS_ObjectAttribute_PVT.modify_object_attribute(
615: p_api_version => l_api_version,
616: p_init_msg_list => FND_API.g_false,
617: p_commit => FND_API.g_false,
618: p_validation_level => FND_API.g_valid_level_full,
619:
620: x_return_status => x_return_status,
621: x_msg_count => x_msg_count,
614: AMS_ObjectAttribute_PVT.modify_object_attribute(
615: p_api_version => l_api_version,
616: p_init_msg_list => FND_API.g_false,
617: p_commit => FND_API.g_false,
618: p_validation_level => FND_API.g_valid_level_full,
619:
620: x_return_status => x_return_status,
621: x_msg_count => x_msg_count,
622: x_msg_data => x_msg_data,
626: p_attr => 'OFFR',
627: p_attr_defined_flag => 'N'
628: );
629:
630: IF x_return_status = FND_API.g_ret_sts_error THEN
631: RAISE FND_API.g_exc_error;
632: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
633: RAISE FND_API.g_exc_unexpected_error;
634: END IF;
627: p_attr_defined_flag => 'N'
628: );
629:
630: IF x_return_status = FND_API.g_ret_sts_error THEN
631: RAISE FND_API.g_exc_error;
632: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
633: RAISE FND_API.g_exc_unexpected_error;
634: END IF;
635: END IF; */
628: );
629:
630: IF x_return_status = FND_API.g_ret_sts_error THEN
631: RAISE FND_API.g_exc_error;
632: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
633: RAISE FND_API.g_exc_unexpected_error;
634: END IF;
635: END IF; */
636:
629:
630: IF x_return_status = FND_API.g_ret_sts_error THEN
631: RAISE FND_API.g_exc_error;
632: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
633: RAISE FND_API.g_exc_unexpected_error;
634: END IF;
635: END IF; */
636:
637: -- finish
634: END IF;
635: END IF; */
636:
637: -- finish
638: IF FND_API.to_boolean(p_commit) THEN
639: COMMIT;
640: END IF;
641:
642: FND_MSG_PUB.count_and_get
640: END IF;
641:
642: FND_MSG_PUB.count_and_get
643: (
644: P_ENCODED => FND_API.g_false,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );
648:
646: p_data => x_msg_data
647: );
648:
649: EXCEPTION
650: WHEN FND_API.g_exc_error THEN
651: ROLLBACK TO delete_act_offer;
652: x_return_status := FND_API.g_ret_sts_error;
653: FND_MSG_PUB.count_and_get
654: (
648:
649: EXCEPTION
650: WHEN FND_API.g_exc_error THEN
651: ROLLBACK TO delete_act_offer;
652: x_return_status := FND_API.g_ret_sts_error;
653: FND_MSG_PUB.count_and_get
654: (
655: p_encoded => FND_API.g_false,
656: p_count => x_msg_count,
651: ROLLBACK TO delete_act_offer;
652: x_return_status := FND_API.g_ret_sts_error;
653: FND_MSG_PUB.count_and_get
654: (
655: p_encoded => FND_API.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659:
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659:
660: WHEN FND_API.g_exc_unexpected_error THEN
661: ROLLBACK TO delete_act_offer;
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
658: );
659:
660: WHEN FND_API.g_exc_unexpected_error THEN
661: ROLLBACK TO delete_act_offer;
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
661: ROLLBACK TO delete_act_offer;
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669:
668: );
669:
670: WHEN OTHERS THEN
671: ROLLBACK TO delete_act_offer;
672: x_return_status :=FND_API.g_ret_sts_unexp_error;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
674: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;
676: FND_MSG_PUB.count_and_get
674: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;
676: FND_MSG_PUB.count_and_get
677: (
678: p_encoded => FND_API.g_false,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682: END Delete_Act_Offer;
690: -------------------------------------------------------------------------------
691: PROCEDURE Lock_Act_Offer
692: (
693: p_api_version IN NUMBER,
694: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
695:
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
716:
717: BEGIN
718:
719: -- initialize
720: IF FND_API.to_boolean(p_init_msg_list) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724: IF NOT FND_API.compatible_api_call
720: IF FND_API.to_boolean(p_init_msg_list) THEN
721: FND_MSG_PUB.initialize;
722: END IF;
723:
724: IF NOT FND_API.compatible_api_call
725: (
726: l_api_version,
727: p_api_version,
728: l_api_name,
728: l_api_name,
729: g_pkg_name
730: )
731: THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;
734:
735: x_return_status := FND_API.g_ret_sts_success;
736:
731: THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;
734:
735: x_return_status := FND_API.g_ret_sts_success;
736:
737: -- lock
738: OPEN c_act_offer_b;
739: FETCH c_act_offer_b INTO l_act_offer_id;
742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
743: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
744: FND_MSG_PUB.add;
745: END IF;
746: RAISE FND_API.g_exc_error;
747: END IF;
748: CLOSE c_act_offer_b;
749:
750: -- finish
749:
750: -- finish
751: FND_MSG_PUB.count_and_get
752: (
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data
756: );
757:
756: );
757:
758: EXCEPTION
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
762: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
763: FND_MSG_PUB.add;
764: END IF;
763: FND_MSG_PUB.add;
764: END IF;
765: FND_MSG_PUB.count_and_get
766: (
767: p_encoded => FND_API.g_false,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771:
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771:
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
769: p_data => x_msg_data
770: );
771:
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789:
787: p_data => x_msg_data
788: );
789:
790: WHEN OTHERS THEN
791: x_return_status :=FND_API.g_ret_sts_unexp_error;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795: FND_MSG_PUB.count_and_get
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795: FND_MSG_PUB.count_and_get
796: (
797: p_encoded => FND_API.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801: END Lock_Act_Offer;
809: -------------------------------------------------------------------------------
810: PROCEDURE Validate_Act_Offer
811: (
812: p_api_version IN NUMBER,
813: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
814: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
815:
816: x_return_status OUT NOCOPY VARCHAR2,
817: x_msg_count OUT NOCOPY NUMBER,
810: PROCEDURE Validate_Act_Offer
811: (
812: p_api_version IN NUMBER,
813: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
814: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
815:
816: x_return_status OUT NOCOPY VARCHAR2,
817: x_msg_count OUT NOCOPY NUMBER,
818: x_msg_data OUT NOCOPY VARCHAR2,
829:
830: BEGIN
831:
832: ----------------------- initialize --------------------
833: IF NOT FND_API.compatible_api_call
834: (
835: l_api_version,
836: p_api_version,
837: l_api_name,
837: l_api_name,
838: g_pkg_name
839: )
840: THEN
841: RAISE FND_API.g_exc_unexpected_error;
842: END IF;
843:
844: x_return_status := FND_API.g_ret_sts_success;
845:
840: THEN
841: RAISE FND_API.g_exc_unexpected_error;
842: END IF;
843:
844: x_return_status := FND_API.g_ret_sts_success;
845:
846: ---------------------- validate ------------------------
847: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
848: check_items
851: x_return_status => l_return_status,
852: p_act_offer_rec => p_act_offer_rec
853: );
854:
855: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
856: RAISE FND_API.g_exc_unexpected_error;
857: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
858: RAISE FND_API.g_exc_error;
859: END IF;
852: p_act_offer_rec => p_act_offer_rec
853: );
854:
855: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
856: RAISE FND_API.g_exc_unexpected_error;
857: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
858: RAISE FND_API.g_exc_error;
859: END IF;
860: END IF;
853: );
854:
855: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
856: RAISE FND_API.g_exc_unexpected_error;
857: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
858: RAISE FND_API.g_exc_error;
859: END IF;
860: END IF;
861:
854:
855: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
856: RAISE FND_API.g_exc_unexpected_error;
857: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
858: RAISE FND_API.g_exc_error;
859: END IF;
860: END IF;
861:
862: -- record level
867: p_complete_rec => p_act_offer_rec,
868: x_return_status => l_return_status
869: );
870:
871: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
874: RAISE FND_API.g_exc_error;
875: END IF;
868: x_return_status => l_return_status
869: );
870:
871: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
874: RAISE FND_API.g_exc_error;
875: END IF;
876: END IF;
869: );
870:
871: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
874: RAISE FND_API.g_exc_error;
875: END IF;
876: END IF;
877:
870:
871: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
874: RAISE FND_API.g_exc_error;
875: END IF;
876: END IF;
877:
878: -------------------- finish --------------------------
877:
878: -------------------- finish --------------------------
879: FND_MSG_PUB.count_and_get
880: (
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,
883: p_data => x_msg_data
884: );
885:
883: p_data => x_msg_data
884: );
885:
886: EXCEPTION
887: WHEN FND_API.g_exc_error THEN
888: x_return_status := FND_API.g_ret_sts_error;
889: FND_MSG_PUB.count_and_get
890: (
891: p_encoded => FND_API.g_false,
884: );
885:
886: EXCEPTION
887: WHEN FND_API.g_exc_error THEN
888: x_return_status := FND_API.g_ret_sts_error;
889: FND_MSG_PUB.count_and_get
890: (
891: p_encoded => FND_API.g_false,
892: p_count => x_msg_count,
887: WHEN FND_API.g_exc_error THEN
888: x_return_status := FND_API.g_ret_sts_error;
889: FND_MSG_PUB.count_and_get
890: (
891: p_encoded => FND_API.g_false,
892: p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895:
892: p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895:
896: WHEN FND_API.g_exc_unexpected_error THEN
897: x_return_status := FND_API.g_ret_sts_unexp_error ;
898: FND_MSG_PUB.count_and_get
899: (
900: p_encoded => FND_API.g_false,
893: p_data => x_msg_data
894: );
895:
896: WHEN FND_API.g_exc_unexpected_error THEN
897: x_return_status := FND_API.g_ret_sts_unexp_error ;
898: FND_MSG_PUB.count_and_get
899: (
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
896: WHEN FND_API.g_exc_unexpected_error THEN
897: x_return_status := FND_API.g_ret_sts_unexp_error ;
898: FND_MSG_PUB.count_and_get
899: (
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904:
902: p_data => x_msg_data
903: );
904:
905: WHEN OTHERS THEN
906: x_return_status := FND_API.g_ret_sts_unexp_error;
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: END IF;
910: FND_MSG_PUB.count_and_get
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: END IF;
910: FND_MSG_PUB.count_and_get
911: (
912: p_encoded => FND_API.g_false,
913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );
916: END Validate_Act_Offer;
931: IS
932:
933: BEGIN
934:
935: x_return_status := FND_API.g_ret_sts_success;
936:
937: -- Following Code is Commented by PTENDULK as Activity Offer ID
938: -- can be null Also No need to send Object version Number
939: -- Date : 14Jan2000
946: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_ACT_OFFER_ID');
947: FND_MSG_PUB.add;
948: END IF;
949:
950: x_return_status := FND_API.g_ret_sts_error;
951: RETURN;
952: END IF;
953:
954: -- check object_version_number
959: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
960: FND_MSG_PUB.add;
961: END IF;
962:
963: x_return_status := FND_API.g_ret_sts_error;
964: RETURN;
965: END IF;
966:
967: -- check act_offer_used_by_id
970: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
971: FND_MSG_PUB.add;
972: END IF;
973:
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;
976: END IF;
977:
978: -- check arc_act_offer_used_by
981: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
982: FND_MSG_PUB.add;
983: END IF;
984:
985: x_return_status := FND_API.g_ret_sts_error;
986: RETURN;
987: END IF;
988:
989: -- check qp_list_header_id
992: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
993: FND_MSG_PUB.add;
994: END IF;
995:
996: x_return_status := FND_API.g_ret_sts_error;
997: RETURN;
998: END IF;
999:
1000: END Check_Req_Items;
1017: l_uk_flag VARCHAR2(1);
1018:
1019: BEGIN
1020:
1021: x_return_status := FND_API.g_ret_sts_success;
1022: -- rssharma fixed bug # 2747282
1023: -- don't allow adding duplicate offers to same campaign
1024: -- check PK, if activity_offer_id is passed in, must check if it is duplicate
1025: IF p_validation_mode = JTF_PLSQL_API.g_create
1045: );
1046:
1047: END IF;
1048:
1049: IF l_uk_flag = FND_API.g_false THEN
1050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1051: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_ID');
1052: FND_MSG_PUB.add;
1053: END IF;
1051: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_ID');
1052: FND_MSG_PUB.add;
1053: END IF;
1054:
1055: x_return_status := FND_API.g_ret_sts_error;
1056: RETURN;
1057: END IF;
1058: -- commented by julou 05/03/2001. offer_code is gone.
1059: /*
1074: );
1075: END IF;
1076: END IF;
1077:
1078: IF l_uk_flag = FND_API.g_false THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');
1081: FND_MSG_PUB.add;
1082: END IF;
1080: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');
1081: FND_MSG_PUB.add;
1082: END IF;
1083:
1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;
1086: END IF;
1087: */
1088: -- end of comment
1108: l_fk_flag VARCHAR2(1);
1109:
1110: BEGIN
1111:
1112: x_return_status := FND_API.g_ret_sts_success;
1113:
1114: -- Following Code Has been Modified by ptendulk
1115: -- Validate p_act_offer_rec.act_offer_used_by_id against View
1116: -- check act_offer_used_by_id
1113:
1114: -- Following Code Has been Modified by ptendulk
1115: -- Validate p_act_offer_rec.act_offer_used_by_id against View
1116: -- check act_offer_used_by_id
1117: IF p_act_offer_rec.act_offer_used_by_id <> FND_API.g_miss_num
1118: AND
1119: p_act_offer_rec.act_offer_used_by_id IS NOT NULL
1120: THEN
1121: IF p_act_offer_rec.arc_act_offer_used_by = 'CAMP' THEN
1135: );
1136: END IF;
1137: END IF;
1138:
1139: IF l_fk_flag = FND_API.g_false THEN
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1141: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
1142: FND_MSG_PUB.add;
1143: END IF;
1141: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
1142: FND_MSG_PUB.add;
1143: END IF;
1144:
1145: x_return_status := FND_API.g_ret_sts_error;
1146: RETURN;
1147: END IF;
1148: END IF;
1149:
1149:
1150: -- Following Code has been modified by ptendulk
1151: -- Validate against QP_LIST_HEADERS_VL
1152: -- check qp_list_header_id
1153: IF p_act_offer_rec.qp_list_header_id <> FND_API.g_miss_num THEN
1154: l_fk_flag := OZF_Utility_PVT.check_fk_exists
1155: (
1156: 'QP_LIST_HEADERS_VL',
1157: 'list_header_id',
1157: 'list_header_id',
1158: p_act_offer_rec.qp_list_header_id
1159: );
1160:
1161: IF l_fk_flag = FND_API.g_false THEN
1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1163: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
1164: FND_MSG_PUB.add;
1165: END IF;
1163: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
1164: FND_MSG_PUB.add;
1165: END IF;
1166:
1167: x_return_status := FND_API.g_ret_sts_error;
1168: RETURN;
1169: END IF;
1170: END IF;
1171:
1186: IS
1187:
1188: BEGIN
1189:
1190: x_return_status := FND_API.g_ret_sts_success;
1191:
1192: -- Following Code has been Changed by ptendulk
1193: -- as Only Campaign can create Offers
1194:
1192: -- Following Code has been Changed by ptendulk
1193: -- as Only Campaign can create Offers
1194:
1195: -- check arc_act_offer_used_by
1196: -- IF p_act_offer_rec.arc_act_offer_used_by <> FND_API.g_miss_char
1197: -- AND p_act_offer_rec.arc_act_offer_used_by NOT IN ('ECAM', 'MCAM', 'RCAM', 'CAMP')
1198: -- THEN
1199: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: -- FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1201: -- FND_MSG_PUB.add;
1202: -- END IF;
1203: --OZF_UTILITY_PVT.debug_message(g_pkg_name||': check used_by');
1204: --OZF_UTILITY_PVT.debug_message('used by: ' || p_act_offer_rec.arc_act_offer_used_by);
1205: IF p_act_offer_rec.arc_act_offer_used_by <> FND_API.g_miss_char
1206: AND (p_act_offer_rec.arc_act_offer_used_by <> 'CAMP'
1207: AND p_act_offer_rec.arc_act_offer_used_by <> 'CSCH')
1208: THEN
1209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1210: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1211: FND_MSG_PUB.add;
1212: END IF;
1213:
1214: x_return_status := FND_API.g_ret_sts_error;
1215: RETURN;
1216: END IF;
1217: -- commented by julou 05/03/2001. offer_type, status_code, lumpsum_payment_type are gone
1218: /*
1216: END IF;
1217: -- commented by julou 05/03/2001. offer_type, status_code, lumpsum_payment_type are gone
1218: /*
1219: -- check offer_type
1220: IF p_act_offer_rec.offer_type <> FND_API.g_miss_char
1221: AND p_act_offer_rec.offer_type IS NOT NULL
1222: THEN
1223: IF OZF_Utility_PVT.check_lookup_exists(
1224: p_lookup_type => 'OZF_OFFER_TYPE',
1222: THEN
1223: IF OZF_Utility_PVT.check_lookup_exists(
1224: p_lookup_type => 'OZF_OFFER_TYPE',
1225: p_lookup_code => p_act_offer_rec.offer_type
1226: ) = FND_API.g_false
1227: THEN
1228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1229: THEN
1230: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_OFFER_TYPE');
1229: THEN
1230: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_OFFER_TYPE');
1231: FND_MSG_PUB.add;
1232: END IF;
1233: x_return_status := FND_API.g_ret_sts_error;
1234: RETURN;
1235: END IF;
1236: END IF;
1237:
1235: END IF;
1236: END IF;
1237:
1238: -- check status_code
1239: IF p_act_offer_rec.status_code <> FND_API.g_miss_char
1240: AND p_act_offer_rec.status_code IS NOT NULL
1241: THEN
1242: IF OZF_Utility_PVT.check_lookup_exists(
1243: p_lookup_type => 'OZF_OFFER_STATUS',
1241: THEN
1242: IF OZF_Utility_PVT.check_lookup_exists(
1243: p_lookup_type => 'OZF_OFFER_STATUS',
1244: p_lookup_code => p_act_offer_rec.status_code
1245: ) = FND_API.g_false
1246: THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1248: THEN
1249: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_STATUS');
1248: THEN
1249: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_STATUS');
1250: FND_MSG_PUB.add;
1251: END IF;
1252: x_return_status := FND_API.g_ret_sts_error;
1253: RETURN;
1254: END IF;
1255: END IF;
1256:
1254: END IF;
1255: END IF;
1256:
1257: -- check lumpsum_payment_type
1258: IF p_act_offer_rec.lumpsum_payment_type <> FND_API.g_miss_char
1259: AND p_act_offer_rec.lumpsum_payment_type IS NOT NULL
1260: THEN
1261: IF OZF_Utility_PVT.check_lookup_exists(
1262: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1260: THEN
1261: IF OZF_Utility_PVT.check_lookup_exists(
1262: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1263: p_lookup_code => p_act_offer_rec.lumpsum_payment_type
1264: ) = FND_API.g_false
1265: THEN
1266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1267: THEN
1268: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_PAYMENT');
1267: THEN
1268: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_BAD_PAYMENT');
1269: FND_MSG_PUB.add;
1270: END IF;
1271: x_return_status := FND_API.g_ret_sts_error;
1272: RETURN;
1273: END IF;
1274: END IF;
1275: */
1297: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1298:
1299: BEGIN
1300:
1301: x_return_status := FND_API.g_ret_sts_success;
1302:
1303: -- check required items
1304: check_req_items
1305: (
1307: p_act_offer_rec => p_act_offer_rec,
1308: x_return_status => x_return_status
1309: );
1310:
1311: IF x_return_status <> FND_API.g_ret_sts_success THEN
1312: RETURN;
1313: END IF;
1314:
1315: -- check unique key items
1319: p_act_offer_rec => p_act_offer_rec,
1320: x_return_status => x_return_status
1321: );
1322:
1323: IF x_return_status <> FND_API.g_ret_sts_success THEN
1324: RETURN;
1325: END IF;
1326:
1327: -- check foreign key items
1330: p_act_offer_rec => p_act_offer_rec,
1331: x_return_status => x_return_status
1332: );
1333:
1334: IF x_return_status <> FND_API.g_ret_sts_success THEN
1335: RETURN;
1336: END IF;
1337:
1338: -- check lookup items
1341: p_act_offer_rec => p_act_offer_rec,
1342: x_return_status => x_return_status
1343: );
1344:
1345: IF x_return_status <> FND_API.g_ret_sts_success THEN
1346: RETURN;
1347: END IF;
1348:
1349: END Check_Items;
1391: l_active NUMBER;
1392:
1393: BEGIN
1394:
1395: x_return_status := FND_API.g_ret_sts_success;
1396:
1397: -- commented by julou 05/03/2001. These dates are gone
1398: /*
1399: -- check offer dates
1402: THEN
1403: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_START_AFTER_END');
1404: FND_MSG_PUB.add;
1405: END IF;
1406: x_return_status := FND_API.g_ret_sts_error;
1407: END IF;
1408:
1409: IF p_complete_rec.order_date_from > p_complete_rec.order_date_to THEN
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1411: THEN
1412: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_ORDER_DATES');
1413: FND_MSG_PUB.add;
1414: END IF;
1415: x_return_status := FND_API.g_ret_sts_error;
1416: END IF;
1417:
1418: IF p_complete_rec.ship_date_from > p_complete_rec.ship_date_to THEN
1419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1420: THEN
1421: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_SHIP_DATES');
1422: FND_MSG_PUB.add;
1423: END IF;
1424: x_return_status := FND_API.g_ret_sts_error;
1425: END IF;
1426:
1427: IF p_complete_rec.perf_date_from > p_complete_rec.perf_date_to THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_BAD_PERF_DATES');
1431: FND_MSG_PUB.add;
1432: END IF;
1433: x_return_status := FND_API.g_ret_sts_error;
1434: END IF;
1435: */
1436: -- check if the campaign is active
1437: IF p_complete_rec.arc_act_offer_used_by = 'CAMP' THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_CAMP_EXPIRED');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: x_return_status := FND_API.g_ret_sts_error;
1448: RETURN;
1449: END IF;
1450: END IF;
1451:
1460: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1461: FND_MSG_PUB.add;
1462: END IF;
1463:
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;
1466: END IF;
1467: CLOSE c_primary_offer_count1;
1468: ELSE
1474: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1475: FND_MSG_PUB.add;
1476: END IF;
1477:
1478: x_return_status := FND_API.g_ret_sts_error;
1479: RETURN;
1480: END IF;
1481: CLOSE c_primary_offer_count2;
1482: END IF;
1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1518: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1519: FND_MSG_PUB.add;
1520: END IF;
1521: RAISE FND_API.g_exc_error;
1522: END IF;
1523: CLOSE c_act_offer;
1524:
1525: IF p_act_offer_rec.act_offer_used_by_id = FND_API.g_miss_num THEN
1521: RAISE FND_API.g_exc_error;
1522: END IF;
1523: CLOSE c_act_offer;
1524:
1525: IF p_act_offer_rec.act_offer_used_by_id = FND_API.g_miss_num THEN
1526: x_complete_rec.act_offer_used_by_id := l_act_offer_rec.act_offer_used_by_id;
1527: END IF;
1528:
1529: IF p_act_offer_rec.arc_act_offer_used_by = FND_API.g_miss_char THEN
1525: IF p_act_offer_rec.act_offer_used_by_id = FND_API.g_miss_num THEN
1526: x_complete_rec.act_offer_used_by_id := l_act_offer_rec.act_offer_used_by_id;
1527: END IF;
1528:
1529: IF p_act_offer_rec.arc_act_offer_used_by = FND_API.g_miss_char THEN
1530: x_complete_rec.arc_act_offer_used_by := l_act_offer_rec.arc_act_offer_used_by;
1531: END IF;
1532: -- commented by julou 05/03/2001. offer_type and offer_code are gone.
1533: /*
1530: x_complete_rec.arc_act_offer_used_by := l_act_offer_rec.arc_act_offer_used_by;
1531: END IF;
1532: -- commented by julou 05/03/2001. offer_type and offer_code are gone.
1533: /*
1534: IF p_act_offer_rec.offer_type = FND_API.g_miss_char THEN
1535: x_complete_rec.offer_type := l_act_offer_rec.offer_type;
1536: END IF;
1537:
1538: IF p_act_offer_rec.offer_code = FND_API.g_miss_char THEN
1534: IF p_act_offer_rec.offer_type = FND_API.g_miss_char THEN
1535: x_complete_rec.offer_type := l_act_offer_rec.offer_type;
1536: END IF;
1537:
1538: IF p_act_offer_rec.offer_code = FND_API.g_miss_char THEN
1539: x_complete_rec.offer_code := l_act_offer_rec.offer_code;
1540: END IF;
1541: */
1542: -- ==================================================================
1542: -- ==================================================================
1543: -- Following line of code is added by ptendulk on 08Jun2000
1544: -- Check for the primary offer Flag
1545: -- =================================================================
1546: IF p_act_offer_rec.primary_offer_flag = FND_API.g_miss_char THEN
1547: x_complete_rec.primary_offer_flag := l_act_offer_rec.primary_offer_flag ;
1548: END IF;
1549:
1550: IF p_act_offer_rec.active_period_set = FND_API.g_miss_char THEN
1546: IF p_act_offer_rec.primary_offer_flag = FND_API.g_miss_char THEN
1547: x_complete_rec.primary_offer_flag := l_act_offer_rec.primary_offer_flag ;
1548: END IF;
1549:
1550: IF p_act_offer_rec.active_period_set = FND_API.g_miss_char THEN
1551: x_complete_rec.active_period_set := l_act_offer_rec.active_period_set;
1552: END IF;
1553:
1554: IF p_act_offer_rec.active_period = FND_API.g_miss_char THEN
1550: IF p_act_offer_rec.active_period_set = FND_API.g_miss_char THEN
1551: x_complete_rec.active_period_set := l_act_offer_rec.active_period_set;
1552: END IF;
1553:
1554: IF p_act_offer_rec.active_period = FND_API.g_miss_char THEN
1555: x_complete_rec.active_period := l_act_offer_rec.active_period;
1556: END IF;
1557: -- commented by julou 05/03/2001. These dates are gone.
1558: /*
1555: x_complete_rec.active_period := l_act_offer_rec.active_period;
1556: END IF;
1557: -- commented by julou 05/03/2001. These dates are gone.
1558: /*
1559: IF p_act_offer_rec.start_date = FND_API.g_miss_date THEN
1560: x_complete_rec.start_date := l_act_offer_rec.start_date;
1561: END IF;
1562:
1563: IF p_act_offer_rec.end_date = FND_API.g_miss_date THEN
1559: IF p_act_offer_rec.start_date = FND_API.g_miss_date THEN
1560: x_complete_rec.start_date := l_act_offer_rec.start_date;
1561: END IF;
1562:
1563: IF p_act_offer_rec.end_date = FND_API.g_miss_date THEN
1564: x_complete_rec.end_date := l_act_offer_rec.end_date;
1565: END IF;
1566:
1567: IF p_act_offer_rec.order_date_from = FND_API.g_miss_date THEN
1563: IF p_act_offer_rec.end_date = FND_API.g_miss_date THEN
1564: x_complete_rec.end_date := l_act_offer_rec.end_date;
1565: END IF;
1566:
1567: IF p_act_offer_rec.order_date_from = FND_API.g_miss_date THEN
1568: x_complete_rec.order_date_from := l_act_offer_rec.order_date_from;
1569: END IF;
1570:
1571: IF p_act_offer_rec.order_date_to = FND_API.g_miss_date THEN
1567: IF p_act_offer_rec.order_date_from = FND_API.g_miss_date THEN
1568: x_complete_rec.order_date_from := l_act_offer_rec.order_date_from;
1569: END IF;
1570:
1571: IF p_act_offer_rec.order_date_to = FND_API.g_miss_date THEN
1572: x_complete_rec.order_date_to := l_act_offer_rec.order_date_to;
1573: END IF;
1574:
1575: IF p_act_offer_rec.ship_date_from = FND_API.g_miss_date THEN
1571: IF p_act_offer_rec.order_date_to = FND_API.g_miss_date THEN
1572: x_complete_rec.order_date_to := l_act_offer_rec.order_date_to;
1573: END IF;
1574:
1575: IF p_act_offer_rec.ship_date_from = FND_API.g_miss_date THEN
1576: x_complete_rec.ship_date_from := l_act_offer_rec.ship_date_from;
1577: END IF;
1578:
1579: IF p_act_offer_rec.ship_date_to = FND_API.g_miss_date THEN
1575: IF p_act_offer_rec.ship_date_from = FND_API.g_miss_date THEN
1576: x_complete_rec.ship_date_from := l_act_offer_rec.ship_date_from;
1577: END IF;
1578:
1579: IF p_act_offer_rec.ship_date_to = FND_API.g_miss_date THEN
1580: x_complete_rec.ship_date_to := l_act_offer_rec.ship_date_to;
1581: END IF;
1582:
1583: IF p_act_offer_rec.perf_date_from = FND_API.g_miss_date THEN
1579: IF p_act_offer_rec.ship_date_to = FND_API.g_miss_date THEN
1580: x_complete_rec.ship_date_to := l_act_offer_rec.ship_date_to;
1581: END IF;
1582:
1583: IF p_act_offer_rec.perf_date_from = FND_API.g_miss_date THEN
1584: x_complete_rec.perf_date_from := l_act_offer_rec.perf_date_from;
1585: END IF;
1586:
1587: IF p_act_offer_rec.perf_date_to = FND_API.g_miss_date THEN
1583: IF p_act_offer_rec.perf_date_from = FND_API.g_miss_date THEN
1584: x_complete_rec.perf_date_from := l_act_offer_rec.perf_date_from;
1585: END IF;
1586:
1587: IF p_act_offer_rec.perf_date_to = FND_API.g_miss_date THEN
1588: x_complete_rec.perf_date_to := l_act_offer_rec.perf_date_to;
1589: END IF;
1590:
1591: IF p_act_offer_rec.status_code = FND_API.g_miss_char THEN
1587: IF p_act_offer_rec.perf_date_to = FND_API.g_miss_date THEN
1588: x_complete_rec.perf_date_to := l_act_offer_rec.perf_date_to;
1589: END IF;
1590:
1591: IF p_act_offer_rec.status_code = FND_API.g_miss_char THEN
1592: x_complete_rec.status_code := l_act_offer_rec.status_code;
1593: END IF;
1594:
1595: IF p_act_offer_rec.status_date = FND_API.g_miss_date
1591: IF p_act_offer_rec.status_code = FND_API.g_miss_char THEN
1592: x_complete_rec.status_code := l_act_offer_rec.status_code;
1593: END IF;
1594:
1595: IF p_act_offer_rec.status_date = FND_API.g_miss_date
1596: OR p_act_offer_rec.status_date IS NULL
1597: THEN
1598: IF x_complete_rec.status_code = l_act_offer_rec.status_code THEN
1599: -- no status change, set it to be the original value
1603: x_complete_rec.status_date := SYSDATE;
1604: END IF;
1605: END IF;
1606:
1607: IF p_act_offer_rec.offer_amount = FND_API.g_miss_num THEN
1608: x_complete_rec.offer_amount := l_act_offer_rec.offer_amount;
1609: END IF;
1610:
1611: IF p_act_offer_rec.lumpsum_payment_type = FND_API.g_miss_char THEN
1607: IF p_act_offer_rec.offer_amount = FND_API.g_miss_num THEN
1608: x_complete_rec.offer_amount := l_act_offer_rec.offer_amount;
1609: END IF;
1610:
1611: IF p_act_offer_rec.lumpsum_payment_type = FND_API.g_miss_char THEN
1612: x_complete_rec.lumpsum_payment_type := l_act_offer_rec.lumpsum_payment_type;
1613: END IF;
1614: */
1615: -- end of comment
1612: x_complete_rec.lumpsum_payment_type := l_act_offer_rec.lumpsum_payment_type;
1613: END IF;
1614: */
1615: -- end of comment
1616: IF p_act_offer_rec.qp_list_header_id = FND_API.g_miss_num THEN
1617: x_complete_rec.qp_list_header_id := l_act_offer_rec.qp_list_header_id;
1618: END IF;
1619:
1620: END Complete_Rec;
1634: IS
1635:
1636: BEGIN
1637:
1638: x_act_offer_rec.activity_offer_id := FND_API.g_miss_num;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1635:
1636: BEGIN
1637:
1638: x_act_offer_rec.activity_offer_id := FND_API.g_miss_num;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1636: BEGIN
1637:
1638: x_act_offer_rec.activity_offer_id := FND_API.g_miss_num;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1637:
1638: x_act_offer_rec.activity_offer_id := FND_API.g_miss_num;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1638: x_act_offer_rec.activity_offer_id := FND_API.g_miss_num;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1639: x_act_offer_rec.last_update_date := FND_API.g_miss_date;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1640: x_act_offer_rec.last_updated_by := FND_API.g_miss_num;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1641: x_act_offer_rec.creation_date := FND_API.g_miss_date;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1642: x_act_offer_rec.created_by := FND_API.g_miss_num;
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1643: x_act_offer_rec.last_update_login := FND_API.g_miss_num;
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1644: x_act_offer_rec.object_version_number := FND_API.g_miss_num;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1645: x_act_offer_rec.act_offer_used_by_id := FND_API.g_miss_num;
1646: x_act_offer_rec.arc_act_offer_used_by := FND_API.g_miss_char;
1647: x_act_offer_rec.primary_offer_flag := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1648: x_act_offer_rec.active_period_set := FND_API.g_miss_char;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1649: x_act_offer_rec.active_period := FND_API.g_miss_char;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1650: -- commented by julou 05/03/2001. These columns are gone.
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1651: /*
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1652: x_act_offer_rec.offer_type := FND_API.g_miss_char;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1653: x_act_offer_rec.offer_code := FND_API.g_miss_char;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1654: x_act_offer_rec.start_date := FND_API.g_miss_date;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1655: x_act_offer_rec.end_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1656: x_act_offer_rec.order_date_from := FND_API.g_miss_date;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1657: x_act_offer_rec.order_date_to := FND_API.g_miss_date;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1658: x_act_offer_rec.ship_date_from := FND_API.g_miss_date;
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1666: */
1659: x_act_offer_rec.ship_date_to := FND_API.g_miss_date;
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1666: */
1667: -- end of comment
1660: x_act_offer_rec.perf_date_from := FND_API.g_miss_date;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1666: */
1667: -- end of comment
1668: x_act_offer_rec.qp_list_header_id := FND_API.g_miss_num;
1661: x_act_offer_rec.perf_date_to := FND_API.g_miss_date;
1662: x_act_offer_rec.status_code := FND_API.g_miss_char;
1663: x_act_offer_rec.status_date := FND_API.g_miss_date;
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1666: */
1667: -- end of comment
1668: x_act_offer_rec.qp_list_header_id := FND_API.g_miss_num;
1669:
1664: x_act_offer_rec.offer_amount := FND_API.g_miss_num;
1665: x_act_offer_rec.lumpsum_payment_type := FND_API.g_miss_char;
1666: */
1667: -- end of comment
1668: x_act_offer_rec.qp_list_header_id := FND_API.g_miss_num;
1669:
1670: END Init_Rec;
1671:
1672: --==================================================================================
1699: -- End of Comments
1700: PROCEDURE Create_Offer
1701: (
1702: p_api_version IN NUMBER,
1703: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1704: p_commit IN VARCHAR2 := FND_API.g_false,
1705: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1706:
1707: x_return_status OUT NOCOPY VARCHAR2,
1700: PROCEDURE Create_Offer
1701: (
1702: p_api_version IN NUMBER,
1703: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1704: p_commit IN VARCHAR2 := FND_API.g_false,
1705: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1706:
1707: x_return_status OUT NOCOPY VARCHAR2,
1708: x_msg_count OUT NOCOPY NUMBER,
1701: (
1702: p_api_version IN NUMBER,
1703: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1704: p_commit IN VARCHAR2 := FND_API.g_false,
1705: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1706:
1707: x_return_status OUT NOCOPY VARCHAR2,
1708: x_msg_count OUT NOCOPY NUMBER,
1709: x_msg_data OUT NOCOPY VARCHAR2,
1708: x_msg_count OUT NOCOPY NUMBER,
1709: x_msg_data OUT NOCOPY VARCHAR2,
1710:
1711: p_act_offer_rec IN act_offer_rec_type,
1712: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1709: x_msg_data OUT NOCOPY VARCHAR2,
1710:
1711: p_act_offer_rec IN act_offer_rec_type,
1712: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1717: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1710:
1711: p_act_offer_rec IN act_offer_rec_type,
1712: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1717: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1718: p_automatic_flag IN VARCHAR2 := 'Y',
1711: p_act_offer_rec IN act_offer_rec_type,
1712: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1717: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1718: p_automatic_flag IN VARCHAR2 := 'Y',
1719: p_invoice_flag IN VARCHAR2 := 'Y',
1712: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1717: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1718: p_automatic_flag IN VARCHAR2 := 'Y',
1719: p_invoice_flag IN VARCHAR2 := 'Y',
1720:
1713: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1714: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1715: p_start_date IN DATE := FND_API.g_miss_date,
1716: p_end_date IN DATE := FND_API.g_miss_date,
1717: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1718: p_automatic_flag IN VARCHAR2 := 'Y',
1719: p_invoice_flag IN VARCHAR2 := 'Y',
1720:
1721: x_list_header_id OUT NOCOPY NUMBER,
1735: -- initialize
1736: SAVEPOINT Create_Offer;
1737: x_message_type := 'FND' ;
1738:
1739: IF FND_API.to_boolean(p_init_msg_list) THEN
1740: FND_MSG_PUB.initialize;
1741: END IF;
1742:
1743: IF NOT FND_API.compatible_api_call
1739: IF FND_API.to_boolean(p_init_msg_list) THEN
1740: FND_MSG_PUB.initialize;
1741: END IF;
1742:
1743: IF NOT FND_API.compatible_api_call
1744: (
1745: l_api_version,
1746: p_api_version,
1747: l_api_name,
1747: l_api_name,
1748: g_pkg_name
1749: )
1750: THEN
1751: RAISE FND_API.g_exc_unexpected_error;
1752: END IF;
1753:
1754: x_return_status := FND_API.g_ret_sts_success;
1755:
1750: THEN
1751: RAISE FND_API.g_exc_unexpected_error;
1752: END IF;
1753:
1754: x_return_status := FND_API.g_ret_sts_success;
1755:
1756:
1757: --
1758: -- Create the List Header for the offer
1776:
1777: x_list_header_id => l_list_header_id
1778: );
1779:
1780: IF l_return_status = FND_API.g_ret_sts_error THEN
1781: x_message_type := 'OE' ;
1782: RAISE FND_API.g_exc_error;
1783: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: x_message_type := 'OE' ;
1778: );
1779:
1780: IF l_return_status = FND_API.g_ret_sts_error THEN
1781: x_message_type := 'OE' ;
1782: RAISE FND_API.g_exc_error;
1783: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: x_message_type := 'OE' ;
1785: RAISE FND_API.g_exc_unexpected_error;
1786: END IF;
1779:
1780: IF l_return_status = FND_API.g_ret_sts_error THEN
1781: x_message_type := 'OE' ;
1782: RAISE FND_API.g_exc_error;
1783: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: x_message_type := 'OE' ;
1785: RAISE FND_API.g_exc_unexpected_error;
1786: END IF;
1787:
1781: x_message_type := 'OE' ;
1782: RAISE FND_API.g_exc_error;
1783: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1784: x_message_type := 'OE' ;
1785: RAISE FND_API.g_exc_unexpected_error;
1786: END IF;
1787:
1788: OZF_Utility_Pvt.Debug_Message('Created List Header for the offers');
1789:
1814: --
1815: -- x_list_line_id => l_line_id
1816: -- );
1817: --
1818: -- IF x_return_status = FND_API.g_ret_sts_error THEN
1819: -- x_message_type := 'OE' ;
1820: -- RAISE FND_API.g_exc_error;
1821: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1822: -- x_message_type := 'OE' ;
1816: -- );
1817: --
1818: -- IF x_return_status = FND_API.g_ret_sts_error THEN
1819: -- x_message_type := 'OE' ;
1820: -- RAISE FND_API.g_exc_error;
1821: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1822: -- x_message_type := 'OE' ;
1823: -- RAISE FND_API.g_exc_unexpected_error;
1824: -- END IF;
1817: --
1818: -- IF x_return_status = FND_API.g_ret_sts_error THEN
1819: -- x_message_type := 'OE' ;
1820: -- RAISE FND_API.g_exc_error;
1821: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1822: -- x_message_type := 'OE' ;
1823: -- RAISE FND_API.g_exc_unexpected_error;
1824: -- END IF;
1825: -- END IF;
1819: -- x_message_type := 'OE' ;
1820: -- RAISE FND_API.g_exc_error;
1821: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1822: -- x_message_type := 'OE' ;
1823: -- RAISE FND_API.g_exc_unexpected_error;
1824: -- END IF;
1825: -- END IF;
1826: --
1827: -- Create the record in Activity Offers
1843: p_act_offer_rec => l_act_offer_rec,
1844: x_act_offer_id => x_act_offer_id
1845: ) ;
1846:
1847: IF l_return_status = FND_API.g_ret_sts_error THEN
1848: x_message_type := 'FND' ;
1849: RAISE FND_API.g_exc_error;
1850: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: x_message_type := 'FND' ;
1845: ) ;
1846:
1847: IF l_return_status = FND_API.g_ret_sts_error THEN
1848: x_message_type := 'FND' ;
1849: RAISE FND_API.g_exc_error;
1850: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: x_message_type := 'FND' ;
1852: RAISE FND_API.g_exc_unexpected_error;
1853: END IF;
1846:
1847: IF l_return_status = FND_API.g_ret_sts_error THEN
1848: x_message_type := 'FND' ;
1849: RAISE FND_API.g_exc_error;
1850: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: x_message_type := 'FND' ;
1852: RAISE FND_API.g_exc_unexpected_error;
1853: END IF;
1854:
1848: x_message_type := 'FND' ;
1849: RAISE FND_API.g_exc_error;
1850: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: x_message_type := 'FND' ;
1852: RAISE FND_API.g_exc_unexpected_error;
1853: END IF;
1854:
1855: --
1856: -- END of API body.
1857: --
1858: l_list_header_id := x_list_header_id ;
1859:
1860: -- Standard check of p_commit.
1861: IF FND_API.To_Boolean ( p_commit )
1862: THEN
1863: COMMIT WORK;
1864: END IF;
1865:
1868: --
1869: FND_MSG_PUB.Count_AND_Get
1870: ( p_count => x_msg_count,
1871: p_data => x_msg_data,
1872: p_encoded => FND_API.G_FALSE
1873: );
1874:
1875: OE_MSG_PUB.Count_AND_Get
1876: ( p_count => x_msg_count,
1874:
1875: OE_MSG_PUB.Count_AND_Get
1876: ( p_count => x_msg_count,
1877: p_data => x_msg_data,
1878: p_encoded => FND_API.G_FALSE
1879: );
1880:
1881: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1882:
1881: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1882:
1883: EXCEPTION
1884:
1885: WHEN FND_API.G_EXC_ERROR THEN
1886:
1887: ROLLBACK TO Create_Offer;
1888: x_return_status := FND_API.G_RET_STS_ERROR ;
1889:
1884:
1885: WHEN FND_API.G_EXC_ERROR THEN
1886:
1887: ROLLBACK TO Create_Offer;
1888: x_return_status := FND_API.G_RET_STS_ERROR ;
1889:
1890: IF x_message_type = 'FND' THEN
1891: FND_MSG_PUB.Count_AND_Get
1892: ( p_count => x_msg_count,
1890: IF x_message_type = 'FND' THEN
1891: FND_MSG_PUB.Count_AND_Get
1892: ( p_count => x_msg_count,
1893: p_data => x_msg_data,
1894: p_encoded => FND_API.G_FALSE
1895: );
1896: ELSIF x_message_type = 'OE' THEN
1897: OE_MSG_PUB.Count_AND_Get
1898: ( p_count => x_msg_count,
1896: ELSIF x_message_type = 'OE' THEN
1897: OE_MSG_PUB.Count_AND_Get
1898: ( p_count => x_msg_count,
1899: p_data => x_msg_data,
1900: p_encoded => FND_API.G_FALSE
1901: );
1902: END IF ;
1903:
1904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1900: p_encoded => FND_API.G_FALSE
1901: );
1902: END IF ;
1903:
1904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1905:
1906: ROLLBACK TO Create_Offer;
1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1908:
1903:
1904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1905:
1906: ROLLBACK TO Create_Offer;
1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1908:
1909: IF x_message_type = 'FND' THEN
1910: FND_MSG_PUB.Count_AND_Get
1911: ( p_count => x_msg_count,
1909: IF x_message_type = 'FND' THEN
1910: FND_MSG_PUB.Count_AND_Get
1911: ( p_count => x_msg_count,
1912: p_data => x_msg_data,
1913: p_encoded => FND_API.G_FALSE
1914: );
1915: ELSIF x_message_type = 'OE' THEN
1916: OE_MSG_PUB.Count_AND_Get
1917: ( p_count => x_msg_count,
1915: ELSIF x_message_type = 'OE' THEN
1916: OE_MSG_PUB.Count_AND_Get
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data,
1919: p_encoded => FND_API.G_FALSE
1920: );
1921: END IF ;
1922:
1923:
1923:
1924: WHEN OTHERS THEN
1925:
1926: ROLLBACK TO Create_Offer;
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1928:
1929: IF x_message_type = 'FND' THEN
1930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1931: THEN
1934:
1935: FND_MSG_PUB.Count_AND_Get
1936: ( p_count => x_msg_count,
1937: p_data => x_msg_data,
1938: p_encoded => FND_API.G_FALSE
1939: );
1940: ELSIF x_message_type = 'OE' THEN
1941: IF OE_MSG_PUB.Check_Msg_Level ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1942: THEN
1944: END IF;
1945: OE_MSG_PUB.Count_AND_Get
1946: ( p_count => x_msg_count,
1947: p_data => x_msg_data,
1948: p_encoded => FND_API.G_FALSE
1949: );
1950: END IF ;
1951:
1952: END Create_Offer ;
1975: -- End of Comments
1976: PROCEDURE Update_Offer
1977: (
1978: p_api_version IN NUMBER,
1979: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1980: p_commit IN VARCHAR2 := FND_API.g_false,
1981: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1982:
1983: x_return_status OUT NOCOPY VARCHAR2,
1976: PROCEDURE Update_Offer
1977: (
1978: p_api_version IN NUMBER,
1979: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1980: p_commit IN VARCHAR2 := FND_API.g_false,
1981: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1982:
1983: x_return_status OUT NOCOPY VARCHAR2,
1984: x_msg_count OUT NOCOPY NUMBER,
1977: (
1978: p_api_version IN NUMBER,
1979: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1980: p_commit IN VARCHAR2 := FND_API.g_false,
1981: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1982:
1983: x_return_status OUT NOCOPY VARCHAR2,
1984: x_msg_count OUT NOCOPY NUMBER,
1985: x_msg_data OUT NOCOPY VARCHAR2,
1984: x_msg_count OUT NOCOPY NUMBER,
1985: x_msg_data OUT NOCOPY VARCHAR2,
1986:
1987: p_act_offer_rec IN act_offer_rec_type,
1988: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1985: x_msg_data OUT NOCOPY VARCHAR2,
1986:
1987: p_act_offer_rec IN act_offer_rec_type,
1988: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1986:
1987: p_act_offer_rec IN act_offer_rec_type,
1988: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1994: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
1987: p_act_offer_rec IN act_offer_rec_type,
1988: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1994: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
1995:
1988: p_list_header_id IN NUMBER := FND_API.g_miss_num,
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1994: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
1995:
1996: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
1989: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1994: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
1995:
1996: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
1997: )
1990: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
1991: p_start_date IN DATE := FND_API.g_miss_date,
1992: p_end_date IN DATE := FND_API.g_miss_date,
1993: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
1994: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
1995:
1996: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
1997: )
1998: IS
2008: SAVEPOINT Update_Offer;
2009:
2010: x_message_type := 'FND' ;
2011:
2012: IF FND_API.to_boolean(p_init_msg_list) THEN
2013: FND_MSG_PUB.initialize;
2014: END IF;
2015:
2016: IF NOT FND_API.compatible_api_call
2012: IF FND_API.to_boolean(p_init_msg_list) THEN
2013: FND_MSG_PUB.initialize;
2014: END IF;
2015:
2016: IF NOT FND_API.compatible_api_call
2017: (
2018: l_api_version,
2019: p_api_version,
2020: l_api_name,
2020: l_api_name,
2021: g_pkg_name
2022: )
2023: THEN
2024: RAISE FND_API.g_exc_unexpected_error;
2025: END IF;
2026:
2027: x_return_status := FND_API.g_ret_sts_success;
2028:
2023: THEN
2024: RAISE FND_API.g_exc_unexpected_error;
2025: END IF;
2026:
2027: x_return_status := FND_API.g_ret_sts_success;
2028:
2029:
2030: --
2031: -- Create the List Header for the offer
2049:
2050: x_list_header_id => l_list_header_id
2051: );
2052:
2053: IF l_return_status = FND_API.g_ret_sts_error THEN
2054: x_message_type := 'OE' ;
2055: RAISE FND_API.g_exc_error;
2056: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2057: x_message_type := 'OE' ;
2051: );
2052:
2053: IF l_return_status = FND_API.g_ret_sts_error THEN
2054: x_message_type := 'OE' ;
2055: RAISE FND_API.g_exc_error;
2056: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2057: x_message_type := 'OE' ;
2058: RAISE FND_API.g_exc_unexpected_error;
2059: END IF;
2052:
2053: IF l_return_status = FND_API.g_ret_sts_error THEN
2054: x_message_type := 'OE' ;
2055: RAISE FND_API.g_exc_error;
2056: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2057: x_message_type := 'OE' ;
2058: RAISE FND_API.g_exc_unexpected_error;
2059: END IF;
2060:
2054: x_message_type := 'OE' ;
2055: RAISE FND_API.g_exc_error;
2056: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2057: x_message_type := 'OE' ;
2058: RAISE FND_API.g_exc_unexpected_error;
2059: END IF;
2060:
2061: --
2062: -- Create the record in Activity Offers
2075:
2076: p_act_offer_rec => p_act_offer_rec
2077: ) ;
2078:
2079: IF l_return_status = FND_API.g_ret_sts_error THEN
2080: x_message_type := 'FND' ;
2081: RAISE FND_API.g_exc_error;
2082: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2083: x_message_type := 'FND' ;
2077: ) ;
2078:
2079: IF l_return_status = FND_API.g_ret_sts_error THEN
2080: x_message_type := 'FND' ;
2081: RAISE FND_API.g_exc_error;
2082: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2083: x_message_type := 'FND' ;
2084: RAISE FND_API.g_exc_unexpected_error;
2085: END IF;
2078:
2079: IF l_return_status = FND_API.g_ret_sts_error THEN
2080: x_message_type := 'FND' ;
2081: RAISE FND_API.g_exc_error;
2082: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2083: x_message_type := 'FND' ;
2084: RAISE FND_API.g_exc_unexpected_error;
2085: END IF;
2086:
2080: x_message_type := 'FND' ;
2081: RAISE FND_API.g_exc_error;
2082: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2083: x_message_type := 'FND' ;
2084: RAISE FND_API.g_exc_unexpected_error;
2085: END IF;
2086:
2087: --
2088: -- END of API body.
2088: -- END of API body.
2089: --
2090:
2091: -- Standard check of p_commit.
2092: IF FND_API.To_Boolean ( p_commit )
2093: THEN
2094: COMMIT WORK;
2095: END IF;
2096:
2099: --
2100: FND_MSG_PUB.Count_AND_Get
2101: ( p_count => x_msg_count,
2102: p_data => x_msg_data,
2103: p_encoded => FND_API.G_FALSE
2104: );
2105:
2106: OE_MSG_PUB.Count_AND_Get
2107: ( p_count => x_msg_count,
2105:
2106: OE_MSG_PUB.Count_AND_Get
2107: ( p_count => x_msg_count,
2108: p_data => x_msg_data,
2109: p_encoded => FND_API.G_FALSE
2110: );
2111:
2112: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2113:
2112: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2113:
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: ROLLBACK TO Update_Offer;
2119: x_return_status := FND_API.G_RET_STS_ERROR ;
2120:
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: ROLLBACK TO Update_Offer;
2119: x_return_status := FND_API.G_RET_STS_ERROR ;
2120:
2121: IF x_message_type = 'FND' THEN
2122: FND_MSG_PUB.Count_AND_Get
2123: ( p_count => x_msg_count,
2121: IF x_message_type = 'FND' THEN
2122: FND_MSG_PUB.Count_AND_Get
2123: ( p_count => x_msg_count,
2124: p_data => x_msg_data,
2125: p_encoded => FND_API.G_FALSE
2126: );
2127: ELSIF x_message_type = 'OE' THEN
2128: OE_MSG_PUB.Count_AND_Get
2129: ( p_count => x_msg_count,
2127: ELSIF x_message_type = 'OE' THEN
2128: OE_MSG_PUB.Count_AND_Get
2129: ( p_count => x_msg_count,
2130: p_data => x_msg_data,
2131: p_encoded => FND_API.G_FALSE
2132: );
2133: END IF ;
2134:
2135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2131: p_encoded => FND_API.G_FALSE
2132: );
2133: END IF ;
2134:
2135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2136:
2137: ROLLBACK TO Update_Offer;
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2139:
2134:
2135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2136:
2137: ROLLBACK TO Update_Offer;
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2139:
2140: IF x_message_type = 'FND' THEN
2141: FND_MSG_PUB.Count_AND_Get
2142: ( p_count => x_msg_count,
2140: IF x_message_type = 'FND' THEN
2141: FND_MSG_PUB.Count_AND_Get
2142: ( p_count => x_msg_count,
2143: p_data => x_msg_data,
2144: p_encoded => FND_API.G_FALSE
2145: );
2146: ELSIF x_message_type = 'OE' THEN
2147: OE_MSG_PUB.Count_AND_Get
2148: ( p_count => x_msg_count,
2146: ELSIF x_message_type = 'OE' THEN
2147: OE_MSG_PUB.Count_AND_Get
2148: ( p_count => x_msg_count,
2149: p_data => x_msg_data,
2150: p_encoded => FND_API.G_FALSE
2151: );
2152: END IF ;
2153:
2154:
2154:
2155: WHEN OTHERS THEN
2156:
2157: ROLLBACK TO Update_Offer;
2158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2159:
2160: IF x_message_type = 'FND' THEN
2161: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2162: THEN
2165:
2166: FND_MSG_PUB.Count_AND_Get
2167: ( p_count => x_msg_count,
2168: p_data => x_msg_data,
2169: p_encoded => FND_API.G_FALSE
2170: );
2171: ELSIF x_message_type = 'OE' THEN
2172: IF OE_MSG_PUB.Check_Msg_Level ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2173: THEN
2175: END IF;
2176: OE_MSG_PUB.Count_AND_Get
2177: ( p_count => x_msg_count,
2178: p_data => x_msg_data,
2179: p_encoded => FND_API.G_FALSE
2180: );
2181: END IF ;
2182:
2183:
2207: -- End of Comments
2208: PROCEDURE Delete_Offer
2209: (
2210: p_api_version IN NUMBER,
2211: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2212: p_commit IN VARCHAR2 := FND_API.g_false,
2213:
2214: x_return_status OUT NOCOPY VARCHAR2,
2215: x_msg_count OUT NOCOPY NUMBER,
2208: PROCEDURE Delete_Offer
2209: (
2210: p_api_version IN NUMBER,
2211: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2212: p_commit IN VARCHAR2 := FND_API.g_false,
2213:
2214: x_return_status OUT NOCOPY VARCHAR2,
2215: x_msg_count OUT NOCOPY NUMBER,
2216: x_msg_data OUT NOCOPY VARCHAR2,
2216: x_msg_data OUT NOCOPY VARCHAR2,
2217:
2218: p_act_offer_id IN NUMBER,
2219: p_object_version IN NUMBER,
2220: p_list_header_id IN NUMBER := FND_API.g_miss_num,
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2217:
2218: p_act_offer_id IN NUMBER,
2219: p_object_version IN NUMBER,
2220: p_list_header_id IN NUMBER := FND_API.g_miss_num,
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2218: p_act_offer_id IN NUMBER,
2219: p_object_version IN NUMBER,
2220: p_list_header_id IN NUMBER := FND_API.g_miss_num,
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2226: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
2219: p_object_version IN NUMBER,
2220: p_list_header_id IN NUMBER := FND_API.g_miss_num,
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2226: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
2227:
2220: p_list_header_id IN NUMBER := FND_API.g_miss_num,
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2226: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
2227:
2228: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
2221: p_offer_name IN VARCHAR2 := FND_API.g_miss_char,
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2226: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
2227:
2228: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
2229: )
2222: p_currency_code IN VARCHAR2 := FND_API.g_miss_char,
2223: p_start_date IN DATE := FND_API.g_miss_date,
2224: p_end_date IN DATE := FND_API.g_miss_date,
2225: p_active_flag IN VARCHAR2 := FND_API.g_miss_char,
2226: p_automatic_flag IN VARCHAR2 := FND_API.g_miss_char,
2227:
2228: x_message_type OUT NOCOPY VARCHAR2 -- OE / FND
2229: )
2230: IS
2239: -- initialize
2240: SAVEPOINT Delete_Offer;
2241: x_message_type := 'FND' ;
2242:
2243: IF FND_API.to_boolean(p_init_msg_list) THEN
2244: FND_MSG_PUB.initialize;
2245: END IF;
2246:
2247: IF NOT FND_API.compatible_api_call
2243: IF FND_API.to_boolean(p_init_msg_list) THEN
2244: FND_MSG_PUB.initialize;
2245: END IF;
2246:
2247: IF NOT FND_API.compatible_api_call
2248: (
2249: l_api_version,
2250: p_api_version,
2251: l_api_name,
2251: l_api_name,
2252: g_pkg_name
2253: )
2254: THEN
2255: RAISE FND_API.g_exc_unexpected_error;
2256: END IF;
2257:
2258: x_return_status := FND_API.g_ret_sts_success;
2259:
2254: THEN
2255: RAISE FND_API.g_exc_unexpected_error;
2256: END IF;
2257:
2258: x_return_status := FND_API.g_ret_sts_success;
2259:
2260:
2261: --
2262: -- Delete the List Header for the offer
2280:
2281: x_list_header_id => l_list_header_id
2282: );
2283:
2284: IF l_return_status = FND_API.g_ret_sts_error THEN
2285: x_message_type := 'OE' ;
2286: RAISE FND_API.g_exc_error;
2287: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2288: x_message_type := 'OE' ;
2282: );
2283:
2284: IF l_return_status = FND_API.g_ret_sts_error THEN
2285: x_message_type := 'OE' ;
2286: RAISE FND_API.g_exc_error;
2287: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2288: x_message_type := 'OE' ;
2289: RAISE FND_API.g_exc_unexpected_error;
2290: END IF;
2283:
2284: IF l_return_status = FND_API.g_ret_sts_error THEN
2285: x_message_type := 'OE' ;
2286: RAISE FND_API.g_exc_error;
2287: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2288: x_message_type := 'OE' ;
2289: RAISE FND_API.g_exc_unexpected_error;
2290: END IF;
2291:
2285: x_message_type := 'OE' ;
2286: RAISE FND_API.g_exc_error;
2287: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2288: x_message_type := 'OE' ;
2289: RAISE FND_API.g_exc_unexpected_error;
2290: END IF;
2291:
2292: --
2293: -- Delete the record in Activity Offers
2306: p_act_offer_id => p_act_offer_id,
2307: p_object_version => p_object_version
2308: ) ;
2309:
2310: IF l_return_status = FND_API.g_ret_sts_error THEN
2311: x_message_type := 'FND' ;
2312: RAISE FND_API.g_exc_error;
2313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2314: x_message_type := 'FND' ;
2308: ) ;
2309:
2310: IF l_return_status = FND_API.g_ret_sts_error THEN
2311: x_message_type := 'FND' ;
2312: RAISE FND_API.g_exc_error;
2313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2314: x_message_type := 'FND' ;
2315: RAISE FND_API.g_exc_unexpected_error;
2316: END IF;
2309:
2310: IF l_return_status = FND_API.g_ret_sts_error THEN
2311: x_message_type := 'FND' ;
2312: RAISE FND_API.g_exc_error;
2313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2314: x_message_type := 'FND' ;
2315: RAISE FND_API.g_exc_unexpected_error;
2316: END IF;
2317:
2311: x_message_type := 'FND' ;
2312: RAISE FND_API.g_exc_error;
2313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2314: x_message_type := 'FND' ;
2315: RAISE FND_API.g_exc_unexpected_error;
2316: END IF;
2317:
2318: --
2319: -- END of API body.
2319: -- END of API body.
2320: --
2321:
2322: -- Standard check of p_commit.
2323: IF FND_API.To_Boolean ( p_commit )
2324: THEN
2325: COMMIT WORK;
2326: END IF;
2327:
2330: --
2331: FND_MSG_PUB.Count_AND_Get
2332: ( p_count => x_msg_count,
2333: p_data => x_msg_data,
2334: p_encoded => FND_API.G_FALSE
2335: );
2336:
2337: OE_MSG_PUB.Count_AND_Get
2338: ( p_count => x_msg_count,
2336:
2337: OE_MSG_PUB.Count_AND_Get
2338: ( p_count => x_msg_count,
2339: p_data => x_msg_data,
2340: p_encoded => FND_API.G_FALSE
2341: );
2342:
2343: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2344:
2343: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2344:
2345: EXCEPTION
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN
2348:
2349: ROLLBACK TO Delete_Offer;
2350: x_return_status := FND_API.G_RET_STS_ERROR ;
2351:
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN
2348:
2349: ROLLBACK TO Delete_Offer;
2350: x_return_status := FND_API.G_RET_STS_ERROR ;
2351:
2352: IF x_message_type = 'FND' THEN
2353: FND_MSG_PUB.Count_AND_Get
2354: ( p_count => x_msg_count,
2352: IF x_message_type = 'FND' THEN
2353: FND_MSG_PUB.Count_AND_Get
2354: ( p_count => x_msg_count,
2355: p_data => x_msg_data,
2356: p_encoded => FND_API.G_FALSE
2357: );
2358: ELSIF x_message_type = 'OE' THEN
2359: OE_MSG_PUB.Count_AND_Get
2360: ( p_count => x_msg_count,
2358: ELSIF x_message_type = 'OE' THEN
2359: OE_MSG_PUB.Count_AND_Get
2360: ( p_count => x_msg_count,
2361: p_data => x_msg_data,
2362: p_encoded => FND_API.G_FALSE
2363: );
2364: END IF ;
2365:
2366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2362: p_encoded => FND_API.G_FALSE
2363: );
2364: END IF ;
2365:
2366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2367:
2368: ROLLBACK TO Delete_Offer;
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2370:
2365:
2366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2367:
2368: ROLLBACK TO Delete_Offer;
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2370:
2371: IF x_message_type = 'FND' THEN
2372: FND_MSG_PUB.Count_AND_Get
2373: ( p_count => x_msg_count,
2371: IF x_message_type = 'FND' THEN
2372: FND_MSG_PUB.Count_AND_Get
2373: ( p_count => x_msg_count,
2374: p_data => x_msg_data,
2375: p_encoded => FND_API.G_FALSE
2376: );
2377: ELSIF x_message_type = 'OE' THEN
2378: OE_MSG_PUB.Count_AND_Get
2379: ( p_count => x_msg_count,
2377: ELSIF x_message_type = 'OE' THEN
2378: OE_MSG_PUB.Count_AND_Get
2379: ( p_count => x_msg_count,
2380: p_data => x_msg_data,
2381: p_encoded => FND_API.G_FALSE
2382: );
2383: END IF ;
2384:
2385:
2385:
2386: WHEN OTHERS THEN
2387:
2388: ROLLBACK TO Delete_Offer;
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2390:
2391: IF x_message_type = 'FND' THEN
2392: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2393: THEN
2396:
2397: FND_MSG_PUB.Count_AND_Get
2398: ( p_count => x_msg_count,
2399: p_data => x_msg_data,
2400: p_encoded => FND_API.G_FALSE
2401: );
2402: ELSIF x_message_type = 'OE' THEN
2403: IF OE_MSG_PUB.Check_Msg_Level ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2404: THEN
2406: END IF;
2407: OE_MSG_PUB.Count_AND_Get
2408: ( p_count => x_msg_count,
2409: p_data => x_msg_data,
2410: p_encoded => FND_API.G_FALSE
2411: );
2412: END IF ;
2413:
2414: