APPS.JL_VENDORMERGE_GRP dependencies on FND_API

Line 26: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

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

Line 27: ,p_commit IN VARCHAR2 default FND_API.G_FALSE

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

Line 28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

24: Procedure Merge_Vendor
25: (p_api_version IN NUMBER
26: ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
27: ,p_commit IN VARCHAR2 default FND_API.G_FALSE
28: ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
29: ,p_return_status OUT NOCOPY VARCHAR2
30: ,p_msg_count OUT NOCOPY NUMBER
31: ,p_msg_data OUT NOCOPY VARCHAR2
32: ,p_vendor_id IN NUMBER --> Represents Merge To Vendor

Line 66: IF NOT FND_API.Compatible_API_Call(l_api_version,

62:
63: SAVEPOINT import_document_PVT;
64:
65: -- Standard call to check for call compatibility
66: IF NOT FND_API.Compatible_API_Call(l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PKG_NAME
70: ) THEN

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: p_api_version,
68: l_api_name,
69: G_PKG_NAME
70: ) THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize API message list if necessary.
75: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 76: IF FND_API.to_Boolean( p_init_msg_list) THEN

72: END IF;
73:
74: -- Initialize API message list if necessary.
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80:

Line 81: p_return_status := FND_API.G_RET_STS_SUCCESS;

77: FND_MSG_PUB.initialize;
78: END IF;
79:
80:
81: p_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: IF p_dup_vendor_id is not null and p_dup_vendor_site_id is null
84: and p_vendor_id is not null Then
85:

Line 140: IF FND_API.To_Boolean( p_commit ) THEN

136: End Loop;
137: End If;
138: -- Bug 16036552 : End
139:
140: IF FND_API.To_Boolean( p_commit ) THEN
141: COMMIT WORK;
142: END IF;
143:
144: -- Standard check of p_commit.

Line 153: p_return_status := FND_API.G_RET_STS_ERROR ;

149: EXCEPTION
150: WHEN NO_DATA_FOUND THEN
151: NULL;
152: WHEN OTHERS THEN
153: p_return_status := FND_API.G_RET_STS_ERROR ;
154: ROLLBACK TO jl_vendor_merge;
155: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
157: FND_MSG_PUB.Add;

Line 163: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

159: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
160: | in the message stack. If there is only one message in |
161: | the stack it retrieves this message |
162: +---------------------------------------------------------*/
163: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
164: p_count => p_msg_count,
165: p_data => p_msg_data
166: );
167: --