DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB_W dependencies on FND_MSG_PUB

Line 9065: FND_MSG_PUB.initialize;

9061: END IF;
9062:
9063: -- initialize message list if p_init_msg_list is set to TRUE
9064: IF FND_API.to_Boolean(p_init_msg_list) THEN
9065: FND_MSG_PUB.initialize;
9066: END IF;
9067:
9068: -- initialize API return status to success
9069: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9130: FND_MSG_PUB.Count_And_Get

9126: IF l_debug = 'Y' THEN
9127: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.copy_quote(+)');
9128: END IF;
9129: -- standard call to get message count and if count is 1, get message info.
9130: FND_MSG_PUB.Count_And_Get
9131: ( p_encoded => FND_API.G_FALSE,
9132: p_count => x_msg_count,
9133: p_data => x_msg_data
9134: );

Line 9144: FND_MSG_PUB.Count_And_Get

9140: EXCEPTION
9141: WHEN FND_API.G_EXC_ERROR THEN
9142: ROLLBACK TO Copy_Quote_Pvt;
9143: x_return_status := FND_API.G_RET_STS_ERROR;
9144: FND_MSG_PUB.Count_And_Get
9145: ( p_encoded => FND_API.G_FALSE,
9146: p_count => x_msg_count,
9147: p_data => x_msg_data
9148: );

Line 9155: FND_MSG_PUB.Count_And_Get

9151: END IF;
9152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9153: ROLLBACK TO Copy_Quote_Pvt;
9154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9155: FND_MSG_PUB.Count_And_Get
9156: ( p_encoded => FND_API.G_FALSE,
9157: p_count => x_msg_count,
9158: p_data => x_msg_data
9159: );

Line 9170: FND_MSG_PUB.Add;

9166: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
9167: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
9168: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9169: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9170: FND_MSG_PUB.Add;
9171: IF FND_MSG_PUB.Check_Msg_Level
9172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9173: THEN FND_MSG_PUB.Add_Exc_Msg
9174: (G_PKG_NAME,

Line 9171: IF FND_MSG_PUB.Check_Msg_Level

9167: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
9168: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9169: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9170: FND_MSG_PUB.Add;
9171: IF FND_MSG_PUB.Check_Msg_Level
9172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9173: THEN FND_MSG_PUB.Add_Exc_Msg
9174: (G_PKG_NAME,
9175: l_api_name

Line 9172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9168: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9169: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9170: FND_MSG_PUB.Add;
9171: IF FND_MSG_PUB.Check_Msg_Level
9172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9173: THEN FND_MSG_PUB.Add_Exc_Msg
9174: (G_PKG_NAME,
9175: l_api_name
9176: );

Line 9173: THEN FND_MSG_PUB.Add_Exc_Msg

9169: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9170: FND_MSG_PUB.Add;
9171: IF FND_MSG_PUB.Check_Msg_Level
9172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9173: THEN FND_MSG_PUB.Add_Exc_Msg
9174: (G_PKG_NAME,
9175: l_api_name
9176: );
9177: END IF;

Line 9178: FND_MSG_PUB.Count_And_Get

9174: (G_PKG_NAME,
9175: l_api_name
9176: );
9177: END IF;
9178: FND_MSG_PUB.Count_And_Get
9179: ( p_encoded => FND_API.G_FALSE,
9180: p_count => x_msg_count,
9181: p_data => x_msg_data
9182: );

Line 9396: FND_MSG_PUB.initialize;

9392:
9393: -- initialize message list if p_init_msg_list is set to TRUE
9394: IF FND_API.to_Boolean(p_init_msg_list)
9395: THEN
9396: FND_MSG_PUB.initialize;
9397: END IF;
9398:
9399: -- begin API body
9400: IF l_debug = 'Y' THEN

Line 9604: FND_MSG_PUB.Count_And_Get(

9600: COMMIT WORK;
9601: END IF;
9602:
9603: -- standard call to get message count and if count is 1, get the message info
9604: FND_MSG_PUB.Count_And_Get(
9605: p_encoded => FND_API.G_FALSE,
9606: p_count => x_msg_count,
9607: p_data => x_msg_data);
9608:

Line 9624: FND_MSG_PUB.Count_And_Get(

9620: WHEN FND_API.G_EXC_ERROR
9621: THEN
9622: ROLLBACK TO Copy_Quote_Line_Pvt;
9623: x_return_status := FND_API.G_RET_STS_ERROR;
9624: FND_MSG_PUB.Count_And_Get(
9625: p_encoded => FND_API.G_FALSE,
9626: p_count => x_msg_count,
9627: p_data => x_msg_data);
9628: IF l_debug = 'Y' THEN

Line 9636: FND_MSG_PUB.Count_And_Get(

9632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
9633: THEN
9634: ROLLBACK TO Copy_Quote_Line_Pvt;
9635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9636: FND_MSG_PUB.Count_And_Get(
9637: p_encoded => FND_API.G_FALSE,
9638: p_count => x_msg_count,
9639: p_data => x_msg_data);
9640: IF l_debug = 'Y' THEN

Line 9652: FND_MSG_PUB.Add;

9648: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
9649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
9650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9652: FND_MSG_PUB.Add;
9653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
9654: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
9655: l_api_name);
9656: END IF;

Line 9653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)

9649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
9650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9652: FND_MSG_PUB.Add;
9653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
9654: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
9655: l_api_name);
9656: END IF;
9657: FND_MSG_PUB.Count_And_Get(

Line 9654: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

9650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
9651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
9652: FND_MSG_PUB.Add;
9653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
9654: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
9655: l_api_name);
9656: END IF;
9657: FND_MSG_PUB.Count_And_Get(
9658: p_encoded => FND_API.G_FALSE,

Line 9657: FND_MSG_PUB.Count_And_Get(

9653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
9654: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
9655: l_api_name);
9656: END IF;
9657: FND_MSG_PUB.Count_And_Get(
9658: p_encoded => FND_API.G_FALSE,
9659: p_count => x_msg_count,
9660: p_data => x_msg_data);
9661: IF l_debug = 'Y' THEN

Line 10776: FND_MSG_PUB.initialize;

10772: END IF;
10773:
10774: -- Initialize message list if p_init_msg_list is set to TRUE.
10775: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10776: FND_MSG_PUB.initialize;
10777: END IF;
10778:
10779: -- Initialize API rturn status to success
10780: x_return_status := FND_API.g_ret_sts_success;

Line 10817: FND_MSG_PUB.Count_And_Get

10813:
10814: IF FND_API.To_Boolean( p_commit ) THEN
10815: COMMIT WORK;
10816: END IF;
10817: FND_MSG_PUB.Count_And_Get
10818: (p_encoded => FND_API.G_FALSE,
10819: p_count => x_msg_count,
10820: p_data => x_msg_data);
10821: IF l_debug = 'Y' THEN

Line 10828: FND_MSG_PUB.Count_And_Get

10824: EXCEPTION
10825: WHEN FND_API.G_EXC_ERROR THEN
10826: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10827: x_return_status := FND_API.G_RET_STS_ERROR ;
10828: FND_MSG_PUB.Count_And_Get
10829: (p_encoded => FND_API.G_FALSE,
10830: p_count => x_msg_count,
10831: p_data => x_msg_data);
10832: IF l_debug = 'Y' THEN

Line 10838: FND_MSG_PUB.Count_And_Get

10834: END IF;
10835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10836: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10838: FND_MSG_PUB.Count_And_Get
10839: (p_encoded => FND_API.G_FALSE,
10840: p_count => x_msg_count,
10841: p_data => x_msg_data);
10842: IF l_debug = 'Y' THEN

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

10844: END IF;
10845: WHEN OTHERS THEN
10846: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10849: FND_MSG_PUB.Add_Exc_Msg
10850: (G_PKG_NAME,
10851: l_api_name);
10852: END IF;

Line 10849: FND_MSG_PUB.Add_Exc_Msg

10845: WHEN OTHERS THEN
10846: ROLLBACK TO Get_Config_Launch_Info_Pvt;
10847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10849: FND_MSG_PUB.Add_Exc_Msg
10850: (G_PKG_NAME,
10851: l_api_name);
10852: END IF;
10853: FND_MSG_PUB.Count_And_Get

Line 10853: FND_MSG_PUB.Count_And_Get

10849: FND_MSG_PUB.Add_Exc_Msg
10850: (G_PKG_NAME,
10851: l_api_name);
10852: END IF;
10853: FND_MSG_PUB.Count_And_Get
10854: (p_encoded => FND_API.G_FALSE,
10855: p_count => x_msg_count,
10856: p_data => x_msg_data);
10857: IF l_debug = 'Y' THEN

Line 10891: FND_MSG_PUB.initialize;

10887: END IF;
10888:
10889: -- Initialize message list if p_init_msg_list is set to TRUE.
10890: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10891: FND_MSG_PUB.initialize;
10892: END IF;
10893:
10894: -- Initialize API rturn status to success
10895: x_return_status := FND_API.g_ret_sts_success;

Line 10910: FND_MSG_PUB.Count_And_Get

10906: IF l_debug = 'Y'
10907: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_COPY_QUOTE_PVT.Get_Quote_Exp_Date');
10908: END IF;
10909:
10910: FND_MSG_PUB.Count_And_Get
10911: (p_encoded => FND_API.G_FALSE,
10912: p_count => x_msg_count,
10913: p_data => x_msg_data);
10914: IF l_debug = 'Y' THEN

Line 10920: FND_MSG_PUB.Count_And_Get

10916: END IF;
10917: EXCEPTION
10918: WHEN FND_API.G_EXC_ERROR THEN
10919: x_return_status := FND_API.G_RET_STS_ERROR ;
10920: FND_MSG_PUB.Count_And_Get
10921: (p_encoded => FND_API.G_FALSE,
10922: p_count => x_msg_count,
10923: p_data => x_msg_data);
10924: IF l_debug = 'Y' THEN

Line 10929: FND_MSG_PUB.Count_And_Get

10925: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10926: END IF;
10927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10929: FND_MSG_PUB.Count_And_Get
10930: (p_encoded => FND_API.G_FALSE,
10931: p_count => x_msg_count,
10932: p_data => x_msg_data);
10933: IF l_debug = 'Y' THEN

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

10934: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;
10935: END IF;
10936: WHEN OTHERS THEN
10937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10939: FND_MSG_PUB.Add_Exc_Msg
10940: (G_PKG_NAME,
10941: l_api_name);
10942: END IF;

Line 10939: FND_MSG_PUB.Add_Exc_Msg

10935: END IF;
10936: WHEN OTHERS THEN
10937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10939: FND_MSG_PUB.Add_Exc_Msg
10940: (G_PKG_NAME,
10941: l_api_name);
10942: END IF;
10943: FND_MSG_PUB.Count_And_Get

Line 10943: FND_MSG_PUB.Count_And_Get

10939: FND_MSG_PUB.Add_Exc_Msg
10940: (G_PKG_NAME,
10941: l_api_name);
10942: END IF;
10943: FND_MSG_PUB.Count_And_Get
10944: (p_encoded => FND_API.G_FALSE,
10945: p_count => x_msg_count,
10946: p_data => x_msg_data);
10947: IF l_debug = 'Y' THEN

Line 10989: FND_MSG_PUB.initialize;

10985: END IF;
10986:
10987: -- initialize message list if p_init_msg_list is set to TRUE
10988: IF FND_API.to_Boolean(p_init_msg_list) THEN
10989: FND_MSG_PUB.initialize;
10990: END IF;
10991:
10992: -- initialize API return status to success
10993: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11021: FND_MSG_PUB.Count_And_Get

11017: ASO_QUOTE_UTIL_PVT.debug('ASO_QUOTE_PUB_W.validate_quantity(-)');
11018: END IF;
11019:
11020: -- standard call to get message count and if count is 1, get message info.
11021: FND_MSG_PUB.Count_And_Get
11022: ( p_encoded => FND_API.G_FALSE,
11023: p_count => x_msg_count,
11024: p_data => x_msg_data
11025: );

Line 11033: FND_MSG_PUB.Count_And_Get

11029:
11030: EXCEPTION
11031: WHEN FND_API.G_EXC_ERROR THEN
11032: x_return_status := FND_API.G_RET_STS_ERROR;
11033: FND_MSG_PUB.Count_And_Get
11034: ( p_encoded => FND_API.G_FALSE,
11035: p_count => x_msg_count,
11036: p_data => x_msg_data
11037: );

Line 11043: FND_MSG_PUB.Count_And_Get

11039: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11040: END IF;
11041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11043: FND_MSG_PUB.Count_And_Get
11044: ( p_encoded => FND_API.G_FALSE,
11045: p_count => x_msg_count,
11046: p_data => x_msg_data
11047: );

Line 11057: FND_MSG_PUB.Add;

11053: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
11054: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
11055: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
11056: FND_MESSAGE.Set_Token('REASON', SQLERRM);
11057: FND_MSG_PUB.Add;
11058: IF FND_MSG_PUB.Check_Msg_Level
11059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11060: THEN FND_MSG_PUB.Add_Exc_Msg
11061: (G_PKG_NAME,

Line 11058: IF FND_MSG_PUB.Check_Msg_Level

11054: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
11055: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
11056: FND_MESSAGE.Set_Token('REASON', SQLERRM);
11057: FND_MSG_PUB.Add;
11058: IF FND_MSG_PUB.Check_Msg_Level
11059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11060: THEN FND_MSG_PUB.Add_Exc_Msg
11061: (G_PKG_NAME,
11062: l_api_name

Line 11059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11055: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
11056: FND_MESSAGE.Set_Token('REASON', SQLERRM);
11057: FND_MSG_PUB.Add;
11058: IF FND_MSG_PUB.Check_Msg_Level
11059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11060: THEN FND_MSG_PUB.Add_Exc_Msg
11061: (G_PKG_NAME,
11062: l_api_name
11063: );

Line 11060: THEN FND_MSG_PUB.Add_Exc_Msg

11056: FND_MESSAGE.Set_Token('REASON', SQLERRM);
11057: FND_MSG_PUB.Add;
11058: IF FND_MSG_PUB.Check_Msg_Level
11059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11060: THEN FND_MSG_PUB.Add_Exc_Msg
11061: (G_PKG_NAME,
11062: l_api_name
11063: );
11064: END IF;

Line 11065: FND_MSG_PUB.Count_And_Get

11061: (G_PKG_NAME,
11062: l_api_name
11063: );
11064: END IF;
11065: FND_MSG_PUB.Count_And_Get
11066: ( p_encoded => FND_API.G_FALSE,
11067: p_count => x_msg_count,
11068: p_data => x_msg_data
11069: );

Line 11442: FND_MSG_PUB.Initialize;

11438:
11439: -- Initialize message list if p_init_msg_list is set to FND_API.G_TRUE
11440: IF FND_API.To_Boolean(p_init_msg_list)
11441: THEN
11442: FND_MSG_PUB.Initialize;
11443: END IF;
11444:
11445: -- Initialize API return status to SUCCESS
11446: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11553: FND_MSG_PUB.Count_And_Get(

11549:
11550: WHEN FND_API.G_EXC_ERROR
11551: THEN
11552: x_return_status := FND_API.G_RET_STS_ERROR;
11553: FND_MSG_PUB.Count_And_Get(
11554: p_encoded => FND_API.G_FALSE,
11555: p_count => x_msg_count,
11556: p_data => x_msg_data
11557: );

Line 11565: FND_MSG_PUB.Count_And_Get(

11561:
11562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
11563: THEN
11564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11565: FND_MSG_PUB.Count_And_Get(
11566: p_encoded => FND_API.G_FALSE,
11567: p_count => x_msg_count,
11568: p_data => x_msg_data
11569: );

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

11572: END IF;
11573:
11574: WHEN OTHERS THEN
11575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11577: THEN
11578: FND_MSG_PUB.Add_Exc_Msg(
11579: G_PKG_NAME,
11580: l_api_name

Line 11578: FND_MSG_PUB.Add_Exc_Msg(

11574: WHEN OTHERS THEN
11575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11577: THEN
11578: FND_MSG_PUB.Add_Exc_Msg(
11579: G_PKG_NAME,
11580: l_api_name
11581: );
11582: END IF;

Line 11583: FND_MSG_PUB.Count_And_Get(

11579: G_PKG_NAME,
11580: l_api_name
11581: );
11582: END IF;
11583: FND_MSG_PUB.Count_And_Get(
11584: p_encoded => FND_API.G_FALSE,
11585: p_count => x_msg_count,
11586: p_data => x_msg_data);
11587: IF l_debug = 'Y' THEN

Line 12319: FND_MSG_PUB.Count_And_Get(

12315: EXCEPTION
12316: WHEN FND_API.G_EXC_ERROR
12317: THEN
12318: x_return_status := FND_API.G_RET_STS_ERROR;
12319: FND_MSG_PUB.Count_And_Get(
12320: p_encoded => FND_API.G_FALSE,
12321: p_count => x_msg_count,
12322: p_data => x_msg_data
12323: );

Line 12331: FND_MSG_PUB.Count_And_Get(

12327:
12328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
12329: THEN
12330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12331: FND_MSG_PUB.Count_And_Get(
12332: p_encoded => FND_API.G_FALSE,
12333: p_count => x_msg_count,
12334: p_data => x_msg_data
12335: );

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

12338: END IF;
12339:
12340: WHEN OTHERS THEN
12341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12343: THEN
12344: FND_MSG_PUB.Add_Exc_Msg(
12345: G_PKG_NAME,
12346: l_api_name

Line 12344: FND_MSG_PUB.Add_Exc_Msg(

12340: WHEN OTHERS THEN
12341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12343: THEN
12344: FND_MSG_PUB.Add_Exc_Msg(
12345: G_PKG_NAME,
12346: l_api_name
12347: );
12348: END IF;

Line 12349: FND_MSG_PUB.Count_And_Get(

12345: G_PKG_NAME,
12346: l_api_name
12347: );
12348: END IF;
12349: FND_MSG_PUB.Count_And_Get(
12350: p_encoded => FND_API.G_FALSE,
12351: p_count => x_msg_count,
12352: p_data => x_msg_data
12353: );

Line 12426: FND_MSG_PUB.initialize;

12422: END IF;
12423:
12424: -- Initialize message list if p_init_msg_list is set to TRUE.
12425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12426: FND_MSG_PUB.initialize;
12427: END IF;
12428:
12429: -- Debug Message
12430: IF l_debug = 'Y' THEN

Line 12431: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

12427: END IF;
12428:
12429: -- Debug Message
12430: IF l_debug = 'Y' THEN
12431: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
12432: 'Private API: ' || l_api_name || 'start');
12433: END IF;
12434:
12435: -- Initialize API return status to SUCCESS

Line 12442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN

12438: -- ******************************************************************
12439: -- Validate Environment
12440: -- ******************************************************************
12441: IF FND_GLOBAL.User_Id IS NULL THEN
12442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
12443: FND_MESSAGE.Set_Name(' + appShortName +',
12444: 'UT_CANNOT_GET_PROFILE_VALUE');
12445: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12446: FND_MSG_PUB.ADD;

Line 12446: FND_MSG_PUB.ADD;

12442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
12443: FND_MESSAGE.Set_Name(' + appShortName +',
12444: 'UT_CANNOT_GET_PROFILE_VALUE');
12445: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12446: FND_MSG_PUB.ADD;
12447: END IF;
12448: RAISE FND_API.G_EXC_ERROR;
12449: END IF;
12450:

Line 12484: FND_MSG_PUB.Count_And_Get

12480: l_party_site_id :=NULL;
12481: END LOOP;
12482:
12483: -- Standard call to get message count and if count is 1, get message info.
12484: FND_MSG_PUB.Count_And_Get
12485: ( p_count => x_msg_count,
12486: p_data => x_msg_data
12487: );
12488: --disable the debug message

Line 12497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

12493: WHEN FND_API.G_EXC_ERROR THEN
12494: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12495: P_API_NAME => L_API_NAME
12496: ,P_PKG_NAME => G_PKG_NAME
12497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12498: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
12499: ,X_MSG_COUNT => X_MSG_COUNT
12500: ,X_MSG_DATA => X_MSG_DATA
12501: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12506: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12507: P_API_NAME => L_API_NAME
12508: ,P_PKG_NAME => G_PKG_NAME
12509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12510: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
12511: ,X_MSG_COUNT => X_MSG_COUNT
12512: ,X_MSG_DATA => X_MSG_DATA
12513: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12877: FND_MSG_PUB.Count_And_Get(

12873: THEN ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CONC_REQ_INT.Submit_Price_Tax_Req');
12874: END IF;
12875:
12876: -- standard call to get message count and if count is 1, get the message info
12877: FND_MSG_PUB.Count_And_Get(
12878: p_encoded => FND_API.G_FALSE,
12879: p_count => x_msg_count,
12880: p_data => x_msg_data);
12881:

Line 12897: FND_MSG_PUB.Count_And_Get(

12893: WHEN FND_API.G_EXC_ERROR
12894: THEN
12895: ROLLBACK TO Submit_Price_Tax_Pvt;
12896: x_return_status := FND_API.G_RET_STS_ERROR;
12897: FND_MSG_PUB.Count_And_Get(
12898: p_encoded => FND_API.G_FALSE,
12899: p_count => x_msg_count,
12900: p_data => x_msg_data);
12901: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 12907: FND_MSG_PUB.Count_And_Get(

12903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
12904: THEN
12905: ROLLBACK TO Submit_Price_Tax_Pvt;
12906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12907: FND_MSG_PUB.Count_And_Get(
12908: p_encoded => FND_API.G_FALSE,
12909: p_count => x_msg_count,
12910: p_data => x_msg_data);
12911: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 12921: FND_MSG_PUB.Add;

12917: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
12918: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
12919: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
12920: FND_MESSAGE.Set_Token('REASON', SQLERRM);
12921: FND_MSG_PUB.Add;
12922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
12923: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
12924: l_api_name);
12925: END IF;

Line 12922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)

12918: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
12919: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
12920: FND_MESSAGE.Set_Token('REASON', SQLERRM);
12921: FND_MSG_PUB.Add;
12922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
12923: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
12924: l_api_name);
12925: END IF;
12926: FND_MSG_PUB.Count_And_Get(

Line 12923: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

12919: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
12920: FND_MESSAGE.Set_Token('REASON', SQLERRM);
12921: FND_MSG_PUB.Add;
12922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
12923: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
12924: l_api_name);
12925: END IF;
12926: FND_MSG_PUB.Count_And_Get(
12927: p_encoded => FND_API.G_FALSE,

Line 12926: FND_MSG_PUB.Count_And_Get(

12922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
12923: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
12924: l_api_name);
12925: END IF;
12926: FND_MSG_PUB.Count_And_Get(
12927: p_encoded => FND_API.G_FALSE,
12928: p_count => x_msg_count,
12929: p_data => x_msg_data);
12930: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 13234: FND_MSG_PUB.Count_And_Get(

13230: ASO_QUOTE_UTIL_PVT.Debug('Returning from ASO_CONC_REQ_INT.Cancel_Price_Tax_Req');
13231: END IF;
13232:
13233: -- standard call to get message count and if count is 1, get the message info
13234: FND_MSG_PUB.Count_And_Get(
13235: p_encoded => FND_API.G_FALSE,
13236: p_count => x_msg_count,
13237: p_data => x_msg_data);
13238:

Line 13253: FND_MSG_PUB.Count_And_Get(

13249: WHEN FND_API.G_EXC_ERROR
13250: THEN
13251: ROLLBACK TO Cancel_Price_Tax_Pvt;
13252: x_return_status := FND_API.G_RET_STS_ERROR;
13253: FND_MSG_PUB.Count_And_Get(
13254: p_encoded => FND_API.G_FALSE,
13255: p_count => x_msg_count,
13256: p_data => x_msg_data);
13257: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 13263: FND_MSG_PUB.Count_And_Get(

13259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
13260: THEN
13261: ROLLBACK TO Cancel_Price_Tax_Pvt;
13262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13263: FND_MSG_PUB.Count_And_Get(
13264: p_encoded => FND_API.G_FALSE,
13265: p_count => x_msg_count,
13266: p_data => x_msg_data);
13267: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 13277: FND_MSG_PUB.Add;

13273: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
13274: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
13275: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
13276: FND_MESSAGE.Set_Token('REASON', SQLERRM);
13277: FND_MSG_PUB.Add;
13278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
13279: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
13280: l_api_name);
13281: END IF;

Line 13278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)

13274: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
13275: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
13276: FND_MESSAGE.Set_Token('REASON', SQLERRM);
13277: FND_MSG_PUB.Add;
13278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
13279: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
13280: l_api_name);
13281: END IF;
13282: FND_MSG_PUB.Count_And_Get(

Line 13279: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

13275: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
13276: FND_MESSAGE.Set_Token('REASON', SQLERRM);
13277: FND_MSG_PUB.Add;
13278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
13279: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
13280: l_api_name);
13281: END IF;
13282: FND_MSG_PUB.Count_And_Get(
13283: p_encoded => FND_API.G_FALSE,

Line 13282: FND_MSG_PUB.Count_And_Get(

13278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_Msg_Lvl_Unexp_Error)
13279: THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
13280: l_api_name);
13281: END IF;
13282: FND_MSG_PUB.Count_And_Get(
13283: p_encoded => FND_API.G_FALSE,
13284: p_count => x_msg_count,
13285: p_data => x_msg_data);
13286: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 14853: FND_MSG_PUB.Count_And_Get(

14849: CLOSE C_Ttl_Hdr_Manu_Prc_Adj_Op;
14850: END IF;
14851:
14852: -- standard call to get message count and if count is 1, get the message info
14853: FND_MSG_PUB.Count_And_Get(
14854: p_encoded => FND_API.G_FALSE,
14855: p_count => x_msg_count,
14856: p_data => x_msg_data);
14857:

Line 15177: FND_MSG_PUB.Count_And_Get

15173: X_Msg_Count => x_msg_count,
15174: X_Msg_Data => x_msg_data
15175: );
15176:
15177: FND_MSG_PUB.Count_And_Get
15178: ( p_encoded => FND_API.G_FALSE,
15179: p_count => x_msg_count,
15180: p_data => x_msg_data
15181: );

Line 15204: FND_MSG_PUB.Count_And_Get(

15200: EXCEPTION
15201: WHEN FND_API.G_EXC_ERROR
15202: THEN
15203: x_return_status := FND_API.G_RET_STS_ERROR;
15204: FND_MSG_PUB.Count_And_Get(
15205: p_encoded => FND_API.G_FALSE,
15206: p_count => x_msg_count,
15207: p_data => x_msg_data
15208: );

Line 15216: FND_MSG_PUB.Count_And_Get(

15212:
15213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15214: THEN
15215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15216: FND_MSG_PUB.Count_And_Get(
15217: p_encoded => FND_API.G_FALSE,
15218: p_count => x_msg_count,
15219: p_data => x_msg_data
15220: );

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

15223: END IF;
15224:
15225: WHEN OTHERS THEN
15226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15227: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15228: THEN
15229: FND_MSG_PUB.Add_Exc_Msg(
15230: G_PKG_NAME,
15231: l_api_name

Line 15229: FND_MSG_PUB.Add_Exc_Msg(

15225: WHEN OTHERS THEN
15226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15227: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15228: THEN
15229: FND_MSG_PUB.Add_Exc_Msg(
15230: G_PKG_NAME,
15231: l_api_name
15232: );
15233: END IF;

Line 15234: FND_MSG_PUB.Count_And_Get(

15230: G_PKG_NAME,
15231: l_api_name
15232: );
15233: END IF;
15234: FND_MSG_PUB.Count_And_Get(
15235: p_encoded => FND_API.G_FALSE,
15236: p_count => x_msg_count,
15237: p_data => x_msg_data
15238: );

Line 15547: FND_MSG_PUB.Count_And_Get

15543: X_Msg_Data => x_msg_data
15544: );
15545:
15546:
15547: FND_MSG_PUB.Count_And_Get
15548: ( p_encoded => FND_API.G_FALSE,
15549: p_count => x_msg_count,
15550: p_data => x_msg_data
15551: );

Line 15574: FND_MSG_PUB.Count_And_Get(

15570: EXCEPTION
15571: WHEN FND_API.G_EXC_ERROR
15572: THEN
15573: x_return_status := FND_API.G_RET_STS_ERROR;
15574: FND_MSG_PUB.Count_And_Get(
15575: p_encoded => FND_API.G_FALSE,
15576: p_count => x_msg_count,
15577: p_data => x_msg_data
15578: );

Line 15586: FND_MSG_PUB.Count_And_Get(

15582:
15583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15584: THEN
15585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15586: FND_MSG_PUB.Count_And_Get(
15587: p_encoded => FND_API.G_FALSE,
15588: p_count => x_msg_count,
15589: p_data => x_msg_data
15590: );

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

15593: END IF;
15594:
15595: WHEN OTHERS THEN
15596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15598: THEN
15599: FND_MSG_PUB.Add_Exc_Msg(
15600: G_PKG_NAME,
15601: l_api_name

Line 15599: FND_MSG_PUB.Add_Exc_Msg(

15595: WHEN OTHERS THEN
15596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15598: THEN
15599: FND_MSG_PUB.Add_Exc_Msg(
15600: G_PKG_NAME,
15601: l_api_name
15602: );
15603: END IF;

Line 15604: FND_MSG_PUB.Count_And_Get(

15600: G_PKG_NAME,
15601: l_api_name
15602: );
15603: END IF;
15604: FND_MSG_PUB.Count_And_Get(
15605: p_encoded => FND_API.G_FALSE,
15606: p_count => x_msg_count,
15607: p_data => x_msg_data
15608: );

Line 15913: FND_MSG_PUB.Count_And_Get

15909: X_Msg_Data => x_msg_data
15910: );
15911:
15912:
15913: FND_MSG_PUB.Count_And_Get
15914: ( p_encoded => FND_API.G_FALSE,
15915: p_count => x_msg_count,
15916: p_data => x_msg_data
15917: );

Line 15936: FND_MSG_PUB.Count_And_Get(

15932: EXCEPTION
15933: WHEN FND_API.G_EXC_ERROR
15934: THEN
15935: x_return_status := FND_API.G_RET_STS_ERROR;
15936: FND_MSG_PUB.Count_And_Get(
15937: p_encoded => FND_API.G_FALSE,
15938: p_count => x_msg_count,
15939: p_data => x_msg_data
15940: );

Line 15948: FND_MSG_PUB.Count_And_Get(

15944:
15945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
15946: THEN
15947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15948: FND_MSG_PUB.Count_And_Get(
15949: p_encoded => FND_API.G_FALSE,
15950: p_count => x_msg_count,
15951: p_data => x_msg_data
15952: );

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

15955: END IF;
15956:
15957: WHEN OTHERS THEN
15958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15959: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15960: THEN
15961: FND_MSG_PUB.Add_Exc_Msg(
15962: G_PKG_NAME,
15963: l_api_name

Line 15961: FND_MSG_PUB.Add_Exc_Msg(

15957: WHEN OTHERS THEN
15958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15959: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15960: THEN
15961: FND_MSG_PUB.Add_Exc_Msg(
15962: G_PKG_NAME,
15963: l_api_name
15964: );
15965: END IF;

Line 15966: FND_MSG_PUB.Count_And_Get(

15962: G_PKG_NAME,
15963: l_api_name
15964: );
15965: END IF;
15966: FND_MSG_PUB.Count_And_Get(
15967: p_encoded => FND_API.G_FALSE,
15968: p_count => x_msg_count,
15969: p_data => x_msg_data
15970: );

Line 16033: FND_MSG_PUB.Count_And_Get

16029: x_msg_count => x_msg_count,
16030: p_qa_terms_only => 'Y'
16031: );
16032:
16033: FND_MSG_PUB.Count_And_Get
16034: (
16035: p_encoded => FND_API.G_FALSE,
16036: p_count => x_msg_count,
16037: p_data => x_msg_data

Line 16125: FND_MSG_PUB.Count_And_Get(

16121: EXCEPTION
16122: WHEN FND_API.G_EXC_ERROR
16123: THEN
16124: x_return_status := FND_API.G_RET_STS_ERROR;
16125: FND_MSG_PUB.Count_And_Get(
16126: p_encoded => FND_API.G_FALSE,
16127: p_count => x_msg_count,
16128: p_data => x_msg_data
16129: );

Line 16137: FND_MSG_PUB.Count_And_Get(

16133:
16134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
16135: THEN
16136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16137: FND_MSG_PUB.Count_And_Get(
16138: p_encoded => FND_API.G_FALSE,
16139: p_count => x_msg_count,
16140: p_data => x_msg_data
16141: );

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

16144: END IF;
16145:
16146: WHEN OTHERS THEN
16147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16148: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16149: THEN
16150: FND_MSG_PUB.Add_Exc_Msg(
16151: G_PKG_NAME,
16152: l_api_name

Line 16150: FND_MSG_PUB.Add_Exc_Msg(

16146: WHEN OTHERS THEN
16147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16148: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16149: THEN
16150: FND_MSG_PUB.Add_Exc_Msg(
16151: G_PKG_NAME,
16152: l_api_name
16153: );
16154: END IF;

Line 16155: FND_MSG_PUB.Count_And_Get(

16151: G_PKG_NAME,
16152: l_api_name
16153: );
16154: END IF;
16155: FND_MSG_PUB.Count_And_Get(
16156: p_encoded => FND_API.G_FALSE,
16157: p_count => x_msg_count,
16158: p_data => x_msg_data
16159: );