APPS.GL_COA_SEGMENT_VAL_PVT 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_segment_val_pvt';
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_tbl IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_tbl_type,

Line 41: IF NOT FND_API.Compatible_API_Call(l_api_version ,

37: --Standard start of API savepoint
38: SAVEPOINT gl_coa_segment_val_pvt;
39:
40: --Standard call to check for call compatibility
41: IF NOT FND_API.Compatible_API_Call(l_api_version ,
42: p_api_version ,
43: l_api_name ,
44: G_PKG_NAME) THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41: IF NOT FND_API.Compatible_API_Call(l_api_version ,
42: p_api_version ,
43: l_api_name ,
44: G_PKG_NAME) THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: --Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 49: IF FND_API.to_Boolean(p_init_msg_list) THEN

45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: --Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.to_Boolean(p_init_msg_list) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:
53:

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: --API body
55:
56:
57: --Initialize API return status to success
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60:
61: --API body
62: p_gl_flex_values_status := 'S';

Line 128: RAISE FND_API.G_EXC_ERROR;

124: --If none of the PL/SQL data has been passed then raise error
125: IF NOT l_record_exists THEN
126: FND_MESSAGE.SET_NAME ('GL','GL_COA_SVI_DATA_NOT_PASSED');
127: FND_MSG_PUB.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: --End of API body
132:

Line 134: IF FND_API.TO_Boolean( p_commit) THEN

130:
131: --End of API body
132:
133: --Standard check of p_commit
134: IF FND_API.TO_Boolean( p_commit) THEN
135: COMMIT WORK;
136: END IF;
137:
138: --Standard call to get message count and if count is 1, get message info.

Line 144: WHEN FND_API.G_EXC_ERROR THEN

140: p_data => x_msg_data);
141:
142:
143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception1:');
146: ROLLBACK;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception1:');
146: ROLLBACK;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
149: p_data => x_msg_data );
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception2:');

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: ROLLBACK;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
149: p_data => x_msg_data );
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception2:');
152: ROLLBACK;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: p_data => x_msg_data );
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception2:');
152: ROLLBACK;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
155: p_data => x_msg_data );
156:
157: WHEN OTHERS THEN

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

156:
157: WHEN OTHERS THEN
158: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception3:'||SQLERRM);
159: ROLLBACK ;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
163: l_api_name);
164: END IF;