[Home] [Help]
27: RAND_NUM_LENGTH number := 3;
28: l_length_expscn number;
29:
30: BEGIN
31: -- Standard Start of API savepoint
32: SAVEPOINT get_unique_name_for_component;
33:
34: -- Initialize API return status to success
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: x_name := l_obj_name || '_'|| l_msg_copy || l_unique_identifier;
80: end if;
81: -- ******* End of API body. ********
82:
83: -- Standard call to get message count and if count is 1, get message info.
84: FND_MSG_PUB.Count_And_Get
85: (p_count => x_msg_count ,
86: p_data => x_msg_data ,
87: p_encoded => FND_API.G_FALSE );
164:
165:
166: BEGIN
167:
168: -- Standard Start of API savepoint
169: SAVEPOINT convert_blob_to_clob;
170:
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call
167:
168: -- Standard Start of API savepoint
169: SAVEPOINT convert_blob_to_clob;
170:
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call
173: (l_api_version ,
174: p_api_version ,
175: l_api_name ,
196:
197: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;
198:
199: -- ******* End of API body. ********
200: -- Standard check of p_commit.
201: IF FND_API.To_Boolean( p_commit ) THEN
202: COMMIT WORK;
203: END IF;
204:
201: IF FND_API.To_Boolean( p_commit ) THEN
202: COMMIT WORK;
203: END IF;
204:
205: -- Standard call to get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get
207: (p_count => x_msg_count ,
208: p_data => x_msg_data ,
209: p_encoded => FND_API.G_FALSE );
258: l_xmltype xmltype;
259: l_clob clob;
260: BEGIN
261:
262: -- Standard Start of API savepoint
263: SAVEPOINT convert_clob_to_xmltype;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call
261:
262: -- Standard Start of API savepoint
263: SAVEPOINT convert_clob_to_xmltype;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call
267: (l_api_version ,
268: p_api_version ,
269: l_api_name ,
289:
290: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
291:
292: -- ******* End of API body. ********
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297:
294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297:
298: -- Standard call to get message count and if count is 1, get message info.
299: FND_MSG_PUB.Count_And_Get
300: (p_count => x_msg_count ,
301: p_data => x_msg_data ,
302: p_encoded => FND_API.G_FALSE );
351: l_msg_data VARCHAR2(2000);
352:
353: BEGIN
354:
355: -- Standard Start of API savepoint
356: SAVEPOINT convert_blob_to_xmltype;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call
354:
355: -- Standard Start of API savepoint
356: SAVEPOINT convert_blob_to_xmltype;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call
360: (l_api_version ,
361: p_api_version ,
362: l_api_name ,
410: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
411: END IF;
412:
413: -- ******* End of API body. ********
414: -- Standard check of p_commit.
415: IF FND_API.To_Boolean(p_commit) THEN
416: COMMIT WORK;
417: END IF;
418:
415: IF FND_API.To_Boolean(p_commit) THEN
416: COMMIT WORK;
417: END IF;
418:
419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: (p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE );