DBA Data[Home] [Help]

APPS.FA_VENDORMERGE_GRP dependencies on FND_API

Line 15: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

11: g_log_level_rec fa_api_types.log_level_rec_type;
12:
13: PROCEDURE Merge_Vendor(
14: p_api_version IN NUMBER
15: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
16: , p_commit IN VARCHAR2 default FND_API.G_FALSE
17: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
18: , x_return_status OUT NOCOPY VARCHAR2
19: , x_msg_count OUT NOCOPY NUMBER

Line 16: , p_commit IN VARCHAR2 default FND_API.G_FALSE

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

Line 17: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

13: PROCEDURE Merge_Vendor(
14: p_api_version IN NUMBER
15: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
16: , p_commit IN VARCHAR2 default FND_API.G_FALSE
17: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
18: , x_return_status OUT NOCOPY VARCHAR2
19: , x_msg_count OUT NOCOPY NUMBER
20: , x_msg_data OUT NOCOPY VARCHAR2
21: , p_vendor_id IN NUMBER

Line 78: l_location := 'Calling fnd_api.compatible_api_call';

74: end if;
75:
76: l_row_count := 0;
77:
78: l_location := 'Calling fnd_api.compatible_api_call';
79: -- Check version of the API
80: -- Standard call to check for API call compatibility.
81: if NOT fnd_api.compatible_api_call (
82: G_API_VERSION,

Line 81: if NOT fnd_api.compatible_api_call (

77:
78: l_location := 'Calling fnd_api.compatible_api_call';
79: -- Check version of the API
80: -- Standard call to check for API call compatibility.
81: if NOT fnd_api.compatible_api_call (
82: G_API_VERSION,
83: p_api_version,
84: G_API_NAME,
85: G_PKG_NAME) then

Line 87: fa_debug_pkg.add(l_calling_fn, 'Failed calling', 'fnd_api.compatible_api_call',

83: p_api_version,
84: G_API_NAME,
85: G_PKG_NAME) then
86: if (g_log_level_rec.statement_level) then
87: fa_debug_pkg.add(l_calling_fn, 'Failed calling', 'fnd_api.compatible_api_call',
88: p_log_level_rec => g_log_level_rec);
89: end if;
90:
91: raise mrg_err;

Line 273: -- if FND_API.to_boolean(p_commit) then

269: where VENDOR_NUMBER = p_dup_segment1;
270:
271:
272: -- Commenting out as this is not necessary
273: -- if FND_API.to_boolean(p_commit) then
274: -- COMMIT;
275: -- end if;
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273: -- if FND_API.to_boolean(p_commit) then
274: -- COMMIT;
275: -- end if;
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: if (g_log_level_rec.statement_level) then
280: fa_debug_pkg.add(l_calling_fn, 'End', 'SUCCESS',
281: p_log_level_rec => g_log_level_rec);

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
289: p_log_level_rec => g_log_level_rec);
290: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
291: p_data => x_msg_data);
292: x_return_status := FND_API.G_RET_STS_ERROR;
293:
294: WHEN OTHERS THEN
295: ROLLBACK TO sp_vendor_merge;
296:

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: p_log_level_rec => g_log_level_rec);
312:
313: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
314: p_data => x_msg_data);
315: x_return_status := FND_API.G_RET_STS_ERROR;
316:
317: END Merge_Vendor;
318:
319: END FA_VENDORMERGE_GRP;