DBA Data[Home] [Help]

APPS.AMS_COPYACTIVITIES_PVT dependencies on FND_MSG_PUB

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

51: -- 24-Dec-2007 spragupa ER - 6467510 - Extend Copy functionality to include TASKS for campaign schedules/activities
52: ---------------------------------------------------------------------
53:
54: g_file_name varchar2(30) := 'amsvcpab.pls';
55: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58:
59: PROCEDURE copy_event_header(

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

52: ---------------------------------------------------------------------
53:
54: g_file_name varchar2(30) := 'amsvcpab.pls';
55: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58:
59: PROCEDURE copy_event_header(
60: p_api_version IN NUMBER,

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

53:
54: g_file_name varchar2(30) := 'amsvcpab.pls';
55: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58:
59: PROCEDURE copy_event_header(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 287: FND_MSG_PUB.initialize;

283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean( p_init_msg_list )
286: THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289:
290: -- Debug Message
291: IF (AMS_DEBUG_HIGH_ON) THEN

Line 762: FND_MSG_PUB.Count_And_Get

758: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
759: END IF;
760:
761: -- Standard call to get message count and if count is 1, get message info.
762: FND_MSG_PUB.Count_And_Get
763: (p_count => x_msg_count,
764: p_data => x_msg_data
765: );
766: --WRITE_TO_ACT_LOG('All attributes copied succesfully','CAMP',1111);

Line 772: FND_MSG_PUB.Count_And_Get (

768: WHEN FND_API.G_EXC_ERROR THEN
769: ROLLBACK TO COPY_Camp_Common_PVT;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: -- Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );

Line 781: FND_MSG_PUB.Count_And_Get (

777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO COPY_Camp_Common_PVT;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );

Line 789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

785: );
786: WHEN OTHERS THEN
787: ROLLBACK TO COPY_Camp_Common_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
791: END IF;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (

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

786: WHEN OTHERS THEN
787: ROLLBACK TO COPY_Camp_Common_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
791: END IF;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,

Line 793: FND_MSG_PUB.Count_And_Get (

789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
791: END IF;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );

Line 849: fnd_msg_pub.initialize;

845: END IF;
846:
847: IF fnd_api.to_boolean(p_init_msg_list)
848: THEN
849: fnd_msg_pub.initialize;
850: END IF;
851:
852: IF NOT fnd_api.compatible_api_call(
853: l_api_version,

Line 988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

984: OR l_return_status = fnd_api.g_ret_sts_unexp_error
985: THEN
986: FOR l_counter IN 1 .. l_msg_count
987: LOOP
988: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
989: p_errmsg := SUBSTR( l_mesg_text || ',): ' || l_counter ||
990: ' OF ' || l_msg_count, 1, 3000);
991: ams_cpyutility_pvt.write_log_mesg( 'DELV',
992: p_src_deliv_id,

Line 1119: fnd_msg_pub.count_and_get(

1115: WHEN fnd_api.g_exc_error
1116: THEN
1117: ROLLBACK TO copy_deliverables;
1118: x_return_status := fnd_api.g_ret_sts_error;
1119: fnd_msg_pub.count_and_get(
1120: p_encoded => fnd_api.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);
1123: WHEN fnd_api.g_exc_unexpected_error

Line 1127: fnd_msg_pub.count_and_get(

1123: WHEN fnd_api.g_exc_unexpected_error
1124: THEN
1125: ROLLBACK TO copy_deliverables;
1126: x_return_status := fnd_api.g_ret_sts_unexp_error;
1127: fnd_msg_pub.count_and_get(
1128: p_encoded => fnd_api.g_false,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data);
1131: WHEN OTHERS

Line 1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1132: THEN
1133: ROLLBACK TO copy_deliverables;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1137: THEN
1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1139: END IF;
1140:

Line 1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1137: THEN
1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1139: END IF;
1140:
1141: fnd_msg_pub.count_and_get(
1142: p_encoded => fnd_api.g_false,

Line 1141: fnd_msg_pub.count_and_get(

1137: THEN
1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1139: END IF;
1140:
1141: fnd_msg_pub.count_and_get(
1142: p_encoded => fnd_api.g_false,
1143: p_count => x_msg_count,
1144: p_data => x_msg_data);
1145: END copy_deliverables;

Line 1222: fnd_msg_pub.initialize;

1218: END IF;
1219:
1220: IF fnd_api.to_boolean(p_init_msg_list)
1221: THEN
1222: fnd_msg_pub.initialize;
1223: END IF;
1224:
1225: IF NOT fnd_api.compatible_api_call(
1226: l_api_version,

Line 1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1432: IF l_return_status = fnd_api.g_ret_sts_error
1433: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1434: THEN
1435: FOR l_counter IN 1 .. l_msg_count LOOP
1436: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1437: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter || ' OF ' ||
1438: l_msg_count, 1, 3000);
1439: ams_cpyutility_pvt.write_log_mesg( 'EVEO',
1440: p_src_eveo_id,

Line 1621: fnd_msg_pub.count_and_get(

1617: WHEN fnd_api.g_exc_error
1618: THEN
1619: ROLLBACK TO copy_event_offer;
1620: x_return_status := fnd_api.g_ret_sts_error;
1621: fnd_msg_pub.count_and_get(
1622: p_encoded => fnd_api.g_false,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data);
1625: WHEN fnd_api.g_exc_unexpected_error

Line 1633: fnd_msg_pub.count_and_get(

1629: IF (AMS_DEBUG_HIGH_ON) THEN
1630:
1631: ams_utility_pvt.debug_message(l_full_name || ': debug');
1632: END IF;
1633: fnd_msg_pub.count_and_get(
1634: p_encoded => fnd_api.g_false,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data);
1637: WHEN OTHERS

Line 1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1638: THEN
1639: ROLLBACK TO copy_event_offer;
1640: x_return_status := fnd_api.g_ret_sts_unexp_error;
1641:
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1643: THEN
1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1645: END IF;
1646:

Line 1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1640: x_return_status := fnd_api.g_ret_sts_unexp_error;
1641:
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1643: THEN
1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1645: END IF;
1646:
1647: fnd_msg_pub.count_and_get(
1648: p_encoded => fnd_api.g_false,

Line 1647: fnd_msg_pub.count_and_get(

1643: THEN
1644: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1645: END IF;
1646:
1647: fnd_msg_pub.count_and_get(
1648: p_encoded => fnd_api.g_false,
1649: p_count => x_msg_count,
1650: p_data => x_msg_data);
1651: END copy_event_offer;

Line 1730: fnd_msg_pub.initialize;

1726: END IF;
1727:
1728: IF fnd_api.to_boolean(p_init_msg_list)
1729: THEN
1730: fnd_msg_pub.initialize;
1731: END IF;
1732:
1733: IF NOT fnd_api.compatible_api_call(
1734: l_api_version,

Line 1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1900: IF l_return_status = fnd_api.g_ret_sts_error
1901: OR l_return_status = fnd_api.g_ret_sts_unexp_error
1902: THEN
1903: FOR l_counter IN 1 .. l_msg_count LOOP
1904: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1905: p_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
1906: ' OF ' || l_msg_count, 1, 3000);
1907: ams_cpyutility_pvt.write_log_mesg( 'EVEH',
1908: p_src_eveh_id,

Line 2108: fnd_msg_pub.count_and_get(

2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO copy_event_header;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get(
2109: p_encoded => fnd_api.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);
2112: WHEN fnd_api.g_exc_unexpected_error

Line 2120: fnd_msg_pub.count_and_get(

2116: IF (AMS_DEBUG_HIGH_ON) THEN
2117:
2118: ams_utility_pvt.debug_message(l_full_name || ': debug');
2119: END IF;
2120: fnd_msg_pub.count_and_get(
2121: p_encoded => fnd_api.g_false,
2122: p_count => x_msg_count,
2123: p_data => x_msg_data);
2124: WHEN OTHERS

Line 2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2125: THEN
2126: ROLLBACK TO copy_event_header;
2127: x_return_status := fnd_api.g_ret_sts_unexp_error;
2128:
2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2130: THEN
2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2132: END IF;
2133:

Line 2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2127: x_return_status := fnd_api.g_ret_sts_unexp_error;
2128:
2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2130: THEN
2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2132: END IF;
2133:
2134: fnd_msg_pub.count_and_get(
2135: p_encoded => fnd_api.g_false,

Line 2134: fnd_msg_pub.count_and_get(

2130: THEN
2131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2132: END IF;
2133:
2134: fnd_msg_pub.count_and_get(
2135: p_encoded => fnd_api.g_false,
2136: p_count => x_msg_count,
2137: p_data => x_msg_data);
2138: END copy_event_header;

Line 2235: FND_MSG_PUB.initialize ;

2231: END IF;
2232: -- Initialize the message List
2233: IF FND_API.to_Boolean( p_init_msg_list )
2234: THEN
2235: FND_MSG_PUB.initialize ;
2236: END IF;
2237: -- Lookup Meaning from ams_lookup for CAMP
2238: IF (AMS_DEBUG_HIGH_ON) THEN
2239:

Line 2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2448: IF ( l_return_status = fnd_api.g_ret_sts_error ) OR
2449: ( l_return_status = fnd_api.g_ret_sts_error ) then
2450: FOR l_counter IN 1 .. l_msg_count
2451: LOOP
2452: l_mesg_text := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2453: l_errmsg := SUBSTR( l_mesg_text || '): ' || l_counter ||
2454: ' OF ' || l_msg_count, 1, 3000);
2455: ams_cpyutility_pvt.write_log_mesg( 'CAMP',
2456: p_src_camp_id,

Line 2676: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,

2672: EXCEPTION
2673: WHEN FND_API.G_EXC_ERROR THEN
2674: ROLLBACK TO Copy_Campaign_PVT;
2675: x_return_status := FND_API.G_RET_STS_ERROR ;
2676: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2677: p_data => x_msg_data
2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Copy_Campaign_PVT;

Line 2682: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,

2678: );
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO Copy_Campaign_PVT;
2681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2682: FND_MSG_PUB.Count_and_Get ( p_count => x_msg_count,
2683: p_data => x_msg_data
2684: );
2685: WHEN OTHERS THEN
2686: ROLLBACK TO Copy_Campaign_PVT;

Line 2688: IF FND_MSG_PUB.Check_Msg_Level

2684: );
2685: WHEN OTHERS THEN
2686: ROLLBACK TO Copy_Campaign_PVT;
2687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2688: IF FND_MSG_PUB.Check_Msg_Level
2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2690: THEN
2691: FND_MSG_PUB.Add_Exc_MSG ( G_FILE_NAME,
2692: G_PKG_NAME,

Line 2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

2685: WHEN OTHERS THEN
2686: ROLLBACK TO Copy_Campaign_PVT;
2687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2688: IF FND_MSG_PUB.Check_Msg_Level
2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2690: THEN
2691: FND_MSG_PUB.Add_Exc_MSG ( G_FILE_NAME,
2692: G_PKG_NAME,
2693: l_api_name

Line 2691: FND_MSG_PUB.Add_Exc_MSG ( G_FILE_NAME,

2687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2688: IF FND_MSG_PUB.Check_Msg_Level
2689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2690: THEN
2691: FND_MSG_PUB.Add_Exc_MSG ( G_FILE_NAME,
2692: G_PKG_NAME,
2693: l_api_name
2694: );
2695: END IF;

Line 2696: FND_MSG_PUB.Count_and_Get (p_count => x_msg_count,

2692: G_PKG_NAME,
2693: l_api_name
2694: );
2695: END IF;
2696: FND_MSG_PUB.Count_and_Get (p_count => x_msg_count,
2697: p_data => x_msg_data
2698: );
2699:
2700: END Copy_Campaign;

Line 2754: FND_MSG_PUB.initialize;

2750: END IF;
2751:
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list )THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756:
2757: IF (AMS_DEBUG_HIGH_ON) THEN
2758:

Line 3004: FND_MSG_PUB.Count_And_Get (

3000: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3001: END IF;
3002:
3003: -- Standard call to get message count and if count is 1, get message info.
3004: FND_MSG_PUB.Count_And_Get (
3005: p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );
3008: EXCEPTION

Line 3013: FND_MSG_PUB.Count_And_Get (

3009: WHEN FND_API.G_EXC_ERROR THEN
3010: ROLLBACK TO copy_schedule_savepoint;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: -- Standard call to get message count and if count=1, get the message
3013: FND_MSG_PUB.Count_And_Get (
3014: p_encoded => FND_API.G_FALSE,
3015: p_count => x_msg_count,
3016: p_data => x_msg_data
3017: );

Line 3022: FND_MSG_PUB.Count_And_Get (

3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO copy_schedule_savepoint;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: -- Standard call to get message count and if count=1, get the message
3022: FND_MSG_PUB.Count_And_Get (
3023: p_encoded => FND_API.G_FALSE,
3024: p_count => x_msg_count,
3025: p_data => x_msg_data
3026: );

Line 3030: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3026: );
3027: WHEN OTHERS THEN
3028: ROLLBACK TO copy_schedule_savepoint;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3031: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3032: END IF;
3033: -- Standard call to get message count and if count=1, get the message
3034: FND_MSG_PUB.Count_And_Get (

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

3027: WHEN OTHERS THEN
3028: ROLLBACK TO copy_schedule_savepoint;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3031: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3032: END IF;
3033: -- Standard call to get message count and if count=1, get the message
3034: FND_MSG_PUB.Count_And_Get (
3035: p_encoded => FND_API.G_FALSE,

Line 3034: FND_MSG_PUB.Count_And_Get (

3030: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3031: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3032: END IF;
3033: -- Standard call to get message count and if count=1, get the message
3034: FND_MSG_PUB.Count_And_Get (
3035: p_encoded => FND_API.G_FALSE,
3036: p_count => x_msg_count,
3037: p_data => x_msg_data
3038: );