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 54: IF NOT FND_API.Compatible_API_Call(l_api_version,

50:
51: SAVEPOINT import_document_PVT;
52:
53: -- Standard call to check for call compatibility
54: IF NOT FND_API.Compatible_API_Call(l_api_version,
55: p_api_version,
56: l_api_name,
57: G_PKG_NAME
58: ) THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version,
56: l_api_name,
57: G_PKG_NAME
58: ) THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize API message list if necessary.
63: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 64: IF FND_API.to_Boolean( p_init_msg_list) THEN

60: END IF;
61:
62: -- Initialize API message list if necessary.
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list) THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68:

Line 69: p_return_status := FND_API.G_RET_STS_SUCCESS;

65: FND_MSG_PUB.initialize;
66: END IF;
67:
68:
69: p_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: IF p_dup_vendor_id is not null and p_dup_vendor_site_id is null
72: and p_vendor_id is not null Then
73:

Line 115: IF FND_API.To_Boolean( p_commit ) THEN

111: and vendor_site_id = p_dup_vendor_site_id;
112:
113: END IF;
114:
115: IF FND_API.To_Boolean( p_commit ) THEN
116: COMMIT WORK;
117: END IF;
118:
119: -- Standard check of p_commit.

Line 128: p_return_status := FND_API.G_RET_STS_ERROR ;

124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: NULL;
127: WHEN OTHERS THEN
128: p_return_status := FND_API.G_RET_STS_ERROR ;
129: ROLLBACK TO jl_vendor_merge;
130: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
132: FND_MSG_PUB.Add;

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

134: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
135: | in the message stack. If there is only one message in |
136: | the stack it retrieves this message |
137: +---------------------------------------------------------*/
138: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
139: p_count => p_msg_count,
140: p_data => p_msg_data
141: );
142: --