DBA Data[Home] [Help]

APPS.PN_VENDORMERGE_GRP dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30):='PN_VendorMerge_GRP';
5:
6: Procedure Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
9: p_commit IN VARCHAR2 default FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

Line 9: p_commit IN VARCHAR2 default FND_API.G_FALSE,

5:
6: Procedure Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
9: p_commit IN VARCHAR2 default FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,

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

6: Procedure Merge_Vendor(
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
9: p_commit IN VARCHAR2 default FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_vendor_id IN NUMBER,

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25:
26: BEGIN
27:
28: -- Initialize API return status to success
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
32: p_api_version ,
33: l_api_name ,

Line 31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

27:
28: -- Initialize API return status to success
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
32: p_api_version ,
33: l_api_name ,
34: G_PKG_NAME )
35: THEN

Line 36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

32: p_api_version ,
33: l_api_name ,
34: G_PKG_NAME )
35: THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: END IF;
38:
39: -- Initialize API message list if necessary.
40: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 41: IF FND_API.to_Boolean( p_init_msg_list) THEN

37: END IF;
38:
39: -- Initialize API message list if necessary.
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list) THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52:
53: -- Prepare message name
54: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_TERMS');
55: IF SQL%FOUND THEN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: l_row_count := SQL%ROWCOUNT;
58: ELSE
59: l_row_count := 0;
60: END IF;

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72:
73: -- Prepare message name
74: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_ITEMS');
75: IF SQL%FOUND THEN
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: l_row_count := SQL%ROWCOUNT;
78: ELSE
79: l_row_count := 0;
80: END IF;

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

93: EXCEPTION
94:
95: WHEN OTHERS THEN
96: ROLLBACK ;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count,
100: p_data => x_msg_data
101: );