APPS.INL_LANDEDCOST_PUB dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

6: -- Function :
7: -- Pre-reqs : None
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_ship_line_id IN NUMBER Required
13: --
14: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

7: -- Pre-reqs : None
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_ship_line_id IN NUMBER Required
13: --
14: -- OUT : x_return_status OUT NOCOPY VARCHAR2
15: -- x_msg_count OUT NOCOPY NUMBER

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

31: --
32: -- Notes :
33: PROCEDURE Get_LandedCost(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_ship_line_id IN NUMBER,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

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

32: -- Notes :
33: PROCEDURE Get_LandedCost(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_ship_line_id IN NUMBER,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 72: IF FND_API.to_Boolean( p_init_msg_list ) THEN

68: -- Standard Start of API savepoint
69: SAVEPOINT Get_LandedCost_PVT;
70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: -- Check for call compatibility.

Line 77: IF NOT FND_API.Compatible_API_Call (

73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: -- Check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call (
78: l_api_version,
79: p_api_version,
80: l_api_name,
81: g_pkg_name)

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: p_api_version,
80: l_api_name,
81: g_pkg_name)
82: THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Api Body
90: BEGIN
91: -- Standard Statement Level Procedure/Function Logging

Line 156: IF FND_API.To_Boolean( p_commit ) THEN

152: END;
153: -- End of Api Body
154:
155: -- Standard check of p_commit.
156: IF FND_API.To_Boolean( p_commit ) THEN
157: COMMIT WORK;
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.

Line 162: p_encoded => FND_API.g_false,

158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.Count_And_Get(
162: p_encoded => FND_API.g_false,
163: p_count => x_msg_count,
164: p_data => x_msg_data);
165:
166: -- Standard End of Procedure/Function Logging

Line 172: WHEN FND_API.G_EXC_ERROR THEN

168: p_module_name => g_module_name,
169: p_procedure_name => l_api_name
170: );
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: -- Standard Expected Error Logging
174: INL_LOGGING_PVT.Log_ExpecError (
175: p_module_name => g_module_name,
176: p_procedure_name => l_api_name

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: p_module_name => g_module_name,
176: p_procedure_name => l_api_name
177: );
178: ROLLBACK TO Get_LandedCost_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MSG_PUB.Count_And_Get(
181: p_encoded => FND_API.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data

Line 181: p_encoded => FND_API.g_false,

177: );
178: ROLLBACK TO Get_LandedCost_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MSG_PUB.Count_And_Get(
181: p_encoded => FND_API.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

181: p_encoded => FND_API.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: -- Standard Unexpected Error Logging
187: INL_LOGGING_PVT.Log_UnexpecError (
188: p_module_name => g_module_name,
189: p_procedure_name => l_api_name);

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: INL_LOGGING_PVT.Log_UnexpecError (
188: p_module_name => g_module_name,
189: p_procedure_name => l_api_name);
190: ROLLBACK TO Get_LandedCost_PVT;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data

Line 193: p_encoded => FND_API.g_false,

189: p_procedure_name => l_api_name);
190: ROLLBACK TO Get_LandedCost_PVT;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.g_false,
194: p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197: WHEN OTHERS THEN

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: p_module_name => g_module_name,
201: p_procedure_name => l_api_name
202: );
203: ROLLBACK TO Get_LandedCost_PVT;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg(
208: g_pkg_name,

Line 213: p_encoded => FND_API.g_false,

209: l_api_name
210: );
211: END IF;
212: FND_MSG_PUB.Count_And_Get(
213: p_encoded => FND_API.g_false,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );
217: END Get_LandedCost;