DBA Data[Home] [Help]

APPS.FEM_FUNC_DIM_PVT dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: EXCEPTION
71:
72: WHEN OTHERS THEN
73: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, g_api_name);
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75:
76: END CopyObjectDefinition;
77:
78:

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: EXCEPTION
105:
106: WHEN OTHERS THEN
107: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, g_api_name);
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109:
110: END DeleteObjectDefinition;
111:
112: --

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: --
163: WHEN OTHERS THEN
164:
165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, g_api_name);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167:
168: END GetDataColumnDimension;
169:
170: --

Line 183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

179: --
180: --------------------------------------------------------------------------------
181: PROCEDURE UpdateColumnDisplayNames(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,

Line 184: p_commit IN VARCHAR2 := FND_API.G_FALSE,

180: --------------------------------------------------------------------------------
181: PROCEDURE UpdateColumnDisplayNames(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,

Line 185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

181: PROCEDURE UpdateColumnDisplayNames(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: --

Line 213: IF NOT FND_API.Compatible_API_Call ( l_api_version,

209:
210: BEGIN
211: SAVEPOINT Update_Column_Display_Pvt ;
212:
213: IF NOT FND_API.Compatible_API_Call ( l_api_version,
214: p_api_version,
215: l_api_name,
216: G_PKG_NAME )
217: THEN

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

214: p_api_version,
215: l_api_name,
216: G_PKG_NAME )
217: THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
219: END IF;
220:
221: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize ;

Line 221: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

217: THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
219: END IF;
220:
221: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize ;
223: END IF;
224: --
225: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS ;

221: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize ;
223: END IF;
224: --
225: x_return_status := FND_API.G_RET_STS_SUCCESS ;
226: --
227:
228: FOR i IN p_sets.FIRST..p_sets.LAST LOOP -- Fetching corresponding l_set_name for set_ids in the array p_set_id
229:

Line 251: IF FND_API.To_Boolean(p_commit)

247: CLOSE cur_fetch_table_column_combo ;
248:
249: END LOOP ; -- Ending outer loop
250:
251: IF FND_API.To_Boolean(p_commit)
252: THEN
253: COMMIT WORK;
254: END IF;
255:

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255:
256: EXCEPTION
257:
258: --
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: ROLLBACK TO Update_Column_Display_Pvt ;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258: --
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: ROLLBACK TO Update_Column_Display_Pvt ;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
264: p_data => x_msg_data );
265:
266:

Line 268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

264: p_data => x_msg_data );
265:
266:
267: --
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269:
270: ROLLBACK TO Update_Column_Display_Pvt ;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267: --
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269:
270: ROLLBACK TO Update_Column_Display_Pvt ;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
273: p_data => x_msg_data );
274:
275: --

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: --
276: WHEN DUP_VAL_ON_INDEX THEN
277:
278: ROLLBACK TO Update_Column_Display_Pvt ;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MESSAGE.SET_NAME('FEM', 'FEM_FUNC_DIM_DUP_DISP_UPD_ERR');
281: FND_MSG_PUB.ADD;
282:
283:

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283:
284: --
285: WHEN OTHERS THEN
286: ROLLBACK TO Update_Column_Display_Pvt ;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: --
289: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
290: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
291: l_api_name);