DBA Data[Home] [Help]

APPS.ECX_VENDORMERGE_GRP dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2: /* $Header: ECXPVMRB.pls 120.2 2006/09/25 23:11:50 sbastida noship $ */
3:
4: procedure merge_vendor (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
7: p_commit IN VARCHAR2 default FND_API.G_FALSE,
8: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,

Line 7: p_commit IN VARCHAR2 default FND_API.G_FALSE,

3:
4: procedure merge_vendor (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
7: p_commit IN VARCHAR2 default FND_API.G_FALSE,
8: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,

Line 8: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

4: procedure merge_vendor (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
7: p_commit IN VARCHAR2 default FND_API.G_FALSE,
8: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
12: p_vendor_id IN NUMBER,

Line 23: p_return_status := FND_API.G_RET_STS_SUCCESS;

19: p_dup_party_site_id IN NUMBER
20: ) is
21: begin
22:
23: p_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: -- check if parent didn't change
26: if (p_dup_party_id = p_party_id and p_dup_party_site_id = p_party_site_id) then
27: return;

Line 69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: exception
66: when others then
67: p_msg_count := nvl(p_msg_count,0) + 1;
68: p_msg_data := 'SQLCODE: '|| SQLCODE ||' SQLERRM: '|| SQLERRM ||'*';
69: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70:
71: end merge_vendor;
72:
73: end;