APPS.XLE_UPGRADE_UTILS dependencies on FND_API

Line 84: RAISE FND_API.G_EXC_ERROR;

80:
81: OPEN check_org_id(p_org_Id);
82: FETCH check_org_id into l_org_id;
83: IF check_org_id%NOTFOUND THEN
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: CLOSE check_org_Id;
87:
88: --Get set_of_books_id from hr_operating_units

Line 93: RAISE FND_API.G_EXC_ERROR;

89:
90: OPEN get_sob_id(p_org_id);
91: FETCH get_sob_id into l_sob_id;
92: IF get_sob_id%NOTFOUND THEN
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95: CLOSE get_sob_id;
96:
97:

Line 104: RAISE FND_API.G_EXC_ERROR;

100:
101: OPEN acct_env_type(l_sob_id);
102: FETCH acct_env_type into l_acct_env_type;
103: IF acct_env_type%NOTFOUND THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: CLOSE acct_env_type;
107:
108:

Line 114: RAISE FND_API.G_EXC_ERROR;

110:
111: OPEN def_legal_context(l_sob_id);
112: fetch def_legal_context into l_def_legal_context;
113: IF def_legal_context%NOTFOUND THEN
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: x_dlc:=l_def_legal_context;
117: CLOSE def_legal_context;
118:

Line 136: --RAISE FND_API.G_EXC_ERROR;

132: OPEN check_le_mapped(p_org_id);
133: fetch check_le_mapped into l_le_mapped;
134: IF check_le_mapped%NOTFOUND THEN
135: l_le_mapped := NULL;
136: --RAISE FND_API.G_EXC_ERROR;
137: ELSE
138: x_dlc := l_le_mapped;
139: END IF;
140: CLOSE check_le_mapped;

Line 150: RAISE FND_API.G_EXC_ERROR;

146:
147: OPEN le_bsv(l_sob_id);
148: FETCH le_bsv into l_bsv_le_id;
149: IF le_bsv%NOTFOUND THEN
150: RAISE FND_API.G_EXC_ERROR;
151: ELSE
152: x_dlc := l_bsv_le_id;
153: END IF;
154: CLOSE le_bsv;

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: END IF;
158:
159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158:
159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg