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_MSG_PUB

Line 54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

50: AND (org_id = p_org_id));
51: BEGIN
52: -- parse the expression
53: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
56: fnd_msg_pub.ADD;
57: END IF;
58:

Line 56: fnd_msg_pub.ADD;

52: -- parse the expression
53: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
56: fnd_msg_pub.ADD;
57: END IF;
58:
59: RAISE fnd_api.g_exc_error;
60: END IF;

Line 95: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

91: IF dummy_cur%ISOPEN THEN
92: CLOSE dummy_cur;
93: END IF;
94:
95: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
96: fnd_message.set_name('CN', 'CN_INVALID_EXP');
97: fnd_message.set_token('EXPRESSION', SQLERRM);
98: fnd_msg_pub.ADD;
99: END IF;

Line 98: fnd_msg_pub.ADD;

94:
95: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
96: fnd_message.set_name('CN', 'CN_INVALID_EXP');
97: fnd_message.set_token('EXPRESSION', SQLERRM);
98: fnd_msg_pub.ADD;
99: END IF;
100:
101: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
102: , p_encoded => fnd_api.g_false);

Line 101: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

97: fnd_message.set_token('EXPRESSION', SQLERRM);
98: fnd_msg_pub.ADD;
99: END IF;
100:
101: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
102: , p_encoded => fnd_api.g_false);
103: END;
104:
105: IF (p_piped_sql_select IS NULL OR p_piped_sql_from IS NULL) THEN

Line 367: fnd_msg_pub.initialize;

363: END IF;
364:
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF fnd_api.to_boolean(p_init_msg_list) THEN
367: fnd_msg_pub.initialize;
368: END IF;
369:
370: -- Initialize API return status to success
371: x_return_status := fnd_api.g_ret_sts_success;

Line 375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

371: x_return_status := fnd_api.g_ret_sts_success;
372:
373: -- API body
374: IF (p_name IS NULL) THEN
375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
378: fnd_message.set_token('OBJ_NAME', l_prompt);
379: fnd_msg_pub.ADD;

Line 379: fnd_msg_pub.ADD;

375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
378: fnd_message.set_token('OBJ_NAME', l_prompt);
379: fnd_msg_pub.ADD;
380: END IF;
381:
382: RAISE fnd_api.g_exc_error;
383: END IF;

Line 390: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

386: FETCH exp_exists INTO l_dummy;
387: CLOSE exp_exists;
388:
389: IF (l_dummy = 1) THEN
390: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
391: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
392: fnd_msg_pub.ADD;
393: END IF;
394:

Line 392: fnd_msg_pub.ADD;

388:
389: IF (l_dummy = 1) THEN
390: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
391: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
392: fnd_msg_pub.ADD;
393: END IF;
394:
395: RAISE fnd_api.g_exc_error;
396: END IF;

Line 400: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

396: END IF;
397:
398: -- make sure name isn't too long
399: IF LENGTH(p_name) > 30 THEN
400: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
401: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
402: fnd_message.set_token('LENGTH', 30);
403: fnd_msg_pub.ADD;
404: END IF;

Line 403: fnd_msg_pub.ADD;

399: IF LENGTH(p_name) > 30 THEN
400: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
401: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
402: fnd_message.set_token('LENGTH', 30);
403: fnd_msg_pub.ADD;
404: END IF;
405:
406: RAISE fnd_api.g_exc_error;
407: END IF;

Line 529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

525: COMMIT WORK;
526: END IF;
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
530: , p_encoded => fnd_api.g_false);
531: EXCEPTION
532: WHEN fnd_api.g_exc_error THEN
533: ROLLBACK TO create_expression;

Line 535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

Line 540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

536: , p_encoded => fnd_api.g_false);
537: WHEN fnd_api.g_exc_unexpected_error THEN
538: ROLLBACK TO create_expression;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
541: , p_encoded => fnd_api.g_false);
542: WHEN OTHERS THEN
543: ROLLBACK TO create_expression;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 546: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

542: WHEN OTHERS THEN
543: ROLLBACK TO create_expression;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;
545:
546: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
547: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
548: END IF;
549:
550: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 547: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

543: ROLLBACK TO create_expression;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;
545:
546: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
547: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
548: END IF;
549:
550: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
551: , p_encoded => fnd_api.g_false);

