APPS.DPP_VENDORMERGE_GRP dependencies on FND_API

Line 24: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

20: PROCEDURE Merge_Vendor
21:
22: ( p_api_version IN NUMBER
23:
24: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
25:
26: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
27:
28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

Line 26: ,p_commit IN VARCHAR2 default FND_API.G_FALSE

22: ( p_api_version IN NUMBER
23:
24: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
25:
26: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
27:
28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
29:
30: ,p_return_status OUT NOCOPY VARCHAR2

Line 28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

24: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
25:
26: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
27:
28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
29:
30: ,p_return_status OUT NOCOPY VARCHAR2
31:
32: ,p_msg_count OUT NOCOPY NUMBER

Line 64: p_return_status := FND_API.G_RET_STS_SUCCESS;

60: l_row_count NUMBER;
61:
62: BEGIN
63:
64: p_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67:
68: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 68: IF NOT FND_API.Compatible_API_Call ( l_api_version,

64: p_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67:
68: IF NOT FND_API.Compatible_API_Call ( l_api_version,
69:
70: p_api_version,
71:
72: l_api_name,

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: G_PKG_NAME)
75:
76: THEN
77:
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79:
80: END IF;
81:
82:

Line 88: IF FND_API.to_Boolean( p_init_msg_list) THEN

84: -- Initialize API message list if necessary.
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87:
88: IF FND_API.to_Boolean( p_init_msg_list) THEN
89:
90: FND_MSG_PUB.initialize;
91:
92: END IF;

Line 120: p_return_status := FND_API.G_RET_STS_SUCCESS;

116: AND vendor_site_id = p_dup_vendor_site_id;
117:
118: IF SQL%FOUND THEN
119:
120: p_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: l_row_count := SQL%ROWCOUNT;
123:
124: ELSE

Line 174: p_return_status := FND_API.G_RET_STS_SUCCESS;

170: AND vendor_site_id = p_dup_vendor_site_id;
171:
172: IF SQL%FOUND THEN
173:
174: p_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: l_row_count := SQL%ROWCOUNT;
177:
178: ELSE

Line 235: p_return_status := FND_API.G_RET_STS_SUCCESS;

231:
232:
233: IF SQL%FOUND THEN
234:
235: p_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: l_row_count := SQL%ROWCOUNT;
238:
239: ELSE

Line 280: p_return_status := FND_API.G_RET_STS_ERROR;

276: WHEN OTHERS THEN
277:
278: ROLLBACK ;
279:
280: p_return_status := FND_API.G_RET_STS_ERROR;
281:
282: FND_MSG_PUB.Count_And_Get
283:
284: ( p_count => p_msg_count,