APPS.OZF_VENDORMERGE_GRP dependencies on FND_API

Line 14: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

10: -- 07/30/2001 sshivali Created.
11: -----------------------------------------------------------------------
12: PROCEDURE Merge_Vendor
13: ( p_api_version IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
15: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
16: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
17: ,p_return_status OUT NOCOPY VARCHAR2
18: ,p_msg_count OUT NOCOPY NUMBER

Line 15: ,p_commit IN VARCHAR2 default FND_API.G_FALSE

11: -----------------------------------------------------------------------
12: PROCEDURE Merge_Vendor
13: ( p_api_version IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
15: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
16: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
17: ,p_return_status OUT NOCOPY VARCHAR2
18: ,p_msg_count OUT NOCOPY NUMBER
19: ,p_msg_data OUT NOCOPY VARCHAR2

Line 16: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

12: PROCEDURE Merge_Vendor
13: ( p_api_version IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
15: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
16: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
17: ,p_return_status OUT NOCOPY VARCHAR2
18: ,p_msg_count OUT NOCOPY NUMBER
19: ,p_msg_data OUT NOCOPY VARCHAR2
20: ,p_vendor_id IN NUMBER

Line 34: p_return_status := FND_API.G_RET_STS_SUCCESS;

30: l_api_name CONSTANT VARCHAR2(30) := 'MERGE_VENDOR';
31: l_api_version CONSTANT NUMBER := 1.0;
32: l_row_count NUMBER;
33: BEGIN
34: p_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: IF NOT FND_API.Compatible_API_Call ( l_api_version,
37: p_api_version,
38: l_api_name,

Line 36: IF NOT FND_API.Compatible_API_Call ( l_api_version,

32: l_row_count NUMBER;
33: BEGIN
34: p_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: IF NOT FND_API.Compatible_API_Call ( l_api_version,
37: p_api_version,
38: l_api_name,
39: G_PKG_NAME)
40: THEN

Line 41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

37: p_api_version,
38: l_api_name,
39: G_PKG_NAME)
40: THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44: -- Initialize API message list if necessary.
45: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 46: IF FND_API.to_Boolean( p_init_msg_list) THEN

42: END IF;
43:
44: -- Initialize API message list if necessary.
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49:
50: UPDATE OZF_CLAIMS_ALL

Line 65: p_return_status := FND_API.G_RET_STS_SUCCESS;

61:
62: -- Prepare message name
63: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
64: IF SQL%FOUND THEN
65: p_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_row_count := SQL%ROWCOUNT;
67: ELSE
68: l_row_count := 0;
69: END IF;

Line 98: p_return_status := FND_API.G_RET_STS_SUCCESS;

94:
95: -- Prepare message name
96: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
97: IF SQL%FOUND THEN
98: p_return_status := FND_API.G_RET_STS_SUCCESS;
99: l_row_count := SQL%ROWCOUNT;
100: ELSE
101: l_row_count := 0;
102: END IF;

Line 130: p_return_status := FND_API.G_RET_STS_SUCCESS;

126:
127: -- Prepare message name
128: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
129: IF SQL%FOUND THEN
130: p_return_status := FND_API.G_RET_STS_SUCCESS;
131: l_row_count := SQL%ROWCOUNT;
132: ELSE
133: l_row_count := 0;
134: END IF;

Line 162: p_return_status := FND_API.G_RET_STS_SUCCESS;

158:
159: -- Prepare message name
160: FND_MESSAGE.SET_NAME('OZF','OZF_VENDOR_MERGE');
161: IF SQL%FOUND THEN
162: p_return_status := FND_API.G_RET_STS_SUCCESS;
163: l_row_count := SQL%ROWCOUNT;
164: ELSE
165: l_row_count := 0;
166: END IF;

Line 184: p_return_status := FND_API.G_RET_STS_ERROR;

180:
181: EXCEPTION
182: WHEN OTHERS THEN
183: ROLLBACK ;
184: p_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => p_msg_count,
187: p_data => p_msg_data
188: );