DBA Data[Home] [Help]

APPS.XLE_CONTACT_GRP dependencies on FND_API

Line 63: x_return_status := FND_API.G_RET_STS_SUCCESS;

59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2)
61: IS
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: IF p_le_etb_party_id IS NULL OR p_contact_party_id IS NULL
66: THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;

Line 67: x_return_status := FND_API.G_RET_STS_ERROR;

63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: IF p_le_etb_party_id IS NULL OR p_contact_party_id IS NULL
66: THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_msg_data := 'Mandatory parameters not passed to end_contact_roles';
69: ELSE
70: UPDATE xle_contact_legal_roles
71: SET effective_to = SYSDATE

Line 77: IF FND_API.To_Boolean( p_commit )

73: AND le_etb_party_id = p_le_etb_party_id
74: AND effective_to IS NULL;
75: END IF;
76:
77: IF FND_API.To_Boolean( p_commit )
78: THEN
79: COMMIT WORK;
80: END IF;
81:

Line 84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

80: END IF;
81:
82: EXCEPTION
83: WHEN OTHERS THEN
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
85: FND_MSG_PUB.Count_And_Get (
86: p_count => x_msg_count,
87: p_data => x_msg_data);
88: