37:
38: -- initialize the message list;
39: -- won't do it again when calling private API
40: IF FND_API.to_boolean(p_init_msg_list) THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43:
44: -- customer pre-processing
45: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
127: IF FND_API.to_boolean(p_commit) THEN
128: COMMIT;
129: END IF;
130: x_return_status := FND_API.g_ret_sts_success;
131: FND_MSG_PUB.count_and_get(
132: p_encoded => FND_API.g_false,
133: p_count => x_msg_count,
134: p_data => x_msg_data
135: );
138:
139: WHEN FND_API.g_exc_error THEN
140: ROLLBACK TO create_campaign_pub;
141: x_return_status := FND_API.g_ret_sts_error;
142: FND_MSG_PUB.count_and_get(
143: p_encoded => FND_API.g_false,
144: p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147:
148: WHEN FND_API.g_exc_unexpected_error THEN
149: ROLLBACK TO create_campaign_pub;
150: x_return_status := FND_API.g_ret_sts_unexp_error ;
151: FND_MSG_PUB.count_and_get(
152: p_encoded => FND_API.g_false,
153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );
158: WHEN OTHERS THEN
159: ROLLBACK TO create_campaign_pub;
160: x_return_status := FND_API.g_ret_sts_unexp_error ;
161:
162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
163: THEN
164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
165: END IF;
166:
160: x_return_status := FND_API.g_ret_sts_unexp_error ;
161:
162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
163: THEN
164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
165: END IF;
166:
167: FND_MSG_PUB.count_and_get(
168: p_encoded => FND_API.g_false,
163: THEN
164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
165: END IF;
166:
167: FND_MSG_PUB.count_and_get(
168: p_encoded => FND_API.g_false,
169: p_count => x_msg_count,
170: p_data => x_msg_data
171: );
205:
206: -- initialize the message list;
207: -- won't do it again when calling private API
208: IF FND_API.to_boolean(p_init_msg_list) THEN
209: FND_MSG_PUB.initialize;
210: END IF;
211:
212: -- customer pre-processing
213: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
296: IF FND_API.to_boolean(p_commit) THEN
297: COMMIT;
298: END IF;
299: x_return_status := FND_API.g_ret_sts_success;
300: FND_MSG_PUB.count_and_get(
301: p_encoded => FND_API.g_false,
302: p_count => x_msg_count,
303: p_data => x_msg_data
304: );
308:
309: WHEN FND_API.g_exc_error THEN
310: ROLLBACK TO delete_campaign_pub;
311: x_return_status := FND_API.g_ret_sts_error;
312: FND_MSG_PUB.count_and_get(
313: p_encoded => FND_API.g_false,
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 delete_campaign_pub;
320: x_return_status := FND_API.g_ret_sts_unexp_error ;
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
328: WHEN OTHERS THEN
329: ROLLBACK TO delete_campaign_pub;
330: x_return_status := FND_API.g_ret_sts_unexp_error ;
331:
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
333: THEN
334: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
335: END IF;
336:
330: x_return_status := FND_API.g_ret_sts_unexp_error ;
331:
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
333: THEN
334: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
335: END IF;
336:
337: FND_MSG_PUB.count_and_get(
338: p_encoded => FND_API.g_false,
333: THEN
334: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
335: END IF;
336:
337: FND_MSG_PUB.count_and_get(
338: p_encoded => FND_API.g_false,
339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
374:
375: -- initialize the message list;
376: -- won't do it again when calling private API
377: IF FND_API.to_boolean(p_init_msg_list) THEN
378: FND_MSG_PUB.initialize;
379: END IF;
380:
381: -- customer pre-processing
382: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
461: END IF;
462: END IF;
463:
464: x_return_status := FND_API.g_ret_sts_success;
465: FND_MSG_PUB.count_and_get(
466: p_encoded => FND_API.g_false,
467: p_count => x_msg_count,
468: p_data => x_msg_data
469: );
472:
473: WHEN FND_API.g_exc_error THEN
474: ROLLBACK TO lock_campaign_pub;
475: x_return_status := FND_API.g_ret_sts_error;
476: FND_MSG_PUB.count_and_get(
477: p_encoded => FND_API.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481:
482: WHEN FND_API.g_exc_unexpected_error THEN
483: ROLLBACK TO lock_campaign_pub;
484: x_return_status := FND_API.g_ret_sts_unexp_error ;
485: FND_MSG_PUB.count_and_get(
486: p_encoded => FND_API.g_false,
487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );
492: WHEN OTHERS THEN
493: ROLLBACK TO lock_campaign_pub;
494: x_return_status := FND_API.g_ret_sts_unexp_error ;
495:
496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
497: THEN
498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
499: END IF;
500:
494: x_return_status := FND_API.g_ret_sts_unexp_error ;
495:
496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
497: THEN
498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
499: END IF;
500:
501: FND_MSG_PUB.count_and_get(
502: p_encoded => FND_API.g_false,
497: THEN
498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
499: END IF;
500:
501: FND_MSG_PUB.count_and_get(
502: p_encoded => FND_API.g_false,
503: p_count => x_msg_count,
504: p_data => x_msg_data
505: );
538:
539: -- initialize the message list;
540: -- won't do it again when calling private API
541: IF FND_API.to_boolean(p_init_msg_list) THEN
542: FND_MSG_PUB.initialize;
543: END IF;
544:
545: -- customer pre-processing
546: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
625: IF FND_API.to_boolean(p_commit) THEN
626: COMMIT;
627: END IF;
628: x_return_status := FND_API.g_ret_sts_success;
629: FND_MSG_PUB.count_and_get(
630: p_encoded => FND_API.g_false,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
636:
637: WHEN FND_API.g_exc_error THEN
638: ROLLBACK TO update_campaign_pub;
639: x_return_status := FND_API.g_ret_sts_error;
640: FND_MSG_PUB.count_and_get(
641: p_encoded => FND_API.g_false,
642: p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645:
646: WHEN FND_API.g_exc_unexpected_error THEN
647: ROLLBACK TO update_campaign_pub;
648: x_return_status := FND_API.g_ret_sts_unexp_error ;
649: FND_MSG_PUB.count_and_get(
650: p_encoded => FND_API.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data
653: );
656: WHEN OTHERS THEN
657: ROLLBACK TO update_campaign_pub;
658: x_return_status := FND_API.g_ret_sts_unexp_error ;
659:
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
661: THEN
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;
664:
658: x_return_status := FND_API.g_ret_sts_unexp_error ;
659:
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
661: THEN
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;
664:
665: FND_MSG_PUB.count_and_get(
666: p_encoded => FND_API.g_false,
661: THEN
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;
664:
665: FND_MSG_PUB.count_and_get(
666: p_encoded => FND_API.g_false,
667: p_count => x_msg_count,
668: p_data => x_msg_data
669: );
701:
702: -- initialize the message list;
703: -- won't do it again when calling private API
704: IF FND_API.to_boolean(p_init_msg_list) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:
708: -- customer pre-processing
709: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
784: END IF;
785: END IF;
786:
787: x_return_status := FND_API.g_ret_sts_success;
788: FND_MSG_PUB.count_and_get(
789: p_encoded => FND_API.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data
792: );
795:
796: WHEN FND_API.g_exc_error THEN
797: ROLLBACK TO validate_campaign_pub;
798: x_return_status := FND_API.g_ret_sts_error;
799: FND_MSG_PUB.count_and_get(
800: p_encoded => FND_API.g_false,
801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804:
805: WHEN FND_API.g_exc_unexpected_error THEN
806: ROLLBACK TO validate_campaign_pub;
807: x_return_status := FND_API.g_ret_sts_unexp_error ;
808: FND_MSG_PUB.count_and_get(
809: p_encoded => FND_API.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data
812: );
815: WHEN OTHERS THEN
816: ROLLBACK TO validate_campaign_pub;
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818:
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
820: THEN
821: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
822: END IF;
823:
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818:
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
820: THEN
821: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
822: END IF;
823:
824: FND_MSG_PUB.count_and_get(
825: p_encoded => FND_API.g_false,
820: THEN
821: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
822: END IF;
823:
824: FND_MSG_PUB.count_and_get(
825: p_encoded => FND_API.g_false,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );