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_CALC_SQL_EXPS_PVT dependencies on FND_API

Line 53: RAISE fnd_api.g_exc_error;

49: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
50: fnd_msg_pub.ADD;
51: END IF;
52:
53: RAISE fnd_api.g_exc_error;
54: END IF;
55:
56: DECLARE
57: l_sql_statement VARCHAR2(4100);

Line 96: , p_encoded => fnd_api.g_false);

92: fnd_msg_pub.ADD;
93: END IF;
94:
95: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
96: , p_encoded => fnd_api.g_false);
97: END;
98:
99: IF (p_piped_sql_select IS NULL OR p_piped_sql_from IS NULL) THEN
100: RETURN;

Line 277: -- Default = FND_API.G_FALSE

273: -- Pre-reqs : None.
274: -- Parameters :
275: -- IN : p_api_version IN NUMBER Required
276: -- p_init_msg_list IN VARCHAR2 Optional
277: -- Default = FND_API.G_FALSE
278: -- p_commit IN VARCHAR2 Optional
279: -- Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional
281: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 279: -- Default = FND_API.G_FALSE

275: -- IN : p_api_version IN NUMBER Required
276: -- p_init_msg_list IN VARCHAR2 Optional
277: -- Default = FND_API.G_FALSE
278: -- p_commit IN VARCHAR2 Optional
279: -- Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional
281: -- Default = FND_API.G_VALID_LEVEL_FULL
282: -- p_name IN VARCHAR2 Required
283: -- p_description IN VARCHAR2 Optional

Line 281: -- Default = FND_API.G_VALID_LEVEL_FULL

277: -- Default = FND_API.G_FALSE
278: -- p_commit IN VARCHAR2 Optional
279: -- Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional
281: -- Default = FND_API.G_VALID_LEVEL_FULL
282: -- p_name IN VARCHAR2 Required
283: -- p_description IN VARCHAR2 Optional
284: -- Default = null
285: -- p_expression_disp IN VARCHAR2 Optional

Line 314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

310: --
311: -- End of comments
312: PROCEDURE create_expression(
313: p_api_version IN NUMBER
314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE

Line 315: , p_commit IN VARCHAR2 := fnd_api.g_false

311: -- End of comments
312: PROCEDURE create_expression(
313: p_api_version IN NUMBER
314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE
319: , p_description IN cn_calc_sql_exps.description%TYPE := NULL

Line 316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

312: PROCEDURE create_expression(
313: p_api_version IN NUMBER
314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE
319: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
320: , p_expression_disp IN VARCHAR2 := NULL

Line 355: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

351: -- Standard Start of API savepoint
352: SAVEPOINT create_expression;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 356: RAISE fnd_api.g_exc_unexpected_error;

352: SAVEPOINT create_expression;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 360: IF fnd_api.to_boolean(p_init_msg_list) THEN

356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF fnd_api.to_boolean(p_init_msg_list) THEN
361: fnd_msg_pub.initialize;
362: END IF;
363:
364: -- Initialize API return status to success

Line 365: x_return_status := fnd_api.g_ret_sts_success;

361: fnd_msg_pub.initialize;
362: END IF;
363:
364: -- Initialize API return status to success
365: x_return_status := fnd_api.g_ret_sts_success;
366:
367: -- API body
368: IF (p_name IS NULL) THEN
369: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 376: RAISE fnd_api.g_exc_error;

372: fnd_message.set_token('OBJ_NAME', l_prompt);
373: fnd_msg_pub.ADD;
374: END IF;
375:
376: RAISE fnd_api.g_exc_error;
377: END IF;
378:
379: OPEN exp_exists;
380: FETCH exp_exists INTO l_dummy;

Line 389: RAISE fnd_api.g_exc_error;

385: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
386: fnd_msg_pub.ADD;
387: END IF;
388:
389: RAISE fnd_api.g_exc_error;
390: END IF;
391:
392: -- make sure name isn't too long
393: IF LENGTH(p_name) > 30 THEN

Line 400: RAISE fnd_api.g_exc_error;

396: fnd_message.set_token('LENGTH', 30);
397: fnd_msg_pub.ADD;
398: END IF;
399:
400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: -- parse the expression and classify it into sub types
404: classify_expression(

Line 517: IF fnd_api.to_boolean(p_commit) THEN

513:
514: -- End of API body.
515:
516: -- Standard check of p_commit.
517: IF fnd_api.to_boolean(p_commit) THEN
518: COMMIT WORK;
519: END IF;
520:
521: -- Standard call to get message count and if count is 1, get message info.

Line 523: , p_encoded => fnd_api.g_false);

519: END IF;
520:
521: -- Standard call to get message count and if count is 1, get message info.
522: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
523: , p_encoded => fnd_api.g_false);
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO create_expression;
527: x_return_status := fnd_api.g_ret_sts_error;

Line 525: WHEN fnd_api.g_exc_error THEN

521: -- Standard call to get message count and if count is 1, get message info.
522: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
523: , p_encoded => fnd_api.g_false);
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO create_expression;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
529: , p_encoded => fnd_api.g_false);

Line 527: x_return_status := fnd_api.g_ret_sts_error;

523: , p_encoded => fnd_api.g_false);
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO create_expression;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
529: , p_encoded => fnd_api.g_false);
530: WHEN fnd_api.g_exc_unexpected_error THEN
531: ROLLBACK TO create_expression;

Line 529: , p_encoded => fnd_api.g_false);

525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO create_expression;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
529: , p_encoded => fnd_api.g_false);
530: WHEN fnd_api.g_exc_unexpected_error THEN
531: ROLLBACK TO create_expression;
532: x_return_status := fnd_api.g_ret_sts_unexp_error;
533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 530: WHEN fnd_api.g_exc_unexpected_error THEN

526: ROLLBACK TO create_expression;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
529: , p_encoded => fnd_api.g_false);
530: WHEN fnd_api.g_exc_unexpected_error THEN
531: ROLLBACK TO create_expression;
532: x_return_status := fnd_api.g_ret_sts_unexp_error;
533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
534: , p_encoded => fnd_api.g_false);

Line 532: x_return_status := fnd_api.g_ret_sts_unexp_error;

528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
529: , p_encoded => fnd_api.g_false);
530: WHEN fnd_api.g_exc_unexpected_error THEN
531: ROLLBACK TO create_expression;
532: x_return_status := fnd_api.g_ret_sts_unexp_error;
533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
534: , p_encoded => fnd_api.g_false);
535: WHEN OTHERS THEN
536: ROLLBACK TO create_expression;

Line 534: , p_encoded => fnd_api.g_false);

530: WHEN fnd_api.g_exc_unexpected_error THEN
531: ROLLBACK TO create_expression;
532: x_return_status := fnd_api.g_ret_sts_unexp_error;
533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
534: , p_encoded => fnd_api.g_false);
535: WHEN OTHERS THEN
536: ROLLBACK TO create_expression;
537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:

Line 537: x_return_status := fnd_api.g_ret_sts_unexp_error;

533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
534: , p_encoded => fnd_api.g_false);
535: WHEN OTHERS THEN
536: ROLLBACK TO create_expression;
537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:
539: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
540: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
541: END IF;

Line 544: , p_encoded => fnd_api.g_false);

540: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
541: END IF;
542:
543: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
544: , p_encoded => fnd_api.g_false);
545: END create_expression;
546:
547: -- Start of comments
548: -- API name : Update_Expressions

Line 555: -- Default = FND_API.G_FALSE

551: -- Pre-reqs : None.
552: -- Parameters :
553: -- IN : p_api_version IN NUMBER Required
554: -- p_init_msg_list IN VARCHAR2 Optional
555: -- Default = FND_API.G_FALSE
556: -- p_commit IN VARCHAR2 Optional
557: -- Default = FND_API.G_FALSE
558: -- p_validation_level IN NUMBER Optional
559: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 557: -- Default = FND_API.G_FALSE

553: -- IN : p_api_version IN NUMBER Required
554: -- p_init_msg_list IN VARCHAR2 Optional
555: -- Default = FND_API.G_FALSE
556: -- p_commit IN VARCHAR2 Optional
557: -- Default = FND_API.G_FALSE
558: -- p_validation_level IN NUMBER Optional
559: -- Default = FND_API.G_VALID_LEVEL_FULL
560: -- p_update_parent_also IN VARCHAR2 Optional
561: -- Default = FND_API.G_FALSE

Line 559: -- Default = FND_API.G_VALID_LEVEL_FULL

555: -- Default = FND_API.G_FALSE
556: -- p_commit IN VARCHAR2 Optional
557: -- Default = FND_API.G_FALSE
558: -- p_validation_level IN NUMBER Optional
559: -- Default = FND_API.G_VALID_LEVEL_FULL
560: -- p_update_parent_also IN VARCHAR2 Optional
561: -- Default = FND_API.G_FALSE
562: -- p_calc_sql_exp_id IN NUMBER Required
563: -- p_name IN VARCHAR2 Required

Line 561: -- Default = FND_API.G_FALSE

557: -- Default = FND_API.G_FALSE
558: -- p_validation_level IN NUMBER Optional
559: -- Default = FND_API.G_VALID_LEVEL_FULL
560: -- p_update_parent_also IN VARCHAR2 Optional
561: -- Default = FND_API.G_FALSE
562: -- p_calc_sql_exp_id IN NUMBER Required
563: -- p_name IN VARCHAR2 Required
564: -- p_description IN VARCHAR2 Optional
565: -- Default = null

Line 596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

592: --
593: -- End of comments
594: PROCEDURE update_expression(
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

Line 597: , p_commit IN VARCHAR2 := fnd_api.g_false

593: -- End of comments
594: PROCEDURE update_expression(
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

Line 598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

594: PROCEDURE update_expression(
595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE

Line 599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false

595: p_api_version IN NUMBER
596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE
603: , p_description IN cn_calc_sql_exps.description%TYPE := NULL

Line 662: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

658: -- Standard Start of API savepoint
659: SAVEPOINT update_expression;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:
666: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 663: RAISE fnd_api.g_exc_unexpected_error;

659: SAVEPOINT update_expression;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:
666: -- Initialize message list if p_init_msg_list is set to TRUE.
667: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 667: IF fnd_api.to_boolean(p_init_msg_list) THEN

663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:
666: -- Initialize message list if p_init_msg_list is set to TRUE.
667: IF fnd_api.to_boolean(p_init_msg_list) THEN
668: fnd_msg_pub.initialize;
669: END IF;
670:
671: -- Initialize API return status to success

Line 672: x_return_status := fnd_api.g_ret_sts_success;

668: fnd_msg_pub.initialize;
669: END IF;
670:
671: -- Initialize API return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: -- API body
675: IF (p_name IS NULL) THEN
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 683: RAISE fnd_api.g_exc_error;

679: fnd_message.set_token('OBJ_NAME', l_prompt);
680: fnd_msg_pub.ADD;
681: END IF;
682:
683: RAISE fnd_api.g_exc_error;
684: END IF;
685:
686: OPEN exp_exists;
687: FETCH exp_exists INTO l_dummy;

Line 696: RAISE fnd_api.g_exc_error;

692: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
693: fnd_msg_pub.ADD;
694: END IF;
695:
696: RAISE fnd_api.g_exc_error;
697: END IF;
698:
699: -- see if expression is in use
700: OPEN parent_exist;

Line 710: RAISE fnd_api.g_exc_error;

706: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
707: fnd_msg_pub.ADD;
708: END IF;
709:
710: RAISE fnd_api.g_exc_error;
711: END IF;
712:
713: -- parse the expression and classify it into sub types
714: classify_expression(

Line 862: IF (fnd_api.to_boolean(p_update_parent_also)) THEN

858:
859: --END IF;
860:
861: -- update parent expressions and formulas also
862: IF (fnd_api.to_boolean(p_update_parent_also)) THEN
863: NULL;
864: END IF;
865:
866: -- End of API body.

Line 869: IF fnd_api.to_boolean(p_commit) THEN

865:
866: -- End of API body.
867:
868: -- Standard check of p_commit.
869: IF fnd_api.to_boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:
873: -- Standard call to get message count and if count is 1, get message info.

Line 875: , p_encoded => fnd_api.g_false);

871: END IF;
872:
873: -- Standard call to get message count and if count is 1, get message info.
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
875: , p_encoded => fnd_api.g_false);
876: EXCEPTION
877: WHEN fnd_api.g_exc_error THEN
878: ROLLBACK TO update_expression;
879: x_return_status := fnd_api.g_ret_sts_error;

Line 877: WHEN fnd_api.g_exc_error THEN

873: -- Standard call to get message count and if count is 1, get message info.
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
875: , p_encoded => fnd_api.g_false);
876: EXCEPTION
877: WHEN fnd_api.g_exc_error THEN
878: ROLLBACK TO update_expression;
879: x_return_status := fnd_api.g_ret_sts_error;
880: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
881: , p_encoded => fnd_api.g_false);

Line 879: x_return_status := fnd_api.g_ret_sts_error;

875: , p_encoded => fnd_api.g_false);
876: EXCEPTION
877: WHEN fnd_api.g_exc_error THEN
878: ROLLBACK TO update_expression;
879: x_return_status := fnd_api.g_ret_sts_error;
880: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
881: , p_encoded => fnd_api.g_false);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: ROLLBACK TO update_expression;

Line 881: , p_encoded => fnd_api.g_false);

877: WHEN fnd_api.g_exc_error THEN
878: ROLLBACK TO update_expression;
879: x_return_status := fnd_api.g_ret_sts_error;
880: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
881: , p_encoded => fnd_api.g_false);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: ROLLBACK TO update_expression;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;
885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 882: WHEN fnd_api.g_exc_unexpected_error THEN

878: ROLLBACK TO update_expression;
879: x_return_status := fnd_api.g_ret_sts_error;
880: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
881: , p_encoded => fnd_api.g_false);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: ROLLBACK TO update_expression;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;
885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
886: , p_encoded => fnd_api.g_false);

Line 884: x_return_status := fnd_api.g_ret_sts_unexp_error;

880: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
881: , p_encoded => fnd_api.g_false);
882: WHEN fnd_api.g_exc_unexpected_error THEN
883: ROLLBACK TO update_expression;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;
885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
886: , p_encoded => fnd_api.g_false);
887: WHEN OTHERS THEN
888: ROLLBACK TO update_expression;

Line 886: , p_encoded => fnd_api.g_false);

882: WHEN fnd_api.g_exc_unexpected_error THEN
883: ROLLBACK TO update_expression;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;
885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
886: , p_encoded => fnd_api.g_false);
887: WHEN OTHERS THEN
888: ROLLBACK TO update_expression;
889: x_return_status := fnd_api.g_ret_sts_unexp_error;
890:

Line 889: x_return_status := fnd_api.g_ret_sts_unexp_error;

885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
886: , p_encoded => fnd_api.g_false);
887: WHEN OTHERS THEN
888: ROLLBACK TO update_expression;
889: x_return_status := fnd_api.g_ret_sts_unexp_error;
890:
891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
892: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
893: END IF;

Line 896: , p_encoded => fnd_api.g_false);

892: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
893: END IF;
894:
895: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
896: , p_encoded => fnd_api.g_false);
897: END update_expression;
898:
899: -- Start of comments
900: -- API name : Delete_Expression

Line 907: -- Default = FND_API.G_FALSE

903: -- Pre-reqs : None.
904: -- Parameters :
905: -- IN : p_api_version IN NUMBER Required
906: -- p_init_msg_list IN VARCHAR2 Optional
907: -- Default = FND_API.G_FALSE
908: -- p_commit IN VARCHAR2 Optional
909: -- Default = FND_API.G_FALSE
910: -- p_validation_level IN NUMBER Optional
911: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 909: -- Default = FND_API.G_FALSE

905: -- IN : p_api_version IN NUMBER Required
906: -- p_init_msg_list IN VARCHAR2 Optional
907: -- Default = FND_API.G_FALSE
908: -- p_commit IN VARCHAR2 Optional
909: -- Default = FND_API.G_FALSE
910: -- p_validation_level IN NUMBER Optional
911: -- Default = FND_API.G_VALID_LEVEL_FULL
912: -- p_calc_sql_exp_id IN NUMBER
913: -- OUT : x_return_status OUT VARCHAR2(1)

Line 911: -- Default = FND_API.G_VALID_LEVEL_FULL

907: -- Default = FND_API.G_FALSE
908: -- p_commit IN VARCHAR2 Optional
909: -- Default = FND_API.G_FALSE
910: -- p_validation_level IN NUMBER Optional
911: -- Default = FND_API.G_VALID_LEVEL_FULL
912: -- p_calc_sql_exp_id IN NUMBER
913: -- OUT : x_return_status OUT VARCHAR2(1)
914: -- x_msg_count OUT NUMBER
915: -- x_msg_data OUT VARCHAR2(4000)

Line 926: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

922: --
923: -- End of comments
924: PROCEDURE delete_expression(
925: p_api_version IN NUMBER
926: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
927: , p_commit IN VARCHAR2 := fnd_api.g_false
928: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
929: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
930: , x_return_status OUT NOCOPY VARCHAR2

Line 927: , p_commit IN VARCHAR2 := fnd_api.g_false

923: -- End of comments
924: PROCEDURE delete_expression(
925: p_api_version IN NUMBER
926: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
927: , p_commit IN VARCHAR2 := fnd_api.g_false
928: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
929: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
930: , x_return_status OUT NOCOPY VARCHAR2
931: , x_msg_count OUT NOCOPY NUMBER

Line 928: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

924: PROCEDURE delete_expression(
925: p_api_version IN NUMBER
926: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
927: , p_commit IN VARCHAR2 := fnd_api.g_false
928: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
929: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
930: , x_return_status OUT NOCOPY VARCHAR2
931: , x_msg_count OUT NOCOPY NUMBER
932: , x_msg_data OUT NOCOPY VARCHAR2

Line 964: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

960: -- Standard Start of API savepoint
961: SAVEPOINT delete_expression;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 965: RAISE fnd_api.g_exc_unexpected_error;

961: SAVEPOINT delete_expression;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 969: IF fnd_api.to_boolean(p_init_msg_list) THEN

965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF fnd_api.to_boolean(p_init_msg_list) THEN
970: fnd_msg_pub.initialize;
971: END IF;
972:
973: -- Initialize API return status to success

Line 974: x_return_status := fnd_api.g_ret_sts_success;

970: fnd_msg_pub.initialize;
971: END IF;
972:
973: -- Initialize API return status to success
974: x_return_status := fnd_api.g_ret_sts_success;
975:
976: -- API body
977: OPEN parent_exist;
978: FETCH parent_exist INTO l_dummy;

Line 987: RAISE fnd_api.g_exc_error;

983: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
984: fnd_msg_pub.ADD;
985: END IF;
986:
987: RAISE fnd_api.g_exc_error;
988: END IF;
989:
990: cn_calc_sql_exps_pkg.delete_row(x_calc_sql_exp_id => p_calc_sql_exp_id);
991:

Line 1000: IF fnd_api.to_boolean(p_commit) THEN

996:
997: -- End of API body.
998:
999: -- Standard check of p_commit.
1000: IF fnd_api.to_boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:
1004: -- Standard call to get message count and if count is 1, get message info.

Line 1006: , p_encoded => fnd_api.g_false);

1002: END IF;
1003:
1004: -- Standard call to get message count and if count is 1, get message info.
1005: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1006: , p_encoded => fnd_api.g_false);
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error THEN
1009: ROLLBACK TO delete_expression;
1010: x_return_status := fnd_api.g_ret_sts_error;

Line 1008: WHEN fnd_api.g_exc_error THEN

1004: -- Standard call to get message count and if count is 1, get message info.
1005: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1006: , p_encoded => fnd_api.g_false);
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error THEN
1009: ROLLBACK TO delete_expression;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1012: , p_encoded => fnd_api.g_false);

Line 1010: x_return_status := fnd_api.g_ret_sts_error;

1006: , p_encoded => fnd_api.g_false);
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error THEN
1009: ROLLBACK TO delete_expression;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1012: , p_encoded => fnd_api.g_false);
1013: WHEN fnd_api.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_expression;

Line 1012: , p_encoded => fnd_api.g_false);

1008: WHEN fnd_api.g_exc_error THEN
1009: ROLLBACK TO delete_expression;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1012: , p_encoded => fnd_api.g_false);
1013: WHEN fnd_api.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_expression;
1015: x_return_status := fnd_api.g_ret_sts_unexp_error;
1016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1013: WHEN fnd_api.g_exc_unexpected_error THEN

1009: ROLLBACK TO delete_expression;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1012: , p_encoded => fnd_api.g_false);
1013: WHEN fnd_api.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_expression;
1015: x_return_status := fnd_api.g_ret_sts_unexp_error;
1016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1017: , p_encoded => fnd_api.g_false);

Line 1015: x_return_status := fnd_api.g_ret_sts_unexp_error;

1011: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1012: , p_encoded => fnd_api.g_false);
1013: WHEN fnd_api.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_expression;
1015: x_return_status := fnd_api.g_ret_sts_unexp_error;
1016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1017: , p_encoded => fnd_api.g_false);
1018: WHEN OTHERS THEN
1019: ROLLBACK TO delete_expression;

Line 1017: , p_encoded => fnd_api.g_false);

1013: WHEN fnd_api.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_expression;
1015: x_return_status := fnd_api.g_ret_sts_unexp_error;
1016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1017: , p_encoded => fnd_api.g_false);
1018: WHEN OTHERS THEN
1019: ROLLBACK TO delete_expression;
1020: x_return_status := fnd_api.g_ret_sts_unexp_error;
1021:

Line 1020: x_return_status := fnd_api.g_ret_sts_unexp_error;

1016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1017: , p_encoded => fnd_api.g_false);
1018: WHEN OTHERS THEN
1019: ROLLBACK TO delete_expression;
1020: x_return_status := fnd_api.g_ret_sts_unexp_error;
1021:
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1024: END IF;

