11: --
12: -- HISTORY
13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(
12: -- HISTORY
13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(
20: p_api_version IN NUMBER,
13: -- 10/01/99 holiu Created.
14: ---------------------------------------------------------------------
15: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
16: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
17: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
18:
19: PROCEDURE create_EventOffer(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41:
42: -- initialize the message list;
43: -- won't do it again when calling private API
44: IF FND_API.to_boolean(p_init_msg_list) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- customer pre-processing
49: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
131: IF FND_API.to_boolean(p_commit) THEN
132: COMMIT;
133: END IF;
134: x_return_status := FND_API.g_ret_sts_success;
135: FND_MSG_PUB.count_and_get(
136: p_encoded => FND_API.g_false,
137: p_count => x_msg_count,
138: p_data => x_msg_data
139: );
142:
143: WHEN FND_API.g_exc_error THEN
144: ROLLBACK TO create_EventOffer_pub;
145: x_return_status := FND_API.g_ret_sts_error;
146: FND_MSG_PUB.count_and_get(
147: p_encoded => FND_API.g_false,
148: p_count => x_msg_count,
149: p_data => x_msg_data
150: );
151:
152: WHEN FND_API.g_exc_unexpected_error THEN
153: ROLLBACK TO create_EventOffer_pub;
154: x_return_status := FND_API.g_ret_sts_unexp_error ;
155: FND_MSG_PUB.count_and_get(
156: p_encoded => FND_API.g_false,
157: p_count => x_msg_count,
158: p_data => x_msg_data
159: );
162: WHEN OTHERS THEN
163: ROLLBACK TO create_EventOffer_pub;
164: x_return_status := FND_API.g_ret_sts_unexp_error ;
165:
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:
164: x_return_status := FND_API.g_ret_sts_unexp_error ;
165:
166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:
171: FND_MSG_PUB.count_and_get(
172: p_encoded => FND_API.g_false,
167: THEN
168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
169: END IF;
170:
171: FND_MSG_PUB.count_and_get(
172: p_encoded => FND_API.g_false,
173: p_count => x_msg_count,
174: p_data => x_msg_data
175: );
209:
210: -- initialize the message list;
211: -- won't do it again when calling private API
212: IF FND_API.to_boolean(p_init_msg_list) THEN
213: FND_MSG_PUB.initialize;
214: END IF;
215:
216: -- customer pre-processing
217: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
300: IF FND_API.to_boolean(p_commit) THEN
301: COMMIT;
302: END IF;
303: x_return_status := FND_API.g_ret_sts_success;
304: FND_MSG_PUB.count_and_get(
305: p_encoded => FND_API.g_false,
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );
312:
313: WHEN FND_API.g_exc_error THEN
314: ROLLBACK TO delete_EventOffer_pub;
315: x_return_status := FND_API.g_ret_sts_error;
316: FND_MSG_PUB.count_and_get(
317: p_encoded => FND_API.g_false,
318: p_count => x_msg_count,
319: p_data => x_msg_data
320: );
321:
322: WHEN FND_API.g_exc_unexpected_error THEN
323: ROLLBACK TO delete_EventOffer_pub;
324: x_return_status := FND_API.g_ret_sts_unexp_error ;
325: FND_MSG_PUB.count_and_get(
326: p_encoded => FND_API.g_false,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );
332: WHEN OTHERS THEN
333: ROLLBACK TO delete_EventOffer_pub;
334: x_return_status := FND_API.g_ret_sts_unexp_error ;
335:
336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:
334: x_return_status := FND_API.g_ret_sts_unexp_error ;
335:
336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
337: THEN
338: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
339: END IF;
340:
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
378:
379: -- initialize the message list;
380: -- won't do it again when calling private API
381: IF FND_API.to_boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384:
385: -- customer pre-processing
386: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
465: END IF;
466: END IF;
467:
468: x_return_status := FND_API.g_ret_sts_success;
469: FND_MSG_PUB.count_and_get(
470: p_encoded => FND_API.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );
476:
477: WHEN FND_API.g_exc_error THEN
478: ROLLBACK TO lock_EventOffer_pub;
479: x_return_status := FND_API.g_ret_sts_error;
480: FND_MSG_PUB.count_and_get(
481: p_encoded => FND_API.g_false,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485:
486: WHEN FND_API.g_exc_unexpected_error THEN
487: ROLLBACK TO lock_EventOffer_pub;
488: x_return_status := FND_API.g_ret_sts_unexp_error ;
489: FND_MSG_PUB.count_and_get(
490: p_encoded => FND_API.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data
493: );
496: WHEN OTHERS THEN
497: ROLLBACK TO lock_EventOffer_pub;
498: x_return_status := FND_API.g_ret_sts_unexp_error ;
499:
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:
498: x_return_status := FND_API.g_ret_sts_unexp_error ;
499:
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
501: THEN
502: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
503: END IF;
504:
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data
509: );
542:
543: -- initialize the message list;
544: -- won't do it again when calling private API
545: IF FND_API.to_boolean(p_init_msg_list) THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- customer pre-processing
550: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
629: IF FND_API.to_boolean(p_commit) THEN
630: COMMIT;
631: END IF;
632: x_return_status := FND_API.g_ret_sts_success;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false,
635: p_count => x_msg_count,
636: p_data => x_msg_data
637: );
640:
641: WHEN FND_API.g_exc_error THEN
642: ROLLBACK TO update_EventOffer_pub;
643: x_return_status := FND_API.g_ret_sts_error;
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649:
650: WHEN FND_API.g_exc_unexpected_error THEN
651: ROLLBACK TO update_EventOffer_pub;
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: FND_MSG_PUB.count_and_get(
654: p_encoded => FND_API.g_false,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
660: WHEN OTHERS THEN
661: ROLLBACK TO update_EventOffer_pub;
662: x_return_status := FND_API.g_ret_sts_unexp_error ;
663:
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:
662: x_return_status := FND_API.g_ret_sts_unexp_error ;
663:
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:
669: FND_MSG_PUB.count_and_get(
670: p_encoded => FND_API.g_false,
665: THEN
666: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
667: END IF;
668:
669: FND_MSG_PUB.count_and_get(
670: p_encoded => FND_API.g_false,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );
705:
706: -- initialize the message list;
707: -- won't do it again when calling private API
708: IF FND_API.to_boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- customer pre-processing
713: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
788: END IF;
789: END IF;
790:
791: x_return_status := FND_API.g_ret_sts_success;
792: FND_MSG_PUB.count_and_get(
793: p_encoded => FND_API.g_false,
794: p_count => x_msg_count,
795: p_data => x_msg_data
796: );
799:
800: WHEN FND_API.g_exc_error THEN
801: ROLLBACK TO validate_EventOffer_pub;
802: x_return_status := FND_API.g_ret_sts_error;
803: FND_MSG_PUB.count_and_get(
804: p_encoded => FND_API.g_false,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );
808:
809: WHEN FND_API.g_exc_unexpected_error THEN
810: ROLLBACK TO validate_EventOffer_pub;
811: x_return_status := FND_API.g_ret_sts_unexp_error ;
812: FND_MSG_PUB.count_and_get(
813: p_encoded => FND_API.g_false,
814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );
819: WHEN OTHERS THEN
820: ROLLBACK TO validate_EventOffer_pub;
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822:
823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822:
823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.count_and_get(
829: p_encoded => FND_API.g_false,
824: THEN
825: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.count_and_get(
829: p_encoded => FND_API.g_false,
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );