DBA Data[Home] [Help]

APPS.CN_SYSTEM_PARAMETERS_PVT dependencies on FND_API

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

81: END Get_Data;
82:
83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,

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

82:
83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,
90: p_set_of_books_id IN NUMBER,

Line 87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

83: PROCEDURE Update_Data
84: (p_api_version IN NUMBER ,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_name IN VARCHAR2,
89: p_rev_class_hierarchy_id IN NUMBER,
90: p_set_of_books_id IN NUMBER,
91: p_batch_size IN NUMBER,

Line 122: IF NOT FND_API.Compatible_API_Call

118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT Update_Data;
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call
123: (l_api_version ,
124: p_api_version ,
125: l_api_name ,
126: G_PKG_NAME )

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: p_api_version ,
125: l_api_name ,
126: G_PKG_NAME )
127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;

Line 131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: -- API body
138: -- locking
139: open c;

Line 145: raise fnd_api.g_exc_unexpected_error;

141: if (c%notfound) then
142: close c;
143: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
144: fnd_msg_pub.add;
145: raise fnd_api.g_exc_unexpected_error;
146: end if;
147: close c;
148:
149: if (tlinfo.object_version_number <> p_object_version_number) then

Line 152: raise fnd_api.g_exc_unexpected_error;

148:
149: if (tlinfo.object_version_number <> p_object_version_number) then
150: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
151: fnd_msg_pub.add;
152: raise fnd_api.g_exc_unexpected_error;
153: end if;
154:
155: -- updating
156: update cn_repositories

Line 224: IF FND_API.To_Boolean( p_commit ) THEN

220:
221: -- End of API body.
222:
223: -- Standard check of p_commit.
224: IF FND_API.To_Boolean( p_commit ) THEN
225: COMMIT WORK;
226: END IF;
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get

Line 231: p_encoded => FND_API.G_FALSE );

227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
229: (p_count => x_msg_count ,
230: p_data => x_msg_data ,
231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 233: WHEN FND_API.G_EXC_ERROR THEN

229: (p_count => x_msg_count ,
230: p_data => x_msg_data ,
231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,

Line 235: x_return_status := FND_API.G_RET_STS_ERROR ;

231: p_encoded => FND_API.G_FALSE );
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Update_Data;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );

Line 239: p_encoded => FND_API.G_FALSE );

235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: FND_MSG_PUB.count_and_get
237: (p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

239: p_encoded => FND_API.G_FALSE );
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Update_Data;
242:
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get
245: (p_count => x_msg_count ,
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );

Line 247: p_encoded => FND_API.G_FALSE );

243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.count_and_get
245: (p_count => x_msg_count ,
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );
248: WHEN OTHERS THEN
249: ROLLBACK TO Update_Data;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.check_msg_level

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE );
248: WHEN OTHERS THEN
249: ROLLBACK TO Update_Data;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251: IF FND_MSG_PUB.check_msg_level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.add_exc_msg

Line 261: p_encoded => FND_API.G_FALSE );

257: END IF;
258: FND_MSG_PUB.count_and_get
259: (p_count => x_msg_count ,
260: p_data => x_msg_data ,
261: p_encoded => FND_API.G_FALSE );
262: END Update_Data;
263: END CN_SYSTEM_PARAMETERS_PVT;