DBA Data[Home] [Help]

APPS.DOM_ASSOCIATIONS_UTIL dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53: l_message := 'DOM_ADD_IMP_ERROR';
54: FND_MESSAGE.Set_Name('DOM', l_message);
55: FND_MESSAGE.Set_Token('DOC_NUMBER', l_doc_number);
56: FND_MSG_PUB.Add;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: ELSE
59: INSERT INTO DOM_RELATIONSHIPS (
60: association_id ,
61: from_entity_name ,

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152: l_message := 'DOM_DELETE_IMP_ERROR';
153: FND_MESSAGE.Set_Name('DOM', l_message);
154: FND_MESSAGE.Set_Token('DOC_NUMBER', l_doc_number);
155: FND_MSG_PUB.Add;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: ELSE
158:
159:
160: DELETE FROM DOM_RELATIONSHIPS

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: l_message := 'DOM_CHANGE_REV_IMP_ERROR';
227: FND_MESSAGE.Set_Name('DOM', l_message);
228: FND_MESSAGE.Set_Token('DOC_NUMBER', l_doc_number);
229: FND_MSG_PUB.Add;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: ELSE
232:
233: UPDATE DOM_RELATIONSHIPS
234: SET

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282:
283:
284: BEGIN
285: -- Initialize API return status to success
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287:
288: l_action := p_action;
289:
290: IF l_action = 'ADD' THEN

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: p_data => x_msg_data );
365:
366: EXCEPTION
367:
368: WHEN FND_API.G_EXC_ERROR THEN
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MSG_PUB.Count_And_Get
371: ( p_count => x_msg_count
372: ,p_data => x_msg_data );

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365:
366: EXCEPTION
367:
368: WHEN FND_API.G_EXC_ERROR THEN
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: FND_MSG_PUB.Count_And_Get
371: ( p_count => x_msg_count
372: ,p_data => x_msg_data );
373:

Line 374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: FND_MSG_PUB.Count_And_Get
371: ( p_count => x_msg_count
372: ,p_data => x_msg_data );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count
378: ,p_data => x_msg_data );

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: ( p_count => x_msg_count
372: ,p_data => x_msg_data );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378: ,p_data => x_msg_data );
379:
380: WHEN OTHERS THEN
381:
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
384: THEN
385: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
386: END IF;