APPS.CN_SALES_HIER_PUB dependencies on FND_API

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

15:
16: PROCEDURE get_sales_hier
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
21:
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,

Line 20: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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

Line 160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

156:
157: --+
158: -- Standard call to check for call compatibility.
159: --+
160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
161: p_api_version ,
162: l_api_name,
163: G_PKG_NAME )
164: THEN

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: p_api_version ,
162: l_api_name,
163: G_PKG_NAME )
164: THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: --+
169: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 171: IF FND_API.to_Boolean( p_init_msg_list ) THEN

167:
168: --+
169: -- Initialize message list if p_init_msg_list is set to TRUE.
170: --+
171: IF FND_API.to_Boolean( p_init_msg_list ) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: --+

Line 178: x_return_status := FND_API.G_RET_STS_SUCCESS;

174:
175: --+
176: -- Initialize API return status to success
177: --+
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179: x_loading_status := 'CN_INSERTED';
180:
181: --+
182: -- API body

Line 248: WHEN FND_API.G_EXC_ERROR THEN

244: END LOOP; -- for the comp groups cursor
245:
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get
251: (
252: p_count => x_msg_count ,

Line 249: x_return_status := FND_API.G_RET_STS_ERROR ;

245:
246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get
251: (
252: p_count => x_msg_count ,
253: p_data => x_msg_data ,

Line 254: p_encoded => FND_API.G_FALSE

250: FND_MSG_PUB.Count_And_Get
251: (
252: p_count => x_msg_count ,
253: p_data => x_msg_data ,
254: p_encoded => FND_API.G_FALSE
255: );
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: p_count => x_msg_count ,
253: p_data => x_msg_data ,
254: p_encoded => FND_API.G_FALSE
255: );
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get
260: (

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: p_encoded => FND_API.G_FALSE
255: );
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,

Line 263: p_encoded => FND_API.G_FALSE

259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE
264: );
265: WHEN OTHERS THEN
266: x_loading_status := 'UNEXPECTED_ERR';
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

263: p_encoded => FND_API.G_FALSE
264: );
265: WHEN OTHERS THEN
266: x_loading_status := 'UNEXPECTED_ERR';
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
271: END IF;

Line 276: p_encoded => FND_API.G_FALSE

272: FND_MSG_PUB.Count_And_Get
273: (
274: p_count => x_msg_count ,
275: p_data => x_msg_data ,
276: p_encoded => FND_API.G_FALSE
277: );
278:
279: END;
280: END cn_sales_hier_pub;