eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLANCOPY_UTIL_PVT dependencies on STANDARD

Line 31: -- Standard Start of API savepoint

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;

Line 83: -- Standard call to get message count and if count is 1, get message info.

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 );

Line 207: -- Standard Start of API savepoint

203:
204:
205: BEGIN
206:
207: -- Standard Start of API savepoint
208: SAVEPOINT convert_blob_to_clob;
209:
210: -- Standard call to check for call compatibility.
211: IF NOT FND_API.Compatible_API_Call

Line 210: -- Standard call to check for call compatibility.

206:
207: -- Standard Start of API savepoint
208: SAVEPOINT convert_blob_to_clob;
209:
210: -- Standard call to check for call compatibility.
211: IF NOT FND_API.Compatible_API_Call
212: (l_api_version ,
213: p_api_version ,
214: l_api_name ,

Line 248: -- Standard check of p_commit.

244:
245: update cn_copy_requests_all set file_content_clob = l_clob where EXP_IMP_REQUEST_ID = p_exp_imp_id;
246:
247: -- ******* End of API body. ********
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN
250: COMMIT WORK;
251: END IF;
252:

Line 253: -- Standard call to get message count and if count is 1, get message info.

249: IF FND_API.To_Boolean( p_commit ) THEN
250: COMMIT WORK;
251: END IF;
252:
253: -- Standard call to get message count and if count is 1, get message info.
254: FND_MSG_PUB.Count_And_Get
255: (p_count => x_msg_count ,
256: p_data => x_msg_data ,
257: p_encoded => FND_API.G_FALSE );

Line 310: -- Standard Start of API savepoint

306: l_xmltype xmltype;
307: l_clob clob;
308: BEGIN
309:
310: -- Standard Start of API savepoint
311: SAVEPOINT convert_clob_to_xmltype;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call

Line 313: -- Standard call to check for call compatibility.

309:
310: -- Standard Start of API savepoint
311: SAVEPOINT convert_clob_to_xmltype;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call
315: (l_api_version ,
316: p_api_version ,
317: l_api_name ,

Line 341: -- Standard check of p_commit.

337:
338: update cn_copy_requests_all set file_content_xmltype = l_xmltype where EXP_IMP_REQUEST_ID = p_exp_imp_id;
339:
340: -- ******* End of API body. ********
341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345:

Line 346: -- Standard call to get message count and if count is 1, get message info.

342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345:
346: -- Standard call to get message count and if count is 1, get message info.
347: FND_MSG_PUB.Count_And_Get
348: (p_count => x_msg_count ,
349: p_data => x_msg_data ,
350: p_encoded => FND_API.G_FALSE );

Line 403: -- Standard Start of API savepoint

399: l_msg_data VARCHAR2(2000);
400:
401: BEGIN
402:
403: -- Standard Start of API savepoint
404: SAVEPOINT convert_blob_to_xmltype;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call

Line 406: -- Standard call to check for call compatibility.

402:
403: -- Standard Start of API savepoint
404: SAVEPOINT convert_blob_to_xmltype;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call
408: (l_api_version ,
409: p_api_version ,
410: l_api_name ,

Line 462: -- Standard check of p_commit.

458: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460:
461: -- ******* End of API body. ********
462: -- Standard check of p_commit.
463: IF FND_API.To_Boolean(p_commit) THEN
464: COMMIT WORK;
465: END IF;
466:

Line 467: -- Standard call to get message count and if count is 1, get message info.

463: IF FND_API.To_Boolean(p_commit) THEN
464: COMMIT WORK;
465: END IF;
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get
469: (p_count => x_msg_count ,
470: p_data => x_msg_data ,
471: p_encoded => FND_API.G_FALSE );

Line 605: -- Standard Start of API savepoint

601: SELECT 1
602: FROM cn_calc_sql_exps
603: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT update_expression;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 608: -- Standard call to check for call compatibility.

604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT update_expression;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:

Line 795: -- Standard check of p_commit.

791: END IF;
792:
793: -- End of API body.
794:
795: -- Standard check of p_commit.
796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:

Line 800: -- Standard call to get message count and if count is 1, get message info.

796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
802: , p_encoded => fnd_api.g_false);
803: EXCEPTION
804: WHEN fnd_api.g_exc_error THEN