eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CAMPAIGN_PVT dependencies on FND_MSG_PUB

Line 23: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

19: -- media_type_code, media_id, channel_id from insert
20: -- 06-Feb-2001 ptendulk Added program descriptive flexfield attributes.
21: -- 31-May-2001 ptendulk Changed the call to copy seeded metric. pass RCAM for programs
22: ---------------------------------------------------------------------
23: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE create_campaign(

Line 24: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

20: -- 06-Feb-2001 ptendulk Added program descriptive flexfield attributes.
21: -- 31-May-2001 ptendulk Changed the call to copy seeded metric. pass RCAM for programs
22: ---------------------------------------------------------------------
23: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE create_campaign(
28: p_api_version IN NUMBER,

Line 25: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

21: -- 31-May-2001 ptendulk Changed the call to copy seeded metric. pass RCAM for programs
22: ---------------------------------------------------------------------
23: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: PROCEDURE create_campaign(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 119: FND_MSG_PUB.initialize;

115:
116: END IF;
117:
118: IF FND_API.to_boolean(p_init_msg_list) THEN
119: FND_MSG_PUB.initialize;
120: END IF;
121:
122: IF NOT FND_API.compatible_api_call(
123: l_api_version,

Line 665: FND_MSG_PUB.count_and_get(

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

Line 684: FND_MSG_PUB.count_and_get(

680:
681: WHEN FND_API.g_exc_error THEN
682: ROLLBACK TO create_campaign;
683: x_return_status := FND_API.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get(
685: p_encoded => FND_API.g_false,
686: p_count => x_msg_count,
687: p_data => x_msg_data
688: );

Line 693: FND_MSG_PUB.count_and_get(

689:
690: WHEN FND_API.g_exc_unexpected_error THEN
691: ROLLBACK TO create_campaign;
692: x_return_status := FND_API.g_ret_sts_unexp_error ;
693: FND_MSG_PUB.count_and_get(
694: p_encoded => FND_API.g_false,
695: p_count => x_msg_count,
696: p_data => x_msg_data
697: );

Line 704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

700: WHEN OTHERS THEN
701: ROLLBACK TO create_campaign;
702: x_return_status := FND_API.g_ret_sts_unexp_error ;
703:
704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
705: THEN
706: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
707: END IF;
708:

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

702: x_return_status := FND_API.g_ret_sts_unexp_error ;
703:
704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
705: THEN
706: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
707: END IF;
708:
709: FND_MSG_PUB.count_and_get(
710: p_encoded => FND_API.g_false,

Line 709: FND_MSG_PUB.count_and_get(

705: THEN
706: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
707: END IF;
708:
709: FND_MSG_PUB.count_and_get(
710: p_encoded => FND_API.g_false,
711: p_count => x_msg_count,
712: p_data => x_msg_data
713: );

Line 766: FND_MSG_PUB.initialize;

762:
763: END IF;
764:
765: IF FND_API.to_boolean(p_init_msg_list) THEN
766: FND_MSG_PUB.initialize;
767: END IF;
768:
769: IF NOT FND_API.compatible_api_call(
770: l_api_version,

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

788: OPEN c_camp ;
789: FETCH c_camp INTO l_status ;
790: IF c_camp%NOTFOUND THEN
791: CLOSE c_camp ;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
793: THEN
794: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
795: FND_MSG_PUB.add;
796: END IF;

Line 795: FND_MSG_PUB.add;

791: CLOSE c_camp ;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
793: THEN
794: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
795: FND_MSG_PUB.add;
796: END IF;
797: RAISE FND_API.g_exc_error;
798: END IF ;
799: CLOSE c_camp ;

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

815: -- WHERE campaign_id = p_camp_id
816: -- AND object_version_number = p_object_version;
817:
818: IF (SQL%NOTFOUND) THEN
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
820: THEN
821: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
822: FND_MSG_PUB.add;
823: END IF;

Line 822: FND_MSG_PUB.add;

818: IF (SQL%NOTFOUND) THEN
819: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
820: THEN
821: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
822: FND_MSG_PUB.add;
823: END IF;
824: RAISE FND_API.g_exc_error;
825: END IF;
826:

Line 832: FND_MSG_PUB.count_and_get(

828: IF FND_API.to_boolean(p_commit) THEN
829: COMMIT;
830: END IF;
831:
832: FND_MSG_PUB.count_and_get(
833: p_encoded => FND_API.g_false,
834: p_count => x_msg_count,
835: p_data => x_msg_data
836: );

Line 851: FND_MSG_PUB.count_and_get(

847:
848: WHEN FND_API.g_exc_error THEN
849: ROLLBACK TO delete_campaign;
850: x_return_status := FND_API.g_ret_sts_error;
851: FND_MSG_PUB.count_and_get(
852: p_encoded => FND_API.g_false,
853: p_count => x_msg_count,
854: p_data => x_msg_data
855: );

Line 860: FND_MSG_PUB.count_and_get(

856:
857: WHEN FND_API.g_exc_unexpected_error THEN
858: ROLLBACK TO delete_campaign;
859: x_return_status := FND_API.g_ret_sts_unexp_error ;
860: FND_MSG_PUB.count_and_get(
861: p_encoded => FND_API.g_false,
862: p_count => x_msg_count,
863: p_data => x_msg_data
864: );

Line 870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

866: WHEN OTHERS THEN
867: ROLLBACK TO delete_campaign;
868: x_return_status := FND_API.g_ret_sts_unexp_error ;
869:
870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
871: THEN
872: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
873: END IF;
874:

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

868: x_return_status := FND_API.g_ret_sts_unexp_error ;
869:
870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
871: THEN
872: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
873: END IF;
874:
875: FND_MSG_PUB.count_and_get(
876: p_encoded => FND_API.g_false,

Line 875: FND_MSG_PUB.count_and_get(

871: THEN
872: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
873: END IF;
874:
875: FND_MSG_PUB.count_and_get(
876: p_encoded => FND_API.g_false,
877: p_count => x_msg_count,
878: p_data => x_msg_data
879: );

Line 933: FND_MSG_PUB.initialize;

929: AMS_Utility_PVT.debug_message(l_full_name||': start');
930: END IF;
931:
932: IF FND_API.to_boolean(p_init_msg_list) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935:
936: IF NOT FND_API.compatible_api_call(
937: l_api_version,

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

953: OPEN c_camp_b;
954: FETCH c_camp_b INTO l_camp_id;
955: IF (c_camp_b%NOTFOUND) THEN
956: CLOSE c_camp_b;
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
959: FND_MSG_PUB.add;
960: END IF;
961: RAISE FND_API.g_exc_error;

Line 959: FND_MSG_PUB.add;

955: IF (c_camp_b%NOTFOUND) THEN
956: CLOSE c_camp_b;
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
959: FND_MSG_PUB.add;
960: END IF;
961: RAISE FND_API.g_exc_error;
962: END IF;
963: CLOSE c_camp_b;

Line 969: FND_MSG_PUB.count_and_get(

965: OPEN c_camp_tl;
966: CLOSE c_camp_tl;
967:
968: -------------------- finish --------------------------
969: FND_MSG_PUB.count_and_get(
970: p_encoded => FND_API.g_false,
971: p_count => x_msg_count,
972: p_data => x_msg_data
973: );

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

983: EXCEPTION
984:
985: WHEN AMS_Utility_PVT.resource_locked THEN
986: x_return_status := FND_API.g_ret_sts_error;
987: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
988: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
989: FND_MSG_PUB.add;
990: END IF;
991:

Line 989: FND_MSG_PUB.add;

985: WHEN AMS_Utility_PVT.resource_locked THEN
986: x_return_status := FND_API.g_ret_sts_error;
987: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
988: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
989: FND_MSG_PUB.add;
990: END IF;
991:
992: FND_MSG_PUB.count_and_get(
993: p_encoded => FND_API.g_false,

Line 992: FND_MSG_PUB.count_and_get(

988: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
989: FND_MSG_PUB.add;
990: END IF;
991:
992: FND_MSG_PUB.count_and_get(
993: p_encoded => FND_API.g_false,
994: p_count => x_msg_count,
995: p_data => x_msg_data
996: );

Line 1000: FND_MSG_PUB.count_and_get(

996: );
997:
998: WHEN FND_API.g_exc_error THEN
999: x_return_status := FND_API.g_ret_sts_error;
1000: FND_MSG_PUB.count_and_get(
1001: p_encoded => FND_API.g_false,
1002: p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );

Line 1008: FND_MSG_PUB.count_and_get(

1004: );
1005:
1006: WHEN FND_API.g_exc_unexpected_error THEN
1007: x_return_status := FND_API.g_ret_sts_unexp_error ;
1008: FND_MSG_PUB.count_and_get(
1009: p_encoded => FND_API.g_false,
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1012: );

Line 1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1012: );
1013:
1014: WHEN OTHERS THEN
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1017: THEN
1018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1019: END IF;
1020:

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

1014: WHEN OTHERS THEN
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1017: THEN
1018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1019: END IF;
1020:
1021: FND_MSG_PUB.count_and_get(
1022: p_encoded => FND_API.g_false,

Line 1021: FND_MSG_PUB.count_and_get(

1017: THEN
1018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1019: END IF;
1020:
1021: FND_MSG_PUB.count_and_get(
1022: p_encoded => FND_API.g_false,
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1079: FND_MSG_PUB.initialize;

1075: END IF;
1076: SAVEPOINT update_campaign;
1077:
1078: IF FND_API.to_boolean(p_init_msg_list) THEN
1079: FND_MSG_PUB.initialize;
1080: END IF;
1081:
1082: IF NOT FND_API.compatible_api_call(
1083: l_api_version,

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

1445: WHERE campaign_id = l_camp_rec.campaign_id
1446: AND object_version_number = l_camp_rec.object_version_number;
1447:
1448: IF (SQL%NOTFOUND) THEN
1449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1450: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1451: FND_MSG_PUB.add;
1452: END IF;
1453: RAISE FND_API.g_exc_error;

Line 1451: FND_MSG_PUB.add;

1447:
1448: IF (SQL%NOTFOUND) THEN
1449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1450: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1451: FND_MSG_PUB.add;
1452: END IF;
1453: RAISE FND_API.g_exc_error;
1454: END IF;
1455:

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

1464: WHERE campaign_id = l_camp_rec.campaign_id
1465: AND USERENV('LANG') IN (language, source_lang);
1466:
1467: IF (SQL%NOTFOUND) THEN
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1469: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1470: FND_MSG_PUB.add;
1471: END IF;
1472: RAISE FND_API.g_exc_error;

Line 1470: FND_MSG_PUB.add;

1466:
1467: IF (SQL%NOTFOUND) THEN
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1469: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1470: FND_MSG_PUB.add;
1471: END IF;
1472: RAISE FND_API.g_exc_error;
1473: END IF;
1474:

Line 1503: FND_MSG_PUB.count_and_get(

1499: IF FND_API.to_boolean(p_commit) THEN
1500: COMMIT;
1501: END IF;
1502:
1503: FND_MSG_PUB.count_and_get(
1504: p_encoded => FND_API.g_false,
1505: p_count => x_msg_count,
1506: p_data => x_msg_data
1507: );

Line 1522: FND_MSG_PUB.count_and_get(

1518:
1519: WHEN FND_API.g_exc_error THEN
1520: ROLLBACK TO update_campaign;
1521: x_return_status := FND_API.g_ret_sts_error;
1522: FND_MSG_PUB.count_and_get(
1523: p_encoded => FND_API.g_false,
1524: p_count => x_msg_count,
1525: p_data => x_msg_data
1526: );

Line 1531: FND_MSG_PUB.count_and_get(

1527:
1528: WHEN FND_API.g_exc_unexpected_error THEN
1529: ROLLBACK TO update_campaign;
1530: x_return_status := FND_API.g_ret_sts_unexp_error;
1531: FND_MSG_PUB.count_and_get(
1532: p_encoded => FND_API.g_false,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );

Line 1541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1537: WHEN OTHERS THEN
1538: ROLLBACK TO update_campaign;
1539: x_return_status := FND_API.g_ret_sts_unexp_error;
1540:
1541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1542: THEN
1543: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1544: END IF;
1545:

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

1539: x_return_status := FND_API.g_ret_sts_unexp_error;
1540:
1541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1542: THEN
1543: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1544: END IF;
1545:
1546: FND_MSG_PUB.count_and_get(
1547: p_encoded => FND_API.g_false,

Line 1546: FND_MSG_PUB.count_and_get(

1542: THEN
1543: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1544: END IF;
1545:
1546: FND_MSG_PUB.count_and_get(
1547: p_encoded => FND_API.g_false,
1548: p_count => x_msg_count,
1549: p_data => x_msg_data
1550: );

Line 1592: FND_MSG_PUB.initialize;

1588: AMS_Utility_PVT.debug_message(l_full_name||': start');
1589: END IF;
1590:
1591: IF FND_API.to_boolean(p_init_msg_list) THEN
1592: FND_MSG_PUB.initialize;
1593: END IF;
1594:
1595: IF NOT FND_API.compatible_api_call(
1596: l_api_version,

Line 1669: FND_MSG_PUB.count_and_get(

1665: END IF;
1666: END IF;
1667:
1668: -------------------- finish --------------------------
1669: FND_MSG_PUB.count_and_get(
1670: p_encoded => FND_API.g_false,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data
1673: );

Line 1687: FND_MSG_PUB.count_and_get(

1683: EXCEPTION
1684:
1685: WHEN FND_API.g_exc_error THEN
1686: x_return_status := FND_API.g_ret_sts_error;
1687: FND_MSG_PUB.count_and_get(
1688: p_encoded => FND_API.g_false,
1689: p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );

Line 1695: FND_MSG_PUB.count_and_get(

1691: );
1692:
1693: WHEN FND_API.g_exc_unexpected_error THEN
1694: x_return_status := FND_API.g_ret_sts_unexp_error ;
1695: FND_MSG_PUB.count_and_get(
1696: p_encoded => FND_API.g_false,
1697: p_count => x_msg_count,
1698: p_data => x_msg_data
1699: );

Line 1703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1699: );
1700:
1701: WHEN OTHERS THEN
1702: x_return_status := FND_API.g_ret_sts_unexp_error;
1703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1704: THEN
1705: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1706: END IF;
1707:

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

1701: WHEN OTHERS THEN
1702: x_return_status := FND_API.g_ret_sts_unexp_error;
1703: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1704: THEN
1705: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1706: END IF;
1707:
1708: FND_MSG_PUB.count_and_get(
1709: p_encoded => FND_API.g_false,

Line 1708: FND_MSG_PUB.count_and_get(

1704: THEN
1705: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1706: END IF;
1707:
1708: FND_MSG_PUB.count_and_get(
1709: p_encoded => FND_API.g_false,
1710: p_count => x_msg_count,
1711: p_data => x_msg_data
1712: );

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

1738: x_return_status := FND_API.g_ret_sts_success;
1739:
1740: ------------------------ owner_user_id --------------------------
1741: IF p_camp_rec.owner_user_id IS NULL THEN
1742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1743: THEN
1744: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_OWNER_ID');
1745: FND_MSG_PUB.add;
1746: END IF;

Line 1745: FND_MSG_PUB.add;

1741: IF p_camp_rec.owner_user_id IS NULL THEN
1742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1743: THEN
1744: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_OWNER_ID');
1745: FND_MSG_PUB.add;
1746: END IF;
1747: x_return_status := FND_API.g_ret_sts_error;
1748: END IF;
1749:

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

1748: END IF;
1749:
1750: ------------------------ user_status_id --------------------------
1751: IF p_camp_rec.user_status_id IS NULL THEN
1752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1753: THEN
1754: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_USER_STATUS_ID');
1755: FND_MSG_PUB.add;
1756: END IF;

Line 1755: FND_MSG_PUB.add;

1751: IF p_camp_rec.user_status_id IS NULL THEN
1752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1753: THEN
1754: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_USER_STATUS_ID');
1755: FND_MSG_PUB.add;
1756: END IF;
1757: x_return_status := FND_API.g_ret_sts_error;
1758: END IF;
1759:

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

1758: END IF;
1759:
1760: ------------------------ rollup_type --------------------------
1761: IF p_camp_rec.rollup_type IS NULL THEN
1762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1763: THEN
1764: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_ROOLUP_TYPE');
1765: FND_MSG_PUB.add;
1766: END IF;

Line 1765: FND_MSG_PUB.add;

1761: IF p_camp_rec.rollup_type IS NULL THEN
1762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1763: THEN
1764: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_ROOLUP_TYPE');
1765: FND_MSG_PUB.add;
1766: END IF;
1767: x_return_status := FND_API.g_ret_sts_error;
1768: END IF;
1769:

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

1768: END IF;
1769:
1770: ------------------------ application_id --------------------------
1771: IF p_camp_rec.application_id IS NULL THEN
1772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1773: THEN
1774: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1775: FND_MSG_PUB.add;
1776: END IF;

Line 1775: FND_MSG_PUB.add;

1771: IF p_camp_rec.application_id IS NULL THEN
1772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1773: THEN
1774: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1775: FND_MSG_PUB.add;
1776: END IF;
1777:
1778: x_return_status := FND_API.g_ret_sts_error;
1779: END IF;

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

1779: END IF;
1780:
1781: ------------------------ campaign_name --------------------------
1782: IF p_camp_rec.campaign_name IS NULL THEN
1783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1784: THEN
1785: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_NAME');
1786: FND_MSG_PUB.add;
1787: END IF;

Line 1786: FND_MSG_PUB.add;

1782: IF p_camp_rec.campaign_name IS NULL THEN
1783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1784: THEN
1785: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_NAME');
1786: FND_MSG_PUB.add;
1787: END IF;
1788: x_return_status := FND_API.g_ret_sts_error;
1789: END IF;
1790:

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

1789: END IF;
1790:
1791: ------------------------ Start Date --------------------------
1792: IF p_camp_rec.actual_exec_start_date IS NULL THEN
1793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1794: THEN
1795: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_START_DATE');
1796: FND_MSG_PUB.add;
1797: END IF;

Line 1796: FND_MSG_PUB.add;

1792: IF p_camp_rec.actual_exec_start_date IS NULL THEN
1793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1794: THEN
1795: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_START_DATE');
1796: FND_MSG_PUB.add;
1797: END IF;
1798: x_return_status := FND_API.g_ret_sts_error;
1799: END IF;
1800:

Line 1904: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1900: -- 'list_header_id',
1901: -- p_camp_rec.qp_list_header_id
1902: -- ) = FND_API.g_false
1903: -- THEN
1904: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1905: -- THEN
1906: -- FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_QP_LIST_ID');
1907: -- FND_MSG_PUB.add;
1908: -- END IF;

Line 1907: -- FND_MSG_PUB.add;

1903: -- THEN
1904: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1905: -- THEN
1906: -- FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_QP_LIST_ID');
1907: -- FND_MSG_PUB.add;
1908: -- END IF;
1909: -- x_return_status := FND_API.g_ret_sts_error;
1910: -- RETURN;
1911: -- END IF;

Line 1924: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1920: -- 'dscript_name',
1921: -- p_camp_rec.dscript_name
1922: -- ) = FND_API.g_false
1923: -- THEN
1924: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1925: -- THEN
1926: -- FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_DSCRIPT_NAME');
1927: -- FND_MSG_PUB.add;
1928: -- END IF;

Line 1927: -- FND_MSG_PUB.add;

1923: -- THEN
1924: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1925: -- THEN
1926: -- FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_DSCRIPT_NAME');
1927: -- FND_MSG_PUB.add;
1928: -- END IF;
1929: -- x_return_status := FND_API.g_ret_sts_error;
1930: -- RETURN;
1931: -- END IF;

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

2053: p_lookup_type => 'AMS_MEDIA_TYPE',
2054: p_lookup_code => p_camp_rec.media_type_code
2055: ) = FND_API.g_false
2056: THEN
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2058: THEN
2059: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_MEDIA_TYPE');
2060: FND_MSG_PUB.add;
2061: END IF;

Line 2060: FND_MSG_PUB.add;

2056: THEN
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2058: THEN
2059: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_MEDIA_TYPE');
2060: FND_MSG_PUB.add;
2061: END IF;
2062: x_return_status := FND_API.g_ret_sts_error;
2063: RETURN;
2064: END IF;

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

2390: -- budget amount must come with budget currency
2391: IF p_complete_rec.transaction_currency_code IS NULL
2392: AND p_complete_rec.budget_amount_tc IS NOT NULL
2393: THEN
2394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2395: THEN
2396: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2397: FND_MSG_PUB.add;
2398: END IF;

Line 2397: FND_MSG_PUB.add;

2393: THEN
2394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2395: THEN
2396: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2397: FND_MSG_PUB.add;
2398: END IF;
2399: x_return_status := FND_API.g_ret_sts_error;
2400: END IF;
2401:

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

2415: OPEN c_parent_type;
2416: FETCH c_parent_type INTO l_parent_type, l_status_code;
2417: IF (c_parent_type%NOTFOUND) THEN
2418: CLOSE c_parent_type;
2419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2420:
2421: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2422: FND_MSG_PUB.add;
2423: END IF;

Line 2422: FND_MSG_PUB.add;

2418: CLOSE c_parent_type;
2419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2420:
2421: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2422: FND_MSG_PUB.add;
2423: END IF;
2424: IF (AMS_DEBUG_HIGH_ON) THEN
2425:
2426: AMS_Utility_PVT.Debug_message('Error Here : ' ||p_camp_rec.parent_campaign_id );

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

2430: CLOSE c_parent_type;
2431:
2432: IF l_parent_type <> 'RCAM'
2433: THEN
2434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2435: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_ROLLUP_TYPE');
2436: FND_MSG_PUB.add;
2437: END IF;
2438: RAISE FND_API.g_exc_error;

Line 2436: FND_MSG_PUB.add;

2432: IF l_parent_type <> 'RCAM'
2433: THEN
2434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2435: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_ROLLUP_TYPE');
2436: FND_MSG_PUB.add;
2437: END IF;
2438: RAISE FND_API.g_exc_error;
2439: END IF;
2440:

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

2607: THEN
2608: IF p_complete_rec.rollup_type <> 'RCAM'
2609: AND p_camp_rec.actual_exec_end_date IS NULL
2610: THEN
2611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2612: THEN
2613: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_END_DATE');
2614: FND_MSG_PUB.add;
2615: END IF;

Line 2614: FND_MSG_PUB.add;

2610: THEN
2611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2612: THEN
2613: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_NO_END_DATE');
2614: FND_MSG_PUB.add;
2615: END IF;
2616: x_return_status := FND_API.g_ret_sts_error;
2617: RETURN;
2618: END IF;

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

3068: OPEN c_camp;
3069: FETCH c_camp INTO l_camp_rec;
3070: IF c_camp%NOTFOUND THEN
3071: CLOSE c_camp;
3072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3073: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3074: FND_MSG_PUB.add;
3075: END IF;
3076: RAISE FND_API.g_exc_error;

Line 3074: FND_MSG_PUB.add;

3070: IF c_camp%NOTFOUND THEN
3071: CLOSE c_camp;
3072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3073: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3074: FND_MSG_PUB.add;
3075: END IF;
3076: RAISE FND_API.g_exc_error;
3077: END IF;
3078: CLOSE c_camp;