DBA Data[Home] [Help]

APPS.GL_COA_SEG_VAL_IMP_PUB dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'gl_coa_seg_val_imp_pub';
5:
6: PROCEDURE coa_segment_val_imp (
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

Line 9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5:
6: PROCEDURE coa_segment_val_imp (
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,

Line 10: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

6: PROCEDURE coa_segment_val_imp (
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_gl_flex_values_obj_tbl IN OUT NOCOPY GL_FLEX_VALUES_OBJ_TBL,

Line 89: IF NOT FND_API.Compatible_API_Call(l_api_version ,

85: --Standard start of API savepoint
86: SAVEPOINT coa_segment_val_imp_pub;
87:
88: --Standard call to check for call compatibility
89: IF NOT FND_API.Compatible_API_Call(l_api_version ,
90: p_api_version ,
91: l_api_name ,
92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: IF NOT FND_API.Compatible_API_Call(l_api_version ,
90: p_api_version ,
91: l_api_name ,
92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: --Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 97: IF FND_API.to_Boolean(p_init_msg_list) THEN

93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: --Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.to_Boolean(p_init_msg_list) THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:
101: IF p_gl_flex_values_obj_tbl IS NOT NULL AND p_gl_flex_values_obj_tbl.COUNT > 0 THEN

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: END IF;
257: END IF;
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO coa_segment_val_imp_pub;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
264: p_data => x_msg_data );

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO coa_segment_val_imp_pub;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
264: p_data => x_msg_data );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO coa_segment_val_imp_pub;

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: ROLLBACK TO coa_segment_val_imp_pub;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
264: p_data => x_msg_data );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO coa_segment_val_imp_pub;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
269: p_data => x_msg_data );

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
264: p_data => x_msg_data );
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO coa_segment_val_imp_pub;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
269: p_data => x_msg_data );
270: WHEN OTHERS THEN
271: ROLLBACK TO coa_segment_val_imp_pub;

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
269: p_data => x_msg_data );
270: WHEN OTHERS THEN
271: ROLLBACK TO coa_segment_val_imp_pub;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
275: l_api_name);
276: END IF;