DBA Data[Home] [Help]

APPS.AMS_RUNTIME_PROD_PVT dependencies on FND_MSG_PUB

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

1: PACKAGE BODY AMS_RUNTIME_PROD_PVT as
2: /* $Header: amsvrpdb.pls 115.20 2004/07/27 14:06:48 sikalyan ship $*/
3:
4: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: FUNCTION Is_Relationship_Valid(

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

1: PACKAGE BODY AMS_RUNTIME_PROD_PVT as
2: /* $Header: amsvrpdb.pls 115.20 2004/07/27 14:06:48 sikalyan ship $*/
3:
4: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: FUNCTION Is_Relationship_Valid(
9: p_relation_type_code VARCHAR2) RETURN BOOLEAN

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

2: /* $Header: amsvrpdb.pls 115.20 2004/07/27 14:06:48 sikalyan ship $*/
3:
4: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8: FUNCTION Is_Relationship_Valid(
9: p_relation_type_code VARCHAR2) RETURN BOOLEAN
10: IS

Line 212: FND_MSG_PUB.initialize;

208: END IF;
209:
210: -- Initialize message list if p_init_msg_list is set to TRUE.
211: IF FND_API.to_Boolean( p_init_msg_list ) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: -- Initialize API return status to success
216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 387: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

383: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
384: END IF;
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data);
390:
391: EXCEPTION

Line 394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

396: p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: WHEN OTHERS THEN

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

403:
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
409: l_api_name );
410: END IF;
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
409: l_api_name );
410: END IF;
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,

Line 411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
409: l_api_name );
410: END IF;
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,
413: p_data => x_msg_data);
414:
415: END getRelatedItems;

Line 558: FND_MSG_PUB.initialize;

554: END IF;
555:
556: -- Initialize message list if p_init_msg_list is set to TRUE.
557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- Initialize API return status to success
562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 598: AMS_UTILITY_PVT.debug_message(' p_max_ret_num is NULL: relationship NOT in MTL.', FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);

594:
595: IF (p_max_ret_num IS NULL) AND (NOT include_mtl) THEN -- Can use bulk fetching
596: IF (AMS_DEBUG_HIGH_ON) THEN
597:
598: AMS_UTILITY_PVT.debug_message(' p_max_ret_num is NULL: relationship NOT in MTL.', FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
599: END IF;
600:
601: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
602: '; END;'

Line 679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

675: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
676: END IF;
677:
678: -- Standard call to get message count and if count is 1, get message info.
679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:
683: EXCEPTION

Line 686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

688: p_data => x_msg_data);
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:
696:

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

696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name );
703: END IF;
704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name );
703: END IF;
704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,

Line 704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

700: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
702: l_api_name );
703: END IF;
704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707:
708: END getRelatedItems;

Line 907: FND_MSG_PUB.initialize;

903: END IF;
904:
905: -- Initialize message list if p_init_msg_list is set to TRUE.
906: IF FND_API.to_Boolean( p_init_msg_list ) THEN
907: FND_MSG_PUB.initialize;
908: END IF;
909:
910: -- Initialize API return status to success
911: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1074: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList ends');
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info.
1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data);
1081:
1082: EXCEPTION

Line 1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1081:
1082: EXCEPTION
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1087: p_data => x_msg_data);
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:
1095:

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

1095:
1096: WHEN OTHERS THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098:
1099: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1101: l_api_name);
1102: END IF;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1096: WHEN OTHERS THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098:
1099: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1101: l_api_name);
1102: END IF;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,

Line 1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1099: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1101: l_api_name);
1102: END IF;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106:
1107: END getFilteredProdsFromList;

Line 1161: FND_MSG_PUB.initialize;

1157: END IF;
1158:
1159: -- Initialize message list if p_init_msg_list is set to TRUE.
1160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1161: FND_MSG_PUB.initialize;
1162: END IF;
1163:
1164: -- Initialize API return status to success
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1180: FND_MSG_PUB.Add;

1176: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
1177: END IF;
1178: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1179: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1180: FND_MSG_PUB.Add;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN

Line 1280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1276: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
1277: END IF;
1278:
1279: -- Standard call to get message count and if count is 1, get message info.
1280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: EXCEPTION

Line 1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1283:
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1289: p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:
1297:

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

1297:
1298: WHEN OTHERS THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300:
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1303: l_api_name );
1304: END IF;
1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1298: WHEN OTHERS THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300:
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1303: l_api_name );
1304: END IF;
1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count ,

Line 1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1303: l_api_name );
1304: END IF;
1305: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count ,
1307: p_data => x_msg_data );
1308:
1309: END getRelProdsForQuoteAndCust;

Line 1362: FND_MSG_PUB.initialize;

1358: END IF;
1359:
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1362: FND_MSG_PUB.initialize;
1363: END IF;
1364:
1365: -- Initialize API return status to success
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1381: FND_MSG_PUB.Add;

1377: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
1378: END IF;
1379: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1380: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1381: FND_MSG_PUB.Add;
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: IF (p_filter_ref_code = 'INCL_PROD_SECTION') THEN

Line 1469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1465:
1466: END IF;
1467:
1468: -- Standard call to get message count and if count is 1, get message info.
1469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1470: p_count => x_msg_count ,
1471: p_data => x_msg_data );
1472:
1473: EXCEPTION

Line 1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1472:
1473: EXCEPTION
1474: WHEN FND_API.G_EXC_ERROR THEN
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1478: p_data => x_msg_data );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1483: p_count => x_msg_count ,
1484: p_data => x_msg_data );
1485:
1486:

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

1486:
1487: WHEN OTHERS THEN
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489:
1490: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1492: l_api_name );
1493: END IF;
1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1487: WHEN OTHERS THEN
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489:
1490: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1492: l_api_name );
1493: END IF;
1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1495: p_count => x_msg_count ,

Line 1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1490: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1492: l_api_name );
1493: END IF;
1494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1495: p_count => x_msg_count ,
1496: p_data => x_msg_data );
1497:
1498: END getRelProdsForProdAndCust;

Line 1558: FND_MSG_PUB.initialize;

1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- Initialize API return status to success
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1715: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1711:
1712: -- End of API body.
1713:
1714: -- Standard call to get message count and if count is 1, get message info.
1715: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data);
1718:
1719: EXCEPTION

Line 1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1718:
1719: EXCEPTION
1720: WHEN FND_API.G_EXC_ERROR THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1724: p_data => x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732:

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

1732:
1733: WHEN OTHERS THEN
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735:
1736: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1738: l_api_name );
1739: END IF;
1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1733: WHEN OTHERS THEN
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735:
1736: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1738: l_api_name );
1739: END IF;
1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1741: p_count => x_msg_count,

Line 1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1736: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1737: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1738: l_api_name );
1739: END IF;
1740: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1741: p_count => x_msg_count,
1742: p_data => x_msg_data);
1743:
1744: END getPrioritizedProds;

Line 1826: FND_MSG_PUB.initialize;

1822: END IF;
1823:
1824: -- Initialize message list if p_init_msg_list is set to TRUE.
1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: -- Initialize API return status to success
1830: x_item_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1846: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1842: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');
1843: END IF;
1844:
1845: -- Standard call to get message count and if count is 1, get message info.
1846: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1847: p_count => x_msg_count ,
1848: p_data => x_msg_data );
1849: return;
1850: END IF;

Line 1916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1912:
1913: -- End of API body.
1914:
1915: -- Standard call to get message count and if count is 1, get message info.
1916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1917: p_count => x_msg_count,
1918: p_data => x_msg_data);
1919:
1920: EXCEPTION

Line 1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1919:
1920: EXCEPTION
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: x_item_return_status := FND_API.G_RET_STS_ERROR;
1923: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1925: p_data => x_msg_data);
1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:
1933:

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

1933:
1934: WHEN OTHERS THEN
1935: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936:
1937: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

1934: WHEN OTHERS THEN
1935: x_item_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936:
1937: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,

Line 1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1937: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944:
1945: END loadItemDetails;

Line 1999: FND_MSG_PUB.initialize;

1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE.
1997:
1998: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1999: FND_MSG_PUB.initialize;
2000: END IF;
2001:
2002: -- Initialize API return status to success
2003:

Line 2022: FND_MSG_PUB.Add;

2018: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
2019: END IF;
2020: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2021: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
2022: FND_MSG_PUB.Add;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: l_max := p_max_ret_num;

Line 2091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2087: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
2088: END IF;
2089:
2090: -- Standard call to get message count and if count is 1, get message info.
2091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2092: p_count => x_msg_count,
2093: p_data => x_msg_data);
2094:
2095: EXCEPTION

Line 2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR;
2098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2100: p_data => x_msg_data);
2101:
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107:
2108:

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

2108:
2109: WHEN OTHERS THEN
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2114: l_api_name );
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2109: WHEN OTHERS THEN
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2114: l_api_name );
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count ,

Line 2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2114: l_api_name );
2115: END IF;
2116: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count ,
2118: p_data => x_msg_data );
2119:
2120: END getRelProdsForCart;

Line 2171: FND_MSG_PUB.initialize;

2167:
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.
2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2171: FND_MSG_PUB.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success
2175: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2190: FND_MSG_PUB.Add;

2186: END IF;
2187:
2188: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2189: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
2190: FND_MSG_PUB.Add;
2191: RAISE FND_API.G_EXC_ERROR;
2192:
2193: END IF;
2194:

Line 2237: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2233: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');
2234: END IF;
2235:
2236: -- Standard call to get message count and if count is 1, get message info.
2237: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2238: p_count => x_msg_count ,
2239: p_data => x_msg_data );
2240:
2241: EXCEPTION

Line 2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2240:
2241: EXCEPTION
2242: WHEN FND_API.G_EXC_ERROR THEN
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count ,
2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2246: p_data => x_msg_data );
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count ,
2252: p_data => x_msg_data );
2253:
2254:

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

2254:
2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257:
2258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2260: l_api_name );
2261: END IF;
2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257:
2258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2260: l_api_name );
2261: END IF;
2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count ,

Line 2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2260: l_api_name );
2261: END IF;
2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data );
2265:
2266: