9162: END IF;
9163: WHEN OTHERS THEN
9164: ROLLBACK TO Copy_Quote_Pvt;
9165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
9163: WHEN OTHERS THEN
9164: ROLLBACK TO Copy_Quote_Pvt;
9165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
9164: ROLLBACK TO Copy_Quote_Pvt;
9165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)
9165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
9644: WHEN OTHERS
9645: THEN
9646: ROLLBACK TO Copy_Quote_Pvt;
9647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
9645: THEN
9646: ROLLBACK TO Copy_Quote_Pvt;
9647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)
9646: ROLLBACK TO Copy_Quote_Pvt;
9647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
9647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);
11049: ASO_QUOTE_UTIL_PVT.disable_debug_pvt;
11050: END IF;
11051: WHEN OTHERS THEN
11052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
11050: END IF;
11051: WHEN OTHERS THEN
11052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
11051: WHEN OTHERS THEN
11052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)
11052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
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;
12447: END IF;
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;
12447: END IF;
12448: RAISE FND_API.G_EXC_ERROR;
12449: END IF;
12913: WHEN OTHERS
12914: THEN
12915: ROLLBACK TO Submit_Price_Tax_Pvt;
12916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
12914: THEN
12915: ROLLBACK TO Submit_Price_Tax_Pvt;
12916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)
12915: ROLLBACK TO Submit_Price_Tax_Pvt;
12916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
12916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);
13269: WHEN OTHERS
13270: THEN
13271: ROLLBACK TO Cancel_Price_Tax_Pvt;
13272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
13270: THEN
13271: ROLLBACK TO Cancel_Price_Tax_Pvt;
13272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)
13271: ROLLBACK TO Cancel_Price_Tax_Pvt;
13272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,
13272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);