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 48: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

44: AND (org_id = p_org_id));
45: BEGIN
46: -- parse the expression
47: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
48: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
49: fnd_message.set_name('CN', 'CN_EXP_TOO_LONG');
50: fnd_msg_pub.ADD;
51: END IF;
52:

Line 50: fnd_msg_pub.ADD;

46: -- parse the expression
47: IF LENGTH(p_sql_select) + LENGTH(p_sql_from) > 4000 THEN
48: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
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;

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

85: IF dummy_cur%ISOPEN THEN
86: CLOSE dummy_cur;
87: END IF;
88:
89: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
90: fnd_message.set_name('CN', 'CN_INVALID_EXP');
91: fnd_message.set_token('EXPRESSION', SQLERRM);
92: fnd_msg_pub.ADD;
93: END IF;

Line 92: fnd_msg_pub.ADD;

88:
89: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
90: fnd_message.set_name('CN', 'CN_INVALID_EXP');
91: fnd_message.set_token('EXPRESSION', SQLERRM);
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);

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

91: fnd_message.set_token('EXPRESSION', SQLERRM);
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

Line 361: fnd_msg_pub.initialize;

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
365: x_return_status := fnd_api.g_ret_sts_success;

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

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
370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
371: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
372: fnd_message.set_token('OBJ_NAME', l_prompt);
373: fnd_msg_pub.ADD;

Line 373: fnd_msg_pub.ADD;

369: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
371: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
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;

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

380: FETCH exp_exists INTO l_dummy;
381: CLOSE exp_exists;
382:
383: IF (l_dummy = 1) THEN
384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
385: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
386: fnd_msg_pub.ADD;
387: END IF;
388:

Line 386: fnd_msg_pub.ADD;

382:
383: IF (l_dummy = 1) THEN
384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
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;

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

390: END IF;
391:
392: -- make sure name isn't too long
393: IF LENGTH(p_name) > 30 THEN
394: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
395: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
396: fnd_message.set_token('LENGTH', 30);
397: fnd_msg_pub.ADD;
398: END IF;

Line 397: fnd_msg_pub.ADD;

393: IF LENGTH(p_name) > 30 THEN
394: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
395: fnd_message.set_name('CN', 'CN_NAME_TOO_LONG');
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;

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

518: COMMIT WORK;
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;

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

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;
532: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 533: 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;
537: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
542:
543: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

Line 668: fnd_msg_pub.initialize;

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
672: x_return_status := fnd_api.g_ret_sts_success;

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

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
677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
678: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
679: fnd_message.set_token('OBJ_NAME', l_prompt);
680: fnd_msg_pub.ADD;

Line 680: fnd_msg_pub.ADD;

676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
678: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
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;

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

687: FETCH exp_exists INTO l_dummy;
688: CLOSE exp_exists;
689:
690: IF (l_dummy = 1) THEN
691: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
692: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
693: fnd_msg_pub.ADD;
694: END IF;
695:

Line 693: fnd_msg_pub.ADD;

689:
690: IF (l_dummy = 1) THEN
691: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
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;

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

701: FETCH parent_exist INTO l_dummy;
702: CLOSE parent_exist;
703:
704: IF (l_dummy = 1) THEN
705: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
706: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
707: fnd_msg_pub.ADD;
708: END IF;
709:

Line 707: fnd_msg_pub.ADD;

703:
704: IF (l_dummy = 1) THEN
705: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
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;

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

870: COMMIT WORK;
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;

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

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;
884: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 885: 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;
889: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
894:
895: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

Line 970: fnd_msg_pub.initialize;

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
974: x_return_status := fnd_api.g_ret_sts_success;

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

978: FETCH parent_exist INTO l_dummy;
979: CLOSE parent_exist;
980:
981: IF (l_dummy = 1) THEN
982: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
983: fnd_message.set_name('CN', 'CN_EXP_IN_USE');
984: fnd_msg_pub.ADD;
985: END IF;
986:

Line 984: fnd_msg_pub.ADD;

980:
981: IF (l_dummy = 1) THEN
982: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
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;

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

1001: COMMIT WORK;
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;

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

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;
1015: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1016: 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;
1020: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
1025:
1026: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

Line 1109: FND_MSG_PUB.initialize;

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;
1113:

Line 1127: FND_MSG_PUB.count_and_get

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
1128: (p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE );
1131: EXCEPTION

Line 1134: FND_MSG_PUB.count_and_get

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 );
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1140: FND_MSG_PUB.count_and_get

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 );
1144: WHEN OTHERS THEN

Line 1146: IF FND_MSG_PUB.check_msg_level

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
1150: (G_PKG_NAME ,

Line 1147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1150: (G_PKG_NAME ,
1151: l_api_name );

Line 1149: FND_MSG_PUB.add_exc_msg

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
1150: (G_PKG_NAME ,
1151: l_api_name );
1152: END IF;
1153: FND_MSG_PUB.count_and_get

Line 1153: FND_MSG_PUB.count_and_get

1149: FND_MSG_PUB.add_exc_msg
1150: (G_PKG_NAME ,
1151: l_api_name );
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; */

Line 1540: fnd_msg_pub.ADD;

1536: l_junk VARCHAR2(4000);
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

Line 1606: fnd_msg_pub.initialize;

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
1610: x_return_status := fnd_api.g_ret_sts_success;

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

1616: COMMIT WORK;
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;

Line 1625: 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;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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;
1633:

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

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;
1637:
1638: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

Line 1682: fnd_msg_pub.ADD;

1678: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
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

Line 1746: fnd_msg_pub.initialize;

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
1750: x_return_status := fnd_api.g_ret_sts_success;

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

1756: COMMIT WORK;
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;

Line 1765: 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;
1769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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;
1773:

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

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;
1777:
1778: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

Line 1896: fnd_msg_pub.initialize;

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
1900: x_return_status := fnd_api.g_ret_sts_success;

Line 1944: fnd_msg_pub.ADD;

1940: l_ix := INSTR(l_sql_select_left, '''', 2);
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) || '|';

Line 2034: fnd_msg_pub.ADD;

2030: CLOSE get_tbl;
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

Line 2063: fnd_msg_pub.ADD;

2059: CLOSE get_col;
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 || '|';

Line 2075: fnd_msg_pub.ADD;

2071: END IF;
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

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

2096: COMMIT WORK;
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;

Line 2105: 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;
2109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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;
2113:

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

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;
2117:
2118: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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

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

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
2316: , p_encoded => fnd_api.g_false);
2317:
2318: WHILE(my_message IS NOT NULL) LOOP
2319: l_error_code := my_message;

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 2431: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

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);
2433: WHEN OTHERS THEN
2434: err_num := SQLCODE;
2435:

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

2438: errbuf := fnd_program.MESSAGE;
2439: ELSE
2440: retcode := 2;
2441:
2442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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

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

2439: ELSE
2440: retcode := 2;
2441:
2442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);

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

2442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);

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 2686: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf

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);
2688: WHEN OTHERS THEN
2689: err_num := SQLCODE;
2690:

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

2693: errbuf := fnd_program.MESSAGE;
2694: ELSE
2695: retcode := 2;
2696:
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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

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

2694: ELSE
2695: retcode := 2;
2696:
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);

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

2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);

Line 2747: fnd_msg_pub.initialize;

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
2751: x_return_status := fnd_api.g_ret_sts_success;

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

2816: COMMIT WORK;
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;

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

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;
2830: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2831: 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;
2835: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
2840:
2841: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data

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

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

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

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