DBA Data[Home] [Help]

APPS.IGI_VENDOR_MERGE_GRP dependencies on FND_API

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

37: -- Supplier merge.
38: -- *************************************************************************
39:
40: PROCEDURE merge_vendor(p_api_version IN NUMBER
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: ,x_return_status OUT NOCOPY VARCHAR2
45: ,x_msg_count OUT NOCOPY NUMBER

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

38: -- *************************************************************************
39:
40: PROCEDURE merge_vendor(p_api_version IN NUMBER
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: ,x_return_status OUT NOCOPY VARCHAR2
45: ,x_msg_count OUT NOCOPY NUMBER
46: ,x_msg_data OUT NOCOPY VARCHAR2

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

39:
40: PROCEDURE merge_vendor(p_api_version IN NUMBER
41: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44: ,x_return_status OUT NOCOPY VARCHAR2
45: ,x_msg_count OUT NOCOPY NUMBER
46: ,x_msg_data OUT NOCOPY VARCHAR2
47: ,p_new_vendor_id IN NUMBER

Line 71: IF (NOT FND_API.Compatible_API_Call(l_api_version

67:
68: BEGIN
69:
70: -- Standard call to check for call compatibility
71: IF (NOT FND_API.Compatible_API_Call(l_api_version
72: ,p_api_version
73: ,l_api_name
74: ,G_PKG_NAME))
75: THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: ,p_api_version
73: ,l_api_name
74: ,G_PKG_NAME))
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Check p_init_msg_list
80: IF FND_API.to_Boolean(p_init_msg_list)

Line 80: IF FND_API.to_Boolean(p_init_msg_list)

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Check p_init_msg_list
80: IF FND_API.to_Boolean(p_init_msg_list)
81: THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: OPEN c_chk_prms;
89: FETCH c_chk_prms INTO l_paid_invoices_flag,
90: l_process;

Line 133: ,p_init_msg_list => FND_API.G_FALSE

129: AND igi_gen.is_req_installed('CC')
130: THEN
131: IGC_VENDOR_MERGE_PVT.MERGE_VENDOR
132: (p_api_version => 1.0
133: ,p_init_msg_list => FND_API.G_FALSE
134: ,p_commit => FND_API.G_FALSE
135: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
136: ,x_return_status => x_return_status
137: ,x_msg_count => x_msg_count

Line 134: ,p_commit => FND_API.G_FALSE

130: THEN
131: IGC_VENDOR_MERGE_PVT.MERGE_VENDOR
132: (p_api_version => 1.0
133: ,p_init_msg_list => FND_API.G_FALSE
134: ,p_commit => FND_API.G_FALSE
135: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
136: ,x_return_status => x_return_status
137: ,x_msg_count => x_msg_count
138: ,x_msg_data => x_msg_data

Line 135: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

131: IGC_VENDOR_MERGE_PVT.MERGE_VENDOR
132: (p_api_version => 1.0
133: ,p_init_msg_list => FND_API.G_FALSE
134: ,p_commit => FND_API.G_FALSE
135: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
136: ,x_return_status => x_return_status
137: ,x_msg_count => x_msg_count
138: ,x_msg_data => x_msg_data
139: ,p_new_vendor_id => p_new_vendor_id

Line 145: IF p_commit = FND_API.G_TRUE

141: ,p_old_vendor_id => p_old_vendor_id
142: ,p_old_vendor_site_id => p_old_vendor_site_id);
143: END IF;
144:
145: IF p_commit = FND_API.G_TRUE
146: AND x_return_status = FND_API.G_RET_STS_SUCCESS
147: THEN
148: COMMIT;
149: END IF;

Line 146: AND x_return_status = FND_API.G_RET_STS_SUCCESS

142: ,p_old_vendor_site_id => p_old_vendor_site_id);
143: END IF;
144:
145: IF p_commit = FND_API.G_TRUE
146: AND x_return_status = FND_API.G_RET_STS_SUCCESS
147: THEN
148: COMMIT;
149: END IF;
150:

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: EXCEPTION
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
156: THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
159: p_data => x_msg_data);

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153:
154: EXCEPTION
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
156: THEN
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
159: p_data => x_msg_data);
160:
161: WHEN OTHERS

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: p_data => x_msg_data);
160:
161: WHEN OTHERS
162: THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
167: END IF;

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187: l_api_name VARCHAR2(30) := 'Update_EXP_Tables';
188: BEGIN
189:
190: -- Initialize API return status to success
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: -- If user has chosen to update all invoices (paid + unpaid)
194: -- then update all the dialog units irrespective of their status.
195: IF p_paid_invoices_flag = 'Y'

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252:
253: EXCEPTION
254: WHEN OTHERS
255: THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
260: END IF;