DBA Data[Home] [Help]

APPS.AMV_SEARCH_PVT dependencies on FND_MSG_PUB

Line 673: FND_MSG_PUB.ADD;*/

669: /* FND_MESSAGE.SET_NAME('AMV','AMV_API_ERROR');
670:
671: FND_MESSAGE.Set_Token('API', 'Parse_IMT_String');
672:
673: FND_MSG_PUB.ADD;*/
674:
675: END Parse_IMT_String;
676:
677:

Line 6350: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

6346: END IF;
6347:
6348: -- Debug Message
6349:
6350: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6351:
6352: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6353:
6354: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

Line 6356: FND_MSG_PUB.Add;

6352: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6353:
6354: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6355:
6356: FND_MSG_PUB.Add;
6357:
6358: END IF;
6359:
6360: --Initialize message list if p_init_msg_list is TRUE.

Line 6364: FND_MSG_PUB.initialize;

6360: --Initialize message list if p_init_msg_list is TRUE.
6361:
6362: IF FND_API.To_Boolean (p_init_msg_list) THEN
6363:
6364: FND_MSG_PUB.initialize;
6365:
6366: END IF;
6367:
6368: -- Get the current (login) user id.

Line 6392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6388: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
6389:
6390: -- User is not login.
6391:
6392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6393:
6394: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6395:
6396: FND_MSG_PUB.Add;

Line 6396: FND_MSG_PUB.Add;

6392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6393:
6394: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6395:
6396: FND_MSG_PUB.Add;
6397:
6398: END IF;
6399:
6400: RAISE FND_API.G_EXC_ERROR;

Line 6548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

6544: /*
6545:
6546: -- Success message
6547:
6548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6549:
6550: THEN
6551:
6552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

Line 6556: FND_MSG_PUB.Add;

6552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
6553:
6554: FND_MESSAGE.Set_Token('ROW', l_full_name);
6555:
6556: FND_MSG_PUB.Add;
6557:
6558: END IF;
6559:
6560: */

Line 6564: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

6560: */
6561:
6562: -- Debug Message
6563:
6564: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6565:
6566: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6567:
6568: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

Line 6570: FND_MSG_PUB.Add;

6566: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6567:
6568: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
6569:
6570: FND_MSG_PUB.Add;
6571:
6572: END IF;
6573:
6574: --Standard call to get message count and if count=1, get the message