Line 550: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

546: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
547: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
548: END IF;
549:
550: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
551: , p_encoded => fnd_api.g_false);
552: END create_expression;
553:
554: -- Start of comments

Line 675: fnd_msg_pub.initialize;

671: END IF;
672:
673: -- Initialize message list if p_init_msg_list is set to TRUE.
674: IF fnd_api.to_boolean(p_init_msg_list) THEN
675: fnd_msg_pub.initialize;
676: END IF;
677:
678: -- Initialize API return status to success
679: x_return_status := fnd_api.g_ret_sts_success;

Line 683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

679: x_return_status := fnd_api.g_ret_sts_success;
680:
681: -- API body
682: IF (p_name IS NULL) THEN
683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
684: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
686: fnd_message.set_token('OBJ_NAME', l_prompt);
687: fnd_msg_pub.ADD;

Line 687: fnd_msg_pub.ADD;

683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
684: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
686: fnd_message.set_token('OBJ_NAME', l_prompt);
687: fnd_msg_pub.ADD;
688: END IF;
689:
690: RAISE fnd_api.g_exc_error;
691: END IF;

Line 698: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

694: FETCH exp_exists INTO l_dummy;
695: CLOSE exp_exists;
696:
697: IF (l_dummy = 1) THEN
698: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
699: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
700: fnd_msg_pub.ADD;
701: END IF;
702:

Line 700: fnd_msg_pub.ADD;

696:
697: IF (l_dummy = 1) THEN
698: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
699: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
700: fnd_msg_pub.ADD;
701: END IF;
702:
703: RAISE fnd_api.g_exc_error;
704: END IF;

Line 712: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

708: FETCH parent_exist INTO l_dummy;
709: CLOSE parent_exist;
710:
711: IF (l_dummy = 1) THEN
712: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
713: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
714: fnd_msg_pub.ADD;
715: END IF;
716:

Line 714: fnd_msg_pub.ADD;

710:
711: IF (l_dummy = 1) THEN
712: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
713: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
714: fnd_msg_pub.ADD;
715: END IF;
716:
717: RAISE fnd_api.g_exc_error;
718: END IF;

Line 882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

878: COMMIT WORK;
879: END IF;
880:
881: -- Standard call to get message count and if count is 1, get message info.
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
883: , p_encoded => fnd_api.g_false);
884: EXCEPTION
885: WHEN fnd_api.g_exc_error THEN
886: ROLLBACK TO update_expression;

Line 888: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

Line 893: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

889: , p_encoded => fnd_api.g_false);
890: WHEN fnd_api.g_exc_unexpected_error THEN
891: ROLLBACK TO update_expression;
892: x_return_status := fnd_api.g_ret_sts_unexp_error;
893: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
894: , p_encoded => fnd_api.g_false);
895: WHEN OTHERS THEN
896: ROLLBACK TO update_expression;
897: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

895: WHEN OTHERS THEN
896: ROLLBACK TO update_expression;
897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

896: ROLLBACK TO update_expression;
897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
904: , p_encoded => fnd_api.g_false);

Line 903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:
903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
904: , p_encoded => fnd_api.g_false);
905: END update_expression;
906:
907: -- Start of comments

Line 978: fnd_msg_pub.initialize;

974: END IF;
975:
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF fnd_api.to_boolean(p_init_msg_list) THEN
978: fnd_msg_pub.initialize;
979: END IF;
980:
981: -- Initialize API return status to success
982: x_return_status := fnd_api.g_ret_sts_success;

Line 990: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

986: FETCH parent_exist INTO l_dummy;
987: CLOSE parent_exist;
988:
989: IF (l_dummy = 1) THEN
990: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
991: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
992: fnd_msg_pub.ADD;
993: END IF;
994:

Line 992: fnd_msg_pub.ADD;

988:
989: IF (l_dummy = 1) THEN
990: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
991: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
992: fnd_msg_pub.ADD;
993: END IF;
994:
995: RAISE fnd_api.g_exc_error;
996: END IF;

Line 1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1009: COMMIT WORK;
1010: END IF;
1011:
1012: -- Standard call to get message count and if count is 1, get message info.
1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1014: , p_encoded => fnd_api.g_false);
1015: EXCEPTION
1016: WHEN fnd_api.g_exc_error THEN
1017: ROLLBACK TO delete_expression;

Line 1019: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

Line 1024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1020: , p_encoded => fnd_api.g_false);
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO delete_expression;
1023: x_return_status := fnd_api.g_ret_sts_unexp_error;
1024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1025: , p_encoded => fnd_api.g_false);
1026: WHEN OTHERS THEN
1027: ROLLBACK TO delete_expression;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1026: WHEN OTHERS THEN
1027: ROLLBACK TO delete_expression;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029:
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033:
1034: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1027: ROLLBACK TO delete_expression;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029:
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033:
1034: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1035: , p_encoded => fnd_api.g_false);

Line 1034: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1031: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1032: END IF;
1033:
1034: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1035: , p_encoded => fnd_api.g_false);
1036: END delete_expression;
1037:
1038: /*-- Start of comments

Line 1117: FND_MSG_PUB.initialize;

1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: END IF;
1115: -- Initialize message list if p_init_msg_list is set to TRUE.
1116: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119: -- Initialize API return status to success
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121:

Line 1135: FND_MSG_PUB.count_and_get

1131: IF FND_API.To_Boolean( p_commit ) THEN
1132: COMMIT WORK;
1133: END IF;
1134: -- Standard call to get message count and if count is 1, get message info.
1135: FND_MSG_PUB.count_and_get
1136: (p_count => x_msg_count ,
1137: p_data => x_msg_data ,
1138: p_encoded => FND_API.G_FALSE );
1139: EXCEPTION

Line 1142: FND_MSG_PUB.count_and_get

1138: p_encoded => FND_API.G_FALSE );
1139: EXCEPTION
1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR ;
1142: FND_MSG_PUB.count_and_get
1143: (p_count => x_msg_count ,
1144: p_data => x_msg_data ,
1145: p_encoded => FND_API.G_FALSE );
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1148: FND_MSG_PUB.count_and_get

1144: p_data => x_msg_data ,
1145: p_encoded => FND_API.G_FALSE );
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1148: FND_MSG_PUB.count_and_get
1149: (p_count => x_msg_count ,
1150: p_data => x_msg_data ,
1151: p_encoded => FND_API.G_FALSE );
1152: WHEN OTHERS THEN

Line 1154: IF FND_MSG_PUB.check_msg_level

1150: p_data => x_msg_data ,
1151: p_encoded => FND_API.G_FALSE );
1152: WHEN OTHERS THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: IF FND_MSG_PUB.check_msg_level
1155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.add_exc_msg
1158: (G_PKG_NAME ,

Line 1155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1151: p_encoded => FND_API.G_FALSE );
1152: WHEN OTHERS THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: IF FND_MSG_PUB.check_msg_level
1155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.add_exc_msg
1158: (G_PKG_NAME ,
1159: l_api_name );

Line 1157: FND_MSG_PUB.add_exc_msg

1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: IF FND_MSG_PUB.check_msg_level
1155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.add_exc_msg
1158: (G_PKG_NAME ,
1159: l_api_name );
1160: END IF;
1161: FND_MSG_PUB.count_and_get

Line 1161: FND_MSG_PUB.count_and_get

1157: FND_MSG_PUB.add_exc_msg
1158: (G_PKG_NAME ,
1159: l_api_name );
1160: END IF;
1161: FND_MSG_PUB.count_and_get
1162: (p_count => x_msg_count ,
1163: p_data => x_msg_data ,
1164: p_encoded => FND_API.G_FALSE );
1165: END Get_Parent_Expressions; */

Line 1548: fnd_msg_pub.ADD;

1544: l_junk VARCHAR2(4000);
1545: BEGIN
1546: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1547: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1548: fnd_msg_pub.ADD;
1549: RAISE fnd_api.g_exc_error;
1550: END IF;
1551:
1552: IF p_node_type = 'P' THEN

Line 1613: fnd_msg_pub.initialize;

1609: END IF;
1610:
1611: -- Initialize message list if p_init_msg_list is set to TRUE.
1612: IF fnd_api.to_boolean(p_init_msg_list) THEN
1613: fnd_msg_pub.initialize;
1614: END IF;
1615:
1616: -- Initialize API return status to success
1617: x_return_status := fnd_api.g_ret_sts_success;

Line 1627: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1623: COMMIT WORK;
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1628: , p_encoded => fnd_api.g_false);
1629: EXCEPTION
1630: WHEN fnd_api.g_exc_error THEN
1631: x_return_status := fnd_api.g_ret_sts_error;

Line 1632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1628: , p_encoded => fnd_api.g_false);
1629: EXCEPTION
1630: WHEN fnd_api.g_exc_error THEN
1631: x_return_status := fnd_api.g_ret_sts_error;
1632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1633: , p_encoded => fnd_api.g_false);
1634: WHEN fnd_api.g_exc_unexpected_error THEN
1635: x_return_status := fnd_api.g_ret_sts_unexp_error;
1636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1633: , p_encoded => fnd_api.g_false);
1634: WHEN fnd_api.g_exc_unexpected_error THEN
1635: x_return_status := fnd_api.g_ret_sts_unexp_error;
1636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1637: , p_encoded => fnd_api.g_false);
1638: WHEN OTHERS THEN
1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:

Line 1641: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1637: , p_encoded => fnd_api.g_false);
1638: WHEN OTHERS THEN
1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:
1641: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644:
1645: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1638: WHEN OTHERS THEN
1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:
1641: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644:
1645: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1646: , p_encoded => fnd_api.g_false);

Line 1645: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1641: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644:
1645: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1646: , p_encoded => fnd_api.g_false);
1647: END get_dependent_plan_elts;
1648:
1649: -- private procedure used in get_parent_plan_elts

Line 1689: fnd_msg_pub.ADD;

1685: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1686: BEGIN
1687: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1688: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1689: fnd_msg_pub.ADD;
1690: RAISE fnd_api.g_exc_error;
1691: END IF;
1692:
1693: IF p_node_type = g_node_type AND

Line 1765: fnd_msg_pub.initialize;

1761: END IF;
1762:
1763: -- Initialize message list if p_init_msg_list is set to TRUE.
1764: IF fnd_api.to_boolean(p_init_msg_list) THEN
1765: fnd_msg_pub.initialize;
1766: END IF;
1767:
1768: -- Initialize API return status to success
1769: x_return_status := fnd_api.g_ret_sts_success;

Line 1779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1775: COMMIT WORK;
1776: END IF;
1777:
1778: -- Standard call to get message count and if count is 1, get message info.
1779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1780: , p_encoded => fnd_api.g_false);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN
1783: x_return_status := fnd_api.g_ret_sts_error;

Line 1784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1780: , p_encoded => fnd_api.g_false);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1785: , p_encoded => fnd_api.g_false);
1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: x_return_status := fnd_api.g_ret_sts_unexp_error;
1788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1785: , p_encoded => fnd_api.g_false);
1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: x_return_status := fnd_api.g_ret_sts_unexp_error;
1788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1789: , p_encoded => fnd_api.g_false);
1790: WHEN OTHERS THEN
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:

Line 1793: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1789: , p_encoded => fnd_api.g_false);
1790: WHEN OTHERS THEN
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:
1793: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1795: END IF;
1796:
1797: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 1794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1790: WHEN OTHERS THEN
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:
1793: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1795: END IF;
1796:
1797: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1798: , p_encoded => fnd_api.g_false);

Line 1797: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

1793: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1795: END IF;
1796:
1797: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1798: , p_encoded => fnd_api.g_false);
1799: END get_parent_plan_elts;
1800:
1801: PROCEDURE parse_sql_select(

Line 1915: fnd_msg_pub.initialize;

1911: END IF;
1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.
1914: IF fnd_api.to_boolean(p_init_msg_list) THEN
1915: fnd_msg_pub.initialize;
1916: END IF;
1917:
1918: -- Initialize API return status to success
1919: x_return_status := fnd_api.g_ret_sts_success;

Line 1963: fnd_msg_pub.ADD;

1959: l_ix := INSTR(l_sql_select_left, '''', 2);
1960:
1961: IF l_ix = 0 THEN
1962: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
1963: fnd_msg_pub.ADD;
1964: RAISE fnd_api.g_exc_error;
1965: END IF;
1966:
1967: x_piped_sql_select := x_piped_sql_select || SUBSTR(l_sql_select_left, 1, l_ix) || '|';

Line 2053: fnd_msg_pub.ADD;

2049: CLOSE get_tbl;
2050:
2051: IF l_disp_seg IS NULL THEN
2052: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2053: fnd_msg_pub.ADD;
2054: RAISE fnd_api.g_exc_error;
2055: END IF;
2056:
2057: -- add to sql from

Line 2082: fnd_msg_pub.ADD;

2078: CLOSE get_col;
2079:
2080: IF l_disp_seg IS NULL THEN
2081: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2082: fnd_msg_pub.ADD;
2083: RAISE fnd_api.g_exc_error;
2084: END IF;
2085:
2086: x_piped_sql_select := x_piped_sql_select || '.' || l_seg || '|';

Line 2094: fnd_msg_pub.ADD;

2090: END IF;
2091:
2092: IF ct = 400 THEN
2093: fnd_message.set_name('CN', 'CN_SQL_SELECT_PARSE_ERR');
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_unexpected_error;
2096: END IF;
2097:
2098: IF success = FALSE THEN

Line 2119: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2115: COMMIT WORK;
2116: END IF;
2117:
2118: -- Standard call to get message count and if count is 1, get message info.
2119: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2120: , p_encoded => fnd_api.g_false);
2121: EXCEPTION
2122: WHEN fnd_api.g_exc_error THEN
2123: x_return_status := fnd_api.g_ret_sts_error;

Line 2124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2120: , p_encoded => fnd_api.g_false);
2121: EXCEPTION
2122: WHEN fnd_api.g_exc_error THEN
2123: x_return_status := fnd_api.g_ret_sts_error;
2124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2125: , p_encoded => fnd_api.g_false);
2126: WHEN fnd_api.g_exc_unexpected_error THEN
2127: x_return_status := fnd_api.g_ret_sts_unexp_error;
2128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 2128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2125: , p_encoded => fnd_api.g_false);
2126: WHEN fnd_api.g_exc_unexpected_error THEN
2127: x_return_status := fnd_api.g_ret_sts_unexp_error;
2128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2129: , p_encoded => fnd_api.g_false);
2130: WHEN OTHERS THEN
2131: x_return_status := fnd_api.g_ret_sts_unexp_error;
2132:

Line 2133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2129: , p_encoded => fnd_api.g_false);
2130: WHEN OTHERS THEN
2131: x_return_status := fnd_api.g_ret_sts_unexp_error;
2132:
2133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2134: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2135: END IF;
2136:
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 2134: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2130: WHEN OTHERS THEN
2131: x_return_status := fnd_api.g_ret_sts_unexp_error;
2132:
2133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2134: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2135: END IF;
2136:
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2138: , p_encoded => fnd_api.g_false);

Line 2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2134: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2135: END IF;
2136:
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2138: , p_encoded => fnd_api.g_false);
2139: END parse_sql_select;
2140:
2141: PROCEDURE import(

Line 2333: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first

2329: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2330: -- try to get correct message
2331: l_failed_row := l_failed_row + 1;
2332: my_message :=
2333: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first
2334: , p_encoded => fnd_api.g_false);
2335:
2336: WHILE(my_message IS NOT NULL) LOOP
2337: l_error_code := my_message;

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

2334: , p_encoded => fnd_api.g_false);
2335:
2336: WHILE(my_message IS NOT NULL) LOOP
2337: l_error_code := my_message;
2338: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2339: END LOOP;
2340:
2341: cn_import_pvt.update_imp_lines(
2342: p_imp_line_id => l_api_rec.imp_line_id

Line 2449: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

2445: EXCEPTION
2446: WHEN fnd_api.g_exc_unexpected_error THEN
2447: retcode := 2;
2448: cn_message_pkg.end_batch(l_process_audit_id);
2449: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2450: , p_encoded => fnd_api.g_false);
2451: WHEN OTHERS THEN
2452: err_num := SQLCODE;
2453:

Line 2460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2456: errbuf := fnd_program.MESSAGE;
2457: ELSE
2458: retcode := 2;
2459:
2460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2461: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2462: END IF;
2463:
2464: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

Line 2461: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2457: ELSE
2458: retcode := 2;
2459:
2460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2461: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2462: END IF;
2463:
2464: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2465: , p_encoded => fnd_api.g_false);

Line 2464: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

2460: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2461: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2462: END IF;
2463:
2464: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2465: , p_encoded => fnd_api.g_false);
2466: END IF;
2467:
2468: cn_message_pkg.set_error(l_api_name, errbuf);

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

2646: cn_message_pkg.WRITE(
2647: p_message_text => 'Export threw exception : rts sts ' || l_return_status
2648: , p_message_type => 'ERROR'
2649: );
2650: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2651:
2652: WHILE(my_message IS NOT NULL) LOOP
2653: l_message := l_message || my_message || '; ';
2654: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

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

2650: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2651:
2652: WHILE(my_message IS NOT NULL) LOOP
2653: l_message := l_message || my_message || '; ';
2654: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2655: END LOOP;
2656:
2657: cn_message_pkg.WRITE(p_message_text => l_message, p_message_type => 'ERROR');
2658: retcode := 2;

Line 2704: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

2700: EXCEPTION
2701: WHEN fnd_api.g_exc_unexpected_error THEN
2702: retcode := 2;
2703: cn_message_pkg.end_batch(l_process_audit_id);
2704: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2705: , p_encoded => fnd_api.g_false);
2706: WHEN OTHERS THEN
2707: err_num := SQLCODE;
2708:

Line 2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2711: errbuf := fnd_program.MESSAGE;
2712: ELSE
2713: retcode := 2;
2714:
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718:
2719: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

Line 2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2712: ELSE
2713: retcode := 2;
2714:
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718:
2719: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2720: , p_encoded => fnd_api.g_false);

Line 2719: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718:
2719: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2720: , p_encoded => fnd_api.g_false);
2721: END IF;
2722:
2723: cn_message_pkg.set_error(l_api_name, errbuf);

Line 2765: fnd_msg_pub.initialize;

2761: END IF;
2762:
2763: -- Initialize message list if p_init_msg_list is set to TRUE.
2764: IF fnd_api.to_boolean(p_init_msg_list) THEN
2765: fnd_msg_pub.initialize;
2766: END IF;
2767:
2768: -- Initialize API return status to success
2769: x_return_status := fnd_api.g_ret_sts_success;

Line 2838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2834: COMMIT WORK;
2835: END IF;
2836:
2837: -- Standard call to get message count and if count is 1, get message info.
2838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2839: , p_encoded => fnd_api.g_false);
2840: EXCEPTION
2841: WHEN fnd_api.g_exc_error THEN
2842: ROLLBACK TO duplicate_expression;

Line 2844: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2840: EXCEPTION
2841: WHEN fnd_api.g_exc_error THEN
2842: ROLLBACK TO duplicate_expression;
2843: x_return_status := fnd_api.g_ret_sts_error;
2844: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2845: , p_encoded => fnd_api.g_false);
2846: WHEN fnd_api.g_exc_unexpected_error THEN
2847: ROLLBACK TO duplicate_expression;
2848: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2849: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2845: , p_encoded => fnd_api.g_false);
2846: WHEN fnd_api.g_exc_unexpected_error THEN
2847: ROLLBACK TO duplicate_expression;
2848: x_return_status := fnd_api.g_ret_sts_unexp_error;
2849: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2850: , p_encoded => fnd_api.g_false);
2851: WHEN OTHERS THEN
2852: ROLLBACK TO duplicate_expression;
2853: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2855: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2851: WHEN OTHERS THEN
2852: ROLLBACK TO duplicate_expression;
2853: x_return_status := fnd_api.g_ret_sts_unexp_error;
2854:
2855: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2856: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2857: END IF;
2858:
2859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

Line 2856: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2852: ROLLBACK TO duplicate_expression;
2853: x_return_status := fnd_api.g_ret_sts_unexp_error;
2854:
2855: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2856: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2857: END IF;
2858:
2859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2860: , p_encoded => fnd_api.g_false);

Line 2859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

2855: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2856: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2857: END IF;
2858:
2859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2860: , p_encoded => fnd_api.g_false);
2861: END duplicate_expression;
2862: END cn_calc_sql_exps_pvt;