DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB_W dependencies on FND_MESSAGE

Line 9166: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 9167: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

Line 9168: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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)

Line 9169: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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

Line 9648: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 9649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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)

Line 9650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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,

Line 9651: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);

Line 11053: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 11054: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

Line 11055: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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)

Line 11056: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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

Line 12443: FND_MESSAGE.Set_Name(' + appShortName +',

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;

Line 12445: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

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;

Line 12917: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 12918: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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)

Line 12919: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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,

Line 12920: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);

Line 13273: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 13274: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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)

Line 13275: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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,

Line 13276: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);