APPS.IGC_VENDOR_MERGE_PVT dependencies on FND_API

Line 20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

16: -- CC related.
17: -- *************************************************************************
18:
19: PROCEDURE merge_vendor(p_api_version IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER

Line 21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

17: -- *************************************************************************
18:
19: PROCEDURE merge_vendor(p_api_version IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2

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

18:
19: PROCEDURE merge_vendor(p_api_version IN NUMBER
20: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,p_new_vendor_id IN NUMBER

Line 38: IF (NOT FND_API.Compatible_API_Call(l_api_version

34:
35: BEGIN
36:
37: -- Standard call to check for call compatibility
38: IF (NOT FND_API.Compatible_API_Call(l_api_version
39: ,p_api_version
40: ,l_api_name
41: ,G_PKG_NAME))
42: THEN

Line 43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

39: ,p_api_version
40: ,l_api_name
41: ,G_PKG_NAME))
42: THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;
45:
46: -- Check p_init_msg_list
47: IF FND_API.to_Boolean(p_init_msg_list)

Line 47: IF FND_API.to_Boolean(p_init_msg_list)

43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;
45:
46: -- Check p_init_msg_list
47: IF FND_API.to_Boolean(p_init_msg_list)
48: THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51:

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: FND_MSG_PUB.initialize;
50: END IF;
51:
52: -- Initialize API return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: -- Update the PO headers table for the CC related rows.
56: UPDATE po_headers
57: SET vendor_id = p_new_vendor_id,

Line 80: IF p_commit = FND_API.G_TRUE

76: WHERE vendor_id = p_old_vendor_id
77: AND vendor_site_id = p_old_vendor_site_id
78: AND org_id = g_org_id;
79:
80: IF p_commit = FND_API.G_TRUE
81: THEN
82: COMMIT;
83: END IF;
84:

Line 89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

85: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
86: p_data => x_msg_data);
87:
88: EXCEPTION
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
90: THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
93: p_data => x_msg_data);

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

87:
88: EXCEPTION
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
90: THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
93: p_data => x_msg_data);
94:
95: WHEN OTHERS

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: p_data => x_msg_data);
94:
95: WHEN OTHERS
96: THEN
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
99: THEN
100: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
101: END IF;