Line 6576: FND_MSG_PUB.Count_And_Get (

6572: END IF;
6573:
6574: --Standard call to get message count and if count=1, get the message
6575:
6576: FND_MSG_PUB.Count_And_Get (
6577:
6578: p_encoded => FND_API.G_FALSE,
6579:
6580: p_count => x_msg_count,

Line 6598: FND_MSG_PUB.Count_And_Get (

6594: x_return_status := FND_API.G_RET_STS_ERROR;
6595:
6596: -- Standard call to get message count and if count=1, get the message
6597:
6598: FND_MSG_PUB.Count_And_Get (
6599:
6600: p_encoded => FND_API.G_FALSE,
6601:
6602: p_count => x_msg_count,

Line 6616: FND_MSG_PUB.Count_And_Get (

6612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6613:
6614: -- Standard call to get message count and if count=1, get the message
6615:
6616: FND_MSG_PUB.Count_And_Get (
6617:
6618: p_encoded => FND_API.G_FALSE,
6619:
6620: p_count => x_msg_count,

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

6628: ROLLBACK TO Find_Repositories;
6629:
6630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6631:
6632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6633:
6634: THEN
6635:
6636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

6632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6633:
6634: THEN
6635:
6636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6637:
6638: END IF;
6639:
6640: -- Standard call to get message count and if count=1, get the message

Line 6642: FND_MSG_PUB.Count_And_Get (

6638: END IF;
6639:
6640: -- Standard call to get message count and if count=1, get the message
6641:
6642: FND_MSG_PUB.Count_And_Get (
6643:
6644: p_encoded => FND_API.G_FALSE,
6645:
6646: p_count => x_msg_count,

Line 6960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

6956: END IF;
6957:
6958: -- Debug Message
6959:
6960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6961:
6962: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6963:
6964: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

Line 6966: FND_MSG_PUB.Add;

6962: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6963:
6964: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6965:
6966: FND_MSG_PUB.Add;
6967:
6968: END IF;
6969:
6970: --Initialize message list if p_init_msg_list is TRUE.

Line 6974: FND_MSG_PUB.initialize;

6970: --Initialize message list if p_init_msg_list is TRUE.
6971:
6972: IF FND_API.To_Boolean (p_init_msg_list) THEN
6973:
6974: FND_MSG_PUB.initialize;
6975:
6976: END IF;
6977:
6978: -- Get the current (login) user id.

Line 7002: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6998: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
6999:
7000: -- User is not login.
7001:
7002: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7003:
7004: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7005:
7006: FND_MSG_PUB.Add;

Line 7006: FND_MSG_PUB.Add;

7002: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7003:
7004: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7005:
7006: FND_MSG_PUB.Add;
7007:
7008: END IF;
7009:
7010: RAISE FND_API.G_EXC_ERROR;

Line 7218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

7214: -- Success message
7215:
7216: /*
7217:
7218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7219:
7220: THEN
7221:
7222: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

Line 7226: FND_MSG_PUB.Add;

7222: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
7223:
7224: FND_MESSAGE.Set_Token('ROW', l_full_name);
7225:
7226: FND_MSG_PUB.Add;
7227:
7228: END IF;
7229:
7230: */

Line 7234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

7230: */
7231:
7232: -- Debug Message
7233:
7234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7235:
7236: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7237:
7238: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

Line 7240: FND_MSG_PUB.Add;

7236: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7237:
7238: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
7239:
7240: FND_MSG_PUB.Add;
7241:
7242: END IF;
7243:
7244: --Standard call to get message count and if count=1, get the message

Line 7246: FND_MSG_PUB.Count_And_Get (

7242: END IF;
7243:
7244: --Standard call to get message count and if count=1, get the message
7245:
7246: FND_MSG_PUB.Count_And_Get (
7247:
7248: p_encoded => FND_API.G_FALSE,
7249:
7250: p_count => x_msg_count,

Line 7268: FND_MSG_PUB.Count_And_Get (

7264: x_return_status := FND_API.G_RET_STS_ERROR;
7265:
7266: -- Standard call to get message count and if count=1, get the message
7267:
7268: FND_MSG_PUB.Count_And_Get (
7269:
7270: p_encoded => FND_API.G_FALSE,
7271:
7272: p_count => x_msg_count,

Line 7286: FND_MSG_PUB.Count_And_Get (

7282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7283:
7284: -- Standard call to get message count and if count=1, get the message
7285:
7286: FND_MSG_PUB.Count_And_Get (
7287:
7288: p_encoded => FND_API.G_FALSE,
7289:
7290: p_count => x_msg_count,

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

7298: ROLLBACK TO Find_RepositoryAreas;
7299:
7300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7301:
7302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7303:
7304: THEN
7305:
7306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

7302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7303:
7304: THEN
7305:
7306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7307:
7308: END IF;
7309:
7310: -- Standard call to get message count and if count=1, get the message

Line 7312: FND_MSG_PUB.Count_And_Get (

7308: END IF;
7309:
7310: -- Standard call to get message count and if count=1, get the message
7311:
7312: FND_MSG_PUB.Count_And_Get (
7313:
7314: p_encoded => FND_API.G_FALSE,
7315:
7316: p_count => x_msg_count,

Line 7866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

7862: END IF;
7863:
7864: -- Debug Message
7865:
7866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7867:
7868: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7869:
7870: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

Line 7872: FND_MSG_PUB.Add;

7868: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7869:
7870: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
7871:
7872: FND_MSG_PUB.Add;
7873:
7874: END IF;
7875:
7876: --Initialize message list if p_init_msg_list is TRUE.

Line 7880: FND_MSG_PUB.initialize;

7876: --Initialize message list if p_init_msg_list is TRUE.
7877:
7878: IF FND_API.To_Boolean (p_init_msg_list) THEN
7879:
7880: FND_MSG_PUB.initialize;
7881:
7882: END IF;
7883:
7884: -- Get the current (login) user id.

Line 7908: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7904: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
7905:
7906: -- User is not login.
7907:
7908: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7909:
7910: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7911:
7912: FND_MSG_PUB.Add;

Line 7912: FND_MSG_PUB.Add;

7908: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7909:
7910: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7911:
7912: FND_MSG_PUB.Add;
7913:
7914: END IF;
7915:
7916: RAISE FND_API.G_EXC_ERROR;

Line 7978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7974: IF l_imt_string is null THEN
7975:
7976: -- Must pass query string
7977:
7978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7979:
7980: FND_MESSAGE.Set_name('AMV','AMV_SRCH_QRY_STR_NULL');
7981:
7982: FND_MSG_PUB.Add;

Line 7982: FND_MSG_PUB.Add;

7978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7979:
7980: FND_MESSAGE.Set_name('AMV','AMV_SRCH_QRY_STR_NULL');
7981:
7982: FND_MSG_PUB.Add;
7983:
7984: END IF;
7985:
7986: RAISE FND_API.G_EXC_ERROR;

Line 8102: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

8098: IF l_channel_array.count = 0 AND l_category_array.count = 0 THEN
8099:
8100: -- user does not have access to any channels or categories
8101:
8102: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8103:
8104: THEN
8105:
8106: FND_MESSAGE.Set_name('AMV','AMV_CAT_USR_NOACCS');

Line 8110: FND_MSG_PUB.Add;

8106: FND_MESSAGE.Set_name('AMV','AMV_CAT_USR_NOACCS');
8107:
8108: FND_MESSAGE.Set_Token('TKN',p_user_id);
8109:
8110: FND_MSG_PUB.Add;
8111:
8112: END IF;
8113:
8114: RAISE FND_API.G_EXC_ERROR;

Line 8276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

8272: /*
8273:
8274: -- Success message
8275:
8276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8277:
8278: THEN
8279:
8280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

Line 8284: FND_MSG_PUB.Add;

8280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
8281:
8282: FND_MESSAGE.Set_Token('ROW', l_full_name);
8283:
8284: FND_MSG_PUB.Add;
8285:
8286: END IF;
8287:
8288: */

Line 8292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

8288: */
8289:
8290: -- Debug Message
8291:
8292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
8293:
8294: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
8295:
8296: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

Line 8298: FND_MSG_PUB.Add;

8294: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
8295:
8296: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
8297:
8298: FND_MSG_PUB.Add;
8299:
8300: END IF;
8301:
8302: --Standard call to get message count and if count=1, get the message

Line 8304: FND_MSG_PUB.Count_And_Get (

8300: END IF;
8301:
8302: --Standard call to get message count and if count=1, get the message
8303:
8304: FND_MSG_PUB.Count_And_Get (
8305:
8306: p_encoded => FND_API.G_FALSE,
8307:
8308: p_count => x_msg_count,

Line 8326: FND_MSG_PUB.Count_And_Get (

8322: x_return_status := FND_API.G_RET_STS_ERROR;
8323:
8324: -- Standard call to get message count and if count=1, get the message
8325:
8326: FND_MSG_PUB.Count_And_Get (
8327:
8328: p_encoded => FND_API.G_FALSE,
8329:
8330: p_count => x_msg_count,

Line 8344: FND_MSG_PUB.Count_And_Get (

8340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8341:
8342: -- Standard call to get message count and if count=1, get the message
8343:
8344: FND_MSG_PUB.Count_And_Get (
8345:
8346: p_encoded => FND_API.G_FALSE,
8347:
8348: p_count => x_msg_count,

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

8356: ROLLBACK TO Content_Search;
8357:
8358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8359:
8360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8361:
8362: THEN
8363:
8364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

8360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8361:
8362: THEN
8363:
8364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8365:
8366: END IF;
8367:
8368: -- Standard call to get message count and if count=1, get the message

Line 8370: FND_MSG_PUB.Count_And_Get (

8366: END IF;
8367:
8368: -- Standard call to get message count and if count=1, get the message
8369:
8370: FND_MSG_PUB.Count_And_Get (
8371:
8372: p_encoded => FND_API.G_FALSE,
8373:
8374: p_count => x_msg_count,