978: OPEN c_resource;
979: FETCH c_resource INTO l_user;
980:
981: IF c_resource%NOTFOUND THEN
982: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
983: fnd_message.set_token ('ROW', SQLERRM);
984: fnd_msg_pub.ADD;
985: END IF;
986:
979: FETCH c_resource INTO l_user;
980:
981: IF c_resource%NOTFOUND THEN
982: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
983: fnd_message.set_token ('ROW', SQLERRM);
984: fnd_msg_pub.ADD;
985: END IF;
986:
987: CLOSE c_resource;
1028: );
1029: END IF;
1030:
1031: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1032: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1033: fnd_message.set_token ('ROW', SQLERRM);
1034: fnd_msg_pub.ADD;
1035: END IF;
1036: END create_note;
1029: END IF;
1030:
1031: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1032: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1033: fnd_message.set_token ('ROW', SQLERRM);
1034: fnd_msg_pub.ADD;
1035: END IF;
1036: END create_note;
1037: