APPS.OZF_ACT_OFFERS_PVT dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.initialize;

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
75: (

Line 300: FND_MSG_PUB.count_and_get

296: IF FND_API.to_boolean(p_commit) THEN
297: COMMIT;
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

Line 311: FND_MSG_PUB.count_and_get

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,
315: p_data => x_msg_data

Line 321: FND_MSG_PUB.count_and_get

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,
325: p_data => x_msg_data

Line 331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
335: (

Line 332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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
335: (
336: p_encoded => FND_API.g_false,

Line 334: FND_MSG_PUB.count_and_get

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
335: (
336: p_encoded => FND_API.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data

Line 381: FND_MSG_PUB.initialize;

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
385: (

Line 474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

470: WHERE activity_offer_id = l_act_offer_rec.activity_offer_id
471: AND object_version_number = l_act_offer_rec.object_version_number;
472:
473: IF (SQL%NOTFOUND) THEN
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;

Line 476: FND_MSG_PUB.add;

472:
473: IF (SQL%NOTFOUND) THEN
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:

Line 486: FND_MSG_PUB.count_and_get

482: IF FND_API.to_boolean(p_commit) THEN
483: COMMIT;
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

Line 497: FND_MSG_PUB.count_and_get

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,
501: p_data => x_msg_data

Line 507: FND_MSG_PUB.count_and_get

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,
511: p_data => x_msg_data

Line 517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
521: (

Line 518: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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
521: (
522: p_encoded => FND_API.g_false,

Line 520: FND_MSG_PUB.count_and_get

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
521: (
522: p_encoded => FND_API.g_false,
523: p_count => x_msg_count,
524: p_data => x_msg_data

Line 574: FND_MSG_PUB.initialize;

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
578: (

Line 600: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

596: WHERE activity_offer_id = p_act_offer_id
597: AND object_version_number = p_object_version;
598:
599: IF (SQL%NOTFOUND) THEN
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;

Line 602: FND_MSG_PUB.add;

598:
599: IF (SQL%NOTFOUND) THEN
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:

Line 642: FND_MSG_PUB.count_and_get

638: IF FND_API.to_boolean(p_commit) THEN
639: COMMIT;
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

Line 653: FND_MSG_PUB.count_and_get

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,
657: p_data => x_msg_data

Line 663: FND_MSG_PUB.count_and_get

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,
667: p_data => x_msg_data

Line 673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
677: (

Line 674: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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
677: (
678: p_encoded => FND_API.g_false,

Line 676: FND_MSG_PUB.count_and_get

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
677: (
678: p_encoded => FND_API.g_false,
679: p_count => x_msg_count,
680: p_data => x_msg_data

Line 721: FND_MSG_PUB.initialize;

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
725: (

Line 742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

738: OPEN c_act_offer_b;
739: FETCH c_act_offer_b INTO l_act_offer_id;
740: IF (c_act_offer_b%NOTFOUND) THEN
741: CLOSE c_act_offer_b;
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;

Line 744: FND_MSG_PUB.add;

740: IF (c_act_offer_b%NOTFOUND) THEN
741: CLOSE c_act_offer_b;
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;

Line 751: FND_MSG_PUB.count_and_get

747: END IF;
748: CLOSE c_act_offer_b;
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

Line 761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
765: FND_MSG_PUB.count_and_get

Line 763: FND_MSG_PUB.add;

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;
765: FND_MSG_PUB.count_and_get
766: (
767: p_encoded => FND_API.g_false,

Line 765: FND_MSG_PUB.count_and_get

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;
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

Line 774: FND_MSG_PUB.count_and_get

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,
778: p_data => x_msg_data

Line 783: FND_MSG_PUB.count_and_get

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,
787: p_data => x_msg_data

Line 792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
796: (

Line 793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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
796: (
797: p_encoded => FND_API.g_false,

Line 795: FND_MSG_PUB.count_and_get

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
796: (
797: p_encoded => FND_API.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data

Line 879: FND_MSG_PUB.count_and_get

875: END IF;
876: END IF;
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

Line 889: FND_MSG_PUB.count_and_get

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,
893: p_data => x_msg_data

Line 898: FND_MSG_PUB.count_and_get

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,
902: p_data => x_msg_data

Line 907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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
911: (

Line 908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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
911: (
912: p_encoded => FND_API.g_false,

Line 910: FND_MSG_PUB.count_and_get

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
911: (
912: p_encoded => FND_API.g_false,
913: p_count => x_msg_count,
914: p_data => x_msg_data

Line 945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

941: -- check activity_offer_id
942: IF p_act_offer_rec.activity_offer_id IS NULL
943: AND p_validation_mode = JTF_PLSQL_API.g_update
944: THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
946: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_ACT_OFFER_ID');
947: FND_MSG_PUB.add;
948: END IF;
949:

Line 947: FND_MSG_PUB.add;

943: AND p_validation_mode = JTF_PLSQL_API.g_update
944: THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

954: -- check object_version_number
955: IF p_act_offer_rec.object_version_number IS NULL
956: AND p_validation_mode = JTF_PLSQL_API.g_update
957: THEN
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
960: FND_MSG_PUB.add;
961: END IF;
962:

Line 960: FND_MSG_PUB.add;

956: AND p_validation_mode = JTF_PLSQL_API.g_update
957: THEN
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

965: END IF;
966:
967: -- check act_offer_used_by_id
968: IF p_act_offer_rec.act_offer_used_by_id IS NULL THEN
969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
970: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY_ID');
971: FND_MSG_PUB.add;
972: END IF;
973:

Line 971: FND_MSG_PUB.add;

967: -- check act_offer_used_by_id
968: IF p_act_offer_rec.act_offer_used_by_id IS NULL THEN
969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

976: END IF;
977:
978: -- check arc_act_offer_used_by
979: IF p_act_offer_rec.arc_act_offer_used_by IS NULL THEN
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
981: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
982: FND_MSG_PUB.add;
983: END IF;
984:

Line 982: FND_MSG_PUB.add;

978: -- check arc_act_offer_used_by
979: IF p_act_offer_rec.arc_act_offer_used_by IS NULL THEN
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

987: END IF;
988:
989: -- check qp_list_header_id
990: IF p_act_offer_rec.qp_list_header_id IS NULL THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
993: FND_MSG_PUB.add;
994: END IF;
995:

Line 993: FND_MSG_PUB.add;

989: -- check qp_list_header_id
990: IF p_act_offer_rec.qp_list_header_id IS NULL THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 1050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1054:

Line 1052: FND_MSG_PUB.add;

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;
1054:
1055: x_return_status := FND_API.g_ret_sts_error;
1056: RETURN;

Line 1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1083:

Line 1081: FND_MSG_PUB.add;

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;
1083:
1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;

Line 1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1144:

Line 1142: FND_MSG_PUB.add;

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;
1144:
1145: x_return_status := FND_API.g_ret_sts_error;
1146: RETURN;

Line 1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1166:

Line 1164: FND_MSG_PUB.add;

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;
1166:
1167: x_return_status := FND_API.g_ret_sts_error;
1168: RETURN;

Line 1199: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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');

Line 1201: -- FND_MSG_PUB.add;

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

Line 1209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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:

Line 1211: FND_MSG_PUB.add;

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;

Line 1228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1231: FND_MSG_PUB.add;
1232: END IF;

Line 1231: FND_MSG_PUB.add;

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');
1231: FND_MSG_PUB.add;
1232: END IF;
1233: x_return_status := FND_API.g_ret_sts_error;
1234: RETURN;
1235: END IF;

Line 1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1250: FND_MSG_PUB.add;
1251: END IF;

Line 1250: FND_MSG_PUB.add;

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');
1250: FND_MSG_PUB.add;
1251: END IF;
1252: x_return_status := FND_API.g_ret_sts_error;
1253: RETURN;
1254: END IF;

Line 1266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1269: FND_MSG_PUB.add;
1270: END IF;

Line 1269: FND_MSG_PUB.add;

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');
1269: FND_MSG_PUB.add;
1270: END IF;
1271: x_return_status := FND_API.g_ret_sts_error;
1272: RETURN;
1273: END IF;

Line 1401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1397: -- commented by julou 05/03/2001. These dates are gone
1398: /*
1399: -- check offer dates
1400: IF p_complete_rec.start_date > p_complete_rec.end_date THEN
1401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1402: THEN
1403: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_START_AFTER_END');
1404: FND_MSG_PUB.add;
1405: END IF;

Line 1404: FND_MSG_PUB.add;

1400: IF p_complete_rec.start_date > p_complete_rec.end_date THEN
1401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
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:

Line 1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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;

Line 1413: FND_MSG_PUB.add;

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:

Line 1419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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;

Line 1422: FND_MSG_PUB.add;

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:

Line 1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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;

Line 1431: FND_MSG_PUB.add;

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: */

Line 1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1439: FETCH c_active INTO l_active;
1440: CLOSE c_active;
1441:
1442: IF l_active = 0 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;

Line 1445: FND_MSG_PUB.add;

1441:
1442: IF l_active = 0 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;

Line 1459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1455: OPEN c_primary_offer_count1(p_complete_rec.act_offer_used_by_id, p_complete_rec.arc_act_offer_used_by);
1456: FETCH c_primary_offer_count1 INTO l_primary_offer_count;
1457: IF l_primary_offer_count <> 0 THEN
1458: CLOSE c_primary_offer_count1;
1459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1460: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1461: FND_MSG_PUB.add;
1462: END IF;
1463:

Line 1461: FND_MSG_PUB.add;

1457: IF l_primary_offer_count <> 0 THEN
1458: CLOSE c_primary_offer_count1;
1459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 1473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1469: OPEN c_primary_offer_count2(p_complete_rec.activity_offer_id, p_complete_rec.act_offer_used_by_id, p_complete_rec.arc_act_offer_used_by);
1470: FETCH c_primary_offer_count2 INTO l_primary_offer_count;
1471: IF l_primary_offer_count <> 0 THEN
1472: CLOSE c_primary_offer_count2;
1473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1474: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_PRI_OFFER_EXISTS');
1475: FND_MSG_PUB.add;
1476: END IF;
1477:

Line 1475: FND_MSG_PUB.add;

1471: IF l_primary_offer_count <> 0 THEN
1472: CLOSE c_primary_offer_count2;
1473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 1517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1513: OPEN c_act_offer;
1514: FETCH c_act_offer INTO l_act_offer_rec;
1515: IF (c_act_offer%NOTFOUND) THEN
1516: CLOSE c_act_offer;
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;

Line 1519: FND_MSG_PUB.add;

1515: IF (c_act_offer%NOTFOUND) THEN
1516: CLOSE c_act_offer;
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;

Line 1740: FND_MSG_PUB.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
1744: (

Line 1869: FND_MSG_PUB.Count_AND_Get

1865:
1866: --
1867: -- Standard call to get message count AND IF count is 1, get message info.
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: );

Line 1891: FND_MSG_PUB.Count_AND_Get

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,
1893: p_data => x_msg_data,
1894: p_encoded => FND_API.G_FALSE
1895: );

Line 1910: FND_MSG_PUB.Count_AND_Get

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,
1912: p_data => x_msg_data,
1913: p_encoded => FND_API.G_FALSE
1914: );

Line 1930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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
1932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1933: END IF;
1934:

Line 1932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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
1932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1933: END IF;
1934:
1935: FND_MSG_PUB.Count_AND_Get
1936: ( p_count => x_msg_count,

Line 1935: FND_MSG_PUB.Count_AND_Get

1931: THEN
1932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1933: END IF;
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: );

Line 2013: FND_MSG_PUB.initialize;

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
2017: (

Line 2100: FND_MSG_PUB.Count_AND_Get

2096:
2097: --
2098: -- Standard call to get message count AND IF count is 1, get message info.
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: );

Line 2122: FND_MSG_PUB.Count_AND_Get

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,
2124: p_data => x_msg_data,
2125: p_encoded => FND_API.G_FALSE
2126: );

Line 2141: FND_MSG_PUB.Count_AND_Get

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,
2143: p_data => x_msg_data,
2144: p_encoded => FND_API.G_FALSE
2145: );

Line 2161: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
2165:

Line 2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
2165:
2166: FND_MSG_PUB.Count_AND_Get
2167: ( p_count => x_msg_count,

Line 2166: FND_MSG_PUB.Count_AND_Get

2162: THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
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: );

Line 2244: FND_MSG_PUB.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
2248: (

Line 2331: FND_MSG_PUB.Count_AND_Get

2327:
2328: --
2329: -- Standard call to get message count AND IF count is 1, get message info.
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: );

Line 2353: FND_MSG_PUB.Count_AND_Get

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,
2355: p_data => x_msg_data,
2356: p_encoded => FND_API.G_FALSE
2357: );

Line 2372: FND_MSG_PUB.Count_AND_Get

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,
2374: p_data => x_msg_data,
2375: p_encoded => FND_API.G_FALSE
2376: );

Line 2392: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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
2394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2395: END IF;
2396:

Line 2394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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
2394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2395: END IF;
2396:
2397: FND_MSG_PUB.Count_AND_Get
2398: ( p_count => x_msg_count,

Line 2397: FND_MSG_PUB.Count_AND_Get

2393: THEN
2394: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2395: END IF;
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: );