Line 1027: , p_encoded => fnd_api.g_false);

1023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1024: END IF;
1025:
1026: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1027: , p_encoded => fnd_api.g_false);
1028: END delete_expression;
1029:
1030: /*-- Start of comments
1031: -- API name : Get_Parent_Expressions

Line 1038: -- Default = FND_API.G_FALSE

1034: -- Pre-reqs : None.
1035: -- Parameters :
1036: -- IN : p_api_version IN NUMBER Required
1037: -- p_init_msg_list IN VARCHAR2 Optional
1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1040: -- Default = FND_API.G_FALSE

1036: -- IN : p_api_version IN NUMBER Required
1037: -- p_init_msg_list IN VARCHAR2 Optional
1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL
1043: -- p_calc_sql_exp_id IN NUMBER
1044: -- OUT : x_parents_tbl OUT expression_tbl_type

Line 1042: -- Default = FND_API.G_VALID_LEVEL_FULL

1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL
1043: -- p_calc_sql_exp_id IN NUMBER
1044: -- OUT : x_parents_tbl OUT expression_tbl_type
1045: -- x_return_status OUT VARCHAR2(1)
1046: -- x_msg_count OUT NUMBER

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

1052: --
1053: -- End of comments
1054: PROCEDURE Get_Parent_Expressions
1055: (p_api_version IN NUMBER ,
1056: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1057: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1058: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1059: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1060: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,

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

1053: -- End of comments
1054: PROCEDURE Get_Parent_Expressions
1055: (p_api_version IN NUMBER ,
1056: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1057: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1058: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1059: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1060: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,
1061: x_return_status OUT NOCOPY VARCHAR2 ,

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

1054: PROCEDURE Get_Parent_Expressions
1055: (p_api_version IN NUMBER ,
1056: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1057: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1058: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1059: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1060: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,
1061: x_return_status OUT NOCOPY VARCHAR2 ,
1062: x_msg_count OUT NOCOPY NUMBER ,

Line 1099: IF NOT FND_API.Compatible_API_Call

1095: OR f_calc_sql_exp_id = p_calc_sql_exp_id));
1096:
1097: BEGIN
1098: -- Standard call to check for call compatibility.
1099: IF NOT FND_API.Compatible_API_Call
1100: (l_api_version ,
1101: p_api_version ,
1102: l_api_name ,
1103: G_PKG_NAME )

Line 1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1101: p_api_version ,
1102: l_api_name ,
1103: G_PKG_NAME )
1104: THEN
1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1106: END IF;
1107: -- Initialize message list if p_init_msg_list is set to TRUE.
1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1109: FND_MSG_PUB.initialize;

Line 1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1104: THEN
1105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1106: END IF;
1107: -- Initialize message list if p_init_msg_list is set to TRUE.
1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1109: FND_MSG_PUB.initialize;
1110: END IF;
1111: -- Initialize API return status to success
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

1108: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1109: FND_MSG_PUB.initialize;
1110: END IF;
1111: -- Initialize API return status to success
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: -- API body
1115: FOR parent_name IN parent_names LOOP
1116: x_parents_tbl(i) := parent_name.name;

Line 1123: IF FND_API.To_Boolean( p_commit ) THEN

1119:
1120: -- End of API body.
1121:
1122: -- Standard check of p_commit.
1123: IF FND_API.To_Boolean( p_commit ) THEN
1124: COMMIT WORK;
1125: END IF;
1126: -- Standard call to get message count and if count is 1, get message info.
1127: FND_MSG_PUB.count_and_get

Line 1130: p_encoded => FND_API.G_FALSE );

1126: -- Standard call to get message count and if count is 1, get message info.
1127: FND_MSG_PUB.count_and_get
1128: (p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE );
1131: EXCEPTION
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: FND_MSG_PUB.count_and_get

Line 1132: WHEN FND_API.G_EXC_ERROR THEN

1128: (p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE );
1131: EXCEPTION
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: FND_MSG_PUB.count_and_get
1135: (p_count => x_msg_count ,
1136: p_data => x_msg_data ,

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR ;

1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE );
1131: EXCEPTION
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: FND_MSG_PUB.count_and_get
1135: (p_count => x_msg_count ,
1136: p_data => x_msg_data ,
1137: p_encoded => FND_API.G_FALSE );

Line 1137: p_encoded => FND_API.G_FALSE );

1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: FND_MSG_PUB.count_and_get
1135: (p_count => x_msg_count ,
1136: p_data => x_msg_data ,
1137: p_encoded => FND_API.G_FALSE );
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140: FND_MSG_PUB.count_and_get
1141: (p_count => x_msg_count ,

Line 1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1134: FND_MSG_PUB.count_and_get
1135: (p_count => x_msg_count ,
1136: p_data => x_msg_data ,
1137: p_encoded => FND_API.G_FALSE );
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140: FND_MSG_PUB.count_and_get
1141: (p_count => x_msg_count ,
1142: p_data => x_msg_data ,

Line 1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1135: (p_count => x_msg_count ,
1136: p_data => x_msg_data ,
1137: p_encoded => FND_API.G_FALSE );
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140: FND_MSG_PUB.count_and_get
1141: (p_count => x_msg_count ,
1142: p_data => x_msg_data ,
1143: p_encoded => FND_API.G_FALSE );

Line 1143: p_encoded => FND_API.G_FALSE );

1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140: FND_MSG_PUB.count_and_get
1141: (p_count => x_msg_count ,
1142: p_data => x_msg_data ,
1143: p_encoded => FND_API.G_FALSE );
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: IF FND_MSG_PUB.check_msg_level
1147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1141: (p_count => x_msg_count ,
1142: p_data => x_msg_data ,
1143: p_encoded => FND_API.G_FALSE );
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: IF FND_MSG_PUB.check_msg_level
1147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1148: THEN
1149: FND_MSG_PUB.add_exc_msg

Line 1156: p_encoded => FND_API.G_FALSE );

1152: END IF;
1153: FND_MSG_PUB.count_and_get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: END Get_Parent_Expressions; */
1158:
1159: /* PROCEDURE get_expr_summary
1160: (p_first IN NUMBER,

Line 1541: RAISE fnd_api.g_exc_error;

1537: BEGIN
1538: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1539: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1540: fnd_msg_pub.ADD;
1541: RAISE fnd_api.g_exc_error;
1542: END IF;
1543:
1544: IF p_node_type = 'P' THEN
1545: IF p_level > 0 THEN

Line 1586: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1582: -- elements referenced directly or indirectly
1583: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
1584: PROCEDURE get_dependent_plan_elts(
1585: p_api_version IN NUMBER
1586: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1587: , p_commit IN VARCHAR2 := fnd_api.g_false
1588: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1589: , p_node_type IN VARCHAR2
1590: , p_node_id IN NUMBER

Line 1587: , p_commit IN VARCHAR2 := fnd_api.g_false

1583: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
1584: PROCEDURE get_dependent_plan_elts(
1585: p_api_version IN NUMBER
1586: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1587: , p_commit IN VARCHAR2 := fnd_api.g_false
1588: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1589: , p_node_type IN VARCHAR2
1590: , p_node_id IN NUMBER
1591: , x_plan_elt_id_tbl OUT NOCOPY num_tbl_type

Line 1588: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1584: PROCEDURE get_dependent_plan_elts(
1585: p_api_version IN NUMBER
1586: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1587: , p_commit IN VARCHAR2 := fnd_api.g_false
1588: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1589: , p_node_type IN VARCHAR2
1590: , p_node_id IN NUMBER
1591: , x_plan_elt_id_tbl OUT NOCOPY num_tbl_type
1592: , x_return_status OUT NOCOPY VARCHAR2

Line 1600: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1596: l_api_name CONSTANT VARCHAR2(30) := 'get_dependent_plan_elts';
1597: l_api_version CONSTANT NUMBER := 1.0;
1598: BEGIN
1599: -- Standard call to check for call compatibility.
1600: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1601: RAISE fnd_api.g_exc_unexpected_error;
1602: END IF;
1603:
1604: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1601: RAISE fnd_api.g_exc_unexpected_error;

1597: l_api_version CONSTANT NUMBER := 1.0;
1598: BEGIN
1599: -- Standard call to check for call compatibility.
1600: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1601: RAISE fnd_api.g_exc_unexpected_error;
1602: END IF;
1603:
1604: -- Initialize message list if p_init_msg_list is set to TRUE.
1605: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1605: IF fnd_api.to_boolean(p_init_msg_list) THEN

1601: RAISE fnd_api.g_exc_unexpected_error;
1602: END IF;
1603:
1604: -- Initialize message list if p_init_msg_list is set to TRUE.
1605: IF fnd_api.to_boolean(p_init_msg_list) THEN
1606: fnd_msg_pub.initialize;
1607: END IF;
1608:
1609: -- Initialize API return status to success

Line 1610: x_return_status := fnd_api.g_ret_sts_success;

1606: fnd_msg_pub.initialize;
1607: END IF;
1608:
1609: -- Initialize API return status to success
1610: x_return_status := fnd_api.g_ret_sts_success;
1611: -- API body
1612: dfs(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1613:
1614: -- Standard check of p_commit.

Line 1615: IF fnd_api.to_boolean(p_commit) THEN

1611: -- API body
1612: dfs(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1613:
1614: -- Standard check of p_commit.
1615: IF fnd_api.to_boolean(p_commit) THEN
1616: COMMIT WORK;
1617: END IF;
1618:
1619: -- Standard call to get message count and if count is 1, get message info.

Line 1621: , p_encoded => fnd_api.g_false);

1617: END IF;
1618:
1619: -- Standard call to get message count and if count is 1, get message info.
1620: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1621: , p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error THEN
1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1623: WHEN fnd_api.g_exc_error THEN

1619: -- Standard call to get message count and if count is 1, get message info.
1620: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1621: , p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error THEN
1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1624: x_return_status := fnd_api.g_ret_sts_error;

1620: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1621: , p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error THEN
1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1626: , p_encoded => fnd_api.g_false);

1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error THEN
1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1630: , p_encoded => fnd_api.g_false);

Line 1627: WHEN fnd_api.g_exc_unexpected_error THEN

1623: WHEN fnd_api.g_exc_error THEN
1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1630: , p_encoded => fnd_api.g_false);
1631: WHEN OTHERS THEN

Line 1628: x_return_status := fnd_api.g_ret_sts_unexp_error;

1624: x_return_status := fnd_api.g_ret_sts_error;
1625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1630: , p_encoded => fnd_api.g_false);
1631: WHEN OTHERS THEN
1632: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1630: , p_encoded => fnd_api.g_false);

1626: , p_encoded => fnd_api.g_false);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1630: , p_encoded => fnd_api.g_false);
1631: WHEN OTHERS THEN
1632: x_return_status := fnd_api.g_ret_sts_unexp_error;
1633:
1634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1632: x_return_status := fnd_api.g_ret_sts_unexp_error;

1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1630: , p_encoded => fnd_api.g_false);
1631: WHEN OTHERS THEN
1632: x_return_status := fnd_api.g_ret_sts_unexp_error;
1633:
1634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1635: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1636: END IF;

Line 1639: , p_encoded => fnd_api.g_false);

1635: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1636: END IF;
1637:
1638: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1639: , p_encoded => fnd_api.g_false);
1640: END get_dependent_plan_elts;
1641:
1642: -- private procedure used in get_parent_plan_elts
1643: PROCEDURE dfs2(

Line 1683: RAISE fnd_api.g_exc_error;

1679: BEGIN
1680: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1681: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1682: fnd_msg_pub.ADD;
1683: RAISE fnd_api.g_exc_error;
1684: END IF;
1685:
1686: IF p_node_type = 'P' THEN
1687: -- Don't return the root as a dependence

Line 1726: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1722: -- elements that reference it directly or indirectly
1723: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
1724: PROCEDURE get_parent_plan_elts(
1725: p_api_version IN NUMBER
1726: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1727: , p_commit IN VARCHAR2 := fnd_api.g_false
1728: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1729: , p_node_type IN VARCHAR2
1730: , p_node_id IN NUMBER

Line 1727: , p_commit IN VARCHAR2 := fnd_api.g_false

1723: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
1724: PROCEDURE get_parent_plan_elts(
1725: p_api_version IN NUMBER
1726: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1727: , p_commit IN VARCHAR2 := fnd_api.g_false
1728: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1729: , p_node_type IN VARCHAR2
1730: , p_node_id IN NUMBER
1731: , x_plan_elt_id_tbl OUT NOCOPY num_tbl_type

Line 1728: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1724: PROCEDURE get_parent_plan_elts(
1725: p_api_version IN NUMBER
1726: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1727: , p_commit IN VARCHAR2 := fnd_api.g_false
1728: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1729: , p_node_type IN VARCHAR2
1730: , p_node_id IN NUMBER
1731: , x_plan_elt_id_tbl OUT NOCOPY num_tbl_type
1732: , x_return_status OUT NOCOPY VARCHAR2

Line 1740: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1736: l_api_name CONSTANT VARCHAR2(30) := 'get_parent_plan_elts';
1737: l_api_version CONSTANT NUMBER := 1.0;
1738: BEGIN
1739: -- Standard call to check for call compatibility.
1740: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1741: RAISE fnd_api.g_exc_unexpected_error;

1737: l_api_version CONSTANT NUMBER := 1.0;
1738: BEGIN
1739: -- Standard call to check for call compatibility.
1740: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1745: IF fnd_api.to_boolean(p_init_msg_list) THEN

1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF fnd_api.to_boolean(p_init_msg_list) THEN
1746: fnd_msg_pub.initialize;
1747: END IF;
1748:
1749: -- Initialize API return status to success

Line 1750: x_return_status := fnd_api.g_ret_sts_success;

1746: fnd_msg_pub.initialize;
1747: END IF;
1748:
1749: -- Initialize API return status to success
1750: x_return_status := fnd_api.g_ret_sts_success;
1751: -- API body
1752: dfs2(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1753:
1754: -- Standard check of p_commit.

Line 1755: IF fnd_api.to_boolean(p_commit) THEN

1751: -- API body
1752: dfs2(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1753:
1754: -- Standard check of p_commit.
1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:
1759: -- Standard call to get message count and if count is 1, get message info.

Line 1761: , p_encoded => fnd_api.g_false);

1757: END IF;
1758:
1759: -- Standard call to get message count and if count is 1, get message info.
1760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1761: , p_encoded => fnd_api.g_false);
1762: EXCEPTION
1763: WHEN fnd_api.g_exc_error THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1763: WHEN fnd_api.g_exc_error THEN

1759: -- Standard call to get message count and if count is 1, get message info.
1760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1761: , p_encoded => fnd_api.g_false);
1762: EXCEPTION
1763: WHEN fnd_api.g_exc_error THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1764: x_return_status := fnd_api.g_ret_sts_error;

1760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1761: , p_encoded => fnd_api.g_false);
1762: EXCEPTION
1763: WHEN fnd_api.g_exc_error THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN
1768: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1766: , p_encoded => fnd_api.g_false);

1762: EXCEPTION
1763: WHEN fnd_api.g_exc_error THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN
1768: x_return_status := fnd_api.g_ret_sts_unexp_error;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1770: , p_encoded => fnd_api.g_false);

Line 1767: WHEN fnd_api.g_exc_unexpected_error THEN

1763: WHEN fnd_api.g_exc_error THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN
1768: x_return_status := fnd_api.g_ret_sts_unexp_error;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1770: , p_encoded => fnd_api.g_false);
1771: WHEN OTHERS THEN

Line 1768: x_return_status := fnd_api.g_ret_sts_unexp_error;

1764: x_return_status := fnd_api.g_ret_sts_error;
1765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN
1768: x_return_status := fnd_api.g_ret_sts_unexp_error;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1770: , p_encoded => fnd_api.g_false);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1770: , p_encoded => fnd_api.g_false);

1766: , p_encoded => fnd_api.g_false);
1767: WHEN fnd_api.g_exc_unexpected_error THEN
1768: x_return_status := fnd_api.g_ret_sts_unexp_error;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1770: , p_encoded => fnd_api.g_false);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773:
1774: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1772: x_return_status := fnd_api.g_ret_sts_unexp_error;

1768: x_return_status := fnd_api.g_ret_sts_unexp_error;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1770: , p_encoded => fnd_api.g_false);
1771: WHEN OTHERS THEN
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773:
1774: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1775: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1776: END IF;

Line 1779: , p_encoded => fnd_api.g_false);

1775: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1776: END IF;
1777:
1778: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1779: , p_encoded => fnd_api.g_false);
1780: END get_parent_plan_elts;
1781:
1782: PROCEDURE parse_sql_select(
1783: p_api_version IN NUMBER

Line 1784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1780: END get_parent_plan_elts;
1781:
1782: PROCEDURE parse_sql_select(
1783: p_api_version IN NUMBER
1784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1785: , p_commit IN VARCHAR2 := fnd_api.g_false
1786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1787: , p_sql_select IN OUT NOCOPY VARCHAR2
1788: , x_piped_sql_select OUT NOCOPY VARCHAR2

Line 1785: , p_commit IN VARCHAR2 := fnd_api.g_false

1781:
1782: PROCEDURE parse_sql_select(
1783: p_api_version IN NUMBER
1784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1785: , p_commit IN VARCHAR2 := fnd_api.g_false
1786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1787: , p_sql_select IN OUT NOCOPY VARCHAR2
1788: , x_piped_sql_select OUT NOCOPY VARCHAR2
1789: , x_expr_disp OUT NOCOPY VARCHAR2

Line 1786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1782: PROCEDURE parse_sql_select(
1783: p_api_version IN NUMBER
1784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1785: , p_commit IN VARCHAR2 := fnd_api.g_false
1786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1787: , p_sql_select IN OUT NOCOPY VARCHAR2
1788: , x_piped_sql_select OUT NOCOPY VARCHAR2
1789: , x_expr_disp OUT NOCOPY VARCHAR2
1790: , x_piped_expr_disp OUT NOCOPY VARCHAR2

Line 1890: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1886: FROM user_objects
1887: WHERE object_type = 'FUNCTION' AND status = 'VALID';
1888: BEGIN
1889: -- Standard call to check for call compatibility.
1890: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893:
1894: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1891: RAISE fnd_api.g_exc_unexpected_error;

1887: WHERE object_type = 'FUNCTION' AND status = 'VALID';
1888: BEGIN
1889: -- Standard call to check for call compatibility.
1890: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893:
1894: -- Initialize message list if p_init_msg_list is set to TRUE.
1895: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1895: IF fnd_api.to_boolean(p_init_msg_list) THEN

1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893:
1894: -- Initialize message list if p_init_msg_list is set to TRUE.
1895: IF fnd_api.to_boolean(p_init_msg_list) THEN
1896: fnd_msg_pub.initialize;
1897: END IF;
1898:
1899: -- Initialize API return status to success

Line 1900: x_return_status := fnd_api.g_ret_sts_success;

1896: fnd_msg_pub.initialize;
1897: END IF;
1898:
1899: -- Initialize API return status to success
1900: x_return_status := fnd_api.g_ret_sts_success;
1901: -- translate RateResult and ForecastAmount
1902: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');
1903: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');
1904:

Line 1945: RAISE fnd_api.g_exc_error;

1941:
1942: IF l_ix = 0 THEN
1943: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
1944: fnd_msg_pub.ADD;
1945: RAISE fnd_api.g_exc_error;
1946: END IF;
1947:
1948: x_piped_sql_select := x_piped_sql_select || SUBSTR(l_sql_select_left, 1, l_ix) || '|';
1949: x_piped_expr_disp := x_piped_expr_disp || SUBSTR(l_sql_select_left, 1, l_ix) || '|';

Line 2035: RAISE fnd_api.g_exc_error;

2031:
2032: IF l_disp_seg IS NULL THEN
2033: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2034: fnd_msg_pub.ADD;
2035: RAISE fnd_api.g_exc_error;
2036: END IF;
2037:
2038: -- add to sql from
2039: IF (x_piped_sql_from IS NULL OR INSTR(x_piped_sql_from, l_table_name) = 0) THEN

Line 2064: RAISE fnd_api.g_exc_error;

2060:
2061: IF l_disp_seg IS NULL THEN
2062: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2063: fnd_msg_pub.ADD;
2064: RAISE fnd_api.g_exc_error;
2065: END IF;
2066:
2067: x_piped_sql_select := x_piped_sql_select || '.' || l_seg || '|';
2068: x_piped_expr_disp := x_piped_expr_disp || '.' || l_disp_seg || '|';

Line 2076: RAISE fnd_api.g_exc_unexpected_error;

2072:
2073: IF ct = 400 THEN
2074: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2075: fnd_msg_pub.ADD;
2076: RAISE fnd_api.g_exc_unexpected_error;
2077: END IF;
2078:
2079: IF success = FALSE THEN
2080: EXIT;

Line 2095: IF fnd_api.to_boolean(p_commit) THEN

2091: x_sql_from := REPLACE(SUBSTR(x_piped_sql_from, 1, LENGTH(x_piped_sql_from) - 1), '|'
2092: , ', '); -- trim last comma
2093:
2094: -- Standard check of p_commit.
2095: IF fnd_api.to_boolean(p_commit) THEN
2096: COMMIT WORK;
2097: END IF;
2098:
2099: -- Standard call to get message count and if count is 1, get message info.

Line 2101: , p_encoded => fnd_api.g_false);

2097: END IF;
2098:
2099: -- Standard call to get message count and if count is 1, get message info.
2100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2101: , p_encoded => fnd_api.g_false);
2102: EXCEPTION
2103: WHEN fnd_api.g_exc_error THEN
2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 2103: WHEN fnd_api.g_exc_error THEN

2099: -- Standard call to get message count and if count is 1, get message info.
2100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2101: , p_encoded => fnd_api.g_false);
2102: EXCEPTION
2103: WHEN fnd_api.g_exc_error THEN
2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2104: x_return_status := fnd_api.g_ret_sts_error;

2100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2101: , p_encoded => fnd_api.g_false);
2102: EXCEPTION
2103: WHEN fnd_api.g_exc_error THEN
2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2106: , p_encoded => fnd_api.g_false);

2102: EXCEPTION
2103: WHEN fnd_api.g_exc_error THEN
2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2110: , p_encoded => fnd_api.g_false);

Line 2107: WHEN fnd_api.g_exc_unexpected_error THEN

2103: WHEN fnd_api.g_exc_error THEN
2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2110: , p_encoded => fnd_api.g_false);
2111: WHEN OTHERS THEN

Line 2108: x_return_status := fnd_api.g_ret_sts_unexp_error;

2104: x_return_status := fnd_api.g_ret_sts_error;
2105: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2110: , p_encoded => fnd_api.g_false);
2111: WHEN OTHERS THEN
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2110: , p_encoded => fnd_api.g_false);

2106: , p_encoded => fnd_api.g_false);
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2110: , p_encoded => fnd_api.g_false);
2111: WHEN OTHERS THEN
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113:
2114: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2112: x_return_status := fnd_api.g_ret_sts_unexp_error;

2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2110: , p_encoded => fnd_api.g_false);
2111: WHEN OTHERS THEN
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113:
2114: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2116: END IF;

Line 2119: , p_encoded => fnd_api.g_false);

2115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2116: END IF;
2117:
2118: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2119: , p_encoded => fnd_api.g_false);
2120: END parse_sql_select;
2121:
2122: PROCEDURE import(
2123: errbuf OUT NOCOPY VARCHAR2

Line 2251: , p_init_msg_list => fnd_api.g_true

2247:
2248: -- build components of record
2249: parse_sql_select(
2250: p_api_version => 1.0
2251: , p_init_msg_list => fnd_api.g_true
2252: , p_sql_select => l_api_rec.sql_select
2253: , x_piped_sql_select => l_piped_sql_select
2254: , x_expr_disp => l_expr_disp
2255: , x_piped_expr_disp => l_piped_expr_disp

Line 2263: IF l_return_status = fnd_api.g_ret_sts_success THEN

2259: , x_msg_count => l_msg_count
2260: , x_msg_data => l_msg_data
2261: );
2262:
2263: IF l_return_status = fnd_api.g_ret_sts_success THEN
2264: -- do import here
2265: l_exp_id := NULL;
2266: create_expression(
2267: p_api_version => 1.0

Line 2268: , p_init_msg_list => fnd_api.g_false

2264: -- do import here
2265: l_exp_id := NULL;
2266: create_expression(
2267: p_api_version => 1.0
2268: , p_init_msg_list => fnd_api.g_false
2269: , p_org_id => p_org_id
2270: , p_name => l_api_rec.expression_name
2271: , p_description => l_api_rec.description
2272: , p_expression_disp => l_expr_disp

Line 2287: IF l_return_status = fnd_api.g_ret_sts_success THEN

2283: , x_msg_data => l_msg_data
2284: , x_object_version_number => l_object_version_number
2285: );
2286:
2287: IF l_return_status = fnd_api.g_ret_sts_success THEN
2288: -- update attribute values appropriately since API doesn't
2289: -- handle flexfields
2290: UPDATE cn_calc_sql_exps
2291: SET attribute_category = l_api_rec.attribute_category

Line 2311: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2307: WHERE calc_sql_exp_id = l_exp_id;
2308: END IF;
2309: END IF;
2310:
2311: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2312: -- try to get correct message
2313: l_failed_row := l_failed_row + 1;
2314: my_message :=
2315: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first

Line 2316: , p_encoded => fnd_api.g_false);

2312: -- try to get correct message
2313: l_failed_row := l_failed_row + 1;
2314: my_message :=
2315: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first
2316: , p_encoded => fnd_api.g_false);
2317:
2318: WHILE(my_message IS NOT NULL) LOOP
2319: l_error_code := my_message;
2320: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 2320: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2316: , p_encoded => fnd_api.g_false);
2317:
2318: WHILE(my_message IS NOT NULL) LOOP
2319: l_error_code := my_message;
2320: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2321: END LOOP;
2322:
2323: cn_import_pvt.update_imp_lines(
2324: p_imp_line_id => l_api_rec.imp_line_id

Line 2428: WHEN fnd_api.g_exc_unexpected_error THEN

2424: cn_message_pkg.end_batch(l_process_audit_id);
2425: -- Commit all imports
2426: COMMIT;
2427: EXCEPTION
2428: WHEN fnd_api.g_exc_unexpected_error THEN
2429: retcode := 2;
2430: cn_message_pkg.end_batch(l_process_audit_id);
2431: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2432: , p_encoded => fnd_api.g_false);

Line 2432: , p_encoded => fnd_api.g_false);

2428: WHEN fnd_api.g_exc_unexpected_error THEN
2429: retcode := 2;
2430: cn_message_pkg.end_batch(l_process_audit_id);
2431: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2432: , p_encoded => fnd_api.g_false);
2433: WHEN OTHERS THEN
2434: err_num := SQLCODE;
2435:
2436: IF err_num = -6501 THEN

Line 2447: , p_encoded => fnd_api.g_false);

2443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2444: END IF;
2445:
2446: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2447: , p_encoded => fnd_api.g_false);
2448: END IF;
2449:
2450: cn_message_pkg.set_error(l_api_name, errbuf);
2451: cn_message_pkg.end_batch(l_process_audit_id);

Line 2625: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2621: , x_msg_count => l_msg_count
2622: , x_msg_data => l_msg_data
2623: );
2624:
2625: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2626: cn_import_pvt.update_imp_headers(p_imp_header_id => p_imp_header_id, p_status_code => 'FAIL'
2627: , p_failed_row => l_rowcount);
2628: cn_message_pkg.WRITE(
2629: p_message_text => 'Export threw exception : rts sts ' || l_return_status

Line 2632: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2628: cn_message_pkg.WRITE(
2629: p_message_text => 'Export threw exception : rts sts ' || l_return_status
2630: , p_message_type => 'ERROR'
2631: );
2632: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2633:
2634: WHILE(my_message IS NOT NULL) LOOP
2635: l_message := l_message || my_message || '; ';
2636: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 2636: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2632: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2633:
2634: WHILE(my_message IS NOT NULL) LOOP
2635: l_message := l_message || my_message || '; ';
2636: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2637: END LOOP;
2638:
2639: cn_message_pkg.WRITE(p_message_text => l_message, p_message_type => 'ERROR');
2640: retcode := 2;

Line 2683: WHEN fnd_api.g_exc_unexpected_error THEN

2679: cn_message_pkg.end_batch(l_process_audit_id);
2680: -- Commit all imports
2681: COMMIT;
2682: EXCEPTION
2683: WHEN fnd_api.g_exc_unexpected_error THEN
2684: retcode := 2;
2685: cn_message_pkg.end_batch(l_process_audit_id);
2686: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2687: , p_encoded => fnd_api.g_false);

Line 2687: , p_encoded => fnd_api.g_false);

2683: WHEN fnd_api.g_exc_unexpected_error THEN
2684: retcode := 2;
2685: cn_message_pkg.end_batch(l_process_audit_id);
2686: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2687: , p_encoded => fnd_api.g_false);
2688: WHEN OTHERS THEN
2689: err_num := SQLCODE;
2690:
2691: IF err_num = -6501 THEN

Line 2702: , p_encoded => fnd_api.g_false);

2698: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2699: END IF;
2700:
2701: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2702: , p_encoded => fnd_api.g_false);
2703: END IF;
2704:
2705: cn_message_pkg.set_error(l_api_name, errbuf);
2706: cn_message_pkg.end_batch(l_process_audit_id);

Line 2711: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2707: END export;
2708:
2709: PROCEDURE duplicate_expression(
2710: p_api_version IN NUMBER
2711: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2712: , p_commit IN VARCHAR2 := fnd_api.g_false
2713: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2714: , p_old_expr_id IN NUMBER
2715: , x_new_expr_id OUT NOCOPY NUMBER

Line 2712: , p_commit IN VARCHAR2 := fnd_api.g_false

2708:
2709: PROCEDURE duplicate_expression(
2710: p_api_version IN NUMBER
2711: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2712: , p_commit IN VARCHAR2 := fnd_api.g_false
2713: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2714: , p_old_expr_id IN NUMBER
2715: , x_new_expr_id OUT NOCOPY NUMBER
2716: , x_new_expr_name OUT NOCOPY cn_calc_sql_exps.NAME%TYPE

Line 2713: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

2709: PROCEDURE duplicate_expression(
2710: p_api_version IN NUMBER
2711: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2712: , p_commit IN VARCHAR2 := fnd_api.g_false
2713: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2714: , p_old_expr_id IN NUMBER
2715: , x_new_expr_id OUT NOCOPY NUMBER
2716: , x_new_expr_name OUT NOCOPY cn_calc_sql_exps.NAME%TYPE
2717: , x_return_status OUT NOCOPY VARCHAR2

Line 2741: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2737: -- Standard Start of API savepoint
2738: SAVEPOINT create_expression;
2739:
2740: -- Standard call to check for call compatibility.
2741: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2742: RAISE fnd_api.g_exc_unexpected_error;
2743: END IF;
2744:
2745: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2742: RAISE fnd_api.g_exc_unexpected_error;

2738: SAVEPOINT create_expression;
2739:
2740: -- Standard call to check for call compatibility.
2741: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2742: RAISE fnd_api.g_exc_unexpected_error;
2743: END IF;
2744:
2745: -- Initialize message list if p_init_msg_list is set to TRUE.
2746: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2746: IF fnd_api.to_boolean(p_init_msg_list) THEN

2742: RAISE fnd_api.g_exc_unexpected_error;
2743: END IF;
2744:
2745: -- Initialize message list if p_init_msg_list is set to TRUE.
2746: IF fnd_api.to_boolean(p_init_msg_list) THEN
2747: fnd_msg_pub.initialize;
2748: END IF;
2749:
2750: -- Initialize API return status to success

Line 2751: x_return_status := fnd_api.g_ret_sts_success;

2747: fnd_msg_pub.initialize;
2748: END IF;
2749:
2750: -- Initialize API return status to success
2751: x_return_status := fnd_api.g_ret_sts_success;
2752:
2753: SELECT org_id
2754: , NAME
2755: , description

Line 2787: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

2783: , x_msg_count => x_msg_count
2784: , x_msg_data => x_msg_data
2785: );
2786:
2787: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2788: RAISE fnd_api.g_exc_error;
2789: END IF;
2790:
2791: create_expression(

Line 2788: RAISE fnd_api.g_exc_error;

2784: , x_msg_data => x_msg_data
2785: );
2786:
2787: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2788: RAISE fnd_api.g_exc_error;
2789: END IF;
2790:
2791: create_expression(
2792: p_api_version => p_api_version

Line 2815: IF fnd_api.to_boolean(p_commit) THEN

2811: , x_object_version_number => x_object_version_number
2812: );
2813:
2814: -- Standard check of p_commit.
2815: IF fnd_api.to_boolean(p_commit) THEN
2816: COMMIT WORK;
2817: END IF;
2818:
2819: -- Standard call to get message count and if count is 1, get message info.

Line 2821: , p_encoded => fnd_api.g_false);

2817: END IF;
2818:
2819: -- Standard call to get message count and if count is 1, get message info.
2820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2821: , p_encoded => fnd_api.g_false);
2822: EXCEPTION
2823: WHEN fnd_api.g_exc_error THEN
2824: ROLLBACK TO duplicate_expression;
2825: x_return_status := fnd_api.g_ret_sts_error;

Line 2823: WHEN fnd_api.g_exc_error THEN

2819: -- Standard call to get message count and if count is 1, get message info.
2820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2821: , p_encoded => fnd_api.g_false);
2822: EXCEPTION
2823: WHEN fnd_api.g_exc_error THEN
2824: ROLLBACK TO duplicate_expression;
2825: x_return_status := fnd_api.g_ret_sts_error;
2826: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2827: , p_encoded => fnd_api.g_false);

Line 2825: x_return_status := fnd_api.g_ret_sts_error;

2821: , p_encoded => fnd_api.g_false);
2822: EXCEPTION
2823: WHEN fnd_api.g_exc_error THEN
2824: ROLLBACK TO duplicate_expression;
2825: x_return_status := fnd_api.g_ret_sts_error;
2826: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2827: , p_encoded => fnd_api.g_false);
2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: ROLLBACK TO duplicate_expression;

Line 2827: , p_encoded => fnd_api.g_false);

2823: WHEN fnd_api.g_exc_error THEN
2824: ROLLBACK TO duplicate_expression;
2825: x_return_status := fnd_api.g_ret_sts_error;
2826: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2827: , p_encoded => fnd_api.g_false);
2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: ROLLBACK TO duplicate_expression;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 2828: WHEN fnd_api.g_exc_unexpected_error THEN

2824: ROLLBACK TO duplicate_expression;
2825: x_return_status := fnd_api.g_ret_sts_error;
2826: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2827: , p_encoded => fnd_api.g_false);
2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: ROLLBACK TO duplicate_expression;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2832: , p_encoded => fnd_api.g_false);

Line 2830: x_return_status := fnd_api.g_ret_sts_unexp_error;

2826: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2827: , p_encoded => fnd_api.g_false);
2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: ROLLBACK TO duplicate_expression;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2832: , p_encoded => fnd_api.g_false);
2833: WHEN OTHERS THEN
2834: ROLLBACK TO duplicate_expression;

Line 2832: , p_encoded => fnd_api.g_false);

2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: ROLLBACK TO duplicate_expression;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2832: , p_encoded => fnd_api.g_false);
2833: WHEN OTHERS THEN
2834: ROLLBACK TO duplicate_expression;
2835: x_return_status := fnd_api.g_ret_sts_unexp_error;
2836:

Line 2835: x_return_status := fnd_api.g_ret_sts_unexp_error;

2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2832: , p_encoded => fnd_api.g_false);
2833: WHEN OTHERS THEN
2834: ROLLBACK TO duplicate_expression;
2835: x_return_status := fnd_api.g_ret_sts_unexp_error;
2836:
2837: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2838: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2839: END IF;

Line 2842: , p_encoded => fnd_api.g_false);

2838: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2839: END IF;
2840:
2841: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2842: , p_encoded => fnd_api.g_false);
2843: END duplicate_expression;
2844: END cn_calc_sql_exps_pvt;