27: -- 04/10/2001 mpande Category and activity should match for the budget and the campaign or schedule
28: -- 06/08/2005 kdass Bug 4415878 SQL Repository Fix
29: -- 2/17/2010 nepanda Bug 9131648 : multi currency changes
30: /*****************************************************************************************/
31: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
32:
33: PROCEDURE check_cat_activity_match (
34: p_used_by_id IN NUMBER
35: ,p_used_by_type IN VARCHAR2
986:
987: IF c_resource%NOTFOUND THEN
988: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
989: fnd_message.set_token ('ROW', SQLERRM);
990: fnd_msg_pub.ADD;
991: END IF;
992:
993: CLOSE c_resource;
994: OPEN c_note (p_activity_type, p_activity_id, p_note_type);
1056:
1057: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1058: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1059: fnd_message.set_token ('ROW', SQLERRM);
1060: fnd_msg_pub.ADD;
1061: END IF;
1062: END create_note;
1063:
1064: END OZF_ACTBUDGETRULES_PVT;