221: -- Initialize message list if p_init_msg_list is set to TRUE
222: -------------------------------------------------------------
223: l_stmt_num := 20;
224: IF fnd_api.to_Boolean(p_init_msg_list) then
225: fnd_msg_pub.initialize;
226: end if;
227:
228: -------------------------------------------------------------
229: -- Initialize API return status to Success
346: EXCEPTION
347: WHEN fnd_api.g_exc_error then
348: x_return_status := fnd_api.g_ret_sts_error;
349:
350: fnd_msg_pub.count_and_get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data );
353:
354: WHEN fnd_api.g_exc_unexpected_error then
353:
354: WHEN fnd_api.g_exc_unexpected_error then
355: x_return_status := fnd_api.g_ret_sts_unexp_error;
356:
357: fnd_msg_pub.count_and_get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data );
360:
361: WHEN OTHERS THEN
359: p_data => x_msg_data );
360:
361: WHEN OTHERS THEN
362: x_return_status := fnd_api.g_ret_sts_unexp_error ;
363: If fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
364: fnd_msg_pub.add_exc_msg
365: ( 'CST_MOH_RULES_PUB','apply_moh : Statement - ' || to_char(l_stmt_num));
366: end if;
367:
360:
361: WHEN OTHERS THEN
362: x_return_status := fnd_api.g_ret_sts_unexp_error ;
363: If fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
364: fnd_msg_pub.add_exc_msg
365: ( 'CST_MOH_RULES_PUB','apply_moh : Statement - ' || to_char(l_stmt_num));
366: end if;
367:
368: fnd_msg_pub.count_and_get( p_count => x_msg_count,
364: fnd_msg_pub.add_exc_msg
365: ( 'CST_MOH_RULES_PUB','apply_moh : Statement - ' || to_char(l_stmt_num));
366: end if;
367:
368: fnd_msg_pub.count_and_get( p_count => x_msg_count,
369: p_data => x_msg_data );
370:
371: END apply_moh;
372: