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.IBE_PROD_RELATION_GRP dependencies on FND_MSG_PUB

Line 199: FND_MSG_PUB.initialize;

195: END IF;
196:
197: -- Initialize message list if l_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( l_init_msg_list ) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203: -- Initialize the return value table

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

221: IF (l_debug = 'Y') THEN
222: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
223: END IF;
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count ,
227: p_data => x_msg_data );
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN

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

227: p_data => x_msg_data );
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count ,
233: p_data => x_msg_data );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

232: p_count => x_msg_count ,
233: p_data => x_msg_data );
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count ,
238: p_data => x_msg_data );
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

237: p_count => x_msg_count ,
238: p_data => x_msg_data );
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
243: l_api_name );
244: END IF;
245: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

238: p_data => x_msg_data );
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
243: l_api_name );
244: END IF;
245: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
246: p_count => x_msg_count ,

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

241: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
243: l_api_name );
244: END IF;
245: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
246: p_count => x_msg_count ,
247: p_data => x_msg_data );
248: END Get_Related_Items;
249: -- Start of comments

Line 438: FND_MSG_PUB.initialize;

434: END IF;
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- Initialize the return value table

Line 458: FND_MSG_PUB.Add;

454: IBE_UTIL.debug('Relationship is not valid.');
455: END IF;
456: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
457: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461: IF l_rule_type = 'SQL' THEN
462: -- 2. Get the related items using the manual SQL.

Line 564: FND_MSG_PUB.Add;

560: IBE_UTIL.debug('SQL execution caused an error.');
561: END IF;
562: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_SQL_RULE_ERROR');
563: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: END; -- end sub-block to handle the SELECT statement's exception
567: ELSE -- l_rule_type = 'MAPPING'
568: -- 3. Get the related items from ibe_ct_related_items table

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

657: IF (l_debug = 'Y') THEN
658: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
659: END IF;
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count ,
663: p_data => x_msg_data );
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN

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

663: p_data => x_msg_data );
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count ,
669: p_data => x_msg_data );
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

668: p_count => x_msg_count ,
669: p_data => x_msg_data );
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count ,
674: p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

673: p_count => x_msg_count ,
674: p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
679: l_api_name );
680: END IF;
681: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

674: p_data => x_msg_data );
675: WHEN OTHERS THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
679: l_api_name );
680: END IF;
681: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count ,

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

677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
679: l_api_name );
680: END IF;
681: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count ,
683: p_data => x_msg_data );
684: END Get_Related_Items;
685: PROCEDURE Get_Related_Items

Line 1140: FND_MSG_PUB.initialize;

1136: END IF;
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.
1139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: -- Initialize API return status to success
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1163: FND_MSG_PUB.Add;

1159: IBE_UTIL.debug('Relationship is not valid.');
1160: END IF;
1161: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1162: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167: -- Populate the itemIds into a temporary table.

Line 1288: FND_MSG_PUB.Add;

1284: IBE_UTIL.debug('SQL execution caused an error.');
1285: END IF;
1286: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_SQL_RULE_ERROR');
1287: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1288: FND_MSG_PUB.Add;
1289: RAISE FND_API.G_EXC_ERROR;
1290: END; -- end sub-block to handle the SELECT statement's exception
1291: ELSE -- l_rule_type = 'MAPPING'
1292: -- 3. Get the related items from ibe_ct_related_items table

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

1566: IF (l_debug = 'Y') THEN
1567: IBE_UTIL.debug('IBE_Prod_Relation_GRP.Get_Related_Items(-)');
1568: END IF;
1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count ,
1572: p_data => x_msg_data );
1573: EXCEPTION
1574: WHEN FND_API.G_EXC_ERROR THEN

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

1572: p_data => x_msg_data );
1573: EXCEPTION
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count ,
1578: p_data => x_msg_data );
1579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1577: p_count => x_msg_count ,
1578: p_data => x_msg_data );
1579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count ,
1583: p_data => x_msg_data );
1584: WHEN OTHERS THEN
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1582: p_count => x_msg_count ,
1583: p_data => x_msg_data );
1584: WHEN OTHERS THEN
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1588: l_api_name );
1589: END IF;
1590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1583: p_data => x_msg_data );
1584: WHEN OTHERS THEN
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1588: l_api_name );
1589: END IF;
1590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1591: p_count => x_msg_count ,

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

1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1588: l_api_name );
1589: END IF;
1590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1591: p_count => x_msg_count ,
1592: p_data => x_msg_data );
1593: END Get_Related_Items;
1594: END IBE_Prod_Relation_GRP;