DBA Data[Home] [Help]

APPS.AMS_WEBMARKETING_PVT dependencies on FND_MSG_PUB

Line 8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_WEBMARKETING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvwppb.pls';
6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12:

Line 9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvwppb.pls';
6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12:
13:

Line 10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12:
13:
14: -- ========================================================================

Line 68: FND_MSG_PUB.Count_And_Get (

64: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: -- Standard call to get message count and if count=1, get the message
67:
68: FND_MSG_PUB.Count_And_Get (
69: p_encoded => FND_API.G_FALSE,
70: p_count => x_msg_count,
71: p_data => x_msg_data
72: );

Line 79: FND_MSG_PUB.Count_And_Get (

75: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: -- Standard call to get message count and if count=1, get the message
79: FND_MSG_PUB.Count_And_Get (
80: p_encoded => FND_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data
83: );

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

84:
85: WHEN OTHERS THEN
86: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;
92: -- Standard call to get message count and if count=1, get the message

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

86: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,

Line 93: FND_MSG_PUB.Count_And_Get (

89: THEN
90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data
97: );

Line 194: FND_MSG_PUB.initialize;

190:
191: -- Initialize message list if p_init_msg_list is set to TRUE.
192: IF FND_API.to_Boolean( p_init_msg_list )
193: THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- Debug Message
198: --Bug Fix 4652859

Line 374: FND_MSG_PUB.Count_And_Get

370: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
375: (p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378:

Line 387: FND_MSG_PUB.Count_And_Get (

383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO webmarketing_plce_citems_pvt;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );

Line 397: FND_MSG_PUB.Count_And_Get (

393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO webmarketing_plce_citems_pvt;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

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

402:
403: WHEN OTHERS THEN
404: ROLLBACK TO webmarketing_plce_citems_pvt;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message

Line 408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);

404: ROLLBACK TO webmarketing_plce_citems_pvt;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,

Line 411: FND_MSG_PUB.Count_And_Get (

407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );

Line 489: FND_MSG_PUB.initialize;

485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean( p_init_msg_list )
488: THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:
492: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
493:

Line 550: FND_MSG_PUB.Count_And_Get

546: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
547: END IF;
548:
549: -- Standard call to get message count and if count is 1, get message info.
550: FND_MSG_PUB.Count_And_Get
551: (p_count => x_msg_count,
552: p_data => x_msg_data
553: );
554:

Line 564: FND_MSG_PUB.Count_And_Get (

560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
564: FND_MSG_PUB.Count_And_Get (
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data
568: );

Line 576: FND_MSG_PUB.Count_And_Get (

572: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );

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

584:
585: AMS_UTILITY_PVT.debug_message('In Validate - others err: validation_mode= ' || p_validation_mode);
586: END IF;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
591: END IF;
592:

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

586: END IF;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
591: END IF;
592:
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (

Line 594: FND_MSG_PUB.Count_And_Get (

590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
591: END IF;
592:
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
598: );

Line 733: FND_MSG_PUB.initialize;

729:
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF FND_API.to_Boolean(p_init_msg_list)
732: THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Debug Message
737: IF (AMS_DEBUG_HIGH_ON) THEN

Line 902: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

898: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
899: -- END IF;
900:
901: -- Standard call to get message count and if count is 1, get message info.
902: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905:
906: x_placement_mp_id := l_placement_mp_id;

Line 929: FND_MSG_PUB.Count_And_Get (

925: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: -- Standard call to get message count and if count=1, get the message
928:
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );

Line 940: FND_MSG_PUB.Count_And_Get (

936: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938:
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count,
943: p_data => x_msg_data
944: );

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

945:
946: WHEN OTHERS THEN
947: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
952: END IF;
953: -- Standard call to get message count and if count=1, get the message

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

947: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
952: END IF;
953: -- Standard call to get message count and if count=1, get the message
954:
955: FND_MSG_PUB.Count_And_Get (

Line 955: FND_MSG_PUB.Count_And_Get (

951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
952: END IF;
953: -- Standard call to get message count and if count=1, get the message
954:
955: FND_MSG_PUB.Count_And_Get (
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data
959: );

Line 1028: FND_MSG_PUB.initialize;

1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1027: THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1031: -- Debug Message
1032: --Bug Fix 4652859

Line 1064: FND_MSG_PUB.Count_And_Get (

1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO webmarketing_plce_content_type;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data
1068: );

Line 1074: FND_MSG_PUB.Count_And_Get (

1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: ROLLBACK TO webmarketing_plce_content_type;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,
1076: p_count => x_msg_count,
1077: p_data => x_msg_data
1078: );

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

1079:
1080: WHEN OTHERS THEN
1081: ROLLBACK TO webmarketing_plce_content_type;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1084: THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;
1087: -- Standard call to get message count and if count=1, get the message

Line 1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);

1081: ROLLBACK TO webmarketing_plce_content_type;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1084: THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,

Line 1088: FND_MSG_PUB.Count_And_Get (

1084: THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );

Line 1163: FND_MSG_PUB.initialize;

1159:
1160: -- Initialize message list if p_init_msg_list is set to TRUE.
1161: IF FND_API.to_Boolean( p_init_msg_list )
1162: THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:
1166: -- Debug Message
1167: --Bug Fix 4652859

Line 1202: FND_MSG_PUB.add;

1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199: ELSE
1200: x_return_status := FND_API. G_RET_STS_ERROR;
1201: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_CITEM_NOT_APPR');
1202: FND_MSG_PUB.add;
1203: FND_MSG_PUB.Count_AND_Get
1204: ( p_count => x_msg_count,
1205: p_data => x_msg_data,
1206: p_encoded => FND_API.G_FALSE

Line 1203: FND_MSG_PUB.Count_AND_Get

1199: ELSE
1200: x_return_status := FND_API. G_RET_STS_ERROR;
1201: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_CITEM_NOT_APPR');
1202: FND_MSG_PUB.add;
1203: FND_MSG_PUB.Count_AND_Get
1204: ( p_count => x_msg_count,
1205: p_data => x_msg_data,
1206: p_encoded => FND_API.G_FALSE
1207: );

Line 1213: FND_MSG_PUB.add;

1209: -- Invalid association
1210: ELSE
1211: x_return_status := FND_API. G_RET_STS_ERROR;
1212: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_ACTIVITY_INVALID');
1213: FND_MSG_PUB.add;
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE

Line 1214: FND_MSG_PUB.Count_AND_Get

1210: ELSE
1211: x_return_status := FND_API. G_RET_STS_ERROR;
1212: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_ACTIVITY_INVALID');
1213: FND_MSG_PUB.add;
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE
1218: );

Line 1233: FND_MSG_PUB.add;

1229:
1230: -- Invalid activity id passed
1231: x_return_status := FND_API. G_RET_STS_ERROR;
1232: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_NO_ACTIVITY');
1233: FND_MSG_PUB.add;
1234: FND_MSG_PUB.Count_AND_Get
1235: ( p_count => x_msg_count,
1236: p_data => x_msg_data,
1237: p_encoded => FND_API.G_FALSE

Line 1234: FND_MSG_PUB.Count_AND_Get

1230: -- Invalid activity id passed
1231: x_return_status := FND_API. G_RET_STS_ERROR;
1232: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_NO_ACTIVITY');
1233: FND_MSG_PUB.add;
1234: FND_MSG_PUB.Count_AND_Get
1235: ( p_count => x_msg_count,
1236: p_data => x_msg_data,
1237: p_encoded => FND_API.G_FALSE
1238: );

Line 1249: FND_MSG_PUB.Count_And_Get (

1245: WHEN FND_API.G_EXC_ERROR THEN
1246: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1253: );

Line 1259: FND_MSG_PUB.Count_And_Get (

1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: -- Standard call to get message count and if count=1, get the message
1259: FND_MSG_PUB.Count_And_Get (
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );

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

1264:
1265: WHEN OTHERS THEN
1266: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message

Line 1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);

1266: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,

Line 1273: FND_MSG_PUB.Count_And_Get (

1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data
1277: );