APPS.CN_EXT_TBL_MAP_PVT dependencies on FND_API

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

61: SAVEPOINT create_external_mapping ;
62: --+
63: -- Standard call to check for call compatibility.
64: --+
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: --+
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: -- +

Line 74: IF FND_API.to_Boolean( p_init_msg_list ) THEN

70: END IF;
71: --+
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: -- +
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: -- +
78: -- Initialize API return status to success

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: END IF;
77: -- +
78: -- Initialize API return status to success
79: -- +
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: x_loading_status := 'CN_INSERTED';
82: -- +
83: -- +
84: x_status := get_mapping_status ( p_table_mapping_rec.name);

Line 120: RAISE fnd_api.g_exc_error;

116: x_last_updated_by => g_last_updated_by ,
117: x_last_update_login => g_last_update_login ) ;
118: ELSE
119: fnd_message.set_name('CN', 'NAME_NOT_UNIQUE');
120: RAISE fnd_api.g_exc_error;
121: END IF;
122:
123: FOR i IN 1 .. p_column_mapping_tbl.COUNT LOOP
124: cn_calc_ext_tbl_dtls_pkg.insert_row

Line 156: IF( FND_API.to_boolean(p_commit)) THEN

152: END LOOP;
153: -- +
154: -- Standard Check to p_commit
155: -- +
156: IF( FND_API.to_boolean(p_commit)) THEN
157: COMMIT WORK;
158: END IF ;
159: -- +
160: -- Standard Call to get Message count if count > 1 get message

Line 166: p_encoded => FND_API.G_FALSE

162: FND_MSG_PUB.count_and_get
163: (
164: p_count => x_msg_count ,
165: p_data => x_msg_data ,
166: p_encoded => FND_API.G_FALSE
167: );
168:
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN

Line 170: WHEN FND_API.G_EXC_ERROR THEN

166: p_encoded => FND_API.G_FALSE
167: );
168:
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO create_external_mapping ;
172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (

Line 172: x_return_status := FND_API.G_RET_STS_ERROR ;

168:
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO create_external_mapping ;
172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (
175: p_count => x_msg_count ,
176: p_data => x_msg_data ,

Line 177: p_encoded => FND_API.G_FALSE

173: FND_MSG_PUB.Count_And_Get
174: (
175: p_count => x_msg_count ,
176: p_data => x_msg_data ,
177: p_encoded => FND_API.G_FALSE
178: );
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO create_external_mapping ;
181: x_loading_status := 'UNEXPECTED_ERR';

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: p_count => x_msg_count ,
176: p_data => x_msg_data ,
177: p_encoded => FND_API.G_FALSE
178: );
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO create_external_mapping ;
181: x_loading_status := 'UNEXPECTED_ERR';
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: FND_MSG_PUB.Count_And_Get

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

178: );
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO create_external_mapping ;
181: x_loading_status := 'UNEXPECTED_ERR';
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => x_msg_count ,
186: p_data => x_msg_data ,

Line 187: p_encoded => FND_API.G_FALSE

183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => x_msg_count ,
186: p_data => x_msg_data ,
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN OTHERS THEN
190: ROLLBACK TO create_external_mapping ;
191: x_loading_status := 'UNEXPECTED_ERR';

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

188: );
189: WHEN OTHERS THEN
190: ROLLBACK TO create_external_mapping ;
191: x_loading_status := 'UNEXPECTED_ERR';
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
193: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
196: END IF;

Line 201: p_encoded => FND_API.G_FALSE

197: FND_MSG_PUB.Count_And_Get
198: (
199: p_count => x_msg_count ,
200: p_data => x_msg_data ,
201: p_encoded => FND_API.G_FALSE
202: );
203:
204: END create_external_mapping;
205: --