90: -- Initialize message list if p_init_msg_list is set to TRUE
91: --
92: IF FND_API.to_boolean( p_init_msg_list) THEN
93:
94: FND_MSG_PUB.initialize ;
95:
96: END IF ;
97:
98: -- Initialize API return status to success.
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
129: p_count => x_msg_count ,
130: p_data => x_msg_data ) ;
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: p_data => x_msg_data ) ;
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133:
134: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg( G_pkg_name, p_api_name ) ;
136: END IF ;
137:
138: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133:
134: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg( G_pkg_name, p_api_name ) ;
136: END IF ;
137:
138: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
139: p_count => x_msg_count ,
134: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg( G_pkg_name, p_api_name ) ;
136: END IF ;
137:
138: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
139: p_count => x_msg_count ,
140: p_data => x_msg_data ) ;
141: END common_code ;
142:
650: EXCEPTION
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
655: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
656: END IF ;
657:
658: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
655: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
656: END IF ;
657:
658: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
659: p_count => x_msg_count ,
654: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
655: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
656: END IF ;
657:
658: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
659: p_count => x_msg_count ,
660: p_data => x_msg_data ) ;
661: END get_award_number ;
662: