DBA Data[Home] [Help]

APPS.IBE_ADDRESS_V2PVT dependencies on FND_MESSAGE

Line 2345: FND_MESSAGE.Set_Name('IBE', 'IBE_OU_GET_PSITE_COUNTRY_FAIL');

2341: OPEN c1(p_party_site_id);
2342: FETCH c1 INTO l_psite_terr_code;
2343: IF (c1%NOTFOUND) THEN
2344: CLOSE c1;
2345: FND_MESSAGE.Set_Name('IBE', 'IBE_OU_GET_PSITE_COUNTRY_FAIL');
2346: FND_MESSAGE.Set_Token('PARTY_SITE_ID', p_party_site_id);
2347: FND_MSG_PUB.Add;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;

Line 2346: FND_MESSAGE.Set_Token('PARTY_SITE_ID', p_party_site_id);

2342: FETCH c1 INTO l_psite_terr_code;
2343: IF (c1%NOTFOUND) THEN
2344: CLOSE c1;
2345: FND_MESSAGE.Set_Name('IBE', 'IBE_OU_GET_PSITE_COUNTRY_FAIL');
2346: FND_MESSAGE.Set_Token('PARTY_SITE_ID', p_party_site_id);
2347: FND_MSG_PUB.Add;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: CLOSE c1;

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

2434: p_data => x_msg_data,
2435: p_encoded => 'F');
2436:
2437: WHEN OTHERS THEN
2438: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2439: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2440: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;

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

2435: p_encoded => 'F');
2436:
2437: WHEN OTHERS THEN
2438: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2439: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2440: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2436:
2437: WHEN OTHERS THEN
2438: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2439: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2440: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:

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

2437: WHEN OTHERS THEN
2438: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2439: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2440: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)